modified picking list

1 files changed, 286 insertions, 19 deletions

diff --git a/jasper_reports/custom_reports/PickingList.jrxml b/jasper_reports/custom_reports/PickingList.jrxml
index 27fd997..aaba91e 100755
--- a/jasper_reports/custom_reports/PickingList.jrxml
+++ b/jasper_reports/custom_reports/PickingList.jrxml
@@ -45,6 +45,54 @@
 		<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="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>
+	</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>
 	<variable name="SumQty" class="java.math.BigDecimal" calculation="Sum">
 		<variableExpression><![CDATA[$F{Demand-product_uom_qty}]]></variableExpression>
 	</variable>
@@ -52,6 +100,22 @@
 		<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>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -64,30 +128,102 @@
 		</band>
 	</title>
 	<pageHeader>
-		<band height="50" splitType="Stretch">
+		<band height="84" splitType="Stretch">
 			<textField>
-				<reportElement x="0" y="0" width="180" height="30" uuid="70b70e92-fd37-4045-a6e9-0efe5b553dbb"/>
+				<reportElement x="200" y="0" width="180" height="30" uuid="70b70e92-fd37-4045-a6e9-0efe5b553dbb"/>
 				<textElement verticalAlignment="Middle"/>
-				<textFieldExpression><![CDATA[$F{CustomerName-name}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{partner_display_name}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="180" y="0" width="200" height="30" uuid="609a5eaf-b3b3-4908-997a-b8d9662f0d82"/>
-				<textElement textAlignment="Right" verticalAlignment="Middle">
+				<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="180" y="30" width="200" height="20" uuid="d6cce15b-c49a-4122-87f7-53b9072f51bc"/>
-				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<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>
 		</band>
 	</pageHeader>
 	<columnHeader>
 		<band height="20" splitType="Stretch">
 			<staticText>
-				<reportElement x="0" y="0" width="310" height="20" uuid="0e9068bc-1d75-4802-8d3c-67586c1c8b94">
+				<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>
@@ -97,56 +233,187 @@
 				<text><![CDATA[Kode & Nama Barang]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="310" y="0" width="70" height="20" uuid="04ecff5f-cf8d-4dfd-8de7-7a4429e36150">
+				<reportElement x="200" y="0" width="60" 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="Right" verticalAlignment="Middle"/>
-				<text><![CDATA[Qty]]></text>
+				<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="260" y="0" width="40" height="20" forecolor="#080278" uuid="01234b47-d045-4dae-9e89-14fffc44167b">
+					<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">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Reserve]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="300" y="0" width="40" height="20" forecolor="#080278" uuid="d0b948cf-ab6e-4b73-9b75-2093ecbb3a44">
+					<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">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[OnHand]]></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[Source]]></text>
 			</staticText>
 		</band>
 	</columnHeader>
 	<detail>
-		<band height="20" splitType="Stretch">
+		<band height="22" splitType="Stretch">
 			<textField>
-				<reportElement x="0" y="0" width="310" height="20" uuid="a71f43a7-9234-4311-b2b5-cad4e125d3a7">
+				<reportElement x="30" y="0" width="170" height="20" 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="310" y="0" width="70" height="20" uuid="bad07ba5-f6f0-47ff-a0b9-280627d17e6a">
+				<reportElement x="200" y="0" width="30" 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"/>
+				<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="20" 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.###-)" isBlankWhenNull="true">
+				<reportElement x="260" y="0" width="40" height="20" uuid="d9ba32c9-c209-4960-9d61-e3037383c153">
+					<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{forecast_qty}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,##0.###;(#,##0.###-)">
+				<reportElement x="230" y="0" width="30" height="20" 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 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>
+				<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{forecast_qty}]]></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>
+				<box>
+					<topPen lineWidth="0.0"/>
+					<leftPen lineWidth="0.25"/>
+					<bottomPen lineWidth="0.25"/>
+					<rightPen lineWidth="0.25"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{location_display_name}]]></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"/>
+				<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="310" y="20" width="70" height="20" uuid="f20eae90-18b1-49db-a91b-7770fea429b2"/>
+				<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="210" y="0" width="100" height="20" uuid="44400c16-dddb-46a7-90c4-dfdf22b8ce68"/>
+				<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="210" y="20" width="100" height="20" uuid="aa643be4-80e1-430c-9a69-cf9fcff7078d"/>
+				<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>