<?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="842" pageHeight="595" orientation="Landscape" columnWidth="802" 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="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 bayar_pemesanan.tgl_bayar,pemesanan.tgl_faktur,pemesanan.tgl_pesan,
pemesanan.tgl_tempo, bayar_pemesanan.no_faktur,
datasuplier.nama_suplier,bayar_pemesanan.nama_bayar,bayar_pemesanan.no_bukti,
bayar_pemesanan.besar_bayar,bayar_pemesanan.keterangan,
bayar_pemesanan.nip,petugas.nama from bayar_pemesanan inner join petugas 
inner join pemesanan inner join datasuplier on bayar_pemesanan.nip=petugas.nip 
and bayar_pemesanan.no_faktur=pemesanan.no_faktur 
and pemesanan.kode_suplier=datasuplier.kode_suplier]]>
	</queryString>
	<field name="tgl_bayar" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="tgl_faktur" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="tgl_pesan" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="tgl_tempo" class="java.sql.Date">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="no_faktur" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nama_suplier" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nama_bayar" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="no_bukti" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="besar_bayar" class="java.lang.Double">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="keterangan" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nip" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="nama" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<variable name="total" class="java.lang.Double" calculation="Sum">
		<variableExpression><![CDATA[$F{besar_bayar}]]></variableExpression>
	</variable>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="90" splitType="Stretch">
			<textField>
				<reportElement x="0" y="25" width="802" height="14"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font fontName="Tahoma" size="9"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$P{kontakrs}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="62" y="55" width="671" height="23"/>
				<textElement textAlignment="Center" lineSpacing="Single">
					<font fontName="Tahoma" size="11" isBold="false"/>
				</textElement>
				<text><![CDATA[REKAP DATA PEMBAYARAN PEMESANAN OBAT, ALKES & BHP]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="0" width="802" 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="35" width="802" 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="14" width="802" 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>
			<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="802" height="1"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double"/>
				</graphicElement>
			</line>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="18" splitType="Stretch">
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="55" y="0" width="55" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Tgl.Faktur]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="110" y="0" width="55" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Tgl.Datang]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="165" y="0" width="55" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Tgl.Tempo]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="655" y="0" width="147" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Petugas]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="0" y="0" width="55" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Tgl.Bayar]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="220" y="0" width="58" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[No.Faktur]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="408" y="0" width="59" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[No.Bukti]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="467" y="0" width="80" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Pembayaran]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="278" y="0" width="130" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Akun Bayar]]></text>
			</staticText>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" mode="Opaque" x="547" y="0" width="108" height="18" forecolor="#000000" backcolor="#F0F0DC"/>
				<textElement verticalAlignment="Middle" lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<text><![CDATA[Keterangan]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="0" width="802" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="0" y="17" width="802" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="11" splitType="Stretch">
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="1" y="1" width="54" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_bayar}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="217" y="1" width="61" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{no_faktur}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="408" y="1" width="59" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{no_bukti}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="467" y="1" width="80" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$F{besar_bayar}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="278" y="1" width="130" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{nama_bayar}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="547" y="1" width="108" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{keterangan}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="655" y="1" width="147" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{nip}+" "+$F{nama}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="55" y="1" width="54" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_faktur}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="109" y="1" width="54" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_pesan}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="163" y="1" width="54" height="10"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[$F{tgl_tempo}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="18" splitType="Stretch">
			<textField evaluationTime="Report" pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="495" y="3" width="301" height="15" 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"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["" + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="365" y="3" width="130" height="15" 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"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA["Halaman " + $V{PAGE_NUMBER} + " dari "]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH.mm.ss" isBlankWhenNull="false">
				<reportElement key="textField" x="1" y="3" width="74" height="15" 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"/>
				</textElement>
				<textFieldExpression class="java.util.Date"><![CDATA[new Date()]]></textFieldExpression>
			</textField>
			<textField pattern="" isBlankWhenNull="false">
				<reportElement key="textField" x="278" y="3" width="87" height="15" 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{REPORT_COUNT}.toString()]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Opaque" x="230" y="3" width="46" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Record :]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="0" width="802" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="0" y="16" width="802" height="1"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<textField isStretchWithOverflow="true" pattern="#,##0" isBlankWhenNull="true">
				<reportElement stretchType="RelativeToBandHeight" x="92" y="3" width="88" height="15"/>
				<textElement lineSpacing="Single">
					<font fontName="Tahoma" size="8"/>
				</textElement>
				<textFieldExpression class="java.lang.Double"><![CDATA[$V{total}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement mode="Transparent" x="46" y="3" width="46" height="15" forecolor="#000000" backcolor="#FFFFFF"/>
				<textElement textAlignment="Right" lineSpacing="Single">
					<font fontName="Tahoma" size="8" isBold="false"/>
				</textElement>
				<text><![CDATA[Total : ]]></text>
			</staticText>
		</band>
	</pageFooter>
</jasperReport>
