UserPoint.php 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\admin\model\user;
  12. use app\admin\model\user\User;
  13. use app\admin\model\user\UserBill;
  14. use traits\ModelTrait;
  15. use basic\ModelBasic;
  16. class UserPoint extends ModelBasic
  17. {
  18. use ModelTrait;
  19. /*
  20. * 获取积分信息
  21. * */
  22. public static function systemPage($where)
  23. {
  24. $model = new UserBill();
  25. if ($where['status'] != '') $model = $model->where('status', $where['status']);
  26. if ($where['title'] != '') $model = $model->where('title', 'like', "%$where[status]%");
  27. $model = $model->where('category', 'integral')->select();
  28. return $model::page($model);
  29. }
  30. public static function setWhere($where)
  31. {
  32. $model = UserBill::alias('a')->join('__USER__ b', 'a.uid=b.uid', 'left')->where('a.category', 'integral');
  33. $time['data'] = '';
  34. if ($where['start_time'] != '' && $where['end_time'] != '') {
  35. $time['data'] = $where['start_time'] . ' - ' . $where['end_time'];
  36. }
  37. $model = self::getModelTime($time, $model, 'a.add_time');
  38. if ($where['nickname'] != '') {
  39. $model = $model->where('b.nickname|b.uid', 'like', $where['nickname']);
  40. }
  41. return $model;
  42. }
  43. }