Forums / Developer / Sorting content by ezimage attribute

Sorting content by ezimage attribute

« 
Previous topic
|
Developer
|
Next topic
 »
Author Message

Felipe Jaramillo

Thursday 28 September 2006 2:47:35 pm

Hello all,

We are building a simple ecommerce site and encountered the following problem:

Only 20% of the products have images right now. We would like to disply the products with images first. This means having a fetch for products sorted by image (yes/no) and then other criteria.

It seems the ezimage attribute does not have the sortKey or sortKeyTipe functions implemented.

Any suggestions on how to achieve this?

Regards,

Felipe

Felipe Jaramillo
eZ Certified Extension Developer
http://www.aplyca.com | Bogotá, Colombia

Xavier Dutoit

Saturday 30 September 2006 2:11:02 am

Hi Felipe,

You are right, no sort so far.

kernel/classes/datatypes/ezimage/ezimagetype.php

You can modify it to add string sort features (taken the filename)
See the two sort methods:
kernel/classes/datatypes/ezstring/ezstringtype.php

Or as a boolean (image present/not present):
kernel/classes/datatypes/ezboolean/ezbooleantype.php

Could you post that as an enhancement so ez could add it to the standard version, as I think it'd be useful for everyone ?

X+

http://www.sydesy.com

eZ debug

Timing: Jan 21 2025 06:08:10
Script start
Timing: Jan 21 2025 06:08:10
Module start 'content'
Timing: Jan 21 2025 06:08:12
Module end 'content'
Timing: Jan 21 2025 06:08:12
Script end

Main resources:

Total runtime2.0353 sec
Peak memory usage4,096.0000 KB
Database Queries191

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0100 587.7344180.8281
Module start 'content' 0.01001.7290 768.5625549.0000
Module end 'content' 1.73900.2962 1,317.5625332.7422
Script end 2.0352  1,650.3047 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00420.2040210.0002
Check MTime0.00160.0780210.0001
Mysql Total
Database connection0.00090.046510.0009
Mysqli_queries1.919794.31881910.0101
Looping result0.00260.12961890.0000
Template Total1.990597.820.9952
Template load0.00180.088320.0009
Template processing1.988797.708720.9943
Template load and register function0.00020.009610.0002
states
state_id_array0.00290.144910.0029
state_identifier_array0.00280.138320.0014
Override
Cache load0.00150.0718220.0001
Sytem overhead
Fetch class attribute can translate value0.00140.066830.0005
Fetch class attribute name0.00190.094130.0006
XML
Image XML parsing0.00100.046730.0003
class_abstraction
Instantiating content class attribute0.00000.000630.0000
General
dbfile0.02711.3308270.0010
String conversion0.00000.000630.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
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
2content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
4content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
2content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 11
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs