mirror of
https://github.com/OCA/account-reconcile.git
synced 2025-01-20 12:27:39 +02:00
121 lines
4.4 KiB
Python
121 lines
4.4 KiB
Python
# -*- coding: utf-8 -*-
|
|
##############################################################################
|
|
#
|
|
# Copyright 2012-2013 Camptocamp SA (Guewen Baconnier)
|
|
# Copyright (C) 2010 Sébastien Beau
|
|
#
|
|
# This program is free software: you can redistribute it and/or modify
|
|
# it under the terms of the GNU Affero General Public License as
|
|
# published by the Free Software Foundation, either version 3 of the
|
|
# License, or (at your option) any later version.
|
|
#
|
|
# This program is distributed in the hope that it will be useful,
|
|
# but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
# GNU Affero General Public License for more details.
|
|
#
|
|
# You should have received a copy of the GNU Affero General Public License
|
|
# along with this program. If not, see <http://www.gnu.org/licenses/>.
|
|
#
|
|
##############################################################################
|
|
|
|
import logging
|
|
from openerp.osv.orm import AbstractModel, TransientModel
|
|
|
|
_logger = logging.getLogger(__name__)
|
|
|
|
|
|
class EasyReconcileSimple(AbstractModel):
|
|
_name = 'easy.reconcile.simple'
|
|
_inherit = 'easy.reconcile.base'
|
|
|
|
# has to be subclassed
|
|
# field name used as key for matching the move lines
|
|
_key_field = None
|
|
|
|
def rec_auto_lines_simple(self, cr, uid, rec, lines, context=None):
|
|
if self._key_field is None:
|
|
raise ValueError("_key_field has to be defined")
|
|
count = 0
|
|
commit_count = 0
|
|
res = []
|
|
while (count < len(lines)):
|
|
for i in xrange(count + 1, len(lines)):
|
|
if lines[count][self._key_field] != lines[i][self._key_field]:
|
|
break
|
|
check = False
|
|
if lines[count]['credit'] > 0 and lines[i]['debit'] > 0:
|
|
credit_line = lines[count]
|
|
debit_line = lines[i]
|
|
check = True
|
|
elif lines[i]['credit'] > 0 and lines[count]['debit'] > 0:
|
|
credit_line = lines[i]
|
|
debit_line = lines[count]
|
|
check = True
|
|
if not check:
|
|
continue
|
|
reconciled, dummy = self._reconcile_lines(
|
|
cr, uid, rec, [credit_line, debit_line],
|
|
allow_partial=False, context=context)
|
|
if reconciled:
|
|
commit_count += 1
|
|
res += [credit_line['id'], debit_line['id']]
|
|
del lines[i]
|
|
if (context['commit_every'] and
|
|
commit_count % context['commit_every'] == 0):
|
|
cr.commit()
|
|
_logger.info(
|
|
"Commit the reconciliations after %d lines",
|
|
count)
|
|
break
|
|
count += 1
|
|
return res, [] # empty list for partial, only full rec in "simple" rec
|
|
|
|
def _simple_order(self, rec, *args, **kwargs):
|
|
return "ORDER BY account_move_line.%s" % self._key_field
|
|
|
|
def _action_rec(self, cr, uid, rec, context=None):
|
|
"""Match only 2 move lines, do not allow partial reconcile"""
|
|
select = self._select(rec)
|
|
select += ", account_move_line.%s " % self._key_field
|
|
where, params = self._where(rec)
|
|
where += " AND account_move_line.%s IS NOT NULL " % self._key_field
|
|
|
|
where2, params2 = self._get_filter(cr, uid, rec, context=context)
|
|
query = ' '.join((
|
|
select,
|
|
self._from(rec),
|
|
where, where2,
|
|
self._simple_order(rec)))
|
|
|
|
cr.execute(query, params + params2)
|
|
lines = cr.dictfetchall()
|
|
return self.rec_auto_lines_simple(cr, uid, rec, lines, context)
|
|
|
|
|
|
class EasyReconcileSimpleName(TransientModel):
|
|
_name = 'easy.reconcile.simple.name'
|
|
_inherit = 'easy.reconcile.simple'
|
|
|
|
# has to be subclassed
|
|
# field name used as key for matching the move lines
|
|
_key_field = 'name'
|
|
|
|
|
|
class EasyReconcileSimplePartner(TransientModel):
|
|
_name = 'easy.reconcile.simple.partner'
|
|
_inherit = 'easy.reconcile.simple'
|
|
|
|
# has to be subclassed
|
|
# field name used as key for matching the move lines
|
|
_key_field = 'partner_id'
|
|
|
|
|
|
class EasyReconcileSimpleReference(TransientModel):
|
|
_name = 'easy.reconcile.simple.reference'
|
|
_inherit = 'easy.reconcile.simple'
|
|
|
|
# has to be subclassed
|
|
# field name used as key for matching the move lines
|
|
_key_field = 'ref'
|