\n"; } } print '

Conflicts have been unset.

'; print '

'; printFooter(); exit; } $pq = "SELECT " . OCC_TABLE_CONFLICT . ".paperid, " . OCC_TABLE_CONFLICT . ".reviewerid, CONCAT_WS(' '," . OCC_TABLE_REVIEWER . ".name_first," . OCC_TABLE_REVIEWER . ".name_last) AS name, title FROM " . OCC_TABLE_PAPER . ", " . OCC_TABLE_REVIEWER . ", " . OCC_TABLE_CONFLICT . " WHERE " . OCC_TABLE_CONFLICT . ".paperid=" . OCC_TABLE_PAPER . ".paperid AND " . OCC_TABLE_CONFLICT . ".reviewerid=" . OCC_TABLE_REVIEWER . ".reviewerid"; if (empty($_GET['s']) || ($_GET['s'] == "pid")) { $q = $pq . " ORDER BY " . OCC_TABLE_CONFLICT . ".paperid, " . OCC_TABLE_CONFLICT . ".reviewerid"; $sortid = "paper"; $pidsort="P-ID
" . $OC_sortImg; $psort='Submission'; $rsort='Reviewer'; $ridsort='R-ID'; } elseif ($_GET['s'] == "paper") { $q = $pq . " ORDER BY " . OCC_TABLE_PAPER . ".title, " . OCC_TABLE_CONFLICT . ".reviewerid"; $sortid = "paper"; $pidsort='P-ID'; $psort="Submission
" . $OC_sortImg; $rsort='Reviewer'; $ridsort='R-ID'; } elseif ($_GET['s'] == "rid") { $q = $pq . " ORDER BY " . OCC_TABLE_CONFLICT . ".reviewerid, " . OCC_TABLE_CONFLICT . ".paperid"; $sortid = "reviewer"; $pidsort='P-ID'; $psort='Submission'; $rsort='Reviewer'; $ridsort="R-ID
" . $OC_sortImg; } elseif ($_GET['s'] == "reviewer") { $q = $pq . " ORDER BY " . OCC_TABLE_REVIEWER . ".name_last, " . OCC_TABLE_REVIEWER . ".name_first, " . OCC_TABLE_CONFLICT . ".paperid"; $sortid = "reviewer"; $pidsort='P-ID'; $psort='Submission'; $rsort="Reviewer
" . $OC_sortImg; $ridsort= 'R-ID'; } else { err("Unknown sort source"); } print '

Links:: Reviewer – Show reviewer info; Submission – Show submission info

Manually Set Conflicts:

'; $r = ocsql_query($q) or err("Unable to get information ".ocsql_errno()); if (ocsql_num_rows($r) == 0) { print '

No conflicts have been set.

'; } else { $s = substr($sortid,0,1); print '

'; $currid = -1; $row = 1; while ($l = ocsql_fetch_array($r)) { if ($sortid == "reviewer") { $ptags = ''; $rtags = ''; } else { $ptags = ''; $rtags = ''; } $blanktags = ''; if ($currid != $l[$sortid.'id']) { if ($currid != -1) { if ($row==1) { $row=2; } else { $row=1; } } $currid = $l[$sortid.'id']; } else { if ($sortid == "reviewer") { $rtags = $blanktags; } else { $ptags = $blanktags; } } print '' . $ptags . $rtags; print ''; print "\n"; } print '

' . $pidsort . '	' . $psort . '	' . $ridsort . '	' . $rsort . '	UC

'.$l['paperid'].'	' . safeHTMLstr($l['title']) . '	' . $l['reviewerid'] . '	' . safeHTMLstr($l['name']) . '	'.$l['paperid'].'	' . safeHTMLstr($l['title']) . '	'.$l['reviewerid'].'	' . safeHTMLstr($l['name']) . '
'; if (empty($l['reviewerid'])) { print ' '; } else { print ''; } print '

'; } // Show auto-detected conflicts print '

Automatically Detected Conflicts: (email ' . ($OC_configAR['OC_allowOrgConflict'] ? '' : 'or organization ') . 'matches)

'; $q = "SELECT " . OCC_TABLE_AUTHOR . ".paperid, reviewerid, title, CONCAT_WS(' '," . OCC_TABLE_REVIEWER . ".name_first," . OCC_TABLE_REVIEWER . ".name_last) AS name FROM " . OCC_TABLE_AUTHOR . ", " . OCC_TABLE_PAPER . ", " . OCC_TABLE_REVIEWER . " WHERE "; $q .= OCC_TABLE_PAPER . ".paperid=" . OCC_TABLE_AUTHOR . ".paperid AND "; $q .= "(" . OCC_TABLE_AUTHOR . ".email=" . OCC_TABLE_REVIEWER . ".email"; $q .= " OR (" . OCC_TABLE_AUTHOR . ".organization<>'' AND " . OCC_TABLE_AUTHOR . ".organization=" . OCC_TABLE_REVIEWER . ".organization)"; $q .= ") GROUP BY paperid, reviewerid ORDER BY paperid, reviewerid"; $r = ocsql_query($q) or err("Unable to get auto paper/reviewer conflicts ".ocsql_errno()); if (ocsql_num_rows($r) < 1) { print '

No conflicts detected

'; } else { print ''; $row = 1; while ($l=ocsql_fetch_array($r)) { print ''; $row = $rowAR[$row]; } print '

Submission	Reviewer
' . $l['paperid'] . '. ' . safeHTMLstr($l['title']) . '	' . $l['reviewerid'] .'. ' . safeHTMLstr($l['name']) . '

You may choose whether an organization match results in a conflict by changing the advanced OpenConf configuration setting OC_allowOrgConflict. Note that for a match to occur, they must be exactly the same.

'; } // Check for addt'l (hook) conflict displays if (isset($OC_hooksAR['list_conflicts-display']) && !empty($OC_hooksAR['list_conflicts-display'])) { foreach ($OC_hooksAR['list_conflicts-display'] as $hook) { print '

'; require_once $hook; } } printFooter(); ?>