I've updated to version 9.1.2 today, added the templates to my themes, all goes fine, however the block doesn't show any values (at least: they're all zero) exept the goals.
So it shows:
Due Date:
Mar 31
March Goal:
50.00
Gross Amount:
0.00
PayPal Fees:
0.00
Net Balance:
0.00
Below Goal:
50.00
Site Currency:
GBP
However there are values in our balance
Please enter your server specs in your user profile! 😢
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
it says 6 by default, as I haven't used this block before (I modded a block to show balance only) I left it that way, so I need to figure out what value it would be. However there's a fair amount of mony on the balance so "Net Balance" should have to show something??
I did a testconnection and the log shows:
2007-03-21 10:43:31 1970-01-01 00:00:00 Debug mode activated
Opening connection and validating request with PayPal...
OK!
Logging events
Date is showing: 1970-01-01 would that be allright??
Please enter your server specs in your user profile! 😢
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
No, but that explains why you have no transactions being summarized.
I'm not sure of why, but your system is not storing the payment_date field - the 1970 value means it is storing zero. Is that field set with type 'datetime'?
nm, that was stupid of me - of course the test records zero because there can't be a payment_date for the test
So, it must be something else.
Have you changed your email address in Treasury PayPal config such that it is now different to the values in the "business" field of the _treas_trans table?
can't see any differences, only I saw some earlier test-connections in the log the right date is mentioned, like:
007-02-03 09:13:04 2007-02-03 00:00:00 Debug mode activated
Opening connection and validating request with PayPal...
OK!
Logging events
So we changed hosts, our former host was a forwarded domain, the current domain was forwarded to a domain holding our site. This has been changed that way our domain can be used directly and as far as I can see I changed all to the current domain.
I've set debugging on and the block shows this:
LINE 25: SELECT * FROM cms_treas_cfg WHERE subtype = ''
LINE 59: SELECT business, COUNT( settle_amount ) AS count, SUM( settle_amount ) AS gross, SUM( settle_amount - mc_fee ) AS net, DATE_FORMAT( NOW( ) , '%M' ) AS mon, DATE_FORMAT( SUBDATE( DATE_FORMAT( ADDDATE( NOW( ) , INTERVAL 1 MONTH ) , '%Y-%c-1' ) , INTERVAL 1 DAY ) , ' %b %e' ) AS due_by, DATE_FORMAT( NOW( ) , '%b' ) AS mon_short FROM cms_treas_trans WHERE ( payment_date >= DATE_FORMAT( NOW( ) , '%Y-%m-6' ) ) GROUP BY business
LINE 65: SELECT '' AS business, '0' AS count, '0' AS gross, '0' AS net, DATE_FORMAT( NOW( ) , '%M' ) AS mon, DATE_FORMAT( SUBDATE( DATE_FORMAT( ADDDATE( NOW( ) , INTERVAL 1 MONTH ) , '%Y-%c-1' ) , INTERVAL 1 DAY ) , ' %b %e' ) AS due_by, DATE_FORMAT( NOW( ) , '%b' ) AS mon_short
LINE 73: SELECT * FROM cms_treas_cfg WHERE name='goal' AND subtype='Mar'
LINE 78: SELECT code FROM cms_treas_currency WHERE code='GBP'
LINE 122: SELECT user_id, custom AS name, option_selection1 as showname, currency_symbol AS currency, DATE_FORMAT( payment_date, '%D' ) AS date, SUM(round(settle_amount, 2)) AS amt, mc_gross as gross FROM cms_treas_trans WHERE ( payment_date >= DATE_FORMAT( NOW( ) , '%Y-%m-6' ) ) GROUP BY txn_id ORDER BY payment_date DESC
Please enter your server specs in your user profile! 😢
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
See, that's what I meant, I didn't know the exact meaning of that, but indeed no donations after the sixth, last donation is from 4th of march. But does that mean it won't show the actual balance then??
I changed it to 2 and now figures are showing. I think I messed up some definitions as my former block showed the total balance of our account so members could see how much mony we have in the kitty. I assumed this block showed the same at Net Balance, but am wrong. The block is working perfectly, so sorry if I wasted your time by this.
Think I need to change the block to show the real balance.
Please enter your server specs in your user profile! 😢
PhoenixOffline
Joined: Mar 18, 2004
Posts: 1543
Location: Netosphere
Geez, no wonder you don't show anything - that's how it's supposed to work.
Treasury ReadMe wrote
# Treasury is currently only designed to look at the current month. The Swing Date allows you to extend the end of that month to be, for example, the 6th day of the next month. This is so that users who make donations in the last couple of days of the month, are displayed for a few days after the month is over. If you wish the month displayed to change over immediately, then set Swing Date to 1 in your Block Config tab. Setting it to a large number is NOT advised.
