From e57142c818fd98df32de2085d0caa8724ae12430 Mon Sep 17 00:00:00 2001
From: root
 <root@prod-erp-indoteknikcom.asia-southeast2-a.c.project-indoteknik-com.internal>
Date: Fri, 30 May 2025 10:38:36 +0700
Subject: add custom report collective

---
 jasper_reports/custom_reports/ShipmentGroup.jrxml | 267 +++++++++++++++++-----
 1 file changed, 206 insertions(+), 61 deletions(-)

(limited to 'jasper_reports/custom_reports/ShipmentGroup.jrxml')

diff --git a/jasper_reports/custom_reports/ShipmentGroup.jrxml b/jasper_reports/custom_reports/ShipmentGroup.jrxml
index bc772c1..ef5509d 100644
--- a/jasper_reports/custom_reports/ShipmentGroup.jrxml
+++ b/jasper_reports/custom_reports/ShipmentGroup.jrxml
@@ -1,7 +1,7 @@
 <?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="ShipmentGroup" pageWidth="595" pageHeight="420" orientation="Landscape" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ee023038-1099-4af8-8961-17b5517d4b2b">
-	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="shipmenttttt.jrdax"/>
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="shipmentgrup.jrdax"/>
 	<property name="ODOO_RELATIONS">
 		<![CDATA[['shipment_line']]]>
 	</property>
@@ -44,6 +44,42 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipment_Group_Lines-shipment_line/Shipping_Paid_by-shipping_paid_by"/>
 		<fieldDescription><![CDATA[/data/record/Shipment_Group_Lines-shipment_line/Shipping_Paid_by-shipping_paid_by]]></fieldDescription>
 	</field>
+	<field name="Phone-phone" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Phone-phone"/>
+		<fieldDescription><![CDATA[/data/record/Customer-partner_id/Phone-phone]]></fieldDescription>
+	</field>
+	<field name="Mobile-mobile" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Customer-partner_id/Mobile-mobile"/>
+		<fieldDescription><![CDATA[/data/record/Customer-partner_id/Mobile-mobile]]></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="Display_Name-display_name_1" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipment_Group_Lines-shipment_line/Ekspedisi-carrier_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Shipment_Group_Lines-shipment_line/Ekspedisi-carrier_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Display_Name-display_name_2" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Ekspedisi-carrier_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Ekspedisi-carrier_id/Display_Name-display_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="Total_Colly-total_colly" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipment_Group_Lines-shipment_line/Total_Colly-total_colly"/>
+		<fieldDescription><![CDATA[/data/record/Shipment_Group_Lines-shipment_line/Total_Colly-total_colly]]></fieldDescription>
+	</field>
+	<field name="Total_Colly-total_colly_line" class="java.math.BigDecimal">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total_Colly-total_colly_line"/>
+		<fieldDescription><![CDATA[/data/record/Total_Colly-total_colly_line]]></fieldDescription>
+	</field>
+	<field name="Display_Name-display_name_3" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Shipment_Group_Lines-shipment_line/Customer-partner_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Shipment_Group_Lines-shipment_line/Customer-partner_id/Display_Name-display_name]]></fieldDescription>
+	</field>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -56,161 +92,270 @@
 				</textElement>
 				<text><![CDATA[Shipment Group]]></text>
 			</staticText>
-		</band>
-	</title>
-	<pageHeader>
-		<band height="60" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="180" height="19" uuid="4b4bdd46-1871-4c25-9947-ea71aaf30baa"/>
+				<textElement markup="none">
+					<font size="9" isBold="true"/>
+				</textElement>
+				<text><![CDATA[PT Indoteknik Dotcom Gemilang]]></text>
+			</staticText>
 			<textField>
-				<reportElement x="0" y="0" width="220" height="50" uuid="e4a7118c-841b-411e-a059-9c41f24b73e4"/>
+				<reportElement x="355" y="2" width="215" height="50" uuid="e4a7118c-841b-411e-a059-9c41f24b73e4"/>
 				<textElement textAlignment="Center">
 					<font size="16" isBold="true"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="220" y="0" width="332" height="50" uuid="7a096341-32d5-4f73-b31c-f367591847ce"/>
-				<textElement textAlignment="Center">
-					<font size="16" isBold="true"/>
+		</band>
+	</title>
+	<pageHeader>
+		<band height="110" splitType="Stretch">
+			<textField isBlankWhenNull="true">
+				<reportElement x="0" y="59" width="305" height="21" isRemoveLineWhenBlank="true" uuid="a708a801-6e14-41cf-819b-ec2071acdcd2"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="0" y="90" width="105" height="10" uuid="f8016b5a-ae4b-45e4-9eff-fae370e36c20"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[M]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="80" width="105" height="10" uuid="60b32b81-4173-4890-b7f7-2bae6623e58c"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[P]]></text>
+			</staticText>
+			<textField isBlankWhenNull="true">
+				<reportElement x="20" y="90" width="285" height="10" isRemoveLineWhenBlank="true" uuid="9b81d678-e6df-4542-aef4-1fd83f55840c"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Mobile-mobile}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="20" y="80" width="285" height="10" isRemoveLineWhenBlank="true" uuid="12a1f6b4-370f-41d5-9eff-51c6bb348d1c"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Phone-phone}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="355" y="20" width="200" height="50" isRemoveLineWhenBlank="true" uuid="f05211dd-76b3-41f2-82f1-1b1313a0c520"/>
+				<textElement>
+					<font size="11"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Display Name Partner}]]></textFieldExpression>
+				<textFieldExpression><![CDATA["Ekspedisi: " + $F{Display_Name-display_name_2}]]></textFieldExpression>
+			</textField>
+			<textField isBlankWhenNull="true">
+				<reportElement x="355" y="70" width="200" height="20" isRemoveLineWhenBlank="true" uuid="eba92841-714c-4de2-b0e8-40240d041037"/>
+				<textElement>
+					<font size="10"/>
+				</textElement>
+				<textFieldExpression><![CDATA["Tanggal: " + $F{Created_on-create_date}]]></textFieldExpression>
 			</textField>
 		</band>
 	</pageHeader>
 	<columnHeader>
-		<band height="30" splitType="Stretch">
+		<band height="10" splitType="Stretch">
 			<staticText>
-				<reportElement x="80" y="0" width="190" height="30" uuid="01ae10e1-96a2-48ce-9b79-2b432b8e5067">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2e94d44a-9423-488b-a401-afaf2c16b860"/>
+				<reportElement x="358" y="0" width="101" height="10" uuid="d1a5649c-1ed7-4076-a167-e73211d90428">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="671d5960-8b0c-4929-9cef-5c27ddaa0d90"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="12"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[Line Partner]]></text>
+				<text><![CDATA[DO Number]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="0" y="0" width="80" height="30" uuid="d1a5649c-1ed7-4076-a167-e73211d90428">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="671d5960-8b0c-4929-9cef-5c27ddaa0d90"/>
+				<reportElement x="41" y="0" width="88" height="10" uuid="0fef1278-e03b-4b45-b8cd-f4fc98651d0d">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="94acfe89-a1ec-4054-89d5-857f5c3004f1"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="12"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[DO Number]]></text>
+				<text><![CDATA[SO Number]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="270" y="0" width="100" height="30" uuid="0fef1278-e03b-4b45-b8cd-f4fc98651d0d">
+				<reportElement x="1" y="0" width="40" height="10" uuid="479e35b1-ab94-461e-8460-67a27e3aac82">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="94acfe89-a1ec-4054-89d5-857f5c3004f1"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="12"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[SO Number]]></text>
+				<text><![CDATA[NO]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="480" y="0" width="73" height="30" uuid="fd42216a-69e8-4339-bf47-f7d5df34fb30">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="462e19c7-ebc5-4ab4-b4b9-24dc4a333126"/>
+				<reportElement x="459" y="0" width="95" height="10" uuid="7f694539-249e-4888-8d5a-90d17536ac37">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c9ef1f91-aec5-4230-85d2-f7233c0e2103"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="12"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[Status]]></text>
+				<text><![CDATA[Total Koli]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="370" y="0" width="110" height="30" uuid="18a3822d-9de0-4e77-af2b-2a63d651a0a1">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="26d7f951-8e46-4b2e-b073-2cff9a705fa0"/>
+				<reportElement x="129" y="0" width="229" height="10" uuid="00bce98b-1b60-495b-ba44-7e1d510b4bc3">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="94acfe89-a1ec-4054-89d5-857f5c3004f1"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="12"/>
+					<font size="8"/>
 				</textElement>
-				<text><![CDATA[Shipping paid by]]></text>
+				<text><![CDATA[Customer]]></text>
 			</staticText>
 		</band>
 	</columnHeader>
 	<detail>
-		<band height="43" splitType="Stretch">
-			<textField>
-				<reportElement x="0" y="0" width="80" height="30" uuid="2caf9efd-5cbd-4f24-bad1-770b7e5c1c64">
+		<band height="27" splitType="Stretch">
+			<textField isBlankWhenNull="true">
+				<reportElement x="358" y="4" width="101" height="17" isRemoveLineWhenBlank="true" uuid="2caf9efd-5cbd-4f24-bad1-770b7e5c1c64">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="671d5960-8b0c-4929-9cef-5c27ddaa0d90"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="11"/>
+					<font size="9"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{DO Number}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="270" y="0" width="100" height="30" uuid="7cd4d47f-e53f-44bb-9c98-7dbafa79ec2f">
+			<textField isBlankWhenNull="true">
+				<reportElement x="41" y="4" width="88" height="17" isRemoveLineWhenBlank="true" uuid="7cd4d47f-e53f-44bb-9c98-7dbafa79ec2f">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="94acfe89-a1ec-4054-89d5-857f5c3004f1"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="11"/>
+					<font size="9"/>
 				</textElement>
 				<textFieldExpression><![CDATA[$F{SO Number}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="480" y="0" width="73" height="30" uuid="c4b01e34-aad5-46f4-98a7-6d50d6dfd237">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="462e19c7-ebc5-4ab4-b4b9-24dc4a333126"/>
-				</reportElement>
+				<reportElement x="1" y="4" width="40" height="17" uuid="3b6a2c82-a6fc-4167-abdc-041175428e91"/>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="11"/>
+					<font size="9"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Status}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="80" y="0" width="190" height="30" uuid="c1d6709a-d962-43c3-bf76-460fc6c60498">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="969c5763-868b-4788-b966-1498d6b831e4"/>
+			<textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true">
+				<reportElement x="459" y="4" width="95" height="17" isRemoveLineWhenBlank="true" uuid="ca07a97e-af62-4654-b866-dfd04bd44fb9">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c9ef1f91-aec5-4230-85d2-f7233c0e2103"/>
 				</reportElement>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="11"/>
+					<font size="9"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{Total_Colly-total_colly}]]></textFieldExpression>
 			</textField>
-			<textField>
-				<reportElement x="370" y="0" width="110" height="30" uuid="dbf054d8-55cd-487e-99ae-10d3e8352aa5">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="26d7f951-8e46-4b2e-b073-2cff9a705fa0"/>
-				</reportElement>
+			<textField isBlankWhenNull="true">
+				<reportElement x="129" y="4" width="229" height="17" isRemoveLineWhenBlank="true" uuid="37e40213-d76d-48ff-a47a-42bd897d9eeb"/>
 				<box>
 					<bottomPen lineWidth="0.5"/>
 				</box>
 				<textElement textAlignment="Center" verticalAlignment="Middle">
-					<font size="11"/>
+					<font size="9"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Shipping_Paid_by-shipping_paid_by}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{Display_Name-display_name_3}]]></textFieldExpression>
 			</textField>
 		</band>
 	</detail>
-	<columnFooter>
-		<band height="45" splitType="Stretch"/>
-	</columnFooter>
-	<pageFooter>
-		<band height="54" splitType="Stretch"/>
-	</pageFooter>
 	<summary>
-		<band height="42" splitType="Stretch"/>
+		<band height="140" splitType="Stretch">
+			<staticText>
+				<reportElement x="205" y="70" width="50" height="10" uuid="d68b3682-f19d-49bd-a27c-f2cb24f66c79"/>
+				<box>
+					<topPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Gudang]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="492" y="70" width="50" height="10" uuid="a9ff11bc-21e9-4d54-a5c5-88bde634d366"/>
+				<box>
+					<topPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Penerima]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="410" y="70" width="50" height="10" uuid="ba7016d6-6431-4a20-b4a9-e04745e29a6d"/>
+				<box>
+					<topPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Security]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="100" y="70" width="50" height="10" uuid="c4973ecb-736b-499e-97c0-647ee7ec33c0"/>
+				<box>
+					<topPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Finance]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="305" y="70" width="50" height="10" uuid="cf7f5982-81c2-4405-bb30-c0d849572a7c"/>
+				<box>
+					<topPen lineWidth="0.5"/>
+				</box>
+				<textElement textAlignment="Center">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Driver]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="-1" y="110" width="556" height="30" uuid="2e9978d1-e73f-47ce-915c-383065f3c94a"/>
+				<text><![CDATA[PERHATIAN: Harap memeriksa kelengkapan & kondisi barang dengan video ketika paket akan dibuka. Komplain harus menyertakan video unboxing
+]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="450" y="0" width="60" height="12" uuid="ad6c779f-69e8-498b-95d6-80e9cdbbd759"/>
+				<textElement textAlignment="Right" verticalAlignment="Bottom">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[Jumlah Koli:]]></text>
+			</staticText>
+			<textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true">
+				<reportElement x="510" y="0" width="45" height="12" isRemoveLineWhenBlank="true" uuid="d4162276-d730-49a8-97d5-553e4dcc10b8"/>
+				<textElement textAlignment="Left" verticalAlignment="Middle">
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[" " + $F{Total_Colly-total_colly_line}]]></textFieldExpression>
+			</textField>
+		</band>
 	</summary>
 </jasperReport>
-- 
cgit v1.2.3