'left', FALSE ); $this->applyDetailFilters($filters); $this->db->group_by('dataumumweb.IDPerkara'); $this->db->order_by($orderby, $type); $this->db->order_by( 'dataumumweb.tglPendaftaran', 'DESC' ); $this->db->limit(20, $begin); return $this->db->get(); } /* * ============================================================ * JUMLAH HASIL QUERY TERAKHIR * * Panggil langsung setelah query daftar yang memakai * SQL_CALC_FOUND_ROWS, pada koneksi DB yang sama. * ============================================================ */ function fecth_data_num() { $query = $this->db->query( "SELECT FOUND_ROWS() AS cnt" ); if ($query && $query->num_rows() > 0) { return (int) $query->row()->cnt; } return 0; } /* * ============================================================ * HITUNG JUMLAH PERKARA UTAMA * ============================================================ */ function fecth_data_num_main( $idalurperkara = '', $key = '' ) { $this->db->from('dataumumweb'); $this->applyKlasifikasiFilter($idalurperkara); $this->applyKeywordFilter($key); return (int) $this->db->count_all_results(); } /* * ============================================================ * HITUNG JUMLAH PERKARA LALU LINTAS * ============================================================ */ function fecth_data_num_ll( $idalurperkara = '', $key = '' ) { $this->db->from('dataumumweb AS A'); $this->db->join( 'perkaralalulintasweb AS B', 'B.IDPerkara = A.IDPerkara', 'left' ); $this->applyKlasifikasiFilter($idalurperkara, 'A'); $this->applyKeywordLLFilter($key); // DISTINCT agar join tidak menggandakan perkara $this->db->select('COUNT(DISTINCT A.IDPerkara) AS cnt', FALSE); $query = $this->db->get(); if ($query && $query->num_rows() > 0) { return (int) $query->row()->cnt; } return 0; } /* * ============================================================ * GET PERBAIKAN GUGATAN * ============================================================ */ function get_perbaikan_gugatan($idperkara) { $idperkara = $this->validInt($idperkara); if ($idperkara === FALSE || $idperkara <= 0) { return FALSE; } return $this->db ->where('IDPerkara', (int) $idperkara) ->get('perbaikangugatanweb'); } }
Fatal error: Class 'Perkara_m' not found in /var/www/html/system/core/Loader.php on line 145