# -*- coding: utf-8 -*-
class Mobile::TopController < CommLogistics::Base::Controller::MobileController
  before_filter :check_date_today
  def index    
    find_sale
    @title_date = date_to_title(params[:start_target_date], params[:end_target_date])
    close_date = TransClose.find_close('sales')
    #@close_flag = SalesClose.find_target_date(params[:start_target_date], MCODE_STATUS2_COMP).length > 0
    @close_flag = close_date.close_date && close_date.close_date >= Date.parse(params[:start_target_date])
    @results = @arobj.period({:start => params[:start_target_date], :end => params[:end_target_date]}).
      find(:all,
           :joins => [:sale_details],
           :select => "product_category_id, SUM(sale_details.quantity) as sum_quantity",
           :group  => "product_category_id",
           :conditions => @conditions.join(" AND ")
           )
    @results = hashfy_and_add_disp_names(@results)
    @total_quantity = total_quantity(@results)
    @day_md = Time.now.strftime("%m/%d")
    
    # sales by last 10days
    start_target_date = get_target_date(params[:start_target_date], -20) # 過去20日のうち10日は営業日という想定
    end_target_date   = params[:end_target_date]
    
    @results_10days = @arobj.period({:start => start_target_date, :end => end_target_date}).
      find(:all,
           :joins => :sale_details,
           :select => "DATE_FORMAT(target_date, '%m/%d') as md, DATE_FORMAT(target_date, '%Y-%m-%d') as ymd, SUM(sale_details.quantity) as sum_quantity",
           :group  => "ymd",
           :order  => 'ymd DESC',
           :limit  => 10,
           :conditions => @conditions.join(" AND ")
           )
    @results_10days = hashfy_and_add_disp_names(@results_10days)
    @total_10days = total_quantity(@results_10days)
    
    # sales by month
    start_target_date = get_first_day_of_month(params[:start_target_date], -2)
    end_target_date   = get_last_day_of_month(params[:end_target_date], 0)


    respond_to do |format|
      format.html
    end
    
  end
end