function process_inclusive_dates()
{
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);
}
$sql_delete = "delete from m_patient_epi_tcl";
$result_delete = mysql_query($sql_delete);
list($month, $day, $year) = explode("/", $post_vars["start_date"]);
$start_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
list($month, $day, $year) = explode("/", $post_vars["end_date"]);
$end_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
/*$sql = "select p.patient_id, p.patient_dob, concat(p.patient_lastname, ', ', p.patient_firstname) ".
"patient_name, p.patient_mother, ".
"date_format(adddate(p.patient_dob, interval 1 year), '%b %y') month_reaches_age1, m.fully_immunized_date ".
"from m_patient p, m_patient_ccdev m ".
"where p.patient_id = m.patient_id and ".
"to_days(adddate(p.patient_dob,interval 1 year)) >= to_days('$start_date') and ".
"to_days(adddate(p.patient_dob,interval 1 year)) <= to_days('$end_date') order by p.patient_dob ";
*/
/*$sql = "select patient_id, patient_dob, concat(patient_lastname, ', ', patient_firstname) ".
"patient_name, patient_mother, ".
"date_format(adddate(patient_dob, interval 1 year), '%b %y') month_reaches_age1 ".
"from m_patient ".
"where to_days(adddate(patient_dob,interval 1 year)) >= to_days('$start_date') and ".
"to_days(adddate(patient_dob,interval 1 year)) <= to_days('$end_date') order by patient_dob ";*/
$sql = "select patient_id, patient_dob, concat(patient_lastname, ', ', patient_firstname) " . "patient_name, patient_mother, " . "date_format(adddate(patient_dob, interval 1 year), '%b %y') month_reaches_age1 " . "from m_patient " . "where to_days(registration_date) >= to_days('{$start_date}') and " . "to_days(registration_date) <= to_days('{$end_date}') order by registration_date ";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
while ($report = mysql_fetch_array($result)) {
// blank variables
$patient_age = patient::get_age($report[patient_id]);
if ($patient_age <= 1) {
$family_id = 0;
$patient_address = '';
$barangay_id = '';
// retrieve other data
$family_id = family::get_family_id($report["patient_id"]);
if ($family_id) {
$patient_address = family::show_address($family_id);
$barangay_id = family::barangay_id($family_id);
}
$fully_immunized_date = $this->get_fully_immunized_date($report[patient_id]);
// insert data into tcl
$sql_insert = "insert into m_patient_epi_tcl (patient_id, patient_dob, family_id, patient_name, " . "patient_mother, patient_address, barangay_name, month_reaches_age1, " . "fully_immunized_date) values ('" . $report["patient_id"] . "', " . "'" . $report["patient_dob"] . "', '{$family_id}', '" . $report["patient_name"] . "', " . "'" . $report["patient_mother"] . "', '{$patient_address}', '{$barangay_id}', " . "'" . $report["month_reaches_age1"] . "', '{$fully_immunized_date}')";
$result_insert = mysql_query($sql_insert) or die(mysql_error());
$this->get_vaccine_date($report["patient_id"], $start_date, $end_date);
}
}
// while
$sql = "select patient_id 'PATIENT ID', date_format(patient_dob,'%c/%e/%y') 'DATE OF BIRTH', " . "family_id 'FAMILY ID', patient_name 'NAME OF INFANT', patient_mother 'NAME OF MOTHER', " . "patient_address 'ADDRESS', barangay_name 'BRGY', month_reaches_age1 'MONTH REACHES AGE 1', " . "fully_immunized_date 'DATE FULLY IMMUNIZED', " . "BCG 'BCG', DPT1 'DPT 1', " . "DPT2 'DPT 2', DPT3 'DPT 3', " . "OPV1 'POLIO 1', OPV2 'POLIO 2', " . "OPV3 'POLIO 3', MSL 'MEASLES', " . "HEPB1 'HEPA B1', HEPB2 'HEPA B2', " . "HEPB3 'HEPA B3' " . "from m_patient_epi_tcl order by barangay_name, patient_dob ";
//"where to_days(actual_vaccine_date) >= to_days('$start_date') and ".
//"to_days(actual_vaccine_date) <= to_days('$end_date') ".
//"order by barangay_name, patient_dob ";
$pdf = new PDF('L', 'pt', 'Legal');
//$pdf->SetMargins('0.5','0.5','0.5');
$pdf->SetFont('Arial', '', 10);
//$pdf->SetMargins('0.5','0.5','0.5');
$pdf->AliasNbPages();
$pdf->connect('localhost', 'root', '', 'game');
$attr = array('titleFontSize' => 14, 'titleText' => 'TARGET CLIENT LIST FOR EPI (' . $post_vars["start_date"] . ' - ' . $post_vars["end_date"] . ')');
$pdf->mysql_report($sql, false, $attr, "../modules/_uploads/epi_tcl.pdf");
header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&report_menu=TCL");
}
}
}
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 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 process_inclusive_dates()
{
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);
}
$sql_delete = "delete from m_patient_mc_prenatal_tcl";
$result_delete = mysql_query($sql_delete) or die(mysql_error());
$sql_delete = "delete from m_patient_mc_postpartum_tcl";
$result_delete = mysql_query($sql_delete) or die(mysql_error());
list($month, $day, $year) = explode("/", $post_vars["start_date"]);
$start_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
list($month, $day, $year) = explode("/", $post_vars["end_date"]);
$end_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
// prenatal
$get_prenatal = mysql_query("SELECT\n m.mc_id, \n p.registration_date,\n p.patient_id,\n concat(p.patient_lastname,', ',p.patient_firstname) patient_name,\n m.patient_lmp,\n m.obscore_gp,\n m.patient_edc,\n m.trimester1_date,\n m.trimester2_date,\n m.trimester3_date,\n date_format(m.delivery_date, '%c/%e/%y') delivery_date,\n m.outcome_id, \n m.birthweight,\n m.delivery_location,\n round((to_days(now())-to_days(p.patient_dob))/365,2) patient_age,\n m.birthmode\n FROM m_patient p, m_patient_mc m\n WHERE p.patient_id = m.patient_id AND\n to_days(p.registration_date) >= to_days('{$start_date}') AND\n to_days(p.registration_date) <= to_days('{$end_date}') AND\n m.delivery_date = '0000-00-00'") or die(mysql_error());
/*$sql = "select m.mc_id, p.registration_date, p.patient_id, concat(p.patient_lastname, ', ', p.patient_firstname) ".
"patient_name, m.patient_lmp, m.obscore_gp, m.patient_edc, m.trimester1_date, m.trimester2_date, ".
"m.trimester3_date, date_format(m.delivery_date, '%c/%e/%y') delivery_date, m.outcome_id, m.birthweight, ".
"m.delivery_location, ".
"m.breastfeeding_asap, round((to_days(now())-to_days(p.patient_dob))/365,2) patient_age, ".
"adddate(m.delivery_date, interval 28 day) postpartum_wk4, ".
"adddate(m.delivery_date, interval 42 day) postpartum_wk6, m.birthmode ".
"from m_patient p, m_patient_mc m ".
"where p.patient_id = m.patient_id and ".
"to_days(p.registration_date) >= to_days('$start_date') and ".
"to_days(p.registration_date) <= to_days('$end_date') "; */
if ($get_prenatal) {
if (mysql_num_rows($get_prenatal)) {
while ($prenatal = mysql_fetch_array($get_prenatal)) {
// blank variables
$family_id = '';
$patient_address = '';
$barangay_id = '';
// retrieve other data
$family_id = family::get_family_id($prenatal["patient_id"]);
if ($family_id != '0') {
$patient_address = family::show_address($family_id);
$barangay_id = family::barangay_id($family_id);
}
if ($prenatal[birthweight] == '0') {
$birthweight = '';
} else {
$birthweight = $prenatal[birthweight];
}
if ($prenatal[delivery_date] == '0/0/00') {
$delivery_date = '';
} else {
$delivery_date = $prenatal[delivery_date];
}
$fully_immunized_date = $this->get_fully_immunized_tt_date($prenatal["patient_id"]);
$tt_vaccines = $this->get_tt_vaccines($prenatal["patient_id"]);
$risk_id_date = $this->get_risk_id_date($prenatal["patient_id"]);
$iron_date = $this->get_iron_date($prenatal["patient_id"]);
/*$vita_date = $this->get_vita_date($report["patient_id"]);
$home_visit_dates = $this->get_home_visit_dates($report["patient_id"]);
$clinic_visit_dates = $this->get_clinic_visit_dates($report["patient_id"],$report[postpartum_wk4],$report[postpartum_wk6]);*/
$trimester1_visit_dates = $this->get_trimester1_visit_dates($prenatal["patient_id"], $prenatal["trimester1_date"], $prenatal["patient_lmp"]);
$trimester2_visit_dates = $this->get_trimester2_visit_dates($prenatal["patient_id"], $prenatal["trimester2_date"], $prenatal["trimester1_date"]);
$trimester3_visit_dates = $this->get_trimester3_visit_dates($prenatal["patient_id"], $prenatal["trimester3_date"], $prenatal["trimester2_date"]);
//$breastfeeding_date = $this->get_breastfeeding_date($report["patient_id"]);
$attendant = $this->get_attendant($prenatal[birthmode]);
//insert data into prenatal tcl
$sql_insert = "insert into m_patient_mc_prenatal_tcl (mc_id, patient_id, registration_date, family_id, patient_name, " . "patient_age, patient_address, barangay_name, patient_lmp, obscore_gp, patient_edc, " . "trimester1_visit_dates, trimester2_visit_dates, trimester3_visit_dates, risk_id_date, " . "fully_immunized_date, TT_vaccine_dates, IRON, delivery_date, outcome_id, birthweight, " . "delivery_location, attendant_name) values ('" . $prenatal["mc_id"] . "', " . "'" . $prenatal["patient_id"] . "', '" . $prenatal["registration_date"] . "', " . "'{$family_id}', '" . $prenatal["patient_name"] . "', '" . $prenatal["patient_age"] . "', " . "'{$patient_address}', '{$barangay_id}', '" . $prenatal["patient_lmp"] . "', " . "'" . $prenatal["obscore_gp"] . "', '" . $prenatal["patient_edc"] . "', " . "'{$trimester1_visit_dates}', '{$trimester2_visit_dates}', " . "'{$trimester3_visit_dates}', '{$risk_id_date}', '{$fully_immunized_date}', " . "'{$tt_vaccines}', '{$iron_date}', '{$delivery_date}', " . "'" . $prenatal["outcome_id"] . "', '{$birthweight}', " . "'" . $prenatal["delivery_location"] . "', '{$attendant}')";
$result_insert = mysql_query($sql_insert) or die(mysql_error());
/*$sql_insert = "insert into m_patient_mc_postpartum_tcl (mc_id, patient_id, family_id, patient_name, ".
"patient_age, patient_address, barangay_name, postpartum_wk4, postpartum_wk6, ".
"date_started_breastfeeding, postpartum_home_visit, postpartum_clinic_visit, ".
"IRON, VITA) values ('".$report["mc_id"]."', '".$report["patient_id"]."', ".
"'$family_id', '".$report["patient_name"]."', '".$report["patient_age"]."', ".
"'$patient_address', '$barangay_id', '".$report["postpartum_wk4"]."', ".
"'".$report["postpartum_wk6"]."', '$breastfeeding_date','$home_visit_dates', ".
"'$clinic_visit_dates', '$iron_date', '$vita_date')";
$result_insert = mysql_query($sql_insert) or die(mysql_error());*/
}
// while
}
}
// get postpartum
/*$get_pp = mysql_query("SELECT
m.mc_id,
p.registration_date,
p.patient_id,
concat(p.patient_lastname,', ',p.patient_firstname) patient_name,
m.breastfeeding_asap,
round((to_days(now())-to_days(p.patient_dob))/365,2) patient_age,
adddate(m.delivery_date, interval 28 day) postpartum_wk4,
adddate(m.delivery_date, interval 42 day) postpartum_wk6
FROM m_patient p, m_patient_mc m
WHERE p.patient_id = m.patient_id AND
to_days(p.registration_date) >= to_days('$start_date') AND
to_days(p.registration_date) <= to_days('$end_date') AND
m.delivery_date <> '0000-00-00' ")
or die(mysql_error());*/
/*$get_pp = mysql_query("SELECT
m.mc_id,
p.registration_date,
p.patient_id,
concat(p.patient_lastname,', ',p.patient_firstname) patient_name,
m.breastfeeding_asap,
round((to_days(now())-to_days(p.patient_dob))/365,2) patient_age,
adddate(m.delivery_date, interval 28 day) postpartum_wk4,
adddate(m.delivery_date, interval 42 day) postpartum_wk6
FROM m_patient p, m_patient_mc m
WHERE p.patient_id = m.patient_id AND
to_days(m.postpartum_date) >= to_days('$start_date') AND
to_days(m.postpartum_date) <= to_days('$end_date') ")
or die(mysql_error());*/
$get_pp = mysql_query("SELECT\n m.mc_id,\n p.registration_date, pp.postpartum_date, pp.visit_sequence,\n p.patient_id,\n concat(p.patient_lastname,', ',p.patient_firstname) patient_name,\n m.breastfeeding_asap,\n round((to_days(now())-to_days(p.patient_dob))/365,2) patient_age,\n adddate(m.delivery_date, interval 28 day) postpartum_wk4,\n adddate(m.delivery_date, interval 42 day) postpartum_wk6\n FROM m_patient p, m_patient_mc m, m_consult_mc_postpartum pp\n WHERE p.patient_id = m.patient_id AND\n to_days(pp.postpartum_date) >= to_days('{$start_date}') AND\n to_days(pp.postpartum_date) <= to_days('{$end_date}') AND \n m.patient_id=pp.patient_id AND \n pp.visit_sequence='1'") or die(mysql_error());
if ($get_pp) {
if (mysql_num_rows($get_pp)) {
while ($pp = mysql_fetch_array($get_pp)) {
// blank variables
$family_id = '';
$patient_address = '';
$barangay_id = '';
// retrieve other data
$family_id = family::get_family_id($pp["patient_id"]);
if ($family_id != '0') {
$patient_address = family::show_address($family_id);
$barangay_id = family::barangay_id($family_id);
}
$vita_date = $this->get_vita_date($pp["patient_id"]);
$iron_date = $this->get_iron_date($pp["patient_id"]);
$home_visit_dates = $this->get_home_visit_dates($pp["patient_id"]);
$clinic_visit_dates = $this->get_clinic_visit_dates($pp["patient_id"], $pp[postpartum_wk4], $pp[postpartum_wk6]);
$breastfeeding_date = $this->get_breastfeeding_date($pp["patient_id"]);
// insert into postpartum tcl
$sql_insert = "insert into m_patient_mc_postpartum_tcl (mc_id, patient_id, family_id, patient_name, " . "patient_age, patient_address, barangay_name, postpartum_wk4, postpartum_wk6, " . "date_started_breastfeeding, postpartum_home_visit, postpartum_clinic_visit, " . "IRON, VITA) values ('" . $pp["mc_id"] . "', '" . $pp["patient_id"] . "', " . "'{$family_id}', '" . $pp["patient_name"] . "', '" . $pp["patient_age"] . "', " . "'{$patient_address}', '{$barangay_id}', '" . $pp["postpartum_wk4"] . "', " . "'" . $pp["postpartum_wk6"] . "', '{$breastfeeding_date}','{$home_visit_dates}', " . "'{$clinic_visit_dates}', '{$iron_date}', '{$vita_date}')";
$result_insert = mysql_query($sql_insert) or die(mysql_error());
}
}
}
$sql = "select date_format(registration_date, '%c/%e/%y') 'REGISTRATION DATE', " . "family_id 'FAMILY ID', concat(patient_name, ' / ', patient_age) 'NAME / AGE', " . "patient_address 'ADDRESS', barangay_name 'BRGY', date_format(patient_lmp, '%c/%e/%y') 'LMP', " . "obscore_gp 'G-P', date_format(patient_edc, '%c/%e/%y') 'EDC', " . "trimester1_visit_dates '1st TRIMESTER VISITS', " . "trimester2_visit_dates '2nd TRIMESTER VISITS', " . "trimester3_visit_dates '3rd TRIMESTER VISITS', " . "risk_id_date 'RISK CODE / DATE DETECTED', fully_immunized_date " . "'FULLY IMMUNIZED DATE', TT_vaccine_dates 'TT IMMUNIZATION GIVEN', " . "IRON 'IRON', delivery_date 'DATE TERMINATED', " . "outcome_id 'OUTCOME', birthweight 'BIRTH WEIGHT', delivery_location 'PLACE OF DELIVERY', " . "attendant_name 'ATTENDED BY' " . "from m_patient_mc_prenatal_tcl order by barangay_name, registration_date ";
$pdf = new PDF('L', 'pt', 'Legal');
$pdf->SetFont('Arial', '', 10);
$pdf->AliasNbPages();
$pdf->connect('localhost', 'root', 'root', 'cuartero');
$attr = array('titleFontSize' => 14, 'titleText' => 'TARGET CLIENT LIST FOR PRENATAL CARE (' . $post_vars["start_date"] . ' - ' . $post_vars["end_date"] . ')');
$pdf->mysql_report($sql, false, $attr, "../modules/_uploads/mc_prenatal_tcl.pdf");
header("location:" . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&report_menu=TCL");
$sql = "select family_id 'FAMILY ID', concat(patient_name, ' / ', patient_age) 'NAME / AGE', " . "patient_address 'ADDRESS', barangay_name 'BRGY', date_format(postpartum_wk4, '%c/%e/%y') '4TH PP WK', " . "date_format(postpartum_wk6, '%c/%e/%y') '6TH PP WK', " . "postpartum_home_visit 'DATES OF POSTPARTUM CARE HOME VISITS', " . "postpartum_clinic_visit 'DATES OF POSTPARTUM CARE CLINIC CHECK-UP BTW 4-6 WKS PP', " . "date_started_breastfeeding 'DATE STARTED BREASTFEEDING', " . "IRON 'IRON', VITA 'VITAMIN A' " . "from m_patient_mc_postpartum_tcl order by barangay_name, patient_name ";
$pdf = new PDF('L', 'pt', 'Legal');
$pdf->SetFont('Arial', '', 12);
$pdf->AliasNbPages();
$pdf->connect('localhost', 'root', 'root', 'chits');
$attr = array('titleFontSize' => 14, 'titleText' => 'TARGET CLIENT LIST FOR POSTPARTUM CARE (' . $post_vars["start_date"] . ' - ' . $post_vars["end_date"] . ')');
$pdf->mysql_report($sql, false, $attr, "../modules/_uploads/mc_postpartum_tcl.pdf");
header("location:" . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&report_menu=TCL");
}
