6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
# File 'app/controllers/educode_sales/money_plans_controller.rb', line 6
def index
authorize! :read, MoneyPlan
respond_to do |format|
format.html do
end
format.json do
last_follow_up_ids = Business.all.pluck(:last_follow_up_id)
@money_plans = MoneyPlan.where(follow_up_id: last_follow_up_ids).joins(:business).left_joins(:money_plan_claims).group("educode_sales_money_plans.id").select("educode_sales_money_plans.*, SUM(educode_sales_money_plan_claims.amount) AS return_money, COUNT(educode_sales_money_plan_claims.id) AS claim_num")
if @current_admin.is_admin?
else
level = @current_admin.role.role_areas.find_by(clazz: '回款管理').level
case level
when '自己'
@money_plans = @money_plans.where(staff_id: @current_admin.id)
when '区域'
school_ids = School.where(province: @current_admin.areas.pluck(:name)).pluck(:id) + StaffSchool.where(staff_id: @current_admin.id).pluck(:school_id)
if @current_admin.staff_school_tags.present?
school_ids += School.joins(:school_tags).where("school_tags.id in (?)", @current_admin.staff_school_tags.pluck(:school_tag_id)).pluck(:id)
end
b_ids = Business.where(school_id: school_ids.uniq).pluck(:id)
@money_plans = @money_plans.where("educode_sales_businesses.id in (?) OR educode_sales_money_plans.staff_id = ?", b_ids, @current_admin.id)
end
end
if params[:q].present? && params[:q][:staff_manages].present?
@money_plans = @money_plans.joins(:business).joins("
LEFT JOIN educode_sales_follow_ups AS last_follow_up ON educode_sales_businesses.last_follow_up_id = last_follow_up.id AND last_follow_up.deleted_at IS NULL
LEFT JOIN educode_sales_assign_follow_ups ON educode_sales_assign_follow_ups.follow_up_id = last_follow_up.id").
where("(educode_sales_assign_follow_ups.id IS NOT NULL AND educode_sales_assign_follow_ups.staff_id = ?) OR (educode_sales_assign_follow_ups.id IS NULL AND educode_sales_businesses.staff_id = ?)", params[:q][:staff_manages], params[:q][:staff_manages])
end
if params[:q].present? && params[:q][:business].present?
@money_plans = @money_plans.where("educode_sales_businesses.name like ?", "%#{params[:q][:business]}%")
end
if params[:q].present? && params[:q][:school].present?
@money_plans = @money_plans.joins(business: :school).where("schools.name like ?", "%#{params[:q][:school]}%")
end
if params[:q].present? && params[:q][:property].present?
@money_plans = @money_plans.joins(business: [department: [school: :school_tags]]).where("school_tags.id = ?", params[:q][:property])
end
if params[:q] && params[:q][:date_at].present?
date = params[:q][:date_at].split(" - ")
@money_plans = @money_plans.where("date_at >= ? AND date_at <= ?", date[0], date[1])
end
if params[:sort].present? && params[:sort][:field]
@money_plans = @money_plans.order("#{params[:sort][:field]} #{params[:sort][:order]}")
else
@money_plans = @money_plans.order(date_at: :desc)
end
if params[:page].present?
@money_plans = @money_plans.page(params[:page]).per(params[:limit])
end
@money_plans = @money_plans
end
end
end
|