Merge lp:~a-camilli/openobject-italia/6.1-fix-controllo-data-registrazione-consecutiva into lp:~openobject-italia-core-devs/openobject-italia/italian-addons-6.1

[Alessandro Camilli]

Controllo consecutività data registrazione fattura

[Sergio Corato (icsergio)]

Non è sufficiente verificare solo per periodo, in quanto così facendo si possono registrare ancora fatture in tutti i periodi precedenti senza problemi.

Vuoi provare con un sql che ragiona tipo così, legato all'anno e slegato dal numero (conta l'ultima data di registrazione sul sezionale):
SELECT max(ai.registration_date)
  FROM account_invoice ai LEFT JOIN account_period ap
  ON ai.period_id = ap.id
  LEFT JOIN account_fiscalyear af
  ON af.id = ap.fiscalyear_id
  WHERE ai.journal_id = %s AND af.name = '%s';

review: Needs Fixing

[Sergio Corato (icsergio)]

Superata

review: Disapprove

[Lorenzo Battistini (elbati)]

On 10/03/2013 10:35 PM, Sergio Corato wrote:
> Review: Disapprove
>
> Superata

Da questa
https://code.launchpad.net/~icsergio/openobject-italia/fix_sequential_dates_61/+merge/184182
<https://code.launchpad.net/%7Eicsergio/openobject-italia/fix_sequential_dates_61/+merge/184182>

Unmerged revisions

231. By Alessandro Camilli on 2013-05-06

controllo consecutività data registrazione

=== modified file 'account_invoice_entry_date/invoice.py'
--- account_invoice_entry_date/invoice.py	2011-09-09 08:48:18 +0000
+++ account_invoice_entry_date/invoice.py	2013-05-06 07:29:27 +0000
@@ -49,6 +49,22 @@
                 if (date_invoice > reg_date) :
                     raise osv.except_osv(_('Error date !'), _('The invoice date cannot be later than the date of registration!'))
 
+            # Consecutività nr fattura/data
+            statement_internal_number = ""
+            if inv.internal_number :
+                statement_internal_number = " AND name > '%s'" % (inv.internal_number,)
+            cr.execute('SELECT date,name FROM account_move ' \
+                'WHERE journal_id=%s AND state = %s' \
+                    'AND period_id=%s ' + statement_internal_number + ' '\
+                'ORDER BY name limit 1' , 
+                (inv.journal_id.id, 'posted', inv.period_id.id))
+            move = cr.fetchone()
+            if move and len(move) > 0 :
+                date_last = move[0]
+                name_last = move[1]
+                if reg_date < date_last :
+                    raise osv.except_osv(_('Error !'), _('Date entry not consecutive. The last invoice is : %s  %s') % (name_last, date_last))
+                
             #periodo
             date_start = inv.registration_date or inv.date_invoice or time.strftime('%Y-%m-%d')
             date_stop = inv.registration_date or inv.date_invoice or time.strftime('%Y-%m-%d')