zw-api/app/extra/basic/Service.php

<?php

namespace app\extra\basic;

use app\model\system\SystemConfig;

class Service
{

    protected $mode = null;


    /**
     * 白名单
     * @var array|string[]
     */
    protected array $mobileWhite = [];



    /**
     * 默认排序筛选
     * @param array $param
     * @param string $prefix
     * @param array $filter
     * @return string[]
     */
    public function defaultSort(array $param = [],string $prefix = "",array $filter = []): array
    {
        if (!empty($prefix)) $prefix = $prefix.".";
        if (isset($param['order']) && $param['order'] == 'descending'){
            $orderBy = ["{$prefix}{$param['field']}" => "desc"];
        } else if (isset($param['order']) && $param['order'] == 'ascending'){
            $orderBy = ["{$prefix}{$param['field']}" => "asc"];
        } else {
            $orderBy = ["{$prefix}create_at" => "desc"];
        }
        return $orderBy;
    }


    /**
     * @param array $param 参数
     * @param array $filter 过滤器
     * @param string $prefix 链表前缀
     * @param string $join 链表表名
     * @param string $field 字段
     * @param string $forKey 链表首字母
     * @param string $localKey 被链表首字母
     */
    protected function searchVal(array $param = [],array $filter = [],string $prefix = "",string $join = "",string $field = "",string $forKey = "",string $localKey = "")
    {
        $orderBy = $this->defaultSort($param,$prefix);
        $commonFilter = [];
        // 起止时间
        if (!empty($param['create'])) {
            $times = between_time($param['create']);
            $start = date('Y-m-d',$times['start_time']);
            $end = date('Y-m-d',($times['end_time'] + 86400));
            $commonFilter[] = ['create_at', '>=', $start ];
            $commonFilter[] = ['create_at', '<', $end ];
        }
        $filter = array_merge($filter,$commonFilter);
        if (!empty($join)) {
            $this->mode =  $this->mode->alias('a')->join("{$join} {$prefix}","a.{$forKey} = {$prefix}.{$localKey}")->field($field);
        }
        return $this->mode->order($orderBy)->where($filter);
    }


    /**
     *
     */
    public function getList(array $param = [],$with = null,bool $page = true,array $append = [],$withAttr = null)
    {
        $model = $this->searchVal($param,$this->searchFilter($param));
        // 支持多种类型的 $with 参数
        if ($with !== null) {
            if (is_callable($with)) {
                $with($model);
            } elseif (is_string($with) || is_array($with)) {
                $model->with($with);
            }
        }
        // 3. 动态设置修改器（withAttr）
        if ($withAttr !== null) {
            $model->withAttr($withAttr);
        }
        if (!empty($append)) {
            $model->append($append);
        }
        if ($page) {
            $resp = $model->paginate([
                "list_rows" => $param['pageSize'],
                "page"      => $param['page']
            ]);
        } else {
            $resp = $model->select()->toArray();
        }
        return $resp;
    }

}