Activity.php 922 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. namespace app\common\Service;
  3. use app\common\Enum\StatusEnum;
  4. use app\common\Enum\ActivityEnum;
  5. use app\common\model\marketing\Activity as ActivityModel;
  6. use app\common\model\marketing\ActivitySkuPrize as ActivitySkuPrizeModel;
  7. class Activity
  8. {
  9. // 获取当前时间 有活动的商品
  10. public function getActivityGoods()
  11. {
  12. $now = time();
  13. $activityIds = ActivityModel::where('start_time', '<=', $now)
  14. ->where('end_time', '>=', $now)
  15. ->where('status',StatusEnum::ENABLED)
  16. ->where('activity_status',ActivityEnum::ACTIVITY_STATUS_ONGOING)
  17. ->select();
  18. //获取对应的商品
  19. // 查询出活动中的商品数据
  20. $activityGoods = ActivitySkuPrizeModel::whereIn('activity_id',$activityIds)
  21. ->where('status',StatusEnum::ENABLED)
  22. ->select();
  23. return $activityGoods;
  24. }
  25. }