|
mblatch
|
October 25, 2012 at 3:42 am
Hello,
After updating to 3.1.26 The attendee spreadsheet ‘date paid’ field value changed – previously it included a time, which my client used whilst importing the spreadsheet into a separate booking system to prevent duplicates. Now it’s just a YMD date.
I noticed in gateways/process_payments.php (which is a customisable file?)
there is a function espresso_update_attendee_payment_status_in_db
which I tried to edit:
$payment_data['payment_date'] = date('d/m/Y H:i:s');
//date(get_option('date_format'));
But it doesn’t seem to have fixed the issue – is this where the field gets set? I can’t use get_option('date_format') because the site templates needs to display dates without times.
Thanks
|
|
Dean
|
October 25, 2012 at 7:08 am
Hello,
I had a look at this one, couldn’t see a way of rectifying it. I considering just appending date(get_option('time_format')) but that didnt seem to work either.
I have passed a message to a developer to see if there is a workaround for it.
|
|
Josh
|
October 26, 2012 at 6:32 am
Hi there,
Which version of Event Espresso was the site updated from?
|
|
mblatch
|
October 26, 2012 at 6:35 am
Hi Josh, thanks for getting back, it was 3.0.19.P.41.
|
|
Josh
|
October 26, 2012 at 7:38 am
I will have to do some research as to why this was removed in 3.1.x, and whether it can be customized or added back in to 3.1.x.
The issue with duplicate registrations that happened in earlier versions of Event Espresso has been addressed, so I can’t imagine that they would need to use the time paid to sort out duplicates. If registrations are getting duplicated regularly, I think it would be best to address that issue and fix it. It may even be another plugin that’s causing this.
Are you still getting duplicated registrations in version 3.1.26?
|
|
mblatch
|
October 26, 2012 at 7:59 am
Thanks Josh. The client has an external booking system/intranet which they export the attendees into – this system was built with a specification to accept spreadsheets with certain formatting which is why they require the timestamp.
I don’t think there is an issue with duplicate registrations on the EE side or any other problems, I just need control over the spreadsheet to return it to the previous formatting.
I thought I’d found it in gateways/process_payments.php.
I’m a developer btw so happy for any general pointers or info towards a solution.
|
|
Josh
|
October 30, 2012 at 3:21 pm
Hi there,
I had to dig up an old copy of 3.0.19.41 and install it on a test site to test this. The Date Paid field didn’t include a timestamp. Do you know whether this was added as a customization?
In Event Espresso 3.0.19.P.41, in the database_install.new.php, the payment_date field is set to be VARCHAR, and the only field that I can that had a timestamp was the date field.
So if this was something that was customized before, it could be added back into the current version using a similar method.
|
|
mblatch
|
November 5, 2012 at 5:43 am
Hi Josh, thanks again and sorry for my slow reply I have been away. I checked 3.0.19.41 and in worldpay_ipn.php (called by process_payments.php) line 12 the date field is set with $payment_date = date('d/m/Y H:i:s', strtotime("now")); If that is a customisation I apologise, I am picking this project up from a prior dev (who became uncommunicative).
But starting from a fresh install I saw that in the newer version of EE process_payments.php is now in the customisation bundle that gets copied into uploads, so I thought it should be easy to edit. However as mentioned editing espresso_update_attendee_payment_status_in_db()
has seemed to have had no effect.
Therefore my question is basically “How to control the format of date paid field in new version of EE?” I noticed the db is a varchar field too, so this isn’t a problem of DATE vs DATETIME fields or anything like that.
|
|
mblatch
|
November 5, 2012 at 7:39 am
I just checked the database and the times are being stored, so I deduced it was the export that was omitting them. I believe it is happening in includes/functions/export.php, Line 435 event_date_display($participant->payment_date, 'Y-m-d')
-
This reply was modified 12 years ago by
 mblatch.
-
This reply was modified 12 years ago by mblatch.
|
|
Tony Warwick
|
November 5, 2012 at 8:01 am
Try.
> event_date_display($participant->payment_date,
> get_option(‘time_format’))
|
