function family_info() { // // family 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 p.patient_id, p.patient_lastname, p.patient_firstname, p.patient_dob, p.patient_gender, round((to_days(now())-to_days(p.patient_dob))/365 , 1) computed_age, f.family_role ". "from m_family_members f, m_patient p where p.patient_id = f.patient_id and f.family_id = '".$get_vars["family_id"]."'". "order by p.patient_lastname, p.patient_firstname"; if ($result = mysql_query($sql)) { print "<table width=270 bgcolor='#FFFFFF' cellpadding='4' cellspacing='0' style='border: 2px solid black'>"; print "<tr><td>"; print "<span class='tinylight'>".INSTR_FAMILY_INFO."</span><br/>"; print "<b><font color='red'>SELECTED FAMILY</font> "; //print "<a href='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&family_id=".$get_vars["family_id"]."&edit_family_id=".$get_vars["family_id"]."#family_form'>".module::pad_zero($get_vars["family_id"],5)."</a></b> "; print module::pad_zero($get_vars["family_id"],5)." <a href='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&family_id=".$get_vars["family_id"]."&edit_family_id=".$get_vars["family_id"]."#family_form'>".edit."</a></b> "; print "<br>"; print "<font color='#999999'>"; print "<b>ADDRESS:</b> ".$this->show_address($get_vars["family_id"])."<br/>"; print "<b>BARANGAY:</b> ".$this->barangay_name($get_vars["family_id"])."<br/>"; print "</font>"; print "<br/>"; if (mysql_num_rows($result)) { $i=0; while (list($pid, $plast, $pfirst, $pdob, $pgender, $p_age, $role) = mysql_fetch_array($result)) { //$patient_menu_id = module::get_menu_id("_patient"); //$consult_menu_id = module::get_menu_id("_consult"); print "<a href='".$_SERVER["PHP_SELF"]."?page=PATIENTS&menu_id=".$get_vars["menu_id"]."&patient_id=$pid&family_id=".$get_vars["family_id"]."'><b>$plast, $pfirst</b></a> [$p_age/$pgender] "; if ($role=="head") { print "<img src='../images/star.gif' border='0'/> "; } if ($_SESSION["priv_delete"]) { print "<a href='".$_SERVER["PHP_SELF"]."?page=".$get_vars["page"]."&menu_id=".$get_vars["menu_id"]."&family_id=".$get_vars["family_id"]."&delete_id=$pid'><img src='../images/delete.png' border='0'/></a>"; } print "<br/>"; $i++; if ($get_vars["patient_id"]==$pid) { family::form_assign_role($menu_id, $post_vars, $get_vars); } } } else { print "No members for this family."; } print "</td></tr>"; print "</table><br/>"; } }