join kecamatan c on c.camat_id=b.lurah_kecamatan where a.id=' . quote_smart($id_pemohon); $data = gcms_query($qy); $rs = gcms_fetch_object($data); } ?> document.getElementById('pendaftaran_id').value='<?php echo $_REQUEST['val']; ?> '; document.getElementById('nama_pemohon').value='<?php echo $rs->nama; ?> '; document.getElementById('alamat').value='<?php echo showMultiLine($rs->alamat); ?> '; document.getElementById('kecamatan').value='<?php echo $rs->camat_nama; ?> '; document.getElementById('kelurahan').value='<?php echo $rs->lurah_nama; ?> '; document.getElementById('wp_wr_gol').value='<?php echo $wp_wr_gol; ?> '; document.getElementById('wp_wr_no_urut').value='<?php
$IdEdit = $row->restoran_id; $id_desa = $row->restoran_id_desa; $pendaftaran_id = $row->pendaftaran_id; $id_rekening = $row->id_rekening; $pendataan_id_hid = $row->pendataan_id; $Npwp = $row->npwp; $periodeSpt1 = $row->spt_no; if ($row->tgl_kembali == "" || $row->tgl_kembali == NULL) { $Tgl = ""; } else { $Tgl = date("Y", strtotime($row->tgl_kembali)); } $periodeSpt2 = $Tgl; $memo = showMultiLine($row->memo); $nama = $row->restoran_nama; $alamat = showMultiLine($row->restoran_alamat); $kelurahan = $row->lurah_nama; $kecamatan = $row->camat_nama; $kabupaten = ''; $sistem_pemungutan = $row->jenis_pungutan; $periodeTransaksi1 = date("d-m-Y", strtotime($row->periode_awal)); $periodeTransaksi2 = date("d-m-Y", strtotime($row->periode_akhir)); $replace = explode(".", $row->kode_rekening); $KodeRek1 = $replace[0] . $replace[1] . $replace[2]; $KodeRek2 = $replace[3]; $KodeRek3 = $replace[4]; $NamaRek = $row->nama_rekening; $TarifDasar = $row->dasar_pengenaan; $Persen = $row->persen_tarif; $Pajak = $row->dasar_pengenaan * $row->persen_tarif / 100; }
$IdEdit = $row->hiburan_id; $id_desa = $row->hiburan_id_desa; $pendaftaran_id = $row->pendaftaran_id; $id_rekening = $row->id_rekening; $pendataan_id_hid = $row->pendataan_id; $Npwp = $row->npwp; $periodeSpt1 = $row->spt_no; if ($row->tgl_kembali == "" || $row->tgl_kembali == NULL) { $Tgl = ""; } else { $Tgl = date("Y", strtotime($row->tgl_kembali)); } $periodeSpt2 = $Tgl; $memo = showMultiLine($row->memo); $nama = $row->hiburan_nama; $alamat = showMultiLine($row->hiburan_alamat); $kelurahan = $row->lurah_nama; $kecamatan = $row->camat_nama; $kabupaten = ''; $sistem_pemungutan = $row->jenis_pungutan; $periodeTransaksi1 = date("d-m-Y", strtotime($row->periode_awal)); $periodeTransaksi2 = date("d-m-Y", strtotime($row->periode_akhir)); $replace = explode(".", $row->kode_rekening); $KodeRek1 = $replace[0] . $replace[1] . $replace[2]; $KodeRek2 = $replace[3]; $KodeRek3 = $replace[4]; $NamaRek = $row->nama_rekening; $TarifDasar = $row->dasar_pengenaan; $Persen = $row->persen_tarif; $Pajak = $row->dasar_pengenaan * $row->persen_tarif / 100; }
?> '; document.getElementById('telp_bu').value='<?php echo $rs->badan_telp; ?> '; document.getElementById('fax_bu').value='<?php echo $rs->badan_fax; ?> '; document.getElementById('nama_pk').value='<?php echo $rs->pemilik_nama; ?> '; document.getElementById('alamat_pk').value='<?php echo showMultiLine($rs->pemilik_alamat); ?> '; document.getElementById('kecamatan_pk').value='<?php echo $rs->camat_pemilik; ?> '; document.getElementById('kelurahan_pk').value='<?php echo $rs->lurah_pemilik; ?> '; document.getElementById('telp_pk').value='<?php echo $rs->pemilik_telp; ?> '; document.getElementById('hp_pk').value='<?php
$sql = "select t.teguran_pr_id as id,t.teguran_pr_no as nomor,t.tanggal_teguran,\r\n\t\t\tt.keterangan,pp.tgl_penetapan,pp.tgl_setor,p.npwp,kl.lurah_kecamatan,bu.badan_id_desa,\r\n\t\t\tp.no_pendaftaran,p.jenis_pendaftaran,s.spt_no,s.spt_id,s.tgl_kembali,pp.penetapan_pr_id,\r\n\t\t\tt.badan_id,\r\n\t\t\tbu.nama AS nama_badan_usaha,pj.nama as nama_petugas,pj.pejabat_id AS petugas_id,t.nominal AS total_tunggakan\r\n\t\t\tfrom teguran_pr t \r\n\t\t\tleft join penetapan_pr pp on t.penetapan_pr_id = pp.penetapan_pr_id\r\n\t\t\tleft join pejabat pj on t.fk_teguran_id = pj.pejabat_id\r\n\t\t\tleft join penetapan_pr_content pc on pp.penetapan_pr_id = pc.penetapan_pr_id\r\n\t\t\tleft join pendataan_spt ps on pc.pendataan_id = ps.pendataan_id\r\n\t\t\tleft join pendaftaran p on ps.pendaftaran_id = p.pendaftaran_id\r\n\t\t\tleft join badan_usaha bu on t.badan_id = bu.id\r\n\t\t\tleft join pemohon ph on p.id_pemohon = ph.pemohon_id\r\n\t\t\tleft join kelurahan kl on ph.id_desa = kl.lurah_id\r\n\t\t\tleft join spt s on p.pendaftaran_id = s.pendaftaran_id\r\n\t\t\twhere t.teguran_pr_id ='" . $_REQUEST['edit'] . "'\r\n\t\t\t"; $data = gcms_query($sql); $x = 1; $rs = gcms_fetch_object($data); $x++; if ($rs->jenis_pendaftaran == "PAJAK") { $Kode = "PAJAK"; } else { $Kode = "RETRIBUSI"; } if ($rs->tgl_kembali == NULL || $rs->tgl_kembali == "" || $rs->tgl_kembali == "00.00.0000") { $Tgl = ""; } else { $Tgl = $rs->tgl_kembali; } $arr = array("kode_npwp" => $Kode, "nomor" => sprintf("%06d", $rs->nomor), "tgl_tagih" => date("d/m/Y", strtotime($rs->tanggal_teguran)), "keterangan" => showMultiLine($rs->keterangan), "npwp1" => $rs->npwp, "npwp2" => sprintf("%02d", $rs->lurah_kecamatan), "npwp3" => sprintf("%02d", $rs->badan_id_desa), "npwp4" => $rs->no_pendaftaran, "periode_spt" => date("Y", strtotime($Tgl)), "spt_no" => $rs->spt_no, "spt_id" => $rs->spt_id, "tanggal_penetapan" => date("d/m/Y", strtotime($rs->tgl_penetapan)), "tanggal_jatuh_tempo" => date("d/m/Y", strtotime($rs->tgl_setor)), "nominal" => $rs->total_tunggakan, "nama" => $rs->nama_badan_usaha, "nama_petugas" => $rs->nama_petugas, "petugas_id" => $rs->petugas_id, "badan_id" => $rs->badan_id, "id_pr" => $rs->penetapan_pr_id); } echo json_encode($arr); } if ($_REQUEST['sender'] == 'daftarnpwp') { $o = null; $sql = 'select a.PENETAPAN_PR_ID as id, a.NO_PENETAPAN, p.npwp, bu.nama, a.TGL_PENETAPAN, a.TGL_SETOR, b.NOMINAL from penetapan_pr a