<?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="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="618e4e07-1acb-41e6-827c-c1d572d6fd20">
	<property name="ireport.zoom" value="1.6105100000000008"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<style name="table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 4">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Crosstab Data Text" hAlign="Center"/>
	<parameter name="DataStart" class="java.sql.Timestamp"/>
	<parameter name="DataFinish" class="java.sql.Timestamp"/>
	<queryString>
		<![CDATA[SELECT
     CONCAT_WS(' ',tbl_client.`street`,' c. ',tbl_client.`build`,' ap. ',tbl_client.`app`) AS Adress,
     tbl_incident.`create_time` AS tbl_incident_create_time,
     tbl_incident.`day_nr` AS tbl_incident_day_nr,
     tbl_incident.`description_user` AS tbl_incident_description_user,
     tbl_incident.`description` AS tbl_theme_description,
     (
           select GROUP_CONCAT(CONCAT(user.name,' ')) as name from tbl_user as user
           inner join tbl_brigade as br
           on user.id = br.user1_id
              or user.id = br.user2_id
           where
             br.id = bri.id
) as brigada
FROM
     `tbl_client` tbl_client INNER JOIN `tbl_incident` tbl_incident ON tbl_client.`id` = tbl_incident.`client_id`
     INNER JOIN `tbl_typeofincident` tbl_typeofincident ON tbl_incident.`incident_type_id` = tbl_typeofincident.`id`
     INNER JOIN `tbl_brigade` bri ON tbl_incident.`brigade_id` = bri.`id`
where tbl_incident.`create_time` >= DATE_FORMAT( $P{DataStart}, GET_FORMAT( DATETIME,  'EUR' ) )
and tbl_incident.`create_time` <= DATE_FORMAT( $P{DataFinish}, GET_FORMAT( DATETIME,  'EUR' ) )]]>
	</queryString>
	<field name="Adress" class="java.lang.String"/>
	<field name="tbl_incident_create_time" class="java.sql.Timestamp"/>
	<field name="tbl_incident_day_nr" class="java.lang.Integer"/>
	<field name="tbl_incident_description_user" class="java.lang.String"/>
	<field name="tbl_theme_description" class="java.lang.String"/>
	<field name="brigada" class="java.lang.String"/>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band splitType="Stretch"/>
	</title>
	<pageHeader>
		<band height="102" splitType="Stretch">
			<staticText>
				<reportElement uuid="3b9fb30c-8cc9-4a86-88f6-76e245b34dec" x="432" y="10" 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="3f0b55ad-f135-484a-bdf8-dd46e688d118" positionType="Float" mode="Opaque" x="105" y="8" width="327" height="33"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" size="20" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[Повторные заявки за период
                ]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="601927a4-6c38-4321-ae35-524e6bc2e0af" mode="Opaque" x="152" y="41" width="16" height="22"/>
				<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="b3e109b7-e6db-46aa-a1a7-0a1fdca47dce" x="285" y="41" width="19" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251" isPdfEmbedded="true"/>
				</textElement>
				<text><![CDATA[по
                ]]></text>
			</staticText>
			<textField pattern="dd/MM/yyyy HH.mm">
				<reportElement uuid="a989f8c0-7898-49cc-acf7-18f4bbfc6cbc" x="303" y="36" width="115" height="22"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="html">
					<font fontName="DejaVu Sans" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DataFinish}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy HH.mm">
				<reportElement uuid="adc8498b-e8cc-49f2-ad50-7cc807edc1b4" x="168" y="36" width="117" 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="edea3dd8-b4dc-4c03-8640-0ad0e34f259d" x="0" y="82" width="132" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Адрес]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="751124cd-33e9-4da8-9509-6dc893dd4c39" x="132" y="82" width="56" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Дата/Время]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="d606ee97-9fa9-4453-a126-edb8426e9d94" x="188" y="82" width="37" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Номер заявки]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="3cdaa628-41d5-4a13-862e-e678a1baa9d8" x="225" y="82" width="126" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Характер заявки со слов заябителя]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="c55fe68a-9acc-494b-b8ef-000755a43e6a" x="351" y="82" width="104" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Ответственные за исполнение лица]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="39241c81-4a40-406a-9119-ee88386c420e" x="455" y="82" width="100" height="20"/>
				<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" pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<text><![CDATA[Описание работ]]></text>
			</staticText>
		</band>
	</pageHeader>
	<columnHeader>
		<band splitType="Stretch"/>
	</columnHeader>
	<detail>
		<band height="35" splitType="Stretch">
			<textField isStretchWithOverflow="true">
				<reportElement uuid="4ebbd2bc-5c29-4612-8034-567e5de21dd7" stretchType="RelativeToBandHeight" x="132" y="0" width="56" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tbl_incident_create_time}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement uuid="50714c35-a26b-46c8-8168-055f9451759e" stretchType="RelativeToBandHeight" x="188" y="0" width="37" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tbl_incident_day_nr}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement uuid="a4a8249c-8620-4a8f-a47f-f787cb00064c" stretchType="RelativeToBandHeight" x="225" y="0" width="126" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tbl_incident_description_user}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement uuid="fdf7682f-0be5-4862-9994-064406b5d29a" stretchType="RelativeToBandHeight" x="455" y="0" width="100" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{tbl_theme_description}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement uuid="709e4d59-13b5-411b-a0d3-7e87bc74e861" stretchType="RelativeToBandHeight" x="351" y="0" width="104" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
					<paragraph lineSpacing="Proportional"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{brigada}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement uuid="4ed4271a-2370-4cc8-afef-b630041a6b80" stretchType="RelativeToBandHeight" x="0" y="0" width="132" height="35"/>
				<box>
					<pen lineWidth="0.0"/>
					<topPen lineWidth="0.0"/>
					<leftPen lineWidth="0.0"/>
					<bottomPen lineWidth="0.0"/>
					<rightPen lineWidth="0.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="DejaVu Sans" size="8" pdfFontName="DejaVuSans"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{Adress}]]></textFieldExpression>
			</textField>
			<rectangle>
				<reportElement uuid="264d0de5-50f6-4815-bb21-0a9ab2def694" stretchType="RelativeToBandHeight" mode="Transparent" x="1" y="0" width="554" height="0"/>
			</rectangle>
		</band>
	</detail>
	<columnFooter>
		<band splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="24" splitType="Stretch">
			<textField pattern="dd/MM/yyyy">
				<reportElement uuid="c7777ff1-8f5b-4b7e-9832-c60a24abff80" mode="Opaque" x="5" y="4" width="100" height="20"/>
				<textElement markup="html">
					<font pdfFontName="DejaVuSans" pdfEncoding="Cp1251"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>
