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
