4
5
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
|
# File 'app/controllers/crm/scheduler/dashboard_controller.rb', line 4
def index
@period = params[:period].presence || 'month'
@date_range = date_range_for(@period)
bookings_scope = @date_range ? SchedulerBooking.where(starts_at: @date_range) : SchedulerBooking.all
@stats = {
total: bookings_scope.count,
confirmed: bookings_scope.confirmed.count,
cancelled: bookings_scope.cancelled.count,
completed: bookings_scope.where(status: 'completed').count
}
@active_profiles = SchedulerProfile.where(scheduler_enabled: true)
.includes(employee: :employee_record)
.order('parties.full_name')
@booking_pages = SchedulerBookingPage.includes(:scheduler_hosts)
.order(:name)
@booking_page_counts = bookings_scope.group(:scheduler_booking_page_id).count
employee_status_counts = bookings_scope
.group(:employee_id, :status)
.count
@per_employee = employee_status_counts
.each_with_object({}) { |((eid, status), count), hash|
hash[eid] ||= { confirmed: 0, cancelled: 0, completed: 0, total: 0 }
hash[eid][status.to_sym] = count
hash[eid][:total] += count
}
.sort_by { |_eid, data| -data[:total] }
employee_ids = @per_employee.map(&:first)
@employees_by_id = Employee.where(id: employee_ids).index_by(&:id)
end
|