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; }