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 get_data($param, $isCount = FALSE, $CompileOnly = False)
{
if ($param['search'] != null && $param['search'] === 'true') {
// cek apakah search_field ada dalam fieldmap ?
if (array_key_exists($param['search_field'], $this->fieldmap)) {
$wh = "UPPER(" . $this->fieldmap[$param['search_field']] . ")";
$param['search_str'] = strtoupper($param['search_str']);
switch ($param['search_operator']) {
case "bw":
// begin with
$wh .= " LIKE '" . $param['search_str'] . "%'";
break;
case "cn":
// contain %param%
$wh .= " LIKE '%" . $param['search_str'] . "%'";
break;
default:
$wh = "";
}
$this->db->where($wh);
}
}
$param['limit'] != null ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
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']);
}
//returns the query string
$this->db->select('ID_KECAMATAN, KODE_KECAMATAN, NAMA_KECAMATAN');
$this->db->from($this->_table);
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_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;
}
}
}
function get_data($param, $isCount = FALSE, $CompileOnly = False)
{
if ($param['search'] != null && $param['search'] === 'true') {
// cek apakah search_field ada dalam fieldmap ?
if (array_key_exists($param['search_field'], $this->fieldmap)) {
$wh = "UPPER(" . $this->fieldmap[$param['search_field']] . ")";
$param['search_str'] = strtoupper($param['search_str']);
switch ($param['search_operator']) {
case "bw":
// begin with
$wh .= " LIKE '" . $param['search_str'] . "%'";
break;
case "cn":
// contain %param%
$wh .= " LIKE '%" . $param['search_str'] . "%'";
break;
default:
$wh = "";
}
$this->db->where($wh);
}
}
$param['limit'] != null ? $this->db->limit($param['limit']['end'], $param['limit']['start']) : '';
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.ID_REKENING, r.TIPE, r.KELOMPOK, r.JENIS, r.OBJEK, r.RINCIAN, r.SUB1,
r.SUB2, r.SUB3, r.KODE_REKENING, r.NAMA_REKENING, t.TARIF_RP, t.TARIF_PERSEN');
$this->db->from('REKENING r');
$this->db->join('TARIF_PAJAK t', 'r.ID_REKENING = t.ID_REKENING');
$this->db->where('t.TAHUN = ' . $this->tahun . '');
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;
}
}
}
