How can I reset the best_sell_list?

Next topic

Author	Message
Christopher Grondahl	Wednesday 04 January 2006 2:30:44 pm I would like to have my best_sell_list just show top sales this month. Any suggestions? thx, Chris Chris ez site: http://www.acem.no Every day is Groundhog Day
Christopher Grondahl	Wednesday 13 September 2006 4:30:54 pm to eZ crew: I would really appreciate some help on this issue - this question has been unanswered for more than halv a year now ... You seem to be somewhat quicker on the bugreport-side. Maybe I should try to introduce this thread there? Chris ez site: http://www.acem.no Every day is Groundhog Day
Kristof Coomans	Thursday 14 September 2006 12:40:19 am Hello Christopher If you immediately want answers from eZ systems, then you should sign up for payed technical support (<i>http://ez.no/services/support</i>). Questions on the forum are mostly answered by community members. The functionality you want is currently missing. You can however write your own template fetch function or add additional parameters for the time interval to the best_sell_list fetch function (in kernel/shop/ezshopfunctioncollection.php: eZShopFunctionCollection::fetchBestSellList). You can also add an enhancement request in the bug tracker for this. Good luck! independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Claudia Kosny	Thursday 14 September 2006 11:54:32 am Hello Christopher As far as I can see this should not be to hard to achieve. Have a look at the function Kristof refered to and you can see that it is generally a pretty simple sql statement. As each row in the table ezorder has an attribute for the created timestamp just add an addition WHERE clause which should limit the counted objects to the timeframe you desire. To create your own template operator that does this have a look at the example for an extension here http://ez.no/products/ez_publish/documentation/development/extensions/template_operator Just use a copy of the original EZ function for your operator and add the timeframe restriction. Greetings from Luxembourg Claudia .

eZ debug

Timing:	Jan 18 2025 11:23:29
Script start
Timing:	Jan 18 2025 11:23:29
Module start 'layout'
Timing:	Jan 18 2025 11:23:29
Module start 'content'
Timing:	Jan 18 2025 11:23:29
Module end 'content'
Timing:	Jan 18 2025 11:23:29
Script end

Main resources:

Total runtime	0.6306 sec
Peak memory usage	4,096.0000 KB
Database Queries	62

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0065	588.0156	152.6250
Module start 'layout'	0.0065	0.0035	740.6406	39.4453
Module start 'content'	0.0099	0.6191	780.0859	586.7813
Module end 'content'	0.6290	0.0015	1,366.8672	12.1563
Script end	0.6305		1,379.0234

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0036	0.5698	16	0.0002
Check MTime	0.0015	0.2447	16	0.0001
Mysql Total
Database connection	0.0011	0.1777	1	0.0011
Mysqli_queries	0.5741	91.0416	62	0.0093
Looping result	0.0008	0.1320	60	0.0000
Template Total	0.5981	94.8	2	0.2990
Template load	0.0023	0.3648	2	0.0012
Template processing	0.5958	94.4800	2	0.2979
Template load and register function	0.0001	0.0173	1	0.0001
states
state_id_array	0.0013	0.1994	1	0.0013
state_identifier_array	0.0011	0.1813	2	0.0006
Override
Cache load	0.0020	0.3103	27	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0818	3	0.0002
Fetch class attribute name	0.0008	0.1267	6	0.0001
XML
Image XML parsing	0.0024	0.3853	3	0.0008
class_abstraction
Instantiating content class attribute	0.0000	0.0018	7	0.0000
General
dbfile	0.0023	0.3641	22	0.0001
String conversion	0.0000	0.0018	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 15 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs