Class: Charity

Inherits:
ApplicationRecord show all
Includes:
Models::Auditable, PgSearch::Model
Defined in:
app/models/charity.rb

Overview

== Schema Information

Table name: charities
Database name: primary

id :integer not null, primary key
address :text
category :string
cause :text
efficiency :decimal(, )
fund :string
name :string
phone :string
status :enum default("active")
website :string
created_at :datetime not null
updated_at :datetime not null
company_id :integer
creator_id :integer
supplier_id :integer
updater_id :integer

Indexes

index_charities_on_supplier_id (supplier_id)

Foreign Keys

fk_rails_... (supplier_id => parties.id)

Constant Summary collapse

CATEGORIES =

Categories.

['Direct Relief',
'Health & Disease',
'Hunger',
'Homelessness',
'Environmental',
'Victims of Abuse',
'Animals',
'Community',
'Government Related',
'Youth',
'Global Aid'].sort
MATCH_FACTOR =

Match factor.

2
WITH_DONATION_TO_DATE_SQL =

With donation to date sql.

<<-SQL.squish.freeze
  select sum(ra.amount)*#{MATCH_FACTOR}
  from reward_allocations ra
  where ra.charity_id = charities.id
SQL
WITH_DONATION_PROCESS_REWARD_SQL =

With donation process reward sql.

<<-SQL.squish.freeze
  select sum(ra.amount)*#{MATCH_FACTOR}
  from reward_allocations ra
  inner join employee_reviews er on er.id = ra.employee_review_id
  where ra.charity_id = charities.id
    and er.state = 'process_reward'
SQL

Constants included from Models::Auditable

Models::Auditable::ALWAYS_IGNORED

Constants included from Schedulable

Schedulable::SIMPLE_FORM_OPTIONS

Instance Attribute Summary collapse

Has many collapse

Belongs to collapse

Methods included from Models::Auditable

#creator, #updater

Class Method Summary collapse

Instance Method Summary collapse

Methods included from Models::Auditable

#all_skipped_columns, #audit_reference_data, #should_not_save_version, #stamp_record

Methods inherited from ApplicationRecord

ransackable_associations, ransackable_attributes, ransortable_attributes, #to_relation

Methods included from Schedulable

config

Methods included from Models::AfterCommittable

#after_commit

Methods included from Models::EventPublishable

#publish_event

Instance Attribute Details

#category ⇒ Object (readonly) 



66
 
# File 'app/models/charity.rb', line 66

validates :category, inclusion: { in: CATEGORIES }, if: :category

#fund ⇒ Object (readonly) 



65
 
# File 'app/models/charity.rb', line 65

validates :fund, uniqueness: { scope: :name }, if: :fund

#name ⇒ Object (readonly) 



64
 
# File 'app/models/charity.rb', line 64

validates :name, presence: true

#phone ⇒ Object (readonly) 



67
 
# File 'app/models/charity.rb', line 67

validates :phone, phone_format: true, if: :phone

#website ⇒ Object (readonly) 



68
 
# File 'app/models/charity.rb', line 68

validates :website, format: ContactPoint::WEBSITE_REGEX, if: :website

Class Method Details

.categories_for_select ⇒ Object 



106
107
108
 
# File 'app/models/charity.rb', line 106

def self.categories_for_select
  CATEGORIES
end

.ransackable_scopes(_auth_object = nil) ⇒ Object 



94
95
96
 
# File 'app/models/charity.rb', line 94

def self.ransackable_scopes(_auth_object = nil)
  %i[search with_company_id]
end

.select_donations_to_date ⇒ ActiveRecord::Relation<Charity>

A relation of Charities that are select donations to date. Active Record Scope

Returns:

  • (ActiveRecord::Relation<Charity>)

See Also:



86
 
# File 'app/models/charity.rb', line 86

scope :select_donations_to_date, -> { select("charities.*,(#{WITH_DONATION_TO_DATE_SQL}) as donations_to_date") }

.select_donations_to_process ⇒ ActiveRecord::Relation<Charity>

A relation of Charities that are select donations to process. Active Record Scope

Returns:

  • (ActiveRecord::Relation<Charity>)

See Also:



87
 
# File 'app/models/charity.rb', line 87

scope :select_donations_to_process, -> { select("charities.*, (#{WITH_DONATION_PROCESS_REWARD_SQL}) as donations_to_process") }

.top_charities(limit: 3) ⇒ Object 



98
99
100
101
102
103
104
 
# File 'app/models/charity.rb', line 98

def self.top_charities(limit: 3)
  Charity.joins(:reward_allocations)
         .group(:name, :fund, :id)
         .select('name,fund,charities.id,count(reward_allocations.id),sum(amount)')
         .order('sum(amount) desc, count(reward_allocations.id) desc')
         .limit(limit)
end

.with_company_id ⇒ ActiveRecord::Relation<Charity>

A relation of Charities that are with company id. Active Record Scope

Returns:

  • (ActiveRecord::Relation<Charity>)

See Also:



89
 
# File 'app/models/charity.rb', line 89

scope :with_company_id, ->(cid) { where('charities.company_id = ? or charities.company_id IS NULL', cid) }

.with_donations_to_process ⇒ ActiveRecord::Relation<Charity>

A relation of Charities that are with donations to process. Active Record Scope

Returns:

  • (ActiveRecord::Relation<Charity>)

See Also:



88
 
# File 'app/models/charity.rb', line 88

scope :with_donations_to_process, -> { where("(#{WITH_DONATION_PROCESS_REWARD_SQL}) > 0") }

Instance Method Details

#company ⇒ Company

Returns:

See Also:



62
 
# File 'app/models/charity.rb', line 62

belongs_to :company, optional: true

#reward_allocations ⇒ ActiveRecord::Relation<RewardAllocation>

Returns:

See Also:



58
 
# File 'app/models/charity.rb', line 58

has_many :reward_allocations

#to_s ⇒ Object 



110
111
112
 
# File 'app/models/charity.rb', line 110

def to_s
  [try(:name), try(:fund)].compact.join(' - ')
end

#total_donations_process_reward ⇒ Object 



118
119
120
 
# File 'app/models/charity.rb', line 118

def total_donations_process_reward
  reward_allocations.joins(:employee_review).where(employee_review: { state: 'process_reward' }).map(&:total_donation)
end

#total_donations_to_date ⇒ Object 



114
115
116
 
# File 'app/models/charity.rb', line 114

def total_donations_to_date
  reward_allocations.sum(&:total_donation)
end