function is_available_e($section_id, $subject_code, $teacher_id, $class_id) { $sy_id = get_active_sy(); //echo $sy_id; AND teacher_id={$teacher_id} $query = mysql_query("SELECT * FROM class_t \n\t\t\t\t\t\t\t\t WHERE subject_code={$subject_code}\n\t\t\t\t\t\t\t\t AND section_id={$section_id}\n\t\t\t\t\t\t\t\t AND sy_id={$sy_id}\n\t\t\t\t\t\t\t\t AND class_id<>{$class_id}") or die("hello"); $row = mysql_fetch_assoc($query); return mysql_num_rows($query) < 1 ? true : false; }
$emp_id = $_GET['emp_id']; } ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Schedule for</title> <link rel="stylesheet" href="css/tables.css" type="text/css" media="screen"/> <?php $color = array("#C6D9F0", "#DBE5F1", "#F2DCDB", "#EBF1DD", "#E5E0EC", "#DBEEF3", "#FDEADA", "#FBD5B5"); include '../db/db.php'; $sy_id = get_active_sy(); $query = mysql_query("SELECT * FROM class_t WHERE teacher_id={$_GET['emp_id']} AND sy_id={$sy_id}"); $class = array(); $i = 0; while ($row = mysql_fetch_assoc($query)) { $class_id = $row['class_id']; $class_color[$class_id] = $color[$i % 8]; $i++; } ?> </head> <body>
<!--</widget>--> </div> <!--</span>--> <div class="span4"> <a class="btn btn-large btn-success" href="report_section.php?section_id=<?php echo $_GET['section_id']; ?> &sy_id=<?php echo isset($_GET['sy_id']) ? $_GET['sy_id'] : get_active_sy(); ?> "><i class="icon-print"></i> PRINT </a> <a class="btn btn-large btn" target="_blank" href="pdf_section.php?section_id=<?php echo $_GET['section_id']; ?> &sy_id=<?php echo isset($_GET['sy_id']) ? $_GET['sy_id'] : get_active_sy(); ?> "><i class="icon-print"></i> PDF </a> </div> <!-- InstanceEndEditable --> <!-- /span6 --> </div> <!-- /row --> </div> <!-- /container --> </div>
?> "> <td><?php echo $row['section_no']; ?> </td> <td><?php echo $row['section_name']; ?> </td> <td><?php echo $row['section_size']; ?> </td> <td><?php echo section_students($section_id, get_active_sy()); ?> </td> <td><?php echo $row['curriculum_code']; ?> </td> <td align="center"> <!--<a class='btn btn-mini' href='section_edit.php?section_id=<?php echo $section_id; ?> '> EDIT </a>--> <a class='btn btn-mini' onClick="fillEditForm(<?php echo $section_id; ?> )" data-toggle="modal" href='#editSection'> <i class="icon-cog" ></i> EDIT </a>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <?php if (isset($_GET['emp_id'])) { $emp_id = $_GET['emp_id']; } include "actions/class_functions.php"; include "actions/subject_functions.php"; if (!isset($_GET['sy_id'])) { $school_yr = get_active_sy(); } else { $school_yr = $_GET['sy_id']; } ?> <html xmlns="http://www.w3.org/1999/xhtml" style="background-color:#FFF"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Teacher Report</title> <link type="text/css" rel="stylesheet" href="../css/bootstrap1.css" /> </head> <body style="background-color:#FFF"> <div style="width:95%; margin:10px auto;"> <div id="header" style="margin-bottom:20px; height:100px; overflow:hidden;"> <img style=" display:inline-block" src="../images/pnhs_logo.png" align="top" > <div style="display:inline-block;; border:0px solid black; height:100%; width:500px;font-weight:bold; padding-top:20px; padding-left:20px;"><h4>PAGASA NATIONAL HIGH SCHOOL</h4></div> </div> <div> <table width="100%" style="border:1px solid black;" cellmargin="0"> <tr>
<td><center><?php echo $row['section_name']; ?> </center></td> <td><center><?php echo $row['section_no']; ?> </center></td> <td><center><?php echo $row['section_size']; ?> </center></td> <td><center><?php echo section_students($section_id, get_active_sy()); $total_students += section_students($section_id, get_active_sy()); ?> </center></td> <td><center><?php echo $row['curriculum_code']; ?> </center></td> </tr> <?php } ?> </tbody> <tfoot>
function is_faculty_loaded_e($class_id, $start, $end, $days, $schedule_id) { $query = mysql_query("SELECT * FROM class_t WHERE class_id={$class_id}"); $row = mysql_fetch_assoc($query); $emp_id = $row['teacher_id']; if ($emp_id == NULL) { return ""; } $sy_id = get_active_sy(); foreach ($days as $day) { $query = mysql_query("SELECT * FROM class_schedule_t WHERE schedule_id <> {$schedule_id} AND day='{$day}' AND class_id IN (SELECT class_id FROM class_t WHERE teacher_id='{$emp_id}' AND sy_id={$sy_id}) ") or die(mysql_error() . " yeh"); while ($row = mysql_fetch_assoc($query)) { $db_start = $row['time_start']; $db_end = $row['time_end']; $t_start = strtotime($start); $t_end = strtotime($end); $t_db_start = strtotime($db_start); $t_db_end = strtotime($db_end); if ("conflict" == conflict_check($t_start, $t_end, $t_db_start, $t_db_end)) { $class_id = $row['class_id']; $query_subject = mysql_query("SELECT subject_t.subject_title FROM subject_t, class_t WHERE class_t.class_id={$class_id} AND subject_t.subject_code=class_t.subject_code"); $row_subject = mysql_fetch_assoc($query_subject); $subject = $row_subject['subject_title']; $st = date('h:i A', $t_db_start); $en = date('h:i A', $t_db_end); return "Teacher has conflicting schedule {$subject} @ {$st} - {$en}."; //$row_subject['subject_title']; } } } return ""; }
function is_teacher_max_e($emp_id, $subject_code_2add, $class_id) { if ($emp_id == "NULL") { return NULL; } $query = mysql_query("SELECT * FROM teacher_t WHERE emp_id='{$emp_id}'") or die("error selecting teach"); $row = mysql_fetch_assoc($query); $max_load = $row['max_load']; //insert codes for getting the current school year $sy_id = get_active_sy(); $total_units = 0; $query2 = mysql_query("SELECT * FROM class_t WHERE teacher_id='{$emp_id}' AND sy_id='{$sy_id}' AND class_id<>'{$class_id}'") or die(mysql_error()); while ($row2 = mysql_fetch_assoc($query2)) { $subject_code = $row2['subject_code']; $total_units += get_units($subject_code); } $total_units += get_units($subject_code_2add); if ($total_units > $max_load) { return "Teaching load exceeded the maximum allowed value ({$total_units}/{$max_load})"; } else { return NULL; } }