| 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/Class/ |
Upload File : |
<?
// Admin/Class/ClassEvaluations.phpinc
debugTrackBegin();
//setDebugOn();
#if (dc()) echo "<b>".__FILE__."</b><br>\n";
$js .= ",ClassEvaluations,wforms";
$headTitle = '_CST_ - '.$f_RCclassId.' '.$f_courseNumber.' sec '.$f_classSection.' Class Evaluations';
$pageTitle = '_CST_<br>'.$f_courseNumber.' sec '.$f_classSection.' Class Evaluations';
require('common/pageHeader.phpinc');
$sectionTitle = $f_RCclassId.' '.$f_courseNumber.' sec '.$f_classSection.' Class Evaluations';
require('common/sectionHeader.phpinc');
$evaluationPointsGraded = 0;
$evaluationPointsExtraCredit = 0;
$evaluationPointsTotal = 0;
?>
<form name="form_classevaluationsupdate" action="<?=php_self()?>" method="post" style="display:inline;">
<input name="f_uuid" type="hidden" value="<?=uuid()?>">
<input name="f_form" type="hidden" value="form_classevaluationsupdate">
<input name="f_classId" type="hidden" value="<?=$f_classId?>">
<input name="f_import_classId" type="hidden" value="">
<input name="f_courseNumber" type="hidden" value="<?=$f_courseNumber?>">
<input name="f_courseId" type="hidden" value="<?=$f_courseId?>">
<input name="f_classSection" type="hidden" value="<?=$f_classSection?>">
<input name="f_task" type="hidden" value="Class Evaluations">
<input name="f_evaluationId_hidden" type="hidden" value="">
<fieldset id="wf_form_classevaluationsupdate" class=""><legend>Class Evaluations</legend>
<div class="instructions">Setup the evaluations for your class.</div>
<?
// Check for previous evaluations.
// Get f_Course_classId_List.
$courseNumber = $f_courseNumber;
$anyYRTR = true;
if ( strpos($f_courseNumber,'CST') !== false ) { $courseNumberOther = str_replace('CST','CST',$courseNumber); } else { $courseNumberOther = str_replace('MMDT','CST',$courseNumber); }
$query = "
SELECT courseId
FROM course
WHERE courseNumber = '".$courseNumber."' OR courseNumber = '".$courseNumberOther."'
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
$f_CourseId_List = '';
$f_Course_classId_List = '';
if ($courseCount) {
mysqli_data_seek($courseResult, 0);
while ($courseRow = mysqli_fetch_assoc($courseResult)) {
$f_CourseId_List = listAppend($f_CourseId_List,$courseRow['courseId']);
}
if ( $f_CourseId_List == '' ) $f_CourseId_List = '0';
#printVar('$f_CourseId_List',$f_CourseId_List);
// Get the list of classIds.
$query = "
SELECT classId
FROM class
WHERE courseId IN ( ".$f_CourseId_List." )";
if ( !isset($anyYRTR) || $anyYRTR === false ) {
$query .= "
AND YRTR = '".$_SESSION['YRTR']['User']."'";
}
$query .= "
ORDER BY classId
";
#d_Var('classResult',$query,'q',false,true);
$classResult = query_do($query);
#d_Var('$classResult',$classResult,'',false,true);
$classCount = $_SESSION['qry']['count'];
// Create f_Course_classId_List.
if ($classCount) {
mysqli_data_seek($classResult, 0);
while ($classRow = mysqli_fetch_assoc($classResult)) {
$f_Course_classId_List .= $classRow['classId'].', ';
}
$f_Course_classId_List = substr($f_Course_classId_List,0,strlen($f_Course_classId_List)-2);
}
}
#require('Course/Course_classId_List.phpinc');
#printVar("\$f_Course_classId_List",$f_Course_classId_List);
// Get Evaluations.
$query = "
SELECT
evaluationId,
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationInactive,
lastModified,
modifiedBy
FROM evaluation
";
if ( $f_classId ) {
$query .= "
WHERE classId = ".$f_classId."
";
} else {
$query .= "
WHERE classId = 0
";
}
$query .= "
ORDER BY evaluationOrder,evaluationSubOrder
";
$evaluationResult = query_do($query);
$evaluationCount = $_SESSION['qry']['count'];
#printVar('$evaluationCount',$evaluationCount);
// Student and Class profiles.
$query = "
SELECT
classId,
courseId,
YRTR,
classSection,
studentProfilePoints,
classProfilePoints,
modifiedBy,
lastModified
FROM class
";
if ( $f_classId ) {
$query .= "
WHERE classId = ".$f_classId."
";
} else {
$query .= "
WHERE classId = 0
";
}
$query .= "
";
$classResult = query_do($query);
$classCount = $_SESSION['qry']['count'];
$classRow = mysqli_fetch_assoc($classResult);
$f_studentProfilePoints = $classRow['studentProfilePoints'];
$evaluationPointsGraded += $f_studentProfilePoints;
$f_classProfilePoints = $classRow['classProfilePoints'];
$evaluationPointsGraded += $f_classProfilePoints;
?>
<br>
<table>
<tr>
<td class="right"><label for="f_studentProfilePoints" class="preField">Student Profile points:</label></td>
<td><input type="text" name="f_studentProfilePoints" id="f_studentProfilePoints" class="number2" value="<?=$f_studentProfilePoints?>" maxlength="2"> If your class does not use the Student Profile set the points to 0. Will have a weight of 1.
</td>
</tr>
<!--
-->
<tr>
<td class="right"><label for="f_classProfilePoints" class="preField">Class Profile points:</label></td>
<td><input type="text" name="f_classProfilePoints" class="number2" value="<?=$f_classProfilePoints?>" maxlength="2"> If your class does not use the Class Profile set the points to 0. Will have a weight of 1.
</td>
</tr>
</table>
<br>
<?
if (dc()) {
printVar('$evaluationCount',$evaluationCount);
}
if ($evaluationCount) {
?>
<table>
<tr>
<td>Id</td>
<th class="">Drop</th>
<th class="number2">Ord</th>
<th class="number2">Sub</th>
<th class="">Type</th>
<th class="">Title</th>
<th class="">Description</th>
<th class="number3">Points</th>
<th class="number3">Weight</th>
<th class="">Critical</th>
<th class="">Extra</th>
<th class="">Inactive</th>
<th class="">Edit</th>
</tr>
<?
mysqli_data_seek($evaluationResult, 0);
while ($evaluationRow = mysqli_fetch_assoc($evaluationResult)) {
if ($evaluationRow['evaluationOrder'] >= 0) {
$fileSelected = '';
$testSelected = '';
switch ($evaluationRow['evaluationType']) {
case '':
case 'na':
break;
case 'file':
$fileSelected = ' selected="selected"';
break;
case 'test':
$testSelected = ' selected="selected"';
break;
default:
echo '<p class="bold">'.__FILE__.' <span class="error">evaluationType for $f_task=['.$f_task.']</span>'.' <span class="error">$f_subtask=['.$f_subtask."] is in error.</p>\n"; setDebugOn(); require('common/pageFooter.phpinc');
}
if ($evaluationRow['evaluationCritical'] == 0 ) { $evaluationCriticalChecked = ''; } else { $evaluationCriticalChecked = ' checked="checked"'; }
if ($evaluationRow['evaluationExtraCredit'] == 0 ) { $evaluationExtraCreditChecked = ''; } else { $evaluationExtraCreditChecked = ' checked="checked"'; }
if ($evaluationRow['evaluationInactive'] == 0 ) { $evaluationInactiveChecked = ''; } else { $evaluationInactiveChecked = ' checked="checked"'; }
?>
<tr>
<td><?/**/echo $evaluationRow['evaluationId'];/**/ ?></td>
<td class="center"><input type="hidden" name="f_evaluationId[]" value="<?=$evaluationRow['evaluationId']?>"><input type="checkbox" id="f_evaluationDrop_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationDrop_U<?=$evaluationRow['evaluationId']?>" value="1" class="" style="margin-top:5px;"></td>
<td><input type="text" id="f_evaluationOrder_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationOrder_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationOrder']?>" class="number2"></td>
<td><input type="text" id="f_evaluationSubOrder_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationSubOrder_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationSubOrder']?>" class="number2"></td>
<td><select id="f_evaluationType_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationType_U<?=$evaluationRow['evaluationId']?>" class="" style="margin-top:0px;">
<option value="">---</option>
<option value="file"<?=$fileSelected?>>file</option>
<option value="test"<?=$testSelected?>>test</option>
</select></td>
<td><input type="text" id="f_evaluationTitle_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationTitle_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationTitle']?>" class=""></td>
<td><input type="text" id="f_evaluationDescription_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationDescription_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationDescription']?>" class=""></td>
<td><input type="text" id="f_evaluationPoints_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationPoints_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationPoints']?>" class="number3"></td>
<td><input type="text" id="f_evaluationWeight_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationWeight_U<?=$evaluationRow['evaluationId']?>" value="<?=$evaluationRow['evaluationWeight']?>" class="number3"></td>
<td class="center"><input type="checkbox" id="f_evaluationCritical_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationCritical_U<?=$evaluationRow['evaluationId']?>" value="1" class="" style="margin-top:5px;"<?=$evaluationCriticalChecked?>></td>
<td class="center"><input type="checkbox" id="f_evaluationCritical_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationExtraCredit_U<?=$evaluationRow['evaluationId']?>" value="1" class="" style="margin-top:5px;"<?=$evaluationExtraCreditChecked?>></td>
<td class="center"><input type="checkbox" id="f_evaluationInactive_U<?=$evaluationRow['evaluationId']?>" name="f_evaluationInactive_U<?=$evaluationRow['evaluationId']?>" value="1" class="" style="margin-top:5px;"<?=$evaluationInactiveChecked?>></td>
<td><input type="submit" class="small" id="f_subtask" name="f_subtask" value="Edit" onclick="document.form_classevaluationsupdate.f_evaluationId_hidden.value=<?=$evaluationRow['evaluationId']?>;"></td>
</tr>
<?
}
if (!isset($evaluationExtraCreditChecked) || !$evaluationExtraCreditChecked) {
$evaluationPointsGraded += $evaluationRow['evaluationPoints'] * $evaluationRow['evaluationWeight'];
} else {
$evaluationPointsExtraCredit += $evaluationRow['evaluationPoints'] * $evaluationRow['evaluationWeight'];
}
}
$evaluationPointsTotal = $evaluationPointsGraded + $evaluationPointsExtraCredit;
?>
<tr><td colspan="6" class="right">Total Graded Points:</td><td><?=$evaluationPointsGraded?></td><td colspan="4"></td></tr>
<tr><td colspan="6" class="right">Total Extra Credit Points:</td><td><?=$evaluationPointsExtraCredit?></td><td colspan="4"></td></tr>
<tr><td colspan="6" class="right">Total Possible Points:</td><td><?=$evaluationPointsTotal?></td><td colspan="4"></td></tr>
</table>
<?
}
?>
<div id="wf_QuestionsNew" class="repeat">
<table>
<tr>
<th class="" style="color:#FFFFFF">Drop</th>
<th class="number2">Ord</th>
<th class="number2">Sub</th>
<th class="">Type</th>
<th class="">Title</th>
<th class="">Description</th>
<th class="number3">Points</th>
<th class="number3">Weight</th>
<th class="">Critical</th>
<th class="">Extra</th>
<th class="">Inactive</th>
</tr>
<tr>
<th class=""></th>
<td><span class="oneField"><input type="text" id="wf_evaluationOrder_A" name="wf_evaluationOrder_A" value="" class="number2"></span></td>
<td><span class="oneField"><input type="text" id="wf_evaluationSubOrder_A" name="wf_evaluationSubOrder_A" value="" class="number2"></span></td>
<td><span class="oneField"><select id="wf_evaluationType_A" name="wf_evaluationType_A" class="" style="margin-top:0px;">
<option value="">---</option>
<option value="file">file</option>
<option value="test">test</option>
</select></span></td>
<td><span class="oneField"><input type="text" id="wf_evaluationTitle_A" name="wf_evaluationTitle_A" value="" class=""></span></td>
<td><span class="oneField"><input type="text" id="wf_evaluationDescription_A" name="wf_evaluationDescription_A" value="" class=""></span></td>
<td><span class="oneField"><input type="text" id="wf_evaluationPoints_A" name="wf_evaluationPoints_A" value="" class="number3"></span></td>
<td><span class="oneField"><input type="text" id="wf_evaluationWeight_A" name="wf_evaluationWeight_A" value="" class="number3"></span></td>
<td><span class="oneField center"><input type="checkbox" id="wf_evaluationCritical_A" name="wf_evaluationCritical_A" value="1" class="" style="margin-top:5px;"></span></td>
<td><span class="oneField center"><input type="checkbox" id="wf_evaluationExtraCredit_A" name="wf_evaluationExtraCredit_A" value="1" class="" style="margin-top:5px;"></span></td>
<td><span class="oneField center"><input type="checkbox" id="wf_evaluationInactive_A" name="wf_evaluationInactive_A" value="1" class="" style="margin-top:5px;"></span></td>
</tr>
</table>
</div>
</fieldset>
<div class="actions">
<input type="submit" class="primaryAction" id="f_subtask" name="f_subtask" value="Update">
<?
if ($f_form != "form_classevaluationsupdate") {
?>
<input type="submit" class="secondaryAction" id="f_subtask" name="f_subtask" value="Cancel">
<?
} else {
?>
<input type="submit" class="secondaryAction" id="f_subtask" name="f_subtask" value="Done">
<?
}
?>
</div>
<?
// Get list of evaluations.
$query = "
SELECT evaluation.classId
, class.YRTR
, RCclassId
, classSection
, courseNumber
, count(evaluationId) AS evaluationIdCount
, course.userId
FROM `evaluation`
JOIN `class` ON class.classId = evaluation.classId
JOIN `course` ON course.courseId = class.courseId
";
#printVar('$f_Course_classId_List',$f_Course_classId_List);
if ( $f_Course_classId_List != '' ) {
$query .= "
WHERE evaluation.classId IN (".$f_Course_classId_List.")
";
} else {
$query .= "
WHERE evaluation.classId = 0
";
}
if ( $f_classId ) {
$query .= "
AND evaluation.classId != ".$f_classId."
";
} else {
$query .= "
AND evaluation.classId != 0
";
}
$query .= "
GROUP BY evaluation.classId
ORDER BY class.YRTR DESC, courseNumber, classSection
";
$evaluationResult = query_do($query);
$evaluationCount = $_SESSION['qry']['count'];
#printVar("\$evaluationIdCount",$evaluationIdCount);
#printVar('$f_classId',$f_classId);
// Display list of evaluations for import.
?>
<br>
<?
if ($evaluationCount) {
?>
<table border="1">
<tr><td></td><th>classId</th><th>YRTR</th><th>Course-Sec</th><th># evals</th><th>Instructor</th><th class="right">Id</th></tr>
<?
mysqli_data_seek($evaluationResult, 0);
while ($evaluationInfo = mysqli_fetch_assoc($evaluationResult)) {
?>
<tr>
<td><input type="submit" class="primaryAction" id="f_subtask" name="f_subtask" value="Import" onclick="importEvaluation(<?=$evaluationInfo['classId']?>);"></td>
<td><?=$evaluationInfo['RCclassId']?></td>
<td><?=$evaluationInfo['YRTR']?></td>
<td><?=$evaluationInfo['courseNumber']?>-<?=$evaluationInfo['classSection']?></td>
<td class="center"><?=$evaluationInfo['evaluationIdCount']?></td>
<td><?=userName($evaluationInfo['userId'])?></td>
<td class="right"><?=$evaluationInfo['classId']?></td>
</tr>
<?
}
?>
</table>
<?
}
?>
</form>
<script type="text/javascript">
function importEvaluation(classId) {
//alert(classId);
document.form_classevaluationsupdate.f_import_classId.value = classId;
}
</script>
<?
require('common/sectionFooter.phpinc');
debugTrackEnd();
require('common/pageFooter.phpinc');
?>