$a = "accept"; $b = "reject"; $c = "forward"; $d = "Specify a reason for rejection (optional) )"; $rID = getIDFromHash($_POST['reqID']); $reqArray = getRequestByID(getIDFromHash($_POST['reqID'])); //print_r($reqArray); $clashArrays = clashMux(checkConflicts()); foreach ($clashArrays as $clashArray) { if (in_array($rID, $clashArray)) { break; } } $_POST['reqID'] = getIDFromHash($_POST['reqID']); //Get comma separated string of concerned persons, insert into db $reqID = getIDFromHash($_POST['reqID']); $cc = $_POST['cc']; $ccPersons = CSVToArray($cc); foreach ($ccPersons as $guy) { $query = "INSERT INTO ccPerson(reqNo, email) values(\"{$reqID}\", \"{$guy}\");"; //echo $query; execute($query); } //clashArray now has all elements clashing with the current request, including the current request // if ($_POST['reqAction'] == $b) { if ($_POST['reason'] == $d) { $sq = "update Requests set appStatus='Rejected', reqRejectReason='None' where reqNo=" . $_POST['reqID'] . ";"; } else { $sq = "update Requests set appStatus='Rejected',reqRejectReason ='" . $_POST['reason'] . "' where reqNo=" . $_POST['reqID'] . ";"; }
dbconnect(); if (isset($_GET['hash'])) { $hash = $_GET['hash']; } else { die("You followed a wrong link to get to this page. Please notify the administrators."); } /*function getidfromhash($hash) { $sq2="select reqNo from Requests where hash='".$hash."';"; //echo $sq2; $res2=execute($sq2); $aa=mysql_fetch_row($res2); return $aa[0]; }*/ $id = getIDFromHash($hash); //execute($sq2); //$id=19; $sq = "select * from Requests where reqNo =" . $id . ";"; //echo $sq; $res = execute($sq); $col1 = array("RequestNO", "hash", "Creator", "creatorEmail", "creatorPhone ", "creatorPhone ", "concernedPersonEmail", " concernedPPhone", "appStatus", " reqGId", "reqDate", "eventStartDate", "eventEndDate", "eventStartTime", "eventEndTime ", "eventTitle", "eventDesc", "eventDays", "concernedAdmin", "room", "reqType"); $num_row = mysql_num_fields($res); $col = mysql_fetch_row($res); $cAdmin = getConcernedAdmin($id); $gID = mysql_real_escape_string($_GET['gID']); ?> <?php include "header_noCAS.php";