Forums / General / Get last published article since a date

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

eZ debug

Timing: Jan 18 2025 18:42:44
Script start
Timing: Jan 18 2025 18:42:44
Module start 'content'
Timing: Jan 18 2025 18:42:45
Module end 'content'
Timing: Jan 18 2025 18:42:45
Script end

Main resources:

Total runtime0.6423 sec
Peak memory usage4,096.0000 KB
Database Queries197

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0058 587.7266180.8359
Module start 'content' 0.00580.4967 768.5625556.4766
Module end 'content' 0.50250.1397 1,325.0391336.7500
Script end 0.6423  1,661.7891 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.6123210.0002
Check MTime0.00140.2216210.0001
Mysql Total
Database connection0.00090.145910.0009
Mysqli_queries0.568288.46101970.0029
Looping result0.00200.31641950.0000
Template Total0.617696.220.3088
Template load0.00200.306720.0010
Template processing0.615695.842120.3078
Template load and register function0.00020.026010.0002
states
state_id_array0.00070.102210.0007
state_identifier_array0.00060.099020.0003
Override
Cache load0.00160.2504230.0001
Sytem overhead
Fetch class attribute can translate value0.00160.256730.0005
Fetch class attribute name0.00110.178450.0002
XML
Image XML parsing0.00110.165830.0004
class_abstraction
Instantiating content class attribute0.00000.002260.0000
General
dbfile0.00390.6147270.0001
String conversion0.00000.000830.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
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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 7

Time used to render debug report: 0.0002 secs