xinyi/application/common/model/ProductPromoModel.php

<?php
namespace app\common\model;
use think\Db;

/**
 * 商品促销信息表
 * Class ProductPromoModel
 * @package app\common\model
 */
class ProductPromoModel extends BaseModel
{
    protected $table = 'product_promo';

    /**
     * 将过期的数据更新
     */
    public static function updateExpireTs(){
        Db::table('product_promo')->where(['end_time'=>['lt',time()]])->update(['status'=>3]);
    }

    public function getProductPromoOne($condition=[]){
        $join=[
            ['product product','product.product_no=product_promo.product_no','LEFT'],
        ];
        $this->alias('product_promo')
            ->field('product_promo.*,product.product_name,product.member_price')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        return $this->BaseModel($this->find());
    }
}