Class: ViewSalesDiscount

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

Overview

== Schema Information

Table name: view_sales_discounts
Database name: primary

id :bigint
auto_apply :boolean
code :string(255)
consolidated_exchange_rate :float
discount_amount :decimal(10, 2)
gl_date :date
is_inactive :boolean
report_grouping :string(255)
tax_class :string(255)
type :string(50)
company_id :integer
coupon_id :integer
customer_id :integer
invoice_id :integer
item_id :integer
line_item_id :integer
order_id :integer

Indexes

index_view_sales_discounts_on_auto_apply (auto_apply)
index_view_sales_discounts_on_company_id (company_id)
index_view_sales_discounts_on_coupon_id (coupon_id)
index_view_sales_discounts_on_customer_id (customer_id)
index_view_sales_discounts_on_gl_date (gl_date)
index_view_sales_discounts_on_id (id) UNIQUE
index_view_sales_discounts_on_invoice_id (invoice_id)
index_view_sales_discounts_on_is_inactive (is_inactive)
index_view_sales_discounts_on_item_id (item_id)
index_view_sales_discounts_on_line_item_id (line_item_id)
index_view_sales_discounts_on_order_id (order_id)
index_view_sales_discounts_on_report_grouping (report_grouping)
index_view_sales_discounts_on_tax_class (tax_class)
index_view_sales_discounts_on_type (type)

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 



42
43
44
 
# File 'app/models/view_sales_discount.rb', line 42

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