User.php 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299
  1. <?php
  2. namespace app\admin\model;
  3. use think\Model;
  4. class User extends Model
  5. {
  6. // 表名
  7. protected $name = 'user';
  8. // 自动写入时间戳字段
  9. protected $autoWriteTimestamp = 'int';
  10. // 定义时间戳字段名
  11. protected $createTime = 'createtime';
  12. protected $updateTime = false;
  13. protected $deleteTime = false;
  14. // 追加属性
  15. protected $append = [
  16. 'yaoqingtime_text',
  17. 'gender_text',
  18. 'idcard_status_text',
  19. 'real_status_text',
  20. 'logintime_text',
  21. 'jointime_text',
  22. 'status_text',
  23. 'hide_is_finishinfo_text',
  24. 'is_active_text',
  25. 'open_match_video_text',
  26. 'open_match_audio_text',
  27. 'jinyantime_text',
  28. 'jinyantype_text',
  29. 'is_shouchong_text'
  30. ];
  31. protected static function init()
  32. {
  33. /*self::beforeUpdate(function ($row) {
  34. $changed = $row->getChangedData();
  35. //如果有修改密码
  36. if (isset($changed['password'])) {
  37. if ($changed['password']) {
  38. $salt = \fast\Random::alnum();
  39. $row->password = \app\common\library\Auth::instance()->getEncryptPassword($changed['password'], $salt);
  40. $row->salt = $salt;
  41. } else {
  42. unset($row->password);
  43. }
  44. }
  45. //手机去重
  46. if (isset($changed['mobile'])) {
  47. if($changed['mobile']){
  48. $exists = db('user')->where('mobile', $changed['mobile'])->where('id', '<>', $row->id)->find();
  49. if ($exists) {
  50. abort(500,'区号手机号已经被使用');
  51. }
  52. }else {
  53. unset($row->mobile);
  54. }
  55. }
  56. //手机去重
  57. if (isset($changed['simplemobile'])) {
  58. if($changed['simplemobile']){
  59. }else {
  60. unset($row->simplemobile);
  61. }
  62. }
  63. });
  64. self::beforeInsert(function ($row){
  65. if (isset($row['password'])) {
  66. if ($row['password']) {
  67. $salt = \fast\Random::alnum();
  68. $row->password = \app\common\library\Auth::instance()->getEncryptPassword($row['password'], $salt);
  69. $row->salt = $salt;
  70. } else {
  71. unset($row->password);
  72. }
  73. }
  74. if($row['mobile']){
  75. $exists = db('user')->where('mobile', $row['mobile'])->find();
  76. if ($exists) {
  77. abort(500,'手机号已经被使用');
  78. }
  79. }else{
  80. abort(500,'手机号不能为空');
  81. }
  82. //判断用户名,手机号重复
  83. });
  84. self::afterInsert(function ($row){
  85. $username = 'u' . (10000 + $row['id']);
  86. db('user')->where('id',$row['id'])->update(['username'=>$username]);
  87. $data = [
  88. 'user_id' => $row['id'],
  89. ];
  90. //注册钱包
  91. db('user_wallet')->insertGetId($data);
  92. //注册用户活跃
  93. db('user_active')->insertGetId($data);
  94. //注册用户权限
  95. db('user_power')->insertGetId($data);
  96. });*/
  97. }
  98. public function getGenderList()
  99. {
  100. return ['1' => __('Gender 1'), '0' => __('Gender 0')];
  101. }
  102. public function getIdcardStatusList()
  103. {
  104. return ['-1' => __('Idcard_status -1'), '0' => __('Idcard_status 0'), '1' => __('Idcard_status 1')];
  105. }
  106. public function getRealStatusList()
  107. {
  108. return ['-1' => __('Real_status -1'), '0' => __('Real_status 0'), '1' => __('Real_status 1')];
  109. }
  110. public function getStatusList()
  111. {
  112. return ['1' => __('Status 1'), '0' => __('Status 0'), '-1' => __('Status -1')];
  113. }
  114. public function getHideIsFinishinfoList()
  115. {
  116. return ['1' => __('Hide_is_finishinfo 1'), '0' => __('Hide_is_finishinfo 0')];
  117. }
  118. public function getIsActiveList()
  119. {
  120. return ['1' => __('Is_active 1'), '0' => __('Is_active 0')];
  121. }
  122. public function getOpenMatchVideoList()
  123. {
  124. return ['1' => __('Open_match_video 1'), '0' => __('Open_match_video 0')];
  125. }
  126. public function getOpenMatchAudioList()
  127. {
  128. return ['1' => __('Open_match_audio 1'), '0' => __('Open_match_audio 0')];
  129. }
  130. public function getJinyantypeList()
  131. {
  132. return ['1' => __('Jinyantype 1'), '2' => __('Jinyantype 2'), '3' => __('Jinyantype 3')];
  133. }
  134. public function getIsShouchongList()
  135. {
  136. return ['0' => __('Is_shouchong 0'), '1' => __('Is_shouchong 1')];
  137. }
  138. public function getYaoqingtimeTextAttr($value, $data)
  139. {
  140. $value = $value ? $value : (isset($data['yaoqingtime']) ? $data['yaoqingtime'] : '');
  141. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  142. }
  143. public function getGenderTextAttr($value, $data)
  144. {
  145. $value = $value ? $value : (isset($data['gender']) ? $data['gender'] : '');
  146. $list = $this->getGenderList();
  147. return isset($list[$value]) ? $list[$value] : '';
  148. }
  149. public function getIdcardStatusTextAttr($value, $data)
  150. {
  151. $value = $value ? $value : (isset($data['idcard_status']) ? $data['idcard_status'] : '');
  152. $list = $this->getIdcardStatusList();
  153. return isset($list[$value]) ? $list[$value] : '';
  154. }
  155. public function getRealStatusTextAttr($value, $data)
  156. {
  157. $value = $value ? $value : (isset($data['real_status']) ? $data['real_status'] : '');
  158. $list = $this->getRealStatusList();
  159. return isset($list[$value]) ? $list[$value] : '';
  160. }
  161. public function getLogintimeTextAttr($value, $data)
  162. {
  163. $value = $value ? $value : (isset($data['logintime']) ? $data['logintime'] : '');
  164. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  165. }
  166. public function getJointimeTextAttr($value, $data)
  167. {
  168. $value = $value ? $value : (isset($data['jointime']) ? $data['jointime'] : '');
  169. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  170. }
  171. public function getStatusTextAttr($value, $data)
  172. {
  173. $value = $value ? $value : (isset($data['status']) ? $data['status'] : '');
  174. $list = $this->getStatusList();
  175. return isset($list[$value]) ? $list[$value] : '';
  176. }
  177. public function getHideIsFinishinfoTextAttr($value, $data)
  178. {
  179. $value = $value ? $value : (isset($data['hide_is_finishinfo']) ? $data['hide_is_finishinfo'] : '');
  180. $list = $this->getHideIsFinishinfoList();
  181. return isset($list[$value]) ? $list[$value] : '';
  182. }
  183. public function getIsActiveTextAttr($value, $data)
  184. {
  185. $value = $value ? $value : (isset($data['is_active']) ? $data['is_active'] : '');
  186. $list = $this->getIsActiveList();
  187. return isset($list[$value]) ? $list[$value] : '';
  188. }
  189. public function getOpenMatchVideoTextAttr($value, $data)
  190. {
  191. $value = $value ? $value : (isset($data['open_match_video']) ? $data['open_match_video'] : '');
  192. $list = $this->getOpenMatchVideoList();
  193. return isset($list[$value]) ? $list[$value] : '';
  194. }
  195. public function getOpenMatchAudioTextAttr($value, $data)
  196. {
  197. $value = $value ? $value : (isset($data['open_match_audio']) ? $data['open_match_audio'] : '');
  198. $list = $this->getOpenMatchAudioList();
  199. return isset($list[$value]) ? $list[$value] : '';
  200. }
  201. public function getJinyantimeTextAttr($value, $data)
  202. {
  203. $value = $value ? $value : (isset($data['jinyantime']) ? $data['jinyantime'] : '');
  204. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  205. }
  206. public function getJinyantypeTextAttr($value, $data)
  207. {
  208. $value = $value ? $value : (isset($data['jinyantype']) ? $data['jinyantype'] : '');
  209. $list = $this->getJinyantypeList();
  210. return isset($list[$value]) ? $list[$value] : '';
  211. }
  212. public function getIsShouchongTextAttr($value, $data)
  213. {
  214. $value = $value ? $value : (isset($data['is_shouchong']) ? $data['is_shouchong'] : '');
  215. $list = $this->getIsShouchongList();
  216. return isset($list[$value]) ? $list[$value] : '';
  217. }
  218. protected function setYaoqingtimeAttr($value)
  219. {
  220. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  221. }
  222. protected function setLogintimeAttr($value)
  223. {
  224. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  225. }
  226. protected function setJointimeAttr($value)
  227. {
  228. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  229. }
  230. protected function setJinyantimeAttr($value)
  231. {
  232. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  233. }
  234. public function usergroup()
  235. {
  236. return $this->belongsTo('UserGroup', 'group_id', 'id', [], 'LEFT')->setEagerlyType(0);
  237. }
  238. }