Odoo 中文社区

    • Register
    • Login
    • Search
    • Categories
    • Tags
    • Popular
    • Users
    • Groups

    Odoo中文社区可以通过以下两个域名访问:shine-it.net , odoo.net.cn

    由于系统升迁的原因,本论坛部分较早期的内容存在格式和链接损坏失效的问题,并非本论坛系统本身的缺陷,望谅解

    本社区没有维护任何QQ群讨论组,任何与本社区同名的QQ群讨论组的言论与本社区无关!

    开发人员可以登录gitter讨论组: http://gitter.im/odoo-china/Talk, 需要github账号

    如果您登录系统碰到问题,请在微信公众号留言:

    XML 中直接定义 python 脚本 和 sql 语句提取数据

    Odoo 开发与实施交流
    2
    3
    2971
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • C
      ccdos last edited by

      openerp\addons\account_test\account_test_data.xml



          <record model="accounting.assert.test" id="account_test_02">
              <field name="sequence">2</field>
              <field name="name">Test 2: Opening a fiscal year</field>
              <field name="desc">Check if the balance of the new opened fiscal year matches with last year's balance</field>
              <field name="code_exec"><![CDATA[result = []
      cr.execute("select coalesce(sum(debit),0) as debit_new_fyear,coalesce(sum(credit),0) as credit_new_fyear from account_move_line where period_id in (select id from account_period where state='draft' and special order by id desc limit 1);")
      rec =  cr.dictfetchall()
      cr.execute("select coalesce(sum(debit),0) as debit_last_fyear,coalesce(sum(credit),0) as credit_last_fyear from account_move_line where period_id in (select period_id from account_fiscalyear where state='done' order by id desc limit 1);")
      rec2= cr.dictfetchall()
      if (rec2[0]['credit_last_fyear']-rec[0]['credit_new_fyear']!=0) or (rec2[0]['debit_last_fyear']-rec[0]['debit_new_fyear']!=0) :
        result.append(('* New fiscalyear debit and credit are:'))
        result.append(rec[0])
        result.append(
      ('* Last year debit and credit are:'))
        result.append(rec2[0])

      ]]></field>
          </record>

      1 Reply Last reply Reply Quote 0
      • mrshelly
        mrshelly last edited by

        这个也只是定义. 尚未执行.
        要执行的话, 应该是 xml 中的 function tag...

        1 Reply Last reply Reply Quote 0
        • First post
          Last post