account_voucher.py 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  1. # -*- coding: utf-8 -*-
  2. from openerp import api, fields, models, cli
  3. from openerp.exceptions import except_orm
  4. from datetime import datetime
  5. from dateutil.relativedelta import relativedelta as rd
  6. from dateutil.parser import parse
  7. class AccountVoucher(models.Model):
  8. _inherit = 'account.voucher'
  9. @api.model
  10. def create_from_pos(self, values):
  11. date_now = fields.Date.context_today(self)
  12. date_format = '%Y-%m-%d'
  13. # Step 1: Create sale order and confirm
  14. sale_order = self.env['sale.order'].create({
  15. 'partner_id': int(values['customer_id']),
  16. 'order_line': [[0, False, {
  17. 'product_id': int(v['id']),
  18. 'product_uom_qty': float(v['qty']),
  19. 'price_unit': float(v['price']),
  20. 'state': 'confirmed'
  21. }] for v in values['cart_items']],
  22. 'picking_policy': 'direct',
  23. 'state': 'manual',
  24. 'date_confirm': date_now,
  25. 'payment_term': 4
  26. })
  27. # Step 2: Create invoice and calculate due_date
  28. invoice_id = sale_order.action_invoice_create()
  29. invoice = self.env['account.invoice'].browse(invoice_id)
  30. due_date = parse(date_now) + rd(days=max(invoice.payment_term.line_ids.mapped(lambda x: x.days + x.days2)))
  31. invoice.write({
  32. 'date_invoice': date_now,
  33. 'date_due': due_date.strftime(date_format)
  34. })
  35. # Step 3: Create invoice move lines
  36. amount_paid = float(values['amount_paid'])
  37. decimal_precision = self.env['decimal.precision'].precision_get('Account')
  38. invoice_move_lines = invoice._get_analytic_lines() + self.env['account.invoice.tax'].move_line_get(invoice_id)
  39. compute_taxes = self.env['account.invoice.tax'].compute(invoice)
  40. invoice.check_tax_lines(compute_taxes)
  41. total, total_currency, invoice_move_lines = invoice.compute_invoice_totals(invoice.company_id.currency_id,\
  42. invoice.reference, invoice_move_lines)
  43. percent_paid = amount_paid / total
  44. distribute_percent = -(percent_paid / len(invoice.payment_term.line_ids))
  45. total_lines = []
  46. for line in invoice.payment_term.line_ids:
  47. due_date = (parse(date_now) + rd(days=line.days + line.days2)).strftime(date_format)
  48. if percent_paid:
  49. total_lines.append([date_now, percent_paid])
  50. percent_paid = amount_paid = 0
  51. if date_format == date_now:
  52. distribute_percent = -((total_lines[0] - line.value_amount) / (len(invoice.payment_term.line_ids) - 1))
  53. continue
  54. if line.value != 'balance':
  55. total_lines.append([due_date, line.value_amount + distribute_percent])
  56. continue
  57. total_lines.append([due_date, line.value_amount])
  58. for total_line in total_lines:
  59. current_price = round(total * total_line[1], decimal_precision)
  60. amount_paid += current_price
  61. invoice_move_lines.append({
  62. 'type': 'dest',
  63. 'name': '/',
  64. 'price': current_price if total_line[1] else total - amount_paid,
  65. 'account_id': invoice.account_id.id,
  66. 'date_maturity': total_line[0],
  67. 'amount_currency': invoice.company_id.currency_id.compute(total_line[1], invoice.currency_id) \
  68. if invoice.currency_id != invoice.company_id.currency_id else False,
  69. 'currency_id': invoice.currency_id != invoice.company_id.currency_id and invoice.currency_id.id,
  70. 'ref': invoice.reference
  71. })
  72. total_lines = []
  73. # Step 4: Create account move
  74. accounting_partner = self.env['res.partner']._find_accounting_partner(invoice.partner_id)
  75. move_line_values = [(0, 0, invoice.line_get_convert(line, accounting_partner.id, invoice.date_invoice)) \
  76. for line in invoice_move_lines]
  77. move_line_values = invoice.group_lines(invoice_move_lines, move_line_values)
  78. move_line_values = invoice.finalize_invoice_move_lines(move_line_values)
  79. account_move = self.env['account.move'].create({
  80. 'ref': invoice.reference or invoice.name,
  81. 'line_id': move_line_values,
  82. 'journal_id': invoice.journal_id.id,
  83. 'date': invoice.date_invoice,
  84. 'narration': invoice.comment,
  85. 'company_id': invoice.company_id.id,
  86. 'period_id': invoice.period_id.find(invoice.date_invoice).id
  87. })
  88. invoice.write({
  89. 'move_id': account_move.id,
  90. 'period_id': account_move.period_id.id,
  91. 'move_name': account_move.name,
  92. })
  93. account_move.post()
  94. # Step 5: Validate invoice
  95. invoice.action_number()
  96. invoice.write({
  97. 'state': 'open'
  98. })
  99. # Step 6: Pay Invoice
  100. account_voucher = self.create({
  101. 'reference': account_move.name,
  102. 'type': 'receipt',
  103. 'journal_id': 7,
  104. 'company_id': account_move.company_id.id,
  105. 'pre_line': True,
  106. 'amount': 35000.0,
  107. 'period_id': account_move.period_id.id,
  108. 'date': account_move.date,
  109. 'partner_id': account_move.partner_id.id,
  110. 'account_id': 160,
  111. 'line_cr_ids': [[0, False, {
  112. 'date_due': l.date_maturity,
  113. 'account_id': l.account_id.id,
  114. 'date_original': l.invoice.date_invoice,
  115. 'move_line_id': l.id,
  116. 'amount_original': abs(l.credit or l.debit or 0.0),
  117. 'amount_unreconciled': abs(l.amount_residual),
  118. 'amount': abs(l.debit) if account_move.date == l.date_maturity else 0.0,
  119. 'reconcile': account_move.date == l.date_maturity
  120. }] for l in account_move.line_id]
  121. })
  122. return account_voucher.action_move_line_create()