recibo.py

#! -*- coding: utf8 -*-
from decimal import Decimal
from trytond.model import ModelView, Workflow, ModelSQL, fields
from trytond.pyson import Eval, If, Not, Equal, Bool
from trytond.transaction import Transaction
from trytond.pool import Pool
from trytond.report import Report
import datetime

__all__ = ['Recibo', 'ReciboReport', 'LineaConceptoRecibo']

_DEPENDS = ['state']

_STATES = {
    'readonly': Eval('state') != 'draft',
}

class Recibo(Workflow, ModelSQL, ModelView):
    "cooperative.partner.recibo"
    __name__ = "cooperative.partner.recibo"
    date = fields.Date('Fecha',
            states={
                'readonly': (Eval('state') != 'draft')
            }, required=True)
    amount = fields.Numeric('Monto',digits=(16,2),
            states={
                'readonly': (Eval('state') != 'draft')
            }, required=True)
    partner = fields.Many2One('cooperative.partner', 'Socio', required=True,
            states={
                'readonly': (Eval('state') != 'draft')
            })
    state = fields.Selection([
        ('draft', 'Borrador'),
        ('confirmed', 'Confirmado'),
        ('paid', 'Pagado'),
        ('cancel', 'Cancelado'),
        ], 'State', readonly=True)
    number = fields.Char('Numero', size=None, readonly=True, select=True)

    description = fields.Char('Descripcion', size=None, states=_STATES,
        depends=_DEPENDS)

    ## Integrando con asientos
    party = fields.Function(fields.Many2One('party.party', 'Entidad',
        required=True, states=_STATES, depends=_DEPENDS,
        on_change_with=['partner']),'on_change_with_party')
    #company = fields.Many2One('company.company', 'Company', required=True,
    #    states=_STATES, select=True, domain=[
    #        ('id', If(Eval('context', {}).contains('company'), '=', '!='),
    #            Eval('context', {}).get('company', -1)),
    #        ],
    #    depends=_DEPENDS)

    company = fields.Many2One('company.company', 'Coooperativa', required=True,
        states=_STATES, select=True, 
        depends=_DEPENDS)

    accounting_date = fields.Date('Fecha de Contabilizacion', states=_STATES,
        depends=_DEPENDS)
    confirmed_move = fields.Many2One('account.move', 'Asiento de Confirmacion', readonly=True)
    paid_move = fields.Many2One('account.move', 'Asiento de Pago', readonly=True,
        states={
            'invisible': Eval('state').in_(['draft', 'confirmed']),
            })
    journal = fields.Many2One('account.journal', 'Diario', 
        states=_STATES, depends=_DEPENDS)
    currency = fields.Many2One('currency.currency', 'Moneda', required=True,
        states={
            'readonly': ((Eval('state') != 'draft')
                | (Eval('lines') & Eval('currency'))),
            }, depends=['state', 'lines'])

    periodo_liquidado = fields.Char('Periodo Liquidado', required=True)
    fecha_pago = fields.Date('Fecha de Pago', required=True)

    #Para concepto de Monotributo    
    pago_monotributo = fields.Boolean('Pago de monotributo')
    valor_monotributo = fields.Numeric('Valor del monotributo',digits=(16,2), states={'invisible': Not(Bool(Eval('pago_monotributo')))})
    mes_monotributo = fields.Selection([('',''),
        ('Enero', 'Enero'),
        ('Febrero', 'Febrero'),
        ('Marzo', 'Marzo'),
        ('Abril', 'Abril'),
        ('Mayo', 'Mayo'),
        ('Junio', 'Junio'),
        ('Julio', 'Julio'),
        ('Agosto', 'Agosto'),
        ('Septiembre', 'Septiembre'),
        ('Octubre', 'Octubre'),
        ('Noviembre', 'Noviembre'),
        ('Diciembre', 'Diciembre')], 
        'Mes del Monotributo', states={'invisible': Not(Bool(Eval('pago_monotributo')))},                   
        )

    #Para pago de cuotas    
    cobro_cuota = fields.Boolean('Cobro de cuota')
    valor_cuota = fields.Numeric('Valor de la cuota',digits=(16,2), states={'invisible': Not(Bool(Eval('cobro_cuota')))})
    mes_cuota = fields.Selection([('',''),
        ('Enero', 'Enero'),
        ('Febrero', 'Febrero'),
        ('Marzo', 'Marzo'),
        ('Abril', 'Abril'),
        ('Mayo', 'Mayo'),
        ('Junio', 'Junio'),
        ('Julio', 'Julio'),
        ('Agosto', 'Agosto'),
        ('Septiembre', 'Septiembre'),
        ('Octubre', 'Octubre'),
        ('Noviembre', 'Noviembre'),
        ('Diciembre', 'Diciembre')], 
        'Mes de la Cuota', states={'invisible': Not(Bool(Eval('cobro_cuota')))},                   
        )

    #Para otros conceptos (AUH, etc)
    pago_otros= fields.Boolean('Pago de adicional')
    concepto_otros = fields.Char('Nombre del concepto adicional',states={'invisible': Not(Bool(Eval('pago_otros')))})
    valor_otros = fields.Numeric('Valor del concepto adicional',digits=(16,2), states={'invisible': Not(Bool(Eval('pago_otros')))})
    
    #Otros conceptos
    lineas_conceptos_recibo = fields.One2Many('cooperative.partner.recibo.lineaconceptorecibo', 'recibo', 'Conceptos a incluir en el recibo')

    total = fields.Function(fields.Numeric('Total', digits=(16, 2),
        on_change_with=['amount', 'pago_monotributo', 'cobro_cuota', 'valor_cuota', 'valor_monotributo', 'total', 'lineas_conceptos_recibo']),
        'on_change_with_total')

    total_en_letras = fields.Function(fields.Char('Total en letras'), 'get_sing_number')

    @classmethod
    def __setup__(cls):
        super(Recibo, cls).__setup__()
        cls._transitions |= set((
                ('draft', 'confirmed'),
                ('draft', 'cancel'),
                ('confirmed', 'draft'),
                ('confirmed', 'paid'),
                ('confirmed', 'cancel'),
                ('cancel', 'draft'),
                ))

        cls._buttons.update({
                'cancel': {
                    'invisible': ~Eval('state').in_(['draft']),
                    },
                'draft': {
                    'invisible': ~Eval('state').in_(['cancel']),
                    },
                'paid': {
                    'invisible': ~Eval('state').in_(['confirmed']),
                    },
                'confirmed': {
                    'invisible': ~Eval('state').in_(['draft']),
                    },
                })

    @classmethod
    @ModelView.button
    @Workflow.transition('draft')
    def draft(cls, recibos):
        Move = Pool().get('account.move')

        moves = []
        for recibo in recibos:
                    
            if recibo.confirmed_move:
                moves.append(recibo.confirmed_move)
        if moves:
            with Transaction().set_user(0, set_context=True):
                Move.delete(moves)

    @classmethod
    @ModelView.button
    @Workflow.transition('confirmed')
    def confirmed(cls, recibos):
        Move = Pool().get('account.move')

        moves = []
        for recibo in recibos:
            recibo.journal = Pool().get('account.journal').search([('code','=','EXP')])[0]    
            recibo.save()   
            recibo.set_number()
            moves.append(recibo.create_confirmed_move())

        cls.write(recibos, {
                'state': 'confirmed',
                })
        Move.post(moves)

    @classmethod
    @ModelView.button
    @Workflow.transition('paid')
    def paid(cls, recibos):
        Move = Pool().get('account.move')

        moves = []
        for recibo in recibos:
            moves.append(recibo.create_paid_move())

        cls.write(recibos, {
                'state': 'paid',
                })
        Move.post(moves)

    @classmethod
    @ModelView.button
    @Workflow.transition('cancel')
    def cancel(cls, recibos):
        cls.write(recibos, {
                'state': 'cancel',
                })

    @staticmethod
    def default_state():
        return 'draft'

    @staticmethod
    def default_description():
        return 'Retornos a cuenta de excedentes'

    @staticmethod
    def default_date():
        Date_ = Pool().get('ir.date')
        return Date_.today()

    @staticmethod
    def default_fecha_pago():
        Date_ = Pool().get('ir.date')
        return Date_.today()

    @staticmethod
    def default_amount():
        return Decimal(0)

    @staticmethod
    def default_valor_cuota():
        return Decimal(0)
    
    @staticmethod
    def default_valor_monotributo():
        return Decimal(0)

    @staticmethod
    def default_valor_otros():
        return Decimal(0)

    @staticmethod
    def default_company():        
        return Transaction().context.get('company')

    @staticmethod
    def default_currency():
        Company = Pool().get('company.company')
        if Transaction().context.get('company'):
            company = Company(Transaction().context['company'])
            return company.currency.id

    def on_change_with_party(self, name=None):
        if self.partner:
            return self.partner.party.id

    def on_change_with_total(self, name=None):
        if self.pago_monotributo:
            total = Decimal(self.amount) + Decimal(self.valor_monotributo)    
        else:
            total = Decimal(self.amount)
        if self.cobro_cuota:
            total -= Decimal(self.valor_cuota) 
        if self.lineas_conceptos_recibo:
            for linea in self.lineas_conceptos_recibo:
                if linea.valor: 
                    total += Decimal(linea.valor)
        #if self.pago_otros:
        #    total += Decimal(self.valor_otros)

        return total

    def set_number(self):
        '''
        Set number to the receipt
        '''
        pool = Pool()
        FiscalYear = pool.get('account.fiscalyear')
        Date = pool.get('ir.date')
        Sequence = pool.get('ir.sequence')

        if self.number:
            return

        accounting_date = self.accounting_date or self.date
        fiscalyear_id = FiscalYear.find(self.company.id,
            date=accounting_date)
        fiscalyear = FiscalYear(fiscalyear_id)
        sequence = fiscalyear.get_sequence('receipt')

        #if not sequence:
        #    self.raise_user_error('no_invoice_sequence', {
        #            'invoice': self.rec_name,
        #            'period': period.rec_name,
        #            })
        with Transaction().set_context(
                date=self.date or Date.today()):
            number = Sequence.get_id(sequence.id)
            vals = {'number': number}

        self.write([self], vals)

    def _get_move_line(self, date, amount, account_id):
        '''
        Return move line
        '''
        Currency = Pool().get('currency.currency')
        res = {}
        if self.currency.id != self.company.currency.id:
            with Transaction().set_context(date=self.date):
                res['amount_second_currency'] = Currency.compute(
                    self.company.currency, amount, self.currency)
            res['amount_second_currency'] = abs(res['amount_second_currency'])
            res['second_currency'] = self.currency.id
        else:
            res['amount_second_currency'] = Decimal('0.0')
            res['second_currency'] = None
        if amount >= Decimal('0.0'):
            res['debit'] = Decimal('0.0')
            res['credit'] = amount
        else:
            res['debit'] = - amount
            res['credit'] = Decimal('0.0')
        res['account'] = account_id
        res['maturity_date'] = date
        res['description'] = self.description
        res['party'] = self.party.id
        return res

    def create_move(self, move_lines):

        pool = Pool()
        Move = pool.get('account.move')
        Period = pool.get('account.period')

        accounting_date = self.accounting_date or self.date
        period_id = Period.find(self.company.id, date=accounting_date)

        move, = Move.create([{
                    'journal': self.journal.id,
                    'period': period_id,
                    'date': self.date,
        #            'origin': str(self),
                    'lines': [('create', move_lines)],
                    }])
        return move

    def create_confirmed_move(self):
        '''
        Create account move for the receipt and return the created move
        '''
        pool = Pool()
        Date = pool.get('ir.date')

        move_lines = []

        val = self._get_move_line(Date.today(), self.amount, self.party.account_payable.id)
        move_lines.append(val)
        # issue #4461
        # En vez de usar la cuenta "a cobrar" del party, deberia ser la
        # cuenta Retornos Asociados (5242) siempre fija, que esta seteada como
        # Expense (Gasto).
        account_receivable = self.party.account_receivable.search([('rec_name','like', '%5242%')])[0]
        val = self._get_move_line(Date.today(), -self.amount, account_receivable.id)
        move_lines.append(val)

        move = self.create_move(move_lines)

        self.write([self], {
                'confirmed_move': move.id,
                })
        return move

    def create_paid_move(self):
        '''
        Create account move for the receipt and return the created move
        '''
        pool = Pool()
        Date = pool.get('ir.date')

        move_lines = []

        val = self._get_move_line(Date.today(), self.amount, self.journal.credit_account.id)
        move_lines.append(val)
        val = self._get_move_line(Date.today(), -self.amount, self.party.account_payable.id)
        move_lines.append(val)

        move = self.create_move(move_lines)

        self.write([self], {
                'paid_move': move.id,
                })
        return move

    def get_sing_number(self, name=None):
        "Convert numbers in its equivalent string text representation in spanish"
        from singing_girl import Singer
        singer = Singer()
        return singer.sing(self.total)


class LineaConceptoRecibo(ModelSQL, ModelView):
    "Linea Concepto Recibo"
    __name__='cooperative.partner.recibo.lineaconceptorecibo'

    #Para otros conceptos (AUH, etc)
    concepto= fields.Char('Nombre')
    valor = fields.Numeric('Valor',digits=(16,2))

    recibo = fields.Many2One('cooperative.partner.recibo', 'Recibo',required=True)
        
class ReciboReport(Report):
    __name__ = 'cooperative.partner.recibo'

    @classmethod
    def parse(cls, report, records, data, localcontext):
        pool = Pool()
        User = pool.get('res.user')

        recibo = records[0]
        #Ver conceptos a incluir

        user = User(Transaction().user)
        localcontext['company_name'] = user.company.party.name.upper()
        localcontext['company_adress'] = str(user.company.party.address_get().street) + " (" + str(user.company.party.address_get().zip) + ")"   
        localcontext['company_matricula'] = user.company.numero_matricula        
        localcontext['company_place'] = user.company.party.address_get().city                
        localcontext['responsable_administrativo'] = user.company.responsable_administrativo.name                    
        localcontext['vat_number'] = cls._get_vat_number(user.company)
        localcontext['partner_vat_number'] = cls._get_vat_number(recibo)         
        fecha_pago = datetime.datetime.strptime(str(recibo.fecha_pago), "%Y-%m-%d").strftime("%d/%m/%Y")
        localcontext['fecha_pago'] = fecha_pago
        
        if user.company.party.name == "COOPERATIVA FALUCHO DE VIVIENDA LTDA":
            if recibo.partner.contratista == True:
                localcontext['concepto_liquidado'] = "ANTICIPO A PROVEEDORES"
            else: 
                localcontext['concepto_liquidado'] = "ANTICIPO DE SUELDO"
        else:
            localcontext['concepto_liquidado'] = "ANTICIPO DE RETORNO"
            
        
        return super(ReciboReport, cls).parse(report, records, data,
                localcontext)
       
    @classmethod
    def _get_sing_number(cls, recibo):
        "Convert numbers in its equivalent string text representation in spanish"
        from singing_girl import Singer
        singer = Singer()
        return singer.sing(recibo.total)

    @classmethod
    def _get_vat_number(cls, company):
        value = company.party.vat_number
        return '%s-%s-%s' % (value[:2], value[2:-1], value[-1])

    @classmethod
    def _get_partner_vat_number(cls, recibo):
        value = recibo.party.vat_number
        return '%s-%s-%s' % (value[:2], value[2:-1], value[-1])