models.py 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109
  1. # -*- coding: utf-8 -*-
  2. from openerp import models, fields, api
  3. class AccountInvoice(models.Model):
  4. _inherit = 'account.invoice'
  5. @api.model
  6. def getAccountInvoicePagare(self,domain):
  7. AccountInvoice = self.env['account.invoice'].search(domain)
  8. values = []
  9. for invoice in AccountInvoice:
  10. values.append({
  11. # ID
  12. 'id': invoice.id,
  13. 'number': invoice.number,
  14. 'origin': invoice.origin,
  15. 'date_invoice': invoice.date_invoice,
  16. 'user_name': invoice.user_id.name,
  17. 'amount_untaxed': invoice.amount_untaxed,
  18. 'amount_tax': invoice.amount_untaxed,
  19. 'amount_total': invoice.amount_untaxed,
  20. 'create_date': invoice.create_date,
  21. # PARTNER INFO
  22. 'partner_id':[{
  23. 'id': invoice.partner_id.id,
  24. 'name': invoice.partner_id.name,
  25. 'ruc': invoice.partner_id.ruc,
  26. 'address': invoice.partner_id.street,
  27. 'phone': invoice.partner_id.phone,
  28. 'mobile': invoice.partner_id.mobile,
  29. 'ref_personal_ids': [{
  30. 'id': refPartner.id,
  31. 'name': refPartner.name,
  32. 'phone': refPartner.phone,
  33. } for refPartner in invoice.partner_id.ref_personal_ids],
  34. }],
  35. # COMPANY INFO
  36. 'company_id': [{
  37. 'id':invoice.user_id.company_id.id,
  38. 'name': invoice.user_id.company_id.name,
  39. 'logo': invoice.user_id.company_id.logo,
  40. 'phone': invoice.user_id.company_id.phone,
  41. }],
  42. # CURRENCY INFO
  43. 'currency_id':[{
  44. 'id': invoice.currency_id.id,
  45. 'name': invoice.currency_id.name,
  46. 'symbol': invoice.currency_id.symbol,
  47. 'thousands_separator': invoice.currency_id.thousands_separator,
  48. 'decimal_separator': invoice.currency_id.decimal_separator,
  49. 'decimal_places': invoice.currency_id.decimal_places,
  50. 'symbol_position': invoice.currency_id.symbol,
  51. }],
  52. })
  53. return values
  54. @api.model
  55. def getAccountInvoicePagareQuota(self,domain):
  56. AccountInvoice = self.env['account.invoice'].search(domain)
  57. AccountMoveLine = self.env['account.move.line'].search([('move_id','=',AccountInvoice.number),('debit','>',0)],order='date_maturity')
  58. i = 1
  59. x = len(AccountMoveLine)
  60. values = []
  61. for line in AccountMoveLine:
  62. amount = 0
  63. value = 0
  64. state = 'No pagado'
  65. if(line.reconcile_ref != False):
  66. if(line.amount_residual == 0):
  67. state = 'Pagado'
  68. if(line.amount_residual > 0):
  69. value = line.debit - line.amount_residual
  70. state = 'Amortizado'
  71. values.append({
  72. 'date': line.date_maturity,
  73. 'name': 'Cuota ' + str(i) + ' / ' + str(x),
  74. 'state': state,
  75. 'value': value,
  76. 'amount': line.debit,
  77. 'residual': line.amount_residual,
  78. })
  79. i = i + 1
  80. return values
  81. class AccountInvoiceLine(models.Model):
  82. _inherit = 'account.invoice.line'
  83. @api.model
  84. def getAccountInvoiceLinePagare(self,domain):
  85. AccountInvoiceLine = self.env['account.invoice.line'].search(domain)
  86. values = []
  87. for line in AccountInvoiceLine:
  88. values.append({
  89. 'id': line.id,
  90. 'name': line.name,
  91. 'quantity': line.quantity,
  92. 'price_unit': line.price_unit,
  93. 'price_subtotal': line.price_subtotal,
  94. })
  95. return values