xinyi/application/common/model/MessageModel.php

<?php
namespace app\common\model;
/**
 * 会员消息表
 * Class BuyCarModel
 * @package app\common\model
 */

class MessageModel extends BaseModel
{
    protected $table = 'message';

    /**
     * 用户消息分页
     * @param $page
     * @param $pageSize
     * @param array $condition
     * @param bool $is_count
     * @param string $order
     * @return array|int|string
     */
    public function getMessagePage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $this->alias('a')
        ->join('user user','a.user_no = user.user_no','LEFT')
            ->join('admin admin','admin.admin_id = a.admin_id','LEFT')
        ->field('a.*,user.user_name,admin.admin_name');
        if(!empty($condition)){
            $this->where($condition);
        }
        if(!empty($order)){
            $this->order($order);
        }
        if($is_count){
            return $this->count();
        }
        return $this->page($page,$pageSize)->select();
    }
}