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

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Where are the sequences?

v7 sequence

2 Antwoorden

14427 Weergaven

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

Beste antwoord

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
`

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
Problem initializing a field with a sequence v7 sequence	0 mrt. 15	7271
How to initialize the invoice sequence number every month ? v7 sequence account.invoice	3 dec. 23	9462
Different sequence number of Quotations and sales order? Opgelost sales v7 sequence	1 mrt. 15	9194
Auto-increment Ref# in Journal Voucher development v7 sequence	0 mrt. 15	5841
Different sequence number of RFQ and Purchase Order? Opgelost purchase v7 sequence	1 mrt. 15	8058

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!