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