Esempio n. 1
0
 function setPenaltyLUT($tempVar)
 {
     if (is_array($tempVar)) {
         $tempVar = arrayToCSV($tempVar);
     }
     $this->penaltyLUT = $tempVar;
 }
function arrayToCSV($array, $seperator = ';')
{
    if (count($array) > 0) {
        $csv = '';
        foreach ($array as $value) {
            if (is_array($value) > 0) {
                $csv .= arrayToCSV($value);
            } else {
                $csv .= $value . $seperator;
            }
        }
        return $csv . '
';
    } else {
        return false;
    }
}
Esempio n. 3
0
<?php

include "essential.php";
dbconnect();
print_r($_POST);
$query = "UPDATE Requests SET appStatus = 'Cancelled', reqRejectReason='" . $_POST['cancelReason'] . "' WHERE reqNo = " . $_POST['reqNo'] . ";";
execute($query);
$query = "DELETE FROM Instances WHERE reqNo = " . $_POST['reqNo'] . ";";
execute($query);
$query = "SELECT creator, creatorEmail, room from Requests WHERE reqNo =  " . $_POST['reqNo'] . ";";
$result = mysql_fetch_assoc(execute($query));
$query = "SELECT email from ccPerson WHERE reqNo =  " . $_POST['reqNo'] . ";";
$cc = array();
$result2 = execute($query);
while ($res = mysql_fetch_assoc($result2)) {
    $cc[] = $res['email'];
}
$cc = arrayToCSV($cc);
cancel($result['creator'], $result['creatorEmail'], $result['room'], $_POST['reqNo'], $_POST['cancelReason'], $cc);
header("Location: table.php?view=Accepted");
Esempio n. 4
0
}
switch ($_GET[view]) {
    case 'All':
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests ";
        getRequests("All", $query);
        break;
    case 'Pending':
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests where appStatus = 'Pending'";
        getRequests("Pending", $query);
        break;
    case 'Rejected':
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests where appStatus = 'Rejected'";
        getRequests("Rejected", $query);
        break;
    case 'nonConflicts':
        $nonConflicts = "(" . arrayToCSV(checkNonConflicts()) . ")";
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests where reqNo in " . $nonConflicts . "";
        getRequests("nonConflicts", $query);
        break;
    case 'Cancelled':
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests where appStatus = 'Cancelled'";
        getRequests("Cancelled", $query);
        break;
    case 'Accepted':
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests where appStatus = 'Accepted'";
        getRequests("Accepted", $query);
        break;
    case 'Conflicts':
        clashMux(checkConflicts());
        if (isset($_GET['st'])) {
            $mstart = $_GET['st'];
Esempio n. 5
0
function clashMux($clashTuples)
{
    $clashGroups = array();
    $clashed = array();
    foreach ($clashTuples as $tuple1) {
        $currGroup = array();
        if (!in_array($tuple1[0], $clashed)) {
            $clashed[] = $tuple1[0];
            $currGroup[] = $tuple1[0];
        }
        if (!in_array($tuple1[1], $clashed)) {
            $clashed[] = $tuple1[1];
            $currGroup[] = $tuple1[1];
        }
        foreach ($clashTuples as $tuple2) {
            if (in_array($tuple2[0], $currGroup)) {
                if (!in_array($tuple2[1], $clashed)) {
                    $clashed[] = $tuple2[1];
                    $currGroup = array_merge($currGroup, array($tuple2[1]));
                }
            } else {
                if (in_array($tuple2[1], $currGroup)) {
                    if (!in_array($tuple2[0], $clashed)) {
                        $clashed[] = $tuple2[0];
                        $currGroup = array_merge($currGroup, array($tuple2[0]));
                    }
                }
            }
        }
        if (sizeof($currGroup)) {
            $clashGroups[] = $currGroup;
        }
    }
    foreach ($clashGroups as $group) {
        $currGroup = arrayToCSV($group);
        $query = "SELECT reqNo,creator,room,eventTitle,eventStartDate,eventStartTime,reqType,appStatus FROM Requests WHERE reqNo IN (" . $currGroup . ");";
        $events = execute($query);
        ?>
		<tr><td style="visibility:hidden"></td></tr>
		<?php 
        while ($roomRecords = mysql_fetch_assoc($events)) {
            ?>
			<tr>
			<?php 
            foreach ($roomRecords as $record) {
                ?>
				<td> <?php 
                echo $record;
                ?>
 </td> 
			<?php 
            }
            ?>
			<td><a href='req_detail.php?id=<?php 
            echo $roomRecords['reqNo'];
            ?>
'>Details</a></td>
			</tr>
			<?php 
        }
    }
    //print_r($roomRecords);
    return $clashGroups;
}