AnonSec Team

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/CetakKeluaran/PenguranganKolektif/

[ Home ]	[ C0mmand ]	[ Upload File ]

Current File : C:/xampp5/htdocs/bhumie/upload/../report/CetakKeluaran/PenguranganKolektif/Keberatan_nmwp.jrxml

<?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="Keberatan_nmwp" language="groovy" pageWidth="198" pageHeight="842" columnWidth="198" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="03cfeea7-1b8b-4fa7-a337-289426b7e982">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="kd_propinsi" class="java.lang.String"/>
	<parameter name="kd_dati2" class="java.lang.String"/>
	<parameter name="kd_kecamatan" class="java.lang.String"/>
	<parameter name="kd_kelurahan" class="java.lang.String"/>
	<parameter name="kd_blok" class="java.lang.String"/>
	<parameter name="no_urut" class="java.lang.String"/>
	<parameter name="kd_jns_op" 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,
           (b.jalan_wp ||' '||b.blok_kav_no_wp) as jalan_wp,
           (a.jalan_op ||' '||a.blok_kav_no_op) as jalan_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{kd_propinsi}
		AND     a.kd_dati2 = $P{kd_dati2}
		AND     a.kd_kecamatan = $P{kd_kecamatan}
		AND     a.kd_kelurahan = $P{kd_kelurahan}
		AND     a.kd_blok = $P{kd_blok}
		AND     a.no_urut = $P{no_urut}
		AND     a.kd_jns_op = $P{kd_jns_op}));]]>
	</queryString>
	<field name="subjek_pajak_id" class="java.lang.String"/>
	<field name="nm_wp" class="java.lang.String"/>
	<field name="jalan_wp" class="java.lang.String"/>
	<field name="jalan_op" class="java.lang.String"/>
	<field name="nop" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="15" splitType="Stretch">
			<textField>
				<reportElement uuid="2c0d8cc4-bee3-4fe0-9212-bb0db054adea" x="0" y="0" width="192" height="13"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{nm_wp}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
</jasperReport>

AnonSec - 2021