|
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="ttbk" language="groovy" pageWidth="283" pageHeight="56" columnWidth="283" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="3e484694-b6f9-406d-b2be-c4decc6bbb65">
<property name="ireport.zoom" value="4.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="tahun_pajak" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT count(pbb_yg_harus_dibayar_sppt) sppt, coalesce(sum(pbb_yg_harus_dibayar_sppt),0) total
FROM pbb.SPPT
WHERE kd_propinsi = $P{kd_propinsi} AND
kd_dati2 = $P{kd_dati2} AND
kd_kecamatan= $P{kd_kecamatan} AND
thn_pajak_sppt = $P{tahun_pajak} AND
status_pembayaran_sppt = '0' AND
TGL_JATUH_TEMPO_SPPT < now() AND
pbb_yg_harus_dibayar_sppt > 5000000]]>
</queryString>
<field name="sppt" class="java.lang.Long"/>
<field name="total" class="java.math.BigDecimal"/>
<variable name="sppt_1" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{sppt}]]></variableExpression>
</variable>
<variable name="sppt_2" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{sppt}]]></variableExpression>
</variable>
<variable name="total_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{total}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<columnFooter>
<band height="17" splitType="Stretch">
<textField>
<reportElement uuid="5971ecd5-77f8-4769-99eb-e7fe74de7d0c" x="3" y="0" width="39" height="15"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($V{sppt_2}).replace(",", ".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="aa27a407-7b4b-4146-a5c0-311347f5d315" x="59" y="0" width="76" height="15"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($V{total_1}).replace(",", ".")]]></textFieldExpression>
</textField>
</band>
</columnFooter>
</jasperReport>