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 :integer 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 = 
['Direct Relief',
 'Health & Disease',
 'Hunger',
 'Homelessness',
 'Environmental',
 'Victims of Abuse',
 'Animals',
 'Community',
 'Government Related',
 'Youth',
 'Global Aid'
].sort
MATCH_FACTOR = 
2
WITH_DONATION_TO_DATE_SQL = 
<<-SQL
  select sum(ra.amount)*#{MATCH_FACTOR}
  from reward_allocations ra
  where ra.charity_id = charities.id
SQL
WITH_DONATION_PROCESS_REWARD_SQL = 
<<-SQL
  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

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 Models::EventPublishable

#publish_event

Instance Attribute Details

#category ⇒ Object (readonly) 



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

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

#fund ⇒ Object (readonly) 



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

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

#name ⇒ Object (readonly) 



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

validates :name, presence: true

#phone ⇒ Object (readonly) 



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

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

#website ⇒ Object (readonly) 



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

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

Class Method Details

.categories_for_select ⇒ Object 



101
102
103
 
# File 'app/models/charity.rb', line 101

def self.categories_for_select
  CATEGORIES
end

.ransackable_scopes(auth_object = nil) ⇒ Object 



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

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:



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

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:



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

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

.top_charities(limit: 3) ⇒ Object 



93
94
95
96
97
98
99
 
# File 'app/models/charity.rb', line 93

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:



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

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:



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

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

Instance Method Details

#company ⇒ Company

Returns:

See Also:



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

belongs_to :company, optional: true

#reward_allocations ⇒ ActiveRecord::Relation<RewardAllocation>

Returns:

See Also:



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

has_many :reward_allocations

#to_s ⇒ Object 



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

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

#total_donations_process_reward ⇒ Object 



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

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 



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

def total_donations_to_date
  reward_allocations.map(&:total_donation).sum
end