models.py 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  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. } for refPartner in invoice.partner_id.ref_personal_ids],
  33. }],
  34. # COMPANY INFO
  35. 'company_id': [{
  36. 'id':invoice.user_id.company_id.id,
  37. 'name': invoice.user_id.company_id.name,
  38. 'logo': invoice.user_id.company_id.logo,
  39. 'phone': invoice.user_id.company_id.phone,
  40. }],
  41. # CURRENCY INFO
  42. 'currency_id':[{
  43. 'id': invoice.currency_id.id,
  44. 'name': invoice.currency_id.name,
  45. 'symbol': invoice.currency_id.symbol,
  46. 'thousands_separator': invoice.currency_id.thousands_separator,
  47. 'decimal_separator': invoice.currency_id.decimal_separator,
  48. 'decimal_places': invoice.currency_id.decimal_places,
  49. 'symbol_position': invoice.currency_id.symbol,
  50. }],
  51. })
  52. return values
  53. @api.model
  54. def getAccountInvoicePagareQuota(self,domain):
  55. AccountInvoice = self.env['account.invoice'].search(domain)
  56. AccountMoveLine = self.env['account.move.line'].search([('move_id','=',AccountInvoice.number),('debit','>',0)],order='date_maturity')
  57. i = 1
  58. x = len(AccountMoveLine)
  59. values = []
  60. for line in AccountMoveLine:
  61. amount = 0
  62. value = 0
  63. state = 'No pagado'
  64. if(line.reconcile_ref != False):
  65. if(line.amount_residual == 0):
  66. state = 'Pagado'
  67. if(line.amount_residual > 0):
  68. value = line.debit - line.amount_residual
  69. state = 'Amortizado'
  70. values.append({
  71. 'date': line.date_maturity,
  72. 'name': 'Cuota ' + str(i) + ' / ' + str(x),
  73. 'state': state,
  74. 'value': value,
  75. 'amount': line.debit,
  76. 'residual': line.amount_residual,
  77. })
  78. i = i + 1
  79. return values
  80. class AccountInvoiceLine(models.Model):
  81. _inherit = 'account.invoice.line'
  82. @api.model
  83. def getAccountInvoiceLinePagare(self,domain):
  84. AccountInvoiceLine = self.env['account.invoice.line'].search(domain)
  85. values = []
  86. for line in AccountInvoiceLine:
  87. values.append({
  88. 'id': line.id,
  89. 'name': line.name,
  90. 'quantity': line.quantity,
  91. 'price_unit': line.price_unit,
  92. 'price_subtotal': line.price_subtotal,
  93. })
  94. return values