Change the date format when exporting reports

  • Posts: 30
  • Thank you received: 1
9 years 11 months ago #180433

-- HikaShop version -- : HikaShop [1407241754]
-- Joomla version -- : 2.5.27

Hello,

I'm looking to change the format when I export my report. Actualy the output is like this:

calculated_date;total
"2014 316";"0"
"2014 317";"581.51500"
"2014 318";"0"
"2014 319";"0"
"2014 320";"0"
"2014 321";"0"
"2014 322";"498.25250"
"2014 323";"419.22500"

I don't want the number of the day but the day with the month, like this: "18.11.2014"

Is that possible?

Best regards

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

  • Posts: 13201
  • Thank you received: 2322
9 years 11 months ago #180448

Hi,

Please give us a screenshot of your report settings in order to reproduce the issue on our end.

The following user(s) said Thank You: inetis

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

  • Posts: 30
  • Thank you received: 1
9 years 11 months ago #180937
Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
9 years 11 months ago #181456

Hi,

You can edit the file "administrator/components/com_hikashop/classes/widget.php", function "csv()" and add:

if($field == 'calculated_date')	$el->$field=hikashop_getDate($el->timestamp,'d-M-Y');
After:
if($convert_date && in_array($field,array('user_created','order_created','order_modified'))) $el->$field=hikashop_getDate($el->$field,$convert_date);

The following user(s) said Thank You: inetis

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

  • Posts: 30
  • Thank you received: 1
9 years 11 months ago #181458

Hi,

Thank you su much, it works perfectly.

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

Time to create page: 0.056 seconds
Powered by Kunena Forum