Forum Eloquent Mutator + DB::raw

santiagogg

posted 10 years ago

Database Eloquent

Last updated 2 years ago.

hailwood

replied 10 years ago

A getter acts on the value that has been pulled from the database only when the field is requested. This means that the value has already been retrieved by the time the getter fires.

Last updated 2 years ago.

santiagogg

replied 10 years ago

Thanks for answering... Any suggestion of doing this with Eloquent or do you recommend go to Repository Pattern and define All()/ find() /etc...? I really want to stay on Eloquent.

Last updated 2 years ago.

santiagogg

replied 10 years ago

Solution

I find a solution that works for my situation and I share it here.

public function newQuery($excludeDeleted = true)
{
    return parent::newQuery()->addSelect('*',DB::raw('asText(position) wkt'));
}

// I added $append = ['wkt']; & hidden= ['position']

If you think it could be better let me know

Last updated 2 years ago.