2014-02-12
. fix data (already done on production server):
	DELETE FROM r_txs WHERE xid IN (76,77,78);

	UPDATE r_txs t0 LEFT JOIN r_txs t1 ON t1.xid=t0.serial
	  SET t0.payerTid=t1.payerTid, t0.type=1, t0.serial=t0.xid,
	  t0.payerFor='payment exchange rebate', t0.payeeFor='payment exchange rebate'
	  WHERE t0.type=-1 AND t1.payerFor='payment exchange' AND t1.amount=0;

	UPDATE r_txs t0 LEFT JOIN r_txs t1 ON t1.xid=t0.serial
	  SET t0.payeeTid=t1.payeeTid, t0.type=1, t0.serial=t0.xid,
	  t0.payerFor='payment exchange bonus', t0.payeeFor='payment exchange bonus'
	  WHERE t0.type=-2 AND t1.payeeFor='payment exchange' AND t1.amount=0;

    DELETE FROM r_txs WHERE amount=0
. fixed bug in cacheTotals that did not recognize when an account was BONA
. fixed new bug in transaction logic that treated unconfirmed web/SMS transactions as confirmed (resulting in a duplicate transaction)
. made adjustments in formMembership (see $dw0) to work around Dwolla's broken Reg API
. fixed bug in 1099 reporting that deleted a couple characters in each person's name, when reporting to the IRS
. adjusted 1099 reports to omit non-positive transactions, as required by the IRS
. added "this is a donation, not a deposit" to Contribution page.
. changed default phone format separator to spaces not periods
. fixed bug in cron notices that gave the same date for every item
Merge remote-tracking branch 'origin/master'
2014-02-25
. eliminated preemptive "dupOk" field in signup.
. removed verifyBy from Contact page
. changed automatic state in postal address to abbreviation
. allowed entry of bank account info before there is a Dwolla account
. added Admin tool to send bank account info to Dwolla
. staff is no longer notified when admin sends an invitation
. fixed account approval message (was sending welcome email)
. created Invitee List link on Invite page
. changed "From Bank" to "From Bank to Here" and "To Bank" to "From Here to Bank"
. in notice digests, finishes with current balance, incentive rewards to date, effective return on your rCredits balance APR (averaged over the past month)
. created admin tool to make a new region or community
. limited community admin choices and results on Admin page
. created new region: ^48(103|104|105|107|108|109|113|115|130|158|175|176|190|191|197|198) rCredits Washtenaw County, MI (MIW) on production server
. fixed bug that kept Grants page from working
. fixed bug that made community's summary page crash
. added "recurs" note to recurring transactions
. fixed bug: dollar sign in input caused problems on Bank page
. now logs just i/o, not db ops
. when administering region, Txs page no longer shows bank transfers nor everyone's transactions, distinguishing it from call on community page.
. brought half the SMS tests up to date
. changed region and community numbering to mirror account numbering (region is just -XXX.AAA; each community is within its region: -XXX.AAB, etc.)
. bug fixed that created a relations record with NULL other upon signup
. allow cadmin to print-id
. cadmin should not have access to SeeSecure (or print-id) for out-of-region accounts
. tells cgf how often a contribution happens
. invite email message defaults to last used (store in data)
. changed community field in users table to BIGINT
. queries:
  UPDATE users set postalAddr=REPLACE(postalAddr, ', Massachusetts', ', MA');
  UPDATE users set postalAddr=REPLACE(postalAddr, ', Ma.', ', MA') WHERE name LIKE 'gop%';
  UPDATE users set postalAddr=REPLACE(postalAddr, ', Michigan', ', MI');
  UPDATE users set postalAddr=REPLACE(postalAddr, ', New Hampshire', ', NH');
  UPDATE users set postalAddr=REPLACE(postalAddr, ', Vermont', ', VT');
  DELETE FROM r_relations WHERE other IS NULL;
. code:
  rCredits\changeUid(-8915, -26742000000001, FALSE);
  rCredits\changeUid(-8321, -25026000000001, FALSE);
  for ($i = 1; $i <= 10; $i++) rCredits\changeUid(24960000000000 + $i, 25026000000000 + $i, FALSE);
  \variable_set('r_totals', array());