xinyi/application/common/model/ProductPromoRecordModel.php

<?php
namespace app\common\model;
/**
 * 商品促销修改记录表
 * Class ProductPromoRecordModel
 * @package app\common\model
 */

class ProductPromoRecordModel extends BaseModel
{
    protected $table = 'product_promo_record';

    public function getPromoRecordPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $join=[
            ['product product','product.product_no=promo_record.product_no','LEFT'],
            ['admin admin','admin.admin_id=promo_record.admin_id','LEFT'],
        ];
        $this->alias('promo_record')
            ->field('promo_record.*,product.product_no,product.product_name,product.member_price,admin.admin_name')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        if($is_count){
            return $this->count();
        }
        if($order){
            $this->order($order);
        }
       return $this->BaseModel($this->page($page,$pageSize)->select());
    }
}