UserEnter.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. /**
  3. * @author: xaboy<365615158@qq.com>
  4. * @day: 2017/11/28
  5. */
  6. namespace app\admin\model\user;
  7. use crmeb\traits\ModelTrait;
  8. use crmeb\basic\BaseModel;
  9. use crmeb\services\PHPExcelService;
  10. /**
  11. * 用户充值记录
  12. * Class UserRecharge
  13. * @package app\admin\model\user
  14. */
  15. class UserEnter extends BaseModel
  16. {
  17. /**
  18. * 数据表主键
  19. * @var string
  20. */
  21. protected $pk = 'id';
  22. /**
  23. * 模型名称
  24. * @var string
  25. */
  26. protected $name = 'user_enter';
  27. use ModelTrait;
  28. public static function list($where)
  29. {
  30. $model = self::alias('a')
  31. ->field('a.*,u.nickname')
  32. ->order('a.id DESC')
  33. ->leftJoin('user u', 'u.uid = a.uid');
  34. if ($where['status'] == -1){
  35. $model->where('a.status' , '=', -1);
  36. }elseif ($where['status'] == 2){
  37. $model->where('a.status' , '=', 0);
  38. }elseif ($where['status'] == 1){
  39. $model->where('a.status' , '=', 1);
  40. }
  41. $data['count'] = $model->count();
  42. if ($where['page'] && $where['limit']){
  43. $model->page($where['page'], $where['limit']);
  44. }else{
  45. $model->page(20, 1);
  46. }
  47. $list = $model->select()->toArray();
  48. $data['data'] = $list;
  49. return $data;
  50. }
  51. }