Forums / Setup & design / Best Way to Set Up Complex Sorting?

Best Way to Set Up Complex Sorting?

Author Message

Alex Jones

Thursday 12 February 2004 8:12:09 am

Howdy all, I need some advice, which I hope someone can give. :)

The Challenge:
I need to provide the user (anonymous, not admin) the ability to sort the results of a search and/or fetch with the following possibilities:
<b>View</b> (Category)
- Fixed Blade
- Folding
- Other
<b>Sort By</b>
- Item Number (Low to High) - Text Field
- Item Number (High to Low) - Text Field
- Price (Low to High) - Price
- Price (High to Low) - Price
- Maker Name (Low to High) - Text Field
- Maker Name (High to Low) - Text Field

So, the user may choose to view all Folding Knives, sorted by Price (Low to High) or perhaps view all Fixed Blade Knives starting with the highest Item Number and progressing to the lowest Item Number. I would like to set it up as a couple of drop downs with an "Apply" button, though if I can set up all of the possible combinations as individual links, that would work just as well. Ideally I can provide this capability to the standard pages that use fetch, as well as search results.

So, how should I do this?

Thanks!

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Bruce Morrison

Thursday 12 February 2004 2:41:29 pm

Not an eZ Publish solution but this may be of help
http://www.activeui.net/

Cheers
Bruce

My Blog: http://www.stuffandcontent.com/
Follow me on twitter: http://twitter.com/brucemorrison
Consolidated eZ Publish Feed : http://friendfeed.com/rooms/ez-publish

Alex Jones

Friday 13 February 2004 7:26:54 am

Thanks Bruce. That looks like a neat tool, but it doesn't quite fit my needs. As there could be hundreds of items to display I don't want to incur the load of pulling them all into a single page for display. Rather I would like to have eZ publish fetch the items and use its sorting capabilities to display them in the user-defined order and, should there be more than X amount of items include the google navigator template.

I appreciate the pointer though, that may very well come in handy for a different site that I need to revise!

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

eZ debug

Timing: Jan 31 2025 08:04:33
Script start
Timing: Jan 31 2025 08:04:33
Module start 'content'
Timing: Jan 31 2025 08:04:33
Module end 'content'
Timing: Jan 31 2025 08:04:33
Script end

Main resources:

Total runtime0.1754 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0110 587.9531180.8281
Module start 'content' 0.01100.0089 768.781397.8828
Module end 'content' 0.01990.1554 866.6641527.8281
Script end 0.1753  1,394.4922 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00352.0162200.0002
Check MTime0.00140.8087200.0001
Mysql Total
Database connection0.00120.684710.0012
Mysqli_queries0.120468.61931410.0009
Looping result0.00110.63401390.0000
Template Total0.155088.410.1550
Template load0.00090.506210.0009
Template processing0.154187.862910.1541
Override
Cache load0.00060.353010.0006
Sytem overhead
Fetch class attribute can translate value0.00070.419610.0007
XML
Image XML parsing0.00030.155110.0003
General
dbfile0.01387.8672200.0007
String conversion0.00000.005730.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs