将集合的值转换为laravel中的键

Question

this my mysql query:

$tmp=almacen::select('nombre_empresa','oferta')->join('users','users.id','=','almacen.emp_id')->where('almacen.event_id','5')->get();

this returns several objects like these:

   ...
   App\almacen {#1948
     nombre_empresa: "Aux1",
     oferta: "Serv_1234",
   },
   App\almacen {#1947
     nombre_empresa: "Aux2",
     oferta: "Serv 12345678",
   },
  ...

i need to convert "nombre_empresa" in a key, for example

$tmp['Aux2']
this return:
"Serv 12345678"

Is it possible to do this in Laravel? or should I do it in another way?

Answer 1

Sure Laravel can handle that, check out the available collections methods. mapWithKeys is probably what you're looking for:

$mapped = $results->mapWithKeys(function ($item) {
    return [$item['nombre_empresa'] => $item['oferta']];
});

Edit: mapWithKeys rather than map

https://laravel.com/docs/5.5/collections#method-mapwithkeys