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