Get last published article since a date

Author Message

Lydie Soler

Monday 24 October 2005 7:48:58 am

Hi,

I would like to know how I can find the last published article since a specified date.

To be more precise, I know I may manage to do it with the fetch function. I just don't know how to specified the begining date.

Thanks a lot

Kristof Coomans

Monday 24 October 2005 9:49:59 am

You can make a timestamp with the template operator maketime: http://ez.no/doc/ez_publish/technical_manual/3_6/reference/template_operators/miscellaneous/maketime
and use that timestamp in the attribute filter.

There are also other threads about this on the forum, like http://ez.no/community/forum/general/show_events_for_the_next_x_days

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Lydie Soler

Tuesday 25 October 2005 7:41:50 am

Thanks!
with your help I have been able to do what I wanted!
I created a new class that has 2 parameters begining and end date

here is the code:


<div class="content-view-full">
    <div class="class-article">

        <h1>{$node.object.data_map.nom.content|wash()}</h1>
        Période de recherche des éléments modifiés sur le site: 

        {section show=$node.data_map.date_debut.content.is_empty|not}
           <br/>
           Date de début:
            <div class="attribute-long">
                {$node.data_map.date_debut.content.timestamp|l10n(date)}
            </div>
        {/section}
        {section show=$node.data_map.date_debut.content.is_empty|not}
            <br/>
            Date de fin: 
            <div class="attribute-long">
                {$node.data_map.date_fin.content.timestamp|l10n(date)}
            </div>
        {/section}
 <br/>

{let 

    start = $node.data_map.date_debut.content.timestamp
     x=1
     end = maketime( 23, 59, 59, $node.data_map.date_fin.content.month, $node.data_map.date_fin.content.day|sum( $x ), $node.data_map.date_fin.content.year )
     events = fetch( 'content', 'tree',
         hash(
               'parent_node_id', 2,
              'sort_by',        array( 'modified', true() ),
               'attribute_filter', array( 'and',  
                                                array( 'modified', '<=', $end ),
                                                array( 'modified', '>=', $start ))
                
              )
            )
}

<ul type="square">
{foreach $events as $event}


<br/>
<li>
{node_view_gui view='line' content_node=$event}
Date de modification: {$event.object.modified|l10n(date)} 
</li>

{/foreach}

</ul>

{/let}
   
<br/>
{section show=$node.object.data_map.author.content.is_empty|not()}
        <div class="attribute-byline">
        <p class="author">
             {attribute_view_gui attribute=$node.object.data_map.author}
        </p>
        <p class="date">
             {$node.object.published|l10n(date)}
        </p>
        </div>
        {/section}

    </div>
</div>


How could I add the google navigation in order to limit the number of element per page?

Thanks

Kristof Coomans

Thursday 27 October 2005 12:57:43 am

Take a look in the standard design, design/standard/templates/node/view/full.tpl. It also uses the google navigator.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 18 2025 20:56:44
Script start
Timing: Jan 18 2025 20:56:44
Module start 'layout'
Timing: Jan 18 2025 20:56:44
Module start 'content'
Timing: Jan 18 2025 20:56:45
Module end 'content'
Timing: Jan 18 2025 20:56:45
Script end

Main resources:

Total runtime1.4398 sec
Peak memory usage4,096.0000 KB
Database Queries60

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0068 588.0078152.6250
Module start 'layout' 0.00680.0035 740.632839.4453
Module start 'content' 0.01031.4281 780.0781551.3984
Module end 'content' 1.43840.0014 1,331.476612.1563
Script end 1.4398  1,343.6328 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00320.2228160.0002
Check MTime0.00130.0930160.0001
Mysql Total
Database connection0.00160.113110.0016
Mysqli_queries1.384096.1268600.0231
Looping result0.00060.0422580.0000
Template Total1.403297.520.7016
Template load0.00220.151120.0011
Template processing1.401097.308420.7005
Template load and register function0.00010.010110.0001
states
state_id_array0.00120.086710.0012
state_identifier_array0.00130.091920.0007
Override
Cache load0.00200.1400230.0001
Sytem overhead
Fetch class attribute can translate value0.00080.058420.0004
Fetch class attribute name0.00140.097550.0003
XML
Image XML parsing0.00060.043320.0003
class_abstraction
Instantiating content class attribute0.00000.001160.0000
General
dbfile0.00180.1272160.0001
String conversion0.00000.000440.0000
Note: percentages do not add up to 100% because some accumulators overlap

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
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
5content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
2content/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
1content/datatype/view/ezxmltags/literal.tpl<No override>extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tplEdit templateOverride template
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs