function courseToInstance()
{
$day2No = array("Sun" => 1, "Mon" => 2, "Tue" => 3, "Wed" => 4, "Thu" => 5, "Fri" => 6, "Sat" => 7);
$eventStartDate = "2012-08-01";
$eventEndDate = "2012-11-28";
dbconnect();
$query = "SELECT reqNo FROM Requests ORDER BY reqNO DESC limit 1";
$result = mysql_fetch_row(execute($query));
$reqNo = $result['reqNo'];
$query = "SELECT * FROM CourseRooms;";
$result = execute($query);
$i = 0;
$total = mysql_num_rows($result);
while ($roomRecords = mysql_fetch_assoc($result)) {
$instances = weeklyRequestToInstance($eventStartDate, $eventEndDate, CSVToArray($day2No[$roomRecords['Day']]));
foreach ($instances as $instance) {
$reqNo++;
$query = "INSERT INTO Instances(reqNo,hash,creator,creatorEmail,creatorPhone,concernedPName,concernedPEmail,concernedPPhone,appStatus,reqGId,reqDate,eventStartDate,eventEndDate,eventStartTime,eventEndTime,eventTitle,eventDesc,eventDays,concernedAdmin,room,reqType) VALUES(\n\t\t\t\t'" . $reqNo . "',\n '" . ($hash = sha1(uniqid(mt_rand(), true)) . "',\n 'Admin',\n '*****@*****.**',\n '',\n 'Admin',\n '*****@*****.**',\n '',\n 'Accepted', \n '5',\n '" . ($reqDate = date("Y-m-d H:i:s") . "',\n '" . $instance . "',\n '" . $instance . "',\n '" . $roomRecords['StartTime'] . "',\n '" . $roomRecords['EndTime'] . "',\n '" . $roomRecords['Code'] . "',\n '" . $roomRecords['Name'] . "',\n '" . $day2No[$roomRecords['Day']] . "',\n 'Admin',\n '" . $roomRecords['Room'] . "',\n '" . $roomRecords['Type'] . "'\n );"));
execute($query);
}
$i++;
$percent = intval($i / $total * 100) . "%";
// Javascript for updating the progress bar and information
echo '<script language="javascript">
document.getElementById("progress").innerHTML="<div style=\\"width:' . $percent . ';background-color:#ddd;\\"> </div>";
document.getElementById("information").innerHTML="' . $i . '/' . $total . ' row(s) processed.";
</script>';
// This is for the buffer achieve the minimum size in order to flush data
echo str_repeat(' ', 1024 * 64);
// Send output to browser immediately
flush();
// Sleep one second so we can see the delay
}
}
//
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'] . ";";
}
$req = getRequestByID($rID);
reject($req['creator'], $req['creatorEmail'], $req['room'], $req['reqNo'], $_POST['reason'], getCC($rID));
reject($req['concernedPName'], $req['concernedPEmail'], $req['room'], $req['reqNo'], $_POST['reason']);
} else {
if ($_POST['reqAction'] == $a) {
$query = "SELECT * FROM Requests WHERE reqNo=" . $_POST['reqID'] . ";";
$acceptedEvent = execute($query);
$roomRecords = mysql_fetch_assoc($acceptedEvent);
$instances = weeklyRequestToInstance($roomRecords['eventStartDate'], $roomRecords['eventEndDate'], CSVToArray($roomRecords['eventDays']));
foreach ($instances as $instance) {
$query = "INSERT INTO Instances(reqNo,hash,creator,creatorEmail,creatorPhone,concernedPName,concernedPEmail,concernedPPhone,appStatus,reqGId,reqDate,eventStartDate,eventEndDate,eventStartTime,eventEndTime,eventTitle,eventDesc,eventDays,concernedAdmin,room,reqType) VALUES(\n\t\t\t'" . $roomRecords['reqNo'] . "',\n\t\t\t'" . $roomRecords['hash'] . "',\n\t\t\t'" . $roomRecords['creator'] . "',\n\t\t\t'" . $roomRecords['creatorEmail'] . "',\n\t\t\t'" . $roomRecords['creatorPhone'] . "',\n\t\t\t'" . $roomRecords['concernedPName'] . "',\n\t\t\t'" . $roomRecords['concernedPEmail'] . "',\n\t\t\t'" . $roomRecords['concernedPPhone'] . "',\n\t\t\t'Accepted', \n\t\t\t'" . $roomRecords['reqGId'] . "',\n\t\t\t'" . $roomRecords['reqDate'] . "',\n\t\t\t'" . $instance . "',\n\t\t\t'" . $instance . "',\n\t\t\t'" . $roomRecords['eventStartTime'] . "',\n\t\t\t'" . $roomRecords['eventEndTime'] . "',\n\t\t\t'" . $roomRecords['eventTitle'] . "',\n\t\t\t'" . $roomRecords['eventDesc'] . "',\n\t\t\t'" . $roomRecords['eventDays'] . "',\n\t\t\t'" . $roomRecords['concernedAdmin'] . "',\n\t\t\t'" . $roomRecords['room'] . "',\n\t\t\t'" . $roomRecords['reqType'] . "'\n\t\t);";
execute($query);
}
$sq = "update Requests set appStatus='Accepted' where reqNo=" . $_POST['reqID'] . ";";
$clash = requestClash($roomRecords['eventStartDate'], $roomRecords['eventEndDate'], $roomRecords['eventStartTime'], $roomRecords['eventEndTime'], $roomRecords['room']);
while ($req = mysql_fetch_assoc($clash)) {
//print_r($req);
if ($req['reqNo'] != $rID) {
//echo $req['reqNo'];
//echo "<HI><br><br><br><br>\n";
$otherQuery = "update Requests set appStatus = 'Rejected', reqRejectReason = 'A request conflicting with your request was accepted.' where reqNo = {$req['reqNo']}";
//echo $otherQuery."\n";
execute($otherQuery);
reject($req['creator'], $req['creatorEmail'], $req['room'], $req['reqNo'], getCC($rID));
