Forums / Developer / agenda

agenda

Author Message

Rinze Cats

Monday 03 May 2004 6:52:12 am

hi, I am trying to implement the agenda V1.0 http://www.ez.no/community/contributions/applications/agenda_v1_0

I am having some trouble getting is to work. it is illustrated by the follwing fetch

{let children=fetch( 'content', 'list_count', hash(
			'parent_node_id', 47,
	 		'attribute_filter', array('agenda/date_from', '<=', $selectedday ) ) )}

I want to fetch all instances of the agenda class that have the date_from attribute smaller than the selected date. This date is build using:

selectedday=cond( and(ne($view_parameters.month, ''), ne($view_parameters.day, ''), ne($view_parameters.year, '')), makedate($view_parameters.month, $view_parameters.day, $view_parameters.year), currentdate() )

the page is called using: content/view/full/47/month/5/year/2004/day/3

when i print the data_int from the date_from attribute field of my agenda items, the timestamp looks identical to selectedday, but the fetch count is always 0.

Can anybody tell me what is going on. The standard code from agenda V1.0 gives me the same problem, the count is always 0 and therefore the calender never show any links!.

thanx for any pointers you can give me!

Rinze Cats

Tuesday 04 May 2004 6:16:48 am

this is driving me crazy! Please help!
what can be the reason that this code isn't working?

{let my_ts=makedate( $month, $number, $year )
		events=fetch( 'content', 'list_count', hash(
			'parent_node_id', 47,
	 		'attribute_filter', array('agendaitem/date_from', '<=', $my_ts 
) ) ) }

agendaitem is then identifier of my class and date_from is a datefield. $events is always zero!

kind regards, rinze

Stefano Guandalini

Sunday 06 June 2004 8:18:57 am

I'm using this piece of code that is actually working:

{let    temp_ts=makedate( $view_parameters.month, $view_parameters.day, $view_parameters.year )
        events=fetch( 'content', 'list', hash( 'parent_node_id', 247,
                                'attribute_filter',
                                array( 'and',
                                        array( 'event/date_from', '<=', $temp_ts ),
                                        array( 'event/date_to', '>=', $temp_ts )
) ) ) }

Maybe try to put $view_parameters. in front oh month, day and year.

Bye.

guandalf

Stefano Guandalini
http://www.nizan.net

eZ debug

Timing: Jan 18 2025 14:57:03
Script start
Timing: Jan 18 2025 14:57:03
Module start 'content'
Timing: Jan 18 2025 14:57:03
Module end 'content'
Timing: Jan 18 2025 14:57:03
Script end

Main resources:

Total runtime0.2009 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.0064 587.5156180.8594
Module start 'content' 0.00640.0058 768.375093.9141
Module end 'content' 0.01220.1886 862.2891523.1875
Script end 0.2008  1,385.4766 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00381.8985200.0002
Check MTime0.00140.7115200.0001
Mysql Total
Database connection0.00060.310210.0006
Mysqli_queries0.153376.30501410.0011
Looping result0.00150.75081390.0000
Template Total0.188293.710.1882
Template load0.00080.409210.0008
Template processing0.187493.287710.1874
Override
Cache load0.00050.266410.0005
Sytem overhead
Fetch class attribute can translate value0.00070.339110.0007
XML
Image XML parsing0.00020.123010.0002
General
dbfile0.00502.5001200.0003
String conversion0.00000.003430.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