Lines Matching refs:query
120 …* @param Builder $query A query to fetch the unfiltered rows and columns.
127 …public function handleQuery(ServerRequestInterface $request, Builder $query, array $search_columns… argument
136 $recordsTotal = (clone $query)->count();
140 $query->where(static function (Builder $query) use ($search, $search_columns): void {
145 $query->orWhere($search_column, 'LIKE', $like);
158 $query->orderBy($sort_column, $value['dir']);
161 $query->orderBy(new Expression(1));
166 $recordsFiltered = (clone $query)->count();
168 $query->skip($start)->limit($length);
169 $data = $query->get();
171 $data = $query->get();