public function add_stock_first_run()
{
$facility_c = $this->session->userdata('news');
$kemsa_code = $_POST['drug_id'];
$expiry_date = $_POST['expiry_date'];
$batch_no = $_POST['batchNo'];
$manuf = $_POST['manuf'];
$a_stock = $_POST['qreceived'];
$count = count($kemsa_code);
$orderDate = date('y-m-d H:i:s');
Facility_Transaction_Table::disable_facility_transaction_table($facility_c);
Facility_Stock::disable_facility_stock($facility_c);
for ($i = 0; $i <= $count; $i++) {
if (isset($kemsa_code[$i]) && $kemsa_code[$i] != '') {
$mydata = array('facility_code' => $facility_c, 'kemsa_code' => $kemsa_code[$i], 'batch_no' => $batch_no[$i], 'manufacture' => $manuf[$i], 'expiry_date' => date('y-m-d', strtotime($expiry_date[$i])), 'balance' => $a_stock[$i], 'quantity' => $a_stock[$i], 'stock_date' => $orderDate);
Facility_Stock::update_facility_stock($mydata);
}
}
//updating the facility transaction table
$data = Facility_Stock::count_facility_stock($facility_c, $orderDate);
foreach ($data as $infor) {
$mydata2 = array('Facility_Code' => $facility_c, 'Kemsa_Code' => $infor->kemsa_code, 'Opening_Balance' => $infor->quantity1, 'Total_Issues' => 0, 'Total_Receipts' => 0, 'Closing_Stock' => $infor->quantity1, 'availability' => 1, 'Cycle_Date' => $orderDate);
$mydata3 = array('facility_code' => $facility_c, 's11_No' => 'Physical Stock Count', 'kemsa_code' => $infor->kemsa_code, 'batch_no' => 'N/A', 'expiry_date' => 'N/A', 'qty_issued' => 0, 'balanceAsof' => $infor->quantity1, 'date_issued' => date('y-m-d'), 'issued_to' => 'N/A', 'issued_by' => $this->session->userdata('identity'));
Facility_Issues::update_issues_table($mydata3);
Facility_Transaction_Table::update_facility_table($mydata2);
}
Update_stock_first_temp::delete_facility_temp(NULL, $facility_c);
//////////////////////////////////////////////////////////////////////////////////////////
$this->send_stock_update_sms();
$this->session->set_flashdata('system_success_message', "Stock Levels Have Been Updated");
redirect('stock_management/stock_level');
////////////////////////////////////////////////////////////////////////////////////////
}
