laravel - change value in array for API Resources

Question

{
"data": {
   "username": "candy",
   "certificates": [
   {
   "id": 11,
   "category_id": 1,
   "certname": "cert name test",
   "created_at": "2018-08-18 00:58:12",
   "updated_at": "2018-08-18 00:58:12"
   }
   ]
 }
}

Above is a response by using Eloquent: API Resources.

I would like to put category name instead of category_id.

Below is resource class

    public function toArray($request)
{
    return [
        'nickname' => $this->nickname,
        'certificates' => $this->certificates,
    ];
}

certificates are in array (hasMany relationship)

certificates belongsTo category

Not really sure what you’re asking here... what are you trying to do? — Zoe Edwards
– Zoe Edwards, Commented Sep 25, 2018 at 11:33
Use laravel.com/docs/5.7/eloquent-resources or when you’re in the controller, use a map() on the collection to rebuild the array laravel.com/docs/5.7/collections#method-map — Zoe Edwards
– Zoe Edwards, Commented Sep 25, 2018 at 11:58

Tharaka Dilshan · Accepted Answer · 2018-09-25 13:19:44Z

2

In this case, in the resource class you can fetch category name for each certificate and attach it.

public function toArray($request)
{

    $certificateList = $this->certificates;

    foreach($certificateList as $ceritificate) {

         // fetch only the category name from the database.
         // attach to the certificate.

         $categoryName = Category::where('id', $certificate->category_id)->pluck('name')->first();
         $certificate->setAttribute('category_name, $categoryName);
    }

    // then as usual
    return [
         'nick_name' => $this->nick_name,
         'certificates' => $certificateList
    ];
}

answered Sep 25, 2018 at 13:19

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wwwrrrxxx Over a year ago

thanks. I slightly modified your code and solved my issue.

Pushpak Bhoir · Accepted Answer · 2018-09-25 11:58:41Z

0

This Might Help, Run a foreach loop

$category = "Your SELECT Query";
foreach ($category as $value) {
               $categoryId = json_decode($value->category_id);
               $x = Category::select('certname')->whereIn('id', $categoryId)->get();
               foreach ($x as $as) {
                   $y[] = $as->certname;
               }
               $value->certname = $y;

answered Sep 25, 2018 at 11:58

Pushpak Bhoir

113 bronze badges

Comments

aitbella · Accepted Answer · 2019-01-29 16:57:32Z

0

you can just do it like this

in controler

 return    CertificateResource::collection(Certificate::with('category')->get());

in CertificateResource

 return [
    'nickname' => $this->nickname,
    'certificates' => $this->certificates,
    'category_name'=>$this->whenLoaded('category', function () {
            return $this->category->category_name;
        }),
];

answered Jan 29, 2019 at 16:57

aitbella

1,10511 silver badges20 bronze badges

Collectives™ on Stack Overflow

laravel - change value in array for API Resources

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related