|
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/report/PengeluaranHimbauan/ |
| [ 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="himbauan_sub_data_sum" language="groovy" pageWidth="595" pageHeight="216" columnWidth="595" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="69a5e936-4dbe-48b7-8b5e-f0a141a25ea9">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kota" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kecamatan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_kelurahan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_blok" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="kd_jns_op" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_awal" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="thn_akhir" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="tgl_terbit" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select sum(c.pbb_yg_harus_dibayar_sppt),
sum(case
when e.denda_adm_stlh_pengurangan != null then e.denda_adm_stlh_pengurangan
when e.denda_adm_stlh_pengurangan is null then (
(0.02 *
(
case when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) > 48 then 48
when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) < 0 then 0
else
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
end
)
) * c.pbb_terhutang_sppt
)
end ) as denda,
sum(case
when e.denda_adm_stlh_pengurangan != null then e.denda_adm_stlh_pengurangan
when e.denda_adm_stlh_pengurangan is null then (
(0.02 *
(
case when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) > 48 then 48
when
(
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
) < 0 then 0
else
(
case when
(
(DATE_PART('day', $P{tgl_terbit}::date) - DATE_PART('day', c.tgl_jatuh_tempo_sppt::date))
) < 0 then 0
else 1
end
) +
(DATE_PART('year', $P{tgl_terbit}::date) * 12) + DATE_PART('month', $P{tgl_terbit}::date) -
(DATE_PART('year', c.tgl_jatuh_tempo_sppt::date) * 12) + DATE_PART('month', c.tgl_jatuh_tempo_sppt::date)
end
)
) * c.pbb_terhutang_sppt
)
end + c.pbb_yg_harus_dibayar_sppt ) as jumlah_pbb_terhutang
from
sppt c left join pembayaran_sppt d on(c.kd_propinsi = d.kd_propinsi
and c.kd_dati2 = d.kd_dati2
and c.kd_kecamatan = d.kd_kecamatan
and c.kd_kelurahan = d.kd_kelurahan
and c.kd_blok = d.kd_blok
and c.no_urut = d.no_urut
and c.kd_jns_op = d.kd_jns_op
and c.thn_pajak_sppt = d.thn_pajak_sppt)
left join denda_administrasi e on (
c.kd_propinsi = e.kd_propinsi
and c.kd_dati2 = e.kd_dati2
and c.kd_kecamatan = e.kd_kecamatan
and c.kd_kelurahan = e.kd_kelurahan
and c.kd_blok = e.kd_blok
and c.no_urut = e.no_urut
and c.kd_jns_op = e.kd_jns_op
and c.thn_pajak_sppt = e.thn_denda
)
where
c.kd_propinsi = $P{kd_propinsi} and
c.kd_dati2 = $P{kd_kota} and
c.kd_kecamatan = $P{kd_kecamatan} and
c.kd_kelurahan = $P{kd_kelurahan} and
c.kd_blok = $P{kd_blok} and
c.no_urut = $P{no_urut} and
c.kd_jns_op = $P{kd_jns_op} and
to_number(c.thn_pajak_sppt, '9999') >= to_number($P{thn_awal},'9999') and
to_number(c.thn_pajak_sppt, '9999') <= to_number($P{thn_akhir},'9999')]]>
</queryString>
<field name="sum" class="java.math.BigDecimal"/>
<field name="denda" class="java.lang.Double"/>
<field name="jumlah_pbb_terhutang" class="java.lang.Double"/>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement uuid="fea5e05e-c00d-4d86-95b5-5f56d9680531" x="60" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{sum}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5e50bd3d-0d20-410e-9828-aff69be3e6e1" x="274" y="0" width="47" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{denda}).replace(",",".")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="26e0c524-c97b-4868-8257-14f16ca9502b" x="393" y="0" width="100" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[new DecimalFormat("#,##0").format($F{jumlah_pbb_terhutang}).replace(",",".")]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>