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; }