<?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="Penjualan per Dokter" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" isFloatColumnFooter="true" uuid="c6b9fb73-1e47-4c03-9980-95e974de79b7">
	<property name="ireport.zoom" value="1.3636363636363635"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="header" class="java.lang.String"/>
	<parameter name="footer" class="java.lang.String"/>
	<parameter name="namaLaporan" class="java.lang.String"/>
	<parameter name="operator" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="tglCetak" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="tglAwal" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="filter" class="java.lang.String"/>
	<parameter name="tglAkhir" class="java.lang.String">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
    *
FROM
     `tPenjualan` tPenjualan
WHERE
dokter != '-' AND
$P!{filter}
ORDER BY dokter, tanggal, waktu ASC]]>
	</queryString>
	<field name="faktur" class="java.lang.String"/>
	<field name="tanggal" class="java.util.Date"/>
	<field name="waktu" class="java.lang.String"/>
	<field name="tunai_kredit" class="java.lang.String"/>
	<field name="nhari" class="java.lang.String"/>
	<field name="jatuh_tempo" class="java.lang.String"/>
	<field name="pelanggan" class="java.lang.String"/>
	<field name="pasien" class="java.lang.String"/>
	<field name="kode_dokter" class="java.lang.String"/>
	<field name="dokter" class="java.lang.String"/>
	<field name="total" class="java.lang.Double"/>
	<field name="operator" class="java.lang.String"/>
	<variable name="grandTotal" class="java.lang.Double" resetType="Group" resetGroup="dokter" calculation="Sum">
		<variableExpression><![CDATA[$F{total}]]></variableExpression>
		<initialValueExpression><![CDATA[$F{total}]]></initialValueExpression>
	</variable>
	<variable name="no_faktur" class="java.lang.Integer" resetType="Group" resetGroup="dokter" incrementType="Report" calculation="DistinctCount">
		<variableExpression><![CDATA[$V{REPORT_COUNT}]]></variableExpression>
		<initialValueExpression><![CDATA[]]></initialValueExpression>
	</variable>
	<group name="dokter">
		<groupExpression><![CDATA[$F{kode_dokter}]]></groupExpression>
		<groupHeader>
			<band height="26">
				<textField>
					<reportElement mode="Opaque" x="0" y="7" width="552" height="12" backcolor="#E3E3E3" uuid="4aea55a1-a584-4df5-8dfe-8153c869b069"/>
					<textElement verticalAlignment="Middle">
						<font size="8"/>
					</textElement>
					<textFieldExpression><![CDATA[$F{dokter}]]></textFieldExpression>
				</textField>
			</band>
		</groupHeader>
		<groupFooter>
			<band height="27">
				<line>
					<reportElement x="29" y="4" width="458" height="1" uuid="f4bc87a2-c447-44e4-8ed8-37bef0bddd55"/>
					<graphicElement>
						<pen lineWidth="0.25" lineStyle="Solid" lineColor="#666666"/>
					</graphicElement>
				</line>
				<textField pattern="Rp #,##0.00">
					<reportElement x="376" y="5" width="86" height="15" uuid="d760c669-765a-4763-a9d6-6720c0044501"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="8" isBold="true" isItalic="false"/>
					</textElement>
					<textFieldExpression><![CDATA[$V{grandTotal}]]></textFieldExpression>
				</textField>
				<staticText>
					<reportElement x="336" y="5" width="40" height="15" uuid="d7b83703-c74a-46b6-819e-2649f1fb7b04"/>
					<textElement verticalAlignment="Middle">
						<font size="8" isBold="true" isItalic="false"/>
					</textElement>
					<text><![CDATA[Total]]></text>
				</staticText>
			</band>
		</groupFooter>
	</group>
	<title>
		<band height="39" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement x="0" y="0" width="271" height="38" uuid="91c932bb-9f18-4c49-911a-0f2232a655d7"/>
				<textElement>
					<font size="10" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{header}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="44" splitType="Stretch">
			<line>
				<reportElement x="0" y="7" width="555" height="1" uuid="402e9748-77b1-4ed7-bdcd-62dd79042fbe"/>
				<graphicElement>
					<pen lineWidth="0.75" lineStyle="Dashed"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="15" width="206" height="24" uuid="4555a4c8-0a9d-4107-af13-e80b3c2fe5f2"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{namaLaporan}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement stretchType="RelativeToBandHeight" x="235" y="15" width="320" height="24" uuid="4555a4c8-0a9d-4107-af13-e80b3c2fe5f2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["Mulai tgl. " + $P{tglAwal} + " S/d " + $P{tglAkhir}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="24" splitType="Stretch">
			<line>
				<reportElement x="0" y="1" width="555" height="1" uuid="54969548-0c88-4cfd-9436-edd443dbe156"/>
				<graphicElement>
					<pen lineWidth="0.5"/>
				</graphicElement>
			</line>
			<line>
				<reportElement x="0" y="20" width="555" height="1" uuid="bd268265-e291-4029-8910-54db37895ec5"/>
				<graphicElement>
					<pen lineWidth="2.25" lineStyle="Double"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="97" y="0" width="109" height="20" uuid="9b93e04d-8356-4579-a1a1-35ed21a11c0e"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Faktur]]></text>
			</staticText>
			<staticText>
				<reportElement x="206" y="0" width="53" height="20" uuid="335f2834-2f7e-4827-8ab1-c74074789f28"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Tanggal]]></text>
			</staticText>
			<staticText>
				<reportElement x="393" y="0" width="69" height="20" uuid="f5ffe185-5cb3-496b-a523-7b7f241b0a6f"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<staticText>
				<reportElement x="462" y="0" width="90" height="20" uuid="8ccb7873-cd61-4294-981c-456cb7e7a55d"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Operator]]></text>
			</staticText>
			<staticText>
				<reportElement x="62" y="0" width="35" height="20" uuid="25fa6f53-b532-448c-8434-cd2e51732650"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[No.]]></text>
			</staticText>
			<staticText>
				<reportElement x="259" y="0" width="60" height="20" uuid="aa425f4f-1022-4d81-b224-c59b7cb5e3fe"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Pembayaran]]></text>
			</staticText>
			<staticText>
				<reportElement x="333" y="0" width="60" height="20" uuid="61a4995e-e44d-4a9e-917c-16327038fc5c"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Pasien]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="12" splitType="Stretch">
			<textField>
				<reportElement x="97" y="0" width="109" height="12" uuid="557f23b3-f7a4-42cd-a080-e3039eda5ec3"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{faktur}]]></textFieldExpression>
			</textField>
			<textField pattern="dd-MM-yyyy">
				<reportElement x="206" y="0" width="53" height="12" uuid="baf72e91-b721-4709-9159-d616535270f4"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tanggal}]]></textFieldExpression>
			</textField>
			<textField pattern="#,###">
				<reportElement x="393" y="0" width="69" height="12" uuid="d3ab60ca-fb95-404c-98be-2f3c7bc25af7"/>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{total}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="462" y="0" width="90" height="12" uuid="fe18222b-6eb4-4c0b-aec6-a694f1f420b5"/>
				<textElement textAlignment="Right">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{operator}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="65" y="0" width="32" height="12" uuid="cb0211d1-92f5-48ad-86c0-960caefa0290"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{no_faktur}]]></textFieldExpression>
			</textField>
			<textField pattern="#,###">
				<reportElement x="259" y="0" width="60" height="12" uuid="442b5015-73eb-4eef-b15b-e2e3bc347d3c"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tunai_kredit}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="333" y="0" width="60" height="12" uuid="835e32e3-9485-4252-9d06-87bd869bb75a"/>
				<textElement>
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{pasien}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="35" splitType="Stretch">
			<textField>
				<reportElement x="271" y="14" width="284" height="21" forecolor="#333333" uuid="a1d32d3e-1753-412d-b8cd-e712d19c2bcb"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA["Oleh : " + $P{operator}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="29" y="14" width="242" height="21" forecolor="#333333" uuid="32b2a99c-f549-431f-bd9b-61f79afc6eff"/>
				<textElement verticalAlignment="Middle">
					<font size="8"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{tglCetak}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="14" width="29" height="21" forecolor="#333333" uuid="a9290114-1fed-4182-8aa6-5b0a245fb47a"/>
				<textElement verticalAlignment="Middle" markup="none">
					<font size="8"/>
				</textElement>
				<text><![CDATA[Cetak :]]></text>
			</staticText>
		</band>
	</columnFooter>
</jasperReport>
