line_items.rb

# 6,357 Qualified Candidates
# 116 Qualified candidates with line items - $7,685
# 189 Line items WITHOUT invoice - $14,365
# 1,005 Line items WITH invoice - $23,500
# 1,194 Line items (with invoice, without invoice) - $37,865


qualified_candidate_ids = []
AbilityScreenApplication.includes({assessment: [:user, :candidate]}, :ability_screen).find_each do |asa|
  next unless asa.assessment
  next unless asa.assessment.user.present?
  next unless asa.qualified?
  qualified_candidate_ids << asa.id
end

puts "#{qualified_candidate_ids.size} Qualified Candidates"

line_items = LineItem.where(chargeable_type: "AbilityScreenApplication", chargeable_id: qualified_candidate_ids).without_invoice
total_amount =LineItem.where(chargeable_type: "AbilityScreenApplication", chargeable_id: qualified_candidate_ids).without_invoice.sum(:amount) / 100
puts "#{line_items.size} qualified candidates with line items - $#{total_amount}"

lt_count = LineItem.without_invoice.count
lt_amount = LineItem.without_invoice.sum(:amount) / 100
puts "#{lt_count} Line items WITHOUT invoice - $#{lt_amount}"

lt_count = LineItem.with_invoice.count
lt_amount = LineItem.with_invoice.sum(:amount) / 100
puts "#{lt_count} Line items WITH invoice - $#{lt_amount}"

lt_count = LineItem.count
lt_amount = LineItem.sum(:amount) / 100
puts "#{lt_count} Line items (with invoice, without invoice) - $#{lt_amount}"