<?php

namespace Common\Model;

use Think\Model;
//[1.3.43]
/**
 * 升级plus会员套餐商品表
 * Class RetailPlusMealGoodsModel
 * @package Common\Model
 */
class RetailMealPlusGoodsModel extends BaseModel
{
    protected $tableName = 'retail_meal_plus_goods';

    const ID = 'id';                    //int(11) NOT NULL AUTO_INCREMENT,
    const GROUP_ID = 'group_id';        //int(11) DEFAULT '0' COMMENT '套餐id',
    const MERCHANT_ID = 'merchantid';   //int(11) DEFAULT '0',
    const STORE_ID = 'storeid';         //int(11) DEFAULT '0',
    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 '添加时间',


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