1236 行
50 KiB
PHP
可执行文件
1236 行
50 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Api\Controller;
|
|
|
|
use Common\Model\CardBagModel;
|
|
use Common\Model\CardUseCodeModel;
|
|
use Common\Model\ImageGalleryModel;
|
|
use Common\Model\RetailCardGoodsModel;
|
|
use Common\Model\RetailCardOrderModel;
|
|
use Common\Model\RetailPayOrderModel;
|
|
use Common\Model\RetailSkuGoodsModel;
|
|
use Common\Model\RetailSkuListModel;
|
|
use Common\Model\RetailStoreModel;
|
|
use Common\Model\RetailVipCardModel;
|
|
use Common\Model\RetailVipCardRecordModel;
|
|
use Common\Model\RetailVipModel;
|
|
use Common\Model\SSaleMGoodsModel;
|
|
use Common\Model\SubCardModel;
|
|
use Common\Model\SubCardViewModel;
|
|
use PayApi\Controller\VipCardController;
|
|
use Think\Controller;
|
|
|
|
//[1.8.20]
|
|
|
|
/**
|
|
* 次卡
|
|
*/
|
|
class SubCardController extends Controller
|
|
{
|
|
/**
|
|
* 获取次卡列表 type 4,5 门店购买和门点购买指定商品
|
|
* @param int $merchant_id 商户id
|
|
* @param int $source 来源 1.线下 2.线上
|
|
* @param int $store_id 门店id
|
|
* @return $res
|
|
*/
|
|
public function subCardList($merchant_id, $source, $store_id = '', $page = '', $limit = '', $keyword = '')
|
|
{
|
|
$time = time();
|
|
// 条件
|
|
$map = array(
|
|
'merchantid' => $merchant_id,
|
|
'type' => array('in', array(4, 5)),
|
|
'card_type' => 1,
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 判断来源 $source 1.线下 2.线上
|
|
if ($source == 1) {
|
|
$map['line_state'] = 1;
|
|
} else {
|
|
$map['online_state'] = 1;
|
|
}
|
|
// 判断门店id
|
|
if ($store_id) {
|
|
$map['storeids'] = $store_id;
|
|
}
|
|
// 搜索
|
|
if (trim($keyword)) {
|
|
$map['name'] = array('like', '%' . trim($keyword) . '%');
|
|
}
|
|
$field = array(
|
|
'id', 'name',
|
|
'surplus',
|
|
'use_type',
|
|
'type',
|
|
'frequency',
|
|
'limit',
|
|
'time_interval',
|
|
'money',
|
|
'introduce',
|
|
'effective_start',
|
|
'effective_end',
|
|
'gallery_id',
|
|
'image',
|
|
'end_time',
|
|
'card_name_color',
|
|
'btn_background',
|
|
'btn_text_color',
|
|
'storeids',
|
|
'effective_time_type',
|
|
'effective_day',
|
|
);
|
|
// 实例化
|
|
$SubCard = new SubCardModel();
|
|
// 查询
|
|
$sub_card = $SubCard->toSelect($map, $page, $limit, $field);
|
|
$ImageGallery = new ImageGalleryModel();
|
|
$storeList = array();
|
|
$StoreModel = new RetailStoreModel();
|
|
foreach ($sub_card as &$val) {
|
|
// 金额
|
|
$val['money'] = floatval($val['money']) ? floatval($val['money']) : 0;
|
|
// 截止日期
|
|
$val['end_time'] = date('Y/m/d H:i:s', $val['end_time']);
|
|
// 类型
|
|
if ($val['use_type'] == 1) {
|
|
$val['use_rule'] = '每天一次';
|
|
} else if ($val['use_type'] == 2) {
|
|
$val['use_rule'] = '可用' . $val['frequency'] . '次，每日最多使用' . $val['limit'] . '次';
|
|
} else if ($val['use_type'] == 3) {
|
|
$val['use_rule'] = '每隔' . $val['limit'] . '天可使用一次';
|
|
}
|
|
$val['time_interval'] = str_replace(',', ' - ', $val['time_interval']);
|
|
// 有效时间
|
|
if ($val['effective_time_type'] == 1) {
|
|
if (!$val['effective_start'] || !$val['effective_end']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = date('Y-m-d', $val['effective_start']) . ' - ' . date('Y-m-d', $val['effective_end']);
|
|
}
|
|
} else if ($val['effective_time_type'] == 2) {
|
|
if (!$val['effective_day']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = '会员领取当日起' . $val['effective_day'] . '天内有效';
|
|
}
|
|
} else if ($val['effective_time_type'] == 3) {
|
|
if (!$val['effective_day']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = '会员领取次日起' . $val['effective_day'] . '天内有效';
|
|
}
|
|
}
|
|
|
|
// 图片
|
|
if ($val['gallery_id'] && $val['gallery_id'] != 0) {
|
|
$val['image_url'] = $ImageGallery->getFieldPath(array('id' => $val['gallery_id']));
|
|
} else {
|
|
$val['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 颜色
|
|
$val['card_name_color'] = $val['card_name_color'] ? $val['card_name_color'] : '#FFFFFF';
|
|
$val['btn_background'] = $val['btn_background'] ? $val['btn_background'] : '#FFFFFF';
|
|
$val['btn_text_color'] = $val['btn_text_color'] ? $val['btn_text_color'] : '#36549a';
|
|
//门店图片
|
|
if ($storeList[$val['storeids']]) {
|
|
$val['store_name'] = $storeList[$val['storeids']]['store_name'];
|
|
$val['store_image'] = $storeList[$val['storeids']]['store_image'];
|
|
} else {
|
|
$store = $StoreModel->getFind(array('id' => $val['storeids']), 'storetag as store_name,shopimg_id');
|
|
$store['store_image'] = getImage($store['shopimg_id']);
|
|
$val['store_name'] = $store['store_name'];
|
|
$val['store_image'] = $store['store_image'];
|
|
$storeList[$val['storeids']] = $store;
|
|
}
|
|
$val['store_id'] = $val['storeids'];
|
|
unset($val['storeids']);
|
|
}
|
|
$res = array(
|
|
'status' => 1,
|
|
'sub_card' => !empty($sub_card) ? $sub_card : array()
|
|
);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 获取次卡列表 type 4,5
|
|
* @param int $merchant_id 商户idz
|
|
* @param int $source 来源 1.线下 2.线上
|
|
* @param int $store_id 门店id
|
|
* @return $res
|
|
*/
|
|
public function cardBagList($merchant_id, $source, $store_id = '', $page = '', $limit = '', $keyword = '')
|
|
{
|
|
// 实例化模型
|
|
$time = time();
|
|
// 条件
|
|
$map = array(
|
|
'merchantid' => $merchant_id,
|
|
'type' => array('in', array(4, 5)),
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 判断类型 $source 来源 1.线下 2. 线上
|
|
if ($source == 1) {
|
|
$map['line_state'] = 1;
|
|
} else {
|
|
$map['online_state'] = 1;
|
|
}
|
|
// 判断门店id
|
|
if ($store_id) {
|
|
$map['storeids'] = $store_id;
|
|
}
|
|
// 搜索
|
|
if (trim($keyword)) {
|
|
$map['name'] = array('like', '%' . trim($keyword) . '%');
|
|
}
|
|
$field = array(
|
|
'id', 'name', 'surplus', 'money',
|
|
'type', 'image', 'gallery_id', 'end_time', 'card_name_color',
|
|
'btn_background', 'btn_text_color', 'storeids'
|
|
);
|
|
// 实例化
|
|
$CardBag = new CardBagModel();
|
|
// 查询
|
|
$card_bag = $CardBag->toSelect($map, $page, $limit, $field);
|
|
$ImageGallery = new ImageGalleryModel();
|
|
$StoreModel = new RetailStoreModel();
|
|
$storeList = array();
|
|
foreach ($card_bag as &$val) {
|
|
// 金额
|
|
$val['money'] = floatval($val['money']) ? floatval($val['money']) : 0;
|
|
// 截止日期
|
|
$val['end_time'] = date('Y/m/d H:i:s', $val['end_time']);
|
|
// 图片
|
|
if ($val['gallery_id'] && $val['gallery_id'] != 0) {
|
|
|
|
$val['image_url'] = $ImageGallery->getFieldPath(array('id' => $val['gallery_id']));
|
|
} else {
|
|
$val['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 颜色
|
|
$val['card_name_color'] = $val['card_name_color'] ? $val['card_name_color'] : '#FFFFFF';
|
|
$val['btn_background'] = $val['btn_background'] ? $val['btn_background'] : '#FFFFFF';
|
|
$val['btn_text_color'] = $val['btn_text_color'] ? $val['btn_text_color'] : '#36549a';
|
|
//门店图片
|
|
if ($storeList[$val['storeids']]) {
|
|
$val['store_name'] = $storeList[$val['storeids']]['store_name'];
|
|
$val['store_image'] = $storeList[$val['storeids']]['store_image'];
|
|
} else {
|
|
$store = $StoreModel->getFind(array('id' => $val['storeids']), 'storetag as store_name,shopimg_id');
|
|
$store['store_image'] = getImage($store['shopimg_id']);
|
|
$val['store_name'] = $store['store_name'];
|
|
$val['store_image'] = $store['store_image'];
|
|
$storeList[$val['storeids']] = $store;
|
|
}
|
|
$val['store_id'] = $val['storeids'];
|
|
unset($val['storeids']);
|
|
}
|
|
$res = array(
|
|
'status' => 1,
|
|
'card_bag' => !empty($card_bag) ? $card_bag : array()
|
|
);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 次卡信息
|
|
* @param int $merchant_id
|
|
* @param int $source 来源 1.线下 2.线上
|
|
* @param int $card_id
|
|
* @param int $store_id 非必传参数
|
|
* @return array
|
|
*/
|
|
public function subCardInfo($merchant_id, $source, $card_id, $store_id = '')
|
|
{
|
|
$time = time();
|
|
// 条件
|
|
$map = array(
|
|
'id' => $card_id,
|
|
'merchantid' => $merchant_id,
|
|
'card_type' => 1,
|
|
);
|
|
// 判断来源 $source 1.线下 2.线上
|
|
if ($source == 1) {
|
|
$map['line_state'] = 1;
|
|
} else {
|
|
$map['online_state'] = 1;
|
|
}
|
|
// 判断门店
|
|
if ($store_id) {
|
|
$map['storeids'] = $store_id;
|
|
}
|
|
$field = array(
|
|
'id', 'name', 'surplus', 'use_type', 'frequency', 'limit', 'time_interval', 'type', 'money', 'introduce', 'effective_start',
|
|
'effective_end', 'gallery_id', 'image', 'end_time', 'status', 'card_name_color', 'btn_background', 'btn_text_color', 'effective_time_type', 'effective_day'
|
|
);
|
|
// 实例化
|
|
$SubCard = new SubCardModel();
|
|
// 查询
|
|
$sub_card = $SubCard->toFind($map, $field);
|
|
// 判断
|
|
if (empty($sub_card)) {
|
|
$res = array('status' => 0, 'msg' => '该次卡活动异常');
|
|
return $res;
|
|
}
|
|
// 判断结束时间，数量
|
|
$sub_card['surplus'] = intval($sub_card['surplus']);
|
|
if ($sub_card['end_time'] < $time || $sub_card['surplus'] <= 0) {
|
|
$sub_card['status'] = 1;
|
|
}
|
|
// 结束时间
|
|
$sub_card['end_time'] = date('Y/m/d H:i:s', $sub_card['end_time']);
|
|
// 处理数据
|
|
if ($sub_card['use_type'] == 1) {
|
|
$sub_card['use_rule'] = '每天一次';
|
|
} else if ($sub_card['use_type'] == 2) {
|
|
$sub_card['use_rule'] = '可用' . $sub_card['frequency'] . '次，每日最多使用' . $sub_card['limit'] . '次';
|
|
} else if ($sub_card['use_type'] == 3) {
|
|
$sub_card['use_rule'] = '每隔' . $sub_card['limit'] . '天可使用一次';
|
|
}
|
|
$sub_card['time_interval'] = str_replace(',', ' - ', $sub_card['time_interval']);
|
|
// 使用有效时间
|
|
if ($sub_card['effective_time_type'] == 1) {
|
|
if (!$sub_card['effective_start'] || !$sub_card['effective_end']) {
|
|
$sub_card['effective_time'] = '无效时间';
|
|
} else {
|
|
$sub_card['effective_time'] = date('Y/m/d', $sub_card['effective_start']) . ' - ' . date('Y/m/d', $sub_card['effective_end']);
|
|
}
|
|
} else if ($sub_card['effective_time_type'] == 2) {
|
|
if (!$sub_card['effective_day']) {
|
|
$sub_card['effective_time'] = '无效时间';
|
|
} else {
|
|
$sub_card['effective_time'] = '会员领取当日起' . $sub_card['effective_day'] . '天内有效';
|
|
}
|
|
} else if ($sub_card['effective_time_type'] == 3) {
|
|
if (!$sub_card['effective_day']) {
|
|
$sub_card['effective_time'] = '无效时间';
|
|
} else {
|
|
$sub_card['effective_time'] = '会员领取次日起' . $sub_card['effective_day'] . '天内有效';
|
|
}
|
|
}
|
|
|
|
// 图片
|
|
if ($sub_card['gallery_id'] && $sub_card['gallery_id'] != 0) {
|
|
$ImageGallery = new ImageGalleryModel();
|
|
$sub_card['image_url'] = $ImageGallery->getFieldPath(array('id' => $sub_card['gallery_id']));
|
|
} else {
|
|
$sub_card['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 颜色
|
|
$sub_card['card_name_color'] = $sub_card['card_name_color'] ? $sub_card['card_name_color'] : '#FFFFFF';
|
|
$sub_card['btn_background'] = $sub_card['btn_background'] ? $sub_card['btn_background'] : '#FFFFFF';
|
|
$sub_card['btn_text_color'] = $sub_card['btn_text_color'] ? $sub_card['btn_text_color'] : '#36549a';
|
|
// 判断类型
|
|
if ($sub_card['type'] == 5) {
|
|
// 判断store_id
|
|
if (!$store_id) {
|
|
$res = array('status' => 0, 'msg' => '缺少必要的store_id');
|
|
return $res;
|
|
}
|
|
// 获取商品
|
|
$result = $this->cardGoods($merchant_id, 0, $card_id, $store_id);
|
|
if ($result['status'] == 0) {
|
|
return $result;
|
|
}
|
|
$res['card_goods'] = $result['card_goods'];
|
|
}
|
|
// 返回值
|
|
$res['status'] = 1;
|
|
$res['sub_card'] = $sub_card;
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 卡包信息
|
|
* @param int $merchant_id
|
|
* @param int $source 来源 1.线下 2.线上
|
|
* @param int $card_id
|
|
* @param int $store_id 非必传参数
|
|
* @return array
|
|
*/
|
|
public function cardBagInfo($merchant_id, $source, $bag_id, $store_id = '')
|
|
{
|
|
// 实例化模型
|
|
$time = time();
|
|
// 条件
|
|
$map = array(
|
|
'id' => $bag_id,
|
|
'merchantid' => $merchant_id,
|
|
);
|
|
// 判来源 $source 1.线下 2.线上
|
|
if ($source == 1) {
|
|
$map['line_state'] = 1;
|
|
} else {
|
|
$map['online_state'] = 1;
|
|
}
|
|
// 判断门店id
|
|
if ($store_id) {
|
|
$map['storeids'] = $store_id;
|
|
}
|
|
$field = array(
|
|
'id', 'name', 'surplus', 'image', 'gallery_id', 'end_time', 'type', 'money', 'status', 'card_name_color', 'btn_background', 'btn_text_color'
|
|
);
|
|
// 实例化
|
|
$CardBag = new CardBagModel();
|
|
// 查询
|
|
$card_bag = $CardBag->toFind($map, $field);
|
|
if (empty($card_bag)) {
|
|
$res = array('status' => 0, 'msg' => '该卡包活动异常');
|
|
return $res;
|
|
}
|
|
// 处理数据
|
|
$card_bag['surplus'] = intval($card_bag['surplus']);
|
|
if ($card_bag['end_time'] < $time || $card_bag['surplus'] <= 0) {
|
|
$card_bag['status'] = 1;
|
|
}
|
|
// 结束时间
|
|
$card_bag['end_time'] = date('Y-m-d H:i:s', $card_bag['end_time']);
|
|
// 颜色
|
|
$card_bag['card_name_color'] = $card_bag['card_name_color'] ? $card_bag['card_name_color'] : '#FFFFFF';
|
|
$card_bag['btn_background'] = $card_bag['btn_background'] ? $card_bag['btn_background'] : '#FFFFFF';
|
|
$card_bag['btn_text_color'] = $card_bag['btn_text_color'] ? $card_bag['btn_text_color'] : '#36549a';
|
|
// 卡包详情
|
|
$result = $this->cardBagDetails($merchant_id, $card_bag);
|
|
if ($result['status'] == 0) {
|
|
return $result;
|
|
}
|
|
// 判断类型
|
|
if ($card_bag['type'] == 5) {
|
|
// 判断store_id
|
|
if (!$store_id) {
|
|
$res = array('status' => 0, 'msg' => '缺少必要的store_id');
|
|
return $res;
|
|
}
|
|
// 获取商品
|
|
$result2 = $this->cardGoods($merchant_id, 1, $bag_id, $store_id);
|
|
if ($result2['status'] == 0) {
|
|
return $result2;
|
|
}
|
|
$res['card_goods'] = $result2['card_goods'];
|
|
}
|
|
$res['status'] = 1;
|
|
$res['card_bag'] = $card_bag;
|
|
$res['card_list'] = $result['card_list'];
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 卡包详情[次卡展示]
|
|
* @param int $bag_id
|
|
* @return array
|
|
*/
|
|
public function cardBagDetails($merchant_id, $card_bag)
|
|
{
|
|
// 查询条件
|
|
$map = array(
|
|
'merchantid' => $merchant_id,
|
|
'bag_id' => $card_bag['id'],
|
|
'card_type' => 2,
|
|
);
|
|
$field = array(
|
|
'id', 'name', 'surplus', 'use_type', 'frequency', 'limit', 'time_interval', 'money', 'introduce', 'effective_start',
|
|
'effective_end', 'gallery_id', 'image', 'effective_time_type', 'effective_day'
|
|
);
|
|
// 实例化模型
|
|
$SubCard = new SubCardModel();
|
|
// 查询
|
|
$card_list = $SubCard->toSelect($map, '', '', $field);
|
|
if (empty($card_list)) {
|
|
$res = array('status' => 0, 'msg' => '该卡包内暂无可用次卡');
|
|
return $res;
|
|
}
|
|
// 处理数据
|
|
$ImageGallery = new ImageGalleryModel();
|
|
foreach ($card_list as &$val) {
|
|
if ($val['use_type'] == 1) {
|
|
$val['use_rule'] = '每天一次';
|
|
} else if ($val['use_type'] == 2) {
|
|
$val['use_rule'] = '可用' . $val['frequency'] . '次，每日最多使用' . $val['limit'] . '次';
|
|
} else if ($val['use_type'] == 3) {
|
|
$val['use_rule'] = '每隔' . $val['limit'] . '天可使用一次';
|
|
}
|
|
$val['time_interval'] = str_replace(',', ' - ', $val['time_interval']);
|
|
// 使用有效时间
|
|
if ($val['effective_time_type'] == 1) {
|
|
if (!$val['effective_start'] || !$val['effective_end']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = date('Y/m/d', $val['effective_start']) . ' - ' . date('Y/m/d', $val['effective_end']);
|
|
}
|
|
} else if ($val['effective_time_type'] == 2) {
|
|
if (!$val['effective_day']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = '会员领取当日起' . $val['effective_day'] . '天内有效';
|
|
}
|
|
} else if ($val['effective_time_type'] == 3) {
|
|
if (!$val['effective_day']) {
|
|
$val['effective_time'] = '无效时间';
|
|
} else {
|
|
$val['effective_time'] = '会员领取次日起' . $val['effective_day'] . '天内有效';
|
|
}
|
|
}
|
|
|
|
// 图片
|
|
if ($val['gallery_id'] && $val['gallery_id'] != 0) {
|
|
$val['image_url'] = $ImageGallery->getFieldPath(array('id' => $val['gallery_id']));
|
|
} else {
|
|
$val['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 发放结束时间
|
|
$val['end_time'] = $card_bag['end_time'];
|
|
// 颜色
|
|
$val['card_name_color'] = $card_bag['card_name_color'];
|
|
$val['btn_background'] = $card_bag['btn_background'];
|
|
$val['btn_text_color'] = $card_bag['btn_text_color'];
|
|
// 类型
|
|
$val['type'] = $card_bag['type'];
|
|
}
|
|
$res = array('status' => 1, 'card_list' => $card_list);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 次卡，卡包商品
|
|
* @param int $merchant_id
|
|
* @param int $type
|
|
* @param int $card_id
|
|
* @param int $store_id
|
|
* @return array
|
|
*/
|
|
public function cardGoods($merchant_id, $type, $card_id, $store_id)
|
|
{
|
|
// 次卡，卡包商品条件
|
|
$CardGoods = new RetailCardGoodsModel();
|
|
$c_map = array(
|
|
'c.' . $CardGoods::MERCHANT_ID => $merchant_id,
|
|
'c.' . $CardGoods::STORE_ID => $store_id,
|
|
'c.' . $CardGoods::TYPE => $type,
|
|
'c.' . $CardGoods::C_ID => $card_id,
|
|
'c.' . $CardGoods::STATUS => 1,
|
|
);
|
|
$c_field = array(
|
|
'c.*', 'g.goods_name', 'g.retail_price', 'g.online_price', 'g.goods_num', 'g.plus_price', 'g.online_state', 'g.attribute_state',
|
|
'g.goods_img_id', 'g.shop_mem_status', 'g.shop_mem_price', 'g.store_mem_status', 'g.store_mem_price', 'g.plus_mem_status',
|
|
'g.pricing_method', 'g.vip_retail_state', 'g.vip_online_state', 'g.store_mem_integral', 'g.plus_mem_integral', 'g.company'
|
|
);
|
|
// 次卡，卡包商品查询
|
|
$card_goods = $CardGoods->getCardGoods($c_map, $c_field);
|
|
// 次卡，卡包商品判断
|
|
if (empty($card_goods)) {
|
|
$res = array(
|
|
'status' => 0,
|
|
'msg' => $type == 1 ? '卡包商品查询失败' : '次卡商品查询失败'
|
|
);
|
|
return $res;
|
|
}
|
|
// 规格公共条件
|
|
$SkuGoods = new RetailSkuGoodsModel();
|
|
$sku_map = array(
|
|
'k.' . $SkuGoods::STORE_ID => $store_id,
|
|
'k.' . $SkuGoods::STATUS => 1,
|
|
'k.' . $SkuGoods::STATE => 0,
|
|
);
|
|
$sku_field = array(
|
|
'k.' . $SkuGoods::ID, 'k.' . $SkuGoods::SKU_ID_LIST, 'k.' . $SkuGoods::ONLINE_PRICE, 'k.' . $SkuGoods::RETAIL_PRICE, 'k.' . $SkuGoods::GOODS_IMG,
|
|
'k.' . $SkuGoods::SKU_CODE, 'k.' . $SkuGoods::SHOP_MEM_PRICE, 'k.' . $SkuGoods::STORE_MEM_PRICE, 'k.' . $SkuGoods::PLUS_PRICE,
|
|
'k.' . $SkuGoods::GOODS_IMG_ID, 's.goods_num', 'k.store_mem_integral', 'k.plus_mem_integral'
|
|
);
|
|
// 商品库存公共条件
|
|
$SSaleMGoods = new SSaleMGoodsModel();
|
|
$sag_map = array(
|
|
'merchant_id' => $merchant_id,
|
|
'store_id' => $store_id,
|
|
);
|
|
// 处理数据
|
|
$SkuList = new RetailSkuListModel();
|
|
foreach ($card_goods as &$value) {
|
|
$value['number'] = floatval($value['number']);
|
|
// 库存
|
|
$sg_map2 = $sag_map;
|
|
$sg_map2['goods_id'] = $value[$CardGoods::GOODS_ID];
|
|
$value['goods_num'] = $SSaleMGoods->getFindField($sg_map2, 'goods_num');
|
|
$value['goods_num'] = floatval($value['goods_num']) > 0 ? floatval($value['goods_num']) : 0;
|
|
// 金额
|
|
$value['retail_price'] = floatval($value['retail_price']); // 门店
|
|
$value['online_price'] = floatval($value['online_price']); // 商城
|
|
$value['plus_price'] = floatval($value['plus_price']); // plus会员
|
|
$value['shop_mem_price'] = floatval($value['shop_mem_price']); // 商城会员
|
|
$value['store_mem_price'] = floatval($value['store_mem_price']); // 门店会员
|
|
$value['goods_num'] = floatval($value['goods_num']);
|
|
// 判断指定规格
|
|
if ($value[$CardGoods::SKU_ID]) {
|
|
// 条件
|
|
$sku_map2 = $sku_map;
|
|
$sku_map2['k.' . $SkuGoods::ID] = $value[$CardGoods::SKU_ID];
|
|
$sku_map2['k.' . $SkuGoods::GOODS_ID] = $value[$CardGoods::GOODS_ID];
|
|
// 查询
|
|
$sku_goods = $SkuGoods->getSkuGoodsInfo($sku_map2, $sku_field);
|
|
// 判断
|
|
if (empty($sku_goods)) {
|
|
// 清除指定规格
|
|
$value[$CardGoods::SKU_ID] = 0;
|
|
} else {
|
|
// 规格
|
|
$sku_name = $SkuList->getFindField(array($SkuList::ID => array('in', $sku_goods[$SkuGoods::SKU_ID_LIST])), $SkuList::NAME, true);
|
|
$value['sku_id_list'] = $sku_goods['sku_id_list'];
|
|
$value['sku_name'] = implode(',', $sku_name);
|
|
$value['sku'] = array(
|
|
array('id' => $value[$CardGoods::SKU_ID], 'name' => $value['sku_name'])
|
|
);
|
|
// 库存
|
|
$value['goods_num'] = floatval($sku_goods['goods_num']) > 0 ? floatval($sku_goods['goods_num']) : 0;
|
|
// 金额
|
|
$value['retail_price'] = floatval($sku_goods[$SkuGoods::RETAIL_PRICE]);
|
|
$value['online_price'] = floatval($sku_goods[$SkuGoods::ONLINE_PRICE]);
|
|
$value['plus_price'] = floatval($sku_goods[$SkuGoods::PLUS_PRICE]);
|
|
$value['shop_mem_price'] = floatval($sku_goods[$SkuGoods::SHOP_MEM_PRICE]);
|
|
$value['store_mem_price'] = floatval($sku_goods[$SkuGoods::STORE_MEM_PRICE]);
|
|
$value['store_mem_integral'] = floatval($sku_goods['store_mem_integral']);
|
|
$value['plus_mem_integral'] = floatval($sku_goods['plus_mem_integral']);
|
|
// 图片
|
|
$value['goods_img_id'] = $sku_goods[$SkuGoods::GOODS_IMG_ID];
|
|
}
|
|
unset($sku_map2);
|
|
unset($sku_name);
|
|
unset($sku_goods);
|
|
}
|
|
// 图片
|
|
$value['goods_image'] = getGoodsImage($value['goods_img_id'], $store_id);
|
|
// 判断规格商品
|
|
if ($value['attribute_state'] == 2) {
|
|
$sku_map2 = $sku_map;
|
|
$sku_map2['k.' . $SkuGoods::GOODS_ID] = $value[$CardGoods::GOODS_ID];
|
|
$sku_goods = $SkuGoods->getSkuGoodsList($sku_map2, $sku_field);
|
|
if (empty($sku_goods)) {
|
|
// 关闭规格
|
|
$value['attribute_state'] = 1;
|
|
} else {
|
|
// 处理商品规格
|
|
$str = '';
|
|
foreach ($sku_goods as &$val) {
|
|
$str .= ',' . $val[$SkuGoods::SKU_ID_LIST];
|
|
$val[$SkuGoods::GOODS_IMG] = getGoodsImage($val[$SkuGoods::GOODS_IMG_ID], $store_id);
|
|
$name = $SkuList->getFindField(array($SkuList::ID => array('in', $val[$SkuGoods::SKU_ID_LIST])), $SkuList::NAME, true);
|
|
$val['name'] = implode('，', $name);
|
|
$val['store_mem_status'] = $value['store_mem_status'];
|
|
$val['shop_mem_status'] = $value['shop_mem_status'];
|
|
$val['plus_mem_status'] = $value['plus_mem_status'];
|
|
}
|
|
$str = ltrim($str, ',');
|
|
$sku_id_list = explode(',', $sku_goods[0][$SkuGoods::SKU_ID_LIST]);
|
|
$attr = array();
|
|
foreach ($sku_id_list as &$v) {
|
|
$list_map['l.' . $SkuList::ID] = $v;
|
|
$tempAttr = $SkuList->getCashierSkuList($list_map);
|
|
$tempAttr['list'] = $SkuList->getSelect(array($SkuList::ID => array('in', $str), $SkuList::ATTR_ID => $tempAttr[$SkuList::ID], $SkuList::STATE => 0), array($SkuList::ID, $SkuList::NAME));
|
|
$attr[] = $tempAttr;
|
|
}
|
|
$value['skuList'] = $sku_goods;
|
|
$value['skuAttr'] = $attr;
|
|
}
|
|
}
|
|
$value['skuAttr'] = !empty($value['skuAttr']) ? $value['skuAttr'] : array();
|
|
$value['skuList'] = !empty($value['skuList']) ? $value['skuList'] : array();
|
|
}
|
|
$res = array('status' => 1, 'card_goods' => $card_goods);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 支付完成，发放次卡
|
|
* @param array $pay_order
|
|
* @return array
|
|
*/
|
|
public function updataCardOrder($pay_order)
|
|
{
|
|
// 条件
|
|
$CardOrder = new RetailCardOrderModel(); // 次卡订单
|
|
$PayOrder = new RetailPayOrderModel(); // 流水
|
|
$co_map = array(
|
|
$CardOrder::MERCHANT_ID => $pay_order[$PayOrder::MERCHANT_ID],
|
|
$CardOrder::STORE_ID => $pay_order[$PayOrder::STORE_ID],
|
|
$CardOrder::VIP_ID => $pay_order[$PayOrder::VID],
|
|
$CardOrder::STATE => 0,
|
|
$CardOrder::PAY_ORDER_ID => $pay_order[$PayOrder::ID],
|
|
);
|
|
$card_order = $CardOrder->getFind($co_map);
|
|
if (empty($card_order)) {
|
|
$res = array('status' => 0, 'msg' => '订单查询失败');
|
|
return $res;
|
|
}
|
|
// 会员
|
|
$Vip = new RetailVipModel();
|
|
// 条件
|
|
$v_map = array(
|
|
$Vip::ID => $pay_order[$PayOrder::VID],
|
|
$Vip::MERCHANT_ID => $pay_order[$PayOrder::MERCHANT_ID],
|
|
$Vip::STATUS => array('neq', 2)
|
|
);
|
|
// 查询
|
|
$vip_info = $Vip->getFind($v_map);
|
|
if (empty($vip_info)) {
|
|
$res = array('status' => 0, 'msg' => '会员信息查询失败');
|
|
return $res;
|
|
}
|
|
// 判断发放类型
|
|
$time = time();
|
|
$VipCardApi = new VipCardController();
|
|
if ($card_order[$CardOrder::TYPE] == 1) {
|
|
// 次卡
|
|
$SubCard = new SubCardModel();
|
|
// 条件
|
|
$sc_map = array(
|
|
'id' => $card_order[$CardOrder::CARD_ID],
|
|
'merchantid' => $pay_order[$PayOrder::MERCHANT_ID],
|
|
'type' => 4,
|
|
'card_type' => 1,
|
|
'storeids' => $pay_order[$PayOrder::STORE_ID],
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 查询
|
|
$sub_card = $SubCard->toSelect($sc_map);
|
|
// 判断
|
|
if (empty($sub_card)) {
|
|
$res = array('status' => 0, 'msg' => '次卡信息查询失败');
|
|
return $res;
|
|
}
|
|
// 发放
|
|
$res = $VipCardApi->vipGetSubCard($pay_order[$PayOrder::MERCHANT_ID], $vip_info, $sub_card, 0, 0, $pay_order[$PayOrder::ID]);
|
|
} else {
|
|
// 卡包
|
|
$CardBag = new CardBagModel();
|
|
// 条件
|
|
$cb_map = array(
|
|
'id' => $card_order[$CardOrder::CARD_ID],
|
|
'merchantid' => $pay_order[$PayOrder::MERCHANT_ID],
|
|
'type' => 4,
|
|
'storeids' => $pay_order[$PayOrder::STORE_ID],
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 查询
|
|
$card_bag = $CardBag->toSelect($cb_map);
|
|
// 判断
|
|
if (empty($card_bag)) {
|
|
$res = array('status' => 0, 'msg' => '次卡信息查询失败');
|
|
return $res;
|
|
}
|
|
// 发放
|
|
$res = $VipCardApi->vipGetCardBag($pay_order[$PayOrder::MERCHANT_ID], $vip_info, $card_bag, 0, 0, $pay_order[$PayOrder::ID]);
|
|
}
|
|
// 更新card_order
|
|
if ($res['status'] == 1) {
|
|
$CardOrder->updateOrder(array($CardOrder::ID => $card_order[$CardOrder::ID]), array($CardOrder::STATE => 1));
|
|
}
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 用户次卡列表
|
|
* @param $merchant_id
|
|
* @param $vip_id
|
|
* @param $page
|
|
* @param $limit
|
|
* @param string $card_id
|
|
* @param bool $get_can_use
|
|
* @return array
|
|
*/
|
|
public function userCardList($merchant_id, $vip_id, $page, $limit, $card_id = '', $get_can_use = true)
|
|
{
|
|
// 条件
|
|
$time = time();
|
|
$map = array(
|
|
'Vip.id' => $vip_id,
|
|
'VipCard.merchantid' => $merchant_id,
|
|
'VipCard.status' => 0,
|
|
);
|
|
if ($get_can_use) {
|
|
//仅获取在有效期内的卡
|
|
$map['VipCard.state'] = 0;
|
|
$map['VipCard.start_time'] = ['elt', $time];
|
|
$map['VipCard.end_time'] = ['egt', $time];
|
|
}
|
|
if ($card_id) {
|
|
$map['VipCard.id'] = $card_id;
|
|
}
|
|
$field = array(
|
|
'name', 'use_type', 'frequency', 'limit_num', 'gallery_id', 'image', 'id', 'use_num', 'time_interval', 'effective_start',
|
|
'effective_end', 'card_type', 'sub_card_id', 'card_bag_id', 'use_num', 'addtime', 'state', 'effective_time_type', 'effective_day', 'start_time', 'end_time'
|
|
);
|
|
$start_time = strtotime(date('Y-m-d')); // 今日开始时间
|
|
// 查询
|
|
$SubCardView = new SubCardViewModel();
|
|
$card_list = $SubCardView->toSelect($map, $page, $limit, $field, 'VipCard.state asc,VipCard.id desc,SubCard.effective_end desc');
|
|
// 处理数据
|
|
$RetailVipCardRecordModel = new RetailVipCardRecordModel();
|
|
$ImageGallery = new ImageGalleryModel();
|
|
$SubCard = new SubCardModel();
|
|
$CardBag = new CardBagModel();
|
|
$returnArr = [];
|
|
foreach ($card_list as $key => &$val) {
|
|
// 判断是否使用完毕
|
|
if ($val['state'] == 1) {
|
|
$val['is_use'] = 2;
|
|
}
|
|
$useMap = [
|
|
'vip_id' => $vip_id,
|
|
'merchantid' => $merchant_id,
|
|
'vip_card_id' => $val['id'],
|
|
'addtime' => ['between', [$start_time, time()]],
|
|
];
|
|
// 今日使用次数和剩余次数处理
|
|
//is_use 1可用 2用完 3过期 4异常
|
|
switch ($val['use_type']) {
|
|
case '1':
|
|
//每天一次
|
|
$val['day_limit_num'] = 1;
|
|
$day_use_num = $RetailVipCardRecordModel->getCount($useMap);
|
|
$val['canUseNum'] = bcsub($val['day_limit_num'], $day_use_num);
|
|
break;
|
|
case '2':
|
|
//自定义总次数，且限制每天使用次数
|
|
$day_use_num = $RetailVipCardRecordModel->getCount($useMap);
|
|
$day_less_num = bcsub($val['frequency'] + $day_use_num, $val['use_num']);
|
|
$val['day_limit_num'] = $day_less_num >= $val['limit_num'] ? $val['limit_num'] : $day_less_num;
|
|
|
|
$val['canUseNum'] = bcsub($val['day_limit_num'], $day_use_num);
|
|
break;
|
|
case '3':
|
|
//几天可使用一次
|
|
unset($useMap['addtime']);
|
|
$pre_use_time = $RetailVipCardRecordModel->getOrderFindField($useMap, 'addtime', 'id desc');
|
|
$pre_use_start_time = strtotime(date('Y-m-d', $pre_use_time));//15 00:00:00
|
|
$min_pre_use_start_time = $start_time - ($val['limit_num'] * 86400);//18 00:00:00 - 3*86400 = 15 00:00:00
|
|
if (empty($pre_use_time) || $pre_use_start_time <= $min_pre_use_start_time) {
|
|
$val['day_limit_num'] = 1;
|
|
$val['canUseNum'] = 1;
|
|
} else if ($pre_use_start_time == $start_time) {
|
|
$val['day_limit_num'] = 1;
|
|
$val['canUseNum'] = 0;
|
|
} else {
|
|
$val['day_limit_num'] = 0;
|
|
$val['canUseNum'] = 0;
|
|
}
|
|
break;
|
|
}
|
|
|
|
//判断是否可以使用
|
|
if ($val['state'] == 1) {
|
|
//已用完
|
|
$val['is_use'] = 2;
|
|
} else if ($val['start_time'] <= $time && $val['end_time'] >= $time) {
|
|
//可以使用
|
|
$val['is_use'] = 1;
|
|
} else if ($val['end_time'] < $time) {
|
|
//已过期
|
|
$val['is_use'] = 3;
|
|
} else if ($val['start_time'] > $time) {
|
|
//未开始
|
|
$val['is_use'] = 5;
|
|
} else {
|
|
//异常
|
|
$val['is_use'] = 4;
|
|
}
|
|
$val['is_use'] = $val['end_time'] < $time ? 3 : ($val['canUseNum'] ? 1 : 2);
|
|
//有效期
|
|
$val['effective_time'] = date('Y/m/d', $val['start_time']) . ' ~ ' . date('Y/m/d', $val['end_time']);
|
|
// 领取时间
|
|
$val['addtime'] = date('Y/m/d H:i:s', $val['addtime']);
|
|
|
|
// 图片
|
|
if ($val['gallery_id'] && $val['gallery_id'] != 0) {
|
|
$val['image_url'] = $ImageGallery->getFieldPath(array('id' => $val['gallery_id']));
|
|
} else {
|
|
$val['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 判断类型
|
|
if ($val['card_type'] == 1 && $val['sub_card_id']) {
|
|
$info = $SubCard->toFind(array('id' => $val['sub_card_id']), 'card_name_color,btn_background,btn_text_color');
|
|
} else if ($val['card_type'] == 2 && $val['card_bag_id']) {
|
|
$info = $CardBag->toFind(array('id' => $val['card_bag_id']), 'card_name_color,btn_background,btn_text_color');
|
|
} else {
|
|
$info = array();
|
|
}
|
|
// 判断$info
|
|
if (!empty($info)) {
|
|
$val['card_name_color'] = $info['card_name_color'] ? $info['card_name_color'] : '#FFFFFF';
|
|
$val['btn_background'] = $info['btn_background'] ? $info['btn_background'] : '#FFFFFF';
|
|
$val['btn_text_color'] = $info['btn_text_color'] ? $info['btn_text_color'] : '#36549a';
|
|
} else {
|
|
$val['card_name_color'] = '#FFFFFF';
|
|
$val['btn_background'] = '#FFFFFF';
|
|
$val['btn_text_color'] = '#36549a';
|
|
}
|
|
$returnArr[] = $val;
|
|
}
|
|
$res = array('status' => 1, 'card_list' => !empty($returnArr) ? $returnArr : array());
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 删除次卡
|
|
* @param int $merchant_id
|
|
* @param int $vip_id
|
|
* @param int $vip_card_id
|
|
* @return array
|
|
*/
|
|
public function deleteCard($merchant_id, $vip_id, $vip_card_id)
|
|
{
|
|
// 条件
|
|
$map = array(
|
|
'VipCard.id' => $vip_card_id,
|
|
'VipCard.merchantid' => $merchant_id,
|
|
'VipCard.status' => 0,
|
|
'Vip.id' => $vip_id,
|
|
);
|
|
// 查询
|
|
$SubCardView = new SubCardViewModel();
|
|
$user_card = $SubCardView->toFind($map);
|
|
// 判断
|
|
if (empty($user_card)) {
|
|
$res = array('status' => 0, 'msg' => '查询失败');
|
|
return $res;
|
|
}
|
|
// 删除次卡
|
|
$VipCard = new RetailVipCardModel();
|
|
$save = $VipCard->updateOrder(array('id' => $vip_card_id), array('status' => 1));
|
|
if ($save) {
|
|
$res = array('status' => 1, 'msg' => '删除成功');
|
|
} else {
|
|
$res = array('status' => 0, 'msg' => '删除失败');
|
|
}
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 用户次卡详情
|
|
* @param int $merchant_id
|
|
* @param int $vip_id
|
|
* @param int $vip_card_id
|
|
* @return array
|
|
*/
|
|
public function userCardInfo($merchant_id, $vip_id, $vip_card_id)
|
|
{
|
|
// 条件
|
|
$map = array(
|
|
'VipCard.id' => $vip_card_id,
|
|
'VipCard.merchantid' => $merchant_id,
|
|
'VipCard.status' => 0,
|
|
'Vip.id' => $vip_id,
|
|
);
|
|
$field = array(
|
|
'name', 'use_type', 'frequency', 'limit_num', 'time_interval', 'gallery_id', 'image', 'introduce',
|
|
'effective_start', 'effective_end', 'card_type', 'sub_card_id', 'card_bag_id',
|
|
'use_num', 'addtime', 'state', 'effective_time_type', 'effective_day', 'start_time', 'end_time'
|
|
);
|
|
// 查询
|
|
$SubCardView = new SubCardViewModel();
|
|
$user_card = $SubCardView->toFind($map, $field);
|
|
// 判断
|
|
if (empty($user_card)) {
|
|
$res = array('status' => 0, 'msg' => '查询失败');
|
|
return $res;
|
|
}
|
|
// 处理数据
|
|
$user_card['is_use'] = $user_card['end_time'] < time() ? 2 : 1;
|
|
//有效期
|
|
$user_card['effective_time'] = date('Y/m/d', $user_card['start_time']) . ' ~ ' . date('Y/m/d', $user_card['end_time']);
|
|
|
|
// 领取时间
|
|
$user_card['add_time'] = date('Y/m/d H:i:s', $user_card['addtime']);
|
|
|
|
// 类型 总次数
|
|
switch ($user_card['use_type']){
|
|
case '1':
|
|
//每天一次
|
|
$user_card['frequency'] = round(($user_card['end_time'] - $user_card['start_time']) / 86400);
|
|
$user_card['use_rule'] = '每天一次';
|
|
break;
|
|
case '2':
|
|
//自定义总次数，且限制每天使用次数
|
|
$user_card['frequency'] = intval($user_card['frequency']);
|
|
$user_card['limit_num'] = intval($user_card['limit_num']);
|
|
$user_card['use_rule'] = '可用' . $user_card['frequency'] . '次，每日最多使用' . intval($user_card['limit_num']) . '次';
|
|
break;
|
|
case '3':
|
|
//每隔几天可用一次
|
|
$user_card['limit_num'] = intval($user_card['limit_num']);
|
|
$user_card['frequency'] = ceil(($user_card['end_time'] - $user_card['start_time']) / 86400 / ($user_card['limit_num']));
|
|
$user_card['use_rule'] = '每隔' . intval($user_card['limit_num']) . '天可使用一次';
|
|
break;
|
|
}
|
|
// 使用次数
|
|
$user_card['use_num'] = intval($user_card['use_num']);
|
|
// 剩余次数
|
|
$user_card['residue_num'] = $user_card['frequency'] - $user_card['use_num'] > 0 ? intval($user_card['frequency'] - $user_card['use_num']) : 0;
|
|
// 判断剩余次数
|
|
if ($user_card['state'] == 1) {
|
|
$user_card['is_use'] = 2;
|
|
}
|
|
// 时段
|
|
$user_card['time_interval'] = str_replace(',', ' - ', $user_card['time_interval']);
|
|
|
|
// 图片
|
|
if ($user_card['gallery_id'] && $user_card['gallery_id'] != 0) {
|
|
$ImageGallery = new ImageGalleryModel();
|
|
$user_card['image_url'] = $ImageGallery->getFieldPath(array('id' => $user_card['gallery_id']));
|
|
} else {
|
|
$user_card['image_url'] = getServerUrl() . '/Public/paper/images/sub_card.png';
|
|
}
|
|
// 使用说明
|
|
$user_card['introduce'] = trim($user_card['introduce']) ? trim($user_card['introduce']) : '暂无说明';
|
|
// 判断类型 查询指定门店
|
|
if ($user_card['card_type'] == 1 && $user_card['sub_card_id']) {
|
|
$SubCard = new SubCardModel();
|
|
$info = $SubCard->toFind(array('id' => $user_card['sub_card_id']), 'card_name_color,storeids');
|
|
} else if ($user_card['card_type'] == 2 && $user_card['card_bag_id']) {
|
|
$CardBag = new CardBagModel();
|
|
$info = $CardBag->toFind(array('id' => $user_card['card_bag_id']), 'card_name_color,storeids');
|
|
} else {
|
|
$res = array('status' => 0, 'msg' => '未知的次卡类型');
|
|
return $res;
|
|
}
|
|
// 颜色
|
|
$user_card['card_name_color'] = $info['card_name_color'] ? $info['card_name_color'] : '#FFFFFF';
|
|
// 判断门店
|
|
if ($info['storeids'] && ($info['storeids'] != 0 || $info['storeids'] != '0')) {
|
|
// 查询门店
|
|
$Store = new RetailStoreModel();
|
|
$user_card['store_data'] = $Store->getFindField(array($Store::ID => array('in', $info['storeids']), $Store::MERCHANT_ID => $merchant_id), $Store::STORE_NAME, true);
|
|
} else {
|
|
$user_card['store_data'] = array('所有门店');
|
|
}
|
|
// 返回值
|
|
$res = array('status' => 1, 'user_card' => $user_card);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 使用次卡
|
|
* @param int $merchant_id
|
|
* @param int $vip_id
|
|
* @param int $vip_card_id
|
|
* @return array
|
|
*/
|
|
public function useCard($merchant_id, $vip_id, $vip_card_id)
|
|
{
|
|
// 条件
|
|
$map = array(
|
|
'VipCard.id' => $vip_card_id,
|
|
'VipCard.merchantid' => $merchant_id,
|
|
'VipCard.Vip_id' => $vip_id
|
|
);
|
|
$field = array('name', 'state');
|
|
// 查询
|
|
$SubCardView = new SubCardViewModel();
|
|
$user_card = $SubCardView->toFind($map, $field);
|
|
// 判断
|
|
if (empty($user_card)) {
|
|
$res = array('status' => 0, 'msg' => '查询失败');
|
|
return $res;
|
|
}
|
|
// 判断是否使用完毕
|
|
if ($user_card['state'] == 1) {
|
|
$res = array('status' => 0, 'msg' => '该次卡已使用完毕');
|
|
return $res;
|
|
}
|
|
// 使用码记录
|
|
$time = time();
|
|
$code_cr = array(
|
|
'merchantid' => $merchant_id,
|
|
'vip_id' => $vip_id,
|
|
'vip_card_id' => $vip_card_id,
|
|
'addtime' => $time,
|
|
'end_time' => $time + 180,
|
|
'status' => 0
|
|
);
|
|
// 生成使用码
|
|
$use_code = $this->generateUseCode();
|
|
if (!$use_code || $use_code == '') {
|
|
$res = array('status' => 0, 'msg' => '使用码生成失败');
|
|
return $res;
|
|
}
|
|
$code_cr['use_code'] = $use_code;
|
|
// 添加
|
|
$CardUseCode = new CardUseCodeModel();
|
|
$code_add = $CardUseCode->toAdd($code_cr);
|
|
// 判断
|
|
if ($code_add) {
|
|
$res = array('status' => 1, 'use_code' => $use_code, 'card_name' => $user_card['name']);
|
|
} else {
|
|
$res = array('status' => 0, '使用码生成失败');
|
|
}
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 生成使用码
|
|
* @return mixed
|
|
*/
|
|
protected function generateUseCode()
|
|
{
|
|
// 实例化模型
|
|
$CardUseCode = new CardUseCodeModel();
|
|
$i = 0;
|
|
$use_code = '';
|
|
while ($i < 10) {
|
|
// 生成11位使用码
|
|
$use_code = rand(100000, 999999) . rand(10000, 99999);
|
|
// 查询使用码是否存在
|
|
$find = $CardUseCode->toFind(array('use_code' => $use_code));
|
|
if (!$find) {
|
|
$i = 11;
|
|
} else {
|
|
$i++;
|
|
}
|
|
}
|
|
return $use_code;
|
|
}
|
|
|
|
/**
|
|
* 购买商品验证次卡是否可以购买
|
|
*
|
|
*/
|
|
public function checkCard($merchant_id, $store_id, $vip_id, $card_id, $card_type, $type, $source)
|
|
{
|
|
// 判断 $card_type
|
|
$SubCard = new SubCardModel(); // 次卡
|
|
$CardBag = new CardBagModel(); // 卡包
|
|
$time = time();
|
|
if ($card_type == 1) {
|
|
// 判断次卡
|
|
$sc_map = array(
|
|
'id' => $card_id,
|
|
'merchantid' => $merchant_id,
|
|
'type' => $type,
|
|
'card_type' => 1,
|
|
'storeids' => $store_id,
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 判断来源
|
|
if ($source == 1) {
|
|
$sc_map['line_state'] = 1;
|
|
} else {
|
|
$sc_map['online_state'] = 1;
|
|
}
|
|
$data = $SubCard->tofind($sc_map);
|
|
} else {
|
|
// 判断卡包
|
|
$cb_map = array(
|
|
'id' => $card_id,
|
|
'merchantid' => $merchant_id,
|
|
'type' => $type,
|
|
'storeids' => $store_id,
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 判断来源
|
|
if ($source == 1) {
|
|
$cb_map['line_state'] = 1;
|
|
} else {
|
|
$cb_map['online_state'] = 1;
|
|
}
|
|
// 查询
|
|
$data = $CardBag->tofind($cb_map);
|
|
}
|
|
// 判断
|
|
if (empty($data)) {
|
|
$res = array(
|
|
'status' => 0,
|
|
'msg' => $card_type == 1 ? '次卡活动查询失败' : '卡包活动查询失败'
|
|
);
|
|
return $res;
|
|
}
|
|
// 判断购买次数
|
|
$CardOrder = new RetailCardOrderModel(); // 购买记录
|
|
$co_map = array(
|
|
$CardOrder::MERCHANT_ID => $merchant_id,
|
|
$CardOrder::STORE_ID => $store_id,
|
|
$CardOrder::VIP_ID => $vip_id,
|
|
$CardOrder::TYPE => $card_type,
|
|
$CardOrder::CARD_ID => $card_id,
|
|
$CardOrder::STATE => 1,
|
|
);
|
|
$co_count = $CardOrder->getCount($co_map);
|
|
if ($co_count && intval($co_count) >= intval($data['give_num'])) {
|
|
$res = array(
|
|
'status' => 0,
|
|
'msg' => $card_type == 1 ? '购买过该次卡活动次数已达上限' : '购买过该卡包活动次数已达上限'
|
|
);
|
|
return $res;
|
|
}
|
|
// 验证通过
|
|
$res = array('status' => 1, 'data' => $data);
|
|
return $res;
|
|
}
|
|
|
|
/**
|
|
* 购买商品发放次卡，卡包
|
|
* @param array $billOrder
|
|
* @return array
|
|
*/
|
|
public function grantCard($card_order, $vip_id)
|
|
{
|
|
$CardOrder = new RetailCardOrderModel(); // 次卡订单
|
|
$Vip = new RetailVipModel();
|
|
// 条件
|
|
$v_map = array(
|
|
$Vip::ID => $vip_id,
|
|
$Vip::MERCHANT_ID => $card_order[$CardOrder::MERCHANT_ID],
|
|
$Vip::STATUS => array('neq', 2)
|
|
);
|
|
// 查询会员
|
|
$vip_info = $Vip->getFind($v_map);
|
|
if (empty($vip_info)) {
|
|
$res = array('status' => 0, 'msg' => '会员信息查询失败');
|
|
return $res;
|
|
}
|
|
// 判断发放类型
|
|
$time = time();
|
|
$VipCardApi = new VipCardController();
|
|
if ($card_order[$CardOrder::TYPE] == 1) {
|
|
// 次卡
|
|
$SubCard = new SubCardModel();
|
|
// 条件
|
|
$sc_map = array(
|
|
'id' => $card_order[$CardOrder::CARD_ID],
|
|
'merchantid' => $card_order[$CardOrder::MERCHANT_ID],
|
|
'type' => 5,
|
|
'card_type' => 1,
|
|
'storeids' => $card_order[$CardOrder::STORE_ID],
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 查询
|
|
$sub_card = $SubCard->toSelect($sc_map);
|
|
// 判断
|
|
if (empty($sub_card)) {
|
|
$res = array('status' => 0, 'msg' => '次卡信息查询失败');
|
|
return $res;
|
|
}
|
|
// 发放
|
|
$res = $VipCardApi->vipGetSubCard($card_order[$CardOrder::MERCHANT_ID], $vip_info, $sub_card, 0, 0, 0, $card_order[$CardOrder::BILL_ID]);
|
|
} else {
|
|
// 卡包
|
|
$CardBag = new CardBagModel();
|
|
// 条件
|
|
$cb_map = array(
|
|
'id' => $card_order[$CardOrder::CARD_ID],
|
|
'merchantid' => $card_order[$CardOrder::MERCHANT_ID],
|
|
'type' => 5,
|
|
'storeids' => $card_order[$CardOrder::STORE_ID],
|
|
'_string' => "end_time > {$time} AND surplus > 0 AND status = 0",
|
|
);
|
|
// 查询
|
|
$card_bag = $CardBag->toSelect($cb_map);
|
|
// 判断
|
|
if (empty($card_bag)) {
|
|
$res = array('status' => 0, 'msg' => '次卡信息查询失败');
|
|
return $res;
|
|
}
|
|
// 发放
|
|
$res = $VipCardApi->vipGetCardBag($card_order[$CardOrder::MERCHANT_ID], $vip_info, $card_bag, 0, 0, 0, $card_order[$CardOrder::BILL_ID]);
|
|
}
|
|
return $res;
|
|
}
|
|
}
|