ProductGroupUserDao.php 952 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. namespace app\common\dao\store\product;
  3. use app\common\dao\BaseDao;
  4. use app\common\model\store\product\ProductGroupUser;
  5. class ProductGroupUserDao extends BaseDao
  6. {
  7. public function getModel(): string
  8. {
  9. return ProductGroupUser::class;
  10. }
  11. public function successUser($id)
  12. {
  13. $query = ProductGroupUser::hasWhere('groupBuying',function($query){
  14. $query->where('status',10);
  15. });
  16. $query->where('ProductGroupUser.product_group_id',$id);
  17. return $query->setOption('field',[])->field('nickname,avatar')->select();
  18. }
  19. public function updateStatus(int $groupId)
  20. {
  21. return $this->getModel()::getDb()->where('group_buying_id',$groupId)->update(['status' => 10]);
  22. }
  23. public function groupOrderIds($productGroupId)
  24. {
  25. return ProductGroupUser::getDB()->where('group_buying_id', $productGroupId)->where('order_id', '>', 0)->column('order_id');
  26. }
  27. }