| @@ -0,0 +1,249 @@ | ||
| <?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="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> | ||
| <property name="ireport.zoom" value="2.0"/> | ||
| <property name="ireport.x" value="0"/> | ||
| <property name="ireport.y" value="0"/> | ||
| <parameter name="parameter" class="java.lang.String"> | ||
| <defaultValueExpression><![CDATA[]]></defaultValueExpression> | ||
| </parameter> | ||
| <parameter name="namars" class="java.lang.String"/> | ||
| <parameter name="alamatrs" class="java.lang.String"/> | ||
| <parameter name="kotars" class="java.lang.String"/> | ||
| <parameter name="propinsirs" class="java.lang.String"/> | ||
| <parameter name="kontakrs" class="java.lang.String"/> | ||
| <parameter name="emailrs" class="java.lang.String"/> | ||
| <parameter name="logo" class="java.io.InputStream"/> | ||
| <parameter name="tanggal1" class="java.lang.String"/> | ||
| <parameter name="tanggal2" class="java.lang.String"/> | ||
| <parameter name="barang" class="java.lang.String"/> | ||
| <queryString> | ||
| <![CDATA[select databarang.kode_brng,databarang.nama_brng,kodesatuan.satuan,jenis.nama as jenis, | ||
| sum(detail_permintaan_medis.jumlah) as jumlah from databarang inner join kodesatuan | ||
| inner join jenis inner join detail_permintaan_medis inner join permintaan_medis | ||
| on databarang.kode_brng=detail_permintaan_medis.kode_brng and databarang.kode_sat=kodesatuan.kode_sat | ||
| and databarang.kdjns=jenis.kdjns and detail_permintaan_medis.no_permintaan=permintaan_medis.no_permintaan | ||
| where permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} | ||
| group by databarang.kode_brng order by databarang.kode_brng]]> | ||
| </queryString> | ||
| <field name="kode_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="nama_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="satuan" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="jenis" class="java.lang.String"/> | ||
| <field name="jumlah" class="java.lang.Double"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <background> | ||
| <band splitType="Stretch"/> | ||
| </background> | ||
| <title> | ||
| <band height="84" splitType="Stretch"> | ||
| <textField> | ||
| <reportElement x="0" y="49" width="555" height="18"/> | ||
| <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single" markup="none"> | ||
| <font fontName="Tahoma" size="11" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Rekap Pengajuan Permintaan Barang Non Medis Periode "+$P{tanggal1}+" s.d. "+$P{tanggal2}]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <textField> | ||
| <reportElement x="2" y="14" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="35" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="25" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="0" width="553" height="17"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="12"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression> | ||
| </textField> | ||
| <image scaleImage="FillFrame" onErrorType="Blank"> | ||
| <reportElement x="0" y="2" width="48" height="45"/> | ||
| <imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression> | ||
| </image> | ||
| <line> | ||
| <reportElement x="0" y="48" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="2.0" lineStyle="Double"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </title> | ||
| <pageHeader> | ||
| <band splitType="Stretch"/> | ||
| </pageHeader> | ||
| <columnHeader> | ||
| <band height="16" splitType="Stretch"> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="505" y="0" width="50" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jumlah]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="348" y="0" width="51" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Satuan]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="398" y="0" width="107" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jenis]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="0" y="0" width="80" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Kode Barang]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="80" y="0" width="268" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Nama Barang]]></text> | ||
| </staticText> | ||
| <line> | ||
| <reportElement x="0" y="14" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </columnHeader> | ||
| <detail> | ||
| <band height="11" splitType="Stretch"> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="2" y="0" width="78" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{kode_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="80" y="0" width="268" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{nama_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="348" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{satuan}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="399" y="0" width="106" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{jenis}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="505" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.Double"><![CDATA[$F{jumlah}]]></textFieldExpression> | ||
| </textField> | ||
| </band> | ||
| </detail> | ||
| <columnFooter> | ||
| <band splitType="Stretch"/> | ||
| </columnFooter> | ||
| <pageFooter> | ||
| <band height="26" splitType="Stretch"> | ||
| <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement textAlignment="Right" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement x="0" y="0" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <line> | ||
| <reportElement x="0" y="23" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </pageFooter> | ||
| <summary> | ||
| <band splitType="Stretch"/> | ||
| </summary> | ||
| </jasperReport> |
| @@ -0,0 +1,249 @@ | ||
| <?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="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> | ||
| <property name="ireport.zoom" value="2.0"/> | ||
| <property name="ireport.x" value="0"/> | ||
| <property name="ireport.y" value="0"/> | ||
| <parameter name="parameter" class="java.lang.String"> | ||
| <defaultValueExpression><![CDATA[]]></defaultValueExpression> | ||
| </parameter> | ||
| <parameter name="namars" class="java.lang.String"/> | ||
| <parameter name="alamatrs" class="java.lang.String"/> | ||
| <parameter name="kotars" class="java.lang.String"/> | ||
| <parameter name="propinsirs" class="java.lang.String"/> | ||
| <parameter name="kontakrs" class="java.lang.String"/> | ||
| <parameter name="emailrs" class="java.lang.String"/> | ||
| <parameter name="logo" class="java.io.InputStream"/> | ||
| <parameter name="tanggal1" class="java.lang.String"/> | ||
| <parameter name="tanggal2" class="java.lang.String"/> | ||
| <parameter name="barang" class="java.lang.String"/> | ||
| <queryString> | ||
| <![CDATA[select databarang.kode_brng,databarang.nama_brng,kodesatuan.satuan,jenis.nama as jenis, | ||
| sum(detail_permintaan_medis.jumlah) as jumlah from databarang inner join kodesatuan | ||
| inner join jenis inner join detail_permintaan_medis inner join permintaan_medis | ||
| on databarang.kode_brng=detail_permintaan_medis.kode_brng and databarang.kode_sat=kodesatuan.kode_sat | ||
| and databarang.kdjns=jenis.kdjns and detail_permintaan_medis.no_permintaan=permintaan_medis.no_permintaan | ||
| where permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} | ||
| group by databarang.kode_brng order by databarang.kode_brng]]> | ||
| </queryString> | ||
| <field name="kode_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="nama_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="satuan" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="jenis" class="java.lang.String"/> | ||
| <field name="jumlah" class="java.lang.Double"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <background> | ||
| <band splitType="Stretch"/> | ||
| </background> | ||
| <title> | ||
| <band height="84" splitType="Stretch"> | ||
| <textField> | ||
| <reportElement x="0" y="49" width="555" height="18"/> | ||
| <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single" markup="none"> | ||
| <font fontName="Tahoma" size="11" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Rekap Pengajuan Permintaan Barang Non Medis Periode "+$P{tanggal1}+" s.d. "+$P{tanggal2}]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <textField> | ||
| <reportElement x="2" y="14" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="35" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="25" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="0" width="553" height="17"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="12"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression> | ||
| </textField> | ||
| <image scaleImage="FillFrame" onErrorType="Blank"> | ||
| <reportElement x="0" y="2" width="48" height="45"/> | ||
| <imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression> | ||
| </image> | ||
| <line> | ||
| <reportElement x="0" y="48" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="2.0" lineStyle="Double"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </title> | ||
| <pageHeader> | ||
| <band splitType="Stretch"/> | ||
| </pageHeader> | ||
| <columnHeader> | ||
| <band height="16" splitType="Stretch"> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="505" y="0" width="50" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jumlah]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="348" y="0" width="51" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Satuan]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="398" y="0" width="107" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jenis]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="0" y="0" width="80" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Kode Barang]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="80" y="0" width="268" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Nama Barang]]></text> | ||
| </staticText> | ||
| <line> | ||
| <reportElement x="0" y="14" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </columnHeader> | ||
| <detail> | ||
| <band height="11" splitType="Stretch"> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="2" y="0" width="78" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{kode_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="80" y="0" width="268" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{nama_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="348" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{satuan}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="399" y="0" width="106" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{jenis}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="505" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.Double"><![CDATA[$F{jumlah}]]></textFieldExpression> | ||
| </textField> | ||
| </band> | ||
| </detail> | ||
| <columnFooter> | ||
| <band splitType="Stretch"/> | ||
| </columnFooter> | ||
| <pageFooter> | ||
| <band height="26" splitType="Stretch"> | ||
| <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement textAlignment="Right" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement x="0" y="0" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <line> | ||
| <reportElement x="0" y="23" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </pageFooter> | ||
| <summary> | ||
| <band splitType="Stretch"/> | ||
| </summary> | ||
| </jasperReport> |
| @@ -0,0 +1,249 @@ | ||
| <?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="null" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> | ||
| <property name="ireport.zoom" value="2.0"/> | ||
| <property name="ireport.x" value="0"/> | ||
| <property name="ireport.y" value="0"/> | ||
| <parameter name="parameter" class="java.lang.String"> | ||
| <defaultValueExpression><![CDATA[]]></defaultValueExpression> | ||
| </parameter> | ||
| <parameter name="namars" class="java.lang.String"/> | ||
| <parameter name="alamatrs" class="java.lang.String"/> | ||
| <parameter name="kotars" class="java.lang.String"/> | ||
| <parameter name="propinsirs" class="java.lang.String"/> | ||
| <parameter name="kontakrs" class="java.lang.String"/> | ||
| <parameter name="emailrs" class="java.lang.String"/> | ||
| <parameter name="logo" class="java.io.InputStream"/> | ||
| <parameter name="tanggal1" class="java.lang.String"/> | ||
| <parameter name="tanggal2" class="java.lang.String"/> | ||
| <parameter name="barang" class="java.lang.String"/> | ||
| <queryString> | ||
| <![CDATA[select databarang.kode_brng,databarang.nama_brng,kodesatuan.satuan,jenis.nama as jenis, | ||
| sum(detail_permintaan_medis.jumlah) as jumlah from databarang inner join kodesatuan | ||
| inner join jenis inner join detail_permintaan_medis inner join permintaan_medis | ||
| on databarang.kode_brng=detail_permintaan_medis.kode_brng and databarang.kode_sat=kodesatuan.kode_sat | ||
| and databarang.kdjns=jenis.kdjns and detail_permintaan_medis.no_permintaan=permintaan_medis.no_permintaan | ||
| where permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} or | ||
| permintaan_medis.tanggal between $P{tanggal1} and $P{tanggal2} and databarang.nama_brng like $P{barang} and databarang.kode_brng like $P{parameter} | ||
| group by databarang.kode_brng order by databarang.kode_brng]]> | ||
| </queryString> | ||
| <field name="kode_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="nama_brng" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="satuan" class="java.lang.String"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <field name="jenis" class="java.lang.String"/> | ||
| <field name="jumlah" class="java.lang.Double"> | ||
| <fieldDescription><![CDATA[]]></fieldDescription> | ||
| </field> | ||
| <background> | ||
| <band splitType="Stretch"/> | ||
| </background> | ||
| <title> | ||
| <band height="84" splitType="Stretch"> | ||
| <textField> | ||
| <reportElement x="0" y="49" width="555" height="18"/> | ||
| <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single" markup="none"> | ||
| <font fontName="Tahoma" size="11" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Rekap Pengajuan Permintaan Barang Non Medis Periode "+$P{tanggal1}+" s.d. "+$P{tanggal2}]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement positionType="FixRelativeToBottom" x="0" y="83" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <textField> | ||
| <reportElement x="2" y="14" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{alamatrs}+", "+$P{kotars}+", "+$P{propinsirs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="35" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["E-mail : "+$P{emailrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="25" width="553" height="14"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="9"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression> | ||
| </textField> | ||
| <textField> | ||
| <reportElement x="2" y="0" width="553" height="17"/> | ||
| <textElement textAlignment="Center" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="12"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression> | ||
| </textField> | ||
| <image scaleImage="FillFrame" onErrorType="Blank"> | ||
| <reportElement x="0" y="2" width="48" height="45"/> | ||
| <imageExpression class="java.io.InputStream"><![CDATA[$P{logo}]]></imageExpression> | ||
| </image> | ||
| <line> | ||
| <reportElement x="0" y="48" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="2.0" lineStyle="Double"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </title> | ||
| <pageHeader> | ||
| <band splitType="Stretch"/> | ||
| </pageHeader> | ||
| <columnHeader> | ||
| <band height="16" splitType="Stretch"> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="505" y="0" width="50" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jumlah]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="348" y="0" width="51" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Satuan]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="398" y="0" width="107" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Jenis]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="0" y="0" width="80" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Kode Barang]]></text> | ||
| </staticText> | ||
| <staticText> | ||
| <reportElement mode="Opaque" x="80" y="0" width="268" height="15" forecolor="#000000" backcolor="#F0F0DC"/> | ||
| <textElement verticalAlignment="Middle" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <text><![CDATA[Nama Barang]]></text> | ||
| </staticText> | ||
| <line> | ||
| <reportElement x="0" y="14" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </columnHeader> | ||
| <detail> | ||
| <band height="11" splitType="Stretch"> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="2" y="0" width="78" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{kode_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="80" y="0" width="268" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{nama_brng}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="348" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{satuan}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="399" y="0" width="106" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA[$F{jenis}]]></textFieldExpression> | ||
| </textField> | ||
| <textField isStretchWithOverflow="true"> | ||
| <reportElement mode="Transparent" x="505" y="0" width="50" height="10"/> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.Double"><![CDATA[$F{jumlah}]]></textFieldExpression> | ||
| </textField> | ||
| </band> | ||
| </detail> | ||
| <columnFooter> | ||
| <band splitType="Stretch"/> | ||
| </columnFooter> | ||
| <pageFooter> | ||
| <band height="26" splitType="Stretch"> | ||
| <textField evaluationTime="Report" pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="505" y="6" width="36" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="305" y="6" width="170" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement textAlignment="Right" lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.lang.String"><![CDATA["Page " + $V{PAGE_NUMBER} + " of "]]></textFieldExpression> | ||
| </textField> | ||
| <textField pattern="" isBlankWhenNull="false"> | ||
| <reportElement key="textField" x="5" y="6" width="209" height="12" forecolor="#000000" backcolor="#FFFFFF"/> | ||
| <box> | ||
| <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> | ||
| </box> | ||
| <textElement lineSpacing="Single"> | ||
| <font fontName="Tahoma" size="8" isBold="false"/> | ||
| </textElement> | ||
| <textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression> | ||
| </textField> | ||
| <line> | ||
| <reportElement x="0" y="0" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| <line> | ||
| <reportElement x="0" y="23" width="555" height="1"/> | ||
| <graphicElement> | ||
| <pen lineWidth="0.5"/> | ||
| </graphicElement> | ||
| </line> | ||
| </band> | ||
| </pageFooter> | ||
| <summary> | ||
| <band splitType="Stretch"/> | ||
| </summary> | ||
| </jasperReport> |