| 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/Admin/DARS.cloak/ProjectedEnrollment/ |
Upload File : |
<?
// Admin/DARS/ProjectedEnrollment/ProjectedEnrollment.phpinc
$sectionTitle = 'Projected Enrollment for '.$_SESSION['YRTR']['User_NAME'].'.';
$IncludeSummerSessions = false;
require('common/sectionHeader.phpinc');
$headerLineCount = 12;
if ( $sessionResultCount ) { // Were there sessions?
$averageCreditsCount = 0;
$averageCreditsTotal = 0;
$classListArray = array();
$classListFullArray = array();
$coreStudentCount = 0;
$coreCreditsNeededTotal = 0;
$coreCreditsCount = 0;
$coreCreditsTotal = 0;
$electiveCreditsCount = 0;
$electiveCreditsTotal = 0;
$electiveStudentCount = 0;
$ElectiveCreditsNeededTotal = 0;
$totalProjectedCredits = 0;
$totalProjectedCount = 0;
$totalProjectedCreditsFull = 0;
$totalProjectedCountFull = 0;
$year = substr($_SESSION['YRTR']['User'],0,4);
$semester = substr($_SESSION['YRTR']['User'],-1);
switch ( $semester ) {
case '3':
$year--;
$semesterDARS = $year.'5';
break;
case '5':
$semesterDARS = $year.'3';
break;
default:
$f_messageError = 'Currently this only works for Fall or Spring semesters.';
require('common/programmingError.phpinc');
break;
}
#d_Var('$semesterDARS',$semesterDARS,'d');
$query = "
SELECT sessionId
FROM `session`
WHERE YRTR = '".mysql_safe($semesterDARS)."'
";
$sessionResult = query_do($query);
$sessionResultCount = $_SESSION['qry']['count'];
#d_Var('$sessionResult',$sessionResult,'d');
if ($sessionResultCount == 1) {
mysql_data_seek($sessionResult, 0);
$sessionRow = mysql_fetch_assoc($sessionResult);
$f_sessionIdDARS = $sessionRow['sessionId'];
} else {
$f_messageError = 'Session not found for '.$semesterDARS.'.';
require('common/programmingError.phpinc');
}
// Get the credential codes.
$query = "
SELECT darscredentialcodeId,
darscredentialcodeCode
FROM `darscredentialcode`
ORDER BY darscredentialcodeCode
";
#d_Var('darscredentialcodeResult',$query,'dq');
$darscredentialcodeResult = query_do($query);
$darscredentialcodeResultCount = $_SESSION['qry']['count'];
#d_Var('$darscredentialcodeResult',$darscredentialcodeResult,'d');
// BEGIN Get the checked darscredentialcodeIds.
$f_darscredentialcodeIdCount = 0; // Count of checked darscredentialcodeId checkboxes.
$f_darscredentialcodeId = array(); // Value of each darscredentialcodeId checkbox.
$f_darscredentialcodeIdList = ''; // List of all darscredentialcodeId checkboxs.
$f_darscredentialcodeIdListChecked = ''; // List of checked darscredentialcodeId checkboxs.
mysql_data_seek($darscredentialcodeResult, 0);
while ($darscredentialcodeRow = mysql_fetch_assoc($darscredentialcodeResult)) {
$f_darscredentialcodeId[$darscredentialcodeRow['darscredentialcodeId']] = formValue('darscredentialcodeId_'.$darscredentialcodeRow['darscredentialcodeId']);
$f_darscredentialcodeIdList = listAppend($f_darscredentialcodeIdList,$darscredentialcodeRow['darscredentialcodeId']);
if ($f_darscredentialcodeId[$darscredentialcodeRow['darscredentialcodeId']]) {
$f_darscredentialcodeIdCount++;
$f_darscredentialcodeIdListChecked = listAppend($f_darscredentialcodeIdListChecked,$darscredentialcodeRow['darscredentialcodeId']);
}
}
#d_Var('$f_darscredentialcodeIdCount',$f_darscredentialcodeIdCount,'d');
#d_Var('$f_darscredentialcodeId',$f_darscredentialcodeId,'d');
#d_Var('$f_darscredentialcodeIdList',$f_darscredentialcodeIdList,'d');
#d_Var('$f_darscredentialcodeIdListChecked',$f_darscredentialcodeIdListChecked,'d');
#$f_darscredentialcodeId[3] = 1;
#$f_darscredentialcodeIdCount = 1;
#printVar('$f_darscredentialcodeId',$f_darscredentialcodeId);
// If no darscredentialcodeId checkboxs are checked - check them all.
if ( !$f_darscredentialcodeIdCount ) {
$f_darscredentialcodeIdListChecked = $f_darscredentialcodeIdList;
foreach ( $f_darscredentialcodeId as $key => $darscredentialcodeId ) {
$f_darscredentialcodeId[$key] = true;
}
}
// END Get the checked darscredentialcodeIds.
// Get the darscredentialId list.
$query = "
SELECT darscredentialId
FROM `darscredential`
WHERE darscredentialcodeId IN (".$f_darscredentialcodeIdList.")
ORDER BY darscredentialId
";
#d_Var('darscredentialResult',$query,'dq');
$darscredentialResult = query_do($query);
$darscredentialResultCount = $_SESSION['qry']['count'];
#d_Var('$darscredentialResult',$darscredentialResult,'d');
if ( !$darscredentialResultCount ) {
$darscredentialRow = '';
include('common/pageHeader.phpinc');
$f_error = 'error_message_goes_here.<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.__FILE__.':'.__LINE__.'</span>';
include('common/displayErrorsAndMessages.phpinc');
include('common/pageFooter.phpinc');
}
$darscredentialIdList = query_to_list($darscredentialResult);
#d_Var('$darscredentialIdList',$darscredentialIdList,'d');
// Get the DARS info.
$query = "
SELECT DISTINCT
dars.darsId,
dars.darsStudentId,
dars.darsStudentFirstName,
dars.darsStudentLastName,
dars.darsCredentialTitle,
dars.darsCredentialCreditsNeeds
FROM `dars`
INNER JOIN `darscredential` ON dars.darsCredentialCode = darscredential.darsCredentialCode
WHERE dars.sessionId = ".$f_sessionIdDARS."
AND darscredentialId IN (".$darscredentialIdList.")
ORDER BY darsStudentFirstName, darsStudentLastName, darsStudentId
";
#$f_darscredentialcodeIdListChecked
# AND darsId = 97
#d_Var('darsResult',$query,'dq');
$darsResult = query_do($query);
$darsResultCount = $_SESSION['qry']['count'];
#d_Var('$darsResult',$darsResult,'d');
#if ( $DEBUG_CalculateYRTRcredits ) require('common/pageFooter.phpinc');
if ( $darsResultCount ) { // Were dars found?
divExpand('Projected Classes by Student and Credential',false);
require('Admin/DARS/ProjectedEnrollment/ShowCLassesNeeded.phpinc'); // Show classes needed.
divClose();
} // Were dars found?
?>
<?
divExpand('Projected "Offered" Class Students',false);
?>
<br class="pagebreak">
<table class="blackborder center">
<tr><th colspan="3">List of students for classes "Offered" <?=$_SESSION['YRTR']['User_NAME']?>.</th></tr>
<tr><th>Class</th><th>#</th><th>Student list</th></tr>
<?
ksort($StudentsThatNeedClass);
$ClassesOffered = array();
$classIndex = 0;
foreach ( $StudentsThatNeedClass as $classNumber => $students ) {
if ( $classNumber ) { // Somehow we are getting a blank $classNumber.
$ClassesOffered[] = $classNumber;
$eo = ($classIndex+1) - ((int)(($classIndex+1)/2) * 2);
if ( $eo ) { $eo = 'row_odd'; } else { $eo = 'row_even'; }
?>
<tr><th class="right <?=$eo?>"><?=$classNumber?></th><td class="number <?=$eo?>"><?=count($students)?></td><td class="<?=$eo?>"><?
$prefix = '';
ksort($students);
foreach ( $students as $student ) {
?><?=$prefix?><span class="nowrap"><?=$student?></span><?
$prefix = ', ';
}
?></td></tr>
<?
$classIndex++;
}
}
?>
</table>
<?
divClose();
?>
<?
divExpand('Projected "Not Offered" Class Students',false);
#d_Var('$ClassesOffered',$ClassesOffered,'d');
?>
<br class="pagebreak">
<table class="blackborder center">
<tr><th colspan="3">List of students for classes "Not Offered" <?=$_SESSION['YRTR']['User_NAME']?>.</th></tr>
<tr><th>Class</th><th>#</th><th>Student list</th></tr>
<?
ksort($StudentsThatNeedIfOfferedClass);
$classIndex = 0;
foreach ( $StudentsThatNeedIfOfferedClass as $classNumber => $students ) {
if ( $classNumber && !in_array($classNumber,$ClassesOffered) ) { // Somehow we are getting a blank $classNumber.
$eo = ($classIndex+1) - ((int)(($classIndex+1)/2) * 2);
if ( $eo ) { $eo = 'row_odd'; } else { $eo = 'row_even'; }
?>
<tr><th class="right <?=$eo?>"><?=$classNumber?></th><td class="number <?=$eo?>"><?=count($students)?></td><td class="<?=$eo?>"><?
$prefix = '';
ksort($students);
foreach ( $students as $student ) {
?><?=$prefix?><span class="nowrap"><?=$student?></span><?
$prefix = ', ';
}
?></td></tr>
<?
$classIndex++;
}
}
?>
</table>
<?
divClose();
?>
<style type="text/css">
input.newEnr { border:1px solid #00cc00; color:#00cc00; }
input.number { font-family: "Courier New", Courier, monospace; font-size:1em; font-weight:bold; margin:0; padding-top:1px; padding-bottom:1px; text-align:right; width:2.5em; }
</style>
<?
#d_Var('$StudentsThatNeedIfOfferedClass',$StudentsThatNeedIfOfferedClass,'d');
divExpand('Projected Enrollment',true);
?>
<br class="pagebreak">
<table class="blackborder center">
<tr>
<th colspan="5"><?=$_SESSION['YRTR']['User_NAME']?><br>Projected Enrollment</th>
</tr>
<tr><th></th><th class="">Offered</th><th class="">NotOffered</th><th class="" style="color:#00CC00;">New</th><th class="" style="color:#0000CC;">Total</th></tr>
<tr><th>Class</th><th class="right"> Enr</th><th class="right"> Enr</th><th class="right" style="color:#00CC00;"> Enr</th><th class="right" style="color:#0000CC;"> Enr</th></tr>
<?
ksort($classListFullArray);
$classIndex = 0;
foreach ( $classListFullArray as $class => $IfOffEnr ) {
if ( isset($classListArray[$class]) ) {
$OffEnr = $classListArray[$class];
$TotalEnr = $IfOffEnr;
$IfOffEnr = '';
} else {
$OffEnr = '';
$TotalEnr = $OffEnr;
}
if ( $IfOffEnr == $OffEnr ) $IfOffEnr = '';
$eo = ($classIndex+1) - ((int)(($classIndex+1)/2) * 2);
if ( $eo ) { $eo = 'row_odd'; } else { $eo = 'row_even'; }
?>
<tr>
<td class="<?=$eo?>"><?=$class?></td>
<td id="offered_<?=$class?>" class="number <?=$eo?>"><?=$OffEnr?></td>
<td id="ifoffered_<?=$class?>" class="number <?=$eo?>"><?=$IfOffEnr?></td>
<td><input type="number" class="number newEnr <?=$eo?>" id="inp_<?=$class?>" onInput="AddEnrollment(this);"></td>
<td class="number <?=$eo?>" style="color:#0000CC;" id="total_<?=$class?>"><?=$TotalEnr?></td>
</tr>
<?
$classIndex++;
}
?>
</table>
<?
divClose();
} else { // Were there sessions?
// There were no sessions.
?>
There are no sessions. This is a programming error.
Please <a href="mailto:<?=$_SESSION['websiteAdministratorEmail']?>">email</a> a copy of this page to <?=$_SESSION['websiteAdministratorName']?> <<?=$_SESSION['websiteAdministratorEmail']?>>.<br>
<?
} // Were there sessions?
require('common/sectionFooter.phpinc');
d_Var("\$_SESSION['YRTR']",$_SESSION['YRTR'],'');
// divExpand($expandText, $content, $state, $class=)
// Create expand and collapse divs.
// NOTE: the expand div is not closed, you must output a '</div>' tag after call to divExpand().
// $expandText = text to show for the expland/collapse.
// $state = true = expanded, false = collapsed (default).
// $class = class of the expandText.
function divExpand($expandText, $state=false, $class='') {
if ( !isset($GLOBALS['divCount']) ) $GLOBALS['divCount'] = 0;
$GLOBALS['divCount']++; // Increment the div id counter.
if ( $state ) { $divCclass = 'hidden'; $divEclass = ''; } else { $divCclass = ''; $divEclass = 'hidden'; }
if ( $class ) { $divCclass .= ' '.$class; $divEclass .= ' '.$class; }
$divExpand = '<div id="SH_'.$GLOBALS['divCount'].'_C" class="'.$divCclass.'">'.'<a class="hideFromPrint" href="javascript: divShow(\'SH_'.$GLOBALS['divCount'].'_E\'); divHide(\'SH_'.$GLOBALS['divCount'].'_C\');">'.$expandText.' +</span></a></div>'."\n";
$divExpand .= '<div id="SH_'.$GLOBALS['divCount'].'_E" class="'.$divEclass.'">'.'<a class="hideFromPrint" href="javascript: divShow(\'SH_'.$GLOBALS['divCount'].'_C\'); divHide(\'SH_'.$GLOBALS['divCount'].'_E\');">'.$expandText.' -</span></a><br>'."\n";
echo $divExpand;
}
function divClose() {
echo "\n</div>\n";
}
debugTrackEnd();
require('common/pageFooter.phpinc');
?>