lundi 4 septembre 2017

laravel convert sql to eloquent query

I have a sql query with joins is

select t.id,t.trip_id,c.containerid,s.shipment_name,s.source_location_name,s.destination_location_name,ss.status_name,st.status_name as status_type from 
(select T.* from(SELECT * FROM tbl_trip_status ORDER BY id DESC) T group by T.trip_id) ts
JOIN tbl_trips t ON t.id=ts.trip_id
JOIN tbl_container c ON c.id=t.container_id 
JOIN tbl_shipment s ON s.id=t.shipment_id 
JOIN tbl_statuses ss ON ss.id=ts.status_id
JOIN tbl_status_types st ON st.id=ss.status_type
where t.status=1 and t.user_id in (1,2,3,4,5,6,14)  
ORDER BY `t`.`trip_id` ASC

I need this query in eloquent mode while am trying to call paginate() with this raw query, it showing

call to membered function paginate() on array



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire