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