summaryrefslogtreecommitdiff
path: root/dynamic_accounts_report/static/src/xml
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2022-05-10 17:14:58 +0700
committerstephanchrst <stephanchrst@gmail.com>2022-05-10 17:14:58 +0700
commit1ca3b3df3421961caec3b747a364071c80f5c7da (patch)
tree6778a1f0f3f9b4c6e26d6d87ccde16e24da6c9d6 /dynamic_accounts_report/static/src/xml
parentb57188be371d36d96caac4b8d65a40745c0e972c (diff)
initial commit
Diffstat (limited to 'dynamic_accounts_report/static/src/xml')
-rw-r--r--dynamic_accounts_report/static/src/xml/ageing.xml580
-rw-r--r--dynamic_accounts_report/static/src/xml/cash_flow_view.xml351
-rw-r--r--dynamic_accounts_report/static/src/xml/daybook.xml341
-rw-r--r--dynamic_accounts_report/static/src/xml/financial_reports_view.xml266
-rw-r--r--dynamic_accounts_report/static/src/xml/general_ledger_view.xml395
-rw-r--r--dynamic_accounts_report/static/src/xml/partner_ledger_view.xml340
-rw-r--r--dynamic_accounts_report/static/src/xml/trial_balance_view.xml283
7 files changed, 2556 insertions, 0 deletions
diff --git a/dynamic_accounts_report/static/src/xml/ageing.xml b/dynamic_accounts_report/static/src/xml/ageing.xml
new file mode 100644
index 0000000..aa63e88
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/ageing.xml
@@ -0,0 +1,580 @@
+<templates>
+ <t t-name="AgeingTemp">
+ <div class="">
+ <div class="">
+ <h1 style="padding:10px">
+ Partner Ageing
+ </h1>
+
+ </div>
+
+ <div>
+ <div class="filter_view_tb"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_tb" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="Ageingtable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Partner</th>
+ <th class="mon_fld">Not Due</th>
+ <th class="mon_fld">0-30</th>
+ <th class="mon_fld">30-60</th>
+ <th class="mon_fld">60-90</th>
+ <th class="mon_fld">90-120</th>
+ <th class="mon_fld">120+</th>
+
+ <th class="mon_fld">Total</th>
+ </tr>
+ </thead>
+ <tbody>
+ <t t-set="none_value" t-value="_"/>
+ <t t-foreach="report_lines[0]" t-as="account">
+
+
+ <t t-set="common_id" t-value="0"/>
+
+ <tr style="border: 1.5px solid black;" class="gl-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['partner_id']"
+ t-attf-data-target=".a{{account['partner_id']}}">
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded" title="Unfolded"></i>
+
+ <span>
+
+ <t t-esc="account['name']"/>
+ </span>
+ <t t-if="currency[1] == 'before'">
+ <td style="text-align:right;">
+ <t t-if="account['direction'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['direction']"/>
+<!-- <t t-esc="Math.round(account['direction'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['4'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['4']"/>
+<!-- <t t-esc="Math.round(account['4'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['3'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['3']"/>
+<!-- <t t-esc="Math.round(account['3'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['2'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['2']"/>
+<!-- <t t-esc="Math.round(account['2'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['1'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['1']"/>
+<!-- <t t-esc="Math.round(account['1'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['0'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['0']"/>
+<!-- <t t-esc="Math.round(account['0'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['total'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['total']"/>
+<!-- <t t-esc="Math.round(account['total'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ </t>
+ <t t-else="">
+ <td style="text-align:right;">
+ <t t-if="account['direction'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['direction']"/>
+<!-- <t t-esc="Math.round(account['direction'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['4'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['4']"/>
+
+<!-- <t t-esc="Math.round(account['4'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['3'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['3']"/>
+<!-- <t t-esc="Math.round(account['3'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['2'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['2']"/>
+<!-- <t t-esc="Math.round(account['2'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['1'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['1']"/>
+<!-- <t t-esc="Math.round(account['1'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['0'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['0']"/>
+<!-- <t t-esc="Math.round(account['0'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td style="text-align:right;">
+ <t t-if="account['total'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['total']"/>
+<!-- <t t-esc="Math.round(account['total'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+
+ </t>
+ </td>
+ <tr t-attf-class="collapse a{{account['partner_id']}}">
+ <td colspan="14">
+ <ul>
+
+ </ul>
+ </td>
+ </tr>
+ </tr>
+ </t>
+
+ </tbody>
+
+ </table>
+ </div>
+ </div>
+ </t>
+
+
+ <t t-name="AgeingFilterView">
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:100px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+ As On Date
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="">
+ <label class="" for="date_from">As On Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="search-Result-Selection" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Account Type:
+ </a>
+ <select id="selection" class="dropdown-menu result_selection" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="customer">Receivable Accounts</option>
+ <option value="supplier">Payable Accounts</option>
+ <option value="customer_supplier">Receivable and Payable Accounts</option>
+ </select>
+ <span id="account_res"></span>
+ </div>
+ <div class="partner_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-users"></span>
+ Partners:
+ </a>
+ <select class="dropdown-menu partners" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.partners_list" t-as="partner">
+ <option t-attf-value="{{partner[0]}}">
+ <t t-esc="partner[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="partner_res"></span>
+ </div>
+ <div class="category_filter">
+ <a type="button" class="dropdown-toggle"
+ data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Partner tag:
+ </a>
+ <select class="dropdown-menu category"
+ name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.category_list"
+ t-as="category">
+ <option t-attf-value="{{category[0]}}">
+ <t t-esc="category[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="category_res"></span>
+
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+ <t t-name="SubSectional">
+ <div class="gl-table-div">
+ <table class="table table-sm o_main_table"
+ style="border: 0px solid black;display compact;">
+ <thead>
+ <tr style="">
+ <th>Entry Label</th>
+ <th>DueDate</th>
+ <th>JRNL</th>
+ <th>Account</th>
+ <th>Not Due</th>
+ <th>0-30</th>
+ <th>30-60</th>
+ <th>60-90</th>
+ <th>90-120</th>
+ <th>120+</th>
+
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="account_line">
+
+
+ <tr>
+ <td>
+ <t t-if="account_line.mov_id">
+ <div class="dropdown dropdown-toggle">
+ <a data-toggle="dropdown" href="#">
+ <span class="caret"></span>
+ <span>
+ <t t-esc="account_line.move"/>
+ </span>
+ </a>
+ <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu">
+ <li>
+ <a class="view-account-move" tabindex="-1" href="#"
+ t-att-data-move-id="account_line.mov_id">
+ View Source move
+
+ </a>
+ </li>
+ </ul>
+ </div>
+ </t>
+ </td>
+ <td>
+ <t t-esc="account_line.date"/>
+ </td>
+ <td>
+ <t t-esc="account_line.jrnl"/>
+ </td>
+ <td>
+ <span>
+ <t t-esc="account_line.acc_code"/>
+ -
+ <t t-esc="account_line.acc_name"/>
+ </span>
+ </td>
+ <t t-if="account_line.currency== 'before'">
+ <td>
+ <t t-if="account_line.period6">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ <td>
+ <t t-if="account_line.period5">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ <td>
+ <t t-if="account_line.period4">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ <td>
+ <t t-if="account_line.period3">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ <td>
+ <t t-if="account_line.period2">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ <td>
+ <t t-if="account_line.period1">
+ <t t-if="account_line.amount== 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.symbol"/>
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </t>
+ <t t-else="">
+ <span>-</span>
+ </t>
+ </td>
+ </t>
+ <t t-else="">
+ <td>
+ <t t-if="account_line.period6">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+ <td>
+ <t t-if="account_line.period5">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+ <td>
+ <t t-if="account_line.period4">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+ <td>
+ <t t-if="account_line.period3">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+ <td>
+ <t t-if="account_line.period2">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+ <td>
+ <t t-if="account_line.period1">
+ <t t-if="account_line.amount == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.amount"/>
+<!-- <t t-esc="Math.round(account_line.amount * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.symbol"/>
+ </t>
+ </t>
+
+ </td>
+
+
+ </t>
+
+ </tr>
+ </t>
+
+
+ </tbody>
+ </table>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/cash_flow_view.xml b/dynamic_accounts_report/static/src/xml/cash_flow_view.xml
new file mode 100644
index 0000000..33a3549
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/cash_flow_view.xml
@@ -0,0 +1,351 @@
+
+<templates>
+ <t t-name="CFTemp">
+ <div class="">
+ <div class="">
+ <h1 style="padding:10px">
+ Cash Flow Statement
+ </h1>
+
+ </div>
+
+ <div>
+ <div class="filter_view_tb"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_tb" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="CashTable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Name</th>
+ <th class="cf_fld">Cash In</th>
+ <th class="cf_fld">Cash Out</th>
+ <th class="cf_fld">Balance</th>
+
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="account">
+ <t t-set="common_id" t-value=""/>
+ <t t-if="(level=='detailed' or level=='very' or level==false )">
+ <tr style="border: .5px solid black;" class="cf-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded" title="Unfolded"></i>
+ <span>
+ <t t-if="account['month_part']">
+ <t t-esc="account['month_part']"/>
+ </t>
+ <t t-esc="account['code']"/>
+ <t t-esc="account['name']"/>
+ </span>
+ </td>
+ <t t-if="currency[1] == 'before'">
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_debit']"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_credit']"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_balance']"/>
+ </td>
+
+ </t>
+ <t t-else="">
+ <td class="cf_fld">
+ <t t-raw="account['total_debit']"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account['total_credit']"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account['total_balance']"/><t t-esc="currency[0]"/>
+ </td>
+ </t>
+ </tr>
+
+ </t>
+ <t t-else="">
+
+ <tr style="border: 1.5px solid black;" class=""
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+
+ <td colspan="6" style="border: 0px solid black;">
+ <span>
+ <t t-if="account['month_part']">
+ <t t-esc="account['month_part']"/>
+ </t>
+ <t t-esc="account['code']"/>
+
+ <t t-esc="account['name']"/>
+ </span>
+ </td>
+ <t t-if="currency[1] == 'before'">
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_debit']"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_credit']"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/> <t t-raw="account['total_balance']"/>
+ </td>
+
+ </t>
+ <t t-else="">
+ <td class="cf_fld">
+ <t t-raw="account['total_debit']"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account['total_credit']"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account['total_balance']"/><t t-esc="currency[0]"/>
+ </td>
+ </t>
+ </tr>
+ </t>
+ <tr t-attf-class="collapse a{{account['id']}}">
+ <td colspan="10">
+ <ul>
+
+ </ul>
+ </td>
+ </tr>
+ </t>
+ </tbody>
+
+
+ </table>
+ </div>
+ </div>
+ </t>
+
+
+
+
+ <t t-name="CashFilterView">
+
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf" style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">Print (PDF)</button>
+ <button type="button" class="btn btn-primary" id="xlsx" style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">Export (XLSX)</button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:110px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="" >
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="" >
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="" >
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]" >
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries </option>
+ </select>
+ <span id="post_res"></span>
+ </div>
+
+ <div class="search-levels">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+Level:
+ </a>
+ <select class="dropdown-menu levels" id="levels" name="states[]">
+ <option value="summary">Summary</option>
+ <option value="consolidated">Consolidated</option>
+ <option value="detailed">Detailed</option>
+ <option value="very">Very Detailed</option>
+ </select>
+ <span id="level_res"> </span>
+ </div>
+
+
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary" style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">Apply</button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+
+
+ <t t-name="SubSectionCF">
+
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Name</th>
+ <th class="cf_fld">Cash In</th>
+ <th class="cf_fld">Cash Out</th>
+ <th class="cf_fld">Balance</th>
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="data">
+
+ <t t-if="data.id == line_id">
+ <t t-foreach="data.journal_lines" t-as="account_line">
+ <t t-set="style" t-value="'font-style: italic;'"/>
+ <tr data-toggle=""
+ t-att-data-account-id="data.id"
+ t-attf-data-target=".a{{data.id}}">
+ <td colspan="6" style="border: 0px solid black;">
+ <t t-esc="account_line.name"/>
+ </td>
+ <t t-if="currency[1] == 'before'">
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/><t t-raw="account_line.total_debit"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/><t t-raw="account_line.total_credit"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/><t t-raw="account_line.balance"/>
+ </td>
+ </t>
+ <t t-else="">
+ <td class="cf_fld">
+ <t t-raw="account_line.total_debit"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account_line.total_credit"/><t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+ <t t-raw="account_line.balance"/><t t-esc="currency[0]"/>
+ </td>
+ </t>
+ </tr>
+ </t>
+ </t>
+ </t>
+ </tbody>
+
+
+ </table>
+
+ </t>
+
+ <t t-name="ChildSubSectionCF">
+ <div class="c-cf-table-div">
+ <table cellspacing="1" width="100%">
+ <thead>
+ <t t-foreach="account_data" t-as="acc_data">
+ <t t-if="acc_data.id == line_id">
+ <t t-foreach="acc_data.journal_lines" t-as="data">
+ <tr style="">
+ <th colspan="6"><t t-esc="data.name"/> </th>
+ <t t-if="currency[1] == 'before'">
+ <th class="cf_fld" style="left: 100px;"><t t-esc="currency[0]"/><t t-esc="data.total_debit"/></th>
+ <th class="cf_fld"><t t-esc="currency[0]"/><t t-esc="data.total_credit"/></th>
+ <th class="cf_fld"><t t-esc="currency[0]"/><t t-esc="data.total_balance"/></th>
+ </t>
+ <t t-else="">
+ <th class="cf_fld" style="left: 100px;"><t t-esc="data.total_debit"/><t t-esc="currency[0]"/></th>
+ <th class="cf_fld"><t t-esc="data.total_credit"/><t t-esc="currency[0]"/></th>
+ <th class="cf_fld"><t t-esc="data.total_balance"/><t t-esc="currency[0]"/></th>
+ </t>
+
+ </tr>
+
+ <t t-foreach="acc_data.move_lines" t-as="account_line">
+ <t t-if="account_line.j_id == data.id">
+ <tr>
+
+ <td colspan="6">
+ <t t-esc="account_line.move_name"/>
+ </td>
+ <t t-if="currency[1] == 'before'">
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account_line.total_debit"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account_line.total_credit"/>
+ </td>
+ <td class="cf_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account_line.balance"/>
+ </td>
+ </t>
+ <t t-else="">
+ <td class="cf_fld">
+ <t t-if="account_line.total_debit==0"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+
+ <t t-raw="account_line.total_credit"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td class="cf_fld">
+
+ <t t-raw="account_line.balance"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ </t>
+ </tr>
+ </t>
+ </t>
+
+ <tr t-attf-class="collapse a{{data.id}}">
+
+ <td colspan=""></td>
+ </tr>
+ </t>
+ </t>
+ </t>
+ </thead>
+ </table>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/daybook.xml b/dynamic_accounts_report/static/src/xml/daybook.xml
new file mode 100644
index 0000000..653d345
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/daybook.xml
@@ -0,0 +1,341 @@
+<templates>
+ <t t-name="DaybookTemp">
+ <div class="">
+ <div class="">
+ <h1 style="padding:10px">
+ Day Book
+ </h1>
+
+ </div>
+
+ <div>
+ <div class="filter_view_db"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_db" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="Daytable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Date</th>
+ <th class="mon_fld">Debit</th>
+ <th class="mon_fld">Credit</th>
+ <th class="mon_fld">Balance</th>
+
+ </tr>
+ </thead>
+<!-- <tbody style="width:100%;">-->
+<!-- </tbody>-->
+ <tbody>
+ <t t-foreach="report_lines" t-as="account">
+ <t t-set="common_id" t-value="0"/>
+ <tr style="border: 1.5px solid black;" class="db-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+ <t t-if="currency[1] == 'before'">
+
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded"
+ title="Unfolded"></i>
+ <span>
+ <t t-esc="account['date']"/>
+ </span>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+
+ <t t-raw="account['debit']"/>
+ </td>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+
+ <t t-raw="account['credit']"/>
+ </td>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+
+ <t t-raw="account['balance']"/>
+ </td>
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </td>
+ </t>
+ <t t-else="">
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded"
+ title="Unfolded"></i>
+ <span>
+ <t t-esc="account['date']"/>
+ </span>
+ <td class="mon_fld">
+
+ <t t-raw="account['debit']"/>
+ <t t-esc="currency[0]"/>
+
+ </td>
+ <td class="mon_fld">
+
+ <t t-raw="account['credit']"/>
+ <t t-esc="currency[0]"/>
+
+ </td>
+ <td class="mon_fld">
+
+ <t t-raw="account['balance']"/>
+ <t t-esc="currency[0]"/>
+
+ </td>
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </td>
+
+ </t>
+
+ <tr t-attf-class="collapse a{{account['id']}}">
+ <td colspan="10">
+ <ul>
+ </ul>
+ </td>
+ </tr>
+ </tr>
+ </t>
+ </tbody>
+ </table>
+ </div>
+ </div>
+ </t>
+
+
+ <t t-name="DayFilterView">
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:100px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+ Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="">
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="journals_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Journals:
+ </a>
+ <select class="dropdown-menu journals" name="states[]" multiple="multiple">
+ <div role="separator" class="dropdown-divider"></div>
+ <t t-foreach="filter_data.journals_list" t-as="journal">
+ <option t-attf-value="{{journal[0]}}">
+ <t t-esc="journal[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="journal_res"></span>
+ </div>
+ <div class="accounts_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Accounts:
+ </a>
+ <select class="dropdown-menu account" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.accounts_list" t-as="account">
+ <option t-attf-value="{{account[0]}}">
+ <t t-esc="account[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="acc_res"></span>
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+ <t t-name="SubSectiondb">
+ <div class="db-table-div">
+ <table class="table table-sm o_main_table"
+ style="border: 0px solid black;display compact;">
+ <thead>
+ <tr style="">
+ <th>Date</th>
+ <th>JRNL</th>
+ <th>Partner</th>
+ <th>Move</th>
+ <th>Entry Label</th>
+ <th>Debit</th>
+ <th>Credit</th>
+ <th>Balance</th>
+
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="account_line">
+ <t t-set="style" t-value="''"/>
+ <tr>
+ <td>
+ <t t-if="account_line.ldate">
+ <div class="dropdown dropdown-toggle">
+ <a data-toggle="dropdown" href="#">
+ <span class="caret"/>
+ <span data-id="17">
+ <t t-esc="account_line.ldate"/>
+ </span>
+ </a>
+ <ul class="dropdown-menu"
+ role="menu"
+ aria-labelledby="dropdownMenu">
+ <li>
+ <a class="view-account-move"
+ tabindex="-1" href="#"
+ t-att-data-move-id="account_line.move_id">
+ View Source move
+ </a>
+ </li>
+ </ul>
+ </div>
+ </t>
+ </td>
+ <td>
+ <t t-esc="account_line.lcode"/>
+ </td>
+ <td>
+ <t t-esc="account_line.partner_name"/>
+ </td>
+ <td t-att-style="style">
+ <t t-esc="account_line.move_name"/>
+ </td>
+ <td t-att-style="style">
+ <t t-esc="account_line.lname"/>
+ </td>
+ <t t-if="currency_position == 'before'">
+ <td t-att-style="style" class="text-right">
+ <t t-if="account_line.debit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency_symbol"/>
+ <t t-esc="account_line.debit"/>
+<!-- <t t-esc="Math.round(account_line.debit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td t-att-style="style" class="text-right">
+ <t t-if="account_line.credit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency_symbol"/>
+ <t t-esc="account_line.credit"/>
+<!-- <t t-esc="Math.round(account_line.credit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td t-att-style="style" class="text-right">
+ <t t-if="account_line.balance == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency_symbol"/>
+ <t t-esc="account_line.balance"/>
+<!-- <t t-esc="Math.round(account_line.balance * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ </t>
+ <t t-else="">
+ <td t-att-style="style" class="amt">
+ <t t-if="account_line.debit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.debit"/>
+<!-- <t t-esc="Math.round(account_line.debit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency_symbol"/>
+ </t>
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-if="account_line.credit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.credit"/>
+<!-- <t t-esc="Math.round(account_line.credit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency_symbol"/>
+ </t>
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-if="account_line.balance == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.balance"/>
+<!-- <t t-esc="Math.round(account_line.balance * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency_symbol"/>
+ </t>
+ </td>
+
+ </t>
+ </tr>
+ </t>
+ </tbody>
+ </table>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/financial_reports_view.xml b/dynamic_accounts_report/static/src/xml/financial_reports_view.xml
new file mode 100644
index 0000000..80997ea
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/financial_reports_view.xml
@@ -0,0 +1,266 @@
+
+<templates>
+ <t t-name="dfr_template_new">
+ <div class="">
+ <div>
+ <div class="filter_view_dfr"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_dfr" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+
+ <t t-name="dfr_table">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6"></th>
+ <th style="text-align: right; padding-right: 50px;">Debit</th>
+ <th style="text-align: right; padding-right: 50px;">Credit</th>
+ <th style="text-align: right; padding-right: 50px;">Balance</th>
+ </tr>
+ </thead>
+ <tbody>
+
+ <t t-set="none_value" t-value="_"/>
+ <t t-foreach="bs_lines" t-as="a">
+ <t t-if="a['code']">
+ <t t-foreach="report_lines" t-as="account">
+
+
+ <t t-set="common_id" t-value="0"/>
+ <t t-if="account['code'] == a['code']">
+ <tr style="border: 1.5px solid black;" class="gl-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+ <td colspan="6" style="border: 0px solid black; padding-left: 50px;">
+ <span>
+ <t t-esc="account['code']"/>
+ -
+ <t t-esc="account['name']"/>
+ </span>
+ <div class="" style="display: inline-block;">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ </a>
+ <div class="dropdown-menu " role="menu">
+ <div class="o_foldable_menu o_closed_menu " >
+ <div class="form-group ">
+ <div class="show-gl" aria-atomic="true" id="" data-target-input="">
+ <li role="presentation">
+ <a role="menuitem" style="background-color:aqua; font-weight:bold;" t-att-data-account-id="account['id']" class="show-gl" >View General Ledger</a>
+ </li>
+ </div>
+ </div>
+
+ </div>
+ </div>
+ </div>
+ </td>
+ <td t-att-style="fr_padding"><t t-esc="a['m_debit']" t-att-style="style"/></td>
+ <td t-att-style="fr_padding"><t t-esc="a['m_credit']" t-att-style="style"/></td>
+ <td t-att-style="fr_padding"><t t-esc="a['m_balance']" t-att-style="style"/></td>
+
+
+
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </tr>
+ </t>
+ </t>
+
+ </t>
+ <t t-else="">
+ <t t-set="style" t-value="'padding: 5px;padding-left: 25px;'"/>
+ <t t-set="fr_head" t-value="'border-bottom: double;'"/>
+ <t t-set="fr_padding" t-value="'padding-top: 5px; text-align: right;padding-right: 50px; vertical-align: bottom;'"/>
+ <t t-if="a['level'] == 1">
+ <t t-set="style" t-value="'padding: 5px;padding-left: 15px; padding-top: 15px;'"/>
+ </t>
+ <t t-if="a['level'] == 2">
+ <t t-set="style" t-value="'padding: 5px;padding-left: 25px; padding-top: 25px;'"/>
+ </t>
+ <t t-if="a['level'] == 3">
+ <t t-set="style" t-value="'padding: 5px;padding-left: 50px;'"/>
+ <t t-set="fr_head" t-value="'border-bottom: 1px solid black;'"/>
+ </t>
+ <t t-if="a['level'] &gt; 3">
+ <t t-set="style" t-value="'padding: 5px;padding-left: 50px;'"/>
+ <t t-set="fr_head" t-value="'border-bottom: 1px solid black;'"/>
+ </t>
+ <tr t-att-style="fr_head">
+ <th colspan="6" t-att-style="style">
+ <t t-esc="a['name']"/>
+ </th>
+ <td t-att-style="fr_padding"><t t-esc="a['m_debit']"/></td>
+ <td t-att-style="fr_padding"><t t-esc="a['m_credit']"/></td>
+ <td t-att-style="fr_padding"><t t-esc="a['m_balance']"/></td>
+ </tr>
+ </t>
+
+ </t>
+
+ </tbody>
+
+ </table>
+
+ </div>
+ </div>
+ </t>
+ <t t-name="DfrFilterView">
+ <div class="">
+ <h1 style="padding:10px">
+ <t t-esc="title"/>
+ </h1>
+
+ </div>
+ <div class="" style="position: relative;">
+
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD;
+ padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:20px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:80px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="" >
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="" >
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="" >
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="journals_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+Journals:
+ </a>
+ <select class="dropdown-menu journals" name="states[]" multiple="multiple">
+ <div role="separator" class="dropdown-divider"></div>
+ <t t-foreach="filter_data.journals_list" t-as="journal">
+ <option t-attf-value="{{journal[0]}}"><t t-esc="journal[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="journal_res"></span>
+ </div>
+
+ <div class="accounts_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Accounts:
+ </a>
+ <select class="dropdown-menu account" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.accounts_list" t-as="account">
+ <option t-attf-value="{{account[0]}}">
+ <t t-esc="account[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="acc_res"></span>
+ </div>
+
+ <div class="account_tags_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Account Tags:
+ </a>
+ <select class="dropdown-menu account-tag" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.account_tag_list" t-as="account_tag">
+ <option t-attf-value="{{account_tag[0]}}">
+ <t t-esc="account_tag[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="acc_tag_res"></span>
+ </div>
+
+ <div class="analytics_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Analytic Accounts:
+ </a>
+ <select class="dropdown-menu analytics" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.analytic_list" t-as="analytic">
+ <option t-attf-value="{{analytic[0]}}">
+ <t t-esc="analytic[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="analytic_res"></span>
+ </div>
+
+ <div class="analytic_tags_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Analytic Tags:
+ </a>
+ <select class="dropdown-menu analytic-tag" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.analytic_tag_list" t-as="analytic_tag">
+ <option t-attf-value="{{analytic_tag[0]}}">
+ <t t-esc="analytic_tag[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="analic_tag_res"></span>
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]" >
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/general_ledger_view.xml b/dynamic_accounts_report/static/src/xml/general_ledger_view.xml
new file mode 100644
index 0000000..7a5c582
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/general_ledger_view.xml
@@ -0,0 +1,395 @@
+<templates>
+ <t t-name="GeneralTemp">
+ <div>
+ <div>
+ <div class="filter_view_tb"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_tb" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="GLTable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Account</th>
+ <th class="mon_fld">Debit</th>
+ <th class="mon_fld">Credit</th>
+ <th class="mon_fld">Balance</th>
+ </tr>
+ </thead>
+ <tbody>
+ <t t-set="none_value" t-value="_"/>
+ <t t-foreach="report_lines" t-as="account">
+ <t t-set="common_id" t-value="0"/>
+ <tr style="border: 1.5px solid black;" class="gl-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded" title="Unfolded"></i>
+ <span>
+ <t t-esc="account['code']"/>
+ -
+ <t t-esc="account['name']"/>
+ </span>
+ </td>
+
+ <t t-if="currency[1] == 'before'">
+ <td class="mon_fld">
+ <t t-if="account['debit'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['debit']"/>
+<!-- <t t-raw="Math.round(account['debit'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td class="mon_fld">
+ <t t-if="account['credit'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['credit']"/>
+<!-- <t t-raw="Math.round(account['credit'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td class="mon_fld">
+ <t t-if="account['balance'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="currency[0]"/>
+ <t t-esc="account['balance']"/>
+<!-- <t t-raw="Math.round(account['balance'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+
+ </t>
+ <t t-else="">
+ <td class="mon_fld">
+ <t t-if="account['debit'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['debit']"/>
+<!-- <t t-raw="Math.round(account['debit'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td class="mon_fld">
+ <t t-if="account['credit'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['credit']"/>
+<!-- <t t-raw="Math.round(account['credit'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+ <td class="mon_fld">
+ <t t-if="account['balance'] == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account['balance']"/>
+<!-- <t t-raw="Math.round(account['balance'] * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="currency[0]"/>
+ </t>
+ </td>
+
+ </t>
+
+
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </tr>
+
+ <tr t-attf-class="collapse a{{account['id']}}">
+ <td colspan="10">
+ <ul>
+ </ul>
+ </td>
+ </tr>
+
+ </t>
+
+ </tbody>
+
+ </table>
+ </div>
+ </div>
+ </t>
+
+
+ <t t-name="GLFilterView">
+ <div>
+ <h1 style="padding:10px">
+ <t t-esc="title"/>
+ </h1>
+
+ </div>
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:80px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+ Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="">
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="journals_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Journals:
+ </a>
+ <select class="dropdown-menu journals" name="states[]" multiple="multiple">
+ <div role="separator" class="dropdown-divider"></div>
+ <t t-foreach="filter_data.journals_list" t-as="journal">
+ <option t-attf-value="{{journal[0]}}">
+ <t t-esc="journal[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="journal_res"></span>
+ </div>
+
+ <div class="accounts_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Accounts:
+ </a>
+ <select class="dropdown-menu account" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.accounts_list" t-as="account">
+ <option t-attf-value="{{account[0]}}">
+ <t t-esc="account[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="acc_res"></span>
+ </div>
+
+ <div class="analytics_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Analytic Accounts:
+ </a>
+ <select class="dropdown-menu analytics" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.analytic_list" t-as="analytic">
+ <option t-attf-value="{{analytic[0]}}">
+ <t t-esc="analytic[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="analytic_res"></span>
+ </div>
+
+ <div class="analytic_tags_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Analytic Tags:
+ </a>
+ <select class="dropdown-menu analytic_tags" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.analytic_tag_list" t-as="analytic_tag">
+ <option t-attf-value="{{analytic_tag[0]}}">
+ <t t-esc="analytic_tag[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="analytic_tag_res"></span>
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+
+ <t t-name="SubSection">
+ <div class="gl-table-div">
+ <table class="table table-sm o_main_table"
+ style="border: 0px solid black;display compact;">
+ <thead>
+ <tr style="">
+ <th>Date</th>
+ <th>JRNL</th>
+ <th>Partner</th>
+ <th>Move</th>
+ <th>Entry Label</th>
+ <th class="mon_fld">Debit</th>
+ <th class="mon_fld">Credit</th>
+ <th class="mon_fld">Balance</th>
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="account_line">
+ <t t-set="style" t-value="''"/>
+ <t t-set="style_right" t-value="'text-align:right;'"/>
+ <tr>
+ <td>
+ <t t-if="account_line.ldate">
+ <div class="dropdown dropdown-toggle">
+ <a data-toggle="dropdown" href="#">
+ <span class="caret"></span>
+ <span>
+ <t t-esc="account_line.ldate"/>
+ </span>
+ </a>
+ <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu">
+ <li>
+ <a class="view-account-move" tabindex="-1" href="#"
+ t-att-data-move-id="account_line.move_id">
+ View Source move
+
+ </a>
+ </li>
+ </ul>
+ </div>
+ </t>
+ </td>
+ <td>
+ <t t-esc="account_line.lcode"/>
+ </td>
+ <td>
+ <t t-esc="account_line.partner_name"/>
+ </td>
+ <td t-att-style="style">
+ <t t-esc="account_line.move_name"/>
+ </td>
+ <td t-att-style="style">
+ <t t-esc="account_line.lname"/>
+ </td>
+ <t t-if="currency_position == 'before'">
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.debit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.currency_code"/>
+ <t t-esc="account_line.debit"/>
+<!-- <t t-esc="Math.round(account_line.debit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.credit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.currency_code"/>
+ <t t-esc="account_line.credit"/>
+<!-- <t t-esc="Math.round(account_line.credit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.balance == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.currency_code"/>
+ <t t-esc="account_line.balance"/>
+<!-- <t t-esc="Math.round(account_line.balance * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ </t>
+ </td>
+ </t>
+ <t t-else="">
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.debit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.debit"/>
+<!-- <t t-esc="Math.round(account_line.debit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.currency_code"/>
+ </t>
+ </td>
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.credit == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.credit"/>
+<!-- <t t-esc="Math.round(account_line.credit * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.currency_code"/>
+ </t>
+ </td>
+ <td t-att-style="style_right" class="amt">
+ <t t-if="account_line.balance == 0">
+ <span>-</span>
+ </t>
+ <t t-else="">
+ <t t-esc="account_line.balance"/>
+<!-- <t t-esc="Math.round(account_line.balance * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="account_line.currency_code"/>
+ </t>
+ </td>
+ </t>
+
+ </tr>
+
+ </t>
+ </tbody>
+ </table>
+ </div>
+ </t>
+
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/partner_ledger_view.xml b/dynamic_accounts_report/static/src/xml/partner_ledger_view.xml
new file mode 100644
index 0000000..db244e5
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/partner_ledger_view.xml
@@ -0,0 +1,340 @@
+<templates>
+ <t t-name="PartnerTemp">
+ <div class="">
+ <div class="">
+ <h1 style="padding:10px">
+ Partner Ledger
+ </h1>
+ </div>
+
+ <div>
+ <div class="filter_view_tb"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_tb" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="PLTable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Partner</th>
+ <th style="text-align:right;">Debit</th>
+ <th style="text-align:right;">Credit</th>
+ <th style="text-align:right;">Balance</th>
+ </tr>
+ </thead>
+
+ <tbody>
+ <t t-set="none_value" t-value="_"/>
+ <t t-foreach="report_lines" t-as="account">
+ <t t-set="common_id" t-value="0"/>
+ <tr style="border: 1.5px solid black;" class="pl-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+ <td colspan="6" style="border: 0px solid black;">
+ <i class="fa fa-caret-down" role="img" aria-label="Unfolded" title="Unfolded"></i>
+ <span>
+ <t t-esc="account['name']"/>
+ </span>
+ </td>
+
+ <t t-if="currency[1] == 'before'">
+ <td style="text-align:right;">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['debit']"/>
+ </td>
+ <td style="text-align:right;">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['credit']"/>
+ </td>
+ <td style="text-align:right;">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['balance']"/>
+ </td>
+
+ </t>
+ <t t-else="">
+ <td style="text-align:right;">
+ <t t-raw="account['debit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td style="text-align:right;">
+ <t t-raw="account['credit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td style="text-align:right;">
+ <t t-raw="account['balance']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+
+ </t>
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </tr>
+ <tr t-attf-class="collapse a{{account['id']}}">
+ <td colspan="10">
+ <ul>
+ </ul>
+ </td>
+ </tr>
+ </t>
+ </tbody>
+
+ </table>
+ </div>
+ </div>
+ </t>
+
+ <t t-name="PLFilterView">
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:80px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+ Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="">
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="partner_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-users"></span>
+ Partners:
+ </a>
+ <select class="dropdown-menu partners " name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.partners_list" t-as="partner">
+ <option t-attf-value="{{partner[0]}}">
+ <t t-esc="partner[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="partner_res"></span>
+
+ </div>
+
+ <div class="acccount_type_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Account Type
+ </a>
+ <select class="dropdown-menu type" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.account_type_list" t-as="type">
+ <option t-attf-value="{{type[0]}}">
+ <t t-esc="type[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="type_res"></span>
+
+ </div>
+ <div class="category_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Partner tag:
+ </a>
+ <select class="dropdown-menu category" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.category_list" t-as="category">
+ <option t-attf-value="{{category[0]}}">
+ <t t-esc="category[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="category_res"></span>
+
+ </div>
+
+ <div class="journals_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Journals:
+ </a>
+ <select class="dropdown-menu journals" name="states[]" multiple="multiple">
+ <div role="separator" class="dropdown-divider"></div>
+ <t t-foreach="filter_data.journals_list" t-as="journal">
+ <option t-attf-value="{{journal[0]}}">
+ <t t-esc="journal[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="journal_res"></span>
+ </div>
+ <div class="acc_filter">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Accounts:
+ </a>
+ <select class="dropdown-menu account" name="states[]" multiple="multiple">
+ <t t-foreach="filter_data.accounts_list" t-as="account">
+ <option t-attf-value="{{account[0]}}">
+ <t t-esc="account[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="account_res"></span>
+
+
+ </div>
+
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+ <t t-name="SubSectionPL">
+ <div class="pl-table-div">
+ <table class="table table-sm o_main_table"
+ style="border: 0px solid black;display compact;">
+ <thead>
+ <tr style="">
+ <th>Date</th>
+ <th>JRNL</th>
+ <th>Account</th>
+ <th>Move</th>
+ <th>Entry Label</th>
+ <th style="text-align:right;">Debit</th>
+ <th style="text-align:right;">Credit</th>
+ <th style="text-align:right;">Balance</th>
+ </tr>
+ </thead>
+ <tbody>
+ <t t-foreach="account_data" t-as="account_line">
+
+ <t t-set="style" t-value="'text-align:right;'"/>
+ <t t-set="styleleft" t-value="'text-align:left;'"/>
+ <tr>
+ <td>
+ <t t-if="account_line.ldate">
+ <div class="dropdown dropdown-toggle">
+ <a data-toggle="dropdown" href="#">
+ <span class="caret"></span>
+ <span>
+ <t t-esc="account_line.ldate"/>
+ </span>
+ </a>
+ <ul class="dropdown-menu" role="menu" aria-labelledby="dropdownMenu">
+ <li>
+ <a class="view-account-move" tabindex="-1" href="#"
+ t-att-data-move-id="account_line.move_id">
+ View Source move
+
+ </a>
+ </li>
+ </ul>
+ </div>
+ </t>
+ </td>
+ <td>
+ <t t-esc="account_line.lcode"/>
+
+ </td>
+ <td>
+ <span>
+ <t t-esc="account_line.account_name"/>
+ </span>
+ </td>
+ <td t-att-style="styleleft">
+ <t t-esc="account_line.move_name"/>
+ </td>
+ <td t-att-style="styleleft">
+ <t t-esc="account_line.lname"/>
+ </td>
+ <t t-if="account_line.currency_position == 'before'">
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.currency_code"/>
+ <t t-raw="account_line.debit"/>
+
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.currency_code"/>
+ <t t-raw="account_line.credit"/>
+
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.currency_code"/>
+ <t t-raw="account_line.balance"/>
+
+ </td>
+
+ </t>
+ <t t-else="">
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.debit"/>
+ <t t-raw="account_line.currency_code"/>
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.credit"/>
+ <t t-raw="account_line.currency_code"/>
+ </td>
+ <td t-att-style="style" class="amt">
+ <t t-raw="account_line.balance"/>
+ <t t-raw="account_line.currency_code"/>
+ </td>
+
+ </t>
+
+ </tr>
+ </t>
+ </tbody>
+ </table>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file
diff --git a/dynamic_accounts_report/static/src/xml/trial_balance_view.xml b/dynamic_accounts_report/static/src/xml/trial_balance_view.xml
new file mode 100644
index 0000000..76869be
--- /dev/null
+++ b/dynamic_accounts_report/static/src/xml/trial_balance_view.xml
@@ -0,0 +1,283 @@
+<templates>
+ <t t-name="TrialTemp">
+ <div class="">
+ <div class="">
+ <h1 style="padding:10px">
+ Trial Balance
+ </h1>
+
+ </div>
+
+ <div>
+ <div class="filter_view_tb"></div>
+ </div>
+ <br></br>
+ <div>
+ <div class="table_view_tb" style="right:20px;"></div>
+ </div>
+ </div>
+ </t>
+ <t t-name="TrialTable">
+ <div>
+ <div class="table_main_view">
+ <table cellspacing="0" width="100%">
+ <thead>
+ <tr>
+ <th colspan="6">Account</th>
+ <t t-if="filter['date_from']">
+ <th class="mon_fld">Initial Debit</th>
+ <th class="mon_fld">Initial Credit</th>
+
+ </t>
+ <th class="mon_fld">Debit</th>
+ <th class="mon_fld">Credit</th>
+ </tr>
+ </thead>
+
+ <tbody>
+
+ <t t-set="none_value" t-value="_"/>
+ <t t-foreach="report_lines" t-as="account">
+ <t t-set="common_id" t-value="0"/>
+ <tr style="border: 1.5px solid black;" class="gl-line"
+ data-toggle="collapse"
+ t-att-data-account-id="account['id']"
+ t-attf-data-target=".a{{account['id']}}">
+ <td colspan="6" style="border: 0px solid black;">
+ <span>
+ <t t-esc="account['code']"/>
+ -
+ <t t-esc="account['name']"/>
+ </span>
+ <div class="" style="display: inline-block;">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown"
+ aria-expanded="false">
+ </a>
+ <div class="dropdown-menu " role="menu">
+ <div class="o_foldable_menu o_closed_menu ">
+ <div class="form-group ">
+ <div class="show-gl" aria-atomic="true" id="" data-target-input="">
+ <li role="presentation">
+ <a role="menuitem" style="background-color:aqua; font-weight:bold;"
+ t-att-data-account-id="account['id']" class="show-gl">
+ View General Ledger
+ </a>
+ </li>
+ </div>
+ </div>
+
+ </div>
+ </div>
+ </div>
+ </td>
+ <t t-if="filter['date_from']">
+ <t t-if="account['Init_balance']">
+ <t t-if="currency[1] == 'before'">
+
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['Init_balance']['debit']"/>
+ </td>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['Init_balance']['credit']"/>
+ </td>
+ </t>
+ <t t-else="">
+ <td class="mon_fld">
+ <t t-raw="account['Init_balance']['debit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td class="mon_fld">
+ <t t-raw="account['Init_balance']['credit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+
+
+ </t>
+ </t>
+ <t t-else="">
+ <t t-if="currency[1] == 'before'">
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>0
+ </td>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>0
+ </td>
+ </t>
+ <t t-else="">
+ <td class="mon_fld">
+ 0
+ <t t-esc="currency[0]"/>
+ </td>
+ <td class="mon_fld">
+ 0
+ <t t-esc="currency[0]"/>
+ </td>
+ </t>
+ </t>
+ </t>
+ <t t-if="currency[1] == 'before'">
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['debit']"/>
+ </td>
+ <td class="mon_fld">
+ <t t-esc="currency[0]"/>
+ <t t-raw="account['credit']"/>
+ </td>
+
+ </t>
+ <t t-else="">
+ <td class="mon_fld">
+ <t t-raw="account['debit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+ <td class="mon_fld">
+ <t t-raw="account['credit']"/>
+ <t t-esc="currency[0]"/>
+ </td>
+
+ </t>
+
+ <t t-set="common_id" t-value="'a'+account['id']"/>
+ </tr>
+ </t>
+ <td colspan="6" style="" class="">
+ <strong>Total</strong>
+ </td>
+ <t t-if="filter['date_from']">
+
+ <td class="mon_fld" style="">
+ <strong></strong>
+ </td>
+ <td class="mon_fld" style="">
+ <strong></strong>
+ </td>
+ </t>
+ <t t-if="currency[1] == 'before'">
+ <td class="mon_fld" style="">
+ <strong>
+ <t t-esc="currency[0]"/>
+<!-- <t t-raw="Math.round(debit_total * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="debit_total"/>
+ </strong>
+ </td>
+ <td class="mon_fld" style="">
+ <strong>
+ <t t-esc="currency[0]"/>
+<!-- <t t-raw="Math.round(credit_total * Math.pow(10, 2)) / Math.pow(10, 2)"/>-->
+ <t t-esc="credit_total"/>
+ </strong>
+ </td>
+ </t>
+ <t t-else="">
+
+ <td class="mon_fld" style="">
+ <strong>
+ <t t-raw="Math.round(debit_total * Math.pow(10, 2)) / Math.pow(10, 2)"/>
+ <t t-esc="currency[0]"/>
+ </strong>
+ </td>
+ <td class="mon_fld" style="">
+ <strong>
+ <t t-raw="Math.round(credit_total * Math.pow(10, 2)) / Math.pow(10, 2)"/>
+ <t t-esc="currency[0]"/>
+ </strong>
+ </td>
+ </t>
+
+ </tbody>
+
+ </table>
+ </div>
+ </div>
+ </t>
+
+
+ <t t-name="TrialFilterView">
+
+ <div class="" style="position: relative;">
+ <div class="sub_container_left">
+ <div class="report_print">
+ <button type="button" class="btn btn-primary" id="pdf"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Print (PDF)
+ </button>
+ <button type="button" class="btn btn-primary" id="xlsx"
+ style="left:10px; height:30px;position: relative;color:white;background-color: #00A0AD;border-color: #00A0AD; padding:3px;">
+ Export (XLSX)
+ </button>
+ </div>
+ </div>
+ <br></br>
+ <div class="sub_container_right" style="width:50%;height:3%;right:0px;top:0px;position: absolute;">
+ <div class="" style="right:80x;">
+
+ <br></br>
+ <div class="row" style="right:110px;top:0px;position: absolute;width:50;">
+ <div class="time_range" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown" aria-expanded="false">
+ <span class="fa fa-calendar" title="Dates" role="img" aria-label="Dates"></span>
+ Date Range
+ </a>
+ <div class="dropdown-menu" role="menu">
+ <div class="">
+ <label class="" for="date_from">Start Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_from"></input>
+ </div>
+ </div>
+ <label class="" for="date_to">End Date :</label>
+ <div class="">
+ <div class="" aria-atomic="true" id="">
+ <input type="date" id="date_to"></input>
+ </div>
+ </div>
+ </div>
+ </div>
+ </div>
+ <div class="journals_filter" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-book"></span>
+ Journals:
+ </a>
+ <select class="dropdown-menu journals" name="states[]" multiple="multiple">
+ <div role="separator" class="dropdown-divider"></div>
+ <t t-foreach="filter_data.journals_list" t-as="journal">
+ <option t-attf-value="{{journal[0]}}">
+ <t t-esc="journal[1]"/>
+ </option>
+ </t>
+ </select>
+ <span id="journal_res"></span>
+ </div>
+
+ <div class="search-Target-move" style="">
+ <a type="button" class="dropdown-toggle" data-toggle="dropdown">
+ <span class="fa fa-filter"></span>
+ Target Move:
+ </a>
+ <select id="entries" class="dropdown-menu target_move" name="states[]">
+ <div role="separator" class="dropdown-divider"></div>
+ <option value="Posted">Posted Entries</option>
+ <option value="All">All Entries</option>
+ </select>
+ <span id="post_res"></span>
+ </div>
+ </div>
+
+ </div>
+ <div style="">
+ <button type="button" id="apply_filter" class="btn btn-primary"
+ style="top:0px;height:30px;right:20px;position: absolute;color:white;background-color: #00A0AD;border-color: #00A0AD;">
+ Apply
+ </button>
+
+ </div>
+ </div>
+ </div>
+ </t>
+
+</templates> \ No newline at end of file