PHP - 计算两个日期之间的工作时间，但不包括请求处于暂停状态的时间

Question

Can some one help me write a function that calculates the number of working hours between two dates but want to exclude the time when the request had a status of "On Hold".

So lets say the request came in at 3PM friday and was closed at 3PM Wednesday, and working hours are from 8AM to 5PM pacific (Mon thru Friday)...Total working hours will be 27 hours...but if the request remained on hold from Monday 3PM till Tuesday 3PM...Actual work time on the request really becomes 18 hours instead of 27 hours.

I have recently started working on PHP and have been assigned this task which is very confusing to me. Please help

Answer 1

Calculate work time with an accuracy of 1 minute.

WARNING: This function can take many seconds to load as it does a loop for every minute between the time span.

<?php

$request = array(
    'start' => '3PM Nov 29 2013',
    'end' => '3PM Dec 4 2013'
);

echo calculate_work($request);

/**
 * Calculate work time by looping through every minute
 * @param  array $request start to end time
 * @return int  work time in minutes
 */
function calculate_work($request)
{
    $start = strtotime($request['start']);
    $end = strtotime($request['end']);
    $work_time = 0;

    /* Add 1 minute to the start so that we don't count 0 as a minute  */
    for ($time = $start + 60; $time <= $end; $time += 60)
    {
        // Weekends
        if (date('D', $time) == 'Sat' OR date('D', $time) == 'Sun')
            continue;

        // Non Working Hours
        if (date('Hi', $time) <= '0800' OR date('Hi', $time) > '1700')
            continue;

        // On Hold
        if ($time > strtotime('3PM Dec 2 2013') AND $time <= strtotime('3PM Dec 3 2013'))
            continue;

        $work_time++;
    }

    // Divide by 60 to turn minutes into hours
    return $work_time / 60;
}