Skip to content

Instantly share code, notes, and snippets.

@stephenrichards

stephenrichards/authorised_claims_with_uplifts.rb

Created October 13, 2016 16:49
Show Gist options
  • Save stephenrichards/ac953d2c74a68c765f636bb18f142414 to your computer and use it in GitHub Desktop.
Save stephenrichards/ac953d2c74a68c765f636bb18f142414 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
authorised_claims_with_uplifts.rb
fee_type_ids = Fee::BaseFeeType.where('description like ?', '%uplift%').where.not(id: [8,9,26,90]).pluck(:id)
claim_ids = Fee::BaseFee.where(fee_type_id: fee_type_ids).where.not(amount: 0.0).pluck(:claim_id)
submitted_claim_ids = Claim::BaseClaim.where(id: claim_ids).where(state: ['authorised', 'part_authorised']).order(id: :desc)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment