0
I attached a spreadsheet of the way payments are received from PayPal. The third row (Dominique Croteau) is the way the payments come from the registration software. Note that the customer number is in column AF. That is what I need to link the payments correctly to the record.
The first two rows (Angela Corriero) show how the payments are received from the invoicing system. I tried putting her customer number (registration id) in the Notes field. That worked for the PayPal direct invoices, but didn’t work here. Note the name differences from the top section to the bottom section. This is the same person, but shows why I MUST have a specific number to tie the records. (Even though the email in this case is the same, that is not always so.)
Secondly, when I put in a payment date or a payment due date, I must enter the next day. For example, if I receive a payment on 4/11, I must say it is received on 4/12 so that it will display as 4/11. Also, the time is recording as East Coast, not Pacific. See the bottom portion of the spreadsheet to compare the same payments as PayPal sent. PayPal is correct.
Can you please help me with these needs?
1) How to pass a number that PalPal will use to return the customer number.
2) How to correct the date display so that it shows the actual date entered rather than the next date.
3) How to change the time zone so that transactions are recorded as Pacific time.
The first two rows (Angela Corriero) show how the payments are received from the invoicing system. I tried putting her customer number (registration id) in the Notes field. That worked for the PayPal direct invoices, but didn’t work here. Note the name differences from the top section to the bottom section. This is the same person, but shows why I MUST have a specific number to tie the records. (Even though the email in this case is the same, that is not always so.)
Secondly, when I put in a payment date or a payment due date, I must enter the next day. For example, if I receive a payment on 4/11, I must say it is received on 4/12 so that it will display as 4/11. Also, the time is recording as East Coast, not Pacific. See the bottom portion of the spreadsheet to compare the same payments as PayPal sent. PayPal is correct.
Can you please help me with these needs?
1) How to pass a number that PalPal will use to return the customer number.
2) How to correct the date display so that it shows the actual date entered rather than the next date.
3) How to change the time zone so that transactions are recorded as Pacific time.
Responses (22)
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0the easiest way to demonstrate it would be to create a new invoice payment and then look at the SQL entry created in the cov_invoices_payments database.
To access the database on the backend, you can use artadminer component.
Go to: MySQL » localhost » churchev_cov17 » cov_invoices_payments
and then click "select data", look under created_datetime. Here in California, I just created a new invoice payment of $30 (id = 157) at 14:11 and it is showing 17:11 on the SQL. We have tried to use both the Los Angeles time and the UTC for the time zone setting but the problem persists in both cases. -
Accepted Answer
-
Accepted Answer
0hello!
sorry. I'm testing this now and yes, there is a 3 hours difference. This is because the server time is not set the same as the joomla timezone (yes, I know you set it to Los Angeles but this is at "joomla" level.. there's some config on the SERVER itself that is set differently.
in this case all I can do is to "force" it to substract 3 hours when it saves a payment.. if you send me FTP access I can do this. -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0Hi,
I see that you have done the patch in /public_html/campcov2016.
I created an entry at 2016-07-20 17:14. In campcov2016, i saw that the created_datetime in cov16_invoices_payment is correct now (id=163, 2016-07-20 17:14:39). It is correctly showing 7-20 in "Detail'. But the invoice date on the dashboard and in the PDF is still wrong (see attached, it showed 2016-07-19) -
Accepted Answer
0Hi,
I see that you have done the patch in /public_html/campcov2016.
I created an entry at 2016-07-20 17:14. In campcov2016, i saw that the created_datetime in cov16_invoices_payment is correct now (id=163, 2016-07-20 17:14:39). It is correctly showing 7-20 in "Detail'. But the invoice date on the dashboard and in the PDF is still wrong (it showed 2016-07-19) -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
0hi
I'm still facing the same issue. I make changes on PHP files but those changes do not appear on the website.
This is NOT joomla cache, I was talking about some server or PHP caching
I mean, this is weird. I made changes (even "die();" sentences) and nothing changes. makes me wonder if I'm uploading to the right directory. this is /campcov2016 we're talking about right? -
Accepted Answer
-
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »