<?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="a4cd6a43-9c00-46ef-a7a8-8d0fb03bb57a">
	<property name="ireport.zoom" value="1.4641000000000008"/>
	<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
,cl.name as Solicitant
,usr.name as Operator
,thm.name AS Tema
,br.name AS Brigada
,lif.stare as LifeCycle 
,statinc.stare as Stat
FROM `tbl_incident` as inc

INNER JOIN  tbl_client as cl
ON inc.`client_id` = cl.id

INNER JOIN `tbl_user` as usr
ON inc.user_id = usr.id 

INNER JOIN tbl_theme as thm
ON inc.theme_id = thm.id

INNER JOIN tbl_brigade as br
ON inc.brigade_id = br.id

INNER JOIN tbl_lifecycle as lif
ON inc.life_cycle_id = lif.id
INNER JOIN tbl_statusincident as statinc
ON inc.status_id = statinc.id
WHERE inc.status_id = 3 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="Solicitant" class="java.lang.String"/>
	<field name="Operator" class="java.lang.String"/>
	<field name="Tema" class="java.lang.String"/>
	<field name="Brigada" class="java.lang.String"/>
	<field name="LifeCycle" class="java.lang.String"/>
	<field name="Stat" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<pageHeader>
		<band height="125" splitType="Stretch">
			<line>
				<reportElement uuid="768f2678-941f-4e0d-badb-036658a4817f" x="0" y="104" width="555" height="1"/>
			</line>
			<line>
				<reportElement uuid="768f2678-941f-4e0d-badb-036658a4817f" x="0" y="124" width="555" height="1"/>
			</line>
			<staticText>
				<reportElement uuid="35fad737-f58f-4d7b-9afa-b712e241f3f6" x="144" y="42" width="289" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" size="14" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Журнал передачи нарядов]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="3b9fb30c-8cc9-4a86-88f6-76e245b34dec" x="419" y="14" 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="8a8ce7fe-6c47-42bf-971d-f9173b6aeaac" x="185" y="104" width="79" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Оператор]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="df3aa5bb-897f-4266-8f33-a7281cf3c79a" x="447" y="105" width="52" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" isStrikeThrough="false" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
					<paragraph lineSpacing="Single"/>
				</textElement>
				<text><![CDATA[Ж.цикл]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="07904466-a840-42b3-b7e1-024618c79755" x="83" y="104" width="100" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Заявитель]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="f420088b-0f27-4ba8-83c8-1c547d4ea383" x="385" y="105" width="62" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Бригада]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5c006662-37f9-4d1a-aaa3-75fb8f831e85" x="0" y="104" width="83" height="20" forecolor="#000000"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Дата/Время]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="9fa63c6f-d670-4c0b-9a96-f8bf71b81a66" x="499" y="104" width="56" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Статус]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d746adad-378b-4edf-8a0d-8c685f667890" x="264" y="104" width="121" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="true" 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="168" y="62" 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>
			<staticText>
				<reportElement uuid="fb70621a-044d-44f0-b779-6bb6292d2ea7" x="281" y="66" width="28" height="20"/>
				<textElement textAlignment="Center">
					<font fontName="DejaVu Sans" isBold="false" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[По]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="88f3a81c-4f1e-4cbf-a7f5-52e65131c4a7" x="153" y="66" width="15" height="20"/>
				<textElement>
					<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="309" y="62" 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="24" splitType="Stretch">
			<textField>
				<reportElement uuid="f18eb7ee-39be-4ab8-953b-33a74b514a7f" x="0" y="0" width="83" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Data}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="b552a24c-4d86-493d-a2a1-2562e5df7dd1" x="83" y="0" width="100" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Solicitant}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="9b84d5d2-793c-4a4b-95b6-b8419f5c9e33" x="183" y="0" width="79" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Operator}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="6892ae94-a889-4e6e-bfb4-92b22c2aa633" x="262" y="0" width="121" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Tema}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="fbd2cd24-17f9-4663-aa1c-0773caf1e534" x="383" y="0" width="62" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Brigada}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="851065b3-484c-44ed-befd-71b6c49b76e1" x="445" y="0" width="52" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{LifeCycle}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8774cdb1-a8ce-4904-a428-2fd5d5c335d3" x="497" y="0" width="56" height="20"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="9" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Stat}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<pageFooter>
		<band height="22" splitType="Stretch"/>
	</pageFooter>
</jasperReport>
