php/app/common/dao/user/UserExtractDao.php

<?php
/**
 * @package merchant
 *
 * @author Qinii
 * @day 2020-06-16
 *
 *
 */
namespace app\common\dao\user;

use app\common\dao\BaseDao;
use app\common\model\user\UserExtract as model;

class UserExtractDao extends  BaseDao
{
    protected function getModel(): string
    {
        return model::class;
    }

    public function serach(array $where)
    {
        return ($this->getModel()::getDB())->when(isset($where['uid']) && $where['uid'] != '',function($query)use($where){
            $query->where('uid',$where['uid']);
        })->when(isset($where['extract_type']) && $where['extract_type'] != '',function($query)use($where){
            $query->where('extract_type',$where['extract_type']);
        })->when(isset($where['keyword']) && $where['keyword'] != '',function($query)use($where){
            $query->where(function($query)use($where){
                $query->where('real_name','like','%'.$where['keyword'].'%')
                    ->whereOr('bank_code','like','%'.$where['keyword'].'%')
                    ->whereOr('alipay_code','like','%'.$where['keyword'].'%')
                    ->whereOr('wechat','like','%'.$where['keyword'].'%');
            });
        })->when(isset($where['status']) && $where['status'] != '',function($query)use($where){
            $query->where('status',$where['status']);
        })->when(isset($where['real_name']) && $where['real_name'] != '',function($query)use($where){
            $query->where('real_name','%'.$where['real_name'].'%');
        })->when(isset($where['date']) && $where['date'] != '',function($query)use($where){
            getModelTime($query, $where['date']);

        })->when(isset($where['mer_id']),function($query)use($where){
            if($where['mer_id']==""){
                $query->where('mer_id',$where['mer_id'])->whereOr('mer_id is null');
            }else{
                $query->where('mer_id',$where['mer_id']);
            }

        });
    }
    public function countmoyer(array $where)
    {
        return ($this->getModel()::getDB());
    }
}