Class: ViewCallStatistic

Inherits:

ApplicationViewRecord

• Object
• ActiveRecord::Base
• ApplicationRecord
• ApplicationViewRecord
• ViewCallStatistic

Defined in:

app/models/view_call_statistic.rb

Overview

== Schema Information

Table name: view_call_statistics
Database name: primary

id :bigint
call_date :datetime
department :string(30)
ext_conn_talk_time_in_seconds :bigint
inbound_direct_answered :bigint
inbound_direct_from_non_customer :bigint
inbound_direct_talk_time_in_seconds :bigint
inbound_from_queue_missed :bigint
inbound_from_queue_presented :bigint
inbound_from_queue_talk_time_in_seconds :bigint
inbounds :bigint
inbounds_from_queue_answered :bigint
member_name :string(255)
outbound_talk_time_in_seconds :bigint
outbounds_to_customers :bigint
outbounds_to_customers_conn :bigint
outbounds_to_customers_non_conn :bigint
outbounds_to_extension_conn :bigint
outbounds_to_extension_non_conn :bigint
outbounds_to_non_customers :bigint
outbounds_to_non_customers_conn :bigint
outbounds_to_non_customers_non_conn :bigint
ttl_outbounds :bigint
employee_id :integer

Indexes

index_view_call_statistics_on_call_date (call_date)
index_view_call_statistics_on_department (department)
index_view_call_statistics_on_employee_id (employee_id)
index_view_call_statistics_on_id (id) UNIQUE

Class Method Summary

• .refresh ⇒ Object

Methods inherited from ApplicationViewRecord

create, create!, #readonly?

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::EventPublishable

#publish_event

Class Method Details

.refresh ⇒ Object

# File 'app/models/view_call_statistic.rb', line 39

def self.refresh
  Scenic.database.refresh_materialized_view(table_name, concurrently: true, cascade: false)
end