products_controller.rb 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344
  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. def create
  81. @with_presentation = true
  82. @product = Product.new(product_params)
  83. if @product.presentation
  84. @product.is_parent = true
  85. end
  86. message = 'El producto ' + @product.sku + ' fue creado.'
  87. @product.audit_comment = message
  88. respond_to do |format|
  89. if @product.save
  90. @product.save_variants
  91. ##--- Para cuando se agrega un producto desde purchase
  92. if params[:remoto] == "true"
  93. ##--- Guardar pre_purchase
  94. @pre_purchases = Array.new
  95. if @product.presentation && @product.is_parent
  96. @product.children.each do |variant|
  97. save_pre_purchase(variant)
  98. set_available
  99. @pre_purchases << @pre_purchase
  100. end
  101. else
  102. save_pre_purchase(@product)
  103. set_available
  104. @pre_purchases << @pre_purchase
  105. end
  106. format.json { head :no_content }
  107. format.js
  108. else
  109. format.html { redirect_to products_url, success: message }
  110. format.json { render :show, status: :created, location: @product }
  111. end
  112. else
  113. format.html { render :new }
  114. format.json { render json: @product.errors, status: :unprocessable_entity }
  115. end
  116. end
  117. end
  118. # PATCH/PUT /products/1
  119. # PATCH/PUT /products/1.json
  120. def update
  121. respond_to do |format|
  122. @product.skip_sku_validation = true
  123. @product.is_parent = params[:product][:presentation] == 'true' ? true : false
  124. message = 'El producto ' + @product.sku + ' fue modificado.'
  125. @product.audit_comment = message
  126. if @product.update(product_params)
  127. if @product.is_parent
  128. @product.children.each_with_index do |variant, index|
  129. variant.skip_sku_validation = true
  130. params_to_edit = product_params
  131. params_to_edit[:sku] = @product.sku + (index + 1).to_s + "A"
  132. variant.update_attributes(params_to_edit)
  133. end
  134. end
  135. format.html { redirect_to products_url, success: message }
  136. format.json { render :show, status: :ok, location: @product }
  137. else
  138. format.html { render :edit }
  139. format.json { render json: @product.errors, status: :unprocessable_entity }
  140. end
  141. end
  142. end
  143. def edit_from_purchase
  144. respond_to do |format|
  145. purchase_in_dollars = params[:is_in_dollars]
  146. exchange = params[:exchange].to_f
  147. if purchase_in_dollars == "true"
  148. @product.price_base_dollars = params[:product][:price_base].to_f
  149. price_in_peso = @product.price_base_dollars * exchange
  150. @product.price_base = @product.price_base.present? ? price_in_peso : nil
  151. @suggested_price_sale = (price_in_peso * (@pos_config.gain_margin / 100)) + price_in_peso
  152. else
  153. @product.price_base = params[:product][:price_base].to_f
  154. price_in_dollars = @product.price_base / exchange if exchange != 0
  155. @product.price_base_dollars = @product.price_base_dollars.present? ? price_in_dollars : nil
  156. @suggested_price_sale = (@product.price_base * (@pos_config.gain_margin / 100)) + @product.price_base
  157. end
  158. @product.audit_comment = 'El producto ' + @product.sku + ' fue modificado.'
  159. @product.save
  160. format.json { head :no_content }
  161. format.js
  162. end
  163. end
  164. def update_from_purchase
  165. ##--- Si el producto es hijo, sacar el registro del padre para cambiar todos los valores
  166. unless @product.parent_id.nil?
  167. @product = Product.find(@product.parent_id)
  168. end
  169. message = "Se ha modificado el precio de venta base del producto " + @product.name
  170. respond_to do |format|
  171. if @product.update(product_params)
  172. @product.children.each do |variant|
  173. variant.update_attributes(product_params)
  174. variant.save
  175. end
  176. @product.audit_comment = message
  177. format.json { head :no_content }
  178. format.js { flash[:success] = message }
  179. else
  180. format.js { render :edit_from_purchase }
  181. format.json { render json: @available_product.errors, status: :unprocessable_entity }
  182. end
  183. end
  184. end
  185. def update_status
  186. product = @product
  187. if product.active?
  188. product.status = 2
  189. elsif product.inactive?
  190. product.status = 1
  191. end
  192. if product.presentation
  193. product.children.each do |pv|
  194. pv.status = product.status
  195. pv.save(validate: false)
  196. end
  197. end
  198. respond_to do |format|
  199. message = "El producto " + product.name + " fue " + (product.active? ? "activado" : "desactivado") + "."
  200. product.audit_comment = message
  201. if product.save(validate: false)
  202. format.html { redirect_to products_url, warning: message }
  203. # format.json { render :show, status: :ok, location: @pointsale }
  204. format.json { head :no_content }
  205. else
  206. format.html { redirect_to products_url }
  207. format.json { render json: @product.errors, status: :unprocessable_entity }
  208. end
  209. end
  210. end
  211. # DELETE /products/1
  212. # DELETE /products/1.json
  213. def destroy
  214. respond_to do |format|
  215. message = "El producto " + @product.name + " fue eliminado."
  216. @product.audit_comment = message
  217. if @product.update_attributes(status: 0)
  218. if @product.is_parent
  219. @product.children.each_with_index do |variant|
  220. variant.update_attributes(status: 0)
  221. variant.save
  222. end
  223. end
  224. format.html { redirect_to products_url, warning: message }
  225. format.json { head :no_content }
  226. else
  227. format.html { redirect_to products_url }
  228. format.json { render json: @product.errors, status: :unprocessable_entity }
  229. end
  230. end
  231. end
  232. def validate_unique_barcode
  233. respond_to do |format|
  234. @product = Product.find_by(barcode: params[:barcode])
  235. if @product.blank?
  236. format.js { head :ok }
  237. else
  238. format.js
  239. end
  240. end
  241. end
  242. def product_track
  243. #--Seguimiento de productos
  244. # @sales = SalesDetail.new
  245. product_id = params[:product_id]
  246. pointsale_id = params[:pointsale_id]
  247. start_date = DateTime.parse(params[:start_date]) if params[:start_date].present?
  248. end_date = DateTime.parse(params[:end_date]) if params[:end_date].present?
  249. if product_id.present?
  250. respond_to do |format|
  251. @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")
  252. format.js
  253. end
  254. end
  255. end
  256. private
  257. # Use callbacks to share common setup or constraints between actions.
  258. def set_product
  259. @product = Product.find(params[:id])
  260. end
  261. def set_product_id
  262. @product = Product.find(params[:product_id])
  263. end
  264. def get_filters
  265. @current_page = params[:current_page].blank? ? 1 : params[:current_page]
  266. @filter = params[:filter]
  267. end
  268. # Never trust parameters from the scary internet, only allow the white list through.
  269. def product_params
  270. 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])
  271. end
  272. def get_categories
  273. @categories = Array.new
  274. unless params[:product][:category_ids].blank?
  275. @categories << Category.find(params[:product][:category_ids])
  276. @product.categories = @categories
  277. end
  278. end
  279. def save_pre_purchase(product)
  280. @pre_purchase = PrePurchase.new
  281. @pre_purchase.supplier_id = params[:supplier]
  282. @pre_purchase.pointsale_id = params[:pointsale] if params[:pointsale].present?
  283. @pre_purchase.warehouse_id = params[:warehouse] if params[:warehouse].present?
  284. @pre_purchase.exchange = params[:exchange] if params[:exchange].present?
  285. @pre_purchase.user_id = current_user.id
  286. @pre_purchase.product_id = product.id
  287. @pre_purchase.quantity = 1
  288. @pre_purchase.get_totals
  289. @pre_purchase.save
  290. end
  291. def set_available
  292. ##--- agregar a productos disponibles ya sea punto de venta o almacen
  293. if params[:pointsale].present?
  294. available_product = AvailableProduct.new
  295. available_product.pointsale_id = @pre_purchase.pointsale_id
  296. else
  297. available_product = WarehouseStock.new
  298. available_product.warehouse_id = @pre_purchase.warehouse_id
  299. end
  300. available_product.product_id = @pre_purchase.product_id
  301. available_product.stock_min = params[:stock_min]
  302. available_product.stock_max = params[:stock_max]
  303. available_product.save
  304. end
  305. def get_attrs
  306. @attrs = Array.new
  307. @product.variants_attributes.each do |attri|
  308. @attrs << attri.context
  309. end
  310. end
  311. end