class:
import time
from openerp.osv import osv
from openerp.report import report_sxw
class stock_picking_out(report_sxw.rml_parse):
def __init__(self, cr, uid, name, context):
super(stock_picking_out, self).__init__(cr, uid, name, context=context)
self.localcontext.update({
'time': time,
'get_partner_product': self._get_partner_product,
})
# todo 获取客户产品编码:
def _get_partner_product(self, partner, product_id):
sql = """SELECT cp.partner_default_code FROM customer_product cp
LEFT JOIN res_partner rp ON rp.id = cp.partner_id
WHERE cp.product_id = %s AND cp.partner_id = %s"""
self.cr.execute(sql, (product_id, partner))
sql_data = self.cr.fetchall()
if len(sql_data) > 0:
for obj in sql_data:
partner_default_code = obj[0]
return partner_default_code
return ''
class report_stockpickingout(osv.AbstractModel):
_name = 'report.report_stock.report_stockpickingout'
_inherit = 'report.abstract_report'
_template = 'report_stock.report_stockpickingout'
_wrapped_report_class = stock_picking_out
Report_view:
<td class="text-left"> <span t-esc="get_partner_product(doc.partner_id.id,l.product_id.id)"/></td>
QWebException: "'NoneType' object is not callable" while evaluating
'get_partner_product(doc.partner_id.id,l.product_id.id)'
Answer:
在"_name"时,路径的错误,必须要添加上"report"的引用:
class report_stockpickingout(osv.AbstractModel):
_name = 'report.report_stock.report_stockpickingout'
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。