Forums / Cotonti / Extensions / Pages order in tag output

This functionallity is hard coded in Tags plugin. So you can not alter it simply with settings.

But it's a flexible enough to be extended with other plugin for this. 

So you can write simple plugin with 2 hooks:

• on «tags.search.pages.query» hook

	// check is it possible to sort by this field
	if ($db->fieldExists($db_pages,'page_'.$o)) {

		$order = 'ORDER BY `page_'.$o.'`';
	}

• on «tags.first» hook

  // column => title
  $addition_fields = array(
  	'begin' => 'Begin date',
  	'author' => 'Author',
  	// on so on — any page field
  );
  foreach ($addition_fields as $order=>$title)
  {
  	$ord = mb_strtolower($order);
  	$selected = $ord == $o ? 'selected="selected"' : '';
  	$tag_order .= cot_rc('input_option', array('value' => $ord, 'selected' => $selected, 'title' => $title));
  }
  

   

Making plugins is just a piece of cake:

Look at here, check readme, download it and install — this is magic box for plugin creation.

Then let's create our simple plugin — look at this http://screenshot.galaxyhost.org/img/20140428-75f-72kb.jpg :

1. Set (marked with green) plugin name, check setup file, addition files for our Hooks — `tagsort.first` and `tagsort.pages.query`. Marked wih blue is optional. Other are useless for out plug and should be unchecked.
2. Add addition info in «Section 2» (http://screenshot.galaxyhost.org/img/20140428-5mp-48kb.jpg) — title, description, author name.

Press «Create extension files». Magic is done. Now we should work a little:

Locate files in `plugins/extension_template/created/tagsort`, copy it to plugins folder as usual plug. 

Open our generated files (`tagsort.first.php` and `tagsort.pages.query.php`), fix hook names and add corresponding code:
http://screenshot.galaxyhost.org/img/20140428-dob-66kb.jpg 
http://screenshot.galaxyhost.org/img/20140428-gs7-42kb.jpg

It's never been so easy. :)

Some code explanation (see post above):

• For `tags.first` we extend drop down selection control with addition «sorting by» values as:  Begin date, author.
• For `tags.search.pages.query` we alter part of tags search SQL query that sets pages order by our selected «sort by» value.

Thank you for a such a broad descriprion of how your plugin works, but anyway, for some reason, your solution didn't work for me properly. Here's the tagsort plugin http://joxi.ru/nNheUxjKTJByDnIHAZc — that seems, the tags.first hook simply doesn't correspond with the Tags plugin settings. There are 4 options of how to sort the pages, just like it used to be, no "Author", no "Begin date", nothing.

I could of course make some mistake, and your help with it would be very much appreciated.

It's quite strange. 

I had checked you archive and it works fine for me — http://screenshot.galaxyhost.org/img/20140501-5q3-35kb.jpg

What about versions that you use (Cotonti and Tags plugin)?

I use Siena version and

Version=0.9.14
Date=2012-02-19

of `Tags` plugin 

Above that, if you don't mind, I found an issue, which could be rather important for your plugin users, particularly for those like me, lacking the experience of writing plugins for their needs. Right after filling up the second section, "Misc", I found out that clicking "Submit" simply doesn't change anything. No output, no answer, the button just leaves everything how it was. I tried refilling the data 3 or 4 times, before I cought what was wrong. The issue here is that user doesn't know where exactly plugin tries to create a subfolder /created. The right answer is: in /datas, but who knows that? :) Therefore, this could be a good idea to give user a short hint, like, "Make /datas writable, we will do the rest", or something.

Thank you for your opinion.

First of all. it should be displayed Log message (like here: http://screenshot.galaxyhost.org/img/20140501-bpb-62kb.jpg )
As for target dir, you are right — I forgot that by default its location is `datas/created/`. It can be altered via plugin settings.

 Now it's all fine, it works. But I was actually planning to hide the sorting options, just leaving the "By begin date" as a default method of sorting pages. Are there any ways of doing so?

This way it's faster to do it via edit template `tags.tpl` and replace:

<select name="order">
	<option value="">{PHP.L.tags_Orderby}</option>
	<option value="">--</option>
	{TAGS_ORDER}
</select>

with:

<input type="hidden" name="order" value="begin" />

Then you can stop `tags.first` part of plugin, leaving only `tagsort.pages.query`.

Also, if you have any ideas on another Tags issue, welcome! Here's the topic: http://www.cotonti.com/forums?m=posts&q=7730.

I'll check it later.