products_controller.rb 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
  1. class ProductsController < ApplicationController
  2. ##--- Abilities
  3. load_and_authorize_resource
  4. ##--- Breadcrum_rails
  5. add_breadcrumb I18n.t("breadcrumbs." + controller_name), :products_path, only: [:index, :new, :show, :edit]
  6. add_breadcrumb "Nuevo " + I18n.t("breadcrumbs." + controller_name).singularize, :new_product_path, only: :new
  7. add_breadcrumb "Detalle del " + I18n.t("breadcrumbs." + controller_name).singularize, :product_path, only: :show
  8. add_breadcrumb "Editar " + I18n.t("breadcrumbs." + controller_name).singularize, :edit_product_path, only: :edit
  9. add_breadcrumb "Seguimiento de productos", :product_track_path, only: :product_track
  10. before_action :set_product, only: [:show, :edit, :update, :destroy]
  11. before_action :set_product_id, only: [:list_prices, :list_prices_variants, :edit_variants, :update_variants, :edit_from_purchase, :update_from_purchase, :update_status]
  12. before_action :get_categories, only: [:create, :update]
  13. before_action :get_attrs, only: [:show, :edit, :update]
  14. before_action :get_filters, only: [:index, :show, :edit, :new]
  15. skip_before_action :get_categories, only: [:edit_from_purchase]
  16. # GET /products
  17. # GET /products.json
  18. def index
  19. respond_to do |format|
  20. format.html
  21. format.json { render json: ProductsDatatable.new(view_context, current_user) }
  22. end
  23. end
  24. def list_prices
  25. if @product.presentation
  26. # @available_products = @product.get_available_children(false)
  27. @pointsales = @product.get_available_children(true)
  28. end
  29. end
  30. def list_prices_variants
  31. children = Product.where("parent_id = ? and status != 0 ", params[:product_id]).pluck(:id)
  32. @variants = AvailableProduct.where("pointsale_id = ? and product_id IN (?)", params[:pointsale_id], children).includes(:product)
  33. @variants_json = Array.new
  34. @variants.each do |v|
  35. @variants_json.push(name: v.product.sku + " " + v.product.name + " <br><small>" + v.product.display_attributes + "</small>", price: v.product.get_price_sale(params[:pointsale_id]), available_product_id: v.id)
  36. end
  37. render json: @variants_json.to_json
  38. end
  39. def edit_variants; end
  40. def update_variants
  41. if @product.is_parent
  42. @product.update_attributes_to_variants(params[:new_size_list], params[:new_color_list], params[:new_style_list])
  43. @product.save_new_attributes(params[:mynewsizes], params[:mynewcolors], params[:mynewstyles])
  44. end
  45. respond_to do |format|
  46. if @product.save(validate: false)
  47. format.html { redirect_to products_url, success: 'Se modificaron las variantes del producto ' + @product.sku + ' - ' + @product.name + '.' }
  48. format.json { render :show, status: :ok, location: @product }
  49. else
  50. format.html { render :edit_variants }
  51. format.json { render json: @product.errors, status: :unprocessable_entity }
  52. end
  53. end
  54. end
  55. # GET /products/1
  56. # GET /products/1.json
  57. def show; end
  58. # GET /products/new
  59. def new
  60. @product = Product.new
  61. # Default unit is 'Pieza'
  62. @product.unit = Unit.where(unit: 'Pieza').first
  63. if params[:remoto].present?
  64. @remoto = params[:remoto]
  65. @pointsale = params[:pointsale]
  66. @warehouse = params[:warehouse]
  67. @supplier = params[:supplier]
  68. @exchange = params[:exchange]
  69. end
  70. @product.price_base = nil
  71. @product.price_sale = nil
  72. end
  73. # GET /products/1/edit
  74. def edit
  75. has_variants = @product.children.any?
  76. @with_presentation = has_variants ? true : false # si aun no tiene variantes, permitir clickear el switch
  77. end
  78. # POST /products
  79. # POST /products.json
  80. # rubocop:disable Metrics/BlockLength
  81. def create
  82. @with_presentation = true
  83. @product = Product.new(product_params)
  84. if @product.presentation
  85. @product.is_parent = true
  86. end
  87. message = 'El producto ' + @product.sku + ' fue creado.'
  88. @product.audit_comment = message
  89. respond_to do |format|
  90. if @product.save
  91. @product.save_variants(current_user)
  92. ##--- Para cuando se agrega un producto desde purchase
  93. if params[:remoto] == "true"
  94. ##--- Guardar pre_purchase
  95. @pre_purchases = Array.new
  96. if @product.presentation && @product.is_parent
  97. @product.children.each do |variant|
  98. save_pre_purchase(variant)
  99. set_available
  100. @pre_purchases << @pre_purchase
  101. end
  102. else
  103. save_pre_purchase(@product)
  104. set_available
  105. @pre_purchases << @pre_purchase
  106. end
  107. format.json { head :no_content }
  108. format.js
  109. else
  110. # crear available product para el p.v, cuando es sin variantes
  111. if current_user.usertype == 'G' && !@product.presentation && !@product.is_parent
  112. AvailableProduct.create(product_id: @product.id, pointsale_id: current_user.pointsale_id, stock: 0)
  113. end
  114. format.html { redirect_to products_url, success: message }
  115. format.json { render :show, status: :created, location: @product }
  116. end
  117. else
  118. format.html { render :new }
  119. format.json { render json: @product.errors, status: :unprocessable_entity }
  120. end
  121. end
  122. end
  123. # rubocop:enable Metrics/BlockLength
  124. # PATCH/PUT /products/1
  125. # PATCH/PUT /products/1.json
  126. def update
  127. respond_to do |format|
  128. @product.skip_sku_validation = true
  129. @product.is_parent = params[:product][:presentation] == 'true' ? true : false
  130. message = 'El producto ' + @product.sku + ' fue modificado.'
  131. @product.audit_comment = message
  132. if @product.update(product_params)
  133. if @product.is_parent
  134. @product.children.each_with_index do |variant, index|
  135. variant.skip_sku_validation = true
  136. params_to_edit = product_params
  137. params_to_edit[:sku] = @product.sku + (index + 1).to_s + "A"
  138. variant.update_attributes(params_to_edit)
  139. end
  140. end
  141. format.html { redirect_to products_url, success: message }
  142. format.json { render :show, status: :ok, location: @product }
  143. else
  144. format.html { render :edit }
  145. format.json { render json: @product.errors, status: :unprocessable_entity }
  146. end
  147. end
  148. end
  149. def edit_from_purchase
  150. respond_to do |format|
  151. purchase_in_dollars = params[:is_in_dollars]
  152. exchange = params[:exchange].to_f
  153. if purchase_in_dollars == "true"
  154. @product.price_base_dollars = params[:product][:price_base].to_f
  155. price_in_peso = @product.price_base_dollars * exchange
  156. @product.price_base = @product.price_base.present? ? price_in_peso : nil
  157. @suggested_price_sale = (price_in_peso * (@pos_config.gain_margin / 100)) + price_in_peso
  158. else
  159. @product.price_base = params[:product][:price_base].to_f
  160. price_in_dollars = @product.price_base / exchange if exchange != 0
  161. @product.price_base_dollars = @product.price_base_dollars.present? ? price_in_dollars : nil
  162. @suggested_price_sale = (@product.price_base * (@pos_config.gain_margin / 100)) + @product.price_base
  163. end
  164. @product.audit_comment = 'El producto ' + @product.sku + ' fue modificado.'
  165. @product.save
  166. format.json { head :no_content }
  167. format.js
  168. end
  169. end
  170. def update_from_purchase
  171. ##--- Si el producto es hijo, sacar el registro del padre para cambiar todos los valores
  172. unless @product.parent_id.nil?
  173. @product = Product.find(@product.parent_id)
  174. end
  175. message = "Se ha modificado el precio de venta base del producto " + @product.name
  176. respond_to do |format|
  177. if @product.update(product_params)
  178. @product.children.each do |variant|
  179. variant.update_attributes(product_params)
  180. variant.save
  181. end
  182. @product.audit_comment = message
  183. format.json { head :no_content }
  184. format.js { flash[:success] = message }
  185. else
  186. format.js { render :edit_from_purchase }
  187. format.json { render json: @available_product.errors, status: :unprocessable_entity }
  188. end
  189. end
  190. end
  191. def update_status
  192. product = @product
  193. if product.active?
  194. product.status = 2
  195. elsif product.inactive?
  196. product.status = 1
  197. end
  198. if product.presentation
  199. product.children.each do |pv|
  200. pv.status = product.status
  201. pv.save(validate: false)
  202. end
  203. end
  204. respond_to do |format|
  205. message = "El producto " + product.name + " fue " + (product.active? ? "activado" : "desactivado") + "."
  206. product.audit_comment = message
  207. if product.save(validate: false)
  208. format.html { redirect_to products_url, warning: message }
  209. # format.json { render :show, status: :ok, location: @pointsale }
  210. format.json { head :no_content }
  211. else
  212. format.html { redirect_to products_url }
  213. format.json { render json: @product.errors, status: :unprocessable_entity }
  214. end
  215. end
  216. end
  217. # DELETE /products/1
  218. # DELETE /products/1.json
  219. def destroy
  220. respond_to do |format|
  221. message = "El producto " + @product.name + " fue eliminado."
  222. @product.audit_comment = message
  223. if @product.update_attributes(status: 0)
  224. if @product.is_parent
  225. @product.children.each_with_index do |variant|
  226. variant.update_attributes(status: 0)
  227. variant.save
  228. end
  229. end
  230. format.html { redirect_to products_url, warning: message }
  231. format.json { head :no_content }
  232. else
  233. format.html { redirect_to products_url }
  234. format.json { render json: @product.errors, status: :unprocessable_entity }
  235. end
  236. end
  237. end
  238. def validate_unique_barcode
  239. respond_to do |format|
  240. @product = Product.find_by(barcode: params[:barcode])
  241. if @product.blank?
  242. format.js { head :ok }
  243. else
  244. format.js
  245. end
  246. end
  247. end
  248. def product_track
  249. #--Seguimiento de productos
  250. # @sales = SalesDetail.new
  251. product_id = params[:product_id]
  252. pointsale_id = params[:pointsale_id]
  253. start_date = DateTime.parse(params[:start_date]) if params[:start_date].present?
  254. end_date = DateTime.parse(params[:end_date]) if params[:end_date].present?
  255. if product_id.present?
  256. respond_to do |format|
  257. @sales = pointsale_id.present? ? Pointsale.find(pointsale_id).sales_details.includes(:sale).where(sales: { date_sale: start_date..end_date }).where('sales.status != 1 and sales_details.product_id = ?', product_id).order("sales_details.id DESC") : SalesDetail.includes(:sale).where(sales: { date_sale: start_date..end_date }).where('sales.status != 1 and sales_details.product_id = ?', product_id).order("sales_details.id DESC")
  258. format.js
  259. end
  260. end
  261. end
  262. private
  263. # Use callbacks to share common setup or constraints between actions.
  264. def set_product
  265. @product = Product.find(params[:id])
  266. end
  267. def set_product_id
  268. @product = Product.find(params[:product_id])
  269. end
  270. def get_filters
  271. @current_page = params[:current_page].blank? ? 1 : params[:current_page]
  272. @filter = params[:filter]
  273. end
  274. # Never trust parameters from the scary internet, only allow the white list through.
  275. def product_params
  276. params.require(:product).permit(:sku, :name, :description, :price_base, :price_sale, :img_product, :img_product_cache, :presentation, :inventory, :unit_id, :content, :status, :categorias, :category_ids, :include_purchase_tax, :include_sale_tax, :barcode, :is_in_dollars, :price_base_dollars, size_list: [], color_list: [], style_list: [], available_products_attributes: [:id, :price_sale])
  277. end
  278. def get_categories
  279. @categories = Array.new
  280. unless params[:product][:category_ids].blank?
  281. @categories << Category.find(params[:product][:category_ids])
  282. @product.categories = @categories
  283. end
  284. end
  285. def save_pre_purchase(product)
  286. @pre_purchase = PrePurchase.new
  287. @pre_purchase.supplier_id = params[:supplier]
  288. @pre_purchase.pointsale_id = params[:pointsale] if params[:pointsale].present?
  289. @pre_purchase.warehouse_id = params[:warehouse] if params[:warehouse].present?
  290. @pre_purchase.exchange = params[:exchange] if params[:exchange].present?
  291. @pre_purchase.user_id = current_user.id
  292. @pre_purchase.product_id = product.id
  293. @pre_purchase.quantity = 1
  294. @pre_purchase.get_totals
  295. @pre_purchase.save
  296. end
  297. def set_available
  298. ##--- agregar a productos disponibles ya sea punto de venta o almacen
  299. if params[:pointsale].present?
  300. available_product = AvailableProduct.new
  301. available_product.pointsale_id = @pre_purchase.pointsale_id
  302. else
  303. available_product = WarehouseStock.new
  304. available_product.warehouse_id = @pre_purchase.warehouse_id
  305. end
  306. available_product.product_id = @pre_purchase.product_id
  307. available_product.stock_min = params[:stock_min]
  308. available_product.stock_max = params[:stock_max]
  309. available_product.save
  310. end
  311. def get_attrs
  312. @attrs = Array.new
  313. @product.variants_attributes.each do |attri|
  314. @attrs << attri.context
  315. end
  316. end
  317. end