<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  -->
<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="A06V01" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ccee3616-4edf-4742-a3a9-8bd2e3edc3ad">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Aissbs"/>
	<style name="Table 1_TH" mode="Opaque" backcolor="#2D5A2D">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 1_CH" mode="Opaque" backcolor="#CFE6CF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="tabulka výbušniny" uuid="bbf59079-f77f-4d9d-900e-43646f174a9a">
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Aissbs"/>
		<parameter name="DATUM" class="java.sql.Timestamp">
			<parameterDescription><![CDATA[K jakému dni]]></parameterDescription>
		</parameter>
		<queryString language="SQL">
			<![CDATA[select * from report_vybusniny_povoleni
WHERE  (SELECT COALESCE( $P{DATUM} , CURRENT_DATE)) >  report_vybusniny_povoleni.datum_nabyti_pravni_moci
AND report_vybusniny_povoleni.platnost_do > (SELECT COALESCE( $P{DATUM} , CURRENT_DATE))]]>
		</queryString>
		<field name="obchodni_nazev" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="obchodni_nazev"/>
		</field>
		<field name="un_kod" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="un_kod"/>
		</field>
		<field name="klasifikacni_kod" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="klasifikacni_kod"/>
		</field>
		<field name="rizikove_prostredi" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="rizikove_prostredi"/>
		</field>
		<field name="cislo_jednaci" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="cislo_jednaci"/>
		</field>
		<field name="platnost_od" class="java.sql.Date">
			<property name="com.jaspersoft.studio.field.label" value="platnost_od"/>
		</field>
		<field name="platnost_do" class="java.sql.Date">
			<property name="com.jaspersoft.studio.field.label" value="platnost_do"/>
		</field>
		<field name="podminky_povoleni" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="podminky_povoleni"/>
		</field>
		<field name="datum_nabyti_pravni_moci" class="java.sql.Date">
			<property name="com.jaspersoft.studio.field.label" value="datum_nabyti_pravni_moci"/>
		</field>
		<field name="stav_povoleni" class="java.math.BigDecimal">
			<property name="com.jaspersoft.studio.field.label" value="stav_povoleni"/>
		</field>
	</subDataset>
	<parameter name="DATUM" class="java.sql.Timestamp">
		<parameterDescription><![CDATA[K jakému dni]]></parameterDescription>
	</parameter>
	<queryString language="SQL">
		<![CDATA[select * from report_vybusniny_povoleni]]>
	</queryString>
	<field name="obchodni_nazev" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="obchodni_nazev"/>
	</field>
	<field name="un_kod" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="un_kod"/>
	</field>
	<field name="klasifikacni_kod" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="klasifikacni_kod"/>
	</field>
	<field name="rizikove_prostredi" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="rizikove_prostredi"/>
	</field>
	<field name="cislo_jednaci" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="cislo_jednaci"/>
	</field>
	<field name="platnost_od" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="platnost_od"/>
	</field>
	<field name="platnost_do" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="platnost_do"/>
	</field>
	<field name="podminky_povoleni" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="podminky_povoleni"/>
	</field>
	<field name="datum_nabyti_pravni_moci" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="datum_nabyti_pravni_moci"/>
	</field>
	<field name="stav_povoleni" class="java.math.BigDecimal">
		<property name="com.jaspersoft.studio.field.label" value="stav_povoleni"/>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="54" splitType="Stretch">
			<staticText>
				<reportElement x="0" y="1" width="555" height="50" uuid="9599ebde-bdc3-4b36-8c90-fe125672b57a"/>
				<textElement textAlignment="Center">
					<font size="18" isBold="true"/>
				</textElement>
				<text><![CDATA[PŘEHLED POVOLENÝCH VÝBUŠNIN PRO POUŽITÍ V RIZIKOVÉM PROSTŘEDÍ NEBO RIZIKOVÝCH PODMÍNKÁCH]]></text>
			</staticText>
		</band>
	</title>
	<pageHeader>
		<band height="42" splitType="Stretch">
			<textField>
				<reportElement x="0" y="7" width="510" height="30" uuid="b6193b5e-b9d6-4116-9bb9-6b6ac6e82c96"/>
				<textElement>
					<font size="16"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DATUM} == null ? "Ke dni: " + new SimpleDateFormat("dd.MM.yyyy").format(new Date()) : ("Ke dni: " + new SimpleDateFormat("dd.MM.yyyy").format($P{DATUM}))]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<summary>
		<band height="127" splitType="Stretch">
			<componentElement>
				<reportElement x="0" y="14" width="555" height="110" uuid="766c6c48-4405-4537-82f3-ed1c8fe19fa3">
					<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
					<property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/>
					<property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/>
					<property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/>
				</reportElement>
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">
					<datasetRun subDataset="tabulka výbušniny" uuid="cf62f5df-965b-40df-9cd1-cbbe6d1d8891">
						<datasetParameter name="DATUM">
							<datasetParameterExpression><![CDATA[$P{DATUM}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="50" uuid="3b895a9e-4cd9-4517-9b1e-4c742cd72a09">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="50" height="50" uuid="22325346-9ad9-4bc7-8d6e-90bb1f6c1c14"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[UN kód]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="50" height="30" isPrintWhenDetailOverflows="true" uuid="0d1a8ef5-6fe3-4ce1-a987-bda912c1fabc"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{un_kod}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="7c027ee2-9fe6-487c-8d3a-fa6519cb259b">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="90" height="50" uuid="2b06db58-de49-42f1-9177-e0eb321245dc"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Název]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="90" height="30" isPrintWhenDetailOverflows="true" uuid="84bde296-6aad-4fd3-9291-9aa300a27d47"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{obchodni_nazev}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="81" uuid="59965a2e-8099-4814-8ed5-063ac4e3fa2a">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="81" height="50" uuid="a33bf195-cbeb-4f8f-b595-7563b27ba643"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Třída/klas.kód]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="81" height="30" isPrintWhenDetailOverflows="true" uuid="70f0345b-ee4d-4b1c-8f64-cca612ed3ab2"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{klasifikacni_kod}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="90" uuid="0a78449f-477d-402c-965d-c8b54b57a511">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="90" height="50" uuid="0e4aaebe-d8ca-4c19-9b74-904ed52c28f0"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Prostředí]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="90" height="30" isPrintWhenDetailOverflows="true" uuid="b4b32b55-a849-47c3-9f8d-ca0419092fd1"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{rizikove_prostredi}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="60" uuid="ef98b3a1-e41f-4b3a-89f2-aa487e55d834">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="60" height="50" uuid="326d54a6-1b54-400c-992f-1971df34e18b"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Platné od]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="60" height="30" isPrintWhenDetailOverflows="true" uuid="f22ba4f9-cc68-48e8-ba20-6bfcd1638475"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[new SimpleDateFormat("dd.MM.yyyy").format($F{platnost_od})]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="120" uuid="20c20676-7624-4e07-8bdf-7e877f7ae601">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="120" height="50" uuid="031a00d2-21d6-414c-a8d0-645ed0607382"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Č. jed. povolení]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="120" height="30" isPrintWhenDetailOverflows="true" uuid="a5c48b2e-55f9-4ef7-9e47-c840d19ea61a"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[$F{cislo_jednaci}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="64" uuid="a9a72bd7-62b6-4c04-aa2e-4f28fa5a0a8b">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/>
						<jr:columnHeader style="Table 1_CH" height="50">
							<staticText>
								<reportElement x="0" y="0" width="64" height="50" uuid="b7d1b280-67b3-4964-8ac5-c0cb91f586d7"/>
								<textElement textAlignment="Center" verticalAlignment="Middle">
									<font isBold="true"/>
								</textElement>
								<text><![CDATA[Podmínky]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:columnFooter style="Table 1_CH" height="30" rowSpan="1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<textField isStretchWithOverflow="true">
								<reportElement positionType="Float" stretchType="RelativeToTallestObject" x="0" y="0" width="64" height="30" isPrintWhenDetailOverflows="true" uuid="b50c8d20-43c2-4ef3-814f-183e7e2bdc5c"/>
								<textElement textAlignment="Left" verticalAlignment="Middle">
									<paragraph firstLineIndent="0" leftIndent="6"/>
								</textElement>
								<textFieldExpression><![CDATA[($F{podminky_povoleni} == null) ? "nebyly stanoveny" : $F{podminky_povoleni}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
		</band>
	</summary>
</jasperReport>
