require_dependency "educode_sales/application_controller"

module EducodeSales
  class BusinessesController < ApplicationController

    def index
      authorize! :read, Business
      respond_to do |format|
        format.html do
          @staffs = Staff.joins(:user).map { |d| [d.user.real_name, d.id]}
        end
        format.json do
          if @current_admin.is_admin?
            @businesses = Business
          else
            level = @current_admin.role.role_areas.find_by(clazz: '商机管理').level
            case level
            when '自己'
              @businesses = Business.where(staff_id: @current_admin.id)
            when '区域'
              school_ids = School.where(province: @current_admin.areas.pluck(:name)).pluck(:id)
              @businesses = Business.joins("JOIN departments ON educode_sales_businesses.department_id = departments.id").where("departments.school_id in (?) OR educode_sales_businesses.staff_id = #{@current_admin.id}", school_ids)
            else
              @businesses = Business
            end
          end
          
          @businesses = @businesses
          if params[:q].present? && params[:q][:name].present?
            @businesses = @businesses.where("educode_sales_businesses.name like ?", "%#{params[:q][:name]}%")
          end
          if params[:q].present? && params[:q][:department].present?
            departments_ids = Department.joins(:school).where("schools.name like ?", "%#{params[:q][:department]}%").pluck(:id)
            @businesses = @businesses.joins(:department).where("departments.id in (?)", departments_ids)
          end
          if params[:q].present? && params[:q][:staff_id].present?
            @businesses = @businesses.where(staff_id: params[:q][:staff_id])
          end
          if params[:q].present? && params[:q][:business_type].present?
            @businesses = @businesses.joins("
              JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id
            ").where("educode_sales_follow_ups.clazz_id = ?", params[:q][:business_type])
          end
          if params[:q].present? && params[:q][:business_step].present?
            @businesses = @businesses.joins(" 
              JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id
            ").where("educode_sales_follow_ups.stage_id = ?", params[:q][:business_step])
          end
          if  params[:q].present? && params[:q][:place_id].present?
            @businesses = @businesses.joins(" 
              JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id
            ").where("educode_sales_follow_ups.place_id = ?", params[:q][:place_id])
          end

          if params[:q].present? && params[:q][:area].present?
            @businesses = @businesses.joins("
              JOIN departments ON educode_sales_businesses.department_id = departments.id
              JOIN schools ON departments.school_id = schools.id
            ").where("province = ?", params[:q][:area])
          end

          if params[:q].present? && params[:q][:date].present?
            date = params[:q][:date].split(" - ")
            @businesses = @businesses.where("created_at > ? AND created_at < ?", date[0], date[1])
          end

          @businesses = @businesses.page(params[:page]).per(params[:per_page])

          if params[:sort].present? && params[:sort][:field]
            @businesses = @businesses.order("#{params[:sort][:field]} #{params[:sort][:order]}")
          else
            @businesses = @businesses.order("created_at desc")
          end

          @business_count = @businesses.count
          
          @businesses = @businesses.select("
            educode_sales_businesses.*,
            last_follow.invitation_at,
            last_follow.reception_at,
            last_follow.total_amount").joins(" 
            LEFT JOIN educode_sales_follow_ups AS last_follow ON educode_sales_businesses.last_follow_up_id = last_follow.id
          ").page(params[:page]).per(params[:per_page])
        end
      end
    end

    def create
      department = Department.find(params[:department_id])
      business = @current_admin.businesses.build(name: params[:name], department_id: department.id)
      if business.save
        render_success
      else
        render_failure business
      end
    end

    def new
      render layout: false
    end

    def edit
      @business = Business.find(params[:id])
      gon.department = {value: @business.department_id, name: "#{@business.department.school.name}-#{@business.department.name}"}
      gon.value = @business.department_id
      render layout: false
    end

    def update
      business = Business.find(params[:id])
      department = Department.find(params[:department_id])
      if business.update(name: params[:name], department_id: department.id)
        render_success
      else
        render_failure business
      end
    end

    def destroy
      business = Business.find(params[:id])
      business.destroy
      render_success
    rescue ActiveRecord::DeleteRestrictionError => e
      render_failure '该商机已其它关联数据产生，暂不能删除'
    end

    def show_keys
      render layout: false
    end

    def add_keys
      render layout: false
    end

    def show_follow
      load_business
      respond_to do |format|
        format.html do
          render layout: false
        end
        format.json do
          @follow_ups = @business.follow_ups
          if params[:field]
            @follow_ups = @follow_ups.order("#{params[:field]} #{params[:order]}")
          else
            @follow_ups = @follow_ups.order("created_at desc")
          end
          @follow_ups = @follow_ups.page(params[:page]).per(params[:per_page])
        end
      end
    end

    def new_follow_record
      load_business
      @clazz = Common.where(clazz: 'business_type').order("position").pluck(:name, :id)
      @stages = Common.where(clazz: 'business_step').order("position").pluck(:name, :id)
      @places = Place.order("created_at desc").pluck(:name, :id)
      @last_follow_up = @business.last_follow_up
      render layout: false
    end


    def unfinish_plans
      load_business
      @plans = @business.sale_plans.where.not(finish_rate: 100).page(params[:page]).per(params[:per_page])
    end

    def show_follow_record
      @follow_up = FollowUp.find(params[:follow_up_id])
      render layout: false
    end

    def edit_follow_record
      @follow_up = FollowUp.find(params[:follow_up_id])
      @clazz = Common.where(clazz: 'business_type').order("position").pluck(:name, :id)
      @stages = Common.where(clazz: 'business_step').order("position").pluck(:name, :id)
      @places = Place.order("created_at desc").pluck(:name, :id)
      render layout: false
    end

    def edit_plan
      render layout: false
    end

    private

    def load_business
      @business = Business.find(params[:id])
    end

    def follow_up_params
      params.permit(:clazz_id, :stage_id, :invitation_at, :reception_at, :total_amount, :actual_amount, :divide_rate, :description, :advise, :place_id)
    end

  end
end