Try this
import xlwt import xlrd import os import win32com.client import base64 from datetime import datetime from odoo import tools from odoo import fields, models, api ADDONS_PATH = tools.config['addons_path'].split(",")[-1]
class CreateReport(models.Model):
_inherit = "purchase.order"
@api.multi
def action_wizard_open(self):
context = dict(self.env.context or {})
self.ensure_one()
context.update({'act_id':self.id})
return {
'type': 'ir.actions.act_window',
'view_type' : 'form',
'view_mode' : 'form',
'res_model' : 'report.wizard',
'target' : 'new',
'context' : context,
}
class PaymentWizard(models.TransientModel):
_name = 'report.wizard'
_description = 'Report Details'
attachment = fields.Binary('File', nodrop=True, readonly= True)
attach_name = fields.Char('Attachment Name')
@api.multi
def get_values(self):
context = dict(self.env.context or {})
vals = context.get('act_id')
purchase = {}
purchase_value = []
rec = self.env['purchase.order'].search([('id','=',vals)])
purchase['date_planned'] = rec.date_planned
purchase['picking_type_id'] = rec.picking_type_id.name
purchase['invoice_status'] = rec.invoice_status
purchase['payment_term_id'] = rec.payment_term_id.id
purchase['details'] = rec.name
purchase['reference'] = rec.partner_id.name
for line in rec.order_line:
order = {}
order['product_id'] = line.product_id.name
order['name'] = line.name
order['date_planned'] = line.date_planned
order['company_id'] = line.company_id.name
order['product_qty'] = line.product_qty
order['qty_received'] = line.qty_received
order['qty_invoiced'] = line.qty_invoiced
order['price_unit'] = line.price_unit
order['taxes_id'] = line.taxes_id.name
order['price_subtotal'] = line.price_subtotal
purchase_value.append(order)
purchase['orders'] = purchase_value
style0 = xlwt.easyxf('font: name Times New Roman, bold on; pattern: pattern solid, fore_colour white;', num_format_str='#,##0.00')
style1 = xlwt.easyxf('font: name Times New Roman, bold 1,height 250; pattern: pattern solid, fore_colour aqua;', num_format_str='#,##0.00')
workbook = xlwt.Workbook()
sheet = workbook.add_sheet('Purchase Order Report')
sheet.write_merge(1, 1, 2, 5, 'Purchase No.', style1)
sheet.write_merge(1, 1, 6, 7, purchase['details'], style1)
sheet.write(3, 2, 'Vendor Name', style0)
sheet.write(3, 4, purchase['reference'], style0)
sheet.write(4, 2, 'Scheduled Date', style0)
sheet.write(4, 4, purchase['date_planned'], style0)
sheet.write(5, 2, 'Deliver To', style0)
sheet.write(5, 4, purchase['picking_type_id'], style0)
sheet.write(6, 2, 'Bill Status', style0)
sheet.write(6, 4, purchase['invoice_status'], style0)
sheet.write(7, 2, 'Payments', style0)
sheet.write(7, 4, purchase['payment_term_id'], style0)
sheet.write_merge(9, 9, 1, 2, 'Product', style1)
sheet.write_merge(9, 9, 3, 4,'Description', style1)
sheet.write_merge(9, 9, 5, 6,'Date', style1)
sheet.write_merge(9, 9, 7, 8, 'Company', style1)
sheet.write_merge(9, 9, 9, 10, 'Quantity', style1)
sheet.write_merge(9, 9, 11, 12, 'Unit Price', style1)
n = 10
for order in purchase['orders']:
sheet.write_merge(n, n, 1, 2, order['product_id'], style0)
sheet.write_merge(n, n, 3, 4, order['name'], style0)
sheet.write_merge(n, n, 5, 6, order['date_planned'], style0)
sheet.write_merge(n, n, 7, 8, order['company_id'], style0)
sheet.write_merge(n, n, 9, 10, order['product_qty'], style0)
sheet.write_merge(n, n, 11, 12, order['price_unit'], style0)
n += 1
ams_time = datetime.now()
date = ams_time.strftime('%m-%d-%Y %H.%M.%S')
filename = os.path.join(ADDONS_PATH, 'Report'+ '-' + date +'.xls')
workbook.save(filename)
fp = open(filename, "rb")
file_data =fp.read()
out = base64.encodestring(file_data)
# excel = win32com.client.Dispatch(filename)
# workbook = excel.Workbooks.open(')
# workbook.SaveAs('unencrypted.xls')
attach_vals = {
'attach_name': 'Report'+ '-' + date +'.xls',
'attachment': out,
}
fp.close()
os.remove(filename)
self.write(attach_vals)
return {
'type': 'ir.actions.act_window',
'name': ('Report'),
'res_model': 'report.wizard',
'res_id': self[0].id,
'view_type': 'form',
'view_mode': 'form',
'target': 'new',
'nodestroy': True,
}
