<?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="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="80295da8-d986-4eb6-895f-943eafc12519">
	<property name="ireport.zoom" value="1.771561000000001"/>
	<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,
CONCAT_WS(', ',cl.name,inc.village,inc.street,inc.build,inc.app,cl.phone1) as adresa,
inc.description_user as descriere_urer,
user.name,
inc.departure_time,
inc.arrival_time,
inc.finish_work_time,
tinc.name  as tname
FROM tbl_incident as inc
inner join tbl_client as cl
on cl.id = inc.client_id
inner join tbl_user as user
on user.id = inc.user_id
inner join tbl_typeofincident as tinc
on tinc.id = inc.incident_type_id
where 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="create_time" class="java.sql.Timestamp"/>
	<field name="adresa" class="java.lang.String"/>
	<field name="descriere_urer" class="java.lang.String"/>
	<field name="name" class="java.lang.String"/>
	<field name="departure_time" class="java.sql.Timestamp"/>
	<field name="arrival_time" class="java.sql.Timestamp"/>
	<field name="finish_work_time" class="java.sql.Timestamp"/>
	<field name="tname" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="97" splitType="Stretch">
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="25" y="76" width="175" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[11]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="282" y="76" width="125" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[13]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="25" y="26" width="175" height="50"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Характер неисправности]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="683" y="76" width="119" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[17]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="601" y="76" width="82" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[16]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="200" y="76" width="82" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[12]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="200" y="26" width="82" height="50"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Подпись исполнителя]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="601" y="26" width="82" height="50"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Дата и время исполнения заявки]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="282" y="26" width="237" height="33"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Заявки переданные в другие службы]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="683" y="26" width="119" height="50"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Ответственное лицо за исполнение заявки]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="406" y="76" width="113" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[14]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="407" y="59" width="112" height="17"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[наименование службы]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="519" y="76" width="82" height="21"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[15]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="519" y="26" width="82" height="50"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Расписка в получении]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="282" y="59" width="125" height="17"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[дата и время передачи]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5daf46b8-9457-4e1b-a96a-ef2d756c0197" mode="Opaque" x="1" y="26" width="25" height="71"/>
				<box>
					<pen lineWidth="1.0"/>
					<topPen lineWidth="1.0"/>
					<leftPen lineWidth="1.0"/>
					<bottomPen lineWidth="1.0"/>
					<rightPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Nr.]]></text>
			</staticText>
			<textField>
				<reportElement uuid="ffe63240-7030-4a4b-9f6d-8fd2274392c2" x="64" y="2" width="100" height="20"/>
				<textElement textAlignment="Left" verticalAlignment="Middle"/>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="74a6bf84-2c17-407c-bfa0-ea9ca5183159" x="1" y="6" width="47" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[стр.2]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="569bb876-4716-4498-85cf-c7a19da91576" x="48" y="5" width="19" height="20"/>
				<textElement/>
				<text><![CDATA[Nr.]]></text>
			</staticText>
		</band>
	</pageHeader>
	<detail>
		<band height="41" splitType="Stretch">
			<textField>
				<reportElement uuid="867114a1-9426-4474-9f57-fa17281025fa" mode="Opaque" x="25" y="1" width="175" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tname}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="683" y="1" width="119" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="601" y="1" width="82" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="519" y="1" width="82" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="407" y="1" width="112" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="282" y="1" width="125" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="200" y="1" width="82" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d30b232a-0486-4436-be0c-9362c6715b0c" mode="Opaque" x="1" y="1" width="25" height="40"/>
				<box>
					<pen lineWidth="0.75"/>
					<topPen lineWidth="0.75"/>
					<leftPen lineWidth="0.75"/>
					<bottomPen lineWidth="0.75"/>
					<rightPen lineWidth="0.75"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle"/>
				<text><![CDATA[]]></text>
			</staticText>
		</band>
	</detail>
	<pageFooter>
		<band height="31" splitType="Stretch"/>
	</pageFooter>
</jasperReport>
