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