您好,我已经使用SQL查询创建了一个简单的树状视图,但是现在我也想下载它,但由于没有任何一个one2many字段,所以我无法下载,所以我无法下载它>
现在它给我每页一行的报告,但是我希望所有行都在一起,我希望它们以pdf格式而不是xls格式。我曾尝试将查询到的数据存储在一个数组中,但这对我不起作用,即使我们可以做到,我也不知道
class PostgresReport(models.Model):
'''
This module is responsible for all of the requisition related operations.
'''
_name = 'purchase.comp'
_auto = False
#all fields
name = fields.Char(string = 'Purchase Order')
origin = fields.Char(string ='Purchase Agreement')
date_order = fields.Datetime('Order Date',index=True,copy=False)
state = fields.Selection([
('draft','RFQ'),('sent','RFQ Sent'),('to approve','To Approve'),('purchase','Purchase Order'),('done','Locked'),('cancel','Cancelled')
],string='Status',readonly=True,copy=False,default='draft',track_visibility='onchange')
product_id = fields.Char(string='Product')
product_qty = fields.Float(string='Quantity')
price_unit = fields.Float(string='Unit Price')
price_subtotal = fields.Monetary(string='Subtotal',store=True)
vendor = fields.Char(string='Vendor')
currency_id = fields.Char('Currency')
'''
This function is responsible for fetching data from 3 different tables and displaying it
'''
@api.model_cr
def init(self,_logger=None):
""" Event Question main report """
query = []
tools.drop_view_if_exists(self._cr,'purchase_comp')
view = self._cr.execute(""" CREATE VIEW purchase_comp AS (
SELECT
b.id as id,a.name as "name",a.origin as "origin",a.date_order as "date_order",a.state as "state",b.name as "product_id",b.product_qty as "product_qty",b.price_unit as "price_unit",b.price_subtotal as "price_subtotal",c.display_name as "vendor",d.name as "currency_id"
FROM public.purchase_order as a
inner join
public.purchase_order_line as b
on a.id = b.order_id
inner join
public.res_partner as c
on a.partner_id = c.id
inner join
public.res_currency as d
on d.id = b.currency_id
WHERE a.origin != ''
order by a.name
)""")
我不发布Web代码,因为它简单明了。请从.py代码中告诉我,我可以使用哪个字段进行XML循环,如果在这种情况下不能使用任何内容,该怎么办。预先感谢