<td><?php
echo $row['subject_title'];
?>
</td>
<td>
<div align="center">
<?php
echo $row['credit_unit'];
?>
</div>
</td>
<td>
<div align="center">
<?php
$total_unit += $row['credit_unit'];
$time = unit_to_time($row['credit_unit']);
$time = round($time * 4) / 4;
$whole1 = (int) $time;
$frac1 = $time * 100 % 100 * 0.6;
printf("%02d:%02d", $whole1, $frac1);
?>
</div>
</td>
<td>
<?php
$category_id = $row['category_id'];
$query2 = mysql_query("SELECT * FROM subject_category_t WHERE category_id={$category_id}");
$row2 = mysql_fetch_assoc($query2);
echo $row2['category_name'];
?>
</td>
echo $row_section['curriculum_code'];
?>
<br /></td>
</tr>
<tr >
<td>Total Units: </td>
<td><?php
echo $total_unit;
?>
<br /></td>
</tr>
<tr >
<td>Hours/Week: </td>
<td>
<?php
$time = unit_to_time($total_unit);
$time = round($time * 4) / 4;
$whole1 = (int) $time;
$frac1 = $time * 100 % 100 * 0.6;
printf(" %02d:%02d", $whole1, $frac1);
?>
</td>
</tr>
<tr >
<td>School Year: </td>
<td> <?php
//echo $row_sy['sy_start']." - ".$row_sy['sy_end'];
?>
<select name="sy_id" id="sy_id" style="width:auto;">
<?php
if ($teacher_id != NULL) {
$query_teacher = mysql_query("SELECT * FROM employee_t WHERE emp_id={$teacher_id}");
$row_teacher = mysql_fetch_assoc($query_teacher);
$teacher = $row_teacher['f_name'];
} else {
$teacher = "";
}
$query_room = mysql_query("SELECT * FROM class_room_t WHERE section_assigned='{$_GET['section_id']}'");
$row_room = mysql_fetch_assoc($query_room);
$room_no = $row_room['room_no'];
$class[$i]['subject'] = $subject;
$class[$i]['teacher'] = $teacher;
$class[$i]['units'] = $units;
$class[$i]['room'] = $room_no;
$class_time = total_hours($class_id);
$class_units = unit_to_time($units);
$class_units = round($class_units * 4) / 4;
$total_time += $class_time;
$total_units += $class_units;
//==============================fractionalizing
$whole2 = (int) $class_units;
$frac2 = $class_units * 100 % 100 * 0.6;
$whole1 = (int) $class_time;
$frac1 = $class_time * 100 % 100 * 0.6;
$class_color[$class_id] = $i % 7 + 1;
?>
<script type="text/javascript">
var classes = <?php
echo json_encode($class);
?>
;
</script>
<tr class="color<?php
echo $i;
?>
">
<td ><?php
echo $subject;
?>
</td>
<td><?php
echo $teacher;
?>
</td>
<td><?php
printf("%.2f/%.2f", total_hours($class_id), unit_to_time($units));
?>
<!--<input value="#FFFFFF" style="padding:0; width:20px; height:20px; line-height:100%; " type="color"> -->
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</td>
<td><?php
echo $emp_row['f_name'] . " " . $emp_row['l_name'];
?>
</td>
<td><?php
?>
</td>
<td class="center"> <?php
echo $row['max_load'];
?>
</td>
<td class="center">
<?php
//echo $row['max_load'];
$time = unit_to_time($row['max_load']);
$time = round($time * 4) / 4;
$whole1 = (int) $time;
$frac1 = $time * 100 % 100 * 0.6;
printf("%02d:%02d", $whole1, $frac1);
?>
</td>
<td class="center">
<a class="btn btn-mini" href="actions/teacher_del.php?emp_id=<?php
echo $row['emp_id'];
?>
"><i class=" icon-remove"></i> DELETE</a>
<a class="btn btn-mini" href="#editTeacher" onClick="fillEditForm(<?php
echo $row['emp_id'];
?>
)" data-toggle="modal"><i class="icon-cog"></i> EDIT</a>
function print_time($units)
{
$time = unit_to_time($units);
$time = round($time * 4) / 4;
$whole1 = (int) $time;
$frac1 = $time * 100 % 100 * 0.6;
//printf("Total Tims: %02d:%02d", $whole1, $frac1);
return sprintf("%02d:%02d", $whole1, $frac1);
}
function is_subj_max_e($class_id, $add_hours, $schedule_id)
{
$query = mysql_query("SELECT subject_t.credit_unit AS credit_unit FROM subject_t, class_t WHERE subject_t.subject_code=class_t.subject_code\n\t\t \t\t\t\t\t\t\t\t\t\t\t\t\t\t AND class_t.class_id={$class_id}") or die("error selecting subject");
$row = mysql_fetch_assoc($query);
$credit_unit = $row['credit_unit'];
$total_hours = unit_to_time($credit_unit);
//insert codes for getting the current school year
$query_sched = mysql_query("SELECT * FROM class_schedule_temp_t WHERE schedule_id='{$schedule_id}'") or die("subj_func " . mysql_error());
$row_sched = mysql_fetch_assoc($query_sched);
$start = $row_sched['time_start'];
$end = $row_sched['time_end'];
$deduction = get_duration($start, $end);
$curr_hours = total_hours($class_id) - $deduction;
$curr_hours += $add_hours;
if ($total_hours < $curr_hours) {
return "Section has exceeded the maximum no. of load for the subject ({$curr_hours}/{$total_hours})";
} else {
return NULL;
}
}