module Caboose PageBarGenerator.class_eval do def all_records return model_with_includes.where(where) end end end module Caboose class ProductsController < Caboose::ApplicationController # GET /products || GET /products/:id def index # If id exists, is an integer and a product exists with the specified id then get the product if params[:id] && params[:id].to_i > 0 && Product.exists?(params[:id]) @product = Product.find(params[:id]) render 'product/not_available' and return if @product.status == 'Inactive' @category = @product.categories.first @review = Review.new @reviews = Review.where(:product_id => @product.id).limit(10).order("id DESC") || nil @logged_in_user = logged_in_user render 'caboose/products/details' and return end # Filter params from url url_without_params = request.fullpath.split('?').first # Find the category cat = Category.where(:site_id => @site.id, :url => url_without_params).first if cat.nil? cat = Category.where(:site_id => @site.id, :url => '/products').first cat = Category.create(:site_id => @site.id, :url => '/products') if cat.nil? end # Set category ID params['category_id'] = cat.id # If this is the top-most category, collect all it's immediate children IDs params['category_id'] = cat.children.collect { |child| child.id } if cat.id == 1 # Shove the original category ID into the first position if the param is an array params['category_id'].unshift(category.id) if params['category_id'].is_a?(Array) # Otherwise looking at a category or search parameters @pager = Caboose::Pager.new(params, { 'site_id' => @site.id, 'category_id' => '', 'vendor_id' => '', 'vendor_name' => '', 'vendor_status' => 'Active', 'status' => 'Active', 'variant_status' => 'Active', 'price_gte' => '', 'price_lte' => '', 'alternate_id' => '', 'search_like' => '' }, { 'model' => 'Caboose::Product', 'sort' => if params[:sort] then params[:sort] else 'store_products.sort_order' end, 'base_url' => url_without_params, 'items_per_page' => 15, 'use_url_params' => false, 'abbreviations' => { 'search_like' => 'title_concat_store_products.alternate_id_concat_vendor_name_concat_category_name_like', }, 'includes' => { 'category_id' => [ 'categories' , 'id' ], 'category_name' => [ 'categories' , 'name' ], 'vendor_id' => [ 'vendor' , 'id' ], 'vendor_name' => [ 'vendor' , 'name' ], 'vendor_status' => [ 'vendor' , 'status' ], 'price_gte' => [ 'variants' , 'price' ], 'price_lte' => [ 'variants' , 'price' ], 'variant_status' => [ 'variants' , 'status' ] } }) @sort_options = [ { :name => 'Default', :value => 'store_products.sort_order' }, { :name => 'Price (Low to High)', :value => 'store_variants.price ASC' }, { :name => 'Price (High to Low)', :value => 'store_variants.price DESC' }, { :name => 'Alphabetical (A-Z)', :value => 'store_products.title ASC' }, { :name => 'Alphabetical (Z-A)', :value => 'store_products.title DESC' }, ] SearchFilter.delete_all @filter = SearchFilter.find_from_url(request.fullpath, @pager, ['page']) @products = @pager.items @category = if @filter['category_id'] then Category.find(@filter['category_id'].to_i) else nil end @pager.set_item_count end def show end # GET /product/info def info p = Product.find(params[:id]) render :json => { :product => p, :option1_values => p.option1_values, :option2_values => p.option2_values, :option3_values => p.option3_values } end #============================================================================= # Admin actions #============================================================================= # GET /admin/products/update-vendor-status/:id def admin_update_vendor_status vendor = Vendor.find(params[:id]) vendor.status = params[:status] render :json => vendor.save end # GET /admin/products def admin_index return if !user_is_allowed('products', 'view') # Temporary patch for vendor name sorting; Fix this params[:sort] = 'store_vendors.name' if params[:sort] == 'vendor' @gen = Caboose::PageBarGenerator.new(params, { 'site_id' => @site.id, 'vendor_name' => '', 'search_like' => '', 'category_id' => '', 'category_name' => '', 'vendor_id' => '', 'vendor_name' => '', 'vendor_status' => '', 'price_gte' => '', 'price_lte' => '', 'price' => '', 'variant_status' => '', 'price' => params[:filters] && params[:filters][:missing_prices] ? 0 : '' }, { 'model' => 'Caboose::Product', 'sort' => 'title', 'desc' => false, 'base_url' => '/admin/products', 'items_per_page' => 25, 'use_url_params' => false, 'abbreviations' => { 'search_like' => 'store_products.title_concat_vendor_name_like' }, 'includes' => { 'category_id' => [ 'categories' , 'id' ], 'category_name' => [ 'categories' , 'name' ], 'vendor_id' => [ 'vendor' , 'id' ], 'vendor_name' => [ 'vendor' , 'name' ], 'vendor_status' => [ 'vendor' , 'status' ], 'price_gte' => [ 'variants' , 'price' ], 'price_lte' => [ 'variants' , 'price' ], 'price' => [ 'variants' , 'price' ], 'variant_status' => [ 'variants' , 'status' ] } }) # Make a copy of all the items; so it can be filtered more @all_products = @gen.all_records # Apply any extra filters if params[:filters] @all_products = @all_products.includes(:product_images).where('store_product_images.id IS NULL') if params[:filters][:missing_images] @all_products = @all_products.where('vendor_id IS NULL') if params[:filters][:no_vendor] end # Get the correct page of the results @products = @all_products.limit(@gen.limit).offset(@gen.offset) @category_options = Category.options(@site.id) render :layout => 'caboose/admin' end # GET /admin/products/json def admin_json return if !user_is_allowed('products', 'view') # Temporary patch for vendor name sorting; Fix this params[:sort] = 'store_vendors.name' if params[:sort] == 'vendor' pager = Caboose::PageBarGenerator.new(params, { 'site_id' => @site.id, 'vendor_name' => '', 'search_like' => '', 'category_id' => '', 'price' => params[:filters] && params[:filters][:missing_prices] ? 0 : '' }, { 'model' => 'Caboose::Product', 'sort' => 'title', 'desc' => false, 'base_url' => '/admin/products', 'items_per_page' => 25, 'use_url_params' => false, 'abbreviations' => { 'search_like' => 'store_products.title_concat_vendor_name_like' }, 'includes' => { 'category_id' => [ 'categories' , 'id' ], 'vendor_name' => [ 'vendor' , 'name' ], 'price' => [ 'variants' , 'price' ] } }) render :json => { :pager => pager, :models => pager.items } end # GET /admin/products/:id/json def admin_json_single p = Product.find(params[:id]) render :json => p end # GET /admin/products/:id/general def admin_edit_general return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # GET /admin/products/:id/description def admin_edit_description return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # GET /admin/products/:id/options def admin_edit_options return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # GET /admin/products/:id/categories def admin_edit_categories return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) @top_categories = Category.where(:parent_id => 1).reorder('name').all @selected_ids = @product.categories.collect{ |cat| cat.id } render :layout => 'caboose/admin' end # GET /admin/products/:id/images def admin_edit_images return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # POST /admin/products/:id/images def admin_add_image return if !user_is_allowed('products', 'edit') product_id = params[:id] if (params[:new_image].nil?) render :text => "" else img = ProductImage.new img.product_id = product_id img.image = params[:new_image] img.square_offset_x = 0 img.square_offset_y = 0 img.square_scale_factor = 1.00 img.save render :text => "" end end # GET /admin/products/:id/collections def admin_edit_collections return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # GET /admin/products/:id/seo def admin_edit_seo return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # GET /admin/products/:id/delete def admin_delete_form return if !user_is_allowed('products', 'edit') @product = Product.find(params[:id]) render :layout => 'caboose/admin' end # PUT /admin/products/:id def admin_update return if !user_is_allowed('products', 'edit') resp = Caboose::StdClass.new({'attributes' => {}}) product = Product.find(params[:id]) save = true params.each do |name,value| case name when 'site_id' then product.site_id = value when 'alternate_id' then product.alternate_id = value when 'title' then product.title = value when 'caption' then product.caption = value when 'featured' then product.featured = value when 'description' then product.description = value when 'vendor_id' then product.vendor_id = value when 'handle' then product.handle = value when 'seo_title' then product.seo_title = value when 'seo_description' then product.seo_description = value when 'status' then product.status = value when 'category_id' then product.toggle_category(value[0], value[1]) when 'stackable_group_id' then product.stackable_group_id = value when 'option1' then product.option1 = value when 'option2' then product.option2 = value when 'option3' then product.option3 = value when 'default1' product.default1 = value Variant.where(:product_id => product.id, :option1 => nil).each do |p| p.option1 = value p.save end when 'default2' product.default2 = value Variant.where(:product_id => product.id, :option2 => nil).each do |p| p.option2 = value p.save end when 'default3' product.default3 = value Variant.where(:product_id => product.id, :option3 => nil).each do |p| p.option3 = value p.save end when 'date_available' if value.strip.length == 0 product.date_available = nil else begin product.date_available = DateTime.parse(value) rescue resp.error = "Invalid date" save = false end end end end resp.success = save && product.save render :json => resp end # GET /admin/products/new def admin_new return if !user_is_allowed('products', 'add') render :layout => 'caboose/admin' end # POST /admin/products def admin_add return if !user_is_allowed('products', 'add') resp = Caboose::StdClass.new name = params[:name] if name.length == 0 resp.error = "The title cannot be empty." else p = Product.new(:site_id => @site.id, :title => name) p.save resp.redirect = "/admin/products/#{p.id}/general" end render :json => resp end # DELETE /admin/products/:id def admin_delete return if !user_is_allowed('products', 'delete') p = Product.find(params[:id]) p.status = 'Deleted' p.save render :json => Caboose::StdClass.new({ :redirect => '/admin/products' }) end # GET /products/status-options def admin_status_options arr = ['Active', 'Inactive', 'Deleted'] render :json => arr.collect{ |status| { :value => status, :text => status }} end # GET /products/stackable-group-options def admin_stackable_group_options arr = ['Active', 'Inactive', 'Deleted'] render :json => arr.collect{ |status| { :value => status, :text => status }} end # GET /admin/products/combine def admin_combine_select_products end # GET /admin/products/combine-step2 def admin_combine_assign_title end # POST /admin/products/combine def admin_combine product_ids = params[:product_ids] p = Product.new p.title = params[:title] p.description = params[:description] p.option1 = params[:option1] p.option2 = params[:option2] p.option3 = params[:option3] p.default1 = params[:default1] p.default2 = params[:default2] p.default3 = params[:default3] p.status = 'Active' p.save product_ids.each do |pid| p = Product.find(pid) p.variants.each do |v| end end end # GET /admin/products/sort def admin_sort @products = Product.active @vendors = Vendor.active @categories = Category.all render :layout => 'caboose/admin' end # PUT /admin/products/update-sort-order def admin_update_sort_order params[:product_ids].each_with_index do |product_id, index| Product.find(product_id.to_i).update_attribute(:sort_order, index) end render :json => { :success => true } end #============================================================================= # API actions #============================================================================= # GET /api/products def api_index render :json => Product.where(:status => 'Active') end # GET /api/products/:id def api_details p = Product.where(:id => params[:id]).first render :json => p ? p : { :error => 'Invalid product ID' } end # GET /api/products/:id/variants def api_variants p = Product.where(:id => params[:id]).first render :json => p ? p.variants : { :error => 'Invalid product ID' } end end end