function process_mc() { 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); } if ($post_vars["submitmc"]) { $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_age = patient::get_age($patient_id); if ($post_vars["lmp_date"]) { list($month, $day, $year) = explode("/", $post_vars["lmp_date"]); $lmp_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); } switch($post_vars["submitmc"]) { case "Save Risk Factor": if(empty($_POST[risk_date])): echo "<script language='Javascript'>"; echo "window.alert('Please supply date of when the risk factor was detected.')"; echo "</script>"; elseif(empty($get_vars[mc_id])): echo "<script language='Javascript'>"; echo "window.alert('Open a maternal record first!')"; echo "</script>"; else: list($month,$date,$year) = explode('/',$_POST[risk_date]); $risk_date = $year.'-'.$month.'-'.$date; $q_risk = mysql_query("SELECT visit_risk_id FROM m_consult_mc_visit_risk WHERE mc_id='$get_vars[mc_id]' AND visit_risk_id='$_POST[risk_code]' AND date_detected='$risk_date'") or die("Cannot query: 582"); if(mysql_num_rows($q_risk)==0): $insert_risk = mysql_query("INSERT INTO m_consult_mc_visit_risk SET consult_id='$get_vars[consult_id]',patient_id='$patient_id',mc_id='$get_vars[mc_id]',visit_risk_id='$_POST[risk_code]',date_detected='$risk_date',risk_timestamp=sysdate(),user_id='$_SESSION[userid]'") or die(mysql_error()); if($insert_risk): echo "<font color='red'>Record successfully added.</font>"; endif; else: echo "<font color='red'>Risk code and date already exists.</font>"; endif; endif; break; case "Delete Risk Factor"; if(isset($_POST[riskcode]) && $_POST[confirm_del]==1): while(list($risk_key,$risk_value)=each($_POST[riskcode])){ list($riskid,$mcid,$datedetected) = explode('*',$risk_value); $del_risk = mysql_query("DELETE FROM m_consult_mc_visit_risk WHERE mc_id='$mcid' AND visit_risk_id='$riskid' AND date_detected='$datedetected'") or die("Cannot query: 615"); } if($del_risk): echo "<font color='red'>Risk factor was successfully deleted.</font>"; header("Location: $_SERVER[PHP_SELF]?page=CONSULTS&menu_id=$get_vars[menu_id]&consult_id=$get_vars[consult_id]&ptmenu=DETAILS&module=mc&mc=RF&mc_id=$get_vars[mc_id]"); endif; endif; break; case "Save Prenatal Remarks": $update_prenatal = mysql_query("UPDATE m_patient_mc SET prenatal_remarks='$_POST[prenatal_remarks]' WHERE mc_id='$get_vars[mc_id]'") or die("Cannot query: 634"); if($update_prenatal): header("Location: $_SERVER[PHP_SELF]?page=CONSULTS&menu_id=$get_vars[menu_id]&consult_id=$get_vars[consult_id]&ptmenu=DETAILS&module=mc&mc=PREN&mc_id=$get_vars[mc_id]#prerem"); endif; break; case "Save Postpartum Remarks": $update_post = mysql_query("UPDATE m_patient_mc SET postpartum_remarks='$_POST[postpartum_remarks]' WHERE mc_id='$get_vars[mc_id]'") or die("Cannot query: 645"); if($update_post): header("Location: $_SERVER[PHP_SELF]?page=CONSULTS&menu_id=$get_vars[menu_id]&consult_id=$get_vars[consult_id]&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=$get_vars[mc_id]#postrem"); endif; break; case "Save Postpartum Visit": if ($post_vars["visit_date"] && $post_vars["visit_type"] && $post_vars["patient_systolic"] && $post_vars["patient_diastolic"]) { print_r($post_vars); $wk_count = mc::get_pp_week($post_vars["mc_id"],$post_vars["visit_date"]); if($wk_count>0): list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); $breastfeeding_flag = ($post_vars["breastfeeding_flag"]?"Y":"N"); $family_planning_flag = ($post_vars["family_planning_flag"]?"Y":"N"); $fever_flag = ($post_vars["fever_flag"]?"Y":"N"); $vaginal_infection_flag = ($post_vars["vaginal_infection_flag"]?"Y":"N"); $vaginal_bleeding_flag = ($post_vars["vaginal_bleeding_flag"]?"Y":"N"); $pallor_flag = ($post_vars["pallor_flag"]?"Y":"N"); $cord_ok_flag = ($post_vars["cord_ok_flag"]?"Y":"N"); $sql = "insert into m_consult_mc_postpartum (mc_id, consult_id, ". "patient_id, postpartum_timestamp, postpartum_date, user_id, ". "postpartum_week, visit_sequence, visit_type, ". "breastfeeding_flag, family_planning_flag, fever_flag, ". "vaginal_infection_flag, vaginal_bleeding_flag, ". "pallor_flag, cord_ok_flag, blood_pressure_systolic, ". "blood_pressure_diastolic) ". "values ('".$post_vars["mc_id"]."', '".$get_vars["consult_id"]."', ". "'$patient_id', sysdate(), '$visit_date', '".$_SESSION["userid"]."', ". "'".$wk_count."', '".$post_vars["visit_sequence"]."', ". "'".$post_vars["visit_type"]."', '$breastfeeding_flag', ". "'$family_planning_flag', '$fever_flag', '$vaginal_infection_flag', ". "'$vaginal_bleeding_flag', '$pallor_flag', '$cord_ok_flag', ". "'".$post_vars["patient_systolic"]."', '".$post_vars["patient_diastolic"]."')"; if ($result = mysql_query($sql)): header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=".$get_vars["ptmenu"]."&module=mc&mc=POSTP&mc_id=".$get_vars["mc_id"]); endif; else: echo "<font color='red'>Postpartum visit date should be after date of delivery.</font>"; endif; } else{ echo "<font color='red'>Postpartum visit not saved. Please check visit date, type of visit and systolic/diastolic.</font>"; } break; case "Update Postpartum Data Form": break; case "Update Postpartum": if ($post_vars["visit_date"] && $post_vars["visit_type"] && $post_vars["patient_systolic"] && $post_vars["patient_diastolic"]) { $wk_count = mc::get_pp_week($get_vars["mc_id"],$post_vars["visit_date"]); list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); $breastfeeding_flag = ($post_vars["breastfeeding_flag"]?"Y":"N"); $family_planning_flag = ($post_vars["family_planning_flag"]?"Y":"N"); $fever_flag = ($post_vars["fever_flag"]?"Y":"N"); $vaginal_infection_flag = ($post_vars["vaginal_infection_flag"]?"Y":"N"); $vaginal_bleeding_flag = ($post_vars["vaginal_bleeding_flag"]?"Y":"N"); $pallor_flag = ($post_vars["pallor_flag"]?"Y":"N"); $cord_ok_flag = ($post_vars["cord_ok_flag"]?"Y":"N"); if($wk_count>0): $sql = "update m_consult_mc_postpartum set ". "postpartum_date = '$visit_date', ". "postpartum_week = '$wk_count', ". "visit_type = '".$post_vars["visit_type"]."', ". "blood_pressure_systolic = '".$post_vars["patient_systolic"]."', ". "blood_pressure_diastolic = '".$post_vars["patient_diastolic"]."', ". "breastfeeding_flag = '$breastfeeding_flag', ". "family_planning_flag = '$family_planning_flag', ". "fever_flag = '$fever_flag', ". "vaginal_infection_flag = '$vaginal_infection_flag', ". "vaginal_bleeding_flag = '$vaginal_bleeding_flag', ". "pallor_flag = '$pallor_flag', ". "cord_ok_flag = '$cord_ok_flag' ". "where mc_id = '".$get_vars["mc_id"]."' and ". "visit_sequence = '".$post_vars["visit_sequence"]."' and ". "consult_id = '".$get_vars["consult_id"]."'"; $result = mysql_query($sql) or die("Cannot query: 721"); if ($result): header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=".$get_vars["mc_id"]."&ppvisitseq=".$get_vars["ppvisitseq"]); endif; else: echo "<font color='red'>Postpartum visit date should be after date of delivery.</font>"; endif; } else{ echo "<font color='red'>Postpartum visit not updated. Please check visit date, type of visit and systolic/diastolic.</font>"; } break; case "Delete Postpartum": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_postpartum ". "where mc_id = '".$get_vars["mc_id"]."' and ". "consult_id = '".$get_vars["consult_id"]."' and ". "visit_sequence = '".$post_vars["visit_sequence"]."'"; if ($result = mysql_query($sql)) { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=".$get_vars["mc_id"]); } } else { if ($post_vars["confirm_delete"]=="No") { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=".$get_vars["mc_id"]); } } break; case "Import Data": if ($post_vars["vaccines"]) { // remember, no need to update m_consult_vaccine // since these data are coming from that source! foreach($post_vars["vaccines"] as $key=>$value) { // get complete data from m_consult_vaccine $sql_vaccine = "select patient_id, consult_id, vaccine_id, actual_vaccine_date, adr_flag, vaccine_timestamp ". "from m_consult_vaccine ". "where patient_id = '".$post_vars["patient_id"]."' and ". "vaccine_id = '$value'"; if ($result_vaccine = mysql_query($sql_vaccine)) { if (mysql_num_rows($result_vaccine)) { while ($vaccine = mysql_fetch_array($result_vaccine)) { //$sql_import = "insert into m_consult_mc_vaccine (mc_id, consult_id, user_id, patient_id, vaccine_timestamp, actual_vaccine_date, vaccine_id) "."values ('".$post_vars["mc_id"]."', '".$vaccine["consult_id"]."', '".$_SESSION["userid"]."', '".$vaccine["patient_id"]."', sysdate(), '".$vaccine["actual_vaccine_date"]."', '".$vaccine["vaccine_id"]."')"; $sql_import = "INSERT INTO m_consult_mc_vaccine SET mc_id='$post_vars[mc_id]',consult_id='$vaccine[consult_id]',user_id='$_SESSION[userid]',patient_id='$vaccine[patient_id]',vaccine_timestamp='$vaccine[vaccine_timestamp]',actual_vaccine_date='$vaccine[actual_vaccine_date]',vaccine_id='$vaccine[vaccine_id]'"; // updating of imported vaccine! $result_import = mysql_query($sql_import) or die("Cannot query: 669"); } } } } } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=SVC&mc_id=".$get_vars["mc_id"]); break; case "Update Services": if ($post_vars["services"]) { foreach($post_vars["services"] as $key=>$value) { $sql = "insert into m_consult_mc_services (mc_id, consult_id, user_id, patient_id, mc_timestamp, service_id, visit_type) ". "values ('".$post_vars["mc_id"]."', '".$get_vars["consult_id"]."', '".$_SESSION["userid"]."', '$patient_id', sysdate(), '$value', '".$post_vars["visit_type"]."')"; $result = mysql_query($sql); } } if ($post_vars["vaccines"]) { foreach($post_vars["vaccines"] as $key=>$value) { $sql = "insert into m_consult_mc_vaccine (mc_id, consult_id, user_id, patient_id, vaccine_timestamp, actual_vaccine_date, vaccine_id) ". "values ('".$post_vars["mc_id"]."', '".$get_vars["consult_id"]."', '".$_SESSION["userid"]."', '$patient_id', sysdate(), sysdate(), '$value')"; $result = mysql_query($sql); // update patient vaccine record also $sql_vaccine = "insert into m_consult_vaccine (consult_id, patient_id, vaccine_id, user_id, vaccine_timestamp, actual_vaccine_date, source_module) ". "values ('".$get_vars["consult_id"]."', '$patient_id', '$value', '".$_SESSION["userid"]."', sysdate(), sysdate(), 'mc')"; $result_vaccine = mysql_query($sql_vaccine); } } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=SVC&mc_id=".$post_vars["mc_id"]); break; case "Save Data": if ($post_vars["lmp_date"] && $post_vars["obscore_gp"] && $post_vars["obscore_fpal"] && $post_vars["patient_height"]) { $sql = "insert into m_patient_mc (patient_id, consult_id, ". "mc_timestamp, mc_consult_date, patient_lmp, patient_edc, ". "trimester1_date, trimester2_date, trimester3_date, postpartum_date, ". "obscore_gp, obscore_fpal, ". "user_id, blood_type, patient_age, patient_height) ". "values ('$patient_id', '".$get_vars["consult_id"]."', ". "sysdate(), sysdate(), '$lmp_date', from_days(to_days('$lmp_date')+280), ". "from_days(to_days('$lmp_date')+93.3), from_days(to_days('$lmp_date')+186.67), from_days(to_days('$lmp_date')+280), from_days(to_days('$lmp_date')+322), ". "'".$post_vars["obscore_gp"]."', '".$post_vars["obscore_fpal"]."', '".$_SESSION["userid"]."', ". "'".$post_vars["bloodtype"]."', '$patient_age', ". "'".$post_vars["patient_height"]."')"; if ($result = mysql_query($sql)) { $insert_id = mysql_insert_id(); /*$tt_vacc = array('TT1','TT2','TT3','TT4','TT5'); for($j=0;$j<count($tt_vacc);$j++){ $check_TT = mysql_query("SELECT actual_vaccine_date, vaccine_id, consult_id,vaccine_timestamp,adr_flag FROM m_consult_vaccine WHERE patient_id='$patient_id' AND vaccine_id='$tt_vacc[$j]'") or die("Cannot query: 713"); if(mysql_num_rows($check_TT)>0): while($r_check_TT=mysql_fetch_array($check_TT)) { $q_mc_vacc = mysql_query("SELECT consult_id,patient_id,mc_id FROM m_consult_mc_vaccine WHERE consult_id='$r_check_TT[consult_id]' AND vaccine_timestamp='$r_check_TT[vaccine_timestamp]' AND vaccine_id='$r_check_TT[vaccine_id]'") or die(mysql_error()); if(mysql_num_rows($q_mc_vacc)==0): $insert_vacc = mysql_query("INSERT INTO m_consult_mc_vaccine SET mc_id='$insert_id',consult_id='$r_check_TT[consult_id]',patient_id='$patient_id',user_id='$_SESSION[userid]',vaccine_timestamp='$r_check_TT[vaccine_timestamp]',actual_vaccine_date='$r_check_TT[actual_vaccine_date]',adr_flag='$r_check_TT[adr_flag]',vaccine_id='$r_check_TT[vaccine_id]'") or die("Cannot query: 725"); $update_to_mc = mysql_query("UPDATE SET m_consult_vaccine SET source_module='mc' WHERE patient_id='$patient_id' AND consult_id='$r_check_TT[consult_id]' AND vaccine_id='$r_check_TT[vaccine_id]' AND vaccine_timestamp='$r_check_TT[vaccine_timestamp]'") or die(mysql_error()); else: echo 'test1'; endif; } else: echo 'test2'; endif; }*/ $date_ngayon = date('Y-m-d'); foreach($post_vars["risk"] as $key=>$value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected ". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '$insert_id', '$value', ". "sysdate(),$date_ngayon '".$_SESSION["userid"]."')"; $result_risk = mysql_query($sql_risk); } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=VISIT1&mc_id=$insert_id"); } } else { print "<font color='red'>Incomplete entries.</font><br/>"; } break; case "Update Data": if ($post_vars["lmp_date"] && $post_vars["obscore_gp"] && $post_vars["obscore_fpal"] && $post_vars["patient_height"]) { $sql = "update m_patient_mc set ". "patient_lmp = '$lmp_date', ". "patient_edc = from_days(to_days('$lmp_date')+280), ". "trimester1_date = from_days(to_days('$lmp_date')+93.3), ". "trimester2_date = from_days(to_days('$lmp_date')+186.67), ". "trimester3_date = from_days(to_days('$lmp_date')+280), ". "postpartum_date = from_days(to_days('$lmp_date')+322), ". "mc_timestamp = sysdate(), ". "obscore_gp = '".$post_vars["obscore_gp"]."', ". "obscore_fpal = '".$post_vars["obscore_fpal"]."', ". "patient_height = '".$post_vars["patient_height"]."', ". "blood_type = '".$post_vars["bloodtype"]."' ". "where mc_id = '".$post_vars["mc_id"]."'"; if ($result = mysql_query($sql)) { // delete risk factors first $sql_delete = "delete from m_consult_mc_visit_risk ". "where consult_id = '".$get_vars["consult_id"]."' and mc_id = '".$post_vars["mc_id"]."'"; $result_delete = mysql_query($sql_delete); // ...then update from form $date_ngayon = date('Y-m-d'); foreach($post_vars["risk"] as $key=>$value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected,". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(),$date_ngayon, '".$_SESSION["userid"]."')"; $result_risk = mysql_query($sql_risk); } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=VISIT1".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } else { print "<font color='red'>Incomplete entries.</font><br/>"; } break; case "Delete Data": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_patient_mc where mc_id = '".$post_vars["mc_id"]."'"; if ($result = mysql_query($sql)) { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=VISIT1".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } else { if ($post_vars["confirm_delete"]=="No") { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=VISIT1".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } break; case "Save Prenatal Data": $exists = mc::check_visit_date($post_vars["visit_date"],$post_vars[mc_id]); if ($post_vars["patient_systolic"] && $post_vars["patient_diastolic"] && $post_vars["patient_weight"] && $post_vars["visit_date"] && $exists!=1) { //if ($post_vars["data_import_flag"]) { list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); list($aog_weeks, $days) = mc::get_aog($post_vars["mc_id"], $visit_date); $aog_total = $aog_weeks + ($days/7); $data_type = "EXT"; //} else { /* $visit_date = healthcenter::get_consult_date($get_vars["consult_id"]); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); $trimester = $post_vars["trimester"]; $aog_total = $post_vars["aog_weeks"]; $data_type = "INT"; */ //} $sql = "insert into m_consult_mc_prenatal (mc_id, consult_id, patient_id, prenatal_timestamp, ". "prenatal_date, user_id, aog_weeks, trimester, visit_sequence, patient_weight, ". "blood_pressure_systolic, blood_pressure_diastolic, fhr, fhr_location, ". "fundic_height, presentation, data_type) values ('".$post_vars["mc_id"]."', ". "'".$get_vars["consult_id"]."', '$patient_id', '$visit_date', ". "'$visit_date', '".$_SESSION["userid"]."', '$aog_total', ". "'$trimester', '".$post_vars["visit_sequence"]."', ". "'".$post_vars["patient_weight"]."', '".$post_vars["patient_systolic"]."', ". "'".$post_vars["patient_diastolic"]."', '".$post_vars["fhr"]."', ". "'".$post_vars["fhr_location"]."', '".$post_vars["fundic_height"]."', ". "'".$post_vars["presentation"]."', '$data_type')"; $result = mysql_query($sql) or die("Cannot query: 840"); mc::reorder_prenatal_visits($post_vars["mc_id"]); if ($result) { // do not update for visit 1 if ($post_vars["visit_sequence"]>1) { // delete risk factors first but only the M flagged // caution use this only with MySQL version 4.+ $sql_delete = "delete from m_consult_mc_visit_risk ". "using m_consult_mc_visit_risk, m_lib_mc_risk_factors ". "where m_consult_mc_visit_risk.consult_id = '".$get_vars["consult_id"]."' ". "and m_consult_mc_visit_risk.mc_id = '".$post_vars["mc_id"]."' and ". "m_consult_mc_visit_risk.visit_risk_id = m_lib_mc_risk_factors.risk_id and ". "m_lib_mc_risk_factors.monitor_flag = 'Y'"; $result_delete = mysql_query($sql_delete); // ...then update from form foreach($post_vars["risk"] as $key=>$value) { /*$sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp, ". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(), '".$_SESSION["userid"]."')"; */ $date_ngayon = date('Y-m-d'); $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected,". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(),$date_ngayon,'".$_SESSION["userid"]."')"; } } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=PREN".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } break; case "Update Prenatal": //print_r($post_vars); $exists = mc::check_visit_date($post_vars["visit_date"],$post_vars[mc_id]); if ($post_vars["patient_systolic"] && $post_vars["patient_diastolic"] && $post_vars["patient_weight"] && $post_vars["fundic_height"] && $post_vars["fhr"] && $post_vars["fhr_location"] && $post_vars["presentation"] && $post_vars["visit_date"]) { list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); $sql = "update m_consult_mc_prenatal set ". "fundic_height = '".$post_vars["fundic_height"]."', ". "fhr = '".$post_vars["fhr"]."', ". "prenatal_date = '".$visit_date."', ". "fhr_location = '".$post_vars["fhr_location"]."', ". "trimester = '".$trimester."', ". "presentation = '".$post_vars["presentation"]."', ". "patient_weight = '".$post_vars["patient_weight"]."', ". "blood_pressure_systolic = '".$post_vars["patient_systolic"]."', ". "blood_pressure_diastolic = '".$post_vars["patient_diastolic"]."' ". "where mc_id = '".$post_vars["mc_id"]."' and visit_sequence = '".$post_vars["visit_sequence"]."'"; $result = mysql_query($sql) or die("Cannot update: 855"); if ($result) { // do not update for visit 1 if ($post_vars["visit_sequence"]>1) { // delete risk factors first but only the M flagged // caution use this only with MySQL version 4.+ /*$sql_delete = "delete from m_consult_mc_visit_risk ". "using m_consult_mc_visit_risk, m_lib_mc_risk_factors ". "where m_consult_mc_visit_risk.consult_id = '".$post_vars["consult_id"]."' ". "and m_consult_mc_visit_risk.mc_id = '".$post_vars["mc_id"]."' and ". "m_consult_mc_visit_risk.visit_risk_id = m_lib_mc_risk_factors.risk_id and ". "m_lib_mc_risk_factors.monitor_flag = 'Y'"; $result_delete = mysql_query($sql_delete); // ...then update from form foreach($post_vars["risk"] as $key=>$value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp, ". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(), '".$_SESSION["userid"]."')"; $result_risk = mysql_query($sql_risk); }*/ } header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=PREN".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } else{ echo 'Record was not updated'; } } else{ echo "Cannot update. Please complete the form."; } break; case "Delete Prenatal": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_prenatal where mc_id = '".$post_vars["mc_id"]."' and visit_sequence = '".$post_vars["visit_sequence"]."'"; if ($result = mysql_query($sql)) { // delete associated risk data for this prenatal visit // there is no referential integrity definition here... $sql_risk = "delete from m_consult_mc_visit_risk where mc_id = '".$post_vars["mc_id"]."' and consult_id = '".$post_vars["consult_id"]."'"; $result_risk = mysql_query($sql_risk); header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=PREN".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } else { if ($post_vars["confirm_delete"]=="No") { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=PREN".($post_vars["mc_id"]?"&mc_id=".$post_vars["mc_id"]:"")); } } break; case "Save Postpartum Data": if ($post_vars["delivery_date"] && $post_vars["delivery_location"] && $post_vars["outcome"] && $post_vars["birth_weight"] && $post_vars["attendant"]) { if(isset($_POST[breastfeeding_flag])): //naka-check if(empty($_POST[date_breastfed])): //no date but checked $datebreastfeed = 'n'; elseif($this->get_day_diff($_POST[date_breastfed],$post_vars["delivery_date"]) < 0): //check if date of breastfeeding occurs after the delivery date $datebreastfeed = 'w'; else: $datebreastfeed = 'y'; //set to yes is date_breastfed is not empty and not exceeding delivery date endif; else: $datebreastfeed = 'y'; //not checked, no need to check for date endif; if($datebreastfeed=='y'){ list($month, $day, $year) = explode("/", $post_vars["delivery_date"]); list($bmonth,$bday,$byr) = explode("/",$_POST["date_breastfed"]); $delivery_date = "$year-".str_pad($month,2,"0",STR_PAD_LEFT)."-".str_pad($day,2,"0",STR_PAD_LEFT); echo $delivery_date; if(isset($_POST[breastfeeding_flag])): $bfeed_date = "$byr-".str_pad($bmonth,2,"0",STR_PAD_LEFT)."-".str_pad($bday,2,"0",STR_PAD_LEFT); else: $bfeed_date = ''; endif; $healthy_baby = ($post_vars["healthy_baby_flag"]?"Y":"N"); $breastfeeding = ($post_vars["breastfeeding_flag"]?"Y":"N"); $end_pregnancy = ($post_vars["end_pregnancy_flag"]?"Y":"N"); // NOTE: update postpartum date from delivery date $sql = "update m_patient_mc set ". "delivery_date = '$delivery_date', ". "postpartum_date = from_days(to_days('$delivery_date')+42), ". "obscore_gp = '".$post_vars["obscore_gp"]."', ". "obscore_fpal = '".$post_vars["obscore_fpal"]."', ". "birthweight = '".$post_vars["birth_weight"]."', ". "child_patient_id = '".$post_vars["child_patient_id"]."', ". "delivery_location = '".$post_vars["delivery_location"]."', ". "outcome_id = '".$post_vars["outcome"]."', ". "healthy_baby = '$healthy_baby', ". "end_pregnancy_flag = '$end_pregnancy', ". "breastfeeding_asap = '$breastfeeding', ". "date_breastfed = '$bfeed_date', ". "birthmode = '".$post_vars["attendant"]."' ". "where mc_id = '".$get_vars["mc_id"]."'"; $result = mysql_query($sql) or die("Cannot query: 1068"); if ($result) { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=".$get_vars["mc_id"]); } } else{ echo "<script language='Javascript'>"; if($datebreastfeed=='n'): echo "window.alert('Record not saved. Please indicate the date of breastfeeding if the baby was breastfed ASAP.')"; else: //w ito echo "window.alert('Record not saved. Date of breastfeeding should be on or after date of delivery.')"; endif; echo "</script>"; } }else{ echo "<script language='Javascript'>"; echo "window.alert('Record not saved. Please complete REQUIRED fields.')"; echo "</script>"; } break; } } }
function process_mc() { 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); } if ($post_vars["submitmc"]) { $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_age = patient::get_age($patient_id); if ($post_vars["lmp_date"]) { list($month, $day, $year) = explode("/", $post_vars["lmp_date"]); $lmp_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); } switch ($post_vars["submitmc"]) { case "Save Risk Factor": if (empty($_POST[risk_date])) { echo "<script language='Javascript'>"; echo "window.alert('Please supply date of when the risk factor was detected.')"; echo "</script>"; } elseif (empty($get_vars[mc_id])) { echo "<script language='Javascript'>"; echo "window.alert('Open a maternal record first!')"; echo "</script>"; } else { list($month, $date, $year) = explode('/', $_POST[risk_date]); $risk_date = $year . '-' . $month . '-' . $date; $q_risk = mysql_query("SELECT visit_risk_id FROM m_consult_mc_visit_risk WHERE mc_id='{$get_vars['mc_id']}' AND visit_risk_id='{$_POST['risk_code']}' AND date_detected='{$risk_date}'") or die("Cannot query: 582"); if (mysql_num_rows($q_risk) == 0) { $insert_risk = mysql_query("INSERT INTO m_consult_mc_visit_risk SET consult_id='{$get_vars['consult_id']}',patient_id='{$patient_id}',mc_id='{$get_vars['mc_id']}',visit_risk_id='{$_POST['risk_code']}',date_detected='{$risk_date}',risk_timestamp=sysdate(),user_id='{$_SESSION['userid']}'") or die(mysql_error()); if ($insert_risk) { echo "<font color='red'>Record successfully added.</font>"; } } else { echo "<font color='red'>Risk code and date already exists.</font>"; } } break; case "Delete Risk Factor": if (isset($_POST[riskcode]) && $_POST[confirm_del] == 1) { while (list($risk_key, $risk_value) = each($_POST[riskcode])) { list($riskid, $mcid, $datedetected) = explode('*', $risk_value); $del_risk = mysql_query("DELETE FROM m_consult_mc_visit_risk WHERE mc_id='{$mcid}' AND visit_risk_id='{$riskid}' AND date_detected='{$datedetected}'") or die("Cannot query: 615"); } if ($del_risk) { echo "<font color='red'>Risk factor was successfully deleted.</font>"; header("Location: {$_SERVER['PHP_SELF']}?page=CONSULTS&menu_id={$get_vars['menu_id']}&consult_id={$get_vars['consult_id']}&ptmenu=DETAILS&module=mc&mc=RF&mc_id={$get_vars['mc_id']}"); } } break; case "Save Prenatal Remarks": $update_prenatal = mysql_query("UPDATE m_patient_mc SET prenatal_remarks='{$_POST['prenatal_remarks']}' WHERE mc_id='{$get_vars['mc_id']}'") or die("Cannot query: 634"); if ($update_prenatal) { header("Location: {$_SERVER['PHP_SELF']}?page=CONSULTS&menu_id={$get_vars['menu_id']}&consult_id={$get_vars['consult_id']}&ptmenu=DETAILS&module=mc&mc=PREN&mc_id={$get_vars['mc_id']}#prerem"); } break; case "Save Postpartum Remarks": $update_post = mysql_query("UPDATE m_patient_mc SET postpartum_remarks='{$_POST['postpartum_remarks']}' WHERE mc_id='{$get_vars['mc_id']}'") or die("Cannot query: 645"); if ($update_post) { header("Location: {$_SERVER['PHP_SELF']}?page=CONSULTS&menu_id={$get_vars['menu_id']}&consult_id={$get_vars['consult_id']}&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id={$get_vars['mc_id']}#postrem"); } break; case "Save Postpartum Visit": if ($post_vars["visit_date"] && $post_vars["visit_type"] && $post_vars["patient_systolic"] && $post_vars["patient_diastolic"]) { //print_r($post_vars); $wk_count = mc::get_pp_week($post_vars["mc_id"], $post_vars["visit_date"]); if ($wk_count > 0) { list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $breastfeeding_flag = $post_vars["breastfeeding_flag"] ? "Y" : "N"; $family_planning_flag = $post_vars["family_planning_flag"] ? "Y" : "N"; $fever_flag = $post_vars["fever_flag"] ? "Y" : "N"; $vaginal_infection_flag = $post_vars["vaginal_infection_flag"] ? "Y" : "N"; $vaginal_bleeding_flag = $post_vars["vaginal_bleeding_flag"] ? "Y" : "N"; $pallor_flag = $post_vars["pallor_flag"] ? "Y" : "N"; $cord_ok_flag = $post_vars["cord_ok_flag"] ? "Y" : "N"; $sql = "insert into m_consult_mc_postpartum (mc_id, consult_id, " . "patient_id, postpartum_timestamp, postpartum_date, user_id, " . "postpartum_week, visit_sequence, visit_type, " . "breastfeeding_flag, family_planning_flag, fever_flag, " . "vaginal_infection_flag, vaginal_bleeding_flag, " . "pallor_flag, cord_ok_flag, blood_pressure_systolic, " . "blood_pressure_diastolic) " . "values ('" . $post_vars["mc_id"] . "', '" . $get_vars["consult_id"] . "', " . "'{$patient_id}', sysdate(), '{$visit_date}', '" . $_SESSION["userid"] . "', " . "'" . $wk_count . "', '" . $post_vars["visit_sequence"] . "', " . "'" . $post_vars["visit_type"] . "', '{$breastfeeding_flag}', " . "'{$family_planning_flag}', '{$fever_flag}', '{$vaginal_infection_flag}', " . "'{$vaginal_bleeding_flag}', '{$pallor_flag}', '{$cord_ok_flag}', " . "'" . $post_vars["patient_systolic"] . "', '" . $post_vars["patient_diastolic"] . "')"; if ($result = mysql_query($sql)) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=" . $get_vars["ptmenu"] . "&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } } else { echo "<font color='red'>Postpartum visit date should be after date of delivery.</font>"; } } else { echo "<font color='red'>Postpartum visit not saved. Please check visit date, type of visit and systolic/diastolic.</font>"; } break; case "Update Postpartum Data Form": break; case "Update Postpartum": if ($post_vars["visit_date"] && $post_vars["visit_type"] && $post_vars["patient_systolic"] && $post_vars["patient_diastolic"]) { $wk_count = mc::get_pp_week($get_vars["mc_id"], $post_vars["visit_date"]); list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $breastfeeding_flag = $post_vars["breastfeeding_flag"] ? "Y" : "N"; $family_planning_flag = $post_vars["family_planning_flag"] ? "Y" : "N"; $fever_flag = $post_vars["fever_flag"] ? "Y" : "N"; $vaginal_infection_flag = $post_vars["vaginal_infection_flag"] ? "Y" : "N"; $vaginal_bleeding_flag = $post_vars["vaginal_bleeding_flag"] ? "Y" : "N"; $pallor_flag = $post_vars["pallor_flag"] ? "Y" : "N"; $cord_ok_flag = $post_vars["cord_ok_flag"] ? "Y" : "N"; if ($wk_count > 0) { $sql = "update m_consult_mc_postpartum set " . "postpartum_date = '{$visit_date}', " . "postpartum_week = '{$wk_count}', " . "visit_type = '" . $post_vars["visit_type"] . "', " . "blood_pressure_systolic = '" . $post_vars["patient_systolic"] . "', " . "blood_pressure_diastolic = '" . $post_vars["patient_diastolic"] . "', " . "breastfeeding_flag = '{$breastfeeding_flag}', " . "family_planning_flag = '{$family_planning_flag}', " . "fever_flag = '{$fever_flag}', " . "vaginal_infection_flag = '{$vaginal_infection_flag}', " . "vaginal_bleeding_flag = '{$vaginal_bleeding_flag}', " . "pallor_flag = '{$pallor_flag}', " . "cord_ok_flag = '{$cord_ok_flag}' " . "where mc_id = '" . $get_vars["mc_id"] . "' and " . "visit_sequence = '" . $post_vars["visit_sequence"] . "' and " . "consult_id = '" . $get_vars["consult_id"] . "'"; $result = mysql_query($sql) or die("Cannot query: 721"); if ($result) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"] . "&ppvisitseq=" . $get_vars["ppvisitseq"]); } } else { echo "<font color='red'>Postpartum visit date should be after date of delivery.</font>"; } } else { echo "<font color='red'>Postpartum visit not updated. Please check visit date, type of visit and systolic/diastolic.</font>"; } break; case "Delete Postpartum": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_postpartum " . "where mc_id = '" . $get_vars["mc_id"] . "' and " . "consult_id = '" . $get_vars["consult_id"] . "' and " . "visit_sequence = '" . $post_vars["visit_sequence"] . "'"; if ($result = mysql_query($sql)) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } } else { if ($post_vars["confirm_delete"] == "No") { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } } break; case "Import Data": if ($post_vars["vaccines"]) { // remember, no need to update m_consult_vaccine // since these data are coming from that source! foreach ($post_vars["vaccines"] as $key => $value) { // get complete data from m_consult_vaccine $sql_vaccine = "select patient_id, consult_id, vaccine_id, actual_vaccine_date, adr_flag, vaccine_timestamp " . "from m_consult_vaccine " . "where patient_id = '" . $post_vars["patient_id"] . "' and " . "vaccine_id = '{$value}'"; if ($result_vaccine = mysql_query($sql_vaccine)) { if (mysql_num_rows($result_vaccine)) { while ($vaccine = mysql_fetch_array($result_vaccine)) { //$sql_import = "insert into m_consult_mc_vaccine (mc_id, consult_id, user_id, patient_id, vaccine_timestamp, actual_vaccine_date, vaccine_id) "."values ('".$post_vars["mc_id"]."', '".$vaccine["consult_id"]."', '".$_SESSION["userid"]."', '".$vaccine["patient_id"]."', sysdate(), '".$vaccine["actual_vaccine_date"]."', '".$vaccine["vaccine_id"]."')"; $sql_import = "INSERT INTO m_consult_mc_vaccine SET mc_id='{$post_vars['mc_id']}',consult_id='{$vaccine['consult_id']}',user_id='{$_SESSION['userid']}',patient_id='{$vaccine['patient_id']}',vaccine_timestamp='{$vaccine['vaccine_timestamp']}',actual_vaccine_date='{$vaccine['actual_vaccine_date']}',vaccine_id='{$vaccine['vaccine_id']}'"; // updating of imported vaccine! $result_import = mysql_query($sql_import) or die("Cannot query: 669"); } } } } } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=SVC&mc_id=" . $get_vars["mc_id"]); break; case "Update Services": if ($post_vars["services"]) { foreach ($post_vars["services"] as $key => $value) { $sql = "insert into m_consult_mc_services (mc_id, consult_id, user_id, patient_id, mc_timestamp, service_id, visit_type) " . "values ('" . $post_vars["mc_id"] . "', '" . $get_vars["consult_id"] . "', '" . $_SESSION["userid"] . "', '{$patient_id}', sysdate(), '{$value}', '" . $post_vars["visit_type"] . "')"; $result = mysql_query($sql); } } if ($post_vars["vaccines"]) { foreach ($post_vars["vaccines"] as $key => $value) { $sql = "insert into m_consult_mc_vaccine (mc_id, consult_id, user_id, patient_id, vaccine_timestamp, actual_vaccine_date, vaccine_id) " . "values ('" . $post_vars["mc_id"] . "', '" . $get_vars["consult_id"] . "', '" . $_SESSION["userid"] . "', '{$patient_id}', sysdate(), sysdate(), '{$value}')"; $result = mysql_query($sql); // update patient vaccine record also $sql_vaccine = "insert into m_consult_vaccine (consult_id, patient_id, vaccine_id, user_id, vaccine_timestamp, actual_vaccine_date, source_module) " . "values ('" . $get_vars["consult_id"] . "', '{$patient_id}', '{$value}', '" . $_SESSION["userid"] . "', sysdate(), sysdate(), 'mc')"; $result_vaccine = mysql_query($sql_vaccine); } } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=SVC&mc_id=" . $post_vars["mc_id"]); break; case "Save Data": //include here the LMP checking/verification if ($post_vars["lmp_date"] == $post_vars["confirm_lmp_date"]) { if ($post_vars["lmp_date"] && $post_vars["obscore_gp"] && $post_vars["obscore_fpal"] && $post_vars["patient_height"]) { $edc = $this->compute_edc($post_vars["lmp_date"]); $sql = "INSERT INTO m_patient_mc SET patient_id='{$patient_id}',consult_id='{$get_vars['consult_id']}',mc_timestamp=sysdate(),mc_consult_date=sysdate(),patient_lmp='{$lmp_date}',patient_edc='{$edc}',trimester1_date=from_days(to_days('{$lmp_date}')+84),trimester2_date=from_days(to_days('{$lmp_date}')+189),trimester3_date=from_days(to_days('{$lmp_date}')+280),postpartum_date=from_days(to_days('{$lmp_date}')+322),obscore_gp='{$post_vars['obscore_gp']}',obscore_fpal='{$post_vars['obscore_fpal']}',user_id='{$_SESSION['userid']}',blood_type='{$post_vars['bloodtype']}',patient_age='{$patient_age}',patient_height='{$post_vars['patient_height']}'"; $result = mysql_query($sql) or die("Cannot query 845" . mysql_error()); if ($result) { $insert_id = mysql_insert_id(); $date_ngayon = date('Y-m-d'); foreach ($post_vars["risk"] as $key => $value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , " . "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected " . "user_id) values ('" . $get_vars["consult_id"] . "', " . "'{$patient_id}', '{$insert_id}', '{$value}', " . "sysdate(),{$date_ngayon} '" . $_SESSION["userid"] . "')"; $result_risk = mysql_query($sql_risk); } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1&mc_id={$insert_id}"); } } else { print "<font color='red'>Incomplete entries.</font><br/>"; } } else { print "<font color='red'>LMP Date does not match</font><br/>"; } break; case "Update Data": if ($post_vars["lmp_date"] && $post_vars["obscore_gp"] && $post_vars["obscore_fpal"] && $post_vars["patient_height"]) { $edc = $this->compute_edc($post_vars["lmp_date"]); $sql = "update m_patient_mc set " . "patient_lmp = '{$lmp_date}', " . "patient_edc = '" . $edc . "', " . "trimester1_date = from_days(to_days('{$lmp_date}')+84), " . "trimester2_date = from_days(to_days('{$lmp_date}')+189), " . "trimester3_date = from_days(to_days('{$lmp_date}')+280), " . "postpartum_date = from_days(to_days('{$lmp_date}')+322), " . "mc_timestamp = sysdate(), " . "obscore_gp = '" . $post_vars["obscore_gp"] . "', " . "obscore_fpal = '" . $post_vars["obscore_fpal"] . "', " . "patient_height = '" . $post_vars["patient_height"] . "', " . "blood_type = '" . $post_vars["bloodtype"] . "' " . "where mc_id = '" . $post_vars["mc_id"] . "'"; if ($result = mysql_query($sql)) { // delete risk factors first $sql_delete = "delete from m_consult_mc_visit_risk " . "where consult_id = '" . $get_vars["consult_id"] . "' and mc_id = '" . $post_vars["mc_id"] . "'"; $result_delete = mysql_query($sql_delete); // ...then update from form $date_ngayon = date('Y-m-d'); foreach ($post_vars["risk"] as $key => $value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , " . "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected," . "user_id) values ('" . $get_vars["consult_id"] . "', " . "'{$patient_id}', '" . $post_vars["mc_id"] . "', '{$value}', " . "sysdate(),{$date_ngayon}, '" . $_SESSION["userid"] . "')"; $result_risk = mysql_query($sql_risk); } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } else { print "<font color='red'>Incomplete entries.</font><br/>"; } break; case "Delete Data": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_patient_mc where mc_id = '" . $post_vars["mc_id"] . "'"; if ($result = mysql_query($sql)) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } else { if ($post_vars["confirm_delete"] == "No") { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } break; case "Save Prenatal Data": $exists = mc::check_visit_date($post_vars["visit_date"], $post_vars[mc_id]); //if ($post_vars["patient_systolic"] && $post_vars["patient_diastolic"] && // $post_vars["patient_weight"] && $post_vars["visit_date"] && $exists!=1) { if ($post_vars["visit_date"]) { //allow the entry of the prenatal visit minus the other vital signs //if ($post_vars["data_import_flag"]) { list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $visit_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); list($aog_weeks, $days) = mc::get_aog($post_vars["mc_id"], $visit_date); $aog_total = $aog_weeks + $days / 7; $data_type = "EXT"; $private = isset($post_vars["check_private"]) ? 'Y' : ''; //} else { /* $visit_date = healthcenter::get_consult_date($get_vars["consult_id"]); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); $trimester = $post_vars["trimester"]; $aog_total = $post_vars["aog_weeks"]; $data_type = "INT"; */ //} $sql = "insert into m_consult_mc_prenatal (mc_id, consult_id, patient_id, prenatal_timestamp, " . "prenatal_date, user_id, aog_weeks, trimester, visit_sequence, patient_weight, " . "blood_pressure_systolic, blood_pressure_diastolic, fhr, fhr_location, " . "fundic_height, presentation, data_type, flag_private) values ('" . $post_vars["mc_id"] . "', " . "'" . $get_vars["consult_id"] . "', '{$patient_id}', '{$visit_date}', " . "'{$visit_date}', '" . $_SESSION["userid"] . "', '{$aog_total}', " . "'{$trimester}', '" . $post_vars["visit_sequence"] . "', " . "'" . $post_vars["patient_weight"] . "', '" . $post_vars["patient_systolic"] . "', " . "'" . $post_vars["patient_diastolic"] . "', '" . $post_vars["fhr"] . "', " . "'" . $post_vars["fhr_location"] . "', '" . $post_vars["fundic_height"] . "', " . "'" . $post_vars["presentation"] . "', '{$data_type}', '{$private}')"; $result = mysql_query($sql) or die("Cannot query: 840" . mysql_error()); mc::reorder_prenatal_visits($post_vars["mc_id"]); if ($result) { // do not update for visit 1 if ($post_vars["visit_sequence"] > 1) { // delete risk factors first but only the M flagged // caution use this only with MySQL version 4.+ $sql_delete = "delete from m_consult_mc_visit_risk " . "using m_consult_mc_visit_risk, m_lib_mc_risk_factors " . "where m_consult_mc_visit_risk.consult_id = '" . $get_vars["consult_id"] . "' " . "and m_consult_mc_visit_risk.mc_id = '" . $post_vars["mc_id"] . "' and " . "m_consult_mc_visit_risk.visit_risk_id = m_lib_mc_risk_factors.risk_id and " . "m_lib_mc_risk_factors.monitor_flag = 'Y'"; $result_delete = mysql_query($sql_delete); // ...then update from form foreach ($post_vars["risk"] as $key => $value) { /*$sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp, ". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(), '".$_SESSION["userid"]."')"; */ $date_ngayon = date('Y-m-d'); $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , " . "patient_id, mc_id, visit_risk_id, risk_timestamp,date_detected," . "user_id) values ('" . $get_vars["consult_id"] . "', " . "'{$patient_id}', '" . $post_vars["mc_id"] . "', '{$value}', " . "sysdate(),{$date_ngayon},'" . $_SESSION["userid"] . "')"; } } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=PREN" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } break; case "Update Prenatal": //print_r($post_vars); $exists = mc::check_visit_date($post_vars["visit_date"], $post_vars[mc_id]); /*if ($post_vars["patient_systolic"] && $post_vars["patient_diastolic"] && $post_vars["patient_weight"] && $post_vars["fundic_height"] && $post_vars["fhr"] && $post_vars["fhr_location"] && $post_vars["presentation"] && $post_vars["visit_date"]) { */ if ($post_vars["visit_date"]) { list($month, $day, $year) = explode("/", $post_vars["visit_date"]); $flag_private = isset($post_vars["check_private"]) ? 'Y' : ''; $visit_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $trimester = mc::get_trimester($post_vars["mc_id"], $visit_date); $sql = "update m_consult_mc_prenatal set " . "fundic_height = '" . $post_vars["fundic_height"] . "', " . "fhr = '" . $post_vars["fhr"] . "', " . "prenatal_date = '" . $visit_date . "', " . "fhr_location = '" . $post_vars["fhr_location"] . "', " . "trimester = '" . $trimester . "', " . "presentation = '" . $post_vars["presentation"] . "', " . "patient_weight = '" . $post_vars["patient_weight"] . "', " . "blood_pressure_systolic = '" . $post_vars["patient_systolic"] . "', " . "blood_pressure_diastolic = '" . $post_vars["patient_diastolic"] . "', " . "flag_private = '" . $flag_private . "' " . "where mc_id = '" . $post_vars["mc_id"] . "' and visit_sequence = '" . $post_vars["visit_sequence"] . "'"; $result = mysql_query($sql) or die("Cannot update: 855"); if ($result) { // do not update for visit 1 if ($post_vars["visit_sequence"] > 1) { // delete risk factors first but only the M flagged // caution use this only with MySQL version 4.+ /*$sql_delete = "delete from m_consult_mc_visit_risk ". "using m_consult_mc_visit_risk, m_lib_mc_risk_factors ". "where m_consult_mc_visit_risk.consult_id = '".$post_vars["consult_id"]."' ". "and m_consult_mc_visit_risk.mc_id = '".$post_vars["mc_id"]."' and ". "m_consult_mc_visit_risk.visit_risk_id = m_lib_mc_risk_factors.risk_id and ". "m_lib_mc_risk_factors.monitor_flag = 'Y'"; $result_delete = mysql_query($sql_delete); // ...then update from form foreach($post_vars["risk"] as $key=>$value) { $sql_risk = "insert into m_consult_mc_visit_risk (consult_id , ". "patient_id, mc_id, visit_risk_id, risk_timestamp, ". "user_id) values ('".$get_vars["consult_id"]."', ". "'$patient_id', '".$post_vars["mc_id"]."', '$value', ". "sysdate(), '".$_SESSION["userid"]."')"; $result_risk = mysql_query($sql_risk); }*/ } header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=PREN" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } else { echo 'Record was not updated'; } } else { echo "Cannot update. Please complete the form."; } break; case "Delete Prenatal": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_prenatal where mc_id = '" . $post_vars["mc_id"] . "' and visit_sequence = '" . $post_vars["visit_sequence"] . "'"; if ($result = mysql_query($sql)) { // delete associated risk data for this prenatal visit // there is no referential integrity definition here... $sql_risk = "delete from m_consult_mc_visit_risk where mc_id = '" . $post_vars["mc_id"] . "' and consult_id = '" . $post_vars["consult_id"] . "'"; $result_risk = mysql_query($sql_risk); header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=PREN" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } else { if ($post_vars["confirm_delete"] == "No") { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=PREN" . ($post_vars["mc_id"] ? "&mc_id=" . $post_vars["mc_id"] : "")); } } break; case "Save Postpartum Data": if ($post_vars["delivery_date"] && $post_vars["delivery_location"] && $post_vars["outcome"] && $post_vars["birth_weight"] && $post_vars["attendant"]) { if (isset($_POST[breastfeeding_flag])) { //naka-check if (empty($_POST[date_breastfed])) { //no date but checked $datebreastfeed = 'n'; } elseif ($this->get_day_diff($_POST[date_breastfed], $post_vars["delivery_date"]) < 0) { //check if date of breastfeeding occurs after the delivery date $datebreastfeed = 'w'; } else { $datebreastfeed = 'y'; //set to yes is date_breastfed is not empty and not exceeding delivery date } } else { $datebreastfeed = 'y'; //not checked, no need to check for date } if ($datebreastfeed == 'y') { list($month, $day, $year) = explode("/", $post_vars["delivery_date"]); list($bmonth, $bday, $byr) = explode("/", $_POST["date_breastfed"]); $delivery_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); echo $delivery_date; if (isset($_POST[breastfeeding_flag])) { $bfeed_date = "{$byr}-" . str_pad($bmonth, 2, "0", STR_PAD_LEFT) . "-" . str_pad($bday, 2, "0", STR_PAD_LEFT); } else { $bfeed_date = ''; } $healthy_baby = $post_vars["healthy_baby_flag"] ? "Y" : "N"; $breastfeeding = $post_vars["breastfeeding_flag"] ? "Y" : "N"; $end_pregnancy = $post_vars["end_pregnancy_flag"] ? "Y" : "N"; // NOTE: update postpartum date from delivery date if (empty($get_vars["mc_id"])) { $patient_id = healthcenter::get_patient_id($_GET[consult_id]); if ($insert_new_patient) { $sql = "insert into m_patient_mc SET patient_id='{$patient_id}',consult_id='{$_GET['consult_id']}',patient_lmp=from_days(to_days('{$delivery_date}')-280),trimester1_date=from_days(to_days('{$delivery_date}')-196),trimester2_date=from_days(to_days('{$delivery_date}')-91),trimester3_date=from_days(to_days('{$delivery_date}')),mc_timestamp=sysdate(),mc_consult_date=sysdate(),patient_edc='{$delivery_date}',delivery_date='{$delivery_date}',postpartum_date=from_days(to_days('{$delivery_date}')+42),obscore_gp='{$post_vars['obscore_gp']}',obscore_fpal='{$post_vars['obscore_fpal']}',birthweight='{$post_vars['birth_weight']}',child_patient_id='{$child_id}',delivery_location='{$post_vars['delivery_location']}',outcome_id='{$post_vars['outcome']}',healthy_baby='{$health_baby}',end_pregnancy_flag='{$end_pregnancy}',breastfeeding_asap='{$breastfeeding}',date_breastfed='{$bfeed_date}',birthmode='{$post_vars['attendant']}'"; //$sql = "insert into m_patient_mc SET patient_id='$patient_id',consult_id='$_GET[consult_id]',patient_lmp=from_days(to_days('$delivery_date')-280),trimester1_date=from_days(to_days('$delivery_date')-186.7),trimester2_date=from_days(to_days('$delivery_date')-93.3),trimester3_date=from_days(to_days('$delivery_date')),mc_timestamp=sysdate(),mc_consult_date=sysdate(),delivery_date='$delivery_date',patient_edc='$date_delivery',postpartum_date=from_days(to_days('$delivery_date')+42),obscore_gp='$post_vars[obscore_gp]',obscore_fpal='$post_vars[obscore_fpal]',birthweight='$post_vars[birth_weight]',child_patient_id='$post_vars[child_patient_id]',delivery_location='$post_vars[delivery_location]',outcome_id='$post_vars[outcome]',healthy_baby='$health_baby',end_pregnancy_flag='$end_pregnancy',breastfeeding_asap='$breastfeeding',date_breastfed='$bfeed_date',birthmode='$post_vars[attendant]'"; } } else { $mothers_name = mysql_query("SELECT patient_lastname, patient_firstname, family_id, child_patient_id FROM m_patient a JOIN m_patient_mc b ON a.patient_id = b.patient_id JOIN m_family_members c ON a.patient_id = c.patient_id WHERE b.mc_id ='" . $get_vars["mc_id"] . "' AND c.patient_id='{$patient_id}'") or die("Cannot query 1158: " . mysql_error()); $name_result = mysql_fetch_assoc($mothers_name); $lastname = ucwords($post_vars[child_lastname]); $firstname = ucwords($post_vars[child_firstname]); $middlename = ucwords($post_vars[child_middlename]); if ($name_result['child_patient_id'] == 0) { //INSERT new patient if no child patient id found if ($post_vars[child_lastname] != null && $post_vars[child_firstname] != null && $post_vars[child_lastname] != null) { $mom_name = $name_result['patient_firstname'] . " " . $name_result['patient_lastname']; $child_family_id = $name_result['family_id']; $get_pxid = mysql_query("SELECT patient_id FROM m_patient ORDER BY patient_id DESC LIMIT 1") or die("Cannot query 1163: " . mysql_error()); $pxid_result = mysql_fetch_assoc($get_pxid); $child_id = $pxid_result['patient_id'] + 1; echo $post_vars[px_gender]; $insert_new_patient = mysql_query("INSERT INTO m_patient SET patient_id='{$child_id}',patient_lastname='{$lastname}', patient_firstname='{$firstname}',patient_middle='{$middlename}',patient_dob='{$delivery_date}',patient_gender='{$post_vars['px_gender']}',registration_date=sysdate(),user_id='{$_SESSION['userid']}',healthcenter_id='{$_SESSION['datanode']}[code]',patient_mother='{$mom_name}',patient_cellphone=''") or die("Cannot query: 1168 " . mysql_error()); if ($child_family_id != 0) { $check_family = mysql_query("SELECT family_id FROM m_family_members WHERE patient_id ='{$child_id}'") or die("Cannot Query 1154: " . mysql_error()); if (mysql_num_rows($check_family) == 0) { $insert_into_family = mysql_query("INSERT INTO m_family_members SET family_id ='{$child_family_id}',family_role='member', patient_id = '{$child_id}'") or die("Cannot query 1177: " . mysql_error()); } } } } else { //UPDATE child information if child_patient_id value is more than 0 $child_id = $name_result['child_patient_id']; $mom_name = $name_result['patient_firstname'] . " " . $name_result['patient_lastname']; $update_patient = mysql_query("UPDATE m_patient SET patient_lastname='{$lastname}',patient_firstname='{$firstname}',patient_middle='{$middlename}',patient_dob='{$delivery_date}',patient_gender='{$post_vars['px_gender']}',registration_date=sysdate(),user_id='{$_SESSION['userid']}',healthcenter_id='{$_SESSION['datanode']}[code]',patient_mother='{$mom_name}',patient_cellphone='' WHERE patient_id ='{$child_id}'") or die("Cannot query: 1182 " . mysql_error()); } $sql = "update m_patient_mc set " . "delivery_date = '{$delivery_date}', " . "postpartum_date = from_days(to_days('{$delivery_date}')+42), " . "obscore_gp = '" . $post_vars["obscore_gp"] . "', " . "obscore_fpal = '" . $post_vars["obscore_fpal"] . "', " . "birthweight = '" . $post_vars["birth_weight"] . "', " . "delivery_location = '" . $post_vars["delivery_location"] . "', " . "child_patient_id = '{$child_id}', " . "outcome_id = '" . $post_vars["outcome"] . "', " . "healthy_baby = '{$healthy_baby}', " . "end_pregnancy_flag = '{$end_pregnancy}', " . "breastfeeding_asap = '{$breastfeeding}', " . "date_breastfed = '{$bfeed_date}', " . "birthmode = '" . $post_vars["attendant"] . "' " . "where mc_id = '" . $get_vars["mc_id"] . "'"; } $result = mysql_query($sql) or die("Cannot query: 1068 " . mysql_error()); if ($result) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } } else { echo "<script language='Javascript'>"; if ($datebreastfeed == 'n') { echo "window.alert('Record not saved. Please indicate the date of breastfeeding if the baby was breastfed ASAP.')"; } else { //w ito echo "window.alert('Record not saved. Date of breastfeeding should be on or after date of delivery.')"; } echo "</script>"; } } else { echo "<script language='Javascript'>"; echo "window.alert('Record not saved. Please complete REQUIRED fields.')"; echo "</script>"; } break; case "Delete Postpartum Data Form": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { //this would remove the initial postpartum data (i.e. dob,location, attendant)that has been encoded echo "<script language='javascript'>"; echo "window.alert('Deleting the initial postpartum data will also clear out the details of the postpartum visits. Please think twice before doing so.')"; echo "</script>"; if ($this->clear_postpartum_data($_GET["mc_id"], $patient_id)) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } else { if ($post_vars["confirm_delete"] == "No") { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=POSTP&mc_id=" . $get_vars["mc_id"]); } } } break; case "Terminate Pregnancy": if (!empty($_POST["cause_termination"])) { /*echo "<script language='javascript'>"; echo "window.alert('Once a pregnancy is terminated, the record will be closed. Please ensure that the details of the pregnancy termination is correct.')"; echo "<script>";*/ echo "<script language='javascript'>"; echo "window.alert('Once a pregnancy is terminated, the record will be closed. Please ensure that the details of the pregnancy termination is correct.')"; echo "</script>"; echo "You are terminating this pregnancy due to: <b>" . $_POST["cause_termination"] . "</b> on " . $_POST["txt_date_termination"] . "<br>"; if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { list($m, $d, $y) = explode('/', $_POST["txt_date_termination"]); $date_term = $y . '/' . $m . '/' . $d; $close_record = mysql_query("UPDATE m_patient_mc SET end_pregnancy_flag='Y',date_terminated_abortion='{$date_term}',termination_code='{$_POST['sel_cause_term']}', pregnancy_termination_cause='{$_POST['cause_termination']}' WHERE mc_id='{$_GET['mc_id']}' AND patient_id='{$patient_id}'") or die("Cannot query 1199 " . mysql_error()); if ($close_record) { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1&mc_id=" . $get_vars["mc_id"]); echo "</script>"; } } else { if ($post_vars["confirm_delete"] == "No") { header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=VISIT1&mc_id=" . $get_vars["mc_id"]); } } } else { echo "<script language='javascript'>"; echo "window.alert('Please fill in the cause of the termination of this pregnancy!')"; echo "</script>"; } break; case 'Open Pregnancy Record': echo "<script>"; echo "window.alert('Opening this pregnancy record will allow you to edit its existing contents.')"; echo "</script>"; $update_mc = mysql_query("UPDATE m_patient_mc SET end_pregnancy_flag='N' WHERE mc_id='{$_GET['mc_id']}'") or die("Cannot query 1249: " . mysql_error()); break; default: break; } } }