function process_consult() { 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); } // make sure you catch where patient_id is coming from if ($post_vars["consult_patient_id"]) { $patient_id = $post_vars["consult_patient_id"]; } elseif ($get_vars["enter_consult"]) { $patient_id = $get_vars["enter_consult"]; } elseif ($post_vars["patient_id"]) { $patient_id = $post_vars["patient_id"]; } // check if consult records for today contain // patient id to avoid possible duplicate consults // limitation of this software enforced constraint // is if consult exceeds one day (not possible in health centers) if (healthcenter::is_patient_in_consult($patient_id)) { $post_vars["patient_id"] = $patient_id; if (healthcenter::confirm_add_consult($menu_id, $post_vars, $get_vars)) { $sql = "insert into m_consult (patient_id, user_id, healthcenter_id, consult_date) ". "values ('$patient_id', '".$_SESSION["userid"]."', '".$_SESSION["datanode"]["code"]."', sysdate())"; if ($result = mysql_query($sql)) { // get insert_id into header $insert_id = mysql_insert_id(); // if patient comes from appointment page // update appointment table if ($post_vars["schedule_id"]) { $sql_appt = "update m_consult_appointments set ". "actual_date = sysdate(), ". "visit_done = 'Y' ". "where schedule_id = '".$post_vars["schedule_id"]."'"; $result_appt = mysql_query($sql_appt); header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&patient_id=".$get_vars["patient_id"]."&schedule_id=".$get_vars["schedule_id"]."&year=".$get_vars["year"]."&month=".$get_vars["month"]."&day=".$get_vars["day"]."&s=0#detail"); } else { header("location: ".$_SERVER["PHP_SELF"]."?page=CONSULTS&menu_id=".$get_vars["menu_id"]."&consult_id=$insert_id&ptmenu=DETAILS"); } } } else { if ($post_vars["confirm_add_consult"]=="No") { header("location: ".$_SERVER["PHP_SELF"]."?page=CONSULTS&menu_id=".$get_vars["menu_id"]."&consult_id=$insert_id&ptmenu=DETAILS"); } } } else { // insert into consult table if there are no // possible duplicate entries $sql = "insert into m_consult (patient_id, user_id, healthcenter_id, consult_date) ". "values ('$patient_id', '".$_SESSION["userid"]."', '".$_SESSION["datanode"]["code"]."', sysdate())"; if ($result = mysql_query($sql)) { // get insert_id into header $insert_id = mysql_insert_id(); // if patient comes from appointment page // update appointment table if ($post_vars["schedule_id"]) { $sql_appt = "update m_consult_appointments set ". "actual_date = sysdate(), ". "visit_done = 'Y' ". "where schedule_id = '".$post_vars["schedule_id"]."'"; $result_appt = mysql_query($sql_appt); header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&patient_id=".$get_vars["patient_id"]."&schedule_id=".$get_vars["schedule_id"]."&year=".$get_vars["year"]."&month=".$get_vars["month"]."&day=".$get_vars["day"]."&s=0#detail"); } else { header("location: ".$_SERVER["PHP_SELF"]."?page=CONSULTS&menu_id=".$get_vars["menu_id"]."&consult_id=$insert_id&ptmenu=DETAILS"); } } } }