$sql = <<< SQL SELECT user_id, SEC_TO_TIME( SUM( TIME_TO_SEC(work_time) - TIME_TO_SEC('8:00:00') ) ) AS total_overtime FROM tb_user_work_time WHERE work_time > CAST('8:00:00' AS TIME) GROUP BY user_id HAVING total_overtime <= CAST('20:00:00' AS TIME); SQL; $result = DB::select($sql);
18行目のSQL;にインデントはつけない
コメント