|
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="detil_perBankScount" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="842" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="565c75f7-2cd9-465b-ba51-e1eb77d107a9">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="112"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" 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="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}
)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}
)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"/>
<variable name="sum_cp1" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_1}]]></variableExpression>
</variable>
<variable name="sum_cp2" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_2}]]></variableExpression>
</variable>
<variable name="sum_cp3" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_3}]]></variableExpression>
</variable>
<variable name="sum_cp4" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_4}]]></variableExpression>
</variable>
<variable name="sum_cp5" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_5}]]></variableExpression>
</variable>
<variable name="sum_cp6" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_6}]]></variableExpression>
</variable>
<variable name="sum_cp7" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_7}]]></variableExpression>
</variable>
<variable name="sum_cp8" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_8}]]></variableExpression>
</variable>
<variable name="sum_cp9" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_9}]]></variableExpression>
</variable>
<variable name="sum_cp10" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_10}]]></variableExpression>
</variable>
<variable name="sum_cp11" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_11}]]></variableExpression>
</variable>
<variable name="sum_cp12" class="java.lang.Double">
<variableExpression><![CDATA[$F{cp_12}]]></variableExpression>
</variable>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="23">
<textField>
<reportElement uuid="8407f6d8-d5c1-49c1-8385-aebca29282a4" x="3" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp1}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f2ec02a0-087e-4d66-8f2b-d427a5ad37fe" x="67" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp2}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5c1442c5-96f6-4aff-b45e-2b35b4c21fe5" x="127" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp3}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7ab11372-1f4b-459f-a2cd-6c1df1d40304" x="188" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp4}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="10c0d306-662e-41b2-887c-2d8f5f562488" x="248" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp8}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="11867692-ad80-4c6a-81e2-ec7c2f930bc7" x="306" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp7}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="7e7e0817-1df8-4c32-8273-7f21e175386d" x="366" y="0" width="44" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp6}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="a8b57ec4-7cb1-4260-b099-4ba609f9987f" x="422" y="0" width="44" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp5}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="b03c2c36-e4d8-41f5-870d-5de7580b849a" x="479" y="0" width="44" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp12}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="86b2390c-aab2-4591-806a-ecbb99068018" x="536" y="0" width="44" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp11}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="028282b1-44a3-49ba-88fa-b0208066afd2" x="590" y="0" width="48" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp10}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="c24ae254-6615-4c1a-82c4-29a113d302f2" x="651" y="0" width="51" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$V{sum_cp9}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="1" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="f63c4cb7-4565-418b-8ffb-df98437147e2" x="473" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="57" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="120" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="181" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="241" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="300" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="359" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="415" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="529" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="584" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="644" y="1" width="1" height="15"/>
</line>
<line>
<reportElement uuid="b7aa5dfb-f2a5-4460-b695-7f9cab84e17e" x="706" y="1" width="1" height="15"/>
</line>
</band>
</detail>
</jasperReport>