| 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/Scheduler/Schedule/ScheduleClass/ |
Upload File : |
<?
// Schedule/ScheduleClassForm_Meeting_Instructor.phpinc
// Display instructor choices.
t_Begin(d_O()); // Begin TRACKing ScheduleClassForm_Meeting_Instructor.phpinc.
// Get instructor data.
$query = "
SELECT user.userId
, userFirstname
, userMiddlename
, userLastname
, userNickname
, CONCAT(IFNULL(userNickname,userFirstname),IF (ISNULL(userMiddlename),'',CONCAT(' ',userMiddlename)),IF (ISNULL(userLastname),'',CONCAT(' ',userLastname))) AS instructorName
FROM `user`
JOIN `user_department` ON user_department.userId = user.userId
WHERE userInactive = 0
AND user_department.departmentId = ".$f['departmentId']."
ORDER BY instructorName
";
#d_Var('instructorResult',$query,'dq');
$instructorResult = query_do($query);
$instructorCount = $GLOBALS['_QUERY']['count'];
#d_Var('$instructorResult',$instructorResult,'d');
if ( !$instructorCount ) programmingError('No instructors found.');
// Store instructorIds.
query_seek($instructorResult, 0);
$instructorIds = array();
while ($thisInstructor = query_row($instructorResult)) {
$instructorIds[] = $thisInstructor['userId'];
}
#d_Var('$instructorIds',$instructorIds,'d');
?>
<?
$instructorSelectedIds = array();
for ( $instructorIndex=0; $instructorIndex<count($instructorIds); $instructorIndex++ ) { // Loop thru $instructorIds.
$instructorId = $instructorIds[$instructorIndex];
if ( isset($thisMeeting['Instructor'][$instructorIndex]) ) {
$f['Instructor'] = $thisMeeting['Instructor'][$instructorIndex];
} else {
$f['Instructor'] = 0;
}
if ( !$f['Instructor'] && $instructorIndex > 0 ) {
$instructorClass = ' hidden';
} else {
$instructorClass = '';
}
#d_Var('$instructorId',$instructorId,'d');
?>
<div id="divInstructor<?=$_scmId?>_<?=$instructorIndex?>"<? if ( $instructorIndex > 0 ) { ?> class="<?=$instructorClass?>"<? } ?>>
<?
// Instructor
?>
<label for="selInstructor<?=$_scmId?>_<?=$instructorIndex?>"><b>Instructor:</b>
<select name="instructorId<?=$_scmId?>_<?=$instructorIndex?>" id="selInstructor<?=$_scmId?>_<?=$instructorIndex?>" onChange="SetupInstructorOptions(this); ShowInstructorButton(this); ClassMeeting_SetHeight('ScheduleClassForm_Meeting_Instructor:<?=__LINE__?>');">
<option></option>
<?
if ( $instructorCount ) {
// Load room options.
query_seek($instructorResult, 0);
while ($instructorInfo = query_row($instructorResult)) {
if ( !in_array($instructorInfo['userId'],$instructorSelectedIds) ) {
?>
<option value="<?=$instructorInfo['userId']?>"<? if ( $f['Instructor'] == $instructorInfo['userId'] ) { ?> selected<? } ?>><?=$instructorInfo['instructorName']?></option>
<?
}
}
}
?>
</select>
</label>
<?
if ( isset($instructorIds[$instructorIndex+1]) ) {
if ( $f['Instructor'] ) {
$btnShowInstructorClass = '';
$instructorSelectedIds[] = $f['Instructor'];
} else {
$btnShowInstructorClass = ' hidden';
}
$nextInstructorIndex = $instructorIndex+1;
button('+','Add another instructor', "ShowInstructorNext(this); ClassMeeting_SetHeight('ScheduleClassForm_Meeting_Instructor:".__LINE__."');", '', 'small'.$btnShowInstructorClass, 'btnShowInstructor'.$_scmId.'_'.$instructorIndex);
}
?>
</div><!-- divInstructor<?=$_scmId?>_<?=$instructorIndex?> -->
<?
} // Loop thru $instructorIds.
t_End(); // End TRACKing ScheduleClassForm_Meeting_Instructor.phpinc.
?>