Class: ViewSmartServicesSale

Inherits:

ApplicationViewRecord

• Object
• ActiveRecord::Base
• ApplicationRecord
• ApplicationViewRecord
• ViewSmartServicesSale

Defined in:

app/models/view_smart_services_sale.rb

Overview

== Schema Information

Table name: view_smart_services_sales
Database name: primary

id :bigint
consolidated_exchange_rate :float
discounted_price :decimal(10, 2)
gl_date :date
month :integer
product_line_name :string(255)
quantity :integer
report_grouping :string(255)
year :integer
customer_id :integer
line_item_id :integer
order_id :integer
primary_sales_rep_id :integer
product_line_id :integer

Indexes

index_view_smart_services_sales_on_customer_id (customer_id)
index_view_smart_services_sales_on_gl_date (gl_date)
index_view_smart_services_sales_on_id (id) UNIQUE
index_view_smart_services_sales_on_line_item_id (line_item_id)
index_view_smart_services_sales_on_month (month)
index_view_smart_services_sales_on_order_id (order_id)
index_view_smart_services_sales_on_primary_sales_rep_id (primary_sales_rep_id)
index_view_smart_services_sales_on_product_line_id (product_line_id)
index_view_smart_services_sales_on_report_grouping (report_grouping)
index_view_smart_services_sales_on_year (year)

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_smart_services_sale.rb', line 35

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