ProductGroupUserDao.php 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2020 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\common\dao\store\product;
  12. use app\common\dao\BaseDao;
  13. use app\common\model\store\product\ProductGroupUser;
  14. class ProductGroupUserDao extends BaseDao
  15. {
  16. public function getModel(): string
  17. {
  18. return ProductGroupUser::class;
  19. }
  20. public function successUser($id)
  21. {
  22. $query = ProductGroupUser::hasWhere('groupBuying',function($query){
  23. $query->where('status',10);
  24. });
  25. $query->where('ProductGroupUser.product_group_id',$id);
  26. return $query->setOption('field',[])->field('nickname,avatar')->select();
  27. }
  28. public function updateStatus(int $groupId)
  29. {
  30. return $this->getModel()::getDb()->where('group_buying_id',$groupId)->update(['status' => 10]);
  31. }
  32. public function groupOrderIds($productGroupId)
  33. {
  34. return ProductGroupUser::getDB()->where('group_buying_id', $productGroupId)->where('order_id', '>', 0)->column('order_id');
  35. }
  36. }