owl-admin/app/Services/ViewService.php

<?php

namespace App\Services;

use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Log;

/**
 * 视图管理
 */
class ViewService
{
    /**
     * 获取视图列表
     *
     * @param  array  $params  查询参数
     */
    public function viewList($viewName, array $whereParams, array $pageParams, array $sortParams = [])
    {
        try {
            $query = DB::table($viewName);

            // 获取分页数据
            // 条件筛选
            foreach ($whereParams as $key => $value) {
                if (is_string($value)) {
                    $query->where($key, 'like', "%{$value}%");
                } else {
                    $query->where($key, $value);
                }
            }

            // 排序
            ! empty($sortParams) && $query->orderBy($sortParams['orderBy'], $sortParams['orderDir']);

            $result = $query->paginate($pageParams['perPage'], ['*'], 'page', $pageParams['page']);

            return response()->json([
                'code' => 200,
                'message' => 'success',
                'data' => $result,
            ]);

        } catch (\Exception $e) {
            Log::error('获取用户列表失败：'.$e->getMessage());

            return response()->json([
                'code' => 500,
                'message' => '获取用户列表失败',
            ]);
        }
    }
}