<?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="Keberatan_Nopel" language="groovy" pageWidth="425" pageHeight="1008" columnWidth="425" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="db3093d8-146c-45ba-b1ff-68c30d9ea72b">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="kd_kanwil" class="java.lang.String"/>
	<parameter name="kd_kantor" class="java.lang.String"/>
	<parameter name="thn_pelayanan" class="java.lang.String"/>
	<parameter name="bundel_pelayanan" class="java.lang.String"/>
	<parameter name="no_urut_pelayanan" class="java.lang.String"/>
	<queryString>
		<![CDATA[SELECT RTRIM(LTRIM(no_srt_permohonan)) as no_surat, to_char(tgl_surat_permohonan, 'DD/MM/YYYY') as tgl_surat,
		to_char(tgl_terima_dokumen_wp, 'DD/MM/YYYY') as tgl_terima
		FROM   pbb.pst_permohonan
		WHERE  kd_kanwil         = $P{kd_kanwil}
		AND    kd_kantor         = $P{kd_kantor}
		AND    thn_pelayanan     = $P{thn_pelayanan}
		AND    bundel_pelayanan  = $P{bundel_pelayanan}
		AND    no_urut_pelayanan = $P{no_urut_pelayanan}]]>
	</queryString>
	<field name="no_surat" class="java.lang.String"/>
	<field name="tgl_surat" class="java.lang.String"/>
	<field name="tgl_terima" class="java.lang.String"/>
	<variable name="vlc_tgl" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[$F{tgl_surat}.substring(0,2)]]></variableExpression>
	</variable>
	<variable name="vlc_bln" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[$F{tgl_surat}.substring(3,5)]]></variableExpression>
	</variable>
	<variable name="vlc_tahun" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[$F{tgl_surat}.substring(6,10)]]></variableExpression>
	</variable>
	<variable name="vlc_bulan" class="java.lang.String" resetType="None">
		<variableExpression><![CDATA[($V{vlc_bln} == 1) ? "JANUARI" :  (
    ($V{vlc_bln} == 2) ? "PEBRUARI" : (
          ($V{vlc_bln} == 3) ? "MARET" :  (
                    ($V{vlc_bln} == 4) ? "APRIL" :  (
                         ($V{vlc_bln} == 5) ? "MEI" :  (
                              ($V{vlc_bln} == 6) ? "JUNI" :  (
                                   ($V{vlc_bln} == 7) ? "JULI" :  (
                                        ($V{vlc_bln} == 8) ? "AGUSTUS" :  (
                                             ($V{vlc_bln} == 9) ? "SEPTEMBER" :  (
                                                  ($V{vlc_bln} == 10) ? "OKTOBER" :  (
                                                       ($V{vlc_bln} == 11) ? "NOVEMBER" :  "DESEMBER"
                                                    )
                                               )
                                          )
                                     )
                                )
                           )
                      )
                 )
            )
   )]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="14" splitType="Stretch">
			<textField>
				<reportElement uuid="10c31c70-3067-452f-b546-a5fb96678540" x="0" y="1" width="425" height="13"/>
				<textElement>
					<font fontName="Courier New"/>
				</textElement>
				<textFieldExpression><![CDATA["Nomor "+$F{no_surat}+", tanggal "+$V{vlc_tgl}+" "+$V{vlc_bulan}+" "+$V{vlc_tahun}+" dari "]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
</jasperReport>