Events - Startdate/Enddate (Enddate - Filter)

funkybrotha · December 23, 2015, 9:47am

Hi Kirby-Fellaz!

I have created an Events-Overview - Site
Each Event-entry has a Start- and Enddate.

Now I want to hide the Events when the Enddate
has passed. This is my Code:

Blueprint

title: Events Element
pages: false
files: true
  fields:
    caption:
      label: Caption
      type: textarea
fields:
  Main Content Meta:
    label: Main Content
    type: headline
  title:
    label: Title
    type:  text
  main_title:
    label: Main Title
    type:  text
  category:
    label: Category
    type: tags
  type:
    label: Type
    type: text
  startdate:
    label: Start Date
    type:  date
    format: MM/DD/YYYY
    width: 1/2
  enddate:
    label: End Date
    type:  date
    format: MM/DD/YYYY
    width: 1/2

Template

	<div class="container">
		<div class="row">

			<?php foreach ($site->find('termine')->children()->sortBy('startdate', 'asc') as $element) : ?>

			<?php
				$eventStartdate	= $element->date('%e. %b. %Y', 'startdate');
				$eventEnddate	= $element->date('%e. %b. %Y', 'enddate');
			?>

			<div class="col-xs-12 col-sm-6 col-md-4">
				<div class="panel panel-default events">
					<div class="panel-body">
						<div class="tri-category"><?php echo $element->category() ?></div><br />

						<div><?php echo $eventStartdate ?>
						<?php if ($eventStartdate != $eventEnddate): ?>
						<?php echo ' - ' . $eventEnddate; ?>
						<?php endif; ?>
						</div>

						<div class="tri-type">
						<?php echo $element->type() ?>
						</div>

						<h3><?php echo $element->main_title() ?></h3>
						<div><?php echo $element->lead() ?></div>

						<a class="tri-more-button" href="<?php echo $element->url() ?>" title="<?php echo $element->main_title() ?>">mehr</a>
					</div><!-- /.panel-body -->
				</div><!-- /.panel panel-default events -->
			</div><!-- /.col-xs-12 -->
			<?php endforeach; ?>

		</div><!-- /.row -->
	</div><!-- /.container -->

I don’t know how to set the Filter.
Your help is greatly appreciated.

Saludos, Funkybrotha

ps. I tried this: http://getkirby.com/docs/cheatsheet/pages/filterBy
but as I renamed date to startdate + enddate my code should
look a bit different, i think.

texnixe · December 23, 2015, 10:22am

You should be able to use filterBy() on your collection like this:

$site->find('termine')->children()->filterBy('enddate', '>', time())->sortBy('startdate', 'asc') as $element) : ?>

Doesn’t it work?

funkybrotha · December 23, 2015, 5:01pm

Hi @texnixe!

Thank you!
No… like this i get several errors.

I have to declare my startdate/enddate like this:
<?php $eventStartdate = $element->date('%e. %b. %Y', 'startdate'); $eventEnddate = $element->date('%e. %b. %Y', 'enddate'); ?>
I don’t know how to declare them before the foreeach loop.

Saludos, Funkybrotha

anon77445132 · December 23, 2015, 5:05pm

My guess:
in the filter use e.g.

$element->startdate()

to fetch the date of the field “startdate” and to calculate with or to compare it.

If you want to echo the date in a readable format use

$eventStartdate

Good luck!

funkybrotha · December 23, 2015, 5:20pm

Hi @anon77445132!

Thanx for your help.

With this code i can output the dates in a nice
readable format:
<?php $eventStartdate = $element->date('%e. %b. %Y', 'startdate'); $eventEnddate = $element->date('%e. %b. %Y', 'enddate'); ?>

For example outputs: 1. Feb. 2016 - 14. Mär. 2016

But this declaration happens after i define $element.
I need to make this before the foreach - loop.

Saludos, Funkybrotha

ps. The code works like posted in my first post.
I’m just missing the ->filterby… enddate - part.

texnixe · December 23, 2015, 6:39pm

Oh, I see, then you have to use a custom filter:

$site->find('termine')->children()->filter(function($child) {
      return strtotime($child->enddate()) > time();
});

funkybrotha · December 23, 2015, 8:36pm

Hi @texnixe!

Thank you for your efforts!
With your Code - Snippet I don’t get any value back. ;-(

Maybe this is just to complicated for me.

I don’t know where to put that in my Code:

<?php foreach ($site->find('termine')->children()->sortBy('startdate', 'asc') as $element) : ?>

			<?php
				$eventStartdate	= $element->date('%e. %b. %Y', 'startdate');
				$eventEnddate	= $element->date('%e. %b. %Y', 'enddate');
			?>

			<div class="col-xs-12 col-sm-6 col-md-4">
				<div class="panel panel-default events">
					<div class="panel-body">

						<div class="tri-category"><?php echo $element->category() ?></div><br />

						<div><?php echo $eventStartdate ?>
						<?php if ($eventStartdate != $eventEnddate): ?>
						<?php echo ' - ' . $eventEnddate; ?>
						<?php endif; ?>
						</div>

						<div class="tri-type">
						<?php echo $element->type() ?>
						</div>

						<h3><?php echo $element->main_title() ?></h3>
						<div><?php echo $element->lead() ?></div>

						<a class="tri-more-button" href="<?php echo $element->url() ?>" title="<?php echo $element->main_title() ?>">mehr</a>
					</div><!-- /.panel-body -->
				</div><!-- /.panel panel-default events -->
			</div><!-- /.col-xs-12 -->
			<?php endforeach; ?>

Saludos, Funkybrotha

texnixe · December 23, 2015, 8:43pm

<?php
$elements = $site->find('termine')->children()->filter(function($child) {
      return strtotime($child->enddate()) > time();
});
?>
<div class="container">
  <div class="row">
    <?php foreach ($elements->sortBy('startdate', 'asc') as $element) : ?>
      <?php
        $eventStartdate	= $element->date('%e. %b. %Y', 'startdate');
	$eventEnddate	= $element->date('%e. %b. %Y', 'enddate');
      ?>
        <div class="col-xs-12 col-sm-6 col-md-4">
          <div class="panel panel-default events">
            <div class="panel-body">
              <div class="tri-category"><?php echo $element->category() ?></div>
              <div><?php echo $eventStartdate ?>
	      <?php if ($eventStartdate != $eventEnddate): ?>
	        <?php echo ' - ' . $eventEnddate; ?>
	      <?php endif; ?>
	      </div>
              <div class="tri-type">
		<?php echo $element->type() ?>
	     </div>
		<h3><?php echo $element->main_title() ?></h3>
		<div><?php echo $element->lead() ?></div>
                  <a class="tri-more-button" href="<?php echo $element->url() ?>" title="<?php echo $element->main_title() ?>">mehr</a>
	    </div><!-- /.panel-body -->
	</div><!-- /.panel panel-default events -->
     </div><!-- /.col-xs-12 -->
  <?php endforeach; ?>
  </div><!-- /.row -->
</div><!-- /.container -->

funkybrotha · December 23, 2015, 10:01pm

Hey @texnixe!

Thanx a lot! It works!!! Yeah!!!
I must say i’m really impressed with the quality of the support in this forum.

One small add. question:
How can I add one day to the Filter?

If I create an Event from yesterday to today…
It disappears already today. But I want to show the Event till the Enddate has passed.
Is it possible to add like +1 day or 24h?

Saludos, Funkybrotha

ps. Hey @texnixe! I wish you happy holidays!

texnixe · December 23, 2015, 10:13pm

You’re welcome!

$elements = $site->find('termine')->children()->filter(function($child) {
      return strtotime($child->enddate()) >= time();
});

Happy holidays to you, too

funkybrotha · December 24, 2015, 7:18am

Hi @texnixe!

Thanx again for your help!

‘>=’ does not work.
I’ve read something that the returned value
by time() is minutes and not a day - value?
Do I need to convert that to something
different?

Saludos, Funkybrotha

texnixe · December 24, 2015, 8:04am

Then try this:

$projects = page('my-projects')->children()->filter(function($child) {
      return strtotime('+1 day', strtotime($child->enddate())) > time();
});

funkybrotha · December 24, 2015, 9:02am

Hi @texnixe!

YESSS!!! IT WORKS!!!

A BIG THANK YOU!!!

Saludos, Funkybrotha

Topic		Replies	Views
filterBy with condition Solved ✅	4	671	February 28, 2016
Generate list of events, sorted by date and time Questions 🤔	1	482	September 30, 2018
Filtering events with startdate and endtime Solved ✅	5	162	July 5, 2023
Filtering events by date Solved ✅	14	308	August 18, 2022
Filtering events by day, week, or month Solved ✅	7	3748	April 14, 2017

Events - Startdate/Enddate (Enddate - Filter)

Related Topics