123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 |
- <?php
- declare (strict_types=1);
- namespace app\dao\activity;
- use app\dao\BaseDao;
- use app\model\activity\StoreActivity;
- class StoreActivityDao extends BaseDao
- {
-
- protected function setModel(): string
- {
- return StoreActivity::class;
- }
-
- protected function search(array $where = [])
- {
- return parent::search($where)->when(isset($where['activityTime']), function ($query) use ($where) {
- [$startTime, $stopTime] = is_array($where['activityTime']) ? $where['activityTime'] : [time(), time() - 86400];
- $query->where('start_day', '<=', $startTime)->where('end_day', '>=', $stopTime);
- })->when(isset($where['start_status']) && $where['start_status'] !== '', function ($query) use ($where) {
- $time = time();
- switch ($where['start_status']) {
- case -1:
- $query->where(function ($q) use ($time) {
- $q->where('end_day', '<', $time - 86400)->whereOr('status', '0');
- });
- break;
- case 0:
- $query->where('start_day', '>', $time)->where('status', 1);
- break;
- case 1:
- $query->where('start_day', '<=', $time)->where('end_day', '>=', $time - 86400)->where('status', 1);
- break;
- }
- });
- }
-
- public function getList(array $where, string $field = '*', int $page = 0, int $limit = 0, array $with = [], string $order = 'start_time asc, id desc')
- {
- return $this->search($where)->field($field)
- ->when($with, function ($query) use ($with) {
- $query->with($with);
- })->when($page != 0 && $limit != 0, function ($query) use ($page, $limit) {
- $query->page($page, $limit);
- })->order($order)->select()->toArray();
- }
-
- public function checkActivity(array $where)
- {
- return $this->search($where)->where('end_day', '>', time())->count() > 0;
- }
- }
|