require_dependency "lib/comm/controllers/wholesale_prices_controller.rb"

class WholesalePricesController
  class WholesalePriceSearch
    def get_columns_and_tables_with_products(tab, join_lists, params, str_vals)
      str_cols, str_tab, str_vals = get_columns_and_tables_without_products(tab, join_lists, params, str_vals)
      str_tab = str_tab.sub("master_app_production.wholesale_prices AS p", "master_app_production.wholesale_prices AS p LEFT JOIN master_app_production.product_sets AS ps ON p.product_set_id=ps.id")
      str_tab = str_tab.sub("p.*,", "p.*, ps.public_price, TRUNCATE((p.price / ps.public_price)*100,3) AS rate, TRUNCATE((p.old_price / ps.public_price)*100,3) AS old_rate, ")
      return str_cols, str_tab, str_vals
    end
    alias_method_chain :get_columns_and_tables, :products
  end
end