123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464 |
- <?php
- namespace app\model\user;
- use app\model\agent\AgentLevel;
- use app\model\order\StoreOrder;
- use app\model\user\level\SystemUserLevel;
- use app\model\user\group\UserGroup;
- use app\model\user\label\UserLabel;
- use app\model\user\label\UserLabelRelation;
- use crmeb\basic\BaseModel;
- use crmeb\traits\ModelTrait;
- use think\Model;
- use think\model\concern\SoftDelete;
- class User extends BaseModel
- {
- use ModelTrait;
- use SoftDelete;
-
- protected $pk = 'uid';
- protected $name = 'user';
- protected $insert = ['add_time', 'add_ip', 'last_time', 'last_ip'];
- protected $hidden = [
- 'add_ip', 'account', 'clean_time', 'last_ip', 'pwd'
- ];
- protected $deleteTime = 'delete_time';
-
- protected $type = [
- 'birthday' => 'int'
- ];
- protected $updateTime = false;
-
- public static function onAfterUpdate($user)
- {
- event('user.update');
- }
- protected function setAddTimeAttr($value)
- {
- return time();
- }
- protected function setAddIpAttr($value)
- {
- return app('request')->ip();
- }
- protected function setLastTimeAttr($value)
- {
- return time();
- }
- protected function setLastIpAttr($value)
- {
- return app('request')->ip();
- }
-
- protected function setExtendInfoAttr($value)
- {
- if ($value) {
- return is_array($value) ? json_encode($value) : $value;
- }
- return '';
- }
-
- protected function getExtendInfoAttr($value)
- {
- if ($value) {
- return is_string($value) ? json_decode($value, true) : $value;
- }
- return [];
- }
-
- protected function setLevelExtendInfoAttr($value)
- {
- if ($value) {
- return is_array($value) ? json_encode($value) : $value;
- }
- return '';
- }
-
- protected function getLevelExtendInfoAttr($value)
- {
- if ($value) {
- return is_string($value) ? json_decode($value, true) : $value;
- }
- return [];
- }
-
- public function systemUserLevel()
- {
- return $this->hasOne(SystemUserLevel::class, 'id', 'level');
- }
-
- public function userGroup()
- {
- return $this->hasOne(UserGroup::class, 'id', 'group_id');
- }
-
- public function spreadUser()
- {
- return $this->hasOne(self::class, 'uid', 'spread_uid');
- }
-
- public function spreadCount()
- {
- return $this->hasMany(UserSpread::class, 'spread_uid', 'uid');
- }
-
- public function LabelRelation()
- {
- return $this->hasMany(UserLabelRelation::class, 'uid', 'uid');
- }
-
- public function label()
- {
- return $this->hasManyThrough(UserLabel::class, UserLabelRelation::class, 'uid', 'id', 'uid', 'label_id');
- }
-
- public function address()
- {
- return $this->hasMany(UserAddress::class, 'uid', 'uid');
- }
-
- public function extract()
- {
- return $this->hasMany(UserExtract::class, 'uid', 'uid');
- }
-
- public function order()
- {
- return $this->hasMany(StoreOrder::class, 'uid', 'uid');
- }
-
- public function agentLevel()
- {
- return $this->hasOne(AgentLevel::class, 'id', 'agent_level')->where('is_del', 0)->where('status', 1);
- }
-
- public function bill()
- {
- return $this->hasMany(UserBill::class, 'uid', 'uid');
- }
-
- public function brokerage()
- {
- return $this->hasMany(UserBrokerage::class, 'uid', 'uid');
- }
-
- public function money()
- {
- return $this->hasMany(UserMoney::class, 'uid', 'uid');
- }
-
- public function searchUidAttr($query, $value)
- {
- if (is_array($value))
- $query->whereIn('uid', $value);
- else
- $query->where('uid', $value);
- }
-
- public function searchAccountAttr($query, $value)
- {
- $query->where('account', $value);
- }
-
- public function searchPwdAttr($query, $value)
- {
- $query->where('pwd', $value);
- }
-
- public function searchUidsAttr($query, $value)
- {
- $query->whereIn('uid', $value);
- }
-
- public function searchStoreLikeAttr($query, $value)
- {
- $query->where('uid|phone|bar_code', 'LIKE', "%$value%");
- }
-
- public function searchLikeAttr($query, $value)
- {
- $query->where('account|nickname|phone|real_name|uid', 'LIKE', "%$value%");
- }
-
- public function searchPhoneAttr($query, $value)
- {
- if (is_array($value)) {
- $query->whereIn('phone', $value);
- } else {
- $query->where('phone', $value);
- }
- }
-
- public function searchGroupIdAttr($query, $value)
- {
- $query->where('group_id', $value);
- }
-
- public function searchIsPromoterAttr($query, $value)
- {
- $query->where('is_promoter', $value);
- }
-
- public function searchStatusAttr($query, $value)
- {
- $query->where('status', $value);
- }
-
- public function searchLevelAttr($query, $value)
- {
- $query->where('level', $value);
- }
-
- public function searchSpreadUidAttr($query, $value)
- {
- $query->where('spread_uid', $value);
- }
-
- public function searchNotSpreadUidAttr($query, $value)
- {
- $query->where('spread_uid', '<>', $value);
- }
-
- public function searchSpreadTimeAttr($query, $value)
- {
- if ($value) {
- if (is_array($value)) {
- if (count($value) == 2) $query->where('spread_time', $value[0], $value[1]);
- } else {
- $query->where('spread_time', $value);
- }
- }
- }
-
- public function searchUserTypeAttr($query, $value)
- {
- if ($value != '') $query->where('user_type', $value);
- }
-
- public function searchPayCountAttr($query, $value)
- {
- if ($value !== '') {
- if ($value == -1) {
- $query->where('pay_count', '>', 0);
- } else {
- $query->where('pay_count', $value);
- }
- }
- }
-
- public function searchSpreadOpenAttr($query, $value)
- {
- if ($value != '') $query->where('spread_open', $value);
- }
- public function searchNicknameAttr($query, $value)
- {
- $query->where('nickname', "like", "%" . $value . "%");
- }
-
- public function searchBarCodeAttr($query, $value)
- {
- if ($value != '') $query->where('bar_code', $value);
- }
- }
|