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

原论坛用户的基本信息和发帖这里都予以保留,请注意:原论坛用户无需重新注册新用户,但是您的密码需要重置

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

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

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



  • openerp\addons\account_test\account_test_data.xml<br /><br /><br /><br />    <record model="accounting.assert.test" id="account_test_02"><br />        <field name="sequence">2</field><br />        <field name="name">Test 2: Opening a fiscal year</field><br />        <field name="desc">Check if the balance of the new opened fiscal year matches with last year's balance</field><br />        <field name="code_exec"><![CDATA[result = []<br />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);")<br />rec =  cr.dictfetchall()<br />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);")<br />rec2= cr.dictfetchall()<br />if (rec2[0]['credit_last_fyear']-rec[0]['credit_new_fyear']!=0) or (rec2[0]['debit_last_fyear']-rec[0]['debit_new_fyear']!=0) :<br />  result.append(('* New fiscalyear debit and credit are:'))<br />  result.append(rec[0])<br />  result.append(('* Last year debit and credit are:'))<br />  result.append(rec2[0])<br /><br />]]></field><br />    </record>



  • openerp\addons\account_test\account_test_data.xml<br /><br /><br /><br />    <record model="accounting.assert.test" id="account_test_02"><br />        <field name="sequence">2</field><br />        <field name="name">Test 2: Opening a fiscal year</field><br />        <field name="desc">Check if the balance of the new opened fiscal year matches with last year's balance</field><br />        <field name="code_exec"><![CDATA[result = []<br />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);")<br />rec =  cr.dictfetchall()<br />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);")<br />rec2= cr.dictfetchall()<br />if (rec2[0]['credit_last_fyear']-rec[0]['credit_new_fyear']!=0) or (rec2[0]['debit_last_fyear']-rec[0]['debit_new_fyear']!=0) :<br />  result.append(('* New fiscalyear debit and credit are:'))<br />  result.append(rec[0])<br />  result.append(('* Last year debit and credit are:'))<br />  result.append(rec2[0])<br /><br />]]></field><br />    </record>



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


登录后回复
 

与 Odoo 中文社区 的连接断开,我们正在尝试重连,请耐心等待