| 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/DARS.cloak/ProjectedStarts/ |
Upload File : |
<?
// Admin/DARS/ProjectedStarts/ProjectedStarts.phpinc
// Calculate the number of starts for the last n years. n is defined in $credentialHistoryYears.
debugTrackBegin();
d_On();
// Set the number of historical years to display:
$credentialHistoryYears = 5;
$pageTitle = "_CST_<br>Credential starts";
include('common/pageHeader.phpinc');
include('Admin/DARS/CredentialFilter.phpinc');
#printVar('$f_darscredentialcodeIdList',$f_darscredentialcodeIdList);
// Get the credential information.
$query = "
SELECT DISTINCT department.departmentCode, darscredential.darscredentialTitle
FROM dars
INNER JOIN darscredential ON darscredential.darsCredentialCode = dars.darsCredentialCode
INNER JOIN darscredentialcode ON darscredentialcode.darscredentialcodeId = darscredential.darscredentialcodeId
AND darscredentialcode.darscredentialcodeId IN (".$f_darscredentialcodeIdList.")
INNER JOIN department ON department.departmentId = darscredentialcode.departmentId
ORDER BY department.departmentCode, darscredential.darscredentialTitle
";
#d_Var('credentialResult',$query,'q');
$credentialResult = query_do($query);
$credentialResultCount = $_SESSION['qry']['count'];
#d_Var('$credentialResult',$credentialResult);
// Get Semester and Year for Ed Plan used.
$query = "
SELECT DISTINCT darsCredentialEdPlanSemesterUsed, darsCredentialEdPlanYrUsed
FROM `dars`
INNER JOIN darscredential ON darscredential.darsCredentialCode = dars.darsCredentialCode
INNER JOIN darscredentialcode ON darscredentialcode.darscredentialcodeId = darscredential.darscredentialcodeId
AND darscredential.darscredentialcodeId IN (".$f_darscredentialcodeIdList.")
ORDER BY darsCredentialEdPlanYrUsed, darsCredentialEdPlanSemesterUsed
";
#printVar('$query',$query,'q');
#d_Var('semesterYearResult',$query,'q');
$semesterYearResult = query_do($query);
$semesterYearResultCount = $_SESSION['qry']['count'];
#d_Var('$semesterYearResult',$semesterYearResult);
$CredentialYRTR_Array = array();
$darsSemester_Array = array();
$darsYear_Array = array();
$index = 0;
if ( $credentialResultCount && $semesterYearResultCount ) {
mysql_data_seek($semesterYearResult, 0);
while ($semesterYearRow = mysql_fetch_assoc($semesterYearResult)) {
// Save the YRTR.
$CredentialYRTR_Array[$index] = SemesterYear_to_YRTR($semesterYearRow['darsCredentialEdPlanSemesterUsed'], $semesterYearRow['darsCredentialEdPlanYrUsed']);
// Save the Year.
$darsYear_Array[$CredentialYRTR_Array[$index]] = $semesterYearRow['darsCredentialEdPlanYrUsed'];
// Save the Semester.
$darsSemester_Array[$CredentialYRTR_Array[$index]] = $semesterYearRow['darsCredentialEdPlanSemesterUsed'];
$index++;
}
// Calculate YRTR for display start.
$YRTR_start = $_SESSION['YRTR']['CURRENT'];
for ($i=0; $i<$credentialHistoryYears*3; $i++) {
$YRTR_start = YRTR_previous($YRTR_start);
}
#printVar('$YRTR_start',$YRTR_start);
// Find the first YRTR_start found in the dars.
$YRTR_found = false;
while ( !$YRTR_found ) {
foreach ( $CredentialYRTR_Array as $key => $YRTR ) {
if ( $YRTR == $YRTR_start ) {
$YRTR_found = true;
}
}
if ( !$YRTR_found ) {
$YRTR_start = YRTR_next($YRTR_start);
}
}
#d_Var('$YRTR_start',$YRTR_start);
#d_Var('YRTR_to_SemesterYear($YRTR_start)',YRTR_to_SemesterYear($YRTR_start));
// Show starts for each semester for each program.
?>
<p>
<div class="center">
<fieldset><legend>Semester Starts</legend>
<form name="DARS_CalculateStarts" action="<?=str_replace('index.php','',$_SERVER['PHP_SELF'])?>" method="post">
<input type="hidden" name="f_form" value="DARS_CalculateStarts" />
<input type="hidden" name="f_uuid" value="<?=uuid()?>" />
<input type="submit" name="f_task" value="Calculate class starts" />
<table>
<tr>
<th colspan="2">Credential</th>
<?
// Loop through each YRTR.
$thisYRTR = $YRTR_start;
while ( $thisYRTR <= $_SESSION['YRTR']['CURRENT'] ) {
if ( isset($darsSemester_Array[$thisYRTR]) ) {
?>
<th><?=$thisYRTR?><br><?=$darsSemester_Array[$thisYRTR]?><br><?=$darsYear_Array[$thisYRTR]?></th>
<?
}
$thisYRTR = YRTR_next($thisYRTR);
}
$nextYRTR = $thisYRTR;
// Averages.
$loopYRTR = $nextYRTR;
for ($i=0; $i<3; $i++) {
$SemesterYear = YRTR_to_SemesterYear($loopYRTR);
?>
<th class="center info"><br><?=$SemesterYear[0]?><br>Average</th>
<?
$loopYRTR = YRTR_next($loopYRTR);
}
?>
</tr>
<?
// Zero averageStartsTotal.
$averageStartsTotal = array();
$averageStartsTotalStd = array();
$averageStartsTotalCount = array();
$averageStartsTotalNonZero = array();
$loopYRTR = $nextYRTR;
for ($i=0; $i<3; $i++) {
$averageStartsTotal[substr($loopYRTR,-1)] = 0;
$averageStartsTotalStd[substr($loopYRTR,-1)] = 0;
$averageStartsTotalCount[substr($loopYRTR,-1)] = 0;
$averageStartsTotalNonZero[substr($loopYRTR,-1)] = false;
$loopYRTR = YRTR_next($loopYRTR);
}
// Loop through each credential.
mysql_data_seek($credentialResult, 0);
while ($credentialRow = mysql_fetch_assoc($credentialResult)) {
// Zero averageStarts.
$averageStarts = array();
$averageStartsList = array();
$averageStartsCount = array();
$averageStartsNonZero = array();
$loopYRTR = $nextYRTR;
for ($i=0; $i<3; $i++) {
$averageStarts[substr($loopYRTR,-1)] = 0;
$averageStartsList[substr($loopYRTR,-1)] = '';
$averageStartsCount[substr($loopYRTR,-1)] = 0;
$averageStartsNonZero[substr($loopYRTR,-1)] = false;
$loopYRTR = YRTR_next($loopYRTR);
}
?>
<tr>
<td class="right"><?=$credentialRow['departmentCode']?></td><td><?=$credentialRow['darscredentialTitle']?></td>
<?
// Loop through each YRTR.
$thisYRTR = $YRTR_start;
$YRTRcount = 0;
while ( $thisYRTR <= $_SESSION['YRTR']['CURRENT'] ) {
if ( isset($darsSemester_Array[$thisYRTR]) ) {
$YRTRcount++;
// Get the total starts.
$query = "SELECT darsId
FROM `dars`
WHERE darsCredentialTitle = '".$credentialRow['darscredentialTitle']."'
AND darsCredentialEdPlanSemesterUsed = '".$darsSemester_Array[$thisYRTR]."'
AND darsCredentialEdPlanYrUsed = '".$darsYear_Array[$thisYRTR]."'
";
#d_Var('darsResult',$query,'q');
$darsResult = query_do($query);
$darsResultCount = $_SESSION['qry']['count'];
#d_Var('$darsResult',$darsResult);
$newStarts = 0;
$darsIdList = query_to_list($darsResult); if ( $darsIdList == '' ) $darsIdList = '0';
$query = "SELECT DISTINCT darsStudentId
FROM `dars`
WHERE darsId IN ( ".$darsIdList." )
";
#d_Var('darsResult',$query,'q');
$darsStudentIdResult = query_do($query);
$darsStudentIdCount = $_SESSION['qry']['count'];
?>
<td class="center"><?=$darsStudentIdCount?></td>
<?
if ( $darsStudentIdCount ) {
// Add count to averageStarts and averageStartsTotal.
$averageStarts[substr($thisYRTR,-1)] += $darsStudentIdCount;
$averageStartsList[substr($thisYRTR,-1)][] = $darsStudentIdCount;
$averageStartsNonZero[substr($thisYRTR,-1)] = true;
}
if ( $averageStartsNonZero[substr($thisYRTR,-1)] ) {
$averageStartsCount[substr($thisYRTR,-1)] += 1;
}
}
$thisYRTR = YRTR_next($thisYRTR);
}
$loopYRTR = $nextYRTR;
for ($i=0; $i<3; $i++) {
if ( $averageStartsCount[substr($loopYRTR,-1)] > 0 ) {
$averageStartNow = $averageStarts[substr($loopYRTR,-1)]/$averageStartsCount[substr($loopYRTR,-1)];
// Calculate Std Deviation.
$averageStartsStd = 0;
$averageStartsStdCount = 0;
$txt = '';
foreach ( $averageStartsList[substr($loopYRTR,-1)] as $averageStart ) {
$thisStd = $averageStart - $averageStartNow;
$txt = listAppend($txt,$averageStart);
$averageStartsStd += $thisStd * $thisStd;
$averageStartsStdCount++;
}
if ( $averageStartsStdCount > 1 ) {
$averageStartsStd = (int)(sqrt($averageStartsStd/($averageStartsStdCount-1))+.5);
} else {
$averageStartsStd = $averageStart;
}
$averageStartsTotal[substr($loopYRTR,-1)] += $averageStartNow;
$averageStartsTotalStd[substr($loopYRTR,-1)] += $averageStartsStd;
$averageStartsTotalCount[substr($loopYRTR,-1)] += 1;
if ( $averageStartsStd > (int)($averageStartNow) ) $averageStartsStd = (int)($averageStartNow);
?>
<td class="center info"><?=(int)($averageStartNow+.5)?>±<?=$averageStartsStd?><br><?=$txt?></td>
<?
} else {
?>
<td class="center info">-</td>
<?
}
$loopYRTR = YRTR_next($loopYRTR);
}
?>
</tr>
<?
}
$YRTRcount += 2;
?>
<tr>
<td class="right" colspan="<?=$YRTRcount?>">Total avarages:</td>
<?
$loopYRTR = $nextYRTR;
for ($i=0; $i<3; $i++) {
if ( $averageStartsTotalCount[substr($loopYRTR,-1)] > 0 ) {
?>
<td class="center info"><?=(int)($averageStartsTotal[substr($loopYRTR,-1)]+.5)?> ±<?=$averageStartsTotalStd[substr($loopYRTR,-1)]?></td>
<?
} else {
?>
<td class="center info">-</td>
<?
}
$loopYRTR = YRTR_next($loopYRTR);
}
?>
</tr>
<?
/* * /
for ($i=0; $i<3; $i++) {
echo 'Predict for ',YRTR_next($YRTR),' ',YRTR_to_Semester(YRTR_next($YRTR)),"<br>\n";
$YRTR = YRTR_next($YRTR);
}
/* */
?>
</table>
<input type="submit" name="f_task" value="Calculate class starts" />
</form>
</fieldset>
</div>
</p>
<?
} // if ( $credentialResultCount && $semesterYearResultCount ) {
debugTrackEnd();
#setDebugOn();
#setDebugOff();
include('common/pageFooter.phpinc');
?>