<?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" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b814fb5b-7a54-4a2b-a5d6-845a86fe4c76">
	<property name="ireport.zoom" value="1.2100000000000004"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<parameter name="DataStart" class="java.sql.Timestamp">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<parameter name="DataFinish" class="java.sql.Timestamp">
		<defaultValueExpression><![CDATA[]]></defaultValueExpression>
	</parameter>
	<queryString>
		<![CDATA[SELECT inc.create_time as Data,
inc.street as Adresa,
inc.description as Descriere,
depar.name as Slujba,
cli.name as Client


FROM `tbl_incident` inc

INNER JOIN `tbl_departament` as depar
ON inc.departament_id = depar.id 

INNER JOIN `tbl_client` as cli
ON inc.client_id = cli.id 
WHERE status_id =4 and inc.create_time >= DATE_FORMAT( $P{DataStart}, GET_FORMAT( DATETIME,  'EUR' )) AND inc.create_time <= DATE_FORMAT( $P{DataFinish}, GET_FORMAT( DATETIME,  'EUR' ))]]>
	</queryString>
	<field name="Data" class="java.sql.Timestamp"/>
	<field name="Adresa" class="java.lang.String"/>
	<field name="Descriere" class="java.lang.String"/>
	<field name="Slujba" class="java.lang.String"/>
	<field name="Client" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="109" splitType="Stretch">
			<staticText>
				<reportElement uuid="c74f5584-20f8-43bf-84c4-dd97bd648ba2" x="0" y="82" width="100" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Дата/Время]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="e3abb5e9-dda2-4c1a-a859-70f20d4c54f1" x="100" y="82" width="100" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Адрес]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="65554e4e-e848-40d8-8f71-d15b69abda85" x="200" y="82" width="100" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Служба]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="0f804c35-ff92-4e1e-ac9a-81a6379b40b5" x="300" y="82" width="100" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Кто передал]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="bd0f3f09-8bd6-49f0-b2c3-15eb3a5a5e6c" x="400" y="82" width="155" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Описание работ]]></text>
			</staticText>
			<line>
				<reportElement uuid="d82bbfc1-4d2f-4d12-a9d3-47508b11e31a" x="0" y="102" width="555" height="1"/>
			</line>
			<line>
				<reportElement uuid="e464f369-98b1-4b68-ac34-11cdbca547fe" x="0" y="82" width="555" height="1"/>
			</line>
			<line>
				<reportElement uuid="5c18185b-71d1-45aa-811b-89efd7bf3236" x="0" y="106" width="555" height="1"/>
			</line>
			<staticText>
				<reportElement uuid="6c3a2822-e22b-4284-acef-05f12133f826" x="100" y="28" width="349" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="14" isBold="false" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Наряды передач без обратной информации]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="3b9fb30c-8cc9-4a86-88f6-76e245b34dec" x="413" y="8" width="118" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[ООО "Кишинев-Газ"
                ]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="88f3a81c-4f1e-4cbf-a7f5-52e65131c4a7" x="138" y="52" width="15" height="20"/>
				<textElement>
					<font fontName="DejaVu Sans" isBold="false" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[С ]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="fb70621a-044d-44f0-b779-6bb6292d2ea7" x="266" y="52" width="28" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="false" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[По]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy HH.mm">
				<reportElement uuid="adc8498b-e8cc-49f2-ad50-7cc807edc1b4" x="153" y="48" width="113" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DataStart}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH.mm">
				<reportElement uuid="adc8498b-e8cc-49f2-ad50-7cc807edc1b4" x="294" y="48" width="107" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DataFinish}]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="23" splitType="Stretch">
			<textField>
				<reportElement uuid="2e4ec56c-665b-4ca1-af16-617688286f2f" x="0" y="0" width="100" height="22"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Data}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="d1b34605-062f-4835-9920-fca65824735a" x="100" y="0" width="100" height="22"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Adresa}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="f261540e-7398-4c77-8eba-449f13e30d08" x="200" y="0" width="100" height="22"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Slujba}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="aa84b882-8f6f-43f9-99cc-3aa8d3479a76" x="300" y="0" width="100" height="22"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Client}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="69ed8749-1da7-4a2b-b4d2-ca2469e7c5a1" x="400" y="0" width="155" height="22"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Descriere}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement uuid="28800832-4028-4fac-9234-ed34607fe453" x="25" y="0" width="418" height="20"/>
				<textElement>
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Проверил начальник АДЦ              _______________________________________]]></text>
			</staticText>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="23" splitType="Stretch">
			<textField pattern="EEEEE dd MMMMM yyyy">
				<reportElement uuid="c59f9595-47a2-4970-9882-3fd8afd9220e" x="0" y="3" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
