From b548e0acdd6177ba9b453f509c7c1f508d33f1d3 Mon Sep 17 00:00:00 2001
From: root <root@prod-erp-indoteknikcom.c.project-indoteknik-com.internal>
Date: Wed, 11 Jan 2023 16:02:22 +0700
Subject: modify jasper report

---
 jasper_reports/custom_reports/AlamatTempel.jrxml   |  52 ++++--
 .../custom_reports/DeliverySlip_A5.jrxml           |  33 ++--
 .../custom_reports/Journal_Entries.jrxml           | 180 +++++++++++++++++++++
 3 files changed, 242 insertions(+), 23 deletions(-)
 create mode 100644 jasper_reports/custom_reports/Journal_Entries.jrxml

diff --git a/jasper_reports/custom_reports/AlamatTempel.jrxml b/jasper_reports/custom_reports/AlamatTempel.jrxml
index 8c67885..3a34cfd 100755
--- a/jasper_reports/custom_reports/AlamatTempel.jrxml
+++ b/jasper_reports/custom_reports/AlamatTempel.jrxml
@@ -49,6 +49,30 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales_Order-sale_id/Customer-partner_id/Phone-phone"/>
 		<fieldDescription><![CDATA[/data/record/Sales_Order-sale_id/Customer-partner_id/Phone-phone]]></fieldDescription>
 	</field>
+	<field name="real_street_1" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Street-street"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Street-street]]></fieldDescription>
+	</field>
+	<field name="real_street_2" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Street2-street2"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Street2-street2]]></fieldDescription>
+	</field>
+	<field name="real_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="real_phone" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Phone-phone"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Phone-phone]]></fieldDescription>
+	</field>
+	<field name="real_mobile" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Mobile-mobile"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Mobile-mobile]]></fieldDescription>
+	</field>
+	<field name="real_display_name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Real_Delivery_Address-real_shipping_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Real_Delivery_Address-real_shipping_id/Display_Name-display_name]]></fieldDescription>
+	</field>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -61,7 +85,7 @@
 		</band>
 	</title>
 	<pageHeader>
-		<band height="172">
+		<band height="186">
 			<staticText>
 				<reportElement x="0" y="0" width="250" height="14" uuid="9d7f7b14-43ea-4492-803f-6badaaa33c7f"/>
 				<textElement>
@@ -88,38 +112,38 @@
 				<textElement verticalAlignment="Top">
 					<font size="10" isBold="true"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{customername}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{real_display_name}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="0" y="70" width="250" height="30" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/>
+				<reportElement x="0" y="84" width="250" height="30" uuid="ce154705-9c04-42d1-b050-16406ad46a1a"/>
 				<textElement>
 					<font size="10"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{real_street_1}]]></textFieldExpression>
 			</textField>
 			<textField isBlankWhenNull="true">
-				<reportElement x="0" y="100" width="250" height="30" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/>
+				<reportElement x="0" y="114" width="250" height="30" uuid="2e2981a9-3514-4af3-92ac-99135dbb1831"/>
 				<textElement>
 					<font size="10"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$F{Street2-street2}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{real_street_2}]]></textFieldExpression>
 			</textField>
 			<staticText>
-				<reportElement x="0" y="130" width="250" height="14" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/>
+				<reportElement x="0" y="144" width="250" height="14" uuid="28ec38f8-9383-40e0-9631-b3ab587d1409"/>
 				<textElement>
 					<font size="10"/>
 				</textElement>
 				<text><![CDATA[Dari]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="0" y="144" width="80" height="14" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/>
+				<reportElement x="0" y="158" width="110" height="14" uuid="c1d2b7b8-1df7-4920-aafd-3a8defdb5fdc"/>
 				<textElement>
 					<font size="10" isBold="true"/>
 				</textElement>
 				<text><![CDATA[INDOTEKNIK.COM]]></text>
 			</staticText>
 			<textField>
-				<reportElement x="80" y="144" width="170" height="14" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4">
+				<reportElement x="110" y="158" width="140" height="14" uuid="d2d66d39-c8a1-4adc-a759-892ebe7df3c4">
 					<property name="com.jaspersoft.studio.unit.height" value="mm"/>
 				</reportElement>
 				<textElement>
@@ -128,14 +152,14 @@
 				<textFieldExpression><![CDATA[$F{salesperson}]]></textFieldExpression>
 			</textField>
 			<staticText>
-				<reportElement x="0" y="158" width="80" height="14" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/>
+				<reportElement x="0" y="172" width="110" height="14" uuid="61f4ad47-fe12-4ccf-af1e-4f5dab099949"/>
 				<textElement>
 					<font size="10"/>
 				</textElement>
 				<text><![CDATA[NO HP]]></text>
 			</staticText>
 			<textField>
-				<reportElement x="80" y="158" width="170" height="14" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2">
+				<reportElement x="110" y="172" width="140" height="14" uuid="6a27d5df-b3af-4824-a036-5c87163a61a2">
 					<property name="com.jaspersoft.studio.unit.height" value="mm"/>
 				</reportElement>
 				<textElement>
@@ -145,7 +169,11 @@
 			</textField>
 			<textField>
 				<reportElement x="0" y="56" width="250" height="14" uuid="689389ff-1dae-483a-a1f6-611095c2952c"/>
-				<textFieldExpression><![CDATA[$F{customerphone}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$F{real_phone}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="70" width="250" height="14" uuid="a6a85851-921f-4c09-9b3e-9ae757e296f5"/>
+				<textFieldExpression><![CDATA[$F{real_mobile}]]></textFieldExpression>
 			</textField>
 		</band>
 	</pageHeader>
diff --git a/jasper_reports/custom_reports/DeliverySlip_A5.jrxml b/jasper_reports/custom_reports/DeliverySlip_A5.jrxml
index c10474c..4a499ff 100755
--- a/jasper_reports/custom_reports/DeliverySlip_A5.jrxml
+++ b/jasper_reports/custom_reports/DeliverySlip_A5.jrxml
@@ -64,6 +64,10 @@
 		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Operations_without_package-move_line_ids_without_package/Done-qty_done"/>
 		<fieldDescription><![CDATA[/data/record/Operations_without_package-move_line_ids_without_package/Done-qty_done]]></fieldDescription>
 	</field>
+	<field name="cust_reference" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Procurement_Group-group_id/Sale_Order-sale_id/Customer_Reference-client_order_ref"/>
+		<fieldDescription><![CDATA[/data/record/Procurement_Group-group_id/Sale_Order-sale_id/Customer_Reference-client_order_ref]]></fieldDescription>
+	</field>
 	<variable name="Jumlah_Barang" class="java.lang.Integer" calculation="Count">
 		<variableExpression><![CDATA[$F{product_name}]]></variableExpression>
 	</variable>
@@ -143,26 +147,19 @@
 				<text><![CDATA[No Order]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="280" y="10" width="100" height="10" uuid="1f3941da-bda3-4650-8ceb-697ae43be3c7"/>
+				<reportElement x="280" y="20" width="100" height="10" uuid="1f3941da-bda3-4650-8ceb-697ae43be3c7"/>
 				<textElement textAlignment="Right">
 					<font size="8"/>
 				</textElement>
-				<text><![CDATA[No DO]]></text>
+				<text><![CDATA[Reference]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="280" y="20" width="100" height="10" uuid="94652b05-841f-4150-99cc-a8adec5be297"/>
+				<reportElement x="280" y="30" width="100" height="10" uuid="94652b05-841f-4150-99cc-a8adec5be297"/>
 				<textElement textAlignment="Right">
 					<font size="8"/>
 				</textElement>
 				<text><![CDATA[Ekspedisi]]></text>
 			</staticText>
-			<staticText>
-				<reportElement x="280" y="30" width="100" height="10" uuid="91358641-ba5b-4741-9ff9-773506e44fad"/>
-				<textElement textAlignment="Right">
-					<font size="8"/>
-				</textElement>
-				<text><![CDATA[No Resi]]></text>
-			</staticText>
 			<textField>
 				<reportElement x="390" y="0" width="165" height="10" uuid="0aadd48d-abbe-49bb-b460-9d52e7ae4780"/>
 				<textElement>
@@ -178,7 +175,7 @@
 				<textFieldExpression><![CDATA[$F{DONo}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="390" y="20" width="165" height="10" uuid="2f7ff77b-bef5-4092-9ad3-6e955359fa08"/>
+				<reportElement x="390" y="30" width="165" height="10" uuid="2f7ff77b-bef5-4092-9ad3-6e955359fa08"/>
 				<textElement>
 					<font size="8"/>
 				</textElement>
@@ -199,6 +196,20 @@
 				<textFieldExpression><![CDATA[$F{Date}]]></textFieldExpression>
 				<patternExpression><![CDATA[new SimpleDateFormat("dd/MM/yyyy").format($F{Date})]]></patternExpression>
 			</textField>
+			<textField>
+				<reportElement x="390" y="20" width="165" height="10" uuid="86208a54-fbe9-4a01-a22b-1faacb4538f0"/>
+				<textElement>
+					<font size="8"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{cust_reference}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="280" y="10" width="100" height="10" uuid="2e97f076-f6b8-4915-86d3-f79641dc83ad"/>
+				<textElement textAlignment="Right">
+					<font size="8"/>
+				</textElement>
+				<text><![CDATA[No DO]]></text>
+			</staticText>
 		</band>
 	</pageHeader>
 	<columnHeader>
diff --git a/jasper_reports/custom_reports/Journal_Entries.jrxml b/jasper_reports/custom_reports/Journal_Entries.jrxml
new file mode 100644
index 0000000..1466d87
--- /dev/null
+++ b/jasper_reports/custom_reports/Journal_Entries.jrxml
@@ -0,0 +1,180 @@
+<?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="Journal_Entries" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="854acef6-eb08-4fac-888a-f2a2ad7ebcbc">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Account Move"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['line_ids']]]>
+	</property>
+	<queryString language="XPath">
+		<![CDATA[]]>
+	</queryString>
+	<field name="Number-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Number-name"/>
+		<fieldDescription><![CDATA[/data/record/Number-name]]></fieldDescription>
+	</field>
+	<field name="Reference-ref" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Reference-ref"/>
+		<fieldDescription><![CDATA[/data/record/Reference-ref]]></fieldDescription>
+	</field>
+	<field name="label_line" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Label-name"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Label-name]]></fieldDescription>
+	</field>
+	<field name="display_name_line" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="display_name_partner" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Partner-partner_id/Display_Name-display_name]]></fieldDescription>
+	</field>
+	<field name="Debit-debit" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Debit-debit"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Debit-debit]]></fieldDescription>
+	</field>
+	<field name="Credit-credit" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Credit-credit"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Credit-credit]]></fieldDescription>
+	</field>
+	<field name="Quantity-quantity" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Journal_Items-line_ids/Quantity-quantity"/>
+		<fieldDescription><![CDATA[/data/record/Journal_Items-line_ids/Quantity-quantity]]></fieldDescription>
+	</field>
+	<variable name="debit" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Debit-debit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Debit-debit})]]></variableExpression>
+	</variable>
+	<variable name="credit" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Credit-credit}.equals("")?new BigDecimal("0"):new BigDecimal($F{Credit-credit})]]></variableExpression>
+	</variable>
+	<variable name="qty" class="java.math.BigDecimal">
+		<variableExpression><![CDATA[$F{Quantity-quantity}.equals("")?new BigDecimal("0"):new BigDecimal($F{Quantity-quantity})]]></variableExpression>
+	</variable>
+	<variable name="total_debit" class="java.math.BigDecimal" calculation="Sum">
+		<variableExpression><![CDATA[$V{debit}]]></variableExpression>
+	</variable>
+	<variable name="total_credit" class="java.math.BigDecimal" calculation="Sum">
+		<variableExpression><![CDATA[$V{credit}]]></variableExpression>
+	</variable>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="70" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="550" height="70" uuid="29a55e19-4078-41c5-a2fb-2a3ceceb3dfa"/>
+				<text><![CDATA[PT. INDOTEKNIK DOTCOM GEMILANG
+Jl. Bandengan Utara 85A No 8-9 RT 3/RW 16
+Penjaringan, Kec. Penjaringan, Jakarta
+JK 14440
+Indonesia]]></text>
+			</staticText>
+		</band>
+	</title>
+	<pageHeader>
+		<band height="30" splitType="Stretch">
+			<textField>
+				<reportElement x="0" y="0" width="550" height="30" forecolor="#2105F2" uuid="76b1b8a3-1bd7-4e23-8882-2e440811e56f"/>
+				<textElement>
+					<font size="14"/>
+				</textElement>
+				<textFieldExpression><![CDATA[$F{Number-name}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageHeader>
+	<columnHeader>
+		<band height="20" splitType="Stretch">
+			<staticText>
+				<reportElement x="0" y="0" width="280" height="20" uuid="b3eef15d-1163-4ccd-aa88-13a6fa569dce">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2bb9801f-c69f-4473-a023-d94a92db34d4"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<text><![CDATA[Description]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="350" y="0" width="100" height="20" uuid="fc5562bc-f6fb-4cc2-ab6b-3ba02c99b96c">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5e9d9201-62b1-4880-a4d4-0b3753fcaebf"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Debit]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="450" y="0" width="100" height="20" uuid="546e7ad9-a211-48dc-b5a0-1662630b1e94">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="a36100ad-7b82-4cf8-9d26-a72c2aa4b9bc"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Credit]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="280" y="0" width="70" height="20" uuid="60bcdaba-60ef-4ead-a503-94336d3a43a1">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5e9d9201-62b1-4880-a4d4-0b3753fcaebf"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="1.0"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<text><![CDATA[Debit]]></text>
+			</staticText>
+		</band>
+	</columnHeader>
+	<detail>
+		<band height="30" splitType="Stretch">
+			<textField pattern="#,#00.00#;(#,#00.00#-)">
+				<reportElement x="350" y="0" width="100" height="30" uuid="8e4d064c-63fb-4a17-9d85-09fa779e058a"/>
+				<box>
+					<bottomPen lineWidth="0.25"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{debit}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,#00.00#;(#,#00.00#-)">
+				<reportElement x="450" y="0" width="100" height="30" uuid="e0d06b19-013a-45be-aa2f-5a0655231da5"/>
+				<box>
+					<bottomPen lineWidth="0.25"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{credit}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,##0.###;(#,##0.###-)">
+				<reportElement x="280" y="0" width="70" height="30" uuid="06327ba4-6483-4655-a70a-093c40adcf97"/>
+				<box>
+					<bottomPen lineWidth="0.25"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{qty}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="0" width="280" height="30" uuid="45307df6-d313-4147-b216-905f47c91539">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="f8348c97-3314-4f6a-8aca-f57a496fcca6"/>
+				</reportElement>
+				<box>
+					<bottomPen lineWidth="0.25"/>
+				</box>
+				<textElement verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$F{label_line}]]></textFieldExpression>
+			</textField>
+		</band>
+	</detail>
+	<summary>
+		<band height="30" splitType="Stretch">
+			<textField pattern="#,#00.00#;(#,#00.00#-)">
+				<reportElement x="350" y="0" width="100" height="30" uuid="ba1b84a4-c1e0-4d02-a0db-e9313e4d2ecc"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{total_debit}]]></textFieldExpression>
+			</textField>
+			<textField pattern="#,#00.00#;(#,#00.00#-)">
+				<reportElement x="450" y="0" width="100" height="30" uuid="9a350fee-cfee-4b63-9bae-ec388e8ddbc2"/>
+				<textElement textAlignment="Right" verticalAlignment="Middle"/>
+				<textFieldExpression><![CDATA[$V{total_credit}]]></textFieldExpression>
+			</textField>
+		</band>
+	</summary>
+</jasperReport>
-- 
cgit v1.2.3