UserRecharge.php 1.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. <?php
  2. /**
  3. *
  4. * @author: xaboy<365615158@qq.com>
  5. * @day: 2017/11/28
  6. */
  7. namespace app\admin\model\user;
  8. use traits\ModelTrait;
  9. use basic\ModelBasic;
  10. /**
  11. * 用户充值记录
  12. * Class UserRecharge
  13. * @package app\admin\model\user
  14. */
  15. class UserRecharge extends ModelBasic
  16. {
  17. use ModelTrait;
  18. public static function systemPage($where){
  19. $model = new self;
  20. $model = $model->alias('A');
  21. if($where['order_id'] != '') {
  22. $model = $model->whereOr('A.order_id','like',"%$where[order_id]%");
  23. $model = $model->whereOr('A.id',(int)$where['order_id']);
  24. $model = $model->whereOr('B.nickname','like',"%$where[order_id]%");
  25. }
  26. $model = $model->where('A.recharge_type','weixin');
  27. $model = $model->where('A.paid',1);
  28. $model = $model->field('A.*,B.nickname');
  29. $model = $model->join('__USER__ B','A.uid = B.uid','RIGHT');
  30. $model = $model->order('A.id desc');
  31. return self::page($model,$where);
  32. }
  33. }