xinyi_admin/application/common/model/PayListModel.php

<?php
namespace app\common\model;
/**
 * 支付记录表
 * Class PayListModel
 * @package app\common\model
 */

class PayListModel extends BaseModel
{
    protected $table = 'pay_list';

    // 用户支付记录分页
    public function getPayListPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $join=[
            ['user user','user.user_no = pay_list.user_no','LEFT'],
        ];
        $this->alias('pay_list')
            ->field('pay_list.*,user.user_name')
            ->join($join);
        if(!empty($condition)){
            $this->where($condition);
        }
        if(!empty($order)){
            $this->order($order);
        }
        if($is_count){
            return $this->count();
        }
        return $this->page($page,$pageSize)->select();
    }
}