diff options
Diffstat (limited to 'jasper_reports/custom_reports/Customer Comision.jrxml')
| -rw-r--r-- | jasper_reports/custom_reports/Customer Comision.jrxml | 289 |
1 files changed, 289 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/Customer Comision.jrxml b/jasper_reports/custom_reports/Customer Comision.jrxml new file mode 100644 index 0000000..820a595 --- /dev/null +++ b/jasper_reports/custom_reports/Customer Comision.jrxml @@ -0,0 +1,289 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.20.5.final using JasperReports Library version 6.20.5-3efcf2e67f959db3888d79f73dde2dbd7acb4f8e --> +<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="Customer Comision" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="267dd142-45c8-4e58-bdae-72f60761b287"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Customer Comision"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['commision_lines']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Document No" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_No-number"/> + <fieldDescription><![CDATA[/data/record/Document_No-number]]></fieldDescription> + </field> + <field name="Partner Name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_ids/Name-name"/> + <fieldDescription><![CDATA[/data/record/Partner-partner_ids/Name-name]]></fieldDescription> + </field> + <field name="Partner Name Line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Customer-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Customer-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Invoice Name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name"/> + <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name]]></fieldDescription> + </field> + <field name="DPP" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/DPP-dpp"/> + <fieldDescription><![CDATA[/data/record/Lines-commision_lines/DPP-dpp]]></fieldDescription> + </field> + <field name="Total Margin" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Total_Margin-total_percent_margin"/> + <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Total_Margin-total_percent_margin]]></fieldDescription> + </field> + <field name="Status Invoice" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/InvStatus-state"/> + <fieldDescription><![CDATA[/data/record/Lines-commision_lines/InvStatus-state]]></fieldDescription> + </field> + <field name="Date From" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_From-date_from"/> + <fieldDescription><![CDATA[/data/record/Date_From-date_from]]></fieldDescription> + </field> + <field name="Date To" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_To-date_to"/> + <fieldDescription><![CDATA[/data/record/Date_To-date_to]]></fieldDescription> + </field> + <field name="Total DPP" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total_DPP-total_dpp"/> + <fieldDescription><![CDATA[/data/record/Total_DPP-total_dpp]]></fieldDescription> + </field> + <field name="Commision Amount" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/> + <fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription> + </field> + <field name="Commision %" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision__-commision_percent"/> + <fieldDescription><![CDATA[/data/record/Commision__-commision_percent]]></fieldDescription> + </field> + <variable name="DPP" class="java.math.BigDecimal" incrementType="Column"> + <variableExpression><![CDATA[$F{DPP}]]></variableExpression> + </variable> + <variable name="Total_Margin" class="java.math.BigDecimal" incrementType="Column"> + <variableExpression><![CDATA[$F{Total Margin}]]></variableExpression> + </variable> + <variable name="Commision_%" class="java.math.BigDecimal" incrementType="Column"> + <variableExpression><![CDATA[$F{Commision %}]]></variableExpression> + </variable> + <variable name="Commision_Amount" class="java.math.BigDecimal" incrementType="Column"> + <variableExpression><![CDATA[$F{Commision Amount}]]></variableExpression> + </variable> + <variable name="Total DPP" class="java.math.BigDecimal" incrementType="Column"> + <variableExpression><![CDATA[$F{Total DPP}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="204" splitType="Stretch"> + <textField> + <reportElement x="151" y="0" width="253" height="50" uuid="ad497d39-25aa-4e99-888a-6e3221d070e4"/> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="1" y="55" width="100" height="30" uuid="3e8e85ed-c77c-4377-80b4-f8817995f545"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Partner Name ]]></text> + </staticText> + <textField> + <reportElement x="105" y="55" width="455" height="30" uuid="d859b5fd-d805-4c86-a1c7-617fa72a3a25"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Partner Name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="1" y="90" width="100" height="30" uuid="850d8de0-d90d-4d7b-a6cf-c7279c1d49da"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Date From ]]></text> + </staticText> + <staticText> + <reportElement x="360" y="91" width="66" height="30" uuid="5f75f83a-e4bf-441d-94dd-4bb0a6b98ef6"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Date To]]></text> + </staticText> + <staticText> + <reportElement x="1" y="127" width="100" height="30" uuid="ee030619-4aa4-4c1b-bf18-94b8a4b77578"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Commision % ]]></text> + </staticText> + <staticText> + <reportElement x="0" y="167" width="100" height="30" uuid="9a60a3ae-72dc-4a06-84be-3ecf879bc7be"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Commision Amount ]]></text> + </staticText> + <staticText> + <reportElement x="360" y="164" width="66" height="30" uuid="e1c94634-0398-4d98-843e-8e2a3286b427"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Total DPP ]]></text> + </staticText> + <textField pattern="MMMM d, yyyy"> + <reportElement x="105" y="90" width="100" height="30" uuid="7b9631c0-b30e-4e5d-9061-768bfe786b8d"/> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Date From}]]></textFieldExpression> + </textField> + <textField pattern="MMMM d, yyyy"> + <reportElement x="430" y="91" width="100" height="30" uuid="f066682f-eabd-477e-8895-8455f49d2579"/> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Date To}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="430" y="164" width="124" height="30" uuid="6983367e-a6f1-409f-be98-3cfa7f6f77b3"/> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Total DPP}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="105" y="162" width="164" height="30" uuid="8c626b25-555a-4681-b491-0ab1d0321cde"/> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[ $F{Commision Amount}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="105" y="127" width="100" height="30" uuid="e2ebe3a4-f126-440b-b057-96126ad5098e"/> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Commision %} + " %"]]></textFieldExpression> + </textField> + </band> + </title> + <columnHeader> + <band height="30" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="156" height="30" uuid="17571371-537e-4cb7-a11c-db822e33e074"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Customer]]></text> + </staticText> + <staticText> + <reportElement x="156" y="0" width="160" height="30" uuid="2adc8d84-e0bd-4ce2-bc82-9b80178a78e6"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Invoice]]></text> + </staticText> + <staticText> + <reportElement x="316" y="0" width="64" height="30" uuid="4bde0bed-2421-4557-a45f-5a665f2ba080"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Status Invoice]]></text> + </staticText> + <staticText> + <reportElement x="380" y="0" width="75" height="30" uuid="9a00a7e1-900b-4d6b-bdeb-3b7f0f7e6a5d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="70d6c4bd-60d2-4606-b48b-2c2f9e15ff92"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[DPP]]></text> + </staticText> + <staticText> + <reportElement x="455" y="0" width="100" height="30" uuid="f4a50d94-89b5-4f23-818d-fadcc0f34092"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0917b22c-3856-447c-ac45-689148535ef7"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Total Margin]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="43" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="156" height="42" uuid="20886f7d-e695-42f4-8274-7e7424c74a6f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Partner Name Line}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="156" y="0" width="160" height="42" uuid="1153f0c3-8080-4f61-8fb7-21d743546826"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Invoice Name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="316" y="0" width="64" height="42" uuid="c702275c-c708-4f27-9f81-fb40ccaefa7f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/> + </reportElement> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Status Invoice}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="380" y="0" width="75" height="42" uuid="f55b5f39-7f6e-4d42-8cfb-bdb990b4991e"/> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{DPP}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="455" y="0" width="100" height="42" uuid="fb2ba136-db4c-4c37-ab43-9616acf30398"/> + <box> + <bottomPen lineWidth="0.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{Total_Margin}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="75" splitType="Stretch"/> + </summary> +</jasperReport> |