|
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/ReportPelayanan/ |
| [ 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="ReportBerkasSelesai" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="70d75939-dda0-4837-8686-4d3adf364069">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="156"/>
<subDataset name="dataset1" uuid="6b7020ee-41b1-426d-8041-78426988833e">
<parameter name="kd_jns_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select nm_jenis_pelayanan from pbb.ref_jns_pelayanan
where kd_jns_pelayanan = $P{kd_jns_pelayanan}]]>
</queryString>
<field name="nm_jenis_pelayanan" class="java.lang.String"/>
</subDataset>
<subDataset name="dataset2" uuid="14efaaff-bd03-429e-b4e1-cd5bead42089">
<parameter name="nip" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[SELECT nm_pegawai from pbb.pegawai
where nip = $P{nip}]]>
</queryString>
<field name="nm_pegawai" class="java.lang.String"/>
</subDataset>
<parameter name="thn_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="bundel_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<parameter name="no_urut_pelayanan" class="java.lang.String">
<defaultValueExpression><![CDATA[]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select thn_pelayanan ,
bundel_pelayanan ,
no_urut_pelayanan ,
kd_propinsi_pemohon ,
kd_dati2_pemohon ,
kd_kecamatan_pemohon ,
kd_kelurahan_pemohon ,
kd_blok_pemohon ,
no_urut_pemohon ,
kd_jns_op_pemohon ,
kd_jns_pelayanan ,
thn_pajak_permohonan,
nama_penerima ,
catatan_penyerahan ,
tgl_selesai ,
kd_seksi_berkas ,
tgl_penyerahan ,
nip_penyerah from pbb.pst_detail
where thn_pelayanan = $P{thn_pelayanan} and bundel_pelayanan = $P{bundel_pelayanan} and no_urut_pelayanan = $P{no_urut_pelayanan}
and status_selesai = '2']]>
</queryString>
<field name="thn_pelayanan" class="java.lang.String"/>
<field name="bundel_pelayanan" class="java.lang.String"/>
<field name="no_urut_pelayanan" class="java.lang.String"/>
<field name="kd_propinsi_pemohon" class="java.lang.String"/>
<field name="kd_dati2_pemohon" class="java.lang.String"/>
<field name="kd_kecamatan_pemohon" class="java.lang.String"/>
<field name="kd_kelurahan_pemohon" class="java.lang.String"/>
<field name="kd_blok_pemohon" class="java.lang.String"/>
<field name="no_urut_pemohon" class="java.lang.String"/>
<field name="kd_jns_op_pemohon" class="java.lang.String"/>
<field name="kd_jns_pelayanan" class="java.lang.String"/>
<field name="thn_pajak_permohonan" class="java.lang.String"/>
<field name="nama_penerima" class="java.lang.String"/>
<field name="catatan_penyerahan" class="java.lang.String"/>
<field name="tgl_selesai" class="java.sql.Timestamp"/>
<field name="kd_seksi_berkas" class="java.lang.String"/>
<field name="tgl_penyerahan" class="java.sql.Timestamp"/>
<field name="nip_penyerah" class="java.lang.String"/>
<background>
<band splitType="Stretch"/>
</background>
<title>
<band height="96" splitType="Stretch">
<staticText>
<reportElement uuid="06568d05-08cf-4d19-810c-b8e3d3635dc0" x="107" y="0" width="370" height="41"/>
<textElement>
<font fontName="Arial" size="14"/>
</textElement>
<text><![CDATA[DINAS PENGELOLA KEUANGAN DAN ASSET DAERAH
KABUPATEN ACEH TENGAH]]></text>
</staticText>
<staticText>
<reportElement uuid="9e88fd31-c2eb-4b62-a8af-74b78a3d0c51" x="107" y="41" width="353" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[PELAYANAN PBB DAN BPHTB]]></text>
</staticText>
<staticText>
<reportElement uuid="39dc341c-5f76-4c4d-962f-8c6ece3e8dc4" x="107" y="59" width="370" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[JL. Kol. Yos Sudarso No. 222 Takengon, Aceh Tengah]]></text>
</staticText>
</band>
</title>
<pageHeader>
<band height="50" splitType="Stretch">
<staticText>
<reportElement uuid="fc1b0f13-8c0b-4750-83a0-e9d0c8ac3e57" x="0" y="0" width="555" height="20"/>
<textElement textAlignment="Center"/>
<text><![CDATA[TANDA TERIMA PENYELESAIAN PELAYANAN]]></text>
</staticText>
<staticText>
<reportElement uuid="b30d3b02-3d9a-47bc-9d09-36ef397eb4ff" x="12" y="30" width="131" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[NOMOR PELAYANAN ]]></text>
</staticText>
<staticText>
<reportElement uuid="dcb19c43-8622-4788-a987-56e282fecad8" x="143" y="30" width="36" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<textField>
<reportElement uuid="c83faf09-3bd8-4073-a055-8014001617c1" x="179" y="30" width="167" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pelayanan} + " - " + $F{bundel_pelayanan} + " - " +
$F{no_urut_pelayanan}]]></textFieldExpression>
</textField>
</band>
</pageHeader>
<columnHeader>
<band height="31" splitType="Stretch">
<staticText>
<reportElement uuid="634f0d9d-f1f8-4ab8-a037-de21e252a83a" x="18" y="6" width="161" height="20"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<text><![CDATA[NOP]]></text>
</staticText>
<staticText>
<reportElement uuid="e1a4875f-a035-469a-adb0-1586ac8b4bed" x="296" y="6" width="134" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[Jenis Pelayanan]]></text>
</staticText>
<line>
<reportElement uuid="00d13c57-2741-4bc3-8084-76767c2f2a1b" x="12" y="0" width="1" height="31"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4da6df63-33b2-4263-9967-8a82b9528d76" x="192" y="0" width="1" height="31"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="8c2c2d2b-8479-45fd-a68e-5297040ee039" x="542" y="0" width="1" height="31"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="83f83f8e-6b3e-4337-8400-b5a4fd48f893" x="12" y="0" width="530" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="4765f77c-411e-4444-940d-a34668469132" x="12" y="30" width="530" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<staticText>
<reportElement uuid="cc5f3316-e60e-4693-afe2-ec3d3d117182" x="196" y="6" width="41" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[TAHUN]]></text>
</staticText>
<line>
<reportElement uuid="d5766f4e-2d60-4a0a-9819-74a50f865933" x="239" y="0" width="1" height="30"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
</band>
</columnHeader>
<detail>
<band height="33" splitType="Stretch">
<line>
<reportElement uuid="92a02795-b643-4d35-a19e-6d63e7081279" x="239" y="0" width="1" height="32"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="b67148ac-bc52-4e04-9a73-70406c19fb6b" x="12" y="32" width="530" height="1"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="77d622a0-db30-40b1-8433-a6530a3ac8cc" x="542" y="0" width="1" height="33"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<textField>
<reportElement uuid="3c246fae-d8df-49cc-ab08-328bc3403822" x="20" y="2" width="170" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{kd_propinsi_pemohon} + "."+$F{kd_dati2_pemohon}+"."+$F{kd_kecamatan_pemohon}
+"."+$F{kd_kelurahan_pemohon}+"."+$F{kd_blok_pemohon}+"."+
$F{no_urut_pemohon}+"."+$F{kd_jns_op_pemohon}]]></textFieldExpression>
</textField>
<line>
<reportElement uuid="db3a88f0-da45-4e53-8af8-4730a1c76b08" x="12" y="0" width="1" height="33"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<line>
<reportElement uuid="041e1ea2-9681-4e80-a856-c2a7eebfd5b6" x="192" y="0" width="1" height="33"/>
<graphicElement>
<pen lineStyle="Dashed"/>
</graphicElement>
</line>
<componentElement>
<reportElement uuid="e6e72447-5f17-474e-ac84-b8eeac348484" x="240" y="0" width="302" height="32"/>
<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="6589ddd3-1dcc-4378-9329-f8cce440cb24">
<datasetParameter name="kd_jns_pelayanan">
<datasetParameterExpression><![CDATA[$F{kd_jns_pelayanan}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="32" width="302">
<textField>
<reportElement uuid="1ae6f273-0cb6-425e-b49c-221184b606e6" stretchType="RelativeToBandHeight" x="2" y="2" width="300" height="30"/>
<textElement textAlignment="Left" verticalAlignment="Top">
<font fontName="Arial" isStrikeThrough="false"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_jenis_pelayanan}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
<textField>
<reportElement uuid="6dd0d362-fdd6-42b0-bcfa-1aeee1c3fb5a" x="196" y="2" width="41" height="20"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{thn_pajak_permohonan}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="227" splitType="Stretch">
<staticText>
<reportElement uuid="92e0355a-6b14-434f-ab82-1a004d3f2e7e" x="21" y="33" width="134" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[CATATAN PENYERAHAN]]></text>
</staticText>
<staticText>
<reportElement uuid="784db25c-73ec-4d6b-9b41-f9b3438a7d31" x="155" y="33" width="20" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<textField>
<reportElement uuid="5c180fd9-ea05-4032-8f2a-7529493d78d0" stretchType="RelativeToBandHeight" x="175" y="33" width="368" height="54"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{catatan_penyerahan}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="aa13fd2c-26e4-4156-84f7-424705a6f1e0" x="21" y="8" width="134" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[NIP / NAMA PENYERAH]]></text>
</staticText>
<staticText>
<reportElement uuid="363cf502-721c-4a1c-a6a1-ec97b24613a1" x="155" y="8" width="20" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<text><![CDATA[:]]></text>
</staticText>
<textField>
<reportElement uuid="e21e8cbd-e82e-4e45-a35f-72eaff3ea747" x="175" y="8" width="131" height="20"/>
<textElement>
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{nip_penyerah} + " / "]]></textFieldExpression>
</textField>
<textField pattern="">
<reportElement uuid="52132616-d2be-4c84-a3fd-b4381d38e908" x="263" y="88" width="214" height="20"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA["ACEH TENGAH ,"+ new SimpleDateFormat("dd").format($F{tgl_penyerahan})
+ " " +
(
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "01" ?
"Januari" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "02" ?
"Februari" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "03" ?
"Maret" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "04" ?
"April" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "05" ?
"Mei" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "06" ?
"Juni" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "07" ?
"Juli" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "08" ?
"Agustus" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "09" ?
"September" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "10" ?
"Oktober" :
new SimpleDateFormat("MM").format($F{tgl_penyerahan}) == "11" ?
"November" :
"Desember"
)
+ " "+
new SimpleDateFormat("yyyy").format($F{tgl_penyerahan})]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="523b6b6a-95e7-483b-a250-18b641f1bac1" x="263" y="107" width="214" height="20"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<text><![CDATA[PENERIMA]]></text>
</staticText>
<textField>
<reportElement uuid="93a36ccd-f7ae-4caa-a852-d783f7f44351" x="249" y="192" width="252" height="20"/>
<textElement textAlignment="Center">
<font fontName="Arial"/>
</textElement>
<textFieldExpression><![CDATA[$F{nama_penerima}]]></textFieldExpression>
</textField>
<componentElement>
<reportElement uuid="408735d6-aa22-4da1-b8d1-36fea80f59f3" x="306" y="8" width="237" height="20"/>
<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="dataset2" uuid="963dd12f-432c-4e86-8821-9066fb6d6f7f">
<datasetParameter name="nip">
<datasetParameterExpression><![CDATA[$F{nip_penyerah}]]></datasetParameterExpression>
</datasetParameter>
<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
</datasetRun>
<jr:listContents height="20" width="237">
<textField>
<reportElement uuid="b5c9c6e6-a30a-490a-9c9f-acfc7a26c4a9" x="0" y="0" width="236" height="20"/>
<textElement/>
<textFieldExpression><![CDATA[$F{nm_pegawai}]]></textFieldExpression>
</textField>
</jr:listContents>
</jr:list>
</componentElement>
</band>
</columnFooter>
</jasperReport>