main.py 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404
  1. # -*- coding: utf-8 -*-
  2. from openerp import http
  3. from openerp.http import request
  4. from http_response import make_gzip_response
  5. import logging
  6. LOGGER = logging.getLogger(__name__)
  7. class PosSales(http.Controller):
  8. #################
  9. # ╦ ╔═╗╔═╗ #
  10. # ║ ║ ║║ ╦ #
  11. # ╩═╝╚═╝╚═╝ #
  12. #################
  13. def make_info_log(self, log):
  14. LOGGER.info('\033[1;34m[INFO] --> \033[m{}'.format(log))
  15. #####################################
  16. # ╦╔╗╔╦╔╦╗ ╔═╗╦═╗╔═╗╔═╗╔═╗╔═╗╔═╗ #
  17. # ║║║║║ ║ ╠═╝╠╦╝║ ║║ ║╣ ╚═╗╚═╗ #
  18. # ╩╝╚╝╩ ╩ ╩ ╩╚═╚═╝╚═╝╚═╝╚═╝╚═╝ #
  19. #####################################
  20. @http.route('/eiru_sales/init', auth='user', methods=['GET'], cors='*')
  21. def _init_sale(self, **kw):
  22. self.make_info_log('Sending JSON response')
  23. # Imports
  24. from server_datetime import get_datetime
  25. from res_currency import check_base_currency
  26. from res_config import get_pos_config
  27. from res_users import get_users
  28. from account_journal import get_journals, get_currencies_from_journals
  29. from res_partner import get_customers
  30. from product_template import get_products
  31. from product_pricelist import get_pricelists
  32. from account_payment_term import get_payment_terms
  33. from res_bank import get_banks
  34. from res_bank_payment_type import get_bank_payment_types
  35. from res_bank_cheque_type import get_cheque_types
  36. from res_store import get_stores
  37. from res_currency import get_base_currency
  38. from sale_order import get_sale_orders
  39. from stock_picking import get_pickings
  40. from stock_warehouse import get_warehouses
  41. from decimal_precision import check_discount_precision
  42. # Logic
  43. check_base_currency()
  44. check_discount_precision()
  45. config = get_pos_config()
  46. image_type = config.get('imageType')
  47. mode = kw.get('mode', 'unknown')
  48. data = {}
  49. warehouses = get_warehouses()
  50. currencies = get_currencies_from_journals()
  51. if len(currencies) == 0:
  52. currencies = [get_base_currency()]
  53. # Take all data
  54. if mode == 'sale':
  55. data = {
  56. 'settings': config,
  57. 'date': get_datetime(),
  58. 'users': get_users(),
  59. 'currencies': currencies,
  60. 'journals': get_journals(),
  61. 'customers': get_customers(image_type),
  62. 'products': get_products(image_type, map(lambda x: x.get('locationStock').get('id'), warehouses)),
  63. 'pricelists': get_pricelists('sale'),
  64. 'paymentTerms': get_payment_terms(),
  65. 'banks': get_banks(),
  66. 'bankPaymentTypes': get_bank_payment_types(),
  67. 'chequeTypes': get_cheque_types(),
  68. 'warehouses': warehouses
  69. }
  70. # Take data for picking
  71. if mode == 'product_picking':
  72. data = {
  73. 'settings': config,
  74. 'date': get_datetime(),
  75. 'users': get_users(),
  76. 'currencies': currencies,
  77. 'journals': get_journals(),
  78. 'customers': get_customers(image_type=image_type),
  79. 'products': get_products(image_type, map(lambda x: x.get('locationStock').get('id'), warehouses)),
  80. 'paymentTerms': get_payment_terms(),
  81. 'warehouses': warehouses
  82. }
  83. # Take data for payment
  84. if mode == 'payment':
  85. data = {
  86. 'saleOrders': get_sale_orders(),
  87. 'currencies': currencies,
  88. 'customers': get_customers(image_type=image_type),
  89. 'journals': get_journals(),
  90. 'paymentTerms': get_payment_terms(),
  91. 'banks': get_banks(),
  92. 'bankPaymentTypes': get_bank_payment_types(),
  93. 'chequeTypes': get_cheque_types(),
  94. 'stores': get_stores()
  95. }
  96. # Take data for delivery
  97. if mode == 'product_delivery':
  98. data = {
  99. 'stockPickings': get_pickings()
  100. }
  101. return make_gzip_response(data)
  102. #####################################################################
  103. # ╔═╗╔═╗╔╦╗ ╔═╗╦═╗╔═╗╔╦╗╦ ╦╔═╗╔╦╗╔═╗ ╔╦╗╔═╗╔╦╗╔═╗ ╔═╗╔╗╔╦ ╦ ╦ #
  104. # ║ ╦║╣ ║ ╠═╝╠╦╝║ ║ ║║║ ║║ ║ ╚═╗ ║║╠═╣ ║ ╠═╣ ║ ║║║║║ ╚╦╝ #
  105. # ╚═╝╚═╝ ╩ ╩ ╩╚═╚═╝═╩╝╚═╝╚═╝ ╩ ╚═╝ ═╩╝╩ ╩ ╩ ╩ ╩ ╚═╝╝╚╝╩═╝╩ #
  106. #####################################################################
  107. @http.route('/eiru_sales/get_images', auth='user', methods=['GET'], cors='*')
  108. def _get_images_only(self, **kw):
  109. from res_config import get_pos_config
  110. image_type = str(get_pos_config().get('imageType'))
  111. # Imports
  112. from res_partner import get_customers
  113. from product_template import get_products
  114. return make_gzip_response({
  115. 'customers': get_customers(image_type=image_type),
  116. 'products': get_products(image_type=image_type)
  117. })
  118. #################################################################################################
  119. # ╔═╗╦═╗╔═╗╔═╗╔╦╗╔═╗ ╔═╗╦ ╦╔═╗╔╦╗╔═╗╔╦╗╔═╗╦═╗ ╔═╗╔╗╔╔╦╗ ╦═╗╔═╗╔╦╗╦ ╦╦═╗╔╗╔ ╔╦╗╔═╗╔╦╗╔═╗ #
  120. # ║ ╠╦╝║╣ ╠═╣ ║ ║╣ ║ ║ ║╚═╗ ║ ║ ║║║║║╣ ╠╦╝ ╠═╣║║║ ║║ ╠╦╝║╣ ║ ║ ║╠╦╝║║║ ║║╠═╣ ║ ╠═╣ #
  121. # ╚═╝╩╚═╚═╝╩ ╩ ╩ ╚═╝ ╚═╝╚═╝╚═╝ ╩ ╚═╝╩ ╩╚═╝╩╚═ ╩ ╩╝╚╝═╩╝ ╩╚═╚═╝ ╩ ╚═╝╩╚═╝╚╝ ═╩╝╩ ╩ ╩ ╩ ╩ #
  122. #################################################################################################
  123. @http.route('/eiru_sales/create_customer', type='json', auth='user', methods=['POST'], cors='*')
  124. def _create_customer(self, **kw):
  125. from res_partner import create_customer
  126. self.make_info_log('Creating customer')
  127. return create_customer(kw)
  128. #############################################
  129. # ╔═╗╔═╗╦ ╦╔═╗ ╔═╗╔═╗╔╦╗╔╦╗╦╔╗╔╔═╗╔═╗ #
  130. # ╚═╗╠═╣╚╗╔╝║╣ ╚═╗║╣ ║ ║ ║║║║║ ╦╚═╗ #
  131. # ╚═╝╩ ╩ ╚╝ ╚═╝ ╚═╝╚═╝ ╩ ╩ ╩╝╚╝╚═╝╚═╝ #
  132. #############################################
  133. @http.route('/eiru_sales/save_settings', type='json', auth='user', methods=['POST'], cors='*')
  134. def _save_config(self, **kw):
  135. from res_config import save_pos_config
  136. self.make_info_log('save settings')
  137. return save_pos_config(kw)
  138. #############################################################################################
  139. # ╔═╗╦═╗╔═╗╔═╗╔╦╗╔═╗ ╔═╗╦═╗╔═╗╔╦╗╦ ╦╔═╗╔╦╗ ╔═╗╔╗╔╔╦╗ ╦═╗╔═╗╔╦╗╦ ╦╦═╗╔╗╔ ╔╦╗╔═╗╔╦╗╔═╗ #
  140. # ║ ╠╦╝║╣ ╠═╣ ║ ║╣ ╠═╝╠╦╝║ ║ ║║║ ║║ ║ ╠═╣║║║ ║║ ╠╦╝║╣ ║ ║ ║╠╦╝║║║ ║║╠═╣ ║ ╠═╣ #
  141. # ╚═╝╩╚═╚═╝╩ ╩ ╩ ╚═╝ ╩ ╩╚═╚═╝═╩╝╚═╝╚═╝ ╩ ╩ ╩╝╚╝═╩╝ ╩╚═╚═╝ ╩ ╚═╝╩╚═╝╚╝ ═╩╝╩ ╩ ╩ ╩ ╩ #
  142. #############################################################################################
  143. @http.route('/eiru_sales/create_product', type='json', auth='user', methods=['POST'], cors='*')
  144. def _create_product(self, **kw):
  145. from product_template import create_product
  146. return create_product(kw)
  147. #############################################
  148. # ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔═╗╦═╗╔═╗╔═╗╔═╗╔═╗╔═╗ #
  149. # ╠╣ ║║║║║╚═╗╠═╣ ╠═╝╠╦╝║ ║║ ║╣ ╚═╗╚═╗ #
  150. # ╚ ╩╝╚╝╩╚═╝╩ ╩ ╩ ╩╚═╚═╝╚═╝╚═╝╚═╝╚═╝ #
  151. #############################################
  152. @http.route('/eiru_sales/finish', type='json', auth='user', methods=['POST'], cors='*')
  153. def _finish(self, **kw):
  154. self.make_info_log('Finishing...')
  155. # Imports
  156. from server_datetime import get_date, get_datetime
  157. '''
  158. ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔╗ ╦ ╦╔╦╗╔═╗╔═╗╔╦╗ ╔═╗╔═╗╔═╗ ╔═╗╦═╗╔═╗╔═╗╔═╗╔╦╗╦ ╦╦═╗╔═╗
  159. ╠╣ ║║║║║╚═╗╠═╣ ╠╩╗║ ║ ║║║ ╦║╣ ║ ╠═╝║ ║╚═╗ ╠═╝╠╦╝║ ║║ ║╣ ║║║ ║╠╦╝║╣
  160. ╚ ╩╝╚╝╩╚═╝╩ ╩ ╚═╝╚═╝═╩╝╚═╝╚═╝ ╩ ╩ ╚═╝╚═╝ ╩ ╩╚═╚═╝╚═╝╚═╝═╩╝╚═╝╩╚═╚═╝
  161. '''
  162. def finish_budget_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id):
  163. # Imports
  164. from account_journal import get_currency
  165. from sale_order import create_sale_from_cart
  166. # Get currency
  167. currency_id = get_currency(journal_id)
  168. if not currency_id:
  169. currency_id = request.env.user.company_id.currency_id.id
  170. self.make_info_log('[OK] Getting journal')
  171. # Create sale order
  172. sale_order = create_sale_from_cart(customer_id, cart_items, date_now, currency_id, payment_term_id, warehouse_id, user_id)
  173. self.make_info_log('[OK] Creating sale order')
  174. return (sale_order.id, currency_id)
  175. '''
  176. ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔═╗╔═╗╦ ╔═╗ ╔═╗╔═╗╔═╗ ╔═╗╦═╗╔═╗╔═╗╔═╗╔╦╗╦ ╦╦═╗╔═╗
  177. ╠╣ ║║║║║╚═╗╠═╣ ╚═╗╠═╣║ ║╣ ╠═╝║ ║╚═╗ ╠═╝╠╦╝║ ║║ ║╣ ║║║ ║╠╦╝║╣
  178. ╚ ╩╝╚╝╩╚═╝╩ ╩ ╚═╝╩ ╩╩═╝╚═╝ ╩ ╚═╝╚═╝ ╩ ╩╚═╚═╝╚═╝╚═╝═╩╝╚═╝╩╚═╚═╝
  179. '''
  180. def finish_sale_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, payment, payment_method, bank_payment_data, warehouse_id, user_id):
  181. # Create budget
  182. sale_order_id, currency_id = finish_budget_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id)
  183. # Imports
  184. from sale_order import confirm_sale_order
  185. from account_invoice import (
  186. create_invoice,
  187. create_invoice_move_lines,
  188. number_invoice,
  189. close_invoice
  190. )
  191. from account_move import create_account_move
  192. from account_voucher import create_account_voucher
  193. from account_bank_statement import create_bank_statement
  194. from res_bank_payment import create_bank_payment_statement
  195. # Confirm sale
  196. confirm_sale_order(sale_order_id)
  197. self.make_info_log('[OK] Confirm sale order')
  198. # Create invoice
  199. invoice = create_invoice(sale_order_id, currency_id, user_id, date_now)
  200. self.make_info_log('[OK] Creating invoice')
  201. # Create invoice move lines
  202. invoice_move_lines = create_invoice_move_lines(invoice.id, payment, date_now)
  203. self.make_info_log('[OK] Creating invoice move lines')
  204. # Create account move
  205. account_move = create_account_move(invoice.id, invoice_move_lines)
  206. self.make_info_log('[OK] Creating account move')
  207. # Number invoice
  208. number_invoice(invoice.id)
  209. self.make_info_log('[OK] Number invoice')
  210. # Create account voucher
  211. account_voucher = create_account_voucher(account_move.id, journal_id, currency_id, payment)
  212. self.make_info_log('[OK] Creating account voucher')
  213. # Close invoice
  214. close_invoice(invoice.id)
  215. self.make_info_log('[OK] Closing invoice')
  216. # Create bank statement
  217. create_bank_statement(account_voucher.id, date_now)
  218. self.make_info_log('[OK] Creating account bank statement')
  219. # Create bank payment statement
  220. if payment_method == 'Banco':
  221. create_bank_payment_statement(bank_payment_data, invoice.id, account_voucher.id)
  222. self.make_info_log('[OK] Creating bank payment statement')
  223. '''
  224. ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔═╗╦═╗╔═╗╔╦╗╦ ╦╔═╗╔╦╗ ╔═╗╦╔═╗╦╔═╦╔╗╔╔═╗
  225. ╠╣ ║║║║║╚═╗╠═╣ ╠═╝╠╦╝║ ║ ║║║ ║║ ║ ╠═╝║║ ╠╩╗║║║║║ ╦
  226. ╚ ╩╝╚╝╩╚═╝╩ ╩ ╩ ╩╚═╚═╝═╩╝╚═╝╚═╝ ╩ ╩ ╩╚═╝╩ ╩╩╝╚╝╚═╝
  227. '''
  228. def finish_process_picking(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id):
  229. sale_order_id, _ = finish_budget_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id)
  230. # Imports
  231. from sale_order import confirm_sale_order, force_assign_picking
  232. # Confirm sale
  233. confirm_sale_order(sale_order_id)
  234. self.make_info_log('[OK] Confirm sale order')
  235. # Force assign picking
  236. force_assign_picking(sale_order_id)
  237. self.make_info_log('[OK] Pick assign')
  238. '''
  239. ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔═╗╔═╗╦ ╦╔╦╗╔═╗╔╗╔╔╦╗
  240. ╠╣ ║║║║║╚═╗╠═╣ ╠═╝╠═╣╚╦╝║║║║╣ ║║║ ║
  241. ╚ ╩╝╚╝╩╚═╝╩ ╩ ╩ ╩ ╩ ╩ ╩ ╩╚═╝╝╚╝ ╩
  242. '''
  243. def finish_payment(sale_order_id, currency_id, date_now, payment_term_id, user_id, payment, payment_method, bank_payment_data):
  244. # Imports
  245. from account_invoice import (
  246. create_invoice,
  247. create_invoice_move_lines,
  248. number_invoice,
  249. close_invoice
  250. )
  251. from account_move import create_account_move
  252. from account_voucher import create_account_voucher
  253. from account_bank_statement import create_bank_statement
  254. from res_bank_payment import create_bank_payment_statement
  255. # Payment term
  256. sale_order = request.env['sale.order'].browse(sale_order_id)
  257. sale_order.write({
  258. 'payment_term': payment_term_id
  259. })
  260. # Create invoice
  261. invoice = create_invoice(sale_order_id, currency_id, user_id, date_now, False)
  262. self.make_info_log('[OK] Creating invoice')
  263. # Create invoice move lines
  264. invoice_move_lines = create_invoice_move_lines(invoice.id, payment, date_now)
  265. self.make_info_log('[OK] Creating invoice move lines')
  266. # Create account move
  267. account_move = create_account_move(invoice.id, invoice_move_lines)
  268. self.make_info_log('[OK] Creating account move')
  269. # Number invoice
  270. number_invoice(invoice.id)
  271. self.make_info_log('[OK] Number invoice')
  272. # Create account voucher
  273. account_voucher = create_account_voucher(account_move.id, journal_id, currency_id, payment)
  274. self.make_info_log('[OK] Creating account voucher')
  275. # Close invoice
  276. close_invoice(invoice.id)
  277. self.make_info_log('[OK] Closing invoice')
  278. # Create bank statement
  279. create_bank_statement(account_voucher.id, date_now)
  280. self.make_info_log('[OK] Creating account bank statement')
  281. # Create bank payment statement
  282. if payment_method == 'Banco':
  283. create_bank_payment_statement(bank_payment_data, invoice.id, account_voucher.id)
  284. self.make_info_log('[OK] Creating bank payment statement')
  285. '''
  286. ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔═╗╦═╗╔═╗╔╦╗╦ ╦╔═╗╔╦╗ ╔╦╗╔═╗╦ ╦╦ ╦╔═╗╦═╗╦ ╦
  287. ╠╣ ║║║║║╚═╗╠═╣ ╠═╝╠╦╝║ ║ ║║║ ║║ ║ ║║║╣ ║ ║╚╗╔╝║╣ ╠╦╝╚╦╝
  288. ╚ ╩╝╚╝╩╚═╝╩ ╩ ╩ ╩╚═╚═╝═╩╝╚═╝╚═╝ ╩ ═╩╝╚═╝╩═╝╩ ╚╝ ╚═╝╩╚═ ╩
  289. '''
  290. def finish_product_delivery(stock_picking_id, user_id):
  291. from stock_picking import confirm_picking
  292. confirm_picking(stock_picking_id, user_id)
  293. '''
  294. ╔═╗╦═╗╔═╗╔═╗╔═╗╔═╗╔═╗ ╔═╗╦╔╗╔╦╔═╗╦ ╦ ╔╦╗╔═╗╔═╗╦╔═╗╦╔═╗╔╗╔
  295. ╠═╝╠╦╝║ ║║ ║╣ ╚═╗╚═╗ ╠╣ ║║║║║╚═╗╠═╣ ║║║╣ ║ ║╚═╗║║ ║║║║
  296. ╩ ╩╚═╚═╝╚═╝╚═╝╚═╝╚═╝ ╚ ╩╝╚╝╩╚═╝╩ ╩ ═╩╝╚═╝╚═╝╩╚═╝╩╚═╝╝╚╝
  297. '''
  298. data = kw.get('data', [])
  299. date_now = get_date()
  300. for row in data:
  301. mode = row.get('mode', 'sale')
  302. journal_id = row.get('journalId', None)
  303. customer_id = row.get('customerId', None)
  304. cart_items = row.get('items', [])
  305. payment_term_id = row.get('paymentTermId', None)
  306. warehouse_id = row.get('warehouseId', None)
  307. user_id = row.get('userId', None)
  308. payment = float(row.get('payment', 0.0))
  309. payment_method = row.get('paymentMethod', 'Efectivo')
  310. bank_payment_data = row.get('bankPaymentData', {})
  311. if mode == 'budget':
  312. finish_budget_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id)
  313. if mode == 'sale':
  314. finish_sale_pos(journal_id, customer_id, cart_items, date_now, payment_term_id, payment, payment_method, bank_payment_data, warehouse_id, user_id)
  315. if mode == 'product_picking':
  316. finish_process_picking(journal_id, customer_id, cart_items, date_now, payment_term_id, warehouse_id, user_id)
  317. if mode == 'payment':
  318. sale_order_id = row.get('saleOrderId', None)
  319. currency_id = row.get('currencyId', None)
  320. finish_payment(sale_order_id, currency_id, date_now, payment_term_id, user_id, payment, payment_method, bank_payment_data)
  321. if mode == 'product_delivery':
  322. stock_picking_id = row.get('stockPickingId', None)
  323. finish_product_delivery(stock_picking_id, user_id)
  324. return {
  325. 'process': True,
  326. 'date': get_datetime()
  327. }