'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