->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'
)
Go to config/database.php
Strictly set to false
This is incorrect, you cannot use a single name for the same column,
change to