# shopのオーダー一覧を取得します
  def self.search_by_shop(shop_id, page = 0, params = {})
    orders = where(shop_id: shop_id)
    orders = orders.where(vendor_id: params[:vendor_id]) if params[:vendor_id].present?
    orders = orders.where('created_at >= ?', Time.zone.parse(params[:from])) if params[:from].present? && Time.zone.parse(params[:from]).present?
    orders = orders.where('created_at <= ?', Time.zone.parse(params[:to]).end_of_day) if params[:to].present? && Time.zone.parse(params[:to]).present?
    orders = orders.where(order_type: params[:order_type]) if params[:order_type].present?
    orders = orders.where(id: keyword_search(shop_id, params[:keyword])) if params[:keyword].present?
    orders = orders.includes(:shop, :vendor, :fax_order, unofficial_order: :unofficial_order_items, official_order: :official_order_items).order(created_at: :desc).page(page.to_i).per(20)

    orders_to_json(orders)
  end