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

namespace app\common\dao\merchant\order;


use app\common\dao\BaseDao;
use app\common\model\user\User;
use app\common\model\merchant\order\OrderGzc;

class OrderGzcDao extends BaseDao
{
    protected function getModel(): string
    {
        return OrderGzc::class;
    }
    public function search(array $where, $sysDel = 0)
    {
        return OrderGzc::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('user_name|mobile|user_card', 'like', "%" . $where['keyword'] . "%");
            })
            ->when(isset($where['account']) && $where['account'] !== '', function ($query) use ($where) {
                $uid = User::where('account|nickname|phone', 'like', "%{$where['account']}%")
                    ->column('uid');
                $query->where('uid', 'in', $uid);
            })
            ->when(isset($where['status']) && $where['status'] !== '', function ($query) use ($where) {
                $query->where('gzc', $where['status']);
            })
            ->where('pension', '>', 0)
            ->whereNotIn('uid', [766, 783]);
    }
    public function updateBindstatus($uinionid, $uid)
    {
        return OrderGzc::getDB()->where('pay_user_id', $uinionid)->update(['uid' => $uid, 'binds' => 1]);
    }
}