from odoo import models, fields
from io import BytesIO
import base64
import openpyxl
import re


class ImportLines(models.Model):
_name = 'import.lines'

xls_file = fields.Binary('File')

def import_xls(self):
    """  Import xlsx report to saleOrder line """
    wb = openpyxl.load_workbook(
        filename=BytesIO(base64.b64decode(self.xls_file)),
        read_only=True
    )
    ws = wb.active
    for record in ws.iter_rows(min_row=2, max_row=None, min_col=None,
                              max_col=None, values_only=True):
        active_id = self.env.context.get('active_id')
        product = record[2]
        if product:
            val = product.split()
            string = re.sub("[\([{})\]]", "", val[0])
            new = self.env['sale.order.line'].create({
                'order_id': active_id,
                'display_type': False,
                'product_id':  self.env['product.product'].search([
                            ('default_code', '=', string)]).id,
                'name': record[0],
                'product_uom_qty': record[1],
                'price_unit': record[3],
                'product_uom':  self.env['uom.uom'].search([
                            ('name', '=', record[4])]).id
            })

    return new