timestamp

[sandy1028]

Hi,

There is a piece of code where $time[$j] should be 2008-06-13 00:10:00 and 0#2008-06-13 00:50:00

$time[$i] should be 2008-06-13 00:40:00 and 2008-06-13 01:10:00

ie. when the status changes from 0 to 1, the timestamp should be assigned as when status was 0 initially.

In the above code status was 0 at 2008-06-13 00:10:00.

again it was 0 at 2008-06-13 00:50:00

<?php
$stack = array();
$val = array();
$time = array();
$values=array("0#2008-06-13 00:10:00","0#2008-06-13 00:20:00","0#2008-06-13 00:30:00","1#2008-06-13 00:40:00","0#2008-06-13 00:50:00","1#2008-06-13 01:10:00");

foreach($values as $v){
$val1=split("#",$v);
array_push($val,$val1[0]);
array_push($time,$val1[1]);
}


//$val = array(0,0,1,0,1,0,0,1,0,0,1,0);
//$val = array(0,0,0,0,0,1,1,1,1,0,1,1);
$previous_value = $val[0];
$i = 0;
foreach ($val as $value){
    $this_value = $value;
    if($previous_value ==0 && $this_value ==1)
    array_push($stack, "$time[$j]#$time[$i]");

  $previous_value = $this_value;
    $i++;
        $j=$i-1;

}

echo"<pre>";
print_r($val);
print_r($stack);
echo"</pre>";

Please tell me how to assign the timestamp from when it was 0.

[leatherback]

Hey Sandy,

Seems like you are struggling to get this to work. I did a bit of tinkering, and rewrote it for you. Hope this helps:

<?php
$values=array(
   "0#2008-06-13 00:10:00",
   "0#2008-06-13 00:20:00",
   "0#2008-06-13 00:30:00",
   "1#2008-06-13 00:40:00",
   "0#2008-06-13 00:50:00",
   "1#2008-06-13 01:10:00"
   );

$i=0;
$outtime = array();
$status = array();

foreach($values as $v) //For each element in the values array
  {
  // Split the value by hash
  $vals = explode('#', $v);
  // If this is the first loop, set the previous status
  if($i == 0) {$previous_value = $vals[0]; $i=1}

  // Set the current status
  $this_value = $vals[0];

  // If the previous =0 and the current is 1, store the values in a new array for output
  if($previous_value ==0 && $this_value ==1)
    {
	$status[]  = $vals[0];
    $outtime[] = $vals[1];
	}

  // Store the current, for the next loop it is previous value
  $previous_value = $vals[0];
  }

echo"<pre>";
print_r($status);
print_r($outtime);
echo"</pre>

?>

[sandy1028]

yes I am struggling to get this work done.

In the above code if status value is all 0 then it comes out of the loop.
I am struggling lot to fix this.

[sandy1028]

In the above code I will get only the time when the status change from 0 to 1.

My problem is how to store the previous timestamp i.e
0#2008-06-13 00:10:00 from when the status was 0 and at 2008-06-13 00:40:00 status was 1.

So I have to find the difference between two timestamps.

Again difference between 2008-06-13 00:50:00 to 2008-06-13 01:10:00

I have to print in the table
Start time End Time Difference
2008-06-13 00:10:00 2008-06-13 00:40:00 30 min
2008-06-13 00:50:00 2008-06-13 01:10:00 10 min
And also if status is all 0 then include in the table like this.
2008-06-13 00:10:00 2008-06-13 01:10:00 60min

I am struggling to print the previous timestamp from when status was 0.

[leatherback]

Sandy,

I am sure the solution is very straightforward, once it is clear what you need. I keep getting confused, as you seem to slightly need something defferent from posting to posting 😃

So..
1) When status does not change, what do you want to show?
- Nothing?
2) When status changes from 0 to 1, what do you want to show?
- The period that status 0 was valid? So start of status 0, end of status 0 and the difference?
3) When status changes from 1 to 0 what do you want to show?
- like, but for status == 1

??

[sandy1028]

I have to find the timestamp difference in two conditions

suppose if the data is
$values=array(
"0#2008-06-13 00:10:00",
"0#2008-06-13 00:20:00",
"0#2008-06-13 00:30:00",
"1#2008-06-13 00:40:00",
"0#2008-06-13 00:50:00",
"1#2008-06-13 01:10:00"
);

Then show timestamp difference when status changes only from 0 to 1.
Here
2008-06-13 00:10:00 to 2008-06-13 00:40:00 i.e from when status was 0 to 1.
Again ", 2008-06-13 00:50:00 to 2008-06-13 01:10:00
I have to display in tabular view in which the header contains :

Start time End time differnece
2008-06-13 00:10:00 2008-06-13 00:40:00 30min
2008-06-13 00:50:00 2008-06-13 01:10:00 20 min

Second condition is suppose all the status is 0
$values=array(
"0#2008-06-13 00:10:00",
"0#2008-06-13 00:20:00",
"0#2008-06-13 00:30:00",
"0#2008-06-13 00:40:00",
"0#2008-06-13 00:50:00",
"0#2008-06-13 01:10:00"
);

I have to just show the timestamp difference from 2008-06-13 00:10:00 to 2008-06-13 01:10:00.

Start time End time differnece
2008-06-13 00:10:00 2008-06-13 01:10:00 60min

My problem is I am not able to show the Start time properly. and status values is always 0.

[leatherback]

Having a look at it now. I am just really bad with the time-functions (I do all my time cals in mysql). Do you have a time diff function already for the timestamps you are using? Or do you have them as actual unix timestamps?

[leatherback]

hope this works for you:

<?php
$values=array(
   "0#2008-06-13 00:10:00",
   "0#2008-06-13 00:20:00",
   "0#2008-06-13 00:30:00",
   "1#2008-06-13 00:40:00",
   "0#2008-06-13 00:50:00",
   "1#2008-06-13 01:10:00"
   );

$i=0;
$outset = array();
$status = array();
$aset   = 0;

foreach($values as $v) //For each element in the values array
  {
  // Split the value by hash
  $vals = explode('#', $v);
  // If this is the first loop, set the previous status
  if($i == 0) {$previous_value = $vals[0]; $i=1; $starttime = $vals[1];}

  // If the previous =0 and the current is 1, store the values in a new array for output
  if($previous_value == 0 && $vals[0] == 1)
    {
	$aset 			= 1;
	$tdiff     		= date('h:i:s', strtotime($vals[1]) - strtotime($starttime)); 
	$outset[]  		= $starttime.' '.$vals[1].' '.$tdiff;
    }

  if($vals[0] == 0 && $previous_value == 1)
    {
	$starttime 		= $vals[1];
	}

  // Store the current, for the next loop it is previous value
  $previous_value 	= $vals[0];
  $lasttime       	= $vals[1];
  }

if($aset == 0)
  {
	$tdiff     		= strtotime($vals[1])-strtotime($starttime);
	$outset[]  		= $starttime.' '.$lasttime.' '.$tdiff;
  }

echo"<pre>";
print_r($outset);
echo"</pre>";

?> 

[sandy1028]

Thank you so much. It worked 🙂

[sandy1028]

$values=array(
"0#2008-06-13 00:10:00",
"0#2008-06-13 00:20:00",
"0#2008-06-13 00:30:00",
"1#2008-06-13 00:40:00",
"0#2008-06-13 00:50:00",
"0#2008-06-13 01:10:00"
);

Can anyone tell me when array has the value as above why it is not plotting.

[leatherback]

plotting what? Plotting how?

[sandy1028]

If
$values=array(
"0#2008-06-13 00:10:00",
"0#2008-06-13 00:20:00",
"1#2008-06-13 00:30:00",
"0#2008-06-13 00:40:00",
"0#2008-06-13 00:50:00",
"0#2008-06-13 01:10:00"
);

The start time and end time between 2008-06-13 00:40:00 and 2008-06-13 01:10:00 is not displayed.

[leatherback]

Because there is no change from 0 to 1 in your status between these times.

Again: You need to be clear in what you need.

If you want to also show the time when the series end with a 0, change:

if($aset == 0)
{

to

if( ($aset == 0) || ($vals[0] == 0 && $previous_value == 0) )
{