Recursive postgresql query as laravel ORM

Need Help to convert this query to laravel Eloquent Query

DB::select('with recursive rel_tree as ( select id,type, file_type, name::TEXT, created_at,description,status, parent,array[id] as path_info from tbl_documents where type =\'file\' AND department_id=:deptId AND deleted_at is null AND name ILIKE :name union all select c.id, c.type, c.file_type, c.name::TEXT, c.created_at, c.description,c.status, c.parent, p.path_info||c.id from tbl_documents c join rel_tree p on c.parent = p.id WHERE deleted_at is null ) select id, name,parent,type,file_type, created_at::timestamp,description,status from rel_tree',[ 'deptId' => $request->deptId , 'name' => '%' . $request->filename . '%'])

I need to implement pagination for this.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2HghwfU
via IFTTT