eiru_account_bank_statement_utility/models/cashbox_statement_cancel.py

# -*- coding: utf-8 -*-
from openerp import models, fields, tools, api
from datetime import datetime
from pytz import timezone
import openerp.addons.decimal_precision as dp

DATE_FORMAT = '%Y-%m-%d'

class eiru_account_statement_cancel(models.Model):
    _inherit = 'account.bank.statement'

    @api.model
    def eiru_get_bank_statement_cancel(self, id):
        return [{
            'id': statement.id,
            'name': statement.name,
            'state': statement.state,
            'date': statement.date,
            'currencystatement': {
                'id': statement.currency.id,
                'symbol': statement.currency.symbol,
                'rate': statement.currency.rate,
                'thousandsSeparator': statement.currency.thousands_separator,
                'decimalSeparator': statement.currency.decimal_separator,
                'decimalPlaces': statement.currency.decimal_places,
                'position': statement.currency.position,
            },
            'user': {
                'id': statement.user_id.id,
                'name': statement.user_id.name
            },
            'statementTransfer': [{
                'id': transfer.id,
                'name': transfer.name,
                'amount': transfer.amount,
                'ref': transfer.ref,
                'date': transfer.date,
                'outputStatement':{
                    'id': transfer.output_statement.id,
                    'name': transfer.output_statement.name,
                    'state': transfer.output_statement.state,
                    'statementUser': "%s/%s" % ((transfer.output_statement.name), (transfer.output_statement.user_id.name))
                },
                'inputStatement':{
                    'id': transfer.input_statement.id,
                    'name': transfer.input_statement.name,
                    'state': transfer.input_statement.state,
                    'statementUser': "%s/%s" % ((transfer.input_statement.name), (transfer.input_statement.user_id.name))
                },
                'outputLineId': transfer.output_line.id,
                'inputLineId': transfer.input_line.id,
                'type': 'in' if (transfer.input_statement.id == statement.id) else 'out'
            } for transfer in self.env['cash.box.transfer'].search(['|', ('output_statement.id','=',statement.id), ('input_statement.id','=',statement.id)])],
            'statementConfirm': [{
                'id': casBox.id,
                'name': casBox.name,
                'amountStatement': casBox.amount_statement,
                'amountReal': casBox.amount_real,
                'amountDifference': casBox.amount_difference,
                'amountNextOpen': casBox.amount_next_open,
                'type': 'open' if (casBox.statement_open.id == statement.id) else 'confirm',
                'statementConfirm':{
                    'id': casBox.statement_id.id if (casBox.statement_id) else '',
                    'name': casBox.statement_id.name if (casBox.statement_id) else '',
                    'state': casBox.statement_id.state if (casBox.statement_id) else '',
                    'statementUser': "%s/%s" % ((casBox.statement_id.name), (casBox.statement_id.user_id.name)) if (casBox.statement_id) else ''
                },
                'statementOpen':{
                    'id': casBox.statement_open.id if (casBox.statement_open) else '',
                    'name': casBox.statement_open.name if (casBox.statement_open) else '',
                    'state': casBox.statement_open.state if (casBox.statement_open) else '',
                    'statementUser': "%s/%s" % ((casBox.statement_open.name), (casBox.statement_open.user_id.name)) if (casBox.statement_open) else ''
                },
                'lineDifference': [{
                    'id':  lineDifference.id,
                    'date': lineDifference.date,
                    'name': lineDifference.name ,
                    'amount': lineDifference.amount,
                    'state': lineDifference.statement_id.state,
                    'type': 'balance'
                } for lineDifference in self.env['account.bank.statement.line'].browse(casBox.line_difference.id)],
                'lineNextOpen': [{
                    'id': lineNextOpen.id,
                    'date': lineNextOpen.date,
                    'name': lineNextOpen.name ,
                    'amount': lineNextOpen.amount,
                    'state': casBox.statement_open.state if (casBox.statement_open) else '',
                    'type': 'reserve'
                } for lineNextOpen in self.env['account.bank.statement.line'].browse(casBox.line_next_open.id)]
            } for casBox in self.env['cashbox.statement.confirm'].search([('statement_id.id','=',statement.id)])],
        } for statement in self.env['account.bank.statement'].search([('id','=',id)])]


    '''
          ____ _____  _  _____ _____ __  __ _____ _   _ _____    ____    _    _   _  ____ _____ _
         / ___|_   _|/ \|_   _| ____|  \/  | ____| \ | |_   _|  / ___|  / \  | \ | |/ ___| ____| |
         \___ \ | | / _ \ | | |  _| | |\/| |  _| |  \| | | |   | |     / _ \ |  \| | |   |  _| | |
          ___) || |/ ___ \| | | |___| |  | | |___| |\  | | |   | |___ / ___ \| |\  | |___| |___| |___
         |____/ |_/_/   \_\_| |_____|_|  |_|_____|_| \_| |_|    \____/_/   \_\_| \_|\____|_____|_____|
    '''
    '''
        Get Statement
    '''
    def _eiru_get_account_bank_statement(self, id):
        return self.env['account.bank.statement'].browse(id)

    '''
        Get Statement Line
    '''
    def _eiru_get_account_bank_statement_line(self, id):
        return self.env['account.bank.statement.line'].browse(id)

    '''
        Get CashBox statement Confirm
    '''
    def _eiru_account_get_cashbox_confirm(self, statementId):
        return self.env['cashbox.statement.confirm'].search([('statement_id', '=', statementId)])

    '''
        statement Cancel
    '''
    @api.model
    def eiru_statement_cancel(self, values):
        ### date server
        dateServer = self.get_server_datetime()
        ###  Statement
        statement = self._eiru_get_account_bank_statement(values['statementId'])
        if (not statement):
            return {
                'state': False,
                'messege': "Error en obtener el registro de caja ref(account.bank.statement)."
            }

        ### user
        users = self.env.user
        if (not users):
            return {
                'state': False,
                'messege':"Error en obtener el usuario. ref(res.users) "
            }

        # Creatre Line cancel
        line_ids = []
        for line in statement.line_ids:
            line_ids.append([0, False, {
                'statement_line': line.id,
                'date': line.date,
                'name': line.name,
                'ref': line.ref,
                'partner_id': line.partner_id.id,
                'amount': line.amount,
                'currency_id': line.currency_id.id
            }])

        # create cancel
        cancel = {
            'name': "Cancelación de caja "+str(statement.name),
            'ref': values['messege'],
            'date': dateServer,
            'message': values['messege'],
            'statement_id': statement.id,
            'journal_id': statement.journal_id.id,
            'user_statement': statement.user_id.id,
            'user_cancel': users.id,
            'line_ids': line_ids
        }
        statementCancel = self.env['cashbox.statement.cancel'].create(cancel)
        if (not statementCancel):
            return {
                'state': False,
                'messege': 'Error en el registro de cancelación de caja. ref(cashbox.statement.cancel /cashbox.statement.cancel.line).'
            }

        '''
            Confirm
        '''
        statementOpen = []
        stateOpen   = []
        lineDifference = []
        lineNextOpen = []
        lineOpen = []

        cashBoxConfirm = self._eiru_account_get_cashbox_confirm(statement.id)
        if (cashBoxConfirm):
            statementOpen = self._eiru_get_account_bank_statement(cashBoxConfirm.statement_open.id)
            if (statementOpen and statementOpen.state =='confirm' and cashBoxConfirm.statement_open.id != cashBoxConfirm.statement_id.id ):
                return {
                    'state': False,
                    'messege': "No se puede reabrir esta caja porque  tiene relación a una caja que ya esta cerrada."
                }

            stateOpen = statementOpen.state
            # Line Diferencia
            lineDifference = self._eiru_get_account_bank_statement_line(cashBoxConfirm.line_difference.id)
            # line Next Open
            lineNextOpen = self._eiru_get_account_bank_statement_line(cashBoxConfirm.line_next_open.id)
            # Line Open
            lineOpen = self._eiru_get_account_bank_statement_line(cashBoxConfirm.line_open.id)

        '''
            Cancel statement
        '''
        cancel = self.eiru_button_cancel(statement)
        if (not cancel):
            return {
                'state': False,
                'messege': "Error al cancelar la caja"
            }

        if (lineDifference):
            self._write_statement_line_transfer(lineDifference)
            self._unlink_statement_line_transfer(lineDifference)

        if (lineNextOpen):
            self._write_statement_line_transfer(lineNextOpen)
            self._unlink_statement_line_transfer(lineNextOpen)


        if (lineOpen):
            statementOpenCancel = self.eiru_button_cancel(statementOpen)
            if (not statementOpenCancel):
                return {
                    'state': False,
                    'messege': "Error al cancelar la caja"
                }

            self._write_statement_line_transfer(lineOpen)
            self._unlink_statement_line_transfer(lineOpen)

            if (stateOpen == 'open'):
                statementOpen.button_open()

        '''
            Update Confirm
        '''
        confirm = {
            'state_avaliable': True,
            'statement_open': '',
            'amount_real': 0.0,
            'amount_difference': 0.0,
            'amount_next_open': 0.0

        }
        confirmCasBox = self._writer_cashbox_statement_confirm(cashBoxConfirm,confirm)
        if (not confirmCasBox):
            return {
                'state': False,
                'messege': 'Error en actualizar cierre de caja ref(cashbox.statement.confirm)'
            }

        open = statement.button_open()
        if (not open):
            return {
                'state': False,
                'messege': 'Error en reabrir la caja  ref('+statement+')'
            }

        return {
            'state': True,
            'messege': 'Caja reabierta'
        }

    '''
        Cancelar Caja
    '''
    def eiru_button_cancel(self,statement):
        return super(eiru_account_statement_cancel, statement.with_context(cancel_from_statement=True)).button_cancel()


'''
    Histórico de Cajas Canceladas.
'''
class cashbox_statement_cancel(models.Model):
    _name = "cashbox.statement.cancel"

    ### fields Basic
    name = fields.Char('name')
    ref = fields.Char('Ref')
    date = fields.Date()
    message = fields.Text('Message Cancel')
    active = fields.Boolean('Active', default=True)
    message_deleted = fields.Text('Message Deleted')
    ### statement, journal, users
    statement_id = fields.Many2one('account.bank.statement', 'Bank Statement Cancel')
    journal_id = fields.Many2one('account.journal', 'Journal')
    user_statement = fields.Many2one('res.users', 'User Statement')
    user_cancel = fields.Many2one('res.users', 'Usaer Cancel')
    line_ids    = fields.One2many('cashbox.statement.cancel.line', 'cancel_id', 'Cancel Lines')

class cashbox_statement_cancel_line(models.Model):
    _name = "cashbox.statement.cancel.line"

    ### cashbox.statement.cancel
    cancel_id = fields.Many2one('cashbox.statement.cancel', 'Statement Cancel')
    statement_line = fields.Many2one('account.bank.statement.line', 'statement Line')
    date = fields.Date()
    name = fields.Char('name')
    ref = fields.Char('Ref')
    partner_id = fields.Many2one('res.partner', 'partner')
    amount = fields.Float('Amount Line', digits_compute=dp.get_precision('Account'))
    currency_id = fields.Many2one('res.currency', string="Currency", help="Moneda de la operación")