public function scopeSummary($query, $begin_date, $end_date)
{
return $query->select([
'goods_code',
'goods_name',
'unit',
DB::raw("MIN(beginning_balance) as beginning_balance"),
DB::raw('SUM(entering) AS entering'),
DB::raw('SUM(spending) AS spending'),
DB::raw('SUM(compliance) AS compliance'),
DB::raw('MAX(final_balance) as final_balance'),
DB::raw('SUM(stock_opname) AS stock_opname'),
DB::raw('MAX(difference) as difference'),
])
->where([
['mutation_date', '>=', $begin_date],
['mutation_date', '<=', $end_date],
])
->groupBy([
'goods_code',
'goods_name',
'unit'
])
->orderBy('goods_code', 'asc');
}

$models::summary($data['begin_date'], $data['end_date'])->paginate(20);

production.ERROR: SQLSTATE[HY000] [2002] Connection refused (SQL: select count(*) as aggregate from (select `goods_code`, `goods_name`, `unit`, MIN(beginning_balance) as beginning_balance, SUM(entering) AS entering, SUM(spending) AS spending, SUM(compliance) AS compliance, MAX(final_balance) as final_balance, SUM(stock_opname) AS stock_opname, MAX(difference) as difference from `mutation_bbp` where (`mutation_date` >= 2018-09-11 and `mutation_date` <= 2020-09-11) group by `goods_code`, `goods_name`, `unit`) as `aggregate_table`) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 2002): SQLSTATE[HY000] [2002] Connection refused (SQL: select count(*) as aggregate from (select `goods_code`, `goods_name`, `unit`, MIN(beginning_balance) as beginning_balance, SUM(entering) AS entering, SUM(spending) AS spending, SUM(compliance) AS compliance, MAX(final_balance) as final_balance, SUM(stock_opname) AS stock_opname, MAX(difference) as difference from `mutation_bbp` where (`mutation_date` >= 2018-09-11 and `mutation_date` <= 2020-09-11) group by `goods_code`, `goods_name`, `unit`) as `aggregate_table`) at /var/www/web/vendor/laravel/framework/src/Illuminate/Database/Connection.php:671)