| 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/newSchedule.phpinc
// include_purpose.
t_Begin(true); // Begin TRACKing newSchedule.phpinc.
pageHeader('New Schedule');
sectionHeader();
f('sessionId'); if ( !$f['sessionId'] ) !$f['sessionId'] = 0;
f('departmentId'); if ( !$f['departmentId'] ) !$f['departmentId'] = 0;
f('scheduleId'); if ( !$f['scheduleId'] ) !$f['scheduleId'] = 0;
if ( !$f['scheduleId'] && $_SESSION['user']['scheduleId'] ) $f['scheduleId'] = $_SESSION['user']['scheduleId'];
f('scheduleName');
// Get user schedules.
$departmentIdList = array_to_list($_SESSION['user']['department']); if ( !$departmentIdList ) $departmentIdList = '0';
$query = "
SELECT scheduleId
, department.departmentId
, session.sessionId
, scheduleName
, departmentCode
, departmentName
, YRTR
, sessionName
FROM `schedule`
JOIN `department` ON schedule.departmentId = department.departmentId
JOIN `session` ON schedule.sessionId = session.sessionId
WHERE schedule.departmentId IN ( ".$departmentIdList." )
ORDER BY departmentCode, YRTR
";
d_Var('scheduleResult',$query,'q');
$scheduleResult = query_do($query);
$scheduleCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleResult',$scheduleResult);
// Get sessions.
$query = "
SELECT sessionId
, YRTR
, sessionName
, sessionDescription
FROM `session`
WHERE sessionEnd > '".currentDate()."'
ORDER BY YRTR DESC
";
d_Var('sessionResult',$query,'q');
$sessionResult = query_do($query);
$sessionCount = $GLOBALS['_QUERY']['count'];
d_Var('$sessionResult',$sessionResult);
include('site/get_user_departments.phpinc'); // Get user departments.
// BEGIN form.
?>
<form name="form_name" action="<?=php_self()?>" method="post">
<input type="hidden" name="form" value="form_name">
<input type="hidden" name="uuid" value="<?=uuid()?>">
<?
if ( $scheduleCount ) {
// Select an existing schedule.
?>
Schedule: <select name="scheduleId">
<option value=""></option>
<?
query_seek($scheduleResult, 0);
while ($scheduleInfo = query_row($scheduleResult)) {
?>
<option value="<?=$scheduleInfo['scheduleId']?>"><?=$scheduleInfo['departmentCode']?> <?=$scheduleInfo['sessionName']?> (<?=$scheduleInfo['YRTR']?>)</option>
<?
}
?>
</select>
<br>
<input type="submit" name="task" value="Select schedule">
<br>
<?
}
// Request sessionId and departmentId for a new schedule.
?>
<? if ( isset($formError['sessionId']) ) { ?>
<span class="error"><?=$formError['sessionId']?></span><br>
<? } ?>
Session: <select name="sessionId">
<option value=""></option>
<?
if ( $sessionCount ) {
query_seek($sessionResult, 0);
while ($sessionInfo = query_row($sessionResult)) {
?>
<option value="<?=$sessionInfo['sessionId']?>"<? if ( $f['sessionId'] == $sessionInfo['sessionId'] ) { ?> selected<? } ?>><?=$sessionInfo['sessionName']?> (<?=$sessionInfo['YRTR']?>)</option>
<?
}
}
?>
</select>
<? if ( isset($formError['departmentId']) ) { ?>
<br><span class="error"><?=$formError['departmentId']?></span>
<? } ?>
<br>
Department: <select name="departmentId">
<option value=""></option>
<?
if ( $departmentCount ) {
query_seek($departmentResult, 0);
while ($departmentInfo = query_row($departmentResult)) {
?>
<option value="<?=$departmentInfo['departmentId']?>"<? if ( $f['departmentId'] == $departmentInfo['departmentId'] ) { ?> selected<? } ?>><?=$departmentInfo['departmentCode']?> - <?=$departmentInfo['departmentName']?></option>
<?
}
}
?>
</select>
<? if ( isset($formError['scheduleName']) ) { ?>
<br><span class="error"><?=$formError['scheduleName']?></span>
<? } ?>
<br>
<input type="text" name="scheduleName" value="<?=htmlSafe($f['scheduleName'])?>">
<br>
<input type="submit" name="task" value="Create new schedule">
</form>
<?
sectionFooter();
t_End(); // End TRACKing newSchedule.phpinc.
?>