function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n        a.id_spt,\r\n        a.nomor_kohir,\r\n        a.npwpd,\r\n        a.nama_wp,\r\n        r.nama_rekening,\r\n        a.jumlah_pajak,\r\n        p.tanggal,\r\n        p.batas_bayar\r\n    ");
     $this->db->from('spt a');
     $this->db->join('rekening r', 'r.id_rekening = a.id_rekening');
     $this->db->join('penetapan p', 'p.id_spt = a.id_spt');
     $this->db->where("a.tipe = 'OA'");
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }
 function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n            a.id_pembayaran_lain,\r\n            a.nama_penyetor,\r\n            a.alamat,\r\n            a.tanggal,\r\n            a.jumlah_bayar,\r\n            b.kode_skpd,\r\n            b.nama_skpd,\r\n            c.kode_rekening,\r\n            c.nama_rekening\r\n    ");
     $this->db->from('pembayaran_lain a');
     $this->db->join('skpd b', 'b.id_skpd = a.id_skpd');
     $this->db->join('rekening c', 'c.id_rekening = a.id_rekening');
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }
 function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n        a.id_spt,\r\n        a.nomor_spt,\r\n        a.tanggal_spt,\r\n        a.periode_awal,\r\n        a.periode_akhir,\r\n        r.nama_rekening,\r\n        a.nama_wp,\r\n        a.lokasi,\r\n        a.jumlah_pajak\r\n    ");
     $this->db->from('spt a');
     $this->db->join('rekening r', 'r.id_rekening = a.id_rekening');
     $this->db->join('rekening_pr pr', 'r.id_rekening = pr.id_rekening');
     $this->db->where('a.tipe', $param['tipe']);
     $this->db->where_not_in('a.id_spt', $this->get_reklame());
     $this->db->where('pr.kode_pr', PAJAK_RESTAURAN);
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }
 function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n            a.id_pembayaran,\r\n            a.tanggal,\r\n            c.nama_rekening,\r\n            b.nama_wp,\r\n            b.nomor_spt,\r\n            b.jumlah_pajak,\r\n            a.telah_dibayar,\r\n            sum(a.jumlah_bayar + a.denda - a.telah_dibayar) sisa\r\n    ");
     $this->db->from('pembayaran a');
     $this->db->join('spt b', 'b.id_spt = a.id_spt');
     $this->db->join('rekening c', 'c.id_rekening = b.id_rekening');
     $this->db->where('b.tipe', 'SA');
     $this->db->group_by('a.id_pembayaran, a.tanggal, c.nama_rekening, b.nama_wp, 
         b.nomor_spt, b.jumlah_pajak, a.telah_dibayar');
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }
 function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n          a.id_pembayaran,\r\n          b.nomor_spt,\r\n          b.nomor_kohir,\r\n          b.npwpd,\r\n          b.tanggal_spt,\r\n          a.tanggal tanggal_bayar,\r\n          a.jumlah_bayar\r\n    ");
     $this->db->from('pembayaran a');
     $this->db->join('spt b', 'b.id_spt = a.id_spt');
     $this->db->where('b.tipe', 'OA');
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }
function build_editdel_links($obj, $edit, $delete)
{
    global $sql_strings;
    $where = get_where_str($obj);
    // build the Edit-Link
    if ($edit == TRUE) {
        $url = url_session('watchtable.php?edit=' . $where);
        echo '<td><a href="' . $url . '" class="act">' . $sql_strings['Edit'] . '</a></td>';
    }
    // build the Del-link
    if ($delete == TRUE) {
        $url = url_session('watchtable.php?del=' . $where);
        echo '<td><a href="' . $url . '" class="act">' . $sql_strings['Delete'] . '</a></td>';
    }
}
 function get_data($param, $isCount = FALSE, $CompileOnly = False)
 {
     isset($param['limit']) && $param['limit'] ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
     if (isset($param['search']) && $param['search'] && ($wh = get_where_str(array($param['search_field'] => $param['search_str']), $this->fieldmap))) {
         $this->db->where($wh);
     }
     if (isset($param['sort_by']) && $param['sort_by'] != null && !$isCount && ($ob = get_order_by_str($param['sort_by'], $this->fieldmap))) {
         $this->db->order_by($ob, $param['sort_direction']);
     }
     $this->db->select("\r\n        a.id_wajib_pajak,\r\n        case a.jenis when 'P' then 'Pajak' when 'R' then 'Retribusi' else '-' end jenis,\r\n        case a.golongan when '1' then 'Golongan 1' when '2' then 'Golongan 2' else '-' end golongan,\r\n        a.nomor,\r\n        a.nomor_reg,\r\n        a.nama_wp,\r\n        a.alamat_wp,\r\n        a.npwpd,\r\n        b.uraian jenis_usaha\r\n    ");
     $this->db->from('wajib_pajak a');
     $this->db->join('jenis_usaha b', 'b.id_jenis_usaha = a.id_jenis_usaha');
     if ($isCount) {
         $result = $this->db->count_all_results();
         return $result;
     } else {
         if ($CompileOnly) {
             return $this->db->get_compiled_select();
         } else {
             $result = $this->db->get()->result_array();
             return $result;
         }
     }
 }