Penduduk Model

class Penduduk_m extends CI_Model {
    var $column_order   = array(null, 'p.penduduk_nik','p.penduduk_no_kk','p.penduduk_nama','p.penduduk_tmpt_lhr','p.penduduk_tgl_lahir','p.penduduk_jk','p.penduduk_alamat','k.kecamatan_nama','d.desa_nama');
    var $column_search  = array('p.penduduk_nik','p.penduduk_no_kk','p.penduduk_nama','p.penduduk_tmpt_lhr','p.penduduk_tgl_lahir','p.penduduk_jk','p.penduduk_alamat','k.kecamatan_nama','d.desa_nama');
    var $order          = array('p.penduduk_nama' => 'asc');

    function __construct() {
        parent::__construct();
    }

    private function _get_datatables_query() {
        $seleksi    = $this->uri->segment(3);
        $id         = $this->uri->segment(4);

        if (empty($seleksi) || $seleksi == '') {
            $this->db->select('p.*, k.kecamatan_nama, d.desa_nama');
            $this->db->from('rtlh_penduduk_jepara p');
            $this->db->join('rtlh_kecamatan k', 'p.kecamatan_id = k.kecamatan_id');
            $this->db->join('rtlh_desa d', 'p.desa_id = d.desa_id');
            $this->db->join('rtlh_kabupaten b', 'k.kabupaten_id = b.kabupaten_id');
            $this->db->where('b.kabupaten_id', '3320');
        } elseif ($seleksi == 'kecamatan') {
            $this->db->select('p.*, k.kecamatan_nama, d.desa_nama');
            $this->db->from('rtlh_penduduk_jepara p');
            $this->db->join('rtlh_kecamatan k', 'p.kecamatan_id = k.kecamatan_id');
            $this->db->join('rtlh_desa d', 'p.desa_id = d.desa_id');
            $this->db->join('rtlh_kabupaten b', 'k.kabupaten_id = b.kabupaten_id');
            $this->db->where('k.kecamatan', $id);
        }

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

                if(count($this->column_search) - 1 == $i)
                    $this->db->group_end();
            }
            $i++;
        }

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

    function get_datatables() {
        $this->_get_datatables_query();

        if($_POST['length'] != -1)
        $this->db->limit($_POST['length'], $_POST['start']);
        $query = $this->db->get();
        return $query->result();
    }

    function count_filtered() {
        $this->_get_datatables_query();

        $query = $this->db->get();
        return $query->num_rows();
    }

    public function count_all() {
        $seleksi    = $this->uri->segment(3);
        $id         = $this->uri->segment(4);

        if (empty($seleksi) || $seleksi == '') {
            $this->db->select('p.*, k.kecamatan_nama, d.desa_nama');
            $this->db->from('rtlh_penduduk_jepara p');
            $this->db->join('rtlh_kecamatan k', 'p.kecamatan_id = k.kecamatan_id');
            $this->db->join('rtlh_desa d', 'p.desa_id = d.desa_id');
            $this->db->join('rtlh_kabupaten b', 'k.kabupaten_id = b.kabupaten_id');
            $this->db->where('b.kabupaten_id', '3320');
        } elseif ($seleksi == 'kecamatan') {
            $this->db->select('p.*, k.kecamatan_nama, d.desa_nama');
            $this->db->from('rtlh_penduduk_jepara p');
            $this->db->join('rtlh_kecamatan k', 'p.kecamatan_id = k.kecamatan_id');
            $this->db->join('rtlh_desa d', 'p.desa_id = d.desa_id');
            $this->db->join('rtlh_kabupaten b', 'k.kabupaten_id = b.kabupaten_id');
            $this->db->where('k.kecamatan', $id);
        }

        return $this->db->count_all_results();
    }

    function select_kecamatan() {
        $this->db->select('*');
        $this->db->from('rtlh_kecamatan');
        $this->db->where('kabupaten_id', '3320');
        $this->db->order_by('kecamatan_nama', 'asc');

        return $this->db->get();
    }

    function select_desa($kecamatan_id) {
        $this->db->select('*');
        $this->db->from('rtlh_desa');
        $this->db->where('kecamatan_id', $kecamatan_id);

        return $this->db->get();
    }

    function select_by_id($user_username) {
        $this->db->select('*');
        $this->db->from('rtlh_penduduk_jepara');
        $this->db->where('user_username', $user_username);

        return $this->db->get();
    }
}