|
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 bpthb seluruh" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="22e0a83c-dc1a-467b-88b3-a413533f5d55">
<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>
<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}
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="5a3f41d0-fd44-494b-8001-e87a6610d55b" 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="f4257e40-8aa3-4458-bda9-010d65acefb6" x="305" y="142" width="59" height="20"/>
<textElement/>
<text><![CDATA[TANGGAL :]]></text>
</staticText>
<staticText>
<reportElement uuid="c87ea800-6875-475b-963b-49906aec2d62" x="422" y="142" width="29" height="20"/>
<textElement/>
<text><![CDATA[S/D :]]></text>
</staticText>
<textField>
<reportElement uuid="43f68bdf-2fdc-4eaa-8b2c-e27461deee4f" 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="16039c29-27f9-4528-b47f-7974b00653e9" 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="c54d98c1-1098-403d-8618-c49a4e21f72b" x="0" y="60" width="802" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{ibu_kota}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="8c2d5435-e141-4ba4-9b95-1f9b5cc085bb" x="0" y="40" width="802" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{alamat_dinas}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cbc34900-198f-4155-be19-fa9dc1a45956" x="363" y="142" width="60" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{tgl_masuk}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="373e2303-6207-44ba-9545-669567674126" x="450" y="142" width="60" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{tgl_keluar}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="20" splitType="Stretch">
<staticText>
<reportElement uuid="65ce7ccc-d769-4623-b3aa-d2cff608b2cc" style="table" x="0" y="0" width="30" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NO]]></text>
</staticText>
<staticText>
<reportElement uuid="fa8c24e0-cc73-41ef-a1f7-4088953b422c" style="table" x="30" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NOSSPD]]></text>
</staticText>
<staticText>
<reportElement uuid="b28dcedd-acbb-48d5-afc7-319c44e72c7f" style="table" x="130" y="0" width="56" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[TANGGAL]]></text>
</staticText>
<staticText>
<reportElement uuid="33b17156-e674-480b-ae63-e4fb18dc4981" style="table" x="186" y="0" width="130" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="71886306-ca21-41c2-984a-3f6a8228fed2" style="table" x="316" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NAMA WP]]></text>
</staticText>
<staticText>
<reportElement uuid="28aa517a-35d4-4db2-b7b7-ec072d555482" style="table" x="416" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[ALAMAT WP]]></text>
</staticText>
<staticText>
<reportElement uuid="764b6960-9172-44b7-ba14-9402f4477dd7" style="table" x="516" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[NAMA PPAT]]></text>
</staticText>
<staticText>
<reportElement uuid="e0a7bef1-11ee-42bb-a48c-4c2a714a8e55" style="table" x="616" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[JUMLAH BPHTB]]></text>
</staticText>
<staticText>
<reportElement uuid="ce3bc4d8-fcf2-4994-8e7b-9fe4ce4eb41a" style="table" x="716" y="0" width="86" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[KETERANGAN]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="40" splitType="Stretch">
<textField>
<reportElement uuid="44c38b7d-3023-4619-9d86-f959359c7c60" style="table" x="0" y="0" width="30" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{posisi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="159c6132-2e3e-4545-8de4-379ce16d4fd2" style="table" x="30" 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="eab15031-62d7-4ad4-a153-5bf95a78c136" style="table" x="130" y="0" width="56" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{tgl_masuk}]]></textFieldExpression>
</textField>
<frame>
<reportElement uuid="5f8460a2-c2e9-462d-9357-b7d047605880" style="table" x="186" y="0" width="130" height="40"/>
<textField>
<reportElement uuid="0ee3f7cd-890f-4a1f-983c-57c44c95133e" x="5" y="0" width="15" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d109eb05-fde4-4a0b-99f7-7230d1316b3b" x="20" y="0" width="15" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bf55a18b-d422-45aa-aa8e-b64896af04f3" x="35" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_kecamatan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5715541d-599c-4395-933f-19d3c57043f1" x="55" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c1516037-4094-4122-b6f1-807bce2587cc" x="75" y="0" width="20" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{kd_blok}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b1ab7360-9a9a-4648-b050-5ce5f4a3788e" x="95" y="0" width="25" height="40"/>
<textElement verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{no_urut}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="729cd99c-25d5-428a-ab3a-0c7cec8bcd30" 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="67812f9c-3bd7-4f2a-bbd7-20d1ca155625" style="table" x="316" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="53458d10-d250-4b85-9a5e-1595a95334f2" style="table" x="416" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{alamat_pemilik}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="a92bc844-f5cb-4365-85e7-3b050cc088ce" style="table" x="516" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{nama_ppat}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="06229eae-7c45-4ab9-bb06-38a245c0d3be" style="table" x="616" y="0" width="100" height="40"/>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{jml_bayar}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="b41da7fd-cd8d-44c4-ab25-93b559c0741e" style="table" x="716" 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="be3ac19d-0e68-41fc-8e6c-89eb9d70a3ba" style="table" x="0" y="0" width="616" height="20"/>
<staticText>
<reportElement uuid="1df1299b-8eda-49cc-8a1b-1cf57c0ec0fb" x="516" y="0" width="100" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[TOTAL]]></text>
</staticText>
</frame>
<textField>
<reportElement uuid="efa9c1d0-1fcb-4521-ae6f-1d183ea62f1e" style="table" x="616" y="0" width="100" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$V{total_bpthb}]]></textFieldExpression>
</textField>
<frame>
<reportElement uuid="9a7a3cef-b60e-475a-88f7-f23e8422751a" style="table" x="716" y="0" width="86" height="20"/>
</frame>
</band>
</columnFooter>
<pageFooter>
<band height="180" splitType="Stretch">
<textField pattern="dd/MM/yyyy">
<reportElement uuid="c13ff1db-0f75-4320-af6e-9e07a6c4a45f" x="707" y="12" width="95" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$P{TGL_SEKARANG}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="fa2f8d54-45d6-44e1-8700-60f14a07329f" x="656" y="12" width="51" height="20"/>
<textElement/>
<text><![CDATA[GIANYAR,]]></text>
</staticText>
<textField>
<reportElement uuid="3df86587-84b4-46b2-aa6b-643684cac595" x="602" y="120" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nama_pjb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4d2597b9-ccc4-4cb8-800a-b3d0246c2352" x="602" y="140" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="ba73d9cb-5ab1-4a73-8324-d2f3208300e1" x="602" y="32" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{nama_jab}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bc38e981-60e9-4a11-89a4-f5b72bed4fdd" x="659" y="160" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="22d61c57-751b-43dc-911a-010cb1db4ba8" x="631" y="160" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
<textField>
<reportElement uuid="960246cd-1024-44c1-ba7b-fdf72bf7cbb6" x="354" y="160" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{kasi_nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a65f63e3-5387-445c-adef-8b225beacfd2" x="62" y="160" width="118" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{kabid_nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe229d63-a9d3-4fab-8455-bd212c148bd5" x="0" y="120" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_nama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="be008b4c-f5e6-40ee-bb71-abe7a998860e" x="0" y="140" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="255a1db5-3755-4cc3-a2e7-f5ee5085a613" x="0" y="32" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kabid_jab}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9029ada5-2f95-44c0-8dda-29517b276276" x="300" y="120" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_nama}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="269c6cd8-57d2-4b2c-b9f4-8d5505c1917d" x="300" y="140" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_pangkat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="100cfd66-f20d-4458-b569-138640dbd9b9" x="300" y="32" width="200" height="20"/>
<textElement textAlignment="Center"/>
<textFieldExpression><![CDATA[$F{kasi_jab}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="ba407da7-f0f2-499c-851c-b8a975b4881c" x="34" y="160" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
<staticText>
<reportElement uuid="645a6e20-9310-4298-adef-ca2a6144a6b3" x="326" y="160" width="28" height="20"/>
<textElement textAlignment="Right"/>
<text><![CDATA[NIP.]]></text>
</staticText>
</band>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>