User.php 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257
  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 = 'updatetime';
  13. protected $deleteTime = false;
  14. // 追加属性
  15. protected $append = [
  16. 'gender_text',
  17. 'idcard_status_text',
  18. 'prevtime_text',
  19. 'logintime_text',
  20. 'jointime_text',
  21. 'status_text',
  22. 'hide_is_finishinfo_text',
  23. 'is_active_text',
  24. 'is_tuijian_text',
  25. 'jinyantime_text',
  26. 'jinyantype_text'
  27. ];
  28. protected static function init()
  29. {
  30. self::beforeUpdate(function ($row) {
  31. $changed = $row->getChangedData();
  32. //如果有修改密码
  33. if (isset($changed['password'])) {
  34. if ($changed['password']) {
  35. $salt = \fast\Random::alnum();
  36. $row->password = \app\common\library\Auth::instance()->getEncryptPassword($changed['password'], $salt);
  37. $row->salt = $salt;
  38. } else {
  39. unset($row->password);
  40. }
  41. }
  42. //手机去重
  43. if (isset($changed['mobile'])) {
  44. if($changed['mobile']){
  45. $exists = db('user')->where('mobile', $changed['mobile'])->where('id', '<>', $row->id)->find();
  46. if ($exists) {
  47. abort(500,'区号手机号已经被使用');
  48. }
  49. }else {
  50. unset($row->mobile);
  51. }
  52. }
  53. //手机去重
  54. if (isset($changed['simplemobile'])) {
  55. if($changed['simplemobile']){
  56. }else {
  57. unset($row->simplemobile);
  58. }
  59. }
  60. });
  61. /*self::beforeInsert(function ($row){
  62. if (isset($row['password'])) {
  63. if ($row['password']) {
  64. $salt = \fast\Random::alnum();
  65. $row->password = \app\common\library\Auth::instance()->getEncryptPassword($row['password'], $salt);
  66. $row->salt = $salt;
  67. } else {
  68. unset($row->password);
  69. }
  70. }
  71. if($row['mobile']){
  72. $exists = db('user')->where('mobile', $row['mobile'])->find();
  73. if ($exists) {
  74. abort(500,'手机号已经被使用');
  75. }
  76. }else{
  77. abort(500,'手机号不能为空');
  78. }
  79. //判断用户名,手机号重复
  80. });
  81. self::afterInsert(function ($row){
  82. $username = 'u' . (10000 + $row['id']);
  83. db('user')->where('id',$row['id'])->update(['username'=>$username]);
  84. $data = [
  85. 'user_id' => $row['id'],
  86. ];
  87. //注册钱包
  88. db('user_wallet')->insertGetId($data);
  89. //注册用户活跃
  90. db('user_active')->insertGetId($data);
  91. //注册用户权限
  92. db('user_power')->insertGetId($data);
  93. });*/
  94. }
  95. public function getGenderList()
  96. {
  97. return ['1' => __('Gender 1'), '0' => __('Gender 0')];
  98. }
  99. public function getIdcardStatusList()
  100. {
  101. return ['-1' => __('Idcard_status -1'), '0' => __('Idcard_status 0'), '1' => __('Idcard_status 1'), '2' => __('Idcard_status 2'), '3' => __('Idcard_status 3')];
  102. }
  103. public function getStatusList()
  104. {
  105. return ['1' => __('Status 1'), '0' => __('Status 0'), '-1' => __('Status -1')];
  106. }
  107. public function getHideIsFinishinfoList()
  108. {
  109. return ['1' => __('Hide_is_finishinfo 1'), '0' => __('Hide_is_finishinfo 0')];
  110. }
  111. public function getIsActiveList()
  112. {
  113. return ['1' => __('Is_active 1'), '0' => __('Is_active 0')];
  114. }
  115. public function getIsTuijianList()
  116. {
  117. return ['1' => __('Is_tuijian 1'), '0' => __('Is_tuijian 0')];
  118. }
  119. public function getJinyantypeList()
  120. {
  121. return ['1' => __('Jinyantype 1'), '2' => __('Jinyantype 2'), '3' => __('Jinyantype 3')];
  122. }
  123. public function getGenderTextAttr($value, $data)
  124. {
  125. $value = $value ? $value : (isset($data['gender']) ? $data['gender'] : '');
  126. $list = $this->getGenderList();
  127. return isset($list[$value]) ? $list[$value] : '';
  128. }
  129. public function getIdcardStatusTextAttr($value, $data)
  130. {
  131. $value = $value ? $value : (isset($data['idcard_status']) ? $data['idcard_status'] : '');
  132. $list = $this->getIdcardStatusList();
  133. return isset($list[$value]) ? $list[$value] : '';
  134. }
  135. public function getPrevtimeTextAttr($value, $data)
  136. {
  137. $value = $value ? $value : (isset($data['prevtime']) ? $data['prevtime'] : '');
  138. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  139. }
  140. public function getLogintimeTextAttr($value, $data)
  141. {
  142. $value = $value ? $value : (isset($data['logintime']) ? $data['logintime'] : '');
  143. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  144. }
  145. public function getJointimeTextAttr($value, $data)
  146. {
  147. $value = $value ? $value : (isset($data['jointime']) ? $data['jointime'] : '');
  148. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  149. }
  150. public function getStatusTextAttr($value, $data)
  151. {
  152. $value = $value ? $value : (isset($data['status']) ? $data['status'] : '');
  153. $list = $this->getStatusList();
  154. return isset($list[$value]) ? $list[$value] : '';
  155. }
  156. public function getHideIsFinishinfoTextAttr($value, $data)
  157. {
  158. $value = $value ? $value : (isset($data['hide_is_finishinfo']) ? $data['hide_is_finishinfo'] : '');
  159. $list = $this->getHideIsFinishinfoList();
  160. return isset($list[$value]) ? $list[$value] : '';
  161. }
  162. public function getIsActiveTextAttr($value, $data)
  163. {
  164. $value = $value ? $value : (isset($data['is_active']) ? $data['is_active'] : '');
  165. $list = $this->getIsActiveList();
  166. return isset($list[$value]) ? $list[$value] : '';
  167. }
  168. public function getIsTuijianTextAttr($value, $data)
  169. {
  170. $value = $value ? $value : (isset($data['is_tuijian']) ? $data['is_tuijian'] : '');
  171. $list = $this->getIsTuijianList();
  172. return isset($list[$value]) ? $list[$value] : '';
  173. }
  174. public function getJinyantimeTextAttr($value, $data)
  175. {
  176. $value = $value ? $value : (isset($data['jinyantime']) ? $data['jinyantime'] : '');
  177. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  178. }
  179. public function getJinyantypeTextAttr($value, $data)
  180. {
  181. $value = $value ? $value : (isset($data['jinyantype']) ? $data['jinyantype'] : '');
  182. $list = $this->getJinyantypeList();
  183. return isset($list[$value]) ? $list[$value] : '';
  184. }
  185. protected function setPrevtimeAttr($value)
  186. {
  187. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  188. }
  189. protected function setLogintimeAttr($value)
  190. {
  191. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  192. }
  193. protected function setJointimeAttr($value)
  194. {
  195. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  196. }
  197. protected function setJinyantimeAttr($value)
  198. {
  199. return $value === '' ? 0 : ($value && !is_numeric($value) ? strtotime($value) : $value);
  200. }
  201. public function userwallet()
  202. {
  203. return $this->belongsTo('Userwallet', 'id', 'user_id', [], 'LEFT')->setEagerlyType(0);
  204. }
  205. }