CRMEB_PRO_M/app/dao/activity/bargain/StoreBargainUserHelpDao.php

82 lines
2.4 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
// +----------------------------------------------------------------------
// | CRMEB [ CRMEB赋能开发者助力企业发展 ]
// +----------------------------------------------------------------------
// | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
// +----------------------------------------------------------------------
// | Licensed CRMEB并不是自由软件未经许可不能去掉CRMEB相关版权
// +----------------------------------------------------------------------
// | Author: CRMEB Team <admin@crmeb.com>
// +----------------------------------------------------------------------
declare (strict_types=1);
namespace app\dao\activity\bargain;
use app\dao\BaseDao;
use app\model\activity\bargain\StoreBargainUserHelp;
/**
* 帮助砍价
* Class StoreBargainUserHelpDao
* @package app\dao\activity\bargain
*/
class StoreBargainUserHelpDao extends BaseDao
{
/**
* 设置模型
* @return string
*/
protected function setModel(): string
{
return StoreBargainUserHelp::class;
}
/**
* 获取帮砍人数
* @return array
*/
public function getHelpAllCount(array $where = [])
{
return $this->getModel()->where($where)->group('bargain_id')->column('count(*)', 'bargain_id');
}
/**
* 获取帮砍列表
* @param int $bid
* @param int $page
* @param int $limit
* @return array
*/
public function getHelpList(int $bid, int $page = 0, int $limit = 0)
{
return $this->getModel()->with('getUser')
->where('bargain_user_id', $bid)
->order('add_time desc')
->when($page && $limit, function ($query) use ($page, $limit) {
$query->page($page, $limit);
})->field("uid,price,from_unixtime(add_time,'%Y-%m-%d %H:%i:%s') as add_time")->select()->toArray();
}
/**
* 获取砍价商品已砍人数
* @return array
*/
public function getNums()
{
return $this->getModel()->field('count(id) as num,bargain_user_id')->group('bargain_user_id')->select()->toArray();
}
/**
* 获取每个商品参与砍价人数
* @param array $where
* @param string $field
* @param string $key
* @return mixed
*/
public function getBargainPeople(array $where, string $field = '*', string $key = 'bargain_id')
{
return $this->getModel()->where($where)->group($key)->column($field, $key);
}
}