function consult_info() { if (func_num_args() > 0) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; $validuser = $arg_list[3]; $isadmin = $arg_list[4]; //print_r($arg_list); } $arr_facility = array(); if (mysql_num_rows(mysql_query("SHOW TABLES LIKE 'm_lib_health_facility_barangay'")) != 0) { $q_facility = mysql_query("SELECT DISTINCT(a.facility_id),b.facility_name FROM m_lib_health_facility_barangay a,m_lib_health_facility b WHERE a.facility_id=b.facility_id ORDER by b.facility_name ASC") or die("Cannot query 1226 " . mysql_error()); if (mysql_num_rows($q_facility) != 0) { while (list($facility_id, $facility_name) = mysql_fetch_array($q_facility)) { array_push($arr_facility, array($facility_id, $facility_name)); } } } if (empty($arr_facility)) { $result = mysql_query("select c.consult_id, p.patient_id, p.patient_lastname, p.patient_firstname, see_doctor_flag from m_consult c, m_patient p where c.patient_id = p.patient_id and consult_end = '0000-00-00 00:00:00' order by c.consult_date asc") or die("Cannot query 1241 " . mysql_error()); } else { if (!empty($_GET["facid"])) { $q_facid = mysql_query("SELECT a.barangay_id FROM m_lib_barangay a, m_lib_health_facility_barangay b WHERE b.facility_id='{$_GET['facid']}' AND a.barangay_id=b.barangay_id") or die("Cannot query 1246 " . mysql_error()); if (mysql_num_rows($q_facid) != 0) { $arr_brgy = array(); while (list($brgy_id) = mysql_fetch_array($q_facid)) { array_push($arr_brgy, $brgy_id); } $str_brgy = implode(",", $arr_brgy); $result = mysql_query("select c.consult_id, p.patient_id, p.patient_lastname, p.patient_firstname, see_doctor_flag from m_consult c, m_patient p, m_family_members x, m_family_address y, m_lib_barangay z where c.patient_id = p.patient_id and consult_end = '0000-00-00 00:00:00' AND p.patient_id=x.patient_id AND x.family_id=y.family_id AND y.barangay_id IN ({$str_brgy}) AND y.barangay_id=z.barangay_id order by c.consult_date asc") or die("Cannot query 1258 " . mysql_error()); } else { echo "<script language='Javascript'>"; echo "window.alert('Invalid health facility code!')"; echo "</script>"; } } else { $result = mysql_query("select c.consult_id, p.patient_id, p.patient_lastname, p.patient_firstname, see_doctor_flag from m_consult c, m_patient p where c.patient_id = p.patient_id and consult_end = '0000-00-00 00:00:00' order by c.consult_date asc") or die("Cannot query 1271 " . mysql_error()); } } if ($result) { print "<a name='consults'></a>"; print "<span class='patient'>" . FTITLE_CONSULTS_TODAY . "</span><br>"; healthcenter::show_tab_headers($arr_facility); print "<table width=600 bgcolor='#FFFFFF' cellpadding='3' cellspacing='0' style='border: 2px solid black'>"; print "<tr><td>"; print "<span class='tinylight'>HIGHLIGHTED NAMES OR THOSE MARKED WITH <img src='../images/star.gif' border='0'/> WILL SEE PHYSICIAN.</span><br/>"; if (mysql_num_rows($result)) { // initialize array index $i = 0; // have to return always to consult page // wherever this is shown $consult_menu_id = module::get_menu_id("_consult"); while (list($cid, $pid, $plast, $pfirst, $see_doctor) = mysql_fetch_array($result)) { $q_lab = mysql_query("SELECT request_id,request_done FROM m_consult_lab WHERE patient_id='{$pid}' AND consult_id='{$cid}'") or die("Cannot query 1224" . mysql_error()); if (mysql_num_rows($q_lab) != 0) { $arr_done = array(); $arr_id = array(); while (list($req_id, $done_status) = mysql_fetch_array($q_lab)) { array_push($arr_id, $req_id); array_push($arr_done, $done_status); } $done = in_array("N", $arr_done) ? "N" : "Y"; $request_id = $arr_id[0]; $url = "page=CONSULTS&menu_id=1327&consult_id={$cid}&ptmenu=LABS#consults"; } else { $request_id = $done = ""; } $visits = healthcenter::get_total_visits($pid); $consult_array[$i] = "<a href='" . $_SERVER["PHP_SELF"] . "?page=CONSULTS&menu_id={$consult_menu_id}&consult_id={$cid}&ptmenu=DETAILS' title='" . INSTR_CLICK_TO_VIEW_RECORD . "' " . ($see_doctor == "Y" ? "style='background-color: #FFFF33'" : "") . ">" . "<b>{$plast}, {$pfirst}</b></a> [{$visits}] " . ($see_doctor == "Y" ? "<img src='../images/star.gif' border='0'/>" : "") . ($request_id != "" ? $done == "Y" ? "<a href='{$_SERVER['PHP_SELF']}?{$url}' title='lab completed'><img src='../images/lab.png' width='15px' height='15px' border='0' alt='lab completed' /></a>" : "<a href='{$_SERVER['PHP_SELF']}?{$url}' title='lab pending'><img src='../images/lab_untested.png' width='15px' height='15px' border='0' alt='lab pending' /></a>" : ""); $i++; } // pass on patient list to be columnized print $this->columnize_list($consult_array); } else { print "<font color='red'>No consults available.</font>"; } $sql_time = "select round(avg(unix_timestamp(consult_end)-unix_timestamp(consult_date))/60,2) consult_minutes from m_consult where consult_end>0 and to_days(consult_date) = to_days(sysdate());"; if ($result_time = mysql_query($sql_time)) { if (mysql_num_rows($result_time)) { list($mean_consult_time) = mysql_fetch_array($result_time); } if ($mean_consult_time) { print "<tr><td class='tinylight'>"; if ($mean_consult_time > 60) { $unit_time = "hour(s)"; } elseif ($meantime > 1440) { $unit_time = "day(s)"; } else { $unit_time = "minute(s)"; } print "AVERAGE CONSULT TIME: <font color='red'>{$mean_consult_time} {$unit_time}</font><br/>"; print "</td></tr>"; } } print "</td></tr>"; print "</table>"; } }