account_bank_statement_utility.py 6.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181
  1. # -*- coding: utf-8 -*-
  2. from openerp import models, fields, tools, api
  3. class AccountBankStatementUtility(models.Model):
  4. _inherit = 'account.bank.statement'
  5. '''
  6. get_account_bank_statement_utility
  7. '''
  8. @api.model
  9. def get_account_bank_statement_utility(self, id):
  10. '''
  11. Get Account Bank Statement
  12. :param : id: id account bank statement,
  13. :return : Object Account bank statement + Amount(account Bank statement line)
  14. '''
  15. decimal_precision = self.env['decimal.precision'].precision_get('Account')
  16. bankStatement = self.env['account.bank.statement'].browse(id)
  17. if (not bankStatement):
  18. return False
  19. accountStatement = []
  20. amount = 0.0
  21. for line in bankStatement.line_ids:
  22. amount += line.amount
  23. if (bankStatement.balance_start > 0):
  24. amount += bankStatement.balance_start
  25. accountStatement.append({
  26. 'id': bankStatement.id,
  27. 'name': bankStatement.name,
  28. 'date': bankStatement.date,
  29. 'journalId': bankStatement.journal_id.id,
  30. 'periodId': bankStatement.period_id.id,
  31. 'userId': bankStatement.user_id.id,
  32. 'userName': bankStatement.user_id.name,
  33. 'typeStatement': bankStatement.type_statement.id,
  34. 'typeStatementName': bankStatement.type_statement.name,
  35. 'state': bankStatement.state,
  36. 'amount': amount,
  37. 'currencystatement': {
  38. 'id': bankStatement.currency.id,
  39. 'symbol': bankStatement.currency.symbol,
  40. 'rate': bankStatement.currency.rate,
  41. 'thousandsSeparator': bankStatement.currency.thousands_separator,
  42. 'decimalSeparator': bankStatement.currency.decimal_separator,
  43. 'decimalPlaces': bankStatement.currency.decimal_places,
  44. 'position': bankStatement.currency.position,
  45. },
  46. })
  47. return accountStatement
  48. @api.model
  49. def get_account_journal_utility(self,id):
  50. bankStatement = self.env['account.bank.statement'].browse(id)
  51. if (not bankStatement):
  52. return False
  53. domain = [('active', '=', True), ('type', 'in', ['bank', 'cash']), ('id', 'in', [bankStatement.journal_id.id])];
  54. accountJournal = self.env['account.journal'].search(domain)
  55. journalUtility = []
  56. for journal in accountJournal:
  57. domainStatment = [('id','!=',bankStatement.id),('journal_id','in',[journal.id])]
  58. # domainStatment = [('id','!=',bankStatement.id) ,('journal_id','in',[journal.id]),('date','=',bankStatement.date),('period_id','=',bankStatement.period_id.id)]
  59. if (journal.type == 'cash'):
  60. domainStatment.append(('state','=', 'open'))
  61. if (journal.type == 'bank'):
  62. domainStatment.append(('state','!=','confirm'))
  63. statementJournal = []
  64. statement = self.env['account.bank.statement'].search(domainStatment)
  65. for statementOpen in statement:
  66. statementJournal.append({
  67. 'id': statementOpen.id,
  68. 'journalId': statementOpen.journal_id.id,
  69. 'date': statementOpen.date,
  70. 'typeStatementId': statementOpen.type_statement.id,
  71. 'typeStatementName': statementOpen.type_statement.name,
  72. 'userId': statementOpen.user_id.id,
  73. 'userName': statementOpen.user_id.name,
  74. 'name': statementOpen.name,
  75. 'state': statementOpen.state,
  76. 'statementname': statementOpen.name+" / "+statementOpen.user_id.name
  77. })
  78. journalUtility.append({
  79. 'id': journal.id,
  80. 'name': journal.name,
  81. 'code': journal.code,
  82. 'type': journal.type,
  83. 'currencyId': journal.currency.id,
  84. 'statementJournal': statementJournal
  85. })
  86. return journalUtility
  87. '''
  88. Get User Login
  89. '''
  90. @api.model
  91. def eiru_transfers_get_user(self):
  92. return [{
  93. 'id': user.id,
  94. 'name': user.name
  95. } for user in self.env.user]
  96. ''' _____ __
  97. |_ _| __ __ _ _ __ ___ / _| ___ _ __ ___
  98. | || '__/ _` | '_ \/ __| |_ / _ \ '__/ __|
  99. | || | | (_| | | | \__ \ _| __/ | \__ \
  100. |_||_| \__,_|_| |_|___/_| \___|_| |___/
  101. '''
  102. '''
  103. Get Account Bank Statement
  104. '''
  105. def _get_statement_transfer(self,id):
  106. return self.env['account.bank.statement'].browse(id)
  107. '''
  108. Get Account Journal
  109. '''
  110. def _get_journal_transfer(self, id):
  111. return self.env['account.journal'].browse(id)
  112. '''
  113. Create Line statement.
  114. '''
  115. def _create_statement_line_transfer(self, statement, name, amount, ref):
  116. statementLine = {
  117. 'statement_id': statement.id,
  118. 'name': name,
  119. 'amount': amount ,
  120. 'ref': ref,
  121. 'account_id': statement.journal_id.internal_account_id.id,
  122. 'journal_id': statement.journal_id.id
  123. }
  124. line = self.env['account.bank.statement.line'].create(statementLine)
  125. return line
  126. '''
  127. Create Line statement Transfer
  128. '''
  129. @api.model
  130. def statement_complet_transfers(self, values):
  131. statementOrigin = self._get_statement_transfer(values['statementOriginId'])
  132. if (not statementOrigin):
  133. return False
  134. statementDestiny = self._get_statement_transfer(values['statementDestinyId'])
  135. if (not statementDestiny):
  136. return False
  137. accountJournal = self._get_journal_transfer(values['journalID'])
  138. if (not accountJournal):
  139. return False
  140. # output
  141. name = "TRANSFERENCIA/"+str(statementDestiny.name)
  142. statementOutput = self._create_statement_line_transfer(statementOrigin, name,(-values['amountTransfer']), values['refTransfer'])
  143. if (not statementOutput):
  144. return False
  145. # input
  146. name = "TRANSFERENCIA/"+str(statementOrigin.name)
  147. statementOutput = self._create_statement_line_transfer(statementDestiny, name, abs(values['amountTransfer']), values['refTransfer'])
  148. if (not statementOutput):
  149. return False
  150. return True