require_once 'include/inc_timeframe.php';
$month = array_search(1, $ARR_SELECT_MONTH);
$year = array_search(1, $ARR_SELECT_YEAR);
if ($printout) {
$start = $_GET['start'];
$end = $_GET['end'];
$start_timeframe = $start;
$end_timeframe = $end;
$startdate = date("y.m.d ", $start_timeframe);
$enddate = date("y.m.d", $end_timeframe);
} else {
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year);
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
// Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_encounter");
$tmp_ward = $rep_obj->SetReportingTable("care_ward");
$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table, "pid", "encounter_date", "care_person", "pid", "date_reg");
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$sql = "SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE FROM {$tmp_table} WHERE encounter_date >= '{$startdate}' AND encounter_date <= '{$enddate}' GROUP BY date_format(encounter_date,'%y %m %d')";
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->GetArray();
require_once 'gui/gui_IPD_admissions_discharge.php';
$startdate = date("y.m.d ", $start_timeframe);
$enddate = date("y.m.d", $end_timeframe);
} else {
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year);
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
// Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_icd10_en");
$tmp_table1 = $rep_obj->SetReportingTable("care_tz_mtuha_cat_key");
$tmp_table2 = $rep_obj->SetReportingTable("care_tz_mtuha_cat");
$tmp_table3 = $rep_obj->SetReportingTable("care_tz_diagnosis");
//$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table,"pid","encounter_date","care_person","pid","date_reg");
$tmp_tbl_OPD_diagnostic = $rep_obj->SetReportingLink('care_person', 'pid', 'care_tz_diagnosis', 'PID');
// get the Diagnostic-Codes, Diagnostic-full-name and total out of this table:
//$sql = "SELECT ICD_10_code, ICD_10_description
// FROM $tmp_table where ICD_10_code in('A88.8','A00.9','A03.9','A75.0','B05','G00.9','A20.9','Z20.3','A82.9','A01.0','A95.9')
// ";
//$sql = "SELECT $tmp_table1.cat_id AS category, $tmp_table2.description AS description FROM $tmp_table1, $tmp_table2,$tmp_tbl_OPD_diagnostic WHERE $tmp_tbl_OPD_diagnostic.icd_10_code = $tmp_table1.icd10_key AND $tmp_table.cat_id = $tmp_table1.cat_id GROUP BY $tmp_table2.cat_id";
$sql = "SELECT care_tz_mtuha_cat.cat_id AS category, care_tz_mtuha_cat.description AS description FROM care_tz_diagnosis, care_tz_mtuha_cat_key, care_tz_mtuha_cat WHERE care_tz_diagnosis.icd_10_code = care_tz_mtuha_cat_key.icd10_key AND care_tz_mtuha_cat.cat_id = care_tz_mtuha_cat_key.cat_id AND timestamp>='{$start}' and timestamp<='{$end}' GROUP BY care_tz_mtuha_cat_key.cat_id";
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->GetArray();
$month = array_search(1, $ARR_SELECT_MONTH);
$year = array_search(1, $ARR_SELECT_YEAR);
if ($printout) {
$start = $_GET['start'];
$end = $_GET['end'];
$start_timeframe = $start;
$end_timeframe = $end;
$startdate = date("y.m.d ", $start_timeframe);
$enddate = date("y.m.d", $end_timeframe);
} else {
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year);
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = false;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
// Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_tz_billing_archive_elem");
//$tmp_table3 = $rep_obj->SetReportingTable("care_department");
//$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table,"pid","encounter_date","care_person","pid","date_reg");
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$sql = "SELECT distinct(FROM_UNIXTIME( date_change, '%d.%m.%y' )) as REGISTRATION_DATE FROM care_tz_billing_archive_elem WHERE FROM_UNIXTIME( date_change, '%y.%m.%d' ) >= '{$startdate}' AND FROM_UNIXTIME( date_change, '%y.%m.%d' )< '{$enddate}' ";
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->fetchRow();
//echo print_r($res_array);
require_once 'gui/gui_cash_billing_summary.php';
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
$start_timeframe = $start;
$end_timeframe = $end;
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year); // Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
//$startdate = date("y.m.d ", $start_timeframe);
//$enddate = date("y.m.d", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_tz_billing_archive_elem");
$tmp_table1 = $rep_obj->SetReportingTable("care_tz_drugsandservices");
//$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table,"pid","encounter_date","care_person","pid","date_reg");
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$sql = "SELECT from_unixtime( date_change, '%d.%m.%y' ) as TEST_DATE FROM {$tmp_table} where date_change>='{$start_timeframe}' and date_change <='{$end_timeframe}' GROUP BY from_unixtime( date_change, '%y.%m.%d' ) ";
//$sql="SELECT DISTINCT(item_description) AS SERVICE FROM $tmp_table1 WHERE purchasing_class LIKE '%xray' " ;
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->GetArray();
$sql_d = "DROP TABLE IF EXISTS `tmp_radio`";
$db_ptr = $db->Execute($sql_d);
$sql1 = "CREATE TEMPORARY TABLE tmp_radio SELECT DISTINCT(item_description) AS SERVICE FROM {$tmp_table1} WHERE purchasing_class LIKE '%xray' ORDER BY item_description ASC ";
$db_ptr1 = $db->Execute($sql1);
$sql2 = "INSERT INTO tmp_radio (SERVICE) VALUES ('TOTAL')";
$db_ptr2 = $db->Execute($sql2);
$sql3 = "SELECT SERVICE FROM tmp_radio ";
$month = array_search(1, $ARR_SELECT_MONTH);
$year = array_search(1, $ARR_SELECT_YEAR);
if ($printout) {
$start = $_GET['start'];
$end = $_GET['end'];
$start_timeframe = $start;
$end_timeframe = $end;
$startdate = date("y.m.d ", $start_timeframe);
$enddate = date("y.m.d", $end_timeframe);
} else {
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year);
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
// Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_encounter");
$tmp_ward = $rep_obj->SetReportingTable("care_ward");
$tmp_disch = $rep_obj->SetReportingTable("care_type_discharge");
$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table, "pid", "encounter_date", "care_person", "pid", "date_reg");
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$sql = "SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , date_format( discharge_date, '%d.%m.%y' ) as DISCHARGE_DATE FROM {$tmp_table} WHERE UNIX_TIMESTAMP(discharge_date) >= '{$start}' AND UNIX_TIMESTAMP(discharge_date) <= '{$end}' GROUP BY date_format(encounter_date,'%y %m %d')";
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->GetArray();
require_once 'gui/gui_IPD_discharge_types.php';
$end = $_GET['end'];
$start_timeframe = $start;
$end_timeframe = $end;
$startdate = date("y.m.d ", $start_timeframe);
$enddate = date("y.m.d", $end_timeframe);
} else {
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(0, 0, 0, $month + 1, 1, $year);
//$start_timeframe = mktime (0,0,0,$month, 1, $year);
//$end_timeframe = mktime (0,0,0,$month+1, 0, $year);
$startdate = date("y.m.d ", $start);
$enddate = date("y.m.d", $end);
}
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
// Last day of requested month
//echo $startdate = gmdate("Y-m-d H:i:s", $start_timeframe);
//echo $enddate = gmdate("Y-m-d H:i:s", $end_timeframe);
$tmp_table = $rep_obj->SetReportingTable("care_icd10_en");
//$tmp_table2 = $rep_obj->SetReportingLink_OPDAdmission($tmp_table,"pid","encounter_date","care_person","pid","date_reg");
$tmp_tbl_OPD_diagnostic = $rep_obj->SetReportingLink('care_person', 'pid', 'care_tz_diagnosis', 'PID');
// get the Diagnostic-Codes, Diagnostic-full-name and total out of this table:
//$sql = "SELECT ICD_10_code, ICD_10_description
// FROM $tmp_table where ICD_10_code in('A88.8','A00.9','A03.9','A75.0','B05','G00.9','A20.9','Z20.3','A82.9','A01.0','A95.9')
// ";
$sql = "SELECT description,diagnosis_code FROM care_icd10_en where diagnosis_code in('A88.8','A00.9','A03.9','A75.0','B05','G00.9','A20.9','Z20.3','A82.9','A01.0','A95.9')";
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , count( distinct(pid) ) as NEW , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE,count( encounter_nr ) - count( DISTINCT (pid) ) as RET FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
//$sql="SELECT count( encounter_nr ) AS AMOUNT_ENCOUTERS , date_format( encounter_date, '%d.%m.%y' ) as REGISTRATION_DATE FROM $tmp_table WHERE encounter_date >= '$startdate' AND encounter_date <= '$enddate' GROUP BY date_format(encounter_date,'%y %m %d')";
$db_ptr = $db->Execute($sql);
$res_array = $db_ptr->GetArray();
require_once 'gui/gui_OPD_infections.php';
