Joomla Templates Club 406,261 posts

[Greg Banig Friend Greg BanigJoin date: September 2014Posts: 41Downloads:0Uploads:5 Thanks: 13 Thanked: 2 times in 1 posts]

#148391

I am using JA News 2 in the JA Teline III template.

How can I control the display order of the categories? I have a Section with three Categories.

1) Category 1 = “Southern”
2) Category 2 = “Central”
3) Category 3 = “Northern”

I would like them to display in JA News 2 in this order.

However, the Categories are displayed Northern, Southern, Central.

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#331500

Hi gregbanig

For the case, i think you should order these categories via ordering field and then open modules/ja_news2/helper.php file, at about line 413, find following code:


$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;
$db->setQuery ( $query, 0, $limit );


and change to:


$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;

$query .= " ORDER BY s.ordering ASC"; //$query .= " ORDER BY s.id ASC";
$db->setQuery ( $query, 0, $limit );


3 users say Thank You to JA Developer for this useful post

1. brightzahabu
2. el patron
3. cinthiapolanco

[etnasci Friend etnasciJoin date: April 2007Posts: 7Downloads:0Uploads:0 Thanks: 2]

#331502

<em>@JA Developer 152249 wrote:</em><blockquote>Hi gregbanig

For the case, i think you should order these categories via ordering field and then open modules/ja_news2/helper.php file, at about line 413, find following code:


$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;
$db->setQuery ( $query, 0, $limit );


and change to:


$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;

$query .= " ORDER BY s.ordering ASC"; //$query .= " ORDER BY s.id ASC";
$db->setQuery ( $query, 0, $limit );

</blockquote>

Ok! This code is ok!

[Greg Banig Friend Greg BanigJoin date: September 2014Posts: 41Downloads:0Uploads:5 Thanks: 13 Thanked: 2 times in 1 posts]

#331503

Thanks. That solved what I was looking for. The code that needed replaced was actually line #553 and…

$query = “SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(“:”, `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=”.(int)$sid.$where;

[purina Friend purinaJoin date: February 2008Posts: 67Downloads:0Uploads:1 Thanks: 2]

#331506

<em>@gregbanig 163437 wrote:</em><blockquote>Thanks. That solved what I was looking for. The code that needed replaced was actually line #553 and…

$query = “SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(“:”, `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=”.(int)$sid.$where;</blockquote>
OK but what about if I want to show some of the categories from more then three

[madeline63 Friend madeline63Join date: January 2010Posts: 92Downloads:0Uploads:30 Thanks: 11 Thanked: 1 times in 1 posts]

#338272

HI,

I am trying to show my section by using ja news2, but not only at frontpage

i am using JA teline III.

thanks

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#338384

Dear madeline63!

Please read this forum

http://www.joomlart.com/forums/showpost.php?p=172160&postcount=11

[madeline63 Friend madeline63Join date: January 2010Posts: 92Downloads:0Uploads:30 Thanks: 11 Thanked: 1 times in 1 posts]

#338424

hi, J.O.O.M staff

thanks for your quick reply,

do your have any suggestion for this? any module can make this?

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#338874

Dear madeline63!

I am sorry for not being of much help in this case. i do not know the module you need in where 🙁

[fmedia Friend fmediaJoin date: December 2009Posts: 99Downloads:0Uploads:3 Thanks: 8]

#340108

hi,

this will help re-order the categories inside sections on janews2. but how do we re-order the sections?

thank you

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#340173

Dear fmedia!

Please access the configuration of the ja news 2 module, you re-order Section IDs in the “Section Ids” Parameter

Example:

Original:

13:red
14:orange
8:deepblue
12:cyan
5:green
9:pink
11:lime
6

change order of sections:

5:green
9:pink
13:red
14:orange
8:deepblue
11:lime
6
12:cyan

Good luck

[guap Friend guapJoin date: March 2008Posts: 408Downloads:16Uploads:109 Thanks: 99 Thanked: 8 times in 2 posts]

#351891

<em>@gregbanig 163433 wrote:</em><blockquote>I am using JA News 2 in the JA Teline III template.

How can I control the display order of the categories? I have a Section with three Categories.

1) Category 1 = “Southern”
2) Category 2 = “Central”
3) Category 3 = “Northern”

I would like them to display in JA News 2 in this order.

However, the Categories are displayed Northern, Southern, Central.</blockquote>

I go the category manager and use the “arrow” to arrange in order. It works for me.

[Author]

Posts