Tp5.1 join的封装以及多表查询

封装代码:

Tp5.1 join的封装以及多表查询
 /**
     * join查询
     *
     * @param $request
     * @param $data //存放查询条件、字段、排序的 数组
     * @param $data [‘join‘]      连接对象  " 表名 b "
     * @param $data [‘condition‘] 连接条件  " a.id = b.classId "
     * @param $data [‘where‘]     查询条件  " [ a.id => $id ,b.name => ‘test‘ ] "
     * @param $data [‘field‘]     查询字段  " a.id,title,class_id , b.id,name "
     * @param $data [‘order‘]     排序      " a.id desc "
     * @param $type //left right join
     * @param $return 1: 纯数据格式  2: api标准参数格式
     * return
     */
    public function _joinList($request, $data, $type = ‘‘, $return = 2)
    {
        $page = $request->page ?? 1;
        $limit = $request->limit ?? 5;

        $list = self::alias(a)                     //主表为 a
        ->join($data[join], $data[condition] ?? ‘‘, $type)
            ->where($data[where] ?? [a.status => 1])
            ->field($data[field])
            ->order($data[order] ?? a.id desc)
            ->select()->toArray();

        $start = $limit * ($page - 1);
        $data = array_slice($list, $start, $limit);   // 第n页 第n条 数据
        $total = count($list);

        if (!$total)
            failApi(无数据, 0, 204)->send();

        if ($return == 2)
            return arrayApi(count($data), $data, success!!, fail!!, $total);
        else
            return $data;
    }
View Code

 

使用:(三表查询)

Tp5.1 join的封装以及多表查询
public function list()     // 展示
    {
        $admin = new Admin();

        $data = [
            ‘join‘ => [[‘role b‘,‘a.role_id = b.id‘,‘right‘],[‘admin_log c‘,‘a.id = c.admin_id‘,‘right‘]],
            ‘field‘ => ‘a.username,account,b.title,c.content,c.create_time‘,
            ‘order‘ => ‘c.create_time desc‘
        ];
        $this->request->limit = 10;
        $res = $admin->_joinList($this->request, $data);
        return json($res);
View Code

 

Tp5.1 join的封装以及多表查询

上一篇:harbor 构建企业级镜像仓库


下一篇:etcd集群部署