Creating an EZdate within an template, for customizing EZ demo blog calendar

Next topic

Author	Message
Tore Skobba	Thursday 11 March 2004 1:35:45 am Hi I want to use the "EZ calendar" (monthview.tpl). As a source I am using the Blog example. However, instead of using it as an archive I would like to use it for forthcoming events. Therefore I have an "calendar folder" having several calendar_event (s) each having an Date field attribute. However, I am not managing to use the actual date in my fetch on attribute date(i.e. fetch all articles for an particular day). I belive this is because I do not know what I should compare the EZdata to? But since it is an EZdate I thought about fetching the current date, making an ezdate of that and then compare with it. More specific below here: I am customizing the "archive_navigatorbar.tpl" file in the blog example. Which has an fetch selecting all "log" grouped on which day they are "published". However I would like to group by my own date field instead of "published". But datafield is an EZ data and I cannot manage to check for dataes in my fetch sentence. Orginal Code: attribute_filter, array( and, array( 'published', '>=',maketime( 0, 0, 0,$today_info.month, 1, $today_info.year ) ), array( 'published', '<=',maketime( 23, 59, 59, $today_info.month \| inc, 0,$today_info.year ) ) ), My wanted change: attribute_filter, array( and, array( 'date', '>=',maketime( 0, 0, 0,$today_info.month, 1, $today_info.year ) ), array( 'date', '<=',maketime( 23, 59, 59, $today_info.month \| inc, 0,$today_info.year ) ) ), But this does not work and gives me an SQL error. UPDATE: I have solved the syntax problem now.. However, my idea of altering the temaplte was not correct. The SQL error was due to using the attribute name instead of the id. Once I changed date to its id it worked. Cheers Tore

Author

Message

Thursday 11 March 2004 1:35:45 am

I want to use the "EZ calendar" (monthview.tpl). As a source I am using the Blog example. However, instead of using it as an archive I would like to use it for forthcoming events. Therefore I have an "calendar folder" having several calendar_event (s) each having an Date field attribute. However, I am not managing to use the actual date in my fetch on attribute date(i.e. fetch all articles for an particular day). I belive this is because I do not know what I should compare the EZdata to? But since it is an EZdate I thought about fetching the current date, making an ezdate of that and then compare with it.

More specific below here:
I am customizing the "archive_navigatorbar.tpl" file in the blog example. Which has an fetch selecting all "log" grouped on which day they are "published". However I would like to group by my own date field instead of "published". But datafield is an EZ data and I cannot manage to check for dataes in my fetch sentence.

Orginal Code:
attribute_filter, array( and, array( 'published', '>=',maketime( 0, 0, 0,$today_info.month, 1, $today_info.year ) ),
array( 'published', '<=',maketime( 23, 59, 59, $today_info.month | inc, 0,$today_info.year ) ) ),

My wanted change:
attribute_filter, array( and, array( 'date', '>=',maketime( 0, 0, 0,$today_info.month, 1, $today_info.year ) ),
array( 'date', '<=',maketime( 23, 59, 59, $today_info.month | inc, 0,$today_info.year ) ) ),

But this does not work and gives me an SQL error.

UPDATE: I have solved the syntax problem now.. However, my idea of altering the temaplte was not correct. The SQL error was due to using the attribute name instead of the id. Once I changed date to its id it worked.
Cheers
Tore

eZ debug

Timing:	Jan 19 2025 07:14:59
Script start
Timing:	Jan 19 2025 07:14:59
Module start 'layout'
Timing:	Jan 19 2025 07:14:59
Module start 'content'
Timing:	Jan 19 2025 07:14:59
Module end 'content'
Timing:	Jan 19 2025 07:14:59
Script end

Main resources:

Total runtime	0.5720 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0053	589.6484	152.6875
Module start 'layout'	0.0053	0.0031	742.3359	39.5234
Module start 'content'	0.0084	0.5621	781.8594	412.1641
Module end 'content'	0.5705	0.0015	1,194.0234	8.0625
Script end	0.5720		1,202.0859

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.5586	16	0.0002
Check MTime	0.0012	0.2183	16	0.0001
Mysql Total
Database connection	0.0009	0.1519	1	0.0009
Mysqli_queries	0.5353	93.5731	46	0.0116
Looping result	0.0004	0.0675	44	0.0000
Template Total	0.5462	95.5	2	0.2731
Template load	0.0019	0.3377	2	0.0010
Template processing	0.5442	95.1367	2	0.2721
Template load and register function	0.0001	0.0238	1	0.0001
states
state_id_array	0.0004	0.0759	1	0.0004
state_identifier_array	0.0007	0.1217	2	0.0003
Override
Cache load	0.0016	0.2717	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.1631	1	0.0009
Fetch class attribute name	0.0005	0.0837	1	0.0005
XML
Image XML parsing	0.0001	0.0262	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0009	1	0.0000
General
dbfile	0.0007	0.1291	10	0.0001
String conversion	0.0000	0.0017	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
1	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
4	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: 12 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs