<?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="Laporan_Absensi_Guru_Bulanan" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="28174bf4-c78b-401e-b475-fc9fa27524d7">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>
	<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>
	<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>
	<style name="Detail" fontName="Arial" fontSize="12"/>
	<style name="Row" mode="Transparent">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style backcolor="#E6DAC3"/>
		</conditionalStyle>
	</style>
	<parameter name="awal" class="java.util.Date">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="akhir" class="java.util.Date">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT
     guru.`nig` AS guru_nig,
     guru.`nama_guru` AS guru_nama_guru,
     presensi_guru.`id` AS presensi_guru_id,
     presensi_guru.`nig` AS presensi_guru_nig,
     presensi_guru.`nama_guru` AS presensi_guru_nama_guru,
     presensi_guru.`keterangan` AS presensi_guru_keterangan,
     presensi_guru.`tgl` AS presensi_guru_tgl
FROM
     `presensi_guru` presensi_guru INNER JOIN `guru` guru ON presensi_guru.`nig` = guru.`nig`

WHERE presensi_guru.`tgl` BETWEEN $P{awal} AND $P{akhir}]]>
	</queryString>
	<field name="guru_nig" class="java.lang.Integer"/>
	<field name="guru_nama_guru" class="java.lang.String"/>
	<field name="presensi_guru_id" class="java.lang.String"/>
	<field name="presensi_guru_nig" class="java.lang.Integer"/>
	<field name="presensi_guru_nama_guru" class="java.lang.String"/>
	<field name="presensi_guru_keterangan" class="java.lang.String"/>
	<field name="presensi_guru_tgl" class="java.sql.Date"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="154" splitType="Stretch">
			<staticText>
				<reportElement x="157" y="16" width="319" height="49" uuid="8a4cb98d-e075-4b2c-9531-6f2c60ce4d76"/>
				<textElement textAlignment="Center">
					<font fontName="SansSerif" size="36" isBold="true"/>
				</textElement>
				<text><![CDATA[SDIT Daarul Fataa]]></text>
			</staticText>
			<image>
				<reportElement x="43" y="16" width="114" height="102" uuid="281bc46e-59d4-426c-8deb-5d4fd4b931bf"/>
				<imageExpression><![CDATA["C:\\Users\\user\\Downloads\\10-03-tgl24\\sdit.jpg"]]></imageExpression>
			</image>
			<staticText>
				<reportElement x="172" y="65" width="278" height="18" uuid="3a019df5-d4ee-48b7-bf18-a8b88ddf7409"/>
				<textElement textAlignment="Center">
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Gg. Lurah Muda Blok Gapura No.40, Rt.03/Rw.03, Cimanggis]]></text>
			</staticText>
			<staticText>
				<reportElement x="205" y="83" width="211" height="18" uuid="04a791df-fc2c-4e60-9e15-e81715258d7e"/>
				<textElement textAlignment="Center">
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Kec. Bojong Gede, Bogor, Jawa Barat 16920]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="5" width="555" height="1" uuid="7e1b02f4-ade4-431c-9ee7-328346cf9339"/>
				<graphicElement>
					<pen lineWidth="1.25"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="90" y="132" width="46" height="16" uuid="195f5088-6779-44be-9714-739d5f2a04be"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[sampai]]></text>
			</staticText>
			<staticText>
				<reportElement x="3" y="132" width="58" height="16" uuid="d32dd5bc-602c-4a6b-9572-d540471caf5b"/>
				<textElement>
					<font size="12" isBold="true"/>
				</textElement>
				<text><![CDATA[Periode :]]></text>
			</staticText>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="127" width="555" height="1" uuid="256a42df-a138-42b9-b678-b34f49a1bc5c"/>
				<graphicElement>
					<pen lineWidth="1.25"/>
				</graphicElement>
			</line>
			<textField>
				<reportElement x="61" y="132" width="25" height="16" uuid="a4cc98df-0af7-4078-bfc7-1dd85911c51c"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{awal}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="136" y="132" width="26" height="16" uuid="394e5bff-7bc6-49c7-a0eb-ec1a3080c81d"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{akhir}]]></textFieldExpression>
			</textField>
		</band>
	</title>
	<pageHeader>
		<band height="53">
			<line>
				<reportElement x="1" y="45" width="554" height="1" uuid="e3387c40-f189-47d7-8f71-47d725d84ae7"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double" lineColor="#000000"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="119" y="12" width="325" height="28" uuid="b49af66b-1f51-4b2b-a5db-747af580e98b"/>
				<textElement textAlignment="Center">
					<font size="20" isBold="true"/>
				</textElement>
				<text><![CDATA[Laporan Absensi Guru Perbulan]]></text>
			</staticText>
			<line>
				<reportElement x="0" y="6" width="554" height="1" uuid="df2f36da-09eb-4df6-a0d1-471abdd8ff83"/>
				<graphicElement>
					<pen lineWidth="2.0" lineStyle="Double" lineColor="#000000"/>
				</graphicElement>
			</line>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="16" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="15" width="555" height="1" uuid="0e76dfde-f358-45ac-a153-8dafbfd203e9"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="0" y="0" width="111" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="7cab1002-b33c-474b-9f32-d370b2c99349"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[ID]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="111" y="0" width="111" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="7842705b-89c2-4c26-acb4-ad1fd35b0ae4"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[NIG]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="222" y="0" width="111" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="5d466294-64a1-4f0f-98c6-b89ca8ca98a7"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Nama Guru]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="333" y="0" width="111" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="10c62846-6575-45e7-8e12-fe344dafd915"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Keterangan]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" mode="Opaque" x="444" y="0" width="111" height="15" forecolor="#736343" backcolor="#CCCCCC" uuid="63aa4099-8a31-44a5-81fc-c823501b54e4"/>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Tanggal]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="15" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="15" uuid="830f0249-022d-4749-b3f8-aaf407888418"/>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="0" y="0" width="111" height="15" uuid="9fc42fc8-384b-4a26-b99e-a6da8ed32b43"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{presensi_guru_id}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="111" y="0" width="111" height="15" uuid="9b64690e-23c8-4876-bd8a-38e73728c0c2"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{guru_nig}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="222" y="0" width="111" height="15" uuid="3e946b6a-6e54-43a4-96c3-774ecffb9460"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{guru_nama_guru}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="333" y="0" width="111" height="15" uuid="b5560884-dd24-40ec-8202-aa94e4136d3e"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{presensi_guru_keterangan}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" x="444" y="0" width="111" height="15" uuid="3808f42e-2bbe-438c-b977-fa1e08c7c65f"/>
					<textElement textAlignment="Center"/>
					<textFieldExpression><![CDATA[$F{presensi_guru_tgl}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="137" splitType="Stretch">
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1" uuid="9cfae18f-9be6-462f-a986-40b484e2a896"/>
				<graphicElement>
					<pen lineWidth="0.5" lineColor="#999999"/>
				</graphicElement>
			</line>
			<staticText>
				<reportElement x="417" y="38" width="93" height="19" uuid="2bdebab9-621d-4e32-aa8e-0b69aaeb346c"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Kepala Sekolah]]></text>
			</staticText>
			<staticText>
				<reportElement x="389" y="19" width="40" height="19" uuid="eabdac13-62ad-44a6-b72d-ac6c2a959d7c"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[Bogor,]]></text>
			</staticText>
			<staticText>
				<reportElement x="387" y="107" width="151" height="27" uuid="20f39334-c6b9-4857-8d50-0d65a5d14595"/>
				<textElement>
					<font size="12" isBold="false"/>
				</textElement>
				<text><![CDATA[( Siti Zuhriah, SPd, M.Pd.I )]]></text>
			</staticText>
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement x="428" y="19" width="126" height="19" uuid="9c297e36-4288-4aa2-87fc-f7d040e296f5"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="26" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="-21" y="1" width="597" height="24" forecolor="#D0B48E" backcolor="#F2EBDF" uuid="171cba44-77f9-4e27-93c3-3ed31e5a34a1"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="515" y="0" width="40" height="20" forecolor="#736343" uuid="8202e569-d079-4c67-8ced-07f02eacf341"/>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
			</frame>
			<textField>
				<reportElement style="Column header" x="414" y="1" width="80" height="20" forecolor="#736343" uuid="488a2d72-73da-4fe1-ac7a-df72cf21fac8"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="10" isBold="false"/>
				</textElement>
				<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
