Class: ViewSalesNetBaseItem

Inherits:
ApplicationViewRecord show all
Defined in:
app/models/view_sales_net_base_item.rb

Overview

== Schema Information

Table name: view_sales_net_base_items
Database name: primary

id :bigint
cogs_value :decimal(, )
profit :decimal(, )
profit_pctg :decimal(, )
sales_value :decimal(, )
company_id :integer
employee_id :integer
item_id :integer
order_id :integer

Indexes

index_view_sales_net_base_items_on_company_id (company_id)
index_view_sales_net_base_items_on_employee_id (employee_id)
index_view_sales_net_base_items_on_id (id) UNIQUE
index_view_sales_net_base_items_on_item_id (item_id)
index_view_sales_net_base_items_on_order_id (order_id)

Class Method Summary collapse

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 



25
26
27
 
# File 'app/models/view_sales_net_base_item.rb', line 25

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