function pilih_spt($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('a.PENDATAAN_ID, a.PENDATAAN_NO, a.TGL_ENTRY, a.NOMINAL, aa.PEMOHON, aa.NPWP, aa.ALAMAT, aa.KELURAHAN, aa.KECAMATAN, aa.PENDATAAN_ID, aa.PENDAFTARAN_ID, aa.PEMOHON_ID '); $this->db->from('pendataan_spt a '); $this->db->join('v_pendataan_spt aa', 'aa.PENDATAAN_ID=a.PENDATAAN_ID', 'left'); $this->db->join('penerimaan_pr b', 'a.PENDATAAN_ID=b.PENDATAAN_ID', 'left'); //$this->db->order_by('spt_no'); $this->db->limit($arr['limit'], $arr['start']); return $this->db->get(); $this->db->trans_complete(); }
function get_data($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('a.PENDATAAN_ID, a.JENIS_PUNGUTAN, a.PENDATAAN_NO, a.TGL_PROSES, a.tgl_entry, a.memo, a.periode_awal, a.periode_akhir, aa.kva, aa.diskon, aa.jam, aa.persen_tarif, aa.dasar_tarif, aa.dasar_pengenaan, aa.nominal, rk.id as id_rekening, rk.kode_rekening, rk.nama_rekening, b.TGL_KIRIM, b.spt_no, b.spt_id, vp.pendaftaran_id, vp.PEMOHON, vp.NPWP, vp.alamat, vp.nama_kecamatan, vp.nama_desa, pp.NO_PENETAPAN, pp.TGL_PENETAPAN, pn.TGL_PENERIMAAN, '); $this->db->from($this->_table . ' a'); $this->db->join($this->_table_rincian . ' aa', 'aa.pendataan_id=a.pendataan_id', 'left'); $this->db->join('rekening_kode rk', 'rk.id=aa.id_rekening', 'left'); $this->db->join('spt b', 'b.PENDAFTARAN_ID=a.PENDAFTARAN_ID', 'left'); $this->db->join('v_pendaftaran vp', 'vp.PENDAFTARAN_ID=a.PENDAFTARAN_ID', 'left'); $this->db->join('penetapan_pr_content ppc', 'ppc.pendataan_id=a.pendataan_id', 'left'); $this->db->join('penetapan_pr pp', 'pp.penetapan_pr_id=ppc.penetapan_pr_id', 'left'); $this->db->join('penerimaan_pr pn', 'pn.PENDATAAN_ID=ppc.PENDATAAN_ID', 'left'); $this->db->limit($arr['limit'], $arr['start']); return $this->db->get(); $this->db->trans_complete(); }
function pilih_penerimaan($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('c.ID as id_rekening, c.KODE_REKENING, c.NAMA_REKENING, a.THN_PENERIMAAN, sum(b.NOMINAL) '); $this->db->from($this->_table . ' a'); $this->db->join($this->_table_rincian . ' b', 'a.PENERIMAAN_PR_ID=b.PENERIMAAN_PR_ID', 'left'); $this->db->join('rekening_kode c', 'b.ID_REKENING=c.ID', 'left'); $this->db->join('sts_content d', 'd.ID_REKENING=b.ID_REKENING', 'left'); if (isset($arr['group'])) { $this->db->group_by($arr['group']); } //$this->db->order_by('spt_no'); $this->db->limit($arr['limit'], $arr['start']); return $this->db->get(); $this->db->trans_complete(); }
function get_sptprd($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('a.pendataan_id as id, a.pendataan_no, a.tgl_entry, a.npwp, a.pemohon, a.jenis_pendataan, a.jenis_pungutan, a.jenis_pendaftaran, a.spt_no, a.spt_tgl, a.nominal'); $this->db->from('v_pendataan_spt a'); $this->db->join('penetapan_pr_content b', 'b.pendataan_id=a.pendataan_id', 'left'); $this->db->limit($arr['limit'], $arr['start']); return $this->db->get(); $this->db->trans_complete(); }
function seeknpw($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('a.pendaftaran_id,a.pemohon,npwp,a.jenis_usaha,a.alamat,a.nama_desa,a.nama_kecamatan,b.tgl_kirim,b.spt_no,b.spt_id'); $this->db->from('v_pendaftaran a'); $this->db->join('spt b', 'b.pendaftaran_id=a.pendaftaran_id', 'left'); $this->db->limit($arr['limit'], $arr['start']); //$this->db->order_by('pemohon'); return $this->db->get(); $this->db->trans_complete(); }
function get_rekening($arr) { $this->db->trans_start(); jqgrid_set_where($arr); $this->db->select('id,kode_rekening,nama_rekening,tarif_dasar,persen_tarif,tarif_tambahan'); $this->db->from($this->_table); $this->db->limit($arr['limit'], $arr['start']); $this->db->order_by('tipe'); $this->db->order_by('kelompok'); $this->db->order_by('jenis'); $this->db->order_by('objek'); $this->db->order_by('rincian'); return $this->db->get(); $this->db->trans_complete(); }
function jqgrid_set_limit($table, $owhere = '') { $CI =& get_instance(); $page = $_REQUEST['page']; // get the requested page $limit = $_REQUEST['rows']; // get how many rows we want to have into the grid $CI->db->trans_start(); jqgrid_set_where($owhere); //if(isset($owhere) && $owhere!='') $CI->db->where($owhere); $CI->db->from($table); $CI->db->select('count(*)'); if (isset($owhere['group'])) { $CI->db->group_by($owhere['group']); } $row = $CI->db->get()->row()->COUNT; $CI->db->trans_complete(); //$count = count($row); $count = $row; if ($count > 0) { $total_pages = ceil($count / $limit); } else { $total_pages = 0; } if ($page > $total_pages) { $page = $total_pages; } $start = $limit * $page - $limit; // do not put $limit*($page - 1) if ($start < 0) { $start = 0; } return array('start' => $start, 'limit' => $limit, 'page' => $page, 'total_pages' => $total_pages, 'records' => $count); //$CI->db->limit($limit, $start); }