<?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="jurnal_Deplin" pageWidth="1684" pageHeight="595" orientation="Landscape" columnWidth="1644" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7e2a3c91-6791-4a96-acda-c2a862e9015f">
	<property name="ireport.zoom" value="1.0"/>
	<property name="ireport.x" value="0"/>
	<property name="ireport.y" value="0"/>
	<property name="ireport.callouts" value="##Tue Oct 09 17:20:38 EEST 2012"/>
	<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"/>
	<pageHeader>
		<band height="76" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="20" splitType="Stretch">
			<staticText>
				<reportElement uuid="cfcf984a-f560-4211-b240-eb71ecef7cf1" x="0" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[create_time]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="0f18a9aa-f2aa-43bb-b714-9e4a30c0f8f2" x="100" y="0" width="331" height="20"/>
				<textElement/>
				<text><![CDATA[adresa]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="cad84106-7868-4f35-9ec6-6affcb1693c5" x="431" y="0" width="216" height="20"/>
				<textElement/>
				<text><![CDATA[descriere_urer]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="5a4be401-d63b-4b85-960d-766884a3846a" x="647" y="0" width="195" height="20"/>
				<textElement/>
				<text><![CDATA[name]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="2077b498-f24f-4469-8b4f-79a85706c02e" x="955" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[departure_time]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="43020b8a-e748-408d-8313-9b0cdcedac6f" x="1055" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[arrival_time]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="66f3f1f1-d6fc-4ac4-b1c1-bd8e67ec46f0" x="1155" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[finish_work_time]]></text>
			</staticText>
			<staticText>
				<reportElement uuid="f9143cf1-ef04-4667-b2a6-7fdb87c65130" x="1255" y="0" width="100" height="20"/>
				<textElement/>
				<text><![CDATA[tname]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="76" splitType="Stretch">
			<textField>
				<reportElement uuid="08c2b73d-1e64-45c7-9bfb-4e1f5c0da72d" x="0" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{create_time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="145eb351-7843-44d6-b5b4-b19999cda7ba" x="100" y="0" width="331" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{adresa}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="9cabad72-8c82-4224-9aa6-9e467a4d3117" x="431" y="0" width="216" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{descriere_urer}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="ccbbc062-a055-41be-a00c-e3eb48b855c2" x="647" y="0" width="195" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="d673ff0f-82fd-4ec4-acba-0fbc1db976fe" x="955" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{departure_time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="ecff7f25-995f-482a-bac9-dcfe4427bf5a" x="1055" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{arrival_time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="8f1c4cdb-759a-4951-b627-b53f08e4a14d" x="1155" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{finish_work_time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement uuid="94503a4f-415c-4433-ba0b-04e5d728b822" x="1255" y="0" width="100" height="20"/>
				<textElement/>
				<textFieldExpression><![CDATA[$F{tname}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
	<columnFooter>
		<band height="45" splitType="Stretch"/>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
</jasperReport>
