How to fix Unknown column 'CONCAT' in laravel

Question

Work in the native query but when I turn into laravel code there is some error

I confused because my CONCAT is considered as column

$query = DB::table('bonus_produksi')
            ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
            ->select('bonus_produksi.area',
                     'CONCAT(\'Rp.\',frupiah(bonus_produksi.besaran)',
                     'bonus_areas.nama_area')->get();

Unknown column 'CONCAT('Rp.',frupiah(bonus_produksi.besaran),',00')'

Answer 1

Inform the query builder you are using a RAW statement.

$query = DB::table('bonus_produksi')
            ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
            ->select('bonus_produksi.area',
                     DB::raw("CONCAT(\'Rp.\',frupiah(bonus_produksi.besaran) as column_name"),
                     'bonus_areas.nama_area')->get();

Be sure to also include this at the top:

use DB;

Answer 2

Try the below answer

$query = DB::table('bonus_produksi')
        ->join('bonus_areas', 'bonus_produksi.area', '=', 'bonus_areas.id')
        ->selectRaw("bonus_produksi.area,
                 CONCAT('Rp.',frupiah(bonus_produksi.besaran),
                 bonus_areas.nama_area")->get();