73 行
2.8 KiB
PHP
可执行文件
73 行
2.8 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Common\Model;
|
|
//[1.7.90]
|
|
|
|
/**
|
|
* Class VipIntegralModel 删除
|
|
* @package Common\Model
|
|
*/
|
|
class RetailVipIntegralModel extends BaseModel
|
|
{
|
|
protected $tableName = 'retail_vip_integral';
|
|
const ID = 'id'; //int(11) NOT NULL AUTO_INCREMENT,
|
|
const MIN_INTEGRAL = 'min_integral'; //int(11) NOT NULL COMMENT '当前会员等级最小所需积分',
|
|
const MERCHANT_ID = 'merchantid'; //int(11) NOT NULL COMMENT '商户id',
|
|
const GRADE = 'grade'; //int(11) NOT NULL COMMENT '当前积分段的等级',
|
|
const ADD_TIME = 'addtime'; //int(11) NOT NULL COMMENT '添加时间',
|
|
const GRADE_IMG_URL = 'gradeimgurl'; //varchar(255) NOT NULL COMMENT '等级图片路径',
|
|
const DISCOUNT = 'discount'; //float(3,2) NOT NULL DEFAULT '1.00' COMMENT '折扣，0-1之间，越大享受折扣越小',
|
|
const CARD_NAME = 'cardname'; //varchar(20) NOT NULL COMMENT '会员卡名称',
|
|
const MAX = 'max'; //int(11) NOT NULL DEFAULT '0' COMMENT '最大优惠金额',
|
|
const GRADE_IMG_URL_ID = 'gradeimgurl_id'; //varchar(255) DEFAULT '0',
|
|
|
|
/**
|
|
* 获取会员等级信息
|
|
* @param $merchant_id 商户ID
|
|
* @param $grade_integral 会员等级积分
|
|
* @param bool $need_img 是否需要获取等级图片
|
|
* @return array|mixed
|
|
*/
|
|
public function getVipGradeInfo($merchant_id, $grade_integral, $need_img = false)
|
|
{
|
|
$map = array(
|
|
'merchantid' => $merchant_id,
|
|
'min_integral' => array('elt', $grade_integral),
|
|
);
|
|
$field = 'id,discount,cardname as grade_name';
|
|
if ($need_img) {
|
|
$field .= ',gradeimgurl_id as img_id';
|
|
}
|
|
$res = $this->getOrderFind($map, $field, 'min_integral desc');
|
|
if ($res && $need_img) {
|
|
$ImageGalleryModel = new ImageGalleryModel();
|
|
$res['grade_img'] = $ImageGalleryModel->getImagePath($res['img_id']);
|
|
}
|
|
return $res ? $res : array();
|
|
}
|
|
|
|
/**
|
|
* 获取会员下个等级信息
|
|
* @param $merchant_id 商户ID
|
|
* @param $grade_integral 会员等级积分
|
|
* @param bool $need_img 是否需要获取等级图片
|
|
* @return array|mixed
|
|
*/
|
|
public function getVipNextGradeInfo($merchant_id, $grade_integral, $need_img = false)
|
|
{
|
|
$map = array(
|
|
'merchantid' => $merchant_id,
|
|
'min_integral' => array('gt', $grade_integral),
|
|
);
|
|
$field = 'discount,min_integral,cardname as grade_name';
|
|
if ($need_img) {
|
|
$field .= ',gradeimgurl_id as img_id';
|
|
}
|
|
$res = $this->getOrderFind($map, $field, 'min_integral');
|
|
if ($res && $need_img) {
|
|
$ImageGalleryModel = new ImageGalleryModel();
|
|
$res['grade_img'] = $ImageGalleryModel->getImagePath($res['img_id']);
|
|
}
|
|
return $res ? $res : array();
|
|
}
|
|
} |