我在SQL 中創建了一個查詢，它運行良好。
SELECT learning_content_number,
course,
count(required) as required,
count(overdue) as overdue,
count(status) as status,
count(completion_date) as completion_date
FROM hse_leatros
GROUP BY learning_content_number
現在我想在Laravel 8 Eloquent 中翻譯它。此腳本有效，但我缺少有關課程的資訊。
$courses = Leatro::groupBy('learning_content_number')
->selectRaw('count(required) as required, learning_content_number')
->selectRaw('count(overdue) as overdue, learning_content_number')
->selectRaw('count(status) as status, learning_content_number')
->selectRaw('count(completion_date) as completion_date, learning_content_number')
->get();
我如何在它傳輸的代碼中輸入 ？
我的資料庫表結構：
$table->id();
$table->integer('employee_id')->nullable();
$table->string('course')->nullable();
$table->string('required')->nullable();
$table->string('mandatory')->nullable();
$table->string('status')->nullable();
$table->string('due_date')->nullable();
$table->string('completion_date')->nullable();
$table->string('overdue')->nullable();
$table->string('learning_content_number')->nullable();
$table->string('assigned_date')->nullable();
$table->string('assigned_mechanism')->nullable();
$table->string('cost_centre_id')->nullable();
$table->string('hash')->nullable();
$table->timestamps();
$table->softDeletes();
uj5u.com熱心網友回復：
你只需要添加->select('learning_content_number', 'course')：
$courses = $db::table('hse_leatros')
->groupBy('learning_content_number', 'course')
->select('learning_content_number', 'course')
->selectRaw('count(required) as required')
->selectRaw('count(overdue) as overdue')
->selectRaw('count(status) as status')
->selectRaw('count(completion_date) as completion_date')
;
echo $courses->toSql();
print_r($courses->get());
Laravel QueryBuilder 在線
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/377691.html
上一篇：在產品頁面上顯示運輸類別（可變產品）Woocommerce
下一篇：無法生成正則運算式