?>
');
});
</script>
</head>
<body>
<form method="POST">
Max Score : <input type="text" name="maxScore" value="100"/><br/>
Score : <input type="text" name="score" value="<?php
echo $score;
?>
"/><br/>
Point : <input type="number" name="point"/><br/>
Grade Range<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 0<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 1<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 1.5<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 2<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 2.5<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 3<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 3.5<br/>
ตั้งแต่ <input type="text" name="min[]"> ไม่ถึง <input type="text" name="max[]"> => 4<br/>
<input type="submit" name="submit"/>
</form>
<?php
if ($submit) {
echo 'Grade Cal = ' . gradeCal($min, $max, $point, $score);
}
?>
</body>
</html>
if ($max[$i] == '' || $max[$i] == null || !isset($max[$i])) {
$maxPass = false;
break;
}
}
if ($maxPass) {
$maxScore = $max[7];
$strSQL = sprintf("\n SELECT\n stu.studentID,stu.firstName,stu.lastName,SUM(stusco.score) AS score\n FROM\n `studentscore` stusco RIGHT JOIN `student` stu ON stusco.studentID = stu.studentID\n WHERE\n stusco.scoreID IN\n (\n SELECT\n scoreID\n FROM\n scoreinfo\n WHERE\n subjectID = '%s' AND\n registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) OR (stu.studentID IN (\n SELECT\n studentID\n FROM\n `register-student` regstu\n WHERE\n regstu.subjectID = '%s' AND\n regstu.registerID =\n (\n SELECT\n registerID\n FROM\n registerinfo\n WHERE\n term = '%s' AND\n year = '%s'\n )\n ) AND stusco.subjectID IS NULL\n )\n GROUP BY\n studentID\n ", mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID), mysql_real_escape_string(getTerm()), mysql_real_escape_string(getYear()), mysql_real_escape_string($subjectID));
$objQuery = mysql_query($strSQL);
if ($objQuery && mysql_num_rows($objQuery)) {
while ($row = mysql_fetch_assoc($objQuery)) {
$preData = $row;
if ($row['score'] == '') {
$preData['score'] = 0;
}
$grade = gradeCal(0, $max, 0, $row['score']);
$select = '<select name="grade" style="width: 80px;">';
// $select.= '<option value="">--</option>';
$select .= '<option value="' . $grade . '" selected>' . $grade . '</option>';
$select .= '<option value="W">W</option>';
$select .= '</select>';
$preData['grade'] = '<input type="hidden" name="studentID" value="' . $row['studentID'] . '">' . $select;
$preData['score'] = $preData['score'] . '/' . $maxScore;
$return['data'][] = $preData;
}
$return['status'] = 'SUCCESS';
} else {
$return['status'] = 'FAIL';
$return['strSQL'] = $strSQL;
}
} else {
durningScore => $confDurningScore,
midScore => $confMidScore,
finalScore => $confFinalScore
);
// Sample Data Generator Begin
for($i=0;$i<7;$i++){
$predata['subjectID'] = 'ท99999';
$predata['subjectName'] = 'ทดสอบรายวิชา';
$predata['hour'] = '99';
$predata['weight'] = '9.9';
$predata['durningScore'] = rand(0,60);
$predata['midScore'] = rand(0,20);
$predata['totalDurningScore'] = $predata['durningScore']+$predata['midScore'];
$predata['finalScore'] = rand(0,20);
$predata['totalScore'] = $predata['totalDurningScore']+$predata['finalScore'];
$predata['grade'] = gradeCal(NULL, array(50,55,60,65,70,75,80,100), '0', $predata['totalScore']);
$predata['beg'] = $predata['grade']=='0'?'<input type="text" value="1" />':'';
$dataInfoExtra[] = $predata;
}
// Sample Data Generator End
function genData($data){
$res = '';
foreach ($data as $val){
$res.= "<tr>";
$res.= '<td class="lefttext">'.$val['subjectID']."</td>";
$res.= '<td class="lefttext">'.$val['subjectName']."</td>";
$res.= "<td>".$val['hour']."</td>";
$res.= "<td>".$val['weight']."</td>";
$res.= "<td>".$val['durningScore']."</td>";
$res.= "<td>".$val['midScore']."</td>";
$res.= "<td>".$val['totalDurningScore']."</td>";
