|
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_perBank" language="groovy" pageWidth="992" pageHeight="595" orientation="Landscape" columnWidth="992" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="1588d07c-b641-45f9-9c0d-7266ca5e355c">
<property name="ireport.zoom" value="1.5"/>
<property name="ireport.x" value="474"/>
<property name="ireport.y" value="0"/>
<subDataset name="nama_bank_1" uuid="062a65c2-ba79-4563-8d30-2541813254f1">
<parameter name="kd_kanwil" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kantor" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_tp" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[Select nm_tp
from tempat_pembayaran
where kd_kanwil =$P{kd_kanwil}
and kd_kantor = $P{kd_kantor}
and kd_tp = $P{kd_tp}]]>
</queryString>
<field name="nm_tp" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset1" uuid="dbecd39c-2df0-430e-8b77-8690c89677e2"/>
<subDataset name="dataset2" uuid="18805e1c-313c-4a24-969a-14f2e598cd0d">
<parameter name="nip" class="java.lang.String"/>
<queryString>
<![CDATA[SELECT NIP,NM_PEGAWAI FROM PEGAWAI WHERE NIP = $P{nip}]]>
</queryString>
<field name="nip" class="java.lang.String"/>
<field name="nm_pegawai" class="java.lang.String"/>
</subDataset>
<parameter name="Pkd_kanwil" 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"/>
<queryString>
<![CDATA[SELECT row_number() OVER (ORDER BY THN_PAJAK_SPPT, KD_PROPINSI, KD_DATI2, KD_KECAMATAN, KD_KELURAHAN, KD_BLOK, NO_URUT, KD_JNS_OP) AS i, KD_PROPINSI, KD_DATI2, KD_KECAMATAN, KD_KELURAHAN, KD_BLOK, NO_URUT, KD_JNS_OP, to_date($P{Ptgl_awal},'dd mm yyyy') as tgl,
KD_PROPINSI||'.'||KD_DATI2||'.'||KD_KECAMATAN||'.'||
KD_KELURAHAN||'.'||KD_BLOK||'-'||NO_URUT||'.'||KD_JNS_OP NOP, THN_PAJAK_SPPT, DENDA_SPPT, JML_SPPT_YG_DIBAYAR, coalesce(JML_SPPT_YG_DIBAYAR,0)-coalesce(DENDA_SPPT,0) POKOK, NIP_REKAM_BYR_SPPT
FROM PEMBAYARAN_SPPT
WHERE KD_KANWIL = $P{Pkd_kanwil}
AND KD_KANTOR = $P{Pkd_kantor}
AND KD_TP = $P{Pkd_tp}
AND TGL_PEMBAYARAN_SPPT = to_date($P{Ptgl_awal},'dd mm yyyy')
ORDER BY THN_PAJAK_SPPT, KD_PROPINSI, KD_DATI2, KD_KECAMATAN, KD_KELURAHAN, KD_BLOK, NO_URUT, KD_JNS_OP]]>
</queryString>
<field name="i" class="java.lang.Long"/>
<field name="kd_propinsi" class="java.lang.String"/>
<field name="kd_dati2" class="java.lang.String"/>
<field name="kd_kecamatan" class="java.lang.String"/>
<field name="kd_kelurahan" class="java.lang.String"/>
<field name="kd_blok" class="java.lang.String"/>
<field name="no_urut" class="java.lang.String"/>
<field name="kd_jns_op" class="java.lang.String"/>
<field name="tgl" class="java.sql.Date"/>
<field name="nop" class="java.lang.String"/>
<field name="thn_pajak_sppt" class="java.lang.String"/>
<field name="denda_sppt" class="java.lang.Long"/>
<field name="jml_sppt_yg_dibayar" class="java.lang.Long"/>
<field name="pokok" class="java.lang.Long"/>
<field name="nip_rekam_byr_sppt" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="47" splitType="Stretch">
<staticText>
<reportElement uuid="86bcad4b-8e09-4ae0-9fd6-7c8a741dece9" x="331" y="0" width="238" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN PENERIMAAN HARIAN PBB]]></text>
</staticText>
<componentElement>
<reportElement uuid="d1047332-8969-45cc-8723-1cd9f1e58614" x="304" y="17" width="288" height="23"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" printOrder="Vertical">
<datasetRun subDataset="nama_bank_1" uuid="a01ddd38-bd5d-424e-a31f-bbafd3c8dc3b">
<datasetParameter name="kd_kanwil">
<datasetParameterExpression><![CDATA[$P{Pkd_kanwil}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_kantor">
<datasetParameterExpression><![CDATA[$P{Pkd_kantor}]]></datasetParameterExpression>
</datasetParameter>
<datasetParameter name="kd_tp">
<datasetParameterExpression><![CDATA[$P{Pkd_tp}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="23" width="288">
<textField>
<reportElement uuid="5c576ad6-1aa8-436b-94a8-6b46bafdd82a" x="145" y="3" width="100" height="17"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_tp} == null
? " "
: "PADA BANK "+$F{nm_tp}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<staticText>
<reportElement uuid="f9b6663c-c837-493e-82a5-ed3b44427abc" x="292" y="20" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TANGGAL]]></text>
</staticText>
<textField>
<reportElement uuid="0b74608e-359f-4387-9f3a-750e0e1e62f1" x="418" y="20" width="29" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("yyyy").format($F{tgl})]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="4781bb53-ff3e-4f70-80f9-7615151d330d" x="366" y="20" width="51" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{tgl}.getMonth() == 0 ?
"Januari" : $F{tgl}.getMonth() == 1 ?
"Februari" : $F{tgl}.getMonth() == 2 ?
"Maret" : $F{tgl}.getMonth() == 3 ?
"April" : $F{tgl}.getMonth() == 4 ?
"Mei" : $F{tgl}.getMonth() == 5 ?
"Juni" : $F{tgl}.getMonth() == 6 ?
"Juli" : $F{tgl}.getMonth() == 7 ?
"Agustus" : $F{tgl}.getMonth() == 8 ?
"September" : $F{tgl}.getMonth() == 9 ?
"Oktober" : $F{tgl}.getMonth() == 10 ?
"November" : $F{tgl}.getMonth() == 11 ?
"Desember" : "Unknown"]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="74c68b5b-92ef-4c29-804b-a70d7a058db7" x="347" y="20" width="24" height="14"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new SimpleDateFormat("dd").format(new Integer($F{tgl}.getDate()))]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="43" splitType="Stretch">
<staticText>
<reportElement uuid="3e3d494d-d490-4541-ace6-01b089f65a6a" x="2" y="1" width="980" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="3e3d494d-d490-4541-ace6-01b089f65a6a" x="2" y="26" width="980" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="695be25a-2bc9-4c0e-aada-7302b28cd287" x="19" y="12" width="50" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NO]]></text>
</staticText>
<staticText>
<reportElement uuid="0feaaccc-d3cd-44d6-b460-bab50da61f18" x="69" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="8c50d682-3b3a-42ba-b8c6-2f54920d7bee" x="245" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA WP]]></text>
</staticText>
<staticText>
<reportElement uuid="fc69ccc7-f903-411b-b920-5b11f8aefe58" x="388" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[TAHUN |]]></text>
</staticText>
<staticText>
<reportElement uuid="eba6d04d-540d-4de2-a875-cd2ec3fea896" x="513" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[POKOK (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="b1edd775-33a9-4365-8f02-18ebfb44512c" x="644" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[DENDA (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="45d68695-cb99-4730-b9f3-88f96a795a40" x="744" y="12" width="98" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML. BAYAR (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="add9112d-5ce0-45c3-9375-d3c2cb2b4022" x="371" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="37abc46f-fe5f-47ef-8a81-fd989ebab23d" x="481" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="9eaf74c5-aee3-4d67-8e1e-38a96bc15b96" x="613" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="ba7e9583-1a64-4ae6-b483-d7ab24726516" x="232" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d68f5eb9-25ed-4653-b7c4-cea6e3e84614" x="724" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="b3af548b-ca8a-4dfa-8d5c-c08c2b86711a" x="53" y="10" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="45d68695-cb99-4730-b9f3-88f96a795a40" x="868" y="10" width="98" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NIP /]]></text>
</staticText>
<staticText>
<reportElement uuid="d68f5eb9-25ed-4653-b7c4-cea6e3e84614" x="848" y="10" width="6" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="45d68695-cb99-4730-b9f3-88f96a795a40" x="868" y="19" width="98" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA PEREKAM]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="30">
<textField>
<reportElement uuid="db75fa3e-0fef-41b3-96a3-2f1661958141" x="69" y="1" width="178" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="35bb289d-0c70-4d04-8a66-a0ec37ce6d68" x="388" y="0" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_sppt}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="38456146-5760-472c-95a7-a58b6eb1b61f" x="489" 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>
<textField>
<reportElement uuid="3d1e1d58-84b3-4bcb-95a8-c4781f140d41" x="614" 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="8c7d1e1f-e686-4e75-867b-775ee3f2fb27" x="736" y="0" width="86" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt_yg_dibayar}).replace(",",".")]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="773fdce3-562c-47d6-b33c-3baeb2071637" x="244" y="0" width="128" height="20"/>
<subreportParameter name="kd_propinsi">
<subreportParameterExpression><![CDATA[$F{kd_propinsi}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_dati2">
<subreportParameterExpression><![CDATA[$F{kd_dati2}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kecamatan">
<subreportParameterExpression><![CDATA[$F{kd_kecamatan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_kelurahan">
<subreportParameterExpression><![CDATA[$F{kd_kelurahan}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_blok">
<subreportParameterExpression><![CDATA[$F{kd_blok}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="no_urut">
<subreportParameterExpression><![CDATA[$F{no_urut}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kd_jns_op">
<subreportParameterExpression><![CDATA[$F{kd_jns_op}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="thn_pajak_sppt">
<subreportParameterExpression><![CDATA[$F{thn_pajak_sppt}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["harian_sub.jasper"]]></subreportExpression>
</subreport>
<textField>
<reportElement uuid="69558df7-b135-43d0-9dc4-17c5aba71c5a" x="19" y="0" width="32" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{i}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="76e4abb0-cd92-44a4-82e5-2f0b2a60d9c9" x="371" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="1eb859fa-8be4-4231-9be8-ec6e488e2e7a" x="481" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="c3819cd1-dd4a-4243-99f7-108100e567f7" x="613" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="750609f8-c6ba-4aeb-b09a-3602a237d8a5" x="232" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="85b58270-91f2-4798-b51c-365b38d1c3b1" x="724" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="ab717ef8-23f3-413d-bd7c-d8b89a50e87f" x="53" y="-2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="d68f5eb9-25ed-4653-b7c4-cea6e3e84614" x="848" y="-2" width="6" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<componentElement>
<reportElement uuid="5438a1c9-4c0b-420d-b79c-7ce8d614b6d9" x="855" y="1" width="134" height="25"/>
<jr:list xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
<datasetRun subDataset="dataset2" uuid="6761c096-5556-47dd-89fb-7f64693ce189">
<datasetParameter name="nip">
<datasetParameterExpression><![CDATA[$F{nip_rekam_byr_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="25" width="134">
<textField>
<reportElement uuid="e274fac9-2283-49a4-9981-4e2aa24b4162" x="10" y="0" width="124" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="e274fac9-2283-49a4-9981-4e2aa24b4162" x="10" y="11" width="124" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</detail>
<summary>
<band height="72">
<staticText>
<reportElement uuid="900879ac-0de2-48b0-a244-648262b4998f" x="2" y="0" width="980" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<subreport>
<reportElement uuid="ced451fc-9c96-461b-a76f-fb4b934f7e8a" x="476" y="10" width="341" height="24"/>
<subreportParameter name="Pkd_tp">
<subreportParameterExpression><![CDATA[$P{Pkd_tp}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="Ptgl_awal">
<subreportParameterExpression><![CDATA[$P{Ptgl_awal}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="Pkd_kantor">
<subreportParameterExpression><![CDATA[$P{Pkd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="Pkd_kanwil">
<subreportParameterExpression><![CDATA[$P{Pkd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["harian_sub_jumlah_bank.jasper"]]></subreportExpression>
</subreport>
<staticText>
<reportElement uuid="7be58329-b369-4454-80b6-f55097be147e" x="66" y="11" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah Total:]]></text>
</staticText>
</band>
</summary>
</jasperReport>