function display_philhealth() {
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_RELATIVE_PHILHEALTH_RECORD."</b><br>";
// does member have philhealth id?
$patient_id = healthcenter::get_patient_id($get_vars["consult_id"]);
$patient_name = patient::get_name($patient_id);
$philhealth_id = philhealth::get_philhealth_id($patient_id);
if (!$philhealth_id) {
// try to see if any family member has a philhealth id
$family_id = family::get_family_id($patient_id);
$philhealth_info = philhealth::whois_philhealth_member($family_id);
$patient_name = $philhealth_info["patient_lastname"].", ".$philhealth_info["patient_firstname"];
$philhealth_id = $philhealth_info["philhealth_id"];
}
if ($philhealth_id && $patient_name) {
print "BENEFICIARY: <b>$patient_name</b><br/>";
print "PHILHEALTH ID: <b>$philhealth_id</b><br/>";
print "EXPIRY: <b>".philhealth::get_expiry_date($philhealth_id)."</b><br/><br/>";
print "<input type='hidden' name='philhealth_id' value='$philhealth_id'/>";
} else {
print "<font color='red'>No PHILHEALTH membership found.</font><br/>";
}
print "</td></tr>";
print "<tr valign='top'><td>";
print "<b>".FTITLE_PHILHEALTH_RECORD."</b><br>";
print "</td></tr>";
$patient_id = healthcenter::get_patient_id($get_vars["consult_id"]);
$sql = "select h.patient_id, ".
"concat(p.patient_lastname, ', ',p.patient_firstname, ' ', p.patient_middle), philhealth_id, ".
"expiry_date, to_days(sysdate()), to_days(expiry_date) ".
"from m_patient_philhealth h, m_patient p ".
"where h.patient_id = p.patient_id and h.patient_id = '$patient_id' ".
"order by h.expiry_date desc";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) {
print "<tr valign='top'><td>";
while (list($pid, $name, $hid, $expiry, $days_sysdate, $days_expirydate) = mysql_fetch_array($result)) {
print "<img src='../images/arrow_redwhite.gif' border='0'/> ";
print "$name <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=CARD&pid=$hid'>$hid</a> ".
"[EXP ".($days_expirydate<=$days_sysdate?"<font color='red'><b>$expiry</b></font>":"$expiry")."]<br/>";
}
print "</td></tr>";
} else {
print "<tr valign='top'><td><font color='red'>No records.</font></td></tr>";
}
}
print "</table><br>";
}
