diff options
| -rwxr-xr-x | jasper_reports/custom_reports/AlamatTempel.jrxml | 114 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/Blank_A4_7.jrxml | 287 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/DeliverySlip_A5_Font_Besar.jrxml | 57 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/DeliverySlip_A5_Nomor_SO.jrxml | 19 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/DunningRun.jrxml | 9 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/Kwitansi.jrxml | 188 | ||||
| -rwxr-xr-x | jasper_reports/custom_reports/PickingList.jrxml | 90 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/ReceivingList.jrxml | 411 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/WMS.jrxml | 476 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/image_sales.jrxml | 395 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/logbook_bill.jrxml | 272 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/logbook_sj.jrxml | 253 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/saleorderimage.jrxml | 609 |
13 files changed, 3094 insertions, 86 deletions
diff --git a/jasper_reports/custom_reports/AlamatTempel.jrxml b/jasper_reports/custom_reports/AlamatTempel.jrxml index 3a34cfd..ae8dec5 100755 --- a/jasper_reports/custom_reports/AlamatTempel.jrxml +++ b/jasper_reports/custom_reports/AlamatTempel.jrxml @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="UTF-8"?> -<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<!-- 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="AlamatTempel" pageWidth="298" pageHeight="420" columnWidth="258" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2e0fdfd1-3a8c-4786-9270-fad3a8435726"> <property name="com.jaspersoft.studio.unit." value="mm"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="mm"/> @@ -10,7 +10,7 @@ <property name="com.jaspersoft.studio.unit.rightMargin" value="mm"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="mm"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="mm"/> - <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Stock Picking"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter12.jrdax"/> <property name="ODOO_RELATIONS"> <![CDATA[['move_lines']]]> </property> @@ -73,77 +73,124 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Display_Name-display_name"/> <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Display_Name-display_name]]></fieldDescription> </field> + <field name="Note_Ekspedisi-note_ekspedisi" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales_Order-sale_id/Note_Ekspedisi-note_ekspedisi"/> + <fieldDescription><![CDATA[/data/record/Sales_Order-sale_id/Note_Ekspedisi-note_ekspedisi]]></fieldDescription> + </field> + <field name="State_Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/State-state_id/State_Name-name"/> + <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/State-state_id/State_Name-name]]></fieldDescription> + </field> + <field name="Address-address" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipping_Method-carrier_id/Address-address"/> + <fieldDescription><![CDATA[/data/record/Shipping_Method-carrier_id/Address-address]]></fieldDescription> + </field> + <field name="PIC_Phone-pic_phone" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipping_Method-carrier_id/PIC_Phone-pic_phone"/> + <fieldDescription><![CDATA[/data/record/Shipping_Method-carrier_id/PIC_Phone-pic_phone]]></fieldDescription> + </field> + <field name="City-city" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/City-city"/> + <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/City-city]]></fieldDescription> + </field> + <field name="Kecamatan-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Kecamatan-kecamatan_id/Kecamatan-name"/> + <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Kecamatan-kecamatan_id/Kecamatan-name]]></fieldDescription> + </field> + <field name="Kelurahan-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Kelurahan-kelurahan_id/Kelurahan-name"/> + <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Kelurahan-kelurahan_id/Kelurahan-name]]></fieldDescription> + </field> + <field name="Kota_Kab-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Kota_Kab-kota_id/Kota_Kab-name"/> + <fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Kota_Kab-kota_id/Kota_Kab-name]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales_Order-sale_id/Order_Reference-name"/> + <fieldDescription><![CDATA[/data/record/Sales_Order-sale_id/Order_Reference-name]]></fieldDescription> + </field> + <field name="Shipping_Paid_by-shipping_paid_by" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales_Order-sale_id/Shipping_Paid_by-shipping_paid_by"/> + <fieldDescription><![CDATA[/data/record/Sales_Order-sale_id/Shipping_Paid_by-shipping_paid_by]]></fieldDescription> + </field> <background> <band splitType="Stretch"/> </background> <title> - <band height="50" splitType="Stretch"> + <band height="56" splitType="Stretch"> <image> - <reportElement x="0" y="0" width="140" height="50" uuid="7dea8f16-ea36-4ebb-8665-3dd09535901d"/> + <reportElement x="0" y="0" width="130" height="50" uuid="7dea8f16-ea36-4ebb-8665-3dd09535901d"/> <imageExpression><![CDATA["/odoo14/images/logo_indoteknik_no_color.jpeg"]]></imageExpression> </image> + <textField> + <reportElement x="130" y="0" width="130" height="50" uuid="5710bf1d-91be-4163-81a6-9d7bc0dcc100"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{Order_Reference-name}]]></textFieldExpression> + </textField> </band> </title> <pageHeader> - <band height="186"> + <band height="324"> <staticText> - <reportElement x="0" y="0" width="250" height="14" uuid="9d7f7b14-43ea-4492-803f-6badaaa33c7f"/> + <reportElement x="0" y="40" width="250" height="14" uuid="9d7f7b14-43ea-4492-803f-6badaaa33c7f"/> <textElement> <font size="10"/> </textElement> <text><![CDATA[Ekspedisi]]></text> </staticText> <textField> - <reportElement x="0" y="14" width="250" height="14" uuid="a08cdd15-9fab-4743-b1d0-d334986a1201"/> + <reportElement x="0" y="54" width="250" height="14" uuid="a08cdd15-9fab-4743-b1d0-d334986a1201"/> <textElement> <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{Delivery_Method-name}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="28" width="250" height="14" uuid="8705000a-f1e7-4efe-a18a-95ffc955921c"/> + <reportElement x="0" y="110" width="250" height="14" uuid="8705000a-f1e7-4efe-a18a-95ffc955921c"/> <textElement> <font size="10"/> </textElement> <text><![CDATA[Kepada]]></text> </staticText> <textField> - <reportElement x="0" y="42" width="250" height="14" uuid="debdc706-5bc6-4b83-8592-848b6130fbbf"/> + <reportElement x="0" y="124" width="250" height="14" uuid="debdc706-5bc6-4b83-8592-848b6130fbbf"/> <textElement verticalAlignment="Top"> <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{real_display_name}]]></textFieldExpression> </textField> <textField> - <reportElement x="0" y="84" width="250" height="30" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/> + <reportElement x="0" y="166" width="250" height="30" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/> <textElement> <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{real_street_1}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> - <reportElement x="0" y="114" width="250" height="30" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/> + <reportElement x="0" y="196" width="250" height="30" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/> <textElement> <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{real_street_2}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="144" width="250" height="14" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/> + <reportElement x="0" y="279" width="250" height="14" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/> <textElement> <font size="10"/> </textElement> <text><![CDATA[Dari]]></text> </staticText> <staticText> - <reportElement x="0" y="158" width="110" height="14" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/> + <reportElement x="0" y="293" width="110" height="14" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/> <textElement> <font size="10" isBold="true"/> </textElement> <text><![CDATA[INDOTEKNIK.COM]]></text> </staticText> <textField> - <reportElement x="110" y="158" width="140" height="14" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4"> + <reportElement x="110" y="293" width="140" height="14" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> </reportElement> <textElement> @@ -152,14 +199,14 @@ <textFieldExpression><![CDATA[$F{salesperson}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="172" width="110" height="14" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/> + <reportElement x="0" y="307" width="110" height="14" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/> <textElement> <font size="10"/> </textElement> <text><![CDATA[NO HP]]></text> </staticText> <textField> - <reportElement x="110" y="172" width="140" height="14" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2"> + <reportElement x="110" y="307" width="140" height="14" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> </reportElement> <textElement> @@ -168,13 +215,44 @@ <textFieldExpression><![CDATA[$F{salesphone}]]></textFieldExpression> </textField> <textField> - <reportElement x="0" y="56" width="250" height="14" uuid="689389ff-1dae-483a-a1f6-611095c2952c"/> + <reportElement x="0" y="138" width="250" height="14" uuid="689389ff-1dae-483a-a1f6-611095c2952c"/> <textFieldExpression><![CDATA[$F{real_phone}]]></textFieldExpression> </textField> <textField> - <reportElement x="0" y="70" width="250" height="14" uuid="a6a85851-921f-4c09-9b3e-9ae757e296f5"/> + <reportElement x="0" y="152" width="250" height="14" uuid="a6a85851-921f-4c09-9b3e-9ae757e296f5"/> <textFieldExpression><![CDATA[$F{real_mobile}]]></textFieldExpression> </textField> + <textField isBlankWhenNull="true"> + <reportElement x="0" y="68" width="250" height="22" isRemoveLineWhenBlank="true" uuid="9a731c81-aa08-4df8-9fce-994cdc6fdca8"/> + <textFieldExpression><![CDATA[$F{Address-address}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="90" width="250" height="20" uuid="896a5498-f842-4b0f-bd25-fe9e1c12924f"/> + <textFieldExpression><![CDATA[$F{PIC_Phone-pic_phone}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="243" width="250" height="20" isRemoveLineWhenBlank="true" uuid="11a48248-d9d2-4528-95b2-599d97e2171b"/> + <textFieldExpression><![CDATA[$F{Kecamatan-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="263" width="250" height="16" isRemoveLineWhenBlank="true" uuid="1cfa551d-595c-4840-85df-56e96ee0bebd"/> + <textFieldExpression><![CDATA[$F{Kelurahan-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="226" width="250" height="16" uuid="40f44771-cc5f-4664-a677-d5325c495714"/> + <textFieldExpression><![CDATA[$F{State_Name-name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="0" width="250" height="20" uuid="4001034f-f6c2-44ec-b1b1-dcb17ec22c0a"/> + <textElement verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[Shipping Paid By]]></text> + </staticText> + <textField> + <reportElement x="0" y="20" width="250" height="19" uuid="f4c03043-ea29-415d-82bc-05a0888d5daa"/> + <textFieldExpression><![CDATA[$F{Shipping_Paid_by-shipping_paid_by}]]></textFieldExpression> + </textField> </band> </pageHeader> </jasperReport> diff --git a/jasper_reports/custom_reports/Blank_A4_7.jrxml b/jasper_reports/custom_reports/Blank_A4_7.jrxml new file mode 100644 index 0000000..09ecf15 --- /dev/null +++ b/jasper_reports/custom_reports/Blank_A4_7.jrxml @@ -0,0 +1,287 @@ +<?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="Journal_Entries" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="854acef6-eb08-4fac-888a-f2a2ad7ebcbc"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Kwitansi v3.jrdax"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['line_ids']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Number-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Number-name"/> + <fieldDescription><![CDATA[/data/record/Number-name]]></fieldDescription> + </field> + <field name="Reference-ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Reference-ref"/> + <fieldDescription><![CDATA[/data/record/Reference-ref]]></fieldDescription> + </field> + <field name="label_line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Label-name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Label-name]]></fieldDescription> + </field> + <field name="display_name_line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Display_Name-display_name]]></fieldDescription> + </field> + <field name="display_name_partner" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Debit-debit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Debit-debit"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Debit-debit]]></fieldDescription> + </field> + <field name="Credit-credit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Credit-credit"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Credit-credit]]></fieldDescription> + </field> + <field name="Quantity-quantity" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Quantity-quantity"/> + <fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Quantity-quantity]]></fieldDescription> + </field> + <field name="Delivery_Amt-delivery_amt" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sale_Order-sale_id/Delivery_Amt-delivery_amt"/> + <fieldDescription><![CDATA[/data/record/Sale_Order-sale_id/Delivery_Amt-delivery_amt]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sale_Order-sale_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Sale_Order-sale_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Partner-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Invoice_Bill_Date-invoice_date" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_Bill_Date-invoice_date"/> + <fieldDescription><![CDATA[/data/record/Invoice_Bill_Date-invoice_date]]></fieldDescription> + </field> + <field name="Angka_Terbilang-delivery_amt_text" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Angka_Terbilang-delivery_amt_text"/> + <fieldDescription><![CDATA[/data/record/Angka_Terbilang-delivery_amt_text]]></fieldDescription> + </field> + <field name="Display_Name-display_name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Display_Name-display_name]]></fieldDescription> + </field> + <variable name="debit" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Debit-debit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Debit-debit})]]></variableExpression> + </variable> + <variable name="credit" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Credit-credit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Credit-credit})]]></variableExpression> + </variable> + <variable name="qty" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Quantity-quantity}.equals("")?new BigDecimal("0"):new BigDecimal($F{Quantity-quantity})]]></variableExpression> + </variable> + <variable name="total_debit" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$V{debit}]]></variableExpression> + </variable> + <variable name="total_credit" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$V{credit}]]></variableExpression> + </variable> + <variable name="delivery_amt" class="java.math.BigDecimal"> + <variableExpression><![CDATA[new BigDecimal($F{Delivery_Amt-delivery_amt})]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="113" splitType="Stretch"> + <image> + <reportElement x="0" y="0" width="190" height="60" uuid="57a602fc-274e-4c1d-8e4f-36d4381b88fa"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression> + </image> + <staticText> + <reportElement x="210" y="70" width="140" height="40" uuid="7404bdcd-ae14-4d53-ac89-36af6bcf8a3e"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="Serif" size="18" isBold="true" isItalic="false"/> + </textElement> + <text><![CDATA[KWITANSI]]></text> + </staticText> + </band> + </title> + <pageHeader> + <band height="410" splitType="Stretch"> + <line> + <reportElement x="180" y="87" width="380" height="1" uuid="c4a75361-a29a-4b63-b900-dd97b74b220a"/> + </line> + <textField> + <reportElement x="180" y="1" width="380" height="28" uuid="7a0e9624-fd91-40d6-b2cc-a6e7fdc84cc8"/> + <textElement verticalAlignment="Middle"> + <font size="9"/> + </textElement> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="14" y="10" width="166" height="28" uuid="29460d22-5076-452f-ae6e-588f22275d40"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Sudah Terima dari :]]></text> + </staticText> + <line> + <reportElement x="182" y="145" width="378" height="1" uuid="263e02a2-5b63-4067-8b65-ea70dd9502db"/> + </line> + <staticText> + <reportElement x="14" y="61" width="166" height="28" uuid="7504996e-0d31-4c5f-9a7c-4d0b2b701c26"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Uang Sejumlah :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="125" width="166" height="28" uuid="80b106ba-e5ae-48c5-84dd-282adbc7bde1"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Untuk Pembayaran :]]></text> + </staticText> + <line> + <reportElement x="180" y="29" width="380" height="1" uuid="3f15ec94-bf24-4ace-80a1-72038f8c22eb"/> + </line> + <staticText> + <reportElement x="182" y="123" width="108" height="28" uuid="875c18df-a524-4c86-8a28-03fbe3dd4132"/> + <textElement verticalAlignment="Middle"> + <font size="9"/> + </textElement> + <text><![CDATA[Pembayaran ongkos kirim ]]></text> + </staticText> + <staticText> + <reportElement x="1" y="303" width="89" height="20" uuid="8765667a-9833-415d-936a-9da803055d50"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Nama Bank :]]></text> + </staticText> + <staticText> + <reportElement x="1" y="343" width="89" height="20" uuid="345d7b55-2e99-4a95-9472-9ca55718d8bd"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[No. Rek :]]></text> + </staticText> + <image> + <reportElement x="377" y="284" width="164" height="86" uuid="46d5eec4-c361-4d05-894b-86088af219ba"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/1892527"]]></imageExpression> + </image> + <staticText> + <reportElement x="1" y="283" width="89" height="20" uuid="38834e21-0771-45cd-ab97-10aadde353e0"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Nama :]]></text> + </staticText> + <staticText> + <reportElement x="1" y="253" width="179" height="20" uuid="50be2029-0faa-4311-932d-ff2a2419c567"/> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[Pembayaran di transfer ke]]></text> + </staticText> + <staticText> + <reportElement x="360" y="270" width="200" height="20" uuid="c5532814-fa3c-4cd4-a715-e34d4d69b312"/> + <textElement verticalAlignment="Middle"> + <font size="9" isBold="true"/> + </textElement> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text> + </staticText> + <line> + <reportElement x="14" y="213" width="281" height="1" uuid="22709a21-550f-4e8c-abff-755003437c44"/> + </line> + <staticText> + <reportElement x="14" y="188" width="115" height="25" uuid="198eae14-d759-4803-a0a4-14ec8f5b7334"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="11" isBold="true" isItalic="true"/> + </textElement> + <text><![CDATA[Terbilang Rp]]></text> + </staticText> + <staticText> + <reportElement x="1" y="323" width="89" height="20" uuid="f2c37a7f-34f0-481e-84fd-fabbbe4865a8"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Cabang :]]></text> + </staticText> + <staticText> + <reportElement x="90" y="303" width="207" height="20" uuid="608ffbc0-c762-478f-9bfc-d8a39def7579"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[BCA (Bank Central Asia)]]></text> + </staticText> + <staticText> + <reportElement x="90" y="343" width="207" height="20" uuid="c1c65cf0-8a22-4c39-879a-3825e0680f4b"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[8870-4000-81]]></text> + </staticText> + <staticText> + <reportElement x="90" y="323" width="207" height="20" uuid="a1dc89dc-59d9-4a9b-9aa6-ab09efe5b559"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[KCP Puri Botanical Joglo, Jakarta Barat]]></text> + </staticText> + <staticText> + <reportElement x="390" y="364" width="75" height="30" uuid="972d62bb-6fff-4cbf-b546-c08614538132"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[FINANCE]]></text> + </staticText> + <line> + <reportElement x="14" y="188" width="281" height="1" uuid="03bab101-596a-49b0-ae27-e046674ef0da"/> + </line> + <staticText> + <reportElement x="90" y="283" width="207" height="20" uuid="44f622c7-ebcf-463e-8eec-18a7ef9c5295"/> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text> + </staticText> + <textField pattern="MMMM d, yyyy"> + <reportElement x="387" y="239" width="173" height="30" uuid="0b661ed2-786a-4f33-a324-28b16444491e"/> + <textElement verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{Invoice_Bill_Date-invoice_date}]]></textFieldExpression> + </textField> + <textField pattern="#,#00.00#;(#,#00.00#-)"> + <reportElement x="131" y="189" width="166" height="25" uuid="d8c1109f-b815-45b6-83b7-28e6cf385cae"/> + <textElement verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{Delivery_Amt-delivery_amt}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="351" y="245" width="36" height="30" uuid="94d0106e-d04c-4205-b1bf-4d497abcfa6f"/> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="false"/> + </textElement> + <text><![CDATA[Jakarta,]]></text> + </staticText> + <staticText> + <reportElement x="0" y="390" width="560" height="20" uuid="21e8b5cb-2227-4346-8699-1864c476d6fe"/> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="true" isItalic="true"/> + </textElement> + <text><![CDATA[Kwitansi ini dianggap sah apabila pembayaran giro/cek tersebut sudah dicairkan.]]></text> + </staticText> + <textField> + <reportElement x="180" y="60" width="380" height="27" uuid="ff36a107-5e17-4922-a4a5-eef96b08058d"/> + <textElement verticalAlignment="Middle"> + <font size="9"/> + </textElement> + <textFieldExpression><![CDATA[$F{Angka_Terbilang-delivery_amt_text}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="290" y="116" width="271" height="30" uuid="9a40b512-7d93-4679-9592-749ca68d4150"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="9"/> + </textElement> + <textFieldExpression><![CDATA[$F{Display_Name-display_name_1}]]></textFieldExpression> + </textField> + </band> + </pageHeader> +</jasperReport> diff --git a/jasper_reports/custom_reports/DeliverySlip_A5_Font_Besar.jrxml b/jasper_reports/custom_reports/DeliverySlip_A5_Font_Besar.jrxml index 43a14db..8dcbeaa 100644 --- a/jasper_reports/custom_reports/DeliverySlip_A5_Font_Besar.jrxml +++ b/jasper_reports/custom_reports/DeliverySlip_A5_Font_Besar.jrxml @@ -1,10 +1,10 @@ <?xml version="1.0" encoding="UTF-8"?> -<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<!-- 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="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="ODOO_RELATIONS"> <![CDATA[['move_line_ids_without_package']]]> </property> - <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Stock Picking"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="transfer.jrdax"/> <queryString language="xPath"> <![CDATA[/data/record/]]> </queryString> @@ -76,6 +76,14 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim"/> <fieldDescription><![CDATA[/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim]]></fieldDescription> </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Stock_Moves-move_lines/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Stock_Moves-move_lines/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Display_Name-display_name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> <variable name="Jumlah_Barang" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[$F{product_name}]]></variableExpression> </variable> @@ -233,7 +241,7 @@ <text><![CDATA[No]]></text> </staticText> <staticText> - <reportElement x="20" y="0" width="400" height="10" uuid="bd07fa03-7433-44af-a2f1-f7a33a75217b"> + <reportElement x="20" y="0" width="417" height="10" uuid="bd07fa03-7433-44af-a2f1-f7a33a75217b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2cb61511-dfd0-4a31-8e17-8d0abb141bf1"/> </reportElement> <box> @@ -245,7 +253,7 @@ <text><![CDATA[Product]]></text> </staticText> <staticText> - <reportElement x="420" y="0" width="60" height="10" uuid="2ed28f46-ba65-41a0-a9c9-a07c887d2d83"> + <reportElement x="437" y="0" width="43" height="10" uuid="2ed28f46-ba65-41a0-a9c9-a07c887d2d83"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1b4ef0cd-e036-41aa-8f13-5493a4ae0ad6"/> </reportElement> <box> @@ -268,29 +276,35 @@ </textElement> <text><![CDATA[UOM]]></text> </staticText> + <staticText> + <reportElement x="150" y="0" width="158" height="10" uuid="4cffedac-3c73-459e-a8ab-68c0fa872d1a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0bcc99a3-cc54-4be1-b167-2b4ac273b8d5"/> + </reportElement> + <text><![CDATA[Display_Name-display_name]]></text> + </staticText> + <staticText> + <reportElement x="79" y="0" width="107" height="10" uuid="6b159e6a-b6b2-403a-97bb-755e9bb7852d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fb6d9389-8b2d-4dc5-88ed-eb7ef23d32f4"/> + </reportElement> + <text><![CDATA[Display_Name-display_name_1]]></text> + </staticText> </band> </columnHeader> <detail> - <band height="20" splitType="Stretch"> + <band height="25" splitType="Stretch"> <textField> - <reportElement x="0" y="0" width="20" height="18" uuid="9bdcb204-03f7-456a-a1e1-35a3dcd6cb1e"/> + <reportElement x="0" y="0" width="20" height="25" uuid="9bdcb204-03f7-456a-a1e1-35a3dcd6cb1e"> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> <textElement verticalAlignment="Middle"> <font size="10"/> </textElement> <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> </textField> - <textField> - <reportElement x="20" y="0" width="400" height="18" uuid="82de5c54-26c3-423f-a520-ac8734e90bff"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b0313fae-0979-4224-a72e-d94057ff0702"/> - </reportElement> - <textElement textAlignment="Left" verticalAlignment="Middle"> - <font size="10"/> - </textElement> - <textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression> - </textField> <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> - <reportElement x="420" y="0" width="60" height="18" uuid="9b6f58bd-145d-4835-bb03-319d3ffd4c0a"> + <reportElement x="437" y="0" width="43" height="25" uuid="9b6f58bd-145d-4835-bb03-319d3ffd4c0a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b7c7a4c-8485-4025-b48d-b29fb2cdb6e7"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> </reportElement> <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="10"/> @@ -298,7 +312,7 @@ <textFieldExpression><![CDATA[$F{Done-qty_done}]]></textFieldExpression> </textField> <textField> - <reportElement x="480" y="0" width="75" height="18" uuid="17178369-02cc-47e2-9239-25ce8a290275"> + <reportElement x="480" y="0" width="75" height="25" uuid="17178369-02cc-47e2-9239-25ce8a290275"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="909ea2e8-ff60-44b3-a812-e77fa8643cda"/> </reportElement> <textElement textAlignment="Right" verticalAlignment="Middle"> @@ -306,6 +320,14 @@ </textElement> <textFieldExpression><![CDATA[$F{uom_name}]]></textFieldExpression> </textField> + <textField> + <reportElement x="20" y="0" width="417" height="25" uuid="4c9f0d43-8d40-476f-94e9-d63ec9bca238"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fb6d9389-8b2d-4dc5-88ed-eb7ef23d32f4"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Display_Name-display_name_1}]]></textFieldExpression> + </textField> </band> </detail> <pageFooter> @@ -342,6 +364,7 @@ <reportElement x="0" y="0" width="99" 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"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> <printWhenExpression><![CDATA[$V{REPORT_COUNT}==12]]></printWhenExpression> </reportElement> </break> diff --git a/jasper_reports/custom_reports/DeliverySlip_A5_Nomor_SO.jrxml b/jasper_reports/custom_reports/DeliverySlip_A5_Nomor_SO.jrxml index a7a285e..84c02de 100644 --- a/jasper_reports/custom_reports/DeliverySlip_A5_Nomor_SO.jrxml +++ b/jasper_reports/custom_reports/DeliverySlip_A5_Nomor_SO.jrxml @@ -1,10 +1,10 @@ <?xml version="1.0" encoding="UTF-8"?> -<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<!-- 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="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="Stock Picking"/> <property name="ODOO_RELATIONS"> <![CDATA[['move_line_ids_without_package']]]> </property> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="transfer.jrdax"/> <queryString language="xPath"> <![CDATA[/data/record/]]> </queryString> @@ -80,6 +80,10 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim"/> <fieldDescription><![CDATA[/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim]]></fieldDescription> </field> + <field name="Notes-note" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Notes-note"/> + <fieldDescription><![CDATA[/data/record/Notes-note]]></fieldDescription> + </field> <variable name="Jumlah_Barang" class="java.lang.Integer" calculation="Count"> <variableExpression><![CDATA[$F{product_name}]]></variableExpression> </variable> @@ -110,7 +114,7 @@ </staticText> <image scaleImage="FillFrame"> <reportElement x="355" y="0" width="200" height="19" uuid="c1fd4c13-d80d-44ba-82c7-e10435c3931c"/> - <imageExpression><![CDATA["https://erp.indoteknik.com/report/barcode/?type=EAN13&value="+$F{Picking_Code-picking_code}+"&width=800&height=40"]]></imageExpression> + <imageExpression><![CDATA["https://erp.indoteknik.com/report/barcode/?type=Code128&value="+$F{Picking_Code-picking_code}+"&width=800&height=40"]]></imageExpression> </image> <textField> <reportElement x="355" y="24" width="200" height="10" uuid="87b21b3f-a965-467b-a390-09387ff4c2bf"/> @@ -369,7 +373,7 @@ </band> </pageFooter> <summary> - <band height="50" splitType="Stretch"> + <band height="100" splitType="Stretch"> <textField> <reportElement x="260" y="0" width="80" height="12" uuid="f08b4b72-4323-4532-9791-8ff8aa2df593"/> <textElement textAlignment="Right" verticalAlignment="Bottom"> @@ -454,6 +458,13 @@ <pen lineWidth="0.5"/> </graphicElement> </line> + <textField isBlankWhenNull="true"> + <reportElement x="-1" y="70" width="557" height="30" uuid="a3cf58a5-f3c8-489f-b126-1788de799698"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Notes-note}]]></textFieldExpression> + </textField> </band> </summary> </jasperReport> diff --git a/jasper_reports/custom_reports/DunningRun.jrxml b/jasper_reports/custom_reports/DunningRun.jrxml index ef06695..2869c62 100644 --- a/jasper_reports/custom_reports/DunningRun.jrxml +++ b/jasper_reports/custom_reports/DunningRun.jrxml @@ -56,6 +56,7 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Dunning_Lines-dunning_line/Total_Amount-total_amt"/> <fieldDescription><![CDATA[/data/record/Dunning_Lines-dunning_line/Total_Amount-total_amt]]></fieldDescription> </field> + <sortField name="invoice_number"/> <variable name="total" class="java.math.BigDecimal"> <variableExpression><![CDATA[new BigDecimal($F{total_amt_line})]]></variableExpression> </variable> @@ -375,10 +376,10 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto <textElement textAlignment="Left" verticalAlignment="Top"> <font size="10"/> </textElement> - <text><![CDATA[Pembayaran melalui Transfer ke :
-
-BCA
-PT. Indoteknik Dotcom Gemilang
+ <text><![CDATA[Pembayaran melalui Transfer ke : + +BCA +PT. Indoteknik Dotcom Gemilang 8870-4000-81]]></text> </staticText> <staticText> diff --git a/jasper_reports/custom_reports/Kwitansi.jrxml b/jasper_reports/custom_reports/Kwitansi.jrxml new file mode 100644 index 0000000..4e1b55a --- /dev/null +++ b/jasper_reports/custom_reports/Kwitansi.jrxml @@ -0,0 +1,188 @@ +<?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="Kwitansi" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="21ae3fda-f56f-4012-bf5c-43c037f724fa"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Invoices"/> + <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[]]> + </queryString> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Partner-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Delivery_Amt-delivery_amt" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sale_Order-sale_id/Delivery_Amt-delivery_amt"/> + <fieldDescription><![CDATA[/data/record/Sale_Order-sale_id/Delivery_Amt-delivery_amt]]></fieldDescription> + </field> + <field name="Invoice_Bill_Date-invoice_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_Bill_Date-invoice_date"/> + <fieldDescription><![CDATA[/data/record/Invoice_Bill_Date-invoice_date]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sale_Order-sale_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Sale_Order-sale_id/Display_Name-display_name]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="125" splitType="Stretch"> + <image> + <reportElement x="0" y="20" width="200" height="60" uuid="d63b17d1-d808-431f-b810-7188901e924e"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression> + </image> + <staticText> + <reportElement x="210" y="80" width="140" height="40" uuid="c7276986-06f4-4cbb-b5b5-48ae8bc309ce"/> + <textElement> + <font fontName="Serif" size="26" isBold="true" isItalic="false"/> + </textElement> + <text><![CDATA[KWITANSI]]></text> + </staticText> + </band> + </title> + <columnHeader> + <band height="401"> + <staticText> + <reportElement x="14" y="20" width="217" height="28" uuid="dec9a6ac-7cab-49a7-83f8-acd31aba230b"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Sudah Terima dari :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="71" width="217" height="28" uuid="9893fbc4-d549-4844-9e33-fa7e648c7895"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Uang Sejumlah :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="135" width="217" height="28" uuid="ff8f2495-58c1-4295-b62f-3174746c702a"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Untuk Pembayaran :]]></text> + </staticText> + <line> + <reportElement x="232" y="47" width="301" height="2" uuid="92016380-399d-4c40-927c-9339742fcd5e"/> + </line> + <line> + <reportElement x="14" y="213" width="281" height="1" uuid="e6e6a887-6ef4-4392-a27c-0d5e1f41657f"/> + </line> + <line> + <reportElement x="232" y="98" width="301" height="1" uuid="0d2012ac-ee4a-4d1b-93d1-6ddf19bb2e95"/> + </line> + <line> + <reportElement x="231" y="163" width="299" height="1" uuid="388bae1d-aa30-4c68-83c7-83784cace74d"/> + </line> + <line> + <reportElement x="14" y="188" width="281" height="1" uuid="2a0ef280-5f8b-4038-85bd-9de42daf1f6c"/> + </line> + <staticText> + <reportElement x="14" y="253" width="128" height="20" uuid="dae1c7dd-72f5-4b60-9551-dfdd677c8806"/> + <text><![CDATA[Pembayaran di transfer ke]]></text> + </staticText> + <staticText> + <reportElement x="14" y="283" width="89" height="20" uuid="b161334f-4b54-45db-a9c9-5bdf232682d6"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[Nama :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="303" width="89" height="20" uuid="8c2024c2-f42d-4565-b42d-74bfec57b18b"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[Nama Bank :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="323" width="89" height="20" uuid="983c5209-94bf-41a8-8bec-bc78d5d3c52f"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[Cabang :]]></text> + </staticText> + <staticText> + <reportElement x="14" y="343" width="89" height="20" uuid="1fd51c88-ab45-4cf3-ad81-e56e8d52c169"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[No. Rek :]]></text> + </staticText> + <staticText> + <reportElement x="103" y="283" width="197" height="20" uuid="d342c2dc-db92-487b-9fb7-ae58cdea3cf8"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text> + </staticText> + <staticText> + <reportElement x="103" y="303" width="197" height="20" uuid="51c09302-f7b6-4006-a41e-f62fe5508bb2"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[BCA (Bank Central Asia)]]></text> + </staticText> + <staticText> + <reportElement x="103" y="323" width="197" height="20" uuid="0689673a-25d4-4250-ab85-901babaaac91"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[KCP Puri Botanical Joglo, Jakarta Barat]]></text> + </staticText> + <staticText> + <reportElement x="103" y="343" width="197" height="20" uuid="523419df-bc0e-4623-bffd-048c3f23b8fe"/> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[8870-4000-81]]></text> + </staticText> + <staticText> + <reportElement x="54" y="188" width="75" height="25" uuid="d0880ebd-164f-4f80-a9dd-2b984fdc7e30"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="11" isBold="true" isItalic="true"/> + </textElement> + <text><![CDATA[Terbilang Rp]]></text> + </staticText> + <staticText> + <reportElement x="344" y="350" width="64" height="30" uuid="cc6b3c67-5a75-420c-9a45-a3c58bd5b23f"/> + <textElement verticalAlignment="Middle"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[FINANCE]]></text> + </staticText> + <image> + <reportElement x="357" y="283" width="126" height="59" uuid="cd5e54f1-5df3-4756-96c6-4eeacd58004d"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2011786"]]></imageExpression> + </image> + <staticText> + <reportElement x="344" y="240" width="209" height="20" uuid="f93b838e-0c09-456e-9e1a-28e481eb2e3c"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG]]></text> + </staticText> + <textField> + <reportElement x="231" y="19" width="302" height="28" uuid="9fba6e2e-9afd-4983-8492-ae4209fa051e"/> + <textElement verticalAlignment="Middle"> + <font size="11"/> + </textElement> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="231" y="135" width="133" height="28" uuid="2b7def82-620b-4075-a6f4-b65744e80d06"/> + <textElement verticalAlignment="Middle"> + <font size="11"/> + </textElement> + <text><![CDATA[Pembayaran ongkos kirim ]]></text> + </staticText> + <textField> + <reportElement x="364" y="135" width="167" height="28" uuid="cf9f438e-3c3f-4489-a521-f5476f77470a"/> + <textElement verticalAlignment="Middle"> + <font size="11"/> + </textElement> + <textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="129" y="188" width="170" height="25" uuid="8efe1235-e484-4ab9-9cdd-17066ea4821a"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="11"/> + </textElement> + <textFieldExpression><![CDATA[$F{Delivery_Amt-delivery_amt}]]></textFieldExpression> + </textField> + </band> + </columnHeader> +</jasperReport> diff --git a/jasper_reports/custom_reports/PickingList.jrxml b/jasper_reports/custom_reports/PickingList.jrxml index 6ee9d43..b293872 100755 --- a/jasper_reports/custom_reports/PickingList.jrxml +++ b/jasper_reports/custom_reports/PickingList.jrxml @@ -1,5 +1,5 @@ <?xml version="1.0" encoding="UTF-8"?> -<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<!-- 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="PickingList" pageWidth="420" pageHeight="595" columnWidth="380" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bedb0c09-337a-4903-8dab-ab419030594b"> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> @@ -10,10 +10,10 @@ <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"/> - <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Stock Picking"/> <property name="ODOO_RELATIONS"> <![CDATA[['move_ids_without_package']]]> </property> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="StockPicking.jrdax"/> <queryString language="XPath"> <![CDATA[/data/record]]> </queryString> @@ -61,10 +61,6 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Inventory_Availability-inventory_availability"/> <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Inventory_Availability-inventory_availability]]></fieldDescription> </field> - <field name="Quantity_On_Hand-qty_available" class="java.math.BigDecimal"> - <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Quantity_On_Hand-qty_available"/> - <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Quantity_On_Hand-qty_available]]></fieldDescription> - </field> <field name="Full_Location_Name-complete_name" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Full_Location_Name-complete_name"/> <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Full_Location_Name-complete_name]]></fieldDescription> @@ -97,6 +93,14 @@ <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability"/> <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability]]></fieldDescription> </field> + <field name="Qty_Available_Bandengan-qty_available_bandengan" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Qty_Available_Bandengan-qty_available_bandengan"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Qty_Available_Bandengan-qty_available_bandengan]]></fieldDescription> + </field> + <field name="Matches_SO-sale_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Matches_SO-sale_order"/> + <fieldDescription><![CDATA[Matches_SO-sale_order]]></fieldDescription> + </field> <variable name="SumQty" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{Demand-product_uom_qty}]]></variableExpression> </variable> @@ -120,11 +124,17 @@ ? "Waiting Another Operation" : $F{status_state}]]></initialValueExpression> </variable> + <variable name="qty_reserved" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{qty_reserved}]]></variableExpression> + </variable> + <variable name="onhand" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Qty_Available_Bandengan-qty_available_bandengan}]]></variableExpression> + </variable> <background> <band splitType="Stretch"/> </background> <title> - <band height="40" splitType="Stretch"> + <band height="42" splitType="Stretch"> <image> <reportElement x="0" y="0" width="140" height="40" uuid="c561d629-3c19-4c9b-a958-80bcc05cc33b"/> <imageExpression><![CDATA["/odoo14/images/logo_indoteknik_no_color.jpeg"]]></imageExpression> @@ -132,7 +142,7 @@ </band> </title> <pageHeader> - <band height="84" splitType="Stretch"> + <band height="71" splitType="Stretch"> <textField> <reportElement x="200" y="0" width="180" height="30" uuid="70b70e92-fd37-4045-a6e9-0efe5b553dbb"/> <textElement verticalAlignment="Middle"/> @@ -227,7 +237,7 @@ <columnHeader> <band height="20" splitType="Stretch"> <staticText> - <reportElement x="30" y="0" width="170" height="20" forecolor="#080278" uuid="0e9068bc-1d75-4802-8d3c-67586c1c8b94"> + <reportElement x="30" y="0" width="158" height="20" forecolor="#080278" uuid="0e9068bc-1d75-4802-8d3c-67586c1c8b94"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb0f2359-ee11-48ca-96cd-d0df561f9bcc"/> </reportElement> <box> @@ -237,7 +247,7 @@ <text><![CDATA[Kode & Nama Barang]]></text> </staticText> <staticText> - <reportElement x="200" y="0" width="60" height="20" forecolor="#080278" uuid="04ecff5f-cf8d-4dfd-8de7-7a4429e36150"> + <reportElement x="260" y="0" width="79" height="20" forecolor="#080278" uuid="04ecff5f-cf8d-4dfd-8de7-7a4429e36150"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> @@ -257,47 +267,47 @@ <text><![CDATA[No]]></text> </staticText> <staticText> - <reportElement x="260" y="0" width="40" height="20" forecolor="#080278" uuid="01234b47-d045-4dae-9e89-14fffc44167b"> + <reportElement x="340" y="0" width="40" height="20" forecolor="#080278" uuid="6313f349-e253-441a-88d9-b919b6b12889"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> <bottomPen lineWidth="0.25"/> </box> - <textElement textAlignment="Center" verticalAlignment="Middle"> + <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> - <text><![CDATA[Reserve]]></text> + <text><![CDATA[Source]]></text> </staticText> <staticText> - <reportElement x="300" y="0" width="40" height="20" forecolor="#080278" uuid="d0b948cf-ab6e-4b73-9b75-2093ecbb3a44"> + <reportElement x="188" y="0" width="40" height="20" forecolor="#080278" uuid="a57dbc06-8d58-470a-8321-a14161ad091c"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> <bottomPen lineWidth="0.25"/> </box> - <textElement textAlignment="Center" verticalAlignment="Middle"> + <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> - <text><![CDATA[OnHand]]></text> + <text><![CDATA[Reserved]]></text> </staticText> <staticText> - <reportElement x="340" y="0" width="40" height="20" forecolor="#080278" uuid="6313f349-e253-441a-88d9-b919b6b12889"> + <reportElement x="228" y="0" width="32" height="20" forecolor="#080278" uuid="a17e4705-efb6-4b37-9d92-83801627ea1b"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> <bottomPen lineWidth="0.25"/> </box> - <textElement textAlignment="Right" verticalAlignment="Middle"> + <textElement textAlignment="Left" verticalAlignment="Middle"> <font size="8"/> </textElement> - <text><![CDATA[Source]]></text> + <text><![CDATA[Onhand]]></text> </staticText> </band> </columnHeader> <detail> - <band height="22" splitType="Stretch"> + <band height="37" splitType="Stretch"> <textField> - <reportElement x="30" y="0" width="170" height="20" uuid="a71f43a7-9234-4311-b2b5-cad4e125d3a7"> + <reportElement x="30" y="0" width="158" height="37" uuid="a71f43a7-9234-4311-b2b5-cad4e125d3a7"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb0f2359-ee11-48ca-96cd-d0df561f9bcc"/> </reportElement> <box> @@ -312,7 +322,7 @@ <textFieldExpression><![CDATA[$F{ProductDisplay_Name-display_name}]]></textFieldExpression> </textField> <textField pattern="#,##0.###;(#,##0.###-)"> - <reportElement x="200" y="0" width="30" height="20" uuid="bad07ba5-f6f0-47ff-a0b9-280627d17e6a"> + <reportElement x="260" y="0" width="40" height="37" uuid="bad07ba5-f6f0-47ff-a0b9-280627d17e6a"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> @@ -327,7 +337,7 @@ <textFieldExpression><![CDATA[$F{Demand-product_uom_qty}]]></textFieldExpression> </textField> <textField> - <reportElement x="0" y="0" width="30" height="20" uuid="4ddf826f-d106-4506-bcb2-a4a0968041a0"/> + <reportElement x="0" y="0" width="30" height="37" uuid="4ddf826f-d106-4506-bcb2-a4a0968041a0"/> <box> <topPen lineWidth="0.0"/> <leftPen lineWidth="0.25"/> @@ -337,8 +347,8 @@ <textElement verticalAlignment="Middle"/> <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> </textField> - <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> - <reportElement x="260" y="0" width="40" height="20" uuid="d9ba32c9-c209-4960-9d61-e3037383c153"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="300" y="0" width="40" height="37" uuid="3f804d35-b770-4dcf-87c7-e59777dd8fe8"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> @@ -350,10 +360,10 @@ <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> - <textFieldExpression><![CDATA[$F{qty_reserved}]]></textFieldExpression> + <textFieldExpression><![CDATA[$F{uom_name}]]></textFieldExpression> </textField> - <textField pattern="#,##0.###;(#,##0.###-)"> - <reportElement x="230" y="0" width="30" height="20" uuid="3f804d35-b770-4dcf-87c7-e59777dd8fe8"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="340" y="0" width="40" height="37" uuid="cc2740a0-4bc7-426d-b145-9e2b4ffeda60"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> </reportElement> <box> @@ -362,17 +372,14 @@ <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> - <textElement textAlignment="Center" verticalAlignment="Middle"> + <textElement textAlignment="Right" verticalAlignment="Middle"> <font size="8"/> </textElement> - <textFieldExpression><![CDATA[$F{uom_name}]]></textFieldExpression> + <textFieldExpression><![CDATA[$F{location_display_name}]]></textFieldExpression> </textField> - <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> - <reportElement x="300" y="0" width="40" height="20" uuid="29910648-38a8-4d0b-9953-a520245f236d"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> - </reportElement> + <textField> + <reportElement x="188" y="0" width="40" height="37" uuid="65af930d-a36e-41ec-bd80-679268914e41"/> <box> - <topPen lineWidth="0.0"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> @@ -380,22 +387,19 @@ <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> - <textFieldExpression><![CDATA[$F{Quantity_On_Hand-qty_available}]]></textFieldExpression> + <textFieldExpression><![CDATA[$V{qty_reserved}]]></textFieldExpression> </textField> - <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> - <reportElement x="340" y="0" width="40" height="20" uuid="cc2740a0-4bc7-426d-b145-9e2b4ffeda60"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> - </reportElement> + <textField isBlankWhenNull="true"> + <reportElement x="228" y="0" width="32" height="37" uuid="4ba8c35c-af25-49e7-a9c0-b819a0e139d7"/> <box> - <topPen lineWidth="0.0"/> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> - <textElement textAlignment="Right" verticalAlignment="Middle"> + <textElement textAlignment="Center" verticalAlignment="Middle"> <font size="8"/> </textElement> - <textFieldExpression><![CDATA[$F{location_display_name}]]></textFieldExpression> + <textFieldExpression><![CDATA[$V{onhand}]]></textFieldExpression> </textField> </band> </detail> diff --git a/jasper_reports/custom_reports/ReceivingList.jrxml b/jasper_reports/custom_reports/ReceivingList.jrxml new file mode 100644 index 0000000..959e343 --- /dev/null +++ b/jasper_reports/custom_reports/ReceivingList.jrxml @@ -0,0 +1,411 @@ +<?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="PickingList" pageWidth="420" pageHeight="595" columnWidth="380" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bedb0c09-337a-4903-8dab-ab419030594b"> + <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"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['move_ids_without_package']]]> + </property> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="FinalPicking.jrdax"/> + <queryString language="XPath"> + <![CDATA[/data/record]]> + </queryString> + <field name="CustomerName-name" 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="Parent_name-parent_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Contact-partner_id/Parent_name-parent_name"/> + <fieldDescription><![CDATA[Contact-partner_id/Parent_name-parent_name]]></fieldDescription> + </field> + <field name="DocNoReference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Reference-name"/> + <fieldDescription><![CDATA[Reference-name]]></fieldDescription> + </field> + <field name="ProductDisplay_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Real_Quantity-product_qty" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Real_Quantity-product_qty"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Real_Quantity-product_qty]]></fieldDescription> + </field> + <field name="Demand-product_uom_qty" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Demand-product_uom_qty"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Demand-product_uom_qty]]></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="Delivery_Method-name" 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="forecast_qty" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Forecast_Availability-forecast_availability"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Forecast_Availability-forecast_availability]]></fieldDescription> + </field> + <field name="uom_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Unit_of_Measure-product_uom/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Unit_of_Measure-product_uom/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Inventory_Availability-inventory_availability" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Inventory_Availability-inventory_availability"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Inventory_Availability-inventory_availability]]></fieldDescription> + </field> + <field name="Full_Location_Name-complete_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Full_Location_Name-complete_name"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Full_Location_Name-complete_name]]></fieldDescription> + </field> + <field name="location_display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Source_Location-location_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="partner_display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Contact-partner_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[Contact-partner_id/Display_Name-display_name]]></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="scheduled_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Scheduled_Date-scheduled_date"/> + <fieldDescription><![CDATA[Scheduled_Date-scheduled_date]]></fieldDescription> + </field> + <field name="weight" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Weight-weight"/> + <fieldDescription><![CDATA[Weight-weight]]></fieldDescription> + </field> + <field name="weight_uom" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Weight_unit_of_measure_label-weight_uom_name"/> + <fieldDescription><![CDATA[Weight_unit_of_measure_label-weight_uom_name]]></fieldDescription> + </field> + <field name="qty_reserved" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Quantity_Reserved-reserved_availability]]></fieldDescription> + </field> + <field name="Qty_Available_Bandengan-qty_available_bandengan" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Qty_Available_Bandengan-qty_available_bandengan"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/Product-product_id/Qty_Available_Bandengan-qty_available_bandengan]]></fieldDescription> + </field> + <field name="Matches_SO-sale_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Matches_SO-sale_order"/> + <fieldDescription><![CDATA[Matches_SO-sale_order]]></fieldDescription> + </field> + <field name="SO_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Stock_moves_not_in_package-move_ids_without_package/SO-sale_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[Stock_moves_not_in_package-move_ids_without_package/SO-sale_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="Reference-name"/> + <fieldDescription><![CDATA[Reference-name]]></fieldDescription> + </field> + <variable name="SumQty" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$F{Demand-product_uom_qty}]]></variableExpression> + </variable> + <variable name="CountQty" class="java.math.BigDecimal" calculation="Count"> + <variableExpression><![CDATA[$F{Demand-product_uom_qty}]]></variableExpression> + </variable> + <variable name="PartnerName" class="java.lang.String"/> + <variable name="status" class="java.lang.String"> + <variableExpression><![CDATA[$F{status_state}.equals("assigned") + ? "Ready" + : $F{status_state}.equals("confirmed") + ? "Waiting" + : $F{status_state}.equals("waiting") + ? "Waiting Another Operation" + : $F{status_state}]]></variableExpression> + <initialValueExpression><![CDATA[$F{status_state}.equals("assigned") + ? "Ready" + : $F{status_state}.equals("confirmed") + ? "Waiting" + : $F{status_state}.equals("waiting") + ? "Waiting Another Operation" + : $F{status_state}]]></initialValueExpression> + </variable> + <variable name="qty_reserved" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{qty_reserved}]]></variableExpression> + </variable> + <variable name="onhand" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Qty_Available_Bandengan-qty_available_bandengan}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="58" splitType="Stretch"> + <image> + <reportElement x="0" y="0" width="140" height="40" uuid="c561d629-3c19-4c9b-a958-80bcc05cc33b"/> + <imageExpression><![CDATA["/odoo14/images/logo_indoteknik_no_color.jpeg"]]></imageExpression> + </image> + <image scaleImage="FillFrame"> + <reportElement x="180" y="9" width="200" height="19" uuid="59dd9078-c8a0-4d42-b45a-1a0dee7b9588"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/report/barcode/?type=Code128&value="+$F{Reference-name}+"&width=800&height=40"]]></imageExpression> + </image> + <textField> + <reportElement x="180" y="29" width="200" height="20" uuid="52588a5b-686f-4bb5-b006-f1cdf9ad1caa"/> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Reference-name}]]></textFieldExpression> + </textField> + </band> + </title> + <pageHeader> + <band height="121" splitType="Stretch"> + <textField> + <reportElement x="200" y="0" width="180" height="30" uuid="70b70e92-fd37-4045-a6e9-0efe5b553dbb"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{partner_display_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="0" width="200" height="30" uuid="609a5eaf-b3b3-4908-997a-b8d9662f0d82"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{DocNoReference-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="50" width="70" height="20" uuid="d6cce15b-c49a-4122-87f7-53b9072f51bc"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Source_Document-origin}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="230" y="50" width="80" height="20" uuid="e7684c20-5edd-4676-a4e4-4817b1d9d3b3"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Delivery_Method-name}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="30" width="70" height="20" uuid="e8098600-d4b9-477f-8268-18ca54de1fa3"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Order:]]></text> + </staticText> + <staticText> + <reportElement x="70" y="30" width="70" height="20" uuid="85096316-3211-4121-867b-a979cc7c3cea"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Status:]]></text> + </staticText> + <staticText> + <reportElement x="140" y="30" width="90" height="20" uuid="fe9aa44d-5d2a-40fb-bfde-6affff2191d9"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Scheduled Date:]]></text> + </staticText> + <staticText> + <reportElement x="230" y="30" width="80" height="20" uuid="705e2324-4836-4580-bb9a-4425094b2800"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Carrier:]]></text> + </staticText> + <staticText> + <reportElement x="310" y="30" width="70" height="20" uuid="2c9d5567-12c6-4e01-a7ea-bbff70ed2af6"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Weight:]]></text> + </staticText> + <textField> + <reportElement x="70" y="50" width="70" height="20" uuid="f861e0f7-8963-41c8-ac95-eafcd97df001"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$V{status}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="140" y="50" width="90" height="20" uuid="487fda54-c965-4a30-8c48-0351ace42750"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{scheduled_date}]]></textFieldExpression> + </textField> + <textField pattern="#00.###;(#00.###-)"> + <reportElement x="310" y="50" width="30" height="20" uuid="9dd6810a-cb0d-40c8-943e-265464c78e8a"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{weight}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="340" y="50" width="40" height="20" uuid="e379fcd9-5f67-4f5e-8009-595bc88252eb"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{weight_uom}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="0" y="80" width="50" height="20" uuid="18ebefa1-c293-42e9-ae97-a2c0a920a962"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Sale Order: ]]></text> + </staticText> + <textField> + <reportElement x="50" y="80" width="330" height="20" uuid="c8dfbe54-d369-4d7f-bafe-9a0b3f7ff0c3"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="9"/> + </textElement> + <textFieldExpression><![CDATA[$F{Matches_SO-sale_order}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="20" splitType="Stretch"> + <staticText> + <reportElement x="30" y="0" width="170" height="20" forecolor="#080278" uuid="0e9068bc-1d75-4802-8d3c-67586c1c8b94"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb0f2359-ee11-48ca-96cd-d0df561f9bcc"/> + </reportElement> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[Kode & Nama Barang]]></text> + </staticText> + <staticText> + <reportElement x="200" y="0" width="140" height="20" forecolor="#080278" uuid="04ecff5f-cf8d-4dfd-8de7-7a4429e36150"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> + </reportElement> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Demand]]></text> + </staticText> + <staticText> + <reportElement x="0" y="0" width="30" height="20" forecolor="#080278" uuid="064a36cd-c552-4792-8552-114d28e6ce4b"/> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement verticalAlignment="Middle"/> + <text><![CDATA[No]]></text> + </staticText> + <staticText> + <reportElement x="340" y="0" width="40" height="20" forecolor="#080278" uuid="6313f349-e253-441a-88d9-b919b6b12889"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> + </reportElement> + <box> + <bottomPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <text><![CDATA[Sale Order]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="37" splitType="Stretch"> + <textField> + <reportElement x="30" y="0" width="170" height="37" uuid="a71f43a7-9234-4311-b2b5-cad4e125d3a7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb0f2359-ee11-48ca-96cd-d0df561f9bcc"/> + </reportElement> + <box> + <topPen lineWidth="0.0"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{ProductDisplay_Name-display_name}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="200" y="0" width="70" height="37" uuid="bad07ba5-f6f0-47ff-a0b9-280627d17e6a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> + </reportElement> + <box> + <topPen lineWidth="0.0"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Demand-product_uom_qty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="0" width="30" height="37" uuid="4ddf826f-d106-4506-bcb2-a4a0968041a0"/> + <box> + <topPen lineWidth="0.0"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="270" y="0" width="70" height="37" uuid="3f804d35-b770-4dcf-87c7-e59777dd8fe8"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> + </reportElement> + <box> + <topPen lineWidth="0.0"/> + <leftPen lineWidth="0.25"/> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{uom_name}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="true"> + <reportElement x="340" y="0" width="40" height="37" uuid="9956b5d7-e4c6-4076-afec-8ddd04e296fb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3386eda0-0d1b-4838-8884-c97004899411"/> + </reportElement> + <box> + <bottomPen lineWidth="0.25"/> + <rightPen lineWidth="0.25"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{SO_name}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="40" splitType="Stretch"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="170" y="0" width="60" height="20" uuid="27e8c52e-5695-4c5a-98c2-686df7b414b7"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{SumQty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="170" y="20" width="60" height="20" uuid="f20eae90-18b1-49db-a91b-7770fea429b2"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{CountQty}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="70" y="0" width="100" height="20" uuid="44400c16-dddb-46a7-90c4-dfdf22b8ce68"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <text><![CDATA[Total Qty]]></text> + </staticText> + <staticText> + <reportElement x="70" y="20" width="100" height="20" uuid="aa643be4-80e1-430c-9a69-cf9fcff7078d"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <text><![CDATA[Jumlah Barang]]></text> + </staticText> + </band> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/WMS.jrxml b/jasper_reports/custom_reports/WMS.jrxml new file mode 100644 index 0000000..f6e94b4 --- /dev/null +++ b/jasper_reports/custom_reports/WMS.jrxml @@ -0,0 +1,476 @@ +<?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="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="ODOO_RELATIONS"> + <![CDATA[['move_line_ids_without_package']]]> + </property> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="transfer.jrdax"/> + <queryString language="xPath"> + <![CDATA[/data/record/]]> + </queryString> + <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/Display_Name-display_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.sql.Date"> + <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="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="Product Name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Stock_Moves-move_lines/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Stock_Moves-move_lines/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Unit_of_Measure-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Stock_Moves-move_lines/Unit_of_Measure-product_uom/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[/data/record/Stock_Moves-move_lines/Unit_of_Measure-product_uom/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Quantity_Done-quantity_done" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Stock_Moves-move_lines/Quantity_Done-quantity_done"/> + <fieldDescription><![CDATA[/data/record/Stock_Moves-move_lines/Quantity_Done-quantity_done]]></fieldDescription> + </field> + <field name="product_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="uom_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/Unit_of_Measure-product_uom_id/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/Unit_of_Measure-product_uom_id/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Done-qty_done" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/Done-qty_done"/> + <fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/Done-qty_done]]></fieldDescription> + </field> + <field name="cust_reference" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Procurement_Group-group_id/Sale_Order-sale_id/Customer_Reference-client_order_ref"/> + <fieldDescription><![CDATA[/data/record/Procurement_Group-group_id/Sale_Order-sale_id/Customer_Reference-client_order_ref]]></fieldDescription> + </field> + <field name="No-line_no" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/No-line_no"/> + <fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/No-line_no]]></fieldDescription> + </field> + <field name="scheduledDate" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Scheduled_Date-scheduled_date"/> + <fieldDescription><![CDATA[/data/record/Scheduled_Date-scheduled_date]]></fieldDescription> + </field> + <field name="tglkirim" class="java.sql.Date"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim"/> + <fieldDescription><![CDATA[/data/record/Tanggal_Kirim_di_SJ-date_doc_kirim]]></fieldDescription> + </field> + <field name="Notes-note" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Notes-note"/> + <fieldDescription><![CDATA[/data/record/Notes-note]]></fieldDescription> + </field> + <field name="Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Reference-name"/> + <fieldDescription><![CDATA[/data/record/Reference-name]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Display_Name-display_name]]></fieldDescription> + </field> + <variable name="Jumlah_Barang" class="java.lang.Integer" calculation="Count"> + <variableExpression><![CDATA[$F{product_name}]]></variableExpression> + </variable> + <variable name="Total_Qty" class="java.math.BigDecimal" calculation="Sum"> + <variableExpression><![CDATA[$F{Done-qty_done}]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="42" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="180" height="19" uuid="e5b47894-822c-470d-b8ef-1d32cdb8fdd8"/> + <textElement markup="none"> + <font size="9" isBold="true"/> + </textElement> + <text><![CDATA[PT Indoteknik Dotcom Gemilang]]></text> + </staticText> + <staticText> + <reportElement x="231" y="0" width="100" height="18" uuid="27e03116-dfa6-4f71-af4b-94238bfe6db8"> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement textAlignment="Center" markup="none"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[WMS]]></text> + </staticText> + <image scaleImage="FillFrame"> + <reportElement x="355" y="0" width="200" height="19" uuid="c1fd4c13-d80d-44ba-82c7-e10435c3931c"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/report/barcode/?type=Code128&value="+$F{Reference-name}+"&width=800&height=40"]]></imageExpression> + </image> + <textField> + <reportElement x="355" y="20" width="200" height="20" uuid="501084eb-84e6-46a3-ac49-c48e0bbb5156"/> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Reference-name}]]></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="280" 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="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[No Order]]></text> + </staticText> + <staticText> + <reportElement x="280" y="20" width="100" height="10" uuid="1f3941da-bda3-4650-8ceb-697ae43be3c7"/> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Reference]]></text> + </staticText> + <staticText> + <reportElement x="280" y="30" width="100" height="10" uuid="94652b05-841f-4150-99cc-a8adec5be297"/> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Ekspedisi]]></text> + </staticText> + <textField> + <reportElement x="390" y="0" width="165" height="10" uuid="0aadd48d-abbe-49bb-b460-9d52e7ae4780"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{SONo}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="390" y="10" width="165" height="10" uuid="326e9ee0-8924-40c6-b4f7-145a2496f6a5"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{DONo}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="390" y="30" width="165" height="10" uuid="2f7ff77b-bef5-4092-9ad3-6e955359fa08"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Ekspedisi}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="280" y="40" width="100" height="10" uuid="a228c42e-26c8-4023-a7f7-fa19f5b94cab"/> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[Tanggal]]></text> + </staticText> + <textField> + <reportElement x="390" y="40" width="165" height="10" uuid="2eed016f-218a-4880-8e70-2c6dbfd41a35"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{tglkirim}]]></textFieldExpression> + <patternExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{tglkirim})]]></patternExpression> + </textField> + <textField> + <reportElement x="390" y="20" width="165" height="10" uuid="86208a54-fbe9-4a01-a22b-1faacb4538f0"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{cust_reference}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="280" y="10" width="100" height="10" uuid="2e97f076-f6b8-4915-86d3-f79641dc83ad"/> + <textElement textAlignment="Right"> + <font size="8"/> + </textElement> + <text><![CDATA[No DO]]></text> + </staticText> + </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="50" y="0" width="370" 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> + <staticText> + <reportElement x="20" y="0" width="30" height="10" uuid="6fb93c09-5e46-496e-a13d-d8797833206d"/> + <box> + <bottomPen lineWidth="0.5"/> + </box> + <textElement> + <font size="8"/> + </textElement> + <text><![CDATA[SO No]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="23" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="20" height="18" uuid="9bdcb204-03f7-456a-a1e1-35a3dcd6cb1e"/> + <textElement verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="50" y="0" width="370" height="18" uuid="82de5c54-26c3-423f-a520-ac8734e90bff"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b0313fae-0979-4224-a72e-d94057ff0702"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{product_name}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="420" y="0" width="60" height="18" uuid="9b6f58bd-145d-4835-bb03-319d3ffd4c0a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6b7c7a4c-8485-4025-b48d-b29fb2cdb6e7"/> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{Done-qty_done}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="480" y="0" width="75" height="18" uuid="17178369-02cc-47e2-9239-25ce8a290275"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="909ea2e8-ff60-44b3-a812-e77fa8643cda"/> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{uom_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="20" y="0" width="30" height="18" uuid="a5033c13-2efb-4c52-91d9-bad1f3223218"/> + <textElement verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <textFieldExpression><![CDATA[$F{No-line_no}]]></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> + <break> + <reportElement x="0" y="0" width="99" 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}==12]]></printWhenExpression> + </reportElement> + </break> + </band> + </pageFooter> + <summary> + <band height="100" 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> + <textField isBlankWhenNull="true"> + <reportElement x="-1" y="70" width="557" height="30" uuid="a3cf58a5-f3c8-489f-b126-1788de799698"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Notes-note}]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> diff --git a/jasper_reports/custom_reports/image_sales.jrxml b/jasper_reports/custom_reports/image_sales.jrxml new file mode 100644 index 0000000..97c173d --- /dev/null +++ b/jasper_reports/custom_reports/image_sales.jrxml @@ -0,0 +1,395 @@ +<?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="image_sales" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1bd9cf3f-928c-4633-a593-8a875697661c"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="sale order line.jrdax"/> + <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"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['order_id']]]> + </property> + <property name="net.sf.jasperreports.data.adapter" value="sale order line.jrdax"/> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Product_Image-image_small" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product_Image-image_small"/> + <fieldDescription><![CDATA[/data/record/Product_Image-image_small]]></fieldDescription> + </field> + <field name="Salesperson-user_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Salesperson-user_id"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Salesperson-user_id]]></fieldDescription> + </field> + <field name="Expiration-validity_date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Expiration-validity_date"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Expiration-validity_date]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Total-amount_total"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Total-amount_total]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Untaxed_Amount-amount_untaxed"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Order_Reference-name"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Order_Reference-name]]></fieldDescription> + </field> + <field name="Order_Date-date_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Order_Date-date_order"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Order_Date-date_order]]></fieldDescription> + </field> + <field name="Product-product_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id"/> + <fieldDescription><![CDATA[/data/record/Product-product_id]]></fieldDescription> + </field> + <field name="Internal_Reference-default_code" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Internal_Reference-default_code"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Internal_Reference-default_code]]></fieldDescription> + </field> + <field name="Description-description" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Description-description"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Description-description]]></fieldDescription> + </field> + <field name="Image-image_1920" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Image-image_1920"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Image-image_1920]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Name-name]]></fieldDescription> + </field> + <field name="Name-x_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name]]></fieldDescription> + </field> + <field name="Unit_of_Measure-product_uom" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Unit_of_Measure-product_uom"/> + <fieldDescription><![CDATA[/data/record/Unit_of_Measure-product_uom]]></fieldDescription> + </field> + <field name="Quantity-product_uom_qty" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Quantity-product_uom_qty"/> + <fieldDescription><![CDATA[/data/record/Quantity-product_uom_qty]]></fieldDescription> + </field> + <field name="Unit_Price-price_unit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Unit_Price-price_unit"/> + <fieldDescription><![CDATA[/data/record/Unit_Price-price_unit]]></fieldDescription> + </field> + <field name="Subtotal-price_subtotal" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Subtotal-price_subtotal"/> + <fieldDescription><![CDATA[/data/record/Subtotal-price_subtotal]]></fieldDescription> + </field> + <field name="Customer-partner_id" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Customer-partner_id"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Customer-partner_id]]></fieldDescription> + </field> + <field name="Street-street" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Customer-partner_id/Street-street"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Customer-partner_id/Street-street]]></fieldDescription> + </field> + <field name="Taxes-amount_tax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-order_id/Taxes-amount_tax"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-order_id/Taxes-amount_tax]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="94" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="270" height="70" uuid="3afafdd6-db9d-41e4-8b61-90ecf8ee3264"/> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG +Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16 +Penjaringan, Kec. Penjaringan, Jakarta +JK 14440 +Indonesia]]></text> + </staticText> + </band> + </title> + <columnHeader> + <band height="21" splitType="Stretch"> + <staticText> + <reportElement x="-10" y="0" width="80" height="20" uuid="85291110-2c03-45bd-a61b-ff89f9e608bb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Item Code dan Type]]></text> + </staticText> + <staticText> + <reportElement x="70" y="0" width="40" height="20" uuid="eb16d31e-fd57-4b0f-b0a7-a27a818991c1"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Brand]]></text> + </staticText> + <staticText> + <reportElement x="110" y="0" width="140" height="20" uuid="fb3aa397-7ae6-46ab-a849-c1efc7cba9c2"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Nama Product dan Spesifikasi]]></text> + </staticText> + <staticText> + <reportElement x="250" y="0" width="40" height="20" uuid="e044b327-ff1c-49cf-9521-8c908354b5a7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Qty Total]]></text> + </staticText> + <staticText> + <reportElement x="360" y="0" width="30" height="20" uuid="ff90e926-55d0-4905-b948-6ea13eacebf8"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[UOM]]></text> + </staticText> + <staticText> + <reportElement x="290" y="0" width="70" height="20" uuid="fe41858a-8fc0-4b44-9877-1565eb97ad1e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Harga]]></text> + </staticText> + <staticText> + <reportElement x="390" y="0" width="70" height="20" uuid="991f5dba-e858-4b95-99fc-384e32d32d6a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="460" y="0" width="100" height="20" uuid="89428b2e-b9ec-469d-9b67-b01ae5e8ea8e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Gambar]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="34" splitType="Stretch"> + <textField> + <reportElement x="-10" y="-1" width="80" height="35" uuid="57fc9731-ecbf-4c0d-b121-f0d1657dfe86"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="da3a8241-5139-428d-8169-83cbe68e4e76"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Internal_Reference-default_code}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="70" y="-2" width="40" height="36" uuid="de12649b-c028-4e8e-8ad1-478d8d5bad2f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="7dc815ef-27fa-4ef0-8e7b-44ef038a97fd"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Name-x_name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="110" y="-1" width="70" height="35" uuid="d5dfa8cf-0ca8-4e36-b11f-1608da13afda"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a0baa39b-ccb8-4b0c-a392-562319adf5dc"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="-1" width="70" height="35" uuid="7c0b9224-bc25-486f-8194-1db3f205d11e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="6fd8c0b1-2caa-458c-b624-2f93d4f1e08e"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Description-description}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="250" y="-1" width="40" height="35" uuid="187c79a0-8647-42b7-aaa6-a91709ae1201"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="eb77f130-c776-4a15-bad1-85a5f18b3d50"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Quantity-product_uom_qty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="290" y="-2" width="70" height="36" uuid="39cc2b53-6ba5-407e-bb37-1295ded950cd"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="62bfc8db-90fc-4863-8efb-3d27060abe7a"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Unit_Price-price_unit}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="360" y="-1" width="30" height="35" uuid="e8b0a651-f658-443e-87f8-efc73e25fa3e"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="422fd1dd-889c-4149-948b-5cb9d039f738"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Unit_of_Measure-product_uom}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="390" y="-1" width="70" height="35" uuid="4491a289-7077-4e16-a635-9cb2f1d4584a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="32401692-e12a-4897-996b-a3cf8420c4f4"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Subtotal-price_subtotal}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="460" y="-1" width="100" height="35" uuid="98ada646-de4e-41c7-8689-c55c3d51d5c0"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e0177552-280e-42c7-8636-4bf1853f3c6d"/> + </reportElement> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Product_Image-image_small}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="97" splitType="Stretch"> + <textField> + <reportElement x="240" y="60" width="40" height="20" uuid="a20bb2b6-244c-47fa-958b-604aeef6ccbc"/> + <textElement textAlignment="Right"/> + <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField evaluationTime="Report"> + <reportElement x="280" y="60" width="40" height="20" uuid="e90f84c4-3e7d-4c83-a6db-ed743b57248f"/> + <textElement textAlignment="Left"/> + <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="460" y="0" width="100" height="20" uuid="a03b8e0b-5646-4bea-acfe-4682b6ef2cb7"/> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Untaxed_Amount-amount_untaxed}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="390" y="0" width="70" height="20" uuid="0aa43a52-9384-4e6f-9836-87590758658f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Subtotal]]></text> + </staticText> + <textField> + <reportElement x="460" y="20" width="100" height="20" uuid="53dd52e5-2fc2-404e-a8a2-f7335838c051"/> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Taxes-amount_tax}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="390" y="20" width="70" height="20" uuid="8197540a-690b-48bf-a386-da6045a8999d"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Taxes]]></text> + </staticText> + <staticText> + <reportElement x="390" y="40" width="70" height="20" uuid="2289c0ab-fb41-46ca-a14a-bd83350e45f7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> + <pen lineWidth="0.5" lineStyle="Solid"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="false"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <textField> + <reportElement x="460" y="40" width="100" height="20" uuid="035a6928-2485-4d5e-be45-5fd627991217"/> + <box> + <pen lineWidth="0.5" lineStyle="Solid"/> + </box> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{Total-amount_total}]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> 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> diff --git a/jasper_reports/custom_reports/logbook_sj.jrxml b/jasper_reports/custom_reports/logbook_sj.jrxml new file mode 100644 index 0000000..9cf38e4 --- /dev/null +++ b/jasper_reports/custom_reports/logbook_sj.jrxml @@ -0,0 +1,253 @@ +<?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_sj" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6d86dab4-0040-4ba1-be1d-8bc305baaca3"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="DataAdapter9.jrdax"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['report_logbook_sj_line']]]> + </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/Name-name"/> + <fieldDescription><![CDATA[/data/record/Name-name]]></fieldDescription> + </field> + <field name="Created By" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Created_By-created_by/Name-name"/> + <fieldDescription><![CDATA[/data/record/Created_By-created_by/Name-name]]></fieldDescription> + </field> + <field name="Date Created" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Created-date"/> + <fieldDescription><![CDATA[/data/record/Date_Created-date]]></fieldDescription> + </field> + <field name="Customer" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Customer-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Customer-partner_id/Name-name]]></fieldDescription> + </field> + <field name="SO" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Sale_Order-sale_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Sale_Order-sale_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Tracking No" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Tracking_No-tracking_no"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Tracking_No-tracking_no]]></fieldDescription> + </field> + <field name="PO" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Picking-picking_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Picking-picking_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Driver" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Driver-driver_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Driver-driver_id/Name-name]]></fieldDescription> + </field> + <field name="Shipping Method" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Shipping_Method-carrier_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Shipping_Method-carrier_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Deparutre Date" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Logbook_SJ_Line-report_logbook_sj_line/Departure_Date-departure_date"/> + <fieldDescription><![CDATA[/data/record/Logbook_SJ_Line-report_logbook_sj_line/Departure_Date-departure_date]]></fieldDescription> + </field> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="70" splitType="Stretch"/> + </title> + <pageHeader> + <band height="80" splitType="Stretch"> + <staticText> + <reportElement x="160" y="-68" width="240" height="30" uuid="f68656b8-e6f8-4587-ad95-af8ffecadcfe"/> + <textElement textAlignment="Center"> + <font size="20" isBold="false"/> + </textElement> + <text><![CDATA[Logbook Surat Jalan]]></text> + </staticText> + <staticText> + <reportElement x="1" y="45" width="99" height="30" uuid="48cb313c-49b4-499c-a53b-ecbb9083b616"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Document No:]]></text> + </staticText> + <textField> + <reportElement x="101" y="45" width="188" height="30" uuid="c1498c69-9b75-40aa-98f2-953a61f33d84"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="380" y="45" width="94" height="30" uuid="3dbc2633-e5b9-407d-b8dd-61d2eec65ce3"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Created by:]]></text> + </staticText> + <textField> + <reportElement x="474" y="45" width="100" height="30" uuid="2ef64d01-19a1-43fd-a673-ac6594a9aa22"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <textFieldExpression><![CDATA[$F{Created By}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="380" y="10" width="94" height="30" uuid="4ed24f17-5682-4888-a4fb-a99a459c0ad1"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <text><![CDATA[Date Created :]]></text> + </staticText> + <textField> + <reportElement x="474" y="10" width="100" height="30" uuid="fe01b41b-0d62-4099-8a7b-0ef3112cd9a8"/> + <textElement verticalAlignment="Middle"> + <font size="14"/> + </textElement> + <textFieldExpression><![CDATA[$F{Date Created}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="30" splitType="Stretch"> + <staticText> + <reportElement x="1" y="0" width="90" height="30" uuid="c9c16b5f-0562-494d-bab7-d0e78ab8cdb7"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[Customer]]></text> + </staticText> + <staticText> + <reportElement x="92" y="0" width="90" height="30" uuid="e9a6b68f-a462-4e5a-b3f5-c4f5102820fa"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[No Picking]]></text> + </staticText> + <staticText> + <reportElement x="182" y="0" width="90" height="30" uuid="acd8a5fc-92b6-411c-909d-13f37dfb1efe"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[No SO]]></text> + </staticText> + <staticText> + <reportElement x="273" y="0" width="90" height="30" uuid="cfbb56e7-92c7-4c14-acd0-b6e21aed682b"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[Driver]]></text> + </staticText> + <staticText> + <reportElement x="363" y="0" width="90" height="30" uuid="2e566559-f915-4dd7-b092-8a3bf382120d"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[Shipping Method]]></text> + </staticText> + <staticText> + <reportElement x="453" y="0" width="92" height="30" uuid="6d462229-750c-492f-a7d5-358097e8355a"/> + <box> + <pen lineWidth="1.0"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10"/> + </textElement> + <text><![CDATA[Departure Date]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="30" splitType="Stretch"> + <textField> + <reportElement x="1" y="0" width="90" height="30" uuid="b05a45f2-b836-488d-bef7-797cdce16ddf"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a6dc69da-7c59-4895-9302-1da41ffe990b"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Customer}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="91" y="0" width="91" height="30" uuid="1bab2b10-cbff-46d8-aead-2fe0604fcb5f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="02c28e92-1108-4659-97c1-7a47f06e979e"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{PO}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="182" y="0" width="90" height="30" uuid="90affdf0-a109-4a5d-be7e-1444767d09cd"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="38404627-3374-4b80-bc1c-20fe87aab743"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{SO}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="273" y="0" width="90" height="30" uuid="71463154-d00d-413e-a1a1-e2881d6ef809"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="bfd8dec3-2bc9-4b38-a643-e18724aaf3ed"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Driver}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="363" y="0" width="90" height="30" uuid="6d4b0665-5a7c-474e-b2f8-1acde0e36a06"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="b92bdba1-3992-4940-874a-4159fa47e605"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Shipping Method}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="453" y="0" width="92" height="30" uuid="465e4dce-f36e-4d61-9f26-4b1dea2d1cda"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a1e60b9-75bb-4594-a1b1-13be9ad8219b"/> + </reportElement> + <box> + <topPen lineWidth="0.5"/> + <bottomPen lineWidth="0.5"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Deparutre Date}]]></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/saleorderimage.jrxml b/jasper_reports/custom_reports/saleorderimage.jrxml new file mode 100644 index 0000000..791aedc --- /dev/null +++ b/jasper_reports/custom_reports/saleorderimage.jrxml @@ -0,0 +1,609 @@ +<?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="saleorderimage" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bcb140b6-15b9-47fa-9abe-df16274d5a7c"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="saleorderlokal.jrdax"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['order_line']]]> + </property> + <queryString language="XPath"> + <![CDATA[]]> + </queryString> + <field name="Order_Lines-order_line" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line]]></fieldDescription> + </field> + <field name="Product_Image-image_small" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product_Image-image_small"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product_Image-image_small]]></fieldDescription> + </field> + <field name="Name-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Name-name]]></fieldDescription> + </field> + <field name="Manufactures-x_manufacture" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Manufactures-x_manufacture/Name-x_name"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Manufactures-x_manufacture/Name-x_name]]></fieldDescription> + </field> + <field name="Product_Type-type" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Product_Type-type"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Product_Type-type]]></fieldDescription> + </field> + <field name="Internal_Reference-default_code" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Internal_Reference-default_code"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Internal_Reference-default_code]]></fieldDescription> + </field> + <field name="Quantity-product_uom_qty" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Quantity-product_uom_qty"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Quantity-product_uom_qty]]></fieldDescription> + </field> + <field name="Unit_of_Measure-product_uom" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom]]></fieldDescription> + </field> + <field name="Total-price_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Total-price_total"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Total-price_total]]></fieldDescription> + </field> + <field name="Unit_Price-price_unit" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_Price-price_unit"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_Price-price_unit]]></fieldDescription> + </field> + <field name="Description_for_the_website-website_description" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Description_for_the_website-website_description"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Description_for_the_website-website_description]]></fieldDescription> + </field> + <field name="Total-amount_total" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total-amount_total"/> + <fieldDescription><![CDATA[/data/record/Total-amount_total]]></fieldDescription> + </field> + <field name="Taxes-amount_tax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Taxes-amount_tax"/> + <fieldDescription><![CDATA[/data/record/Taxes-amount_tax]]></fieldDescription> + </field> + <field name="Untaxed_Amount-amount_untaxed" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Untaxed_Amount-amount_untaxed"/> + <fieldDescription><![CDATA[/data/record/Untaxed_Amount-amount_untaxed]]></fieldDescription> + </field> + <field name="Manufacture-x_product_manufacture" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Manufacture-x_product_manufacture"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Manufacture-x_product_manufacture]]></fieldDescription> + </field> + <field name="Order_Reference-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Reference-name"/> + <fieldDescription><![CDATA[/data/record/Order_Reference-name]]></fieldDescription> + </field> + <field name="Name-name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Customer-partner_id/Name-name]]></fieldDescription> + </field> + <field name="Street-street" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Street-street"/> + <fieldDescription><![CDATA[/data/record/Customer-partner_id/Street-street]]></fieldDescription> + </field> + <field name="Customer_Reference-client_order_ref" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer_Reference-client_order_ref"/> + <fieldDescription><![CDATA[/data/record/Customer_Reference-client_order_ref]]></fieldDescription> + </field> + <field name="Name-name_2" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Salesperson-user_id/Name-name"/> + <fieldDescription><![CDATA[/data/record/Salesperson-user_id/Name-name]]></fieldDescription> + </field> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Order_Date-date_order" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Date-date_order"/> + <fieldDescription><![CDATA[/data/record/Order_Date-date_order]]></fieldDescription> + </field> + <field name="Unit_of_Measure-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom/Unit_of_Measure-name"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Unit_of_Measure-product_uom/Unit_of_Measure-name]]></fieldDescription> + </field> + <field name="Name-x_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name"/> + <fieldDescription><![CDATA[/data/record/Product-product_id/Manufactures-x_manufacture/Name-x_name]]></fieldDescription> + </field> + <field name="Subtotal-price_subtotal" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Subtotal-price_subtotal"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Subtotal-price_subtotal]]></fieldDescription> + </field> + <field name="pricewithtax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Price_Reduce_Tax_inc-price_reduce_taxinc]]></fieldDescription> + </field> + <field name="pricewithouttax" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Price_Reduce_Tax_excl-price_reduce_taxexcl]]></fieldDescription> + </field> + <field name="Included_in_Price-price_include" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tax-sales_tax_id/Included_in_Price-price_include"/> + <fieldDescription><![CDATA[/data/record/Tax-sales_tax_id/Included_in_Price-price_include]]></fieldDescription> + </field> + <field name="Display_Name-display_name_1" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Product-product_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Product-product_id/Display_Name-display_name]]></fieldDescription> + </field> + <field name="Description-name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Order_Lines-order_line/Description-name"/> + <fieldDescription><![CDATA[/data/record/Order_Lines-order_line/Description-name]]></fieldDescription> + </field> + <variable name="subtotal" class="java.math.BigDecimal"> + <variableExpression><![CDATA[new BigDecimal($F{Untaxed_Amount-amount_untaxed})]]></variableExpression> + </variable> + <variable name="taxes" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True" + ?$F{Taxes-amount_tax}.equals("")?new BigDecimal("0"):new BigDecimal($F{Taxes-amount_tax}) + :$F{Taxes-amount_tax}.equals("")?new BigDecimal("0"):new BigDecimal($F{Taxes-amount_tax})]]></variableExpression> + </variable> + <variable name="grand_total" class="java.math.BigDecimal"> + <variableExpression><![CDATA[new BigDecimal($F{Total-amount_total})]]></variableExpression> + </variable> + <variable name="price_subtotal" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True" + ?$F{Total-price_total}.equals("")?new BigDecimal("0"):new BigDecimal($F{Total-price_total}) + :$F{Subtotal-price_subtotal}.equals("")?new BigDecimal("0"):new BigDecimal($F{Subtotal-price_subtotal})]]></variableExpression> + </variable> + <variable name="PriceUnit" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True" + ?$F{pricewithtax}.equals("")?new BigDecimal("0"):new BigDecimal($F{pricewithtax}) + :$F{pricewithouttax}.equals("")?new BigDecimal("0"):new BigDecimal($F{pricewithouttax})]]></variableExpression> + </variable> + <variable name="Amount" class="java.math.BigDecimal"> + <variableExpression><![CDATA[$F{Included_in_Price-price_include}=="True" + ?$F{Total-price_total}.equals("")?new BigDecimal("0"):new BigDecimal($F{Total-price_total}) + :$F{Subtotal-price_subtotal}.equals("")?new BigDecimal("0"):new BigDecimal($F{Subtotal-price_subtotal})]]></variableExpression> + </variable> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="251" splitType="Stretch"> + <staticText> + <reportElement x="0" y="35" width="270" height="70" uuid="c5cca9a5-34d9-4754-bf83-dbbef02d1e16"/> + <text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG +Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16 +Penjaringan, Kec. Penjaringan, Jakarta +JK 14440 +Indonesia]]></text> + </staticText> + <image> + <reportElement x="0" y="1" width="126" height="33" uuid="6d862bb5-8132-4c49-bba6-0d4e66f7c2c7"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression> + </image> + <line> + <reportElement x="-3" y="34" width="560" height="1" uuid="7ca9f9f3-8916-424b-b710-da4efc4cc7e6"/> + </line> + <textField> + <reportElement x="0" y="179" width="380" height="30" forecolor="#AF171D" uuid="33527582-6dbc-42d4-8745-e62770210912"/> + <textElement verticalAlignment="Bottom"> + <font size="22" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="true"> + <reportElement x="390" y="89" width="176" height="30" uuid="348377cf-189b-44fc-a1b2-34d4b9d637af"/> + <textElement verticalAlignment="Bottom"/> + <textFieldExpression><![CDATA[$F{Name-name_1}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="true"> + <reportElement x="390" y="119" width="176" height="60" uuid="ce4985af-6361-4160-be08-22ad85b244df"/> + <textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="2" y="210" width="198" height="20" forecolor="#3D5959" uuid="849c6c33-d49c-4eaf-a822-3b3faf1502c4"/> + <textElement verticalAlignment="Bottom"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Your Reference:]]></text> + </staticText> + <textField pattern="M/d/yy h:mm a" isBlankWhenNull="true"> + <reportElement x="200" y="230" width="132" height="20" uuid="d1ad6fd3-a9a5-4f37-baf1-7f161a5227ea"/> + <textElement verticalAlignment="Top"/> + <textFieldExpression><![CDATA[$F{Order_Date-date_order}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="392" y="210" width="164" height="20" forecolor="#3D5959" uuid="903ee404-bd44-412f-bcee-884cfadf3662"/> + <textElement verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Salesperson:]]></text> + </staticText> + <staticText> + <reportElement x="200" y="210" width="132" height="20" forecolor="#3D5959" uuid="9b3ef29d-5603-4f2c-ace3-e337056c711c"/> + <textElement verticalAlignment="Bottom"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Order Date:]]></text> + </staticText> + <textField isBlankWhenNull="true"> + <reportElement x="392" y="230" width="164" height="20" uuid="2d1d41ad-5435-4961-8a72-37d2b13df6d3"/> + <textElement verticalAlignment="Top"/> + <textFieldExpression><![CDATA[$F{Name-name_2}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="true"> + <reportElement x="2" y="230" width="198" height="20" uuid="7138d167-f59f-44d2-b711-a7aaa57128d6"/> + <textElement verticalAlignment="Top"/> + <textFieldExpression><![CDATA[$F{Customer_Reference-client_order_ref}]]></textFieldExpression> + </textField> + </band> + </title> + <columnHeader> + <band height="21" splitType="Stretch"> + <staticText> + <reportElement x="126" y="1" width="70" height="20" forecolor="#3D5959" backcolor="#DEE2E6" uuid="32b70c17-8a3c-42e3-b64c-044e01391eb4"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid" lineColor="#DEE2E6"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Item Code]]></text> + </staticText> + <staticText> + <reportElement x="196" y="1" width="50" height="20" forecolor="#3D5959" uuid="198dcc67-d7b4-485d-bbab-0e62844651e9"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Brand]]></text> + </staticText> + <staticText> + <reportElement x="246" y="1" width="54" height="20" forecolor="#3D5959" uuid="39d12e92-0464-4c79-a430-4e9d73225a8a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Quantity]]></text> + </staticText> + <staticText> + <reportElement x="300" y="1" width="72" height="20" forecolor="#3D5959" uuid="b07e0e71-d652-448f-8901-e60b70f894a4"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Unit Price]]></text> + </staticText> + <staticText> + <reportElement x="460" y="1" width="96" height="20" forecolor="#3D5959" uuid="eb2db65e-36ab-4cdc-ad98-2d0a2b6d5c83"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Gambar]]></text> + </staticText> + <staticText> + <reportElement x="372" y="1" width="88" height="20" forecolor="#3D5959" uuid="4a4b093a-6a76-41bc-97e2-948104309393"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Total]]></text> + </staticText> + <staticText> + <reportElement x="0" y="1" width="126" height="20" forecolor="#3D5959" uuid="395e9288-dad6-44a2-b131-1dbd448bf490"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="8" isBold="true"/> + </textElement> + <text><![CDATA[Nama Product]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="51" splitType="Stretch"> + <image hAlign="Center" onErrorType="Blank"> + <reportElement x="460" y="0" width="96" height="50" isRemoveLineWhenBlank="true" uuid="a9b50876-65d5-4e35-8b7f-7ef9e216dbb7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cc4a5789-2434-434e-b7f5-03f64145e6ad"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <imageExpression><![CDATA[$F{Product_Image-image_small}]]></imageExpression> + </image> + <textField isBlankWhenNull="false"> + <reportElement x="126" y="0" width="70" height="50" uuid="0ce11ea3-eb06-4a3a-aa2a-9542c27a8f4f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="dadf5eab-a8f3-4f55-b718-dcdd6449d2a2"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Internal_Reference-default_code}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="false"> + <reportElement x="276" y="0" width="24" height="50" uuid="1aa08123-9a3b-4d26-8831-02ef3e3fae51"/> + <box> + <topPen lineWidth="1.0"/> + <bottomPen lineWidth="0.0"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Unit_of_Measure-name}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="false"> + <reportElement x="196" y="0" width="50" height="50" uuid="15ea9ab0-a0a1-4d3e-a27c-96d98485be62"/> + <box> + <topPen lineWidth="1.0"/> + <bottomPen lineWidth="0.0"/> + </box> + <textElement textAlignment="Left" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Manufactures-x_manufacture}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.00#;(#,##0.00#-)"> + <reportElement x="300" y="0" width="72" height="50" uuid="3bb4eedf-c149-4391-8099-cd17b035ecfd"/> + <box> + <pen lineWidth="1.0"/> + <topPen lineWidth="1.0"/> + <leftPen lineWidth="0.0"/> + <bottomPen lineWidth="0.0"/> + <rightPen lineWidth="0.0"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{PriceUnit}]]></textFieldExpression> + </textField> + <textField pattern="#,###.00#;(#,###.00#-)"> + <reportElement x="372" y="0" width="88" height="50" uuid="c1d4f8e9-bb8f-40be-ad3f-61e93928df3b"/> + <box> + <pen lineWidth="1.0"/> + <topPen lineWidth="1.0"/> + <leftPen lineWidth="0.0"/> + <bottomPen lineWidth="0.0"/> + <rightPen lineWidth="0.0"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{Amount}]]></textFieldExpression> + </textField> + <textField isBlankWhenNull="true"> + <reportElement x="246" y="0" width="30" height="50" uuid="cbad73db-a978-4e1e-9a79-3d434f0ff51c"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="4a3a7752-dc0e-4af0-9883-7f049412b89e"/> + </reportElement> + <box> + <topPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Quantity-product_uom_qty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="0" y="0" width="126" height="50" uuid="ac174790-d132-4f88-88e3-a814c4191de8"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="56b97ace-7223-4ae6-ba51-39cdb8d179e3"/> + </reportElement> + <box> + <topPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Description-name}]]></textFieldExpression> + </textField> + </band> + </detail> + <pageFooter> + <band height="39"> + <staticText> + <reportElement x="231" y="5" width="120" height="14" uuid="64fded97-ed54-4055-8256-4266e96eff70"/> + <text><![CDATA[https://Indoteknik.com]]></text> + </staticText> + <textField evaluationTime="Report"> + <reportElement x="286" y="18" width="40" height="20" uuid="ecca9a9f-4ed5-4731-970a-e5717a472e2c"/> + <textElement textAlignment="Left"/> + <textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + <line> + <reportElement x="-1" y="2" width="560" height="1" uuid="a1a17ab1-3e8e-4e16-9237-513a7c646906"/> + </line> + <textField> + <reportElement x="246" y="18" width="40" height="20" uuid="debb9eb2-8e91-46f4-99b5-b1b7a485d6b6"/> + <textElement textAlignment="Right"/> + <textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression> + </textField> + </band> + </pageFooter> + <summary> + <band height="264"> + <line> + <reportElement x="381" y="3" width="176" height="1" uuid="f9d3c5a2-8321-4b76-81e6-66d70abeb0aa"/> + <graphicElement> + <pen lineWidth="1.0"/> + </graphicElement> + </line> + <staticText> + <reportElement x="381" y="93" width="56" height="20" forecolor="#AF171D" uuid="93c62d9c-a1bf-4433-a928-a0444e8fb242"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Total :]]></text> + </staticText> + <staticText> + <reportElement x="2" y="120" width="556" height="40" uuid="698ac1df-f661-4e72-8166-37bde455c352"/> + <text><![CDATA[1. Kirimkan Data NPWP & SPPKP pada saat pertama kali melakukan pemesanan ke finance@indoteknik.co.id. +2. Penawaran ini memiliki jangka waktu, harga dan stok tidak mengikat. +3. Pembelian tidak dapat dikembalikan. +]]></text> + </staticText> + <staticText> + <reportElement x="437" y="53" width="43" height="20" uuid="67b996f7-8233-45c1-ab3a-9c4f7debde8c"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="false"/> + </textElement> + <text><![CDATA[Rp]]></text> + </staticText> + <textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="true"> + <reportElement x="480" y="13" width="76" height="20" uuid="47a95556-dad6-4b82-902f-98e84869af86"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{subtotal}]]></textFieldExpression> + </textField> + <line direction="BottomUp"> + <reportElement x="381" y="43" width="176" height="1" uuid="6f5ae847-0aed-401f-8454-4c41e92b02cd"/> + <graphicElement> + <pen lineWidth="0.5"/> + </graphicElement> + </line> + <line> + <reportElement x="381" y="83" width="176" height="1" uuid="fe5bba9f-3ca7-48b5-b553-e17c89f4a75f"/> + <graphicElement> + <pen lineWidth="1.0"/> + </graphicElement> + </line> + <staticText> + <reportElement x="1" y="170" width="556" height="40" uuid="9d700a0d-5d35-4eb5-97d7-eddcd069c1dd"/> + <text><![CDATA[Data Bank PT. INDOTEKNIK DOTCOM GEMILANG +BCA CAB. PURI BOTANICAL Acc. No. 8870 4000 81 +Pembayaran giro/cek dinyatakan lunas hanya setelah pencairan. +]]></text> + </staticText> + <textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="false"> + <reportElement x="480" y="53" width="76" height="20" uuid="bd23120c-46ba-4860-b819-53c7d034ff88"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{taxes}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="437" y="93" width="43" height="20" uuid="f6f2526b-b820-4127-9174-2894b4bc2edb"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="false"/> + </textElement> + <text><![CDATA[Rp]]></text> + </staticText> + <staticText> + <reportElement x="381" y="53" width="56" height="20" uuid="7be591e6-712d-4ef2-b299-a74867fafac3"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Taxes :]]></text> + </staticText> + <staticText> + <reportElement x="381" y="13" width="56" height="20" forecolor="#AF171D" uuid="ed88011f-ed01-4682-9620-3c16d7d208d6"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Subtotal :]]></text> + </staticText> + <staticText> + <reportElement x="437" y="13" width="43" height="20" uuid="bd4d3945-73e1-4778-8130-9c819ccdfe4a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/> + </reportElement> + <box> + <pen lineWidth="1.0" lineStyle="Solid"/> + <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font size="10" isBold="false"/> + </textElement> + <text><![CDATA[Rp]]></text> + </staticText> + <textField pattern="#,###.00#;(#,###.00#-)" isBlankWhenNull="true"> + <reportElement x="480" y="93" width="76" height="20" uuid="cf0d483a-dc98-412c-b1a6-32651a4eff2f"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{grand_total}]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> |