function display_consults()
{
if (func_num_args() > 0) {
$arg_list = func_get_args();
$report_date = $arg_list[0];
$patient_id = $arg_list[1];
//a handler for the patient ID
$end_report_date = $arg_list[2];
}
$arr_contents = array();
$sql = "select c.patient_id, c.consult_id, " . "concat(p.patient_lastname, ', ', p.patient_firstname,' ',p.patient_middle) patient_name, " . "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,1) patient_age, " . "p.patient_gender,date_format(c.consult_date,'%Y-%m-%d') as consult_date,date_format(p.patient_dob,'%m-%d-%Y') as pxdob " . "from m_consult c, m_patient p " . "where c.patient_id = p.patient_id " . "and c.consult_date BETWEEN '{$report_date} 00:00:00' AND '{$end_report_date} 23:59:00' ORDER by c.consult_date ASC";
$result = mysql_query($sql) or die("Cannot query: 456 " . mysql_error());
if ($result) {
if (mysql_num_rows($result)) {
$header = array('PATIENT ID', 'PATIENT NAME/SEX/BDAY/AGE', 'CONSULT DATE / ELAPSED TIME', 'ADDRESS', 'BRGY', 'FAMILY ID', 'PHILHEALTH ID', 'CCT/4P RECIPIENT', 'VITAL SIGNS', 'COMPLAINTS', 'DIAGNOSIS', 'TREATMENT');
$contents = array();
//print "<a href='../chits_query/pdf_reports/dailyservice_report.php'>PRINTER FRIENDLY VERSION</a><br/>";
print "<b><center>CONSULTS</center></b><br/>";
print "<table width='1000' cellspacing='0' cellpadding='2' style='border: 1px solid #000000'>";
print "<tr bgcolor='#FFCC33'>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['0']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['1']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['2']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['3']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['4']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['5']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['6']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['7']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['8']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['9']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['10']} </b></td>";
print "<td class='tinylight' valign='middle' align=center><b> {$header['11']} </b></td>";
print "</tr>";
while (list($pid, $consult_id, $pname, $age, $sex, $consult_date, $pxdob) = mysql_fetch_array($result)) {
$inner_record = array();
if ($fid = family::get_family_id($pid)) {
$addr = family::get_family_address($fid);
$barangay_id = family::barangay_id($family_id);
} else {
$fid = 0;
$barangay_id = 0;
$addr = family::get_family_address($fid);
}
$phid = philhealth::get_philhealth_id($pid);
$cct_member = family::check_cct($pid);
$cc = notes::get_complaints($pid, $consult_date, $consult_id);
$dx = notes::get_diagnosis_list($pid, $consult_date, $consult_id);
$tx = notes::get_plan($pid, $consult_date);
$q_brgy = mysql_query("SELECT c.barangay_name FROM m_family_members a, m_family_address b, m_lib_barangay c WHERE a.patient_id='{$pid}' AND a.family_id=b.family_id AND b.barangay_id=c.barangay_id") or die("Cannot query 451 " . mysql_error());
list($brgy) = mysql_fetch_array($q_brgy);
//for displaying the vitals signs
$selvitals = mysql_query("SELECT vitals_weight,vitals_temp,vitals_systolic,vitals_diastolic,vitals_heartrate,\n\t\t vitals_resprate, a.consult_id FROM m_consult a, m_consult_vitals b WHERE a.patient_id='{$pid}' AND a.consult_date BETWEEN '{$report_date} 00:00:00' AND '{$end_report_date} 23:59:59' AND a.consult_id=b.consult_id") or die(mysql_error());
$sel_elapsed = mysql_query("SELECT date_format(consult_date,'%m/%d/%Y %h:%i %p') as consult_start,date_format(consult_end,'%m/%d/%Y %h:%i %p') as consult_end, round((unix_timestamp(consult_end)-unix_timestamp(consult_date))/60,2) as consult_minutes FROM m_consult WHERE consult_id='{$consult_id}'") or die("Cannot query 531 " . mysql_error());
list($start, $end, $elapsed) = mysql_fetch_array($sel_elapsed);
$elapsed_time = $this->get_str_elapsed($start, $end, $elapsed);
$select_brgy = mysql_query("SELECT barangay_name from m_lib_barangay WHERE barangay_id='{$bgy}'") or die(mysql_error());
$resbrgy = mysql_fetch_array($select_brgy);
$res_vitals = mysql_fetch_array($selvitals);
$bp = empty($res_vitals[vitals_systolic]) && empty($res_vitals[vitals_diastolic]) ? '-' : $res_vitals[vitals_systolic] . '/' . $res_vitals[vitals_diastolic];
$count = mysql_num_rows($selvitals);
$bgcolor = $bgcolor == "#FFFF99" ? "white" : "#FFFF99";
print "<tr bgcolor='{$bgcolor}'>";
print "<td class='tinylight' align=center>" . $pid . "</td>";
print "<td class='tinylight' align=center>" . $pname . " / " . $sex . " / " . $pxdob . " / " . $age . "</td>";
print "<td class='tinylight' align=center>" . $elapsed_time . "</td>";
print "<td class='tinylight' align=center>" . $addr . "</td>";
//print "<td class='tinylight' align=center>".$resbrgy[barangay_name]."</td>";
print "<td class='tinylight' align=center>" . $brgy . "</td>";
print "<td class='tinylight' align=center>" . ($fid == 0 ? "-" : $fid) . "</td>";
print "<td class='tinylight' align=center>" . ($phid == 0 ? "-" : $phid) . "</td>";
print "<td class='tinylight' align=center>" . $cct_member . "</td>";
print "<td class='tinylight' align=center>BP: {$bp},\n\t\t HR: {$res_vitals['vitals_heartrate']},RR: {$res_vitals['vitals_resprate']},<br>\n\t\t Wt: {$res_vitals['vitals_weight']} kg,Temp: {$res_vitals['vitals_temp']}</td>";
// display the vital signs
print "<td class='tinylight' align=center>" . $cc . "</td>";
print "<td class='tinylight' align=center>" . $dx . "</td>";
print "<td class='tinylight' align=center>" . $tx . "</td>";
print "</tr>";
$vitals_sign = "BP: " . $bp . ", HR: " . $res_vitals[vitals_heartrate] . ",RR: " . $res_vitals[vitals_resprate] . ", Wt: " . $res_vitals[vitals_weight] . "kg, Temp: " . $res_vitals[vitals_temp];
//array_push($inner_record,array($pid,$pname." / ".$sex." / ".$pxdob.' / "..$age,$addr,$resbrgy[barangay_name],$brgy,$fid,$phid,'BP: '.$bp.', '.
//'HR: '.$res_vitals[vitals_heartrate].', RR: '. $res_vitals[vitals_resprate].', Wt:' $res_vitals[vitals_weight] kg.', Temp:'. $res_vitals[vitals_temp],$cc,$dx,$tx));
array_push($inner_record, array($pid, $pname . " / " . $sex . " / " . $pxdob . " / " . $age, $elapsed_time, $addr, $brgy, $fid, $phid, $cct_member, $vitals_sign, $cc, $dx, $tx));
array_push($contents, $inner_record);
}
print "</table>";
$_SESSION[tbl_header] = $header;
$_SESSION[daily_service_contents] = $contents;
$_SESSION[record_count] = mysql_num_rows($result);
array_push($arr_contents, $header, $contents, mysql_num_rows($result));
}
}
return $arr_contents;
}
