account_interest.py 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. # -*- coding: utf-8 -*-
  2. from openerp import models, fields, tools, api
  3. import openerp.addons.decimal_precision as dp
  4. from datetime import datetime
  5. from openerp.exceptions import ValidationError
  6. class AccountInterest(models.Model):
  7. _name = 'account.interest'
  8. name = fields.Char()
  9. date = fields.Date('Date', help="Fecha de operación")
  10. state = fields.Selection([('cancel', 'Cancelado'),('open', 'Abierto'),('paid', 'Pagado')],'Estado del pago', default="open", help="Estado")
  11. comment = fields.Text('Comment', help="Información adicional")
  12. ## Cliente
  13. customer_id = fields.Many2one('res.partner', string="customer")
  14. ## factura
  15. invoice_id = fields.Many2one('account.invoice', string='Invoice Reference', ondelete='restrict', index=True)
  16. reference = fields.Char(string='Invoice Reference', help="Invoice Reference")
  17. ## Currency
  18. currency_id = fields.Many2one('res.currency', string="Currency", help="Moneda de la operación")
  19. ## Line
  20. lines_ids = fields.One2many('account.interest.line', 'interest_id', string='interest line')
  21. '''
  22. Create
  23. '''
  24. @api.model
  25. def create(self, vals):
  26. interest = super(AccountInterest, self).create(vals)
  27. interest.write({'name':("INTEREST/%06d" % (interest.id))})
  28. return interest
  29. '''
  30. Unlink
  31. '''
  32. @api.multi
  33. def unlink(self):
  34. interestLine = self.env['account.interest.line'].search([('interest_id.id', '=', self.id)])
  35. invoice_ids = map(lambda x: x.invoice.id, interestLine)
  36. moves_ids = map(lambda x: x.move_line_id.id, interestLine)
  37. invoiceNumber = ""
  38. invoice = self.env['account.invoice'].search([('id', 'in', invoice_ids)])
  39. if (invoice):
  40. for invoiceN in invoice:
  41. invoiceNumber += "%s, " % (invoiceN.number)
  42. raise ValidationError('Existe relacion de la lineas de interes con las facturas (%s)' % (invoiceNumber))
  43. return False
  44. moveLine = self.env['account.move.line'].search([('id', 'in', moves_ids)])
  45. for lineMove in moveLine:
  46. lineMove.write({'date_interest': lineMove.date_maturity})
  47. return super(AccountInterest, self).unlink()
  48. '''
  49. Invoice
  50. '''
  51. class accountInvoiceInterest(models.Model):
  52. _inherit = 'account.invoice'
  53. interest_ids = fields.One2many('account.interest', 'invoice_id', string=' Account Interest')
  54. is_interest = fields.Boolean('Factura de interés', default=False, help="Indica si esta factura fue generado por un interés.")
  55. '''
  56. Unlink Invoice
  57. '''
  58. @api.multi
  59. def unlink(self):
  60. interestLine = self.env['account.interest.line'].search([('invoice.id', '=', self.id)])
  61. for line in interestLine:
  62. moveLine = self.env['account.move.line'].browse(line.move_line_id.id)
  63. if (moveLine):
  64. moveLine.write({'date_interest': moveLine.date_maturity})
  65. line.write({
  66. 'state': 'open',
  67. 'reference': ''
  68. })
  69. return super(accountInvoiceInterest, self).unlink()
  70. '''
  71. partner
  72. '''
  73. class ResPartnerInterest(models.Model):
  74. _inherit = 'res.partner'
  75. interest_ids = fields.One2many('account.interest', 'customer_id', string=' Account Interest')
  76. class AccountInterestLine(models.Model):
  77. _name = 'account.interest.line'
  78. ## Interest
  79. interest_id = fields.Many2one('account.interest', string='Account Interest', ondelete='cascade', index=True, required=True)
  80. move_line_id = fields.Many2one('account.move.line', string="Registros del diario", help="Registros del diario")
  81. amount = fields.Float('amount', digits_compute=dp.get_precision('Account'), required=True, help="Monto del pago")
  82. amount_residual = fields.Float('amount', digits_compute=dp.get_precision('Account'), required=True, help="Monto del pago")
  83. amount_interest = fields.Float('amount', digits_compute=dp.get_precision('Account'), required=True, help="Monto del pago")
  84. date_maturity = fields.Date()
  85. expired_days = fields.Integer('Expired Days ')
  86. invoice = fields.Many2one('account.invoice', string='Invoice Reference', index=True)
  87. reference = fields.Char(string='Invoice Reference', help="Invoice Reference")
  88. state = fields.Selection([('cancel','Cancelado'),('open','Abierto'),('invoiced','Facturado')],'Estado del pago', default="open")
  89. amount_dicount = fields.Float('amount disconut', digits_compute=dp.get_precision('Account'), help="Monto del descuento")
  90. '''
  91. Move Line
  92. '''
  93. class accountMoveLineInterest(models.Model):
  94. _inherit = 'account.move.line'
  95. interest_line_ids = fields.One2many('account.interest.line', 'move_line_id', string=' Account Interest Line')
  96. date_interest = fields.Date("Date interés", help="Fecha de la facturación de os interés")