laravel convert sql to eloquent query

Question

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

Dhanu Kanakala · Accepted Answer · 2017-09-04 14:39:10Z

1

Thanks to all I found one solution in eloquent query,i.e.,

DB::table('tbl_trips as t')->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')
                    ->join(DB::raw('(select T.* from(SELECT * FROM tbl_trip_status ORDER BY id DESC) T group by T.trip_id) ts'),'ts.trip_id', '=', 't.id')
                    ->join('tbl_container as c', 'c.id', '=', 't.container_id')
                    ->join('tbl_shipment as s', 's.id', '=', 't.shipment_id')
                    ->join('tbl_statuses as ss', 'ss.id', '=', 'ts.status_id')
                    ->join('tbl_status_types as st', 'st.id', '=', 'ss.status_type')
                    ->where('t.status','=',"1")
                    ->where('t.id', '=', 'ts.trip_id')
                    ->whereIn('t.user_id',$subusrs)
                    ->paginate(10);

Thats all..

answered Sep 4, 2017 at 14:39

Dhanu Kanakala

12.5k6 gold badges27 silver badges42 bronze badges

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

1 Comment

Gayan Over a year ago

you should consider accepting your answer since you found the solution.

Mayank Pandeyz · Accepted Answer · 2017-09-04 13:54:05Z

0

I think the issue is, after getting the data from your query, you have converted that Std Class Object to an array that's why the error you are getting.

Try this:

$data = DB::select(DB::raw('your query'));

here $data is an Std Class Object on which you can call the paginate functions.

Reference

answered Sep 4, 2017 at 13:54

Mayank Pandeyz

26.3k4 gold badges43 silver badges61 bronze badges

1 Comment

Dhanu Kanakala Over a year ago

here also paginate(10) function showing the same call to the membered function error

Collectives™ on Stack Overflow

laravel convert sql to eloquent query

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related