|
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/bhumie/report/DHR/ |
| [ 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="DhrRingkas" language="groovy" pageWidth="1057" pageHeight="830" columnWidth="1017" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="11e7c5dc-4851-46b5-99b7-538c9897c00b">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="363"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_dati2" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select
a.kd_propinsi||'.'||a.kd_dati2||'.'||a.kd_kecamatan||'.'||a.kd_kelurahan||'.'||
a.kd_blok||'-'||a.no_urut||'.'||a.kd_jns_op NOP, b.NM_WP, coalesce(a.JALAN_OP,'')||'
'||coalesce(a.BLOK_KAV_NO_OP,'') jln_op,
coalesce(b.JALAN_WP,'')||' '||coalesce(b.BLOK_KAV_NO_WP,'') jln_wp, a.TOTAL_LUAS_BUMI,
a.TOTAL_LUAS_BNG, a.NO_FORMULIR_SPOP
from dat_objek_pajak a, dat_subjek_pajak b
where a.SUBJEK_PAJAK_ID = b.SUBJEK_PAJAK_ID
and a.kd_propinsi = $P{kd_propinsi}
and a.kd_dati2 = $P{kd_dati2}
and a.kd_kecamatan = $P{kd_kecamatan}
and a.kd_kelurahan = $P{kd_kelurahan}]]>
</queryString>
<field name="nop" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="jln_op" class="java.lang.String"/>
<field name="jln_wp" class="java.lang.String"/>
<field name="total_luas_bumi" class="java.lang.Long"/>
<field name="total_luas_bng" class="java.lang.Long"/>
<field name="no_formulir_spop" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="87" splitType="Stretch">
<staticText>
<reportElement uuid="656210ad-702e-4acb-96fc-04c5fc7568d6" x="0" y="0" width="1017" height="35"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="12"/>
</textElement>
<text><![CDATA[DAFTAR OBJEK DAN SUBJEK PAJAK]]></text>
</staticText>
</band>
</pageHeader>
<columnHeader>
<band height="52" splitType="Stretch">
<line>
<reportElement uuid="a8d0bbe9-647b-4da8-8459-3125f8f9d214" x="728" y="9" width="1" height="39"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="95190d72-4f25-418d-a7b6-d9e81b698365" x="237" y="9" width="1" height="35"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="631668b1-b1c5-4fb1-9cf3-8c069129e402" x="3" y="20" width="34" height="23"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NO]]></text>
</staticText>
<staticText>
<reportElement uuid="66947ea9-edc6-4f69-b3d8-928357219317" x="49" y="20" width="75" height="23"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="8adf7a51-907f-4db7-b4a6-86769855fcc3" x="250" y="20" width="176" height="22"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama]]></text>
</staticText>
<staticText>
<reportElement uuid="09d7dfa1-f086-4528-ba7a-0b812f9cac4d" x="546" y="21" width="119" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat OP / WP]]></text>
</staticText>
<staticText>
<reportElement uuid="0e21584a-afa4-46c5-aa2e-a603582ef822" x="734" y="21" width="87" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[L. Bumi / Bng]]></text>
</staticText>
<staticText>
<reportElement uuid="c52722ee-dc4e-46c7-897e-4b9721024588" x="868" y="22" width="119" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Formulir]]></text>
</staticText>
<line>
<reportElement uuid="1269ac68-1eb2-4da7-9c35-81e4f0a1590a" x="42" y="9" width="1" height="34"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ccc0ef80-6d2f-4f1c-b8b9-4b1dfe0131d2" x="0" y="41" width="999" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="ede842fd-cec8-416b-89f4-657a96cc7519" x="0" y="48" width="999" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="956c9a86-a36e-4500-9f7e-8bd5ae359d3e" x="0" y="7" width="999" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="d9e35d34-4a29-4394-b042-2ef884bdf4be" x="0" y="14" width="999" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="00fef744-e7f7-4902-87b6-06065638f8e9" x="438" y="9" width="1" height="39"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="bc107adc-ec2a-4337-8c66-6e7d8fa920d9" x="847" y="9" width="2" height="39"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b9589d92-2304-4f26-89ef-462307ac783c" x="999" y="9" width="1" height="41"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="bbde5cee-af95-4d65-bc77-956b2b323db1" x="0" y="9" width="1" height="39"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="49" splitType="Stretch">
<textField>
<reportElement uuid="d17d0859-6b00-4ede-bedb-fa26191a6ec5" x="49" y="0" width="177" height="44"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="53c8e736-5f3a-42ce-a885-609456d7189b" x="450" y="0" width="277" height="22"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jln_op}==null?
""
:$F{jln_op}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fe92ba82-5134-46b9-b492-77b4d14f4aef" x="450" y="24" width="277" height="24"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jln_wp}==null?
""
:$F{jln_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="44e86d0a-01a4-4826-b611-ea162e5b7e1b" x="734" y="0" width="108" height="22"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{total_luas_bumi}==null?
""
:new DecimalFormat("#,##0").format($F{total_luas_bumi}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="f6d18412-b7e6-472d-9d1b-41080f6fd215" x="42" y="-2" width="1" height="50"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="aa379f46-468b-4b74-ab11-5aa1af7eedba" x="734" y="23" width="108" height="22"/>
<textElement textAlignment="Right">
<font fontName="Courier New" isStrikeThrough="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{total_luas_bng}==null?
""
:new DecimalFormat("#,##0").format($F{total_luas_bng}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6d6ea130-c968-4916-a8d3-1f8075ad8e48" x="852" y="2" width="147" height="42"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{jln_wp}==null?
""
:$F{no_formulir_spop}.toString().substring(0, 4) + "."
+ $F{no_formulir_spop}.toString().substring(4, 8) + "."
+ $F{no_formulir_spop}.toString().substring(8, 11)]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="2ed93b28-be19-4154-b210-e650a0cf1c1e" x="848" y="-2" width="1" height="50"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f547313b-f39e-4c23-96eb-e111944bb7b0" x="729" y="-4" width="1" height="53"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="a753787a-379a-4818-bc3f-0f390bd56ef8" x="0" y="2" width="42" height="42"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="d0f8c828-36bd-4ae9-b7a0-7aa3c37fb226" x="999" y="2" width="1" height="42"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="54a0b534-a720-4a4a-a525-73fca8700ae8" x="250" y="0" width="176" height="44"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="60d8fc0a-3cda-49ca-9a61-66b92ed24c69" x="238" y="2" width="1" height="46"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="a0440159-30fd-43d2-be43-c4914d9d6325" x="439" y="-2" width="1" height="50"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="f2eacd10-db0c-4dfa-9655-1a5e57e8f561" x="0" y="2" width="1" height="47"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch">
<line>
<reportElement uuid="ad3df8cc-3e6e-46e4-bf68-475988817b1c" x="0" y="0" width="999" height="2"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>