DataGroupUserid.php 1.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\admin\model;
  4. use think\Model;
  5. /**
  6. * @mixin \think\Model
  7. */
  8. class DataGroupUserid extends Model
  9. {
  10. protected $schema = [
  11. 'id' => 'integer',
  12. 'data_group_id' => 'integer',
  13. 'uid' => 'integer',
  14. 'status' => 'integer',
  15. 'addtime' => 'datetime',
  16. 'updatetime' => 'datetime',
  17. 'is_del' => 'integer'
  18. ];
  19. protected $createTime = 'addtime';
  20. protected $updateTime = 'updatetime';
  21. protected $visible=["id","data_group_id","uid",'status','nickname','mobile',];
  22. public function userInfo(){
  23. return $this->belongsTo(\app\user\model\User::class,"uid","account_id")->bind(["nickname","mobile"]);
  24. }
  25. public static function GroupIdByUid(int $uid):array{
  26. return self::where(["uid"=>$uid,"is_del"=>0,"status"=>1])->column("data_group_id");
  27. }
  28. public static function UidsByGroupId($GroupId):array{
  29. $list= self::where(['data_group_id'=>$GroupId,'is_del'=>0,'status'=>1])->field('data_group_id,uid')->select();
  30. $GroupByIds=[];
  31. if($list->isEmpty()==false){
  32. foreach ($list as $item){
  33. $GroupByIds[$item->data_group_id][]=$item->uid;
  34. }
  35. }
  36. return $GroupByIds;
  37. }
  38. }