public function new_order($note = NULL) { if (isset($note)) { $facility_c = $this->session->userdata('news'); $data['title'] = "New Order"; $data['content_view'] = "facility/facility_data/facility_orders/new_order_v"; $data['banner_text'] = "New Order"; $data['link'] = "order_management"; $data['drug_name'] = Drug::getAll(); $data['facility_order'] = Facility_Transaction_Table::get_commodities_for_ordering($facility_c); $data['quick_link'] = "new_order"; $this->load->view("template", $data); } else { redirect("stock_management/stock_level/c0N123"); } }
public function commoditieshtml() { $from = $_POST['fromcommodity']; $to = $_POST['tocommodity']; $facility_Code = $_POST['facilitycode']; $id = $this->session->userdata('identity'); //echo "$from"; $req_data = array('from' => $from, 'to' => $to); $this->session->set_userdata($req_data); //$data['title'] = "Commodity Issues Summary"; $mycount = count(Facility_Issues::getcissues()); if ($mycount > 0) { $data['reports'] = Facility_Issues::getcissues(); $data['names'] = User::getsome($id); $data['drugs'] = Drug::getAll(); $this->load->view("commodityIssues", $data); } else { echo '<div class="norecord"></div>'; } }
public function Insert_test() { $ids = $_POST['kemsaCode']; $Available = $_POST['AvStck']; $batchN = $_POST['batchNo']; $Expiry = $_POST['Exp']; //$sNo=$_POST['s11N']; $qty = $_POST['Qtyissued']; $thedate = $_POST['datepicker']; $serviceP = $_POST['Servicepoint']; $j = sizeof($ids); $count = 0; $facilityCode = $facility_c = $this->session->userdata('news'); $usernow = $this->session->userdata('identity'); for ($me = 0; $me < $j; $me++) { if ($qty[$me] > 0) { $count++; $mydata = array('facility_code' => $facilityCode, 'kemsa_code' => $ids[$me], 's11_No' => "internal issue", 'batch_no' => $batchN[$me], 'expiry_date' => $Expiry[$me], 'qty_issued' => $qty[$me], 'issued_to' => $serviceP, 'balanceAsof' => $Available[$me], 'date_issued' => date('y-m-d', strtotime($thedate[$me])), 'issued_by' => $usernow); $u = new Facility_Issues(); $u->fromArray($mydata); $u->save(); //echo "$xraws records inserted"; $q = Doctrine_Query::create()->update('Facility_Stock')->set('balance', '?', $Available[$me])->where("kemsa_code='{$ids[$me]}' AND batch_no='{$batchN[$me]}' and facility_code ='{$facilityCode}'"); $q->execute(); $inserttransaction = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction->execute("UPDATE `facility_transaction_table` SET total_issues = (SELECT SUM(qty_issued) \n\t\t\tFROM facility_issues WHERE kemsa_code = '{$ids[$me]}' and availability='1' and facility_code='{$facilityCode}')\n WHERE `kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code='{$facilityCode}'; "); //echo "$numrows records updated"; $inserttransaction1 = Doctrine_Manager::getInstance()->getCurrentConnection(); $inserttransaction1->execute("UPDATE `facility_transaction_table` SET closing_stock = (SELECT SUM(balance)\n\t\t\t FROM facility_stock WHERE kemsa_code = '{$ids[$me]}' and availability='1' and facility_code='{$facilityCode}')\n WHERE `kemsa_code`= '{$ids[$me]}' and availability='1' and facility_code ='{$facilityCode}'; "); } $data['title'] = "Stock"; $data['drugs'] = Drug::getAll(); $data['popout'] = "You have issued {$count} item(s)"; $data['content_view'] = "issuesnRecpt"; $data['banner_text'] = "Stock Control Card"; $data['link'] = "order_management"; $data['quick_link'] = "stockcontrol_c"; $this->load->view("template", $data); } }
public function get_leadtime_chart_ajax() { $district = $this->session->userdata('district1'); $data['facilities'] = Facilities::getFacilities($district); $this->load->view("district/ajax_view/leadtime_v", $data); $data['drugs'] = Drug::getAll(); }
public function historical_stock_take() { $facility_code = $this->session->userdata('news'); $data['title'] = "Provide Historical Stock Data"; $data['content_view'] = "facility/historical_stock_v"; $data['banner_text'] = "Provide Historical Stock Data"; $data['quick_link'] = "load_stock"; $data['link'] = "home"; $data['drugs'] = Drug::getAll(); $data['drug_name'] = Drug::get_drug_name(); $data['drug_categories'] = Drug_Category::getAll(); $data['historical_data'] = Historical_Stock::load_historical_stock($facility_code); $data['quick_link'] = "update_stock_level"; $this->load->view("template", $data); }