Developing (v7+)

Filtering Page List Block by Attribute

Permalink April 15, 2015 at 4:54 PM

I'm using the following code, and can't seem to get pages to filter out those pages that have a "Calendar End Date/Time" in the past. How do I get the filtering to work on this attribute?

$now = date('Y-m-d H:i:s');
$pl->filterByAttribute('calendar_event_end_date_time', $now, '>=');

MrKDilkington replied on Apr 16, 2015 at 5:51 am Permalink Reply

Hi Deladroid,

You might find these two links useful for 5.7. They deal with page list filtering by custom attribute.
http://www.concrete5.org/community/forums/5-7-discussion/blog-sorti...
http://www.concrete5.org/index.php?cID=689225...

The Event Date Time List block works, but is very simple. I learned a lot more since I made it and plan to improve it.

Deladroid replied on Apr 16, 2015 at 1:43 pm Permalink Reply

Thanks for the reply.

I got it working finally in regards to the end-date, but now I'm trying to also filter by the "event is featured" and it is not working.

Here's the debug output for the block:

(mysqlt): select p1.cID, pt.ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = if(p2.cID is null, p1.cID, p2.cID)) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID) and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on pt.ctID = cv.ctID inner join Collections c on (c.cID = if(p2.cID is null, p1.cID, p2.cID)) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cvIsApproved = '1' and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ak_calendar_event_end_date_time >= '2015-04-16' and ak_calendar_event_is_featured = '1' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0 or p2.cIsSystemPage = 0) limit 0,20

Here is the snippet from the template view for the page list block:

<?php
defined('C5_EXECUTE') or die("Access Denied.");
$rssUrl = $showRss ? $controller->getRssUrl($b) : '';
$th = Loader::helper('text');
$ih = Loader::helper('image'); 
$today = date("Y-m-d");
$pl = new PageList();
$pl->filterByAttribute('calendar_event_end_date_time', $today, '>=');
$pl->filterByAttribute('calendar_event_is_featured', 1);
$pl->debug();
$pages = $pl->getPage();
?>
<div class="slider-tabs event flexslider">
  <ul class="slides">
    <?php

Viewing 15 lines of 58 lines. View entire code block.

 
<?php
defined('C5_EXECUTE') or die("Access Denied.");
$rssUrl = $showRss ? $controller->getRssUrl($b) : '';
$th = Loader::helper('text');
$ih = Loader::helper('image'); 
$today = date("Y-m-d");
 
$pl = new PageList();
$pl->filterByAttribute('calendar_event_end_date_time', $today, '>=');
$pl->filterByAttribute('calendar_event_is_featured', 1);
$pl->debug();
$pages = $pl->getPage();
 
?>
<div class="slider-tabs event flexslider">
  <ul class="slides">
    <?php 
   foreach ($pages as $page):
      // Title
      $title = $th->entities($page->getCollectionName());
 
      // URL
      $url = $nh->getLinkToCollection($page);
 
      // URL Target
      $target = ($page->getCollectionPointerExternalLink() != '' && $page->openCollectionPointerExternalLinkInNewWindow()) ? '_blank' : $page->getAttribute('nav_target');
      $target = empty($target) ? '_self' : $target;
 
      // Description
       $description = $page->getCollectionDescription();
      $description = $controller->truncateSummaries ? $th->wordSafeShortText($description, $controller->truncateChars) : $description;
      $description = $th->entities($description);   
 
      // Image Thumb
      $img = $page->getAttribute('image');
      $thumb = $ih->getThumbnail($img, 190, 230, false);
      $thumbRetina = $ih->getThumbnail($img, 380, 460, false);
 
      // Event Location
      $eventLocation = $page->getAttribute('location');
 
      // Event Start Date
      $eventStartDate = $page->getAttribute('calendar_event_start_date_time');
      //$eventStartDate = date("F j, Y, g:i a",strtotime($eventStartDate));    
      // Event End Date
      $eventEndDate = $page->getAttribute('calendar_event_end_date_time');
      //$eventEndDate = date("F j, Y, g:i a",strtotime($eventEndDate));    
       ?>
 
    <li>
      <div class="slider-tabs-content">
        <div style="height: 230px; float:left;"> <img src="<?php echo $thumb->src ?>" width="<?php echo $thumb->width ?>" height="<?php echo $thumb->height ?>"  data-retina="<?php echo $thumbRetina->src ?>" alt="" /> </div>
        <h2><a href="<?php echo $url ?>" target="<?php echo $target ?>"><?php echo $title ?></a></h2>
        <p><?php echo $description ?></p>
        <ul class="list-event-slider">
       <li style="font-size: 8px;"><?php echo $today ?>
          <li style="font-size: 8px;"><?php echo $eventStartDate ?></li>
          <li style="font-size: 8px;"><?php echo $eventEndDate ?></li> 
         <!-- <li class="time-slider"><?php echo $eventStartDate ?></li>-->
          <li class="location-slider"><em><?php echo $eventLocation ?></em></li>
          <li class="link-more"><a href="/events">more events...</a></li>
        </ul>
      </div>
    </li>
 
    <?php endforeach; ?>
 
  </ul>
</div>

MrKDilkington replied on Apr 18, 2015 at 1:17 pm Permalink Reply

What version of concrete5 are you using?

Deladroid replied on Apr 18, 2015 at 6:56 pm Permalink Reply

5.6.3.3

Deladroid replied on May 6, 2015 at 2:56 am Permalink Reply

Here's my code for the View.php in my custom template. It works without the $eventIsFeatured check in the IF statement, but I can't get it to work when check for both "Event is Featured" (checked; 1) AND "Event End Date" >= "Today".

<?php
defined('C5_EXECUTE') or die("Access Denied.");
$th = Loader::helper('text');
$ih = Loader::helper('image'); 
?>
<div class="slider-tabs event flexslider">
  <ul class="slides">
    <?php 
   foreach ($pages as $page):
      // Title
      $title = '';
      $title = $th->entities($page->getCollectionName());
      // URL
      $url = '';
      $url = $nh->getLinkToCollection($page);

Viewing 15 lines of 70 lines. View entire code block.

 
<?php
defined('C5_EXECUTE') or die("Access Denied.");
 
$th = Loader::helper('text');
$ih = Loader::helper('image'); 
?>
 
<div class="slider-tabs event flexslider">
  <ul class="slides">
    <?php 
   foreach ($pages as $page):
      // Title
      $title = '';
      $title = $th->entities($page->getCollectionName());
 
      // URL
      $url = '';
      $url = $nh->getLinkToCollection($page);
 
      // URL Target
      $target = '';
      $target = ($page->getCollectionPointerExternalLink() != '' && $page->openCollectionPointerExternalLinkInNewWindow()) ? '_blank' : $page->getAttribute('nav_target');
      $target = empty($target) ? '_self' : $target;
 
      // Description
      $description = '';
       $description = $page->getCollectionDescription();
      $description = $controller->truncateSummaries ? $th->wordSafeShortText($description, $controller->truncateChars) : $description;
      $description = $th->entities($description);   
 
      // Image Thumb
      $img = '';
      $img = $page->getAttribute('image');
      $thumb = '';
      $thumb = $ih->getThumbnail($img, 190, 230, false);
      $thumbRetina = '';
      $thumbRetina = $ih->getThumbnail($img, 380, 460, false);
 
      // Event Location
      $eventLocation = '';
      $eventLocation = $page->getAttribute('location');
 
      // Event Start Date
      $eventStartDate = '';
      $eventStartDate = $page->getAttribute('calendar_event_start_date_time');
      $eventStartDate = date("Y-m-d H:i",strtotime($eventStartDate));    
      // Event End Date
      $eventEndDate = '';
      $eventEndDate = $page->getAttribute('calendar_event_end_date_time');
      $eventEndDate = date("Y-m-d H:i",strtotime($eventEndDate));    
 
      // Event Is Featured
      $eventIsFeatured = '';
      $eventIsFeatured = $page->getAttribute('calendar_event_is_featured');
 
      $today = date("Y-m-d H:i");
 
      <!-- TROUBLE HERE-->   
if ($eventIsFeatured !== '0' && $eventEndDate >= $today) { 
 
       ?>
 
    <li>
      <div class="slider-tabs-content">
      <?php if($thumb) { ?>
        <div style="height: 230px; float:left;"> <img src="<?php echo $thumb->src ?>" width="<?php echo $thumb->width ?>" height="<?php echo $thumb->height ?>"  data-retina="<?php echo $thumbRetina->src ?>" alt="" /> </div>
        <?php } ?>
        <h2><a href="<?php echo $url ?>" target="<?php echo $target ?>"><?php echo $title ?></a></h2>
        <p><?php echo $description ?></p>
        <ul class="list-event-slider">
        <li style="font-size: 8px;"><?php echo $eventIsFeatured ?></li>
         <li style="font-size: 8px;"><?php echo date("Y-m-d H:i") ?></li>
          <li style="font-size: 8px;"><?php echo $eventStartDate ?></li>
          <li style="font-size: 8px;"><?php echo $eventEndDate ?></li> 
       <!-- <li class="time-slider"><?php echo $eventStartDate ?></li>-->
          <li class="location-slider"><em><?php echo $eventLocation ?></em></li>
          <li class="link-more"><a href="/events">more events...</a></li>
        </ul>
      </div>
    </li>
    <?php } endforeach; ?>
 
  </ul>
</div>

Forums

Developing (v7+)

Filtering Page List Block by Attribute

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?