php/app/common/dao/merchant/order/OrderMerchantDao.php

<?php
/**
 * @package merchant
 *
 * @author xaboy
 * @day 2020/5/30
 *
 *
 */

namespace app\common\dao\merchant\order;


use app\common\dao\BaseDao;
use app\common\model\merchant\order\OrderMerchant;
use app\common\repositories\user\UserRepository;

class OrderMerchantDao extends BaseDao
{
    protected function getModel(): string
    {
        return OrderMerchant::class;
    }

    public function test()
    {
        return OrderMerchant::getDB()->select();
    }
    public function merchantSearch($merId, array $where, $sysDel = 0)
    {
        return OrderMerchant::getDB()
            ->where('mer_id', $merId)
            ->when(isset($where['date']) && $where['date'] !== '', function ($query) use ($where) {
                getModelTime($query, $where['date']);
            })
            ->when(isset($where['keyword']) && $where['keyword'] !== '', function ($query) use ($where) {
                $query->where('merch_no|out_trade_no|refund_no', 'like', "%" . $where['keyword'] . "%");
            })
            ->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
                $query->where('status', 1);
            })
            ->order('create_time DESC');
    }
    public function search(array $where, $sysDel = 0)
    {
        return OrderMerchant::getDB()
            ->when(isset($where['date']) && $where['date'] !== '', function ($query) use ($where) {
                getModelTime($query, $where['date']);
            })
            ->when(isset($where['keyword']) && $where['keyword'] !== '', function ($query) use ($where) {
                $query->where('merch_no|out_trade_no|refund_no', 'like', "%" . $where['keyword'] . "%");
            })
            ->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
                $query->where('status', 1);
            })
            ->order('create_time DESC');
    }
    public function updateBindstatus($uinionid, $uid)
    {
        return OrderMerchant::getDB()->where('pay_user_id', $uinionid)->update(['uid' => $uid, 'binds' => 1]);
    }
}