<?
include('../Code/confHeader.inc');
$Me -> goIfInvalid("../index.php");
$Me -> goIfNotAssistant('../index.php');
$Conf -> connect();
?>

<html>

<? $Conf->header("Prepare Facesheet Material") ?>

<body>

<h2> List of paper contacts (names and email addresses) </h2>

<?

$query = "SELECT firstName, lastName, email, "
	. " paperId, outcome, title "
	. " FROM ContactInfo, Paper "
	. " WHERE (Paper.outcome='accepted' OR Paper.outcome='acceptedShort') "
	. " AND Paper.contactId=ContactInfo.contactId "
	. " ORDER BY paperId ";

$result = $Conf->qe($query);

if (DB::isError($result)) {
  $Conf->errorMsg("Error in retrieving author list "
		  . $result->getMessage());
} else {
  print "<table align=center border=1>\n";
  print "<tr> <th> # </th> <th> Paper # </th> ";
  print "<th> Contact Authors for Accepted Papers </th>\n";
  print "<th> Paper Title </th> </tr>\n";

  $num = 1;
  while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
    print "<tr> <td> $num </td> <td> " . $row['paperId'] . " </td> ";
    print "<td> "
      . $row['firstName']
      . " "
      . $row['lastName'] 
      . " ( "
      . $row['email'] . " ) </td>\n";
    print "<td> " . $row['title'] . " </td>\n";
    print "</tr>";
    $num++;
  }
  print "</table>";
}

?>

<h2> List of all reviewers who provided first and last names </h2>

<?

$query = "SELECT firstName, lastName, email, "
	. " paperId "
	. " FROM PaperReview, ContactInfo "
	. " WHERE PaperReview.finalized=1 "
	. " AND firstName!='' "
	. " AND lastName!='' "
	. " AND PaperReview.reviewer=ContactInfo.contactId "
	. " GROUP BY reviewer "
	. " ORDER BY lastName, firstName ";

$result = $Conf->qe($query);

if (DB::isError($result)) {
  $Conf->errorMsg("Error in retrieving author list "
		  . $result->getMessage());
} else {
  print "<table align=center border=1>\n";
  print "<tr> <th> # </th> ";
  print "<th> Reviewers </th>\n";
  print "</tr>\n";

  $num = 1;
  while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
      print "<tr> <td> $num </td> ";
      print "<td> "
	. $row['firstName']
	. " "
	. $row['lastName'] 
	. " ( "
	. $row['email'] . " ) </td>\n";
      print "</tr>";
      $num++;
  }
  print "</table>";
}

?>

<h2> List of all reviewers who only provided partial information </h2>

<?

$query = "SELECT firstName, lastName, email, "
	. " paperId "
	. " FROM PaperReview, ContactInfo "
	. " WHERE PaperReview.finalized=1 "
	. " AND (firstName='' OR lastName='') "
	. " AND PaperReview.reviewer=ContactInfo.contactId "
	. " GROUP BY reviewer "
	. " ORDER BY lastName, firstName ";

$result = $Conf->qe($query);

if (DB::isError($result)) {
  $Conf->errorMsg("Error in retrieving author list "
		  . $result->getMessage());
} else {
  print "<table align=center border=1>\n";
  print "<tr> <th> # </th> ";
  print "<th> Reviewers </th>\n";
  print "</tr>\n";

  $num = 1;
  while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
    print "<tr> <td> $num </td> ";
    print "<td> "
      . $row['firstName']
      . " "
      . $row['lastName'] 
      . " ( "
      . $row['email'] . " ) </td>\n";
    print "</tr>";
    $num++;
  }
  print "</table>";
}
?>



</body>
<? $Conf->footer() ?>
</html>

