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