public function authenticate(user $user) { $password = sha1($this->config->item('salt') . $user->get_password()); $row = $this->db->get_where('users', array('username' => $user->get_username()))->row(); if ($row != null) { if ($row->password == $password) { if ($row->confirm) { $user->set_id($row->id); return 'LOGGEDIN'; } else { return 'ACCOUNT_INVALID'; } } else { return 'PASSWORD_INCORRECT'; } } else { return 'USER_NOT_FOUND'; } }
function form_consult_lab_fecalysis() { 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]; } $q_fecalysis = mysql_query("SELECT date_format(date_lab_exam,'%m/%d/%Y') as 'date_lab_exam',fecal_color,fecal_consistency,fecal_occultblood,fecal_ova,fecal_wbc,fecal_rbc,fecal_bacteria,fecal_fat,fecal_starch,fecal_others,user_id,patient_id FROM m_consult_lab_fecalysis WHERE request_id='{$_GET['request_id']}'") or die("Cannot query 150" . mysql_error()); $q_lab_details = mysql_query("SELECT patient_id,date_format(request_timestamp,'%a %d %b %Y, %h %i %p') as 'date_requested', request_user_id, date_format(done_timestamp,'%a %d %b %Y, %h %i %p') as 'date_done', request_done, done_user_id FROM m_consult_lab WHERE request_id='{$_GET['request_id']}'") or die("Cannot query 151:" . mysql_error()); list($pxid, $date_request, $request_user_id, $date_done, $request_done, $done_user_id) = mysql_fetch_array($q_lab_details); if (mysql_num_rows($q_fecalysis) != 0) { list($date_lab_exam, $color, $consistency, $blood, $ova, $wbc, $rbc, $bacteria, $fat, $starch, $others, $userid, $pxid) = mysql_fetch_row($q_fecalysis); } else { $date_lab_exam = date('m/d/Y'); } echo "<a name='fecalysis'></a>"; echo "<form action='{$_SERVER['PHP_SELF']}?page={$get_vars['page']}&menu_id={$get_vars['menu_id']}&consult_id={$get_vars['consult_id']}&module=fecalysis&request_id={$get_vars['request_id']}&lab_id=FEC&ptmenu=LABS#fecalysis' name='form_lab' method='post'>"; echo "<span class='tinylight'>"; echo "<b>LAB REQUEST DETAILS</b><br/>"; echo "<table width='250' bgcolor='#ffff99' style='border: 1px solid black'>"; //echo "<tr><td class='tinylight'><b>REQUEST ID: </b><font color='red'>".module::pad_zero($_GET["request_id"],7)."</font><br/>"; echo "<tr><td class='tinylight'><b>LAB EXAM: </b>FECALYSIS<br/>"; echo "<b>DATE REQUESTED: </b>" . $date_request . "<br/>"; echo "<b>REQUESTED BY: </b>" . user::get_username($request_user_id) . "<br/>"; echo "<b>DATE COMPLETED: </b>" . $date_done . "<br/>"; echo "<b>PROCESSED BY: </b>" . ($done_user_id ? user::get_username($done_user_id) : "NA") . "<br/>"; echo "<b>RELEASED: </b>" . $request_done . "<br/></td></tr>"; echo "</table>"; echo "<hr size='1'/>"; echo "<table style='border: 1px dotted black'>"; echo "<tr><td colspan='2' class='boxtitle'>DATE EXAMINED <input type='text' name='fecal_date' size='8' maxlength='10' value='{$date_lab_exam}' class='tinylight'></input> "; echo "<a href=\"javascript:show_calendar4('document.form_lab.fecal_date', document.form_lab.fecal_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; echo "</td></tr>"; echo "<tr><td colspan='2' align='center' class='boxtitle'>MACROSCOPIC</td></tr>"; echo "<tr><td colspan='2' class='boxtitle' align='center'>PHYSICAL</td></tr>"; echo "<tr valign='top' class='tinylight'><td class='boxtitle'>COLOR</td><td><input name='fecal_color' type='text' size='9' value='{$color}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>CONSISTENCY</td><td><input name='fecal_consistency' type='text' size='9' value='{$consistency}' class='tinylight'></input></td></tr>"; echo "<tr><td colspan='2' class='boxtitle' align='center'>CHEMICAL</td></tr>"; echo "<tr><td class='boxtitle'>OCCULT BLOOD</td><td><textarea name='fecal_blood' rows='2' cols='20' class='tinylight'>{$blood}</textarea></td></tr>"; echo "<tr><td colspan='2'> </td></tr>"; echo "<tr><td colspan='2' class='boxtitle' align='center'>MICROSCOPIC</td></tr>"; echo "<tr valign='top'><td class='boxtitle'>OVA OR PARASITE</td>"; echo "<td><textarea name='fecal_ova' rows='2' cols='20' class='tinylight'>{$ova}</textarea></td></tr>"; echo "<tr valign='top'><td class='boxtitle'>WBC</td>"; echo "<td><input name='fecal_wbc' type='text' size='9' value='{$wbc}' class='tinylight'></input> /hpf</td></tr>"; echo "<tr valign='top'><td class='boxtitle'>RBC</td>"; echo "<td><input name='fecal_rbc' type='text' size='9' value='{$rbc}' class='tinylight'></input> /hpf</td></tr>"; echo "<tr valign='top'><td class='boxtitle'>BACTERIA</td>"; echo "<td><input name='fecal_bacteria' type='text' size='9' value='{$bacteria}' class='tinylight'></input></td></tr>"; echo "<tr valign='top'><td class='boxtitle'>FAT GLOBULES</td>"; echo "<td><input name='fecal_fat' type='text' size='9' value='{$fat}' class='tinylight'></input></td></tr>"; echo "<tr valign='top'><td class='boxtitle'>STARCH GLOBULES</td>"; echo "<td><input name='fecal_starch' type='text' size='9' value='{$starch}' class='tinylight'></input></td></tr>"; echo "<tr valign='top'><td class='boxtitle'>OTHERS</td>"; echo "<td><textarea name='fecal_others' rows='2' cols='20' class='tinylight'>{$others}</textarea></td></tr>"; echo "<tr valign='top'><td colspan='2'>"; echo "<span class='boxtitle'>" . LBL_RELEASE_FLAG . "</span><br>"; echo "<input type='checkbox' name='release_flag' " . (($fecalysis["release_flag"] ? $fecalysis["release_flag"] : $post_vars["release_flag"]) == "Y" ? "checked" : "") . " value='1'/> " . INSTR_RELEASE_FLAG . "<br />"; echo "</td></tr>"; echo "<tr><td colspan='2' align='center'>"; if ($get_vars["request_id"]) { print "<input type='hidden' name='request_id' value='" . $get_vars["request_id"] . "'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } } echo "</td></tr>"; echo "</table>"; echo "</form>"; }
function display_vaccine_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); } $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $sql = "select consult_id, user_id, patient_id, vaccine_timestamp, date_format(vaccine_timestamp, '%a %d %b %Y, %h:%i%p'), " . "vaccine_id, adr_flag, actual_vaccine_date, source_module " . "from m_consult_vaccine where " . "vaccine_id = '" . $get_vars["vaccine"] . "' and patient_id = '{$patient_id}' and " . "vaccine_timestamp = '" . $get_vars["ts"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { list($cid, $uid, $pid, $vstamp, $vdate, $vid, $adr, $actual_date, $source) = mysql_fetch_array($result); print "<a name='detail'>"; print "<table width='250' cellpadding='3' style='border:1px dashed black'><tr><td>"; print "<form name='form_vaccine_detail' method='post' action='" . $_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&vaccine={$vid}&ts={$vstamp}&actual={$actual_vdate}'>"; print "<span class='tinylight'>"; print "PATIENT: " . patient::get_name($pid) . "<br/>"; print "DATA SOURCE: " . strtoupper($source) . "<br/>"; print "VACCINE: " . vaccine::get_vaccine_name($vid) . "<br/>"; print "REPORT DATE: {$vdate}<br/>"; print "RECORDED BY: " . user::get_username($uid) . "<br/>"; print "ACTUAL VACCINE DATE:<br/>"; if ($actual_date != "0000-00-00") { list($year, $month, $day) = explode("-", $actual_date); $conv_date = "{$month}/{$day}/{$year}"; } print "<input type='text' size='10' maxlength='10' class='tinylight' name='actual_vaccine_date' value='" . ($conv_date ? $conv_date : $post_vars["actual_vaccine_date"]) . "' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_vaccine_detail.actual_vaccine_date', document.form_vaccine_detail.actual_vaccine_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a><br>"; print "<input type='checkbox' name='adr_flag' " . ($adr == "Y" ? "checked" : "") . " value='1'/> " . INSTR_ADVERSE_VACCINE_REACTION . "<br/>"; print "<input type='hidden' name='vaccine' value='" . $get_vars["vaccine"] . "'/>"; print "<input type='hidden' name='vaccine_consult_id' value='{$cid}'/>"; print "<input type='hidden' name='ts' value='" . $get_vars["ts"] . "'/>"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Record' class='tinylight' style='border: 1px solid black'/> "; } if ($_SESSION["priv_update"]) { print "<input type='submit' name='submitdetail' value='Update Record' class='tinylight' style='border: 1px solid black'/> "; } print "</span>"; print "</form>"; print "</td></tr></table>"; } } }
function form_news() { // // called from _vaccine() // if (func_num_args()) { $arg_list = func_get_args(); $menu_id = $arg_list[0]; $post_vars = $arg_list[1]; $get_vars = $arg_list[2]; $isadmin = $arg_list[3]; if ($get_vars["news_id"]) { $sql = "select news_id, news_title, news_timestamp, news_author, news_lead, news_text, news_active ". "from m_news where news_id = '".$get_vars["news_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $news = mysql_fetch_array($result); } //print_r($news); } } } print "<table width='300'>"; print "<form action = '".$_SERVER["SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."' name='form_news' method='post'>"; print "<tr valign='top'><td>"; print "<span class='library'>".FTITLE_NEWS_FORM."</span><br><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; if ($get_vars["news_id"]) { print "<b>CREATED:</b> ".$news["news_timestamp"]."<br />"; } else { print "<b>NOTE: Fill up the form with your news item content.</b><br /><br />"; } print "</td></tr>"; if ($_SESSION["isadmin"]) { print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_NEWS_AUTHOR."</span><br> "; print user::show_users(($news["news_author"]?$news["news_author"]:$post_vars["user_id"])); print "</td></tr>"; } else { print "<b>AUTHOR: </b>".user::get_username($_SESSION["userid"])."<br />"; print "<input type='hidden' name='user_id' value='".$_SESSION["userid"]."' />"; } print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_NEWS_ACTIVE."</span><br> "; print "<input type='checkbox' name='news_active' ".($news["news_active"]=="Y"?"checked":"")." value='1' > ".INSTR_CHECK_ACTIVATE."<br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_NEWS_TITLE."</span><br> "; print "<input type='text' class='textbox' size='25' maxlength='50' name='news_title' value='".($news["news_title"]?$news["news_title"]:$post_vars["news_title"])."' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_NEWS_LEAD."</span><br> "; print "<textarea rows='3' cols='35' name='news_lead' class='textbox' style='border: 1px solid #000000'>".stripslashes(($news["news_lead"]?$news["news_lead"]:$post_vars["news_lead"]))."</textarea>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_NEWS_TEXT."</span><br> "; print "<textarea rows='7' cols='35' name='news_text' class='textbox' style='border: 1px solid #000000'>".stripslashes(($news["news_text"]?$news["news_text"]:$post_vars["news_text"]))."</textarea>"; print "</td></tr>"; print "<tr><td><br>"; if ($get_vars["news_id"]) { print "<input type='hidden' name='news_id' value='".$get_vars["news_id"]."'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update News' class='textbox' name='submitnews' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete News' class='textbox' name='submitnews' style='border: 1px solid #000000'> "; } } else { if ($_SESSION["priv_add"]) { print "<input type='submit' value = 'Add News' class='textbox' name='submitnews' style='border: 1px solid #000000'> "; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function display_consult_notes_detail() { if (func_num_args()) { $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]; } // do some processing here if ($get_vars["delete_complaint_id"]) { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_notes_complaint ". "where notes_id = '".$get_vars["notes_id"]."' and ". "consult_id = '".$get_vars["consult_id"]."' and ". "complaint_id = '".$get_vars["delete_complaint_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_id"]); } } } if ($get_vars["delete_class_id"]) { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_notes_dxclass ". "where notes_id = '".$get_vars["notes_id"]."' and ". "consult_id = '".$get_vars["consult_id"]."' and ". "class_id = '".$get_vars["delete_class_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_id"]); } } } // continue with real task $sql = "select notes_id, consult_id, notes_history, ". "notes_physicalexam, notes_plan, user_id, date_format(notes_timestamp, '%a %d %b %Y, %h:%i%p') ts ". "from m_consult_notes where consult_id = '".$get_vars["consult_id"]."' and ". "notes_id = '".$get_vars["notes_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $notes = mysql_fetch_array($result); print "<form method='post' action=''>"; print "<table width='300' cellpadding='2' style='border: 1px dashed black'><tr><td>"; print "<span class='tinylight'>"; print "<b>NOTES ID:</b> <font color='red'>".module::pad_zero($notes["notes_id"],7)."</font><br/>"; print "<b>DATE/TIME:</b> ".$notes["ts"]."<br/>"; print "<b>TAKEN BY:</b> ".user::get_username($notes["user_id"])."<br/>"; print "<hr size='1'/>"; print "<b>COMPLAINTS:</b><br/>"; notes::show_complaints($menu_id, $post_vars, $get_vars); print "<hr size='1'/>"; print "<b>HISTORY:</b><br/>"; if (strlen($notes["notes_history"])>0) { print stripslashes(nl2br($notes["notes_history"]))."<br/>"; if ($_SESSION["priv_update"]) { print "<br/>"; print "<input type='submit' name='submitdetail' value='Update History' class='tinylight' style='border: 1px solid black'"; } } else { print "<font color='red'>No recorded history.</font><br/>"; } print "<hr size='1'/>"; print "<b>PHYSICAL EXAM:</b><br/>"; if (strlen($notes["notes_physicalexam"])>0) { print stripslashes(nl2br($notes["notes_physicalexam"]))."<br/>"; if ($_SESSION["priv_update"]) { print "<br/>"; print "<input type='submit' name='submitdetail' value='Update PE' class='tinylight' style='border: 1px solid black'"; } } else { print "<font color='red'>No recorded PE.</font><br/>"; } print "<hr size='1'/>"; print "<b>DIAGNOSIS:</b><br/>"; notes::show_diagnosis($menu_id, $post_vars, $get_vars); print "<hr size='1'/>"; print "<b>PLAN:</b><br/>"; if (strlen($notes["notes_plan"])>0) { print stripslashes(nl2br($notes["notes_plan"]))."<br/>"; if ($_SESSION["priv_update"]) { print "<br/>"; print "<input type='submit' name='submitdetail' value='Update Plan' class='tinylight' style='border: 1px solid black'"; } } else { print "<font color='red'>No recorded plan.</font><br/>"; } print "<hr size='1'/>"; print "<input type='hidden' name='notes_id' value='".$get_vars["notes_id"]."' />"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Notes' class='tinylight' style='border: 1px solid black; background-color: #FF6633;'/> "; } print "</span>"; print "</td></tr></table><br>"; print "</form>"; } } }
function vitals_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]; $validuser = $arg_list[3]; $isadmin = $arg_list[4]; //print_r($arg_list); } // process delete here if ($post_vars["submitvitals"]) { if ($post_vars["submitvitals"]=="Delete") { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql_delete = "delete from m_consult_vitals ". "where consult_id = '".$get_vars["consult_id"]."' and ". "vitals_timestamp = '".$get_vars["timestamp"]."'"; if ($result_delete = mysql_query($sql_delete)) { header("location: ".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=VITALS"); } } 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=VITALS"); } } } } $sql = "select user_id, vitals_weight, vitals_temp, vitals_systolic, vitals_diastolic, vitals_heartrate, vitals_resprate,vitals_height,vitals_pulse ". "from m_consult_vitals where consult_id = '".$get_vars["consult_id"]."' and vitals_timestamp = '".$get_vars["timestamp"]."'"; $edad = healthcenter::get_patient_age($get_vars["consult_id"]); if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { list($uid, $wt, $temp, $syst, $diast, $hrate, $rrate,$ht,$pulse) = mysql_fetch_array($result); print "<a name='detail'>"; 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=VITALS×tamp=".$get_vars["timestamp"]."' name='form_vitals_detail'>"; print "<table width='250' style='border: 1px dotted black'><tr><td colspan='2'>"; print "Taken by: ".user::get_username($uid)."<br/>"; print "<td></tr>"; print "<tr valign='top'><td>"; print "BP: $syst/$diast<br/>"; print "HR: $hrate<br/>"; print "RR: $rrate<br/>"; print "Pulse Rate: $pulse<br/>"; print "</td><td>"; print "Weight (kg): $wt<br/>"; print "Temp deg C: $temp<br/>"; print "Height: $ht cms<br/>"; print "</td></tr>"; print "<tr><td colspan='2'>"; print "HPN STAGE: ".healthcenter::hypertension_stage($syst, $diast, $edad)."<br/>"; print healthcenter::compute_bmi($ht,$wt); print "</td></tr>"; print "<tr><td colspan='2'>"; //if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitvitals' value='Update' class='tinylight' style='border: 1px solid black'/> "; print "<input type='submit' name='submitvitals' value='Delete' class='tinylight' style='border: 1px solid black'/>"; //} print "</td></tr>"; print "</table>"; print "</form>"; } } }
function show_service_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); } $sql = "select ccdev_id, consult_id, user_id, patient_id, ccdev_timestamp, date_format(ccdev_timestamp, '%a %d %b %Y, %h:%i%p'), ". "service_id, round(age_on_service,2) ". "from m_consult_ccdev_services where ". "ccdev_id = '".$get_vars["ccdev_id"]."' and service_id = '".$get_vars["service_id"]."' and ". "ccdev_timestamp = '".$get_vars["sts"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { list($cdid, $cid, $uid, $pid, $cstamp, $sdate, $sid, $age_service) = mysql_fetch_array($result); print "<a name='detail'>"; print "<table width='250' cellpadding='3' style='border:1px dashed black'><tr><td>"; print "<form name='form_service_detail' method='post' action='".$_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=".$get_vars["ccdev"]."'>"; print "<span class='tinylight'>"; print "REGISTRY ID: $cdid<br/>"; print "SERVICE: ".ccdev::get_service_name($sid)."<br/>"; print "REPORT DATE: $sdate<br/>"; print "AGE ON SERVICE: $age_service weeks<br/>"; print "RECORDED BY: ".user::get_username($uid)."<br/>"; print "<input type='hidden' name='service' value='$sid'/>"; print "<input type='hidden' name='sts' value='$cstamp'/>"; print "<input type='hidden' name='ccdev_id' value='$cdid'/>"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Service' class='tinylight' style='border: 1px solid black'/> "; } print "</span>"; print "</form>"; print "</td></tr></table>"; } } }
function form_consult_lab_sputum() { 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); } echo "<a name='sputum'></a>"; 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"]."&module=sputum&request_id=".$get_vars["request_id"]."&lab_id=SPT". "&ptmenu=LABS' name='form_lab' method='post'>"; print "<tr valign='top'><td>"; print "<b>".FTITLE_LAB_EXAM_FORM."</b><br><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_LAB_REQUEST_DETAILS."</span><br> "; $sql = "select lab_id, consult_id, date_format(request_timestamp, '%a %d %b %Y, %h:%i%p') request_timestamp, request_user_id, request_done, "."date_format(done_timestamp, '%a %d %b %Y, %h:%i%p') done_timestamp, done_user_id "."from m_consult_lab "."where request_id = '".$get_vars["request_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $lab = mysql_fetch_array($result); print "<table width='250' bgcolor='#FFFF99' style='border: 1px solid black'><tr><td class='tinylight'>"; print "<b>".LBL_LAB_EXAM.":</b> ".lab::get_lab_name($lab["lab_id"])."<br/>"; print "<b>".LBL_DATE_REQUESTED.":</b> ".$lab["request_timestamp"]."<br/>"; print "<b>".LBL_REQUESTED_BY.":</b> ".user::get_username($lab["request_user_id"])."<br/>"; print "<b>".LBL_DATE_PROCESSED.":</b> ".($lab["done_timestamp"]?$lab["done_timestamp"]:"NA")."<br/>"; print "<b>".LBL_PROCESSED_BY.":</b> ".($lab["done_user_id"]?user::get_username($lab["done_user_id"]):"NA")."<br/>"; print "</td></tr></table>"; } } print "</td></tr>"; print "<tr valign='top'><td>"; if ($get_vars["request_id"]) { $sql_sputum = "select sp1_collection_date, sp2_collection_date, sp3_collection_date, ". "sp1_appearance, sp2_appearance, sp3_appearance, ". "sp1_reading, sp2_reading, sp3_reading, lab_diag1, lab_diag2, lab_diag3, lab_diagnosis, release_flag, sputum_period ". "from m_consult_lab_sputum ". "where request_id = '".$get_vars["request_id"]."'"; if ($result_sputum = mysql_query($sql_sputum)) { if (mysql_num_rows($result_sputum)) { $sputum = mysql_fetch_array($result_sputum); //print_r($sputum); // set up collection dates if ($sputum["sp1_collection_date"]<>"0000-00-00") { list($year,$month,$day) = explode("-",$sputum["sp1_collection_date"]); $sp1_collection_date = "$month/$day/$year"; } if ($sputum["sp2_collection_date"]<>"0000-00-00") { list($year,$month,$day) = explode("-",$sputum["sp2_collection_date"]); $sp2_collection_date = "$month/$day/$year"; } if ($sputum["sp3_collection_date"]<>"0000-00-00") { list($year,$month,$day) = explode("-",$sputum["sp3_collection_date"]); $sp3_collection_date = "$month/$day/$year"; } } } } print "<table width='250' style='border: 1px dotted black'>"; print "<tr><td class='boxtitle'>".LBL_SPECIMEN."</td><td class='boxtitle'>#1</td><td class='boxtitle'>#2</td><td class='boxtitle'>#3</td></tr>"; print "<tr><td class='boxtitle'nowrap>".LBL_COLLECTION_DATE."</td>"; print "<td>"; print "<input type='text' size='10' class='tinylight' name='sp1_collection_date' value='".($sp1_collection_date?$sp1_collection_date:$post_vars["sp1_collection_date"])."' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_lab.sp1_collection_date', document.form_lab.sp1_collection_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; print "</td><td>"; print "<input type='text' size='10' class='tinylight' name='sp2_collection_date' value='".($sp2_collection_date?$sp2_collection_date:$post_vars["sp2_collection_date"])."' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_lab.sp2_collection_date', document.form_lab.sp2_collection_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; print "</td><td>"; print "<input type='text' size='10' class='tinylight' name='sp3_collection_date' value='".($sp3_collection_date?$sp3_collection_date:$post_vars["sp3_collection_date"])."' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_lab.sp3_collection_date', document.form_lab.sp3_collection_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; print "</td>"; print "</tr>"; print "<tr><td class='boxtitle'nowrap>".LBL_VISUAL_APPEARANCE."</td>"; print "<td>".sputum::show_sputum_appearance(($sputum["sp1_appearance"]?$sputum["sp1_appearance"]:$post_vars["sp1_appearance"]),'sp1_appearance')."</td>"; print "<td>".sputum::show_sputum_appearance(($sputum["sp2_appearance"]?$sputum["sp2_appearance"]:$post_vars["sp2_appearance"]),'sp2_appearance')."</td>"; print "<td>".sputum::show_sputum_appearance(($sputum["sp3_appearance"]?$sputum["sp3_appearance"]:$post_vars["sp3_appearance"]),'sp3_appearance')."</td>"; print "</tr>"; print "<tr><td class='boxtitle'>SPUTUM EXAM RESULT</td>"; print sputum::show_sputum_dropdown('lab_diag1',$sputum["lab_diag1"]); print sputum::show_sputum_dropdown('lab_diag2',$sputum["lab_diag2"]); print sputum::show_sputum_dropdown('lab_diag3',$sputum["lab_diag3"]); print "</tr>"; print "<tr><td class='boxtitle'>".LBL_READING."</td>"; print "<td>".sputum::show_sputum_reading(($sputum["sp1_reading"]?$sputum["sp1_reading"]:$post_vars["sp1_reading"]),'sp1_reading')."</td>"; print "<td>".sputum::show_sputum_reading(($sputum["sp2_reading"]?$sputum["sp2_reading"]:$post_vars["sp2_reading"]),'sp2_reading')."</td>"; print "<td>".sputum::show_sputum_reading(($sputum["sp3_reading"]?$sputum["sp3_reading"]:$post_vars["sp3_reading"]),'sp3_reading')."</td>"; print "</tr>"; print "<tr><td class='boxtitle'>".LBL_SPUTUM_PERIOD."</td>"; print "<td colspan='3'>"; print sputum::show_sputum_period(($sputum["sputum_period"]?$sputum["sputum_period"]:$post_vars["sputum_period"])); print "</td>"; print "</tr>"; print "<tr><td class='boxtitle'>FINAL ".LBL_LAB_DIAGNOSIS."</td>"; print "<td colspan='3'>"; print "<select name='lab_diagnosis' class='tinylight'>"; print "<option value=''>Select Diagnosis</option>"; print "<option value='P' ".(($sputum["lab_diagnosis"]?$sputum["lab_diagnosis"]:$post_vars["lab_diagnosis"])=="P"?"selected":"").">Positive</option>"; print "<option value='N' ".(($sputum["lab_diagnosis"]?$sputum["lab_diagnosis"]:$post_vars["lab_diagnosis"])=="N"?"selected":"").">Negative</option>"; print "<option value='D' ".(($sputum["lab_diagnosis"]?$sputum["lab_diagnosis"]:$post_vars["lab_diagnosis"])=="D"?"selected":"").">Doubtful</option>"; print "</select>"; print "</td>"; print "</tr>"; print "</table>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_RELEASE_FLAG."</span><br> "; print "<input type='checkbox' name='release_flag' ".(($sputum["release_flag"]?$sputum["release_flag"]:$post_vars["release_flag"])=="Y"?"checked":"")." value='1'/> ".INSTR_RELEASE_FLAG."<br />"; print "</td></tr>"; print "<tr><td align='center'>"; if ($get_vars["request_id"]) { print "<input type='hidden' name='request_id' value='".$get_vars["request_id"]."'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function display_ntp_maintenance_txdate() { 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); } print "<a name='m_detail'>"; // manage Delete here if ($post_vars["submitntp"] && $get_vars["ntp_id"]) { if ($post_vars["submitntp"] == "Delete Maintenance Entry") { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_ntp_collection_maintenance " . "where ntp_id = '" . $get_vars["ntp_id"] . "' and " . "treatment_date = '" . $get_vars["txm_date"] . "'"; 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=ntp&ntp=" . $get_vars["ntp"] . "&ntp_id=" . $get_vars["ntp_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=ntp&ntp=" . $get_vars["ntp"] . "&ntp_id=" . $get_vars["ntp_id"]); } } } } $sql = "select patient_id, user_id, treatment_date, intake_flag, remarks, " . "treatment_week, treatment_month " . "from m_consult_ntp_collection_maintenance " . "where ntp_id = '" . $get_vars["ntp_id"] . "' and treatment_date = '" . $get_vars["txm_date"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $txdate = mysql_fetch_array($result); print "<form method='post' action='" . $_SERVER["PHPS-SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=" . $get_vars["ptmenu"] . "&module=ntp&ntp=" . $get_vars["ntp"] . "&ntp_id=" . $get_vars["ntp_id"] . "&txm_date=" . $txdate["treatment_date"] . "#m_detail' name='form_maintenance_txdate'>"; print "<table width='200' style='border: 1px dotted black'><tr><td>"; print "<span class='tinylight'>"; print "<b>TREATMENT DATE " . $txdate["treatment_date"] . "</b><br/>"; print "Entered by: " . user::get_username($txdate["user_id"]) . "<br/>"; print "Treatment Week: " . $txdate["treatment_week"] . "<br/>"; print "Treatment Month: " . $txdate["treatment_month"] . "<br/>"; print "Intake: " . ($txdate["intake_flag"] == "Y" ? "Yes" : "No") . "<br/>"; print "Remarks:<br/>" . nl2br(stripslashes($txdate["remarks"])) . "<br/>"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitntp' value='Delete Maintenance Entry' class='tinylight' style='border:1px solid black' />"; } print "</span>"; print "</td></tr></table>"; print "</form>"; } } }
function show_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]; //print_r($arg_list); } $sql = "select schedule_id, visit_date, consult_id, date_format(schedule_timestamp, '%a %d %b %Y, %h:%i%p') schedule_timestamp, user_id, ". "patient_id, appointment_id, reminder_flag ". "from m_consult_appointments where schedule_id = '".$get_vars["schedule_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $appt = mysql_fetch_array($result); 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=APPTS&schedule_id=".$appt["schedule_id"]."'>"; print "<table width='200' cellpadding='1' style='border: 1px dotted black'><tr><td>"; print "<span class='tinylight'>"; print "VISIT DATE: ".$appt["visit_date"]."<br/>"; print "APPT SET ON: ".$appt["visit_date"]."<br/>"; print "APPT SET BY: ".user::get_username($appt["user_id"])."<br/>"; print "APPT CODE: ".appointment::get_appointment_name($appt["appointment_id"])."<br/>"; print "REMINDER: ".$appt["reminder_flag"]."<br/>"; print "<br/><input type='submit' class='tinylight' name='submitsked' value='Delete' style='border: 1px solid black'/>"; print "</span>"; print "</td></tr></table></form>"; } } }
function _news() { 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 "<table width='300'>"; print "<tr valign='top'><td>"; print "<span class='library'>".FTITLE_SITE_NEWS."</span><br>"; print "</td></tr>"; $sql = "select news_id, news_timestamp, news_title, news_author, news_lead from m_news order by news_timestamp desc"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { while (list($id, $ts, $title, $author, $lead) = mysql_fetch_array($result)) { print "<tr valign='top'><td>"; if (!isset($menu_id)) { $menu_id = module::get_menu_id("_news"); } print "<a href='".$_SERVER["SELF"]."?page=CONTENT&menu_id=$menu_id&news_id=$id' class='boxtext'><b>$title</b></a><br />"; print "<span class='tiny'><b>$ts ".user::get_username($author)."</b></span><br/>"; print "$lead<br />"; print "</td></tr>"; } } } print "</table><br>"; }
function display_drug_dispense_detail() { if (func_num_args()) { $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]; } // do some processing here /*if ($get_vars["delete_complaint_id"]) { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_notes_complaint ". "where notes_id = '".$get_vars["notes_id"]."' and ". "consult_id = '".$get_vars["consult_id"]."' and ". "complaint_id = '".$get_vars["delete_complaint_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_id"]); } } } if ($get_vars["delete_class_id"]) { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_notes_dxclass ". "where notes_id = '".$get_vars["notes_id"]."' and ". "consult_id = '".$get_vars["consult_id"]."' and ". "class_id = '".$get_vars["delete_class_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_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=DETAILS&module=notes¬es=".$get_vars["notes"]."¬es_id=".$get_vars["notes_id"]); } } }*/ // continue with real task /*$sql = "select notes_id, consult_id, notes_history, ". "notes_physicalexam, notes_plan, user_id, date_format(notes_timestamp, '%a %d %b %Y, %h:%i%p') ts, plan_px_info ". "from m_consult_notes where consult_id = '".$get_vars["consult_id"]."' and ". "notes_id = '".$get_vars["notes_id"]."'";*/ $sql = "select *, date_format(dispense_timestamp, '%a %d %b %Y, %h:%i%p') ts from m_consult_pcb_dispense WHERE consult_id = '" . $get_vars["consult_id"] . "' and dispense_id = '" . $get_vars["drug_id"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $drug = mysql_fetch_array($result); //list($min,$max,$class) = wtforage::_wtforage($_GET["consult_id"]); print "<form method='post' action=''>"; print "<table width='300' cellpadding='2' style='border: 1px dashed black'><tr><td>"; print "<span class='tinylight'>"; print "<b>DISPENSE ID:</b> <font color='red'>" . module::pad_zero($drug["dispense_id"], 7) . "</font><br/>"; print "<b>DATE/TIME:</b> " . $drug["ts"] . "<br/>"; print "<b>TAKEN BY:</b> " . user::get_username($drug["user_id"]) . "<br/>"; print "<hr size='1'/>"; print "<b>DIAGNOSIS:</b><br/>"; drug::show_diagnosis($menu_id, $post_vars, $get_vars); print "<br><br><hr size='1'/>"; print "<b>PLAN:</b><br/>"; $notes_id = drug::get_notes_id($get_vars["consult_id"]); $sql_notes = "select notes_id, consult_id, notes_history, " . "notes_physicalexam, notes_plan, user_id, date_format(notes_timestamp, '%a %d %b %Y, %h:%i%p') ts, plan_px_info " . "from m_consult_notes where consult_id = '" . $get_vars["consult_id"] . "' and " . "notes_id = '{$notes_id}'"; if ($result_notes = mysql_query($sql_notes)) { if (mysql_num_rows($result_notes)) { $notes = mysql_fetch_array($result_notes); if (strlen($notes["notes_plan"]) >= 0) { print stripslashes(nl2br($notes["notes_plan"])) . "<br/><br />"; print stripslashes(nl2br($notes["plan_px_info"])) . "<br/>"; $plan = stripslashes(nl2br($notes["notes_plan"])); } else { print "<font color='red'>No recorded plan.</font><br/>"; } } } print "<hr size='1'/>"; print "<input type='hidden' name='drug_id' value='" . $get_vars["drug_id"] . "' />"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdrug' value='Delete Drugs' class='tinylight' style='border: 1px solid black; background-color: #FF6633;'/> "; } print "</span>"; print "</td></tr></table><br>"; print "</form>"; } } }
function form_patient() { 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); if ($get_vars["patient_id"]) { $sql = "select patient_id, healthcenter_id, registration_date, patient_lastname, " . "patient_firstname, patient_middle, patient_dob, patient_gender, user_id, patient_mother, patient_cellphone, pwd_flag, ind_flag, blood_type " . "from m_patient where patient_id = '" . $get_vars["patient_id"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $patient = mysql_fetch_array($result); } } } } $q_sms_enroll = mysql_query("SELECT menu_id FROM module_menu WHERE menu_id='1370'") or die("Cannot quer 535: " . mysql_error()); print "<a name='ptform'>"; print "<table width='300'>"; print "<form action = '" . $_SERVER["SELF"] . "?page=" . $get_vars["page"] . "&menu_id={$menu_id}' name='form_patient' method='post'>"; if ($get_vars["patient_id"]) { print "<tr valign='top'>"; print "<td>"; print "<font color='#99CC00' size='5'><b>" . FTITLE_EDIT_PATIENT . "</b></font>"; print "</td>"; print "</tr>"; } else { print "<tr valign='top'><td>"; print "<font color='#99CC00' size='5'><b>" . FTITLE_NEW_PATIENT . "</b></font>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<b>NOTE: This form is for new patients. All Fields are Required<br><br>"; print "</td></tr>"; } if ($get_vars["patient_id"]) { print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_REGISTRATION_DATE . "</span><br> "; print $patient["registration_date"] . "<br/>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_REGISTERED_BY . "</span><br> "; print user::get_username($patient["user_id"]) . "<br/>"; print "</td></tr>"; } print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_FIRST_NAME . "</span><br> "; print "<input type='text' class='textbox' name='patient_firstname' value='" . ($patient["patient_firstname"] ? $patient["patient_firstname"] : ($post_vars["patient_firstname"] ? $post_vars["patient_firstname"] : "")) . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_MIDDLE_NAME . "</span><br> "; print "<input type='text' class='textbox' name='patient_middle' value='" . ($patient["patient_middle"] ? $patient["patient_middle"] : ($post_vars["patient_middle"] ? $post_vars["patient_middle"] : "")) . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_LAST_NAME . "</span><br> "; print "<input type='text' class='textbox' name='patient_lastname' value='" . ($patient["patient_lastname"] ? $patient["patient_lastname"] : ($post_vars["patient_lastname"] ? $post_vars["patient_lastname"] : "")) . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_PATIENT_DOB . "</span><br> "; if ($patient["patient_dob"]) { // convert to external format list($year, $month, $day) = explode("-", $patient["patient_dob"]); $dob = "{$month}/{$day}/{$year}"; } print "<input type='text' size='10' maxlength='10' class='textbox' name='patient_dob' value='" . ($dob ? $dob : ($post_vars["patient_dob"] ? $post_vars["patient_dob"] : "")) . "' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_patient.patient_dob', document.form_patient.patient_dob.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a></input>"; print "</td></tr>"; print "<tr valign='top'>"; print "<td>"; print "<span class='boxtitle'>" . LBL_GENDER . "</span><br> "; print "<select name='patient_gender' " . ($get_vars["patient_id"] ? '' : '') . " class='textbox'>"; print "<option " . ($patient["patient_gender"] == 'M' ? 'selected' : ($post_vars["patient_gender"] == 'M' ? 'selected' : '')) . " value='M'>Male</option>"; print "<option " . ($patient["patient_gender"] == 'F' ? 'selected' : ($post_vars["patient_gender"] == 'F' ? 'selected' : '')) . " value='F'>Female</option>"; print "</select>"; print "<tr valign='top'>"; print "<td>"; print "<span class='boxtitle'>" . LBL_MOTHERS_NAME . "</span><br> "; print "<input type='text' size='30' class='textbox' name='patient_mother' value='" . ($patient["patient_mother"] ? $patient["patient_mother"] : ($post_vars["patient_mother"] ? $post_vars["patient_mother"] : "")) . "' style='border: 1px solid #000000'><br>"; print "</td>"; print "</tr>"; print "</td>"; print "</tr>"; print "<tr>"; print "<td>"; print "<span class='boxtitle'>CELLPHONE NUMBER (11-digit,i.e. 09XX1234567)</span><br> "; print "<input type='text' size='12' class='textbox' maxlength='11' name='patient_cellphone' value='" . ($patient["patient_cellphone"] ? $patient["patient_cellphone"] : ($post_vars["patient_cellphone"] ? $post_vars["patient_cellphone"] : "")) . "'></input>"; print "</td>"; print "</tr>"; print "<tr>"; print "<td>"; //Dagdag Hanggang 649 print "<span class='boxtitle'>CONFIRM CELLPHONE NUMBER</span><br> "; print "<input type='text' size='12' class='textbox' maxlength='11' name='confirm_cellphone' value='" . ($patient["patient_cellphone"] ? $patient["patient_cellphone"] : ($post_vars["confirm_cellphone"] ? $post_vars["confirm_cellphone"] : "")) . "'></input>"; print "</td>"; print "</tr>"; //Hanggang Dito print "<tr>"; print "<td>"; print "<span class='boxtitle'>PATIENT GROUP</span><br> "; print "<input type='checkbox' name='p_group[]' value='pwd' " . ($patient["pwd_flag"] == 'Y' ? CHECKED : ($post_vars["p_group"][0] ? CHECKED : "")) . " >PWD</input><br />"; print "<input type='checkbox' name='p_group[]' value='ind' " . ($patient["ind_flag"] == 'Y' ? CHECKED : ($post_vars["p_group"][1] ? CHECKED : "")) . " >Indigenous</input>"; print "</td>"; print "</tr>"; if (mysql_num_rows($q_sms_enroll) != 0) { $arr_alert = array(); $q_alert = mysql_query("SELECT program_id FROM m_lib_sms_px_enroll WHERE patient_id='{$_GET['patient_id']}'") or die("Cannot query 634: " . mysql_error()); while (list($program_id) = mysql_fetch_array($q_alert)) { array_push($arr_alert, $program_id); } echo "<tr valign='top'>"; echo "<td><span class='boxtitle'>ENROLL PATIENT TO SMS ALERT PROGRAM?</span><br>"; echo "<input type='checkbox' name='sms_prog[]' value='epi' " . (in_array('epi', $arr_alert) ? CHECKED : '') . ">EPI</input><br>"; echo "<input type='checkbox' name='sms_prog[]' value='fp' " . (in_array('fp', $arr_alert) ? CHECKED : '') . ">Family Planning</input><br>"; echo "<input type='checkbox' name='sms_prog[]' value='mc' " . (in_array('mc', $arr_alert) ? CHECKED : '') . ">Maternal Care</input><br>"; echo "<input type='checkbox' name='sms_prog[]' value='philhealth' " . (in_array('philhealth', $arr_alert) ? CHECKED : '') . ">PhilHealth</input><br>"; echo "<input type='checkbox' name='sms_prog[]' value='sick' " . (in_array('sick', $arr_alert) ? CHECKED : '') . ">Sick Child Under 5</input><br>"; echo "<input type='checkbox' name='sms_prog[]' value='tb' " . (in_array('tb', $arr_alert) ? CHECKED : '') . ">Tuberculosis</input><br>"; echo "</td></tr>"; } print "<tr><td>"; if ($get_vars["patient_id"]) { print "<input type='hidden' name='patient_id' value='" . $get_vars["patient_id"] . "'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } print "<input type='submit' value = 'Cancel' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } else { if ($_SESSION["priv_add"]) { print "<br><input type='submit' value= 'Add Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; print "<input type='reset' value= 'Clear Fields' class='textbox' name='submitpatient' style='border: 1px solid #000000'><br>"; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function display_consult_reminder_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]; $validuser = $arg_list[3]; $isadmin = $arg_list[4]; //print_r($arg_list); } // do processing here if ($post_vars["submitsms"] == "Delete SMS") { if (module::confirm_delete($menu_id, $post_vars, $get_vars)) { $sql = "delete from m_consult_reminder where reminder_id = '" . $post_vars["reminder_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=DETAILS&module=reminder&reminder=" . $get_vars["reminder"]); } } 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=DETAILS&module=reminder&reminder=" . $get_vars["reminder"]); } } } $sql = "select reminder_id, reminder_text, patient_id, consult_id, sent_flag, user_id, reminder_date " . "from m_consult_reminder where reminder_id = '" . $get_vars["reminder_id"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $sms = mysql_fetch_array($result); print "<form method='post' action=''>"; print "<table style='border: 1px dotted black'><tr><td>"; print "<span class='tinylight'>"; print "REMINDER NO: <font color='red'>" . module::pad_zero($sms["reminder_id"], 7) . "</font><br/>"; print "SENT: " . $sms["sent_flag"] . "<br/>"; print "REMINDER DATE: " . $sms["reminder_date"] . "<br/>"; print "CREATED BY: " . user::get_username($sms["user_id"]) . "<br/>"; print "<hr size='1'/>"; print "REMINDER TEXT:<br/>"; print $sms["reminder_text"] . "<br/>"; print "<br/>"; print "<input type='hidden' name='reminder_id' value='" . $sms["reminder_id"] . "' />"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitsms' value='Delete SMS' class='tinylight' style='border: 1px solid black'/>"; } print "</span>"; print "</td></tr></table>"; print "</form>"; } } }
/** * Show Patient Form * * Show form for adding or updating patient * @param string $menu_id * @param array $past_vars * @param array $get_vars */ function form_patient () { 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); if ($get_vars["patient_id"]) { $sql = "select patient_id, healthcenter_id, registration_date, patient_lastname, ". "patient_firstname, patient_middle, patient_dob, patient_gender, user_id, patient_mother ". "from m_patient where patient_id = '".$get_vars["patient_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $patient = mysql_fetch_array($result); } } } } print "<a name='ptform'>"; print "<table width='300'>"; print "<form action = '".$_SERVER["SELF"]."?page=".$get_vars["page"]."&menu_id=$menu_id' name='form_patient' method='post'>"; if ($get_vars["patient_id"]) { print "<tr valign='top'><td>"; print "<font color='#99CC00' size='5'><b>".FTITLE_EDIT_PATIENT."</b></font>"; print "</td></tr>"; } else { print "<tr valign='top'><td>"; print "<font color='#99CC00' size='5'><b>".FTITLE_NEW_PATIENT."</b></font>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<b>NOTE: This form is for new patients.</b><br><br>"; print "</td></tr>"; } if ($get_vars["patient_id"]) { print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_REGISTRATION_DATE."</span><br> "; print $patient["registration_date"]."<br/>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_REGISTERED_BY."</span><br> "; print user::get_username($patient["user_id"])."<br/>"; print "</td></tr>"; } print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_FIRST_NAME."</span><br> "; print "<input type='text' class='textbox' name='patient_firstname' value='".($patient["patient_firstname"]?$patient["patient_firstname"]:$post_vars["patient_firstname"])."' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_MIDDLE_NAME."</span><br> "; print "<input type='text' class='textbox' name='patient_middle' value='".($patient["patient_middle"]?$patient["patient_middle"]:$post_vars["patient_middle"])."' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_LAST_NAME."</span><br> "; print "<input type='text' class='textbox' name='patient_lastname' value='".($patient["patient_lastname"]?$patient["patient_lastname"]:$post_vars["patient_lastname"])."' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_MOTHERS_NAME."</span><br> "; print "<input type='text' size='30' class='textbox' ".($_SESSION["isadmin"]||!$get_vars["patient_id"]?"":"disabled")." name='patient_mother' value='".($patient["patient_mother"]?$patient["patient_mother"]:$post_vars["patient_mother"])."' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_PATIENT_DOB."</span><br> "; if ($patient["patient_dob"]) { // convert to external format list($year, $month, $day) = explode("-", $patient["patient_dob"]); $dob = "$month/$day/$year"; } print "<input type='text' size='10' maxlength='10' class='textbox' name='patient_dob' value='".($dob?$dob:$post_vars["patient_dob"])."' style='border: 1px solid #000000'><br>"; print "<small>Use format MM/DD/YYYY.</small>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_GENDER."</span><br> "; print "<select name='patient_gender' ".($get_vars["patient_id"]?'disabled':'')." class='textbox'>"; print "<option ".($patient["patient_gender"]=='M'?'selected':'')." value='M'>Male</option>"; print "<option ".($patient["patient_gender"]=='F'?'selected':'')." value='F'>Female</option>"; print "<option ".($patient["patient_gender"]=='I'?'selected':'')." value='I'>Indeterminate</option>"; print "</select>"; if ($patient["patient_gender"]) { print "<input type='hidden' name='patient_gender' value='".$patient["patient_gender"]."' />"; } print "</td></tr>"; print "<tr><td>"; if ($get_vars["patient_id"]) { print "<input type='hidden' name='patient_id' value='".$get_vars["patient_id"]."'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } } else { if ($_SESSION["priv_add"]) { print "<br><input type='submit' value = 'Add Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'><br> "; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function show_service_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); } $sql = "select ccdev_id, consult_id, user_id, patient_id, ccdev_timestamp, date_format(ccdev_timestamp, '%a %d %b %Y, %h:%i%p'), " . "service_id, round(age_on_service,2),date_format(ccdev_service_date, '%m/%d/%Y'),ccdev_service_date " . "from m_consult_ccdev_services where " . "ccdev_id = '" . $get_vars["ccdev_id"] . "' and service_id = '" . $get_vars["service_id"] . "' and " . "ccdev_timestamp = '" . $get_vars["sts"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { list($cdid, $cid, $uid, $pid, $cstamp, $sdate, $sid, $age_service, $service_date, $ccdev_sdate) = mysql_fetch_array($result); print "<a name='detail'>"; print "<table width='250' cellpadding='3' style='border:1px dashed black'><tr><td>"; print "<form name='form_service_detail' method='post' action='" . $_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=" . $get_vars["ccdev"] . "'>"; print "<span class='tinylight'>"; print "REGISTRY ID: {$cdid}<br/>"; print "SERVICE: " . ccdev::get_service_name($sid) . "<br/>"; print "REPORT DATE: {$sdate}<br/>"; print "AGE ON SERVICE: {$age_service} weeks<br/>"; print "RECORDED BY: " . user::get_username($uid) . "<br/>"; print "<input type='hidden' name='service' value='{$sid}'/>"; print "<input type='hidden' name='sts' value='{$cstamp}'/>"; print "<input type='hidden' name='ccdev_id' value='{$cdid}'/>"; print "<input type='hidden' name='ccdev_sdate' value='{$ccdev_sdate}'/>"; echo "ACTUAL DATE OF SERVICE<br>"; if ($service_date == '00/00/0000') { list($tstamp) = explode(' ', $cstamp); list($tstamp_yr, $tstamp_mo, $tstamp_date) = explode('-', $tstamp); $tstamp_serv_date = $tstamp_mo . '/' . $tstamp_date . '/' . $tstamp_yr; echo "<font color='red' size='1'><b>(report timestamp is used. please record actual service date)</b></font><br>"; echo "<input type='text' size='7' maxlength='10' value='{$tstamp_serv_date}' name='ccdev_serv_date'></input>"; } else { echo "<input type='text' size='7' maxlength='10' value='{$service_date}' name='ccdev_serv_date'></input>"; } echo " <a href=\"javascript:show_calendar4('document.form_service_detail.ccdev_serv_date',document.form_service_detail.ccdev_serv_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a>"; if ($_SESSION["priv_update"]) { print "<br><br><input type='submit' name='submitdetail' value='Update Service' class='tinylight' style='border: 1px solid black'/> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Service' class='tinylight' style='border: 1px solid black'/> "; } print "</span>"; print "</form>"; print "</td></tr></table>"; } } }
function form_patient() { 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); if ($get_vars["patient_id"]) { $sql = "select patient_id, healthcenter_id, registration_date, patient_lastname, " . "patient_firstname, patient_middle, patient_dob, patient_gender, user_id, patient_mother,patient_cellphone " . "from m_patient where patient_id = '" . $get_vars["patient_id"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $patient = mysql_fetch_array($result); } } } } print "<a name='ptform'>"; print "<table width='300'>"; print "<form action = '" . $_SERVER["SELF"] . "?page=" . $get_vars["page"] . "&menu_id={$menu_id}' name='form_patient' method='post'>"; if ($get_vars["patient_id"]) { print "<tr valign='top'><td>"; print "<font color='#99CC00' size='5'><b>" . FTITLE_EDIT_PATIENT . "</b></font>"; print "</td></tr>"; } else { print "<tr valign='top'><td>"; print "<font color='#99CC00' size='5'><b>" . FTITLE_NEW_PATIENT . "</b></font>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<b>NOTE: This form is for new patients. Fields with <font style='color:red; font-weight: bold'>*</font> are required.</b><br><br>"; print "</td></tr>"; } if ($get_vars["patient_id"]) { print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_REGISTRATION_DATE . "</span><br> "; print $patient["registration_date"] . "<br/>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_REGISTERED_BY . "</span><br> "; print user::get_username($patient["user_id"]) . "<br/>"; print "</td></tr>"; } print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_FIRST_NAME . "</span><font style='color:red; font-weight: bold'> *</font><br> "; //print "<input type='text' class='textbox' name='patient_firstname' value='".($patient["patient_firstname"]?$patient["patient_firstname"]:$post_vars["patient_firstname"])."' style='border: 1px solid #000000'><br>"; print "<input type='text' class='textbox' name='patient_firstname' value='" . ($patient["patient_firstname"] ? $patient["patient_firstname"] : "") . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_MIDDLE_NAME . "</span><br> "; //print "<input type='text' class='textbox' name='patient_middle' value='".($patient["patient_middle"]?$patient["patient_middle"]:$post_vars["patient_middle"])."' style='border: 1px solid #000000'><br>"; print "<input type='text' class='textbox' name='patient_middle' value='" . ($patient["patient_middle"] ? $patient["patient_middle"] : "") . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_LAST_NAME . "</span><font style='color:red; font-weight: bold'> *</font><br> "; //print "<input type='text' class='textbox' name='patient_lastname' value='".($patient["patient_lastname"]?$patient["patient_lastname"]:$post_vars["patient_lastname"])."' style='border: 1px solid #000000'><br>"; print "<input type='text' class='textbox' name='patient_lastname' value='" . ($patient["patient_lastname"] ? $patient["patient_lastname"] : "") . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_PATIENT_DOB . "</span><font style='color:red; font-weight: bold'> *</font><br> "; if ($patient["patient_dob"]) { // convert to external format list($year, $month, $day) = explode("-", $patient["patient_dob"]); $dob = "{$month}/{$day}/{$year}"; } //print "<input type='text' size='10' maxlength='10' class='textbox' name='patient_dob' value='".($dob?$dob:$post_vars["patient_dob"])."' style='border: 1px solid #000000'><br>"; //print "<input type='text' size='10' maxlength='10' class='textbox' name='patient_dob' value='".($dob?$dob:"")."' style='border: 1px solid #000000'>"; print "<input type='text' size='10' maxlength='10' class='textbox' name='patient_dob' value='" . ($dob ? $dob : "") . "' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_patient.patient_dob', document.form_patient.patient_dob.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a></input>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_GENDER . "</span><font style='color:red; font-weight: bold'> *</font><br> "; print "<select name='patient_gender' " . ($get_vars["patient_id"] ? '' : '') . " class='textbox'>"; print "<option " . ($patient["patient_gender"] == 'M' ? 'selected' : '') . " value='M'>Male</option>"; print "<option " . ($patient["patient_gender"] == 'F' ? 'selected' : '') . " value='F'>Female</option>"; print "<option " . ($patient["patient_gender"] == 'I' ? 'selected' : '') . " value='I'>Indeterminate</option>"; print "</select>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>" . LBL_MOTHERS_NAME . "</span><font style='color:red; font-weight: bold'> *</font><br> "; //print "<input type='text' size='30' class='textbox' ".($_SESSION["isadmin"]||!$get_vars["patient_id"]?"":"disabled")." name='patient_mother' value='".($patient["patient_mother"]?$patient["patient_mother"]:$post_vars["patient_mother"])."' style='border: 1px solid #000000'><br>"; print "<input type='text' size='30' class='textbox' name='patient_mother' value='" . ($patient["patient_mother"] ? $patient["patient_mother"] : "") . "' style='border: 1px solid #000000'><br>"; print "</td></tr>"; //if ($patient["patient_gender"]) { // print "<input type='hidden' name='patient_gender' value='".$patient["patient_gender"]."' />"; //} print "</td></tr>"; print "<tr><td>"; print "<span class='boxtitle'>CELLPHONE NUMBER (11-digit,i.e. 09XX1234567)</span><br> "; print "<input type='text' size='10' class='textbox' maxlength='11' name='patient_cellphone' value='{$patient['patient_cellphone']}'></input>"; print "</td></tr>"; print "<tr><td>"; if ($get_vars["patient_id"]) { print "<input type='hidden' name='patient_id' value='" . $get_vars["patient_id"] . "'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } print "<input type='submit' value = 'Cancel' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; } else { if ($_SESSION["priv_add"]) { print "<br><input type='submit' value= 'Add Patient' class='textbox' name='submitpatient' style='border: 1px solid #000000'> "; print "<input type='reset' value= 'Clear Fields' class='textbox' name='submitpatient' style='border: 1px solid #000000'><br>"; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function _consult_lab_hematology_results() { 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]; } $q_hema = mysql_query("SELECT date_format(date_lab_exam,'%m/%d/%Y') as 'date_lab_exam',hemoglobin,hematocrit,rbc,rbc_mcv,rbc_mchc,rbc_mch,wbc,wbc_polys,wbc_lympho,wbc_mxd,wbc_mono,wbc_eosin,wbc_baso,platelet,reticulocytes,esr,clotting_time,bleeding_time,malaria,slit_smear,fbs,blood_type,user_id,patient_id,others,rh,stabs FROM m_consult_lab_hematology WHERE request_id='{$_GET['request_id']}'") or die("Cannot query: 131" . mysql_error()); $q_lab = mysql_query("SELECT patient_id,date_format(request_timestamp,'%a %d %Y,%h %i %p') as 'date_requested',request_user_id,date_format(done_timestamp,'%a %d %b %Y, %h %i %p') as 'date_done',request_done,done_user_id FROM m_consult_lab WHERE request_id='{$_GET['request_id']}'") or die("Cannot query 132" . mysql_error()); if (mysql_num_rows($q_hema) != 0) { list($date_lab_exam, $hemo, $hema, $rbc, $mcv, $mchc, $mch, $wbc, $polys, $lympho, $mxd, $mono, $eosin, $baso, $platelet, $reticulocytes, $esr, $clotting_time, $bleeding_time, $malaria, $slit_smear, $fbs, $blood_type, $user_id, $patient_id, $others, $rh, $stabs) = mysql_fetch_array($q_hema); } else { $date_lab_exam = date('m/d/Y'); } list($pxid, $date_request, $request_user_id, $date_done, $request_done, $done_user_id) = mysql_fetch_array($q_lab); echo "<a name='hematology_result'></a>"; echo "<table style='border: 1px dotted black' width='400'><tr><td colspan='4'>"; echo "<span class='tinylight'>"; echo "<b>HEMATOLOGY RESULTS FOR " . strtoupper(patient::get_name($pxid)) . "</b><br/>"; echo "REQUEST ID: <font color='red'>" . module::pad_zero($_GET["request_id"], 7) . "</font><br/>"; echo "DATE REQUESTED: " . $date_request . "<br/>"; echo "REQUESTED BY: " . user::get_username($request_user_id) . "<br/>"; echo "DATE COMPLETED: " . $date_done . "<br/>"; echo "PROCESSED BY: " . ($done_user_id ? user::get_username($done_user_id) : "NA") . "<br/>"; echo "RELEASED: " . $request_done . "<br/>"; echo "<hr size='1'></td></tr>"; echo "<tr><td colspan='4' class='boxtitle'>DATE EXAMINED {$date_lab_exam}"; echo "</td></tr>"; echo "<tr><td>TEST</td><td>RESULT</td><td>TEST</td><td>RESULT</td></tr>"; echo "<tr><td class='boxtitle'>HEMOGLOBIN</td><td class='tinylight'>{$hemo}</td><td class='boxtitle'>PLATELET</td><td class='tinylight'>{$platelet}</td></tr>"; echo "<tr><td class='boxtitle'>HEMATOCRIT</td><td class='tinylight'>{$hema}</td><td class='boxtitle'>RETICULOCYTES</td><td class='tinylight'>{$reticulocytes}</td></tr>"; echo "<tr><td class='boxtitle'>RBC</td><td class='tinylight'>{$rbc}</td><td class='boxtitle'>ESR</td><td class='tinylight'>{$esr}</td></tr>"; echo "<tr><td class='boxtitle'>MCV</td><td class='tinylight'>{$mcv}</td><td class='boxtitle'>CLOTING TIME</td><td class='tinylight'>{$clotting_time}</td></tr>"; echo "<tr><td class='boxtitle'>MCHC</td><td class='tinylight'>{$mchc}</td><td class='boxtitle'>BLEEDING TIME</td><td class='tinylight'>{$bleeding_time}</td></tr>"; echo "<tr><td class='boxtitle'>MCH</td><td class='tinylight'>{$mch}</td><td class='boxtitle'>MALARIA</td><td class='tinylight'>{$malaria}</td></tr>"; echo "<tr><td class='boxtitle'>WBC</td><td class='tinylight'>{$wbc}</td><td class='boxtitle'>SLIT SMEAR</td><td class='tinylight'>{$slit_smear}</td></tr>"; echo "<tr><td class='boxtitle'>POLYS</td><td class='tinylight'>{$polys}</td><td class='boxtitle'>FBS</td><td class='tinylight'>{$fbs}</td></tr>"; echo "<tr><td class='boxtitle'>LYMPHO</td><td class='tinylight'>{$lympho}</td><td class='boxtitle'>"; $blood_type = $blood_type == '0' ? '' : $blood_type; echo "BLOOD TYPE"; echo "</td><td class='tinylight'>{$blood_type}"; echo "</td></tr>"; echo "<tr><td class='boxtitle'>RH</td><td class='tinylight'>{$rh}</td><td colspan='2'> </td></tr>"; echo "<tr><td class='boxtitle'>MXD</td><td class='tinylight'>{$mxd}</td><td colspan='2'> </td></tr>"; echo "<tr><td class='boxtitle'>MONO</td><td class='tinylight'>{$mono}</td><td colspan='2'> </td></tr>"; echo "<tr><td class='boxtitle'>EOSIN</td><td class='tinylight'>{$eosin}</td><td colspan='2'> </td></tr>"; echo "<tr><td class='boxtitle'>BASO</td><td class='tinylight'>{$baso}</td><td colspan='2'> </td></tr>"; echo "<tr><td class='boxtitle'>STABS</td><td class='tinylight'>{$stabs}</td><td colspan='2'> </td></tr>"; echo "</table>"; $_SESSION["lab_print"] = "HEMATOLOGY RESULTS FOR " . strtoupper(patient::get_name($pxid)) . "<br/>" . "DATE REQUESTED: " . $date_request . "<br/>" . "REQUESTED BY: " . user::get_username($request_user_id) . "<br/>" . "DATE COMPLETED: " . $date_done . "<br/>" . "PROCESSED BY: " . ($done_user_id ? user::get_username($done_user_id) : "NA") . "<br/>" . "<br/><br/>" . "HEMOGLOBIN: {$hemo}<br/>PLATELET: {$platelet}<br/>" . "HEMATOCRIT: {$hema}<br/>RETICULOCYTES: {$reticulocytes}<br/>" . "RBC: {$rbc}<br/>ESR: {$esr}<br/>" . "MCV: {$mcv}<br/>CLOTING TIME: {$clotting_time}<br/>" . "MCHC: {$mchc}<br/>BLEEDING TIME: {$bleeding_time}<br/>" . "MCH: {$mch}<br/>MALARIA: {$malaria}<br/>" . "WBC: {$wbc}<br/>SLIT SMEAR: {$slit_smear}<br/>" . "POLYS: {$polys}<br/>FBS: {$fbs}<br/>" . "LYMPHO: {$lympho}<br/>" . "BLOOD TYPE: {$blood_type}" . "<br/>" . "RH: {$rh}<br/>" . "MXD: {$mxd}<br/>" . "MONO: {$mono}<br/>" . "EOSIN: {$eosin}<br/>" . "BASO: {$baso}<br/>" . "STABS: {$stabs}"; }
function display_service_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); } $sql = "select mc_id, consult_id, user_id, patient_id, mc_timestamp, date_format(mc_timestamp, '%a %d %b %Y, %h:%i%p'), ". "service_id, visit_type ". "from m_consult_mc_services where ". "mc_id = '".$get_vars["mc_id"]."' and service_id = '".$get_vars["service_id"]."' and ". "mc_timestamp = '".$get_vars["sts"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { list($cdid, $cid, $uid, $pid, $cstamp, $sdate, $sid, $vtype) = mysql_fetch_array($result); print "<a name='detail'>"; print "<table width='250' cellpadding='3' style='border:1px dashed black'><tr><td>"; print "<form name='form_service_detail' method='post' action='".$_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=".$get_vars["mc"]."'>"; print "<span class='tinylight'>"; print "REGISTRY ID: <font color='red'>".module::pad_zero($cdid,7)."</font><br/>"; print "SERVICE: ".mc::get_service_name($sid)."<br/>"; print "VISIT TYPE: $vtype<br/>"; print "REPORT DATE: $sdate<br/>"; print "RECORDED BY: ".user::get_username($uid)."<br/>"; print "<input type='hidden' name='service' value='$sid'/>"; print "<input type='hidden' name='sts' value='$cstamp'/>"; print "<input type='hidden' name='mc_id' value='$cdid'/>"; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Service' class='tinylight' style='border: 1px solid black'/> "; } print "</span>"; print "</form>"; print "</td></tr></table>"; } } }
function display_service_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); } $sql = "select mc_id, consult_id, user_id, patient_id, mc_timestamp, date_format(mc_timestamp, '%a %d %b %Y, %h:%i%p'), ". "service_id, visit_type, actual_service_date, service_qty ". "from m_consult_mc_services where ". "mc_id = '".$get_vars["mc_id"]."' and service_id = '".$get_vars["service_id"]."' and ". "mc_timestamp = '".$get_vars["sts"]."'"; $result = mysql_query($sql) or die(mysql_error()); if ($result) { if (mysql_num_rows($result)) { while(list($cdid, $cid, $uid, $pid, $cstamp, $sdate, $sid, $vtype, $actual_date, $qty) = mysql_fetch_array($result)) { print "<a name='detail'>"; print "<table width='250' cellpadding='3' style='border:1px dashed black'><tr><td>"; print "<form name='form_service_detail' method='post' action='".$_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=".$get_vars["mc"]."&mc_id=".$get_vars["mc_id"]."&sts=".$get_vars["sts"]."&service_id=".$get_vars["service_id"].'#detail'."'>"; print "<span class='tinylight'>"; print "REGISTRY ID: <font color='red'>".module::pad_zero($cdid,7)."</font><br/>"; print "SERVICE: ".mc::get_service_name($sid)."<br/>"; print "VISIT TYPE: $vtype<br/>"; print "REPORT DATE: $sdate<br/>"; print "RECORDED BY: ".user::get_username($uid)."<br/>"; print "DATE SERVICE WAS GIVEN: "; list($reported_date) = explode(' ',$cstamp); $actual = ($actual_date=='0000-00-00')?$reported_date.' <font color=\'red\'>(no date given, report date instead)</font>':$actual_date; $disp_date = ($actual_date=='0000-00-00')?$reported_date:$actual_date; list($yr,$month,$date) = explode('-',$disp_date); $disp = $month.'/'.$date.'/'.$yr; echo $actual.'<br>'; print "SET DATE <input type='text' size='10' class='tinylight' name='actual_service_date' value='$disp' style='border: 1px solid #000000' readonly></input>"; print "<a href=\"javascript:show_calendar4('document.form_service_detail.actual_service_date', document.form_service_detail.actual_service_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a><br><br>"; print "QUANTITY <input type='text' size='10' class='tinylight' name='service_qty' value='$qty' style='border: 1px solid #000000'></input><br><br>"; print "<input type='hidden' name='service' value='$sid'/>"; print "<input type='hidden' name='sts' value='$cstamp'/>"; print "<input type='hidden' name='mc_id' value='$cdid'/>"; if($_SESSION["priv_update"]): print "<input type='submit' name='submitdetail' value='Update Service' class='tinylight' style='border: 1px solid black'/> "; endif; if ($_SESSION["priv_delete"]) { print "<input type='submit' name='submitdetail' value='Delete Service' class='tinylight' style='border: 1px solid black'/> "; } print "</span>"; print "</form>"; print "</td></tr></table>"; } } } }
function form_consult_lab_fecalysis() { 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); } 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"]."&module=fecalysis&request_id=".$get_vars["request_id"]."&lab_id=SPT' name='form_lab' method='post'>"; print "<tr valign='top'><td>"; print "<b>".FTITLE_LAB_EXAM_FORM."</b><br><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_LAB_REQUEST_DETAILS."</span><br> "; $sql = "select lab_id, consult_id, date_format(request_timestamp, '%a %d %b %Y, %h:%i%p') request_timestamp, request_user_id, request_done, ". "date_format(done_timestamp, '%a %d %b %Y, %h:%i%p') done_timestamp, done_user_id ". "from m_consult_lab ". "where request_id = '".$get_vars["request_id"]."'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $lab = mysql_fetch_array($result); print "<table width='250' bgcolor='#FFFF99' style='border: 1px solid black'><tr><td class='tinylight'>"; print "<b>".LBL_LAB_EXAM.":</b> ".lab::get_lab_name($lab["lab_id"])."<br/>"; print "<b>".LBL_DATE_REQUESTED.":</b> ".$lab["request_timestamp"]."<br/>"; print "<b>".LBL_REQUESTED_BY.":</b> ".user::get_username($lab["request_user_id"])."<br/>"; print "<b>".LBL_DATE_PROCESSED.":</b> ".($lab["done_timestamp"]?$lab["done_timestamp"]:"NA")."<br/>"; print "<b>".LBL_PROCESSED_BY.":</b> ".($lab["done_user_id"]?user::get_username($lab["done_user_id"]):"NA")."<br/>"; print "</td></tr></table>"; } } print "</td></tr>"; print "<tr valign='top'><td>"; if ($get_vars["request_id"]) { $sql_fecalysis = "select fec_collection_date, ". "fec_macro_findings, ". "fec_micro_findings,release_flag, ". "from m_consult_lab_fecalysis ". "where request_id = '".$get_vars["request_id"]."'"; if ($result_fecalysis = mysql_query($sql_fecalysis)) { if (mysql_num_rows($result_fecalysis)) { $fecalysis = mysql_fetch_array($result_fecalysis); //print_r($fecalysis); // set up collection dates if ($fecalysis["fec_collection_date"]<>"0000-00-00") { list($year,$month,$day) = explode("-",$fecalysis["fec_collection_date"]); $fec_collection_date = "$month/$day/$year"; } } } } print "<table width='250' style='border: 1px dotted black'>"; print "<tr><td class='boxtitle'>".LBL_SPECIMEN."</td><td class='boxtitle'>#1</td><td class='boxtitle'>#2</td><td class='boxtitle'>#3</td></tr>"; print "<tr><td class='boxtitle'nowrap>".LBL_COLLECTION_DATE."</td>"; print "<td>"; print "<input type='text' size='10' class='tinylight' name='fec_collection_date' value='".($fec_collection_date?$fec_collection_date:$post_vars["fec_collection_date"])."' style='border: 1px solid #000000'> "; print "<a href=\"javascript:show_calendar4('document.form_lab.fec_collection_date', document.form_lab.fec_collection_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; print "</td>"; print "</tr>"; // print "<tr><td class='boxtitle'nowrap>".LBL_MACROSCOPIC_FINDINGS."</td>"; // print "<td>".fecalysis::load_template(($fecalysis["fec_macro_findings"]?$fecalysis["fec_macro_findings"]:$post_vars["fec_macro_findings"]),'fec_macro_findings')."</td>"; // print "</tr>"; // print "<tr><td class='boxtitle'nowrap>".LBL_MICROSCOPIC_FINDINGS."</td>"; // print "<td>".fecalysis::load_template(($fecalysis["fec_micro_findings"]?$fecalysis["fec_micro_findings"]:$post_vars["fec_micro_findings"]),'fec_micro_findings')."</td>"; // print "</tr>"; print "<tr valign='top'><td>"; print "<br>"; print "<span class='boxtitle'>".LBL_MACROSCOPIC_FINDINGS."</span><br> "; $default_macroscopic = fecalysis::load_template("FEC_MACROSCOPIC"); print "<textarea class='textbox' rows='8' cols='30' name='FEC_MACROSCOPIC' style='border: 1px solid #000000'>".($fecalysis["FEC_MACROSCOPIC"]?$fecalysis["FEC_MACROSCOPIC"]:($post_vars["FEC_MACROSCOPIC"]?$post_vars["FEC_MACROSCOPIC"]:$default_macroscopic))."</textarea><br>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_MICROSCOPIC_FINDINGS."</span><br> "; $default_microscopic = fecalysis::load_template("FEC_MICROSCOPIC"); print "<textarea class='textbox' rows='8' cols='30' name='FEC_MICROSCOPIC' style='border: 1px solid #000000'>".($fecalysis["FEC_MICROSCOPIC"]?$fecalysis["FEC_MICROSCOPIC"]:($post_vars["FEC_MICROSCOPIC"]?$post_vars["FEC_MICROSCOPIC"]:$default_microscopic))."</textarea><br>"; print "</td></tr>"; print "</table>"; print "</td></tr>"; print "<tr valign='top'><td>"; print "<span class='boxtitle'>".LBL_RELEASE_FLAG."</span><br> "; print "<input type='checkbox' name='release_flag' ".(($fecalysis["release_flag"]?$fecalysis["release_flag"]:$post_vars["release_flag"])=="Y"?"checked":"")." value='1'/> ".INSTR_RELEASE_FLAG."<br />"; print "<br/></td></tr>"; print "<tr><td><br>"; if ($get_vars["request_id"]) { print "<input type='hidden' name='request_id' value='".$get_vars["request_id"]."'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } if ($_SESSION["priv_delete"]) { print "<input type='submit' value = 'Delete Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } } print "</td></tr>"; print "</form>"; print "</table><br>"; }
function form_consult_lab_urinalysis() { 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]; } $q_lab_urinalysis = mysql_query("SELECT date_format(date_lab_exam,'%m/%d/%Y') as 'date_lab_exam',physical_color,physical_reaction,physical_transparency,physical_gravity,physical_ph,chem_albumin,chem_sugar,chem_pregnancy,sediments_rbc,sediments_pus,sediments_epithelial,sediments_urates,sediments_calcium,sediments_fat,sediments_phosphate,sediments_uric,sediments_amorphous,sediments_carbonates,sediments_bacteria,sediments_mucus,cast_coarsely,cast_pus,cast_hyaline,cast_finely,cast_redcell,cast_waxy FROM m_consult_lab_urinalysis WHERE request_id='{$_GET['request_id']}'") or die("Cannot query 146" . mysql_error()); $q_lab_details = mysql_query("SELECT patient_id,date_format(request_timestamp,'%a %d %b %Y, %h %i %p') as 'date_requested', request_user_id, date_format(done_timestamp,'%a %d %b %Y, %h %i %p') as 'date_done', request_done, done_user_id FROM m_consult_lab WHERE request_id='{$_GET['request_id']}'") or die("Cannot query 147:" . mysql_error()); if (mysql_num_rows($q_lab_urinalysis) != 0) { list($date_lab_exam, $color, $reaction, $transparency, $gravity, $ph, $albumin, $sugar, $pregnancy, $rbc, $pus, $epithelial, $urates, $calcium, $fat, $phosphate, $uric, $amorphous, $carbonates, $bacteria, $mucus, $cast_coarsely, $cast_pus, $cast_hyaline, $cast_finely, $cast_redcell, $cast_waxy) = mysql_fetch_array($q_lab_urinalysis); } else { $date_lab_exam = date('m/d/Y'); } list($pxid, $date_request, $request_user_id, $date_done, $request_done, $done_user_id) = mysql_fetch_array($q_lab_details); echo "<form action='{$_SERVER['PHP_SELF']}?page={$_GET['page']}&menu_id={$_GET['menu_id']}&consult_id={$_GET['consult_id']}&lab_id=URN&ptmenu={$_GET['ptmenu']}&module={$_GET['module']}&request_id={$_GET['request_id']}#{$_GET}'.'_form' method='POST' name='form_lab'>"; echo "<a name='urinalysis'></a>"; echo "<span class='tinylight'>"; echo "<b>LAB REQUEST DETAILS</b><br/>"; echo "<table width='550' bgcolor='#ffff99' style='border: 1px solid black'>"; echo "<tr><td class='tinylight'><b>LAB EXAM: </b>FECALYSIS<br/>"; echo "<b>DATE REQUESTED: </b>" . $date_request . "<br/>"; echo "<b>REQUESTED BY: </b>" . user::get_username($request_user_id) . "<br/>"; echo "<b>DATE COMPLETED: </b>" . $date_done . "<br/>"; echo "<b>PROCESSED BY: </b>" . ($done_user_id ? user::get_username($done_user_id) : "NA") . "<br/>"; echo "<b>RELEASED: </b>" . $request_done . "<br/></td></tr>"; echo "</table>"; echo "<hr size='1'/>"; echo "<table width='550' style='border: 1px solid black'>"; echo "<tr class='boxtitle' align='center'><td colspan='2'>URINALYSIS</td></tr>"; echo "<tr><td colspan='2' class='boxtitle'>DATE EXAMINED <input type='text' name='urinalysis_date' size='8' maxlength='10' value='{$date_lab_exam}' class='tinylight'></input> "; echo "<a href=\"javascript:show_calendar4('document.form_lab.urinalysis_date', document.form_lab.urinalysis_date.value);\"><img src='../images/cal.gif' width='16' height='16' border='0' alt='Click Here to Pick up the date'></a> "; echo "</td></tr>"; echo "<tr><td>PHYSICAL APPEARANCE</td><td>QUANT. CHEMICAL TEST</td></tr>"; echo "<tr>"; echo "<td>"; echo "<table>"; echo "<tr><td class='boxtitle'>COLOR</td><td><select name='sel_color' value='1' class='tinylight'>"; foreach ($this->color as $key_color => $value_color) { if ($value_color == $color) { echo "<option value='{$value_color}' SELECTED>{$value_color}</option>"; } else { echo "<option value='{$value_color}'>{$value_color}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>REACTION</td><td><select name='sel_reaction' value='1'>"; foreach ($this->reaction as $key_reaction => $value_reaction) { if ($value_reaction == $reaction) { echo "<option value='{$value_reaction}' SELECTED>{$value_reaction}</option>"; } else { echo "<option value='{$value_reaction}'>{$value_reaction}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>TRANSPARENCY</td><td><select name='sel_transparency' value='1'>"; foreach ($this->transparency as $key_trans => $value_trans) { if ($value_trans == $transparency) { echo "<option value='{$value_trans}' SELECTED>{$value_trans}</option>"; } else { echo "<option value='{$value_trans}'>{$value_trans}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>SPECIFIC GRAVITY</td><td><select name='sel_gravity' value='1'>"; foreach ($this->gravity as $key_gravity => $value_gravity) { if ($value_gravity == $gravity) { echo "<option value='{$value_gravity}' SELECTED>{$value_gravity}</option>"; } else { echo "<option value='{$value_gravity}'>{$value_gravity}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>pH</td><td><select name='sel_ph' value='1'>"; foreach ($this->ph as $key_ph => $value_ph) { if ($value_ph == $ph) { echo "<option value='{$value_ph}' SELECTED>{$value_ph}</option>"; } else { echo "<option value='{$value_ph}'>{$value_ph}</option>"; } } echo "</select></td></tr>"; echo "</table>"; echo "</td>"; echo "<td valign='top'>"; echo "<table>"; echo "<tr><td class='boxtitle'>ALBUMIN</td><td><select name='sel_albumin' value='1'>"; foreach ($this->albumin as $key_albumin => $value_albumin) { if ($value_albumin == $albumin) { echo "<option value='{$value_albumin}' SELECTED>{$value_albumin}</option>"; } else { echo "<option value='{$value_albumin}'>{$value_albumin}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>SUGAR</td><td><select name='sel_sugar' value='1'>"; foreach ($this->sugar as $key_sugar => $value_sugar) { if ($value_sugar == $sugar) { echo "<option value='{$value_sugar}' SELECTED>{$value_sugar}</option>"; } else { echo "<option value='{$value_sugar}'>{$value_sugar}</option>"; } } echo "</select></td></tr>"; echo "<tr><td class='boxtitle'>PREGNANCY TEST</td><td><select name='sel_pregnancy' value='1'>"; foreach ($this->pregnancy as $key_pregnancy => $value_pregnancy) { if ($value_pregnancy == $pregnancy) { echo "<option value='{$value_pregnancy}' SELECTED>{$value_pregnancy}</option>"; } else { echo "<option value='{$value_pregnancy}'>{$value_pregnancy}</option>"; } } echo "</select></td></tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "<tr><td colspan='2'>SEDIMENTS</td></tr>"; echo "<tr><td valign='top'>"; echo "<table>"; echo "<tr><td class='boxtitle'>RED BLOOD CELLS</td><td><input type='text' name='txt_red' size='5' value='{$rbc}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>PUS CELLS</td><td><input type='text' name='txt_pus' size='5' value='{$pus}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>EPHITHELIAL CELLS</td><td><input type='text' name='txt_epithelial' size='5' value='{$epithelial}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>AMORPHOUS URATES</td><td><input type='text' name='txt_amorphous' size='5' value='{$urates}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>CALCIUM OXELATES</td><td><input type='text' name='txt_calcium_oxelates' size='5' value='{$calcium}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>FAT GLOBULES</td><td><input type='text' name='txt_fat' size='5' value='{$fat}' class='tinylight'></input></td></tr>"; echo "</table>"; echo "</td>"; echo "<td class='boxtitle'>"; echo "<table>"; echo "<tr><td class='boxtitle'>TRIPLE PHOSPHATES</td><td><input type='text' name='txt_triple' size='5' value='{$phosphate}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>URIC ACID CRYSTALS</td><td><input type='text' name='txt_uric' size='5' value='{$uric}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>AMORPHOUS PHOSPATES</td><td><input type='text' name='txt_amorphouse_phosphate' size='5' value='{$amorphous}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>CALCIUM CARBONATES</td><td><input type='text' name='txt_calcium_carb' size='5' value='{$carbonates}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>BACTERIA</td><td><input type='text' name='txt_bacteria' size='5' value='{$bacteria}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>MUCUS THREADS</td><td><input type='text' name='txt_mucus' size='5' value='{$mucus}' class='tinylight'></input></td></tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td colspan='2'>CASTS</td></tr>"; echo "<tr>"; echo "<td valign='top' class='boxtitle'>"; echo "<table>"; echo "<tr><td class='boxtitle'>COARSELY GRANULAR CAST</td><td><input type='text' name='txt_granular' size='5' value='{$cast_coarsely}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>PUS CELLS CAST</td><td><input type='text' name='txt_pus_cast' size='5' value='{$cast_pus}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>HYALINE CAST</td><td><input type='text' name='txt_hyaline' size='5' value='{$cast_hyaline}' class='tinylight'></input></td></tr>"; echo "</table>"; echo "</td>"; echo "<td class='boxtitle'>"; echo "<table>"; echo "<tr><td class='boxtitle'>FINELY GRANULAR CAST</td><td><input type='text' name='txt_finely_cast' size='5' value='{$cast_finely}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>RED CELL CAST</td><td><input type='text' name='txt_red_cell' size='5' value='{$cast_redcell}' class='tinylight'></input></td></tr>"; echo "<tr><td class='boxtitle'>WAXY CAST</td><td><input type='text' name='txt_wax' size='5' value='{$cast_waxy}' class='tinylight'></input></td></tr>"; echo "</table>"; echo "</td>"; echo "</tr>"; echo "<tr valign='top'><td colspan='2'>"; echo "<span class='boxtitle'>" . LBL_RELEASE_FLAG . "</span><br>"; echo "<input type='checkbox' name='release_flag' value='1'/> " . INSTR_RELEASE_FLAG . "<br />"; echo "</td></tr>"; echo "<tr><td colspan='2' align='center'>"; if ($get_vars["request_id"]) { print "<input type='hidden' name='request_id' value='" . $get_vars["request_id"] . "'>"; if ($_SESSION["priv_update"]) { print "<input type='submit' value = 'Update Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } print "<input type='reset' value = 'Clear Lab Exam' class='textbox' name='submitlab' style='border: 1px solid #000000'> "; } echo "</td></tr>"; echo "</table>"; echo "</form>"; }
function show_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]; } $patient_id = healthcenter::get_patient_id($get_vars["consult_id"]); $sql = "select patient_id, consult_id, date_format(injury_timestamp, '%a %d %b %Y, %h:%i%p') ts, " . "user_id, injury_id, location_code, location_detail, injury_date, injury_time, mechanism_code " . "from m_consult_injury where patient_id = '{$patient_id}' and consult_id = '" . $get_vars["cid"] . "'"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $injury = mysql_fetch_array($result); print "<table cellpadding='1' width='200' style='border: 1px dotted black'><tr><td>"; print "<span class='tinylight'>"; print "CONSULT DATE: " . $injury["ts"] . "<br/>"; print "SEEN BY: " . user::get_username($injury["user_id"]) . "<br/><br/>"; print "INJURY DATE: " . $injury["injury_date"] . "<br/>"; print "INJURY TIME: " . $injury["injury_time"] . "<br/>"; print "INJURY CODE: " . injury::get_injury_name($injury["injury_id"]) . "<br/>"; print "INJURY LOCATION: " . injury::get_location_name($injury["location_code"]) . "<br/>"; print "INJURY MECHANISM:<br/>" . stripslashes(nl2br($injury["injury_mechanism"])) . "<br/>"; print "</span>"; print "</td></tr></table>"; } } }