xny/app/common/dao/openapi/OpenAuthDao.php

<?php

// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者，助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2024 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件，未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------

namespace app\common\dao\openapi;

use app\common\model\openapi\OpenAuth;
use app\common\dao\BaseDao;

class OpenAuthDao extends BaseDao
{

    protected function getModel(): string
    {
        return OpenAuth::class;
    }

    /**
     * 查询按照创建时间排序
     * @param array $where
     * @return mixed
     * @author wuhaotian
     * @email 442384644@qq.com
     * @date 2024/7/13
     */
    public function search(array $where)
    {
        $query = $this->getModel()::getDB()
            ->when(isset($where['type']) && $where['type'] !== '',function($query) use($where){
                $query->where('type',$where['type']);
            })
            ->when(isset($where['mer_id']) && $where['mer_id'] !== '',function($query) use($where){
                $query->where('mer_id',$where['mer_id']);
            });
        $query->order('create_time DESC');
        return $query;
    }
}