function process_dispense_drug() { 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); } $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $consult_date = healthcenter::get_consult_date($get_vars["consult_id"]); $notes_id = drug::get_notes_id($get_vars["consult_id"]); $philhealth_id = drug::get_philhealth_id($patient_id); //$note_link = $this->switch_notes($get_vars["notes"]); switch ($post_vars["submitdrug"]) { case "Dispense Drugs": if ($notes_id != null || $notes_id != "") { /*$sql = "insert into m_consult_pcb_drugs (consult_id, notes_id, patient_id, user_id, dispense_timestamp) ". "values ('".$get_vars["consult_id"]."', '$notes_id', '$patient_id', '".$_SESSION["userid"]."', sysdate())";*/ $sql = "insert into m_consult_pcb_dispense (consult_id, patient_id, user_id, dispense_timestamp, dispense_date) " . "values ('" . $get_vars["consult_id"] . "', '{$patient_id}', '" . $_SESSION["userid"] . "', sysdate(), sysdate())"; //echo $sql; if ($result = mysql_query($sql)) { $insert_id = mysql_insert_id(); //header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=NOTES&module=notes¬es=NOTES¬es_id=$insert_id#menu"); header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DRUGS&module=drug&drug=PCB&drug_id={$insert_id}#menu"); } } else { print "<font color='red'>Please create consult notes <br/>and diagnosis before dispensing.</font>"; } break; case "Dispense": if ($philhealth_id != null || $philhealth_id != "") { if ($post_vars["selectdiag"] && $post_vars["selectDrug"] && $post_vars["quantity"]) { $sql_select = "select * from m_consult_pcb_drugs WHERE generic_id = '" . $post_vars["selectDrug"] . "' and consult_id = '" . $get_vars["consult_id"] . "' and patient_id = '{$patient_id}'"; if ($result_select = mysql_query($sql_select)) { if (mysql_num_rows($result_select)) { $sql = "update m_consult_pcb_drugs set generic_id='" . $post_vars["selectDrug"] . "', user_id='" . $_SESSION["userid"] . "', dispense_timestamp=sysdate(), quantity='" . $post_vars["quantity"] . "', class_id='" . $post_vars["selectdiag"] . "' where patient_id = '{$patient_id}' and consult_id = '" . $get_vars["consult_id"] . "' and generic_id = '" . $post_vars["selectDrug"] . "'"; echo $sql; } else { $sql = "insert into m_consult_pcb_drugs (dispense_id, generic_id, consult_id, notes_id, patient_id, user_id, dispense_timestamp, quantity, class_id) " . "values ('" . $get_vars["drug_id"] . "', '" . $post_vars["selectDrug"] . "', '" . $get_vars["consult_id"] . "', '{$notes_id}', '{$patient_id}', '" . $_SESSION["userid"] . "', sysdate(), '" . $post_vars["quantity"] . "', '" . $post_vars["selectdiag"] . "' )"; } } } //$sql = "insert into m_consult_pcb_drugs (dispense_id, generic_id, consult_id, notes_id, patient_id, user_id, dispense_timestamp, quantity, class_id) ". //"values ('".$get_vars["drug_id"]."', '".$post_vars["selectDrug"]."', '".$get_vars["consult_id"]."', '$notes_id', '$patient_id', '".$_SESSION["userid"]."', sysdate(), '".$post_vars["quantity"]."', '".$post_vars["selectdiag"]."' )"; echo $sql; if ($result = mysql_query($sql)) { $dispense_id = $get_vars["drug_id"]; //header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=NOTES&module=notes¬es=NOTES¬es_id=$insert_id#menu"); header("location: " . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DRUGS&module=drug&drug=PCB&drug_id={$dispense_id}#menu"); } } else { print "<font color='red'>PCB Drug Dispensing is for Philhealth Members Only.</font>"; } break; } }