添加时间类型栏

Question

不知道怎么加时间工作控制器if($request->status === 'completed')    {        $t = 0;        $alltime = Work::where('project_id', $project->id)->get();        foreach($alltime as $time)        {            $t = $t + $time->work_time;        }        $project -> fill(['total_work_time' => $t])->save();    }但是没有一个好的方法可以做到这一点吗？

Answer 1

你可以用区间求和，

$base_time = new DateTime();

$time_now = clone $base_time;

foreach ($alltime as $time) {

    $array = explode(':', $time);

    $base_time->add(new DateInterval(sprintf('PT%dH%dM', $array[0], $array[1])));

}

$sum_of_diff = $time_now->diff($base_time);