| 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/Class/ |
Upload File : |
<?
// Class/Gradebook.phpinc
debugTrackBegin();
$skipAuthentication = false;
include('Login/authenticate.phpinc');
if (!isset($courseNumber)) {
$courseNumber = formValue('courseNumber');
include('Course/courseInfo.phpinc');
}
if ( !isset($_GET['PostGrades']) ) { $f['PostGrades'] = false; } else { $f['PostGrades'] = true; }
#setDebugOff();
#if (dc()) echo "<b>".__FILE__."</b><br>\n";
$headTitle = '_CST_ - '.$f_courseNumber.' Gradebook';
$pageTitle = '_CST_<br>'.$f_courseNumber.' Gradebook';
#$css = listAppend($css,'viewport');
//$js .= ',div,openCenteredWindow,select,updateHTMLelement';
//$onresize = 'changeView();';
#$displayHeader = false;
//include('common/pageHeader.phpinc');
//$headTitle = '_CST_ - '.$CDN[0].$CDN[1].' '.$courseTitle.' - Gradebook';
//$pageTitle = $CDN[0].$CDN[1].' '.$courseTitle.'<br>Gradebook';
$pageMenu = 'Course/courseMenu.phpinc';
$js = listAppend($js,'div,openCenteredWindow,select,updateHTMLelement,Gradebook/Gradebook.js');
$onresize = 'changeView();';
include('common/pageHeader.phpinc');
?><!-- Class/Gradebook.phpinc --><?
// Get the classIds.
$f_classId = formValue('classId');
// Proocess class section filter.
if ($f_form == 'form_classSectionFilter') {
if ($f_subtask == 'Filter') {
$f_classId = '';
$f_classSection = formValue('classSection');
if ($f_classSection) {
foreach ($f_classSection as $thisSection) {
$f_classId = listAppend($f_classId,$thisSection);
}
}
} else {
$f_classId = '';
}
}
#d_Var('$f_classId',$f_classId,'',false,true);
#printVar('$courseNumber',$courseNumber);
if (!$f_classId) {
// Get all classIds
if ( strpos($f_courseNumber,'CST') !== false ) { $courseNumberOther = str_replace('CST','CST',$courseNumber); } else { $courseNumberOther = str_replace('MMDT','CST',$courseNumber); }
$query = "
SELECT class.*
, courseNumber
FROM course
INNER JOIN class ON course.courseId = class.courseId
WHERE ( courseNumber = '".$courseNumber."' OR courseNumber = '".$courseNumberOther."' )
AND class.YRTR = ".$_SESSION['YRTR']['User']."
ORDER BY courseNumber, class.classSection
";
} else {
#printVar('$query',$query);
// Get the classIds
$query = "
SELECT class.*
, courseNumber
FROM class
JOIN course ON course.courseId = class.courseId
WHERE class.classId IN ( ".$f_classId." )
ORDER BY courseNumber, class.classSection
";
}
#printVar('$query',$query);
$classResult = query_do($query);
#printVar('$classResult',$classResult);
/** /
if ( $_SERVER['REMOTE_ADDR'] == '50.82.158.167' ) {
printVar('$query',$query,'q');
printVar('$classResult',$classResult);
}
/**/
$classCount = $_SESSION['qry']['count'];
$TitleOfCourse = array();
if ($classCount) {
$f_classId = query_to_list($classResult,'classId');
$f_classSection = query_to_list($classResult,'classSection');
$f_RCclassId = query_to_list($classResult,'RCclassId');
mysqli_data_seek($classResult, 0);
while ($classRow = mysqli_fetch_assoc($classResult)) {
$TitleOfCourse[$classRow['classId']] = $classRow['courseNumber'];
}
} else {
$f_classId = '';
}
/** /
if ( $_SERVER['REMOTE_ADDR'] == '50.82.158.167' ) {
printVar('$f_classId',$f_classId);
}
/**/
// Create $f_classIdList for the filter.
if ( strpos($f_courseNumber,'CST') !== false ) { $courseNumberOther = str_replace('CST','CST',$courseNumber); } else { $courseNumberOther = str_replace('MMDT','CST',$courseNumber); }
// Get all classIds
$query = "
SELECT class.classid
, class.classSection
, courseNumber
, CONCAT(courseNumber,'-',class.classSection) as CS
FROM course
INNER JOIN class ON course.courseId = class.courseId
WHERE ( courseNumber = '".$courseNumber."' OR courseNumber = '".$courseNumberOther."' )
AND class.YRTR = ".$_SESSION['YRTR']['User']."
ORDER BY courseNumber, class.classSection
";
$classIdListResult = query_do($query);
$classIdListCount = $_SESSION['qry']['count'];
#d_Var('$classIdListResult',$classIdListResult,'',false,true);
$f_classIdList = query_to_list($classIdListResult,'classid');
$f_classSectionList = query_to_list($classIdListResult,'CS');
#$f_classIdList = $f_classId;
if ($classCount) {
// Display Gradebook, Profiles, and Email.
#printVar('$classCount',$classCount);
#printQuery('$classResult',$classResult);
$f_classSectionDisplay = ListAnd($f_classSectionList);
$sectionTitle = $f_classSectionDisplay.' section filter';
include('common/sectionHeader.phpinc');
$action = $_SERVER['PHP_SELF'];
if ($_SERVER['QUERY_STRING'] != '') $action .= '?'.$_SERVER['QUERY_STRING'];
include('Class/SectionFilter.phpinc');
include('common/sectionFooter.phpinc');
include('Gradebook/Gradebook.phpinc');
}
#setDebugOn();
debugTrackEnd();
include('common/pageFooter.phpinc');
?>