コード例 #1
0
ファイル: acceptRejectHash.php プロジェクト: nehaljwani/SSAD
$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'] . ";";
    }
コード例 #2
0
ファイル: req_detail_hash.php プロジェクト: nehaljwani/SSAD
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";