From 1ca3b3df3421961caec3b747a364071c80f5c7da Mon Sep 17 00:00:00 2001
From: stephanchrst <stephanchrst@gmail.com>
Date: Tue, 10 May 2022 17:14:58 +0700
Subject: initial commit

---
 .../views/account_financial_report_data.xml        | 71 ++++++++++++++++
 account_reports_xlsx/views/action_manager.xml      |  9 ++
 .../views/financial_report_wizard_view.xml         | 16 ++++
 .../views/financial_report_xls_view.xml            | 15 ++++
 .../views/general_ledger_report_view.xml           | 15 ++++
 .../views/general_ledger_report_wizard_view.xml    | 15 ++++
 .../views/partner_ledgerreport.xml                 | 96 ++++++++++++++++++++++
 account_reports_xlsx/views/report.xml              | 17 ++++
 .../views/report_agedpartnerbalance.xml            | 95 +++++++++++++++++++++
 .../views/supplier_aging_report_view.xml           | 85 +++++++++++++++++++
 10 files changed, 434 insertions(+)
 create mode 100644 account_reports_xlsx/views/account_financial_report_data.xml
 create mode 100644 account_reports_xlsx/views/action_manager.xml
 create mode 100644 account_reports_xlsx/views/financial_report_wizard_view.xml
 create mode 100644 account_reports_xlsx/views/financial_report_xls_view.xml
 create mode 100644 account_reports_xlsx/views/general_ledger_report_view.xml
 create mode 100644 account_reports_xlsx/views/general_ledger_report_wizard_view.xml
 create mode 100644 account_reports_xlsx/views/partner_ledgerreport.xml
 create mode 100644 account_reports_xlsx/views/report.xml
 create mode 100644 account_reports_xlsx/views/report_agedpartnerbalance.xml
 create mode 100644 account_reports_xlsx/views/supplier_aging_report_view.xml

(limited to 'account_reports_xlsx/views')

diff --git a/account_reports_xlsx/views/account_financial_report_data.xml b/account_reports_xlsx/views/account_financial_report_data.xml
new file mode 100644
index 0000000..2309c50
--- /dev/null
+++ b/account_reports_xlsx/views/account_financial_report_data.xml
@@ -0,0 +1,71 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data noupdate="1">
+        <!-- 
+            Financial Reports
+        -->
+        <record id="account_financial_report_profitandloss0" model="account.financial.report">
+            <field name="name">Profit and Loss</field>
+<!--            <field name="sign" eval="-1" />-->
+            <field name="sign">-1</field>
+            <field name="type">sum</field>
+        </record>
+
+        <record id="account_financial_report_income0" model="account.financial.report">
+            <field name="name">Income</field>
+<!--            <field name="sign" eval="-1" />-->
+            <field name="sign">-1</field>
+            <field name="parent_id" ref="account_financial_report_profitandloss0"/>
+            <field name="display_detail">detail_with_hierarchy</field>
+            <field name="type">account_type</field>
+            <field name="account_type_ids" eval="[(4,ref('account.data_account_type_other_income')), (4,ref('account.data_account_type_revenue'))]"/>
+        </record>
+
+        <record id="account_financial_report_expense0" model="account.financial.report">
+            <field name="name">Expense</field>
+<!--            <field name="sign" eval="-1" />-->
+            <field name="sign">-1</field>
+            <field name="parent_id" ref="account_financial_report_profitandloss0"/>
+            <field name="display_detail">detail_with_hierarchy</field>
+            <field name="type">account_type</field>
+            <field name="account_type_ids" eval="[(4,ref('account.data_account_type_expenses')), (4,ref('account.data_account_type_direct_costs')), (4,ref('account.data_account_type_depreciation'))]"/>
+        </record>
+
+        <record id="account_financial_report_balancesheet0" model="account.financial.report">
+            <field name="name">Balance Sheet</field>
+            <field name="type">sum</field>
+        </record>
+
+        <record id="account_financial_report_assets0" model="account.financial.report">
+            <field name="name">Assets</field>
+            <field name="parent_id" ref="account_financial_report_balancesheet0"/>
+            <field name="display_detail">detail_with_hierarchy</field>
+            <field name="type">account_type</field>
+            <field name="account_type_ids" eval="[(4,ref('account.data_account_type_receivable')), (4,ref('account.data_account_type_liquidity')), (4,ref('account.data_account_type_current_assets')), (4,ref('account.data_account_type_non_current_assets'), (4,ref('account.data_account_type_prepayments'))), (4,ref('account.data_account_type_fixed_assets'))]"/>
+        </record>
+
+        <record id="account_financial_report_liabilitysum0" model="account.financial.report">
+            <field name="name">Liability</field>
+            <field name="parent_id" ref="account_financial_report_balancesheet0"/>
+            <field name="display_detail">no_detail</field>
+            <field name="type">sum</field>
+        </record>
+
+        <record id="account_financial_report_liability0" model="account.financial.report">
+            <field name="name">Liability</field>
+            <field name="parent_id" ref="account_financial_report_liabilitysum0"/>
+            <field name="display_detail">detail_with_hierarchy</field>
+            <field name="type">account_type</field>
+            <field name="account_type_ids" eval="[(4,ref('account.data_account_type_payable')), (4,ref('account.data_account_type_equity')), (4,ref('account.data_account_type_current_liabilities')), (4,ref('account.data_account_type_non_current_liabilities'))]"/>
+        </record>
+
+        <record id="account_financial_report_profitloss_toreport0" model="account.financial.report">
+            <field name="name">Profit (Loss) to report</field>
+            <field name="parent_id" ref="account_financial_report_liabilitysum0"/>
+            <field name="display_detail">no_detail</field>
+            <field name="type">account_report</field>
+            <field name="account_report_id" ref="account_financial_report_profitandloss0"/>
+        </record>
+
+    </data>
+</odoo>
diff --git a/account_reports_xlsx/views/action_manager.xml b/account_reports_xlsx/views/action_manager.xml
new file mode 100644
index 0000000..f5c8f87
--- /dev/null
+++ b/account_reports_xlsx/views/action_manager.xml
@@ -0,0 +1,9 @@
+<odoo>
+    <data>
+        <template id="assets_backend" name="xls_assets" inherit_id="web.assets_backend">
+            <xpath expr="." position="inside">
+                <script type="text/javascript" src="/account_reports_xlsx/static/src/js/action_manager.js"/>
+            </xpath>
+        </template>
+    </data>
+</odoo>
diff --git a/account_reports_xlsx/views/financial_report_wizard_view.xml b/account_reports_xlsx/views/financial_report_wizard_view.xml
new file mode 100644
index 0000000..6723928
--- /dev/null
+++ b/account_reports_xlsx/views/financial_report_wizard_view.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+	    <record id="financial_wizard_xlsx_form_view" model="ir.ui.view">
+            <field name="name">Accounting report</field>
+            <field name="model">accounting.report.xlsx</field>
+            <field name="inherit_id" ref="account.account_common_report_view"/>
+            <!--XLS print button in financial report  wizard-->
+            <field name="arch" type="xml">
+				<xpath expr="//button[@name='check_report']" position="after">
+                    <button name="check_report" string="Export XLSX" type="object" context="{'xls_export':1}" class="oe_highlight"  style="margin: 0 5px;"/>
+                </xpath>
+			</field>
+        </record>
+	</data>
+</odoo>
diff --git a/account_reports_xlsx/views/financial_report_xls_view.xml b/account_reports_xlsx/views/financial_report_xls_view.xml
new file mode 100644
index 0000000..05c02bf
--- /dev/null
+++ b/account_reports_xlsx/views/financial_report_xls_view.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+         <report
+            id="accounting_report_xls"
+            model="accounting.report.xlsx"
+            string="Financial Report "
+            print_report_name = "Financial Report"
+            report_type="xlsx"
+            name="account_reports_xlsx.financial_report_xls"
+            file="account_reports_xlsx.financial_report_xls"
+            attachment_use="False"
+        />
+    </data>
+</odoo>
diff --git a/account_reports_xlsx/views/general_ledger_report_view.xml b/account_reports_xlsx/views/general_ledger_report_view.xml
new file mode 100644
index 0000000..81c208c
--- /dev/null
+++ b/account_reports_xlsx/views/general_ledger_report_view.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<openerp>
+    <data>
+         <report
+            id="ledger_xlsx"
+            model="account.report.general.ledger.xlsx"
+            string="General Ledger"
+            print_report_name = "General Ledger"
+            report_type="xlsx"
+            name="account_reports_xlsx.ledger_report_xls"
+            file="account_reports_xlsx.ledger_report_xls"
+            attachment_use="False"
+        />
+    </data>
+</openerp>
diff --git a/account_reports_xlsx/views/general_ledger_report_wizard_view.xml b/account_reports_xlsx/views/general_ledger_report_wizard_view.xml
new file mode 100644
index 0000000..3f7c0e0
--- /dev/null
+++ b/account_reports_xlsx/views/general_ledger_report_wizard_view.xml
@@ -0,0 +1,15 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+	    <record id="general_ledger_wizard_xlsx_form_view" model="ir.ui.view">
+            <field name="name">General Ledger</field>
+            <field name="model">account.report.general.ledger.xlsx</field>
+            <field name="inherit_id" ref="account.account_report_general_ledger_view"/>
+            <field name="arch" type="xml">
+				<xpath expr="//button[@name='check_report']" position="after">
+                    <button name="report_xlsx" string="Export XLSX" type="object"  class="oe_highlight"  style="margin: 0 5px;"/>
+                </xpath>
+			</field>
+        </record>
+	</data>
+</odoo>
\ No newline at end of file
diff --git a/account_reports_xlsx/views/partner_ledgerreport.xml b/account_reports_xlsx/views/partner_ledgerreport.xml
new file mode 100644
index 0000000..c42418d
--- /dev/null
+++ b/account_reports_xlsx/views/partner_ledgerreport.xml
@@ -0,0 +1,96 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+<template id="account_reports_xlsx.report_partnerledger">
+    <t t-call="web.html_container">
+        <t t-set="data_report_margin_top" t-value="12"/>
+        <t t-set="data_report_header_spacing" t-value="9"/>
+        <t t-set="data_report_dpi" t-value="110"/>
+        <t t-foreach="docs" t-as="o">
+            <t t-call="web.internal_layout">
+                <div class="page">
+                    <h2>Partner Ledger</h2>
+
+                    <div class="row">
+                        <div class="col-xs-3">
+                            <strong>Company:</strong>
+                            <p t-esc="res_company.name"/>
+                        </div>
+                        <div class="col-xs-3">
+                            <t t-if="data['form']['date_from']"><strong>Date from :</strong> <span t-esc="data['form']['date_from']"/><br/></t>
+                            <t t-if="data['form']['date_to']"><strong>Date to :</strong> <span t-esc="data['form']['date_to']"/></t>
+                        </div>
+                        <div class="col-xs-3">
+                            <strong>Target Moves:</strong>
+                            <p t-if="data['form']['target_move'] == 'all'">All Entries</p>
+                            <p t-if="data['form']['target_move'] == 'posted'">All Posted Entries</p>
+                        </div>
+                    </div>
+
+                    <table class="table table-condensed">
+                        <thead>
+                            <tr>
+                                <th>Date</th>
+                                <th>JRNL</th>
+                                <th>Account</th>
+                                <th>Ref</th>
+                                <th>Debit</th>
+                                <th>Credit</th>
+                                <th>Balance</th>
+                                <th t-if="data['form']['amount_currency']">Currency</th>
+                            </tr>
+                        </thead>
+                        <tbody>
+                            <tr>
+                                <td colspan="4">
+                                        <strong t-esc="o.ref"/>
+                                        - <strong t-esc="o.name"/>
+                                </td>
+                                <td class="text-right">
+                                    <strong t-esc="sum_partner(data, o, 'debit')" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right">
+                                    <strong t-esc="sum_partner(data, o, 'credit')" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right">
+                                    <strong t-esc="sum_partner(data, o, 'debit - credit')" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right" t-if="data['form']['amount_currency']">
+                                    <strong t-esc="sum_partner(data, o, 'amount_currency')" />
+                                </td>
+                            </tr>
+                            <tr t-foreach="lines(data, o)" t-as="line">
+                                <td>
+                                    <span t-esc="line['date']"/>
+                                </td>
+                                <td>
+                                    <span t-esc="line['code']"/>
+                                </td>
+                                <td>
+                                    <span t-esc="line['a_code']"/>
+                                </td>
+                                <td>
+                                    <span t-esc="line['displayed_name']"/>
+                                </td>
+                                <td class="text-right">
+                                    <span t-esc="line['debit']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right">
+                                    <span t-esc="line['credit']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right">
+                                    <span t-esc="line['progress']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                                </td>
+                                <td class="text-right" t-if="data['form']['amount_currency']">
+                                    <t t-if="line['currency_id']">
+                                      <span t-esc="line['amount_currency']" t-options="{'widget': 'monetary', 'display_currency': line['currency_id']}"/>
+                                    </t>
+                                </td>
+                            </tr>
+                        </tbody>
+                    </table>
+                </div>
+            </t>
+        </t>
+    </t>
+</template>
+</odoo>
diff --git a/account_reports_xlsx/views/report.xml b/account_reports_xlsx/views/report.xml
new file mode 100644
index 0000000..cf3b8d0
--- /dev/null
+++ b/account_reports_xlsx/views/report.xml
@@ -0,0 +1,17 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+    <data>
+
+        <act_window name="Partner Ledger"
+            res_model="account.report.partner.ledger.xlsx"
+            src_model="res.partner"
+            view_mode="form"
+            view_id ="account_reports_xlsx.account_report_partner_ledger_view"
+            target="new"
+            key2="client_print_multi"
+            id="action_account_partner_ledger_report_filter"
+            context="{'default_partner_ids':active_ids}"
+        />
+
+    </data>
+</odoo>
diff --git a/account_reports_xlsx/views/report_agedpartnerbalance.xml b/account_reports_xlsx/views/report_agedpartnerbalance.xml
new file mode 100644
index 0000000..40fe28e
--- /dev/null
+++ b/account_reports_xlsx/views/report_agedpartnerbalance.xml
@@ -0,0 +1,95 @@
+<?xml version="1.0" encoding="utf-8"?>
+<odoo>
+<template id="report_agedpartnerbalance">
+    <t t-call="web.html_container">
+        <t t-call="web.internal_layout">
+            <div class="page">
+                <h2>Aged Partner Balance</h2>
+
+                <div class="row mt32">
+                    <div class="col-3">
+                        <strong>Start Date:</strong>
+                        <p t-esc="data['date_from']"/>
+                    </div>
+                    <div class="col-3">
+                        <strong>Period Length (days)</strong>
+                        <p t-esc="data['period_length']"/>
+                    </div>
+                </div>
+                <div class="row mb32">
+                    <div class="col-3">
+                        <strong>Partner's:</strong>
+                        <p>
+                            <span t-if="data['result_selection'] == 'customer'">Receivable Accounts</span>
+                            <span t-if="data['result_selection'] == 'supplier'">Payable Accounts</span>
+                            <span t-if="data['result_selection'] == 'customer_supplier'">Receivable and Payable Accounts</span>
+                        </p>
+                    </div>
+                    <div class="col-3">
+                        <strong>Target Moves:</strong>
+                        <p>
+                            <span t-if="data['target_move'] == 'all'">All Entries</span>
+                            <span t-if="data['target_move'] == 'posted'">All Posted Entries</span>
+                        </p>
+                    </div>
+                </div>
+
+                <table class="table table-sm">
+                    <thead>
+                        <tr>
+                            <th><span>Partners</span></th>
+                            <th class="text-right">
+                                <span>Not due</span>
+                            </th>
+                            <th class="text-right"><span t-esc="data['4']['name']"/></th>
+                            <th class="text-right"><span t-esc="data['3']['name']"/></th>
+                            <th class="text-right"><span t-esc="data['2']['name']"/></th>
+                            <th class="text-right"><span t-esc="data['1']['name']"/></th>
+                            <th class="text-right"><span t-esc="data['0']['name']"/></th>
+                            <th class="text-right"><span>Total</span></th>
+                        </tr>
+                        <tr t-if="get_partner_lines">
+                            <th>Account Total</th>
+                            <th class="text-right"><span t-esc="get_direction[6]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[4]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[3]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[2]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[1]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[0]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                            <th class="text-right"><span t-esc="get_direction[5]" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/></th>
+                        </tr>
+                    </thead>
+                    <tbody>
+                        <tr t-foreach="get_partner_lines" t-as="partner">
+                            <td>
+                                <span t-esc="partner['name']"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['direction']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['4']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['3']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['2']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['1']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['0']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                            <td class="text-right">
+                                <span t-esc="partner['total']" t-options="{'widget': 'monetary', 'display_currency': res_company.currency_id}"/>
+                            </td>
+                        </tr>
+                    </tbody>
+                </table>
+            </div>
+        </t>
+    </t>
+</template>
+</odoo>
diff --git a/account_reports_xlsx/views/supplier_aging_report_view.xml b/account_reports_xlsx/views/supplier_aging_report_view.xml
new file mode 100644
index 0000000..d2c0cd0
--- /dev/null
+++ b/account_reports_xlsx/views/supplier_aging_report_view.xml
@@ -0,0 +1,85 @@
+<odoo>
+    <data>
+        <template id="account_reports_xlsx.aging_partnerbalance">
+            <t t-call="web.html_container">
+                <t t-call="web.external_layout">
+                    <div class="page">
+                        <h2>Aged Partner Balance</h2>
+                        <div class="row mt32">
+                            <div class="col-xs-3">
+                                <strong>Start Date:</strong>
+                                <p t-esc="data['date_from']"/>
+                            </div>
+                            <div class="col-xs-3">
+                                <strong>Period Length (days)</strong>
+                                <p t-esc="data['period_length']"/>
+                            </div>
+                        </div>
+                        <div class="row mb32">
+                            <div class="col-xs-3">
+                                <strong>Partner's:</strong>
+                                <p>
+                                    <span t-if="data['result_selection'] == 'customer'">Receivable Accounts</span>
+                                    <span t-if="data['result_selection'] == 'supplier'">Payable Accounts</span>
+                                    <span t-if="data['result_selection'] == 'customer_supplier'">Receivable and Payable Accounts</span>
+                                </p>
+                            </div>
+                            <div class="col-xs-3">
+                                <strong>Target Moves:</strong>
+                                <p>
+                                    <span t-if="data['target_move'] == 'all'">All Entries</span>
+                                    <span t-if="data['target_move'] == 'posted'">All Posted Entries</span>
+                                </p>
+                            </div>
+                        </div>
+
+                        <table class="table table-condensed">
+                            <thead>
+                                <tr>
+                                    <th>Partners</th>
+                                    <th class="text-right">
+                                        <span>Not due</span>
+                                    </th>
+                                    <th class="text-right"><span t-esc="data['4']['name']"/></th>
+                                    <th class="text-right"><span t-esc="data['3']['name']"/></th>
+                                    <th class="text-right"><span t-esc="data['2']['name']"/></th>
+                                    <th class="text-right"><span t-esc="data['1']['name']"/></th>
+                                    <th class="text-right"><span t-esc="data['0']['name']"/></th>
+                                    <th class="text-right">Total</th>
+                                </tr>
+                            </thead>
+                            <tbody>
+                                <tr t-foreach="get_partner_lines" t-as="partner">
+                                    <td>
+                                        <span t-esc="partner['name'] "/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="partner['direction']"/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['4'], 3)"/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['3'], 3)"/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['2'], 3)"/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['1'], 3)"/>
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['0'], 3)" />
+                                    </td>
+                                    <td class="text-right">
+                                        <span t-esc="round(partner['total'], 3)"/>
+                                    </td>
+                                </tr>
+                            </tbody>
+                        </table>
+                    </div>
+                </t>
+            </t>
+        </template>
+    </data>
+</odoo>
\ No newline at end of file
-- 
cgit v1.2.3