function grid_wp()
{
$this->load->library('Datatables', $this->load->database('pad', TRUE));
$this->datatables->select('c.id, get_npwpd(c.id, true) as npwpd, c.nama as customernm,
(case when c.wpnama=\'\' then c.pnama else c.wpnama end) as nama, c.alamat', false);
$this->datatables->from('pad_customer c');
$this->datatables->join('(select cu.id, cu.usaha_id, u.nama, cu.customer_id
from pad_customer_usaha cu
inner join pad_usaha u on cu.usaha_id = u.id and u.id not in (' . pad_reklame_id() . ',' . pad_air_tanah_id() . ')
) as cu', 'cu.customer_id = c.id');
$this->datatables->where('c.rp', 'P');
echo $this->datatables->generate();
}
function sptpd_get_cu($customer_id, $usaha_id = '')
{
// terlanjur sayang
$qry = "select cu.id customer_usaha_id, cu.customer_id, cu.usaha_id, get_npwpd(c.id, true) as npwpd, get_npwpd(c.id, false) as npwpd2, c.nama as customernm,\r\n\t\t\tcu.konterid, cu.air_zona_id, cu.air_manfaat_id , u.so, cu.def_pajak_id,\r\n\t\t\tcast(u.nama||' ('||cu.konterid||' | '||coalesce(cu.opnm,u.nama)||')' as character varying) as usahanm,\r\n \r\n c.wpnama, c.wpalamat\r\n\r\n\t\t\tfrom pad_customer_usaha cu\r\n\t\t\tinner join pad_customer c on cu.customer_id=c.id\r\n\t\t\tinner join pad_usaha u on cu.usaha_id=u.id\r\n\t\t\twhere cu.customer_id = ?";
if (wp_login() && empty($usaha_id)) {
$qry .= "and u.id not in (" . pad_reklame_id() . ", " . pad_air_tanah_id() . ") ";
}
if (wp_login() && !empty($usaha_id)) {
$qry .= "and u.id in ({$usaha_id}) ";
}
$qry .= "order by c.rp,c.pb,c.formno, cu.usaha_id, cu.konterid";
$query = $this->db_pad->query($qry, array($customer_id));
if ($query->num_rows() !== 0) {
return $query->result();
} else {
return FALSE;
}
}
function get_skpdj_data($usaha_id = '', $cu_id = '')
{
$pad_reklame_id = pad_reklame_id();
$pad_airtanah_id = pad_air_tanah_id();
$qry = "SELECT \r\n --c.id as c_id, get_npwpd(c.id, true) as npwpd, upper(c.customernm) customernm, \r\n --(case when c.wpnama='' then c.pnama else c.wpnama end) as nama, c.alamat, \r\n --u.usahanm, kel.kelurahannm, kec.kecamatannm, \r\n cu.id as cu_id\r\n --, cu.usaha_id \r\n\r\n FROM pad_customer c \r\n INNER JOIN pad_customer_usaha cu ON cu.customer_id=c.id \r\n INNER JOIN pad_usaha u ON u.id=cu.usaha_id \r\n INNER JOIN pad_kecamatan kec ON kec.id = cu.kecamatan_id \r\n INNER JOIN pad_kelurahan kel ON kel.kecamatan_id = cu.kecamatan_id and kel.id = cu.kelurahan_id \r\n\r\n WHERE c.rp = 'P' AND cu.customer_status_id = 1 \r\n AND cu.usaha_id not in ({$pad_reklame_id}, {$pad_airtanah_id})\r\n AND extract(month from cu.created)<extract(month from now())\r\n AND extract(year from cu.created)=extract(year from now())\r\n AND ( \r\n select count(*) \r\n from pad_spt s1 \r\n where s1.customer_usaha_id = cu.id \r\n and extract(month from s1.masadari)= extract(month from now()-interval '1 month')\r\n and extract(year from s1.masadari)= extract(year from now()-interval '1 month')\r\n ) < 1\r\n ";
if ($cu_id != '') {
$qry .= " and cu.id in ({$cu_id}) ";
}
if ($usaha_id != '') {
$qry .= " and cu.usaha_id in ({$usaha_id}) ";
}
$qry .= "ORDER BY cu.usaha_id, c.npwpd desc";
$query = $this->db->query($qry);
if ($query->num_rows() !== 0) {
return $query->result();
} else {
return FALSE;
}
}
function get_typeahead_nopd($xnopd = NULL, $usaha_id = FALSE)
{
$this->db_pad->select('cu.id, get_nopd(cu.id, true) as nopd, cu.customer_id, cu.usaha_id, customernm, usahanm||\' - \'||cu.notes as usahanm ', false);
$this->db_pad->from('pad_customer_usaha cu');
$this->db_pad->join('pad_customer c', 'c.id=cu.customer_id');
$this->db_pad->join('pad_usaha u', 'u.id=cu.usaha_id');
$this->db_pad->like(array('lower(get_nopd(cu.id, true))' => strtolower($xnopd)), false);
if ($usaha_id) {
$this->db_pad->where(array('u.id' => $usaha_id));
} else {
$this->db_pad->where_not_in('u.id', array(pad_reklame_id(), pad_air_tanah_id()));
}
$this->db_pad->order_by('nopd');
$query = $this->db_pad->get();
if ($query->num_rows() !== 0) {
return $query->result();
} else {
return FALSE;
}
}
function get_typeahead_nopd($xnopd = NULL, $usaha_id = FALSE, $formatted = true)
{
$formatted = $formatted ? 'true' : 'false';
$this->db->select("cu.id, get_nopd(cu.id, {$formatted}) as nopd, cu.customer_id, cu.usaha_id, c.nama as customernm, u.nama||' - '||cu.notes as usahanm, cu.def_pajak_id ", false);
$this->db->from('pad_customer_usaha cu');
$this->db->join('pad_customer c', 'c.id=cu.customer_id');
$this->db->join('pad_usaha u', 'u.id=cu.usaha_id');
$this->db->like(array("lower(get_nopd(cu.id, {$formatted}))" => strtolower($xnopd)), false);
if ($usaha_id) {
$this->db->where(array('u.id' => $usaha_id));
} else {
$this->db->where_not_in('u.id', array(pad_reklame_id(), pad_air_tanah_id()));
}
$this->db->order_by('nopd');
$query = $this->db->get();
if ($query->num_rows() !== 0) {
return $query->result();
} else {
return FALSE;
}
}
public function update()
{
$this->load_auth();
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$p_usaha_id = $this->uri->segment(4);
$p_type_id = $this->uri->segment(5);
$p_id = $this->uri->segment(6);
//cek tipe dokumen -> cm bisa edit yg self aja
if ($p_type_id != pad_dok_self_id()) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
//cek usaha
if ($p_usaha_id == pad_reklame_id() || $p_usaha_id == pad_air_tanah_id()) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
//cek kohir
//if ($this->sptpd_model->is_kohir_ok($p_id)) {
// $this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
// redirect(active_module_url($this->controller));
//}
if ($this->sptpd_model->is_bayar($p_id)) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
//Validasi Multiple
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/update/{$p_usaha_id}/{$p_type_id}/{$p_id}");
$post_data = $this->fpost($p_usaha_id);
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$update_data = array('customer_id' => $input_post['customer_id'], 'customer_usaha_id' => $input_post['customer_usaha_id'], 'pajak_id' => $input_post['pajak_id'], 'tahun' => date('Y', strtotime($input_post['terimatgl'])), 'bulan' => date('m', strtotime($input_post['terimatgl'])), 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'type_id' => $input_post['type_id'], 'so' => $input_post['so'], 'jatuhtempotgl' => date('Y-m-d', strtotime($input_post['jatuhtempotgl'])), 'masadari' => date('Y-m-d', strtotime($input_post['masadari'])), 'masasd' => date('Y-m-d', strtotime($input_post['masasd'])), 'minimal_omset' => $input_post['minimal_omset'], 'dasar' => $input_post['dasar'], 'tarif' => $input_post['tarif'], 'denda' => $input_post['denda'], 'bunga' => $input_post['bunga'], 'setoran' => $input_post['setoran'], 'kenaikan' => $input_post['kenaikan'], 'kompensasi' => $input_post['kompensasi'], 'lain2' => $input_post['lain2'], 'cara_bayar' => $input_post['cara_bayar'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id(), 'omset1' => $input_post['omset1'], 'omset6' => $input_post['omset6'], 'omset2' => $input_post['omset2'], 'omset7' => $input_post['omset7'], 'omset3' => $input_post['omset3'], 'omset8' => $input_post['omset8'], 'omset4' => $input_post['omset4'], 'omset9' => $input_post['omset9'], 'omset5' => $input_post['omset5'], 'omset10' => $input_post['omset10'], 'omset11' => $input_post['omset11'], 'omset16' => $input_post['omset16'], 'omset12' => $input_post['omset12'], 'omset17' => $input_post['omset17'], 'omset13' => $input_post['omset13'], 'omset18' => $input_post['omset18'], 'omset14' => $input_post['omset14'], 'omset19' => $input_post['omset19'], 'omset15' => $input_post['omset15'], 'omset20' => $input_post['omset20'], 'omset21' => $input_post['omset21'], 'omset26' => $input_post['omset26'], 'omset22' => $input_post['omset22'], 'omset27' => $input_post['omset27'], 'omset23' => $input_post['omset23'], 'omset28' => $input_post['omset28'], 'omset24' => $input_post['omset24'], 'omset29' => $input_post['omset29'], 'omset25' => $input_post['omset25'], 'omset30' => $input_post['omset30'], 'omset31' => $input_post['omset31'], 'omset_lain' => $input_post['omset32'], 'keterangan1' => $input_post['keterangan1'], 'keterangan6' => $input_post['keterangan6'], 'keterangan2' => $input_post['keterangan2'], 'keterangan7' => $input_post['keterangan7'], 'keterangan3' => $input_post['keterangan3'], 'keterangan8' => $input_post['keterangan8'], 'keterangan4' => $input_post['keterangan4'], 'keterangan9' => $input_post['keterangan9'], 'keterangan5' => $input_post['keterangan5'], 'keterangan10' => $input_post['keterangan10'], 'keterangan11' => $input_post['keterangan11'], 'keterangan16' => $input_post['keterangan16'], 'keterangan12' => $input_post['keterangan12'], 'keterangan17' => $input_post['keterangan17'], 'keterangan13' => $input_post['keterangan13'], 'keterangan18' => $input_post['keterangan18'], 'keterangan14' => $input_post['keterangan14'], 'keterangan19' => $input_post['keterangan19'], 'keterangan15' => $input_post['keterangan15'], 'keterangan20' => $input_post['keterangan20'], 'keterangan21' => $input_post['keterangan21'], 'keterangan26' => $input_post['keterangan26'], 'keterangan22' => $input_post['keterangan22'], 'keterangan27' => $input_post['keterangan27'], 'keterangan23' => $input_post['keterangan23'], 'keterangan28' => $input_post['keterangan28'], 'keterangan24' => $input_post['keterangan24'], 'keterangan29' => $input_post['keterangan29'], 'keterangan25' => $input_post['keterangan25'], 'keterangan30' => $input_post['keterangan30'], 'keterangan31' => $input_post['keterangan31'], 'keterangan_lain' => $input_post['keterangan32']);
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
//
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
//
}
// data tambahan
$tambahan_data = array();
if (wp_login()) {
//
}
// Validasi Duplikasi Masa Pajak
if ($this->session->userdata("mode") == "edit") {
if ($input_post['multiple'] == 0) {
$lastinput = date('Y-m-d', strtotime($input_post['masadari']));
$customer_usaha_id = $input_post['customer_usaha_id'];
$pajak_id = $input_post['pajak_id'];
$rekening_id = $input_post['rekening_id'];
$type_id = $input_post['type_id'];
$cekduplikat = $this->sptpd_model->is_multiple($customer_usaha_id, $pajak_id, $type_id, $rekening_id, $lastinput);
if ($cekduplikat == true) {
$this->session->set_flashdata('msg_warning', 'Pajak dengan Masa Pajak Tersebut Sudah Ada, Harap Cek Data-data Sebelumnya');
redirect(active_module_url($this->controller));
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$this->sptpd_model->update($p_id, $update_data);
}
} else {
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$this->sptpd_model->update($p_id, $update_data);
}
}
// data tambahan / detail
if (wp_login()) {
//
// uplod dokeumen
$this->unggah($p_id);
}
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge"';
$data['select_usaha'] = form_dropdown('customer_usaha_id', $options, null, $js);
$select_data = $this->load->model('pajak_model')->get_select($get->pajak_id);
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->nama;
}
$js = 'id="pajak_id" class="input-xxlarge"';
$data['select_pajak'] = form_dropdown('pajak_id', $options, $get->pajak_id, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->typenm;
}
$js = 'id="type_id" class="input-small" onChange="void(0);"';
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $get->type_id, $js);
$pajak_detail = $this->load->model('pad_model');
if ($row = $pajak_detail->sptpd_get_pajak_detail($get->pajak_id, $get->terimatgl)) {
$data['dt']['rekening_id'] = $row->rekening_id;
$data['dt']['kode'] = $row->kode;
$data['dt']['jatuhtempo'] = $row->jatuhtempo;
$data['dt']['multiple'] = $row->multiple;
}
if (wp_login()) {
$this->load->helper('directory');
$dir = directory_map(dirname(__FILE__) . '//..//dokumen//');
$files = array();
foreach ($dir as $file) {
$f = explode('@', $file);
if ($f[0] == $p_id) {
$files[] = anchor(active_module_url("sptpd/unduh/{$file}"), $f[1], array("title" => "Unduh file {$f['1']}", "target" => "_blank"));
}
}
$data['dt']['files'] = $files;
}
if ($p_usaha_id == pad_reklame_id()) {
//
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
//
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
public function update()
{
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url('sptpd'));
}
$p_usaha_id = $this->uri->segment(4);
$p_type_id = $this->uri->segment(5);
$p_id = $this->uri->segment(6);
$data['current'] = 'pendataan';
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("sptpd/update/{$p_usaha_id}/{$p_type_id}/{$p_id}");
$post_data = $this->fpost($p_usaha_id);
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$update_data = array('customer_id' => $input_post['customer_id'], 'customer_usaha_id' => $input_post['customer_usaha_id'], 'pajak_id' => $input_post['pajak_id'], 'tahun' => $input_post['tahun'], 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'type_id' => $input_post['type_id'], 'so' => $input_post['so'], 'jatuhtempotgl' => date('Y-m-d', strtotime($input_post['jatuhtempotgl'])), 'masadari' => date('Y-m-d', strtotime($input_post['masadari'])), 'masasd' => date('Y-m-d', strtotime($input_post['masasd'])), 'minimal_omset' => $input_post['minimal_omset'], 'dasar' => $input_post['dasar'], 'tarif' => $input_post['tarif'], 'denda' => $input_post['denda'], 'bunga' => $input_post['bunga'], 'setoran' => $input_post['setoran'], 'kenaikan' => $input_post['kenaikan'], 'kompensasi' => $input_post['kompensasi'], 'lain2' => $input_post['lain2'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'updated' => date('Y-m-d'), 'update_uid' => sipkd_user_id());
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
$input_post = $post_data;
$reklame_data = array('r_nsrno' => $input_post['r_nsrno'], 'r_nsrtgl' => empty($input_post['r_nsrtgl']) ? NULL : date('Y-m-d', strtotime($input_post['r_nsrtgl'])), 'r_tarifid' => $input_post['r_tarifid'], 'r_kontrak' => $input_post['r_kontrak'], 'r_lama' => $input_post['r_lama'], 'r_jalanklas_id' => $input_post['r_jalanklas_id'], 'r_jalan_id' => $input_post['r_jalan_id'], 'r_lokasi' => $input_post['r_lokasi'], 'r_judul' => $input_post['r_judul'], 'r_panjang' => $input_post['r_panjang'], 'r_lebar' => $input_post['r_lebar'], 'r_muka' => $input_post['r_muka'], 'r_banyak' => $input_post['r_banyak'], 'r_luas' => $input_post['r_luas'], 'r_lokasi_id' => $input_post['r_lokasi_id'], 'r_calculated' => $input_post['r_calculated']);
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
$input_post = $post_data;
$air_tanah_data = array('air_manfaat_id' => $input_post['air_manfaat_id'], 'air_zona_id' => $input_post['air_zona_id'], 'meteran_awal' => $input_post['meteran_awal'], 'meteran_akhir' => $input_post['meteran_akhir'], 'volume' => $input_post['volume'], 'satuan' => 'M3');
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$this->sptpd_model->update($p_id, $update_data);
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url('sptpd'));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$options = array();
$js = 'id="usaha_id" class="input-xlarge"';
$data['select_usaha'] = form_dropdown('usaha_id', $options, null, $js);
$select_data = $this->load->model('pajak_model')->get_select($get->pajak_id);
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->nama;
}
$js = 'id="pajak_id" class="input-xxlarge"';
$data['select_pajak'] = form_dropdown('pajak_id', $options, $get->pajak_id, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->typenm;
}
$js = 'id="type_id" class="input-small" onChange="void(0);"';
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $get->type_id, $js);
$pajak_detail = $this->load->model('pad_model');
if ($row = $pajak_detail->sptpd_get_pajak_detail($get->pajak_id, $get->terimatgl)) {
$data['dt']['rekening_id'] = $row->rekening_id;
$data['dt']['rekeningkd'] = $row->rekeningkd;
$data['dt']['jatuhtempo'] = $row->jatuhtempo;
}
if ($p_usaha_id == pad_reklame_id()) {
$select_data = $this->load->model('jalan_kelas_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->kelasnm;
}
$js = 'id="r_jalanklas_id" class="input-xlarge" required ';
$data['select_jalan_kelas'] = form_dropdown('r_jalanklas_id', $options, $get->r_jalanklas_id, $js);
$select_data = $this->load->model('jalan_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="r_jalan_id" class="input-xlarge" required ';
$data['select_jalan'] = form_dropdown('r_jalan_id', $options, $get->r_jalan_id, $js);
$select_data = $this->load->model('kecamatan_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->kecamatannm;
}
$js = 'id="r_lokasi_id" class="input-medium" required ';
$data['select_lokasi'] = form_dropdown('r_lokasi_id', $options, $get->r_lokasi_id, $js);
$options = array(1 => 'Tidak ada', 2 => 'Kenaikan 25%', 3 => 'Pengurangan 25%', 4 => 'Kenaikan 25% & Pengurangan 25%');
$js = 'id="r_tarifid" class="input-large" required ';
$data['select_tarif'] = form_dropdown('r_tarifid', $options, $get->r_tarifid, $js);
$this->load->view('vsptpd_form_reklame', $data);
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
$select_data = $this->load->model('air_zona_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="air_zona_id" class="input-medium" required ';
$data['select_zona'] = form_dropdown('air_zona_id', $options, $get->air_zona_id, $js);
$select_data = $this->load->model('air_manfaat_model')->get_select();
$options = array();
foreach ($select_data as $row) {
$options[$row->id] = $row->nama;
}
$js = 'id="air_manfaat_id" class="input-medium" required ';
$data['select_manfaat'] = form_dropdown('air_manfaat_id', $options, $get->air_manfaat_id, $js);
$this->load->view('vsptpd_form_at', $data);
} else {
$this->load->view('vsptpd_form', $data);
}
}
}
:
</label>
<label class="control-label col-sm-8" id="pajak_view">
</label>
<label class="control-label col-sm-3" for="cara_bayar">Cara Bayar </label>
<label class="control-label col-sm-1">
:
</label>
<div class="col-sm-2">
<select class="form-control" style="width:180px" name="cara_bayar" id="cara_bayar">
</select>
<label name="cara_bayar_view" id="cara_bayar_view"></label>
</div>
<?php
if ($this->uri->segment(4) == pad_reklame_id() || $this->uri->segment(4) == pad_air_tanah_id() || $this->uri->segment(3) == 'kb' || $this->uri->segment(3) == 'kbt') {
?>
<style>
.content {
min-height: 300px;
}
</style>
<div class="col-sm-12">
</div>
<label class="control-label col-sm-3" for="petugas_id" id="petugas_id_lbl">Petugas Penetap</label>
<label class="control-label col-sm-1" id="petugas_id_lbl2">
:
</label>
<div class="col-sm-2">
<?php
echo $select_petugas;
public function update()
{
$this->load_auth();
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$p_usaha_id = $this->uri->segment(4);
$p_type_id = $this->uri->segment(5);
$p_id = $this->uri->segment(6);
//cek kohir
if ($this->sptpd_model->is_kohir_ok($p_id) && !is_super_admin()) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
// cek pmb
// kalau user sa boleh edit. 17-10-2014 (AA)
if (($this->sptpd_model->is_sspd_ok($p_id) || $this->sptpd_model->is_bayar_ok($p_id)) && !is_super_admin()) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/update/{$p_usaha_id}/{$p_type_id}/{$p_id}");
$post_data = $this->fpost($p_usaha_id);
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
//cek nama wp - kalo beda update nama
/*
$wp_data = $this->load->model('subjek_pajak_model')->get($input_post['customer_id']);
$wp_nama = $wp_data->nama;
$cid = $input_post['customer_id'];
if($wp_nama != $input_post['nama']) {
$this->load->model('subjek_pajak_model')->rename_wp($cid, $input_post['nama']);
}
*/
$update_data = array('customer_id' => $input_post['customer_id'], 'customer_usaha_id' => $input_post['customer_usaha_id'], 'pajak_id' => $input_post['pajak_id'], 'tahun' => date('Y', strtotime($input_post['terimatgl'])), 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'type_id' => $input_post['type_id'], 'so' => $input_post['so'], 'jatuhtempotgl' => date('Y-m-d', strtotime($input_post['jatuhtempotgl'])), 'masadari' => date('Y-m-d', strtotime($input_post['masadari'])), 'masasd' => date('Y-m-d', strtotime($input_post['masasd'])), 'minomset' => $input_post['minomset'], 'dasar' => $input_post['dasar'], 'tarif' => $input_post['tarif'], 'denda' => $input_post['denda'], 'bunga' => $input_post['bunga'], 'setoran' => $input_post['setoran'], 'kenaikan' => $input_post['kenaikan'], 'kompensasi' => $input_post['kompensasi'], 'lain2' => $input_post['lain2'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'write_date' => date('Y-m-d'), 'write_uid' => sipkd_user_id());
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
$input_post = $post_data;
$reklame_data = array('r_nsrno' => $input_post['r_nsrno'], 'r_nsrtgl' => empty($input_post['r_nsrtgl']) ? NULL : date('Y-m-d', strtotime($input_post['r_nsrtgl'])), 'r_tarifid' => $input_post['r_tarifid'], 'r_kontrak' => $input_post['r_kontrak'], 'r_lama' => $input_post['r_lama'], 'r_jalanklas_id' => $input_post['r_jalanklas_id'], 'r_jalan_id' => $input_post['r_jalan_id'], 'r_lokasi' => $input_post['r_lokasi'], 'r_judul' => $input_post['r_judul'], 'r_panjang' => $input_post['r_panjang'], 'r_lebar' => $input_post['r_lebar'], 'r_muka' => $input_post['r_muka'], 'r_banyak' => $input_post['r_banyak'], 'r_luas' => $input_post['r_luas'], 'r_lokasi_id' => $input_post['r_lokasi_id'], 'r_calculated' => $input_post['r_calculated'], 'r_nsr_id' => $input_post['r_nsr_id'], 'r_lokasi_pasang_id' => $input_post['r_lokasi_pasang_id'], 'r_lokasi_pasang_val' => $input_post['r_lokasi_pasang_val'], 'r_jalanklas_val' => $input_post['r_jalanklas_val'], 'r_sudut_pandang_id' => $input_post['r_sudut_pandang_id'], 'r_sudut_pandang_val' => $input_post['r_sudut_pandang_val'], 'r_tinggi' => $input_post['r_tinggi'], 'r_njop' => $input_post['r_njop'], 'r_status' => $input_post['r_status'], 'r_nama' => $input_post['nama']);
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
$input_post = $post_data;
$air_tanah_data = array('volume' => $input_post['volume'], 'satuan' => 'M3');
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data);
$this->sptpd_model->update($p_id, $update_data);
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge"';
$data['select_usaha'] = form_dropdown('customer_usaha_id', $options, null, $js);
$select_data = $this->load->model('pad_model')->sptpd_get_pajak($p_usaha_id);
$options = array();
if ($select_data) {
foreach ($select_data as $rows) {
if ($p_usaha_id == pad_reklame_id()) {
$options[$rows->id] = $rows->nama . " = " . number_format($rows->reklame, 0, ',', '.');
} else {
$options[$rows->id] = $rows->nama;
}
}
}
$js = 'id="pajak_id" class="input-xxlarge"';
$data['select_pajak'] = form_dropdown('pajak_id', $options, $get->pajak_id, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->typenm;
}
}
$js = 'id="type_id" class="input-small" onChange="void(0);"';
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $get->type_id, $js);
$pajak_detail = $this->load->model('pad_model');
if ($row = $pajak_detail->sptpd_get_pajak_detail($get->pajak_id, $get->terimatgl)) {
$data['dt']['rekening_id'] = $row->rekening_id;
$data['dt']['rekeningkd'] = $row->rekeningkd;
$data['dt']['jatuhtempo'] = $row->jatuhtempo;
} else {
$data['dt']['rekeningkd'] = '';
$data['dt']['jatuhtempo'] = '';
}
if ($p_usaha_id == pad_reklame_id()) {
//-new
$select_data = $this->load->model('reklame_nilai_strategis_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->nsrnm;
}
}
$js = 'id="r_nsr_id" class="input-xlarge" required ';
$data['select_nsr'] = form_dropdown('r_nsr_id', $options, $get->r_nsr_id, $js);
$select_data = $this->load->model('rek_lokasi_pasang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->lokasinm;
}
}
$js = 'id="r_lokasi_pasang_id" class="input-xlarge" required ';
$data['select_lokasi_pasang'] = form_dropdown('r_lokasi_pasang_id', $options, $get->r_lokasi_pasang_id, $js);
$select_data = $this->load->model('rek_sudut_pandang_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->sudutnm;
}
}
$js = 'id="r_sudut_pandang_id" class="input-xlarge" required ';
$data['select_sudut_pandang'] = form_dropdown('r_sudut_pandang_id', $options, $get->r_sudut_pandang_id, $js);
$options = array('Pasang Baru' => 'Pasang Baru', 'Perpanjangan' => 'Perpanjangan');
$js = 'id="r_status" class="input-large" required ';
$data['select_status'] = form_dropdown('r_status', $options, $get->r_status, $js);
//-end-new
$select_data = $this->load->model('jalan_klas_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->kelasnm;
}
}
$js = 'id="r_jalanklas_id" class="input-xlarge" required ';
$data['select_jalan_klas'] = form_dropdown('r_jalanklas_id', $options, $get->r_jalanklas_id, $js);
$select_data = $this->load->model('jalan_model')->get_select();
$options = array();
if ($select_data) {
$options[] = "# KOSONG #";
foreach ($select_data as $row) {
$options[$row->id] = $row->jalannm;
}
}
$js = 'id="r_jalan_id" class="input-large combobox" ';
$data['select_jalan'] = form_dropdown('r_jalan_id', $options, $get->r_jalan_id, $js);
$select_data = $this->load->model('kecamatan_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->kecamatannm;
}
}
$js = 'id="r_lokasi_id" class="input-medium" required ';
$data['select_lokasi'] = form_dropdown('r_lokasi_id', $options, $get->r_lokasi_id, $js);
$options = array(1 => 'Tidak ada', 2 => 'Produk Rokok +25%', 3 => 'Reklame Pendidikan -25%', 4 => 'Kenaikan 25% & Pengurangan 25%');
$js = 'id="r_tarifid" class="input-large" required ';
$data['select_tarif'] = form_dropdown('r_tarifid', $options, $get->r_tarifid, $js);
if (!wp_login()) {
$this->load->view('vsptpd_form_reklame', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form_reklame', $data);
}
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
$select_data = $this->load->model('air_zona_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->zonanm;
}
}
$js = 'id="air_zona_id" class="input-medium" required ';
$data['select_zona'] = form_dropdown('air_zona_id', $options, $get->air_zona_id, $js);
$select_data = $this->load->model('air_manfaat_model')->get_select();
$options = array();
if ($select_data) {
foreach ($select_data as $row) {
$options[$row->id] = $row->manfaatnm;
}
}
$js = 'id="air_manfaat_id" class="input-medium" required ';
$data['select_manfaat'] = form_dropdown('air_manfaat_id', $options, $get->air_manfaat_id, $js);
if (!wp_login()) {
$this->load->view('vsptpd_form_at', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form_at', $data);
}
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
$(document).ready(function() {
$('#btn_sptpd').click(function() {
window.location = '<?php
echo active_module_url('sptpd/add');
?>
';
});
$('#btn_sptpd_rek').click(function() {
window.location = '<?php
echo active_module_url('sptpd/add/' . pad_reklame_id());
?>
';
});
$('#btn_sptpd_air').click(function() {
window.location = '<?php
echo active_module_url('sptpd/add/' . pad_air_tanah_id());
?>
';
});
});
</script>
<div class="content">
<div class="container-fluid">
<?php
echo msg_block();
?>
<p> </p>
<p>Selamat datang di SPTPD Online, <strong><?php
echo wp_nm();
?>
$('#add_reklame').click(function() {
window.location = '<?php
echo active_module_url($controller);
?>
add/<?php
echo pad_reklame_id();
?>
';
});
$('#add_at').click(function() {
window.location = '<?php
echo active_module_url($controller);
?>
add/<?php
echo pad_air_tanah_id();
?>
';
});
$('#btn_edit').click(function() {
if(mID) {
window.location = '<?php
echo active_module_url($controller);
?>
edit/'+uID+'/'+tID+'/'+mID;
}else{
alert('Silahkan pilih data yang akan diedit');
}
});
"sInfoEmpty": "Menampilkan 0 sampai 0 dari 0 entri",
"sInfoFiltered": "(disaring dari _MAX_ entri keseluruhan)",
"sInfoPostFix": "",
"sSearch": "Cari : ",
"sUrl": "",
"oPaginate": {
"sFirst": "«",
"sPrevious": "‹",
"sNext": "›",
"sLast": "»",
}
},
"bProcessing": true,
"bServerSide": true,
"sAjaxSource": "<?php
echo active_module_url('subjek_pajak/grid_for_spt/' . pad_air_tanah_id());
?>
"
});
$('#btn_cancel').click(function() {
window.location = '<?php
echo active_module_url($this->uri->segment(2));
?>
';
});
$('#btn_dialog_ok').click(function() {
if (mID == '' || mID == null)
alert('Data belum dipilih.');
else {
public function update()
{
$this->load_auth();
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$p_usaha_id = $this->uri->segment(4);
$p_type_id = $this->uri->segment(5);
$p_id = $this->uri->segment(6);
//cek usaha -> cm bisa edit yg self aja
if ($p_usaha_id == pad_reklame_id() || $p_usaha_id == pad_air_tanah_id()) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
//cek kohir
if ($this->sptpd_model->is_kohir_ok($p_id)) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
// cek pmb
if ($this->sptpd_model->is_sspd_ok($p_id) || $this->sptpd_model->is_bayar_ok($p_id)) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$data['current'] = $this->module;
$data['apps'] = $this->apps_model->get_active_only();
$data['faction'] = active_module_url("{$this->controller}/update/{$p_usaha_id}/{$p_type_id}/{$p_id}");
$post_data = $this->fpost($p_usaha_id);
$this->fvalidation();
if ($this->form_validation->run() == TRUE) {
$input_post = $post_data;
$update_data = array('customer_id' => $input_post['customer_id'], 'customer_usaha_id' => $input_post['customer_usaha_id'], 'pajak_id' => $input_post['pajak_id'], 'tahun' => $input_post['tahun'], 'terimatgl' => date('Y-m-d', strtotime($input_post['terimatgl'])), 'type_id' => $input_post['type_id'], 'so' => $input_post['so'], 'jatuhtempotgl' => date('Y-m-d', strtotime($input_post['jatuhtempotgl'])), 'masadari' => date('Y-m-d', strtotime($input_post['masadari'])), 'masasd' => date('Y-m-d', strtotime($input_post['masasd'])), 'minomset' => $input_post['minomset'], 'dasar' => $input_post['dasar'], 'tarif' => $input_post['tarif'], 'denda' => $input_post['denda'], 'bunga' => $input_post['bunga'], 'setoran' => $input_post['setoran'], 'kenaikan' => $input_post['kenaikan'], 'kompensasi' => $input_post['kompensasi'], 'lain2' => $input_post['lain2'], 'pajak_terhutang' => $input_post['pajak'], 'r_bayarid' => $input_post['r_bayarid'], 'r_nsr' => $input_post['r_nsr'], 'rekening_id' => $input_post['rekening_id'], 'write_date' => date('Y-m-d'), 'write_uid' => sipkd_user_id());
$reklame_data = array();
if ($p_usaha_id == pad_reklame_id()) {
//
}
$air_tanah_data = array();
if ($p_usaha_id == pad_air_tanah_id()) {
//
}
// data tambahan
$tambahan_data = array();
if (wp_login()) {
//
}
$update_data = array_merge($update_data, $reklame_data, $air_tanah_data, $tambahan_data);
$this->sptpd_model->update($p_id, $update_data);
// data tambahan / detail
if (wp_login()) {
//
// uplod dokeumen
$this->unggah($p_id);
}
$this->session->set_flashdata('msg_success', 'Data telah disimpan');
redirect(active_module_url($this->controller));
}
$data['dt'] = $post_data;
$get = (object) $post_data;
$options = array();
$js = 'id="customer_usaha_id" class="input-xlarge"';
$data['select_usaha'] = form_dropdown('customer_usaha_id', $options, null, $js);
$select_data = $this->load->model('pajak_model')->get_select($get->pajak_id);
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->pajaknm;
}
$js = 'id="pajak_id" class="input-xxlarge"';
$data['select_pajak'] = form_dropdown('pajak_id', $options, $get->pajak_id, $js);
$select_data = $this->load->model('sptpd_type_model')->get_select();
$options = array();
foreach ($select_data as $rows) {
$options[$rows->id] = $rows->typenm;
}
$js = 'id="type_id" class="input-small" onChange="void(0);"';
$data['select_sptpd_type'] = form_dropdown('type_id', $options, $get->type_id, $js);
$pajak_detail = $this->load->model('pad_model');
if ($row = $pajak_detail->sptpd_get_pajak_detail($get->pajak_id, $get->terimatgl)) {
$data['dt']['rekening_id'] = $row->rekening_id;
$data['dt']['rekeningkd'] = $row->rekeningkd;
$data['dt']['jatuhtempo'] = $row->jatuhtempo;
}
if (wp_login()) {
$this->load->helper('directory');
$dir = directory_map(dirname(__FILE__) . '//..//dokumen//');
$files = array();
foreach ($dir as $file) {
$f = explode('@', $file);
if ($f[0] == $p_id) {
$files[] = anchor(active_module_url("sptpd/unduh/{$file}"), $f[1], array("title" => "Unduh file {$f['1']}", "target" => "_blank"));
}
}
$data['dt']['files'] = $files;
}
if ($p_usaha_id == pad_reklame_id()) {
//
} else {
if ($p_usaha_id == pad_air_tanah_id()) {
//
} else {
if (!wp_login()) {
$this->load->view('vsptpd_form', $data);
} else {
$data['dt']['customer_id'] = wp_id();
$this->load->view('wp/vsptpd_form', $data);
}
}
}
}
function grid()
{
$usaha_id = $this->uri->segment(4);
$proses_id = $this->uri->segment(5);
// on skpdj
$this->load->library('Datatables');
if ($proses_id != 2) {
$this->datatables->select("cu.id as cu_id, get_npwpd(c.id, true) as npwpd, upper(c.nama) as nama,cu.opnm, \r\n (case when c.wpnama='' then c.pnama else c.wpnama end) as namawp, c.alamat, \r\n u.nama as usahanm, \r\n coalesce((select max(dasar) from pad_spt where customer_usaha_id=cu.id),0) as max_omset,\r\n kel.nama as kelnm, kec.nama as kecnm, c.id as c_id, cu.usaha_id", false);
$this->datatables->from('pad_customer c');
$this->datatables->join('pad_customer_usaha cu', 'cu.customer_id=c.id');
$this->datatables->join('pad_usaha u', 'u.id=cu.usaha_id');
$this->datatables->join('pad_kecamatan kec', 'kec.id = cu.kecamatan_id');
$this->datatables->join('pad_kelurahan kel', 'kel.kecamatan_id = cu.kecamatan_id and kel.id = cu.kelurahan_id');
$this->datatables->join('pad_jenis_pajak jp', 'jp.id = cu.def_pajak_id');
//kata pa wawan jgn catering ditampilkan
$this->datatables->where('c.rp', 'P');
$this->datatables->where('cu.customer_status_id', 1);
//$this->datatables->where('sp.proses', 1);
$pad_reklame_id = pad_reklame_id();
$pad_airtanah_id = pad_air_tanah_id();
$pad_ppj_id = 5;
$this->datatables->where("cu.usaha_id not in ({$pad_reklame_id},{$pad_ppj_id})");
$this->datatables->where("cu.def_pajak_id not in (64)");
//kata pa wawan jgn catering ditampilkan
//$this->datatables->where("extract(month from cu.created)<extract(month from now())");
//$this->datatables->where("extract(year from cu.created)=extract(year from now())");
$this->datatables->where("(\r\n select count(*)\r\n from pad.pad_spt s1\r\n where s1.customer_usaha_id = cu.id\r\n and extract(month from s1.masadari)=extract(month from now()-interval '1 month')\r\n and extract(year from s1.masadari)=extract(year from now()-interval '1 month')\r\n ) < 1");
if ($usaha_id != 999 && !empty($usaha_id)) {
$this->datatables->filter('cu.usaha_id', $usaha_id);
}
$sort = $this->input->get('sSortDir_0');
if ($this->input->get('iSortCol_0') == 1) {
$this->datatables->order_by('npwpd', $sort);
}
} else {
$skpdj_type_id = '3';
// <--------- id default
$skpdj_type = $this->db->query("select id from pad_spt_type where typenm ilike '%skpdj%' limit 1");
if ($skpdj_type->num_rows() !== 0) {
$skpdj_type_id = $skpdj_type->row()->id;
}
$this->datatables->select("s.id as spt_id, get_npwpd(c.id, true) as npwpd, upper(c.nama) as nama, \r\n (case when c.wpnama='' then c.pnama else c.wpnama end) as nama, c.alamat, \r\n u.nama, \r\n coalesce((select max(dasar) from pad_spt where customer_usaha_id=cu.id),0) as max_omset,\r\n c.id as c_id, cu.usaha_id", false);
$this->datatables->from('pad_spt s');
$this->datatables->join('pad_kohir k', 'k.spt_id=s.id');
$this->datatables->join('pad_customer_usaha cu', 'cu.id=s.customer_usaha_id');
$this->datatables->join('pad_customer c', 'cu.customer_id=c.id');
$this->datatables->join('pad_usaha u', 'u.id=cu.usaha_id');
$this->datatables->where('c.rp', 'P');
$this->datatables->where('cu.customer_status_id', 1);
$pad_reklame_id = pad_reklame_id();
$pad_airtanah_id = pad_air_tanah_id();
$this->datatables->where("cu.usaha_id not in ({$pad_reklame_id}, {$pad_airtanah_id})");
$this->datatables->where("extract(month from s.masadari)=extract(month from now()-interval '1 month')");
$this->datatables->where("extract(year from s.masadari)=extract(year from now()-interval '1 month')");
$this->datatables->where("s.type_id", $skpdj_type_id);
if ($usaha_id != 999 && !empty($usaha_id)) {
$this->datatables->filter('cu.usaha_id', $usaha_id);
}
$sort = $this->input->get('sSortDir_0');
if ($this->input->get('iSortCol_0') == 1) {
$this->datatables->order_by('npwpd', $sort);
}
}
$this->datatables->rupiah_column('7');
echo $this->datatables->generate();
}
function cetak()
{
$type = $this->uri->segment(4);
$qs = urldecode($_SERVER['QUERY_STRING']);
parse_str($qs, $qs_data);
$params = array();
// foreach ($qs_data as $key => $val)
// $params[$key] = $val;
$kondisi = $this->input->get('kondisi');
if (!empty($kondisi)) {
$kondisi = 'and s.type_id=' . $this->input->get('kondisi');
}
$rpt = $this->input->get('rpt');
$tglawal = date('Y-m-d', strtotime($this->input->get('tglawal')));
$tglakhir = date('Y-m-d', strtotime($this->input->get('tglakhir')));
$tglawalbayar = date('Y-m-d', strtotime($this->input->get('tglawalbayar')));
$tglakhirbayar = date('Y-m-d', strtotime($this->input->get('tglakhirbayar')));
$tglcetak = date('Y-m-d', strtotime($this->input->get('tglcetak')));
$ignore_html_pg = TRUE;
switch ($rpt) {
case 'tap_register':
case 'tap_register_airtanah':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali':
case 'tap_kendali_blm_bayar':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_self':
case 'tap_kendali_self_sdh_bayar':
// $kondisi = ' and s.type_id='.pad_dok_self_id();
$kondisi = ' and cd.usaha_id not in(' . pad_reklame_id() . ',' . pad_air_tanah_id() . ') ';
$kondisi .= " and date(s.terimatgl) between '{$tglawal}' and '{$tglakhir}' ";
$kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' ";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar);
break;
case 'tap_kendali_blm_bayar_self':
// $kondisi = 'and s.type_id='.pad_dok_self_id();
$kondisi = ' and cd.usaha_id not in(' . pad_reklame_id() . ',' . pad_air_tanah_id() . ') ';
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_airtanah':
case 'tap_kendali_airtanah_sdh_bayar':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$kondisi .= " and date(k.kohirtgl) between '{$tglawal}' and '{$tglakhir}' ";
$kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' ";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar);
break;
case 'tap_kendali_airtanah_blm_bayar':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_register_reklame':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$naskah = trim($this->input->get('naskah'));
$kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_register_reklame_jthtempo':
$type_id = intval($this->input->get('type_id'));
if ($type_id > 0) {
$kondisi = 'and s.type_id=' . $type_id;
} else {
$kondisi = '';
}
$naskah = trim($this->input->get('naskah'));
$kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_reklame':
case 'tap_kendali_reklame_sdh_bayar':
$insidentil = intval($this->input->get('insidentil'));
$type_id = intval($this->input->get('type_id'));
$kondisi = '';
if ($insidentil > -1) {
$kondisi .= ' and r.insidentil=' . $insidentil;
}
if ($type_id > 0) {
$kondisi .= ' and s.type_id=' . $type_id;
}
$naskah = trim($this->input->get('naskah'));
$kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$kondisi .= " and date(k.kohirtgl) between '{$tglawal}' and '{$tglakhir}' ";
$kondisi_bayar = " and date(ss.sspdtgl) between '{$tglawalbayar}' and '{$tglakhirbayar}' ";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi, 'kondisi_bayar' => $kondisi_bayar);
// print_r($kondisi_bayar);exit;
break;
case 'tap_kendali_reklame_blm_bayar':
$insidentil = intval($this->input->get('insidentil'));
$type_id = intval($this->input->get('type_id'));
$kondisi = '';
if ($insidentil > -1) {
$kondisi .= ' and r.insidentil=' . $insidentil;
}
if ($type_id > 0) {
$kondisi .= ' and s.type_id=' . $type_id;
}
$naskah = trim($this->input->get('naskah'));
$kondisi .= $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_reklame_jthtempo_tgl':
$naskah = trim($this->input->get('naskah'));
$kondisi = $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_reklame_jthtempo':
$naskah = trim($this->input->get('naskah'));
$kondisi = $naskah != "" ? " and s.r_judul ilike '%{$naskah}%' " : "";
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'kondisi' => $kondisi);
break;
case 'tap_kendali_reklame_jthtempo_rek':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))), 'rekeningid' => (int) $this->input->get('rekeningid'));
break;
case 'tap_kendali_airtanah':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'bulan' => (int) $this->input->get('bulan'), 'tahun' => (int) $this->input->get('tahun'));
break;
case 'tap_kendali_airtanah_skpd':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))));
break;
case 'tap_kendali_airtanah_tgl':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))));
break;
case 'tap_kendali_airtanah_masa':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tglawal' => date('Y-m-d', strtotime($this->input->get('tglawal'))), 'tglakhir' => date('Y-m-d', strtotime($this->input->get('tglakhir'))));
break;
case 'tap_catat_vol_airtanah':
$params = array('tglcetak' => date('Y-m-d', strtotime($this->input->get('tglcetak'))), 'tahun' => (int) $this->input->get('tahun'));
break;
}
$tambahan = array("daerah" => pad_pemda_daerah());
$params = array_merge($params, $tambahan);
$ignore_html_pg = false;
//paging aja semua
$rpt = 'penetapan/' . $rpt;
// var_dump($params);
// die;
$jasper = $this->load->library('Jasper');
if ($type == 'pdf') {
echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg);
} else {
if ($type == 'html') {
$assetpath = 'assets/file';
$tmp = $assetpath . '/tmp/report' . sipkd_user_id() . '.html';
if (is_file($tmp)) {
unlink($tmp);
}
ob_start();
echo $jasper->cetak($rpt, $params, $type, $ignore_html_pg);
echo '1';
file_put_contents($tmp, ob_get_contents());
$objPHPExcel = new PHPExcel();
$inputFileType = 'HTML';
$inputFileName = $tmp;
$outputFileType = 'Excel2007';
$outputFileName = $assetpath . '/Report.xls';
$filename = $rpt . date("d-m-Y") . ".xls";
$objPHPExcelReader = IOFactory::createReader($inputFileType);
$objPHPExcel = $objPHPExcelReader->load($inputFileName);
ini_set('zlib.output_compression', 'Off');
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
//the folowing two lines make sure it is saved as a xls file
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename=' . $filename);
//simpan dalam file sample.xls
$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
}
}
// echo $jasper->query_debug($rpt, $params);
}
public function proces_validasi()
{
$this->load_auth();
if (!$this->module_auth->update) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url($this->controller));
}
$controller = 'sptpd';
//default
$mode = $this->input->post('mode');
$cara_bayar = $this->input->post('cara_bayar');
$spt_id = $this->input->post('spt_id');
$jatuhtempotgl = $this->input->post('jatuhtempotgl');
$pajak = $this->input->post('pajak');
$source_nama = 'pad_spt';
$p_usaha_id = $this->session->userdata('usaha_id');
$prosestgl_skpd = $this->input->post('prosestgl_skpd');
$petugas_id = $this->input->post('petugas_id');
$pejabat_id = $this->input->post('pejabat_id');
$type_id = $this->input->post('type_ids');
$bulan_telat = $this->input->post('bulan_telat');
$masadari = $this->session->userdata('masadari_temp');
if ($mode == 'proses_skpd') {
$controller = 'skpd';
$this->proses_skpd($p_usaha_id, $spt_id, $prosestgl_skpd, $petugas_id, $pejabat_id, $type_id);
//PROSES SKPD
} else {
if ($mode == 'validate') {
$controller = 'sptpd';
}
}
if ($mode == 'validate' || $mode == 'proses_skpd') {
/*
if ($this->sptpd_model->is_kohir_ok($spt_id)) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
*/
if ($this->sptpd_model->is_bayar($spt_id)) {
$this->session->set_flashdata('msg_warning', $this->module_auth->msg_update);
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
// Validasi
if ($this->sptpd_model->is_validasi_ok($spt_id)) {
$this->session->set_flashdata('msg_warning', 'Data sudah divalidasi sebelumnya');
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
$proses = 2;
//sudah validasi, 1 belum
$tgl = date('Y-m-d h:i:s');
if ($p_usaha_id == pad_air_tanah_id() || $p_usaha_id == pad_reklame_id()) {
$bunga = $this->input->post('denda');
//khusus office bunga dinsert (DENDA)
$query = $this->db->query("update pad_spt \r\n set cara_bayar = {$cara_bayar} , proses = {$proses}, tanggal_validasi = '{$tgl}', denda=0, bunga={$bunga} ,bulan_telat={$bulan_telat} , pajak_terhutang={$pajak} \r\n where id= {$spt_id}");
} else {
$query = $this->db->query("update pad_spt \r\n set cara_bayar = {$cara_bayar} , proses = {$proses}, tanggal_validasi = '{$tgl}' , denda=0, bunga=0 \r\n where id= {$spt_id}");
//khusus self
}
$query = $this->db->query("select s.id as source_id, \r\n s.tahun, u.id as usaha_id, get_invno(s.id) as invoice_no, s.masadari, \r\n u.nama as jenis_usaha, jp.nama as jenis_pajak,\r\n get_npwpd(c.id,true) as npwpd, c.nama as nama_wp, \r\n c.alamat as alamat_wp, cu.opnm as op_nama, cu.opalamat as op_alamat, \r\n s.tahun||lpad(u.id::text, 2, '0')||lpad(get_invno(s.id)::text, 5, '0') as nomor_tagihan,\r\n s.dasar as pokok, s.denda, s.bunga, s.pajak_terhutang as total, 0 as status_bayar,\r\n s.jatuhtempotgl as jatuh_tempo,\r\n extract(year from s.masadari)||lpad(extract(month from s.masadari)::text, 2, '0') periode,\r\n left(get_rekening(r.kode)::text,11) as rekening_pokok, r.nama as nama_pokok,\r\n left(get_rekening(d.kode)::text,11) as rekening_denda, d.nama as nama_denda\r\n from pad_spt s \r\n inner join pad_customer c on c.id=s.customer_id \r\n inner join pad_customer_usaha cu on cu.id=s.customer_usaha_id \r\n inner join pad_usaha u on u.id=cu.usaha_id \r\n inner join pad_jenis_pajak jp on jp.id=s.pajak_id \r\n inner join pad_rekening r on r.id=s.rekening_id\r\n inner join pad_rekening d on d.id=jp.rekdenda_id\r\n where s.id={$spt_id}");
foreach ($query->result() as $row) {
$source_id = $row->source_id;
$tahun = $row->tahun;
$npwpd = $row->npwpd;
$nama_wp = $row->nama_wp;
$alamat_wp = $row->alamat_wp;
$op_nama = $row->op_nama;
$op_alamat = $row->op_alamat;
$rekening_pokok = str_replace(".", "", $row->rekening_pokok);
//rekening pokok
$nama_pokok = $row->nama_pokok;
//nama pokok
$invoice_no = $row->invoice_no;
$usaha_id = $row->usaha_id;
$spt_id = $spt_id;
$jenis_usaha = $row->jenis_usaha;
$jenis_pajak = $row->jenis_pajak;
$nomor_tagihan = $row->nomor_tagihan;
$status_bayar = $row->status_bayar;
$periode = $row->periode;
$rekening_denda = str_replace(".", "", $row->rekening_denda);
$nama_denda = $row->nama_denda;
$jatuh_tempo = $row->jatuh_tempo;
$pokok = $row->pokok;
if ($usaha_id == pad_air_tanah_id() || $usaha_id == pad_reklame_id()) {
$denda = $row->denda;
$bunga = $row->bunga;
if ($usaha_id == pad_reklame_id()) {
$jatuh_tempo = $jatuhtempotgl;
}
$total = $pajak;
} else {
$denda = 0;
$bunga = 0;
$total = $row->total;
}
}
$update_data = array('tahun' => $tahun, 'usaha_id' => $usaha_id, 'invoice_no' => $invoice_no, 'source_id' => $source_id, 'source_nama' => $source_nama, 'jatuh_tempo' => $jatuhtempotgl, 'nomor_tagihan' => $nomor_tagihan, 'jenis_usaha' => $jenis_usaha, 'jenis_pajak' => $jenis_pajak, 'pokok' => $pokok, 'denda' => $denda, 'bunga' => $bunga, 'total' => $total, 'npwpd' => $npwpd, 'nama_wp' => $nama_wp, 'alamat_wp' => $alamat_wp, 'alamat_op' => $op_alamat, 'nama_op' => $op_nama, 'status_bayar' => 0, 'rekening_pokok' => $rekening_pokok, 'rekening_denda' => $rekening_denda, 'periode' => $periode, 'nama_pokok' => $nama_pokok, 'nama_denda' => $nama_denda, 'created' => date('Y-m-d h:i:s'), 'create_uid' => sipkd_user_id());
$save = $this->invoice_model->save($update_data);
if ($query && $save) {
if ($mode == 'proses_skpd' || $mode == 'recall') {
$this->session->set_userdata('rpt_skpd', 1);
$this->session->set_userdata('id_skpd', $spt_id);
$query = $this->db->query("update pad_spt \r\n set jatuhtempotgl = '{$jatuhtempotgl}' where id= {$spt_id}");
} else {
$this->session->set_userdata('rpt_skpd', 0);
}
if ($this->session->userdata('skpd_tipe') == 'SKPDKB') {
$this->session->set_flashdata('msg_success', 'Proses SKPDKB Berhasil');
redirect(active_module_url("{$controller}/kb/{$p_usaha_id}"));
} else {
if ($this->session->userdata('skpd_tipe') == 'SKPDKBT') {
$this->session->set_flashdata('msg_success', 'Proses SKPDKBT Berhasil');
redirect(active_module_url("{$controller}/kbt/{$p_usaha_id}"));
} else {
$this->session->set_flashdata('msg_success', 'Data berhasil divalidasi');
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
}
} else {
if ($this->session->userdata('skpd_tipe') == 'SKPDKB') {
$this->session->set_flashdata('msg_warning', 'Proses SKPDKB Gagal');
redirect(active_module_url("{$controller}/kb/{$p_usaha_id}"));
} else {
if ($this->session->userdata('skpd_tipe') == 'SKPDKBT') {
$this->session->set_flashdata('msg_warning', 'Proses SKPDKBT Gagal');
redirect(active_module_url("{$controller}/kbt/{$p_usaha_id}"));
} else {
$this->session->set_flashdata('msg_warning', 'Data Gagal divalidasi');
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
}
}
}
if ($mode == 'cancel' || $mode == 'recall') {
if ($mode == 'recall') {
$controller = 'skpd';
$newjtp = strtotime('-1 day', strtotime($masadari));
$jatuhtempotgl = date('Y-m-d', $newjtp);
$this->db->query("update pad_spt \r\n set jatuhtempotgl = '{$jatuhtempotgl}' where id= {$spt_id}");
$this->recall_skpd($p_usaha_id, $spt_id);
//PROSES SKPD
} else {
if ($mode == 'cancel') {
$controller = 'sptpd';
}
}
$proses = 1;
//batalkan validasi
$updated = date('Y-m-d h:i:s');
$update_uid = sipkd_user_id();
if ($p_usaha_id == pad_reklame_id()) {
$query = $this->db->query("select pajak_terhutang, bunga from pad_spt where id={$spt_id}");
foreach ($query->result() as $row) {
$pajak_terhutang = $row->pajak_terhutang;
$bunga = $row->bunga;
}
$pajak = $pajak_terhutang - $bunga;
$query = $this->db->query("update pad_spt \r\n set cara_bayar = {$cara_bayar} , proses = {$proses}, pajak_terhutang={$pajak} , bunga=0, \r\n updated = '{$updated}', update_uid = {$update_uid} \r\n where id= {$spt_id}");
} else {
$query = $this->db->query("update pad_spt \r\n set cara_bayar = {$cara_bayar} , proses = {$proses}, \r\n updated = '{$updated}', update_uid = {$update_uid} \r\n where id= {$spt_id}");
}
$query_delete = $this->db->query("delete from pad_invoice \r\n where source_id={$spt_id} and source_nama='{$source_nama}'");
if ($query && $query_delete) {
$this->session->set_userdata('rpt_skpd', 0);
if ($this->session->userdata('skpd_tipe') == 'SKPDKB') {
$this->session->set_flashdata('msg_success', 'Recall Berhasil');
redirect(active_module_url("{$controller}/kb/{$p_usaha_id}"));
} else {
if ($this->session->userdata('skpd_tipe') == 'SKPDKBT') {
$this->session->set_flashdata('msg_success', 'Validasi Dibatalkan');
redirect(active_module_url("{$controller}/kbt/{$p_usaha_id}"));
} else {
$this->session->set_flashdata('msg_success', 'Validasi Dibatalkan');
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
}
} else {
$this->session->set_flashdata('msg_danger', 'Data Gagal dibatalkan');
redirect(active_module_url("{$controller}/index/{$p_usaha_id}"));
}
}
}
