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 " . "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 / AGE', 'CONSULT DATE / ELAPSED TIME', 'ADDRESS', 'BRGY', 'FAMILY ID', 'PHILHEALTH ID', '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 "</tr>"; while (list($pid, $consult_id, $pname, $age, $sex, $consult_date) = 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); $cc = notes::get_complaints($pid, $consult_date); $dx = notes::get_diagnosis_list($pid, $consult_date); $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}' AND '{$end_report_date}' 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 . " / " . $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>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." / ".$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 . " / " . $age, $elapsed_time, $addr, $brgy, $fid, $phid, $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; }
function generate_summary() { 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); } list($month, $day, $year) = explode("/", $post_vars["report_date"]); //$report_date = $year."-".str_pad($month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); $report_date = $year.'-'.$month.'-'.str_pad($day, 2, "0", STR_PAD_LEFT); list($end_month, $end_day, $end_year) = explode("/", $post_vars["end_report_date"]); //$end_report_date = $end_year."-".str_pad($end_month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); $end_report_date = $end_year.'-'.$end_month.'-'.str_pad($end_day, 2, "0", STR_PAD_LEFT); $_SESSION[report_date] = $report_date; $_SESSION[end_report_date] = $end_report_date; // STEP 1. empty report tables for given date $sql_delete = "delete from m_consult_report_dailyservice where service_date = '$report_date'"; $result_delete = mysql_query($sql_delete); $sql_delete = "delete from m_consult_ccdev_report_dailyservice where service_date = '$report_date'"; $result_delete = mysql_query($sql_delete); $sql_delete = "delete from m_consult_mc_report_dailyservice where service_date = '$report_date'"; $result_delete = mysql_query($sql_delete); // STEP 2. get all consults for specified report date // records are unique for patient_id and service_date /*$sql_patient = "select c.patient_id, c.consult_id, ". "concat(p.patient_lastname, ', ', p.patient_firstname) patient_name, ". "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,2) patient_age, ". "p.patient_gender ". "from m_consult c, m_patient p ". "where c.patient_id = p.patient_id ". "and to_days(c.consult_date) = to_days('$report_date')"; */ $sql_patient = "select c.patient_id, c.consult_id, ". "concat(p.patient_lastname, ', ', p.patient_firstname) patient_name, ". "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,2) patient_age, ". "p.patient_gender ". "from m_consult c, m_patient p ". "where c.patient_id = p.patient_id ". "and c.consult_date BETWEEN '$report_date' AND '$end_report_date'"; $result_patient = mysql_query($sql_patient) or die("Cannot query: 305 ".mysql_error()); if ($result_patient) { if (mysql_num_rows($result_patient)) { while ($patient = mysql_fetch_array($result_patient)) { // get family and address if ($family_id = family::get_family_id($patient["patient_id"])) { $patient_address = family::get_family_address($family_id); $barangay_id = family::barangay_id($family_id); } else { $family_id = 0; $barangay_id = 0; $patient_address = reminder::get_home_address($patient_id); //$barangay_name = reminder::get_barangay($patient_id); } // get chief complaint and diagnosis from notes $complaints = notes::get_complaints($patient["patient_id"], $report_date); $diagnosis = notes::get_diagnosis_list($patient["patient_id"], $report_date); $treatment = notes::get_plan($patient["patient_id"], $report_date); //get vaccines $vaccines = $this->get_vaccines($patient["patient_id"], $report_date); $services = $this->get_services($patient["consult_id"], $patient["patient_id"], $report_date); $ptgroup = $this->get_ptgroup($patient["consult_id"], $report_date); $aog = $this->get_aog($patient["patient_id"], $report_date); $visit_seq = healthcenter::get_total_visits($patient["patient_id"]); $philhealth_id = philhealth::get_philhealth_id($patient["patient_id"]); if ($mc_id = mc::registry_record_exists($patient["patient_id"])) { $pp_weeks = mc::get_pp_weeks($mc_id, $patient["consult_id"]); //$visit_sequence = mc::get_ppvisit_sequence($mc_id, $patient["consult_id"]); } if ($complaints != '' || $diagnosis != '' || $treatment != '') { $sql_insert = "insert into m_consult_report_dailyservice (patient_id, patient_name, ". "patient_gender, patient_age, patient_address, patient_bgy, family_id, philhealth_id, ". "notes_cc, notes_dx, notes_tx, service_date) values ". "('".$patient["patient_id"]."', '".$patient["patient_name"]."', ". "'".$patient["patient_gender"]."', '".$patient["patient_age"]."', ". "'$patient_address', '$barangay_id', '$family_id', '$philhealth_id', ". "'$complaints', '$diagnosis', '$treatment', '$report_date')"; $result_insert = mysql_query($sql_insert); } if ($vaccines != '' || $services != '') { if ($ptgroup == 'CHILD') { $sql_insert = "insert into m_consult_ccdev_report_dailyservice (patient_id, ". "patient_name, patient_gender, patient_age, patient_address, patient_bgy, ". "family_id, philhealth_id, service_given, vaccine_given, service_date) values ". "('".$patient["patient_id"]."', '".$patient["patient_name"]."', ". "'".$patient["patient_gender"]."', '".$patient["patient_age"]."', ". "'$patient_address', '$barangay_id', '$family_id', '$philhealth_id', ". "'$services', '$vaccines', '$report_date')"; $result_insert = mysql_query($sql_insert); } if ($ptgroup == 'MATERNAL') { $sql_insert = "insert into m_consult_mc_report_dailyservice (patient_id, ". "patient_name, patient_gender, patient_age, aog_weeks, postpartum_weeks, patient_address, ". "patient_bgy, family_id, philhealth_id, visit_sequence, service_given, vaccine_given, ". "service_date) values ". "('".$patient["patient_id"]."', '".$patient["patient_name"]."', ". "'".$patient["patient_gender"]."', '".$patient["patient_age"]."', ". "'$aog', '$pp_weeks', '$patient_address', '$barangay_id', '$family_id', '$philhealth_id', ". "'$visit_seq', '$services', '$vaccines', '$report_date')"; $result_insert = mysql_query($sql_insert); } } } /*$sql = "select patient_id 'PATIENT ID', concat(patient_name,' / ',patient_gender,' / ',patient_age) ". "'NAME / SEX / AGE', patient_address 'ADDRESS', patient_bgy 'BRGY', family_id 'FAMILY ID', ". "philhealth_id 'PHILHEALTH ID', notes_cc 'COMPLAINTS', notes_dx 'DIAGNOSIS', notes_tx 'TREATMENT' ". "from m_consult_report_dailyservice where service_date = '$report_date' order by patient_name "; $pdf = new PDF('L','pt','A4'); $pdf->SetFont('Arial','',12); $pdf->AliasNbPages(); $pdf->connect('localhost','root','kambing','game'); $attr=array('titleFontSize'=>14,'titleText'=>'DAILY SERVICE REGISTER - CONSULTS'); $pdf->mysql_report($sql,false,$attr,"../modules/_uploads/consult_reg.pdf"); header("location:".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&report_menu=SUMMARY"); //$sql = "select patient_id 'PATIENT ID', concat(patient_name,' / ',patient_gender,' / ',patient_age) ". // "'NAME / SEX / AGE', patient_address 'ADDRESS', patient_bgy 'BRGY', family_id 'FAMILY ID', ". // "philhealth_id 'PHILHEALTH ID', vaccine_given 'VACCINE(S) GIVEN', service_given 'SERVICE(S) GIVEN' " // "from m_consult_ccdev_report_dailyservice where service_date = '$report_date' order by patient_name "; //$pdf = new PDF('L','pt','A4'); //$pdf->SetFont('Arial','',12); //$pdf->AliasNbPages(); //$pdf->connect('localhost','root','kambing','game'); //$attr=array('titleFontSize'=>14,'titleText'=>'DAILY SERVICE REGISTER - CHILD CARE SERVICES'); //$pdf->mysql_report($sql,false,$attr,"../modules/_uploads/consult_ccdev_reg.pdf"); //header("location:".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&report_menu=SUMMARY"); $sql = "select patient_id 'PATIENT ID', concat(patient_name,' / ',patient_gender,' / ',patient_age) ". "'NAME / SEX / AGE', aog_weeks 'AOG (wks)', postpartum_weeks 'POSTPARTUM WK', ". "patient_address 'ADDRESS', patient_bgy 'BRGY', family_id 'FAMILY ID', ". "philhealth_id 'PHILHEALTH ID', visit_sequence 'VISIT SEQ.', vaccine_given 'VACCINE(S) GIVEN', ". "service_given 'SERVICE(S) GIVEN' ". "from m_consult_mc_report_dailyservice where service_date = '$report_date' order by patient_name "; $pdf = new PDF('L','pt','A4'); $pdf->SetFont('Arial','',12); $pdf->AliasNbPages(); $pdf->connect('localhost','root','kambing','game'); $attr=array('titleFontSize'=>14,'titleText'=>'DAILY SERVICE REGISTER - MATERNAL CARE SERVICES'); $pdf->mysql_report($sql,false,$attr,"../modules/_uploads/consult_mc_reg.pdf"); header("location:".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&report_menu=SUMMARY"); */ } } //STEP 3. display daily service report print "<br/>"; print "<b>DAILY SERVICE REPORT</b><br/>"; print "REPORT DATE : <b>".$post_vars["report_date"]." to ".$post_vars["end_report_date"]."</b><br/><br/>"; $this->display_consults($report_date,"patient_id",$end_report_date); //pass the report_date and patient_id $this->display_ccdev($report_date); $this->display_mc($report_date); $sql = "select count(distinct(patient_id)) from m_consult where ". "to_days(consult_date) = to_days('$report_date') and patient_id != '0'"; $result = mysql_result(mysql_query($sql),0); print "<br/>"; print "Total No. of Today's Patients : $result"; }
function generate_summary() { 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); } list($month, $day, $year) = explode("/", $post_vars["report_date"]); $report_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); // STEP 1. empty report tables for given date $sql_delete = "delete from m_consult_report_dailyservice where service_date = '{$report_date}'"; $result_delete = mysql_query($sql_delete); $sql_delete = "delete from m_consult_ccdev_report_dailyservice where service_date = '{$report_date}'"; $result_delete = mysql_query($sql_delete); $sql_delete = "delete from m_consult_mc_report_dailyservice where service_date = '{$report_date}'"; $result_delete = mysql_query($sql_delete); // STEP 2. get all consults for specified report date // records are unique for patient_id and service_date $sql_patient = "select c.patient_id, c.consult_id, " . "concat(p.patient_lastname, ', ', p.patient_firstname) patient_name, " . "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,2) patient_age, " . "p.patient_gender " . "from m_consult c, m_patient p " . "where c.patient_id = p.patient_id " . "and to_days(c.consult_date) = to_days('{$report_date}')"; if ($result_patient = mysql_query($sql_patient)) { if (mysql_num_rows($result_patient)) { while ($patient = mysql_fetch_array($result_patient)) { // get family and address if ($family_id = family::get_family_id($patient["patient_id"])) { $patient_address = family::get_family_address($family_id); $barangay_name = family::barangay_name($family_id); } else { $family_id = 0; $patient_address = reminder::get_home_address($patient_id); $barangay_name = reminder::get_barangay($patient_id); } // get chief complaint and diagnosis from notes $complaints = notes::get_complaints($patient["patient_id"], $report_date); $diagnosis = notes::get_diagnosis_list($patient["patient_id"], $report_date); $treatment = notes::get_plan($patient["patient_id"], $report_date); //get vaccines $vaccines = $this->get_vaccines($patient["patient_id"], $report_date); $services = $this->get_services($patient["consult_id"], $patient["patient_id"], $report_date); $ptgroup = $this->get_ptgroup($patient["consult_id"], $report_date); $aog = $this->get_aog($patient["patient_id"], $report_date); $visit_seq = healthcenter::get_total_visits($patient["patient_id"]); if ($mc_id = mc::registry_record_exists($patient["patient_id"])) { $pp_weeks = mc::get_pp_weeks($mc_id, $patient["consult_id"]); //$visit_sequence = mc::get_ppvisit_sequence($mc_id, $patient["consult_id"]); } if ($complaints != '' || $diagnosis != '' || $treatment != '') { $sql_insert = "insert into m_consult_report_dailyservice (patient_id, patient_name, " . "patient_gender, patient_age, patient_address, patient_bgy, family_id, " . "notes_cc, notes_dx, notes_tx, service_date) values " . "('" . $patient["patient_id"] . "', '" . $patient["patient_name"] . "', " . "'" . $patient["patient_gender"] . "', '" . $patient["patient_age"] . "', " . "'{$patient_address}', '{$barangay_name}', '{$family_id}', " . "'{$complaints}', '{$diagnosis}', '{$treatment}', '{$report_date}')"; $result_insert = mysql_query($sql_insert); } if ($vaccines != '' || $services != '') { if ($ptgroup == 'CHILD') { $sql_insert = "insert into m_consult_ccdev_report_dailyservice (patient_id, " . "patient_name, patient_gender, patient_age, patient_address, patient_bgy, " . "family_id, service_given, vaccine_given, service_date) values " . "('" . $patient["patient_id"] . "', '" . $patient["patient_name"] . "', " . "'" . $patient["patient_gender"] . "', '" . $patient["patient_age"] . "', " . "'{$patient_address}', '{$barangay_name}', '{$family_id}', " . "'{$services}', '{$vaccines}', '{$report_date}')"; $result_insert = mysql_query($sql_insert); } if ($ptgroup == 'MATERNAL') { $sql_insert = "insert into m_consult_mc_report_dailyservice (patient_id, " . "patient_name, patient_gender, patient_age, aog_weeks, postpartum_weeks, patient_address, " . "patient_bgy, family_id, visit_sequence, service_given, vaccine_given, " . "service_date) values " . "('" . $patient["patient_id"] . "', '" . $patient["patient_name"] . "', " . "'" . $patient["patient_gender"] . "', '" . $patient["patient_age"] . "', " . "'{$aog}', '{$pp_weeks}', '{$patient_address}', '{$barangay_name}', '{$family_id}', '{$visit_seq}', " . "'{$services}', '{$vaccines}', '{$report_date}')"; $result_insert = mysql_query($sql_insert); } } } } } //STEP 3. display daily service report print "<br/>"; print "<b>DAILY SERVICE REPORT</b><br/>"; print "REPORT DATE : <b>" . $post_vars["report_date"] . "</b><br/><br/>"; $this->display_consults($report_date); $this->display_ccdev($report_date); $this->display_mc($report_date); $sql = "select count(distinct(patient_id)) from m_consult where " . "to_days(consult_date) = to_days('{$report_date}') and patient_id != '0'"; $result = mysql_result(mysql_query($sql), 0); print "<br/>"; print "Total No. of Today's Patients : {$result}"; }
function generate_summary() { 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); } list($month, $day, $year) = explode("/", $post_vars["report_date"]); $report_date = $year."-".str_pad($month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); // STEP 1. empty report table for given date print $sql_delete = "delete from m_consult_report_dailyservice where service_date = '$report_date'"; $result_delete = mysql_query($sql_delete); // STEP 2. get all consults for specified report date // records are unique for patient_id and service_date $sql_patient = "select c.patient_id, concat(p.patient_lastname, ', ', p.patient_firstname) patient_name, ". "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,2) patient_age, ". "p.patient_gender ". "from m_consult c, m_patient p ". "where c.patient_id = p.patient_id ". "and to_days(c.consult_date) = to_days('$report_date')"; if ($result_patient = mysql_query($sql_patient)) { if (mysql_num_rows($result_patient)) { while ($patient = mysql_fetch_array($result_patient)) { // get family and address if ($family_id = family::get_family_id($patient["patient_id"])) { $patient_address = family::get_family_address($family_id); $barangay_name = family::barangay_name($family_id); } else { $family_id = 0; $patient_address = reminder::get_home_address($patient_id); $barangay_name = reminder::get_barangay($patient_id); } // get chief complaint from notes $complaints = notes::get_complaints($patient["patient_id"], $report_date); // get notes dx list or icd10 list if (!$dx_list = icd10::get_icd10_list($patient["patient_id"], $report_date)) { $dx_list = notes::get_diagnosis_list($patient["patient_id"], $report_date); } // get treatment data from notes $plans = notes::get_plan($patient["patient_id"], $report_date); $sql_insert = "insert into m_consult_report_dailyservice (patient_id, patient_name, patient_gender, ". "patient_age, patient_address, patient_bgy, family_id, notes_cc, notes_dx, notes_tx, service_date) ". "values ('".$patient["patient_id"]."', '".$patient["patient_name"]."', ". "'".$patient["patient_gender"]."', '".$patient["patient_age"]."', ". "'$patient_address', '$barangay_name', '$family_id', '$complaints', ". "'$dx_list', '$plans', '$report_date')"; $result_insert = mysql_query($sql_insert); } } } }
function display_appointment_details() { 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]; //print_r($arg_list); } $sql = "select schedule_id, visit_date, consult_id, date_format(schedule_timestamp, '%a %d %b %Y, %h:%i%p') schedule_timestamp, user_id, ". "patient_id, appointment_id, reminder_flag, actual_date, to_days(visit_date)- to_days(actual_date) variance ". "from m_consult_appointments where schedule_id = '".$get_vars["schedule_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $appt = mysql_fetch_array($result); print "<a name='detail'>"; print "<table width='600' cellpadding='1'><tr valign='top'><td>"; // column 1 print "<form method='post' action='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&patient_id=".$get_vars["patient_id"]."&schedule_id=".$appt["schedule_id"]."&year=".$get_vars["year"]."&month=".$get_vars["month"]."&day=".$get_vars["day"]."&s=0'>"; print "<table width='300' bgcolor='#FFFFCC' cellpadding='3'><tr><td>"; print "<span class='PATIENT'>".strtoupper(patient::get_name($appt["patient_id"]))."</span><br/><br/>"; print "VISIT DATE: <font color='red'><b>".$appt["visit_date"]."</b></font><br/>"; print "ACTUAL DATE: <font color='red'><b>".($appt["actual_date"]=="0000-00-00"?"No visit yet":$appt["actual_date"])."</b></font><br/>"; if ($appt["actual_date"]<>"0000-00-00") { print "VARIANCE, DAYS: ".($appt["variance"]<0?"<font color='red'><b>".$appt["variance"]."</b></font>":$appt["variance"])."<br/>"; } print "REMINDER: ".$appt["reminder_flag"]."<br/>"; print "APPT SET BY: ".user::get_username($appt["user_id"])."<br/><br/>"; print "<span class='boxtitle'>APPT CODE</span><br/> ".appointment::get_appointment_name($appt["appointment_id"])."<br/><br/>"; /* print "<span class='boxtitle'>ACTUAL FOLLOWUP DATE</span><br/>"; if ($injury["injury_date"]) { list($year, $month, $day) = explode("-", $injury["injury_date"]); $injury_date = "$month/$day/$year"; } print "<input type='text' size='15' maxlength='10' class='textbox' name='injury_date' value='".($injury_date?$injury_date:$post_vars["injury_date"])."' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_consult_injury.injury_date', document.form_consult_injury.injury_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a><br>"; print "<small>Click on the calendar icon to select date. Otherwise use MM/DD/YYYY format.</small><br>"; print "<br/>"; */ if ($appt["actual_date"]=="0000-00-00") { print "<span class='boxtitle'>".LBL_DEFER_CONSULT."?</span><br/>"; print "<input type='checkbox' name='defer_consult' checked value='1'/> ".INSTR_DEFER_CONSULT."<br/><br/>"; } if ($_SESSION["priv_add"]) { if ($appt["actual_date"]=="0000-00-00") { print "<input type='submit' class='textbox' name='submitsked' value='Arrived' style='border: 1px solid black'/> "; } } if ($_SESSION["priv_delete"]) { print "<input type='submit' class='textbox' name='submitsked' value='Delete' style='border: 1px solid black'/> "; } print "<input type='hidden' name='schedule_id' value='".$get_vars["schedule_id"]."'/>"; print "<input type='hidden' name='consult_patient_id' value='".$appt["patient_id"]."'/>"; print "</td></tr></table></form>"; print "</td><td width='50%'>"; // column 2 // followup history // compute only for those who have followed up print "<b>".LBL_FOLLOW_UP_BEHAVIOR."</b><br/>"; $sql_hx = "select case when (to_days(visit_date)-to_days(actual_date)) >= 0 and actual_date <> '0000-00-00' then 'on time' ". "when (to_days(visit_date)-to_days(actual_date)) < 0 and actual_date <> '0000-00-00' then 'not on time' ". "when actual_date = '0000-00-00' then 'no follow up' ". "end status, count(schedule_id) times, round(avg(to_days(visit_date)-to_days(actual_date)),2) variance ". "from m_consult_appointments ". "where patient_id = ".$appt["patient_id"]." and ". "actual_date <> '0000-00-00' group by status"; if ($result_hx = mysql_query($sql_hx)) { if (mysql_num_rows($result_hx)) { print "<table width='300'>"; print "<tr valign='top'><td class='tinylight'><b>STATUS</b></td><td class='tinylight'><b>FREQUENCY</b></td><td class='tinylight'><b>AVE VARIANCE</b></td></tr>"; while (list($status, $times, $variance) = mysql_fetch_array($result_hx)) { print "<tr valign='top'><td class='tinylight'>$status</td><td class='tinylight'>$times</td><td class='tinylight'>$variance</td></tr>"; } print "</table><br/>"; } else { print "<font color='red'>No records to process</font><br/><br/>"; } } print "<b>".LBL_PATIENT_DETAILS."</b><br/><br/>"; print "<span class='tinylight'>"; print "<b>".FTITLE_FAMILY_INFO."</b><br/>"; $family_id = family::get_family_id($appt["patient_id"]); if ($family_id) { print "FAMILY ID: $family_id<br/>"; print "ADDRESS: ".family::get_family_address($family_id)."<br/>"; print "BARANGAY: ".family::barangay_name($family_id)."<br/>"; print "MEMBERS:<br/>".family::get_family_members($family_id)."<br/>"; } else { print "<font color='red'>No family record.</font><br/><br/>"; } print "<b>".FTITLE_PATIENT_GROUP_HX."</b><br/>"; $sql_ptgroup = "select count(c.ptgroup_id), g.ptgroup_name, g.ptgroup_module, c.ptgroup_id, c.consult_id ". "from m_consult_ptgroup c, m_lib_ptgroup g, m_consult h ". "where g.ptgroup_id = c.ptgroup_id and ". "h.consult_id = c.consult_id and ". "h.patient_id = '".$appt["patient_id"]."' ". "group by c.ptgroup_id"; if ($result = mysql_query($sql_ptgroup)) { if (mysql_num_rows($result)) { while (list($count, $name, $mod, $grp, $cid) = mysql_fetch_array($result)) { print "<img src='../images/arrow_redwhite.gif' border='0'/> "; print "$name: $count ".($count>1?" visits":"visit")."<br/> "; } } else { print "<font color='red'>No records.</font><br/>"; } } print "</span>"; print "</td></tr></table><br/>"; } } }