|
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="14" bottomMargin="0" uuid="1588d07c-b641-45f9-9c0d-7266ca5e355c">
<property name="ireport.zoom" value="0.75"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<subDataset name="nama_bank" uuid="0e258afd-db36-4425-a216-0457ae26721e">
<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="062c156f-43b7-4073-ae3d-5810d98a2728">
<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="Ptgl_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<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_TP, KD_JNS_OP,
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, to_date($P{Ptgl_awal},'dd mm yyyy') as tgl, nip_rekam_byr_sppt
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')
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_tp" class="java.lang.String"/>
<field name="kd_jns_op" class="java.lang.String"/>
<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="tgl" class="java.sql.Date"/>
<field name="nip_rekam_byr_sppt" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<pageHeader>
<band height="45" splitType="Stretch">
<staticText>
<reportElement uuid="86bcad4b-8e09-4ae0-9fd6-7c8a741dece9" x="2" y="0" width="990" height="20"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[LAPORAN PENERIMAAN HARIAN PBB]]></text>
</staticText>
<textField>
<reportElement uuid="06e51bcd-18bd-48a2-8c4b-4b06a8fb9f49" x="2" y="20" width="990" height="14"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA["Tanggal : "+
new SimpleDateFormat("dd").format($F{tgl})
+" "+
($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")
+" "+
new SimpleDateFormat("yyyy").format($F{tgl})]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="49" splitType="Stretch">
<staticText>
<reportElement uuid="3e3d494d-d490-4541-ace6-01b089f65a6a" x="2" y="3" width="979" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="3e3d494d-d490-4541-ace6-01b089f65a6a" x="2" y="29" width="979" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="695be25a-2bc9-4c0e-aada-7302b28cd287" x="19" y="14" width="50" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NO]]></text>
</staticText>
<staticText>
<reportElement uuid="0feaaccc-d3cd-44d6-b460-bab50da61f18" x="86" y="15" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NOP | ]]></text>
</staticText>
<staticText>
<reportElement uuid="8c50d682-3b3a-42ba-b8c6-2f54920d7bee" x="270" y="15" 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="413" y="15" 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="15" 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="15" 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="15" width="84" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[JML. BAYAR (RP)]]></text>
</staticText>
<staticText>
<reportElement uuid="d8a5ef66-ea79-4e33-8ba5-422459be8e4c" x="243" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="712e055d-60d9-440c-b26b-9b0f4b9dfed1" x="64" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="45986cf7-af2c-47f9-a562-e9e65702fc37" x="382" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="a1ea3042-a3d9-478b-9fab-c0bc40e0162c" x="492" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="fdd8cec5-fe5d-4e0c-85e9-0c4751e5d4d7" x="624" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="8445859a-b08b-434a-a568-7c293fccc600" x="717" y="12" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="fdd8cec5-fe5d-4e0c-85e9-0c4751e5d4d7" x="833" y="14" width="4" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="45d68695-cb99-4730-b9f3-88f96a795a40" x="856" y="13" width="98" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NIP PEREKAM]]></text>
</staticText>
<staticText>
<reportElement uuid="45d68695-cb99-4730-b9f3-88f96a795a40" x="856" y="21" width="98" height="12"/>
<textElement textAlignment="Center">
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[NAMA PEREKAM]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="29" splitType="Stretch">
<textField>
<reportElement uuid="db75fa3e-0fef-41b3-96a3-2f1661958141" x="86" y="2" width="145" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nop}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="35bb289d-0c70-4d04-8a66-a0ec37ce6d68" x="413" y="2" 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="506" y="2" width="100" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{pokok}).replace(",",".")]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="937147fc-cfc2-4e74-a6f5-2b54dc4e75f7" x="840" y="0" width="141" height="24"/>
<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="dataset1" uuid="1d658d5c-16f7-4752-86ab-9f569a93ca64">
<datasetParameter name="nip">
<datasetParameterExpression><![CDATA[$F{nip_rekam_byr_sppt}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="24" width="141">
<textField>
<reportElement uuid="54a1c0e1-8f9f-46e3-a6ba-9e28fc9cb9ca" x="3" y="9" width="128" height="12"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="040b6c32-b934-4a38-b6e3-b113f2d3163c" x="3" y="0" width="128" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<textField>
<reportElement uuid="8c7d1e1f-e686-4e75-867b-775ee3f2fb27" x="744" y="2" width="84" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jml_sppt_yg_dibayar}).replace(",",".")]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="526e0959-def4-4f91-8975-c4f637d446c1" x="717" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="57c2eafb-0d2d-4f45-bee9-ff05b18fee3c" x="833" y="2" width="4" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="57c2eafb-0d2d-4f45-bee9-ff05b18fee3c" x="624" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="341d5723-6eef-43aa-b032-b636a58fd431" x="492" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="616710a8-13ee-4527-a80a-eec9254d807c" x="382" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<subreport>
<reportElement uuid="247f76ed-247a-4be3-897d-4801d45cc610" x="270" y="2" width="143" height="22"/>
<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>
<staticText>
<reportElement uuid="2a877d67-f2e1-4ccb-b8f0-de75da410570" x="243" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<staticText>
<reportElement uuid="9aef7571-7e23-4db1-8209-af6b4c4bb5ee" x="64" y="2" width="35" height="20"/>
<textElement/>
<text><![CDATA[|]]></text>
</staticText>
<textField>
<reportElement uuid="3424ac2b-4a4d-4289-a213-44b27905e472" x="19" y="2" width="33" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{i}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="3d1e1d58-84b3-4bcb-95a8-c4781f140d41" x="627" y="4" width="87" height="20"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda_sppt}).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</detail>
<summary>
<band height="77">
<staticText>
<reportElement uuid="84a20350-0a73-4b02-8d36-2bf9d450bd84" x="2" y="0" width="979" height="16"/>
<textElement/>
<text><![CDATA[============================================================================================================================================================================================================================================================================================================================================================]]></text>
</staticText>
<staticText>
<reportElement uuid="29f0f075-fbb0-4e4b-9a5a-f3f50944b3c2" x="86" y="12" width="100" height="20"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<text><![CDATA[Jumlah Total:]]></text>
</staticText>
<subreport>
<reportElement uuid="bda63b23-6bab-4fe0-87ad-7c7e5cdd1398" x="476" y="11" width="366" height="24"/>
<subreportParameter name="Pkd_kanwil">
<subreportParameterExpression><![CDATA[$P{Pkd_kanwil}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="Pkd_kantor">
<subreportParameterExpression><![CDATA[$P{Pkd_kantor}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="Ptgl_awal">
<subreportParameterExpression><![CDATA[$P{Ptgl_awal}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["harian_sub_jumlah.jasper"]]></subreportExpression>
</subreport>
</band>
</summary>
</jasperReport>