| 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/Admin/Enrollment/CurrentEnrollment/ |
Upload File : |
<?
// Admin/DARS/ProjectedEnrollment/ShowCLassesNeeded.phpinc
// phpinc_filename_purpose.
$d_O = d_O(); #d_On(); // Uncomment to DEBUG.
d_Line(basename(__FILE__),'bi');
if ( !isset($IsAdvising) ) $IsAdvising = false;
if ( $IsAdvising ) {
$aDEBUG = '';
#$aDEBUG = 'd';
} else {
$aDEBUG = '';
}
d_Var('$aDEBUG',$aDEBUG,$aDEBUG.'bi');
// BEGIN Show classes needed.
$colSem = count($semesterCode) + 1;
$colTot = $colSem + 10;
if ( !isset($IsAdvising) ) $IsAdvising = false;
?>
<style type="text/css">
td, th {
empty-cells:show;
padding-left:2px;
padding-right:2px;
}
td.rbdr, th.rbdr {
border-right:1px solid #666666;
}
td.bbdr, th.bbdr {
border-bottom:1px solid #666666;
}
td.tbdr, th.tbdr {
border-top:1px solid #666666;
}
td.even {
background-color:white;
}
td.odd {
background-color:#E0E0E0;
}
</style>
<br class="pagebreak" />
<table class="blackborder center">
<?
if ( !$IsAdvising ) {
?>
<tr><th colspan="<?=$colTot?>">Projected classes for each student by credintial.</th></tr>
<?
}
$semesterStudentCount = array();
$semesterTotalCredits = array();
$StudentsThatNeedClass = array();
$StudentsThatNeedIfOfferedClass = array();
for ($i=0; $i<count($semesterCode); $i++) {
$semesterTotalCredits[$i] = 0;
$semesterStudentCount[$i] = 0;
}
mysql_data_seek($darsResult, 0);
$DARSindex = 0;
while ( $darsRow = mysql_fetch_assoc($darsResult) ) { // Loop through the DARS for each student.
#if ( $darsRow['darsStudentId'] == '12081039' ) d_On(); // DEBUG a student DARS.
if ( true || $darsRow['darsId'] == 1285 ) { // Normally true, used for DEBUGGING: or is this darsId == value?
if ( $aDEBUG ) {
$colspan = $colSem + 10;
?>
<tr style="vertical-align:bottom;">
<td colspan="<?=$colspan?>">darsRow <? d_Var('$darsRow',$darsRow,''); ?></td>
</tr>
<?
}
$eo = ($DARSindex+1) - ((int)(($DARSindex+1)/2) * 2);
if ( $eo ) { $eo = 'row_odd'; } else { $eo = 'row_even'; }
if ( $DARSindex == (int)($DARSindex/$headerLineCount) * $headerLineCount ) {
?>
<tr style="vertical-align:bottom;">
<th class="rbdr" colspan="4"></th>
<th class="center rbdr" colspan="<?=$colSem?>">Semester credits</th>
<th class="center rbdr" colspan="2">Needed</th>
<th class="center rbdr" colspan="2">Next</th>
<th class="left" colspan="2">Projected Credits and Class list</th>
</tr>
<tr style="vertical-align:bottom;">
<th>CC</th>
<th>StudentId</th>
<th class="right">First</th>
<th class="rbdr">Last</th>
<?
$yearCode4 = array();
for ( $i=0; $i<count($semesterCode); $i++ ) { // Loop thru semesterCodes.
#printVar('$semesterCode[$i] $yearCode[$i]',$semesterCode[$i].' '.$yearCode[$i]);
$yearCode4[$i] = $yearCode[$i];
if ( $yearCode4[$i] > 80 ) {
$yearCode4[$i] = '19'.$yearCode4[$i];
} else {
$yearCode4[$i] = '20'.$yearCode4[$i];
}
} // Loop thru semesterCodes.
for ( $i=0; $i<count($semesterCode); $i++ ) { // Loop thru semesterCodes.
?>
<th class="right"><?=$semesterCode[$i]?><?=$yearCode[$i]?></th>
<?
} // Loop thru semesterCodes.
?>
<th class="rbdr right">Avg</th>
<th class="center">Core</th>
<th class="rbdr center">Elec</th>
<th class="center">Core</th>
<th class="rbdr center">Elec</th>
<th class="center">Cr</th>
<th class="left">Class list</th>
</tr>
<?
}
// Get the darscredentialcodeCode and darscredentialcodeId.
$query = "
SELECT darscredentialcode.darscredentialcodeId,
darscredentialcode.darscredentialcodeCode
FROM `darscredentialcode`
INNER JOIN `darscredential` ON darscredentialcode.darscredentialcodeId = darscredential.darscredentialcodeId
WHERE darscredential.darscredentialTitle = '".$darsRow['darsCredentialTitle']."'
";
d_Var('darscredentialcodeResult',$query,'q');
$darscredentialcodeResult = query_do($query);
$darscredentialcodeResultCount = $_SESSION['qry']['count'];
d_Var('$darscredentialcodeResult',$darscredentialcodeResult,'');
if ( !$darscredentialcodeResultCount ) { // Did we not fine a credential?
$darscredentialcodeRow = '';
$f_error = '['.$darsRow['darsCredentialTitle'].'] does not have darscredentialcodeId.<span class="pv_fl"> '.basename(__FILE__).':'.__LINE__.'</span>';
require('common/displayErrorsAndMessages.phpinc');
require('common/pageFooter.phpinc');
} // Did we not fine a credential?
$darscredentialcodeRow = mysql_fetch_assoc($darscredentialcodeResult);
$f_darscredentialcodeId = $darscredentialcodeRow['darscredentialcodeId'];
$f_darscredentialcodeCode = $darscredentialcodeRow['darscredentialcodeCode'];
?>
<tr>
<td class="<?=$eo?>"><?=$f_darscredentialcodeCode?></td>
<td class="<?=$eo?> nowrap"><? if ( $IsAdvising && $darsResultCount > 1 ) { ?><a href="./?f_task=Search%20...&search=<?=$darsRow['darsStudentId']?>&darsId=<?=$darsRow['darsId']?>">Select <? } ?><?=$darsRow['darsStudentId']?><? if ( $IsAdvising && $darsResultCount > 1 ) { ?></a><? } ?></td>
<td class="right <?=$eo?>"><?=$darsRow['darsStudentFirstName']?></td>
<td class="rbdr <?=$eo?>"><?=$darsRow['darsStudentLastName']?></td>
<?
// Get the darssectionId for the 'Technical Core Courses' and 'Technical Electives' section.
$query = "
SELECT darssectionId
FROM `darssection`
WHERE darsId = ".$darsRow['darsId']."
AND ( darssectionTitle = 'Technical Core Courses' OR darssectionTitle = 'Technical Electives' )
";
# AND darssectionTitle = 'Technical Core Courses'
#printVar('$query',$query,'q');
$darssectionResult = query_do($query);
$darssectionResultCount = $_SESSION['qry']['count'];
d_Var('$darssectionResultCount',$darssectionResultCount);
d_Var('$darssectionResult',$darssectionResult);
if ( $darssectionResultCount ) { // Was there a core section?
// BEGIN Calculate and display the credits for each session.
$darssectionIdList = query_to_list($darssectionResult);
$totalCredits = 0;
$totalClasses = 0;
$semestersWithClasses = 0;
d_Var('$yearCode4',$yearCode4,'');
for ( $i=0; $i<count($semesterCode); $i++ ) { // Loop thru semesters.
$query = "
SELECT darssectionclassId,
darsId,
darssectionId,
darssectionclassSemester,
darssectionclassYear,
darssectionclassDept,
darssectionclassNumb,
darssectionclassCredits,
darssectionclassGrade,
darssectionclassLegend,
darssectionclassTitle,
darssectionclassComment
FROM `darssectionclass`
WHERE darssectionId IN (".$darssectionIdList.")
AND darssectionclassSemester = '".mysql_safe($semesterCode[$i])."'
AND ( darssectionclassYear = '".mysql_safe($yearCode[$i])."' OR darssectionclassYear = '".mysql_safe($yearCode4[$i])."' )
ORDER BY darssectionclassDept, darssectionclassNumb
";
d_Var('darssectionclassResult',$query,'q');
$darssectionclassResult = query_do($query);
$darssectionclassResultCount = $_SESSION['qry']['count'];
d_Var('$darssectionclassResultCount',$darssectionclassResultCount,'');
d_Var('$darssectionclassResult',$darssectionclassResult,'');
$semesterCredits = 0;
$semesterClasses = 0;
if ( $darssectionclassResultCount ) { // Were there classes this semester.
mysql_data_seek($darssectionclassResult, 0);
while ( $darssectionclassRow = mysql_fetch_assoc($darssectionclassResult) ) { // Loop thru semester classes.
$semesterCredits += $darssectionclassRow['darssectionclassCredits'];
if ($darssectionclassRow['darssectionclassCredits']) $semesterClasses++;
} // Loop thru semester classes.
} // Were there classes this semester.
if ($semesterCredits) {
$semesterTotalCredits[$i] += $semesterCredits;
$semesterStudentCount[$i]++;
}
$totalCredits += $semesterCredits;
$totalClasses += $semesterClasses;
if ($semesterCredits > 0 ) $semestersWithClasses++;
?>
<td class="right <?=$eo?>"><?=$semesterCredits?></td>
<?
} // Loop thru semesters.
// END Calculate and display the credits for each session.
if ( $semestersWithClasses && $semesterCredits ) { // Were there semesters with credits?
$averageCredits = max(6,intval($totalCredits / $semestersWithClasses + .99));
$averageClasses = max(intval($averageCredits/3+.5),intval($totalClasses / $semestersWithClasses + .99));
} else { // Were there semesters with credits?
$averageCredits = 15;
$averageClasses = intval($averageCredits/3+.5);
} // Were there semesters with credits?
} // Was there a core section?
// Calculate core credits needed.
$query = "
SELECT SUM(darssectionCreditsNeeds) AS coreCreditsNeeded
FROM darssection
WHERE darsId = ".$darsRow['darsId']."
AND darssection.darssectionTitle = 'Technical Core Courses'
";
d_Var('coreCreditsNeededResult',$query,$aDEBUG.'q');
$coreCreditsNeededResult = query_do($query);
d_Var('$coreCreditsNeededResult',$coreCreditsNeededResult,$aDEBUG.'');
$coreCreditsNeededResultCount = $_SESSION['qry']['count'];
if ( $coreCreditsNeededResultCount ) { // Are there core credits needed?
$coreCreditsNeededRow = mysql_fetch_assoc($coreCreditsNeededResult);
$coreCreditsNeeded = intval($coreCreditsNeededRow['coreCreditsNeeded']+.5);
if ($coreCreditsNeeded) $coreStudentCount++;
$coreCreditsNeededTotal+= $coreCreditsNeeded;
} else { // Are there core credits needed?
$coreCreditsNeeded = 0;
} // Are there core credits needed?
// Calculate elective credits needed.
$query = "
SELECT SUM(darssectionCreditsNeeds) AS electiveCreditsNeeded
FROM darssection
WHERE darsId = ".$darsRow['darsId']."
AND darssection.darssectionTitle = 'Technical Electives'
";
d_Var('ElectiveCreditsNeededResult',$query,$aDEBUG.'q');
$ElectiveCreditsNeededResult = query_do($query);
d_Var('$ElectiveCreditsNeededResult',$ElectiveCreditsNeededResult,$aDEBUG.'');
$ElectiveCreditsNeededCount = $_SESSION['qry']['count'];
if ( $ElectiveCreditsNeededCount ) {
$ElectiveCreditsNeededRow = mysql_fetch_assoc($ElectiveCreditsNeededResult);
$electiveCreditsNeeded = max(0,intval($ElectiveCreditsNeededRow['electiveCreditsNeeded']+.5));
if ($electiveCreditsNeeded) $electiveStudentCount++;
$ElectiveCreditsNeededTotal+= $electiveCreditsNeeded;
} else {
$electiveCreditsNeeded = 0;
}
$coreCredits = min( $averageCredits,$coreCreditsNeeded );
if ( $coreCredits ) $coreCreditsCount++;
$coreCreditsTotal += $coreCredits;
$electiveCredits = min(max(0,$averageCredits-$coreCredits),$electiveCreditsNeeded);
if ( $electiveCredits ) $electiveCreditsCount++;
$electiveCreditsTotal += $electiveCredits;
if ( $averageCredits ) {
$averageCreditsCount++;
$averageCreditsTotal += $averageCredits;
}
?>
<td class="rbdr right bold <?=$eo?>"><?=$averageCredits?></td>
<td class="right <?=$eo?>"><?=$coreCreditsNeeded?></td>
<td class="rbdr right <?=$eo?>"><?=$electiveCreditsNeeded?></td>
<?
// BEGIN Calculate classes to take.
$classList = '';
$classListFull = '';
#$classList = $f_darscredentialcodeId;
$nextCoreCredits = $coreCredits;
$nextElectiveCredits = $electiveCredits;
$nextTotalCredits = $nextCoreCredits + $nextElectiveCredits;
$nextTakenCredits = 0;
$nextCoreCreditsFull = $coreCredits;
$nextElectiveCreditsFull = $electiveCredits;
$nextTotalCreditsFull = $nextCoreCredits + $nextElectiveCredits;
$nextTakenCreditsFull = 0;
// Get the list of classes by ranking.
$query = "
SELECT darsclassrank.darsclassrankRank,
darsclass.darsclassOffered,
darsclass.darsclassDept,
darsclass.darsclassNumb,
darsclass.darsclassCredits
FROM `darsclassrank`
INNER JOIN darsclass ON darsclass.darsclassId = darsclassrank.darsclassId
WHERE darsclassrank.darscredentialcodeId = ".$f_darscredentialcodeId."
AND darsclass.darsclassCredits >= 0
AND darsclassrank.darsclassrankRank > 0
ORDER BY darsclassrank.darsclassrankRank, darsclass.darsclassDept, darsclass.darsclassNumb
";
# AND darsclass.darsclassOffered = 1
d_Var('darsclassrankResult',$query,'q');
$darsclassrankResult = query_do($query);
$darsclassrankResultCount = $_SESSION['qry']['count'];
d_Var('$darsclassrankResultCount',$darsclassrankResultCount,$aDEBUG.'');
d_Var('$darsclassrankResult',$darsclassrankResult,'+');
#printVar('$query',$query,'q');
#printVar('$darsclassrankResultCount',$darsclassrankResultCount);
if ( $darsclassrankResultCount ) { // Are there any classes?
#printVar('$darsclassrankResult',$darsclassrankResult);
mysql_data_seek($darsclassrankResult, 0);
d_Var('$nextTotalCredits',$nextTotalCredits,$aDEBUG.'');
while ( $nextTotalCredits > 0 && $darsclassrankRow = mysql_fetch_assoc($darsclassrankResult) ) { // Loop thru classes by ranking.
// See if this class is in the select from list.
if ( !( $darsclassrankRow['darsclassDept'] == 'CST' && $darsclassrankRow['darsclassNumb'] == '1000' ) ) { // Is this not CST1000?
$query = "
SELECT darssectionselectfromId
FROM `darssectionselectfrom`
WHERE darsId = ".$darsRow['darsId']."
AND darssectionselectfromDept = '".mysql_safe($darsclassrankRow['darsclassDept'])."'
AND ( darssectionselectfromNumb = '".mysql_safe($darsclassrankRow['darsclassNumb'])."'";
// Fix for CST1145 and MMDT1145.
if ( $darsclassrankRow['darsclassNumb'] == '1145' ) {
$query .= " OR darssectionselectfromNumb = '2146'";
}
if ( $darsclassrankRow['darsclassNumb'] == '2146' ) {
$query .= " OR darssectionselectfromNumb = '1145'";
}
$query .= " )
";
d_Var('darssectionselectfromResult',$query,$aDEBUG.'q');
if ( $DEBUG_CalculateYRTRcredits && $darsRow['darsId'] == 1285 ) printVar('$query',$query,'q');
$darssectionselectfromResult = query_do($query);
d_Var('$darssectionselectfromResult',$darssectionselectfromResult,$aDEBUG.'');
if ( $DEBUG_CalculateYRTRcredits && $darsRow['darsId'] == 1285 ) printVar('$darssectionselectfromResult',$darssectionselectfromResult,'f');
$darssectionselectfromResultCount = $_SESSION['qry']['count'];
if( $darssectionselectfromResultCount ) { // Did the student have classes to select from?
/* * /
if ($darsRow['darsStudentLastName'] == 'Muilenburg') {
printVar("\$darsclassrankRow['darsclassDept']",$darsclassrankRow['darsclassDept']);
printVar("\$darsclassrankRow['darsclassNumb']",$darsclassrankRow['darsclassNumb']);
printVar("\$darsclassrankRow['darsclassCredits']",$darsclassrankRow['darsclassCredits']);
printVar('$classListFull',$classListFull);
}
/* */
$classListFull = listAppend($classListFull,$darsclassrankRow['darsclassDept'].$darsclassrankRow['darsclassNumb']);
$nextTakenCreditsFull += $darsclassrankRow['darsclassCredits'];
/* * /
if ($darsRow['darsStudentLastName'] == 'Muilenburg') {
printVar('$classListFull',$classListFull);
printVar('$nextTakenCreditsFull',$nextTakenCreditsFull);
echo "<br>\n";
}
/* */
$nextTotalCreditsFull -= $darsclassrankRow['darsclassCredits'];
// Add the student to the StudentsThatNeedClass.
$classNumber = $darsclassrankRow['darsclassDept'].$darsclassrankRow['darsclassNumb'];
if ( !isset($StudentsThatNeedIfOfferedClass[$classNumber]) ) $StudentsThatNeedIfOfferedClass[$classNumber] = array();
$studentNameId = $darsRow['darsStudentFirstName'].' '.$darsRow['darsStudentLastName'].' '.$darsRow['darsStudentId'];
if ( !in_array($studentNameId,$StudentsThatNeedIfOfferedClass[$classNumber]) ) {
$StudentsThatNeedIfOfferedClass[$classNumber][] = $studentNameId;
if ( isset($classListFullArray[$classNumber]) ) {
$classListFullArray[$classNumber]++;
} else {
$classListFullArray[$classNumber] = 1;
}
}
// If Advising, check schedule to see if a class is offered.
@d_Var('$IsAdvising',$IsAdvising,'');
if ( $IsAdvising ) { // Are we advisings?
#d_Var('$darsclassrankRow',$darsclassrankRow,'');
/** /
$darsclassrankRow['darsclassDept'] == 'CST'
$darsclassrankRow['darsclassNumb'] == 1794
/**/
$query = "
SELECT YRTR,
COU_ID,
SUBJ,
NBR,
SECT,
TITLE,
CRHR,
CRMAX,
INSTR_TYPE,
ENR,
EMAX,
GRADE_METH,
COU_START,
COU_END,
campus,
IsDropped
FROM `pclass`
WHERE YRTR = '".mysql_safe($_SESSION['YRTR']['User'])."'
AND SUBJ = '".mysql_safe($darsclassrankRow['darsclassDept'])."'
AND NBR = '".mysql_safe($darsclassrankRow['darsclassNumb'])."'
AND IsDropped = 0
ORDER BY SUBJ, NBR, SECT
";
d_Var('pclassResult',$query,'q');
$pclassResult = query_do($query);
$pclassResultCount = $_SESSION['qry']['count'];
d_Var('$pclassResult',$pclassResult,'');
/** /
#if ($pclassResultCount != 1) {
if (!$pclassResultCount) {
$pclassRow = false;
$thisFile=__FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$f_error = 'error_message_goes_here from query: "<span class="d_s_q">'.$query.'</span>".<span class="d_s_fl"> '.basename(__FILE__).':'.__LINE__.'</span><span class="d_s_fp"> '.basename(__FILE__).':'.__LINE__.'</span>';
$thisFile=__FILE__; $thisLine=__LINE__; include('common/displayErrorsAndMessages.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
}
mysql_data_seek($pclassResult, 0);
#$pclassRow = mysql_fetch_assoc($pclassResult);
while ($pclassRow = mysql_fetch_assoc($pclassResult)) {
}
/**/
if ( $pclassResultCount ) {
$cr = '';
mysql_data_seek($pclassResult, 0);
while ($pclassRow = mysql_fetch_assoc($pclassResult)) {
if ( $cr == '' ) {
$cr = ' ('.$pclassRow['CRHR'];
if ( $pclassRow['CRMAX'] ) $cr .= '-'.$pclassRow['CRMAX'];
$cr .= 'cr)';
}
$COU_ID_List = listAppend($COU_ID_List,"'".$pclassRow['COU_ID']."'"); // Add COU_ID to list.
}
$darsclassrankRow['darsclassOffered'] = 1;
} else {
$darsclassrankRow['darsclassOffered'] = 0;
$cr = '';
}
d_Var($darsclassrankRow['darsclassDept'].$darsclassrankRow['darsclassNumb'].$cr.' offered',$darsclassrankRow['darsclassOffered'],$aDEBUG.'bl');
} // Are we advisings?
if ( $darsclassrankRow['darsclassOffered'] ) { // Is the class offered?
$classNumber = $darsclassrankRow['darsclassDept'].$darsclassrankRow['darsclassNumb'];
$classList = listAppend($classList,$classNumber);
$nextTakenCredits += $darsclassrankRow['darsclassCredits'];
$nextTotalCredits -= $darsclassrankRow['darsclassCredits'];
// Add the student to the StudentsThatNeedClass.
if ( !isset($StudentsThatNeedClass[$classNumber]) ) $StudentsThatNeedClass[$classNumber] = array();
$studentNameId = $darsRow['darsStudentFirstName'].' '.$darsRow['darsStudentLastName'].' '.$darsRow['darsStudentId'];
if ( !in_array($studentNameId,$StudentsThatNeedClass[$classNumber]) ) {
$StudentsThatNeedClass[$classNumber][] = $studentNameId;
if ( isset($classListArray[$classNumber]) ) {
$classListArray[$classNumber]++;
} else {
$classListArray[$classNumber] = 1;
}
}
} // Is the class offered?
} // Did the student have classes to select from?
} // Is this not CST1000?
} // Loop thru classes by ranking.
} // Are there any classes?
$nextTotalCreditsFull = $nextCoreCredits + $nextElectiveCredits;
if ($nextTakenCreditsFull) {
$totalProjectedCreditsFull += $nextTakenCredits;
$totalProjectedCountFull++;
}
$nextTotalCredits = $nextCoreCredits + $nextElectiveCredits;
if ($nextTakenCredits) {
$totalProjectedCredits += $nextTakenCredits;
$totalProjectedCount++;
}
if ($nextTakenCredits < $nextTotalCredits) {
$nextTakenCredits = '<span class="error">'.$nextTakenCredits.'</span>';
} elseif ($nextTakenCredits > $nextTotalCredits) {
$nextTakenCredits = '<span class="attention">'.$nextTakenCredits.'</span>';
}
$classListDisplayArray = explode(",",$classList);
$classListFullDisplayArray = explode(",",$classListFull);
$classList = str_replace(",",", ",listSort($classList));
$classListFull = str_replace(",",", ",listSort($classListFull));
if ($classList == $classListFull) {
$classListFullDisplay = '';
} else {
$classListFullDisplay = '';
$classListFullCount = 0;
foreach ( $classListFullDisplayArray as $thisFullClass ) {
/**/
if ( !in_array($thisFullClass,$classListDisplayArray) ) {
$classListFullCount++;
$classListFullDisplay = listAppend($classListFullDisplay,$thisFullClass);
}
/**/
}
$classListFullDisplay = '<br>Could also take '.str_replace(",",", ",listSort($classListFullDisplay)).' if ';
if ( $classListFullCount == 1 ) {
$classListFullDisplay .= 'it was ';
} else {
$classListFullDisplay .= 'they were ';
}
$classListFullDisplay .= 'offered ('.$nextTakenCreditsFull.'cr)';
}
// END Calculate classes to take.
?>
<td class="right <?=$eo?>"><?=$coreCredits?></td>
<td class="rbdr right <?=$eo?>"><?=$electiveCredits?></td>
<td class="bold right <?=$eo?>"><?=$nextTakenCredits?></td>
<td class="left <?=$eo?>">
<?=$classList?><?=$classListFullDisplay?>
<?
if ( $IsAdvising ) { // Are we advising?
// Also show classes taken.
$classesTaken = '';
$TotalCreditsTaken = 0;
$currentClassInfo = '';
$failedClassInfo = '';
$query = "
SELECT darssectionclassId,
darsId,
darssectionId,
darssectionclassSemester,
darssectionclassYear,
darssectionclassDept,
darssectionclassNumb,
darssectionclassCredits,
darssectionclassGrade,
darssectionclassLegend,
darssectionclassTitle,
darssectionclassComment
FROM `darssectionclass`
WHERE darssectionId IN (".$darssectionIdList.")
ORDER BY darssectionclassDept, darssectionclassNumb
";
d_Var('darssectionclassTakenResult',$query,'q');
$darssectionclassTakenResult = query_do($query);
$darssectionclassTakenCount = $_SESSION['qry']['count'];
d_Var('$darssectionclassTakenCount',$darssectionclassTakenCount,'');
d_Var('$darssectionclassTakenResult',$darssectionclassTakenResult,'');
if ( $darssectionclassTakenCount ) { // Were there classes this semester.
mysql_data_seek($darssectionclassTakenResult, 0);
while ( $classRow = mysql_fetch_assoc($darssectionclassTakenResult) ) { // Loop thru semester classes.
$classTaken = $classRow['darssectionclassDept'].$classRow['darssectionclassNumb'];
if ( $classRow['darssectionclassGrade'] == 'Z' ) {
$classTaken = '<span class="gradeNG">'.$classTaken.'</span>';
$currentClassInfo = '<span class="gradeNG">(current class)</span>';
$TotalCreditsTaken += $classRow['darssectionclassCredits'];
} else if ( $classRow['darssectionclassGrade'] == 'F' || $classRow['darssectionclassGrade'] == 'NP' ) {
$classTaken = '<span class="gradeF">'.$classTaken.'</span>';
$failedClassInfo = '<span class="gradeF">(failed class)</span>';
} else {
$TotalCreditsTaken += $classRow['darssectionclassCredits'];
}
$classesTaken = listAppend($classesTaken,$classTaken);
} // Loop thru semester classes.
} // Were there classes this semester.
if ( $classesTaken != '' ) {
$classesTaken = 'Taken: '.listAnd($classesTaken).'.';
if ( $currentClassInfo != '' || $failedClassInfo != '' ) $classesTaken .= '<br>'.trim($currentClassInfo.' '.$failedClassInfo);
$classesTaken .= '<br>Total credits = '.$TotalCreditsTaken.'.';
} else {
$classesTaken = 'No classes taken.';
}
?><br><?=$classesTaken?><?
/** /
$query = "
SELECT darssectionclassId,
darsId,
darssectionId,
darssectionclassSemester,
darssectionclassYear,
darssectionclassDept,
darssectionclassNumb,
darssectionclassCredits,
darssectionclassGrade,
darssectionclassLegend,
darssectionclassTitle,
darssectionclassComment
FROM `darssectionclass`
WHERE darssectionId IN (".$darssectionIdList.")
AND darssectionclassSemester = '".mysql_safe($semesterCode[$i])."'
AND ( darssectionclassYear = '".mysql_safe($yearCode[$i])."' OR darssectionclassYear = '".mysql_safe($yearCode4[$i])."' )
ORDER BY darssectionclassDept, darssectionclassNumb
/**/
} // Are we advising?
?>
</td>
</tr>
<?
$DARSindex++;
} // Normally true, else is this darsId == value?
if ( isset($d_O) && !$d_O ) d_Off();
} // Loop through the DARS for each student.
?>
<tr>
<td class="tbdr bbdr" colspan="<?=$colTot?>">
<span class="bold error">Red</span> projected credits are less than average credits taken.<br>
<span class="attention">Blue</span> projected credits are greater than average credits taken.<br>
</td>
</tr>
<?
if ( !$IsAdvising ) { // Are we calculating YRTR credits?
?>
<tr style="vertical-align:bottom;">
<th class="center rbdr" colspan="4"></th>
<th class="center rbdr" colspan="<?=$colSem?>">Semester credits</th>
<th class="center rbdr" colspan="2">Needed</th>
<th class="center rbdr" colspan="2">Next</th>
<th class="right"></th>
<th class="right"></th>
</tr>
<tr style="vertical-align:bottom;">
<th class="rbdr" colspan="4"></th>
<?
for ($i=0; $i<count($semesterCode); $i++) {
?>
<th class="right"><?=$semesterCode[$i]?><?=$yearCode[$i]?></th>
<?
}
?>
<th class="rbdr right">Avg</th>
<th class="center">Core</th>
<th class="rbdr center">Elec</th>
<th class="center">Core</th>
<th class="rbdr center">Elec</th>
<th class="center">Cr</th>
<th class="left" colspan="2">Other Information</th>
</tr>
<tr>
<th colspan="4" class="rbdr right">Total technical credits:</th>
<?
$averageCreditsTotal = 0;
for ($i=0; $i<count($semesterCode); $i++) {
$averageCreditsTotal += $semesterTotalCredits[$i];
?>
<td class="right"><?=$semesterTotalCredits[$i]?></td>
<?
}
$averageCreditsTaken = intval(($averageCreditsTotal/count($semesterCode))+.51);
?>
<td class="rbdr right"><?=$averageCreditsTaken?></td>
<td class="right"><?=$coreCreditsNeededTotal?></td>
<td class="rbdr right"><?=$ElectiveCreditsNeededTotal?></td>
<td class="right"><?=$coreCreditsTotal?></td>
<td class="rbdr right"><?=$electiveCreditsTotal?></td>
<td class="right"><?=$totalProjectedCredits?></td><td>credits projected excluding new starts.</td>
</tr>
<tr>
<th colspan="4" class="rbdr right">Student count:</th>
<?
$semesterStudentCountTotal = 0;
for ($i=0; $i<count($semesterCode); $i++) {
if ($i == count($semesterCode)-1) $semesterStudentCountLastSemester = $semesterStudentCount[$i];
$semesterStudentCountTotal += $semesterStudentCount[$i];
?>
<td class="right"><?=$semesterStudentCount[$i]?></td>
<?
}
$averageStudentCount = intval(($semesterStudentCountTotal/count($semesterCode))+.51);
?>
<td class="rbdr right"><?=$averageStudentCount?></td>
<td class="right"><?=$coreStudentCount?></td>
<td class="rbdr right"><?=$electiveStudentCount?></td>
<td class="right"><?=$coreCreditsCount?></td>
<td class="rbdr right"><?=$electiveCreditsCount?></td>
<td class="right"><?=$totalProjectedCount?></td><td>students projected to return.</td>
</tr>
<tr>
<th colspan="4" class="rbdr right">Average technical credits per student:</th>
<?
$averageCreditsTakenTotal = 0;
for ($i=0; $i<count($semesterCode); $i++) {
if ($semesterStudentCount[$i]) {
$averageCreditsTaken = intval((($semesterTotalCredits[$i]/$semesterStudentCount[$i])+.051)*10)/10;
} else {
$averageCreditsTaken = 0;
}
$averageCreditsTakenTotal += $averageCreditsTaken;
?>
<td class="right"><?=$averageCreditsTaken?></td>
<?
}
$averageCreditsPerStudent = intval(($averageCreditsTakenTotal/count($semesterCode))+.51);
$coreCreditsNeededPerStudent = intval(($coreCreditsNeededTotal/$semesterStudentCountLastSemester)+.51);
$electiveCreditsNeededPerStudent = intval(($ElectiveCreditsNeededTotal/$semesterStudentCountLastSemester)+.51);
$coreCreditsPredictedPerStudent = intval(($coreCreditsTotal/$semesterStudentCountLastSemester)+.51);
$electiveCreditsPredictedPerStudent = intval(($ElectiveCreditsNeededTotal/$semesterStudentCountLastSemester)+.51);
if ($totalProjectedCount) {
$projectedCreditsPredictedPerStudent = intval(($totalProjectedCredits/$totalProjectedCount)+.51);
} else {
$projectedCreditsPredictedPerStudent = 'N/A';
}
?>
<td class="rbdr right"><?=$averageCreditsPerStudent?></td>
<td class="right"><?=$coreCreditsNeededPerStudent?></td>
<td class="rbdr right"><?=$electiveCreditsNeededPerStudent?></td>
<td class="right"><?=$coreCreditsPredictedPerStudent?></td>
<td class="rbdr right"><?=$electiveCreditsPredictedPerStudent?></td>
<td class="right"><?=$projectedCreditsPredictedPerStudent?></td><td>average credits per returning student.</td>
</tr>
<?
} // Are we calculating YRTR credits?
?>
</table>
<?
// END Show classes needed.
if ( isset($d_O) && !$d_O ) d_Off();
?>