Time anomaly between Event Booking and Paypal

More
12 years 9 months ago #10673 by viv
Great module and the forum is excellent for solving problems but I couldn't find an answer to this one.

I've noticed a difference in reporting of transaction times between Paypal (which says it is on Australian Eastern Standard time) and the registrant list in Event Booking.

Eg. a transaction reported as being processed by Paypal at 9 Aug 2011
Event Booking is showing the same transaction registration date as 08-10-2011 (MMDDYYYY) - one day apart.

I checked my sites global configuration and the time is set to Eastern Australia time which is correct.

Also, the "Event Date" in the Registrant management screen is showing correct date of 3 Sept 2011 BUT the downloaded CSV file shows ievent date as 4 Sept 2011. Why did it change?

I'd like to know why the inconsistencies are occurring.

Thanks
Viv

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
12 years 9 months ago #10709 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Time anomaly between Event Booking and Paypal
Hi Viv

Infact, there is some bugs in the code with timezone setting. To solve the issue, please follow the instructions below :

- Open the file administrator/components/com_eventbooking/views/registrants/tmpl/default.php, looks at the code at line 157 :
Code:
<?php echo JHTML::_('date', $row->register_date, '%m-%d-%Y'); ?>

Change it to :
Code:
<?php echo JHTML::_('date', $row->register_date, '%m-%d-%Y', 0); ?>

- Open the file administrator/components/com_eventbooking/controller.php, find the code below (there are two lines in the file) :
Code:
$results_arr[]= JHTML::_('date', $r->register_date, $config->date_format);

Change it to :
Code:
$results_arr[]= JHTML::_('date', $r->register_date, $config->date_format, 0);

After that, all will work fine. I will update this fix to next release !

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
12 years 9 months ago #10712 by viv
I've made those changes.
Many thanks!

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
12 years 9 months ago #10742 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Re: Time anomaly between Event Booking and Paypal
OK, Great !

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc