Getting the dates of specific days

designtrooper · February 23, 2016, 10:04am

I want to do this:
Suppose we have a time span…from February 1st to February 28th.
Simply put…I want to get all the dates of the Sundays and Saturdays within this time span.

Any ideas about how to achieve this?

John_Betong · February 23, 2016, 10:39am

Try this:

  $str = '2016-02-';
  for($i2=1; $i2<30; $i2++)
  {

    // echo '<br>',
      $ddd = $str.$i2;
    // echo '',
      $date = date('Y M D d', $time = strtotime($ddd) );

    if( strpos($date, 'Sat') || strpos($date, 'Sun') )
    {
      echo '<br>' .$date;
    }
  }

Output:

I will leave it up to you to optimize or to wait for an alternative solution.

designtrooper · February 23, 2016, 11:15am

very interesting…so far it seems that it does the job…I want to make some tests.
I will inform you if this after all will be the solution to the problem posed.

davidtsadler · February 23, 2016, 11:38am

This example takes a different approach. It makes use of a function that builds an array of DateTime objects that span a specified date range. This array can then be filtered to find dates that you are interested in. The example shows how to obtain those that fall on a weekend and a Monday.

<?php

/**
 *  @begin    string A date/time string that can be accepted by the DateTime constructor.
 *  @end      string A date/time string that can be accepted by the DateTime constructor.
 *  @interval string An interval specification that can be accepted by the DateInterval constructor.
 *                   Defaults to P1D
 *
 *  @return   array Array of DateTime objects for the specified date range.
 */
function dateRange($begin, $end, $interval = null)
{
    $begin = new DateTime($begin);
    $end = new DateTime($end);
    // Because DatePeriod does not include the last date specified.
    $end = $end->modify('+1 day');
    $interval = new DateInterval($interval ? $interval : 'P1D');

    return iterator_to_array(new DatePeriod($begin, $interval, $end));
}

$dates = dateRange('2016-01-01', '2016-02-23');

$weekends = array_filter($dates, function ($date) {
    $day = $date->format("N");
    return $day === '6' || $day === '7';
});

foreach ($weekends as $date) {
    echo $date->format("D Y-m-d") . "\n";
}

$mondays = array_filter($dates, function ($date) {
    return $date->format("N") === '1';
});

foreach ($mondays as $date) {
    echo $date->format("D Y-m-d") . "\n";
}

designtrooper · February 23, 2016, 4:24pm

I wll go for this code…it is "cleaner: and it allowς for a timeframe that varies.

I must add something though.
In my original post I said that I want to get the dates of saturdays/sundays.

**This will vary too…**It maybe any day of the week and any number of it(it might be 2 or 3 or 4 days)
The code does not take into consideration this.

A change must occur here:
$weekends = array_filter($dates, function ($date) {
$day = $date->format(“N”);
return $day === ‘6’ || $day === ‘7’;
});

For naming purposes of course weekends must be replaced with an other name…
I must say here that the days of interest will result from a query and this query will give days in this format: monday… tuesday…etc.As such I have modified the code to this

$weekends = array_filter($dates, function ($date) 
        {
    $day = $date->format("l");
    return $day === 'Saturday' || $day === 'Sunday';
});

Nonetheless this code is for a fixed number of days(2) and specific days of the week.

How to change the code so to reflect the fact that the above factors will vary?

davidtsadler · February 23, 2016, 5:32pm

Will the query return the number of days in an array? For example an array such as:

$days = [
 'Monday',
 'Friday',
 'Saturday'
];

designtrooper · February 23, 2016, 5:46pm

YES…an array with the days will be returned.

felgall · February 23, 2016, 8:23pm

If Mondays are to be included is there a reason why only four of the five Mondays in February are included in the original date range?

davidtsadler · February 23, 2016, 9:09pm

I’ve updated the code a little so that the filter can work with any number of days.

<?php

/**
 *  @begin    string A date/time string that can be accepted by the DateTime constructor.
 *  @end      string A date/time string that can be accepted by the DateTime constructor.
 *  @interval string An interval specification that can be accepted by the DateInterval constructor.
 *                   Defaults to P1D
 *
 *  @return   array Array of DateTime objects for the specified date range.
 */
function dateRange($begin, $end, $interval = null)
{
    $begin = new DateTime($begin);
    $end = new DateTime($end);
    // Because DatePeriod does not include the last date specified.
    $end = $end->modify('+1 day');
    $interval = new DateInterval($interval ? $interval : 'P1D');

    return iterator_to_array(new DatePeriod($begin, $interval, $end));
}

function dateFilter(array $daysOfTheWeek)
{
    return function ($date) use ($daysOfTheWeek) {
        return in_array($date->format('l'), $daysOfTheWeek);
    };
}

function display($date) { echo $date->format("D Y-m-d")."\n"; }

$dates = dateRange('2016-01-01', '2016-02-23');

array_walk(array_filter($dates, dateFilter(['Monday'])), 'display');
array_walk(array_filter($dates, dateFilter(['Tuesday', 'Wednesday', 'Thursday'])), 'display');
array_walk(array_filter($dates, dateFilter(['Saturday', 'Sunday'])), 'display');

John_Betong · February 24, 2016, 4:09am

@davidtsadler

Version: 002

<?php 
/**
 function: find the aDays in the time period
   usage:
    getDays($start, $duration, $aDays, $fFormat) 
 where:  
   $start = 'YYYY';   
   $iDays =  365;  // maximum  
   $aDays = ['Mon', 'Wed', 'Fri'];  //  3xchar  
*/
>
function getDays(
    $start  ='2016-12-25', 
    $iDays  = 365, 
    $aDays  = ['Sun', 'Wed', 'Sat'],
    $format = 'D, M jS Y'
) 
{
  $dStart = date('d', strtotime($start));
  $YM     = substr($start, 0, 8);

  for($i=$dStart; $i<=$iDays; $i++)
  {
    $ok   = strtotime($YM.$i);
    if($ok)
    {
      $date = date('D', $ok);
      foreach($aDays as $day)
      {
        $date = strtolower($date);         
        $day  = strtolower($day);         
        if( $date===$day )
        {
          echo '<br>' .date($format, $ok);
        }
      }//foreach 
    }//$ok
  }
}//endfunc

Usage:

getDays();

Results:
Sun, Dec 25th 2016
Wed, Dec 28th 2016
Sat, Dec 31st 2016

Usage:

getDays($str = ‘2016-02-01’, 42, $aDays = [‘Mon’,‘Thu’,‘Fri’],‘Y M D jS’);

2016 Feb Mon 1st
2016 Feb Thu 4th
2016 Feb Fri 5th
2016 Feb Mon 8th
2016 Feb Thu 11th
2016 Feb Fri 12th
2016 Feb Mon 15th
2016 Feb Thu 18th
2016 Feb Fri 19th
2016 Feb Mon 22nd
2016 Feb Thu 25th
2016 Feb Fri 26th
2016 Feb Mon 29th

[off topic] ***It took me longer to format the post than it did write the function :(***

Edit:
Added optional formatting parameter to function

designtrooper · February 24, 2016, 4:32pm

I am having hard time to figure out what is the usage of use.

John_Betong · February 24, 2016, 5:35pm

Notice: Only variables should be passed by reference in /home/john/www/atests/index-get-selected-days.php on line 85

To eliminate the Warning message try changing error_reporting()

KLUDGE

error_reporting(E_STRICT);
    $dates = dateRange('2016-01-01', '2016-02-23');

    array_walk( array_filter($dates, dateFilter( ['Monday'])), 'display' );
    array_walk( array_filter($dates, dateFilter( ['Tuesday', 'Wednesday', 'Thursday'])), 'display' );
    array_walk( array_filter($dates, dateFilter( ['Saturday', 'Sunday'])), 'display' );
error_reporting(-1);

John_Betong · February 24, 2016, 5:39pm

Maybe this will help:

designtrooper · February 24, 2016, 7:12pm

to eliminate the warning I just did this:

$d=array_filter($dates, dateFilter(['Tuesday']));

array_walk($d, 'display');

I passed array_filter to a variable and then used it to array walk.

John_Betong · February 26, 2016, 4:08am

I tried this and was most surprised the warning was still activate:

    array_walk( $tmp=array_filter($dates, dateFilter( ['Saturday', 'Sunday'])), 'display' );

designtrooper · February 26, 2016, 8:07am

John_Betong:

designtrooper:

I passed array_filter to a variable and then used it to array walk.

I tried this and was most surprised the warning was still activate:
    array_walk( $tmp=array_filter($dates, dateFilter( ['Saturday', 'Sunday'])), 'display' );

I do not know why that might be happening…I do not know the logic of the parser.

designtrooper · February 26, 2016, 11:51am

There is an issue left though.
As the code is now a display function is called to print the data to the browser.

function display($date) { echo $date->format("D Y-m-d")."\n"; }

I want though these data to be passed to an array
I tried this function:
function create_cl_days_array($date)
{ $closed_day=array();
$day=array(“date”=>$date->format(“l Y-m-d”));
array_push($closed_day, $day);
}
And:
array_walk($closed_dts, 'create_cl_days_array');
var_dump($closed_day)

I was hoping that var dumping $closed_day would give me the array with the dates…instead I get the usual udefined variable message.

Why?

P.S Sorry for not formatting properly create_cl_days()…I tried very hard to do so…but I couldn’t

John_Betong · February 26, 2016, 2:06pm

Version 003:

/* =========================================
 function: find the aDays in the time period
 usage:
   @getDays( @start, @duration, @aDays, @format, @result) 
 where:  
   @start  = 'YYYY';   
   @iDays  =  365;  // maximum  
   @aDays  = ['Mon', 'Wed', 'Fri']; # 3xchar  
   @format = 'Y M D jS',
   @result = NULL
========================================= */
function getDays(
    $start  ='2016-12-25', 
    $iDays  = 365, 
    $aDays  = ['Sun', 'Wed', 'Sat'],
    $format = 'D, M jS Y',
    $result = NULL
) 
{
  $dStart = date('d', strtotime($start));
  $YM     = substr($start, 0, 8);

  for($i=$dStart; $i<=$iDays; $i++)
  {
    $ok   = strtotime($YM.$i);
    if($ok)
    {
      $date = date('D', $ok);
      foreach($aDays as $day)
      {
        $date = strtolower($date);         
        $day  = strtolower($day);         
        if( $date===$day )
        {
          if( is_array($result) )
          {
            $result[] = date($format, $ok);
          }else{
            echo '<br>' .date($format, $ok);
          }
        }
      }//foreach 
    }//$ok
  }

  return $result;
}//endfunc

echo '<b>Defaults: (no Parameters)</b>';
  getDays();

echo '<br><br>';
echo '<b>all the Parameters:</b>';
  $result    = getDays(
      $str   = '2016-02-01', 
      $iDays = 12, 
      $aDays = ['Mon','Thu','Fri'],
      $format= 'Y M D jS',
      $aDate = []
      );

  echo '<pre>', print_r($result, true), '</pre>';

Output:

Defaults: (no Parameters)
Sun, Dec 25th 2016
Wed, Dec 28th 2016
Sat, Dec 31st 2016

all the Parameters:
Array
(
[0] => 2016 Feb Mon 1st
[1] => 2016 Feb Thu 4th
[2] => 2016 Feb Fri 5th
[3] => 2016 Feb Mon 8th
[4] => 2016 Feb Thu 11th
[5] => 2016 Feb Fri 12th
)

davidtsadler · February 26, 2016, 5:32pm

I’ve added more examples of what can be done. The important thing to keep in mind is that once you have called array_filter you will be left with an array of DateTime objects for a range of dates that have meet a criteria. This array can be molded into what ever your project needs. Notice that at no point do I ever need to change how dateRange works. I just simple make use of the various array_ functions.

designtrooper · February 26, 2016, 7:30pm

thank you for devoting the time and the effort.