model

function get_data_karyawan($id = null, $offset = null, $limit = null, $order = null, $filters = null)
    {
        $this->db->select("a.id, a.nipbaru, a.nama, a.jabatan, b.nama_unitkerja, b.eselon, a.unit_id, a.foto, a.golongan, a.is_pns, a.unor, a.unker");
        $this->db->from($this->table.' a');
        $this->db->join("m_ehrm_unit b","a.kdunit=b.kode_unit");


        if ($id == null OR $id == "") {
             // $this->db->where("a.active", "1"); // data tidak aktif tidak ditampilkan

            if (!empty($filters)) {
                if (is_array($filters) && count($filters) >= 1) {
                    $this->db->group_start();
                    $this->db->like('id', $filters[0]['value']);
                    $this->db->or_like('nipbaru', $filters[0]['value']);
                    $this->db->or_like('nama', $filters[0]['value']);
                    $this->db->or_like('jabatan', $filters[0]['value']);
                    $this->db->or_like('unit_id', $filters[0]['value']);
                    $this->db->or_like('eselon', $filters[0]['value']);
                    $this->db->or_like('foto', $filters[0]['value']);
                    $this->db->or_like('golongan', $filters[0]['value']);
                    $this->db->or_like('is_pns', $filters[0]['value']);
                    $this->db->or_like('unor', $filters[0]['value']);
                    $this->db->or_like('unker', $filters[0]['value']);
                    $this->db->group_end();
                }
            }

            if (!empty($order)) {
                $this->db->order_by($order[0]['field'], $order[0]['dir'], TRUE);
            } else {
                $this->db->order_by('id');
            }

            if (empty($offset)) $offset = 0;
            if (empty($limit)) $limit = 10;
            $this->db->limit($limit, $offset);

            $Q = $this->db->get();
            $this->_data = $Q->result();
        } else {
            $this->db->where("id", $id);

            $Q = $this->db->get();
            $this->_data = $Q->row();
        }

        $Q->free_result();
        return $this->_data;
    }

    function get_data_cnt_karyawan($filters = null)
    {
        $this->db->select("count(1) _cnt");
        $this->db->from($this->table.' a');
        $this->db->join("m_ehrm_unit b","a.kdunit=b.kode_unit");
         // $this->db->where("a.active", "1"); // data tidak aktif tidak ditampilkan

        if (!empty($filters)) {
            if (is_array($filters) && count($filters) >= 1) {
                $this->db->group_start();
                $this->db->like('id', $filters[0]['value']);
                $this->db->or_like('nipbaru', $filters[0]['value']);
                $this->db->or_like('nama', $filters[0]['value']);
                $this->db->or_like('jabatan', $filters[0]['value']);
                $this->db->or_like('unit_id', $filters[0]['value']);
                $this->db->or_like('eselon', $filters[0]['value']);
                $this->db->or_like('foto', $filters[0]['value']);
                $this->db->or_like('golongan', $filters[0]['value']);
                $this->db->or_like('is_pns', $filters[0]['value']);
                $this->db->or_like('unor', $filters[0]['value']);
                $this->db->or_like('unker', $filters[0]['value']);
                $this->db->group_end();
            }
        }

        $Q = $this->db->get();
        $this->_data = $Q->row()->_cnt;
        $Q->free_result();
        return $this->_data;
    }