1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / arudhra_accounts / application / models /
Filename : Set_material_model.php
back
<?php
class Set_material_model extends CI_Model {

    public function __construct() {
        parent::__construct();
        $this->load->database();
        
        $this->table = 'tbl_material_request';       
        $this->column_order = array(
            '0'=>'reference_id',
            '1'=>'reference_no',
            '2'=>'supplier',
            '3'=>'delivery_date',
            '4'=>'status'
        );
        $this->column_search = array(
            '0'=>'reference_no',
            '1'=>'supplier',
            '2'=>'delivery_date',
            '3'=>'status'
        );
        $this->order = array('reference_no' => 'ASC');
    }

    public function getRows($postData){
        $this->_get_datatables_query($postData);

        if($postData['length'] != -1){
            $this->db->limit($postData['length'], $postData['start']);
        }

        $query = $this->db->get();
        return $query->result();
    }
    
    public function countAll($postData){
        $this->db->from($this->table);
        return $this->db->count_all_results();
    }
    
    public function countFiltered($postData){
        $this->_get_datatables_query($postData);
        $query = $this->db->get();
        return $query->num_rows();
    }

    private function _get_datatables_query($postData){
        // Select fields from both tables
        $this->db->select('tbl_material_request.*, tbl_material_request_records.itemcode, tbl_material_request_records.itemname, tbl_material_request_records.quantity, tbl_material_request_records.available_quantity');
        $this->db->from($this->table);

        // Join with tbl_material_request_records table
        $this->db->join('tbl_material_request_records', 'tbl_material_request.reference_id = tbl_material_request_records.material_request_id', 'left');

        $i = 0;
        foreach($this->column_search as $item){
            if($postData['search']['value']){
                if($i === 0){
                    $this->db->group_start();
                    $this->db->like($item, $postData['search']['value']);
                } else {
                    $this->db->or_like($item, $postData['search']['value']);
                }
                
                if(count($this->column_search) - 1 == $i){
                    $this->db->group_end();
                }
            }
            $i++;
        }

        if(isset($postData['order'])){
            $this->db->order_by($this->column_order[$postData['order']['0']['column']], $postData['order']['0']['dir']);
        } else if(isset($this->order)){
            $order = $this->order;
            $this->db->order_by(key($order), $order[key($order)]);
        }
    }
}
?>