trytond-farm_prescription/prescription.jrxml

447 lines
21 KiB
XML

<?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="recipt" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="a2e6542d-192c-4c06-aba2-26e19b94d2f3">
<property name="ireport.zoom" value="1.331000000000002"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="64"/>
<property name="ireport.layers" value="##Tue Jun 25 17:11:49 CEST 2013\nlayer.0.name=Background\nlayer.0.visible=true\nlayer.0.id=0"/>
<property name="TRYTON_RELATIONS" value="[&apos;lines&apos;]"/>
<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>
<parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"/>
<parameter name="STANDARD_DIR" class="java.lang.String"/>
<parameter name="SUBTITLE" class="java.lang.String"/>
<parameter name="HEADER_DS" class="java.lang.Object"/>
<parameter name="COMMENT" class="java.lang.String"/>
<parameter name="budget" class="java.lang.String"/>
<parameter name="start_date" class="java.lang.String"/>
<parameter name="end_date" class="java.lang.String"/>
<parameter name="currency" class="java.lang.String"/>
<queryString language="xPath">
<![CDATA[/dat./modules/farm_prescription/record]]>
</queryString>
<field name="reference" class="java.lang.String">
<fieldDescription><![CDATA[reference-reference]]></fieldDescription>
</field>
<field name="veterinarian-name" class="java.lang.String">
<fieldDescription><![CDATA[veterinarian-veterinarian/name-name]]></fieldDescription>
</field>
<field name="veterinarian-street" class="java.lang.String">
<fieldDescription><![CDATA[veterinarian-veterinarian/addresses-addresses/street-street]]></fieldDescription>
</field>
<field name="veterinarian-city" class="java.lang.String">
<fieldDescription><![CDATA[veterinarian-veterinarian/party-party/addresses-addresses/city-city]]></fieldDescription>
</field>
<field name="collegiate_number" class="java.lang.String">
<fieldDescription><![CDATA[veterinarian-veterinarian/collegiate_number-collegiate_number]]></fieldDescription>
</field>
<field name="company_name" class="java.lang.String">
<fieldDescription><![CDATA[company-company/party-party/name-name]]></fieldDescription>
</field>
<field name="company_street" class="java.lang.String">
<fieldDescription><![CDATA[company-company/party-party/addresses-addresses/street-street]]></fieldDescription>
</field>
<field name="company_city" class="java.lang.String">
<fieldDescription><![CDATA[company-company/party-party/addresses-addresses/city-city]]></fieldDescription>
</field>
<field name="company_vat_code" class="java.lang.String">
<fieldDescription><![CDATA[company-company/party-party/vat_code-vat_code]]></fieldDescription>
</field>
<field name="party_name" class="java.lang.String">
<fieldDescription><![CDATA[party-party/name-name]]></fieldDescription>
</field>
<field name="party_street" class="java.lang.String">
<fieldDescription><![CDATA[party-party/addresses-addresses/street-street]]></fieldDescription>
</field>
<field name="party_city" class="java.lang.String">
<fieldDescription><![CDATA[party-party/addresses-addresses/city-city]]></fieldDescription>
</field>
<field name="party_zip" class="java.lang.String">
<fieldDescription><![CDATA[party-party/addresses-addresses/zip-zip]]></fieldDescription>
</field>
<field name="party_vat_code" class="java.lang.String">
<fieldDescription><![CDATA[party-party/vat_code-vat_code]]></fieldDescription>
</field>
<field name="afection" class="java.lang.String">
<fieldDescription><![CDATA[afection-afection]]></fieldDescription>
</field>
<field name="product" class="java.lang.String">
<fieldDescription><![CDATA[lines-lines/product-product/rec_name-rec_name]]></fieldDescription>
</field>
<field name="line_quantity" class="java.lang.Number">
<fieldDescription><![CDATA[lines-lines/quantity-quantity]]></fieldDescription>
</field>
<field name="unit_symbol" class="java.lang.String">
<fieldDescription><![CDATA[lines-lines/unit-unit/symbol-symbol]]></fieldDescription>
</field>
<field name="quantity" class="java.lang.Number">
<fieldDescription><![CDATA[quantity-quantity]]></fieldDescription>
</field>
<field name="waiting_period" class="java.lang.String">
<fieldDescription><![CDATA[waiting_period-waiting_period]]></fieldDescription>
</field>
<field name="expiry_period" class="java.lang.String">
<fieldDescription><![CDATA[expiry_period]]></fieldDescription>
</field>
<field name="date" class="java.util.Date">
<fieldDescription><![CDATA[date-date]]></fieldDescription>
</field>
<field name="delivery_date" class="java.util.Date">
<fieldDescription><![CDATA[delivery_date-delivery_date]]></fieldDescription>
</field>
<field name="note" class="java.lang.String">
<fieldDescription><![CDATA[note-note]]></fieldDescription>
</field>
<variable name="L" class="java.util.Locale">
<variableExpression><![CDATA[$P{REPORT_LOCALE}]]></variableExpression>
<initialValueExpression><![CDATA[$P{REPORT_LOCALE}]]></initialValueExpression>
</variable>
<background>
<band/>
</background>
<title>
<band height="56">
<textField>
<reportElement uuid="2924b266-8c5f-4a29-95ce-716893b1e31e" x="0" y="26" width="555" height="16"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="8"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"THIS RECIPT CAN ONLY BE USED ONE TIME")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="86eed93e-d9c9-4cf3-9c73-337ab7e7764f" x="102" y="0" width="365" height="24"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="16" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"RECIPT")+": "+$F{reference}]]></textFieldExpression>
</textField>
</band>
</title>
<pageHeader>
<band/>
</pageHeader>
<columnHeader>
<band height="272">
<textField isBlankWhenNull="true">
<reportElement uuid="5324f0c9-7c03-4b4e-a498-40830a8a2b39" x="2" y="262" width="250" height="10"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true" pdfFontName="Helvetica"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Denomination of autorized medicated mixtures")]]></textFieldExpression>
</textField>
<textField isBlankWhenNull="true">
<reportElement uuid="97609307-fff7-4b37-8838-abc5c71e0342" x="268" y="262" width="90" height="10"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="7" isBold="true" isUnderline="true" pdfFontName="Helvetica"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"DOSIFICATION")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="f05efcd3-5e74-404f-9be3-54397f88522d" x="0" y="0" width="555" height="16"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Surname, name and address of veterinarian")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="09b0d73f-6833-4b72-85ac-c063696215d7" x="0" y="80" width="555" height="16"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Surname, name and address of manufacturer or supplier")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="934a6336-9529-4bf3-ac67-a333cb62b5b9" x="0" y="157" width="555" height="16"/>
<textElement verticalAlignment="Middle">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Surname, name and address of the party")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="e2aff0c5-9a2f-41cf-b3a2-dc27a16081ea" x="41" y="29" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{veterinarian-name}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="d3bf1198-0744-4d7e-9907-6561f1cf46de" x="41" y="16" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{collegiate_number}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="edb26f88-31b1-4d33-a88e-2bd967058941" x="41" y="42" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{veterinarian-street}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="74e6e37e-5461-42b3-be19-42dea69d7bcc" x="41" y="55" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{veterinarian-city}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="6d7b1856-b164-4dbd-b442-ab9e70d36c2b" x="41" y="121" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_street}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="cf6816df-657d-4b6c-ae1a-110f6370cbda" x="41" y="134" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_vat_code}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="3ac2657a-5378-4502-81a2-2c4d3b3925a5" x="41" y="109" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_street}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="aebd5dff-bea8-41b5-b0e8-913a9d4d5b4f" x="41" y="96" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_name}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="79885dc5-deb0-4977-b039-55523c4ccd7a" x="268" y="198" width="90" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{party_zip}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="b4e7fabe-2761-4ee7-a83f-a36c4e0390a2" x="41" y="173" width="227" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{party_name}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="f2252f2f-1555-443f-8e26-289118277e52" x="41" y="186" width="317" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{party_street}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="a659076f-cf61-4d15-948f-904fbc9d5928" x="41" y="198" width="227" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{party_city}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="e47f7b87-f1fa-4010-a4b3-79e2960e694e" x="268" y="173" width="90" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{party_vat_code}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="fd724b4e-250a-40cd-bb0f-41964bb76e5d" x="2" y="222" width="206" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Number e identification of the animals")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="6969057b-ac55-4334-ab67-112b4f8fa55a" x="2" y="238" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Afection")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="882a137d-60c7-474a-85ff-a0adf05e7e41" x="208" y="225" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{afection}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="cbcb856f-185c-48bc-98fc-3f006d7892ef" x="102" y="241" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{afection}]]></textFieldExpression>
</textField>
</band>
</columnHeader>
<detail>
<band height="15">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="1a9998f1-c0b1-4767-8433-9154d70083a3" x="41" y="0" width="211" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{product}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement uuid="1926abd0-3b52-4cb5-8d4f-4aed0e803514" x="268" y="0" width="56" height="13"/>
<textElement textAlignment="Right" verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{line_quantity}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="#,##0.00;-#,##0.00" isBlankWhenNull="true">
<reportElement uuid="7f80b5bb-ce52-4a69-bb57-9ba506aa971e" x="337" y="0" width="21" height="13"/>
<textElement verticalAlignment="Middle">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{unit_symbol}]]></textFieldExpression>
</textField>
</band>
</detail>
<columnFooter>
<band height="115">
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="bf60229d-bf1f-4327-b480-350c610133fa" x="100" y="16" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{quantity}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="5351f053-0ec0-4e6f-a260-ef64f4b172cf" x="0" y="13" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Quantity")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9471829f-4b5d-40a6-8324-18c26233896e" x="2" y="29" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Especial notes")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="9379e8b7-69c4-4cb1-abf6-b3f9aae4d9b3" x="102" y="32" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{note}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="9e761352-ca1d-4c6a-b792-4c8e87d38747" x="2" y="69" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Retention period")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="ce97d82b-bb26-4569-9516-47a03ce0e8b1" x="104" y="88" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{expiry_period}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="539bca6a-bccc-4934-9db5-be7bb6451e98" x="104" y="72" width="335" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{waiting_period}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="95419c3b-0cef-4774-85bc-96ff008c0854" x="2" y="85" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Waiting period")]]></textFieldExpression>
</textField>
</band>
</columnFooter>
<pageFooter>
<band height="145">
<textField>
<reportElement uuid="89066031-8276-4fc8-a29b-db72fb6db9b8" x="10" y="23" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_city}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" isBlankWhenNull="true">
<reportElement uuid="e66ea228-a7fa-4bab-ade2-4533b97580d5" x="112" y="42" width="188" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{delivery_date}]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement uuid="4f2674db-0e47-429a-9a74-3531e525878b" x="110" y="26" width="190" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="0da30b12-a152-461f-b824-81a4e4d5eb3c" x="12" y="39" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Delivery date")]]></textFieldExpression>
</textField>
<textField isStretchWithOverflow="true" pattern="dd/MM/yyyy" isBlankWhenNull="true">
<reportElement uuid="1f1fab5b-9d4a-4f67-9f19-740bc7befec8" x="122" y="109" width="178" height="13"/>
<textElement verticalAlignment="Bottom">
<font size="7"/>
</textElement>
<textFieldExpression><![CDATA[$F{date}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="181a91c7-c494-4127-8ee7-962a4f053e96" x="22" y="106" width="100" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true"/>
</textElement>
<textFieldExpression><![CDATA[$F{company_city}]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="64c6ace5-eb0c-41b2-a6f1-f70aff8d097c" x="314" y="26" width="153" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true" isUnderline="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Veterinarian Signature")]]></textFieldExpression>
</textField>
<textField>
<reportElement uuid="1f3c4d0c-dfff-45a0-bf91-e7b8a8dbe22c" x="314" y="106" width="153" height="16"/>
<textElement verticalAlignment="Bottom">
<font size="7" isBold="true" isUnderline="true"/>
</textElement>
<textFieldExpression><![CDATA[tr($V{L},"Supplier Signature")]]></textFieldExpression>
</textField>
</band>
</pageFooter>
<summary>
<band/>
</summary>
</jasperReport>