diff options
Diffstat (limited to 'jasper_reports/custom_reports/logbook_bill.jrxml')
| -rw-r--r-- | jasper_reports/custom_reports/logbook_bill.jrxml | 272 |
1 files changed, 272 insertions, 0 deletions
diff --git a/jasper_reports/custom_reports/logbook_bill.jrxml b/jasper_reports/custom_reports/logbook_bill.jrxml new file mode 100644 index 0000000..b44fddf --- /dev/null +++ b/jasper_reports/custom_reports/logbook_bill.jrxml @@ -0,0 +1,272 @@ +<?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="logbook_bill" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bb91654d-75e6-4fa7-bd9d-f8a2fe7bb26f"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="LogbookBill.jrdax"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['report_logbook_bill_line']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Name-name"/> + <fieldDescription><![CDATA[/data/record/Name-name]]></fieldDescription> + </field> + <field name="Created_on-create_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_on-create_date"/> + <fieldDescription><![CDATA[/data/record/Created_on-create_date]]></fieldDescription> + </field> + <field name="Created_By-created_by" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_By-created_by"/> + <fieldDescription><![CDATA[/data/record/Created_By-created_by]]></fieldDescription> + </field> + <field name="Customer-partner_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Customer-partner_id"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Customer-partner_id]]></fieldDescription> + </field> + <field name="Name-name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Name-name"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Name-name]]></fieldDescription> + </field> + <field name="Purchase_Order-purchase_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Purchase_Order-purchase_id"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Purchase_Order-purchase_id]]></fieldDescription> + </field> + <field name="Invoice-invoice" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Invoice-invoice"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Invoice-invoice]]></fieldDescription> + </field> + <field name="SJ-surat_jalan" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/SJ-surat_jalan"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/SJ-surat_jalan]]></fieldDescription> + </field> + <field name="FP-faktur_pajak" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/FP-faktur_pajak"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/FP-faktur_pajak]]></fieldDescription> + </field> + <field name="Proforma_Inv-proforma_invoice" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Proforma_Inv-proforma_invoice"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Proforma_Inv-proforma_invoice]]></fieldDescription> + </field> + <field name="Grand_Total-grand_total" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Grand_Total-grand_total"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Grand_Total-grand_total]]></fieldDescription> + </field> + <field name="Name-name_2" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_Bill_Line-report_logbook_bill_line/Customer-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Logbook_Bill_Line-report_logbook_bill_line/Customer-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Name-name_3" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_by-create_uid/Name-name"/> + <fieldDescription><![CDATA[/data/record/Created_by-create_uid/Name-name]]></fieldDescription> + </field> + <variable name="Variable_1" class="java.lang.String"/> + <variable name="GrandTotal" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Grand_Total-grand_total}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="80" splitType="Stretch"> + <staticText> + <reportElement x="157" y="0" width="240" height="30" uuid="c8d922c5-8549-4d1e-9eaf-55bdd95a7bc8"/> + <textElement textAlignment="Center"> + <font size="20" isBold="false"/> + </textElement> + <text><![CDATA[Logbook Bill]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="83" splitType="Stretch"> + <staticText> + <reportElement x="300" y="8" width="114" height="30" uuid="3737b682-6c24-468b-83f6-55aaed60eaf8"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Date Created :]]></text> + </staticText> + <staticText> + <reportElement x="1" y="45" width="119" height="30" uuid="2facfd86-bd77-459f-9398-a2009fdd41ad"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Document No:]]></text> + </staticText> + <staticText> + <reportElement x="300" y="43" width="114" height="30" uuid="2fde90cb-267d-431d-bbc5-74ac70406f74"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Created by:]]></text> + </staticText> + <textField> + <reportElement x="120" y="45" width="100" height="30" uuid="38c7b054-04b6-472d-9840-d5405b6a16de"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="414" y="14" width="134" height="30" uuid="27fc6f4a-0fdb-493c-9af5-656d6bcbd271"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Created_on-create_date}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="414" y="45" width="134" height="30" uuid="529278fd-dd7f-499d-b9c6-dc86509e5048"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Name-name_3}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="30" splitType="Stretch"> + <staticText> + <reportElement x="372" y="0" width="69" height="30" uuid="aa551ae4-7353-462b-be86-bd09cb8bd2f9"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[Proforma Invoice]]></text> + </staticText> + <staticText> + <reportElement x="294" y="0" width="78" height="30" uuid="ddb1e02d-a3af-4475-a413-2800f8b3c2fc"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[FP]]></text> + </staticText> + <staticText> + <reportElement x="5" y="0" width="93" height="30" uuid="da05e9ee-b6c7-4ff9-b224-548b41d39531"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[Customer]]></text> + </staticText> + <staticText> + <reportElement x="234" y="0" width="60" height="30" uuid="448fbc37-e5ba-43b4-ba01-1aa52d43fb9e"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[SJ]]></text> + </staticText> + <staticText> + <reportElement x="192" y="0" width="42" height="30" uuid="58c33d7f-0b27-4e3d-89c7-8a115d128479"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[Invoice]]></text> + </staticText> + <staticText> + <reportElement x="98" y="0" width="94" height="30" uuid="0c90d84f-28ff-45ac-9087-52f15249c64b"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[No Picking]]></text> + </staticText> + <staticText> + <reportElement x="441" y="0" width="110" height="30" uuid="5decd7e6-6934-4d70-8a38-18f3920c9704"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="12"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="31" splitType="Stretch"> + <textField> + <reportElement x="98" y="0" width="94" height="30" uuid="5cce27da-cc43-459e-a5e4-ea50c8e8e369"/> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="192" y="0" width="42" height="30" uuid="6a639950-be89-4ecb-90e2-f4da769c3448"/> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Invoice-invoice}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="234" y="0" width="60" height="30" uuid="0ac47be3-9817-44e5-823a-5dc5abcbc6d8"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="58b81ab4-e53e-4223-878a-8dfcb13a7648"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{SJ-surat_jalan}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="294" y="0" width="78" height="30" uuid="bf9f0814-4745-4dae-ba69-926da53e550f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="672088fc-e3dc-46db-9917-61ef024c037d"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{FP-faktur_pajak}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="372" y="0" width="69" height="30" uuid="8fca63ea-73d5-4ef5-9053-921c52f1e157"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7dae296a-7670-4eca-b1ec-31ed59adff3a"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Proforma_Inv-proforma_invoice}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="5" y="0" width="93" height="30" uuid="f50056df-de43-48c8-a58c-3d45052643cb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7c8a3a09-8c39-42a5-9512-cafcc6f0bd62"/> + </reportElement> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Name-name_2}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="441" y="0" width="110" height="30" uuid="39c074e1-d098-4bc4-8d8b-e0939438bba9"/> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{GrandTotal}]]></textFieldExpression> + </textField> + </band> + </detail> + <columnFooter> + <band height="82" splitType="Stretch"/> + </columnFooter> + <pageFooter> + <band height="54" splitType="Stretch"/> + </pageFooter> + <summary> + <band height="42" splitType="Stretch"/> + </summary> +</jasperReport> |