<?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="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<property name="ireport.zoom" value="1.5"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<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"/>
	<queryString>
		<![CDATA[select detail_pemberian_obat.tgl_perawatan,detail_pemberian_obat.jam,
 detail_pemberian_obat.no_rawat,reg_periksa.no_rkm_medis,pasien.nm_pasien,
 detail_pemberian_obat.kode_brng,databarang.nama_brng,detail_pemberian_obat.embalase,
 detail_pemberian_obat.tuslah,
                   detail_pemberian_obat.jml,detail_pemberian_obat.biaya_obat,detail_pemberian_obat.total
                   from detail_pemberian_obat inner join reg_periksa inner join pasien inner join databarang
                   on detail_pemberian_obat.no_rawat=reg_periksa.no_rawat
                   and reg_periksa.no_rkm_medis=pasien.no_rkm_medis
                   and detail_pemberian_obat.kode_brng=databarang.kode_brng
ORDER BY
     detail_pemberian_obat.tgl_perawatan ASC]]>
	</queryString>
	<field name="tgl_perawatan" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="jam" class="java.sql.Time">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="no_rawat" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="no_rkm_medis" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nm_pasien" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<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="embalase" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="tuslah" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="jml" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="biaya_obat" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="total" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<variable name="totalembalase" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{embalase}]]></variableExpression>
	</variable>
	<variable name="totaltuslah" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{tuslah}]]></variableExpression>
	</variable>
	<variable name="totalbiaya" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{total}]]></variableExpression>
	</variable>
	<group name="byNoRawat">
		<groupExpression><![CDATA[$F{no_rawat}]]></groupExpression>
		<groupHeader>
			<band height="15">
				<textField>
					<reportElement x="52" y="0" width="133" height="15"/>
					<textElement lineSpacing="Single"/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rawat}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="220" y="0" width="85" height="15"/>
					<textElement lineSpacing="Single"/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{no_rkm_medis}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement x="369" y="0" width="186" height="15"/>
					<textElement lineSpacing="Single"/>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{nm_pasien}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="0" y="0" width="52" height="15"/>
					<textElement lineSpacing="Single"/>
					<text><![CDATA[No Rawat: ]]></text>
				</staticText>
				<staticText>
					<reportElement x="185" y="0" width="35" height="15"/>
					<textElement lineSpacing="Single"/>
					<text><![CDATA[No RM: ]]></text>
				</staticText>
				<staticText>
					<reportElement x="305" y="0" width="64" height="15"/>
					<textElement lineSpacing="Single"/>
					<text><![CDATA[Nama Pasien: ]]></text>
				</staticText>
			</band>
		</groupHeader>
	</group>
	<group name="grtgl">
		<groupExpression><![CDATA[$F{tgl_perawatan}]]></groupExpression>
		<groupHeader>
			<band height="15">
				<textField pattern="dd/MM/yyyy">
					<reportElement x="1" y="0" width="100" height="15"/>
					<textElement lineSpacing="Single"/>
					<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_perawatan}]]></textFieldExpression>
				</textField>
				<line>
					<reportElement x="2" y="0" width="553" height="1"/>
				</line>
			</band>
		</groupHeader>
	</group>
	<group name="grjam">
		<groupExpression><![CDATA[$F{jam}]]></groupExpression>
		<groupHeader>
			<band height="15">
				<textField pattern="HH:mm:ss">
					<reportElement x="15" y="0" width="100" height="15"/>
					<textElement lineSpacing="Single"/>
					<textFieldExpression class="java.sql.Time"><![CDATA[$F{jam}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
	</group>
	<group name="by">
		<groupHeader>
			<band height="15">
				<staticText>
					<reportElement mode="Opaque" x="15" y="0" width="250" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Nama Obat/Alkes]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="476" y="0" width="79" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Total Biaya]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="365" y="0" width="41" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Jumlah]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="265" y="0" width="50" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Embalase]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="315" y="0" width="50" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Tuslah]]></text>
				</staticText>
				<staticText>
					<reportElement mode="Opaque" x="406" y="0" width="70" height="15" forecolor="#000000" backcolor="#F0F0DC"/>
					<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
						<font fontName="Tahoma" size="8" isBold="false"/>
					</textElement>
					<text><![CDATA[Harga]]></text>
				</staticText>
			</band>
		</groupHeader>
	</group>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="97" splitType="Stretch">
			<staticText>
				<reportElement x="2" y="53" width="553" height="23"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font fontName="Tahoma" size="11" isBold="false"/>
				</textElement>
				<text><![CDATA[DATA PEMBERIAN OBAT/BARANG/ALKES/PERLENGKAPAN]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="35" width="555" 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="0" y="0" width="555" height="17"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font fontName="Tahoma" size="13"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{namars}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="14" width="555" 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>
			<line>
				<reportElement x="0" y="48" width="555" height="1"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement x="0" y="25" width="555" height="14"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></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>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<detail>
		<band height="11" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement x="15" y="1" width="250" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8" isUnderline="false"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{nama_brng}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0">
				<reportElement x="476" y="0" width="79" height="10"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{total}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="369" y="0" width="37" height="10"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{jml}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="15" y="10" width="540" height="1"/>
			</line>
			<textField pattern="#,##0">
				<reportElement x="265" y="0" width="50" height="10"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{embalase}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="315" y="1" width="50" height="10"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{tuslah}]]></textFieldExpression>
			</textField>
			<textField pattern="#,##0">
				<reportElement x="406" y="1" width="70" height="10"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{biaya_obat}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<summary>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement mode="Transparent" x="2" y="0" width="93" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8" isBold="true"/>
				</textElement>
				<text><![CDATA[Total :]]></text>
			</staticText>
			<textField isStretchWithOverflow="true" pattern="#,##0">
				<reportElement x="470" y="0" width="85" height="18"/>
				<textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8" isBold="true"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{totalbiaya}]]></textFieldExpression>
			</textField>
		</band>
	</summary>
</jasperReport>
