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, date_format(p.patient_dob, '%Y-%m-%d'), round((to_days(c.consult_date)-to_days(p.patient_dob))/365,1) 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, date_format(p.patient_dob, '%Y-%m-%d'), round((to_days(c.consult_date)-to_days(p.patient_dob))/365,1) 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, date_format(p.patient_dob, '%Y-%m-%d'), round((to_days(c.consult_date)-to_days(p.patient_dob))/365,1) 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>";
healthcenter::show_tab_headers($arr_facility);
print "<table width=600 bgcolor='#FFFFFF' cellpadding='3' cellspacing='0' style='border: 2px solid black'>";
print "<tr>";
print "<td>";
print "<span class='tinylight'><b><span style='background-color:#FFFF00'>NAME</span> </b> - WILL SEE PHYSICIAN.</span>";
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");
$patient_count = 0;
while (list($cid, $pid, $plast, $pfirst, $see_doctor, $patient_dobx, $age) = 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";
} else {
$request_id = $done = "";
}
$visits = healthcenter::get_total_visits($pid);
$ptgroup = healthcenter::check_icons($pid, $cid, $consult_menu_id);
/*
if($age>=60){
$prio_color = '#006600';
}else{
if($_SESSION['mc_tag']>=1){
$prio_color= '#CC0033';
}else{
$prio_color ='#000000';
}
}
*/
if ($see_doctor == "Y") {
$style = "style='background-color:#FFFF00'";
} else {
$style = '';
}
$patient_elapsed = healthcenter::get_elapsedtime($cid);
$consult_array[$i] = "<tr><td {$style}><a style='text-decoration:none' 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='text-color: #FFFF33'" : "") . ">" . "<b>{$plast}, {$pfirst}</b></td></a><td style='text-align:center'>[{$visits}]</td><td style='text-align:center'>" . $patient_dobx . "</td><td align='center'>" . ($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>{$ptgroup}" : "<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>" . ($age >= 60 ? "<img src='../images/senior.jpg' width='20' height='20' />" : '') . "{$ptgroup}" : "" . ($age >= 60 ? "<img src='../images/senior.jpg' width='20' height='20' />" : '') . " {$ptgroup}") . "</td><td>{$patient_elapsed}</td>";
$i++;
$patient_count += 1;
}
// pass on patient list to be columnized
print healthcenter::display_todays_consult($consult_array);
} else {
print "<font color='red'>No consults available.</font>";
}
print "<tr>";
print "<td>";
print "Number of patients waiting: <b>" . $patient_count . "</b>";
print "</td>";
print "</tr>";
/*
$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>";
print "</td></tr>";
}
}
*/
print "</td>";
print "</tr>";
print "</table>";
}
}
