Add notification for missing credit card about gratipay.com HOT 9 CLOSED

(188 rows)

from gratipay.com.

I mean, I skimmed it for UPDATE DELETE and INSERT. :P

from gratipay.com.

We require a credit card to set up a gift initially, right?

from gratipay.com.

No! There's just a gentle reminder. We should make this a hard rule, because otherwise what's the point?

I'd also go so far (once this is fixed) as to email everyone who is giving but doesn't have a card set up to tell them that they aren't actually giving and need to set a card up.

from gratipay.com.

@whit537 can you query how many ~users are giving but don't have a credit card set up?

from gratipay.com.

I think it would be something like

    SELECT username
         , balance
         , (SELECT SUM(amount) FROM payment_instructions WHERE participant_id = p.id) AS giving
         , (SELECT COUNT(*) FROM payment_instructions WHERE participant_id = p.id AND amount > 0) AS ngiving_to
      FROM participants p
     WHERE (                                  -- They do not have a credit card set up
             SELECT COUNT(*)
               FROM exchange_routes r
              WHERE r.participant = p.id
              AND r.network = 'balanced-cc'
           ) = 0
       AND giving > 0
       AND NOT is_closed
  ORDER BY claimed_time

Modified from

from gratipay.com.

Was my query right?

from gratipay.com.

I didn't dig that deep, I just ran it. 🐭

from gratipay.com.

Are you feeling okay? Is now the time for me to submit PRs without tests? ;-)

from gratipay.com.