Smarty

[gazoot]

Again, thanks for the followup for the new version. I fixed everything you commented on, except for a logical error in the strpos fix: Since strpos() can return both FALSE and 0, it is a mistake to use loose comparison because it will be treated as false even if found (when it returns 0 for first position in string). So you need the strict comparison, and so the fix will be:

[php:1:23fca1f697]if(strpos($url, '&') !== FALSE)
{
$url = str_replace('&', '& amp;', $url);
}[/php:1:23fca1f697]
I hope SmartyColumnSort is getting good enough for a version 1.0 release! What do you think?

/Gazoot

[TGKnIght]

Ok I see what you are saying... the strpos could return a 0 if the & was the first character of the string, and the If statement in PHP evaluates 0's as false...

After thinking about it though, is it even neccessary in this case to perform a conditional?

[TGKnIght]

Hello everyone, all the way back since page one of this thread, I have been asking for functionality simliar to SmartyPaginate where everything is saved into the session and each ColumnSort can get it's own ID so that you can have multiple columnsorts on one page.

Well guess what I have went ahead and did just that! I have only tested it on PHP 5.1 but I'm pretty sure it will work for PHP 4+

I have also removed some unneccessary methods... I didn't see a reason for some of the getters and setters that were in there, and seeing as how they were undocumented it looks like they were just auto-created... I guess if someone was using them just post here about it.

Oh as an added benefit, the user's sorted columns will be saved in that state until you destroy the session. So if someone likes to see something ascending, well then let it ascend!

To reduce any confusion I have incremented the version number to .0935-dev

Basically to use it, you only need to add an $id onto the end of each of the calls to it... I have also set it up so that it does not require the $id to be set, just in the spirit of backwards compatibility.

For example :

[TGKnIght]

I forgot to mention that if you are using ID's for multiple column sorts in your template you will also need to specify the same ID, so that the plugin will know which set of columns you are talking about.

Unfortunately the attribute "ID" was already taken for the plugin (AFAIK if you use the ID attribute it allows you to override the order the columns are displayed), so it is called "cid" for "column id"

You first columnsort tag should look somethign like this :

[reynier]

I have three questions about Plugins and use:
1) If I use SmartyPaginate then I can use SmartyColumnSort?
2) Why you don't publish a simply tutorial for explain how to works with plugin? I read the entire post and not know yet how works with this.
3) From where I can download it?

Best
_________________
ReynierPM

[TGKnIght]

[bob88]

Hi

I have a problem, and i don't understand the problem...

here my code in .php, something like that :
[php]$myID = "users";
$columns = array('login', 'status', 'email', 'language', 'subcription_date');
$columnsort = new SmartyColumnSort($columns, $myID);
$columnsort->sortOrder(false,$myID);[/php]

and here my .tpl:

[TGKnIght]

[TGKnIght]

Gazoot's version link for those who are interested :

http://hem.passagen.se/gazoot/scs/smartycolumnsort.zip
_________________
Smarty site with one index.php controller file
Working with MySQL and Smarty
SmartyColumnSort
Custom Smarty Javascript Debug Template

[TGKnIght]

[php:1:99a2eb33eb]
include_once("smarty/SmartyColumnSort.class.php");

$myID = "users";
$columns = array('login', 'status', 'email', 'language', 'subcription_date');
$columnsort = new SmartyColumnSort($columns, $myID);
$columnsort->sortOrder(false,$myID);

$smarty->assign('myID', $myID);
[/php:1:99a2eb33eb]

[bob88]

It's working ! Excellent, thanks a lot !

My problem was here, i think :
[php]$smarty->assign('myID', $myID);[/php]

So, now it's ok, for who want, this is my code with TGKnIght code version, and i'm using Pear DB:

list.php
[php]require_once('Smarty.class.php');
require_once('SmartyColumnSort.class.php'); //Tri de colonne


$tpl = new Smarty;

//Sort
$myID = "users";
$columns = array('login', 'status', 'email', 'language');
$columnsort = new SmartyColumnSort($columns, $myID);
$columnsort->setDefault('login', 'asc', $myID);
$order = $columnsort->sortOrder(false,$myID);
$tpl->assign('myID', $myID);

//DB
$db = DB::connect($dsn);
$query = 'SELECT * FROM users ORDER BY '.$order;
$result = $db->getAll($query, array(), DB_FETCHMODE_ASSOC);
$tpl->assign('user_list', $result);

$tpl->display('list.tpl');[/php]

and list.tpl

[TGKnIght]

Glad you got it working

[reynier]

Thanks for every who develop this plugin, really is amazing. I made some changes to function.columnsort.php. If any is interested:
* Add a alt attribute for img element:
* Add two DIV one for align html attribute to left and other for align im to right.
* Make img XHTML valid element
This are the changes:
[php:1:5e1d83e442]
// alt for image
if(isset($params['img_alt'])) {
$img_alt = $params['img_alt'];
}

// If asc/desc image exists, append it.
if($selected && $sort_asc_image !== NULL) {
$image_src = $sort_order == 'asc' ? $sort_desc_image : $sort_asc_image;
$image = " <img src=\"$image_src\" alt=\"$img_alt\" />";
} else {
$image = "";
}

return "<div style=\"float:left;\"><a {$class}href=\"$url\">$html</a></div> <div style=\"float: right;\"><a {$class}href=\"$url\">$image</a></div>";
[/php:1:5e1d83e442]

Best,
_________________
ReynierPM

[TGKnIght]

Hi Reynier, thanks for your contribution to this plugin... I have been incredibly busy at work, but still plan on eventually incorporating all your changes into a new version of the plugin..

Things that need to be done :

Create updated version of plugin with appropriate user submitted changes
Add the plugin to the Smarty Wiki
Create a walkthrough with the new functionality for saving data to $_SESSION
Create a walkthrough for using SmartyColumnSort & SmartyPaginate for the same dataset

_________________
Smarty site with one index.php controller file
Working with MySQL and Smarty
SmartyColumnSort
Custom Smarty Javascript Debug Template

[TGKnIght]

Updated plugin code to reset counter if a new ID is passed in.. this allows for multiple columnsorts to be used on the same page.