diff options
| -rw-r--r-- | jasper_reports/custom_reports/AlamatTempel.jrxml | 56 | ||||
| -rw-r--r-- | jasper_reports/custom_reports/PickingList.jrxml | 155 |
2 files changed, 187 insertions, 24 deletions
diff --git a/jasper_reports/custom_reports/AlamatTempel.jrxml b/jasper_reports/custom_reports/AlamatTempel.jrxml index 90b44e9..8c67885 100644 --- a/jasper_reports/custom_reports/AlamatTempel.jrxml +++ b/jasper_reports/custom_reports/AlamatTempel.jrxml @@ -61,84 +61,92 @@ </band> </title> <pageHeader> - <band height="130"> + <band height="172"> <staticText> - <reportElement x="0" y="0" width="250" height="10" uuid="9d7f7b14-43ea-4492-803f-6badaaa33c7f"/> + <reportElement x="0" y="0" width="250" height="14" uuid="9d7f7b14-43ea-4492-803f-6badaaa33c7f"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <text><![CDATA[Ekspedisi]]></text> </staticText> <textField> - <reportElement x="0" y="10" width="250" height="10" uuid="a08cdd15-9fab-4743-b1d0-d334986a1201"/> + <reportElement x="0" y="14" width="250" height="14" uuid="a08cdd15-9fab-4743-b1d0-d334986a1201"/> <textElement> - <font size="8" isBold="true"/> + <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{Delivery_Method-name}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="30" width="250" height="10" uuid="8705000a-f1e7-4efe-a18a-95ffc955921c"/> + <reportElement x="0" y="28" width="250" height="14" uuid="8705000a-f1e7-4efe-a18a-95ffc955921c"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <text><![CDATA[Kepada]]></text> </staticText> <textField> - <reportElement x="0" y="40" width="250" height="10" uuid="debdc706-5bc6-4b83-8592-848b6130fbbf"/> - <textElement> - <font size="8" isBold="true"/> + <reportElement x="0" y="42" width="250" height="14" uuid="debdc706-5bc6-4b83-8592-848b6130fbbf"/> + <textElement verticalAlignment="Top"> + <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression> </textField> <textField> - <reportElement x="0" y="50" width="250" height="20" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/> + <reportElement x="0" y="70" width="250" height="30" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> - <reportElement x="0" y="70" width="250" height="20" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/> + <reportElement x="0" y="100" width="250" height="30" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{Street2-street2}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="100" width="250" height="10" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/> + <reportElement x="0" y="130" width="250" height="14" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <text><![CDATA[Dari]]></text> </staticText> <staticText> - <reportElement x="0" y="110" width="80" height="10" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/> + <reportElement x="0" y="144" width="80" height="14" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/> <textElement> - <font size="8" isBold="true"/> + <font size="10" isBold="true"/> </textElement> <text><![CDATA[INDOTEKNIK.COM]]></text> </staticText> <textField> - <reportElement x="80" y="110" width="170" height="10" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4"/> + <reportElement x="80" y="144" width="170" height="14" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4"> + <property name="com.jaspersoft.studio.unit.height" value="mm"/> + </reportElement> <textElement> - <font size="8" isBold="true"/> + <font size="10" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$F{salesperson}]]></textFieldExpression> </textField> <staticText> - <reportElement x="0" y="120" width="80" height="10" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/> + <reportElement x="0" y="158" width="80" height="14" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <text><![CDATA[NO HP]]></text> </staticText> <textField> - <reportElement x="80" y="120" width="170" height="10" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2"/> + <reportElement x="80" y="158" width="170" height="14" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2"> + <property name="com.jaspersoft.studio.unit.height" value="mm"/> + </reportElement> <textElement> - <font size="8"/> + <font size="10"/> </textElement> <textFieldExpression><![CDATA[$F{salesphone}]]></textFieldExpression> </textField> + <textField> + <reportElement x="0" y="56" width="250" height="14" uuid="689389ff-1dae-483a-a1f6-611095c2952c"/> + <textFieldExpression><![CDATA[$F{customerphone}]]></textFieldExpression> + </textField> </band> </pageHeader> </jasperReport> diff --git a/jasper_reports/custom_reports/PickingList.jrxml b/jasper_reports/custom_reports/PickingList.jrxml new file mode 100644 index 0000000..27fd997 --- /dev/null +++ b/jasper_reports/custom_reports/PickingList.jrxml @@ -0,0 +1,155 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 6.20.0.final using JasperReports Library version 6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad --> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="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="com.jaspersoft.studio.data.defaultdataadapter" value="Stock Picking"/> + <property name="ODOO_RELATIONS"> + <![CDATA[['move_ids_without_package']]]> + </property> + <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> + <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"/> + <background> + <band splitType="Stretch"/> + </background> + <title> + <band height="40" 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> + </band> + </title> + <pageHeader> + <band height="50" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="180" height="30" uuid="70b70e92-fd37-4045-a6e9-0efe5b553dbb"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{CustomerName-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="0" width="200" height="30" uuid="609a5eaf-b3b3-4908-997a-b8d9662f0d82"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{DocNoReference-name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="30" width="200" height="20" uuid="d6cce15b-c49a-4122-87f7-53b9072f51bc"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Source_Document-origin}]]></textFieldExpression> + </textField> + </band> + </pageHeader> + <columnHeader> + <band height="20" splitType="Stretch"> + <staticText> + <reportElement x="0" y="0" width="310" height="20" 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="310" y="0" width="70" height="20" 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="Right" verticalAlignment="Middle"/> + <text><![CDATA[Qty]]></text> + </staticText> + </band> + </columnHeader> + <detail> + <band height="20" splitType="Stretch"> + <textField> + <reportElement x="0" y="0" width="310" height="20" uuid="a71f43a7-9234-4311-b2b5-cad4e125d3a7"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="cb0f2359-ee11-48ca-96cd-d0df561f9bcc"/> + </reportElement> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{ProductDisplay_Name-display_name}]]></textFieldExpression> + </textField> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="310" y="0" width="70" height="20" uuid="bad07ba5-f6f0-47ff-a0b9-280627d17e6a"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="de1ff7fb-ba90-40dc-b343-59f9ec2710ca"/> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Demand-product_uom_qty}]]></textFieldExpression> + </textField> + </band> + </detail> + <summary> + <band height="40" splitType="Stretch"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="310" y="0" width="70" height="20" uuid="27e8c52e-5695-4c5a-98c2-686df7b414b7"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{SumQty}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="310" y="20" width="70" height="20" uuid="f20eae90-18b1-49db-a91b-7770fea429b2"/> + <textElement textAlignment="Right" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{CountQty}]]></textFieldExpression> + </textField> + <staticText> + <reportElement x="210" 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="210" 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> |