Get back on track with user review

[rohitpaulk]

Unreviewed Accounts (N = 416)

We have 416 unreviewed accounts! I was digging into history for gratipay/gratipay.com#3878, and we have users who haven't been reviewed for 6 months 😕

cc: @whit537, @mattbk

[mattbk]

Also, http://inside.gratipay.com/howto/review-accounts is a little out of date.

[rohitpaulk]

SELECT COUNT(DISTINCT(p.username))
  FROM participants p
  JOIN current_payment_instructions cpi ON cpi.participant = p.username -- Only those with tips
 WHERE braintree_customer_id IS NOT NULL
   AND p.is_suspicious IS NULL
   AND NOT is_closed;

=> 68

[chadwhitacre]

As a workaround since this queue is collapsed, I've been only reviewing users during payday where giving > 0.

[rohitpaulk]

I ran Participant.update_giving on the entire DB over at gratipay/gratipay.com#3876, which refreshed a few stale values.

Viewing the review dashboard on my local, I see ~10 users who have a giving > 0 now.

[rohitpaulk]

^ Oh sorry - those values (most of them) are from before payday :)

[chadwhitacre]

Done!

!m @rohitpaulk