[feature] A process for cleaning up unpaid duplicate reservations

[offbyone]

Need to scan periodically for unpaid duplicates. People who have difficulties with payment often have more than one reserved membership, but only one actual paid membership

[offbyone]

This is a candidate query for those unpaid memberships:

ChicagoContact.joins({:claim=>[:user, {:reservation=>:membership}]}).
    eager_load({:claim=>[:user, {:reservation=>:membership}]}).
    merge(Reservation.uncharged).
    merge(Reservation.unpaid).
    where("memberships.name in ('adult', 'ya', 'first', 'child', 'staff', 'teen', 'supporting')")

Assuming we add to the reservation model these two scopes:

  scope :unpaid, -> { where.not(state: PAID) }
  scope :uncharged, -> {left_outer_joins(:charges).where('charges.id is null')}

I think it'll make sense to add a support view that puts these all up front and centre so that a support user can easily go through them.