function process_consult_notes() {
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"]);
switch($post_vars["submitnotes"]) {
case "Create Notes":
$sql = "insert into m_consult_notes (consult_id, patient_id, user_id, notes_timestamp) ".
"values ('".$get_vars["consult_id"]."', '$patient_id', '".$_SESSION["userid"]."', sysdate())";
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");
}
break;
case "Save Complaint":
if ($post_vars["complaintcat"]) {
foreach ($post_vars["complaintcat"] as $key=>$value) {
$sql = "insert into m_consult_notes_complaint (notes_id, consult_id, patient_id, complaint_id, complaint_date, user_id, complaint_timestamp) ".
"values ('".$get_vars["notes_id"]."', '".$get_vars["consult_id"]."', '$patient_id', '$value', '$consult_date', '".$_SESSION["userid"]."', sysdate())";
$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=NOTES&module=notes¬es=CC¬es_id=".$get_vars["notes_id"]);
}
break;
case "Save History":
if ($post_vars["history_text"]) {
$sql = "update m_consult_notes set ".
"notes_history = '".addslashes($post_vars["history_text"])."' ".
"where notes_id = '".$get_vars["notes_id"]."'";
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=NOTES&module=notes¬es=HX¬es_id=".$get_vars["notes_id"]);
}
}
break;
case "Save PE":
if ($post_vars["pe_text"]) {
$sql = "update m_consult_notes set ".
"notes_physicalexam = '".addslashes($post_vars["pe_text"])."' ".
"where notes_id = '".$get_vars["notes_id"]."'";
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=NOTES&module=notes¬es=PE¬es_id=".$get_vars["notes_id"]);
}
}
break;
case "Save Diagnosis Class":
if ($post_vars["dxclass"]) {
foreach($post_vars["dxclass"] as $key=>$value) {
$sql = "insert into m_consult_notes_dxclass (notes_id, consult_id, patient_id, class_id, diagnosis_date, user_id, diagnosis_timestamp) ".
"values ('".$get_vars["notes_id"]."', '".$get_vars["consult_id"]."', '$patient_id', '$value', '$consult_date', '".$_SESSION["userid"]."', sysdate())";
$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=NOTES&module=notes¬es=DX¬es_id=".$get_vars["notes_id"]);
}
break;
case "Save Plan":
if ($post_vars["plan_text"]) {
$sql = "update m_consult_notes set ".
"notes_plan = '".addslashes($post_vars["plan_text"])."' ".
"where notes_id = '".$get_vars["notes_id"]."'";
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=NOTES&module=notes¬es=TX¬es_id=".$get_vars["notes_id"]);
}
}
break;
}
}
function display_registry_record_detail() {
//
// called from _details_mc()
// contains most alerts for this pregnancy
//
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"]);
$sql = "select mc_id, patient_id, consult_id, date_format(mc_timestamp, '%a %d %b %Y, %h:%i%p') mc_timestamp, ".
"patient_lmp, patient_edc, trimester1_date, trimester2_date, round((to_days(mc_consult_date)-to_days(patient_lmp))/7,0) patient_aog, ".
"MOD((to_days(mc_consult_date)-to_days(patient_lmp)),7) remainder, ".
"trimester3_date, postpartum_date, to_days(trimester1_date) days_trim1, ".
"to_days(trimester2_date) days_trim2, to_days(trimester3_date) days_trim3, ".
"to_days(postpartum_date) days_pp, to_days(mc_consult_date) days_today, obscore_gp, obscore_fpal, user_id, ".
"blood_type, patient_age, patient_height, delivery_date, ".
"outcome_id, birthweight, end_pregnancy_flag ".
"from m_patient_mc where patient_id = '$patient_id' and mc_id = '".$get_vars["mc_id"]."'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$mc = mysql_fetch_array($result);
if ($get_vars["mc_id"]==$mc["mc_id"]) {
print "<form method='post' action='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=mc&mc=".$get_vars["mc"]."&mc_id=".$get_vars["mc_id"]."#visit1form'>";
print "<table width='280' style='border: 1px dotted black'><tr><td>";
print "<span class='tinylight'>";
print "REGISTRY ID: <font color='red'>".module::pad_zero($mc["mc_id"], 7)."</font><br/>";
print "PATIENT NAME: ".patient::get_name($patient_id)."<br/>";
$patient_age = patient::get_age($patient_id);
print "AGE: ".(!mc::is_normal_age($patient_age)?"<font color='red'><b>$patient_age</b></font>":$patient_age)."<br/>";
print "SCORE: ".mc::check_gp_score($mc["obscore_gp"])." ".mc::check_fpal_score($mc["obscore_fpal"])."<br/>";
print "<hr size='1'/>";
print "REG DATE: ".$mc["mc_timestamp"]."<br/>";
print "REG BY: ".user::get_username($mc["user_id"])."<br/>";
print "<hr size='1'/>";
print "<table cellpadding='0' cellspacing='0'><tr valign='top'><td>";
// column 1
print "<span class='tinylight'>";
print "LMP: ".$mc["patient_lmp"]."<br/>";
print "EDC: ".$mc["patient_edc"]."<br/>";
// get AOG according to whether patient has delivered or not
// if has delivered, compute AOG according to that
// if not compute by consult_date
list($aog_wks, $aog_days) = mc::get_aog($mc["mc_id"], (mc::get_delivery_date($mc["mc_id"])=="0000-00-00"?healthcenter::get_consult_date($get_vars["consult_id"]):mc::get_delivery_date($mc["mc_id"])));
print "AOG: ".$aog_wks." WKS ".$aog_days." DAYS<br/>";
print "</span>";
print "</td><td>";
// column 2
print "<span class='tinylight'>";
print " BLOOD TYPE: ".($mc["blood_type"]=="AB"?"<font color='red'><b>".$mc["blood_type"]."</b></font>":$mc["blood_type"])."<br/>";
print " HEIGHT (cm): ".(!mc::is_normal_height($mc["patient_height"])?"<font color='red'><b>".$mc["patient_height"]."</b></font>":$mc["patient_height"])."<br/>";
list($systolic, $diastolic) = healthcenter::get_blood_pressure($get_vars["consult_id"]);
print " SYS BP: ".($systolic?$systolic:"NA")."<br/>";
print " DIAS BP: ".($diastolic?$diastolic:"NA")."<br/>";
if ($systolic && $diastolic) {
print " STAGE: ";
healthcenter::hypertension_stage($systolic, $diastolic,$patient_age)."<br/>";
}
print "</span>";
print "</td></tr></table>";
print "<hr size='1'/>";
print "IMPORTANT DATES:<br/>";
print "End of 1st trimester: ".($mc["days_today"]>=$mc["days_trim1"]?"<font color='red'>".$mc["trimester1_date"]."</font>":$mc["trimester1_date"])."<br/>";
print "End of 2nd trimester: ".($mc["days_today"]>=$mc["days_trim2"]?"<font color='red'>".$mc["trimester2_date"]."</font>":$mc["trimester2_date"])."<br/>";
print "End of 3rd trimester: ".($mc["days_today"]>=$mc["days_trim3"]?"<font color='red'>".$mc["trimester3_date"]."</font>":$mc["trimester3_date"])."<br/>";
print "End of postpartum period: ".($mc["days_today"]>=$mc["days_pp"]?"<font color='red'>".$mc["postpartum_date"]."</font>":$mc["postpartum_date"])."<br/>";
echo "<hr size='1'>";
echo "Tetanus Toxoid Status: ";
echo "<font color='red'><b>".mc::get_tt_status($mc["mc_id"],$patient_id,$mc["patient_edc"])."</b></font>";
echo "</hr>";
print "<hr size='1'/>";
print "RISK FACTORS:<br/>";
$sql_risk = "select c.visit_risk_id, r.hospital_flag, r.monitor_flag ".
"from m_consult_mc_visit_risk c, m_lib_mc_risk_factors r ".
"where c.visit_risk_id = r.risk_id and ".
"c.consult_id = '".$mc["consult_id"]."'";
if ($result_risk = mysql_query($sql_risk)) {
if (mysql_num_rows($result_risk)) {
while ($risk = mysql_fetch_array($result_risk)) {
print "<img src='../images/arrow_redwhite.gif' border='0' /> ";
print ($risk["hospital_flag"]=="Y"?"<font color='red'>".mc::get_riskfactor_name($risk["visit_risk_id"])."</font>":mc::get_riskfactor_name($risk["visit_risk_id"]))."<br/>";
}
}
}
if ($mc["delivery_date"]<>"0000-00-00") {
// if registry record closed display the rest
print "<hr size='1'/>";
print "<table cellspacing='0' cellpadding='0' width='100%' bgcolor='#CCFFCC'><tr><td class='tinylight'>";
print "DELIVERY DATE: ".$mc["delivery_date"]."<br/>";
print "OUTCOME: ".mc::get_pregnancy_outcome($mc["outcome_id"])."<br/>";
print "BIRTH WT (KG): ".$mc["birthweight"]."<br/>";
print "</td></tr></table>";
}
print "<br/>";
if ($_SESSION["priv_add"]) {
if ($mc["end_pregnancy_flag"]=="N") {
// prevent editing of closed registry record
print "<input type='submit' name='submitmc' value='Update Visit 1' class='tinylight' style='border: 1px solid black'/> ";
print "<input type='submit' name='submitmc' value='Update Postpartum Data Form' class='tinylight' style='border: 1px solid black'/> ";
}
print "<input type='hidden' name='mc_id' value='".$mc["mc_id"]."'/>";
}
print "</span>";
print "</td></tr></table>";
print "</form>";
}
}
}
}
function process_consult_notes()
{
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"]);
$note_link = $this->switch_notes($get_vars["notes"]);
switch ($post_vars["submitnotes"]) {
case "Create Notes":
$sql = "insert into m_consult_notes (consult_id, patient_id, user_id, notes_timestamp) " . "values ('" . $get_vars["consult_id"] . "', '{$patient_id}', '" . $_SESSION["userid"] . "', sysdate())";
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=NOTES&module=notes¬es={$note_link}¬es_id={$insert_id}#menu");
}
break;
case "Save Complaint":
if ($post_vars["complaintcat"]) {
foreach ($post_vars["complaintcat"] as $key => $value) {
$sql = "insert into m_consult_notes_complaint (notes_id, consult_id, patient_id, complaint_id, complaint_date, user_id, complaint_timestamp) " . "values ('" . $get_vars["notes_id"] . "', '" . $get_vars["consult_id"] . "', '{$patient_id}', '{$value}', '{$consult_date}', '" . $_SESSION["userid"] . "', sysdate())";
$result = mysql_query($sql);
}
}
$update_complaint_note = mysql_query("UPDATE m_consult_notes SET notes_complaint='{$post_vars['complaint_notes']}' WHERE consult_id='{$get_vars['consult_id']}'") or die("Cannot query: 302 " . mysql_error());
//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=CC¬es_id=".$get_vars["notes_id"]."#menu");
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={$note_link}¬es_id=" . $get_vars["notes_id"] . "#menu");
break;
case "Save History":
$pastHistory = implode(",", $post_vars["pastmedhistory"]);
$familyHistory = implode(",", $post_vars["familymedhistory"]);
$medintake = implode(",", $post_vars["medintake"]);
$checkSQL = "select * from m_patient_history WHERE patient_id = '{$patient_id}'";
list($month, $day, $year) = explode("/", $post_vars["lmp"]);
$lmp_date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
if ($result = mysql_query($checkSQL)) {
if (mysql_num_rows($result)) {
$sqlPE = "update m_patient_history set consult_id='" . $get_vars["consult_id"] . "', user_id='" . $_SESSION["userid"] . "',\n \t\t\t\t\tpasthistory_id='{$pastHistory}', familyhistory_id='{$familyHistory}', medintake_id='{$medintake}',\n\t \t\t\t\tmenarche='" . $post_vars["menarche"] . "', lmp='{$lmp_date}', period_duration='" . $post_vars["pduration"] . "', cycle='" . $post_vars["cycle"] . "', pads_perday='" . $post_vars["pads"] . "',\n\t \t\t\t\tonset_sexinter='" . $post_vars["sexinter"] . "', method_id='" . $post_vars["controlmethod"] . "', menopause='" . $post_vars["menopause"] . "', meno_age='" . $post_vars["menopauseage"] . "',\n\t \t\t\t\tsmoking='" . $post_vars["smoking"] . "', pack_peryear='" . $post_vars["pack"] . "', alcohol='" . $post_vars["alcohol"] . "', bottles_perday='" . $post_vars["bottles"] . "', ill_drugs='" . $post_vars["illdrugs"] . "',\n \t\t\t\t\thistory_timestamp=sysdate() WHERE patient_id = '{$patient_id}'";
$resultPE = mysql_query($sqlPE);
} else {
$sqlPE = "insert into m_patient_history (consult_id, patient_id, user_id,\n\t \t\t\t\tpasthistory_id, familyhistory_id, medintake_id,\n\t \t\t\t\tmenarche, lmp, period_duration, cycle, pads_perday,\n\t \t\t\t\tonset_sexinter, method_id, menopause, meno_age,\n\t \t\t\t\tsmoking, pack_peryear, alcohol, bottles_perday, ill_drugs, history_timestamp) \n\t \t\t\t\tvalues ('" . $get_vars["consult_id"] . "', '{$patient_id}', '" . $_SESSION["userid"] . "',\n\t \t\t\t\t'{$pastHistory}', '{$familyHistory}', '{$medintake}',\n\t \t\t\t\t'" . $post_vars["menarche"] . "', '{$lmp_date}', '" . $post_vars["pduration"] . "', '" . $post_vars["cycle"] . "', '" . $post_vars["pads"] . "',\n\t \t\t\t\t'" . $post_vars["sexinter"] . "','" . $post_vars["controlmethod"] . "', '" . $post_vars["menopause"] . "', '" . $post_vars["menopauseage"] . "',\n\t \t\t\t\t'" . $post_vars["smoking"] . "','" . $post_vars["pack"] . "', '" . $post_vars["alcohol"] . "', '" . $post_vars["bottles"] . "', '" . $post_vars["illdrugs"] . "',\n\t \t\t\t\tsysdate())";
$resultPE = mysql_query($sqlPE);
}
}
if ($post_vars["history_text"]) {
$sql = "update m_consult_notes set " . "notes_history = '" . addslashes($post_vars["history_text"]) . "' " . "where notes_id = '" . $get_vars["notes_id"] . "'";
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=NOTES&module=notes¬es=HX¬es_id=".$get_vars["notes_id"]."#menu");
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={$note_link}¬es_id=" . $get_vars["notes_id"] . "#menu");
}
}
break;
case "Save PE":
if ($post_vars["Skin"] || $post_vars["HEENT"] || $post_vars["Chest/Lungs"] || $post_vars["Heart"] || $post_vars["Abdomen"] || $post_vars["Extremities"]) {
$skin = implode(",", $post_vars["Skin"]);
$heent = implode(",", $post_vars["HEENT"]);
$chest = implode(",", $post_vars["Chest/Lungs"]);
$heart = implode(",", $post_vars["Heart"]);
$abdomen = implode(",", $post_vars["Abdomen"]);
$extremities = implode(",", $post_vars["Extremities"]);
$checkSQL = "select * from m_consult_notes_pe WHERE notes_id = '" . $get_vars["notes_id"] . "'";
if ($result = mysql_query($checkSQL)) {
if (mysql_num_rows($result)) {
$sqlPE = "update m_consult_notes_pe set user_id='" . $_SESSION["userid"] . "',\n \t\t\t\t\t\tbreast_screen='" . $post_vars["breastscreen"] . "', breast_remarks='" . $post_vars["bcscreenRemarks"] . "',\n \t\t\t\t\t\tskin_code='{$skin}', skin_remarks='" . $post_vars["SkinRemarks"] . "',\n \t\t\t\t\t\theent_code='{$heent}', heent_remarks='" . $post_vars["HEENTRemarks"] . "',\n \t\t\t\t\t\tchest_code='{$chest}', chest_remarks='" . $post_vars["Chest/LungsRemarks"] . "',\n \t\t\t\t\t\theart_code='{$heart}', heart_remarks='" . $post_vars["HeartRemarks"] . "',\n \t\t\t\t\t\tabdomen_code='{$abdomen}', abdomen_remarks='" . $post_vars["AbdomenRemarks"] . "',\n \t\t\t\t\t\textremities_code='{$extremities}', extremities_remarks='" . $post_vars["ExtremitiesRemarks"] . "',\n \t\t\t\t\t\tpe_timestamp=sysdate() WHERE notes_id = '" . $get_vars["notes_id"] . "'";
$resultPE = mysql_query($sqlPE);
} else {
$sqlPE = "insert into m_consult_notes_pe (patient_id, notes_id, consult_id, user_id,\n\t \t\t\t\tbreast_screen, breast_remarks,\n\t \t\t\t\tskin_code, skin_remarks, heent_code, heent_remarks,\n\t \t\t\t\tchest_code, chest_remarks, heart_code, heart_remarks,\n\t \t\t\t\tabdomen_code, abdomen_remarks, extremities_code, extremities_remarks,\n\t \t\t\t\tpe_timestamp) values ('{$patient_id}', '" . $get_vars["notes_id"] . "', '" . $get_vars["consult_id"] . "', '" . $_SESSION["userid"] . "',\n\t \t\t\t\t'" . $post_vars["breastscreen"] . "', '" . $post_vars["bcscreenRemarks"] . "',\n\t \t\t\t\t'{$skin}', '" . $post_vars["SkinRemarks"] . "',\n\t \t\t\t\t'{$heent}', '" . $post_vars["HEENTRemarks"] . "',\n\t \t\t\t\t'{$chest}','" . $post_vars["Chest/LungsRemarks"] . "',\n\t \t\t\t\t'{$heart}','" . $post_vars["HeartRemarks"] . "',\n\t \t\t\t\t'{$abdomen}','" . $post_vars["AbdomenRemarks"] . "',\n\t \t\t\t\t'{$extremities}','" . $post_vars["ExtremitiesRemarks"] . "',\n\t \t\t\t\tsysdate())";
$resultPE = mysql_query($sqlPE);
}
}
}
if ($post_vars["pe_text"]) {
$sql = "update m_consult_notes set " . "notes_physicalexam = '" . addslashes($post_vars["pe_text"]) . "' " . "where notes_id = '" . $get_vars["notes_id"] . "'";
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=NOTES&module=notes¬es=PE¬es_id=".$get_vars["notes_id"]."#menu");
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={$note_link}¬es_id=" . $get_vars["notes_id"] . "#menu");
}
}
break;
case "Save Diagnosis Class":
if ($post_vars["dxclass"]) {
foreach ($post_vars["dxclass"] as $key => $value) {
$sql = "insert into m_consult_notes_dxclass (notes_id, consult_id, patient_id, class_id, diagnosis_date, user_id, diagnosis_timestamp) " . "values ('" . $get_vars["notes_id"] . "', '" . $get_vars["consult_id"] . "', '{$patient_id}', '{$value}', '{$consult_date}', '" . $_SESSION["userid"] . "', sysdate())";
$result = mysql_query($sql) 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=NOTES&module=notes¬es=DX¬es_id=".$get_vars["notes_id"]."#menu");
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={$note_link}¬es_id=" . $get_vars["notes_id"] . "#menu");
}
break;
case "Save Treatment Plan":
/*$sql = "update m_consult_notes set ".
"notes_plan = '".addslashes($post_vars["plan_text"])."' plan_sms_info='".addslashes($post_vars["plan_px_info"]).
"' ".."where notes_id = '".$get_vars["notes_id"]."'"; */
$result = mysql_query("UPDATE m_consult_notes SET notes_plan='" . addslashes($post_vars["plan_text"]) . "', plan_px_info='" . addslashes($post_vars["plan_px_info"]) . "', sms_plan_info='N', sms_send_date='{$post_vars['txt_sms_px_info']}' WHERE notes_id='{$get_vars['notes_id']}'") or die("Cannot query: 411: " . mysql_error());
if ($result) {
//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=TX¬es_id=".$get_vars["notes_id"]."#menu");
//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=$note_link¬es_id=".$get_vars["notes_id"]."#menu");
}
break;
case "Add Surgical History":
list($month, $day, $year) = explode("/", $post_vars["surgicaldate"]);
$date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
if ($post_vars["surgicalname"] != null && $post_vars["surgicaldate"] != null) {
$sqlPE = "insert into m_patient_history_surgical (notes_id, consult_id, patient_id, user_id,\n\t\t \t\t\t\toperation, operation_date, operation_timestamp) \n\t\t \t\t\t\tvalues ('" . $get_vars["notes_id"] . "', '" . $get_vars["consult_id"] . "', '{$patient_id}', '" . $_SESSION["userid"] . "',\n\t\t \t\t\t\t'" . $post_vars["surgicalname"] . "', '{$date}',\n\t\t \t\t\t\tsysdate())";
$resultPE = mysql_query($sqlPE);
}
break;
case "Update Surgical History":
list($month, $day, $year) = explode("/", $post_vars["surgicaldate"]);
$date = "{$year}-" . str_pad($month, 2, "0", STR_PAD_LEFT) . "-" . str_pad($day, 2, "0", STR_PAD_LEFT);
if ($post_vars["surgicalname"] != null && $post_vars["surgicaldate"] != null) {
$sqlPE = "update m_patient_history_surgical set notes_id='" . $get_vars["notes_id"] . "', consult_id='" . $get_vars["consult_id"] . "',\n\t \t\t\t\t\tpatient_id='{$patient_id}', user_id='" . $_SESSION["userid"] . "', operation='" . $post_vars["surgicalname"] . "', \n\t \t\t\t\t\toperation_date='{$date}', operation_timestamp=sysdate() WHERE record_id='" . $post_vars["recordID"] . "'";
$resultPE = mysql_query($sqlPE);
}
break;
}
}
function display_registry_record_detail()
{
//
// called from _details_mc()
// contains most alerts for this pregnancy
//
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"]);
$arr_cause = array('SPON' => 'Spontaneous Abortion / Miscarriage', 'IND' => 'Induced Abortion', 'UNK' => 'Unknown');
$sql = "select mc_id, patient_id, consult_id, date_format(mc_timestamp, '%a %d %b %Y, %h:%i%p') mc_timestamp, " . "patient_lmp, patient_edc, trimester1_date, trimester2_date, round((to_days(mc_consult_date)-to_days(patient_lmp))/7,0) patient_aog, " . "MOD((to_days(mc_consult_date)-to_days(patient_lmp)),7) remainder, " . "trimester3_date, postpartum_date, to_days(trimester1_date) days_trim1, " . "to_days(trimester2_date) days_trim2, to_days(trimester3_date) days_trim3, " . "to_days(postpartum_date) days_pp, to_days(mc_consult_date) days_today, obscore_gp, obscore_fpal, user_id, " . "blood_type, patient_age, patient_height, delivery_date, " . "outcome_id, birthweight, end_pregnancy_flag,pregnancy_termination_cause,date_terminated_abortion,termination_code " . "from m_patient_mc where patient_id = '{$patient_id}' and mc_id = '" . $get_vars["mc_id"] . "'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$mc = mysql_fetch_array($result);
if ($get_vars["mc_id"] == $mc["mc_id"]) {
print "<form method='post' action='" . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=mc&mc=" . $get_vars["mc"] . "&mc_id=" . $get_vars["mc_id"] . "#visit1form' name='display_reg_detail'>";
print "<table width='350' style='border: 1px dotted black'><tr><td>";
print "<span class='tinylight'>";
print "REGISTRY ID: <font color='red'>" . module::pad_zero($mc["mc_id"], 7) . "</font><br/>";
print "PATIENT NAME: " . patient::get_name($patient_id) . "<br/>";
$patient_age = patient::get_age($patient_id);
print "AGE: " . (!mc::is_normal_age($patient_age) ? "<font color='red'><b>{$patient_age}</b></font>" : $patient_age) . "<br/>";
print "SCORE: " . mc::check_gp_score($mc["obscore_gp"]) . " " . mc::check_fpal_score($mc["obscore_fpal"]) . "<br/>";
print "<hr size='1'/>";
print "REG DATE: " . $mc["mc_timestamp"] . "<br/>";
print "REG BY: " . user::get_username($mc["user_id"]) . "<br/>";
print "<hr size='1'/>";
print "<table cellpadding='0' cellspacing='0'><tr valign='top'><td>";
// column 1
print "<span class='tinylight'>";
print "LMP: " . $mc["patient_lmp"] . "<br/>";
print "EDC: " . $mc["patient_edc"] . "<br/>";
// get AOG according to whether patient has delivered or not
// if has delivered, compute AOG according to that
// if not compute by consult_date
list($aog_wks, $aog_days) = mc::get_aog($mc["mc_id"], mc::get_delivery_date($mc["mc_id"]) == "0000-00-00" ? healthcenter::get_consult_date($get_vars["consult_id"]) : mc::get_delivery_date($mc["mc_id"]));
print "AOG: " . $aog_wks . " WKS " . $aog_days . " DAYS<br/>";
print "</span>";
print "</td><td>";
// column 2
print "<span class='tinylight'>";
print " BLOOD TYPE: " . ($mc["blood_type"] == "AB" ? "<font color='red'><b>" . $mc["blood_type"] . "</b></font>" : $mc["blood_type"]) . "<br/>";
print " HEIGHT (cm): " . (!mc::is_normal_height($mc["patient_height"]) ? "<font color='red'><b>" . $mc["patient_height"] . "</b></font>" : $mc["patient_height"]) . "<br/>";
list($systolic, $diastolic) = healthcenter::get_blood_pressure($get_vars["consult_id"]);
print " SYS BP: " . ($systolic ? $systolic : "NA") . "<br/>";
print " DIAS BP: " . ($diastolic ? $diastolic : "NA") . "<br/>";
if ($systolic && $diastolic) {
print " STAGE: ";
healthcenter::hypertension_stage($systolic, $diastolic, $patient_age) . "<br/>";
}
print "</span>";
print "</td></tr></table>";
print "<hr size='1'/>";
print "IMPORTANT DATES:<br/>";
print "End of 1st trimester: " . ($mc["days_today"] >= $mc["days_trim1"] ? "<font color='red'>" . $mc["trimester1_date"] . "</font>" : $mc["trimester1_date"]) . "<br/>";
print "End of 2nd trimester: " . ($mc["days_today"] >= $mc["days_trim2"] ? "<font color='red'>" . $mc["trimester2_date"] . "</font>" : $mc["trimester2_date"]) . "<br/>";
print "End of 3rd trimester: " . ($mc["days_today"] >= $mc["days_trim3"] ? "<font color='red'>" . $mc["trimester3_date"] . "</font>" : $mc["trimester3_date"]) . "<br/>";
print "End of postpartum period: " . ($mc["days_today"] >= $mc["days_pp"] ? "<font color='red'>" . $mc["postpartum_date"] . "</font>" : $mc["postpartum_date"]) . "<br/>";
echo "<hr size='1'>";
echo "Tetanus Toxoid Status: ";
echo "<font color='red'><b>" . mc::get_tt_status($mc["mc_id"], $patient_id, $mc["patient_edc"]) . "</b></font>";
echo "</hr>";
print "<hr size='1'/>";
print "RISK FACTORS:<br/>";
$sql_risk = "select c.visit_risk_id, r.hospital_flag, r.monitor_flag " . "from m_consult_mc_visit_risk c, m_lib_mc_risk_factors r " . "where c.visit_risk_id = r.risk_id and " . "c.consult_id = '" . $mc["consult_id"] . "'";
if ($result_risk = mysql_query($sql_risk)) {
if (mysql_num_rows($result_risk)) {
while ($risk = mysql_fetch_array($result_risk)) {
print "<img src='../images/arrow_redwhite.gif' border='0' /> ";
print ($risk["hospital_flag"] == "Y" ? "<font color='red'>" . mc::get_riskfactor_name($risk["visit_risk_id"]) . "</font>" : mc::get_riskfactor_name($risk["visit_risk_id"])) . "<br/>";
}
}
}
if ($mc["delivery_date"] != "0000-00-00") {
// if registry record closed display the rest
print "<hr size='1'/>";
print "<table cellspacing='0' cellpadding='0' width='100%' bgcolor='#CCFFCC'><tr><td class='tinylight'>";
print "DELIVERY DATE: " . $mc["delivery_date"] . "<br/>";
print "OUTCOME: " . mc::get_pregnancy_outcome($mc["outcome_id"]) . "<br/>";
print "BIRTH WT (KG): " . $mc["birthweight"] . "<br/>";
print "</td></tr>";
echo "</table>";
}
if ($mc["end_pregnancy_flag"] == 'Y') {
echo "<p align='center'><input type='submit' value='Open Pregnancy Record' name='submitmc' class='tinylight' style='border: 1px solid black'></input></p>";
}
print "<br/>";
if (!empty($mc["pregnancy_termination_cause"]) && $mc[end_pregnancy_flag] == 'Y') {
echo "<hr size='1'>";
echo "DETAILS OF TERMINATION: ";
echo $mc["pregnancy_termination_cause"] . "<br/>";
echo "CAUSE OF TERMINATION: ";
echo empty($mc["termination_code"]) ? ' ' : $arr_cause[$mc["termination_code"]] . '</br>';
echo "DATE OF PREGNANCY TERMINATION: ";
echo $mc["date_terminated_abortion"];
echo "</hr>";
}
if ($_SESSION["priv_add"]) {
if ($mc["end_pregnancy_flag"] == "N") {
// prevent editing of closed registry record
echo "<hr size='1'>";
print "<p align='center'>";
print "<input type='submit' name='submitmc' value='Update Visit 1' class='tinylight' style='border: 1px solid black'/><br><br>";
print "<input type='submit' name='submitmc' value='Update Postpartum Data Form' class='tinylight' style='border: 1px solid black'/><br><br>";
print "<input type='submit' name='submitmc' value='Delete Postpartum Data Form' class='tinylight' style='border: 1px solid black'/><br><br>";
print "<input type='submit' name='submitmc' value='Terminate This Pregnancy' class='tinylight' style='border: 1px solid black'/> ";
print "</span>";
echo "</hr>";
}
print "<input type='hidden' name='mc_id' value='" . $mc["mc_id"] . "'/>";
}
print "</span>";
print "</td></tr>";
echo "<tr><td>";
switch ($_POST["submitmc"]) {
case "Terminate This Pregnancy":
if (mc::check_postpartum($_GET["mc_id"], $patient_id)) {
echo "<script language='javascript'>";
echo "window.alert('This patient has record for postpartum (i.e. date of delivery). Termination of pregnancy should occur during the prenatal period and before the actual delivey due to certain causes like miscarriage and abortion. If the you wish to terminate this pregnancy, Delete the Postpartum Data first to clear out the postpartum data.')";
echo "</script>";
} else {
//before terminating the pregnancy, make sure that cause is being captured
mc::display_terminate_cause();
}
break;
default:
break;
}
echo "</td></tr>";
echo "</table>";
print "</form>";
}
}
}
}
function form_consult_appointment() {
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];
if ($get_vars["cid"] && $get_vars["injury_ts"]) {
$sql = "select injury_id, mechanism_code, location_code, injury_date, injury_time, location_detail ".
"from m_consult_injury ".
"where consult_id = '".$get_vars["cid"]."' and injury_timestamp = '".$get_vars["injury_ts"]."'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$injury = mysql_fetch_array($result);
}
}
}
}
$pxid = healthcenter::get_patient_id($get_vars[consult_id]);
$cp = $this->get_patient_cellphone($pxid);
$this->process_consult_appointment($menu_id,$post_vars,$get_vars,$validuser,$isadmin);
$consult_date = healthcenter::get_consult_date($get_vars[consult_id]);
$cons_date = $this->parse_date($consult_date);
print "<table width='300'>";
print "<form action = '".$_SERVER["SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=".$get_vars["ptmenu"]."' name='form_consult_appointment' method='post'>";
print "<tr valign='top'><td>";
print "<b>".FTITLE_APPOINTMENT_SCHEDULER."</b><br/><br/>";
print "</td></tr>";
print "<tr valign='top'><td>";
print "<span class='boxtitle'>".LBL_APPOINTMENT_DATE."</span><br> ";
if ($appointment["visit_date"]) {
list($year, $month, $day) = explode("-", $appointment["visit_date"]);
$appointment_date = "$month/$day/$year";
}
print "<input type='text' size='15' maxlength='10' class='textbox' name='appointment_date' value='".($appointment_date?$appointment_date:$post_vars["appointment_date"])."' style='border: 1px solid #000000'> ";
print "<a href=\"javascript:show_calendar4('document.form_consult_appointment.appointment_date', document.form_consult_appointment.appointment_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a><br>";
print "<small>Click on the calendar icon to select date. Otherwise use MM/DD/YYYY format.</small><br>";
print "<br/></td></tr>";
print "<tr valign='top'><td>";
print "<span class='boxtitle'>".LBL_APPOINTMENT_CODE."</span><br> ";
print appointment::checkbox_appointment($injury["injury_id"]?$injury["injury_id"]:$post_vars["injury_id"]);
print "<br/></td></tr>";
print "<tr valign='top'><td>";
print "<span class='boxtitle'>".LBL_REMINDER_FLAG."</span><br> ";
print "<input type='checkbox' name='reminder_flag' value='1'/> Check to send reminder<br/>";
print "<br/></td></tr>";
print "<tr>";
print "<td><span class='boxtitle'>PATIENT CELLPHONE NUMBER</span>";
print "<input type='textbox' name='patient_cp' size='10' maxlength='11' value='$cp'></input>";
print "<input type='hidden' name='valid' value='0'></input>";
print "<input type='hidden' name='action_button' value=''>";
print "<input type='hidden' name='hidden_cp' value='$cp'>";
if(empty($cp)):
print "<br><b><font color='red' size='2'>(patient no cellphone, please indicate)</font></b>";
endif;
print "</td>";
print "</tr>";
print "<tr valign='top'><td>";
print "<tr><td>";
if ($get_vars["cid"] && $get_vars["injury_ts"]) {
print "<input type='hidden' name='cid' value='".$get_vars["cid"]."'>";
print "<input type='hidden' name='injury_ts' value='".$get_vars["injury_ts"]."'>";
if ($_SESSION["priv_update"]) {
print "<input type='button' value = 'Update Schedule' class='textbox' name='submitsked' style='border: 1px solid #000000' onclick='check_appt_info()'> ";
}
if ($_SESSION["priv_delete"]) {
print "<input type='submit' value = 'Delete Schedule' class='textbox' name='submitsked' style='border: 1px solid #000000'> ";
}
} else {
if ($_SESSION["priv_add"]) {
print "<br><input type='button' value = 'Save Schedule' class='textbox' name='submitsked' style='border: 1px solid #000000' onclick='check_appt_info()'><br> ";
}
}
print "</td></tr>";
print "</form>";
print "</table><br>";
}
function display_ntp_record_details()
{
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);
}
// manage Delete here
if ($post_vars["submitntp"] && $get_vars["ntp_id"]) {
if ($post_vars["submitntp"] == "Delete") {
if (module::confirm_delete($menu_id, $post_vars, $get_vars)) {
print $sql = "delete from m_patient_ntp where ntp_id = '" . $get_vars["ntp_id"] . "'";
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"] . "&ntp=VISIT1");
}
} 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"] . "&ntp=VISIT1");
}
}
}
}
$patient_id = healthcenter::get_patient_id($get_vars["consult_id"]);
$consult_date = healthcenter::get_consult_date($get_vars["consult_id"]);
$sql = "select patient_id, date_format(ntp_consult_date, '%a %d %b %Y, %h:%i%p') ntp_consult_date, date_format(ntp_timestamp, '%a %d %b %Y, %h:%i%p') ts, ntp_id, user_id, " . "occupation_id, household_contacts, region_id, body_weight, bcg_scar, " . "previous_treatment_flag, previous_treatment_duration, previous_treatment_drugs, " . "patient_type_id, outcome_id, treatment_partner_id, treatment_category_id, contact_person, course_end_flag, " . "intensive_start_date, maintenance_start_date, treatment_end_date, " . "sputum1_date, sputum2_date, sputum3_date, " . "intensive_projected_end_date, maintenance_projected_end_date, " . "to_days('{$consult_date}') days_consult_date, " . "to_days(intensive_projected_end_date) days_proj_int_end, " . "to_days(maintenance_projected_end_date) days_proj_maint_end, " . "to_days(sputum1_date) days_sputum1_date, " . "to_days(sputum2_date) days_sputum2_date, " . "to_days(sputum3_date) days_sputum3_date " . "from m_patient_ntp " . "where ntp_id = '" . $get_vars["ntp_id"] . "'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
while ($ntpdata = mysql_fetch_array($result)) {
print "<table width='250' style='border: 1px dotted black'>";
print "<form method='post' action='" . $_SERVER["PHP_SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=ntp&ntp=INTAKE&ntp_id=" . $get_vars["ntp_id"] . "'>";
print "<tr><td>";
print "<span class='tinylight'>";
print "Patient Name: " . strtoupper(patient::get_name($ntpdata["patient_id"])) . "<br/>";
print "Registration Date: " . $ntpdata["ntp_consult_date"] . "<br/>";
print "Last Update: " . $ntpdata["ts"] . "<br/>";
print "Updated By: " . user::get_username($ntpdata["user_id"]) . "<br/>";
print "<hr size='1'/>";
print "IMPORTANT DATES:<br/>";
print "Start Intensive Phase: " . ($ntpdata["intensive_start_date"] != "0000-00-00" ? $ntpdata["intensive_start_date"] : "NA") . "<br/>";
print "Start Maintenance Phase: " . ($ntpdata["maintenance_start_date"] != "0000-00-00" ? $ntpdata["maintenance_start_date"] : "NA") . "<br/>";
print "End of Treatment: " . ($ntpdata["maintenance_start_date"] != "0000-00-00" ? $ntpdata["maintenance_start_date"] : "NA") . "<br/><br/>";
print "PROJECTED DATES:<br/>";
print "Proj End Intensive Phase: " . ($ntpdata["intensive_projected_end_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_proj_int_end"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["intensive_projected_end_date"] . "</font>" : $ntpdata["intensive_projected_end_date"])) . "<br/>";
print "Proj End Maint Phase: " . ($ntpdata["maintenance_projected_end_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_proj_maint_end"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["maintenance_projected_end_date"] . "</font>" : $ntpdata["maintenance_projected_end_date"])) . "<br/>";
if ($ntpdata["treatment_category"] == 3) {
print "Sputum Exam #1 Date: " . ($ntpdate["sputum1_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_sputum1_date"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["sputum1_date"] . "</font>" : $ntpdata["sputum1_date"])) . "<br/>";
} else {
print "Sputum Exam #1 Date: " . ($ntpdate["sputum1_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_sputum1_date"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["sputum1_date"] . "</font>" : $ntpdata["sputum1_date"])) . "<br/>";
print "Sputum Exam #2 Date: " . ($ntpdate["sputum2_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_sputum2_date"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["sputum2_date"] . "</font>" : $ntpdata["sputum2_date"])) . "<br/>";
print "Sputum Exam #3 Date: " . ($ntpdate["sputum3_date"] == "0000-00-00" ? "NA" : ($ntpdata["days_sputum3_date"] <= $ntpdata["days_consult_date"] ? "<font color='red'>" . $ntpdata["sputum3_date"] . "</font>" : $ntpdata["sputum3_date"])) . "<br/>";
}
print "<hr size='1'/>";
print "Occupation: " . occupation::get_occupation_name($ntpdata["occupation_id"]) . "<br/>";
print "Contact Person: " . $ntpdata["contact_person"] . "<br/>";
print "Region: " . region::get_region_name($ntpdata["region_id"]) . "<br/>";
print "<hr size='1'/>";
print "BCG Scar: " . ($ntpdata["bcg_scar"] == "D" ? "Doubtful" : $ntpdata["bcg_scar"]) . "<br/>";
print "Household Contacts: " . $ntpdata["household_contacts"] . " " . ($ntpdata["household_contacts"] == 1 ? "person" : "persons") . "<br/>";
print "Previous Treatment? " . $ntpdata["previous_treatment_flag"] . "<br/>";
if ($ntpdata["previous_treatment_flag"] == "Y") {
print "<span class='tinylight'>";
print " Drugs: " . $ntpdata["previous_treatment_drugs"] . "<br/>";
print " Duration: " . ($ntpdata["previous_treatment_duration"] == "M1" ? ">1 month" : "<1 month") . "<br/>";
print "</span>";
}
print "Patient Type: " . ntp::get_patient_type($ntpdata["patient_type_id"]) . "<br/>";
print "Tx Category: " . ntp::get_treatment_cat($ntpdata["treatment_category_id"]) . "<br/>";
print "Tx Outcome: " . ntp::get_treatment_outcome($ntpdata["outcome_id"]) . "<br/>";
print "Tx Partner: " . ntp::get_partner_name($ntpdata["treatment_partner_id"]) . "<br/>";
if ($_SESSION["priv_delete"]) {
if ($ntpdata["course_end_flag"] != "Y") {
print "<input type='submit' class='tinylight' name='submitntp' value='Delete' style='border: 1px solid black'/>";
}
}
print "</span>";
print "</td></tr>";
print "</form>";
print "</table>";
}
}
}
}
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;
}
}
