Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

客户关系管理
e-Commerce
会计
库存
PoS
项目
MRP

All apps

所有帖文人徽章

标签（查看所有）

odoo accounting v14 pos v15

关于此论坛区

帮助

create sequence with button to increment it

sequence button

4 回复

2742 查看

Oliver

Hello all,

i am new in Odoo and i try my first steps to create a sequece and a button to increment it on button click.

I created my own module and added my files.

Here my files:

debit_card.py

from odoo import models, fields, api, _

class DebitCard(models.Model):
    _name="debit.card"
    _description="Debit Card"
    
    debit_seq = fields.Char(
        string="Debit Card Datev Sequence",
        required=True,
        copy=False,
        readonly=True,
        index=True,
        default=lambda self: _("New"))

    @api.model
    def create(self, vals):
        if vals.get('debit_seq', _('New')) == _('New'):
            vals['debit_seq'] = self.env['ir.sequence'].next_by_code('debit.card.sequence.code') or _('New')
        result = super(DebitCard, self).create(vals)
        return result

debit_card_view.xml (can´t post correct code. don´t know why...)


        (record id="debit_card_form_view" model="ir.ui.view")
            (field name="name")debit.card.form.view(/field)
            (field name="model")debit.card(/field)
            (field name="arch")type="xml"(/field)
             (form string="Debit Card")
                    (div)Hello World! (/div)
                    (field name="debit_seq" style="font-size:22px;font-weight:bold;"/)
             (/form)
          (/field)
        (/record)

sequence.xml

(odoo)
    (data noupdate="1")
        (!-- Sequence for debit.card //--)
        (record id="debit_card_datev_sequence" model="ir.sequence")
            (field name="name")Debit Card Datev Sequence(/field)
            (field name="code")debit.card.sequence.code(/field)
            (field name="padding")7(/field)
            (field name="number_next")62071(/field)
            (field name="number_increment")1(/field)
            (field name="company_id" eval="False"/)
        (/record)
    (/data)
(/odoo)

Now, if i call the debit card it shows me: "Hello World!"

But no sequence but "New"

I found many "examples" on web search but nothing helps me.

Where is the issue for not showing the sequence?

And how to implement a button to increment the sequence on click?

Mohamed Rizwan

Hi,

you can create a button like

def seq_increment(self):
for rec in self:
rec.debit_seq = self.env['ir.sequence'].next_by_code('debit.card.sequence.code')

and xml would like

(record id="debit_card_form_view" model="ir.ui.view")
            (field name="name")debit.card.form.view(/field)
            (field name="model")debit.card(/field)
            (field name="arch")type="xml"(/field)
             (form string="Debit Card")
                    (header)
					(button name="seq_increment" type="object" string="Increment" class="oe_highlight" id="button_seq_increment"/)
				(/header)
             (/form)
          (/field)
        (/record)

thanks

Oliver

编写者

Thank you very much. It works fine but it doesn`t use the next_number. I changed the field name next_number to next_number_actual because in Settings-Technical-Sequences the field name for the next number is: next_number_actual.
And if i call the "page" debit card first, it always shows "New". Is this because in the field declaration is the default value lambda self: _("New")? If yes, how may i show the current value of the sequence?

Niyas Raphy (Walnut Software Solutions)

Hi,
If you already have a sequence record and if you need to increment the sequence value on a button click, inside the button function, you can add below line of code to get next number from the sequence.

Code: self.env['ir.sequence'].next_by_code('code_Value_of_Sequence')

Thanks

Oliver

编写者

The titel changed the value after clicking on the "increment button" and i don`t know why.

Can anyone explain me this behavior?

befor click:

after clicked.

Mohamed Rizwan

by default, odoo is taking field 'name' as the record name, if your model doesnt have a field called 'name' it will shows as model_name,record_id, in your case it is debit.card,11.

if you need to show any other field as the record name, kindly provide that field in _rec_name after declaring the model name.

ie;
_name = 'debit.card'
_description = 'Debit Card Details'
_rec_name = 'seq_increment'

this will solve your issue.

thanks

Cybrosys Techno Solutions Pvt.Ltd

Hi,

You should declare your sequence field in XML view to display it.

Like this, <field name="name"/>

Hope it helps

Oliver

编写者

The sequence field is declared in the xml view but it displayed always "New".
I need help for adding a button to increment the sequence and update the field output.

喜欢讨论吗？不要只阅读，加入进来！

立即创建账户，享受专属功能，与我们的精彩社区互动！

相关帖文	回复	查看
Sequence Prefix sequence	0 2月 23	6461
Opening new window with button in OpenERP 已解决 button	1 1月 24	15322
How to customize the invoice,bill and journal name sequence sequence	0 1月 23	95
What is the best (correct) way to create sequence ? py or xml? 已解决 sequence	1 10月 22	5216
Deleted a sequence sequence	0 4月 22	3616

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！