Ordering of articles

thellie root
Topic Author
Offline
Fresh Boarder

11 years 10 months ago #301 by thellie root

Ordering of articles was created by thellie root

Is it possible to adapt so that the articles are in alphabetical order, or preferably, ordered according to their order set in the back-end?

My articles in the minitab are such that I would like an overview article to always sit at the top of the list on each tab.

thanks

btw Joomla 1.7

The following user(s) said Thank You: makcim makcimov

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

Linh Robert
Offline
Banned

11 years 10 months ago #302 by Linh Robert

Replied by Linh Robert on topic Re: Ordering of articles

thellie wrote: Is it possible to adapt so that the articles are in alphabetical order, or preferably, ordered according to their order set in the back-end?

My articles in the minitab are such that I would like an overview article to always sit at the top of the list on each tab.

thanks

btw Joomla 1.7

Hi thellie,
In the back-end, at this module edit page, there is parameters area at the right side. You'll find the "order by" options.

Thanks for using our products!

If you need to send us FTP access / host access, administrator access or any private information:
services(at)omegatheme(dot)com or drop a ticket Notice: Undefined variable: target in /home/omegatheme/public_html/components/com_kunena/template/aurelia/layouts/bbcode/url/default.php on line 32
> www.omegatheme.com/member/

The following user(s) said Thank You: makcim makcimov

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

thellie root
Topic Author
Offline
Fresh Boarder

11 years 10 months ago #305 by thellie root

Replied by thellie root on topic Re: Ordering of articles

Yes, I have seen them already, but the order options are limited to ones related to 'Recently...' and 'Most hits..'

I would like one based on the parameters I mentioned, but these options are not available.

Which files would I need to hack to add these options myself? I'm fairly comfortable in PHP and MySQL, so am not worried about giving it a go.

The following user(s) said Thank You: makcim makcimov

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

Linh Robert
Offline
Banned

11 years 10 months ago - 11 years 10 months ago #306 by Linh Robert

Replied by Linh Robert on topic Re: Ordering of articles

thellie wrote: Yes, I have seen them already, but the order options are limited to ones related to 'Recently...' and 'Most hits..'

I would like one based on the parameters I mentioned, but these options are not available.

Which files would I need to hack to add these options myself? I'm fairly comfortable in PHP and MySQL, so am not worried about giving it a go.

Hi,
Great to hear that! You can find the file named "helper.php" in "modules/mod_otminitabs/".

Goodluck and thanks for using our products!

Last edit: 11 years 10 months ago by Linh Robert.

The following user(s) said Thank You: makcim makcimov

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

thellie root
Topic Author
Offline
Fresh Boarder

11 years 10 months ago #309 by thellie root

Replied by thellie root on topic Re: Ordering of articles

Ok, thanks.

Below is the amended code, but I had to manually change the ordering parameter in the #_modules table, to the new option (o_asc), as I couldn't work out where the MySQL table is updated. I also added the option to the en-GB files in the language folder, but as the MySQL update doesn't work, this is currently redundant.

Code:

        // Set ordering
        $order_map = array(
            'm_dsc' => 'a.modified DESC, a.created',
            'mc_dsc' => 'CASE WHEN (a.modified = '.$db->quote($db->getNullDate()).') THEN a.created ELSE a.modified END',
            'c_dsc' => 'a.created',
            'p_dsc' => 'a.publish_up',
            'h_dsc' => 'a.hits',
            'o_asc' => 'a.ordering'
        );
        
        $ordering = JArrayHelper::getValue($order_map, $params->get('ordering'), 'a.publish_up');
        IF($order_map='o_asc') {$dir = 'ASC';} ELSE {$dir = 'DESC';}
        $model->setState('list.ordering', $ordering);
        $model->setState('list.direction', $dir);

The following user(s) said Thank You: makcim makcimov

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

Morten Lysgaard
Offline
Fresh Boarder

11 years 8 months ago #857 by Morten Lysgaard

Replied by Morten Lysgaard on topic Re: Ordering of articles

Hi

I have tried to change my code to

// Set ordering
$order_map = array(
'm_dsc' => 'a.modified DESC, a.created',
'mc_dsc' => 'CASE WHEN (a.modified = '.$db->quote($db->getNullDate()).') THEN a.created ELSE a.modified END',
'c_dsc' => 'a.created',
'p_dsc' => 'a.publish_up',
);
$ordering = JArrayHelper::getValue($order_map, $params->get('ordering'), 'a.publish_up');
IF($order_map='p_dsc') {$dir = 'ASC';} ELSE {$dir = 'DESC';}

But the ELSE function doesn't seem to work....

Best regards
Morten

The following user(s) said Thank You: makcim makcimov

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

Time to create page: 0.261 seconds

Ordering of articles

About Growth

Information

Contact Info

Mobile Menu