Users.php 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | A3Mall
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2020 http://www.a3-mall.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Author: xzncit <158373108@qq.com>
  8. // +----------------------------------------------------------------------
  9. namespace app\admin\model;
  10. use app\common\models\users\Users as UsersModel;
  11. use app\common\models\users\UsersGroup;
  12. class Users extends UsersModel {
  13. /**
  14. * 增加查询条件
  15. * @param $query
  16. * @param $value
  17. * @param $data
  18. */
  19. public function searchGroupIdAttr($query, $value, $data){
  20. if(!empty($value) && $value != '-1'){
  21. $query->where('users.group_id','=',$value);
  22. }
  23. }
  24. /**
  25. * 增加查询条件
  26. * @param $query
  27. * @param $value
  28. * @param $data
  29. */
  30. public function searchUsernameAttr($query, $value, $data){
  31. if(!empty($value)){
  32. $query->where('users.username','like',"%" . $value . "%");
  33. }
  34. }
  35. /**
  36. * 关联表
  37. * @return \think\model\relation\HasOne
  38. */
  39. public function order(){
  40. return $this->hasOne(Order::class,'id','user_id')->joinType("LEFT");
  41. }
  42. /**
  43. * 关联表
  44. * @return \think\model\relation\HasOne
  45. */
  46. public function group(){
  47. return $this->hasOne(UsersGroup::class,'id','group_id')->bind(["group_name"=>"name"])->joinType("LEFT");
  48. }
  49. public function getSpreadTimeAttr($value){
  50. return date("Y-m-d H:i:s",$value);
  51. }
  52. }