Keyword

Item Navigation order alphabetically

  • Filipe Madeira
  • Filipe Madeira's Avatar Topic Author
  • Offline
  • New Member
More
7 years 9 months ago #154734 by Filipe Madeira
Item Navigation order alphabetically was created by Filipe Madeira
Hi there guys,

Does anyone knows how to make Item Navigation in Item View alphabetically?
In my category View, I have my items ordered alphabetically, and it would be nice to have them ordered that way when navigate in items.

Of course, ideally, this Item Navigation should respect always the category ordering:
If in Category A, items are ordered by ID, in Item Navigation should be also by ID.
If in Category B, items are ordered alphabetically, in respective items Item Navigation should be ordered alphabetically.

Does anyone have a clue on this?
i don't mind to loose Update Capability of K2 to achieve this, i guess next big update should be K2 3.0 and maybe this would be a native feature...

Many thanks in advance.

Joomla 3.5.1
K2 2.7.0

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

  • Krikor Boghossian
  • Krikor Boghossian's Avatar
  • Offline
  • Platinum Member
More
7 years 9 months ago #154811 by Krikor Boghossian
Replied by Krikor Boghossian on topic Item Navigation order alphabetically
Hello Filipe,

We are looking into this.
I have not forgotten about you.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Filipe Madeira
  • Filipe Madeira's Avatar Topic Author
  • Offline
  • New Member
More
7 years 9 months ago #154817 by Filipe Madeira
Replied by Filipe Madeira on topic Item Navigation order alphabetically
Thanks Krikor!

I think this should be a great feature for K2.

Looking forward to hear news from you guys!

Thanks a lot!

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

  • JoomlaWorks Support Team
  • JoomlaWorks Support Team's Avatar
  • Offline
  • Elite Member
More
7 years 9 months ago #154819 by JoomlaWorks Support Team
Replied by JoomlaWorks Support Team on topic Item Navigation order alphabetically
Hello Filipe,

The next and previous navigation depends on the ordering value of the K2 item you are currently in. For example if the current K2 item has ordering 3 the previous item will be the one which belong of course to the same category as the current one and has an ordering value of 2. As you understand the next item's ordering value is 4.

Now this functionality relies on two seperate functions at components/com_k2/models/item.php
function getPreviousItem($id, $catid, $ordering)

and
function getNextItem($id, $catid, $ordering)

Inside each of those functions there are a set of queries which controls the navigation. For example the getNextItem function with the query below
$query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering < {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";

is fetching the data of the next item. Try to change the ORDER BY ordering value of the query with the one you want to (e.x ORDER BY created). As you understand you need to change this value to all the queries in those 2 functions I mentioned. Keep in mind also that I have not tested all that and by altering those 2 functions you are hacking the core of the extension.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Filipe Madeira
  • Filipe Madeira's Avatar Topic Author
  • Offline
  • New Member
More
7 years 9 months ago #154822 by Filipe Madeira
Replied by Filipe Madeira on topic Item Navigation order alphabetically
Hi Teo,

Great news from your support!

I've tried it, and all works well with id, created, ordering... But doesn't work with title or alias....
...ORDER BY title DESC";
...ORDER BY title ASC";

None of them works, how can I make it work alphabetically?

Thanks!

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

  • JoomlaWorks Support Team
  • JoomlaWorks Support Team's Avatar
  • Offline
  • Elite Member
More
7 years 9 months ago #154883 by JoomlaWorks Support Team
Replied by JoomlaWorks Support Team on topic Item Navigation order alphabetically
Can you share a link in order to understand what you are getting back from the database query ?

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Filipe Madeira
  • Filipe Madeira's Avatar Topic Author
  • Offline
  • New Member
More
7 years 9 months ago #154903 by Filipe Madeira
Replied by Filipe Madeira on topic Item Navigation order alphabetically
Hi Teo,

Thanks for your reply.

I don't think I can get you a URl of this PHP file, but is the same you mentioned:
Now this functionality relies on two seperate functions at components/com_k2/models/item.php

and the query for next item is:
$query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering < {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";

At the end where:
...ORDER BY ordering DESC

If I change to:
ORDER BY title DESC
or
ORDER BY alias DESC

It wont order alphabeticaly, only works with ordering, id or date. Is it possible to work by the title?

Many thanks!

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


Powered by Kunena Forum