add cap ttd di dunning run

1 files changed, 46 insertions, 59 deletions

diff --git a/jasper_reports/custom_reports/DunningRun.jrxml b/jasper_reports/custom_reports/DunningRun.jrxml
index 27755fd..e76aba1 100644
--- a/jasper_reports/custom_reports/DunningRun.jrxml
+++ b/jasper_reports/custom_reports/DunningRun.jrxml
@@ -65,6 +65,9 @@
 	<variable name="total_outstanding" class="java.math.BigDecimal" calculation="Sum">
 		<variableExpression><![CDATA[$V{outstanding}]]></variableExpression>
 	</variable>
+	<variable name="grand_total" class="java.math.BigDecimal" calculation="Sum">
+		<variableExpression><![CDATA[$V{total}]]></variableExpression>
+	</variable>
 	<background>
 		<band splitType="Stretch"/>
 	</background>
@@ -86,7 +89,7 @@ Indonesia]]></text>
 				<text><![CDATA[Tanda Terima Faktur]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="390" y="10" width="140" height="80" uuid="25d02f1d-cc50-4b6f-9ce0-209951f96d7f"/>
+				<reportElement x="390" y="10" width="140" height="90" uuid="25d02f1d-cc50-4b6f-9ce0-209951f96d7f"/>
 				<box>
 					<topPen lineWidth="0.5"/>
 					<leftPen lineWidth="0.5"/>
@@ -96,8 +99,8 @@ Indonesia]]></text>
 				<textElement textAlignment="Center" verticalAlignment="Top">
 					<font size="8" isBold="true"/>
 				</textElement>
-				<text><![CDATA[Note:

-Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto untuk dikirimkan ke kami melalui email finance@indoteknik.co.id atau melalui WA di +62 882-1961-6220]]></text>
+				<text><![CDATA[Note:
+Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto untuk dikirimkan ke kami melalui email finance@indoteknik.co.id atau melalui WA di +62 857-1697-0374]]></text>
 			</staticText>
 		</band>
 	</title>
@@ -142,7 +145,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[No]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="20" y="0" width="80" height="20" uuid="bb1978fb-f5ab-4c6e-9967-9164b8406d8a">
+				<reportElement x="20" y="0" width="90" height="20" uuid="bb1978fb-f5ab-4c6e-9967-9164b8406d8a">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
 				</reportElement>
 				<box>
@@ -154,7 +157,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[Invoice]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="100" y="0" width="60" height="20" uuid="c07c62fa-9d20-4f87-98ee-9765952b1e6d">
+				<reportElement x="110" y="0" width="70" height="20" uuid="c07c62fa-9d20-4f87-98ee-9765952b1e6d">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
 				</reportElement>
 				<box>
@@ -166,7 +169,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[Invoice Date]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="160" y="0" width="100" height="20" uuid="fd89030d-6c15-45d1-9b22-1801e7b46d69">
+				<reportElement x="180" y="0" width="110" height="20" uuid="fd89030d-6c15-45d1-9b22-1801e7b46d69">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
 				</reportElement>
 				<box>
@@ -178,7 +181,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[Faktur]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="260" y="0" width="80" height="20" uuid="4b8b5ced-c7d1-4553-add0-a96f016d9204">
+				<reportElement x="290" y="0" width="110" height="20" uuid="4b8b5ced-c7d1-4553-add0-a96f016d9204">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
 				</reportElement>
 				<box>
@@ -190,7 +193,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[Reference]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="400" y="0" width="70" height="20" uuid="4b55a424-baaa-4c60-90a6-fb87db30dc88">
+				<reportElement x="460" y="0" width="90" height="20" uuid="4b55a424-baaa-4c60-90a6-fb87db30dc88">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
 				</reportElement>
 				<box>
@@ -202,7 +205,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<text><![CDATA[Total]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="340" y="0" width="60" height="20" uuid="ae0915e4-83a8-4945-9ce1-d560303bf41c">
+				<reportElement x="400" y="0" width="60" height="20" uuid="ae0915e4-83a8-4945-9ce1-d560303bf41c">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>
 				</reportElement>
 				<box>
@@ -213,18 +216,6 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				</textElement>
 				<text><![CDATA[Due]]></text>
 			</staticText>
-			<staticText>
-				<reportElement x="470" y="0" width="80" height="20" uuid="d1815f0c-d3fe-412f-a92f-e33ddfc65f7f">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c2e05b8e-e9c7-4c0a-80c8-9592982cd2a4"/>
-				</reportElement>
-				<box>
-					<bottomPen lineWidth="0.5"/>
-				</box>
-				<textElement textAlignment="Right" verticalAlignment="Middle">
-					<font size="8" isBold="true"/>
-				</textElement>
-				<text><![CDATA[Outstanding]]></text>
-			</staticText>
 		</band>
 	</columnHeader>
 	<detail>
@@ -240,7 +231,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$V{REPORT_COUNT}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="20" y="0" width="80" height="20" uuid="0a33350c-f826-4f92-b409-7f2b1eea58c6">
+				<reportElement x="20" y="0" width="90" height="20" uuid="0a33350c-f826-4f92-b409-7f2b1eea58c6">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ce1fe034-d166-429b-8566-fe0c16b92a0c"/>
 				</reportElement>
 				<box>
@@ -252,7 +243,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$F{invoice_number}]]></textFieldExpression>
 			</textField>
 			<textField pattern="MMM d, yyyy">
-				<reportElement x="100" y="0" width="60" height="20" uuid="b9715916-74c1-4892-8883-b681f7baf4cb">
+				<reportElement x="110" y="0" width="70" height="20" uuid="b9715916-74c1-4892-8883-b681f7baf4cb">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="3a258e3c-10cd-4b66-9918-3fc9abcac5e1"/>
 				</reportElement>
 				<box>
@@ -264,7 +255,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$F{invoice_date}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="160" y="0" width="100" height="20" uuid="4830ecbf-9739-4431-b0b8-3f1feb3b1f4d">
+				<reportElement x="180" y="0" width="110" height="20" uuid="4830ecbf-9739-4431-b0b8-3f1feb3b1f4d">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="69ab7207-5108-44e3-b756-df99df8c269a"/>
 				</reportElement>
 				<box>
@@ -276,7 +267,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$F{eFaktur_Number-name}]]></textFieldExpression>
 			</textField>
 			<textField>
-				<reportElement x="260" y="0" width="80" height="20" uuid="8c5d0138-c176-487d-9d12-1cb2b77a6609">
+				<reportElement x="290" y="0" width="110" height="20" uuid="8c5d0138-c176-487d-9d12-1cb2b77a6609">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2dfd3f0c-531e-450e-86fc-9aa69249f4a4"/>
 				</reportElement>
 				<box>
@@ -288,7 +279,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$F{Reference-ref}]]></textFieldExpression>
 			</textField>
 			<textField pattern="#,#00.00#;(#,#00.00#-)">
-				<reportElement x="400" y="0" width="70" height="20" uuid="5d81a73c-3e98-45c0-a541-e5c299e2b8cd">
+				<reportElement x="460" y="0" width="90" height="20" uuid="5d81a73c-3e98-45c0-a541-e5c299e2b8cd">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
 				</reportElement>
 				<box>
@@ -300,7 +291,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textFieldExpression><![CDATA[$V{total}]]></textFieldExpression>
 			</textField>
 			<textField pattern="MMM d, yyyy">
-				<reportElement x="340" y="0" width="60" height="20" uuid="ce215c7b-d245-4bbd-9f91-01a07b09c8e7">
+				<reportElement x="400" y="0" width="60" height="20" uuid="ce215c7b-d245-4bbd-9f91-01a07b09c8e7">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="289181ee-1809-46e9-8ad9-2b44772e6161"/>
 				</reportElement>
 				<box>
@@ -311,18 +302,6 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				</textElement>
 				<textFieldExpression><![CDATA[$F{Due_Date-invoice_date_due}]]></textFieldExpression>
 			</textField>
-			<textField pattern="#,#00.00#;(#,#00.00#-)">
-				<reportElement x="470" y="0" width="80" height="20" uuid="e8bea303-7a64-4452-8cbd-2ae15b382da3">
-					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="fad2b8be-b9d1-4265-8d32-1982c00d5eb8"/>
-				</reportElement>
-				<box>
-					<bottomPen lineWidth="0.5"/>
-				</box>
-				<textElement textAlignment="Right" verticalAlignment="Middle">
-					<font size="8"/>
-				</textElement>
-				<textFieldExpression><![CDATA[$V{outstanding}]]></textFieldExpression>
-			</textField>
 		</band>
 	</detail>
 	<pageFooter>
@@ -360,7 +339,7 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 	<summary>
 		<band height="160" splitType="Stretch">
 			<textField pattern="#,#00.###;(#,#00.###-)">
-				<reportElement x="470" y="0" width="80" height="20" uuid="12f22b10-d8f4-4f94-b2d0-993fda701e9e"/>
+				<reportElement x="460" y="0" width="90" height="20" uuid="12f22b10-d8f4-4f94-b2d0-993fda701e9e"/>
 				<box>
 					<leftPen lineWidth="0.0"/>
 					<bottomPen lineWidth="0.0"/>
@@ -369,10 +348,10 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textElement textAlignment="Right" verticalAlignment="Middle">
 					<font size="8"/>
 				</textElement>
-				<textFieldExpression><![CDATA[$V{total_outstanding}]]></textFieldExpression>
+				<textFieldExpression><![CDATA[$V{grand_total}]]></textFieldExpression>
 			</textField>
 			<staticText>
-				<reportElement x="0" y="0" width="470" height="20" uuid="4a2c174b-a7a3-4620-8bd3-6dd57eee600d">
+				<reportElement x="0" y="0" width="460" height="20" uuid="4a2c174b-a7a3-4620-8bd3-6dd57eee600d">
 					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
 				</reportElement>
 				<box>
@@ -396,35 +375,43 @@ Jika dokumen sudah diterima mohon untuk ditanda tangani, dicap, dan discan/foto
 				<textElement textAlignment="Left" verticalAlignment="Top">
 					<font size="10"/>
 				</textElement>
-				<text><![CDATA[Pembayaran melalui Transfer ke :

-

-BCA

-PT. Indoteknik Dotcom Gemilang

-8870-4000-81

-

-Mandiri

-PT. Indoteknik Dotcom Gemilang

+				<text><![CDATA[Pembayaran melalui Transfer ke :
+
+BCA
+PT. Indoteknik Dotcom Gemilang
+8870-4000-81
+
+Mandiri
+PT. Indoteknik Dotcom Gemilang
 155-0067-6869-75]]></text>
 			</staticText>
 			<staticText>
 				<reportElement x="440" y="31" width="90" height="107" uuid="a5d971ef-fa8e-4ced-b7b9-cf3861e26a2d"/>
-				<text><![CDATA[Yang menerima,

-

-

-

-

-(                          )

+				<text><![CDATA[Yang menerima,
+
+
+
+
+(                          )
      Nama Jelas]]></text>
 			</staticText>
 			<staticText>
-				<reportElement x="240" y="31" width="110" height="108" uuid="2d02021f-ffd3-4694-917d-0bf584038278"/>
+				<reportElement x="240" y="31" width="110" height="19" uuid="2d02021f-ffd3-4694-917d-0bf584038278"/>
 				<text><![CDATA[Yang menyerahkan,

 

 

 

 

-(                          )

-     Nama Jelas]]></text>
+]]></text>
+			</staticText>
+			<image>
+				<reportElement x="231" y="51" width="126" height="59" uuid="7ddbd82e-5e16-4e91-8220-26b35cef48db"/>
+				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/1839336"]]></imageExpression>
+			</image>
+			<staticText>
+				<reportElement x="248" y="110" width="82" height="20" uuid="526748bf-97a4-470e-a0a9-4530098f3048"/>
+				<textElement textAlignment="Center"/>
+				<text><![CDATA[Manzilah Septia]]></text>
 			</staticText>
 		</band>
 	</summary>