|
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/upload/../report/SKKeberatan/ |
| [ 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="SKKeberatan_wp" language="groovy" pageWidth="453" pageHeight="842" columnWidth="453" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="2f3fdb2d-f9c0-4af0-8bfd-cccdb74c5a22">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="propinsi_pemohon" class="java.lang.String"/>
<parameter name="dati2_pemohon" class="java.lang.String"/>
<parameter name="kecamatan_pemohon" class="java.lang.String"/>
<parameter name="kelurahan_pemohon" class="java.lang.String"/>
<parameter name="kd_blok_pemohon" class="java.lang.String"/>
<parameter name="no_urut_pemohon" class="java.lang.String"/>
<parameter name="kd_jenis_op_pemohon" class="java.lang.String"/>
<parameter name="thn_pajak_permohonan" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT RTRIM(LTRIM(A.SUBJEK_PAJAK_ID)) as subjek_pajak_id, RTRIM(LTRIM(B.NM_WP)) as nm_wp,
initcap(b.jalan_wp ||' '||b.blok_kav_no_wp) as alamat_wp,
initcap(a.jalan_op ||' '||a.blok_kav_no_op) as alamat_op,
(a.kd_propinsi||'.'||a.kd_dati2||'.'||a.kd_kecamatan||'.'||
a.kd_kelurahan||'.'||a.kd_blok||'-'||a.no_urut||'.'||kd_jns_op) as nop
FROM pbb.DAT_OBJEK_PAJAK A, pbb.DAT_SUBJEK_PAJAK B
WHERE ((A.SUBJEK_PAJAK_ID=B.SUBJEK_PAJAK_ID)
AND (a.kd_propinsi = $P{propinsi_pemohon}
AND a.kd_dati2 = $P{dati2_pemohon}
AND a.kd_kecamatan = $P{kecamatan_pemohon}
AND a.kd_kelurahan = $P{kelurahan_pemohon}
AND a.kd_blok = $P{kd_blok_pemohon}
AND a.no_urut = $P{no_urut_pemohon}
AND a.kd_jns_op = $P{kd_jenis_op_pemohon}));]]>
</queryString>
<field name="subjek_pajak_id" class="java.lang.String"/>
<field name="nm_wp" class="java.lang.String"/>
<field name="alamat_wp" class="java.lang.String"/>
<field name="alamat_op" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="73" splitType="Stretch">
<staticText>
<reportElement uuid="a455009d-7133-4b3d-8692-4567bd39a71a" x="0" y="0" width="133" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Nama Wajib Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="a455009d-7133-4b3d-8692-4567bd39a71a" x="0" y="13" width="133" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP :]]></text>
</staticText>
<staticText>
<reportElement uuid="a455009d-7133-4b3d-8692-4567bd39a71a" x="0" y="26" width="133" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="a455009d-7133-4b3d-8692-4567bd39a71a" x="0" y="42" width="133" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Alamat Wajib Pajak :]]></text>
</staticText>
<staticText>
<reportElement uuid="a455009d-7133-4b3d-8692-4567bd39a71a" x="0" y="58" width="133" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Letak Tanah/Bangunan :]]></text>
</staticText>
<textField>
<reportElement uuid="82af84d9-f067-47df-9307-5179b202671e" x="133" y="0" width="320" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b4c3b395-ce1d-4638-8078-18b1721d4ff0" x="133" y="13" width="320" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e9db7916-4ace-43ae-9722-c2fd9959e4bf" x="133" y="26" width="320" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{thn_pajak_permohonan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c7d0b480-f902-4443-a6db-296bb7d978eb" x="133" y="42" width="320" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_wp}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="349f8472-8f4b-4958-bb1b-f76e6e8ddd8a" x="133" y="58" width="320" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{alamat_op}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
</jasperReport>