Please go back and select at least one submission and one advocate

'; } else { // Get conflicts? if ($OC_configAR['OC_allowConflictOverride'] && isset($_POST['conflict_override']) && ($_POST['conflict_override'] == 1)) { $conflictAR = array(); } else { $conflictAR = getConflicts(); } // Assign advocates (and reviewers?) // NOTE: Although a foreach is used below for future expansion, there should only be 1 advocate $advocateAssignmentAR = array(); // keep track of advocates w/successful assignments $submissionAssignmentAR = array(); // keep track of submissions assigned foreach ($_POST['advocates'] as $i) { if (!is_numeric($i)) { err('Invalid advocate ID: ' . safeHTMLstr($i)); } foreach ($_POST['papers'] as $j) { if (!is_numeric($j)) { err('Invalid submission ID: ' . safeHTMLstr($j)); } // Check for conflict if (in_array("$j-$i",$conflictAR)) { print "

! Submission $j is in conflict with advocate $i.

\n"; continue; } // Delete current assignment? if (isset($_POST['assignment_override']) && ($_POST['assignment_override'] == 1)) { oc_deleteAssignments($j, null, 'advocate'); } // Make assignment $q = "INSERT INTO `" . OCC_TABLE_PAPERADVOCATE . "` (`paperid`,`advocateid`) VALUES ('" . safeSQLstr($j) . "','" . safeSQLstr($i) . "')"; ocsql_query($q); if (($merr = ocsql_errno()) != 0) { if ($merr == 1062) { // Duplicate entry print "! Submission $j already has an advocate assigned. Please delete the existing advocate first before assigning a new one, or select Override Current Assingment.

\n"; } else { print "!! Error assigning submission $j to advocate $i

\n"; } } else { print "

Submission $j assigned to advocate $i.\n"; if (!isset($advocateAssignmentAR[$i])) { $advocateAssignmentAR[$i] = array(); } $advocateAssignmentAR[$i][] = $j; if (!in_array($j, $submissionAssignmentAR)) { $submissionAssignmentAR[] = $j; } // Also assign a reviewer? if (isset($_POST['asrev']) && ($_POST['asrev'] == "yes")) { $q = "INSERT INTO `" . OCC_TABLE_PAPERREVIEWER . "` (`paperid`,`reviewerid`,`assigned`) VALUES ('" . safeSQLstr($j) . "','" . safeSQLstr($i) . "','" . safeSQLstr(date('Y-m-d')) . "')"; ocsql_query($q); if (($merr = ocsql_errno()) != 0) { if ($merr == 1062) { // Duplicate entry print "

! Submission $j has already been assigned reviewer $i.

\n"; } else { print "!! Error assigning submission $j to reviewer $i

\n"; } } } } } } print '

'; // Notify? if ( isset($_POST['notify']) && ($_POST['notify'] == 1) && (count($advocateAssignmentAR) > 0) ) { // Get list of sub titles $r = ocsql_query("SELECT `paperid`, `title` FROM `" . OCC_TABLE_PAPER . "` WHERE `paperid` IN (" . implode(',',$submissionAssignmentAR) . ")") or err('Unable to retrieve submission titles for notification'); $submissionTitleAR = array(); while ($l = ocsql_fetch_assoc($r)) { $submissionTitleAR[$l['paperid']] = $l['paperid'] . '. ' . $l['title']; } // Get advocates to notify $q = "SELECT `reviewerid`, `name_first`, `name_last`, CONCAT_WS(' ', `name_first`, `name_last`) AS `name`, `email`, `username` FROM `" . OCC_TABLE_REVIEWER . "` WHERE `reviewerid` IN (" . implode(',', array_keys($advocateAssignmentAR)) . ")"; $r = ocsql_query($q) or err('Unable not get advocate email address(es) for notification'); // Get notification template // ocIgnore included so poEdit picks up (DB) template translation $ocIgnoreSubject = oc_('New Advocate Assignment(s)'); //T: [:OC_confName:] is the event name $ocIgnoreBody = oc_('New assignments have been made for you to advocate in the [:OC_confName:] OpenConf system: [:assignments:] Thank you.'); list($mailsubject, $msg) = oc_getTemplate('chair-assign_advocates'); // Hook if (oc_hookSet('chair-assign-advocate-notify')) { foreach ($OC_hooksAR['chair-assign-advocate-notify'] as $f) { require_once $f; } } while ($l = ocsql_fetch_assoc($r)) { $templateExtraAR = $l; $templateExtraAR['assignments'] = ''; $templateExtraAR['advocateid'] = $l['reviewerid']; foreach ($advocateAssignmentAR[$l['reviewerid']] as $sid) { $templateExtraAR['assignments'] .= $submissionTitleAR[$sid] . "\n\n"; } $mailsubject = oc_replaceVariables($mailsubject, $templateExtraAR); $msg = oc_replaceVariables($msg, $templateExtraAR); if (sendEmail($l['email'], $mailsubject, $msg)) { print '

Notification sent to ' . safeHTMLstr($l['name']) . ' (' . safeHTMLstr($l['reviewerid']) . ')

'; } else { print '

!! Unable to email notification to ' . safeHTMLstr($l['name']) . ' (' . safeHTMLstr($l['reviewerid']) . ')

'; } } print '

'; } } print '

» Make additional assignments

» View/Edit assignments

» Manage conflicts

'; } else { $pq = "SELECT `" . OCC_TABLE_PAPER . "`.`paperid`, `" . OCC_TABLE_PAPER . "`.`title`, `" . OCC_TABLE_PAPERADVOCATE . "`.`advocateid` FROM `" . OCC_TABLE_PAPER . "` LEFT JOIN `" . OCC_TABLE_PAPERADVOCATE . "` ON `" . OCC_TABLE_PAPER . "`.`paperid`=`" . OCC_TABLE_PAPERADVOCATE . "`.`paperid` ORDER BY `" . OCC_TABLE_PAPER . "`.`paperid`"; $pr = ocsql_query($pq) or err("Unable to get submissions"); // Get pad size for paper id's - yes, we really need the max id, but this should do:) $psize = oc_strlen((string) ocsql_num_rows($pr)); if (ocsql_num_rows($pr) == 0) { print 'No submissions have been made yet

'; } else { if (!isset($_GET['s']) || ($_GET['s'] == "id")) { $idsortstr = 'ID'; $nsortstr = 'Name'; $rsortstr = 'No. Submission'; $legend = "[ Advocate ID - $nsortstr ($rsortstr) ]"; $sortby = "`" . OCC_TABLE_REVIEWER . "`.`reviewerid`"; } elseif ($_GET['s'] == "reviews") { $rsortstr = 'No. Reviews'; $idsortstr = 'ID'; $nsortstr = 'Name'; $legend = "[ No. Submissions - Advocate $nsortstr - $idsortstr ]"; $sortby = "`acount`, `" . OCC_TABLE_REVIEWER . "`.`name_last`, `" . OCC_TABLE_REVIEWER . "`.`name_first`"; } else { $idsortstr = 'ID'; $nsortstr = 'Name'; $rsortstr = 'No. Submissions'; $legend = "[ Advocate Name - $idsortstr ($rsortstr) ]"; $sortby = "`" . OCC_TABLE_REVIEWER . "`.`name_last`, `" . OCC_TABLE_REVIEWER . "`.`name_first`"; } $rq = "SELECT `" . OCC_TABLE_REVIEWER . "`.`reviewerid`, CONCAT_WS(' ', `" . OCC_TABLE_REVIEWER . "`.`name_first`, `" . OCC_TABLE_REVIEWER . "`.`name_last`) AS `name`, count(`" . OCC_TABLE_PAPERADVOCATE . "`.`advocateid`) AS `acount` FROM `" . OCC_TABLE_REVIEWER . "` LEFT JOIN `" . OCC_TABLE_PAPERADVOCATE . "` ON `" . OCC_TABLE_REVIEWER . "`.`reviewerid`=`" . OCC_TABLE_PAPERADVOCATE . "`.`advocateid` WHERE `" . OCC_TABLE_REVIEWER . "`.`onprogramcommittee`='T' GROUP BY `" . OCC_TABLE_REVIEWER . "`.`reviewerid` ORDER BY $sortby"; $rr = ocsql_query($rq) or err("Unable to get program committee members"); // Get pad size for advocate id's - yes, we really need the max id, but this should do:) $rsize = oc_strlen((string) ocsql_num_rows($rr)); if (ocsql_num_rows($rr) == 0) { print 'No program committee members have signed up yet

'; } else { print '

Select Submission(s):

[ Submission ID - Title (Advocate ID or ***) ]

Select Advocate:   (one per submission)

' . $legend . '


Tip: Click the ID, Name, or Submission links
above to re-sort this list (page will reload)

Options:

– check box to also assign advocate as reviewer of submission

– check box to change advocate if one already assigned

'; if ($OC_configAR['OC_allowConflictOverride']) { print '

– check box to make assignments even if there is a conflict

'; } print '

– check box to notify advocate(s) that new assignments have been made


'; } } } printFooter(); ?>