|
Server IP : 127.0.0.1 / Your IP : 127.0.0.1 Web Server : Apache/2.4.10 (Win32) OpenSSL/1.0.1i PHP/5.6.3 System : Windows NT WIN-R7LTCC7BPLI 6.3 build 9200 (Windows Server 2012 R2 Datacenter Edition) i586 User : GerbangSIPAD ( 0) PHP Version : 5.6.3 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF Directory (0777) : C:/xampp5/htdocs/bphtb/report/CetakDaftarPenerimaanBPHTB/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="daftar penerimaan bphtb perppat" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="ff61d175-3698-4417-8d7c-a0baeb3ecea0">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<style name="table" fill="Solid" pattern="">
<pen lineWidth="1.0"/>
<box>
<topPen lineWidth="1.0" lineColor="#000000"/>
<leftPen lineWidth="1.0" lineColor="#000000"/>
<bottomPen lineWidth="1.0" lineColor="#000000"/>
<rightPen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<parameter name="tgl_masuk" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_keluar" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="nip" class="java.lang.String">
<defaultValueExpression><![CDATA["848573625483648592 "]]></defaultValueExpression>
</parameter>
<parameter name="TGL_SEKARANG" class="java.lang.String"/>
<parameter name="nip_kasi" class="java.lang.String">
<defaultValueExpression><![CDATA["19810702 199912 1 0"]]></defaultValueExpression>
</parameter>
<parameter name="nip_kabid" class="java.lang.String">
<defaultValueExpression><![CDATA["19660705 199203 1 0"]]></defaultValueExpression>
</parameter>
<parameter name="organisasi" class="java.lang.String">
<defaultValueExpression><![CDATA["01"]]></defaultValueExpression>
</parameter>
<parameter name="ppat" class="java.lang.String">
<defaultValueExpression><![CDATA["00000000201200029"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT org.nama_org, org.nama_dinas, org.alamat_dinas, org.ibu_kota,row_number() OVER(ORDER BY d.no_form) AS posisi, d.no_form, d.tgl_masuk, d.kd_propinsi, d.kd_dati2, d.kd_kecamatan, d.kd_kelurahan, d.kd_blok,
d.no_urut, d.kd_jns_op, v.nm_wp, v.alamat_pemilik, T.nama_ppat, T.jml_bayar, d.ket, p.nip, p.nama_pjb, p.pangkat, j.nama_jab, kasi.nip AS kasi_nip, kasi.nama_pjb AS kasi_nama, kasi.pangkat AS kasi_pangkat,
kasi.nama_jab AS kasi_jab, kabid.nip AS kabid_nip, kabid.nama_pjb AS kabid_nama, kabid.pangkat AS kabid_pangkat, kabid.nama_jab AS kabid_jab
FROM bphtb.dok_terima d LEFT JOIN ( SELECT pp.kode_ppat, setor.nomor, pp.nama_ppat, setor.jml_bayar
FROM bphtb.ppat pp, bphtb.setoran setor ) T
ON d.kode_ppat = T.kode_ppat AND d.no_reg = T.nomor,
bphtb.v_nop_pemilik v,
bphtb.pejabat p LEFT JOIN bphtb.jabatan j ON p.kode_jab = j.kode_jab,
bphtb.organisasi org,
(SELECT p.nip, p.nama_pjb, p.pangkat, j.nama_jab FROM bphtb.pejabat p LEFT JOIN bphtb.jabatan j ON p.kode_jab = j.kode_jab
WHERE p.nip = $P{nip_kasi}) AS kasi,
(SELECT p.nip, p.nama_pjb, p.pangkat, j.nama_jab FROM bphtb.pejabat p LEFT JOIN bphtb.jabatan j ON p.kode_jab = j.kode_jab
WHERE p.nip = $P{nip_kabid}) AS kabid
WHERE v.kd_propinsi = d.kd_propinsi
AND v.kd_dati2 = d.kd_dati2
AND v.kd_kecamatan = d.kd_kecamatan
AND v.kd_kelurahan = d.kd_kelurahan
AND v.no_urut = d.no_urut
AND v.kd_jns_op = d.kd_jns_op
AND org.kode_org = $P{organisasi}
AND d.tgl_masuk BETWEEN to_date($P{tgl_masuk},'MM/dd/yyyy') AND to_date($P{tgl_keluar},'MM/dd/yyyy')
AND p.nip = $P{nip}
AND d.kode_ppat = $P{ppat}
ORDER BY d.no_form]]>
</queryString>
<field name="nama_org" class="java.lang.String"/>
<field name="nama_dinas" class="java.lang.String"/>
<field name="alamat_dinas" class="java.lang.String"/>
<field name="ibu_kota" class="java.lang.String"/>
<field name="posisi" class="java.lang.Long"/>
<field name="no_form" class="java.lang.String"/>
<field name="tgl_masuk" class="java.sql.Date"/>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="kd_blok" class="java.lang.String"/>
<field name="no_urut" class="java.lang.String"/>
<field name="kd_jns_op" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="alamat_pemilik" class="java.lang.String"/>
<field name="nama_ppat" class="java.lang.String"/>
<field name="jml_bayar" class="java.lang.Double"/>
<field name="ket" class="java.lang.String"/>
<field name="nip" class="java.lang.String"/>
<field name="nama_pjb" class="java.lang.String"/>
<field name="pangkat" class="java.lang.String"/>
<field name="nama_jab" class="java.lang.String"/>
<field name="kasi_nip" class="java.lang.String"/>
<field name="kasi_nama" class="java.lang.String"/>
<field name="kasi_pangkat" class="java.lang.String"/>
<field name="kasi_jab" class="java.lang.String"/>
<field name="kabid_nip" class="java.lang.String"/>
<field name="kabid_nama" class="java.lang.String"/>
<field name="kabid_pangkat" class="java.lang.String"/>
<field name="kabid_jab" class="java.lang.String"/>
<variable name="total_bpthb" class="java.lang.Integer" calculation="Sum">
<variableExpression><![CDATA[$F{jml_bayar}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="11" splitType="Stretch"/>
</title>
<pageHeader>
<band height="162" splitType="Stretch">
<staticText>
<reportElement uuid="cb6c9e8e-0a79-4463-b55c-c6120fc63255" x="0" y="110" width="802" height="20"/>
<textElement textAlignment="Center">
<font size="14" isBold="true"/>
</textElement>
<text><![CDATA[DAFTAR PENERIMAAN BPHTB]]></text>
</staticText>
<staticText>
<reportElement uuid="db3d339d-0f27-484d-b384-6f48cbb38416" x="305" y="142" width="59" height="20"/>
<textElement/>
<text><![CDATA[TANGGAL :]]></text>
</staticText>
<staticText>
<reportElement uuid="46ed43b2-0e75-4ff1-8853-23ba04c198ec" x="422" y="142" width="29" height="20"/>
<textElement/>
<text><![CDATA[S/D :]]></text>
</staticText>
<textField>
<reportElement uuid="0a66a198-cda8-42ae-83a1-e0eb581b82e1" x="0" y="0" width="802" height="20"/>
<textElement>
<font size="14" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_org}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f52dedc4-345c-4b22-ad79-fecc8ec3216e" x="0" y="20" width="802" height="20"/>
<textElement>
<font size="14" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_dinas}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="70944d76-c733-4bd0-a6bd-08364a306cac" x="0" y="60" width="802" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{ibu_kota}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="43cd89cd-56bb-427b-bc4f-56b37ca36c3c" x="0" y="40" width="802" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{alamat_dinas}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7b33efc7-a6ae-4697-bd89-c99b351c0f76" x="363" y="142" width="60" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{tgl_masuk}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="11f91bf5-5aa6-4ebe-a57e-c320a6e89f60" x="450" y="142" width="60" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{tgl_keluar}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="50" splitType="Stretch">
<staticText>
<reportElement uuid="3e794ccc-d082-4735-b9a6-2bd531176457" style="table" x="1" y="30" width="30" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NO]]></text>
</staticText>
<staticText>
<reportElement uuid="524126ec-1341-4051-9fa7-89b0fb47429b" style="table" x="31" y="30" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NOSSPD]]></text>
</staticText>
<staticText>
<reportElement uuid="d547a282-708e-4ff3-a97b-e01d1a549f82" style="table" x="131" y="30" width="56" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[TANGGAL]]></text>
</staticText>
<staticText>
<reportElement uuid="ca40c47b-275b-48fb-8af3-9f1c694647d8" style="table" x="187" y="30" width="130" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="963b3fad-75dc-4635-bf77-d94405ea7772" style="table" x="317" y="30" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NAMA WP]]></text>
</staticText>
<staticText>
<reportElement uuid="3c0e1b73-804b-4e09-90ff-5a1da6f87b97" style="table" x="417" y="30" width="200" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ALAMAT WP]]></text>
</staticText>
<staticText>
<reportElement uuid="9d7362b9-830d-4c26-a875-0dd61372b8c6" style="table" x="617" y="30" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[JUMLAH BPHTB]]></text>
</staticText>
<staticText>
<reportElement uuid="b7aa3638-b0df-4cc2-a9ef-9777c9096cda" style="table" x="717" y="30" width="86" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[KETERANGAN]]></text>
</staticText>
<textField isBlankWhenNull="true">
<reportElement uuid="d07e84c0-e44c-43f2-a12b-25e64318799b" x="74" y="10" width="100" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nama_ppat}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="fd2bfde4-a455-4cc2-b304-ed8a55ecd9a7" x="0" y="10" width="74" height="20"/>
<textElement/>
<text><![CDATA[NAMA PPAT :]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="40" splitType="Stretch">
<textField>
<reportElement uuid="4a3d9a0d-1946-420a-9239-306505e29f73" style="table" x="1" y="0" width="30" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{posisi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="dcb2e6e1-18c1-49ae-9af7-b8caf3a0aa49" style="table" x="31" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{no_form}]]></textFieldExpression>
</textField>
<textField pattern="dd/MM/yyyy">
<reportElement uuid="6e4d261b-1504-4ad3-9a8a-018698f9c22c" style="table" x="131" y="0" width="56" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{tgl_masuk}]]></textFieldExpression>
</textField>
<frame>
<reportElement uuid="77ee29b3-3855-406f-bd72-58dd71f8e57f" style="table" x="187" y="0" width="130" height="40"/>
<textField>
<reportElement uuid="ab2a1709-18b5-4f91-aa60-e10189ad6c45" x="5" y="0" width="15" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e73f78a7-021d-4e37-a347-e5a4700b6dd5" x="20" y="0" width="15" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="176674da-f420-4355-b5d2-0e1af0e5cb34" x="35" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="567071cf-dfab-4cdf-872d-b765357382c4" x="55" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8b5a5230-78d0-4d15-90de-db2671238fdc" x="75" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_blok}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="426a949f-1cba-4898-9df8-cad8b20459ca" x="95" y="0" width="25" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{no_urut}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1f87a922-0b01-4419-a067-ac4597bcd39d" x="120" y="0" width="5" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_jns_op}]]></textFieldExpression>
</textField>
</frame>
<textField isBlankWhenNull="true">
<reportElement uuid="d1ebe5a1-28df-40cf-acc2-0d9d6653299c" style="table" x="317" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="a22a1c12-f902-4f38-9625-f21632047680" style="table" x="417" y="0" width="200" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{alamat_pemilik}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="cee4dfb4-c8b9-41a7-8212-a600e38fdf62" style="table" x="617" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{jml_bayar}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="a0f2dfce-9c64-4947-8328-0e39af1bf767" style="table" x="717" y="0" width="86" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{ket}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="20" splitType="Stretch">
<frame>
<reportElement uuid="ee015821-5b54-4c0a-b7f0-eddb2ab57029" style="table" x="1" y="0" width="616" height="20"/>
<staticText>
<reportElement uuid="0fb23aa9-c6af-42ee-81ed-141ca7eb3a6d" x="502" y="0" width="100" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[TOTAL]]></text>
</staticText>
</frame>
<textField>
<reportElement uuid="ffc5e211-e7da-4c8b-8931-2990644e7b55" style="table" x="617" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$V{total_bpthb}]]></textFieldExpression>
</textField>
<frame>
<reportElement uuid="842677ec-27b9-4af0-badd-583c89d2181a" style="table" x="717" y="0" width="86" height="20"/>
</frame>
</band>
</columnFooter>
<pageFooter>
<band height="180" splitType="Stretch">
<textField pattern="dd/MM/yyyy">
<reportElement uuid="68a346dd-b75d-4d0a-81c6-5708bf8aa445" x="708" y="11" width="95" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{TGL_SEKARANG}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="e8b9d656-d928-4723-8505-42be7d2e0b1b" x="657" y="11" width="51" height="20"/>
<textElement/>
<text><![CDATA[GIANYAR,]]></text>
</staticText>
<textField>
<reportElement uuid="861fa72f-a723-4f0d-93ca-31161586c1fb" x="603" y="119" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nama_pjb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="55e651d0-49e8-410d-bb47-a42b94ee7b06" x="603" y="139" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="924c7c9e-a9b8-412d-a1ff-e7b6de78eab5" x="603" y="31" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nama_jab}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c413104a-b6c0-4d6d-a30f-0bc30f8ed32c" x="660" y="159" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="f99f37ce-51ed-4a2a-948e-718deb2aaa8c" x="632" y="159" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
<textField>
<reportElement uuid="32250f77-54f9-4c66-a7f4-84497f346be7" x="355" y="159" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{kasi_nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bfcfa8dd-bd8e-4f0e-80e9-a522f867c377" x="63" y="159" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{kabid_nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d0a79c18-c3f6-471d-bcd4-9459a9df100b" x="1" y="119" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_nama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e55f6833-4062-4197-83f1-e4cff249834a" x="1" y="139" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="dafef57c-5ec3-46d1-860a-3c7a78023315" x="1" y="31" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_jab}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="205654be-4600-44a9-ad82-8cca91698aa8" x="301" y="119" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_nama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="545466aa-7a9e-45e7-b1e8-8caf9313e6cc" x="301" y="139" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5dccd85f-eb35-4626-bb9b-cb3b2fcd6e33" x="301" y="31" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_jab}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="d90b4e62-e052-4a29-8bc1-839fb9afa771" x="35" y="159" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
<staticText>
<reportElement uuid="345e3cee-cfd0-4869-820f-8953214bdf44" x="327" y="159" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
</band>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>