<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1  -->
<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="certidaoLiberatoria" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d4a1d5eb-82dd-412f-a620-202e4bdf9dba">
	<property name="template.engine" value="tabular_template"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
	<style name="Table">
		<box>
			<pen lineWidth="1.0" lineColor="#000000"/>
			<topPen lineWidth="1.0" lineColor="#000000"/>
			<leftPen lineWidth="1.0" lineColor="#000000"/>
			<bottomPen lineWidth="1.0" lineColor="#000000"/>
			<rightPen lineWidth="1.0" lineColor="#000000"/>
		</box>
	</style>
	<parameter name="FILTRO" class="java.lang.String"/>
	<parameter name="DADOS_BASICOS" class="br.com.elotech.config.DadosBasicos"/>
	<parameter name="LOGO" class="java.lang.Object"/>
	<parameter name="TITULO" class="java.lang.String"/>
	<parameter name="TP_REL" class="java.lang.String"/>
	<parameter name="VERSION" class="java.lang.String"/>
	<queryString>
		<![CDATA[]]>
	</queryString>
	<field name="unidade" class="java.lang.String"/>
	<field name="lei" class="java.lang.String"/>
	<field name="decreto" class="java.lang.String"/>
	<field name="dataValidade" class="java.sql.Date"/>
	<field name="dataConcessao" class="java.sql.Date"/>
	<field name="numero" class="java.lang.Integer"/>
	<field name="exercicio" class="java.lang.Integer"/>
	<field name="profissional" class="java.lang.String"/>
	<field name="cargo" class="java.lang.String"/>
	<field name="cnpjUnidade" class="java.lang.String"/>
	<pageHeader>
		<band height="103" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="0" y="0" width="555" height="70" backcolor="#FFFFFF" uuid="6321f5e3-86eb-444f-acc1-8daaaa0d6c60">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="ShowOutOfBoundContent" value="false"/>
				</reportElement>
				<box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
					<pen lineColor="#D18015"/>
					<topPen lineWidth="2.0"/>
					<leftPen lineWidth="2.0"/>
					<rightPen lineWidth="2.0"/>
				</box>
				<textField isBlankWhenNull="true">
					<reportElement mode="Transparent" x="100" y="7" width="455" height="20" forecolor="#000000" uuid="555240c1-0443-419c-8bf0-7a4f388e4155">
						<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					</reportElement>
					<box topPadding="0" leftPadding="10" bottomPadding="0" rightPadding="10"/>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="SansSerif" size="12" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$P{DADOS_BASICOS}.getPrefeitura()]]></textFieldExpression>
				</textField>
				<textField isBlankWhenNull="true">
					<reportElement mode="Transparent" x="100" y="27" width="455" height="15" forecolor="#000000" uuid="502aeaee-ee33-429f-a820-6d44c1a2501e">
						<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					</reportElement>
					<box topPadding="0" leftPadding="10" bottomPadding="0" rightPadding="10"/>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="SansSerif" size="11" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$P{DADOS_BASICOS}.getSecretaria()]]></textFieldExpression>
				</textField>
				<image hAlign="Center" vAlign="Middle" isUsingCache="true" onErrorType="Blank">
					<reportElement mode="Opaque" x="10" y="7" width="90" height="55" backcolor="#FFFFFF" uuid="5090998c-dbda-4473-beeb-6e51ecea41eb">
						<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
						<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					</reportElement>
					<box padding="5"/>
					<imageExpression><![CDATA[$P{LOGO}]]></imageExpression>
				</image>
				<textField isBlankWhenNull="true">
					<reportElement mode="Transparent" x="100" y="42" width="455" height="20" forecolor="#000000" uuid="793b703b-ee2c-4fa2-af62-98d51b646058">
						<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					</reportElement>
					<box topPadding="0" leftPadding="10" bottomPadding="0" rightPadding="10"/>
					<textElement textAlignment="Center" verticalAlignment="Middle">
						<font fontName="SansSerif" size="10" isBold="true" pdfFontName="Helvetica-Bold"/>
					</textElement>
					<textFieldExpression><![CDATA[$P{DADOS_BASICOS}.getUnidade()]]></textFieldExpression>
				</textField>
			</frame>
			<textField isBlankWhenNull="true">
				<reportElement mode="Opaque" x="0" y="70" width="555" height="20" forecolor="#FFFFFF" backcolor="#D18015" uuid="27c7256f-d960-4b5c-b965-b9b267c275f8">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
				</reportElement>
				<box leftPadding="0" rightPadding="0">
					<pen lineColor="#D18015"/>
					<leftPen lineWidth="2.0"/>
					<rightPen lineWidth="2.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="9" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{TITULO}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="555" y="0" width="8" height="90" uuid="63d1e194-1d1a-49dd-9419-aea03a2bcf77">
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<textElement rotation="Left">
					<font size="5"/>
				</textElement>
				<textFieldExpression><![CDATA[($P{VERSION} != null && $P{VERSION} != "" ? "v."+$P{VERSION} : "")]]></textFieldExpression>
			</textField>
		</band>
	</pageHeader>
	<detail>
		<band height="500">
			<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
			<textField>
				<reportElement x="0" y="20" width="555" height="20" uuid="abf5adcb-2392-426c-9912-f067502bc314">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
				</reportElement>
				<box>
					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font fontName="SansSerif" size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA["Nº da Certidão: "+ $F{numero} +"/"+$F{exercicio}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="90" y="100" width="464" height="20" uuid="3648e2f9-9cba-435d-a8cd-a631cab983ec">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
				</reportElement>
				<box leftPadding="0"/>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{unidade}]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement x="0" y="180" width="555" height="62" uuid="18fdce4a-5295-41de-8ab4-0b7dbb031291">
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<box topPadding="0" leftPadding="10" bottomPadding="0" rightPadding="10"/>
				<textElement textAlignment="Justified" verticalAlignment="Middle">
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA["Certificamos, para os devidos fins, que " + $F{unidade}+ " , está em situação regular, no que dispõe a Lei n° " + $F{lei} +" e Decreto Municipal nº "+$F{decreto}+"."]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="0" y="430" width="555" height="29" uuid="09c7dc0c-4ee8-4163-a718-566a0e16c92f">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Bottom">
					<font fontName="SansSerif" size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{profissional}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="0" y="459" width="555" height="31" isRemoveLineWhenBlank="true" uuid="7708f1f9-68b1-4f17-abd5-bcb23881eb5e">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
				</reportElement>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font fontName="SansSerif" size="12" isBold="false" pdfFontName="Helvetica"/>
				</textElement>
				<textFieldExpression><![CDATA[$F{cargo}]]></textFieldExpression>
			</textField>
			<textField isBlankWhenNull="true">
				<reportElement x="90" y="120" width="464" height="20" isRemoveLineWhenBlank="true" uuid="60d656a4-f8d3-4b84-b311-897e2a4f0539">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<textElement textAlignment="Left" verticalAlignment="Middle">
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[( $F{cnpjUnidade}.length() == 14 ? ($F{cnpjUnidade}.substring(0, 2) + "." + $F{cnpjUnidade}.substring(2, 5) + "." + $F{cnpjUnidade}.substring(5, 8) + "/" + $F{cnpjUnidade}.substring(8, 12) + "-" + $F{cnpjUnidade}.substring(12, 14)) : ($F{cnpjUnidade}.substring(0, 3) + "." + $F{cnpjUnidade}.substring(3, 6) + "." + $F{cnpjUnidade}.substring(6, 9) + "-" + $F{cnpjUnidade}.substring(9, 11)) )
]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="120" width="90" height="20" uuid="4703b6a9-c0ec-4724-951b-c7c2afcc74fc">
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<box leftPadding="10" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[CNPJ: ]]></text>
			</staticText>
			<textField pattern="d/M/yyyy">
				<reportElement x="0" y="260" width="555" height="20" uuid="42005c23-616c-41bd-8cb1-203033d154b0">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
				</reportElement>
				<box leftPadding="10" rightPadding="10"/>
				<textElement textAlignment="Center" verticalAlignment="Middle" markup="styled">
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[" A presente certidão é valida até " + (new SimpleDateFormat("dd/MM/yyyy.")).format( $F{dataValidade} )]]></textFieldExpression>
			</textField>
			<textField pattern="">
				<reportElement x="0" y="359" width="555" height="20" uuid="cae05d95-b078-4c46-b0f8-2f31294f51d1">
					<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.x" value="pixel"/>
					<property name="com.jaspersoft.studio.unit.y" value="pixel"/>
				</reportElement>
				<box leftPadding="10" rightPadding="10"/>
				<textElement textAlignment="Center" verticalAlignment="Middle">
					<font size="14"/>
				</textElement>
				<textFieldExpression><![CDATA[$P{DADOS_BASICOS}.getCidade()+", " +(new SimpleDateFormat("dd")).format( $F{dataConcessao} ) + " de " + (new SimpleDateFormat("MMMM")).format( $F{dataConcessao} ) + " de " +(new SimpleDateFormat("yyyy.")).format( $F{dataConcessao} )]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="100" width="90" height="20" uuid="cd2b6764-71f4-47e0-8aa3-38acee2c2b76">
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<box leftPadding="10" rightPadding="2"/>
				<textElement textAlignment="Right" verticalAlignment="Middle">
					<font size="14" isBold="true" pdfFontName="Helvetica-Bold"/>
				</textElement>
				<text><![CDATA[Unidade: ]]></text>
			</staticText>
		</band>
	</detail>
	<pageFooter>
		<band height="13">
			<property name="com.jaspersoft.studio.unit.height" value="pixel"/>
			<textField pattern="dd/MM/yyyy">
				<reportElement mode="Opaque" x="0" y="0" width="60" height="13" backcolor="#FFFFFF" uuid="fc593335-5cbf-4caf-97b3-ff897c676bde"/>
				<box padding="2">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Left">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField pattern="dd/MM/yyyy">
				<reportElement mode="Opaque" x="60" y="0" width="420" height="13" backcolor="#FFFFFF" uuid="8c2f09c6-c33b-4843-8073-d7317eb5fec7"/>
				<box topPadding="2" leftPadding="5">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Center" verticalAlignment="Top">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[(($P{DADOS_BASICOS}.getUnidade() != "" && $P{DADOS_BASICOS}.getUnidade() != null) ? $P{DADOS_BASICOS}.getUnidade() + " - " : "")
+ 
(($P{DADOS_BASICOS}.getEndereco() != "" && $P{DADOS_BASICOS}.getEndereco() != null) ? $P{DADOS_BASICOS}.getEndereco() : "")]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement mode="Opaque" x="520" y="0" width="34" height="13" backcolor="#FFFFFF" uuid="fd319649-de73-4bc8-ba68-f76e26a91428">
					<property name="com.jaspersoft.studio.unit.width" value="pixel"/>
				</reportElement>
				<box topPadding="2" leftPadding="2" rightPadding="5">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement>
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement mode="Opaque" x="480" y="0" width="40" height="13" backcolor="#FFFFFF" uuid="c3b4d6b6-f7be-40f3-b7ad-0e55f8dcd99b"/>
				<box topPadding="2">
					<topPen lineWidth="1.0"/>
				</box>
				<textElement textAlignment="Right">
					<font size="6" isBold="true"/>
				</textElement>
				<textFieldExpression><![CDATA["Pág. "+$V{PAGE_NUMBER}+" de "]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
</jasperReport>
