public function index($checker = NULL, $pop_up_msg = NULL)
{
$facility = $this->session->userdata('news');
//$facility=$this->uri->segment(4);
switch ($checker) {
case 'Internal':
$data['content_view'] = "facility/facility_data/facility_issues/IssueInternal_v";
$data['title'] = "Stock";
$data['banner_text'] = "Issue";
$data['link'] = "IssuesnReceipts";
$data['quick_link'] = "IssueInternal_v";
break;
case 'External':
$data['content_view'] = "facility/facility_data/facility_issues/IssueExternal_v";
//$data['content_view'] = "IssueExternal_v";
$county = districts::get_county_id($this->session->userdata('district1'));
$data['district'] = districts::getAll();
$data['banner_text'] = "Redistribute Commodities";
$data['title'] = "Redistribute Commodities";
$data['quick_link'] = "IssueExternal_v";
break;
case 'Donation':
$data['title'] = "Update Stock Level: External source";
$data['content_view'] = "facility/facility_data/facility_issues/update_stock_donation_v";
$data['banner_text'] = "Update Stock Level: External source";
$data['drug_categories'] = Drug::getAll();
$data['quick_link'] = "update_stock_level";
break;
default:
$data['content_view'] = "facility/facility_data/facility_issues/issuesnRecpt";
$data['banner_text'] = "Issues Home";
$data['title'] = "Stock";
$data['quick_link'] = "issuenRecpt";
$data['popout'] = $pop_up_msg;
}
$data['service'] = Service::getall($facility);
$data['drugs'] = Facility_Stock::getAllStock($facility);
$this->load->view("template", $data);
}
public function district_profile($district)
{
$data = array();
$lastday = date('Y-m-d', strtotime("last day of previous month"));
$current_month = $this->session->userdata('Month');
if ($current_month == '') {
$current_month = date('mY', time());
}
$previous_month = date('m', strtotime("last day of previous month"));
$previous_month_1 = date('mY', strtotime('-2 month'));
$previous_month_2 = date('mY', strtotime('-3 month'));
$year_current = substr($current_month, -4);
$year_previous = date('Y', strtotime("last day of previous month"));
$year_previous_1 = substr($previous_month_1, -4);
$year_previous_2 = substr($previous_month_2, -4);
$current_month = substr_replace($current_month, "", -4);
$previous_month_1 = substr_replace($previous_month_1, "", -4);
$previous_month_2 = substr_replace($previous_month_2, "", -4);
$monthyear_current = $year_current . '-' . $current_month . '-1';
$monthyear_previous = $year_previous . '-' . $previous_month . '-1';
$monthyear_previous_1 = $year_previous_1 . '-' . $previous_month_1 . '-1';
$monthyear_previous_2 = $year_previous_2 . '-' . $previous_month_2 . '-1';
$englishdate = date('F, Y', strtotime($monthyear_current));
$m_c = date("F", strtotime($monthyear_current));
//first month
$m0 = date("F", strtotime($monthyear_previous));
$m1 = date("F", strtotime($monthyear_previous_1));
$m2 = date("F", strtotime($monthyear_previous_2));
$month_text = array($m2, $m1, $m0);
$district_summary = $this->rtk_summary_district($district, $year_current, $current_month);
$district_summary_prev = $this->rtk_summary_district($district, $year_previous, $previous_month);
$district_summary1 = $this->rtk_summary_district($district, $year_previous_1, $previous_month_1);
$district_summary2 = $this->rtk_summary_district($district, $year_previous_2, $previous_month_2);
$county_id = districts::get_county_id($district);
$county_name = counties::get_county_name($county_id['county']);
$cid = $this->db->select('districts.county')->get_where('districts', array('id' => $district))->result_array();
foreach ($cid as $key => $value) {
$myres = $cid[0]['county'];
}
$mycounties = $this->db->select('districts.district,districts.id')->get_where('districts', array('county' => $myres))->result_array();
$data['district_balances_current'] = $this->district_totals($year_current, $previous_month, $district);
$data['district_balances_previous'] = $this->district_totals($year_previous, $previous_month, $district);
$data['district_balances_previous_1'] = $this->district_totals($year_previous_1, $previous_month_1, $district);
$data['district_balances_previous_2'] = $this->district_totals($year_previous_2, $previous_month_2, $district);
$data['district_summary'] = $district_summary;
$data['districts'] = $mycounties;
$data['facilities'] = $this->_facilities_in_district($district);
$data['district_name'] = $district_summary['district'];
$data['county_id'] = $county_name['id'];
$data['county_name'] = $county_name['county'];
$data['title'] = 'RTK County Admin - Sub-County Profile: ' . $district_summary['district'];
$data['banner_text'] = 'Sub-County Profile: ' . $district_summary['district'];
$data['content_view'] = "rtk/rtk/district_profile_view";
$data['months'] = $month_text;
$this->load->view("rtk/template", $data);
}
public function partner_county_profile($district)
{
$data = array();
$partner_id = $this->session->userdata('partner_id');
$sql_facilities = "select * from facilities, districts,counties \n where facilities.district = districts.id and facilities.partner = '{$partner_id}' \n and districts.county = counties.id and counties.id = '{$district}' ";
$facilities = $this->db->query($sql_facilities)->result_array();
$lastday = date('Y-m-d', strtotime("last day of previous month"));
$current_month = $this->session->userdata('Month');
if ($current_month == '') {
$current_month = date('mY', time());
}
$previous_month = date('m', strtotime("last day of previous month"));
$previous_month_1 = date('mY', strtotime('-2 month'));
$previous_month_2 = date('mY', strtotime('-3 month'));
$year_current = substr($current_month, -4);
$year_previous = date('Y', strtotime("last day of previous month"));
$year_previous_1 = substr($previous_month_1, -4);
$year_previous_2 = substr($previous_month_2, -4);
$current_month = substr_replace($current_month, "", -4);
$previous_month_1 = substr_replace($previous_month_1, "", -4);
$previous_month_2 = substr_replace($previous_month_2, "", -4);
$monthyear_current = $year_current . '-' . $current_month . '-1';
$monthyear_previous = $year_previous . '-' . $previous_month . '-1';
$monthyear_previous_1 = $year_previous_1 . '-' . $previous_month_1 . '-1';
$monthyear_previous_2 = $year_previous_2 . '-' . $previous_month_2 . '-1';
$englishdate = date('F, Y', strtotime($monthyear_current));
$m_c = date("F", strtotime($monthyear_current));
$m0 = date("F", strtotime($monthyear_previous));
$m1 = date("F", strtotime($monthyear_previous_1));
$m2 = date("F", strtotime($monthyear_previous_2));
$month_text = array($m2, $m1, $m0);
$district_summary = $this->partner_summary($district, $year_current, $current_month, $partner_id);
$district_summary_prev = $this->partner_summary($district, $year_previous, $previous_month, $partner_id);
$district_summary1 = $this->partner_summary($district, $year_previous_1, $previous_month_1, $partner_id);
$district_summary2 = $this->partner_summary($district, $year_previous_2, $previous_month_2, $partner_id);
$county_id = districts::get_county_id($district);
$county_name = counties::get_county_name($district);
// $cid = $this->db->select('districts.county')->get_where('districts', array('id' =>$district))->result_array();
// foreach ($cid as $key => $value) {
// $myres = $cid[0]['county'];
// }
$sql_counties = "select distinct counties.id,counties.county from facilities, districts,counties \n where facilities.district = districts.id and facilities.partner = '{$partner_id}' and facilities.rtk_enabled='1' \n and districts.county = counties.id";
$mycounties = $this->db->query($sql_counties)->result_array();
$data['district_balances_current'] = $this->partner_county_totals($year_current, $previous_month, $district);
$data['district_balances_previous'] = $this->partner_county_totals($year_previous, $previous_month, $district);
$data['district_balances_previous_1'] = $this->partner_county_totals($year_previous_1, $previous_month_1, $district);
$data['district_balances_previous_2'] = $this->partner_county_totals($year_previous_2, $previous_month_2, $district);
$data['district_summary'] = $district_summary;
$data['counties_list'] = $mycounties;
$data['facilities'] = $facilities;
$data['district_name'] = $district_summary['district'];
$data['county_id'] = $county_name['id'];
$data['county_name'] = $county_name['county'];
$data['title'] = 'RTK Partner County Profile: ' . $district_summary['district'];
$data['banner_text'] = 'Partner County Profile: ' . $district_summary['district'];
$data['content_view'] = "rtk/rtk/partner/partner_profile_v";
$data['months'] = $month_text;
$this->load->view("rtk/template", $data);
}
public function get_county_ordering_rate_chart()
{
$district = $this->session->userdata('district');
$county_id = districts::get_county_id($district);
$county_name = counties::get_county_name($county_id[0]['county']);
$districts_in_this_county = districts::getDistrict($county_name[0]['id']);
$category_data = '<categories>';
$orders_made_data = "";
$total_no_of_facilities = "";
$strXML = "<chart stack100Percent='1' showPercentValues='1' palette='2' bgColor='FFFFFF' formatNumberScale='0' showBorder='0' showLabels='1' showvalues='0' numberPrefix='' showSum='1' decimals='0' useRoundEdges='1' legendBorderAlpha='0'>";
foreach ($districts_in_this_county as $chart_data) {
$category_data .= "<category label='{$chart_data->district}' />";
$district_data = facilities::get_orders_made_in_district($chart_data->id);
$orders_made_data .= "<set value='{$district_data['orders_made_data']}' />";
$bal = $district_data['total_no_of_facilities'] - $district_data['orders_made_data'];
$total_no_of_facilities .= "<set value='{$bal}'/>";
}
$strXML .= $category_data . "</categories><dataset seriesName='Orders Made' color='659EC7' showValues='0'>{$orders_made_data}</dataset><dataset seriesName='Orders not made' color='E8E8E8' showValues='0'>{$total_no_of_facilities}</dataset></chart>";
echo $strXML;
}
