Beispiel #1
0
 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)."&nbsp;<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/>";
     }
 }