123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143 |
- <?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\StoreBargain;
- /**
- * 砍价商品
- * Class StoreBargainDao
- * @package app\dao\activity\bargain
- */
- class StoreBargainDao extends BaseDao
- {
- /**
- * 设置模型
- * @return string
- */
- protected function setModel(): string
- {
- return StoreBargain::class;
- }
- /**
- * @param array $where
- * @return \crmeb\basic\BaseModel|mixed|\think\Model
- */
- public function search(array $where = [])
- {
- return parent::search($where)
- ->when(isset($where['start_status']) && $where['start_status'] !== '', function ($query) use ($where) {
- $time = time();
- switch ($where['start_status']) {
- case -1:
- $query->where('stop_time', '<', $time);
- break;
- case 0:
- $query->where('start_time', '>', $time);
- break;
- case 1:
- $query->where('start_time', '<=', $time)->where('stop_time', '>=', $time);
- break;
- }
- });
- }
- /**
- * 获取砍价列表
- * @param array $where
- * @param int $page
- * @param int $limit
- * @return array
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\DbException
- * @throws \think\db\exception\ModelNotFoundException
- */
- public function getList(array $where, int $page = 0, int $limit = 0)
- {
- return $this->search($where)->when($page != 0 && $limit != 0, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order('sort desc,id desc')->select()->toArray();
- }
- /**
- * 获取活动开启中的砍价id以数组形式返回
- * @param array $ids
- * @param array $field
- * @return array
- */
- public function getBargainIdsArray(array $ids, array $field = [])
- {
- return $this->search(['is_del' => 0, 'status' => 1])->where('start_time', '<=', time())
- ->where('stop_time', '>=', time())->whereIn('product_id', $ids)->column(implode(',', $field), 'product_id');
- }
- /**
- * 根据id获取砍价数据
- * @param array $ids
- * @param string $field
- * @return array
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\DbException
- * @throws \think\db\exception\ModelNotFoundException
- */
- public function idByBargainList(array $ids, string $field)
- {
- return $this->getModel()->whereIn('id', $ids)->field($field)->select()->toArray();
- }
- /**
- * 正在开启的砍价活动
- * @param int $status
- * @return StoreBargain
- */
- public function validWhere(int $status = 1)
- {
- return $this->getModel()->where('is_del', 0)->where('status', $status)->where('start_time', '<', time())->where('stop_time', '>', time());
- }
- /**
- * 砍价列表
- * @param int $page
- * @param int $limit
- * @return array
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\DbException
- * @throws \think\db\exception\ModelNotFoundException
- */
- public function bargainList(int $page = 0, int $limit = 0)
- {
- return $this->search(['is_del' => 0, 'status' => 1])
- ->where('start_time', '<=', time())
- ->where('stop_time', '>=', time())
- ->where('product_id', 'IN', function ($query) {
- $query->name('store_product')->where('is_show', 1)->where('is_del', 0)->field('id');
- })->with('product')->when($page && $limit, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order('sort DESC,id DESC')->select()->toArray();
- }
- /**
- * 修改砍价状态
- * @param int $id
- * @param string $field
- * @return mixed
- */
- public function addBargain(int $id, string $field)
- {
- return $this->getModel()->where('id', $id)->inc($field, 1)->update();
- }
- }
|