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