Trying to sort my list by date

[tchoidesign]

I’m using easy folder module on a joomla website to display pdf’s as a list.

I would like to sort my list by date but instead of sorting it by year then month then day it sorts it by what the date actually displays (i.e. 16 December 2011 THEN 13 October 2011 THEN 12 October 2011 THEN 12 December 2011)

you can see it at:

http://new.carbontradexchange.com/

It’s in the “CTX Media” box in the middle – why is “12 October 2011” not first?

[Michael Gilkes]

@tchoidesign. Thanks for your post. That’s interesting. Looking at it now, I realize that the reason it does this is because I format the date before I sort it. To fix it, I will have to sort it first, and then format the date. I will set this as a priority for the next release, which should be in a couple of weeks.

If you want to fix it now, and you understand the basics of PHP, then I can tell you what to do to fix it. Let me know.

[tchoidesign]

Thanks Michael for your reply. I’ve got little knowledge in php but i’d like to give it a try anyway, if you could tell me what to do that would be great!

[Michael Gilkes]

@tchoidesign. Ok, I am on the forum late tonight. I haven’t tested this code, but it should work. You will be editing code in the helper.php file.

STEP 1: Go to around line 67, and you will see:

$list[$index]['date'] = modEasyFolderListingHelper::formatDate($params, $filestats['mtime']);

1	$list[$index]['date'] = modEasyFolderListingHelper::formatDate($params, $filestats['mtime']);

Change it to:

$list[$index]['date'] = $filestats['mtime'];

1	$list[$index]['date'] = $filestats['mtime'];

STEP 2: Go to line 220, and you should see:

$html .= $rows[$i]['date'];

1	$html .= $rows[$i]['date'];

Change it to:

$html .= modEasyFolderListingHelper::formatDate($params, $rows[$i]['date']);

1	$html .= modEasyFolderListingHelper::formatDate($params, $rows[$i]['date']);

STEP 3: Go to line 268, and you should see:

$html .= ' ['.$rows[$i]['date'].']';

1	$html .= ' ['.$rows[$i]['date'].']';

Change it to:

$html .= ' ['.modEasyFolderListingHelper::formatDate($params, $rows[$i]['date']).']';

1	$html .= ' ['.modEasyFolderListingHelper::formatDate($params, $rows[$i]['date']).']';

That’s it!

[tchoidesign]

Hey Michael, I’ve followed your steps and even did it twice to make sure but I always end-up with a white screen when refreshing the page…

When is the update coming out?

[Michael Gilkes]

@tchoidesign. i must apologize for the syntax errors in the code in the above post. I corrected them. Please try again. I just tested it. It works now.

[tchoidesign]

Thanks a lot for your help Michael… It works!

[Author]

Posts