From 289a96245b2ba6bd90093b91096adf02a721dd1b Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Thu, 13 Oct 2022 11:29:29 +0700
Subject: add picking / receiving list

---
 jasper_reports/custom_reports/AlamatTempel.jrxml |  56 ++++----
 jasper_reports/custom_reports/PickingList.jrxml  | 155 +++++++++++++++++++++++
 2 files changed, 187 insertions(+), 24 deletions(-)
 create mode 100644 jasper_reports/custom_reports/PickingList.jrxml

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>
-- 
cgit v1.2.3