function generate_summary() { 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); } list($month, $day, $year) = explode("/", $post_vars["report_date"]); $report_date = $year."-".str_pad($month, 2, "0", STR_PAD_LEFT)."-".str_pad($day, 2, "0", STR_PAD_LEFT); // STEP 1. empty report table for given date print $sql_delete = "delete from m_consult_report_dailyservice where service_date = '$report_date'"; $result_delete = mysql_query($sql_delete); // STEP 2. get all consults for specified report date // records are unique for patient_id and service_date $sql_patient = "select c.patient_id, concat(p.patient_lastname, ', ', p.patient_firstname) patient_name, ". "round((to_days(c.consult_date)-to_days(p.patient_dob))/365,2) patient_age, ". "p.patient_gender ". "from m_consult c, m_patient p ". "where c.patient_id = p.patient_id ". "and to_days(c.consult_date) = to_days('$report_date')"; if ($result_patient = mysql_query($sql_patient)) { if (mysql_num_rows($result_patient)) { while ($patient = mysql_fetch_array($result_patient)) { // get family and address if ($family_id = family::get_family_id($patient["patient_id"])) { $patient_address = family::get_family_address($family_id); $barangay_name = family::barangay_name($family_id); } else { $family_id = 0; $patient_address = reminder::get_home_address($patient_id); $barangay_name = reminder::get_barangay($patient_id); } // get chief complaint from notes $complaints = notes::get_complaints($patient["patient_id"], $report_date); // get notes dx list or icd10 list if (!$dx_list = icd10::get_icd10_list($patient["patient_id"], $report_date)) { $dx_list = notes::get_diagnosis_list($patient["patient_id"], $report_date); } // get treatment data from notes $plans = notes::get_plan($patient["patient_id"], $report_date); $sql_insert = "insert into m_consult_report_dailyservice (patient_id, patient_name, patient_gender, ". "patient_age, patient_address, patient_bgy, family_id, notes_cc, notes_dx, notes_tx, service_date) ". "values ('".$patient["patient_id"]."', '".$patient["patient_name"]."', ". "'".$patient["patient_gender"]."', '".$patient["patient_age"]."', ". "'$patient_address', '$barangay_name', '$family_id', '$complaints', ". "'$dx_list', '$plans', '$report_date')"; $result_insert = mysql_query($sql_insert); } } } }
} } if (file_exists('../modules/healthcenter/class.healthcenter.php')) { include '../modules/healthcenter/class.healthcenter.php'; $healthcenter = new healthcenter; if (!$module->activated('healthcenter') && $initmod) { $healthcenter->init_sql(); $healthcenter->init_menu(); $healthcenter->init_deps(); $healthcenter->init_lang(); $healthcenter->init_help(); } } if (file_exists('../modules/icd10/class.icd10.php')) { include '../modules/icd10/class.icd10.php'; $icd10 = new icd10; if (!$module->activated('icd10') && $initmod) { $icd10->init_sql(); $icd10->init_menu(); $icd10->init_deps(); $icd10->init_lang(); $icd10->init_help(); } } if (file_exists('../modules/imci/class.imci.php')) { include '../modules/imci/class.imci.php'; $imci = new imci; if (!$module->activated('imci') && $initmod) { $imci->init_sql(); $imci->init_menu(); $imci->init_deps();
function _details_icd10() { 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]; } icd10::display_consult_icd10($menu_id, $post_vars, $get_vars); icd10::display_consult_icd10_hx($menu_id, $post_vars, $get_vars); }