|
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/SKKepalaDaerah/ |
| [ 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="SKZntSistep_2" language="groovy" pageWidth="7200" pageHeight="595" columnWidth="7200" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="1e3ddd81-c151-44f0-8515-43682de85a85">
<property name="ireport.zoom" value="1.4641000000000006"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="kd_propinsi" class="java.lang.String"/>
<parameter name="kd_dati2" class="java.lang.String"/>
<parameter name="kd_kecamatan" class="java.lang.String"/>
<parameter name="kd_kelurahan" class="java.lang.String"/>
<parameter name="tahun_pajak" class="java.lang.String"/>
<parameter name="kd_znt" class="java.lang.String"/>
<parameter name="SUBREPORT_DIR" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select (pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric))).vlc_kd_kelas,(pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric))).vlc_thn_awal_kls,(pbb.penentuan_kelas('1',temp.thn_nir_znt,cast(temp.nir as numeric))).vln_njop_perm2
from
(SELECT '1', $P{tahun_pajak}::character varying as thn_nir_znt,coalesce(nilai_per_m2_tanah,0)*1000 as nir
FROM kelas_tanah
WHERE rpad(kd_kls_tanah,3) = rpad($P{kd_znt},3)) as temp]]>
</queryString>
<field name="vlc_kd_kelas" class="java.lang.String"/>
<field name="vlc_thn_awal_kls" class="java.lang.String"/>
<field name="vln_njop_perm2" class="java.math.BigDecimal"/>
<background>
<band splitType="Stretch"/>
</background>
<detail>
<band height="17" splitType="Stretch">
<textField>
<reportElement uuid="51805827-ca13-4011-aeb9-32a66bda8bf1" x="4" y="0" width="35" height="16"/>
<textElement>
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{vlc_kd_kelas}]]></textFieldExpression>
</textField>
<textField pattern="#,##0">
<reportElement uuid="4df22d80-969c-40bb-b616-4cd55ba929bd" x="201" y="1" width="75" height="15"/>
<textElement textAlignment="Right">
<font fontName="Courier New"/>
</textElement>
<textFieldExpression><![CDATA[$F{vln_njop_perm2}]]></textFieldExpression>
</textField>
<subreport>
<reportElement uuid="d76769cc-1a1a-4fbc-82d8-1076abfea18a" x="40" y="0" width="126" height="16"/>
<subreportParameter name="tahun_pajak">
<subreportParameterExpression><![CDATA[$P{tahun_pajak}]]></subreportParameterExpression>
</subreportParameter>
<subreportParameter name="kls_tanah">
<subreportParameterExpression><![CDATA[$F{vlc_kd_kelas}]]></subreportParameterExpression>
</subreportParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
<subreportExpression><![CDATA["SKZntSistep_3.jasper"]]></subreportExpression>
</subreport>
</band>
</detail>
</jasperReport>