Class: SalesCommissionNetBase

Inherits:
ApplicationRecord show all
Includes:
Models::Auditable
Defined in:
app/models/sales_commission_net_base.rb

Overview

== Schema Information

Table name: sales_commission_net_bases
Database name: primary

id :integer not null, primary key
cogs :float
commission_date :date not null
currency :string not null
num_orders :integer not null
profit :float
rate :float
sales :float
sales_code :string not null
sales_type :string not null
sorted :integer not null
total :float
created_at :datetime not null
updated_at :datetime not null
company_id :integer not null
creator_id :integer
emp_comp_id :integer not null
employee_id :integer not null
sales_commission_id :integer not null
updater_id :integer

Indexes

index_sales_commission_net_bases_on_commission_date (commission_date)
index_sales_commission_net_bases_on_company_id (company_id)
index_sales_commission_net_bases_on_emp_comp_id (emp_comp_id)
index_sales_commission_net_bases_on_employee_id (employee_id)
index_sales_commission_net_bases_on_sales_code (sales_code)
index_sales_commission_net_bases_on_sorted (sorted)
sales_commission_id_commission_date (sales_commission_id,commission_date)

Constant Summary

Constants included from Models::Auditable

Models::Auditable::ALWAYS_IGNORED

Class Method Summary collapse

Methods included from Models::Auditable

#all_skipped_columns, #audit_reference_data, #creator, #should_not_save_version, #stamp_record, #updater

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransackable_scopes, ransortable_attributes, #to_relation

Methods included from Models::EventPublishable

#publish_event

Class Method Details

.with_details_num ⇒ ActiveRecord::Relation<SalesCommissionNetBase>

A relation of SalesCommissionNetBases that are with details num. Active Record Scope

Returns:

See Also:



40
41
42
43
44
 
# File 'app/models/sales_commission_net_base.rb', line 40

scope :with_details_num, -> { select("sales_commission_net_bases.*, (select count(*)
from sales_commission_net_base_details
where sales_commission_net_bases.sales_commission_id = sales_commission_net_base_details.sales_commission_id
and sales_commission_net_bases.sales_code = sales_commission_net_base_details.sales_code
and sales_commission_net_bases.company_id = sales_commission_net_base_details.company_id) as details_num") }