function Display_OPD_Summary($start, $end)
{
global $db;
$WITH_TIMEFRAME = FALSE;
if (func_num_args()) {
$start = func_get_arg(0);
$end = func_get_arg(1);
$WITH_TIMEFRAME = TRUE;
}
$rep_obj = new selianreport();
$tmp_tbl_OPD_summary = $rep_obj->SetReportingLink('care_person', 'pid', 'care_tz_diagnosis', 'PID');
//$tmp_tbl_allpatients = $rep_obj -> SetReportingTable('care_person');
$debug = FALSE;
$debug ? $db->debug = TRUE : ($db->debug = FALSE);
$arr_ret['return']['underage'];
$arr_ret['return']['adult'];
$arr_ret['return']['male'];
$arr_ret['return']['female'];
$arr_ret['return']['total'];
$arr_ret['NewRegistration']['underage'];
$arr_ret['NewRegistration']['adult'];
$arr_ret['NewRegistration']['male'];
$arr_ret['NewRegistration']['female'];
$arr_ret['NewRegistration']['total'];
$arr_ret['Total']['underage'];
$arr_ret['Total']['adult'];
$arr_ret['Total']['male'];
$arr_ret['Total']['female'];
$arr_ret['Total']['total'];
$arr_ret['Total_Pedriatics']['underage'];
$arr_ret['revisit']['underage'];
$arr_ret['revisit']['adult'];
$arr_ret['revisit']['male'];
$arr_ret['revisit']['female'];
$arr_ret['revisit']['total'];
/****************************************************************************************************
* Revisit�s under 5
*/
$sql = "SELECT count(*) AS return_underage FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new' AND UNIX_TIMESTAMP(date_birth) > (UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 year))) ";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['return']['underage'] = $row['return_underage'];
/**
* Total revisits
*/
$sql = "SELECT count(*) AS total FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['return']['total'] = $row['total'];
/**
* Revist�s over 5
*/
$arr_ret['return']['adult'] = $arr_ret['return']['total'] - $arr_ret['return']['underage'];
/**
* Total male revisits
*/
$sql = "SELECT count(*) AS male FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new' and sex='m'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['return']['male'] = $row['male'];
/**
* Total female revisits
*/
$sql = "SELECT count(*) AS female FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new' and sex='f'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['return']['female'] = $row['female'];
/****************************************************************************************************
* New Registration�s under 5
*/
$sql = "SELECT count(*) AS return_underage FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new patient' AND UNIX_TIMESTAMP(date_birth) > (UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 year)))";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['NewRegistration']['underage'] = $row['return_underage'];
/**
* Total New Registration
*/
$sql = "SELECT count(*) AS Total FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new patient' ";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['NewRegistration']['total'] = $row['Total'];
/**
* New Registration�s over 5
*/
$arr_ret['NewRegistration']['adult'] = $arr_ret['NewRegistration']['total'] - $arr_ret['NewRegistration']['underage'];
/**
* Total male New Registration
*/
$sql = "SELECT count(*) AS male FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new patient' and sex='m'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['NewRegistration']['male'] = $row['male'];
/**
* Total female New Registration
*/
$sql = "SELECT count(*) AS female FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='new patient' and sex='f'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['NewRegistration']['female'] = $row['female'];
/****************************************************************************************************
* Total Registration�s under 5
*/
$sql = "SELECT count(*) AS Total_underage FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE UNIX_TIMESTAMP(date_birth) > (UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 year)))";
if ($WITH_TIMEFRAME) {
$sql .= " AND (timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['Total']['underage'] = $row['Total_underage'];
/**
* Total New Registration
*/
$sql = "SELECT count(*) AS Total FROM {$tmp_tbl_OPD_summary} ";
if ($WITH_TIMEFRAME) {
$sql .= " WHERE ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['Total']['total'] = $row['Total'];
/**
* New Registration�s over 5
*/
$arr_ret['Total']['adult'] = $arr_ret['Total']['total'] - $arr_ret['Total']['underage'];
/**
* Total male New Registration
*/
$sql = "SELECT count(*) AS Total_male FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE sex='m'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['Total']['male'] = $row['Total_male'];
/**
* Total female New Registration
*/
$sql = "SELECT count(*) AS Total_female FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE sex='f'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['Total']['female'] = $row['Total_female'];
/**
* **************************************************************************************************
* Total Pedriatics
*/
$sql = "SELECT count(*) AS Total_underage FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE UNIX_TIMESTAMP(date_birth) > (UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 year)))";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['Total_Pedriatics']['underage'] = $row['Total_underage'];
/****************************************************************************************************
* Views for the same reasons:
*/
$sql = "SELECT count(*) AS return_underage FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='revisit' AND UNIX_TIMESTAMP(date_birth) > (UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 5 year)))\r\n\t\t ";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['revisit']['underage'] = empty($row['return_underage']) ? 0 : $row['return_underage'];
//$arr_ret['revisit']['underage'] = $row['return_underage'];
/**
* Total revisits
*/
$sql = "SELECT count(*) AS total FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='revisit'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$sql .= " GROUP BY ICD_10_code";
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['revisit']['total'] = empty($row['total']) ? 0 : $row['total'];
/**
* Revist�s over 5
*/
$arr_ret['revisit']['adult'] = $arr_ret['revisit']['total'] - $arr_ret['revisit']['underage'];
/**
* Total male revisits
*/
$sql = "SELECT count(*) AS male FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='revisit' and sex='m'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$sql .= " GROUP BY ICD_10_code";
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['revisit']['male'] = empty($row['male']) ? 0 : $row['male'];
/**
* Total female revisits
*/
$sql = "SELECT count(*) AS female FROM {$tmp_tbl_OPD_summary}\r\n\t\t\t\t\t WHERE type='revisit' and sex='f'";
if ($WITH_TIMEFRAME) {
$sql .= " AND ( timestamp>=" . $start . " AND timestamp<=" . $end . ")";
}
$sql .= " GROUP BY ICD_10_code";
$rs_ptr = $db->Execute($sql);
$row = $rs_ptr->FetchRow();
$arr_ret['revisit']['female'] = empty($row['female']) ? 0 : $row['female'];
$rep_obj->DisconnectReportingTable($tmp_tbl_OPD_summary);
return $arr_ret;
}
$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();
require_once 'gui/gui_mtuha_icd10.php';
