add custom report collective

1 files changed, 247 insertions, 0 deletions

diff --git a/jasper_reports/custom_reports/INPOIS.jrxml b/jasper_reports/custom_reports/INPOIS.jrxml
new file mode 100644
index 0000000..33cfcc8
--- /dev/null
+++ b/jasper_reports/custom_reports/INPOIS.jrxml
@@ -0,0 +1,247 @@
+<?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="INPOIS" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6070e82b-8dfc-4fa9-927b-4b109e551f09">
+	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="invoice_new.jrdax"/>
+	<property name="ODOO_RELATIONS">
+		<![CDATA[['invoice_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="Name-name" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Name-name"/>
+		<fieldDescription><![CDATA[/data/record/Partner-partner_id/Name-name]]></fieldDescription>
+	</field>
+	<field name="Street-street" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_id/Street-street"/>
+		<fieldDescription><![CDATA[/data/record/Partner-partner_id/Street-street]]></fieldDescription>
+	</field>
+	<field name="Invoice_Bill_Date-invoice_date" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Invoice_Bill_Date-invoice_date"/>
+		<fieldDescription><![CDATA[/data/record/Invoice_Bill_Date-invoice_date]]></fieldDescription>
+	</field>
+	<field name="Due_Date-invoice_date_due" class="java.sql.Date">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Due_Date-invoice_date_due"/>
+		<fieldDescription><![CDATA[/data/record/Due_Date-invoice_date_due]]></fieldDescription>
+	</field>
+	<field name="Origin-invoice_origin" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Origin-invoice_origin"/>
+		<fieldDescription><![CDATA[/data/record/Origin-invoice_origin]]></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="Tax_amount_by_group-amount_by_group" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Tax_amount_by_group-amount_by_group"/>
+		<fieldDescription><![CDATA[/data/record/Tax_amount_by_group-amount_by_group]]></fieldDescription>
+	</field>
+	<field name="Untaxed_Amount-amount_untaxed" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Untaxed_Amount-amount_untaxed"/>
+		<fieldDescription><![CDATA[/data/record/Untaxed_Amount-amount_untaxed]]></fieldDescription>
+	</field>
+	<field name="Total-amount_total" class="java.lang.String">
+		<property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total-amount_total"/>
+		<fieldDescription><![CDATA[/data/record/Total-amount_total]]></fieldDescription>
+	</field>
+	<background>
+		<band splitType="Stretch"/>
+	</background>
+	<title>
+		<band height="260" splitType="Stretch">
+			<staticText>
+				<reportElement x="284" y="206" width="132" height="20" forecolor="#3D5959" uuid="6fa7a9d7-9d72-42df-98d6-c3d4eaf65465"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Source:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="139" y="206" width="132" height="20" forecolor="#3D5959" uuid="8d780816-aa12-43d9-9ec0-c5fadbac26fa"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Due Date:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="0" y="35" width="270" height="70" uuid="8f3b05d6-7057-4a60-a143-08c12caa64bd"/>
+				<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>
+			<image>
+				<reportElement x="0" y="1" width="126" height="33" uuid="fe68367d-328f-4bb4-9b67-3543b35187c8"/>
+				<imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression>
+			</image>
+			<line>
+				<reportElement x="-3" y="34" width="560" height="1" uuid="c397fccc-69ea-462f-9f41-97e3bc05856f"/>
+			</line>
+			<staticText>
+				<reportElement x="1" y="206" width="108" height="20" forecolor="#3D5959" uuid="6432b56e-1cd4-4c68-9a7b-d1276135f472"/>
+				<textElement verticalAlignment="Bottom">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Date:]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="450" y="206" width="104" height="20" forecolor="#3D5959" uuid="5384afef-c086-40c8-ba25-225cc73504f1"/>
+				<textElement verticalAlignment="Middle">
+					<font size="11" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Reference:]]></text>
+			</staticText>
+			<textField>
+				<reportElement x="380" y="80" width="174" height="25" uuid="78635647-2eae-46d9-ba3c-78f897dea343"/>
+				<textElement verticalAlignment="Bottom"/>
+				<textFieldExpression><![CDATA[$F{Name-name}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="381" y="110" width="173" height="96" uuid="830a55ef-d9e5-4839-9666-2b3f1299b8e8"/>
+				<textFieldExpression><![CDATA[$F{Street-street}]]></textFieldExpression>
+			</textField>
+			<textField pattern="M/d/yy">
+				<reportElement x="1" y="230" width="108" height="30" uuid="48d4b33c-43cb-4716-a507-346e0aece950"/>
+				<textFieldExpression><![CDATA[$F{Invoice_Bill_Date-invoice_date}]]></textFieldExpression>
+			</textField>
+			<textField pattern="M/d/yy">
+				<reportElement x="140" y="230" width="131" height="30" uuid="a79b4690-3af1-440f-80ef-9b6089082754"/>
+				<textFieldExpression><![CDATA[$F{Due_Date-invoice_date_due}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="284" y="230" width="132" height="30" uuid="d011fdd6-149f-4813-b5aa-34d64eca1bd3"/>
+				<textFieldExpression><![CDATA[$F{Origin-invoice_origin}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="450" y="230" width="104" height="30" uuid="ecd24b9f-3d67-4bd6-b05c-2ed0cd37a5d7"/>
+				<textFieldExpression><![CDATA[$F{Reference-ref}]]></textFieldExpression>
+			</textField>
+			<textField>
+				<reportElement x="0" y="180" width="380" height="30" forecolor="#AF171D" uuid="52d73f28-1315-4676-b56f-96d4c0ca1b55"/>
+				<textElement>
+					<font size="20"/>
+				</textElement>
+				<textFieldExpression><![CDATA["Invoice " + $F{Number-name}]]></textFieldExpression>
+			</textField>
+		</band>
+	</title>
+	<columnHeader>
+		<band height="29" splitType="Stretch"/>
+	</columnHeader>
+	<detail>
+		<band height="63" splitType="Stretch"/>
+	</detail>
+	<pageFooter>
+		<band height="54" splitType="Stretch">
+			<textField>
+				<reportElement x="180" y="20" width="100" height="30" uuid="06ca71f9-46fd-43bc-a149-0de473027798"/>
+				<textElement textAlignment="Right"/>
+				<textFieldExpression><![CDATA["Page " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+			<staticText>
+				<reportElement x="231" y="5" width="120" height="14" uuid="31a48890-7bd8-4804-9932-27f1f8899ba1"/>
+				<text><![CDATA[https://Indoteknik.com]]></text>
+			</staticText>
+			<line>
+				<reportElement x="-1" y="2" width="560" height="1" uuid="699e7e83-77e4-46d6-a26c-69dc05eb114f"/>
+			</line>
+			<textField evaluationTime="Report">
+				<reportElement x="280" y="20" width="100" height="30" uuid="59ba3265-aa18-4176-ad05-8a7240ded7e4"/>
+				<textElement textAlignment="Left"/>
+				<textFieldExpression><![CDATA[" of " + $V{PAGE_NUMBER}]]></textFieldExpression>
+			</textField>
+		</band>
+	</pageFooter>
+	<summary>
+		<band height="285" splitType="Stretch">
+			<staticText>
+				<reportElement x="381" y="93" width="56" height="20" forecolor="#AF171D" uuid="180b29b5-b1c1-47fa-a19b-ac23683046d0">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Total :]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="381" y="13" width="56" height="20" forecolor="#AF171D" uuid="d399d420-cfa9-4774-b0cc-7fa02edab5f1">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Subtotal :]]></text>
+			</staticText>
+			<line>
+				<reportElement x="381" y="83" width="176" height="1" uuid="a7c77e1f-acb0-408d-a399-84c3fa7ebdf6"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="381" y="53" width="56" height="20" uuid="f2f898b5-1e92-49c5-a722-c5a0d3e943a9">
+					<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ccdad13f-2e83-406d-b470-4aa25d3b646a"/>
+				</reportElement>
+				<box>
+					<pen lineWidth="1.0" lineStyle="Solid"/>
+					<topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+					<rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
+				</box>
+				<textElement textAlignment="Right" verticalAlignment="Middle">
+					<font size="10" isBold="true"/>
+				</textElement>
+				<text><![CDATA[Taxes :]]></text>
+			</staticText>
+			<line>
+				<reportElement x="381" y="3" width="176" height="1" uuid="85e258a5-d100-4f62-bdab-6487471fb2d9"/>
+				<graphicElement>
+					<pen lineWidth="1.0"/>
+				</graphicElement>
+			</line>
+			<line direction="BottomUp">
+				<reportElement x="381" y="43" width="176" height="1" uuid="39009b84-4e3a-4199-ae95-6309a5dedf55"/>
+				<graphicElement>
+					<pen lineWidth="0.5"/>
+				</graphicElement>
+			</line>
+			<staticText>
+				<reportElement x="1" y="140" width="380" height="145" uuid="a5dc45e4-dd04-4c79-a601-e66450361769"/>
+				<text><![CDATA[

+1. Kirimkan Data NPWP & SPPKP pada saat pertama kali melakukan pemesanan ke finance@indoteknik.co.id.

+2. Penawaran ini memiliki jangka waktu, harga dan stok tidak mengikat.

+3. Pembelian tidak dapat dikembalikan.

+

+Data Bank PT. INDOTEKNIK DOTCOM GEMILANG

+BCA CAB. PURI BOTANICAL Acc. No. 8870 4000 81

+Pembayaran giro/cek dinyatakan lunas hanya setelah pencairan.

+Biaya administrasi bank dibebankan ke konsumen]]></text>
+			</staticText>
+			<staticText>
+				<reportElement x="1" y="114" width="379" height="30" uuid="e4a164cb-2efe-41c7-81ba-d2f217ddf881"/>
+				<text><![CDATA[Please use the following communication for your payment : 

+]]></text>
+			</staticText>
+		</band>
+	</summary>
+</jasperReport>