|
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/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="SubReportTotal" language="groovy" pageWidth="936" pageHeight="612" orientation="Landscape" columnWidth="916" leftMargin="0" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="279c6438-a583-4e59-a818-68260b443903">
<property name="ireport.zoom" value="0.9090909090909127"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<parameter name="tanggalAwal" class="java.lang.String">
<defaultValueExpression><![CDATA[$P{tanggalAwal}]]></defaultValueExpression>
</parameter>
<parameter name="tanggalAkhir" class="java.lang.String">
<defaultValueExpression><![CDATA[$P{tanggalAkhir}]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[select a.*, b.nm_jenis_pelayanan, 0+row_number() OVER(ORDER BY b.nm_jenis_pelayanan) as nomor FROM (
select b.kd_jns_pelayanan, count (b.kd_jns_pelayanan) as jumlah from pst_detail b
INNER JOIN
pbb.pst_permohonan c on c.thn_pelayanan = b.thn_pelayanan and
c.bundel_pelayanan = b.bundel_pelayanan and
c.no_urut_pelayanan = b.no_urut_pelayanan
where tgl_surat_permohonan >= to_date($P{tanggalAwal} , 'DD-MM-YYYY') and tgl_surat_permohonan <= to_date($P{tanggalAkhir}, 'DD-MM-YYYY')
group by b.kd_jns_pelayanan)
a
left join pbb.ref_jns_pelayanan b
on a.kd_jns_pelayanan = b.kd_jns_pelayanan]]>
</queryString>
<field name="kd_jns_pelayanan" class="java.lang.String"/>
<field name="jumlah" class="java.lang.Long"/>
<field name="nm_jenis_pelayanan" class="java.lang.String"/>
<field name="nomor" class="java.lang.Long"/>
<variable name="jumlah_1" class="java.lang.Long" resetType="Column" calculation="Sum">
<variableExpression><![CDATA[$F{jumlah}]]></variableExpression>
</variable>
<columnHeader>
<band height="35">
<line>
<reportElement uuid="4cee497f-d6fe-491a-9da7-b7d29d12b045" x="64" y="34" width="674" height="1"/>
</line>
<staticText>
<reportElement uuid="512c4adc-5451-4d32-b304-baa7c1bb515f" x="75" y="1" width="35" height="33"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[NO.]]></text>
</staticText>
<staticText>
<reportElement uuid="819f224b-504a-480e-92e2-5fd9f77ed2d8" x="123" y="1" width="217" height="33"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[NAMA PERMOHONAN]]></text>
</staticText>
<staticText>
<reportElement uuid="40763509-f65d-4ae1-b578-ed4eece7ef01" x="353" y="1" width="200" height="33"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[JUMLAH PERMOHONAN]]></text>
</staticText>
<staticText>
<reportElement uuid="e54e91b3-2f9b-49cd-986f-d3b977cebd1d" x="568" y="1" width="160" height="33"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[KETERANGAN]]></text>
</staticText>
<line>
<reportElement uuid="01394aeb-c070-44c7-8a65-fa167f089f46" x="738" y="1" width="1" height="34"/>
</line>
<line>
<reportElement uuid="9f5a1075-58d5-4746-b87b-fa7e5408f2d4" x="561" y="1" width="1" height="34"/>
</line>
<line>
<reportElement uuid="b0d89b87-6e03-458a-a839-138f2ca47d22" x="346" y="1" width="1" height="34"/>
</line>
<line>
<reportElement uuid="fdd118dd-9c12-40bb-a1c6-51600dd75b98" x="116" y="1" width="1" height="34"/>
</line>
<line>
<reportElement uuid="cf09cf72-02a4-4f30-a162-1bf92c194689" x="64" y="0" width="1" height="34"/>
</line>
<line>
<reportElement uuid="1d74d6c3-d65e-44be-9b23-2094ad7a6d3a" x="64" y="0" width="675" height="1"/>
</line>
</band>
</columnHeader>
<detail>
<band height="21" splitType="Stretch">
<line>
<reportElement uuid="243fc042-01a7-47d8-b88b-000eb1a93206" x="116" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="cd53815b-eb34-4a0b-8069-63c6baaafeda" x="64" y="20" width="674" height="1"/>
</line>
<line>
<reportElement uuid="548c4bcc-be82-43df-88c0-67a03a6e46bb" x="64" y="0" width="1" height="21"/>
</line>
<textField>
<reportElement uuid="1490917c-f817-4f4e-ba41-765712cd6f04" x="75" y="0" width="35" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nomor}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1f024cce-f53e-40d8-a830-b794c938cdda" x="123" y="0" width="217" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{nm_jenis_pelayanan}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="412e3c8e-3365-4f00-9d61-ca0f7dc7b73f" x="353" y="0" width="95" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{jumlah}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="985e9dbd-6048-4a7a-98a2-56ddfd9135fc" x="463" y="0" width="90" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[BERKAS]]></text>
</staticText>
<line>
<reportElement uuid="603e191c-6ae5-4e84-a0d3-8e3eb2b191d1" x="346" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="456f83bf-1c97-4106-a1d5-7a526089bd23" x="455" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="c381b43b-209f-46e5-a624-58662b16026a" x="561" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="0a90e797-355e-4937-8a9c-3828a22c4128" x="738" y="0" width="1" height="21"/>
</line>
</band>
</detail>
<columnFooter>
<band height="21">
<textField>
<reportElement uuid="bf4c576e-2c4c-444d-a1db-bfa4ac6d22da" x="353" y="0" width="95" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$V{jumlah_1}]]></textFieldExpression>
</textField>
<staticText>
<reportElement uuid="be04b774-40cb-4eba-ab4f-218e70ea5bb6" x="124" y="0" width="151" height="20"/>
<textElement verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[TOTAL BERKAS MASUK]]></text>
</staticText>
<staticText>
<reportElement uuid="fb555a9a-5295-454c-9681-cb64b05972b7" x="463" y="0" width="90" height="20"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font fontName="Arial" isBold="true"/>
</textElement>
<text><![CDATA[BERKAS]]></text>
</staticText>
<line>
<reportElement uuid="fd765793-c3a7-4ed3-b9cd-e6550c6a3187" x="64" y="-1" width="1" height="21"/>
</line>
<line>
<reportElement uuid="e68b185d-f2fe-4caa-8549-bd7f9dddeb37" x="116" y="-1" width="1" height="21"/>
</line>
<line>
<reportElement uuid="abd522b0-8842-407d-b4e4-283c91799455" x="346" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="7626c180-be9e-44cf-b1f0-876be16fd708" x="455" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="8a73f9ae-0973-4014-94b6-f1b738c15f90" x="561" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="6fd4e5e6-ba9d-45ec-ab4d-eadb421de626" x="738" y="0" width="1" height="21"/>
</line>
<line>
<reportElement uuid="8350bb6f-f59b-4d20-b5e4-b2ddbbf3a3cc" x="65" y="20" width="674" height="1"/>
</line>
</band>
</columnFooter>
</jasperReport>