function process_detail() { if (func_num_args()>0) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; //print_r($arg_list); } switch($post_vars["submitdetail"]) { case "Update Service": if(isset($_POST[actual_service_date]) && isset($_POST[service_qty])): list($month,$date,$year) = explode('/',$_POST[actual_service_date]); $serv_date = $year.'-'.$month.'-'.$date; /* $sel_px = mysql_query("SELECT patient_id FROM m_patient_mc WHERE mc_id='$get_vars[mc_id]'") or die("Cannot query: 2197"); list($px_id) = mysql_fetch_array($sel_px); $q_service = mysql_query("SELECT actual_service_date,service_id,mc_timestamp FROM m_consult_mc_services WHERE mc_id='$get_vars[mc_id]' AND patient_id='$px_id' AND actual_service_date='$_POST[actual_service_date]' AND service_id='$get_vars[service_id]' AND mc_timestamp!='$get_vars[sts]'") or die("Cannot query: 2200"); list($date,$sid,$ts) = mysql_fetch_array($q_service); echo $_POST[actual_service_date]; if(mysql_num_rows($q_service)==0): */ $update_service = mysql_query("UPDATE m_consult_mc_services SET actual_service_date='$serv_date',service_qty='$_POST[service_qty]' WHERE service_id='$_POST[service]' AND mc_id='$_POST[mc_id]' AND mc_timestamp='$_POST[sts]'") or die("Cannot query: 2193"); echo "<script language='Javascript'>"; if($update_service): echo "window.alert('Service was successfully been updated!')"; else: echo "window.alert('Service was not update.\n Maaring kulang ang date o quantity.')"; endif; echo "</script>"; /* else: echo 'b'; echo "<script language='Javascript'>"; echo "window.alert('Service was not updated. Actual date of service already exists.')"; echo "</script>"; endif; */ else: echo "<script language='Javascript'>"; echo "window.alert('Service was not update.\n Maaring kulang ang date o quantity.')"; echo "</script>"; endif; break; case "Delete Service": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_services ". "where service_id = '".$post_vars["service"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "mc_timestamp = '".$post_vars["sts"]."'"; 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=SVC&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=".$get_vars["ptmenu"]."&module=mc&mc=SVC&mc_id=".$post_vars["mc_id"]); } } break; case "Delete Record"; if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_vaccine ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "vaccine_timestamp = '".$post_vars["ts"]."'"; if ($result = mysql_query($sql)) { /*$sql_vaccine = "delete from m_consult_vaccine ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "consult_id = '".$post_vars["vaccine_consult_id"]."' and ". "source_module = 'mc'"; */ $sql_vaccine = "DELETE FROM m_consult_vaccine WHERE consult_id='$post_vars[vaccine_consult_id]' AND vaccine_id='$post_vars[vaccine]'"; $result_vaccine = mysql_query($sql_vaccine) or die(mysql_error()); 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=SVC&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=".$get_vars["ptmenu"]."&module=mc&mc=SVC&mc_id=".$post_vars["mc_id"]); } } break; case "Update Record"; $adr = ($post_vars["adr_flag"]?"Y":"N"); list($month,$day,$year) = explode("/", $post_vars["actual_vaccine_date"]); $actual_vaccine_date = $year."-".str_pad($month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_dob = patient::get_dob($patient_id); $sql = "update m_consult_mc_vaccine set ". "actual_vaccine_date = '$actual_vaccine_date' ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "vaccine_timestamp = '".$post_vars["ts"]."'"; if ($result = mysql_query($sql)) { /*$sql_vaccine = "update m_consult_vaccine set ". "actual_vaccine_date = '$actual_vaccine_date' ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "consult_id = '".$post_vars["vaccine_consult_id"]."' and ". "source_module = 'mc'"; */ $sql_vaccine = "update m_consult_vaccine set ". "actual_vaccine_date = '$actual_vaccine_date' ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "consult_id = '".$post_vars["vaccine_consult_id"]; $result_vaccine = mysql_query("UPDATE m_consult_vaccine SET actual_vaccine_date='$actual_vaccine_date' WHERE consult_id='$post_vars[vaccine_consult_id]' AND vaccine_id='$post_vars[vaccine]'") or die("Cannot update: 2247"); 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=".$get_vars["module"]."&mc=SVC&vaccine=".$post_vars["vaccine"]."&ts=".$post_vars["ts"]."&mc_id=".$post_vars["mc_id"]."#vaccine_detail"); } } }
function process_detail() { if (func_num_args() > 0) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; //print_r($arg_list); } switch ($post_vars["submitdetail"]) { case "Delete Record": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_vaccine " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "consult_id = '" . $post_vars["vaccine_consult_id"] . "' and " . "source_module = 'vaccine'"; if ($result = mysql_query($sql)) { $delete_mc_vacc = mysql_query("DELETE FROM m_consult_mc_vaccine WHERE vaccine_id='{$post_vars['vaccine']}' AND consult_id='{$post_vars['vaccine_consult_id']}'") or die("cannot query: 298"); 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=vaccine"); } } 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=" . $get_vars["ptmenu"] . "&module=vaccine"); } } break; case "Update Record": $adr = $post_vars["adr_flag"] ? "Y" : "N"; list($month, $day, $year) = explode("/", $post_vars["actual_vaccine_date"]); $actual_vaccine_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_dob = patient::get_dob($patient_id); $sql = "update m_consult_vaccine set " . "adr_flag = '{$adr}', " . "actual_vaccine_date = '{$actual_vaccine_date}' " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "consult_id = '" . $post_vars["vaccine_consult_id"] . "' and " . "source_module = 'vaccine'"; if ($result = mysql_query($sql)) { $update_mc = mysql_query("UPDATE m_consult_mc_vaccine SET actual_vaccine_date='{$actual_vaccine_date}',adr_flag='{$adr}' WHERE consult_id='{$post_vars['vaccine_consult_id']}' AND patient_id='{$patient_id}' AND vaccine_id='{$post_vars['vaccine']}'") or die("Cannot query: 319"); 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=vaccine"); } } }
function process_detail() { if (func_num_args() > 0) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; //print_r($arg_list); } switch ($post_vars["submitdetail"]) { case "Update Service": list($serv_mo, $serv_date, $serv_year) = explode('/', $_POST[ccdev_serv_date]); $actual_serv_date = $serv_year . '-' . $serv_mo . '-' . $serv_date; $get_px_id = mysql_query("SELECT b.patient_lastname,b.patient_firstname,b.patient_dob,(TO_DAYS('{$actual_serv_date}')-TO_DAYS(b.patient_dob)) age_days FROM m_consult_ccdev_services a,m_patient b WHERE a.ccdev_id='{$post_vars['ccdev_id']}' AND b.patient_id=a.patient_id") or die(mysql_error()); if (mysql_num_rows($get_px_id) != 0) { list($lname, $fname, $dob, $age_days) = mysql_fetch_array($get_px_id); $age_weeks = round($age_days / 7, 1); if ($age_days < 0) { echo "<font color='red' size='3'>Update unsuccessful.Newborn screening should occur on or after this patient's date of birth. ({$dob})</font><br>"; } else { $update_ccdev_service = mysql_query("UPDATE m_consult_ccdev_services SET ccdev_service_date='{$actual_serv_date}' ,age_on_service='{$age_weeks}' WHERE service_id='{$post_vars['service']}' AND ccdev_id='{$post_vars['ccdev_id']}' AND ccdev_timestamp='{$post_vars['sts']}'") or die("Cannot query: 960"); if ($update_ccdev_service) { echo "<font color='red' size='3'>Update was successfully done!</font><br>"; } } } else { } break; case "Delete Service": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_ccdev_services " . "where service_id = '" . $post_vars["service"] . "' and " . "ccdev_id = '" . $post_vars["ccdev_id"] . "' and " . "ccdev_timestamp = '" . $post_vars["sts"] . "'"; 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=" . $get_vars["module"]); } } 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=" . $get_vars["ptmenu"] . "&module=" . $get_vars["module"]); } } break; case "Delete Record": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_ccdev_vaccine " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "ccdev_id = '" . $post_vars["ccdev_id"] . "' and " . "vaccine_timestamp = '" . $post_vars["ts"] . "'"; if ($result = mysql_query($sql)) { $sql_vaccine = "delete from m_consult_vaccine " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "consult_id = '" . $post_vars["vaccine_consult_id"] . "' and " . "source_module = 'ccdev'"; $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=" . $get_vars["ptmenu"] . "&module=" . $get_vars["module"]); } } 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=" . $get_vars["ptmenu"] . "&module=" . $get_vars["module"]); } } break; case "Update Record": $adr = $post_vars["adr_flag"] ? "Y" : "N"; list($month, $day, $year) = explode("/", $post_vars["actual_vaccine_date"]); $actual_vaccine_date = $year . "-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT); $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_dob = patient::get_dob($patient_id); $sql = "update m_consult_ccdev_vaccine set " . "adr_flag = '{$adr}', " . "actual_vaccine_date = '{$actual_vaccine_date}', " . "age_on_vaccine = (to_days('{$actual_vaccine_date}')-to_days('{$patient_dob}'))/7 " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "ccdev_id = '" . $post_vars["ccdev_id"] . "' and " . "vaccine_timestamp = '" . $post_vars["ts"] . "'"; if ($result = mysql_query($sql)) { $sql_vaccine = "update m_consult_vaccine set " . "actual_vaccine_date = '{$actual_vaccine_date}' " . "where vaccine_id = '" . $post_vars["vaccine"] . "' and " . "consult_id = '" . $post_vars["vaccine_consult_id"] . "' and " . "source_module = 'ccdev'"; $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=" . $get_vars["ptmenu"] . "&module=" . $get_vars["module"] . "&ccdev=SVC&vaccine=" . $post_vars["vaccine"] . "&ts=" . $post_vars["ts"] . "&ccdev_id=" . $post_vars["ccdev_id"] . "#detail"); } } }
function process_detail() { if (func_num_args()>0) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; //print_r($arg_list); } switch($post_vars["submitdetail"]) { case "Delete Service": if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_services ". "where service_id = '".$post_vars["service"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "mc_timestamp = '".$post_vars["sts"]."'"; 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=SVC&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=".$get_vars["ptmenu"]."&module=mc&mc=SVC&mc_id=".$post_vars["mc_id"]); } } break; case "Delete Record"; if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_mc_vaccine ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "vaccine_timestamp = '".$post_vars["ts"]."'"; if ($result = mysql_query($sql)) { $sql_vaccine = "delete from m_consult_vaccine ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "consult_id = '".$post_vars["vaccine_consult_id"]."' and ". "source_module = '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=".$get_vars["ptmenu"]."&module=mc&mc=SVC&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=".$get_vars["ptmenu"]."&module=mc&mc=SVC&mc_id=".$post_vars["mc_id"]); } } break; case "Update Record"; $adr = ($post_vars["adr_flag"]?"Y":"N"); list($month,$day,$year) = explode("/", $post_vars["actual_vaccine_date"]); $actual_vaccine_date = $year."-".str_pad($month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $patient_dob = patient::get_dob($patient_id); $sql = "update m_consult_mc_vaccine set ". "actual_vaccine_date = '$actual_vaccine_date' ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "mc_id = '".$post_vars["mc_id"]."' and ". "vaccine_timestamp = '".$post_vars["ts"]."'"; if ($result = mysql_query($sql)) { $sql_vaccine = "update m_consult_vaccine set ". "actual_vaccine_date = '$actual_vaccine_date' ". "where vaccine_id = '".$post_vars["vaccine"]."' and ". "consult_id = '".$post_vars["vaccine_consult_id"]."' and ". "source_module = '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=".$get_vars["ptmenu"]."&module=".$get_vars["module"]."&mc=SVC&vaccine=".$post_vars["vaccine"]."&ts=".$post_vars["ts"]."&mc_id=".$post_vars["mc_id"]."#vaccine_detail"); } } }