Module: EducodeSales::ApplicationHelper

Defined in:
app/helpers/educode_sales/application_helper.rb

Instance Method Summary collapse

Instance Method Details

#add_businesses_score(staff_id, start_time, end_time) ⇒ Object

新增商机数 得分规则



85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
 
# File 'app/helpers/educode_sales/application_helper.rb', line 85

def add_businesses_score(staff_id,start_time,end_time)
  if @current_admin.is_admin?
    @businesses = Business.all
  else
    level = @current_admin.role.role_areas.find_by(clazz: '商机管理').level
    case level
    when '自己'
      # Business.joins(Business字段: :表的名称)----> Business表(belongs_to) Business字段关联的表(has_many)  Business字段关联的表在关联的表(belongs_to)
      business_ids = Business.joins(last_follow_up: :assign_follow_ups).where("educode_sales_assign_follow_ups.staff_id = ?", @current_admin.id).pluck(:id)
      @businesses = Business.where("educode_sales_businesses.staff_id = ? OR educode_sales_businesses.id in (?)", @current_admin.id, business_ids)
    when '区域'
      school_ids = School.where(province: @current_admin.areas.pluck(:name)).pluck(:id) + StaffSchool.where(staff_id: @current_admin.id).pluck(:school_id)
      business_ids = Business.joins(last_follow_up: :assign_follow_ups).where("educode_sales_assign_follow_ups.staff_id = ?", @current_admin.id).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}  OR educode_sales_businesses.id in (?)", school_ids, business_ids)
    else
      @businesses = Business.all
    end
  end

  ids_a_b = Common.where(extras: %w[a_class b_class ]).pluck(:id)
  ids_c_d = Common.where(extras: %w[c_class d_class]).pluck(:id)
  @businesses_a_b_count = @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 in (?)", ids_a_b)
                                     .where("educode_sales_businesses.staff_id = ?", staff_id)
                                     .where("educode_sales_businesses.created_at >= ? and educode_sales_businesses.created_at <= ?", "#{@assessment_year}-#{start_time} 00:00:00".to_date,
                                            "#{@assessment_year}-#{end_time} 23:59:00".to_date)
  @businesses_c_d_count = @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 in (?)", ids_c_d)
                                     .where("educode_sales_businesses.staff_id = ?", staff_id)
                                     .where("educode_sales_businesses.created_at >= ? and educode_sales_businesses.created_at <= ?", "#{@assessment_year}-#{start_time} 00:00:00".to_date,
                                            "#{@assessment_year}-#{end_time} 23:59:00".to_date)
  @businesses_a_b_count.count.to_i * 10 + @businesses_c_d_count.count.to_i * 5
end

#base_url ⇒ Object 



45
46
47
48
49
50
51
52
53
54
 
# File 'app/helpers/educode_sales/application_helper.rb', line 45

def base_url
  url = Rails.application.config_for(:configuration)['wechat_pay']['callback_url']
  if url.include?("https://data.educoder")
    "https://www.educoder.net"
  elsif url.include?("'https://pre-data.educoder")
    "https://pre.educoder.net"
  else
    "https://test.educoder.net"
  end
end

#collection_amount_score(setting, progress) ⇒ Object

回款金额 得分规则



73
74
75
 
# File 'app/helpers/educode_sales/application_helper.rb', line 73

def collection_amount_score(setting,progress)
  (progress.to_i >= setting.to_i) ||  (setting.to_i == 0) ? 20:(progress.to_f/setting.to_f*20).round(2)
end

#completion_rate(setting, progress) ⇒ Object

完成率completion_rate



58
59
60
61
62
63
64
65
 
# File 'app/helpers/educode_sales/application_helper.rb', line 58

def completion_rate(setting,progress)
  if setting.to_i == 0
    '100%'
  else
    (progress.to_f/setting.to_f*100).round(2).to_s + "%"
  end

end

#current?(css, path) ⇒ Boolean

Returns:

  • (Boolean) 


4
5
6
7
8
9
10
 
# File 'app/helpers/educode_sales/application_helper.rb', line 4

def current?(css, path)
  if path.is_a?(Array) ? (current_page?(path.first) || request.path == path.last) : current_page?(path)
    css
  else
    ' '
  end
end

#disk_filename(source_type, source_id, image_file = nil) ⇒ Object 



33
34
35
 
# File 'app/helpers/educode_sales/application_helper.rb', line 33

def disk_filename(source_type,source_id,image_file=nil)
  File.join(storage_path, "#{source_type}", "#{source_id}")
end

#get_businesses_chart(year, month) ⇒ Object 



117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
 
# File 'app/helpers/educode_sales/application_helper.rb', line 117

def get_businesses_chart(year, month)
  contract_ids = EducodeSales::Common.where(clazz: '商机阶段', name: ['已中标', '已签单', '已验收', '回款中', '服务中', '已结束']).pluck(:id)
  @businesses = EducodeSales::Business.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 in (?)", contract_ids)

  # 逾期id
  late_ids = EducodeSales::Business.joins("JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id JOIN educode_sales_commons on educode_sales_commons.id = educode_sales_follow_ups.stage_id")
                                   .where("educode_sales_follow_ups.bidded_date is not null")
                                   .where("NOW() > DATE_ADD(educode_sales_follow_ups.bidded_date, INTERVAL 1 MONTH)")
                                   .where("educode_sales_businesses.p_stage is null")
                                   .where("educode_sales_commons.name = '已中标'")
                                   .or(EducodeSales::Business.joins("JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id JOIN educode_sales_commons on educode_sales_commons.id = educode_sales_follow_ups.stage_id")
                                                             .where("NOW() > educode_sales_businesses.p_pre_money_time")
                                                             .where("educode_sales_businesses.p_pre_money_time is not null")
                                                             .where("educode_sales_businesses.p_actual_money_time is null")
                                   ).or(EducodeSales::Business.joins("JOIN educode_sales_follow_ups ON educode_sales_businesses.last_follow_up_id = educode_sales_follow_ups.id JOIN educode_sales_commons on educode_sales_commons.id = educode_sales_follow_ups.stage_id")
                                                              .where("NOW() > educode_sales_businesses.p_pre_accept_time")
                                                              .where("educode_sales_businesses.p_pre_accept_time is not null")
                                                              .where("educode_sales_businesses.p_accept_time is null")).ids

  # 待交付项目
  data_4 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 实际交付
  data_5 = @businesses.where("educode_sales_businesses.p_deploy_time > ? AND educode_sales_businesses.p_deploy_time < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 待准备项目
  data_6 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 完成准备
  data_7 = @businesses.where("educode_sales_businesses.p_status = 1")
                      .where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 待验收平台包
  data_8 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 实际验收平台包
  data_9 = @businesses.where("educode_sales_businesses.p_platform_time is not null")
                      .where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                      .count("distinct educode_sales_businesses.id")
  # 待验收课程包
  data_10 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                       .count("distinct educode_sales_businesses.id")
  # 实际验收课程包
  data_11 = @businesses.where("educode_sales_businesses.p_course_time is not null")
                       .where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                       .count("distinct educode_sales_businesses.id")
  data_2 = data_4 + data_6 + data_8 + data_10 # 本月总任务
  data_3 = data_5 + data_7 + data_9 + data_11 # 本月完成任务
  # 本月任务完成度
  data_1 = data_2.zero? ? 0 : (data_3.to_f / data_2.to_f).round(2) * 100

  # 历史遗漏项目
  data_12 = @businesses.where("educode_sales_follow_ups.reception_at < ?", year + "-01-01")
                       .where("educode_sales_businesses.p_course_time IS NULL
                   OR educode_sales_businesses.p_platform_time IS NULL
                   OR educode_sales_businesses.p_deploy_time IS NULL
                   OR educode_sales_businesses.p_actual_money_time IS NULL
                   OR educode_sales_businesses.p_accept_time IS NULL
").count("distinct educode_sales_businesses.id")
  # 年度待交付项目
  data_13 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                       .count("distinct educode_sales_businesses.id")
  # 年度已交付项目
  data_14 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                       .where("educode_sales_businesses.p_course_time IS NOT NULL
                   AND educode_sales_businesses.p_platform_time IS NOT NULL
                   AND educode_sales_businesses.p_deploy_time IS NOT NULL
                   AND educode_sales_businesses.p_actual_money_time IS NOT NULL
                   AND educode_sales_businesses.p_accept_time IS NOT NULL
").count("distinct educode_sales_businesses.id")
  # 年度延期项目
  data_15 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                       .where(id: late_ids)
                       .count("distinct educode_sales_businesses.id")

  year_data_all_1 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                               .group(:p_staff_id).sum("case when educode_sales_businesses.p_course_time is not null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is not null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is not null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is not null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is not null then 1 else 0 end")
  year_data_all_2 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                               .group(:p_sale_staff_id).sum("case when educode_sales_businesses.p_course_time is not null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is not null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is not null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is not null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is not null then 1 else 0 end")
  month_data_all_1 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                                .group(:p_staff_id).sum("case when educode_sales_businesses.p_course_time is not null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is not null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is not null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is not null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is not null then 1 else 0 end")
  month_data_all_2 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                                .group(:p_sale_staff_id).sum("case when educode_sales_businesses.p_course_time is not null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is not null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is not null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is not null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is not null then 1 else 0 end")

  year_merged_hash = month_data_all_1.merge(month_data_all_2) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h
  month_merged_hash = year_data_all_1.merge(year_data_all_2) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h

  not_finish_year_data_all_1 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                                          .group(:p_staff_id).sum("case when educode_sales_businesses.p_course_time is null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is null then 1 else 0 end")
  not_finish_year_data_all_2 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-01-01", year + "-12-31")
                                          .group(:p_sale_staff_id).sum("case when educode_sales_businesses.p_course_time is null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is null then 1 else 0 end")
  not_finish_month_data_all_1 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                                           .group(:p_staff_id).sum("case when educode_sales_businesses.p_course_time is null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is null then 1 else 0 end")
  not_finish_month_data_all_2 = @businesses.where("educode_sales_follow_ups.reception_at > ? AND educode_sales_follow_ups.reception_at < ?", year + "-" + month + "-01", year + "-" + month + "-31")
                                           .group(:p_sale_staff_id).sum("case when educode_sales_businesses.p_course_time is null then 1 else 0 end + case when educode_sales_businesses.p_platform_time is null then 1 else 0 end + case when educode_sales_businesses.p_deploy_time is null then 1 else 0 end + case when educode_sales_businesses.p_actual_money_time is null then 1 else 0 end + case when educode_sales_businesses.p_accept_time is null then 1 else 0 end")
  not_finish_year_merged_hash = not_finish_year_data_all_1.merge(not_finish_year_data_all_2) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h
  not_finish_month_merged_hash = not_finish_month_data_all_1.merge(not_finish_month_data_all_2) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h

  all_year_merged_hash = year_merged_hash.merge(not_finish_year_merged_hash) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h
  all_month_merged_hash = month_merged_hash.merge(not_finish_month_merged_hash) { |key, v1, v2| v1 + v2 }.sort_by { |k, v| v }.reverse.to_h
  staffs = EducodeSales::Staff.all.includes(:user)
  colors = SaleTrend::COLORS
  chart1 = {
    labels: staffs.map { |d| d.user.real_name },
    datasets: %w[已完成 未完成].map.with_index do |d, i|
      {
        label: d,
        data: staffs.map { |s|
          case d
          when "已完成"
            month_merged_hash[s.id].to_i
          when "未完成"
            not_finish_month_merged_hash[s.id].to_i
          end
        },
        backgroundColor: colors[i],
        borderColor: colors[i],
        borderWidth: 1
      }
    end
  }
  chart2 = {
    labels: staffs.map { |d| d.user.real_name },
    datasets: %w[已完成 未完成].map.with_index do |d, i|
      {
        label: d,
        data: staffs.map { |s|
          case d
          when "已完成"
            year_merged_hash[s.id].to_i
          when "未完成"
            not_finish_year_merged_hash[s.id].to_i
          end
        },
        backgroundColor: colors[i],
        borderColor: colors[i],
        borderWidth: 1
      }
    end
  }
  staff_data = EducodeSales::Staff.where(id: year_merged_hash.keys).limit(3).map { |d| [d.user.real_name, all_year_merged_hash[d.id], year_merged_hash[d.id]] }

  [data_1, data_2, data_3, data_4, data_5, data_6, data_7, data_8, data_9, data_10, data_11, data_12, data_13, data_14, data_15, staff_data, chart1, chart2]
end

#relative_path ⇒ Object 



41
42
43
 
# File 'app/helpers/educode_sales/application_helper.rb', line 41

def relative_path
  "avatars"
end

#signed_amount_score(setting, progress) ⇒ Object

签单金额 得分规则



68
69
70
 
# File 'app/helpers/educode_sales/application_helper.rb', line 68

def signed_amount_score(setting,progress)
  progress.to_f >= setting.to_f || setting.to_i == 0 ? 40:(progress.to_f/setting.to_f*40).round(2)
end

#storage_path ⇒ Object 



37
38
39
 
# File 'app/helpers/educode_sales/application_helper.rb', line 37

def storage_path
  File.join(Rails.root, "public", "images", relative_path)
end

#url_to_avatar(source) ⇒ Object 



12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
# File 'app/helpers/educode_sales/application_helper.rb', line 12

def url_to_avatar(source)
  return "" if source.blank?
  if File.exist?(disk_filename(source&.class, source&.id)) && File.file?(disk_filename(source&.class, source&.id))
    ctime = File.ctime(disk_filename(source&.class, source&.id)).to_i
    if source.class.to_s == 'User'
      File.join(relative_path, ["#{source&.class}", "#{source&.id}"]) + "?t=#{ctime}"
    else
      File.join("images/avatars", ["#{source&.class}", "#{source&.id}"]) + "?t=#{ctime}"
    end
  elsif source.class.to_s == 'User'

    str = source.user_extension.try(:gender).to_i == 0 ? "b" : "g"
    File.join(relative_path, "#{source.class}", str)
  elsif source.class.to_s == 'Subject'
    File.join("images","educoder", "index", "subject", "subject#{rand(19)}.jpg")
  elsif source.class.to_s == 'Shixun'
    File.join("images","educoder", "index", "shixun", "shixun#{rand(23)}.jpg")
  end
end

#visits_score(d) ⇒ Object

拜访量 得分规则



79
80
81
 
# File 'app/helpers/educode_sales/application_helper.rb', line 79

def visits_score(d)
  d.to_i > 30 ? 20:0
end