lumen 底层model

最近项目有些紧，对博客懈怠了，临时补充项目中用到的两篇，下面代码是项目中用到的 底层model ，lumen版本6.0X，贴代码：里面有多个数据库链接、分页等等很方便

<?php
/**
 * base model
 *
 * User: Faithlee
 * Date: 2020/5/18
 * Time: 下午3:16
 */

namespace App\Model;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Query\Builder as QueryBuilder;
use Illuminate\Support\Facades\DB;

class BaseModel extends Model
{
    protected $perPage = 10;

    /**
     * 分页查询方法
     *
     * @param mixed|null $where 查询判断条件
     * @param string $select 查询字段
     * @param array $orders 查询排序
     * @param int $page 查询页码
     * @param int $perPage 自定义分页大小
     * @return mixed
     */
    public function getCommonList($where = null, $select = '*', array $orders = [], int $page, int $perPage = 0)
    {
        $table = $this->getBaseTable()->select($select);
        if ($where) {
            if (!isset($where['bindingParams'])) {
                $table->where($where);
            } else {
                $table->whereRaw($where['where'], $where['bindingParams']);
            }
        }
        if ($orders) {
            foreach ($orders as $key => $value) {
                $table->orderBy($key, $value);
            }
        }
        $pageSize = $perPage ? $perPage : $this->perPage;
        return $table->paginate($pageSize, ['*'], 'page', $page)->toArray();
    }

    public function getCommonFirst($where = [], $select = '*')
    {
        $table = $this->getBaseTable();
        if (is_array($select)) {
            $table->select($select);
        } else {
            $table->selectRaw($select);
        }
        if (!isset($where['bindingParams'])) {
            $table->where($where);
        } else {
            $table->whereRaw($where['where'], $where['bindingParams']);
        }
        return $table->first();

    }

    /**
     * 插入数据
     *
     * @param $data
     * @return mixed
     */
    public function baseInsert($data)
    {
        return $this->getBaseTable()->insertGetId($data);
    }

    /**
     * 更新数据
     *
     * @param array $where
     * @param array $data
     * @return mixed
     */
    public function baseUpdate($where = [], array $data)
    {
        $table = $this->getBaseTable();
        if ($where) {
            $table->where($where);
        }

        return $table->update($data);
    }

    protected function getBaseTable()
    {
        if ($this->connection) {
            return DB::connection($this->connection)->table($this->table);
        }

        return DB::table($this->table);
    }


    public function dealPaginate(QueryBuilder $query, $page)
    {
        $data = $query->paginate($this->perPage, ['*'], 'page', $page)->toArray();

        $newData['list'] = $data['data'];
        $newData['current_page'] = $data['current_page'];
        $newData['per_page'] = $data['per_page'];
        $newData['total'] = $data['total'];
        $newData['total_page'] = ceil($data['total'] / $data['per_page']);

        return $newData;
    }


    /**
     * 查询符合条件的总条数
     * @param array $where
     * @return array
     */
    public function getCommonNum(array $where = [], array $wheres = [])
    {
        $table = $this->getBaseTable();
        if ($where) {
            if (isset($where['where'])) {
                $table->whereRaw($where['where'], $where['bindingParams']);
            } else {
                $table->where($where);
            }
        }

        if ($wheres) {
            foreach ($wheres as $key => $item) {
                $table->whereIn($key, $item);
            }
        }
        $totalNum = $table->count();
        return $totalNum;
    }

    /**
     * 求和
     * @param array $where
     * @return array
     */
    public function getSum(array $where = [],$field = '', array $wheres = [])
    {
        $table = $this->getBaseTable();
        if ($where) {
            if (isset($where['where'])) {
                $table->whereRaw($where['where'], $where['bindingParams']);
            } else {
                $table->where($where);
            }
        }

        if ($wheres) {
            foreach ($wheres as $key => $item) {
                $table->whereIn($key, $item);
            }
        }
        return $table->pluck($field)->sum();
    }

    /**
     * 根据条件查询
     * @param array $where 查询条件
     * @param string $select 查询字段
     * @param array $orders 排序规则 ['id' => 'asc', 'create_time' => 'desc']
     * @param array $likes 模糊查询 ['project_cate_name' => '2323']
     * @return mixed
     */
    public function getBaseInfo($where = [], $select = '*', array $orders = [], array $likes = [])
    {
        $table = $this->getBaseTable();
        $table->select($select);
        if (!empty($where)) {
            if (!isset($where['bindingParams'])) {
                $table->where($where);
            } else {
                $table->whereRaw($where['where'], $where['bindingParams']);
            }
        }

        if (!empty($likes)) {
            foreach ($likes as $lkey => $item) {
                $table->where($lkey, 'like', '%' . $item . '%');
            }
        }

        if (!empty($orders)) {
            foreach ($orders as $key => $value) {
                $table->orderBy($key, $value);
            }
        }

        $data = $table->get()->toArray();
        return $data;
    }

    /**
     * 获取单条记录
     * @param array $where
     * @param string $select
     * @return Model|\Illuminate\Database\Query\Builder|object|null
     */
    public function getInfoRow(array $where = [], $select = '*', array $orders = [])
    {
        $table = $this->getBaseTable();
        $table->select($select);

        if (!empty($where)) {
            if(isset($where['where'])){
                $table->whereRaw($where['where'], $where['bindingParams']);
            }else {
                $table->where($where);
            }
        }
        if ($orders) {
            foreach ($orders as $key => $value) {
                $table->orderBy($key, $value);
            }
        }
        return $table->first();
    }

    /**
     * 查询某个字段的最大值
     * @param array $where
     * @param string $column
     * @return bool|mixed
     */
    public function getMaxValue(array $where = [], string $column = '')
    {
        if (empty($column)) {
            return false;
        }

        $table = $this->getBaseTable();

        if (!empty($where)) {
            $table->where($where);
        }

        return $table->max($column);
    }

    /**
     * whereIn 批量修改
     * @param array $where
     * @param array $update
     * @return int
     */
    public function baseUpdateBatch(array $where = [], $update = [])
    {
        $table = $this->getBaseTable();

        if ($where) {
            foreach ($where as $key => $item) {
                $table->whereIn($key, $item);
            }
        }

        return $table->update($update);
    }

    /**
     * 基本删除
     * @param array $where
     */
    public function baseDelete(array $where = [])
    {
        $table = $this->getBaseTable();
        return $table->where($where)->delete();
    }

    /**
     * 批量插入数据
     *
     * @param $data
     * @return mixed
     */
    public function patInsert($data)
    {
        return $this->getBaseTable()->insert($data);
    }

    /**
     * 改变数据库连接
     * 同一model中需要操作两个数据库中的表
     * @param string $dbName 数据库名称
     * @param string $table 表明
     * @return bool|QueryBuilder
     */
    protected function changeDbTable(string $dbName = '', string $table = '')
    {
        try {
            return DB::connection($dbName ? $dbName : $this->changeConnection)->table($table ? $table : $this->changeTable);
        } catch (\Exception $e) {
            return false;
        }
    }

    /**
     * 批量获取信息
     * @param array $where
     * @param string $select
     * @param array $orders
     * @return array
     */
    public function getInfoBatch(array $wheres, array $where, $select = '*', array $orders = [], $page = 0, $pageSize = 0)
    {
        $table = $this->getBaseTable()->select($select);

        if ($wheres) {
            foreach ($wheres as $key => $item) {
                $table->whereIn($key, $item);
            }
        }

        if ($where) {
            $table->where($where);
        }

        if ($orders) {
            foreach ($orders as $key => $value) {
                $table->orderBy($key, $value);
            }
        }

        if ($page) {
            $pageSize = $pageSize ? $pageSize : $this->perPage;
            return $table->paginate($pageSize, ['*'], 'page', $page)->toArray();
        }

        return $table->get()->toArray();
    }


}