osbzr/gooderp_addons

View on GitHub
finance/views/trial_balance.xml

Summary

Maintainability
Test Coverage
<?xml version="1.0"?>
<openerp>
    <data>

        <record id="trial_balance_tree" model="ir.ui.view">
            <field name="name">trial.balance.form</field>
            <field name="model">trial.balance</field>
            <field name="arch" type="xml">
                <tree string="科目余额表" decoration-info="account_type == 'view'" editable="TOP" default_order='subject_name_id'>
                    <field name="period_id" readonly="1"/>
                    <field name="subject_code" invisible="1"/>
                    <field name="subject_name_id" readonly="1"/>
                    <field name="level" invisible="1"/>
                    <field name="account_type" invisible="1"/>
                    <field name="initial_balance_debit" base_string='期初余额' merge="False" child_name='借方' colspan='2' readonly='1' widget="bgcolor" color="success"/>
                    <field name="initial_balance_credit" merge="True" child_name='贷方' readonly='1' widget="bgcolor" color="primary"/>
                    <field name="current_occurrence_debit" base_string='本期发生' merge="False" child_name='借方' colspan='2' readonly='1' widget="bgcolor" color="success"/>
                    <field name="current_occurrence_credit" merge="True" child_name='贷方' readonly='1' widget="bgcolor" color="primary"/>
                    <field name="ending_balance_debit" base_string='期末余额' merge="False" child_name='借方' colspan='2' readonly='1' widget="bgcolor" color="success"/>
                    <field name="ending_balance_credit" merge="True" child_name='贷方' readonly='1' widget="bgcolor" color="primary"/>
                  </tree>
            </field>
        </record>

        <record id="init_balance_tree" model="ir.ui.view">
            <field name="name">initial.balance.form</field>
            <field name="model">trial.balance</field>
            <field name="arch" type="xml">
                <tree string="科目余额表" decoration-info="account_type == 'view'" editable="TOP" default_order='subject_name_id'>
                    <button name="button_change_number" string="调整累计数" type="object" class="oe_highlight" attrs="{ 'invisible': [('account_type','=','view')] }" />
                    <field name="period_id" readonly="1"/>
                    <field name="subject_code" invisible="1"/>
                    <field name="subject_name_id" readonly="1"/>
                    <field name="level" invisible="1"/>
                    <field name="account_type" invisible="1"/>
                    <field name="year_init_debit" base_string='年初余额' merge="False" child_name='借方' colspan='2'  widget="bgcolor" color="success" />
                    <field name="year_init_credit" merge="True" child_name='贷方' widget="bgcolor" color="primary"/>
                    <field name="cumulative_occurrence_debit" base_string='本年累计' merge="False" child_name='借方' colspan='2'  widget="bgcolor" color="success" readonly="1"/>
                    <field name="cumulative_occurrence_credit" merge="True" child_name='贷方' widget="bgcolor" color="primary" readonly="1"/>
                    <field name="ending_balance_debit" base_string='期末余额' merge="False" child_name='借方' colspan='2' readonly='1'  widget="bgcolor" color="success"/>
                    <field name="ending_balance_credit" merge="True" child_name='贷方' readonly='1' widget="bgcolor" color="primary"/>
                  </tree>
            </field>
        </record>

        <record id="trial_balance_search" model="ir.ui.view">
            <field name="name">trial.balance.form</field>
            <field name="model">trial.balance</field>
            <field name="arch" type="xml">
                 <search>
                    <filter string="有发生额" name='has_transaction'
                            domain="['|', ('current_occurrence_debit','!=', 0), ('current_occurrence_credit','!=', 0)]"/>
                    <filter string="有余额" name='has_balance'
                            domain="['|', ('ending_balance_debit','!=', 0), ('ending_balance_credit','!=', 0)]"/>
                    <group expand="0" string="分组">
                        <filter string="会计期间" domain="[]" context="{'group_by':'period_id'}"/>
                        <filter string="科目级次" domain="[]" context="{'group_by':'level'}"/>
                        <filter string="科目" domain="[]" context="{'group_by':'subject_name_id'}"/>
                    </group>
                 </search>
            </field>
        </record>

        <record id="trial_balance_action" model="ir.actions.act_window">
            <field name="name">科目余额表</field>
            <field name="res_model">trial.balance</field>
            <field name="type">ir.actions.act_window</field>
            <field name="view_type">form</field>
            <field name="view_mode">tree</field>
        </record>
        
        <record id="create_trial_balance_wizard_form" model="ir.ui.view">
            <field name="name">create.trial.balance.wizard.form</field>
            <field name="model">create.trial.balance.wizard</field>
            <field name="arch" type="xml">
                <form>
                    <group>
                        <group>
                            <field name="period_id" options="{'no_open':True,'no_create':True}" required="True" style="width: 60%%"/>
                            <field name="has_transaction" />
                            <field name="has_balance" />
                        </group>
                    </group>
                    <footer>
                        <button name="create_trial_balance" string="科目余额表" type="object" class="oe_highlight"/>
                        或者
                        <button string="取消" class="oe_link" special="cancel"/>
                    </footer>
                </form>
            </field>
        </record>

      <act_window id="create_trial_balance_wizard_action"
        name='科目余额表'
        res_model="create.trial.balance.wizard"
        multi="True"
        view_type="form"
        view_mode="form"
        target="new" 
        />

        <record id="check_trial_balance_wizard_form" model="ir.ui.view">
            <field name="name">check.trial.balance.wizard.form</field>
            <field name="model">check.trial.balance.wizard</field>
            <field name="arch" type="xml">
                <form>
                    <group invisible="context.get('inline')">
                        <group>
                            <field name="period_id" options="{'no_open':True,'no_create':True}" required="True" style="width: 60%%" />
                        </group>
                    </group>
                    <group invisible="not context.get('inline')">
                        <group>
                            <field name="is_init_period" invisible="1" />
                            <field name="total_year_init_debit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', False)]  }"/>
                            <field name="total_year_init_credit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', False)]  }"/>
                            <field name="total_initial_balance_debit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', True)]  }"/>
                            <field name="total_initial_balance_credit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', True)]  }"/>
                            <field name="total_current_occurrence_debit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', True)]  }"/>
                            <field name="total_current_occurrence_credit" readonly="1" attrs="{ 'invisible': [('is_init_period','=', True)]  }"/>
                            <field name="total_cumulative_occurrence_debit" readonly="1"  attrs="{ 'invisible': [('is_init_period','=', False)]  }"/>
                            <field name="total_cumulative_occurrence_credit" readonly="1"  attrs="{ 'invisible': [('is_init_period','=', False)]  }"/>
                            <field name="total_ending_balance_debit" readonly="1"/>
                            <field name="total_ending_balance_credit" readonly="1"/>
                            <field name="result"  readonly="1"/>
                            <field name="is_balance" invisible="1"/>
                            <field name="diff" attrs="{ 'invisible': [('is_balance','=', True)]  }" readonly="1"/>
                        </group>
                    </group>
                    <footer>
                       <!--  <button name="check_trial_balance" string="试算平衡" type="object" class="oe_highlight" /> 或者 -->
                        <button string="确认" class="oe_link" special="cancel" />
                    </footer>
                </form>
            </field>
        </record>

        <act_window id="check_trial_balance_wizard_action"
            name='试算平衡'
            res_model="check.trial.balance.wizard"
            multi="True"
            view_type="form"
            view_mode="form"
            target="new" 
            />

        <act_window id="check_trial_balance_wizard_action_popup"
            name='试算平衡'
            res_model="check.trial.balance.wizard"
            multi="True"
            view_type="form"
            view_mode="form"
            target="new"
            context="{'inline':True}"
            />

        <!-- 动作绑定 -->
        <record model="ir.values" id="check_trial_balance_wizard_values">
            <field name="model_id" ref="finance.model_trial_balance" />
            <field name="name">试算平衡</field>
            <field name="key2">client_action_multi</field>
            <field name="value" eval="'ir.actions.act_window,' + str(ref('check_trial_balance_wizard_action_popup'))" />
            <field name="key">action</field>
            <field name="model">trial.balance</field>
        </record>

        <record id="change_cumulative_occurrence_wizard_form" model="ir.ui.view">
            <field name="name">change.cumulative.occurrence.wizard.form</field>
            <field name="model">change.cumulative.occurrence.wizard</field>
            <field name="arch" type="xml">
                <form>
                    <group>
                        <group>
                            <field name="account_id" readonly="1"/>
                            <field name="costs_types" readonly="1"/>
                            <field name="old_cumulative_occurrence_debit" invisible="1"/>
                            <field name="cumulative_occurrence_debit" attrs="{ 'invisible': [('costs_types','in',('in','out'))]  }"/>
                            <field name="old_cumulative_occurrence_credit" invisible="1"/>
                            <field name="cumulative_occurrence_credit" attrs="{ 'invisible': [('costs_types','in',('in','out'))]  }"/>
                            <field name="cumulative_occurrence" attrs="{ 'invisible': [('costs_types','not in',('in','out'))]  }"/>
                        </group>
                    </group>
                    <footer>
                        <button name="update_cumulative_occurrence" string="更新" type="object" class="oe_highlight"/>
                        或者
                        <button string="取消" class="oe_link" special="cancel"/>
                    </footer>
                </form>
            </field>
        </record>

        <act_window id="change_cumulative_occurrence_wizard_action"
            name='调整累计数'
            res_model="change.cumulative.occurrence.wizard"
            multi="True"
            view_type="form"
            view_mode="form"
            target="new" 
            />

        <record id="create_vouchers_summary_wizard_form" model="ir.ui.view">
            <field name="name">create.vouchers.summary.wizard.form</field>
            <field name="model">create.vouchers.summary.wizard</field>
            <field name="arch" type="xml">
                <form>
                    <group>
                        <group>
                            <field name="period_begin_id" options="{'no_open':True,'no_create':True}" required="True"/>
                            <field name="subject_name_id" options="{'no_open':True,'no_create':True}" required="True"/>
                        </group>
                         <group>
                            <field name="period_end_id" options="{'no_open':True,'no_create':True}" required="True"/>
                            <field name="subject_name_end_id" options="{'no_open':True,'no_create':True}" required="True"/>
                         </group>
                        <group>
                            <field name="no_occurred" invisible="context.get('create_general_ledger_account')" />
                            <field name="no_balance"/>
                        </group>
                    </group>
                    <footer>
                        <button name="create_vouchers_summary" invisible="context.get('create_general_ledger_account')" string="科目明细账表" type="object" class="oe_highlight"/>
                         <button name="create_general_ledger_account" invisible="context.get('create_vouchers_summary')" string="科目总账" type="object" class="oe_highlight"/>
                        或者
                        <button string="取消" class="oe_link" special="cancel"/>
                    </footer>
                </form>
            </field>
        </record>
      <act_window id="create_vouchers_summary_wizard_action"
        name='明细账'
        res_model="create.vouchers.summary.wizard"
        multi="True"
        view_type="form"
        view_mode="form"
        target="new" 
        context="{'create_vouchers_summary':True}"/>

        <record id="vouchers_summary_tree" model="ir.ui.view">
            <field name="name">trial.balance.form</field>
            <field name="model">vouchers.summary</field>
            <field name="arch" type="xml">
                <tree string="科目明细账" create="false" edit='false'>
                    <field name="date"/>
                    <field name="period_id"/>
                    <field name="voucher_id"/>
                    <button name="view_detail_voucher" type="object" string="查看明细" icon="fa-search"
                         attrs="{'invisible': [('voucher_id','=',False)]}"/>
                    <field name="summary"/>
                    <field name="debit"/>
                    <field name="credit" />
                     <field name="direction"/>
                    <field name="balance"/>
                </tree>
            </field>
        </record>

        <!--明细账 search 视图-->
        <record id="vouchers_summary_search" model="ir.ui.view">
            <field name="name">vouchers.summary.search</field>
            <field name="model">vouchers.summary</field>
            <field name="arch" type="xml">
                <search string="科目明细账">
                    <field name="date"/>
                    <field name="period_id"/>
                    <field name="voucher_id"/>
                    <field name="summary"/>
                     <field name="direction" string="余额方向" domain="[('balance','=',u'平')]"/>
                    <group expand="0" string="分组">
                        <filter string="摘要" domain="[]" context="{'group_by':'summary'}"/>
                        <filter string="单据日期" domain="[]" context="{'group_by':'date:day'}"/>
                    </group>
                </search>
            </field>
        </record>

        <record id="vouchers_summary_action" model="ir.actions.act_window">
            <field name="name">明细账</field>
            <field name="res_model">vouchers.summary</field>
            <field name="type">ir.actions.act_window</field>
            <field name="view_type">form</field>
            <field name="view_mode">tree</field>
        </record>
        <act_window id="create_ledger_account_action"
            name='科目总账'
            res_model="create.vouchers.summary.wizard"
            multi="True"
            view_type="form"
            view_mode="form"
            target="new" 
            context="{'create_general_ledger_account':True}"/>
        
        <record id="general_ledger_account_tree" model="ir.ui.view">
            <field name="name">general_ledger_account_tree</field>
            <field name="model">general.ledger.account</field>
            <field name="arch" type="xml">
                <tree string="科目总账" create="false" edit='false'>
                    <field name="period_id"/>
                    <field name="summary"/>
                    <field name="debit"/>
                    <field name="credit" />
                     <field name="direction"/>
                    <field name="balance"/>
                </tree>
            </field>
        </record>

        <!--总账 search 视图-->
        <record id="general_ledger_account_search" model="ir.ui.view">
            <field name="name">vougeneral.ledger.account.search</field>
            <field name="model">general.ledger.account</field>
            <field name="arch" type="xml">
                <search string="科目总账">
                    <field name="period_id"/>
                    <field name="summary"/>
                     <field name="direction" string="余额方向" domain="[('balance','=',u'平')]"/>
                    <group expand="0" string="分组">
                        <filter string="摘要" domain="[]" context="{'group_by':'summary'}"/>
                    </group>
                </search>
            </field>
        </record>

        <record id="general_ledger_account_action" model="ir.actions.act_window">
            <field name="name">科目总账</field>
            <field name="res_model">general.ledger.account</field>
            <field name="type">ir.actions.act_window</field>
            <field name="view_type">form</field>
            <field name="view_mode">tree</field>
        </record>
     <menuitem id='create_general_ledger_account_menu' action='create_ledger_account_action' parent='voucher_books_menu' sequence='60' name="科目总账"/>
     <menuitem id='create_vouchers_summary_menu' action='create_vouchers_summary_wizard_action' parent='voucher_books_menu' sequence='50' name="科目明细账"/>
     <menuitem id='create_trial_balance_menu' action='create_trial_balance_wizard_action' parent='voucher_books_menu' sequence='22' name="科目余额表"/>
     <menuitem id='check_trial_balance_menu' action='check_trial_balance_wizard_action' parent='voucher_books_menu' sequence='23' name="试算平衡"/>
     <delete  model='ir.ui.menu' id='check_trial_balance_menu' />
    </data>
</openerp>