Add weekly citations report

[garethrees]

We currently run some code in the console to have a look at the latest citations.

# Added in the last week
Citation.
  where(created_at: (Time.now.beginning_of_week-1.week)..Time.now.beginning_of_week).
  map { |c| "https://www.whatdotheyknow.com/request/" + c.citable.url_title }.
  uniq

It would be good to create a periodic digest email to the admin addresses to see what gets mentioned.

We're currently interested in:

• The URL of the FOI request
• The URL of the citable
• Whether the user was pro at the time of making the request
• Whether the request currently has an embargo

[sallytay]

It would be useful to have this feature to allow us to see what requests have received 'in the news' citations to more easily identify good use of the service

Sally

[gbp]

range = (Time.now.beginning_of_week-1.week)..Time.now.beginning_of_week

def pro_citation?(citation)
  return true if citation.citable.is_a?(InfoRequestBatch)

  pro_account = citation.citable.user.pro_account
  return false unless pro_account

  subscriptions = Stripe::Subscription.list(
    status: 'all', customer: pro_account.stripe_customer_id
  )

  ranges = subscriptions.map do |s|
    started_at = Time.at(s.created)
    ended_at = Time.at(s.ended_at) if s.ended_at
    ended_at ||= Time.now

    started_at..ended_at
  end

  ranges.any? { |r| r.include?(citation.created_at) }
end

Citation.where(created_at: range).uniq.map do |c|
  pro = pro_citation?(c) ? 'PRO: ' : 'NOT-PRO: '
  puts pro + "https://www.whatdotheyknow.com/request/" + c.citable.url_title
end

[RichardTaylor]

We're currently interested in:

It might be worth looking at who is adding the citations - to look to see if requesters are being effectively encouraged to add their own, and to surface some potentially more hidden work done by volunteers.

Related: #6620 Public credit for individuals who added "in the news" links

[garethrees]

Noting an updated version of the export script at https://github.com/mysociety/alaveteli/wiki/Export-citations.

[HelenWDTK]

This issue has been automatically closed due to a lack of discussion or resolution for over 12 months.
Should we decide to revisit this issue in the future, it can be reopened.