| 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 : /nginx/html/Scheduler/Schedule/ScheduleClass/ |
Upload File : |
<?
// Schedule/ScheduleClass/ScheduleClassForm.phpinc
// Create the ScheduleClass form.
#$DEBUG_ScheduleClassForm = true;
if (!isset($DEBUG_ScheduleClassForm)) { $DEBUG_ScheduleClassForm = d_O(); }
#$DEBUG_ScheduleClassForm = false;
t_Begin($DEBUG_ScheduleClassForm); // Begin TRACKing ScheduleClassForm.phpinc.
d_V();
d_Var("\$_SESSION",$_SESSION);
// Initialize form variables.
if ( !f('campusId') ) $f['campusId'] = -1;
if ( !f('buildingId') ) $f['buildingId'] = -1;
f('courseId');
if ( !f('departmentId') ) { $f['departmentId'] = $_SESSION['user']['departmentId']; };
f('instructorId');
if ( !f('roomId') ) $f['roomId'] = -1;
f('scheduleclassId'); if ( !$f['scheduleclassId'] ) $f['scheduleclassId'] = 0;
f('scheduleclassSection');
f('scheduleclassStartDate');
f('scheduleclassEndDate');
f('scheduleId');
f('userFullname');
if ( !f('weekdayIds') || !is_array($f['weekdayIds']) ) $f['weekdayIds'] = array();
d_V();
/** / // Modified 2-23-03-21 jfm
// Get department courses.
$query = "
SELECT courseId
, departmentCode
, courseNumber
, courseTitle
, courseCredits
, courseCreditsMax
FROM `course`
JOIN department ON department.departmentId = course.departmentId
WHERE courseInactive = 0
AND department.departmentId = ".$f['departmentId']."
ORDER BY departmentCode, courseNumber, courseId DESC
";
/**/
$query = "
SELECT courseId
, departmentCode
, courseNumber
, courseTitle
, courseCredits
, courseCreditsMax
FROM `course`
JOIN department ON department.departmentId = course.departmentId
WHERE courseInactive = 0
AND department.departmentId = 15
AND courseId = (
SELECT max(courseId)
FROM course as c
WHERE c.departmentId = course.departmentId
AND c.courseNumber = course.courseNumber
)
ORDER BY departmentCode, courseNumber
";
d_Var('courseIdResult',$query,'q');
$courseIdResult = query_do($query);
$courseIdCount = $_QUERY['count'];
d_Var('$courseIdResult',$courseIdResult,'');
// Get weekdays.
require('site/get_weekdays.phpinc');
d_Var('$weekdayResult',$weekdayResult,'');
// Get Instructors:
$query = "
SELECT user.userId
, CONCAT(COALESCE(userNickname,userFirstname), ' '
, IF ( userMiddlename IS NOT NULL, CONCAT(userMiddlename,' '), '')
, userLastname) AS userFullname
FROM `user_department`
JOIN `user` ON user.userId = user_department.userId
WHERE departmentId = ".$f['departmentId']."
AND userInactive = 0
ORDER BY userFullname
";
d_Var('user_departmentResult',$query,'q');
$user_departmentResult = query_do($query);
$user_departmentCount = $GLOBALS['_QUERY']['count'];
d_Var('$user_departmentResult',$user_departmentResult);
d_V('scheduleclassId','');
$scm = array(); // Holds scheduleclassmeetings.
if ( $f['scheduleclassId'] ) { // Is this a previously scheduled class?
// Yes. This is a scheduleclass edit.
// Get scheduleclass info.
$query = "
SELECT scheduleclassId
, scheduleId
, YRTR
, scheduleclassQId
, courseId
, scheduleclassEnr
, scheduleclassMax
, scheduleclassStartDate
, scheduleclassEndDate
, courseinsttypeId
, scheduleclassOnline
FROM `scheduleclass`
WHERE scheduleclassId = ".$f['scheduleclassId']."
";
d_Var('scheduleclassInfo',$query,'q');
$scheduleclassInfo = query_info($query);
d_Var('$scheduleclassInfo',$scheduleclassInfo,'');
$f['scheduleclassStartDate'] = substr($scheduleclassInfo['scheduleclassStartDate'],0,10);
$f['scheduleclassEndDate'] = substr($scheduleclassInfo['scheduleclassEndDate'],0,10);
// Get scheduleclass course info.
$query = "
SELECT courseId
, departmentCode
, courseNumber
, courseTitle
, courseCredits
, courseCreditsMax
FROM `course`
JOIN department ON department.departmentId = course.departmentId
WHERE courseId = ".$scheduleclassInfo['courseId']."
";
d_Var('courseInfo',$query,'q');
$courseInfo = query_info($query);
d_Var('$courseInfo',$courseInfo,'');
// Get scheduleclasssections.
$query = "SELECT scheduleclassSection FROM `scheduleclasssection` WHERE scheduleclassId = ".$scheduleclassInfo['scheduleclassId']." ORDER BY scheduleclassSection";
d_Var('scheduleclasssectionResult',$query,'q');
$scheduleclasssectionResult = query_do($query);
$scheduleclasssectionCount = $GLOBALS['_QUERY']['count'];
$f['scheduleclassSection'] = query_to_list($scheduleclasssectionResult);
$scheduleclassInfo['scheduleclassId'] = $f['scheduleclassId'];
require('Schedule/GetScheduleClassMeeting.phpinc');
d_Var('$scheduleclassmeetingResult',$scheduleclassmeetingResult,'');
if ( $scheduleclassmeetingCount ) { // Are there any scheduled meetings?
query_seek($scheduleclassmeetingResult, 0);
while ($scheduleclassmeetingInfo = query_row($scheduleclassmeetingResult)) {
$scmId = $scheduleclassmeetingInfo['scheduleclassmeetingId'];
$scm[$scmId] = array();
$scm[$scmId]['scheduleclassmeetingStartDate'] = $scheduleclassmeetingInfo['scheduleclassmeetingStartDate'];
$scm[$scmId]['scheduleclassmeetingEndDate'] = $scheduleclassmeetingInfo['scheduleclassmeetingEndDate'];
$scm[$scmId]['scheduleclassmeetingBeginTime'] = $scheduleclassmeetingInfo['scheduleclassmeetingBeginTime'];
$scm[$scmId]['scheduleclassmeetingEndTime'] = $scheduleclassmeetingInfo['scheduleclassmeetingEndTime'];
$scm[$scmId]['scheduleclassmeetingOnCampus'] = $scheduleclassmeetingInfo['scheduleclassmeetingOnCampus'];
// Get scheduleclassmeetingweekdays.
$scm[$scmId]['Day'] = array();
$query = "
SELECT weekdayId
FROM `scheduleclassmeetingweekday`
WHERE scheduleclassmeetingId = ".$scmId."
ORDER BY weekdayId
";
d_Var('scheduleclassmeetingweekdayResult',$query,'q');
$scheduleclassmeetingweekdayResult = query_do($query);
$scheduleclassmeetingweekdayCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingweekdayResult',$scheduleclassmeetingweekdayResult);
if ( $scheduleclassmeetingweekdayCount ) {
query_seek($scheduleclassmeetingweekdayResult, 0);
while ($scheduleclassmeetingweekdayInfo = query_row($scheduleclassmeetingweekdayResult)) {
$scm[$scmId]['Day'][] = $scheduleclassmeetingweekdayInfo['weekdayId'];
}
}
// Get scheduleclassmeetingrooms.
$scm[$scmId]['Room'] = array();
$query = "
SELECT room.roomId
, building.buildingId
, campus.campusId
FROM `scheduleclassmeetingroom`
JOIN `room` ON room.roomId = scheduleclassmeetingroom.roomId
JOIN `building` ON building.buildingId = room.buildingId
JOIN `campus` ON campus.campusId = building.campusId
WHERE scheduleclassmeetingId = ".$scmId."
ORDER BY campusName, buildingCode, roomNumber
";
d_Var('scheduleclassmeetingroomResult',$query,'q');
$scheduleclassmeetingroomResult = query_do($query);
$scheduleclassmeetingroomCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetingroomResult',$scheduleclassmeetingroomResult);
if ( $scheduleclassmeetingroomCount ) {
query_seek($scheduleclassmeetingroomResult, 0);
while ($scheduleclassmeetingroomInfo = query_row($scheduleclassmeetingroomResult)) {
$scm[$scmId]['Room'][] = array('roomId'=>$scheduleclassmeetingroomInfo['roomId'],'buildingId'=>$scheduleclassmeetingroomInfo['buildingId'],'campusId'=>$scheduleclassmeetingroomInfo['campusId']);
}
}
// Get scheduleclassmeetinginstructors.
$scm[$scmId]['Instructor'] = array();
$query = "
SELECT userId
FROM `scheduleclassmeetinginstructor`
WHERE scheduleclassmeetingId = ".$scmId."
ORDER BY userId
";
d_Var('scheduleclassmeetinginstructorResult',$query,'q');
$scheduleclassmeetinginstructorResult = query_do($query);
$scheduleclassmeetinginstructorCount = $GLOBALS['_QUERY']['count'];
d_Var('$scheduleclassmeetinginstructorResult',$scheduleclassmeetinginstructorResult);
if ( $scheduleclassmeetinginstructorCount ) {
query_seek($scheduleclassmeetinginstructorResult, 0);
while ($scheduleclassmeetinginstructorInfo = query_row($scheduleclassmeetinginstructorResult)) {
$scm[$scmId]['Instructor'][] = $scheduleclassmeetinginstructorInfo['userId'];
}
}
}
} // Are there any scheduled meetings?
$closeTooltip = 'Close; Do not change the class on the schedule'; // Set the tooltip for the Close button.
} else { // Is this a previously scheduled class?
// No. This is a scheduleclass add.
// Initialize array.
$scm['add0'] = array();
$scm['add0']['Day'] = array();
$scm['add0']['Instructor'] = array();
$scm['add0']['Room'] = array();
$scm['add0']['scheduleclassmeetingBeginTime'] = '';
$scm['add0']['scheduleclassmeetingEndDate'] = '';
$scm['add0']['scheduleclassmeetingEndTime'] = '';
$scm['add0']['scheduleclassmeetingOnCampus'] = 1;
$scm['add0']['scheduleclassmeetingStartDate'] = '';
$closeTooltip = 'Close; Do not add the class to the schedule'; // Set the tooltip for the Close button.
} // Is this a previously scheduled class?
d_Var('$scm',$scm,'+');
?>
<div id="scheduleBox">
<div id="div_scd_error"></div>
<fieldset id="fldScheduleForm"><legend onmouseover="ttShow('<div class="actionback nowrap">Mouse-down / drag / drop to move.</div>')" onmouseout="ttHide();" class="drag_cursor">Schedule <span style="display: inline-block; background-image:url(<?=$_SESSION['ROOT']['http']?>/images/mousemove.png); width: 23px;"> </span> Class <? if ($f['scheduleclassId']) { ?>Edit<? } else { ?>Add<? } ?></legend>
<div id="divScheduleFormContainer">
<form name="Schedule_form" id="frmSchedule_form" action="<?=$_SESSION['ROOT']['http']?>/Schedule/" method="post">
<input type="hidden" name="form" value="Schedule_form">
<input type="hidden" name="uuid" value="<?=uuid()?>">
<input type="hidden" name="scheduleclassId" id="hid_scheduleclassId" value="<?=$f['scheduleclassId']?>">
<input class="small float_right upMargin" id="btnClose" type="button" value="Close" onClick="CheckChangeInSCD(event);" onMouseOver="ttShow('<?=$closeTooltip?>');" onMouseOut="ttHide();">
<div class="nowrap">
<label for="id_courseId">Class:
<?
if ( $f['scheduleclassId'] ) { // Is this a previously scheduled class?
// Yes. This is a scheduleclass edit.
?>
<input type="hidden" name="courseId" id="id_courseId" value="<?=$courseInfo['courseId']?>">
<b id="id_courseId_name"><?=$courseInfo['departmentCode']?><?=$courseInfo['courseNumber']?> <?=$courseInfo['courseTitle']?></b>
<?
} else { // Is this a previously scheduled class?
// No. This is a scheduleclass add.
?>
<select id="id_courseId" name="courseId">
<option value=""></option>
<?
if ( $courseIdCount ) {
#$previousCourse = ''; // modified 2023-03-21 jfm
query_seek($courseIdResult, 0);
while ($courseInfo = query_row($courseIdResult)) {
$thisCourse = $courseInfo['departmentCode'].$courseInfo['courseNumber'];
#if ( $thisCourse != $previousCourse ) {
?>
<option value="<?=$courseInfo['courseId']?>"><?=$thisCourse?> <?=$courseInfo['courseTitle']?></option>
<?
$previousCourse = $thisCourse;
#}
}
}
?>
</select>
<?
} // Is this a previously scheduled class?
?>
</label>
<? if ( $f['scheduleclassId'] ) { ?> <? } ?><label for="txt_scheduleclassSection">Section(s):
<?
?>
<input type="text" class="sectionNumbers" id="txt_scheduleclassSection" name="scheduleclassSection" value="<?=$f['scheduleclassSection']?>" onBlur="Validate(this);" onFocus="Validate_ShowError(this);">
</label>
<label for="id_scheduleclassOnline"><input type="checkbox" name="scheduleclassOnline" id="id_scheduleclassOnline" value="1" onclick="Validate_ScheduleClass();"<? if ( $f['scheduleclassId'] && $scheduleclassInfo['scheduleclassOnline'] ) { ?> checked<? } ?>><span>Online</span></label>
</div>
Class dates:
<input type="date" name="scheduleclassStartDate" id="id_scheduleclassStartDate" value="<?=$f['scheduleclassStartDate']?>" onBlur="Validate(this);" onFocus="Validate_ShowError(this);" max="">
-
<input type="date" name="scheduleclassEndDate" id="id_scheduleclassEndDate" value="<?=$f['scheduleclassEndDate']?>" onBlur="Validate(this);" onFocus="Validate_ShowError(this);" min="">
<?
button('Full','Class runs the full semester',"Date_Set_BothDates('id_scheduleclassStartDate','id_scheduleclassEndDate',SemesterFullStart,SemesterFullEnd);",'','small');
button('1st half','Class runs the first half of the semester',"Date_Set_BothDates('id_scheduleclassStartDate','id_scheduleclassEndDate',Semester1stStart,Semester1stEnd);",'','small');
button('2nd half','Class runs the second half of the semester',"Date_Set_BothDates('id_scheduleclassStartDate','id_scheduleclassEndDate',Semester2ndStart,Semester2ndEnd);",'','small');
button('▼','Copy class dates to all meetings',"CopyClassDatesToAllmeeting();",'','small','btnCopyDates'); // ► ◄ ■ ▲ ▼ ↑ ↓ → ←
?>
<br>
<fieldset id="fldMeetings" class="ClassMeetings"><legend>Meetings: <? button('+','Add another meeting',"AddClassMeeting(".$f['scheduleclassId'].");",'','small','btnAddMeeting'); ?></legend>
<?
// Create the scheduleclassmeetingIds list and dislay the meetings.
$scheduleclassmeetingIds = '';
foreach ( $scm as $scmId => $thisMeeting ) {
$scheduleclassmeetingIds = listAppend($scheduleclassmeetingIds,$scmId);
?>
<div class="divClassMeeting" id="id_classmeeting_<?=$scmId?>">
<?
$DEBUG_ScheduleClassForm_Meeting = d_O();
require('Schedule/ScheduleClass/ScheduleClassForm_Meeting.phpinc');
?>
</div><!-- id_classmeeting_<?=$scmId?> -->
<?
}
#d_Var('$scheduleclassmeetingIds',$scheduleclassmeetingIds,'d');
?>
</fieldset>
<?
?>
<input type="hidden" name="scheduleId" value="<?=$_SESSION['user']['scheduleId']?>">
<input type="hidden" name="scheduleclassmeetingIds" id="hid_scheduleclassmeetingIds" value="<?=$scheduleclassmeetingIds?>">
<br>
<?
if ( $f['scheduleclassId'] ) { // Is this a previously scheduled class?
// Yes. This is a scheduleclass edit.
button('Update class','Update the class on the schedule',"VerifySCD(event);",'','','btn_UpdateClass', false);
button('Remove class','Remove the class from the schedule',"ScheduleClass_RemoveClassVerify();",'','','btn_RemoveClass');
?>
<div class="p" id="div_RemoveClassVerify">
<?
?>
Are you sure you want to remove <b><?=$courseInfo['departmentCode']?><?=$courseInfo['courseNumber']?> <?=$courseInfo['courseTitle']?></b> section<? if ( listLen($f['scheduleclassSection']) > 1 ) { ?>s<? } ?> <?=listAnd($f['scheduleclassSection'])?> from the schedule?
<div class="center">
<?
button('Yes','Remove the class from the schedule',"ScheduleClass_RemoveClassVerify(true);",'','');
button('No','Do not remove the class from the schedule',"ScheduleClass_RemoveClassVerify(false);",'','');
?>
</div>
</div>
<?
} else { // Is this a previously scheduled class?
// No. This is a scheduleclass add.
button('Add class','Add the class to the schedule',"VerifySCD(event);",'','small','btnAddClass',false); #,false SaveAutoscrollPosition(); formSubmit(this,'Add class');
} // Is this a previously scheduled class?
?>
</form>
</div><!-- divScheduleFormContainer -->
</fieldset>
</div>
<div style="display:none;">Load OK</div>
<?
t_End(); // End TRACKing ScheduleClassForm.phpinc.
?>