|
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/SKKepalaDaerah/ |
| [ 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="SKPemantauanOP_3" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="9f3aaf10-1007-42f6-8684-db0a68c94da4">
<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="jalan_op" class="java.lang.String"/>
<parameter name="thn_pajak_sppt" class="java.lang.String"/>
<parameter name="kd_znt" class="java.lang.String"/>
<queryString>
<![CDATA[select SUM(b.pbb_terhutang_sppt) as pbb_terhutang, SUM(b.njop_sppt) as njop_terhutang
FROM pbb.SPPT B,
pbb.DAT_OP_BUMI C,
pbb.DAT_OBJEK_PAJAK A
WHERE B.kd_propinsi = c.kd_propinsi and
B.kd_dati2 = c.kd_dati2 and
B.kd_kecamatan = c.kd_kecamatan and
B.kd_kelurahan = c.kd_kelurahan and
B.kd_blok = c.kd_blok and
B.no_urut = c.no_urut and
B.kd_jns_op = c.kd_jns_op AND
A.kd_propinsi = c.kd_propinsi and
A.kd_dati2 = c.kd_dati2 and
A.kd_kecamatan = c.kd_kecamatan and
A.kd_kelurahan = c.kd_kelurahan and
A.kd_blok = c.kd_blok and
A.no_urut = c.no_urut and
A.kd_jns_op = c.kd_jns_op AND
B.kd_propinsi = A.kd_propinsi and
B.kd_dati2 = A.kd_dati2 and
B.kd_kecamatan = A.kd_kecamatan and
B.kd_kelurahan = A.kd_kelurahan and
B.kd_blok = A.kd_blok and
B.no_urut = A.no_urut and
B.kd_jns_op = A.kd_jns_op AND
RTRIM(A.JALAN_OP) = $P{jalan_op} AND
C.KD_ZNT = $P{kd_znt} AND
C.KD_PROPINSI = $P{kd_propinsi} AND
C.KD_DATI2 = $P{kd_dati2} AND
C.KD_KECAMATAN = $P{kd_kecamatan} AND
B.THN_PAJAK_SPPT = $P{thn_pajak_sppt};]]>
</queryString>
<field name="pbb_terhutang" class="java.math.BigDecimal"/>
<field name="njop_terhutang" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<columnHeader>
<band height="21" splitType="Stretch">
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="-1" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="176" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="92" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="-1" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="176" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="370" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="370" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="92" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="273" y="-1" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1e778c55-38ec-43e8-a118-f754830e406b" x="273" y="8" width="4" height="13"/>
<textElement textAlignment="Center" verticalAlignment="Top">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="f8af7842-e12a-4454-97b9-d3384edc107e" x="10" y="1" width="80" height="17"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{pbb_terhutang}.doubleValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="81d285e5-85e2-4f1a-acb7-afe589fa362b" x="191" y="1" width="80" height="17"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{njop_terhutang}.doubleValue())]]></textFieldExpression>
</textField>
</band>
</columnHeader>
</jasperReport>