function display_postpartum_record_detail() {
//
// called from _details_mc()
// lowest level detail about postpartum visit
//
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(postpartum_date, '%a %d %b %Y, %h:%i%p') postpartum_date, ".
"user_id, postpartum_week, visit_sequence, date_format(postpartum_timestamp, '%a %d %b %Y, %h:%i%p') postpartum_timestamp, ".
"blood_pressure_systolic, blood_pressure_diastolic, visit_type, ".
"breastfeeding_flag, family_planning_flag, fever_flag, ".
"vaginal_infection_flag, vaginal_bleeding_flag, pallor_flag, cord_ok_flag ".
"from m_consult_mc_postpartum where patient_id = '$patient_id' and ".
"mc_id = '".$get_vars["mc_id"]."' and visit_sequence = '".$get_vars["ppvisitseq"]."'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$mc = mysql_fetch_array($result);
if ($get_vars["mc_id"]==$mc["mc_id"]) {
print "<a name='postpartum_detail'>";
$bgcolor = ($get_vars["consult_id"]==$mc["consult_id"]?"#FFFFCC":"#FFFFFF");
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=POSTP".($get_vars["mc_id"]?"&mc_id=".$get_vars["mc_id"]."&visitseq=".$get_vars["visitseq"]."#postpartum_visit":"")."'>";
print "<table bgcolor='$bgcolor' 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/>";
print "VISIT DATE: ".$mc["postpartum_date"]."<br/>";
print "VISIT SEQUENCE: ".$mc["visit_sequence"]."<br/>";
print "VISIT TYPE: ".$mc["visit_type"]."<br/>";
print "POSTPARTUM WEEK: ".$mc["postpartum_week"]."<br/>";
print "<hr size='1'/>";
print "LAST UPDATE: ".$mc["postpartum_timestamp"]."<br/>";
print "UPDATE BY: ".user::get_username($mc["user_id"])."<br/>";
print "<hr size='1'/>";
print "VITAL SIGNS:<br/>";
print " SYS BP: ".$mc["blood_pressure_systolic"]."<br/>";
print " DIAS BP: ".$mc["blood_pressure_diastolic"]."<br/>";
print "<br/>";
print "POSTPARTUM EVENTS:<br/>";
print " Fever >38°C: ".($mc["fever_flag"]=="Y"?"Yes":"No")."<br/>";
print " Vaginal Infection: ".($mc["vaginal_infection_flag"]=="Y"?"Yes":"No")."<br/>";
print " Vaginal Bleeding: ".($mc["vaginal_bleeding_flag"]=="Y"?"Yes":"No")."<br/>";
print " Pallor: ".($mc["pallor_flag"]=="Y"?"Yes":"No")."<br/>";
print " Baby's Cord OK: ".($mc["cord_ok_flag"]=="Y"?"Yes":"No")."<br/>";
print "<br/>";
print "OTHER INFO:<br/>";
print " Breastfeeding: ".($mc["breastfeeding_flag"]=="Y"?"Yes":"No")."<br/>";
print " Family Planning Method: ".($mc["family_planning_flag"]=="Y"?"Yes":"No")."<br/>";
print "<br/>";
if ($_SESSION["priv_update"]) {
print "<input type='submit' name='submitmc' value='Update Visit' class='tinylight' style='border: 1px solid black'/>";
print "<input type='hidden' name='postpartum_id' value='".$mc["mc_id"]."'/>";
print "<input type='hidden' name='visit_sequence' value='".$mc["visit_sequence"]."'/>";
}
print "</span>";
print "</td></tr></table>";
print "</form>";
}
}
}
}
function _consult_lab_urinalysis_results()
{
$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']}' AND release_flag='Y'") 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']}' AND request_done='Y'") or die("Cannot query 147:" . mysql_error());
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);
list($pxid, $date_request, $request_user_id, $date_done, $request_done, $done_user_id) = mysql_fetch_array($q_lab_details);
echo "<a name='urinalysis_result'></a>";
echo "<table style='border: 1px dotted black' width='400'><tr><td colspan='2'>";
echo "<span class='tinylight'>";
echo "<b>URINALYSIS 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'/>";
echo "<tr><td colspan='2' class='boxtitle'>URINALYSIS EXAM DATE: {$date_lab_exam}";
echo "</td></tr>";
echo "<tr><td class='boxtitle'>PHYSICAL APPEARANCE</td><td class='boxtitle'>QUANT. CHEMICAL TEST</td></tr>";
echo "<tr>";
echo "<td>";
echo "<table>";
echo "<tr><td class='boxtitle'>COLOR:</td><td class='tinylight'>{$color}</td></tr>";
echo "<tr><td class='boxtitle'>REACTION:</td><td class='tinylight'>{$reaction}</td></tr>";
echo "<tr><td class='boxtitle'>TRANSPARENCY:</td><td class='tinylight'>{$transparency}</td></tr>";
echo "<tr><td class='boxtitle'>SPECIFIC GRAVITY:</td><td class='tinylight'>{$gravity}</td></tr>";
echo "<tr><td class='boxtitle'>pH:</td><td class='tinylight'>{$ph}</td></tr>";
echo "</table>";
echo "</td>";
echo "<td valign='top'>";
echo "<table>";
echo "<tr><td class='boxtitle'>ALBUMIN:</td><td class='tinylight'>{$albumin}</td></tr>";
echo "<tr><td class='boxtitle'>SUGAR:</td><td class='tinylight'>{$sugar}</td></tr>";
echo "<tr><td class='boxtitle'>PREGNANCY TEST:</td><td class='tinylight'>{$pregnancy}</td></tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr><td colspan='2' class='boxtitle'><hr size='1'>SEDIMENTS</td></tr>";
echo "<tr><td valign='top'>";
echo "<table>";
echo "<tr><td class='boxtitle'>RED BLOOD CELLS:</td><td class='tinylight'>{$rbc}</td></tr>";
echo "<tr><td class='boxtitle'>PUS CELLS:</td><td class='tinylight'>{$pus}</td></tr>";
echo "<tr><td class='boxtitle'>EPHITHELIAL CELLS:</td><td class='tinylight'>{$epithelial}</td></tr>";
echo "<tr><td class='boxtitle'>AMORPHOUS URATES:</td><td class='tinylight'>{$urates}</td></tr>";
echo "<tr><td class='boxtitle'>CALCIUM OXALATES:</td><td class='tinylight'>{$calcium}</td></tr>";
echo "<tr><td class='boxtitle'>FAT GLOBULES:</td><td class='tinylight'>{$fat}</td></tr>";
echo "</table>";
echo "</td>";
echo "<td class='boxtitle'>";
echo "<table>";
echo "<tr><td class='boxtitle'>TRIPLE PHOSPHATES:</td><td class='tinylight'>{$phosphate}</td></tr>";
echo "<tr><td class='boxtitle'>URIC ACID CRYSTALS:</td><td class='tinylight'>{$uric}</td></tr>";
echo "<tr><td class='boxtitle'>AMORPHOUS PHOSPATES:</td><td class='tinylight'>{$amorphous}</td></tr>";
echo "<tr><td class='boxtitle'>BACTERIA:</td><td class='tinylight'>{$bacteria}</td></tr>";
echo "<tr><td class='boxtitle'>MUCUS THREADS:</td><td class='tinylight'>{$mucus}</td></tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td colspan='2' class='boxtitle'><hr size='1'>CASTS</td></tr>";
echo "<tr>";
echo "<td class='boxtitle'>";
echo "<table>";
echo "<tr><td class='boxtitle'>COARSELY GRANULAR CAST:</td><td class='tinylight'>{$cast_coarsely}</td></tr>";
echo "<tr><td class='boxtitle'>PUS CELLS CAST:</td><td class='tinylight'>{$cast_pus}</td></tr>";
echo "<tr><td class='boxtitle'>HYALINE CAST:</td><td class='tinylight'>{$cast_hyaline}</td></tr>";
echo "</table>";
echo "</td>";
echo "<td class='boxtitle'>";
echo "<table>";
echo "<tr><td class='boxtitle'>FINELY GRANULAR CAST:</td><td class='tinylight'>{$cast_finely}</td></tr>";
echo "<tr><td class='boxtitle'>RED CELL CAST:</td><td class='tinylight'>{$cast_redcell}</td></tr>";
echo "<tr><td class='boxtitle'>WAXY CAST:</td><td class='tinylight'>{$cast_waxy}</td></tr>";
echo "</table>";
echo "</td>";
echo "</tr>";
echo "</span>";
echo "</table>";
}
function _consult_lab_sputum_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];
}
$sql = mysql_query("select l.request_id, l.request_user_id, l.request_done, ".
"date_format(l.request_timestamp, '%a %d %b %Y, %h:%i%p') request_timestamp, ".
"s.consult_id, s.patient_id, done_user_id, ".
"if(l.done_timestamp<>'00000000000000', date_format(l.done_timestamp, '%a %d %b %Y, %h:%i%p'), 'NA') done_timestamp, ".
"if(l.request_done='Y', (unix_timestamp(l.done_timestamp)-unix_timestamp(l.request_timestamp))/3600,(unix_timestamp(sysdate())-unix_timestamp(l.request_timestamp))/3600) elapsed, ".
"s.sp1_collection_date, s.sp2_collection_date, s.sp3_collection_date, ".
"s.sp1_appearance, s.sp2_appearance, s.sp3_appearance, ".
"s.sp1_reading, s.sp2_reading, s.sp3_reading, s.lab_diagnosis, ".
"s.user_id, s.request_id, s.release_flag, s.sputum_period,s.lab_diag1,s.lab_diag2,s.lab_diag3 ".
"from m_consult_lab_sputum s, m_consult_lab l ".
"where l.request_id = s.request_id and ".
"s.request_id = '".$get_vars["request_id"]."'") or die("Cannot query ".mysql_error());
if ($sql) {
if (mysql_num_rows($sql)) {
$sputum = mysql_fetch_array($sql);
$res1 = ((!empty($sputum["lab_diag1"])?(($sputum["lab_diag1"]=="P")?"Positive":(($sputum["lab_diag1"]=="N")?"Negative":"Doubtful")):"No diagnosis yet"));
$res2 = ((!empty($sputum["lab_diag2"])?(($sputum["lab_diag2"]=="P")?"Positive":(($sputum["lab_diag2"]=="N")?"Negative":"Doubtful")):"No diagnosis yet"));
$res3 = ((!empty($sputum["lab_diag3"])?(($sputum["lab_diag3"]=="P")?"Positive":(($sputum["lab_diag3"]=="N")?"Negative":"Doubtful")):"No diagnosis yet"));
print "<a name='sputum_result'>";
print "<table style='border: 1px dotted black'><tr><td>";
print "<span class='tinylight'>";
print "<b>SPUTUM RESULTS FOR ".strtoupper(patient::get_name($sputum["patient_id"]))."</b><br/>";
print "REQUEST ID: <font color='red'>".module::pad_zero($sputum["request_id"],7)."</font><br/>";
print "DATE REQUESTED: ".$sputum["request_timestamp"]."<br/>";
print "REQUESTED BY: ".user::get_username($sputum["request_user_id"])."<br/>";
print "DATE COMPLETED: ".$sputum["done_timestamp"]."<br/>";
print "PROCESSED BY: ".($sputum["done_user_id"]?user::get_username($sputum["done_user_id"]):"NA")."<br/>";
print "HOURS ELAPSED: ".$sputum["elapsed"]."<br/>";
print "RELEASED: ".$sputum["release_flag"]."<br/>";
print "<hr size='1'/>";
print "SPUTUM EXAM PERIOD:<br/> ";
print " ".sputum::get_sputum_period_name($sputum["sputum_period"])."<br/>";
print "<hr size='1'/>";
print "SPECIMEN COLLECTION DATES - DIAGNOSIS<br/>";
print "sp #1: ".$sputum["sp1_collection_date"]." - ".$res1."<br/>";
print "sp #2: ".$sputum["sp2_collection_date"]." - ".$res2."<br/>";
print "sp #3: ".$sputum["sp3_collection_date"]." - ".$res3."<br/>";
print "<hr size='1'/>";
print "SPECIMEN VISUAL APPEARANCE:<br/>";
print "sp #1: ".sputum::get_sputum_appearance_name($sputum["sp1_appearance"])."<br/>";
print "sp #2: ".sputum::get_sputum_appearance_name($sputum["sp2_appearance"])."<br/>";
print "sp #3: ".sputum::get_sputum_appearance_name($sputum["sp3_appearance"])."<br/>";
print "<hr size='1'/>";
print "SPECIMEN READING:<br/>";
print "sp #1: ".sputum::get_sputum_reading_name($sputum["sp1_reading"])."<br/>";
print "sp #2: ".sputum::get_sputum_reading_name($sputum["sp2_reading"])."<br/>";
print "sp #3: ".sputum::get_sputum_reading_name($sputum["sp3_reading"])."<br/>";
print "<hr size='1'/>";
print "FINAL LAB DIAGNOSIS: ".sputum::get_diagnosis_name($sputum["lab_diagnosis"])."<br/>";
print "</span>";
print "</td></tr></table>";
}
}
}
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 _consult_lab_fecalysis_results()
{
$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']}' AND release_flag='Y'") 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']}' AND request_done='Y'") 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);
list($date_lab_exam, $color, $consistency, $blood, $ova, $wbc, $rbc, $bacteria, $fat, $starch, $others, $userid, $pxid) = mysql_fetch_row($q_fecalysis);
echo "<a name='fecalysis_result'></a>";
echo "<table style='border: 1px dotted black'><tr><td>";
print "<span class='tinylight'>";
print "<b>FECALYSIS RESULTS FOR " . strtoupper(patient::get_name($pxid)) . "</b><br/>";
print "REQUEST ID: <font color='red'>" . module::pad_zero($_GET["request_id"], 7) . "</font><br/>";
print "DATE REQUESTED: " . $date_request . "<br/>";
print "REQUESTED BY: " . user::get_username($request_user_id) . "<br/>";
print "DATE COMPLETED: " . $date_done . "<br/>";
print "PROCESSED BY: " . ($done_user_id ? user::get_username($done_user_id) : "NA") . "<br/>";
print "RELEASED: " . $request_done . "<br/>";
print "<hr size='1'/>";
print "<b>FECALYSIS EXAM DATE: </b>" . $date_lab_exam . "<br/> ";
print "<b>MACROSCOPIC</b><br/><b>PHYSICAL</b><br/>";
print "<b>COLOR: </b>" . $color . "<br/>";
print "<b>CONSISTENCY: </b>" . $consistency . "<br/>";
print "<b>CHEMICAL</b><br/>";
print "<b>OCCULT BLOOD: </b>" . $blood . "<br/>";
print "<hr size='1'/>";
print "<b>MICROSCOPIC </b><br/>";
print "<b>OVA OR PARASITE: </b>" . $ova . "<br/>";
print "<b>WBC: </b>" . $wbc . "<br/>";
print "<b>RBC: </b>" . $rbc . "<br/>";
print "<b>BACTERIA: </b>" . $bacteria . "<br/>";
print "<b>FAT GLOBULES: </b>" . $fat . "<br/>";
print "<b>STARCH GRANULES: </b>" . $starch . "<br/>";
print "<b>OTHERS: </b>" . $others . "<br/>";
print "</span>";
echo "</td></tr></table>";
}
function display_reminder_data()
{
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 "<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=reminder&reminder=DATA'>";
print "<table width='300' cellpadding='2' style='border: 1px dotted black'><tr><td>";
$patient_id = healthcenter::get_patient_id($get_vars["consult_id"]);
print "<b>NAME: " . strtoupper(patient::get_name($patient_id)) . "</b><br/>";
$sql = "select patient_id, cellular_phone, home_phone, " . "office_phone, email_address, home_address, " . "barangay, reg_timestamp, user_id " . "from m_patient_reminder_data " . "where patient_id = {$patient_id}";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$reminder = mysql_fetch_array($result);
print "<span class='tinylight'>";
if (strlen($reminder["cellular_phone"]) > 0) {
print "CELLULAR PHONE: " . $reminder["cellular_phone"] . "<br/>";
}
if (strlen($reminder["home_phone"]) > 0) {
print "HOME PHONE: " . $reminder["home_phone"] . "<br/>";
}
if (strlen($reminder["office_phone"]) > 0) {
print "OFFICE PHONE: " . $reminder["office_phone"] . "<br/>";
}
if (strlen($reminder["email_address"]) > 0) {
print "EMAIL ADDRESS: " . $reminder["email_address"] . "<br/>";
}
if (strlen($reminder["home_address"]) > 0) {
print "HOME ADDRESS: " . $reminder["home_address"] . "<br/>";
}
if ($reminder["barangay"]) {
print "BARANGAY: " . barangay::barangay_name($reminder["barangay"]) . "<br/>";
}
print "<br/></span>";
print "<input type='hidden' name='patient_id' value='" . $reminder["patient_id"] . "' />";
if ($_SESSION["priv_update"] || $_SESSION["priv_delete"]) {
print "<input type='submit' name='submitdetail' value='Edit Reminder Data' class='tinylight' style='border: 1px solid black' />";
}
} else {
print "<font color='red'>No reminder data</font><br/>";
}
}
print "</td></tr></table>";
print "</form>";
}
function _consult_lab_fecalysis_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];
}
$sql = "select l.request_id, l.request_user_id, l.request_done, ".
"date_format(l.request_timestamp, '%a %d %b %Y, %h:%i%p') request_timestamp, ".
"f.consult_id, f.patient_id, done_user_id, ".
"if(l.done_timestamp<>'00000000000000', date_format(l.done_timestamp, '%a %d %b %Y, %h:%i%p'), 'NA') done_timestamp, ".
"if(l.request_done='Y', (unix_timestamp(l.done_timestamp)-unix_timestamp(l.request_timestamp))/3600,(unix_timestamp(sysdate())-unix_timestamp(l.request_timestamp))/3600) elapsed, ".
"f.fec_collection_date, ".
"f.fec_macro_findings, ".
"f.fec_micro_findings, ".
"f.user_id, f.request_id ".
"from m_consult_lab_fecalysis f, m_consult_lab l ".
"where l.request_id = f.request_id and ".
"f.request_id = '".$get_vars["request_id"]."'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
$fecalysis = mysql_fetch_array($result);
print "<a name='fecalysis'>";
print "<table style='border: 1px dotted black'><tr><td>";
print "<span class='tinylight'>";
print "<b>FECALYSIS RESULTS FOR ".strtoupper(patient::get_name($fecalysis["patient_id"]))."</b><br/>";
print "REQUEST ID: <font color='red'>".module::pad_zero($fecalysis["request_id"],7)."</font><br/>";
print "DATE REQUESTED: ".$fecalysis["request_timestamp"]."<br/>";
print "REQUESTED BY: ".user::get_username($fecalysis["request_user_id"])."<br/>";
print "DATE COMPLETED: ".$fecalysis["done_timestamp"]."<br/>";
print "PROCESSED BY: ".($fecalysis["done_user_id"]?user::get_username($fecalysis["done_user_id"]):"NA")."<br/>";
print "RELEASED: ".$fecalysis["release_flag"]."<br/>";
print "<hr size='1'/>";
print "SPECIMEN COLLECTION DATE:<br/>";
print $fecalysis["fec_collection_date"]."<br/>";
print "<hr size='1'/>";
print "MACROSCOPIC FINDINGS:<br/>";
print $fecalysis["fec_macro_findings"]."<br/>";
print "<hr size='1'/>";
print "MICROSCOPIC FINDINGS:<br/>";
print $fecalysis["fec_micro_findings"]."<br/>";
print "<hr size='1'/>";
print "</span>";
print "</td></tr></table>";
}
}
}
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 display_notifiable_diseases_hx()
{
//
// displays notifiable diseases
// entered for all consults
//
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"]);
$patient_name = patient::get_name($get_vars["patient_id"]);
print "<table width='300'>";
print "<tr valign='top'><td>";
print "<b>" . FTITLE_NOTIFIABLE_DISEASES_CONSULT_HX . "</b><br>";
print "</td></tr>";
$sql = "select distinct h.consult_id, h.disease_id, l.disease_name, h.onset_date " . "from m_lib_disease_notifiable l, m_consult_disease_notifiable h " . "where l.disease_id = h.disease_id and h.patient_id = '{$patient_id}'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
print "<tr valign='top'><td>";
while (list($cid, $did, $name, $onset) = mysql_fetch_array($result)) {
print "<img src='../images/arrow_redwhite.gif' border='0'/> ";
print "<a href='" . $_SERVER["SELF"] . "?page=" . $get_vars["page"] . "&menu_id=" . $get_vars["menu_id"] . "&consult_id=" . $get_vars["consult_id"] . "&ptmenu=DETAILS&module=philhealth&philhealth=LABS&pid={$hid}'>{$hid}</a> {$name} ({$onset}) <br/>";
}
print "</td></tr>";
} else {
print "<tr valign='top'><td><font color='red'>No records.</font></td></tr>";
}
}
print "</table><br>";
}
function display_consult_icd10_hx()
{
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
$patient_id = healthcenter::get_patient_id($get_vars["consult_id"]);
$patient_name = patient::get_name($get_vars["patient_id"]);
print "<table width='300'>";
print "<tr valign='top'><td>";
print "<b>" . FTITLE_CONSULT_ICD10_HX . "</b><br>";
print "</td></tr>";
$sql = "select h.consult_id, h.diagnosis_code, l.description " . "from m_lib_icd10_en l, m_consult_icd10 h " . "where l.diagnosis_code = h.diagnosis_code and h.patient_id = '{$patient_id}' " . "order by h.diagnosis_code";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
print "<tr valign='top'><td>";
while (list($cid, $icd, $name) = mysql_fetch_array($result)) {
print "<img src='../images/arrow_redwhite.gif' border='0'/> ";
print "<b>{$icd}</b> {$name} ";
print "<br/>";
}
print "</td></tr>";
} else {
print "<tr valign='top'><td><font color='red'>No records.</font></td></tr>";
}
}
print "</table><br>";
}
function display_appointment_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, actual_date, to_days(visit_date)- to_days(actual_date) variance ".
"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 "<a name='detail'>";
print "<table width='600' cellpadding='1'><tr valign='top'><td>";
// column 1
print "<form method='post' action='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&patient_id=".$get_vars["patient_id"]."&schedule_id=".$appt["schedule_id"]."&year=".$get_vars["year"]."&month=".$get_vars["month"]."&day=".$get_vars["day"]."&s=0'>";
print "<table width='300' bgcolor='#FFFFCC' cellpadding='3'><tr><td>";
print "<span class='PATIENT'>".strtoupper(patient::get_name($appt["patient_id"]))."</span><br/><br/>";
print "VISIT DATE: <font color='red'><b>".$appt["visit_date"]."</b></font><br/>";
print "ACTUAL DATE: <font color='red'><b>".($appt["actual_date"]=="0000-00-00"?"No visit yet":$appt["actual_date"])."</b></font><br/>";
if ($appt["actual_date"]<>"0000-00-00") {
print "VARIANCE, DAYS: ".($appt["variance"]<0?"<font color='red'><b>".$appt["variance"]."</b></font>":$appt["variance"])."<br/>";
}
print "REMINDER: ".$appt["reminder_flag"]."<br/>";
print "APPT SET BY: ".user::get_username($appt["user_id"])."<br/><br/>";
print "<span class='boxtitle'>APPT CODE</span><br/> ".appointment::get_appointment_name($appt["appointment_id"])."<br/><br/>";
/*
print "<span class='boxtitle'>ACTUAL FOLLOWUP DATE</span><br/>";
if ($injury["injury_date"]) {
list($year, $month, $day) = explode("-", $injury["injury_date"]);
$injury_date = "$month/$day/$year";
}
print "<input type='text' size='15' maxlength='10' class='textbox' name='injury_date' value='".($injury_date?$injury_date:$post_vars["injury_date"])."' style='border: 1px solid #000000'> ";
print "<a href=\"javascript:show_calendar4('document.form_consult_injury.injury_date', document.form_consult_injury.injury_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/>";
*/
if ($appt["actual_date"]=="0000-00-00") {
print "<span class='boxtitle'>".LBL_DEFER_CONSULT."?</span><br/>";
print "<input type='checkbox' name='defer_consult' checked value='1'/> ".INSTR_DEFER_CONSULT."<br/><br/>";
}
if ($_SESSION["priv_add"]) {
if ($appt["actual_date"]=="0000-00-00") {
print "<input type='submit' class='textbox' name='submitsked' value='Arrived' style='border: 1px solid black'/> ";
}
}
if ($_SESSION["priv_delete"]) {
print "<input type='submit' class='textbox' name='submitsked' value='Delete' style='border: 1px solid black'/> ";
}
print "<input type='hidden' name='schedule_id' value='".$get_vars["schedule_id"]."'/>";
print "<input type='hidden' name='consult_patient_id' value='".$appt["patient_id"]."'/>";
print "</td></tr></table></form>";
print "</td><td width='50%'>";
// column 2
// followup history
// compute only for those who have followed up
print "<b>".LBL_FOLLOW_UP_BEHAVIOR."</b><br/>";
$sql_hx = "select case when (to_days(visit_date)-to_days(actual_date)) >= 0 and actual_date <> '0000-00-00' then 'on time' ".
"when (to_days(visit_date)-to_days(actual_date)) < 0 and actual_date <> '0000-00-00' then 'not on time' ".
"when actual_date = '0000-00-00' then 'no follow up' ".
"end status, count(schedule_id) times, round(avg(to_days(visit_date)-to_days(actual_date)),2) variance ".
"from m_consult_appointments ".
"where patient_id = ".$appt["patient_id"]." and ".
"actual_date <> '0000-00-00' group by status";
if ($result_hx = mysql_query($sql_hx)) {
if (mysql_num_rows($result_hx)) {
print "<table width='300'>";
print "<tr valign='top'><td class='tinylight'><b>STATUS</b></td><td class='tinylight'><b>FREQUENCY</b></td><td class='tinylight'><b>AVE VARIANCE</b></td></tr>";
while (list($status, $times, $variance) = mysql_fetch_array($result_hx)) {
print "<tr valign='top'><td class='tinylight'>$status</td><td class='tinylight'>$times</td><td class='tinylight'>$variance</td></tr>";
}
print "</table><br/>";
} else {
print "<font color='red'>No records to process</font><br/><br/>";
}
}
print "<b>".LBL_PATIENT_DETAILS."</b><br/><br/>";
print "<span class='tinylight'>";
print "<b>".FTITLE_FAMILY_INFO."</b><br/>";
$family_id = family::get_family_id($appt["patient_id"]);
if ($family_id) {
print "FAMILY ID: $family_id<br/>";
print "ADDRESS: ".family::get_family_address($family_id)."<br/>";
print "BARANGAY: ".family::barangay_name($family_id)."<br/>";
print "MEMBERS:<br/>".family::get_family_members($family_id)."<br/>";
} else {
print "<font color='red'>No family record.</font><br/><br/>";
}
print "<b>".FTITLE_PATIENT_GROUP_HX."</b><br/>";
$sql_ptgroup = "select count(c.ptgroup_id), g.ptgroup_name, g.ptgroup_module, c.ptgroup_id, c.consult_id ".
"from m_consult_ptgroup c, m_lib_ptgroup g, m_consult h ".
"where g.ptgroup_id = c.ptgroup_id and ".
"h.consult_id = c.consult_id and ".
"h.patient_id = '".$appt["patient_id"]."' ".
"group by c.ptgroup_id";
if ($result = mysql_query($sql_ptgroup)) {
if (mysql_num_rows($result)) {
while (list($count, $name, $mod, $grp, $cid) = mysql_fetch_array($result)) {
print "<img src='../images/arrow_redwhite.gif' border='0'/> ";
print "$name: $count ".($count>1?" visits":"visit")."<br/> ";
}
} else {
print "<font color='red'>No records.</font><br/>";
}
}
print "</span>";
print "</td></tr></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 display_services() {
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"]);
$patient_name = patient::get_name($get_vars["patient_id"]);
print "<table width='300'>";
print "<tr valign='top'><td>";
print "<b>".FTITLE_PHILHEALTH_SERVICES."</b><br>";
print "</td></tr>";
$sql = "select h.patient_id, h.philhealth_id, s.service_name ".
"from m_lib_philhealth_services s, m_consult_philhealth_services h ".
"where s.service_id = h.service_id and h.consult_id = '".$get_vars["consult_id"]."'";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
print "<tr valign='top'><td>";
while (list($pid, $hid, $lab) = mysql_fetch_array($result)) {
print "<img src='../images/arrow_redwhite.gif' border='0'/> ";
print "<a href='".$_SERVER["SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&consult_id=".$get_vars["consult_id"]."&ptmenu=DETAILS&module=philhealth&philhealth=LABS&pid=$hid'>$hid</a> $lab<br/>";
}
print "</td></tr>";
} else {
print "<tr valign='top'><td><font color='red'>No records.</font></td></tr>";
}
}
print "</table><br>";
}
