public function get_facility_stock_details($facility_code) { $facility_name = Facilities::get_facility_name($facility_code); $msg = "Stock levels for :" . $facility_name['facility_name'] . " as of " . date("d M, Y"); $data['msg'] = $msg; $data['facility_order'] = Facility_Transaction_Table::get_all($facility_code); $data['content_view'] = "district/district_report/facility_stock_level_v"; $data['quick_link'] = "actions"; $data['banner_text'] = "Stock Level"; $data['title'] = "Stock Level "; $this->load->view("template", $data); }
public function facility_impact_report() { $facility_code = $this->session->userdata('facility_id'); $current_user = $this->session->userdata('user_id'); $report = Facility_Impact_Evaluation::get_all($facility_code, $current_user); isset($report) ? $data['filled_report'] = $report : ($data['filled_report'] = NULL); $data['facilities'] = Facilities::get_facility_name($facility_code); $data['title'] = "Facility Impact Report"; $data['content_view'] = "facility/facility_reports/facility_impact_evaluation"; $data['banner_text'] = "Facility Evaluation Form"; $this->load->view("shared_files/template/template", $data); }
public function generate_malaria_report_pdf($report_name, $title, $html_data) { $current_year = date('Y'); $current_month = date('F'); $facility_code = $this->session->userdata('news'); $facility_name_array = Facilities::get_facility_name($facility_code)->toArray(); $facility_name = $facility_name_array['facility_name']; /********************************************setting the report title*********************/ $html_title = "<div ALIGN=CENTER><img src='" . base_url() . "assets/img/coat_of_arms.png' height='70' width='70'style='vertical-align: top;' > </img></div>\n <div style='text-align:center; font-family: arial,helvetica,clean,sans-serif; font-size: 14px; display: block; font-weight: bold; '>\n Ministry of Public Health and Sanitation/Ministry of Medical Services</div>\n <div style='text-align:center; font-family: arial,helvetica,clean,sans-serif;display: block; font-weight: bold;display: block; font-size: 13px;'>Health Commodities Management Platform</div>\n <div style='text-align:center; font-family: arial,helvetica,clean,sans-serif; font-size: 12px; display: block; font-weight: bold;'>" . $current_month . " " . $current_year . "</h2>\n <hr /> "; $css_path = base_url() . 'assets/css/style.css'; /**********************************initializing the report **********************/ $this->load->library('mpdf'); $this->mpdf = new mPDF('', 'A4-L', 0, '', 15, 15, 16, 16, 9, 9, ''); //$stylesheet = file_get_contents("$css_path"); //$this->mpdf->WriteHTML($stylesheet,1); // The parameter 1 tells that this is css/style only and no body/html/text $this->mpdf->SetTitle($title); $this->mpdf->WriteHTML($html_title); $this->mpdf->simpleTables = true; $this->mpdf->WriteHTML('<br/>'); $this->mpdf->WriteHTML($html_data); $reportname = $report_name . ".pdf"; $this->mpdf->Output($reportname, 'D'); }
public function facility_order_($facility_code = null) { // hack to ensure that when you are ordering for a facility that is not using hcmp they have all the items $checker = $this->session->userdata('facility_id') ? null : 1; if (isset($_FILES['file']) && $_FILES['file']['size'] > 0) { $more_data = $this->hcmp_functions->kemsa_excel_order_uploader($_FILES["file"]["tmp_name"]); $data['order_details'] = $data['facility_order'] = $more_data['row_data']; $facility_data = Facilities::get_facility_name($more_data['facility_code'])->toArray(); $facility_code = $facility_data[0]['facility_code']; if (count($facility_data) == 0) { $this->session->set_flashdata('system_error_message', "Kindly upload a file with correct facility MFL code "); redirect("reports/order_listing/subcounty"); } if ($facility_data[0]['using_hcmp'] == 1) { //$this -> session -> set_flashdata('system_error_message', "You cannot order for a" . " facility that is already using HCMP, they need to place their order using their accounts"); //redirect("reports/order_listing/subcounty"); } } else { $data['order_details'] = $data['facility_order'] = Facility_Transaction_Table::get_commodities_for_ordering($facility_code, $checker); $facility_data = Facilities::get_facility_name($facility_code)->toArray(); } $data['content_view'] = "facility/facility_orders/facility_order_from_kemsa_v"; $data['title'] = "Facility New Order"; $data['system_error_message'] = "You are ordering for " . $facility_data[0]['facility_name']; $data['facility_code'] = $facility_code; $data['banner_text'] = "Facility New Order"; $data['drawing_rights'] = $facility_data[0]['drawing_rights']; $data['facility_commodity_list'] = Commodities::get_all_from_supllier(1); $this->load->view('shared_files/template/template', $data); }
public function send_order_approval_sms($facility_code, $status) { //get the facility_name $name = Facilities::get_facility_name($facility_code); $facility_name = $name[0]['facility_name']; $message = $status == 1 ? $facility_name . " order has been rejected. HCMP" : $facility_name . " order has been approved. HCMP"; $data = Users::getUsers($facility_code)->toArray(); $phone = $this->get_facility_phone_numbers($facility_code); $phone .= $this->get_ddp_phone_numbers($data[0]['district']); $spam_sms = '254728778002+254707463571' . $phone; $phone_numbers = explode("+", $spam_sms); foreach ($phone_numbers as $key => $user_no) { file("http://41.57.109.242:13000/cgi-bin/sendsms?username=clinton&password=ch41sms&to={$user_no}&text={$message}"); } }
public function generate_pdf($r_name, $title, $data, $display_type) { $facility_code = $this->session->userdata('news'); $facility_name_array = Facilities::get_facility_name($facility_code)->toArray(); $facility_name = $facility_name_array['facility_name']; if ($display_type == "Download PDF") { /********************************************setting the report title*********************/ $html_title = "<div ALIGN=CENTER><img src='" . base_url() . "Images/coat_of_arms.png' height='70' width='70'style='vertical-align: top;' > </img></div>\n <div style='text-align:center; font-size: 14px;display: block;font-weight: bold;'>{$title}</div>\n <div style='text-align:center; font-family: arial,helvetica,clean,sans-serif;display: block; font-weight: bold; font-size: 14px;'>\n Ministry of Public Health and Sanitation/Ministry of Medical Services</div>\n <div style='text-align:center; font-family: arial,helvetica,clean,sans-serif;display: block; font-weight: bold;display: block; font-size: 13px;'>Health Commodities Management Platform</div><hr /> \n <span><p style='font-weight: bold;'>MFL CODE: " . $facility_code . "</p><p style='font-weight: bold;'> FACILITY NAME: " . $facility_name . "</p>\n "; /**********************************initializing the report **********************/ $this->load->library('mpdf'); $this->mpdf = new mPDF('', 'A4-L', 0, '', 15, 15, 16, 16, 9, 9, ''); $this->mpdf->SetTitle($title); $this->mpdf->WriteHTML($html_title); $this->mpdf->simpleTables = true; $this->mpdf->WriteHTML('<br/>'); $this->mpdf->WriteHTML($data); $report_name = $r_name . ".pdf"; $this->mpdf->Output($report_name, 'D'); } else { if ($display_type == "View Report") { $html_title = '<link href="' . base_url() . 'CSS/style.css" type="text/css" rel="stylesheet"/> <div class="logo"><a class="logo" ></a> </div> <div id="system_title"> <span style="display: block; font-weight: bold; font-size: 14px; margin:2px;">Public Health and Sanitation/Ministry of Medical Services</span> <span style="display: block; font-size: 12px;">Health Commodities Management Platform</span> </div> </div> <span style="display: block; font-size: 12px;">Health Commodities Management Platform</span><span style="text-align:center;" ><hr /> <span><p style="font-weight: bold;">MFL CODE: ' . $facility_code . '</p><p style="font-weight: bold;"> FACILITY NAME: ' . $facility_name . '</p>'; echo $html_title . $data; } } }
public function InsertExt() { #solves error code fac#35 changing issuing to use commodity id that batchno $commodity_id = $_POST['commodity_id']; #/////////////////////////////////////// $Available = $_POST['commodity_balance']; $ids = $_POST['drug_id']; $mfl = $_POST['mfl']; $batchN = $_POST['batchNo']; $Expiry = $_POST['expiry_date']; $qty = $_POST['Qtyissued']; $thedate = $_POST['date_issue']; $j = sizeof($ids); $count = 0; $facilityCode = $facility_c = $this->session->userdata('news'); $usernow = $this->session->userdata('identity'); //loop through all th donated commodities and process for ($me = 0; $me < $j; $me++) { if ($qty[$me] > 0) { ///update the donating facility details $facility_name = Facilities::get_facility_name($mfl[$me])->toArray(); $facility_details = "inter-facility donation: MFL NO " . $mfl[$me]; $sNo = "(-ve Adj) Stock Deduction"; $count++; $issues = $qty[$me] * -1; ////checking if the facilility receiving the commodities is using HCMP $users_array = user::getUsers($mfl[$me]); $user_in_donated_facility = count($users_array); //inserting in the facility issues $mydata = array('facility_code' => $facilityCode, 'kemsa_code' => $ids[$me], 's11_No' => $sNo, 'batch_no' => $batchN[$me], 'expiry_date' => date('y-m-d', strtotime($Expiry[$me])), 'qty_issued' => $qty[$me], 'balanceAsof' => $Available[$me], 'date_issued' => date('y-m-d', strtotime($thedate[$me])), 'issued_to' => $facility_details, 'issued_by' => $usernow, 'receipts' => $issues); $u = new Facility_Issues(); $u->fromArray($mydata); $u->save(); //updating the facility stock $a = Doctrine_Manager::getInstance()->getCurrentConnection(); $a->execute("UPDATE `Facility_Stock` SET `balance` = `balance`-{$qty[$me]} where id='{$commodity_id[$me]}'"); ///updating the trascation_table $inserttransaction_1 = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAll("select `adj` from `facility_transaction_table`WHERE `kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code={$facility_c}; "); $inserttransaction_2 = Doctrine_Manager::getInstance()->getCurrentConnection()->fetchAll("SELECT (SUM(qty_issued)*-1) as update_ FROM facility_issues \n\t\t\tWHERE kemsa_code = '{$ids[$me]}' and issued_to='{$facility_details}' and availability='1'"); $new_value = $inserttransaction_1[0]['adj'] + $inserttransaction_2[0]['update_']; $inserttransaction = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction->execute("UPDATE `facility_transaction_table` SET adj ={$new_value} \n WHERE `kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code={$facilityCode}; "); $inserttransaction1 = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction1->execute("UPDATE `facility_transaction_table` SET closing_stock = (SELECT SUM(balance) FROM facility_stock WHERE kemsa_code = '{$ids[$me]}'\n\t\t\tand availability='1' and facility_code='{$facilityCode}' and availability='1')\n WHERE`kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code={$facilityCode}; ; "); ///updating the receiving facility records if they are using the system if ($user_in_donated_facility > 0) { //getting the name of the mauf of the given drug $mauf = facility_stock::get_batch_details($batchN[$me], $ids[$me]); $mydata = array('facility_code' => $mfl[$me], 'kemsa_code' => $ids[$me], 'batch_no' => $batchN[$me], 'manufacture' => $mauf['manufacture'], 'expiry_date' => date('y-m-d', strtotime($Expiry[$me])), 'balance' => $qty[$me], 'quantity' => $qty[$me], 'stock_date' => date('y-m-d')); Facility_Stock::update_facility_stock($mydata); ///checking if the receiving_facility_has_this_drug //kemsa_code facility code $receiving_facility_has_this_drug = Facility_Transaction_Table::get_if_drug_is_in_table($mfl[$me], $ids[$me]); if (count($receiving_facility_has_this_drug) > 0) { //if yes update their records $inserttransaction = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction->execute("UPDATE `facility_transaction_table` SET \n\t\t\tadj = (SELECT SUM(qty_issued) FROM facility_issues WHERE kemsa_code = '{$ids[$me]}' and issued_to='{$facility_details}' and availability='1')\n WHERE `kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code={$mfl[$me]}; "); $inserttransaction1 = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction1->execute("UPDATE `facility_transaction_table` \n\t\t\tSET closing_stock = (SELECT SUM(qty_issued) FROM facility_issues WHERE kemsa_code = '{$ids[$me]}' and issued_to='{$facility_details}' and availability='1')\n WHERE`kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code={$mfl[$me]};"); } else { //if no insert the record in the transaction table $mydata2 = array('Facility_Code' => $mfl[$me], 'Kemsa_Code' => $ids[$me], 'Opening_Balance' => 0, 'Total_Issues' => 0, 'Total_Receipts' => 0, 'Adj' => $qty[$me], 'Closing_Stock' => $qty[$me], 'availability' => 1); Facility_Transaction_Table::update_facility_table($mydata2); } } else { //do nothing } } } $this->send_stock_donate_sms(); $this->session->set_flashdata('system_success_message', "You have Donated {$count} item(s)"); redirect('issues_main'); }