All Committee Members';
print '
';
}
if (isset($_POST['faction']) && isset($_POST['drop']) && !empty($_POST['drop'])) {
// Check for valid submission
if (!validToken('chair')) {
warn('Invalid submission');
}
if ($_POST['faction'] == "Delete Members") { // delete members
foreach ($_POST['drop'] as $val) {
if (preg_match("/^\d+$/", $val)) {
issueSQL("DELETE FROM `" . OCC_TABLE_PAPERADVOCATE . "` WHERE `advocateid`='" . safeSQLstr($val) . "'");
issueSQL("DELETE FROM `" . OCC_TABLE_PAPERREVIEWER . "` WHERE `reviewerid`='" . safeSQLstr($val) . "'");
issueSQL("DELETE FROM `" . OCC_TABLE_REVIEWERTOPIC . "` WHERE `reviewerid`='" . safeSQLstr($val) . "'");
issueSQL("DELETE FROM `" . OCC_TABLE_PAPERSESSION . "` WHERE `reviewerid`='" . safeSQLstr($val) . "'");
issueSQL("DELETE FROM `" . OCC_TABLE_REVIEWER . "` WHERE `reviewerid`='" . safeSQLstr($val) . "'");
}
}
} elseif ($_POST['faction'] == "Add to PC") { // add to program committee
foreach ($_POST['drop'] as $val) {
if (preg_match("/^\d+$/", $val)) {
issueSQL("UPDATE " . OCC_TABLE_REVIEWER . " SET `onprogramcommittee`='T' WHERE `reviewerid`='" . safeSQLstr($val) . "' LIMIT 1");
}
}
} elseif ($_POST['faction'] == "Remove from PC") { // remove from program committee
foreach ($_POST['drop'] as $val) {
if (preg_match("/^\d+$/", $val)) {
issueSQL("DELETE FROM `" . OCC_TABLE_PAPERADVOCATE . "` WHERE `advocateid`='" . safeSQLstr($val) . "'");
issueSQL("UPDATE `" . OCC_TABLE_REVIEWER . "` SET `onprogramcommittee`='F' WHERE `reviewerid`='" . safeSQLstr($val) . "' LIMIT 1");
}
}
}
}
if (!isset($_REQUEST['s']) || empty($_REQUEST['s']) || ($_REQUEST['s'] == "id")) {
$sortby = "`reviewerid`";
$rsortstr = 'ID ' . $OC_sortImg;
$pcsortstr = 'PC';
$nsortstr = 'Name';
} elseif ($_REQUEST['s'] == "pc") {
$sortby = "`onprogramcommittee`, `name_last`, `name_first`";
$pcsortstr = 'PC ' . $OC_sortImg;
$rsortstr = 'ID';
$nsortstr = 'Name';
} else { // name sort
$sortby = "`name_last`, `name_first`";
$nsortstr = 'Name ' . $OC_sortImg;
$rsortstr = 'ID';
$pcsortstr = 'PC';
}
$q = "SELECT `reviewerid`, CONCAT_WS(' ',`name_first`,`name_last`) AS `name`, `username`, `email`, `onprogramcommittee`, `comments` FROM `" . OCC_TABLE_REVIEWER . "` $cmtAdd ORDER BY $sortby";
$r = ocsql_query($q) or err("Unable to get information");
if (ocsql_num_rows($r) == 0) {
print 'No committee members have signed up yet
';
} else {
print '
Count: ' . ocsql_num_rows($r) . '
Note: If you choose to delete committee member(s), any records of papers assigned to them for review ' . ($OC_configAR['OC_paperAdvocates'] ? 'or advocacy ' : '') . 'will also be deleted.