|
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/ |
| [ 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="3.0"/>
<property name="ireport.x" value="399"/>
<property name="ireport.y" value="144"/>
<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>
<parameter name="tgl_mulai" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_selesai" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="sts" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select nama_org as judul1, nama_dinas||' '||jenis_pem||' '|| nama_kab as judul2
from bphtb.organisasi]]>
</queryString>
<field name="judul1" class="java.lang.String"/>
<field name="judul2" class="java.lang.String"/>
</subDataset>
<parameter name="status" class="java.lang.String"/>
<parameter name="tanggal2" class="java.lang.String"/>
<parameter name="tgl_mulai" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_selesai" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="sts" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select a.no_reg,g.no_sertf, a.nik_wp,coalesce(b.nama,'-') 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,
e.no_permohonan,e.jenis_sk, e.pajak_bphtb, f.jenis_prh
from bphtb.daftar a
left join bphtb.wajib_pajak b on a.nik_wp = b.nik
left join bphtb.ppat c on a.kode_ppat = c.kode_ppat
left join bphtb.pejabat d on a.nip = d.nip
inner join bphtb.setoran e on a.no_reg = e.no_reg
inner join bphtb.jenis_prh f on (f.kode_jns=e.kode_jns)
inner join bphtb.objek_pajak g on a.kd_propinsi = g.kd_propinsi
and a.kd_dati2 = g.kd_dati2
and a.kd_kecamatan = g.kd_kecamatan
and a.kd_kelurahan = g.kd_kelurahan
and a.kd_blok = g.kd_blok
and a.no_urut = g.no_urut
and a.kd_jns_op = g.kd_jns_op
WHERE e.tgl_bayar between to_date($P{tgl_mulai},'DD/MM/YYYY')
and to_date($P{tgl_selesai},'DD/MM/YYYY')
and a.is_deleted ='0'
and CASE WHEN $P{sts} = '9' then cast (a.status as character) IN ('0','1','2','3')
WHEN $P{sts} = '0' then e.pajak_bphtb = 0 and e.jenis_sk='05'
WHEN $P{sts} = '1' then a.status = '1' or a.status = '3'
WHEN $P{sts} = '2' then a.status = '2' or (a.status = '0' and e.jenis_sk !='05')
END
order by a.status ASC,a.tgl_serah_berkas]]>
</queryString>
<field name="no_reg" class="java.lang.Integer"/>
<field name="no_sertf" 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"/>
<field name="no_permohonan" class="java.lang.String"/>
<field name="jenis_sk" class="java.lang.String"/>
<field name="pajak_bphtb" class="java.lang.Double"/>
<field name="jenis_prh" class="java.lang.String"/>
<variable name="pajak_bphtb_1" class="java.lang.Double" calculation="Sum">
<variableExpression><![CDATA[$F{pajak_bphtb}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="10" splitType="Stretch"/>
</title>
<pageHeader>
<band height="92">
<componentElement>
<reportElement uuid="c706091a-c255-4ab1-aee3-7f20ea1dc5e0" x="0" y="0" width="894" height="92"/>
<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" printOrder="Vertical">
<datasetRun subDataset="dataset1" uuid="37171ddb-5fe5-4315-a07d-2170eaf49a22">
<datasetParameter name="status">
<datasetParameterExpression><![CDATA[$P{status}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="tgl_mulai">
<datasetParameterExpression><![CDATA[$P{tgl_mulai}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="tgl_selesai">
<datasetParameterExpression><![CDATA[$P{tgl_selesai}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="sts">
<datasetParameterExpression><![CDATA[$P{sts}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="92" width="894">
<textField>
<reportElement uuid="3c64a839-9262-472e-a3b3-d89672ceb15f" x="7" y="34" width="861" height="18"/>
<textElement>
<font fontName="Arial" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{judul2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3c64a839-9262-472e-a3b3-d89672ceb15f" x="7" y="9" width="864" height="21"/>
<textElement>
<font fontName="Arial" size="10"/>
</textElement>
<textFieldExpression><![CDATA[$F{judul1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e6e544ba-45fd-4236-9a06-e4e1652db52a" x="6" y="57" width="418" height="20"/>
<textElement>
<font size="10"/>
</textElement>
<textFieldExpression><![CDATA["Tanggal Penyerahan Berkas : "+ $P{tgl_mulai} + " s/d " + $P{tgl_selesai}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</pageHeader>
<columnHeader>
<band height="21" splitType="Stretch">
<staticText>
<reportElement uuid="a764e645-3fc3-456c-8053-a2c8896db5b7" x="3" y="1" width="20" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NO.]]></text>
</staticText>
<staticText>
<reportElement uuid="d3e33653-f4ef-47b5-94a4-d5678bfcb0f2" x="23" y="1" width="53" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NO DAFTAR]]></text>
</staticText>
<staticText>
<reportElement uuid="005d8da0-38f1-46ac-a6f9-f4db71a9fa01" x="76" y="1" width="88" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NIK]]></text>
</staticText>
<staticText>
<reportElement uuid="a398d95b-63be-49fc-8e7b-ef710aca0a7b" x="163" y="1" width="126" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NAMA]]></text>
</staticText>
<staticText>
<reportElement uuid="bcfb78ef-d585-4f96-aae2-48a48aa12730" x="289" y="1" width="113" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="c37364ca-888f-42e6-93d2-f282c6983af2" x="474" y="1" width="125" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[NOTARIS/PPAT]]></text>
</staticText>
<staticText>
<reportElement uuid="45ef5baa-fc5c-43d1-865f-ee91701ae965" x="835" y="1" width="57" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[STATUS]]></text>
</staticText>
<line>
<reportElement uuid="31814892-e9c3-4342-a276-d87407101cf8" x="835" y="2" width="1" height="19"/>
</line>
<line>
<reportElement uuid="dd52fbc0-428d-4234-9402-1ab936b3bfe5" x="600" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="73e60790-c4f9-4b02-899d-2db1ea655183" x="401" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="1aa911b9-47f0-4ea5-9814-d8021eb3ad45" x="289" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="5c81c995-23a4-45ac-8451-826d2cd60db1" x="164" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="efb55f2f-e8e2-45d2-b6aa-f563b0dd5c79" x="75" y="1" width="1" height="20"/>
</line>
<line>
<reportElement uuid="ced447c7-f499-44c5-8f9f-9aa3ad85b42f" x="22" 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="688" y="1" width="62" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true"/>
</textElement>
<text><![CDATA[TANGGAL]]></text>
</staticText>
<line>
<reportElement uuid="31814892-e9c3-4342-a276-d87407101cf8" x="750" y="1" width="1" height="19"/>
</line>
<staticText>
<reportElement uuid="45ef5baa-fc5c-43d1-865f-ee91701ae965" x="753" y="2" width="82" height="19"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[Pajak BPHTB]]></text>
</staticText>
<line>
<reportElement uuid="17fbd5d3-9824-4333-a62f-e85bec2582f2" x="686" y="2" width="1" height="18"/>
</line>
<staticText>
<reportElement uuid="c37364ca-888f-42e6-93d2-f282c6983af2" x="600" y="1" width="86" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true" isItalic="false"/>
</textElement>
<text><![CDATA[PEROLEHAN]]></text>
</staticText>
<line>
<reportElement uuid="73e60790-c4f9-4b02-899d-2db1ea655183" x="474" y="1" width="1" height="20"/>
</line>
<staticText>
<reportElement uuid="2dc259af-676b-4dd6-87f3-bdce42a4a9ed" x="402" y="1" width="73" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" size="8" isBold="true"/>
</textElement>
<text><![CDATA[NO SERTIFIKAT]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="29" splitType="Stretch">
<line>
<reportElement uuid="40ec01f1-76aa-4c71-be9d-20c37e2ae9f3" x="3" y="28" width="890" height="1"/>
</line>
<textField>
<reportElement uuid="bbb227f6-555d-47a4-a3e7-a8703abc3ac6" stretchType="RelativeToBandHeight" x="75" y="-1" width="89" height="19"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nik_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="2ba0135e-69cb-4020-b35a-5bfddc43135d" stretchType="RelativeToBandHeight" x="167" y="0" width="124" height="27"/>
<box topPadding="5"/>
<textElement verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b24a29f7-88f3-4b66-aadc-67609d20404a" x="289" y="0" width="112" height="18"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="be470c61-60d7-4eee-8ee2-e50026fe6bd4" stretchType="RelativeToBandHeight" x="473" y="0" width="126" height="27"/>
<box topPadding="5" leftPadding="5"/>
<textElement verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_ppat}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="c1e7d682-68ef-4f45-9efd-9ff57f1b6000" x="835" y="0" width="1" height="28"/>
</line>
<line>
<reportElement uuid="17fbd5d3-9824-4333-a62f-e85bec2582f2" x="600" y="0" width="1" height="28"/>
</line>
<line>
<reportElement uuid="4acbf1e8-bef1-44bd-b414-3498ecf64499" x="289" y="0" width="1" height="28"/>
</line>
<line>
<reportElement uuid="c02c1bed-6d1d-4e5b-b759-4259faebe373" x="164" y="-1" width="1" height="29"/>
</line>
<line>
<reportElement uuid="0723d6c2-d4c1-420f-9077-af3dc3b957a1" x="75" y="-1" width="1" height="29"/>
</line>
<line>
<reportElement uuid="11b4d4b3-814f-4d7c-85d8-126bca5e533d" x="22" y="-1" width="1" height="29"/>
</line>
<line>
<reportElement uuid="7ebdacff-574e-4cae-a20c-b2cbdc705676" x="2" y="-1" width="1" height="29"/>
</line>
<line>
<reportElement uuid="aeb0313b-d07d-4555-9498-70f2a220410b" x="893" y="0" width="1" height="29"/>
</line>
<textField>
<reportElement uuid="14fe2bc5-34c3-4d58-8e60-909c34087806" x="688" y="1" width="62" height="17"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" size="9"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{tgl_serah_berkas})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1800bb66-ddbc-4504-83c1-f7585e2ee8e6" x="2" y="1" width="21" height="17"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" size="9"/>
</textElement>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="34486da3-55b0-4ab2-895b-8b3625bbcb7c" x="23" y="1" width="53" height="17"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_permohonan}]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="94f496bf-6e4d-4046-8640-08651f37beb4" x="836" y="1" width="57" height="17"/>
<box topPadding="5"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[($F{pajak_bphtb} == 0 && $F{jenis_sk}=="05") ? "Nihil" : (($F{status} == 1 || $F{status} == 3) ? "Lunas": (($F{status} == 2 || ($F{status} == 0 && $F{jenis_sk} !="05"))? "Belum Lunas":""))]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="c1e7d682-68ef-4f45-9efd-9ff57f1b6000" x="750" y="0" width="1" height="28"/>
</line>
<textField pattern="###0.00;-###0.00" isBlankWhenNull="true">
<reportElement uuid="94f496bf-6e4d-4046-8640-08651f37beb4" x="753" y="1" width="82" height="17"/>
<box topPadding="5" rightPadding="5"/>
<textElement textAlignment="Right" verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0.00").format(($F{pajak_bphtb}).doubleValue()).replace(",", "x").replace(".", ",").replace("x", ".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="285d975a-64ed-4db2-b594-9b75041497ee" x="401" y="0" width="1" height="28"/>
</line>
<line>
<reportElement uuid="17fbd5d3-9824-4333-a62f-e85bec2582f2" x="686" y="0" width="1" height="28"/>
</line>
<textField>
<reportElement uuid="be470c61-60d7-4eee-8ee2-e50026fe6bd4" stretchType="RelativeToBandHeight" x="599" y="-1" width="88" height="28"/>
<box topPadding="5" leftPadding="5"/>
<textElement verticalAlignment="Top">
<font fontName="Arial" size="9" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{jenis_prh}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="285d975a-64ed-4db2-b594-9b75041497ee" x="474" y="-1" width="1" height="30"/>
</line>
<textField>
<reportElement uuid="5909f96b-4310-4372-842e-328549ee93af" x="404" y="1" width="71" height="26"/>
<textElement verticalAlignment="Top">
<font fontName="Arial" size="9"/>
</textElement>
<textFieldExpression><![CDATA[$F{no_sertf}]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height="49">
<textField>
<reportElement uuid="56bb3727-0345-429c-8ad6-104946d0a4c6" x="0" y="33" width="358" height="13"/>
<textElement>
<font fontName="Arial" isItalic="false"/>
</textElement>
<textFieldExpression><![CDATA["Di terbitkan pada tanggal "+$P{tanggal2}.replace("-", " ")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="11305106-b2cb-4dce-a804-167b0d5a1bce" x="2" y="23" width="892" height="1"/>
</line>
<line>
<reportElement uuid="5e97b696-149e-4c67-9217-8ce0ab329d51" x="2" y="-2" width="1" height="25"/>
</line>
<line>
<reportElement uuid="5e97b696-149e-4c67-9217-8ce0ab329d51" x="750" y="1" width="1" height="23"/>
</line>
<line>
<reportElement uuid="5e97b696-149e-4c67-9217-8ce0ab329d51" x="835" y="0" width="1" height="24"/>
</line>
<line>
<reportElement uuid="5e97b696-149e-4c67-9217-8ce0ab329d51" x="893" y="-2" width="1" height="26"/>
</line>
<textField pattern="#,##0.00" isBlankWhenNull="true">
<reportElement uuid="ab775725-701a-4d54-b1f9-106e678ed7fa" x="753" y="3" width="80" height="20"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="8" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$V{pajak_bphtb_1}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="1f0ee15e-5e68-47ad-9148-54867964c44a" x="686" y="2" width="64" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="10" isBold="true"/>
</textElement>
<text><![CDATA[Jumlah ]]></text>
</staticText>
</band>
</summary>
</jasperReport>