public function stock_control_ajax()
{
//loads the bin card after the user selects the particular commodity
$facility_code = $this->session->userdata('facility_id');
$commodity_id = $_POST['commodity_select'];
$to = $_POST['to'];
$from = $_POST['from'];
$commodity_name = $_POST['commodity_name'];
//to enable pdf download
$data['commodity_id'] = $commodity_id;
$data['commodity_name'] = $commodity_name;
$data['from'] = $from;
$data['to'] = $to;
$data['facility_code'] = $this->session->userdata('facility_id');
$data_ = Facility_issues::get_bin_card($facility_code, $commodity_id, $from, $to);
$data_final = array();
foreach ($data_ as $key => $value) {
$date_issued = $value['date_issued'];
$expiry_date = $value['expiry_date'];
$batch_no = $value['batch_no'];
$unit_size = $value['unit_size'];
$s11_No = $value['s11_No'];
$balance_as_of = $value['balance_as_of'];
$adjustmentnve = $value['adjustmentnve'];
$adjustmentpve = $value['adjustmentpve'];
$qty_issued = $value['qty_issued'];
$fname = $value['fname'];
$lname = $value['lname'];
$service_point_name = $value['service_point_name'];
if ($s11_No == 'internal issue') {
if (preg_match('/[A-Za-z]/i', $service_point_name)) {
$data_final[] = array('date_issued' => $date_issued, 'expiry_date' => $expiry_date, 'batch_no' => $batch_no, 'unit_size' => $unit_size, 's11_No' => $s11_No, 'balance_as_of' => $balance_as_of, 'adjustmentnve' => $adjustmentnve, 'adjustmentpve' => $adjustmentpve, 'qty_issued' => $qty_issued, 'fname' => $fname, 'fname' => $fname, 'service_point_name' => $service_point_name);
} else {
$service_point_name = intval($service_point_name);
$service_point_details = Facility_issues::get_one_service_points($service_point_name);
foreach ($service_point_details as $keys => $values) {
$service_point_name = $values['service_point_name'];
}
$data_final[] = array('date_issued' => $date_issued, 'expiry_date' => $expiry_date, 'batch_no' => $batch_no, 'unit_size' => $unit_size, 's11_No' => $s11_No, 'balance_as_of' => $balance_as_of, 'adjustmentnve' => $adjustmentnve, 'adjustmentpve' => $adjustmentpve, 'qty_issued' => $qty_issued, 'fname' => $fname, 'fname' => $fname, 'service_point_name' => $service_point_name);
}
} else {
$data_final[] = array('date_issued' => $date_issued, 'expiry_date' => $expiry_date, 'batch_no' => $batch_no, 'unit_size' => $unit_size, 's11_No' => $s11_No, 'balance_as_of' => $balance_as_of, 'adjustmentnve' => $adjustmentnve, 'adjustmentpve' => $adjustmentpve, 'qty_issued' => $qty_issued, 'fname' => $fname, 'fname' => $fname, 'service_point_name' => $service_point_name);
}
}
// echo "<pre>";
// print_r($data_final);die;
$available_bal = Facility_stocks::get_all_facility($facility_code, $commodity_id);
$distinct = count(Facility_issues::get_distinct_batch($facility_code, $commodity_id, $from, $to));
// echo "<pre>";print_r($data_);exit;
$data['bin_card'] = $data_final;
// $data['bin_card'] = $data_;
$count_records = count($data_);
$data['count_records'] = $count_records;
$data['distinct_batch'] = $distinct;
$data['available_bal'] = $available_bal[0]['current_bal'];
if ($count_records <= 0) {
echo ' <div class="" id="reports_display" style="min-height: 350px;" >
<div style="margin:auto; text-align: center">
<h2>You have no Records, for the given filters</h2>
<h3>
Please select filters above.
</h3>
</div>
</div>
';
} else {
$this->load->view("facility/facility_reports/ajax/bin_card_ajax", $data);
}
}
public function stock_control_ajax()
{
//loads the bin card after the user selects the particular commodity
$facility_code = $this->session->userdata('facility_id');
$commodity_id = $_POST['commodity_select'];
$to = $_POST['to'];
$from = $_POST['from'];
$commodity_name = $_POST['commodity_name'];
//to enable pdf download
$data['commodity_id'] = $commodity_id;
$data['commodity_name'] = $commodity_name;
$data['from'] = $from;
$data['to'] = $to;
$data['facility_code'] = $this->session->userdata('facility_id');
$data_ = Facility_issues::get_bin_card($facility_code, $commodity_id, $from, $to);
$available_bal = Facility_stocks::get_all_facility($facility_code, $commodity_id);
$distinct = count(Facility_issues::get_distinct_batch($facility_code, $commodity_id, $from, $to));
//echo "<pre>";print_r($data_);exit;
$data['bin_card'] = $data_;
$count_records = count($data_);
$data['count_records'] = $count_records;
$data['distinct_batch'] = $distinct;
$data['available_bal'] = $available_bal[0]['current_bal'];
if ($count_records <= 0) {
echo ' <div class="" id="reports_display" style="min-height: 350px;" >
<div style="margin:auto; text-align: center">
<h2>You have no Records, for the given filters</h2>
<h3>
Please select filters above.
</h3>
</div>
</div>
';
} else {
$this->load->view("facility/facility_reports/ajax/bin_card_ajax", $data);
}
}
