Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Все посты Люди Значки
Теги (Смотреть все)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
4 Ответы
11943 Представления
Аватар
birduser

I try to implement numbering positions in invoices. I got a field "position" in the one2many field and it looks like this

<field name="invoice_line" widget="one2many_list" context="{'type': type,'order_id':active_id}">
      <field name="position"/>
(..)

My class

class account_invoice_line(osv.osv):
    _inherit = 'account.invoice.line'
    _columns = {
        'position': fields.char('Position'),
    }

    def position_number(self, cr, uid, context=None):
        return ACTUAL ROW NUMBER

    _defaults = {
        'position': lambda obj, cr, uid, context: obj.position_number(cr, uid, context),
    }

account_invoice_line()

I have no Idea how to get the actual row number or how to count the rows. I found this, but it's not working :-/

def _default_sequence(self, cr, uid, context=None):
        if context is None:
            context = {}
        max_sequence = 0
        if context.get('order_id'):
            sale_order_line_ids = self.search(cr, uid, [('order_id', '=', context['order_id'])])
            if sale_order_line_ids:
                max_sequence = max([line['position'] for line in self.read(cr, uid, sale_order_line_ids, ['position'])])
        return max_sequence + 1

    _defaults = {
        'sequence': lambda obj, cr, uid, context: obj._default_sequence(cr, uid, context),
    }

Can anybody help me?

Аватар
Отменить
Аватар
Hardikgiri Goswami
Лучший ответ

I have do it using on_change attribute of order_line. I have made changes in xml like this.

<field name="order_line" on_change="update_seq(order_line)">

and the python side in sale.order added following method.

def update_seq(self, cr, uid, ids, order_line, context=None):
        new_order_line = []
        counter = 1
        for line in order_line:
            if line[0] in [1,4]:
                line[0] = 1
            if type(line[2]) == type({}):
                line[2].update({'seq':counter})
            else:
                line[2] = {'seq':counter}
            counter = counter + 1
            new_order_line.append(line)
        return {'value': {'order_line': new_order_line} }

Just try it. and post here if any problem occurs.

Аватар
Отменить
birduser
Автор

Okay, I tried it, but I have the problem, that the onchange function won't be executed. So I have a field: <field name="position" on_change="position_number(cr, uid, context)"/> and a function "def position_number(self, cr, uid, context=None): print("bla")" but the function will not be executed. Why?

Hardikgiri Goswami

Because, from the XML part you can not pass cr, uid and context. These are the default parameter that OpenERP core will be pass automatically. That's is the only reason the method is not going to execute.

Аватар
Kevin Kong
Лучший ответ

I just have an app to slove this problem. search rowno in app store.

Аватар
Отменить