main.py 20 KB

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