How to appending a column db result with relation and some logic laravel

Question

I have a problem here, I want to add one column from the result of the relation, namely the percentage column, this column is the result of pagebook / pageread * 100 this is my result db what I want

"id": 2,
    "id_book": 2,
    "id_user": 2,
    "pageread": 120,
    "books": {
                "id": 2,
                "pagebook":125
             }
    "percentage":96

this is my code in controller

$book= Read::with('books.authors')->where('id_user',$user->id)->get();

and this my code in model

public function books()
    {
        return $this->belongsTo(Book::class,'id_book','id');
    }

Look into resources: laravel.com/docs/8.x/eloquent-resources#introduction they allow you to include such info — Maarten Veerman
– Maarten Veerman, Commented May 1, 2021 at 14:15

Alberto · Accepted Answer · 2021-05-01 14:16:32Z

1

you can do it in the model:

class YourModel ...{
    protected $appends = ['percentage'];
    public function getPercentageAttribute()
    {
        return /* the calculation that you need */
    }
}

answered May 1, 2021 at 14:16

Alberto

13.1k3 gold badges31 silver badges72 bronze badges

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

2 Comments

Newbie 123 Over a year ago

how can i send parameter book->pagebook and pageread to getPercentageAttribute for calculate?

Alberto Over a year ago

@Newbie123 same way you would have done in a controller or anywhere else

Newbie 123 · Accepted Answer · 2021-05-01 14:58:21Z

0

 protected $appends = ['percentage'];
    public function getPercentageAttribute()
    {
        $read= $this->pageread;
        $book= $this->books->pagebook
        return $read/$book*100


    }

answered May 1, 2021 at 14:58

Newbie 123

2741 gold badge8 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to appending a column db result with relation and some logic laravel

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related