I created a sequence for a class. This is the xml structure that create it: Report Review management.reports_review Report Review management.reports_review %(year)s\ 3

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

CRM
e-Commerce
Contabilidad
Inventario
PoS
Proyecto
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

Where are the sequences?

v7 sequence

2 Respuestas

13198 Vistas

Francesco OpenCode

I created a sequence for a class. This is the xml structure that create it:

    <record id="seq_type_report_review" model="ir.sequence.type">
        <field name="name">Report Review</field>
        <field name="code">management.reports_review</field>
    </record>

    <record id="seq_report_review" model="ir.sequence">
        <field name="name">Report Review</field>
        <field name="code">management.reports_review</field>
        <field name="prefix">%(year)s\</field>
        <field name="padding">3</field>
        <field name="company_id" eval="False"/>
    </record>

And this is the system I use to call the sequence in the class:

def create(self, cr, uid, vals, context=None):
    vals['review_number'] = self.pool.get('ir.sequence').get(cr, uid, 'management.reports_review') or ''
    return super(management_reports_review, self).create(cr, uid, vals, context)

If I create a new voice, the sequence increse by 1. It's ok for me but if I go in the Configuration section the next number voice is always on 1! Why? I would change it but if I change it the sequence go on with is old number.

Brett Lehrer

Mejor respuesta

Depends if you're using standard or no-gap sequence implementation. Check out this function in openerp/addons/base/ir/ir_sequence.py:

def _get_number_next_actual(self, cr, user, ids, field_name, arg, context=None):
    '''Return number from ir_sequence row when no_gap implementation,
    and number from postgres sequence when standard implementation.'''
    res = dict.fromkeys(ids)
    for element in self.browse(cr, user, ids, context=context):
        if  element.implementation != 'standard':
            res[element.id] = element.number_next
        else:
            # get number from postgres sequence. Cannot use
            # currval, because that might give an error when
            # not having used nextval before.
            statement = (
                "SELECT last_value, increment_by, is_called"
                " FROM ir_sequence_%03d"
                % element.id)
            cr.execute(statement)
            (last_value, increment_by, is_called) = cr.fetchone()
            if is_called:
                res[element.id] = last_value + increment_by
            else:
                res[element.id] = last_value
    return res

Using no-gap implementation, the current sequence should be listed directly in the table in ir_sequence. Otherwise, using something like pgAdmin, you can just look directly at the sequence value under "Sequences" -> "ir_sequence_<sequence id="">". Or, referring to that function, a SQL query like:

select last_value from ir_sequence_041;

Why you aren't seeing the updated number on the configuration page is odd. Something else must be going wrong there, but I don't know what. Using updated server source code?

Rachid

   odoo 8: 
modify the file odoo/openerp/addons/base/ir/ir_sequence.py as bellow
 

`
def _predict_nextval(self, cr, seq_id):
    """Predict next value for PostgreSQL sequence without consuming it"""
    # Cannot use currval() as it requires prior call to nextval()
    query = """SELECT last_value,
                      (SELECT increment_by
                       FROM pg_sequences
                       WHERE sequencename = 'ir_sequence_%(seq_id)s'),
                      is_called
               FROM ir_sequence_%(seq_id)s"""
    if cr._cnx.server_version < 100000:
        query = "SELECT last_value, increment_by, is_called FROM ir_sequence_%(seq_id)s"
    cr.execute(query % {'seq_id': seq_id})
    (last_value, increment_by, is_called) = cr.fetchone()
    if is_called:
        return last_value + increment_by
    # sequence has just been RESTARTed to return last_value next time
    return last_value


class ir_sequence(openerp.osv.osv.osv):

 def _get_number_next_actual(self, cr, user, ids, field_name, arg, context=None):
    '''Return number from ir_sequence row when no_gap implementation,
    and number from postgres sequence when standard implementation.'''
    res = dict.fromkeys(ids)
    for element in self.browse(cr, user, ids, context=context):
        if element.implementation != 'standard':
            res[element.id] = element.number_next
        else:
            # get number from postgres sequence. Cannot use
            # currval, because that might give an error when
            # not having used nextval 
            
            seq_id = "%03d" % element.id
            res[element.id] = _predict_nextval(self, cr, seq_id)
    return res
`

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse

Publicaciones relacionadas	Respuestas	Vistas
Problem initializing a field with a sequence v7 sequence	0 mar 15	6039
How to initialize the invoice sequence number every month ? v7 sequence account.invoice	3 dic 23	8182
Different sequence number of Quotations and sales order? Resuelto sales v7 sequence	1 mar 15	8259
Auto-increment Ref# in Journal Voucher development v7 sequence	0 mar 15	4918
Different sequence number of RFQ and Purchase Order? Resuelto purchase v7 sequence	1 mar 15	7195

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!