account_bank_statement_line.py 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
  1. # -*- coding: utf-8 -*-
  2. from openerp.http import request
  3. from eiru_logging import make_info_log
  4. _MODEL= 'account.bank.statement.line'
  5. ''' Get Line statement '''
  6. def get_line_statement(statementId):
  7. lines= '''
  8. SELECT
  9. line.id as id,
  10. line.date,
  11. line.name,
  12. line.ref,
  13. line.amount,
  14. line.partner_id
  15. FROM account_bank_statement_line as line
  16. WHERE line.statement_id = %s
  17. '''
  18. request.cr.execute(lines,[statementId])
  19. return [{
  20. 'id': line[0],
  21. 'date': line[1],
  22. 'name': line[2],
  23. 'ref': line[3],
  24. 'amount': line[4],
  25. 'partnerId': line[5],
  26. } for line in request.cr.fetchall()]
  27. ''' Create Statement line '''
  28. def create_statement_line(values):
  29. return request.env[_MODEL].sudo().create(values)
  30. ''' Modify statement line '''
  31. def modify_statement_line(value):
  32. ''' DELETED '''
  33. if (value['linesDeleted']):
  34. make_info_log('Unlink Statement Line')
  35. for line in request.env[_MODEL].search([('id', 'in', value['linesDeleted'])]):
  36. if(line.is_deleted):
  37. lineWrite={'is_deleted': False}
  38. write_statement_line(line,lineWrite)
  39. unlink_statement_line(line)
  40. ''' UPDATE '''
  41. if (value['lineUpdate']):
  42. make_info_log('Write Statement Line')
  43. for update in value['lineUpdate']:
  44. lineStatement = request.env[_MODEL].browse(update['id'])
  45. if (lineStatement):
  46. lines = {
  47. 'amount': update['amount'],
  48. 'date': update['date'],
  49. 'name': update['name'],
  50. 'partner_id': update['partnerId'],
  51. 'ref':update['ref'],
  52. }
  53. write_statement_line(lineStatement, lines)
  54. return {
  55. 'state': True,
  56. 'message': 'Proceso finalizado.'
  57. }
  58. ''' Unlink '''
  59. def unlink_statement_line(line):
  60. return line.sudo().unlink()
  61. ''' Write '''
  62. def write_statement_line(line, value):
  63. return line.sudo().write(value)