Working hours / Non working hours

[benja]

i need to know if a telephone call was made in working hours or not.

supose i have a table with the non working hours:

---

Monday 18:00PM - 24:00
Tuesday 18:00PM - 24:00
..
Saturday 14:00 - 24:00

Sunday 00:00 - 24:00

Supose now that we have theses calls made:

Monday: 2:00 - 4:00. =>(working hour)
Tuesday: 18:30 - 18:45. =>(non working hour)

Satuday: 13:30 - 14:50. => (half working, half not working. We will supose, that this one is working hours.)

Any help to make a script that can achieve this is well received.

Thanks in advance

[infolock]

😕

sorry that doesn't make any sense at all to me =\ how are you getting the times? how does your table look? how does the data even get into the table that they made a call? how are you going to determine if the call was a non-working hour or working hour?

etc etc.

[benja]

infolock,
i havent created the "non working hour table" yet. Not sure what is the best way to create this table for resolving this problem
The two dates/times would be avaliable to PHP in the form: YYYY-mm-dd H:i:s.

What i need to determine is if that YYYY-mm-dd H:i:s is on working hours or not.

[bpat1434]

Well, let's assume that all the call times are in an array called "$calltimes". Now, we just create the basic non-working-hour timestamps (or working hour, depending upon how you look at it):

<?php
$working = array(
    'Monday' => strtotime("18:00"),
    'Tuesday' => strtotime("18:00"),
    'Wednesday' => strtotime("18:00"),
    'Thursday' => strtotime("18:00"),
    'Friday' => strtotime("18:00"),
    'Saturday' => strtotime("14:00"),
    'Sunday' => strtotime("00:00"),
    'Start' => strtotime("24:00")
    );
$calls = array('1' => array('day' => 'Monday', 'strt' => strtotime('02:00'), 'end' => strtotime('04:00')),
    '2' => array('day' => 'Tuesday', 'strt' => strtotime('18:30'), 'end' => strtotime('18:45')),
    '3' => array('day' => 'Saturday', 'strt' => strtotime('13:30'), 'end' => strtotime('14:50'))
    );

// Empty variable for writing to within our loop
$output = '';

// Get the start time for each work day (since they're all the same, i.e. not dynamic)
$start = $working['Start'];

// Now, loop through and compare whether the start time is within the the off time(s)
// Assuming that all calls that start prior to the end time time will be counted as within
// working time.
for($i=1; $i<=count($calls); $i++)
{
    $output .= 'Call initiated at '.$calls[$i]['strt'].' on '.$calls[$i]['day'].' lasting until '.$calls[$i]['end'].'<br>';
    $end = $working[$call[$i]['day']];
    if( ($calls[$i]['strt'] > $working[$calls[$i]['day']]) && ($calls[$i]['strt'] < $working['Start']) )
    {
        // The call was initiated between the end of the work day, and the beginning of
        // the work day
        $output .= '<span style="color: #f00;">The call was initiated outside of the normal work hours.</span>';
    }
    else
    {
        // The call had to have been initiated within the work hours
        $output .= '<span style="color: #009;">The call was initiated inside of the normal work day.</span>';
    }
    $output .= '<hr>';
}

echo $output;

?>

Hope that helps....

~Brett

[benja]

Thanks bpat for your code was really usefull for solving my problem.
This is what i did.

//test call

//ano: year
//mes: month
//dia: day
//hora:hour
//minuto: minute
//inicio: start
//termino: end

  $ano_inicio = "2005";
  $mes_inicio = "03";
  $dia_inicio = "06";
  $hora_inicio = "15";
  $minuto_inicio = "00";

  $ano_termino = "2005";
  $mes_termino = "03";
  $dia_termino = "07";
  $hora_termino = "07";
  $minuto_termino = "00";
//end test call


//non working array

$non_working = array( 
	'Monday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					  'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					  'inicio2' => mktime(18, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					  'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio)),


'Tuesday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				  'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				  'inicio2' => mktime(18, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				  'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio)),

'Wednesday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				    'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
			     	'inicio2' => mktime(18, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
			    	'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio)),

'Thursday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
			    	'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
			    	'inicio2' => mktime(18, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio)),

'Friday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				 'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				 'inicio2' => mktime(18, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				 'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio)),

'Saturday' => array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
			   		'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					'inicio2' => mktime(14, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
					'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +2, $ano_inicio)),

'Sunday'=> array('inicio1' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				'termino1' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio),
			 	'inicio2' => mktime(0, 0, 0, $mes_inicio, $dia_inicio, $ano_inicio),
				'termino2' => mktime(6, 0, 0, $mes_inicio, $dia_inicio +1, $ano_inicio))

			);

//transform date of call in unix timestamp
$ts_inicio = mktime($hora_inicio, $minuto_inicio, 0, $mes_inicio, $dia_inicio, $ano_inicio);
$ts_termino = mktime($hora_termino, $minuto_termino, 0, $mes_termino, $dia_termino, $ano_termino);



if(	($ts_inicio	>= $non_working[date("l", $ts_inicio)]['inicio1'] AND
	$ts_termino < $non_working[date("l", $ts_inicio)]['termino1'])
	OR
	($ts_inicio	>= $non_working[date("l", $ts_inicio)]['inicio2'] AND
	$ts_termino < $non_working[date("l", $ts_inicio)]['termino2'] ))
	{
		echo "\n<br><br>Outside normal hours";
		$dscto = 1;
	}
	else
	{
		echo "\n<br><br>Normal Work Hour";
		$dscto = 0;
	}

Thanks for the help.

[bpat1434]

Glad to hear I could be of help....

~Brett

[jazz_snob]

I thought this was a good problem to try to solve. Tests ok, so far. I tried to think of tricky test cases.

OK. Fixed bug.

/**
 * @ returns 1 if duration is at least 50% during working hours
 * otherwise returns 0.
 * @param $start and $end are timestamps (seconds since Epoch)
 */
function is_working_hours( $start, $end ) {

$is_working = 0;
$call_length = $end - $start;

// assume call starts during working hour!
// if tests fail, then we'll go in and dink w/ code

switch( strtolower(strftime( "%A", $end )) ) {
    case 'saturday':
        $work_day_start = 0;
        $work_day_end = 14*3600;
        break;
    case 'sunday':
        return 0;
        break;
    default:
        // weekdays
        $work_day_start = 0;
        $work_day_end= 18*3600;

} // switch

list( $hr, $min ) = explode( ",", strftime( "%H,%M", $end ) );
$sec_off = ($hr*3600 + $min*60) - $work_day_end;
if( $sec_off < 0 ) $sec_off = 0;

$is_working = $sec_off <= ( $call_length * .5 );

return $is_working;
}

// testing

function check( $start, $end ){
    $is_working = is_working_hours($start, $end );
    echo strftime( "%A %R", $start ) ." thru ". strftime( "%A %R", $end) .": " . ( ( $is_working ) ? ' was during working hours' : ' off hours' ) . "<br />";
}

// testing
// monday, 14:00
check( mktime( 14, 0, 0, 11, 7, 05 ), mktime( 16,0,0,11,7,05) );
check( mktime( 18, 30, 0, 11, 8, 05 ), mktime( 18, 45, 0, 11, 8, 05 ) );
echo "note that the bulk of this Saturday call is off hours<br />";
check( mktime( 13, 30, 0, 11, 5, 05 ), mktime( 14, 50, 0, 11, 5, 05 ) );

echo "now test call starting before working hours<br />";

check( mktime( 23, 0, 0, 11, 6, 05 ), mktime( 3, 0, 0, 11, 7, 05 ) );
echo "a tricky case--have to decide where division work/non-work is 50%?<br />";
check( mktime( 23, 0, 0, 11,8,05 ), mktime( 1,0,0,11,9,05 ) );

echo "call all during working hours<br />";
check( mktime( 5,0,0,11,7,05), mktime( 6,0,0,11,7,05));

echo "call is off hours entirely<br />";
check( mktime( 18,0,0,11,7,05 ), mktime( 20,0,0,11,7,05));

echo "call starts during working, ends after, just about even<br />";
check( mktime( 17,30,0,11,7,05), mktime( 18,29,0,11,7,05));