convert query builder to eloquent

Is there a way to transform this query builder to eloquent ?

$products = DB::select("SELECT *,
(CASE
WHEN datediff(expire_date,CURDATE()) > 0 then datediff(expire_date,CURDATE())
ELSE 'Expired'
END) as remaining from products");

bobbybouwmann

6 years ago

Best Answer

Level 88

You can do something like this

$products = Product::select([
    '*',
    DB::raw('(CASE WHEN datediff(expire_date,CURDATE()) > 0 then datediff(expire_date,CURDATE()) ELSE 'Expired' END) as remaining'))
])->get();

This should do the trick for you.

bekaskaki

6 years ago

Level 1

it works Thank you

Please or to participate in this conversation.