php 计算时间段内的工作日 与节假日

计算方法是取开始时间后的第一个星期一，如果结束时间大于等这一天则用第一个星期一至结束时间的时间的间隔取整周数与余数计算工作日与周末，再加上第一个周一前一周的工作日与节假日.

 

/** 计算时间段内的工作日 与节假日
 * @param $begin_date \DateTime
 * @param $end_date  \DateTime
 * @return array
 * @throws \Exception
 */
static function computeDays($begin_date,$end_date)
{
 
    if ($end_date >= $begin_date) {
        $begin_week_day = $begin_date->format("N");
        if ($begin_week_day == 1) {
            $cut_week_days = 0;
        } else {
            $cut_week_days = 7 - $begin_week_day + 1;
        }
 
        $dateInterval = new \DateInterval("P" . $cut_week_days . "D");
        $first_monday = $begin_date->add($dateInterval);
 
        //总工作日
        $total_work_days = 0;
        //总节假日
        $total_holidays = 0;
        //总天数，包括起始日期
        $total_days = 0;
        if ($end_date >= $first_monday) {
            $diff = $first_monday->diff($end_date);
            $diff_days = $diff->days + 1; // 包括开始日期 +1
            $weeks_yu = $diff_days % 7;
            $weeks = floor($diff_days / 7);
            $total_days = $diff_days;
            if ($weeks > 0) {
                $total_work_days = $weeks * 5;
                $total_holidays = $weeks * 2;
            }
 
            if ($weeks_yu == 6) {
                $total_holidays += 1;
                $total_work_days += 5;
            } else {
                $total_work_days += $weeks_yu;
            }
 
            if ($cut_week_days > 0) {
                if ($cut_week_days >= 2) {
                    $total_work_days += $cut_week_days - 2;
                    $total_holidays += $cut_week_days + 2;
                } else {
                    $total_holidays += 1;
                }
            }
 
        } else {
            $diff = $first_monday->diff($end_date);
            $diff_days = $diff->days + 1; // 包括开始日期 +1
            $end_week_day = $end_date->format("N");
            if ($begin_week_day <= 5 && $end_week_day <= 5) {
                $total_work_days += $end_week_day - $begin_week_day + 1;
            } elseif ($begin_week_day > 5 && $end_week_day > 5) {
                $total_holidays += $end_week_day - $begin_week_day + 1;
            } elseif ($begin_week_day <= 5 && $end_week_day > 5) {
                $total_work_days += 5 - $begin_week_day + 1;
                $total_holidays += $end_week_day - 5;
            }
 
            $total_days = $end_week_day - $begin_week_day + 1;
        }
 
 
        //判断国家规定节假日     
        /*$project_holidays = ProjectHolidaysModel::where("1=1")
            ->whereBetweenTime("thedate",$begin_date->format("Y-m-d"),$end_date->format("Y-m-d"))
            ->all();*/
         //以2020 五一为例 ，在数据库中加入上班与节假日调整
         //is_holidays 1假期 0上班
         $project_holidays = [
             ["thedate"=>'2020-5-1',"is_holidays"=>1],
             ["thedate"=>'2020-5-4',"is_holidays"=>1],
             ["thedate"=>'2020-5-5',"is_holidays"=>1],
             ["thedate"=>'2020-5-9',"is_holidays"=>0],
         ];
 
 
        foreach ($project_holidays as $one){
            $the_date = new \DateTime($one["thedate"]);
            $the_week_day = $the_date->format("N");
 
            if($the_week_day > 5 && $one["is_holidays"] =="0"){
                $total_holidays -= 1;
                $total_work_days += 1;
            }
            if($the_week_day <=5 && $one["is_holidays"] == "1"){
                $total_holidays += 1;
                $total_work_days -= 1;
            }
        }
 
 
 
        return [
            "total_work_days" => $total_work_days,
            "total_holidays" => $total_holidays,
            "total_days" => $total_days
        ];
 
    }
}