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/DaftarTunggakan/

[ Home ]	[ C0mmand ]	[ Upload File ]

Current File : C:/xampp5/htdocs/bhumie/upload/../report/DaftarTunggakan/buku.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="buku" language="groovy" pageWidth="131" pageHeight="56" orientation="Landscape" columnWidth="131" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="e7995187-2e16-4212-b60b-f451f867fbaa">
	<property name="ireport.zoom" value="7.0"/>
	<property name="ireport.x" value="313"/>
	<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="tahun_pajak" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT count(pbb_yg_harus_dibayar_sppt) sppt, coalesce(sum(pbb_yg_harus_dibayar_sppt),'0') as total
FROM pbb.SPPT
WHERE kd_propinsi = $P{kd_propinsi} AND
kd_dati2	= $P{kd_dati2} AND
kd_kecamatan= $P{kd_kecamatan} AND
kd_kelurahan= $P{kd_kelurahan} AND
thn_pajak_sppt = $P{tahun_pajak} AND
status_pembayaran_sppt = '0' AND
TGL_JATUH_TEMPO_SPPT  < now() AND
pbb_yg_harus_dibayar_sppt BETWEEN 0 AND 100001]]>
	</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="total_1" class="java.math.BigDecimal" resetType="Column" calculation="Sum">
		<variableExpression><![CDATA[$F{total}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<detail>
		<band height="16" splitType="Stretch">
			<textField>
				<reportElement uuid="b01815f3-2cd4-4936-8835-55a653f5c8ea" x="4" y="0" width="38" height="15"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{sppt}).replace(",", ".")]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6dcb0b7a-35f6-41aa-afd6-1dbe39ce0f5e" x="50" y="0" width="76" height="15"/>
				<textElement textAlignment="Right">
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{total}).replace(",", ".")]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>

AnonSec - 2021