Search/filter/sort functions, how?

collacocca
Offline
New Member

13 years 7 months ago - 13 years 7 months ago #10276 by collacocca

Replied by collacocca on topic Search/filter/sort functions, how?

OK a q&d solution to give an idea how to adjust the date sort function to other formats.
We use a single field for date+time the european way - 'dd.mm.yy - HH:MM Uhr' - looks like 31.12.10 - 23:59 Uhr

Change the regex pattern in line #119, 120 of sortable.js to -

Code:

if (itm.match(/^(\d{2}?)[\/\.\-]\s?([a-zA-z]{2,9}?)[\/\.\-]\s?(\d{2,4}?).*$/)){sortfn = ts_sort_date;}
if (itm.match(/^(\d{2}?)[\/\.\-](\d{2}?)[\/\.\-](\d{2,4}?).*/)){sortfn = ts_sort_date;}

…just to be a bit more flexible

…append an additional 'else if' block to line #238 -
//we use the date/time separating dash in our format as anchor. Adjust it to whatever you need

Code:

} else if (date.substr(9,1) == '-') { // we use the date/time separating dash in our format as anchor
		if (europeandate == false) {
			// yyyy.mm.dd - HH:MM:SS
			dt = date.substr(6,4)+date.substr(0,2)+date.substr(3,2)+date.substr(13,2)+date.substr(16,2)+date.substr(19,2);
			return dt;
		} else {
			// 31.12.10 - 23:59 Uhr => 1012312359
			dt = date.substr(6,2)+date.substr(3,2)+date.substr(0,2)+date.substr(11,2)+date.substr(14,2);
			return dt;
		}

and now combined date+time fields can be sorted the right way

Somewhere over the drain flows…

Last edit: 13 years 7 months ago by collacocca.

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

Vogglz
Offline
Junior Member

13 years 7 months ago #10355 by Vogglz

Replied by Vogglz on topic Search/filter/sort functions, how?

Beautiful tip for sorting the category tables, thanks!

But, the initial problem this poster has with not being able to search field other than the Title field is still not solved...

There seem to be more user having this issue, and I have posted the problem again here: www.flexicontent.org/forum/index.php?f=20&t=2263&rb_v=viewtopic

Please please please developers, have a look at this. It is a basic feature that should be working, but with some of your users, it simply isn't...

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

collacocca
Offline
New Member

13 years 7 months ago - 13 years 7 months ago #10401 by collacocca

Replied by collacocca on topic Search/filter/sort functions, how?

Ok another q&d solution -

copy the following javascript function into the 'category_items.php' of your flexicontent template (around line #32) -

Code:

function filter_table( phrase, _id ) {
		var words = phrase.value.toLowerCase().split(" ");
		var table = document.getElementById(_id);
		var ele;
		for (var r = 1; r < table.rows.length; r++){
			ele = table.rows[r].innerHTML.replace(/<[^>]+>/g,"");
			var displayStyle = 'none';
			for (var i = 0; i < words.length; i++) {
				if (ele.toLowerCase().indexOf(words[i])>=0) {
			    	displayStyle = '';
				} else {
			   		displayStyle = 'none';
					break;
				}
			}
			table.rows[r].style.display = displayStyle;
		}
	}

change the <div class="fc_fleft"> - block to

Code:

<div class="fc_fleft">
	<input name="filter" id="filtr" onkeyup="filter_table(this, 'flexitable', 1)" type="text">
<!--//		<input type="text" name="filter" id="filter" value="<?php echo $this->lists['filter'];?>" class="text_area" onchange="document.getElementById('adminForm').submit();" />-->
<!--//		<button onclick="document.getElementById('adminForm').submit();"><?php echo JText::_( 'FLEXI_GO' ); ?></button>-->
<!--//	<button onclick="document.getElementById('filter').value='';document.getElementById('adminForm').submit();"><?php echo JText::_( 'FLEXI_RESET' ); ?></button>-->
	<label for="filtr">Search</label>
	</div>

(we keep the original code because you never know)
et voilà - you can even use more than one keyword (AND)

And don't forget to activate the search field in your category params

The javascript is from www.vonloesch.de/node/23
Give him the credits, the honour and your recognition. Me the money 'nd love

And here is an extension leparlement.org/filterTable
Someone out there who brings in the 'string OR string' function?

Somewhere over the drain flows…

Last edit: 13 years 7 months ago by collacocca.

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

Vogglz
Offline
Junior Member

13 years 7 months ago #10469 by Vogglz

Replied by Vogglz on topic Search/filter/sort functions, how?

Wow collacocca,

this is not a q&d solution, it is magnificent in all its simplicity! :mrgreen:

Even better than what I asked for, this should be in Flexicontent core! Thanks a million!

By the way, there is 1 too many brackets ( } ) at the end, wouldn't work at first.

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