diff options
Diffstat (limited to 'jasper_reports/custom_reports/Customer Comision.jrxml')
| -rw-r--r-- | jasper_reports/custom_reports/Customer Comision.jrxml | 571 |
1 files changed, 402 insertions, 169 deletions
diff --git a/jasper_reports/custom_reports/Customer Comision.jrxml b/jasper_reports/custom_reports/Customer Comision.jrxml index 820a595..df975b9 100644 --- a/jasper_reports/custom_reports/Customer Comision.jrxml +++ b/jasper_reports/custom_reports/Customer Comision.jrxml @@ -1,289 +1,522 @@ <?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="Customer Comision" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="267dd142-45c8-4e58-bdae-72f60761b287"> - <property name="com.jaspersoft.studio.data.defaultdataadapter" value="Customer Comision"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="cccuki.jrdax"/> <property name="ODOO_RELATIONS"> <![CDATA[['commision_lines']]]> </property> <queryString language="XPath"> <![CDATA[]]> </queryString> - <field name="Document No" class="java.lang.String"> + <field name="Partner" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_ids/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Partner-partner_ids/Display_Name-display_name]]></fieldDescription> + </field> + <field name="INVOICE NO" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Group_Invoice_Number-grouped_invoice_number"/> + <fieldDescription><![CDATA[/data/record/Group_Invoice_Number-grouped_invoice_number]]></fieldDescription> + </field> + <field name="SO NO" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Group_SO_Number-grouped_so_number"/> + <fieldDescription><![CDATA[/data/record/Group_SO_Number-grouped_so_number]]></fieldDescription> + </field> + <field name="Nominal" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/> + <fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription> + </field> + <field name="Terbilang" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount_Text-commision_amt_text"/> + <fieldDescription><![CDATA[/data/record/Commision_Amount_Text-commision_amt_text]]></fieldDescription> + </field> + <field name="Bank" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Bank-bank_name"/> + <fieldDescription><![CDATA[/data/record/Bank-bank_name]]></fieldDescription> + </field> + <field name="Account No" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Account_No-bank_account"/> + <fieldDescription><![CDATA[/data/record/Account_No-bank_account]]></fieldDescription> + </field> + <field name="Account Name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Account_Name-account_name"/> + <fieldDescription><![CDATA[/data/record/Account_Name-account_name]]></fieldDescription> + </field> + <field name="Keterangan" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Keterangan-note_transfer"/> + <fieldDescription><![CDATA[/data/record/Keterangan-note_transfer]]></fieldDescription> + </field> + <field name="Approved_By-approved_by" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Approved_By-approved_by"/> + <fieldDescription><![CDATA[/data/record/Approved_By-approved_by]]></fieldDescription> + </field> + <field name="Document_No-number" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Document_No-number"/> <fieldDescription><![CDATA[/data/record/Document_No-number]]></fieldDescription> </field> - <field name="Partner Name" class="java.lang.String"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Partner-partner_ids/Name-name"/> - <fieldDescription><![CDATA[/data/record/Partner-partner_ids/Name-name]]></fieldDescription> + <field name="Date_Approved_Accounting-date_approved_accounting" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Accounting-date_approved_accounting"/> + <fieldDescription><![CDATA[/data/record/Date_Approved_Accounting-date_approved_accounting]]></fieldDescription> + </field> + <field name="Date_Approved_Marketing-date_approved_marketing" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Marketing-date_approved_marketing"/> + <fieldDescription><![CDATA[/data/record/Date_Approved_Marketing-date_approved_marketing]]></fieldDescription> </field> - <field name="Partner Name Line" class="java.lang.String"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Customer-partner_id/Name-name"/> - <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Customer-partner_id/Name-name]]></fieldDescription> + <field name="Date_Approved_Pimpinan-date_approved_pimpinan" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Pimpinan-date_approved_pimpinan"/> + <fieldDescription><![CDATA[/data/record/Date_Approved_Pimpinan-date_approved_pimpinan]]></fieldDescription> </field> - <field name="Invoice Name" class="java.lang.String"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name"/> - <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Invoice-invoice_id/Number-name]]></fieldDescription> + <field name="Date_Approved_Sales-date_approved_sales" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_Approved_Sales-date_approved_sales"/> + <fieldDescription><![CDATA[/data/record/Date_Approved_Sales-date_approved_sales]]></fieldDescription> </field> - <field name="DPP" class="java.math.BigDecimal"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/DPP-dpp"/> - <fieldDescription><![CDATA[/data/record/Lines-commision_lines/DPP-dpp]]></fieldDescription> + <field name="Position_Accounting-position_accounting" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Accounting-position_accounting"/> + <fieldDescription><![CDATA[/data/record/Position_Accounting-position_accounting]]></fieldDescription> </field> - <field name="Total Margin" class="java.math.BigDecimal"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/Total_Margin-total_percent_margin"/> - <fieldDescription><![CDATA[/data/record/Lines-commision_lines/Total_Margin-total_percent_margin]]></fieldDescription> + <field name="Position_Marketing-position_marketing" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Marketing-position_marketing"/> + <fieldDescription><![CDATA[/data/record/Position_Marketing-position_marketing]]></fieldDescription> </field> - <field name="Status Invoice" class="java.lang.String"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Lines-commision_lines/InvStatus-state"/> - <fieldDescription><![CDATA[/data/record/Lines-commision_lines/InvStatus-state]]></fieldDescription> + <field name="Position_Pimpinan-position_pimpinan" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Pimpinan-position_pimpinan"/> + <fieldDescription><![CDATA[/data/record/Position_Pimpinan-position_pimpinan]]></fieldDescription> </field> - <field name="Date From" class="java.sql.Date"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_From-date_from"/> - <fieldDescription><![CDATA[/data/record/Date_From-date_from]]></fieldDescription> + <field name="Position_Sales-position_sales" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Position_Sales-position_sales"/> + <fieldDescription><![CDATA[/data/record/Position_Sales-position_sales]]></fieldDescription> </field> - <field name="Date To" class="java.sql.Date"> - <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Date_To-date_to"/> - <fieldDescription><![CDATA[/data/record/Date_To-date_to]]></fieldDescription> + <field name="Display_Name-display_name" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Sales-sales_id/Display_Name-display_name"/> + <fieldDescription><![CDATA[/data/record/Sales-sales_id/Display_Name-display_name]]></fieldDescription> </field> - <field name="Total DPP" class="java.math.BigDecimal"> + <field name="Created_on-create_date" class="java.sql.Date"> + <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="Notes_Finnance-note_finnance" class="java.lang.String"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Notes_Finnance-note_finnance"/> + <fieldDescription><![CDATA[/data/record/Notes_Finnance-note_finnance]]></fieldDescription> + </field> + <field name="Total_DPP-total_dpp" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Total_DPP-total_dpp"/> <fieldDescription><![CDATA[/data/record/Total_DPP-total_dpp]]></fieldDescription> </field> - <field name="Commision Amount" class="java.math.BigDecimal"> + <field name="Commision_Amount-commision_amt" class="java.math.BigDecimal"> <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/> <fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription> </field> - <field name="Commision %" class="java.math.BigDecimal"> + <field name="Commision__-commision_percent" class="java.lang.String"> <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision__-commision_percent"/> <fieldDescription><![CDATA[/data/record/Commision__-commision_percent]]></fieldDescription> </field> - <variable name="DPP" class="java.math.BigDecimal" incrementType="Column"> - <variableExpression><![CDATA[$F{DPP}]]></variableExpression> - </variable> - <variable name="Total_Margin" class="java.math.BigDecimal" incrementType="Column"> - <variableExpression><![CDATA[$F{Total Margin}]]></variableExpression> - </variable> - <variable name="Commision_%" class="java.math.BigDecimal" incrementType="Column"> - <variableExpression><![CDATA[$F{Commision %}]]></variableExpression> - </variable> - <variable name="Commision_Amount" class="java.math.BigDecimal" incrementType="Column"> - <variableExpression><![CDATA[$F{Commision Amount}]]></variableExpression> - </variable> - <variable name="Total DPP" class="java.math.BigDecimal" incrementType="Column"> - <variableExpression><![CDATA[$F{Total DPP}]]></variableExpression> - </variable> + <field name="Commision_Amount-commision_amt_1" class="java.lang.Float"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/> + <fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription> + </field> + <field name="Commision_Amount-commision_amt_2" class="java.math.BigDecimal"> + <property name="net.sf.jasperreports.xpath.field.expression" value="/data/record/Commision_Amount-commision_amt"/> + <fieldDescription><![CDATA[/data/record/Commision_Amount-commision_amt]]></fieldDescription> + </field> <background> <band splitType="Stretch"/> </background> <title> - <band height="204" splitType="Stretch"> + <band height="90" splitType="Stretch"> + <image> + <reportElement x="0" y="1" width="151" height="49" uuid="c596ef6c-086a-4136-a96d-7e0ba6a369ca"/> + <imageExpression><![CDATA["https://erp.indoteknik.com/api/image/ir.attachment/datas/2135765"]]></imageExpression> + </image> + <staticText> + <reportElement x="131" y="55" width="293" height="30" uuid="fb2717c3-16e5-498b-a9a4-658c12e80cce"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <box> + <bottomPen lineWidth="1.75"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="14" isBold="true"/> + </textElement> + <text><![CDATA[PENGAJUAN KOMISI EKSTERNAL]]></text> + </staticText> + <textField> + <reportElement x="418" y="32" width="157" height="25" uuid="23a30f84-be11-43dc-8469-6e5a3affbd50"/> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="14" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$F{Document_No-number}]]></textFieldExpression> + </textField> <textField> - <reportElement x="151" y="0" width="253" height="50" uuid="ad497d39-25aa-4e99-888a-6e3221d070e4"/> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Document No}]]></textFieldExpression> + <reportElement x="418" y="12" width="157" height="20" uuid="f5142e3c-8a9b-49b0-a3d6-250480d08d06"/> + <textElement> + <font size="11"/> + </textElement> + <textFieldExpression><![CDATA[$F{Display_Name-display_name}]]></textFieldExpression> + </textField> + <textField pattern="MMM d, yyyy h:mm:ss a"> + <reportElement x="418" y="58" width="157" height="30" uuid="2d713832-ad16-4ab5-977b-c473950aa3e7"/> + <textElement> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Created_on-create_date}]]></textFieldExpression> </textField> <staticText> - <reportElement x="1" y="55" width="100" height="30" uuid="3e8e85ed-c77c-4377-80b4-f8817995f545"> + <reportElement x="418" y="-18" width="157" height="30" uuid="0d135bef-745f-4466-9d6d-682350dacd30"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Partner Name ]]></text> + <text><![CDATA[Diajukan Oleh Sales:]]></text> </staticText> - <textField> - <reportElement x="105" y="55" width="455" height="30" uuid="d859b5fd-d805-4c86-a1c7-617fa72a3a25"> + </band> + </title> + <columnHeader> + <band height="679"> + <staticText> + <reportElement x="6" y="31" width="100" height="57" uuid="84e40804-8a4c-45b7-989d-a494f7bab127"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Partner Name}]]></textFieldExpression> - </textField> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[No. SO]]></text> + </staticText> <staticText> - <reportElement x="1" y="90" width="100" height="30" uuid="850d8de0-d90d-4d7b-a6cf-c7279c1d49da"> + <reportElement x="6" y="1" width="100" height="30" uuid="2ebffff5-278d-4d33-a990-e0e250c49025"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Date From ]]></text> + <text><![CDATA[Nama Penerima]]></text> </staticText> <staticText> - <reportElement x="360" y="91" width="66" height="30" uuid="5f75f83a-e4bf-441d-94dd-4bb0a6b98ef6"> + <reportElement x="6" y="88" width="100" height="58" uuid="555a644d-6776-467f-96a3-054353bc29a1"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Date To]]></text> + <text><![CDATA[No. Invoice]]></text> </staticText> <staticText> - <reportElement x="1" y="127" width="100" height="30" uuid="ee030619-4aa4-4c1b-bf18-94b8a4b77578"> + <reportElement x="5" y="146" width="100" height="30" uuid="e267a3de-4e3f-4efa-97c3-dd08cad87556"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Commision % ]]></text> + <text><![CDATA[Keterangan :]]></text> </staticText> <staticText> - <reportElement x="0" y="167" width="100" height="30" uuid="9a60a3ae-72dc-4a06-84be-3ecf879bc7be"> + <reportElement x="20" y="176" width="225" height="30" uuid="99d2f90f-bb3c-452a-a137-9d1319ae3847"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Commision Amount ]]></text> + <text><![CDATA[PT. Indoteknik Dotcom Gemilang]]></text> </staticText> <staticText> - <reportElement x="360" y="164" width="66" height="30" uuid="e1c94634-0398-4d98-843e-8e2a3286b427"> + <reportElement x="6" y="206" width="154" height="30" uuid="03195972-9b6f-4759-abe1-3a828c4c89bc"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <textElement textAlignment="Left" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="12" isBold="true"/> </textElement> - <text><![CDATA[Total DPP ]]></text> + <text><![CDATA[Jumlah yang penerimaan ]]></text> </staticText> - <textField pattern="MMMM d, yyyy"> - <reportElement x="105" y="90" width="100" height="30" uuid="7b9631c0-b30e-4e5d-9061-768bfe786b8d"/> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Date From}]]></textFieldExpression> + <staticText> + <reportElement x="6" y="227" width="154" height="30" uuid="c76fb1a8-ad22-413b-8211-bdc793d550ed"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Nominal ]]></text> + </staticText> + <staticText> + <reportElement x="6" y="258" width="154" height="30" uuid="5aa87439-2f82-4bb1-812d-0a2964bff8f0"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Terbilang]]></text> + </staticText> + <staticText> + <reportElement x="6" y="293" width="154" height="30" uuid="d1604fef-020b-4995-8ccf-709ffb23d3cf"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Keterangan Penerimaan :]]></text> + </staticText> + <staticText> + <reportElement x="19" y="316" width="225" height="30" uuid="54d1a728-4507-45a8-bd2f-7c18df87f244"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Transfer Via Bank]]></text> + </staticText> + <ellipse> + <reportElement x="29" y="354" width="11" height="10" backcolor="#000000" uuid="654a71b1-2fa9-4e6e-b4c0-589792610243"/> + </ellipse> + <staticText> + <reportElement x="50" y="348" width="130" height="19" uuid="b68e58d0-0963-4c1a-8b8c-48ab389a49aa"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Bank]]></text> + </staticText> + <ellipse> + <reportElement x="29" y="384" width="11" height="10" backcolor="#000000" uuid="d70730c7-a2cc-4ac6-be95-8d50d24ac54a"/> + </ellipse> + <staticText> + <reportElement x="50" y="378" width="130" height="19" uuid="c6774fa3-5aad-4e1f-8582-c0ee2d95fa1f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Nama Account]]></text> + </staticText> + <ellipse> + <reportElement x="29" y="414" width="11" height="10" backcolor="#000000" uuid="7dc9788f-3a2d-45e4-b16b-204ddda21f7a"/> + </ellipse> + <staticText> + <reportElement x="50" y="406" width="130" height="22" uuid="6a3d8b74-2440-4b69-b957-cfab743f76d6"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[No. Rekening]]></text> + </staticText> + <staticText> + <reportElement x="6" y="430" width="154" height="30" uuid="7c69e54b-6885-4957-940f-61837dffb454"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="12" isBold="true"/> + </textElement> + <text><![CDATA[Keterangan Penerimaan :]]></text> + </staticText> + <staticText> + <reportElement x="340" y="480" width="170" height="30" uuid="bbaa03e0-bf1f-4949-ac79-a3a00e739f5f"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="11" isBold="true"/> + </textElement> + <text><![CDATA[Approved By System:]]></text> + </staticText> + <textField> + <reportElement x="106" y="1" width="468" height="30" uuid="6b5b90d1-6d70-492c-b999-2734271b3a39"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Partner}]]></textFieldExpression> </textField> - <textField pattern="MMMM d, yyyy"> - <reportElement x="430" y="91" width="100" height="30" uuid="f066682f-eabd-477e-8895-8455f49d2579"/> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Date To}]]></textFieldExpression> + <textField> + <reportElement x="106" y="88" width="468" height="58" uuid="8ec34349-c8bf-46f9-9738-b1fc81a8f85a"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[": " + $F{INVOICE NO}]]></textFieldExpression> </textField> - <textField pattern="#,#00.00#;(#,#00.00#-)"> - <reportElement x="430" y="164" width="124" height="30" uuid="6983367e-a6f1-409f-be98-3cfa7f6f77b3"/> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Total DPP}]]></textFieldExpression> + <textField> + <reportElement x="106" y="31" width="468" height="58" uuid="328c0a2f-7ca8-41b8-ab7e-f740e2a7aaa9"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[": " + $F{SO NO}]]></textFieldExpression> </textField> - <textField pattern="#,#00.00#;(#,#00.00#-)"> - <reportElement x="105" y="162" width="164" height="30" uuid="8c626b25-555a-4681-b491-0ab1d0321cde"/> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[ $F{Commision Amount}]]></textFieldExpression> + <textField> + <reportElement x="160" y="258" width="415" height="30" uuid="ab9ced78-6663-4ea7-9ed7-20181a05f64d"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Terbilang}]]></textFieldExpression> </textField> <textField> - <reportElement x="105" y="127" width="100" height="30" uuid="e2ebe3a4-f126-440b-b057-96126ad5098e"/> - <textElement textAlignment="Left" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Commision %} + " %"]]></textFieldExpression> + <reportElement x="180" y="348" width="394" height="19" uuid="fd758a7a-c789-4373-ab74-648d2d8c18c3"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Bank}]]></textFieldExpression> </textField> - </band> - </title> - <columnHeader> - <band height="30" splitType="Stretch"> - <staticText> - <reportElement x="0" y="0" width="156" height="30" uuid="17571371-537e-4cb7-a11c-db822e33e074"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/> - </reportElement> + <textField> + <reportElement x="180" y="406" width="394" height="22" uuid="559cfb4b-8348-465e-9136-d103de29a366"/> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="1.0"/> </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Account No}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="180" y="378" width="394" height="19" uuid="40d0fbb2-7089-4c58-ab1d-988120be4109"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Account Name}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="160" y="430" width="414" height="30" uuid="476f2174-e622-4246-b5ad-f16610aa55c9"/> + <box> + <bottomPen lineWidth="1.0"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[": " + $F{Keterangan}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="470" y="630" width="84" height="20" uuid="177c1bf7-1e57-4a7d-9008-684efeaf3a80"/> <textElement textAlignment="Center" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="8"/> </textElement> - <text><![CDATA[Customer]]></text> - </staticText> + <textFieldExpression><![CDATA[$F{Date_Approved_Accounting-date_approved_accounting}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="347" y="630" width="84" height="20" uuid="9c70e307-2abd-4bb9-8f0e-895ea9c7afa2"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Date_Approved_Marketing-date_approved_marketing}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="470" y="531" width="84" height="20" uuid="40f198dd-6ad4-4c8a-b161-61df3730f692"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Date_Approved_Pimpinan-date_approved_pimpinan}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="347" y="531" width="84" height="20" uuid="a5d9a20d-330b-4269-9048-ac756f3959be"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Date_Approved_Sales-date_approved_sales}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="470" y="650" width="84" height="20" uuid="d7ab58c7-3853-4ef4-9da9-8170eae41343"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Position_Accounting-position_accounting}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="347" y="650" width="84" height="20" uuid="f45ed865-8398-4520-b79d-a394a935d71f"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Position_Marketing-position_marketing}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="347" y="551" width="84" height="20" uuid="4445689c-e1fb-4290-ad5c-6f340c5253cd"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Position_Sales-position_sales}]]></textFieldExpression> + </textField> + <textField> + <reportElement x="470" y="551" width="84" height="20" uuid="5862a49e-aeb2-4c46-9155-2562a90eaf66"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="8"/> + </textElement> + <textFieldExpression><![CDATA[$F{Position_Pimpinan-position_pimpinan}]]></textFieldExpression> + </textField> <staticText> - <reportElement x="156" y="0" width="160" height="30" uuid="2adc8d84-e0bd-4ce2-bc82-9b80178a78e6"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/> + <reportElement x="347" y="510" width="84" height="20" uuid="6f80b179-970d-489a-95cf-7ea7fc826af1"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="1.75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="9" isBold="true"/> </textElement> - <text><![CDATA[Invoice]]></text> + <text><![CDATA[Novita Mayasari]]></text> </staticText> <staticText> - <reportElement x="316" y="0" width="64" height="30" uuid="4bde0bed-2421-4557-a45f-5a665f2ba080"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/> + <reportElement x="470" y="510" width="84" height="20" uuid="2606b5d5-8479-464d-ae32-85baa2857309"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="1.75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="9" isBold="true"/> </textElement> - <text><![CDATA[Status Invoice]]></text> + <text><![CDATA[Akbar Prabawa]]></text> </staticText> <staticText> - <reportElement x="380" y="0" width="75" height="30" uuid="9a00a7e1-900b-4d6b-bdeb-3b7f0f7e6a5d"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="70d6c4bd-60d2-4606-b48b-2c2f9e15ff92"/> + <reportElement x="347" y="610" width="84" height="20" uuid="3dd59c77-0427-43d8-a838-c0e29b40cbce"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="1.75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="9" isBold="true"/> </textElement> - <text><![CDATA[DPP]]></text> + <text><![CDATA[Stefanus Darren]]></text> </staticText> <staticText> - <reportElement x="455" y="0" width="100" height="30" uuid="f4a50d94-89b5-4f23-818d-fadcc0f34092"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0917b22c-3856-447c-ac45-689148535ef7"/> + <reportElement x="470" y="610" width="84" height="20" uuid="ee4f1a9c-9318-48b7-8bf0-4c8ad9478809"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="1.75"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> - <font isBold="true"/> + <font size="9" isBold="true"/> </textElement> - <text><![CDATA[Total Margin]]></text> + <text><![CDATA[Tania Aji Asri]]></text> </staticText> - </band> - </columnHeader> - <detail> - <band height="43" splitType="Stretch"> <textField> - <reportElement x="0" y="0" width="156" height="42" uuid="20886f7d-e695-42f4-8274-7e7424c74a6f"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e50ddf3c-3644-4aa9-ae22-3d13c50042cc"/> - </reportElement> - <box> - <bottomPen lineWidth="0.75"/> - </box> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Partner Name Line}]]></textFieldExpression> + <reportElement x="1" y="510" width="308" height="168" uuid="34d3e4b9-8e14-4d72-9277-df79b4ca7e88"/> + <textFieldExpression><![CDATA[$F{Notes_Finnance-note_finnance}]]></textFieldExpression> </textField> - <textField> - <reportElement x="156" y="0" width="160" height="42" uuid="1153f0c3-8080-4f61-8fb7-21d743546826"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="2a258251-88c2-4d37-8cca-4bbc12be0e70"/> + <staticText> + <reportElement x="1" y="480" width="100" height="30" uuid="ad926945-9613-40ae-a17e-642359cb8b79"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> <box> - <bottomPen lineWidth="0.75"/> + <bottomPen lineWidth="0.0"/> </box> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Invoice Name}]]></textFieldExpression> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="11" isBold="true" isUnderline="false"/> + </textElement> + <text><![CDATA[Note Finance :]]></text> + </staticText> + <textField pattern="#,#00.00#;#,#00.00#-"> + <reportElement x="180" y="227" width="394" height="30" uuid="50e6f714-8b62-44e9-b2a5-df3876138c7e"/> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$F{Commision_Amount-commision_amt_2}]]></textFieldExpression> </textField> - <textField> - <reportElement x="316" y="0" width="64" height="42" uuid="c702275c-c708-4f27-9f81-fb40ccaefa7f"> - <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c696cbe2-085a-4130-9dfc-976622aff9d4"/> + <staticText> + <reportElement x="160" y="227" width="20" height="30" uuid="6215e691-9bbf-4f3f-a875-dee58d252f33"> + <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5fc91896-e17c-432f-bb0a-8cfc2e7549e2"/> </reportElement> - <box> - <bottomPen lineWidth="0.75"/> - </box> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$F{Status Invoice}]]></textFieldExpression> - </textField> - <textField pattern="#,#00.00#;(#,#00.00#-)"> - <reportElement x="380" y="0" width="75" height="42" uuid="f55b5f39-7f6e-4d42-8cfb-bdb990b4991e"/> - <box> - <bottomPen lineWidth="0.75"/> - </box> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$V{DPP}]]></textFieldExpression> - </textField> - <textField> - <reportElement x="455" y="0" width="100" height="42" uuid="fb2ba136-db4c-4c37-ab43-9616acf30398"/> - <box> - <bottomPen lineWidth="0.75"/> - </box> - <textElement textAlignment="Center" verticalAlignment="Middle"/> - <textFieldExpression><![CDATA[$V{Total_Margin}]]></textFieldExpression> - </textField> + <textElement textAlignment="Left" verticalAlignment="Middle"> + <font size="10" isBold="false"/> + </textElement> + <text><![CDATA[: Rp ]]></text> + </staticText> </band> - </detail> - <summary> - <band height="75" splitType="Stretch"/> - </summary> + </columnHeader> </jasperReport> |