我想按名稱按表分組并選擇名稱和日期，對于具有相同值的名稱具有不同的日期值，我試過這個但不起作用：
public function period(Request $req)
{
$absences = Absence::whereBetween('date', [$req->from, $req->to])->get();
$daily = $absences->select('name ','date', 'COUNT(date) as counts');
$arr['absences'] = $absences;
$arr['daily'] = $daily;
$arr['from'] = $req->from;
$arr['to'] = $req->to;
return $arr;
return view('period',$arr,);
}
我得到錯誤： Method Illuminate\Database\Eloquent\Collection::select does not exist.
當我使用它時：
public function period(Request $req)
{
$absences = Absence::selectraw('name , date')->whereBetween('date', [$req->from, $req->to])->groupBy('name')->get();
$arr['absences'] = $absences;
$arr['from'] = $req->from;
$arr['to'] = $req->to;
//return $arr;
return view('period',$arr,);
}
我明白了：
SQLSTATE[42000]：語法錯誤或訪問沖突：1055 SELECT 串列的運算式 #2 不在 GROUP BY 子句中，并且包含非聚合列“absences.absences.date”，該列在功能上不依賴于 GROUP BY 子句中的列；這與 sql_mode=only_full_group_by 不兼容（SQL: select name , date from
absenceswheredatebetween 2021-10-02 and 2021-10-12 group byname）
uj5u.com熱心網友回復：
你能試試這個嗎？我認為問題是您忘記按您選擇的（非聚合）列進行分組。
$daily = Absence::query()
->select('name', 'date')
->selectRaw('count(date) as counts')
->whereBetween('date', [$req->from, $req->to])
->groupBy('name', 'date')
->get();
dd($daily);
uj5u.com熱心網友回復：
select 子句中的所有列也應該在 gorup by 中，這是 mysql 中的嚴格模式。如果要更改它，請轉到 config/database.php 并將其設定為 false：
'mysql' => [
'driver' => 'mysql',
'url' => env('DATABASE_URL'),
'host' => env('DB_HOST', '127.0.0.1'),
'port' => env('DB_PORT', '3306'),
'database' => env('DB_DATABASE', 'forge'),
'username' => env('DB_USERNAME', 'forge'),
'password' => env('DB_PASSWORD', ''),
'unix_socket' => env('DB_SOCKET', ''),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'prefix_indexes' => true,
'strict' => false, // instead of true
'engine' => null,
'options' => extension_loaded('pdo_mysql') ? array_filter([
PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
]) : [],
],
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/312830.html
下一篇：Laravel/Eloquent：如何在Larvael`->whereNotExists`子查詢中參考外部選擇的列？