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);
}
