Laravel hide or remove some database column data from result

Question

in Laravel API i have some method which they are return some fields which i don't want to have in result, for example:

id  -  email  -  user_id

and they are optional and i can't set this fields into self models, now i'm using this class as ManageResource to hode/remove fields/columns from result like this code:

$user = User::whereApiToken($request->api_token)->first();
$result = ManageResource::make($user)->hide(['id','email']);

after using this code that implemented by below class i get only id and email on array keys, but i want to hide them

ManageResource class:

namespace App\Http\Resources;
use Illuminate\Http\Resources\Json\Resource;

class ManageResource extends Resource
{
    /**
     * @var array
     */
    protected $withoutFields = [];

    /**
     * Transform the resource into an array.
     *
     * @param  \Illuminate\Http\Request
     * @return array
     */
    public function toArray($request)
    {
        return $this->filterFields($this->withoutFields);
    }

    /**
     * Set the keys that are supposed to be filtered out.
     *
     * @param array $fields
     * @return $this
     */
    public function hide(array $fields)
    {
        $this->withoutFields = $fields;
        return $this;
    }

    /**
     * Remove the filtered keys.
     *
     * @param $array
     * @return array
     */
    protected function filterFields($array)
    {
        return collect($array)->toArray();
    }
}

Answer 1

As you would like to make some typically visible attributes hidden on a given model instance, you may use the makeHidden method.

return $user->makeHidden('attribute')->toArray();

Here, $user represents user model

Example Case : use makeHidden with code to hide column in pagination result

$result = Job::where('user_id','=',Auth::id())->paginate(5);
$data =$result;
$result= $result->makeHidden(['hasMessage']);
$data->data = $result;
return $data;

In Your case :

$result = ManageResource::make($user)->makeHidden(['id','email'])->toArray();
$data->data = $result;
return $data;

or

$result = User::whereApiToken($request->api_token)->first()->setHidden(['id', 'email']);
$data->data = $result;
return $data;

Note :

As far as I'm aware, makeHidden doesn't affect relations. It would have been good if it allowed you to specify attributes in relations as -makeHidden(['relation.field']). Alternatively you can use following code

App\Models\Product::with(['images' => function ($query) {             
 $query->select(['id','product_id','image_url',   
'row_id'])->orderBy('created_at', 'desc');                            
}])->get()->makeHidden(['id']);

In your case

$tickets = UserTickets::with(['user', 'reply' => function ($query) use ($user) {
    $query->with('user')->select(['id','Attrib1','Attrib2'])->whereUserId($user->id);
}])->whereTicketNumber($request->ticket_number)->get();

Answer 2

You can use map filter to get the desired fields.

$events= Events::where(['id' => 1])->get()
            ->map(function ($event) {
                return [
                    'id' => $event->id,
                    'title' => $event->title,
                    'target' => $event->specific,
                    'date' => $event->start . '-' . $event->end,
                    'created' => $event->created_at
                ];
            });