[Resolved] Exclusion Times Within Two Times

anvedo

Hi,
briefly, im trying to display a range of time (like ($begins 08:00am) to ($ends 04:00pm),
by excluding one, none, or more range in 2 arrays of other times in couple ($from -> $to).
Like:8am to 4pm with steps of 20 mins, and there are, for example, 3 arrays, like
$from=array("09:00","12:00","14:00") and
$to = array("10:00","13:00","15:00"), meaning: the first range of time i want ot exclude from 8 to 4 is: from 09:00 to 10:00, and so on, -the time is never overlapped-
and im looking for something that displays :
08:00
08:20
08:40
10:00
10:20
10:40
11:00
11:20
11:40
13:00
13:20
13:40
15:00
15:20
15:40
I've used seconds from midnight, like 28800 it's 08:00, then mktime.

Here's what i triedwhich doesnt work, naturally......)

PHP Code:

<?php 
$begins="28800";//08:00am 
$ends="57600";// 04:00pm 
$from=array("32400","43200","50400");//09:00,12:00,14:00 
$to=array("36000","46800","54000");  //10:00,13:00,15:00 
$step=1200; 
foreach($from as $n => $f){ 
    for($y=$begins;$y <= $ends-$step;$y++){ 
        $v=date("H:i",mktime(0,0,$y,7,11,2004)); 
        if    ($y <= $f[$n]-$step || $y >= $to[$n]){echo $v."<br>";} 
        elseif($y >= $f[$n] && $y <= $to[$n]){echo"empty $n <br>";}; 
        $y=$y+1199;//seconds, less 1 (20 minutes) 
                              }; 
                                       }; 
?>

it returns the (wrong) results as many times as the "count($from)"

The following does work, but jeez.......very slow and very ugly

PHP Code:

<?php 
$begins="28800";//08:00am 
$ends="57600";// 04:00pm 
$from=array("32400","43200","50400");//09:00,12:00,14:00 
$to=array("36000","46800","54000");  //10:00,13:00,15:00 
$step=1200; 
for($y=$begins;$y <= $ends-$step;$y++){ 
$v=date("H:i",mktime(0,0,$y,7,11,2004)); 
if    (   

      ($y <= $from[0]-$step || $y >= $to[0])&& 
      ($y <= $from[1]-$step || $y >= $to[1])&& 
      ($y <= $from[2]-$step || $y >= $to[2])&& 
      ($y <= $from[3]-$step || $y >= $to[3])&& 
      ($y <= $from[4]-$step || $y >= $to[4])&& 
      ($y <= $from[5]-$step || $y >= $to[5])&& 
      ($y <= $from[6]-$step || $y >= $to[6])//and so on..........zzzz 
       )       

      {echo"$v<br>";}; 
$y=$y+1199;//seconds, less 1 (20 minutes) 
}; 
?>

in short i i'd like to exclude some range of time from a longer given time.

anybody merciful?

BuzzLY

I notice one thing right off... in your first code block, you refer to $from1[$n]. That is wrong. It should be $from1 (since you pulled that value from the array already).

anvedo

Thanks for noticing, i made the changes, but it doesnt work either.
Other suggestions?

tsinka

Hi,

I looked at your code and thought that it would make things a lot easier to change the Array(s) containing the excluded time ranges a bit.

Example:

Looks like a lot of code but the only thing of interest is getExcluded... this code was very fast on my server...

<?PHP
  function getExcluded($arrRanges,$step,$first,$last) {
    $arrExcluded = array();
    while (list($key,$range) = each($arrRanges)) {
      // start and end of range
      $start = $range['begin'];
      $end   = $range['end'];

  // makes only sense if start<end
  if ($start < $end) {
    // difference in seconds
    $diff = $start-$first;

    // divide by step (minutes) to adjust indexes of excluded array
    $divisor = 60 * $step;

    // if diff mod divisor is 0 we start with $start else we start
    // with the next offset after $start to make sure that the indexes
    // of the exclusion array will match the timestamp values of interest
    // (example: using 7 as step won't hit the full hours of this example)
    if (($diff % $divisor) != 0) {
      $start = $first + (floor($diff/$divisor)*$divisor) + (60 * $step);
    }

    // now fill the array
    for ($cnt = $start;$cnt < $end;$cnt += (60*$step)) {
      $arrExcluded[$cnt] = 1;
    }
  }
}

return $arrExcluded;
  }

  // global time range
  $first = mktime(8,0,0,date('m'),date('d'),date('Y'));
  $last  = mktime(20,0,0,date('m'),date('d'),date('Y'));

  // step in minutes
  $step  = 20;


  // Array containing excluded time ranges
  $exclude[] = array('begin' => mktime(10,0,0,date('m'),date('d'),date('Y')),
                     'end'   => mktime(11,0,0,date('m'),date('d'),date('Y')));

  $exclude[] = array('begin' => mktime(14,0,0,date('m'),date('d'),date('Y')),
                     'end'   => mktime(15,0,0,date('m'),date('d'),date('Y')));

  $exclude[] = array('begin' => mktime(0,0,0,date('m'),date('d'),date('Y')),
                     'end'   => mktime(3,0,0,date('m'),date('d'),date('Y')));

  $exclude[] = array('begin' => mktime(16,0,0,date('m'),date('d'),date('Y')),
                     'end'   => mktime(20,0,0,date('m'),date('d'),date('Y')));

  // get exclude array and measure time
  $t1 = time();
  $arrExcluded = getExcluded($exclude,$step,$first,$last);
  $t2 = time();

  echo "Time in seconds to build exclude array: ".($t2-$t1)."<br>";

  $t1 = time();
  for ($cnt=$first;$cnt<=$last;$cnt+=(60*$step)) {
    if (!array_key_exists($cnt,$arrExcluded)) {
      echo date("H:i",$cnt)."<br>";
    }
  }
  $t2 = time();

  echo "Time in seconds to generate output: ".($t2-$t1)."<br>";
?>

Thomas

anvedo

this doesnt work either:

<?php
$begins=28800;//08:00am 
$ends=57600;// 04:00pm 
$from=array(32400,43200,50400);//09:00,12:00,14:00 
$to=array(36000,46800,54000);  //10:00,13:00,15:00 
$step=1200; 
foreach($from as $n => $f){ 
    for($y=$begins;$y <= $ends; $y+=$step){ 
        if($y >= $f AND $y < $to[$n]) { 
            //echo "y = $y, to = $to[$n]"; 
            $y = $to[$n] - $step; 

    } 
    else echo date("H:i", mktime(0,0,$y,7,11,2004)) . '<br />'; 
} 
echo '**************************'; 
} 
?>

tsinka

This modified version of your code should work:

<?php
$begins=28800;//08:00am
$ends=57600;// 04:00pm
$from=array(32400,43200,50400);//09:00,12:00,14:00
$to=array(36000,46800,54000);  //10:00,13:00,15:00
$step=1200;

for ($cnt=$begins;$cnt<=$ends;$cnt+=$step) {
  $excl = false;
  foreach($from as $n => $f) {
    if ($cnt >= $f && $cnt < $to[$n]) {
      $excl = true;
    }
  }

  if (!$excl)
    echo date("H:i", mktime(0,0,$cnt,date("m"),date("d"),date("Y")))."<br>\n";
}
?>

Loop from $begins to $ends and check all $from and $to values each time.

Thomas

tsinka

This one is better (performance):

<?php
$begins=28800;//08:00am
$ends=57600;// 04:00pm
$from=array(32400,43200,50400);//09:00,12:00,14:00
$to=array(36000,46800,54000);  //10:00,13:00,15:00
$step=1200;

for ($cnt=$begins;$cnt<=$ends;$cnt+=$step) {
  $excl = false;
  foreach($from as $n => $f) {
    if ($cnt >= $f && $cnt < $to[$n]) {
      $excl = true;
      break;
    }
  }

  if (!$excl)
    echo date("H:i", mktime(0,0,$cnt,date("m"),date("d"),date("Y")))."<br>\n";
}
?>

Notice the break ... since we don't need to go any further in case we matched against any of the exculded date ranges.

Thomas

anvedo

Thomas..........what can i say, your piece of code is simply EEExcellent! :p

Thank you very much!!!!!!!!