->select
(
'a.status as status',
'b.name as customer_name',
'e.name as branch_name' ,
'c.name as company_name',
'd.name as project_name',
'f.name as region_name',
'e.code as branch_code',
'e.id as branch_code',
DB::raw('COUNT(a.id) as total_transaksi')
)
->groupBy
(
'e.id',
'b.name',
'e.name',
'e.code',
'a.status',
'c.name',
'd.name',
'f.name'
) 
2
0
0
這是不正確的，您不能對同一列使用單個名稱，
'e.code as branch_code', 'e.id as branch_code',
更改為
'e.code as branch_code', 'e.id as branch_id',
![[Web-Frontend] Node.js-Schnellstart](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
