Laravel Best Practices

 https://github.com/alexeymezenin/laravel-best-practices

Laravel join query with date formatting

$complains=DB::table('complains')

         ->join('error_types','error_types.id','=','complains.error_type_id')

         ->join('complain_details','complain_details.id','=','complains.complain_detail_id')

         ->select('complains.id','complains.image',DB::raw("DATE_FORMAT(complains.created_at, '%d-%b-%Y') as date"))

         ->get();