main.py 8.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221
  1. # -*- coding: utf-8 -*-
  2. from openerp import http
  3. from openerp.http import request
  4. from werkzeug.wrappers import Response
  5. from werkzeug.datastructures import Headers
  6. from datetime import datetime
  7. from StringIO import StringIO
  8. from gzip import GzipFile
  9. from StringIO import StringIO as IO
  10. import simplejson as json
  11. import gzip
  12. import logging
  13. LOGGER = logging.getLogger(__name__)
  14. class Sales(http.Controller):
  15. '''
  16. Get server date
  17. '''
  18. def get_server_date(self):
  19. return datetime.now().strftime('%Y-%m-%d')
  20. '''
  21. Get current user information
  22. '''
  23. def get_user(self):
  24. user = request.env.user
  25. return {
  26. 'id': user.id,
  27. 'name': user.name,
  28. 'displayName': user.display_name,
  29. 'currency': {
  30. 'id': user.company_id.currency_id.id,
  31. 'name': user.company_id.currency_id.name,
  32. 'displayName': user.company_id.currency_id.display_name,
  33. 'symbol': user.company_id.currency_id.symbol
  34. }
  35. }
  36. '''
  37. Get currencies
  38. '''
  39. def get_currencies(self):
  40. return [{
  41. 'id': currency.id,
  42. 'name': currency.name,
  43. 'displayName': currency.display_name,
  44. 'base': currency.base,
  45. 'accuracy': currency.accuracy,
  46. 'rateSilent': currency.rate_silent,
  47. 'rounding': currency.rounding,
  48. 'symbol': currency.symbol,
  49. 'position': currency.position,
  50. 'decimalSeparator': currency.decimal_separator,
  51. 'decimalPlaces': currency.decimal_places,
  52. 'thousandsSeparator': currency.thousands_separator
  53. } for currency in request.env['res.currency'].search([('active', '=', True)])]
  54. '''
  55. Get all active journals
  56. '''
  57. def get_journals(self):
  58. return [{
  59. 'id': journal.id,
  60. 'name': journal.name,
  61. 'displayName': journal.display_name,
  62. 'code': journal.code,
  63. 'cashControl': journal.cash_control,
  64. 'type': journal.type,
  65. 'currency': {
  66. 'id': journal.currency.id,
  67. 'name': journal.currency.name,
  68. 'displayName': journal.currency.display_name
  69. },
  70. 'defaultCreditAccount': {
  71. 'id': journal.default_credit_account_id.id,
  72. 'name': journal.default_credit_account_id.name,
  73. 'displayName': journal.default_credit_account_id.display_name,
  74. 'code': journal.default_credit_account_id.code,
  75. 'exchangeRate': journal.default_credit_account_id.exchange_rate,
  76. 'foreignBalance': journal.default_credit_account_id.foreign_balance,
  77. 'reconcile': journal.default_credit_account_id.reconcile,
  78. 'debit': journal.default_credit_account_id.debit,
  79. 'credit': journal.default_credit_account_id.credit,
  80. 'currencyMode': journal.default_credit_account_id.currency_mode,
  81. 'companyCurrency': {
  82. 'id': journal.default_credit_account_id.company_currency_id.id,
  83. 'name': journal.default_credit_account_id.company_currency_id.name,
  84. 'displayName': journal.default_credit_account_id.company_currency_id.display_name,
  85. },
  86. 'currency': {
  87. 'id': journal.default_credit_account_id.currency_id.id,
  88. 'name': journal.default_credit_account_id.currency_id.name,
  89. 'displayName': journal.default_credit_account_id.currency_id.display_name
  90. },
  91. },
  92. 'defaultDebitAccount': {
  93. 'id': journal.default_debit_account_id.id,
  94. 'name': journal.default_debit_account_id.name,
  95. 'displayName': journal.default_debit_account_id.display_name,
  96. 'code': journal.default_debit_account_id.code,
  97. 'exchange_rate': journal.default_credit_account_id.exchange_rate,
  98. 'foreignBalance': journal.default_credit_account_id.foreign_balance,
  99. 'reconcile': journal.default_credit_account_id.reconcile,
  100. 'debit': journal.default_credit_account_id.debit,
  101. 'credit': journal.default_credit_account_id.credit,
  102. 'currencyMode': journal.default_credit_account_id.currency_mode,
  103. 'companyCurrency': {
  104. 'id': journal.default_credit_account_id.company_currency_id.id,
  105. 'name': journal.default_credit_account_id.company_currency_id.name,
  106. 'displayName': journal.default_credit_account_id.company_currency_id.display_name,
  107. },
  108. 'currency': {
  109. 'id': journal.default_credit_account_id.currency_id.id,
  110. 'name': journal.default_credit_account_id.currency_id.name,
  111. 'displayName': journal.default_credit_account_id.currency_id.display_name
  112. }
  113. }
  114. } for journal in request.env['account.journal'].search([('type', 'in', ['bank', 'cash']), ('default_debit_account_id.currency_id', '=', False), ('active', '=', True)], order='id')]
  115. '''
  116. Get all active customers
  117. '''
  118. def get_customers(self):
  119. return [{
  120. 'id': customer.id,
  121. 'name': customer.name,
  122. 'displayName': customer.display_name,
  123. 'imageMedium': customer.image_medium,
  124. 'phone': customer.phone,
  125. 'mobile': customer.mobile,
  126. 'email': customer.email
  127. } for customer in request.env['res.partner'].search([('customer', '=', True), ('active', '=', True)])]
  128. '''
  129. Get all saleable and active products
  130. '''
  131. def get_products(self):
  132. return [{
  133. 'id': product.id,
  134. 'name': product.name,
  135. 'displayName': product.display_name,
  136. 'ean13': product.ean13,
  137. 'imageMedium': product.image_medium,
  138. 'listPrice': product.list_price,
  139. 'variantCount': product.product_variant_count,
  140. 'variants': [{
  141. 'id': variant.id,
  142. 'name': variant.name,
  143. 'displayName': variant.display_name,
  144. 'ean13': variant.ean13,
  145. 'imageMedium': variant.image_medium,
  146. 'listPrice': variant.list_price
  147. } for variant in product.product_variant_ids if variant.active]
  148. } for product in request.env['product.template'].search([('sale_ok', '=', True), ('list_price', '>', 0), ('active', '=', True)])]
  149. '''
  150. Get all active payment terms
  151. '''
  152. def get_payment_terms(self):
  153. return [{
  154. 'id': payment_term.id,
  155. 'name': payment_term.name,
  156. 'displayName': payment_term.display_name,
  157. 'lines': [{
  158. 'id': line.id,
  159. 'days': line.days,
  160. 'days2': line.days2,
  161. 'value': line.value,
  162. 'value_amount': line.value_amount
  163. } for line in payment_term.line_ids]
  164. } for payment_term in request.env['account.payment.term'].search([('active', '=', True)])]
  165. '''
  166. Make JSON response
  167. '''
  168. def make_json_response(self, data=None, status=200):
  169. return Response(json.dumps(data), status=status, content_type='application/json')
  170. '''
  171. Make GZIP to JSON response
  172. '''
  173. def make_gzip_response(self, data=None, status=200):
  174. gzip_buffer = IO()
  175. with GzipFile(mode='wb', compresslevel=9, fileobj=gzip_buffer) as gzip_file:
  176. gzip_file.write(json.dumps(data))
  177. contents = gzip_buffer.getvalue()
  178. gzip_buffer.close()
  179. headers = Headers()
  180. headers.add('Content-Encoding', 'gzip')
  181. headers.add('Vary', 'Accept-Encoding')
  182. headers.add('Content-Length', len(contents))
  183. return Response(contents, status=status, headers=headers, content_type='application/json')
  184. '''
  185. '''
  186. def make_info_log(self, log):
  187. LOGGER.info(log)
  188. '''
  189. New purchase resource route
  190. '''
  191. @http.route('/eiru_sales/new', auth='user', methods=['GET'], cors='*')
  192. def init_sale(self, **kw):
  193. self.make_info_log('Sending JSON response')
  194. return self.make_gzip_response({
  195. 'date': self.get_server_date(),
  196. 'user': self.get_user(),
  197. 'currencies': self.get_currencies(),
  198. 'journals': self.get_journals(),
  199. 'customers': self.get_customers(),
  200. 'products': self.get_products(),
  201. 'paymentTerms': self.get_payment_terms()
  202. })