<?php 
// php code starts here........................................................................
  if ($includeConfigFlag == false) {
    HEADER("Expires: Mon, 07 FEB 2000 05:00:00 GMT");             // Date in the past
    HEADER("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
    HEADER("Cache-Control: no-cache, must-revalidate");           // HTTP/1.1
    HEADER("Pragma: no-cache");

    include ("./CMSconfig.phpi"); // include the config file...
  }
  
  // determine which HTTP variables can be posted to this script

  $allowed_full_keys = array("rgsID","athUserName","athPassword","login","usernm","passwd","pymID","chgStatus","mode","searchField","orderBy","viewBy"); 

  $allowed_key_prefixes = array("status");

  if (sizeof($HTTP_GET_VARS) > 0) {
    $http_input_vars = $HTTP_GET_VARS;  
  } 
 
  if (sizeof($HTTP_POST_VARS) > 0) {
    $http_input_vars = $HTTP_POST_VARS;  
  } 

  while (list($key, $value) = each($http_input_vars)) {
      if (in_array($key,$allowed_full_keys)) {
        if (($magic_quotes_gpc_off) && (! $slashesadded)){
  	  $value = addslashes($value);
        }
	${$key} = $value;
      }
      else {
	reset($allowed_key_prefixes);	
        while (list($foo, $keyname) = each($allowed_key_prefixes)) {
          if (preg_match("/^".$keyname."\d+/",$key)) {
            if (($magic_quotes_gpc_off) && (! $slashesadded)){
	      $value = addslashes($value);
            }
	    ${$key} = $value;
            break;
	  }
        } 
      }  
  }
  $slashesadded = true;
  
  // authenticate user....
  $db_CMS->db_process_query("select", $athTbl, "*", "none", "athUserName = '$usernm' and athPassword = '$passwd' and athLevel = 'organizer'", "none"); 
  
  if ($db_CMS->dbNumRow == 0) {
   // error something wrong..... reset the whole page...
   echo "something wrong";
  }
  else {
    if ($mode == "sts") {
      // we basically update the status of user to deleted..
      switch($chgStatus) {
        case "rqs" :
          $chgStatus = "requested";
          break;
        case "cnf" :
          $chgStatus = "confirmed";
          break;
        case "del" :
          $chgStatus = "deleted";
          break;
        case "wtd" :
          $chgStatus = "withdrawn";
          break;
        case "pna" :
          $chgStatus = "Appr. reqd.";
          break;  
      }
      $db_CMS->db_process_query("update",$rgsTbl,"rgsStatus = '$chgStatus'","none","rgsID = '$rgsID'","none");
    }

    switch ($viewBy) {
      case "vewAll" :
        $cndValue = "none";
        break;
      case "vewAllExcDelWithDr" :
        $cndValue = "((not (rgsStatus = 'withdrawn')) and (not (rgsStatus = 'deleted')))";
        break;
      case "vewAllExcDel" :
        $cndValue = "(not (rgsStatus = 'deleted'))";
        break;
      case "vewConfirmed" :
        $cndValue = "rgsStatus = 'confirmed'";
        break;
      case "vewPending" :
        $cndValue = "rgsStatus = 'Appr. reqd.'";
        break;
      case "vewRequested" :
        $cndValue = "rgsStatus = 'requested'";
        break;
      case "vewWithdrawn":
        $cndValue = "rgsStatus = 'withdrawn'";
        break;
      case "vewDeleted" :
        $cndValue = "rgsStatus = 'deleted'";
        break;
      default :
        $cndValue = "((not (rgsStatus = 'withdrawn')) and (not (rgsStatus = 'deleted')))";
    }  
  
    // find out all participants registered for the conference
    switch ($orderBy) {
      case null :
        $orderBy = "rgsID";
        break;
      case "" :
        $orderBy = "rgsID";
        break;
    }
        
    if ($orderBy != "anbName") {
      $db_CMS->db_process_query("select",$rgsTbl,"*","none","$cndValue","$orderBy");
    }
    else {
      $db_CMS->db_process_query("select",$rgsTbl,"*","none","$cndValue","none");
    }
  
    $sRsltSet_rgs = $db_CMS->dbRsltSet;
  
    if ($db_CMS->dbNumRow > 0) { //ok there are people registered.. now find out details about them..
      $errFlag = false;
      $rowCount = 0; // initialize a counter..

      // list of coloumn names to be displayed..
      $colValue = array("ID","User Name","Full Name","Registration Date","Category","Status","anbodyID","paymentID","email", "tagName", "tagAddress");

      while ($sCurRow_rgs = $db_CMS->db_fetch_array($sRsltSet_rgs)) {
        $rgsID = $sCurRow_rgs["rgsID"];
        $athUserName = $sCurRow_rgs["athUserName"];
        $pymID = $sCurRow_rgs["pymID"];
        $rgsRegistrationDate = $sCurRow_rgs["rgsRegistrationDate"];
        $rgsCategory = $sCurRow_rgs["rgsCategory"];
        $rgsStatus = $sCurRow_rgs["rgsStatus"];
        $rgsTagAddress = $sCurRow_rgs["rgsTagAddress"];

        // look up personal information for now..
        $db_CMS->db_process_query("select",$anbTbl,"*","none","athUserName = '$athUserName'","none");
        $sRsltSet_anb = $db_CMS->dbRsltSet;
        $sCurRow_anb = $db_CMS->db_fetch_array($sRsltSet_anb);

        // ok store the respective values...
        $rowValue[$rowCount][$colValue[0]] = $rgsID;
        $rowValue[$rowCount][$colValue[1]] = $athUserName;
        $rowValue[$rowCount][$colValue[2]] = $sCurRow_anb["anbLName"];        	  	 
        $rowValue[$rowCount][$colValue[2]] .= ",&nbsp;".$sCurRow_anb["anbTitle"];
        $rowValue[$rowCount][$colValue[2]] .= "&nbsp;".$sCurRow_anb["anbFName"];
      
        $rowValue[$rowCount][$colValue[3]] = $rgsRegistrationDate;
        $rowValue[$rowCount][$colValue[4]] = $rgsCategory;
        $rowValue[$rowCount][$colValue[5]] = $rgsStatus;
        $rowValue[$rowCount][$colValue[6]] = $pymID;
        $rowValue[$rowCount][$colValue[7]] = $sCurRow_anb["anbEmail"]; 
        $rowValue[$rowCount][$colValue[8]] = $sCurRow_anb["anbFName"]." ".$sCurRow_anb["anbLName"]; 
        $rowValue[$rowCount][$colValue[9]] = $rgsTagAddress; 
        
        rmvQuotes($rowValue[$rowCount][$colValue[8]]);
        $rowCount++;
      }

      // create a new array..
      for ($rowTmpCnt=0;$rowTmpCnt<count($rowValue);$rowTmpCnt++) {
        $rowTmpValue[$rowTmpCnt] = strtoupper($rowValue[$rowTmpCnt][$colValue[2]]);
      }

    
      // let's do the sorting..here.. based on the orderby variable.. 
      // we only have to do it for full Name
    
      switch ($orderBy) {
        case "anbName" :
          asort($rowTmpValue);
          break;
      }
    }
    else {
      // list of coloumn names to be displayed..
      $colValue = array("ID","User Name","Full Name","Registration Date","Category","Status","anbodyID","paymentID","email","tagName", "tagAddress");
  
      $errMsg = "Sorry, registrations of this status are not present.";
      $errFlag = true;
    }

    $all_e_mails_on_list = ""; // mail address string for all registered participants;

// php codes ends ..............................................................................  
?>
    <html>
      <head>
	<script LANGUAGE="JavaScript">
	  function submitFormValue(rgsID,athUserName,rgsCategory,pymID,modeValue,countValue) {
	    document.administration.rgsID.value = rgsID;
	    document.administration.pymID.value = pymID;
	    document.administration.athUserName.value = athUserName;
	    
	    if (modeValue == 'sts') {
	      myEvalString = 'optionIndex = document.administration.status'+countValue+'.selectedIndex;';
	      eval(myEvalString);
	      myEvalString = 'document.administration.chgStatus.value = document.administration.status'+countValue+'.options[optionIndex].value;';
	      eval(myEvalString);
	      document.administration.action='usrAdministration.php3';
	      if (document.administration.chgStatus.value == 'del') {
	        confirmMsg = 'You are about to delete a participant. Are you sure??';
	        if (confirm(confirmMsg)) {
	          document.administration.mode.value = 'sts';
	        }
	        else {
	          document.administration.mode.value = 'rld';
	        }
	      }
	      else {
	        document.administration.mode.value = 'sts';
	      }
	    }
	    else {
	      document.administration.action='individualInfo.php3';
	    }
	    document.administration.submit();
	  }
	 
	  function submitFinancialValue(pymID, athUserName) {
	    document.administration.action='financialInfo.php3';
	    document.administration.pymID.value = pymID;
	    document.administration.searchField.value = athUserName;
	    document.administration.submit();
	  }
        </script>
      </head>
     
      <body BGCOLOR="#ffffff">
  	<form NAME="administration" ACTION="usrAdministration.php3" METHOD="post">
  	  <table CELLSPACING="1" CELLPADDING="2" ALIGN="center" WIDTH="100%" BORDER="0" BGCOLOR="#ffffff">
  	    <tr>
  	      <td COLSPAN="7" BGCOLOR="99cccc">
  		<font SIZE="+1">Participant Administration</font>
  	      </td>
  	    </tr>
  	    <input TYPE="hidden" NAME="rgsID" VALUE="">
  	    <input TYPE="hidden" NAME="athUserName" VALUE="">
  	    <input TYPE="hidden" NAME="usernm" VALUE="<?php echo $usernm; ?>">
  	    <input TYPE="hidden" NAME="passwd" VALUE="<?php echo $passwd; ?>">
  	    <input TYPE="hidden" NAME="pymID" VALUE="">
  	    <input TYPE="hidden" NAME="chgStatus" VALUE="">
  	    <input TYPE="hidden" NAME="mode" VALUE="">
  	    <input TYPE="hidden" NAME="searchField" VALUE="">
 
<?php
// php code starts here..............................................................
  	    $colCount = count($colValue)-5; // get the number of columns.
  	    echo "<tr BGCOLOR=\"#cccccc\" WIDTH=\"100%\">";
  	      // create the column names...
  	      for ($count=0;$count<$colCount;$count++) {
		$colLabel = $colValue[$count];
		$colLabel = preg_replace("/\s/","<br>",$colLabel);
  		echo "<td>";
  		  echo "<font COLOR=\"#ffffff\" SIZE=\"-2\" FACE=\"arial\"><b>".$colLabel."</b></font>";
  		echo "</td>";
  	      }
  	      echo "<td>";
  		echo "&nbsp;";
  	      echo "</td>";
  	    echo "</tr>";
 
  	    if ($errFlag) {
  	      echo "<tr bgColor=\"#ffffff\">";
  		echo "<td COLSPAN=\"6\">";
  		  echo $errMsg;
  		echo "</td>";
  	      echo "</tr>";
  	    }
  	    else {
  	      // lets print their respective values...........
  		reset($rowTmpValue);
  		$countX = 0;
  		while (list($key,$value) = each($rowTmpValue)) {
  		  if (($rowValue[$key][$colValue[5]] == "deleted") || ($rowValue[$key][$colValue[5]] == "withdrawn")){
  		    echo "<tr bgColor=\"#cc9999\">";
  		  }
  		  else {
  		    if ($rowValue[$key][$colValue[5]] == "confirmed") {
  		      echo "<tr bgColor=\"#99cc99\">";
  		    }
  		    else {
  		      echo "<tr bgColor=\"#9999cc\">";
  		    }
  		  }
  		  for ($countY=0;$countY<$colCount;$countY++) {
  		    if ($rowValue[$key][$colValue[$countY]] == "") {
  		      $rowValue[$key][$colValue[$countY]] = "&nbsp;";
  		    }
  		    echo "<td>";
  		      echo "<font COLOR=\"#000000\" SIZE=\"-1\" FACE=\"arial\">";
  		        switch ($countY) {
  		          case 0 :
  		            echo $countX+1;
  		            break;
  		          case 2 :
  		            echo "<a HREF=\"mailto:".$rowValue[$key][$colValue[7]]."\">".$rowValue[$key][$colValue[$countY]]."</a><br>";
  		            echo "<script LANGUAGE=\"javascript\">\n";
  		            echo "  var myUrlPDF = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME=".urlencode($rowValue[$key][$colValue[8]])."&INSTITUTION=".urlencode($rowValue[$key][$colValue[9]])."&CONFERENCE=".urlencode($nameTagConferenceName)."&FORMAT=PDF\"><img BORDER=\"0\" SRC=\"images/pdftag.gif\"></a>';";
  		            echo "  var myUrlPS = '<a TARGET=\"new\" HREF=\"http://www.tcs.auckland.ac.nz/~ulrich/cgi-bin/nametags.cgi?NAME=".urlencode($rowValue[$key][$colValue[8]])."&INSTITUTION=".urlencode($rowValue[$key][$colValue[9]])."&CONFERENCE=".urlencode($nameTagConferenceName)."&FORMAT=PS\"><img BORDER=\"0\" SRC=\"images/pstag.gif\"></a>';";
  		            echo "  document.write('<font SIZE=\"-2\">Name tags in ');";
  		            echo "  document.write(myUrlPDF);";
  		            echo "  document.write(' or ');";
  		            echo "  document.write(myUrlPS);";
   		            echo "  document.writeln('</font>');";
	                    echo "</script>";
                            $all_e_mails_on_list = $all_e_mails_on_list.$rowValue[$key][$colValue[7]].",";
  		            break;
			  case 3 :
			    $colDateValue = $rowValue[$key][$colValue[$countY]];
			    $colDateValue = preg_replace("/\s/","<br>",$colDateValue);
			    echo "<font size=\"-2\">".$colDateValue."</font>";
			    break;
  		          case 5 :
  		            echo "<font COLOR=\"#000000\" SIZE=\"-2\" FACE=\"arial\">";
		              echo "<select NAME=\"status".$key."\" WIDTH=\"10\" ONCHANGE=\"submitFormValue('".$rowValue[$key][$colValue[0]]."','".$rowValue[$key][$colValue[1]]."','".$rowValue[$key][$colValue[4]]."','".$rowValue[$key][$colValue[6]]."','sts', '$key');\">";
		                echo "<option VALUE=\"\">".$rowValue[$key][$colValue[$countY]]."</option>";
		                echo "<option VALUE=\"rqs\">Requested</option>";
		                echo "<option VALUE=\"cnf\">Confirmed</option>";
		                echo "<option VALUE=\"del\">Deleted</option>";
		                echo "<option VALUE=\"wtd\">Withdrawn</option>";
		                echo "<option VALUE=\"pna\">Appr. reqd.</option>";
		              echo "</select>";
		            echo "</font>";
		            break;
  		          default :
  		            echo $rowValue[$key][$colValue[$countY]];
  		        } // end of switch
  		      echo "</font>";
  		    echo "</td>";
  		  } // end of for
  		    echo "<td>";
		      echo "<font size=\"-1\">";
  		      echo "<input TYPE=\"submit\" NAME=\"personal".$key."\" VALUE=\"personal\" ONCLICK=\"submitFormValue('".$rowValue[$key][$colValue[0]]."','".$rowValue[$key][$colValue[1]]."','".$rowValue[$key][$colValue[4]]."','".$rowValue[$key][$colValue[6]]."','vew', '$key');\">";
  		      echo "<br>";
		      echo "<input TYPE=\"submit\" NAME=\"financial".$key."\" VALUE=\"financial\" ONCLICK=\"submitFinancialValue('".$rowValue[$key][$colValue[6]]."','".$rowValue[$key][$colValue[1]]."');\">";
		      echo "</font>";	
		    echo "</td>";
		    $countX++; // increment the row counter...
		  echo "</tr>";
	        }
	      }
  	      echo "<tr BGCOLOR=\"#99cccc\">";
  	        echo "<td COLSPAN=\"2\">";
  	          echo "Order By : <br>";
  	          echo "<select NAME=\"orderBy\" onChange=\"document.administration.submit();\">";
  	  	    echo "<option VALUE=\"".$orderBy."\"></option>";
  		    echo "<option VALUE=\"anbName\">Name</option>";
  		    echo "<option VALUE=\"rgsStatus\">Status</option>";
  		    echo "<option VALUE=\"rgsCategory\">Category</option>";
  		    echo "<option VALUE=\"rgsRegistrationDate\">Registration Date</option>";
  	          echo "</select>";
  	        echo "</td>";
 
  	        echo "<td COLSPAN=\"1\">";
  	          echo "View by status : <br>";
  	          echo "<select NAME=\"viewBy\" onChange=\"document.administration.submit();\">";
  	  	    echo "<option VALUE=\"".$viewBy."\"></option>";
  		    echo "<option VALUE=\"vewAllExcDelWithDr\">All except deleted/withdrawn</option>";
  		    echo "<option VALUE=\"vewAllExcDel\">All except deleted</option>";
  		    echo "<option VALUE=\"vewAll\">All</option>";
       		    echo "<option VALUE=\"vewConfirmed\">Confirmed</option>";
  		    echo "<option VALUE=\"vewPending\">Appr. reqd.</option>";
  		    echo "<option VALUE=\"vewRequested\">Requested</option>";
  		    echo "<option VALUE=\"vewWithdrawn\">Withdrawn</option>";
  		    echo "<option VALUE=\"vewDeleted\">Deleted</option>";
  	          echo "</select>";
  	        echo "</td>";
 
  	        echo "<td COLSPAN=\"1\">";
  	          echo "<input TYPE=\"submit\" NAME=\"refresh\" VALUE=\"Refresh\" onClick=\"document.administration.submit();\">";
  	        echo "</td>";
  	      echo "</tr>";
// php code ends here..
?>    	     
          </table>
	  <p>
          <?php echo "<A HREF='mailto:".substr($all_e_mails_on_list,0,strlen($all_e_mails_on_list)-1)."'>";
                echo "E-mail all people on the list above</A></P>";
          ?>
        </form>
      </body>
    </html>
<?php    
  }
?>