CODEWITHSUNDEEP
mysqllaravellaravel-query-builder
Saleem Hakeem
Saleem Hakeem

Reputation: 33

Please How can I convert sql query into laravel query

I need to convert this sql query into laravel query builder or how can I run into laravel as it is.

SELECT rt.id, rt.type, rt.total_no_of_rooms,IFNULL(SUM(r.no_of_rooms), 0) as "reserved rooms", rt.total_no_of_rooms - IFNULL(SUM(r.no_of_rooms),0) as "rooms available" FROM Rooms rt LEFT OUTER JOIN Reservations r ON r.roomtype_id = rt.id  AND  '2020-04-04' >=  r.check_in AND  '2020-04-02' <=  r.check_out GROUP BY rt.id, rt.type, rt.total_no_of_rooms

Upvotes: 0

Views: 34

Answers (1)

Mondini
Mondini

Reputation: 610

how can I run into laravel as it is.

There is this approach:

$query= DB::select( DB::raw("SELECT rt.id, rt.type, rt.total_no_of_rooms,IFNULL(SUM(r.no_of_rooms), 0) as 'reserved rooms', rt.total_no_of_rooms - IFNULL(SUM(r.no_of_rooms),0) as 'rooms available' FROM Rooms rt LEFT OUTER JOIN Reservations r ON r.roomtype_id = rt.id  AND  '2020-04-04' >=  r.check_in AND  '2020-04-02' <=  r.check_out GROUP BY rt.id, rt.type, rt.total_no_of_rooms"));

It will simply run the query. You can foreach the $query now.

Upvotes: 1

Related Questions