|
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="rekap_perBanks" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="270a8351-be20-44e2-9a9b-c382de81af5d">
<property name="ireport.zoom" value="0.75"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_kanwil" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="Pkd_kecamatan" class="java.lang.String"/>
<parameter name="Pkd_kelurahan" class="java.lang.String"/>
<parameter name="Pkd_kantor" class="java.lang.String"/>
<parameter name="Pkd_tp" class="java.lang.String"/>
<parameter name="Ptgl_awal" class="java.lang.String"/>
<parameter name="Ptgl_akhir" class="java.lang.String"/>
<queryString>
<![CDATA[select
a.cp_1
,a.cp_4 - a.cp_3 as cp_2
,a.cp_3
,a.cp_4
,b.cp_5
,b.cp_8 - b.cp_7 as cp_6
,b.cp_7
,b.cp_8
,a.cp_1 + b.cp_5 as cp_9
,(a.cp_4 - a.cp_3) + (b.cp_8 - b.cp_7) as cp_10
,cp_3 + cp_7 as cp_11
,cp_4 + cp_8 as cp_12
from (
Select 1 as id,coalesce(COUNT(*),0) as cp_1, coalesce(sum(DENDA_SPPT),0) as cp_3, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) as cp_4
from pbb.pembayaran_sppt
where tgl_pembayaran_sppt < date($P{Ptgl_awal}
) and tgl_pembayaran_sppt >= date(to_char(date($P{Ptgl_awal}),'YYYY')||'-01-01')
and kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
)a left join (
Select 1 as id,coalesce(COUNT(*),0) as cp_5, coalesce(sum(DENDA_SPPT),0) as cp_7, coalesce(sum(JML_SPPT_YG_DIBAYAR),0) as cp_8
from pbb.Pembayaran_sppt
where tgl_pembayaran_sppt between date($P{Ptgl_akhir}) and date($P{Ptgl_awal})
and kd_propinsi = $P{kd_propinsi}
and kd_dati2 = $P{kd_dati2}
and kd_kecamatan= $P{Pkd_kecamatan}
and kd_kelurahan= $P{Pkd_kelurahan}
and kd_kanwil like $P{kd_kanwil}
and kd_kantor like $P{Pkd_kantor}
and kd_tp like $P{Pkd_tp}
)b on a.id = b.id]]>
</queryString>
<field name="cp_1" class="java.lang.Long"/>
<field name="cp_2" class="java.math.BigDecimal"/>
<field name="cp_3" class="java.math.BigDecimal"/>
<field name="cp_4" class="java.math.BigDecimal"/>
<field name="cp_5" class="java.lang.Long"/>
<field name="cp_6" class="java.math.BigDecimal"/>
<field name="cp_7" class="java.math.BigDecimal"/>
<field name="cp_8" class="java.math.BigDecimal"/>
<field name="cp_9" class="java.lang.Long"/>
<field name="cp_10" class="java.math.BigDecimal"/>
<field name="cp_11" class="java.math.BigDecimal"/>
<field name="cp_12" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="22" splitType="Stretch">
<textField>
<reportElement uuid="ec9f58b6-42d1-496e-8306-b997c887a281" x="7" y="0" width="53" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="437400e6-9ba8-4d33-947b-d70b8f4ad4bf" x="71" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="bca6bcc0-b9b7-4f2e-bf91-cca966b362b5" x="127" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_3}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="d44d200c-353b-4dd5-9828-8701677d073b" x="184" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_4}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0c394f45-8268-4d7e-b26d-84e5a4e7162d" x="240" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_8}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="21306525-f135-400e-ada7-0cd1afd98ed1" x="296" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_7}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="064064a5-4c12-4a87-8a4a-5ccf17ad696c" x="352" y="0" width="51" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_6}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="44e3bdf4-40e8-40ad-816d-6489a940c477" x="413" y="0" width="51" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_5}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7ded5397-8a7d-404d-b919-ad63fcbfe003" x="474" y="0" width="54" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_12}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="56d85c34-83b8-461f-8c74-0aef20db4b4d" x="539" y="0" width="52" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_11}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="cf4f6483-c837-40d5-ada3-831fa51a10b2" x="602" y="0" width="51" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_10}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="61a96bcd-8d20-42ae-9c13-d0eb90f431fd" x="664" y="0" width="45" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{cp_9}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="3" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="65" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="121" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="177" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="234" y="2" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="290" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="346" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="407" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="468" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="533" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="596" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="657" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="4bcdafc7-65f1-414f-9ef2-91f1159e9cbf" x="713" y="1" width="1" height="15"/>
</line>
</band>
</detail>
</jasperReport>