You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
376 lines
18 KiB
376 lines
18 KiB
<?xml version="1.0" encoding="UTF-8"?>
|
|
<!-- Created with Jaspersoft Studio version 6.17.0.final using JasperReports Library version 6.17.0-6d93193241dd8cc42629e188b94f9e0bc5722efd -->
|
|
<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="Cherry" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="13acf49e-4913-4d1b-bccc-113817ad15d1">
|
|
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
|
|
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="MySqlLocalHost"/>
|
|
<style name="Title" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false"/>
|
|
<style name="SubTitle" forecolor="#CCCCCC" fontName="Times New Roman" fontSize="18" isBold="false"/>
|
|
<style name="Column header" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true"/>
|
|
<style name="Detail" mode="Transparent" fontName="Times New Roman"/>
|
|
<style name="Row" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman">
|
|
<conditionalStyle>
|
|
<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
|
|
<style mode="Opaque" backcolor="#F0EFEF"/>
|
|
</conditionalStyle>
|
|
</style>
|
|
<queryString language="SQL">
|
|
<![CDATA[select * from tb_recibos]]>
|
|
</queryString>
|
|
<field name="data_emprestimo" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="data_emprestimo"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="data_emprestimo"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="id" class="java.lang.Integer">
|
|
<property name="com.jaspersoft.studio.field.name" value="id"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="id"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="emprestimo_id" class="java.lang.Integer">
|
|
<property name="com.jaspersoft.studio.field.name" value="emprestimo_id"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="emprestimo_id"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="data_devolucao_agendada" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="data_devolucao_agendada"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="data_devolucao_agendada"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="data_entrega" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="data_entrega"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="data_entrega"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="livro" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="livro"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="livro"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="usuario" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="usuario"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="usuario"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="tipo" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="tipo"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="tipo"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="multa" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="multa"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="multa"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="status" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="status"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="status"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<field name="funcionario" class="java.lang.String">
|
|
<property name="com.jaspersoft.studio.field.name" value="funcionario"/>
|
|
<property name="com.jaspersoft.studio.field.label" value="funcionario"/>
|
|
<property name="com.jaspersoft.studio.field.tree.path" value="tb_recibos"/>
|
|
<fieldDescription><![CDATA[]]></fieldDescription>
|
|
</field>
|
|
<background>
|
|
<band splitType="Stretch"/>
|
|
</background>
|
|
<title>
|
|
<band height="132" splitType="Stretch">
|
|
<image>
|
|
<reportElement x="456" y="0" width="99" height="132" uuid="97705585-a0b5-4ec7-86f3-ae10c220e6af"/>
|
|
<imageExpression><![CDATA["cherry.jpg"]]></imageExpression>
|
|
</image>
|
|
<frame>
|
|
<reportElement mode="Opaque" x="0" y="0" width="451" height="95" backcolor="#000000" uuid="6c6ca4e1-17cd-4913-93d6-5e670ea9ae8a"/>
|
|
<staticText>
|
|
<reportElement style="Title" x="0" y="0" width="370" height="66" uuid="a2a2cac8-5a7d-4487-8c54-dab235ce4e21"/>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[Cherry Title]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="SubTitle" x="157" y="66" width="249" height="29" uuid="8978eac3-c578-41c9-837e-48d2b0184642"/>
|
|
<textElement>
|
|
<font size="22" isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[Cherry SubTitle]]></text>
|
|
</staticText>
|
|
</frame>
|
|
<frame>
|
|
<reportElement mode="Opaque" x="0" y="100" width="451" height="32" forecolor="#000000" backcolor="#CC0000" uuid="e3c14156-5b51-4201-918b-97fdc012e5d4"/>
|
|
<textField pattern="EEEEE dd MMMMM yyyy">
|
|
<reportElement x="307" y="12" width="144" height="20" forecolor="#FFFFFF" uuid="5c3301e7-a737-4c59-8a2f-a6c79fd1adb8"/>
|
|
<textElement textAlignment="Right">
|
|
<font size="12"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
|
|
</textField>
|
|
</frame>
|
|
</band>
|
|
</title>
|
|
<pageHeader>
|
|
<band splitType="Stretch"/>
|
|
</pageHeader>
|
|
<columnHeader>
|
|
<band height="26" splitType="Stretch">
|
|
<staticText>
|
|
<reportElement style="Column header" x="0" y="7" width="50" height="18" forecolor="#000000" uuid="2216f7be-c63f-4470-9826-41e9ebebc9eb">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d890e1c1-5684-4c27-88b1-499f8970f6ad"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[data_emprestimo]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="50" y="7" width="50" height="18" forecolor="#000000" uuid="6ae9e8b5-1b65-490b-bf0b-af886f5c8ce2">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9e47ef95-59b7-46f2-89fe-2556030140bb"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[id]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="100" y="7" width="50" height="18" forecolor="#000000" uuid="05ff3074-20d9-431d-a609-f3c74d67ca3e">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3136a413-edde-48e2-985d-dc7fcf28fe00"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[emprestimo_id]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="150" y="7" width="50" height="18" forecolor="#000000" uuid="b8580f74-2dfb-46d0-9f36-1d06bf11fd2e">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0942822c-9757-4d85-975e-4f01c54a64bd"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[data_devolucao_agendada]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="200" y="7" width="50" height="18" forecolor="#000000" uuid="67ff6677-1a3a-4b25-94f2-e26cfcda2018">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f79b9fd0-2a75-489c-b019-eb05ab9cb712"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[data_entrega]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="250" y="7" width="50" height="18" forecolor="#000000" uuid="b9bc706d-92c9-4e7b-96d3-e6cef5bb2ba5">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="37ed5007-a5d5-4c78-af3e-37294fd294e5"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[livro]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="300" y="7" width="50" height="18" forecolor="#000000" uuid="b9b1a22d-0115-414e-bdfc-32d72e21588a">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5d1bb69c-4034-42b9-9a7a-b1dbff2a9c9c"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[usuario]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="350" y="7" width="50" height="18" forecolor="#000000" uuid="4c69d593-5c64-4644-8500-296c5d727247">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3398507f-56bb-441b-944c-ba3dd058154b"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[tipo]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="400" y="7" width="50" height="18" forecolor="#000000" uuid="c5ce8252-1283-4e29-8a49-b48a3c7db839">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d039641f-b80b-4dd9-adaf-b49331616bfb"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[multa]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="450" y="7" width="50" height="18" forecolor="#000000" uuid="fece9269-0dfd-4256-85e4-2e075e57926b">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0127de5f-966c-44f0-ada8-8eb3d3cc9979"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[status]]></text>
|
|
</staticText>
|
|
<staticText>
|
|
<reportElement style="Column header" x="500" y="7" width="50" height="18" forecolor="#000000" uuid="442eb29f-3152-465f-a1ce-fd7b4ac8c83a">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d5c5a03d-bb38-4e82-9e70-0bc4bb7c32c4"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font isBold="false"/>
|
|
</textElement>
|
|
<text><![CDATA[funcionario]]></text>
|
|
</staticText>
|
|
</band>
|
|
</columnHeader>
|
|
<detail>
|
|
<band height="18" splitType="Stretch">
|
|
<frame>
|
|
<reportElement style="Row" mode="Opaque" x="0" y="0" width="555" height="18" uuid="b50221b5-8254-440b-8c6f-1f0b138c9259"/>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="0" y="0" width="50" height="18" uuid="3447f2f7-ab9b-46da-b342-437025be4146">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d890e1c1-5684-4c27-88b1-499f8970f6ad"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{data_emprestimo}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="50" y="0" width="50" height="18" uuid="d843a774-b8c2-4186-bdb0-37367700a92d">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9e47ef95-59b7-46f2-89fe-2556030140bb"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="100" y="0" width="50" height="18" uuid="e7c6d6ed-80b1-4b45-a385-75422e0fb95f">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3136a413-edde-48e2-985d-dc7fcf28fe00"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{emprestimo_id}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="150" y="0" width="50" height="18" uuid="c9336283-fa61-4917-98c1-ae830e9a815f">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0942822c-9757-4d85-975e-4f01c54a64bd"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{data_devolucao_agendada}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="200" y="0" width="50" height="18" uuid="41fa1d56-79db-49ad-a372-1007963d0045">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f79b9fd0-2a75-489c-b019-eb05ab9cb712"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{data_entrega}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="250" y="0" width="50" height="18" uuid="163b99e0-f65f-4932-bedd-e96acbe72970">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="37ed5007-a5d5-4c78-af3e-37294fd294e5"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{livro}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="300" y="0" width="50" height="18" uuid="409141db-a763-4d0e-a85c-8cb3640e5269">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5d1bb69c-4034-42b9-9a7a-b1dbff2a9c9c"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{usuario}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="350" y="0" width="50" height="18" uuid="9deda814-95d1-4d71-9b3e-20152766c31e">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3398507f-56bb-441b-944c-ba3dd058154b"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{tipo}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="400" y="0" width="50" height="18" uuid="cf890b88-6457-494e-90f7-ebc1224d4d71">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d039641f-b80b-4dd9-adaf-b49331616bfb"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{multa}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="450" y="0" width="50" height="18" uuid="26b953dd-d6be-4076-9b32-e5327428bf8d">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0127de5f-966c-44f0-ada8-8eb3d3cc9979"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{status}]]></textFieldExpression>
|
|
</textField>
|
|
<textField textAdjust="StretchHeight">
|
|
<reportElement style="Detail" positionType="Float" x="500" y="0" width="50" height="18" uuid="6debca13-8afd-4af0-956b-15f753da9c2a">
|
|
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="d5c5a03d-bb38-4e82-9e70-0bc4bb7c32c4"/>
|
|
</reportElement>
|
|
<textElement>
|
|
<font size="14"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[$F{funcionario}]]></textFieldExpression>
|
|
</textField>
|
|
</frame>
|
|
</band>
|
|
</detail>
|
|
<columnFooter>
|
|
<band height="7" splitType="Stretch">
|
|
<line>
|
|
<reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1" uuid="1133a906-5b71-476e-9f3e-bc97c97058c1"/>
|
|
<graphicElement>
|
|
<pen lineWidth="0.5" lineColor="#999999"/>
|
|
</graphicElement>
|
|
</line>
|
|
</band>
|
|
</columnFooter>
|
|
<pageFooter>
|
|
<band height="25" splitType="Stretch">
|
|
<frame>
|
|
<reportElement mode="Opaque" x="0" y="1" width="555" height="24" forecolor="#D0B48E" backcolor="#000000" uuid="729c3539-f946-4d0e-a0a7-bda2815ea1b0"/>
|
|
<textField evaluationTime="Report">
|
|
<reportElement style="Column header" x="513" y="0" width="40" height="20" forecolor="#FFFFFF" uuid="4834e99c-7f6c-485a-b098-50e5187f2ab4"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
|
|
</textField>
|
|
<textField>
|
|
<reportElement style="Column header" x="433" y="0" width="80" height="20" forecolor="#FFFFFF" uuid="9825b46e-76f1-469a-abb8-a1cc27aad685"/>
|
|
<textElement textAlignment="Right" verticalAlignment="Middle">
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
|
|
</textField>
|
|
<textField pattern="EEEEE dd MMMMM yyyy">
|
|
<reportElement style="Column header" x="2" y="1" width="197" height="20" forecolor="#FFFFFF" uuid="137d38c7-1a83-4fc5-b156-9d5f1b1a0ddc"/>
|
|
<textElement verticalAlignment="Middle">
|
|
<font size="10" isBold="false"/>
|
|
</textElement>
|
|
<textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression>
|
|
</textField>
|
|
</frame>
|
|
</band>
|
|
</pageFooter>
|
|
<summary>
|
|
<band splitType="Stretch"/>
|
|
</summary>
|
|
</jasperReport>
|
|
|