我要统计一下所有与今天日期相符的记录。
我代码:
$today_present = AppAttendance::where('attendance_date', '=', CarbonCarbon::now()->toDateString())
->where('attendance_status', 1)->get();
$today_absent = AppAttendance::where('attendance_date', '=', CarbonCarbon::now()->toDateString())
->where('attendance_status', 0)->get();
这里我想从表中计算今天出席和缺席的行。但是它不工作。
嗨,请使用它将工作:
$StartDate=date('Y-m-d 00:00:00');//您也可以根据保存日期更改日期格式,如Y-m-d或d-m-Y等
$ EndDate =日期("Y-m-d 23:59:59");
$today_present = AppAttendance::whereBetween('attendance_date', [$StartDate, $EndDate])→(attendance_status, 1)→();$today_absent = AppAttendance::whereBetween('attendance_date', [$StartDate, $EndDate])→(attendance_status, 0)→();
同样,你也可以在header中导入你的模态名称并使用你的模态名称,如:
$today_present =考勤::whereBetween('attendance_date', [$StartDate, $EndDate]) ->where('attendance_status', 1)->get();