|
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/CetakStatusBphtb - Copy/ |
| [ 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="CetakStatusBphtb" pageWidth="936" pageHeight="612" orientation="Landscape" columnWidth="896" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="2161e252-9f2a-4ba6-983b-4c977d4e7c09">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="67"/>
<subDataset name="dataset1" uuid="8138eba0-2022-47e8-a70d-fd660fc9353b">
<parameter name="condition" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="status" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select count(a.no_reg) as jumlah from bphtb.daftar a left join pbb.dat_subjek_pajak b on a.nik_wp = b.subjek_pajak_id
left join bphtb.ppat c on a.kode_ppat = c.kode_ppat
left join bphtb.pejabat d on a.nip = d.nip
$P!{condition}
]]>
</queryString>
<field name="jumlah" class="java.lang.Long"/>
</subDataset>
<parameter name="kota" class="java.lang.String"/>
<parameter name="condition" class="java.lang.String">
<defaultValueExpression><![CDATA[" WHERE 1=1 "]]></defaultValueExpression>
</parameter>
<parameter name="status" class="java.lang.String"/>
<parameter name="tanggal" class="java.lang.String"/>
<parameter name="tanggal2" class="java.lang.String"/>
<parameter name="kota2" class="java.lang.String"/>
<queryString>
<![CDATA[select a.no_reg,a.nik_wp,coalesce(b.nm_wp,'-') as nm_wp,a.kd_propinsi||'.'||a.kd_dati2||'.'||a.kd_kecamatan||'.'||a.kd_kelurahan ||'.'||a.kd_blok||'.'||a.no_urut||'.'||a.kd_jns_op as nop,
c.nama_ppat,coalesce(d.nama_pjb,'-') as nama_pjb,a.status,a.tgl_serah_berkas
from bphtb.daftar a left join pbb.dat_subjek_pajak b on a.nik_wp = b.subjek_pajak_id
left join bphtb.ppat c on a.kode_ppat = c.kode_ppat
left join bphtb.pejabat d on a.nip = d.nip
$P!{condition}
order by a.tgl_serah_berkas,a.no_reg]]>
</queryString>
<field name="no_reg" class="java.lang.String"/>
<field name="nik_wp" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="nama_ppat" class="java.lang.String"/>
<field name="nama_pjb" class="java.lang.String"/>
<field name="status" class="java.lang.Integer"/>
<field name="tgl_serah_berkas" class="java.sql.Date"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="14" splitType="Stretch"/>
</title>
<pageHeader>
<band height="103" splitType="Stretch">
<textField>
<reportElement uuid="e6e544ba-45fd-4236-9a06-e4e1652db52a" x="5" y="56" width="355" height="20"/>
<textElement/>
<textFieldExpression><![CDATA["Tanggal Penyerahan Berkas : "+$P{tanggal}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3c64a839-9262-472e-a3b3-d89672ceb15f" x="0" y="0" width="555" height="20"/>
<textElement>
<font fontName="Arial" size="15"/>
</textElement>
<textFieldExpression><![CDATA[$P{kota}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3c64a839-9262-472e-a3b3-d89672ceb15f" x="1" y="22" width="555" height="20"/>
<textElement>
<font fontName="Arial" size="15"/>
</textElement>
<textFieldExpression><![CDATA[$P{kota2}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="c706091a-c255-4ab1-aee3-7f20ea1dc5e0" x="5" y="75" width="400" height="27"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="dataset1" uuid="37171ddb-5fe5-4315-a07d-2170eaf49a22">
<datasetParameter name="condition">
<datasetParameterExpression><![CDATA[$P{condition}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="REPORT_CONTEXT">
<datasetParameterExpression><![CDATA[$P{status}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="27" width="400">
<textField>
<reportElement uuid="43c81f0a-f514-48c0-b117-968251f7e646" x="2" y="6" width="355" height="20"/>
<textElement>
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA["TOTAL BPHTB :"+$P{status} +" dan sebanyak"+$F{jumlah}+" berkas"]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</pageHeader>
<columnHeader>
<band height="21" splitType="Stretch">
<staticText>
<reportElement uuid="a764e645-3fc3-456c-8053-a2c8896db5b7" x="5" y="1" width="20" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NO.]]></text>
</staticText>
<staticText>
<reportElement uuid="d3e33653-f4ef-47b5-94a4-d5678bfcb0f2" x="30" y="1" width="81" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NO REGISTRASI]]></text>
</staticText>
<staticText>
<reportElement uuid="005d8da0-38f1-46ac-a6f9-f4db71a9fa01" x="115" y="1" width="89" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NIK]]></text>
</staticText>
<staticText>
<reportElement uuid="a398d95b-63be-49fc-8e7b-ef710aca0a7b" x="210" y="1" width="141" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NAMA]]></text>
</staticText>
<staticText>
<reportElement uuid="bcfb78ef-d585-4f96-aae2-48a48aa12730" x="356" y="1" width="116" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="c37364ca-888f-42e6-93d2-f282c6983af2" x="479" y="1" width="106" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[NOTARIS/PPAT]]></text>
</staticText>
<staticText>
<reportElement uuid="45ef5baa-fc5c-43d1-865f-ee91701ae965" x="682" y="1" width="91" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[PETUGAS]]></text>
</staticText>
<staticText>
<reportElement uuid="caf39c20-0b09-45a4-87a3-3263b55787f5" x="795" y="1" width="95" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<text><![CDATA[STATUS]]></text>
</staticText>
<line>
<reportElement uuid="406379a6-0e84-4a34-b28c-77b833fcfd78" x="792" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="31814892-e9c3-4342-a276-d87407101cf8" x="666" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="dd52fbc0-428d-4234-9402-1ab936b3bfe5" x="590" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="73e60790-c4f9-4b02-899d-2db1ea655183" x="476" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="1aa911b9-47f0-4ea5-9814-d8021eb3ad45" x="351" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="5c81c995-23a4-45ac-8451-826d2cd60db1" x="205" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="efb55f2f-e8e2-45d2-b6aa-f563b0dd5c79" x="111" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="ced447c7-f499-44c5-8f9f-9aa3ad85b42f" x="27" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="4be8f3cb-9c17-474e-a734-86c12277e842" x="2" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="9245163a-d32b-4baf-a82c-c2223bc4e50e" x="3" y="1" width="890" height="1"/>
</line>
<line>
<reportElement uuid="ac818465-0f09-4be2-88f0-1ac39ecda6fe" x="3" y="20" width="890" height="1"/>
</line>
<line>
<reportElement uuid="64d6e997-baa9-476c-bff5-8dea7165b865" x="893" y="1" width="1" height="20"/>
</line>
<staticText>
<reportElement uuid="9e584bf8-035d-44e8-80b5-fc0f7482b2a9" x="594" y="1" width="71" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial"/>
</textElement>
<text><![CDATA[TANGGAL]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="30" splitType="Stretch">
<textField>
<reportElement uuid="0b470dfe-4301-45ed-9c13-19fbe1fd730a" x="32" y="0" width="73" height="30"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_reg}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bbb227f6-555d-47a4-a3e7-a8703abc3ac6" stretchType="RelativeToBandHeight" x="115" y="-1" width="89" height="31"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nik_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2ba0135e-69cb-4020-b35a-5bfddc43135d" stretchType="RelativeToBandHeight" x="208" y="0" width="140" height="30"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b24a29f7-88f3-4b66-aadc-67609d20404a" x="354" y="0" width="120" height="30"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="be470c61-60d7-4eee-8ee2-e50026fe6bd4" stretchType="RelativeToBandHeight" x="479" y="0" width="107" height="30"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_ppat}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bcea430c-0649-4066-bc45-d564d30c06f3" stretchType="RelativeToBandHeight" x="670" y="0" width="118" height="30"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_pjb}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="94f496bf-6e4d-4046-8640-08651f37beb4" x="795" y="1" width="95" height="29"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[(
$F{status} == 0 ?
"Belum diproses" :
$F{status} == 1 ?
"Sudah diproses" :
$F{status} == 2 ?
"Kurang Bayar(KB)" :
$F{status} == 3 ?
"Kurang Bayar Tambahan(KBT)" :
"Tidak diketahui"
)]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="8f2d8864-0aa5-476b-952b-9efefc9eb44d" x="792" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="c1e7d682-68ef-4f45-9efd-9ff57f1b6000" x="666" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="17fbd5d3-9824-4333-a62f-e85bec2582f2" x="590" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="285d975a-64ed-4db2-b594-9b75041497ee" x="476" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="4acbf1e8-bef1-44bd-b414-3498ecf64499" x="351" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="c02c1bed-6d1d-4e5b-b759-4259faebe373" x="205" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="0723d6c2-d4c1-420f-9077-af3dc3b957a1" x="111" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="11b4d4b3-814f-4d7c-85d8-126bca5e533d" x="28" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="7ebdacff-574e-4cae-a20c-b2cbdc705676" x="2" y="0" width="1" height="30"/>
</line>
<line>
<reportElement uuid="aeb0313b-d07d-4555-9498-70f2a220410b" x="893" y="0" width="1" height="30"/>
</line>
<textField>
<reportElement uuid="14fe2bc5-34c3-4d58-8e60-909c34087806" x="594" y="1" width="70" height="29"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{tgl_serah_berkas})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1800bb66-ddbc-4504-83c1-f7585e2ee8e6" x="4" y="1" width="23" height="29"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<break>
<reportElement uuid="73fb1c36-36d8-4da9-a392-3d6fb20bc283" x="0" y="28" width="100" height="1">
<printWhenExpression><![CDATA[$V{PAGE_COUNT} == 10]]></printWhenExpression>
</reportElement>
</break>
</band>
</detail>
<columnFooter>
<band height="37">
<line>
<reportElement uuid="40ec01f1-76aa-4c71-be9d-20c37e2ae9f3" x="3" y="0" width="890" height="1"/>
</line>
<textField>
<reportElement uuid="43c81f0a-f514-48c0-b117-968251f7e646" x="3" y="11" width="355" height="20"/>
<textElement>
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA["Status BPHTB :"+$P{status} +" pada halaman ini sebanyak"+$V{COLUMN_COUNT}+ " berkas"]]></textFieldExpression>
</textField>
</band>
</columnFooter>
<lastPageFooter>
<band height="46">
<textField>
<reportElement uuid="56bb3727-0345-429c-8ad6-104946d0a4c6" x="2" y="26" width="358" height="20"/>
<textElement>
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA["DI TERBITKAN PADA "+$P{tanggal2}]]></textFieldExpression>
</textField>
</band>
</lastPageFooter>
</jasperReport>