On Sun, Jun 21, 2009 at 11:03:44AM +0100, Jonathan McDowell wrote: > On Sat, Jun 20, 2009 at 08:06:54PM -0400, Richard Darst wrote: > > I was working on sanitizing some data in Penta today. > > > > We have four fields related to attendee payments: > > - has_to_pay > > - amount_to_pay > > - has_paid > > - paid_amount > I have been updating these fields when processing the payment mails from > Click'n'pledge or the FFIS dumps. The values I've used are (from memory) > €300, €600 and $420 - ie professional attendance, professional > attendance including DebCamp and professional attendance in dollars. I > don't think I've used anything different but if you give me any names > your curious about I can check. > > I've also been updating the has_paid field for these people obviously. > > penta/entrance only presents the amount_to_pay field that I can see, > rather than paid_amount, hence not updating that. Here is what we decided Sunday: Since the paid_amount field isn't easily visible, we'll use the amount_to_pay filed. amount_to_pay lists the amount they need to pay, or the amount they actually paid if it is greater (our records e.g. paying for debcamp might not be right, or it might include a donation). has_paid and need_to_pay are what they say. I set Ganneff some SQL UPDATE statements to make amount_to_pay be correct and update has_to_pay. However, if someone already has amount_to_pay, I didn't change that. Also, if has_paid=t and amount_to_pay is blank, I didn't update amount_to_pay since whoever marked has_paid should update that to be sure that it's set to the *actual* amount they paid (which might be different, and I don't want to possibly let the difference fall through the cracks). So, if you have marked has_paid on someone, make sure that amount_to_pay gets updated with the amount they have actually paid. - Richard -- | Richard Darst - rkd@ - lefschetz: up 139 days, 3:01 | http://rkd.zgib.net - pgp 0xBD356740 | "Ye shall know the truth and -- the truth shall make you free"
Attachment:
signature.asc
Description: Digital signature