42 行
1.3 KiB
PHP
可执行文件
42 行
1.3 KiB
PHP
可执行文件
<?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;
|
|
}
|
|
} |