public function get_county_facility_mapping_ajax_request($option = null)
{
//$district_id = $this -> session -> userdata('district_id');
$county_id = $this->session->userdata('county_id');
//echo $county_id;
$district_data = districts::getDistrict($county_id);
$table_data = "<tbody>";
$table_data_summary = "<tbody>";
$district_names = "<thead><tr><th>Monthly Activities</th>";
//Total number of facilities using HCMP in the district
$district_total = array();
//Total number of facilities in the district
$district_total_facilities = array();
//Total number of facilities targetted in the district
$district_total_facilities_targetted = array();
$district_total_facilities_using_hcmp = array();
$table_district_totals = "";
$all_facilities = 0;
$total_using_hcmp = 0;
$total_facility_list = '';
$total_facilities_in_county = 0;
$total_facilities_targetted = 0;
$percentage_coverage = "";
$percentage_coverage_total = 0;
$percentage_coverage_using = "";
$percentage_coverage_total_using = 0;
$get_dates_facility_went_online = facilities::get_dates_facility_went_online($county_id);
foreach ($get_dates_facility_went_online as $facility_dates) {
$monthly_total = 0;
$date = $facility_dates['date_when_facility_went_online'];
$table_data .= "<tr>\n\t <td>" . $date . "</td>";
foreach ($district_data as $district_detail) {
$district_id = $district_detail->id;
$district_name = $district_detail->district;
$get_facilities_which_went_online_ = facilities::get_facilities_which_went_online_($district_id, $facility_dates['date_when_facility_went_online']);
$total = $get_facilities_which_went_online_[0]['total'];
$total_facilities = $get_facilities_which_went_online_[0]['total_facilities'];
$total_facilities_targetted = $get_facilities_which_went_online_[0]['total_facilities_targetted'];
$total_facilitites_using_hcmp = $get_facilities_which_went_online_[0]['total_using_hcmp'];
$monthly_total = $monthly_total + $total;
$all_facilities = $all_facilities + $total;
array_key_exists($district_name, $district_total) ? $district_total[$district_name] = $district_total[$district_name] + $total : ($district_total = array_merge($district_total, array($district_name => $total)));
array_key_exists($district_name, $district_total_facilities) ? $district_total_facilities[$district_name] = $total_facilities : ($district_total_facilities = array_merge($district_total_facilities, array($district_name => $total_facilities)));
array_key_exists($district_name, $district_total_facilities_targetted) ? $district_total_facilities_targetted[$district_name] = $total_facilities_targetted : ($district_total_facilities_targetted = array_merge($district_total_facilities_targetted, array($district_name => $total_facilities_targetted)));
array_key_exists($district_name, $district_total_facilities_using_hcmp) ? $district_total_facilities_using_hcmp[$district_name] = $total_facilitites_using_hcmp : ($district_total_facilities_using_hcmp = array_merge($district_total_facilities_using_hcmp, array($district_name => $total_facilitites_using_hcmp)));
$table_data .= $total > 0 ? "<td><a href='#' id='{$district_id}' class='ajax_call2 link' date='{$date}'> {$total}</a></td>" : "<td>{$total}</td>";
}
$table_data .= "<td>{$monthly_total}</td></tr>";
}
$table_data .= "<tr>";
$table_data_summary .= "<tr>";
$checker = 1;
foreach ($district_total as $key => $value) {
$coverage = 0;
$using = 0;
@($coverage = round($value / $district_total_facilities[$key] * 100, 1));
@($using_percentage = round($district_total_facilities_targetted[$key] / $value * 100, 1));
$percentage_coverage_total = $percentage_coverage_total + $coverage;
$percentage_coverage_total_using = $percentage_coverage_total_using + $using_percentage;
$district_names .= "<th>{$key}</th>";
$total_facility_list .= $checker == 1 ? "<tr><td><b>TOTAL: Facilities in District</b></td><td>{$district_total_facilities[$key]}</td>" : "<td>{$district_total_facilities[$key]}</td>";
$table_data .= $checker == 1 ? "<td><b>TOTAL: Facilities using HCMP</b></td><td>{$value}</td>" : "<td>{$value}</td>";
$table_summary .= $checker == 1 ? "<td><b>TOTAL: Facilities using HCMP</b></td><td>{$value}</td>" : "<td>{$value}</td>";
$total_targetted_facility_list .= $checker == 1 ? "<tr><td><b>TOTAL: Targetted Facilities in District</b></td><td>{$district_total_facilities_targetted[$key]}</td>" : "<td>{$district_total_facilities_targetted[$key]}</td>";
$total_facilities_in_county = $total_facilities_in_county + $district_total_facilities[$key];
$targetted_total = $targetted_total + $district_total_facilities_targetted[$key];
$total_using_hcmp = $total_using_hcmp + $district_total_facilities_using_hcmp[$key];
@($targetted_vs_using_hcmp = round($total_facilitites_using_hcmp / $total_facilities_targetted * 100, 1));
@($final_coverage_total = round($all_facilities / $total_facilities_in_county * 100, 1));
$percentage_coverage_using .= $checker == 1 ? "<tr><td><b>TOTAL: Targetted vs Using HCMP%</b></td>\n\t\t\t<td>{$targetted_vs_using_hcmp} %</td>" : "<td>{$using_percentage} %</td>";
$percentage_coverage .= $checker == 1 ? "<tr><td><b>% Coverage</b></td>\n\t\t\t<td>{$coverage} %</td>" : "<td>{$coverage} %</td>";
$checker++;
}
$table_data .= "<td><a href='#' id='total' class='ajax_call1 link' option='total' date='total'>{$all_facilities}</a></td></tr></tbody>";
$table_data_summary .= "<td><a href='#' id='total' class='ajax_call2 link' date='total'>{$all_facilities}</a></td></tr></tbody>";
$table_datas_summary .= "<td><a href='#' id='total' class='ajax_call1 link' date='total'>{$all_facilities}</a></td>";
$district_names .= "<th>TOTAL</th></tr></thead>";
$final_coverage_total = 0;
$targetted_vs_using_hcmp = 0;
@($final_coverage_total = round($all_facilities / $total_facilities_in_county * 100, 1));
@($targetted_vs_using_hcmp = round($targetted_total / $all_facilities * 100, 1));
$data_ = "\n\t\t<div class='tabbable tabs-left'>\n\t\t<div class='tab-content'>\n <ul class='nav nav-tabs'>\n <li class='active'><a href='#A' data-toggle='tab'>Monthly Break Down</a></li>\n <li class=><a href='#B' data-toggle='tab'>Roll out Summary</a></li>\n </ul>\n <div id='A' class='tab-pane fade active in'>\n\t\t\t<table class='row-fluid table table-hover table-bordered table-update' width='80%' id='test1'>" . $district_names . $table_data . $total_facility_list . "<td>{$total_facilities_in_county}</td></tr>" . $total_targetted_facility_list . "<td>{$targetted_total}</td>" . $percentage_coverage . "<td>{$final_coverage_total} %</td></tr>" . $percentage_coverage_using . "<td>{$targetted_vs_using_hcmp} %</td></tr>\n\t\t\t</table>\n\t\t</div>\n\t\t\n\t\t<div id='B' class='tab-pane fade' >\n\t\t<table class='row-fluid table table-hover table-bordered table-update' width='80%' id='test2'>" . $district_names . $table_summary . $table_datas_summary . $total_facility_list . "<td>{$total_facilities_in_county}</td></tr>" . $total_targetted_facility_list . "<td>{$targetted_total}</td>" . $percentage_coverage . "<td>{$final_coverage_total} %</td></tr>" . $percentage_coverage_using . "<td>{$targetted_vs_using_hcmp} %</td></tr></table>\n\t\t </div>\n\t\t </div>";
if (isset($option)) {
return $data_;
} else {
echo $data_;
}
}
public function get_sub_county_facility_mapping_data($year = null, $month = NULL)
{
/*$year = (isset($year) && ($year > 0)) ? $year : date("Y");
$month = (isset($month) && ($month > 0)) ? $month : date("m");
$identifier = $this -> session -> userdata('user_indicator');
$county_id = $this -> session -> userdata('county_id');
//Get facility code
$facility_code = $this -> session -> userdata('facility_id');
$facility_code_ = (isset($facility_code) && ($facility_code > 0)) ? facilities::get_facility_name_($facility_code) -> toArray() : null;
$facility_name = $facility_code_[0]['facility_name'];
$district_id = $this -> session -> userdata('district_id');
$district = $this -> session -> userdata('district_id');
//Get the name of the county
$county_name = Counties::get_county_name($county_id);
$county_name = $county_name;
//get the name of the district
$district_name_ = (isset($district_id) && ($district_id > 0)) ? Districts::get_district_name_($district_id) : null;
$district_name = $district_name_['district'];
$first_day_of_the_month = date("Y-m-1", strtotime(date($year . "-" . $month)));
$last_day_of_the_month = date("Y-m-t", strtotime(date($year . "-" . $month)));
$date_1 = new DateTime($first_day_of_the_month);
$date_2 = new DateTime($last_day_of_the_month);
$facility_data = Facilities::get_Facilities_using_HCMP($county_id, $district);
$series_data = array();
$category_data = array();
$series_data_monthly = array();
$category_data_monthly = array();
$seconds_diff = strtotime($last_day_of_the_month) - strtotime($first_day_of_the_month);
$date_diff = floor($seconds_diff / 3600 / 24);
switch ($identifier) :
case 'county' :
$graph_category_data = $facility_data;
$graph_title = $county_name['county'] . " County ";
break;
case 'facility_admin' :
case 'facility' :
$graph_category_data = $facility_data;
$graph_title = $facility_name;
break;
case 'district' :
$graph_category_data = $facility_data;
$graph_title = $district_name . " SubCounty ";
break;
endswitch;
for ($i = 0; $i <= $date_diff; $i++) :
$day = 1 + $i;
$new_date = "$year-$month-" . $day;
$new_date = date('Y-m-d', strtotime($new_date));
if (date('N', strtotime($new_date)) < 6) {
$date_ = date('D d', strtotime($new_date));
$category_data = array_merge($category_data, array($date_));
$temp_1 = array();
foreach ($graph_category_data as $facility_) :
$facility_id = $facility_ -> facility_code;
$facility_name = $facility_ -> facility_name;
$subcounty_data = Log::get_subcounty_login_count($county_id, $district_id, $facility_id, $new_date);
(array_key_exists($facility_name, $series_data)) ? $series_data[$facility_name] = array_merge($series_data[$facility_name], array((int)$subcounty_data[0]['total'])) : $series_data = array_merge($series_data, array($facility_name => array((int)$subcounty_data[0]['total'])));
endforeach;
} else {
// do nothing
}
endfor;
//for setting the month name in the graph when filtering
$m = date('F', strtotime('2000-' . $month . '-01'));
$graph_data_daily = array();
$graph_data_daily = array_merge($graph_data_daily, array("graph_id" => 'container'));
$graph_data_daily = array_merge($graph_data_daily, array("graph_title" => 'Daily Facility Access log for ' . $m . " for " . $graph_title));
$graph_data_daily = array_merge($graph_data_daily, array("graph_type" => 'line'));
$graph_data_daily = array_merge($graph_data_daily, array("graph_yaxis_title" => 'log In'));
$graph_data_daily = array_merge($graph_data_daily, array("graph_categories" => array()));
$graph_data_daily = array_merge($graph_data_daily, array("series_data" => $series_data));
$graph_data_daily['graph_categories'] = $category_data;
$graph_daily = $this -> hcmp_functions -> create_high_chart_graph($graph_data_daily);
for ($i = 0; $i < 12; $i++) :
$day = 1 + $i;
//changed it to be a month
$new_date = "$year-$day";
$new_date = date('Y-m', strtotime($new_date));
$date_ = date('M', strtotime($new_date));
$category_data_monthly = array_merge($category_data_monthly, array($date_));
foreach ($graph_category_data as $facility_) :
$facility_id = $facility_ -> facility_code;
$facility_name = $facility_ -> facility_name;
$subcounty_data = Log::get_subcounty_login_monthly_count($county_id, $district_id, $facility_id, $new_date);
(array_key_exists($facility_name, $series_data_monthly)) ? $series_data_monthly[$facility_name] = array_merge($series_data_monthly[$facility_name], array((int)$subcounty_data[0]['total'])) : $series_data_monthly = array_merge($series_data_monthly, array($facility_name => array((int)$subcounty_data[0]['total'])));
endforeach;
endfor;
$graph_data = array();
$graph_data = array_merge($graph_data, array("graph_id" => 'container_monthly'));
$graph_data = array_merge($graph_data, array("graph_title" => 'Monthly Facility Access for ' . $year));
$graph_data = array_merge($graph_data, array("graph_type" => 'line'));
$graph_data = array_merge($graph_data, array("graph_yaxis_title" => 'log In'));
$graph_data = array_merge($graph_data, array("graph_categories" => array()));
$graph_data = array_merge($graph_data, array("series_data" => $series_data_monthly));
$graph_data['graph_categories'] = $category_data_monthly;
$graph_monthly = $this -> hcmp_functions -> create_high_chart_graph($graph_data);
$graph_log_data = array();
$graph_log_data = array_merge($graph_log_data, array("graph_id" => 'log_data_graph'));
$graph_log_data = array_merge($graph_log_data, array("graph_title" => 'User Activity for ' . $m . ' for ' . $graph_title));
$graph_log_data = array_merge($graph_log_data, array("graph_type" => 'column'));
$graph_log_data = array_merge($graph_log_data, array("graph_yaxis_title" => 'Frequency'));
$graph_log_data = array_merge($graph_log_data, array("graph_categories" => array('Decommissions', 'Redistributions', 'Stock Updates', 'Orders', 'Issues', 'Log Ins')));
$graph_log_data = array_merge($graph_log_data, array("series_data" => array('Total %' => array())));
$log_data = Log::get_log_data($facility_code, $district_id, $county_id, $year, $month);
$log_data_login_only = Log::get_login_only($facility_code, $district_id, $county_id, $year, $month);
//echo "<pre>";print_r($facility_data);echo "</pre>";exit;
foreach ($log_data as $log_data_) {
$sum = $log_data_['user_log'] + $log_data_login_only[0]['total'];
$issues = ($log_data_['total_issues'] / $sum) * 100;
$orders = ($log_data_['total_orders'] / $sum) * 100;
$decommissions = ($log_data_['total_decommisions'] / $sum) * 100;
$redistributions = ($log_data_['total_redistributions'] / $sum) * 100;
$stock = ($log_data_['total_stock_added'] / $sum) * 100;
;
$user = ($log_data_login_only[0]['total'] / $sum) * 100;
;
$temp = array((int)$decommissions, (int)$redistributions, (int)$stock, (int)$orders, (int)$issues, (int)$user);
$graph_log_data['series_data']['Total %'] = array_merge($graph_log_data['series_data']['Total %'], $temp);
}
$graph_log = $this -> hcmp_functions -> create_high_chart_graph($graph_log_data);
$data['graph_data_monthly'] = $graph_monthly;
$data['graph_data_daily'] = $graph_daily;
$data['graph_log'] = $graph_log;
*/
$county_id = $this->session->userdata('county_id');
$data['get_facility_data'] = facilities::get_facilities_online_per_district($county_id);
$get_dates_facility_went_online = facilities::get_dates_facility_went_online($county_id);
$data['data'] = $this->get_county_facility_mapping_ajax_request("on_load");
if ($this->input->is_ajax_request()) {
return $this->load->view('subcounty/ajax/facility_roll_out_at_a_glance_v', $data);
} else {
$data['title'] = "User Logs";
$data['banner_text'] = "System Use Statistics";
$data['report_view'] = "subcounty/ajax/facility_roll_out_at_a_glance_v";
$data['sidebar'] = !$this->session->userdata('facility_id') ? "shared_files/report_templates/side_bar_sub_county_v" : "shared_files/report_templates/side_bar_v";
$data['content_view'] = "facility/facility_reports/reports_v";
$data['active_panel'] = !$this->session->userdata('facility_id') ? "system_usage" : "system_usage";
$view = 'shared_files/template/template';
$this->load->view($view, $data);
}
}
public function get_county_facility_mapping_ajax_request($option = null)
{
$county_id = $this->session->userdata('county_id');
$district_data = districts::getDistrict($county_id);
$table_data = "<tbody>";
$table_data_summary = "<tbody>";
$district_names = "<thead><tr><th>Monthly Activities</th>";
$district_total = array();
$district_total_facilities = array();
$table_district_totals = "";
$all_facilities = 0;
$total_facility_list = '';
$total_facilities_in_county = 0;
$percentage_coverage = "";
$percentage_coverage_total = 0;
$get_dates_facility_went_online = facilities::get_dates_facility_went_online($county_id);
foreach ($get_dates_facility_went_online as $facility_dates) {
$monthly_total = 0;
$date = $facility_dates['date_when_facility_went_online'];
$table_data .= "<tr>\n\t <td>" . $date . "</td>";
foreach ($district_data as $district_detail) {
$district_id = $district_detail->id;
$district_name = $district_detail->district;
$get_facilities_which_went_online_ = facilities::get_facilities_which_went_online_($district_id, $facility_dates['date_when_facility_went_online']);
$total = $get_facilities_which_went_online_[0]['total'];
$total_facilities = $get_facilities_which_went_online_[0]['total_facilities'];
$monthly_total = $monthly_total + $total;
$all_facilities = $all_facilities + $total;
array_key_exists($district_name, $district_total) ? $district_total[$district_name] = $district_total[$district_name] + $total : ($district_total = array_merge($district_total, array($district_name => $total)));
array_key_exists($district_name, $district_total_facilities) ? $district_total_facilities[$district_name] = $total_facilities : ($district_total_facilities = array_merge($district_total_facilities, array($district_name => $total_facilities)));
$table_data .= $total > 0 ? "<td><a href='#' id='{$district_id}' class='ajax_call_1 link' option='monthly' date='{$date}'> {$total}</a></td>" : "<td>{$total}</td>";
}
$table_data .= "<td>{$monthly_total}</td></tr>";
}
$table_data .= "<tr>";
$table_data_summary .= "<tr>";
$checker = 1;
foreach ($district_total as $key => $value) {
$coverage = 0;
@($coverage = round($value / $district_total_facilities[$key] * 100, 1));
$percentage_coverage_total = $percentage_coverage_total + $coverage;
$district_names .= "<th>{$key}</th>";
$table_data .= $checker == 1 ? "<td><b>TOTAL: Facilities using HCMP</b></td><td>{$value}</td>" : "<td>{$value}</td>";
$table_data_summary .= $checker == 1 ? "<td><b>TOTAL: Facilities using HCMP</b></td><td>{$value}</td>" : "<td>{$value}</td>";
$total_facility_list .= $checker == 1 ? "<tr><td><b>TOTAL: Facilities in District</b></td><td>{$district_total_facilities[$key]}</td>" : "<td>{$district_total_facilities[$key]}</td>";
$total_facilities_in_county = $total_facilities_in_county + $district_total_facilities[$key];
$percentage_coverage .= $checker == 1 ? "<tr><td><b>% Coverage</b></td><td>{$coverage} %</td>" : "<td>{$coverage} %</td>";
$checker++;
}
$table_data .= "<td><a href='#' id='total' class='ajax_call_1 link' option='total' date='total'>{$all_facilities}</a></td></tr></tbody>";
$table_data_summary .= "<td><a href='#' id='total' class='ajax_call_1 link' option='total' date='total'>{$all_facilities}</a></td></tr></tbody>";
$district_names .= "<th>TOTAL</th></tr></thead>";
$final_coverage_total = 0;
@($final_coverage_total = round($all_facilities / $total_facilities_in_county * 100, 1));
$data_ = "\n\t\t<div class='tabbable tabs-left'>\n\t\t<div class='tab-content'>\n <ul class='nav nav-tabs'>\n <li class=''><a href='#A' data-toggle='tab'><h3>Monthly Break Down</h3></a></li>\n <li class='active'><a href='#B' data-toggle='tab'><h3>Roll out Summary</h3></a></li>\n </ul>\n <div class='tab-pane' id='A'>\n\t\t<table class='data-table' width='100%'>" . $district_names . $table_data . $total_facility_list . "<td>{$total_facilities_in_county}</td></tr>" . $percentage_coverage . "<td>{$final_coverage_total} %</td></tr></table>\n\t\t </div>\n\t\t <div class='tab-pane active' id='B'>\n\t\t <table class='data-table' width='100%'>" . $district_names . $table_data_summary . $total_facility_list . "<td>{$total_facilities_in_county}</td></tr>" . $percentage_coverage . "<td>{$final_coverage_total} %</td></tr></table>\n\t\t </div></div>";
if (isset($option)) {
return $data_;
} else {
echo $data_;
}
}