如何在laravel中对项目进行分组，并在组计数大于某个数字时回显该值

Question

$sql = "SELECT COUNT(date) AS numberofreservations, date FROM reservations GROUP BY date HAVING numberofreservations >= $max";//#per day

我刚切换到laravel，我正试图基于这个sql获取一个变量，$max将在我已经获得的另一个数据库的控制器中，但我如何像这样对它们进行分组？

Answer 1

Eloquent:

$max = 1; // example
$sql = Reservation::selectRaw('count(date) as numberofreservations, date')
->groupBy('date')
->havingRaw('numberofreservations >= ' . $max)
->get();

或者查询生成器：

$max = 1; // example
$sql = DB::table('reservations')
->selectRaw('count(date) as numberofreservations, date')
->groupBy('date')
->havingRaw('numberofreservations >= ' . $max)
->get();

调试：

$sql = DB::table('reservations')
->selectRaw('count(date) as numberofreservations, date')
->groupBy('date')
->havingRaw('numberofreservations >= ' . $max)
->dd();

"select count(date) as numberofreservations, date from `reservations` group by `date` having numberofreservations >= 1"
[]