|
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/LaporanPembayaran/ |
| [ 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="harian_sub_jumlah" language="groovy" pageWidth="595" pageHeight="72" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="bab83dd6-a219-464f-bde2-4daddde84597">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="Pkd_kanwil" class="java.lang.String"/>
<parameter name="Pkd_kantor" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="Pkd_tp" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT sum(DENDA_SPPT) as DENDA_SPPT, sum(JML_SPPT_YG_DIBAYAR) as JML_SPPT_YG_DIBAYAR, sum(coalesce(JML_SPPT_YG_DIBAYAR,0)-coalesce(DENDA_SPPT,0)) as POKOK
FROM PEMBAYARAN_SPPT
WHERE KD_KANWIL = $P{Pkd_kanwil}
AND KD_KANTOR = $P{Pkd_kantor}
AND TGL_PEMBAYARAN_SPPT = to_date($P{Ptgl_awal},'dd mm yyyy')
AND KD_TP = $P{Pkd_tp}]]>
</queryString>
<field name="denda_sppt" class="java.math.BigDecimal"/>
<field name="jml_sppt_yg_dibayar" class="java.math.BigDecimal"/>
<field name="pokok" class="java.math.BigDecimal"/>
<columnFooter>
<band height="20">
<textField>
<reportElement uuid="e36c069b-62da-487e-8f53-1eedf7865cdb" x="138" y="0" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="356d7cf5-c60b-45cc-b6e5-576161468338" x="290" y="0" width="57" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt_yg_dibayar}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="56258316-1f3f-4f9c-8546-1ed8aba7488a" x="14" y="0" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pokok}).replace(",",".")]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="41f63749-4f80-4166-a0f3-5d45e46fae80" x="3" y="0" width="28" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="e850bad8-be97-4f84-bac7-6a39984f6851" x="135" y="0" width="28" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="6824d392-c105-499a-8d82-b6556f5431bc" x="246" y="0" width="28" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[|]]></text>
</staticText>
</band>
</columnFooter>
</jasperReport>