我想在请购单上做个报告模块。那么这是到目前为止我已经做的。 采购申请_报表.py在
from odoo import models, fields, api
class purchase_requisition_report(models.Model):
_name = 'purchase.requisition.report'
_description="Purchase Requisition Report"
_column={
'date': fields.datetime('Order Date', readonly=True, help="Date on which this document has been created"),
'state': fields.selection([('draft', 'Request for Quotation'),
('confirmed', 'Waiting Supplier Ack'),
('approved', 'Approved'),
('done', 'Done'),
('cancel', 'Cancelled')], 'Purchase Requisition Status', readonly=True),
'name': fields.char('Purchase Requisition No'),
'product_id': fields.many2many('product.product','Product Name'),
'supplier': fields.many2many('res.partner','Supplier Name'),
}
_order = 'date desc'
def init(self, cr):
tools.sql.drop_view_if_exists(cr, 'purchase_requisition_report')
cr.execute("""
create or replace view purchase_requisition_report as (
SELECT
purchase_requisition.name,
product_product.name_template,
res_partner.display_name,
purchase_order.name,
purchase_requisition.state
FROM
purchase_requisition_line inner join purchase_requisition on(purchase_requisition_line.requisition_id = purchase_requisition.id)
inner join product_product on(purchase_requisition_line.product_id = product_product.id)
inner join purchase_order on(purchase_order.requisition_id = purchase_requisition.id)
inner join res_partner on(purchase_order.partner_id = res_partner.id);
""")
采购申请报告_视图.xml在
^{pr2}$在打开程序.py在
{
'name': 'Purchase Requisitions',
'version': '0.1',
'author': 'OpenERP SA',
'category': 'Purchase Management',
'website': 'https://www.odoo.com/page/purchase',
'description': """
This module allows you to manage your Purchase Requisition.
===========================================================
When a purchase order is created, you now have the opportunity to save the
related requisition. This new object will regroup and will allow you to easily
keep track and order all your purchase orders.
""",
'depends' : ['purchase'],
'demo': ['purchase_requisition_demo.xml'],
'data': ['views/purchase_requisition.xml',
'security/purchase_tender.xml',
'wizard/purchase_requisition_partner_view.xml',
'wizard/bid_line_qty_view.xml',
'purchase_requisition_data.xml',
'purchase_requisition_view.xml',
'purchase_requisition_report.xml',
'report/purchase_requisition_report_view.xml',
'purchase_requisition_workflow.xml',
'security/ir.model.access.csv','purchase_requisition_sequence.xml',
'views/report_purchaserequisition.xml',
],
'auto_install': False,
'test': [
'test/purchase_requisition_users.yml',
'test/purchase_requisition_demo.yml',
'test/cancel_purchase_requisition.yml',
'test/purchase_requisition.yml',
],
'installable': True,
}
在做了所有这些之后,我得到了以下错误
Error details:
Model not found: purchase.requisition.report
Error context:
View `purchase.requisition.report.tree`
[view_id: 1419, xml_id: n/a, model: purchase.requisition.report, parent_id: n/a]" while parsing file:///C:/Program%20Files/Odoo%208.0-20150515/server/openerp/addons/purchase_requisition/report/purchase_requisition_report_view.xml:5, near
<record id="view_purchase_requisition_report_tree" model="ir.ui.view">
<field name="name">purchase.requisition.report.tree</field>
<field name="model">purchase.requisition.report</field>
<field name="arch" type="xml">
<tree string="Purchase Requisition Report">
<field name="name"/>
<field name="product_id"/>
<field name="supplier"/>
<field name="state"/>
</tree>
</field>
</record>
我无法找出错误在哪里,谢谢救命。谢谢你。 P.S:我用的是Odoo V.8
你的日志应该充满了导入错误。如果您使用的是odoov8,那么应该使用},因为那时Odoo包不存在,所以您需要这样做:
openerp
,而不是{我已经在
^{pr2}$imports
中包含了工具,因为您没有包含。另外,如果要创建一个用作模型表的SQL视图,则应指示ORM不要尝试为模型创建表,添加:之后,如果在Odoo服务器启动时没有在日志中看到任何其他错误,则应该可以
未导入的代码不会被执行,因此可能找不到它。在
从模块的
__init__.py
文件导入它:相关问题 更多 >
编程相关推荐