diff options
| -rwxr-xr-x | jasper_reports/custom_reports/PickingList.jrxml | 305 |
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> |