Skip to Content
Menu
This question has been flagged
4531 Views

Good evening,

I am having trouble reading the record and loading it into the dataframe, please appreciate your help.

odoo: 11

thanks,

Traceback (most recent call last):

  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 205, in run_wsgi

    execute(self.server.app)

  File "/usr/lib/python3/dist-packages/werkzeug/serving.py", line 193, in execute

    application_iter = app(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 260, in app

    return self.app(e, s)

  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 166, in application

    return application_unproxied(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/service/wsgi_server.py", line 154, in application_unproxied

    result = handler(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1319, in __call__

    return self.dispatch(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1293, in __call__

    return self.app(environ, start_wrapped)

  File "/usr/lib/python3/dist-packages/werkzeug/wsgi.py", line 599, in __call__

    return self.app(environ, start_response)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1491, in dispatch

    result = ir_http._dispatch()

  File "/usr/lib/python3/dist-packages/odoo/addons/auth_signup/models/ir_http.py", line 19, in _dispatch

    return super(Http, cls)._dispatch()

  File "/usr/lib/python3/dist-packages/odoo/addons/web_editor/models/ir_http.py", line 22, in _dispatch

    return super(IrHttp, cls)._dispatch()

  File "/usr/lib/python3/dist-packages/odoo/addons/http_routing/models/ir_http.py", line 393, in _dispatch

    result = super(IrHttp, cls)._dispatch()

  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_http.py", line 212, in _dispatch

    return cls._handle_exception(e)

  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_http.py", line 182, in _handle_exception

    return request._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 771, in _handle_exception

    return super(HttpRequest, self)._handle_exception(exception)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 310, in _handle_exception

    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise

    raise value

  File "/usr/lib/python3/dist-packages/odoo/addons/base/ir/ir_http.py", line 208, in _dispatch

    result = request.dispatch()

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 830, in dispatch

    r = self._call_function(**self.params)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 342, in _call_function

    return checked_call(self.db, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper

    return f(dbname, *args, **kwargs)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 335, in checked_call

    result = self.endpoint(*a, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 937, in __call__

    return self.method(*args, **kw)

  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap

    response = f(*args, **kw)

  File "/mnt/extra-addons/report_xlsx/controllers/main.py", line 30, in report_routes

    docids, data=data

  File "/mnt/extra-addons/report_xlsx/models/ir_report.py", line 21, in render_xlsx

    }).create_xlsx_report(docids, data)

  File "/mnt/extra-addons/report_comprobantes_efact/models/invoice_line_wi.py", line 36, in create_xlsx_report

    self.generate_xlsx_report(workbook, data, objs)

  File "/mnt/extra-addons/report_comprobantes_efact/models/invoice_line_wi.py", line 51, in generate_xlsx_report

    for lista in listadireccionario.itervalues():

AttributeError: 'list' object has no attribute 'itervalues'

*************

from odoo import models,fields,api,_
import pandas as pd
import numpy as np
.......
.....
...
..
def generate_xlsx_report(selfworkbookdatarecords):
        fecha_inicio = data.get("fecha_inicio",False)
        fecha_fin = data.get("fecha_fin",False)
        records = []
        listadireccionario = self._sql_get_line_for_report(fecha_inicio,fecha_fin)
        
        number=""
        product_id=0

        for lista in listadireccionario.itervalues():
            for value in lista:
                number.send_keys(value)
                product_id.send_keys(value)
                records.append({
                    "number":number,
                    "product_id":product_id,
                })

        df_states_0 = pd.DataFrame(records,columns=["Number",
                                                    "Itemcode"])
        
        df_states_0.to_excel(workbook, sheet_name='Detalle_Facturas')


        
    def _sql_get_line_for_report(self,fecha_inicio,fecha_fin):
        self.env['account.invoice.line'].check_access_rights('read')
        query = """select 
                    f.number,df.product_id from account_invoice_line df inner join account_invoice f on f.id=df.id
                """
        params = [
            fecha_inicio, fecha_fin
        ]

        self.env.cr.execute(query, tuple(params))
        
        return self.env.cr.dictfetchall()
Avatar
Discard