1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / api.kitchentoolsbd.com / app / Traits /
Filename : PaginationTraits.php
back
<?php

namespace App\Traits;


trait PaginationTraits
{
    public function getPaginatedData($query, $column = []): array
    {
        $page = request('page');
        $queryData = request('pagination', []);
        $current = request('current', 1);

        $page = $page ? $page : $current;

        $sortBy = array_key_exists("sortBy", $queryData) ? $queryData['sortBy'] : [];
        $sortDesc = array_key_exists("sortDesc", $queryData) ? $queryData['sortDesc'] : [];
        $itemsPerPage = request('pageSize', 10);
        $search_val = request('search');

        if (count($sortDesc) > 0 && $sortDesc[0]) {
            $orderedBy = 'desc';
        } else {
            $orderedBy = 'asc';
        }
        $start = ($page - 1) * $itemsPerPage;
        if ($search_val && count($column) > 0) {
            $query->where(function ($query) use ($column, $search_val) {
                foreach ($column as $col) {
                    $query->orWhere($col, 'LIKE', '%' . $search_val . '%');
                }
            });
        }
        $pageNumber = $query->count();
        if ($sortBy && $orderedBy) {
            foreach ($sortBy as $sort) {
                $query->orderBy($sort, $orderedBy);
            }
        }
        if ($itemsPerPage && $itemsPerPage >= 0) {
            $query->skip($start)->take($itemsPerPage);
        }

        $arr_items['data'] = $query;
        $arr_items['total_records'] = $pageNumber;
        return $arr_items;
    }

}