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