<?php

namespace Common\Model;

use Think\Model;

//[1.3.43]

/**
 * 单品升级PLUS会员设置表
 * Class RetailSinglePlusGoodsModel
 * @package Common\Model
 */
class RetailSinglePlusGoodsModel extends BaseModel
{
    protected $tableName = 'retail_single_plus_goods';

    const ID = 'id';//int(11) NOT NULL AUTO_INCREMENT,
    const MERCHANT_ID = 'merchantid';//int(11) DEFAULT '0' COMMENT '商户id',
    const STORE_ID = 'storeid';//int(11) DEFAULT '0' COMMENT '门店id',
    const GOODS_ID = 'goods_id';//int(11) DEFAULT '0' COMMENT '门店商品id',
    const STATUS = 'status';//tinyint(4) DEFAULT '1' COMMENT '1正常      2删除',
    const ADD_TIME = 'addtime';//varchar(13) DEFAULT NULL COMMENT '添加时间',
    const TIME = 'time';//varchar(13) DEFAULT NULL COMMENT '套餐时长',

    /**
     * 获取购买单个商品送次卡商品列表
     * @param $map
     * @param $fields
     * @param string $order
     * @return mixed
     */
    public function getSelectGoods($map, $fields, $order = 'p.id desc')
    {
        $list = $this->alias('p')
            ->join('ls_retail_goods as g on g.id=p.goods_id')
            ->where($map)
            ->field($fields)
            ->order($order)
            ->select();
        return $list;
    }
}