| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST2146/VM_Data/Data_WWW/scheduler/Schedule/ |
Upload File : |
<?
// Schedule/getSchedule.phpinc
// include_purpose.
t_Begin(); // Begin TRACKing getSchedule.phpinc.
f('departmentId',0);
f('sessionId',0);
d_V('departmentId');
d_V('sessionId');
if ( $f['departmentId'] && $f['sessionId'] ) {
// Check for schedule.
$query = "
SELECT scheduleId
, departmentId
, sessionId
, scheduleName
FROM `schedule`
WHERE departmentId = ".$f['departmentId']."
AND sessionId = ".$f['sessionId']."
";
d_Var('scheduleInfo',$query,'q');
$scheduleInfo = query_info($query);
d_Var('$scheduleInfo',$scheduleInfo);
if ( !$scheduleInfo ) {
// INSERT new schedule.
$query = "
INSERT INTO `schedule` (
departmentId
, sessionId
, scheduleName
) VALUES (
".$f['departmentId']."
, ".$f['sessionId']."
, '".query_safe($f['scheduleName'])."'
)
";
d_Var('scheduleINSERT',$query,'q');
$scheduleINSERT = query_do($query);
d_Var('$scheduleINSERT',$scheduleINSERT,'l');
$_SESSION['user']['scheduleId'] = $GLOBALS['_QUERY']['insertId'];
d_Var("\$_SESSION['user']['scheduleId']",$_SESSION['user']['scheduleId']);
} else {
$_SESSION['user']['scheduleId'] = $scheduleInfo['scheduleId'];
}
} else {
if ( $_SESSION['user']['scheduleId'] ) {
// Get sessionId and departmentId.
$query = "
SELECT departmentId
, sessionId
, scheduleName
FROM `schedule`
WHERE scheduleId = ".$_SESSION['user']['scheduleId']."
";
d_Var('scheduleInfo',$query,'q');
$scheduleInfo = query_info($query);
d_Var('$scheduleInfo',$scheduleInfo);
$f['sessionId'] = $scheduleInfo['sessionId'];
$f['departmentId'] = $scheduleInfo['departmentId'];
} else {
$scheduleInfo = NULL;
$f['sessionId'] = NULL;
$f['departmentId'] = NULL;
}
}
d_V('sessionId');
d_V('departmentId');
d_Var("\$_SESSION['user']['scheduleId']",$_SESSION['user']['scheduleId']);
include('Schedule/getSession.phpinc');
// Get department.
$query = "
SELECT *
FROM `department`
WHERE departmentId = ".$f['departmentId']."
";
d_Var('departmentInfo',$query,'q');
$departmentInfo = query_info($query);
d_Var('$departmentInfo',$departmentInfo);
t_End(); // End TRACKing getSchedule.phpinc.
?>