diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2022-09-13 12:05:33 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2022-09-13 12:05:33 +0700 |
| commit | 8f3d096dbae18bacd95796d03b17d4d94a806c85 (patch) | |
| tree | ae90032724dabe417b907db43145639e6df9565f /jasper_reports/custom_reports | |
| parent | 0d87fec0c4c6fb573b1a09076f6d50844d8d0a80 (diff) | |
jasper report integration
Diffstat (limited to 'jasper_reports/custom_reports')
| -rwxr-xr-x | jasper_reports/custom_reports/DeliverySlip_A5.jasper | bin | 0 -> 82250 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/DeliverySlip_A5.jrxml | 430 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/Invoice_jasper.jasper | bin | 0 -> 109967 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/Invoice_jasper.jrxml | 338 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/global.png | bin | 0 -> 5823 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/jasper_sale_order.jrxml | 156 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/logo-serpents.png | bin | 0 -> 7448 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/sale_order_report.jasper | bin | 0 -> 73241 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/sale_order_report.jrxml | 194 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/sale_order_template.jrxml | 119 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/sub_report.jrxml | 141 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/user.jasper | bin | 0 -> 138413 bytes | |||
| -rwxr-xr-x | jasper_reports/custom_reports/user.jrxml | 119 |
13 files changed, 1497 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/DeliverySlip_A5.jasper b/jasper_reports/custom_reports/DeliverySlip_A5.jasper Binary files differnew file mode 100755 index 0000000..d2cda54 --- /dev/null +++ b/jasper_reports/custom_reports/DeliverySlip_A5.jasper diff --git a/jasper_reports/custom_reports/DeliverySlip_A5.jrxml b/jasper_reports/custom_reports/DeliverySlip_A5.jrxml new file mode 100755 index 0000000..632a494 --- /dev/null +++ b/jasper_reports/custom_reports/DeliverySlip_A5.jrxml @@ -0,0 +1,430 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<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="Blank_A4_5" pageWidth="595" pageHeight="420" orientation="Landscape" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7ca89ceb-4b1e-446c-bd67-06493bb506b1"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['move_lines']]]> + </property> + <queryString language="xPath"> + <![CDATA[/data/record]]> + </queryString> + <field name="ItemCode" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Operations_without_package-move_line_ids_without_package/Product-product_id/Internal_Reference-default_code"/> + <fieldDescription><![CDATA[Operations_without_package-move_line_ids_without_package/Product-product_id/Internal_Reference-default_code]]></fieldDescription> + </field> + <field name="ProductName" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Operations_without_package-move_line_ids_without_package/Product-product_id/Name-name"/> + <fieldDescription><![CDATA[Operations_without_package-move_line_ids_without_package/Product-product_id/Name-name]]></fieldDescription> + </field> + <field name="CustomerName" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Contact-partner_id/Name-name"/> + <fieldDescription><![CDATA[Contact-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Address" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Contact-partner_id/Street-street"/> + <fieldDescription><![CDATA[Contact-partner_id/Street-street]]></fieldDescription> + </field> + <field name="Phone" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Contact-partner_id/Phone-phone"/> + <fieldDescription><![CDATA[Contact-partner_id/Phone-phone]]></fieldDescription> + </field> + <field name="SONo" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Source_Document-origin"/> + <fieldDescription><![CDATA[Source_Document-origin]]></fieldDescription> + </field> + <field name="Date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Date_of_Transfer-date_done"/> + <fieldDescription><![CDATA[Date_of_Transfer-date_done]]></fieldDescription> + </field> + <field name="DONo" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Reference-name"/> + <fieldDescription><![CDATA[Reference-name]]></fieldDescription> + </field> + <field name="Ekspedisi" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Carrier-carrier_id/Delivery_Method-name"/> + <fieldDescription><![CDATA[Carrier-carrier_id/Delivery_Method-name]]></fieldDescription> + </field> + <field name="UOM" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Operations_without_package-move_line_ids_without_package/Unit_of_Measure-product_uom_id/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[Operations_without_package-move_line_ids_without_package/Unit_of_Measure-product_uom_id/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Internal_Reference-default_code" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_Moves-move_lines/Product-product_id/Internal_Reference-default_code"/> + <fieldDescription><![CDATA[Stock_Moves-move_lines/Product-product_id/Internal_Reference-default_code]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_Moves-move_lines/Product-product_id/Name-name"/> + <fieldDescription><![CDATA[Stock_Moves-move_lines/Product-product_id/Name-name]]></fieldDescription> + </field> + <field name="Real_Quantity-product_qty" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_Moves-move_lines/Real_Quantity-product_qty"/> + <fieldDescription><![CDATA[Stock_Moves-move_lines/Real_Quantity-product_qty]]></fieldDescription> + </field> + <field name="Unit_of_Measure-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_Moves-move_lines/Unit_of_Measure-product_uom/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[Stock_Moves-move_lines/Unit_of_Measure-product_uom/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Picking_Code-picking_code" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Picking_Code-picking_code"/> + <fieldDescription><![CDATA[Picking_Code-picking_code]]></fieldDescription> + </field> + <field name="Qty_BigDecimal" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_Moves-move_lines/Real_Quantity-product_qty"/> + <fieldDescription><![CDATA[Stock_Moves-move_lines/Real_Quantity-product_qty]]></fieldDescription> + </field> + <variable name="Jumlah_Barang" class="java.lang.Integer" calculation="Count"> + <variableExpression><![CDATA[$F{ProductName}]]></variableExpression> + </variable> + <variable name="Total_Qty" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$F{Qty_BigDecimal}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="40" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="180" height="19" uuid="e5b47894-822c-470d-b8ef-1d32cdb8fdd8"/> + <textElement markup="none"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[PT Indoteknik Dotcom Gemilang]]></text> + </staticText> + <staticText> + <reportElement x="180" y="0" width="200" height="19" uuid="27e03116-dfa6-4f71-af4b-94238bfe6db8"/> + <textElement textAlignment="Center" markup="none"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Surat Jalan]]></text> + </staticText> + <image> + <reportElement x="390" y="0" width="165" height="30" uuid="c1fd4c13-d80d-44ba-82c7-e10435c3931c"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/report/barcode/?type=Code128&value="+$F{Picking_Code-picking_code}+"&width=300&height=50"]]></imageExpression> + </image> + <textField> + <reportElement x="390" y="30" width="165" height="10" uuid="87b21b3f-a965-467b-a390-09387ff4c2bf"/> + <textElement textAlignment="Center"> + <font size="6"/> + </textElement> + <textFieldExpression><![CDATA[$F{Picking_Code-picking_code}]]></textFieldExpression> + </textField> + </band> + </title> + <pageHeader> + <band height="50" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="280" height="10" uuid="6ca71a9b-cc1e-42ae-9985-72121f9be1a9"/> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Kepada]]></text> + </staticText> + <textField> + <reportElement x="0" y="10" width="280" height="10" uuid="29cbb842-a147-4d34-9911-1c426789311e"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{CustomerName}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="20" width="280" height="20" uuid="f0515c7c-ded5-438c-bc64-3f907c262501"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Address}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="40" width="100" height="10" uuid="41904a3a-1284-49a6-a1e6-a29b527d9d42"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Phone}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="280" y="0" width="100" height="10" uuid="32162bd1-d6e4-453b-afa3-77f953a56557"/> + <textElement textAlignment="Left"> + <font size="8"/> + </textElement> + <text><![CDATA[No Order]]></text> + </staticText> + <staticText> + <reportElement x="280" y="10" width="100" height="10" uuid="1f3941da-bda3-4650-8ceb-697ae43be3c7"/> + <textElement textAlignment="Left"> + <font size="8"/> + </textElement> + <text><![CDATA[No DO]]></text> + </staticText> + <staticText> + <reportElement x="280" y="20" width="100" height="10" uuid="94652b05-841f-4150-99cc-a8adec5be297"/> + <textElement textAlignment="Left"> + <font size="8"/> + </textElement> + <text><![CDATA[Ekspedisi]]></text> + </staticText> + <staticText> + <reportElement x="280" y="30" width="100" height="10" uuid="91358641-ba5b-4741-9ff9-773506e44fad"/> + <textElement textAlignment="Left"> + <font size="8"/> + </textElement> + <text><![CDATA[No Resi]]></text> + </staticText> + <textField> + <reportElement x="380" y="0" width="175" height="10" uuid="0aadd48d-abbe-49bb-b460-9d52e7ae4780"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{SONo}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="380" y="10" width="175" height="10" uuid="326e9ee0-8924-40c6-b4f7-145a2496f6a5"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{DONo}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="380" y="20" width="175" height="10" uuid="2f7ff77b-bef5-4092-9ad3-6e955359fa08"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Ekspedisi}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="10" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="20" height="10" uuid="9329023d-d677-4f77-ac6f-57a0b917db83"/> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[No]]></text> + </staticText> + <staticText> + <reportElement x="20" y="0" width="100" height="10" uuid="3f275bdf-4dc8-4bb5-a719-d1aef5a84e46"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2fbd4baa-83af-42f6-9b81-5099916b205b"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Item Code]]></text> + </staticText> + <staticText> + <reportElement x="120" y="0" width="300" height="10" uuid="bd07fa03-7433-44af-a2f1-f7a33a75217b"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2cb61511-dfd0-4a31-8e17-8d0abb141bf1"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Product]]></text> + </staticText> + <staticText> + <reportElement x="420" y="0" width="60" height="10" uuid="2ed28f46-ba65-41a0-a9c9-a07c887d2d83"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1b4ef0cd-e036-41aa-8f13-5493a4ae0ad6"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Qty]]></text> + </staticText> + <staticText> + <reportElement x="480" y="0" width="75" height="10" uuid="de53e020-b3e7-48dd-af39-00a36a283b2b"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="859e0bfe-3143-40bc-86e1-45d14977b47c"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[UOM]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="12" splitType="Stretch"> + <textField> + <reportElement x="120" y="0" width="300" height="10" uuid="a6166c16-dddf-4d4b-9507-a36d5a03dbef"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ebb69155-e03c-4113-a895-144d5307e239"/> + </reportElement> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="480" y="0" width="75" height="10" uuid="f92f1f54-ecd2-4461-9d0d-d517523bb273"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2b17ae44-66f6-4e69-942f-8d75337f080e"/> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Unit_of_Measure-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="0" width="20" height="10" uuid="9bdcb204-03f7-456a-a1e1-35a3dcd6cb1e"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> + </textField> + <break> + <reportElement x="0" y="11" width="100" height="1" uuid="9611fbef-4224-48d6-b9cd-09e91ef84d77"> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + <property name="com.jaspersoft.studio.unit.y" value="px"/> + <printWhenExpression><![CDATA[$V{REPORT_COUNT}==20]]></printWhenExpression> + </reportElement> + </break> + <textField> + <reportElement x="20" y="0" width="100" height="10" uuid="d7ed5eeb-4493-467f-8bc3-46c9dedec7ae"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0fc318ec-7a48-48ed-9e3a-7c3810d848f7"/> + </reportElement> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Internal_Reference-default_code}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="420" y="0" width="60" height="10" uuid="03ca17c9-c940-4aea-8d4d-9f6822998001"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="79fe52b4-2f7c-4811-944b-55ee974e991c"/> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Qty_BigDecimal}]]></textFieldExpression> + </textField> + </band> + </detail> + <pageFooter> + <band height="10"> + <staticText> + <reportElement x="437" y="0" width="39" height="10" uuid="47958420-1dcb-4ecf-a3aa-9ae4ea040130"/> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Halaman]]></text> + </staticText> + <staticText> + <reportElement x="506" y="0" width="19" height="10" uuid="19843949-b9d1-4d2d-9728-51f701ec11fa"/> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[dari]]></text> + </staticText> + <textField> + <reportElement x="476" y="0" width="30" height="10" uuid="b9133a7f-6e33-4ba2-a3f8-7791d82b4576"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField evaluationTime="Report"> + <reportElement x="525" y="0" width="30" height="10" uuid="16a7219a-7de8-47ed-ab16-3f24c89f4f2e"/> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + </band> + </pageFooter> + <summary> + <band height="50" splitType="Stretch"> + <textField> + <reportElement x="260" y="0" width="80" height="12" uuid="f08b4b72-4323-4532-9791-8ff8aa2df593"/> + <textElement textAlignment="Right" verticalAlignment="Bottom"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{Jumlah_Barang}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="200" y="0" width="60" height="12" uuid="799b4bd4-7604-45fb-b8ef-2eba344dd101"/> + <textElement textAlignment="Right" verticalAlignment="Bottom"> + <font size="8"/> + </textElement> + <text><![CDATA[Jumlah Barang]]></text> + </staticText> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="420" y="0" width="60" height="12" uuid="c2f3749a-89aa-494a-ae30-4683e46c90b5"/> + <textElement textAlignment="Right" verticalAlignment="Bottom"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{Total_Qty}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="340" y="0" width="80" height="12" uuid="497e85ca-e95a-4300-8ff4-588d134d8c2d"/> + <textElement textAlignment="Right" verticalAlignment="Bottom"> + <font size="8"/> + </textElement> + <text><![CDATA[Total Qty]]></text> + </staticText> + <staticText> + <reportElement x="492" y="40" width="50" height="10" uuid="a59a8370-0ec7-4bc1-9acb-4f16756eab2c"/> + <box> + <topPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Penerima]]></text> + </staticText> + <staticText> + <reportElement x="410" y="40" width="50" height="10" uuid="8ed381ef-c03d-46ad-ac67-491edc0cb715"/> + <box> + <topPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Security]]></text> + </staticText> + <staticText> + <reportElement x="305" y="40" width="50" height="10" uuid="5fadd41c-f414-46ff-a2f2-3022fdf615a2"/> + <box> + <topPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Driver]]></text> + </staticText> + <staticText> + <reportElement x="205" y="40" width="50" height="10" uuid="ff36a278-3484-462b-a491-26d11b76dd14"/> + <box> + <topPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Gudang]]></text> + </staticText> + <staticText> + <reportElement x="100" y="40" width="50" height="10" uuid="2ac2e22f-ddf8-44f4-bdd6-a30b11d5ab2f"/> + <box> + <topPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center"> + <font size="8"/> + </textElement> + <text><![CDATA[Finance]]></text> + </staticText> + <line> + <reportElement x="0" y="0" width="555" height="1" uuid="cfaed684-f1df-483d-a8f0-0f5a64c10951"/> + <graphicElement> + <pen lineWidth="0.5"/> + </graphicElement> + </line> + </band> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/Invoice_jasper.jasper b/jasper_reports/custom_reports/Invoice_jasper.jasper Binary files differnew file mode 100755 index 0000000..2feab57 --- /dev/null +++ b/jasper_reports/custom_reports/Invoice_jasper.jasper diff --git a/jasper_reports/custom_reports/Invoice_jasper.jrxml b/jasper_reports/custom_reports/Invoice_jasper.jrxml new file mode 100755 index 0000000..11c2d77 --- /dev/null +++ b/jasper_reports/custom_reports/Invoice_jasper.jrxml @@ -0,0 +1,338 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 3.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="Invoice_demo" language="groovy" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" whenResourceMissingType="Key"> + <property name="OPENERP_RELATIONS" value="['invoice_line_ids']"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Odoo Invoice"/> + <style name="Table" lineSpacing="Single"> + <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> + <style name="Table_TH" mode="Opaque" backcolor="#FFFFFF" lineSpacing="Single"> + <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_CH" mode="Opaque" backcolor="#CACED0" lineSpacing="Single"> + <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_TD" mode="Opaque" backcolor="#FFFFFF" lineSpacing="Single"> + <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> + <queryString language="xPath"> + <![CDATA[/data/record]]> + </queryString> + <field name="City-city" class="java.lang.String"> + <fieldDescription><![CDATA[Commercial_Entity-commercial_partner_id/City-city]]></fieldDescription> + </field> + <field name="Email-email" class="java.lang.String"> + <fieldDescription><![CDATA[Commercial_Entity-commercial_partner_id/Email-email]]></fieldDescription> + </field> + <field name="Mobile-mobile" class="java.lang.String"> + <fieldDescription><![CDATA[Commercial_Entity-commercial_partner_id/Mobile-mobile]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <fieldDescription><![CDATA[Commercial_Entity-commercial_partner_id/Name-name]]></fieldDescription> + </field> + <field name="Street-street" class="java.lang.String"> + <fieldDescription><![CDATA[Commercial_Entity-commercial_partner_id/Street-street]]></fieldDescription> + </field> + <field name="Company_Name-name" class="java.lang.String"> + <fieldDescription><![CDATA[Company-company_id/Company_Name-name]]></fieldDescription> + </field> + <field name="City-city_1" class="java.lang.String"> + <fieldDescription><![CDATA[Company-company_id/City-city]]></fieldDescription> + </field> + <field name="Email-email_1" class="java.lang.String"> + <fieldDescription><![CDATA[Company-company_id/Email-email]]></fieldDescription> + </field> + <field name="Street-street_1" class="java.lang.String"> + <fieldDescription><![CDATA[Company-company_id/Street-street]]></fieldDescription> + </field> + <field name="Phone-phone" class="java.lang.String"> + <fieldDescription><![CDATA[Company-company_id/Phone-phone]]></fieldDescription> + </field> + <field name="Description-name" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Description-name]]></fieldDescription> + </field> + <field name="Amount-price_total" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Amount-price_total]]></fieldDescription> + </field> + <field name="Unit_Price-price_unit" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Unit_Price-price_unit]]></fieldDescription> + </field> + <field name="Quantity-quantity" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Quantity-quantity]]></fieldDescription> + </field> + <field name="Amount-price_subtotal" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Amount-price_subtotal]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <fieldDescription><![CDATA[Total-amount_total]]></fieldDescription> + </field> + <field name="ID-id" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/ID-id]]></fieldDescription> + </field> + <field name="Invoice_Reference-invoice_id" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Lines-invoice_line_ids/Invoice_Reference-invoice_id]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <fieldDescription><![CDATA[Display_Name-display_name]]></fieldDescription> + </field> + <field name="Number-number" class="java.lang.String"> + <fieldDescription><![CDATA[Number-number]]></fieldDescription> + </field> + <field name="Tax-amount_tax" class="java.lang.String"> + <fieldDescription><![CDATA[Tax-amount_tax]]></fieldDescription> + </field> + <field name="Total__In_Words_-amount_total_words" class="java.lang.String"> + <fieldDescription><![CDATA[Total__In_Words_-amount_total_words]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <fieldDescription><![CDATA[Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Invoice_Date-date_invoice" class="java.lang.String"> + <fieldDescription><![CDATA[Invoice_Date-date_invoice]]></fieldDescription> + </field> + <detail> + <band height="243"> + <printWhenExpression><![CDATA[!$F{Name-name}.equals("Name-name")]]></printWhenExpression> + <textField> + <reportElement isPrintRepeatedValues="false" x="3" y="7" width="548" height="25" isRemoveLineWhenBlank="true"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement lineSpacing="Single"> + <font size="18" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Company_Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="2" y="131" width="258" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Street-street} + "-" + $F{City-city}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="2" y="146" width="258" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Email-email}]]></textFieldExpression> + </textField> + <textField pattern="dd/MM/yyyy"> + <reportElement isPrintRepeatedValues="false" x="433" y="32" width="119" height="14" isRemoveLineWhenBlank="true"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"/> + <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="2" y="116" width="258" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="383" y="32" width="50" height="15" isRemoveLineWhenBlank="true"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Print Date:"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="383" y="47" width="50" height="14" isRemoveLineWhenBlank="true"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Invoice Date :"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="2" y="91" width="84" height="25" isRemoveLineWhenBlank="true"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement lineSpacing="Single"> + <font size="16" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Bill to:"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="2" y="161" width="258" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Mobile-mobile}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="3" y="32" width="257" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Street-street_1} + "-" + $F{City-city_1}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="3" y="47" width="257" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Email-email_1}]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="3" y="62" width="257" height="15" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Phone-phone}]]></textFieldExpression> + </textField> + <textField> + <reportElement key="" isPrintRepeatedValues="false" x="41" y="194" width="199" height="20" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true"/> + <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA["Description"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="241" y="194" width="78" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA["Quantity"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="340" y="194" width="78" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA["Unit Price"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="440" y="194" width="78" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Right" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA["Subtotal"]]></textFieldExpression> + </textField> + <textField> + <reportElement key="" isPrintRepeatedValues="false" x="41" y="220" width="199" height="20" isPrintWhenDetailOverflows="true"/> + <textElement textAlignment="Left" lineSpacing="1_1_2"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Description-name}.equals("Description-name") ? "" : $F{Description-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="241" y="220" width="78" height="20"/> + <textElement textAlignment="Right" lineSpacing="1_1_2"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Quantity-quantity}.equals("Quantity-quantity") ? "" : String.format("%.2f", Float.parseFloat($F{Quantity-quantity}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="340" y="220" width="78" height="20"/> + <textElement textAlignment="Right" lineSpacing="1_1_2"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Unit_Price-price_unit}.equals("Unit_Price-price_unit") ? "" : String.format("%.2f", Float.parseFloat($F{Unit_Price-price_unit}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="440" y="220" width="78" height="20"/> + <textElement textAlignment="Right" lineSpacing="1_1_2"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Amount-price_subtotal}.equals("Amount-price_subtotal") ? "" : String.format("%.2f", Float.parseFloat($F{Amount-price_subtotal}))]]></textFieldExpression> + </textField> + <line> + <reportElement isPrintRepeatedValues="false" x="41" y="216" width="477" height="1" isPrintInFirstWholeBand="true" forecolor="#B5B3B3"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <printWhenExpression><![CDATA[!$F{Description-name}.equals("Description-name")]]></printWhenExpression> + </reportElement> + </line> + <textField> + <reportElement isPrintRepeatedValues="false" x="433" y="47" width="119" height="14" isRemoveLineWhenBlank="true"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Invoice_Date-date_invoice}.equals("Invoice_Date-date_invoice") ? "" : new SimpleDateFormat("dd/MM/yyyy").format(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse($F{Invoice_Date-date_invoice}))]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="383" y="61" width="50" height="14" isRemoveLineWhenBlank="true"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" verticalAlignment="Middle" lineSpacing="Single"> + <font isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Invoice:"]]></textFieldExpression> + </textField> + <textField> + <reportElement isPrintRepeatedValues="false" x="433" y="61" width="119" height="14" isRemoveLineWhenBlank="true"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression> + </textField> + </band> + </detail> + <lastPageFooter> + <band height="177"> + <staticText> + <reportElement positionType="Float" x="-1" y="40" width="261" height="101"/> + <box> + <topPen lineWidth="1.1" lineStyle="Dashed"/> + <leftPen lineWidth="1.1" lineStyle="Dashed"/> + <bottomPen lineWidth="1.1" lineStyle="Dashed"/> + <rightPen lineWidth="1.1" lineStyle="Dashed"/> + </box> + <textElement lineSpacing="Single"/> + <text><![CDATA[Your notes here]]></text> + </staticText> + <staticText> + <reportElement positionType="Float" mode="Opaque" x="0" y="147" width="556" height="30" backcolor="#E6E8E9"/> + <textElement textAlignment="Center" verticalAlignment="Middle" lineSpacing="Single"> + <font fontName="Serif" size="9" isItalic="true"/> + </textElement> + <text><![CDATA[THANKYOU FOR YOUR BUSINESS]]></text> + </staticText> + <textField> + <reportElement x="380" y="3" width="65" height="20"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" lineSpacing="Single"> + <font size="14" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Untaxed Amount :"]]></textFieldExpression> + </textField> + <textField pattern="EEEEE dd MMMMM yyyy"> + <reportElement x="445" y="3" width="108" height="20"/> + <textElement lineSpacing="Single"> + <font size="14"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Untaxed_Amount-amount_untaxed}.equals("Untaxed_Amount-amount_untaxed") ? "" : String.format("%.2f", Float.parseFloat($F{Untaxed_Amount-amount_untaxed}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="380" y="23" width="65" height="20"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" lineSpacing="Single"> + <font size="14" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Tax :"]]></textFieldExpression> + </textField> + <textField pattern="EEEEE dd MMMMM yyyy"> + <reportElement x="445" y="23" width="108" height="20" isRemoveLineWhenBlank="true"/> + <textElement lineSpacing="Single"> + <font size="14"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Tax-amount_tax}.equals("Tax-amount_tax") && $F{Tax-amount_tax}.equals("") ? "" : String.format("%.2f", Float.parseFloat($F{Tax-amount_tax}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="380" y="46" width="65" height="20"/> + <box rightPadding="4"/> + <textElement textAlignment="Left" lineSpacing="Single"> + <font size="16" isBold="true"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : "Total :"]]></textFieldExpression> + </textField> + <textField pattern="EEEEE dd MMMMM yyyy"> + <reportElement x="445" y="46" width="108" height="20"/> + <textElement lineSpacing="Single"> + <font size="16"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Total-amount_total}.equals("Total-amount_total") ? "" : String.format("%.2f", Float.parseFloat($F{Total-amount_total}))]]></textFieldExpression> + </textField> + </band> + </lastPageFooter> +</jasperReport> diff --git a/jasper_reports/custom_reports/global.png b/jasper_reports/custom_reports/global.png Binary files differnew file mode 100755 index 0000000..016cff4 --- /dev/null +++ b/jasper_reports/custom_reports/global.png diff --git a/jasper_reports/custom_reports/jasper_sale_order.jrxml b/jasper_reports/custom_reports/jasper_sale_order.jrxml new file mode 100755 index 0000000..e73170d --- /dev/null +++ b/jasper_reports/custom_reports/jasper_sale_order.jrxml @@ -0,0 +1,156 @@ +<?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="jasper_sale_order" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bfb08868-d9e1-4ac4-871e-69fed777395f"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Jasper Sale Order"/> + <queryString language="xPath"> + <![CDATA[/data/record]]> + </queryString> + <field name="id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="id"/> + <fieldDescription><![CDATA[id]]></fieldDescription> + </field> + <field name="Last_Modified_on-__last_update" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Last_Modified_on-__last_update"/> + <fieldDescription><![CDATA[Last_Modified_on-__last_update]]></fieldDescription> + </field> + <field name="Security_Token-access_token" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Security_Token-access_token"/> + <fieldDescription><![CDATA[Security_Token-access_token]]></fieldDescription> + </field> + <field name="Next_Activity_Deadline-activity_date_deadline" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Next_Activity_Deadline-activity_date_deadline"/> + <fieldDescription><![CDATA[Next_Activity_Deadline-activity_date_deadline]]></fieldDescription> + </field> + <field name="State-activity_state" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="State-activity_state"/> + <fieldDescription><![CDATA[State-activity_state]]></fieldDescription> + </field> + <field name="Next_Activity_Summary-activity_summary" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Next_Activity_Summary-activity_summary"/> + <fieldDescription><![CDATA[Next_Activity_Summary-activity_summary]]></fieldDescription> + </field> + <field name="Taxes-amount_tax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Taxes-amount_tax"/> + <fieldDescription><![CDATA[Taxes-amount_tax]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Total-amount_total"/> + <fieldDescription><![CDATA[Total-amount_total]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Untaxed_Amount-amount_untaxed"/> + <fieldDescription><![CDATA[Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Customer_Reference-client_order_ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Customer_Reference-client_order_ref"/> + <fieldDescription><![CDATA[Customer_Reference-client_order_ref]]></fieldDescription> + </field> + <field name="Confirmation_Date-confirmation_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Confirmation_Date-confirmation_date"/> + <fieldDescription><![CDATA[Confirmation_Date-confirmation_date]]></fieldDescription> + </field> + <field name="Creation_Date-create_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Creation_Date-create_date"/> + <fieldDescription><![CDATA[Creation_Date-create_date]]></fieldDescription> + </field> + <field name="Order_Date-date_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Order_Date-date_order"/> + <fieldDescription><![CDATA[Order_Date-date_order]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Display_Name-display_name"/> + <fieldDescription><![CDATA[Display_Name-display_name]]></fieldDescription> + </field> + <field name="ID-id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="ID-id"/> + <fieldDescription><![CDATA[ID-id]]></fieldDescription> + </field> + <field name="__of_Invoices-invoice_count" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="__of_Invoices-invoice_count"/> + <fieldDescription><![CDATA[__of_Invoices-invoice_count]]></fieldDescription> + </field> + <field name="Invoice_Status-invoice_status" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Invoice_Status-invoice_status"/> + <fieldDescription><![CDATA[Invoice_Status-invoice_status]]></fieldDescription> + </field> + <field name="Is_expired-is_expired" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Is_expired-is_expired"/> + <fieldDescription><![CDATA[Is_expired-is_expired]]></fieldDescription> + </field> + <field name="Is_Follower-message_is_follower" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Is_Follower-message_is_follower"/> + <fieldDescription><![CDATA[Is_Follower-message_is_follower]]></fieldDescription> + </field> + <field name="Last_Message_Date-message_last_post" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Last_Message_Date-message_last_post"/> + <fieldDescription><![CDATA[Last_Message_Date-message_last_post]]></fieldDescription> + </field> + <field name="Action_Needed-message_needaction" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Action_Needed-message_needaction"/> + <fieldDescription><![CDATA[Action_Needed-message_needaction]]></fieldDescription> + </field> + <field name="Number_of_Actions-message_needaction_counter" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Number_of_Actions-message_needaction_counter"/> + <fieldDescription><![CDATA[Number_of_Actions-message_needaction_counter]]></fieldDescription> + </field> + <field name="Unread_Messages-message_unread" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Unread_Messages-message_unread"/> + <fieldDescription><![CDATA[Unread_Messages-message_unread]]></fieldDescription> + </field> + <field name="Unread_Messages_Counter-message_unread_counter" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Unread_Messages_Counter-message_unread_counter"/> + <fieldDescription><![CDATA[Unread_Messages_Counter-message_unread_counter]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Order_Reference-name"/> + <fieldDescription><![CDATA[Order_Reference-name]]></fieldDescription> + </field> + <field name="Terms_and_conditions-note" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Terms_and_conditions-note"/> + <fieldDescription><![CDATA[Terms_and_conditions-note]]></fieldDescription> + </field> + <field name="Source_Document-origin" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Source_Document-origin"/> + <fieldDescription><![CDATA[Source_Document-origin]]></fieldDescription> + </field> + <field name="Portal_Access_URL-portal_url" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Portal_Access_URL-portal_url"/> + <fieldDescription><![CDATA[Portal_Access_URL-portal_url]]></fieldDescription> + </field> + <field name="Status-state" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Status-state"/> + <fieldDescription><![CDATA[Status-state]]></fieldDescription> + </field> + <field name="Expiration_Date-validity_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Expiration_Date-validity_date"/> + <fieldDescription><![CDATA[Expiration_Date-validity_date]]></fieldDescription> + </field> + <field name="Last_Updated_on-write_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Last_Updated_on-write_date"/> + <fieldDescription><![CDATA[Last_Updated_on-write_date]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="79" splitType="Stretch"/> + </title> + <pageHeader> + <band height="35" splitType="Stretch"/> + </pageHeader> + <columnHeader> + <band height="61" splitType="Stretch"/> + </columnHeader> + <detail> + <band height="125" splitType="Stretch"/> + </detail> + <columnFooter> + <band height="45" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/logo-serpents.png b/jasper_reports/custom_reports/logo-serpents.png Binary files differnew file mode 100755 index 0000000..cdc042a --- /dev/null +++ b/jasper_reports/custom_reports/logo-serpents.png diff --git a/jasper_reports/custom_reports/sale_order_report.jasper b/jasper_reports/custom_reports/sale_order_report.jasper Binary files differnew file mode 100755 index 0000000..99f5079 --- /dev/null +++ b/jasper_reports/custom_reports/sale_order_report.jasper diff --git a/jasper_reports/custom_reports/sale_order_report.jrxml b/jasper_reports/custom_reports/sale_order_report.jrxml new file mode 100755 index 0000000..d1a66ba --- /dev/null +++ b/jasper_reports/custom_reports/sale_order_report.jrxml @@ -0,0 +1,194 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 3.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="sale_order_report" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <property name="OPENERP_RELATIONS" value="['order_line']"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Jasper Quotation XML"/> + <property name="com.jaspersoft.studio.unit." value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> + <queryString language="xPath"> + <![CDATA[data/record]]> + </queryString> + <field name="Date-date_order" class="java.lang.String"> + <fieldDescription><![CDATA[Date-date_order]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Reference-name]]></fieldDescription> + </field> + <field name="Name-display_name" class="java.lang.String"> + <fieldDescription><![CDATA[Customer-partner_id/Name-display_name]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Lines-order_line/Product-product_id/Name-name]]></fieldDescription> + </field> + <field name="Unit_Price-price_unit" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Lines-order_line/Unit_Price-price_unit]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <fieldDescription><![CDATA[Total-amount_total]]></fieldDescription> + </field> + <field name="Quantity-product_uom_qty" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Lines-order_line/Quantity-product_uom_qty]]></fieldDescription> + </field> + <field name="Subtotal-price_subtotal" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Lines-order_line/Subtotal-price_subtotal]]></fieldDescription> + </field> + <field name="Reference-code" class="java.lang.String"> + <fieldDescription><![CDATA[Order_Lines-order_line/Product-product_id/Reference-code]]></fieldDescription> + </field> + <sortField name="Order_Reference-name" order="Ascending"/> + <title> + <band height="72"> + <staticText> + <reportElement x="317" y="22" width="168" height="29"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="18" isBold="true"/> + </textElement> + <text><![CDATA[Sale Order Lines]]></text> + </staticText> + <textField pattern="dd/MM/yyyy"> + <reportElement x="702" y="0" width="100" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"/> + <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> + </textField> + <image> + <reportElement x="1" y="1" width="135" height="47"/> + <imageExpression class="java.lang.String">"logo-serpents.png"</imageExpression> + </image> + </band> + </title> + <columnHeader> + <band height="39"> + <staticText> + <reportElement x="305" y="12" width="77" height="20"/> + <textElement lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Product]]></text> + </staticText> + <staticText> + <reportElement x="629" y="12" width="50" height="20"/> + <textElement textAlignment="Right" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Price]]></text> + </staticText> + <staticText> + <reportElement x="721" y="12" width="81" height="20"/> + <textElement textAlignment="Right" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Subtotal]]></text> + </staticText> + <staticText> + <reportElement x="543" y="12" width="37" height="20"/> + <textElement textAlignment="Right" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Qty.]]></text> + </staticText> + <line> + <reportElement x="-2" y="38" width="803" height="1"/> + </line> + <staticText> + <reportElement x="1" y="12" width="49" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Order ]]></text> + </staticText> + <staticText> + <reportElement x="81" y="12" width="82" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Customer]]></text> + </staticText> + <staticText> + <reportElement x="191" y="12" width="95" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="15" isBold="true"/> + </textElement> + <text><![CDATA[Order Date]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="21"> + <textField> + <reportElement x="610" y="1" width="69" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Right" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Unit_Price-price_unit}.equals("Unit_Price-price_unit") ? "" : String.format("%.2f", Float.parseFloat($F{Unit_Price-price_unit}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="721" y="1" width="81" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Right" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Subtotal-price_subtotal}.equals("Subtotal-price_subtotal") ? "" : String.format("%.2f", Float.parseFloat($F{Subtotal-price_subtotal}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="1" y="1" width="59" height="20"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f43ece14-7e87-473b-a295-cf6a53a90848"/> + </reportElement> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Order_Reference-name}.equals("Order_Reference-name") ? "" : $F{Order_Reference-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="540" y="1" width="55" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Center" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Quantity-product_uom_qty}.equals("Quantity-product_uom_qty") ? "" : String.format("%.2f", Float.parseFloat($F{Quantity-product_uom_qty}))]]></textFieldExpression> + </textField> + <textField> + <reportElement x="305" y="1" width="234" height="20" isRemoveLineWhenBlank="true"/> + <textElement textAlignment="Left" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-name}.equals("Name-name") ? "" : $F{Reference-code}.equals('') ? $F{Name-name} : "["+$F{Reference-code}+"] "+$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="80" y="1" width="92" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Name-display_name}.equals("Name-display_name") ? "" : $F{Name-display_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="191" y="0" width="94" height="20"/> + <textElement verticalAlignment="Middle" lineSpacing="Single"> + <font size="13"/> + </textElement> + <textFieldExpression class="java.lang.String"><![CDATA[$F{Date-date_order}.equals("Date-date_order") ? "" : new SimpleDateFormat("dd/MM/yyyy").format(new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse($F{Date-date_order}))]]></textFieldExpression> + </textField> + </band> + </detail> + <pageFooter> + <band height="58"> + <textField> + <reportElement x="680" y="19" width="80" height="20"/> + <textElement textAlignment="Right" lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> + </textField> + <textField evaluationTime="Report"> + <reportElement x="760" y="19" width="40" height="20"/> + <textElement lineSpacing="Single"/> + <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + </band> + </pageFooter> +</jasperReport> diff --git a/jasper_reports/custom_reports/sale_order_template.jrxml b/jasper_reports/custom_reports/sale_order_template.jrxml new file mode 100755 index 0000000..757266c --- /dev/null +++ b/jasper_reports/custom_reports/sale_order_template.jrxml @@ -0,0 +1,119 @@ +<?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="sale_order_template" pageWidth="612" pageHeight="792" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Jasper Sale Order Template"/> + <queryString language="xPath"> + <![CDATA[/data/record]]> + </queryString> + <field name="id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="id"/> + <fieldDescription><![CDATA[id]]></fieldDescription> + </field> + <field name="Taxes-amount_tax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Taxes-amount_tax"/> + <fieldDescription><![CDATA[Taxes-amount_tax]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Total-amount_total"/> + <fieldDescription><![CDATA[Total-amount_total]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Untaxed_Amount-amount_untaxed"/> + <fieldDescription><![CDATA[Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Customer_Reference-client_order_ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Customer_Reference-client_order_ref"/> + <fieldDescription><![CDATA[Customer_Reference-client_order_ref]]></fieldDescription> + </field> + <field name="Confirmation_Date-confirmation_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Confirmation_Date-confirmation_date"/> + <fieldDescription><![CDATA[Confirmation_Date-confirmation_date]]></fieldDescription> + </field> + <field name="Creation_Date-create_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Creation_Date-create_date"/> + <fieldDescription><![CDATA[Creation_Date-create_date]]></fieldDescription> + </field> + <field name="Order_Date-date_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Order_Date-date_order"/> + <fieldDescription><![CDATA[Order_Date-date_order]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Display_Name-display_name"/> + <fieldDescription><![CDATA[Display_Name-display_name]]></fieldDescription> + </field> + <field name="Invoice_Status-invoice_status" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Invoice_Status-invoice_status"/> + <fieldDescription><![CDATA[Invoice_Status-invoice_status]]></fieldDescription> + </field> + <field name="Status-state" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Status-state"/> + <fieldDescription><![CDATA[Status-state]]></fieldDescription> + </field> + <field name="Expiration_Date-validity_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Expiration_Date-validity_date"/> + <fieldDescription><![CDATA[Expiration_Date-validity_date]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <fieldDescription><![CDATA[Name-name]]></fieldDescription> + </field> + <field name="Related_Partner-partner_id" class="java.lang.String"> + <fieldDescription><![CDATA[Related_Partner-partner_id]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="79" splitType="Stretch"> + <staticText> + <reportElement x="206" y="29" width="161" height="20"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14" isBold="true" isUnderline="true"/> + </textElement> + <text><![CDATA[Sale Order Report]]></text> + </staticText> + <textField pattern="MMMMM dd, yyyy"> + <reportElement x="470" y="10" width="101" height="21"/> + <textFieldExpression><![CDATA[new java.util.Date()]]></textFieldExpression> + </textField> + </band> + </title> + <detail> + <band height="125" splitType="Stretch"> + <textField> + <reportElement x="80" y="10" width="100" height="30"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7c53c044-d815-4f7d-818e-c13a9a61dc11"/> + </reportElement> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="10" width="90" height="30"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Order :]]></text> + </staticText> + <staticText> + <reportElement x="340" y="10" width="100" height="30"/> + <textElement verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Customer :]]></text> + </staticText> + <textField> + <reportElement x="440" y="10" width="100" height="30"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Related_Partner-partner_id}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="45" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/sub_report.jrxml b/jasper_reports/custom_reports/sub_report.jrxml new file mode 100755 index 0000000..e27bd36 --- /dev/null +++ b/jasper_reports/custom_reports/sub_report.jrxml @@ -0,0 +1,141 @@ +<?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="sub_report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="com.jaspersoft.studio.data.sql.tables"/> + <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="260"/> + <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="740"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Odoo Jasper"/> + <queryString language="SQL"> + <![CDATA[SELECT public.product_template.name, + public.product_template.sequence, + public.sale_order.name, + public.sale_order.date_order, + public.sale_order.confirmation_date, + public.sale_order.amount_total, + public.res_partner.name, + public.res_partner.street, + public.res_partner.street2, + public.res_partner.zip, + public.res_partner.city, + public.sale_order_line.price_unit, + public.sale_order_line.price_subtotal, + public.sale_order_line.price_tax, + public.sale_order_line.price_total, + public.sale_order_line.price_reduce, + public.sale_order_line.discount +FROM public.product_template, + public.res_partner + INNER JOIN public.sale_order ON + public.sale_order.partner_id = public.res_partner.id + INNER JOIN public.sale_order_line ON + public.sale_order_line.order_id = public.sale_order.id LIMIT 1]]> + </queryString> + <field name="name" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="name"/> + </field> + <field name="sequence" class="java.lang.Integer"> + <property name="com.jaspersoft.studio.field.label" value="sequence"/> + </field> + <field name="COLUMN_3" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="name"/> + </field> + <field name="date_order" class="java.sql.Timestamp"> + <property name="com.jaspersoft.studio.field.label" value="date_order"/> + </field> + <field name="confirmation_date" class="java.sql.Timestamp"> + <property name="com.jaspersoft.studio.field.label" value="confirmation_date"/> + </field> + <field name="amount_total" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="amount_total"/> + </field> + <field name="COLUMN_7" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="name"/> + </field> + <field name="street" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="street"/> + </field> + <field name="street2" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="street2"/> + </field> + <field name="zip" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="zip"/> + </field> + <field name="city" class="java.lang.String"> + <property name="com.jaspersoft.studio.field.label" value="city"/> + </field> + <field name="price_unit" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="price_unit"/> + </field> + <field name="price_subtotal" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="price_subtotal"/> + </field> + <field name="price_tax" class="java.lang.Double"> + <property name="com.jaspersoft.studio.field.label" value="price_tax"/> + </field> + <field name="price_total" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="price_total"/> + </field> + <field name="price_reduce" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="price_reduce"/> + </field> + <field name="discount" class="java.math.BigDecimal"> + <property name="com.jaspersoft.studio.field.label" value="discount"/> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="79" splitType="Stretch"> + <staticText> + <reportElement x="200" y="26" width="154" height="26"/> + <textElement textAlignment="Center" verticalAlignment="Top"> + <font size="16"/> + </textElement> + <text><![CDATA[Sale Order Report]]></text> + </staticText> + </band> + </title> + <detail> + <band height="327" splitType="Stretch"> + <staticText> + <reportElement x="0" y="20" width="90" height="21"/> + <textElement textAlignment="Center"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[Customer :]]></text> + </staticText> + <textField> + <reportElement x="100" y="20" width="120" height="21"/> + <textElement textAlignment="Left"> + <font size="14"/> + </textElement> + <textFieldExpression><![CDATA[$F{COLUMN_7}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="100" y="41" width="120" height="19"/> + <textElement> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{street}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="100" y="60" width="120" height="20"/> + <textFieldExpression><![CDATA[$F{city}]]></textFieldExpression> + </textField> + <subreport> + <reportElement x="0" y="110" width="550" height="200"/> + <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> + <subreportExpression><![CDATA["Blank_Letter_Landscape.jasper"]]></subreportExpression> + </subreport> + </band> + </detail> + <columnFooter> + <band height="45" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/user.jasper b/jasper_reports/custom_reports/user.jasper Binary files differnew file mode 100755 index 0000000..cf74789 --- /dev/null +++ b/jasper_reports/custom_reports/user.jasper diff --git a/jasper_reports/custom_reports/user.jrxml b/jasper_reports/custom_reports/user.jrxml new file mode 100755 index 0000000..d003429 --- /dev/null +++ b/jasper_reports/custom_reports/user.jrxml @@ -0,0 +1,119 @@ +<?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="report1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="48"/> + <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> + <style name="table 1"> + <box> + <pen lineWidth="1.0" lineColor="#000000"/> + </box> + </style> + <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + </box> + <conditionalStyle> + <conditionExpression><![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]></conditionExpression> + <style backcolor="#EFF7FF"/> + </conditionalStyle> + </style> + <subDataset name="Table Dataset 1" /> + <subDataset name="Table Dataset 2" /> + <queryString> + <![CDATA[select p.name, u.login from res_partner p, res_users u where p.id= u.partner_id]]> + </queryString> + <field name="name" class="java.lang.String"/> + <field name="login" class="java.lang.String"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="79" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="555" height="79" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="30" isBold="true"/> + </textElement> + <text><![CDATA[User Report]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="35" splitType="Stretch"/> + </pageHeader> + <columnHeader> + <band height="41" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="372" height="41" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="26" isBold="true"/> + </textElement> + <text><![CDATA[User Name]]></text> + </staticText> + <staticText> + <reportElement x="372" y="0" width="183" height="41" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="24" isBold="true"/> + </textElement> + <text><![CDATA[Login]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="27" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="372" height="25" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="15"/> + </textElement> + <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="372" y="0" width="183" height="25" /> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="15"/> + </textElement> + <textFieldExpression><![CDATA[$F{login}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="45" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> |
