jh-admin/addon/cardservice/model/CardGoods.php

1472 lines
73 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
/**
* SaaSMall商城系统 - 团队十年电商经验汇集巨献!
* =========================================================
* Copy right 2019-2029 成都SAAS云科技有限公司, 保留所有权利。
* ----------------------------------------------
* 官方网址: https://www.gobuysaas.com
* =========================================================
*/
namespace addon\cardservice\model;
use addon\discount\model\Discount;
use app\model\BaseModel;
use app\model\goods\GoodsStock;
use app\model\storegoods\StoreGoods;
use app\model\system\Cron;
use app\model\system\Stat;
use extend\Time;
/**
* 虚拟商品
*/
class CardGoods extends BaseModel
{
private $goods_class = array('id' => 5, 'name' => '卡项套餐');
private $goods_state = array(
1 => '销售中',
0 => '仓库中'
);
public $card_type = [
'commoncard' => [
'title' => '通用卡',
'type' => 'commoncard',
'desc' => '会员可在设定次数内任意使用卡内项目/商品'
],
'oncecard' => [
'title' => '限次卡',
'desc' => '支持创建多个项目/商品集合有限次数卡',
'type' => 'oncecard'
],
'timecard' => [
'title' => '限时卡',
'type' => 'timecard',
'desc' => '支持创建多个项目/商品集合不限次数卡'
]
];
public $card_name = [
'month' => '月',
'week' => '周',
'number' => '次',
'year' => '年',
'discount_num' => '次',
'discount_week' => '周',
'discount_month' => '月'
];
public function getCardType($type = '')
{
if (empty($type)) {
return $this->card_type;
} else {
return $this->card_type[$type];
}
}
public function getGoodsState()
{
return $this->goods_state;
}
public function getGoodsClass()
{
return $this->goods_class;
}
/**
* 商品添加
* @param $data
*/
public function addGoods($data)
{
model('goods')->startTrans();
try {
if (!empty($data['goods_attr_format'])) {
$goods_attr_format = json_decode($data['goods_attr_format'], true);
$keys = array_column($goods_attr_format, 'sort');
if (!empty($keys)) {
array_multisort($keys, SORT_ASC, SORT_NUMERIC, $goods_attr_format);
$data['goods_attr_format'] = json_encode($goods_attr_format);
}
}
$goods_image = $data['goods_image'];
$first_image = explode(",", $goods_image)[0];
//SKU商品数据
if (!empty($data['goods_sku_data'])) {
$data['goods_sku_data'] = json_decode($data['goods_sku_data'], true);
}
//获取标签名称
$label_name = '';
if ($data['label_id']) {
$label_info = model('goods_label')->getInfo([['id', '=', $data['label_id']]], 'label_name');
$label_name = $label_info['label_name'] ?? '';
}
$brand_name = '';
if ($data['brand_id']) {
$brand_info = model('goods_brand')->getInfo([['brand_id', '=', $data['brand_id']]], 'brand_name');
$brand_name = $brand_info['brand_name'] ?? '';
}
$goods_data = array(
'goods_image' => $goods_image,
'price' => $data['goods_sku_data'][0]['price'],
'market_price' => $data['goods_sku_data'][0]['market_price'],
'cost_price' => $data['goods_sku_data'][0]['cost_price'],
'goods_spec_format' => $data['goods_spec_format'],
'category_id' => $data['category_id'],
'category_json' => $data['category_json'],
'label_id' => $data['label_id'],
'label_name' => $label_name,
'timer_on' => $data['timer_on'],
'timer_off' => $data['timer_off'],
'sale_show' => $data['sale_show'] ?? 1,
'stock_show' => $data['stock_show'] ?? 1,
'market_price_show' => $data['market_price_show'] ?? 1,
'barrage_show' => $data['barrage_show'] ?? 1,
'is_consume_discount' => $data['is_consume_discount'],
'promotion_addon' => $data['promotion_addon'] ?? '',
'discount_method' => $data['discount_method'] ?? '',
'period_type' => $data['cloud_card_type'],
'period' => $data['common_num'],
'is_zmxx' => $data['is_zmxx']
);
$common_data = array(
'goods_name' => $data['goods_name'],
'goods_class' => $this->goods_class['id'],
'goods_class_name' => $this->goods_class['name'],
'goods_attr_class' => $data['goods_attr_class'],
'goods_attr_name' => $data['goods_attr_name'],
'is_limit' => isset($data['is_limit']) ? $data['is_limit'] : 0,
'limit_type' => isset($data['limit_type']) ? $data['limit_type'] : 1,
'site_id' => $data['site_id'],
'goods_content' => $data['goods_content'],
'goods_state' => $data['goods_state'],
'goods_stock_alarm' => $data['goods_stock_alarm'],
'is_virtual' => 1,
'virtual_indate' => 0,
'goods_attr_format' => $data['goods_attr_format'],
'introduction' => $data['introduction'],
'keywords' => $data['keywords'],
'unit' => $data['unit'],
'brand_id' => $data['brand_id'],//品牌id
'brand_name' => $brand_name,//品牌名称
'video_url' => $data['video_url'],
'sort' => $data['sort'],
'goods_service_ids' => $data['goods_service_ids'],
'create_time' => time(),
'virtual_sale' => $data['virtual_sale'],
'max_buy' => $data['max_buy'],
'min_buy' => $data['min_buy'],
'recommend_way' => $data['recommend_way'],
'qr_id' => isset($data['qr_id']) ? $data['qr_id'] : 0,
'template_id' => isset($data['template_id']) ? $data['template_id'] : 0,
'form_id' => $data['form_id'] ?? 0,
'sale_channel' => $data['sale_channel'] ?? 'all',
'sale_store' => $data['sale_store'] ?? 'all',
'is_unify_pirce' => $data['is_unify_pirce'] ?? 1,
);
$goods_id = model('goods')->add(array_merge($goods_data, $common_data));
$sku_arr = array();
$sku_stock_list = [];
//添加sku商品
foreach ($data['goods_sku_data'] as $item) {
$sku_data = array(
'sku_name' => $data['goods_name'] . ' ' . $item['spec_name'],
'spec_name' => $item['spec_name'],
'sku_no' => $item['sku_no'],
'sku_spec_format' => !empty($item['sku_spec_format']) ? json_encode($item['sku_spec_format']) : "",
'price' => $item['price'],
'market_price' => $item['market_price'],
'cost_price' => $item['cost_price'],
'discount_price' => $item['price'],//sku折扣价默认等于单价
'stock' => $item['stock'],
'stock_alarm' => $item['stock_alarm'],
'sku_image' => !empty($item['sku_image']) ? $item['sku_image'] : $first_image,
'sku_images' => $item['sku_images'],
'goods_id' => $goods_id,
'is_default' => $item['is_default'] ?? 0,
'is_consume_discount' => $data['is_consume_discount'],
'site_id' => $data['site_id']
);
$sku_arr[] = array_merge($sku_data, $common_data);
$sku_stock_list[] = [
'stock' => $item['stock'],
'site_id' => $data['site_id'],
'goods_class' => $common_data['goods_class']
];
}
if ($data['is_alipay_public'] == 1) {
$template = new AliGoodsTemplate();
$version = 1.5;
if ($version == 3) {
$card_template = $template->CreateAndModifyTemplate($data['site_id'], $goods_id, $data, 'create');
} else {
$card_template = $template->CreateUpdatePublic($data['site_id'], $goods_id, $data);
$card_template['data']['card_template_id'] = $card_template['data']['productNo'];
}
if ($card_template['code'] != 0) {
model('goods')->rollback();
return $card_template;
} else {
$card_template_id = $card_template['data']['card_template_id'];
}
}
model('goods_sku')->addList($sku_arr);
// 赋值第一个商品sku_id
$first_info = model('goods_sku')->getFirstData(['goods_id' => $goods_id], 'sku_id', 'is_default desc,sku_id asc');
model('goods')->update(['sku_id' => $first_info['sku_id'], 'goods_stock' => array_sum(array_column($sku_stock_list, 'stock'))], [['goods_id', '=', $goods_id]]);
if (!empty($data['goods_spec_format'])) {
// 刷新SKU商品规格项 / 规格值JSON字符串
$this->dealGoodsSkuSpecFormat($goods_id, $data['goods_spec_format']);
}
// 添加商品卡项表
$card_id = model('goods_card')->add([
'site_id' => $data['site_id'],
'goods_id' => $goods_id,
'card_type' => $data['card_type'],
'is_cloud_zmxx' => $data['is_cloud_zmxx'],
'discount_type' => $data['discount_type'],
'cloud_card_type' => $data['cloud_card_type'],
'downPaymentPeriods' => $data['downPaymentPeriods'],
'downPayment' => $data['downPayment'],
'periods' => $data['periods'],
'perPeriodPriceArray' => $data['perPeriodPriceArray'],
'use_rule' => $data['use_rule'],
'card_type_name' => $this->card_type[$data['card_type']]['title'],
'renew_price' => $data['renew_price'],
'recharge_money' => $data['recharge_money'] ?? 0,
'common_num' => $data['common_num'],
'discount_goods_type' => $data['discount_goods_type'],
'discount' => $data['discount'],
'validity_type' => $data['validity_type'],
'validity_day' => $data['validity_day'] ?? 0,
'validity_time' => $data['validity_time'] ?? 0,
'average_original_price' => $data['average_original_price'] ?? 0,
'average_discount_price' => $data['average_discount_price'] ?? 0,
'is_alipay_public' => $data['is_alipay_public'] ?? 0,
'alipay_cat_id' => $data['alipay_cat_id'] ?? 0,
'card_template_id' => $card_template_id ?? '',
'change_type' => $data['change_type'] ?? '',
'least_period' => $data['least_period'] ?? 0,
'downPaymentDate' => $data['downPaymentDate'] ?? 0,
]);
// 添加商品卡项项目表
$relation_goods = json_decode($data['relation_goods'], true);
if (!empty($relation_goods)) {
$goods_card_item = [];
foreach ($relation_goods as $item) {
array_push($goods_card_item, [
'site_id' => $data['site_id'],
'card_goods_id' => $goods_id,
'goods_id' => $item['goods_id'],
'sku_id' => $item['sku_id'],
'num' => $item['num'] ?? 0,
'discount' => $item['discount'] ?? 0,
]);
}
model('goods_card_item')->addList($goods_card_item);
}
$cron = new Cron();
//定时上下架
if ($goods_data['timer_on'] > 0) {
$cron->addCron(1, 0, "商品定时上架", "CronGoodsTimerOn", $goods_data['timer_on'], $goods_id);
}
if ($goods_data['timer_off'] > 0) {
$cron->addCron(1, 0, "商品定时下架", "CronGoodsTimerOff", $goods_data['timer_off'], $goods_id);
}
//添加统计
$stat = new Stat();
$stat->switchStat(['type' => 'add_goods', 'data' => ['add_goods_count' => 1, 'site_id' => $data['site_id']]]);
// 商品设置库存
$sku_list = model('goods_sku')->getList(['goods_id' => $goods_id], 'sku_id');
$goods_sku_model = new GoodsStock();
foreach ($sku_stock_list as $k => $v) { //设置库存问题
$sku_stock_list[$k]['sku_id'] = $sku_list[$k]['sku_id'];
if ($v['stock'] > 0) {
$sku_stock_data = [
'sku_id' => $sku_stock_list[$k]['sku_id'],
'num' => $v['stock']
];
$goods_sku_model->incStock($sku_stock_data);
}
}
event('AddGoods', [
'site_id' => $data['site_id'],
'goods_id' => $goods_id,
'goods_sku_list' => $sku_stock_list,
'goods_state' => $data['goods_state'],
'sale_store' => $data['sale_store'] ?? 'all',
'store_type' => $data['store_type'] ?? 'directsale',
'goods_name' => $data['goods_name'],
'alipay_cat_id' => $data['alipay_cat_id'],
'goods_class' => $common_data['goods_class']
]);
model('goods')->commit();
return $this->success($goods_id);
} catch (\Exception $e) {
model('goods')->rollback();
return $this->error($e->getMessage() . $e->getFile() . $e->getLine());
}
}
/**
* 商品编辑
* @param $data
*/
public function editGoods($data)
{
model('goods')->startTrans();
try {
if (!empty($data['goods_attr_format'])) {
$goods_attr_format = json_decode($data['goods_attr_format'], true);
$keys = array_column($goods_attr_format, 'sort');
if (!empty($keys)) {
array_multisort($keys, SORT_ASC, SORT_NUMERIC, $goods_attr_format);
$data['goods_attr_format'] = json_encode($goods_attr_format);
}
}
$goods_id = $data['goods_id'];
$goods_image = $data['goods_image'];
$first_image = explode(",", $goods_image)[0];
//SKU商品数据
if (!empty($data['goods_sku_data'])) {
$data['goods_sku_data'] = json_decode($data['goods_sku_data'], true);
}
//获取标签名称
$label_name = '';
if ($data['label_id']) {
$label_info = model('goods_label')->getInfo([['id', '=', $data['label_id']]], 'label_name');
$label_name = $label_info['label_name'] ?? '';
}
$brand_name = '';
if ($data['brand_id']) {
$brand_info = model('goods_brand')->getInfo([['brand_id', '=', $data['brand_id']]], 'brand_name');
$brand_name = $brand_info['brand_name'] ?? '';
}
$goods_data = array(
'goods_image' => $goods_image,
'price' => $data['goods_sku_data'][0]['price'],
'market_price' => $data['goods_sku_data'][0]['market_price'],
'cost_price' => $data['goods_sku_data'][0]['cost_price'],
'goods_spec_format' => $data['goods_spec_format'],
'category_id' => $data['category_id'],
'category_json' => $data['category_json'],
'label_id' => $data['label_id'],
'label_name' => $label_name,
'timer_on' => $data['timer_on'],
'timer_off' => $data['timer_off'],
'sale_show' => $data['sale_show'],
'stock_show' => $data['stock_show'],
'market_price_show' => $data['market_price_show'],
'barrage_show' => $data['barrage_show'],
'is_consume_discount' => $data['is_consume_discount'],
'period' => $data['common_num'],
);
$common_data = array(
'goods_name' => $data['goods_name'],
'goods_class' => $this->goods_class['id'],
'goods_class_name' => $this->goods_class['name'],
'goods_attr_class' => $data['goods_attr_class'],
'goods_attr_name' => $data['goods_attr_name'],
'is_limit' => isset($data['is_limit']) ? $data['is_limit'] : 0,
'limit_type' => isset($data['limit_type']) ? $data['limit_type'] : 1,
'site_id' => $data['site_id'],
'goods_content' => $data['goods_content'],
'goods_state' => $data['goods_state'],
'goods_stock_alarm' => $data['goods_stock_alarm'],
'is_virtual' => 1,
'virtual_indate' => 0,
'goods_attr_format' => $data['goods_attr_format'],
'introduction' => $data['introduction'],
'keywords' => $data['keywords'],
'unit' => $data['unit'],
'video_url' => $data['video_url'],
'sort' => $data['sort'],
'goods_service_ids' => $data['goods_service_ids'],
'brand_id' => $data['brand_id'],//品牌id
'brand_name' => $brand_name,//品牌名称
'modify_time' => time(),
'virtual_sale' => $data['virtual_sale'],
'max_buy' => $data['max_buy'],
'min_buy' => $data['min_buy'],
'recommend_way' => $data['recommend_way'],
'qr_id' => isset($data['qr_id']) ? $data['qr_id'] : 0,
'template_id' => isset($data['template_id']) ? $data['template_id'] : 0,
'form_id' => $data['form_id'] ?? 0,
'sale_channel' => $data['sale_channel'] ?? 'all',
'sale_store' => $data['sale_store'] ?? 'all',
'is_unify_pirce' => $data['is_unify_pirce'] ?? 1,
);
$sku_stock_list = [];
if (!empty($data['goods_sku_data'][0]['sku_id'])) {
if ($data['spec_type_status'] == 1) {
model('goods_sku')->delete([['goods_id', '=', $goods_id]]);
$sku_arr = array();
//添加sku商品
foreach ($data['goods_sku_data'] as $item) {
$sku_data = array(
'sku_name' => $data['goods_name'] . ' ' . $item['spec_name'],
'spec_name' => $item['spec_name'],
'sku_no' => $item['sku_no'],
'sku_spec_format' => !empty($item['sku_spec_format']) ? json_encode($item['sku_spec_format']) : "",
'price' => $item['price'],
'market_price' => $item['market_price'],
'cost_price' => $item['cost_price'],
'discount_price' => $item['price'],//sku折扣价默认等于单价
'stock' => $item['stock'],
'stock_alarm' => $item['stock_alarm'],
'sku_image' => !empty($item['sku_image']) ? $item['sku_image'] : $first_image,
'sku_images' => $item['sku_images'],
'goods_id' => $goods_id,
'is_default' => $item['is_default'] ?? 0,
'is_consume_discount' => $data['is_consume_discount'],
);
$sku_arr[] = array_merge($sku_data, $common_data);
$sku_stock_list[] = ['stock' => $item['stock'], 'site_id' => $data['site_id'], 'goods_class' => $common_data['goods_class']];
}
model('goods_sku')->addList($sku_arr);
$sku_list = model('goods_sku')->getList(['goods_id' => $goods_id], 'sku_id');
foreach ($sku_stock_list as $k => $v) {
$sku_stock_list[$k]['sku_id'] = $sku_list[$k]['sku_id'];
}
} else {
$discount_model = new Discount();
$sku_id_arr = [];
foreach ($data['goods_sku_data'] as $item) {
$discount_info = [];
if (!empty($item['sku_id'])) {
$discount_info_result = $discount_model->getDiscountGoodsInfo([['pdg.sku_id', '=', $item['sku_id']], ['pd.status', '=', 1]], 'id');
$discount_info = $discount_info_result['data'];
}
$sku_data = array(
'sku_name' => $data['goods_name'] . ' ' . $item['spec_name'],
'spec_name' => $item['spec_name'],
'sku_no' => $item['sku_no'],
'sku_spec_format' => !empty($item['sku_spec_format']) ? json_encode($item['sku_spec_format']) : "",
'price' => $item['price'],
'market_price' => $item['market_price'],
'cost_price' => $item['cost_price'],
'stock' => $item['stock'],
'stock_alarm' => $item['stock_alarm'],
'sku_image' => !empty($item['sku_image']) ? $item['sku_image'] : $first_image,
'sku_images' => $item['sku_images'],
'goods_id' => $goods_id,
'is_default' => $item['is_default'] ?? 0,
'is_consume_discount' => $data['is_consume_discount']
);
if (empty($discount_info)) {
$sku_data['discount_price'] = $item['price'];
}
if (!empty($item['sku_id'])) {
$sku_id_arr[] = $item['sku_id'];
model('goods_sku')->update(array_merge($sku_data, $common_data), [['sku_id', '=', $item['sku_id']], ['goods_class', '=', $this->goods_class['id']]]);
} else {
$sku_id = model('goods_sku')->add(array_merge($sku_data, $common_data));
$item['sku_id'] = $sku_id;
$sku_id_arr[] = $sku_id;
}
$sku_stock_list[] = ['stock' => $item['stock'], 'sku_id' => $item['sku_id'], 'site_id' => $data['site_id'], 'goods_class' => $common_data['goods_class']];
}
// 移除不存在的商品SKU
$sku_id_list = model('goods_sku')->getList([['goods_id', '=', $goods_id]], 'sku_id');
$sku_id_list = array_column($sku_id_list, 'sku_id');
foreach ($sku_id_list as $k => $v) {
foreach ($sku_id_arr as $ck => $cv) {
if ($v == $cv) {
unset($sku_id_list[$k]);
}
}
}
$sku_id_list = array_values($sku_id_list);
if (!empty($sku_id_list)) {
model('goods_sku')->delete([['sku_id', 'in', implode(",", $sku_id_list)]]);
}
}
} else {
model('goods_sku')->delete([['goods_id', '=', $goods_id]]);
$sku_arr = array();
//添加sku商品
foreach ($data['goods_sku_data'] as $item) {
$sku_data = array(
'sku_name' => $data['goods_name'] . ' ' . $item['spec_name'],
'spec_name' => $item['spec_name'],
'sku_no' => $item['sku_no'],
'sku_spec_format' => !empty($item['sku_spec_format']) ? json_encode($item['sku_spec_format']) : "",
'price' => $item['price'],
'market_price' => $item['market_price'],
'cost_price' => $item['cost_price'],
'discount_price' => $item['price'],//sku折扣价默认等于单价
'stock' => $item['stock'],
'stock_alarm' => $item['stock_alarm'],
'sku_image' => !empty($item['sku_image']) ? $item['sku_image'] : $first_image,
'sku_images' => $item['sku_images'],
'goods_id' => $goods_id,
'is_default' => $item['is_default'] ?? 0,
'is_consume_discount' => $data['is_consume_discount']
);
$sku_arr[] = array_merge($sku_data, $common_data);
$sku_stock_list[] = ['stock' => $item['stock'], 'site_id' => $data['site_id'], 'goods_class' => $common_data['goods_class']];
}
model('goods_sku')->addList($sku_arr);
$sku_list = model('goods_sku')->getList(['goods_id' => $goods_id], 'sku_id');
foreach ($sku_stock_list as $k => $v) {
$sku_stock_list[$k]['sku_id'] = $sku_list[$k]['sku_id'];
}
}
if ($data['is_alipay_public'] == 1) {
$template = new AliGoodsTemplate();
$card_template_id = model('goods_card')->getValue(['goods_id' => $goods_id, 'site_id' => $data['site_id']], 'card_template_id');
if ($card_template_id) {
$data['card_template_id'] = $card_template_id;
$card_template = $template->CreateAndModifyTemplate($data['site_id'], $goods_id, $data);
} else {
$card_template = $template->CreateAndModifyTemplate($data['site_id'], $goods_id, $data, 'create');
}
if ($card_template['code'] != 0) {
model('goods')->rollback();
return $card_template;
} else {
$card_template_id = $card_template['data']['template_id'];
}
}
// 赋值第一个商品sku_id
$first_info = model('goods_sku')->getFirstData(['goods_id' => $goods_id], 'sku_id', 'is_default desc,sku_id asc');
$goodsUpdata = array_merge($goods_data, $common_data, ['sku_id' => $first_info['sku_id'], 'goods_stock' => array_sum(array_column($sku_stock_list, 'stock'))]);
model('goods')->update($goodsUpdata, [['goods_id', '=', $goods_id]]);
if (!empty($data['goods_spec_format'])) {
// 刷新SKU商品规格项 / 规格值JSON字符串
$this->dealGoodsSkuSpecFormat($goods_id, $data['goods_spec_format']);
}
// 编辑商品卡项表
model('goods_card')->update([
'renew_price' => $data['renew_price'],
'recharge_money' => $data['recharge_money'] ?? 0,
'common_num' => $data['common_num'],
'periods' => $data['periods'],
'discount_goods_type' => $data['discount_goods_type'],
'discount' => $data['discount'],
'validity_type' => $data['validity_type'],
'validity_day' => $data['validity_day'] ?? 0,
'validity_time' => $data['validity_time'] ?? 0,
'discount_type' => $data['discount_type'],
'downPaymentPeriods' => $data['downPaymentPeriods'],
'downPayment' => $data['downPayment'],
'perPeriodPriceArray' => $data['perPeriodPriceArray'],
'use_rule' => $data['use_rule'],
'average_original_price' => $data['average_original_price'] ?? 0,
'average_discount_price' => $data['average_discount_price'] ?? 0,
'is_alipay_public' => $data['is_alipay_public'] ?? 0,
'alipay_cat_id' => $data['alipay_cat_id'] ?? 0,
'card_template_id' => $card_template_id ?? '',
'change_type' => $data['change_type'] ?? '',
'least_period' => $data['least_period'] ?? 0,
'downPaymentDate' => $data['downPaymentDate'] ?? 0,
], [['goods_id', '=', $goods_id]]);
// 添加商品卡项项目表
model('goods_card_item')->delete([['card_goods_id', '=', $goods_id]]);
$relation_goods = json_decode($data['relation_goods'], true);
if (!empty($relation_goods)) {
$goods_card_item = [];
foreach ($relation_goods as $item) {
array_push($goods_card_item, [
'site_id' => $data['site_id'],
'card_goods_id' => $goods_id,
'goods_id' => $item['goods_id'],
'sku_id' => $item['sku_id'],
'num' => $item['num'] ?? 0,
'discount' => $item['discount'] ?? 0,
]);
}
model('goods_card_item')->addList($goods_card_item);
}
$cron = new Cron();
$cron->deleteCron([['event', 'in', ['CronGoodsTimerOn', 'CronGoodsTimerOff']], ['relate_id', '=', $goods_id]]);
//定时上下架
if ($goods_data['timer_on'] > 0) {
$cron->addCron(1, 0, "商品定时上架", "CronGoodsTimerOn", $goods_data['timer_on'], $goods_id);
}
if ($goods_data['timer_off'] > 0) {
$cron->addCron(1, 0, "商品定时下架", "CronGoodsTimerOff", $goods_data['timer_off'], $goods_id);
}
event('GoodsEdit', [
'site_id' => $data['site_id'],
'goods_id' => $goods_id,
'goods_sku_list' => $sku_stock_list,
'goods_state' => $data['goods_state'],
'store_type' => $data['store_type'] ?? 'directsale',
'sale_store' => $data['sale_store'] ?? 'all',
'goods_name' => $data['goods_name'],
'alipay_cat_id' => $data['alipay_cat_id'] ?? '',
'goods_class' => $common_data['goods_class']
]);
model('goods')->commit();
return $this->success($goods_id);
} catch (\Exception $e) {
model('goods')->rollback();
return $this->error($e->getMessage() . $e->getFile() . $e->getLine());
}
}
/**
* 获取商品信息
* @param array $condition
* @param string $field
*/
public function getGoodsInfo($condition, $field = 'goods_id,goods_name,goods_class,goods_class_name,goods_attr_class,goods_attr_name,goods_image,goods_content,goods_state,price,market_price,cost_price,goods_stock,goods_stock_alarm,goods_spec_format,goods_attr_format,introduction,keywords,unit,sort,video_url,evaluate,virtual_indate')
{
$info = model('goods')->getInfo($condition, $field);
if (!empty($info)) {
if (isset($info['goods_stock'])) {
$info['goods_stock'] = numberFormat($info['goods_stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
}
return $this->success($info);
}
/**
* 获取商品信息
* @param array $condition
* @param string $field
*/
public function editGetGoodsInfo($data)
{
$condition = [
['g.goods_id', '=', $data['goods_id']],
['g.site_id', '=', $data['site_id']]
];
$join = [
['goods_card gc', 'g.goods_id = gc.goods_id', 'inner']
];
$field = 'g.*,gc.card_type,gc.renew_price,gc.recharge_money,gc.common_num,gc.discount_goods_type,gc.discount,gc.validity_type,gc.validity_day,gc.validity_time,gc.is_cloud_zmxx,gc.discount_type,gc.downPaymentPeriods,gc.downPayment,gc.perPeriodPriceArray,gc.use_rule,gc.cloud_card_type,gc.card_template_id,gc.periods,gc.least_period,gc.alipay_cat_id,gc.downPaymentDate';
$info = model('goods')->getInfo($condition, $field, 'g', $join);
if (!empty($info)) {
if (isset($info['goods_stock'])) {
$info['goods_stock'] = numberFormat($info['goods_stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
$info['relation_goods'] = model('goods_card_item')->getList([
['gci.card_goods_id', '=', $data['goods_id']]
], 'gci.goods_id,gci.sku_id,gci.num,gci.discount,gs.sku_name,gs.price,gs.sku_image,gs.goods_class_name', 'id asc', 'gci', [
['goods_sku gs', 'gs.sku_id = gci.sku_id', 'inner']
]);
return $this->success($info);
}
return $this->error();
}
/**
* 获取商品详情
* @param $goods_id
* @return array
*/
public function getGoodsDetail($goods_id, $site_id)
{
$info = model('goods')->getInfo([['is_delete', '=', 0], ['goods_id', '=', $goods_id], ['site_id', '=', $site_id], ['goods_class', '=', 3]], "*");
$field = 'sku_id, sku_name,spec_name, sku_no, sku_spec_format, price, market_price, cost_price, discount_price, stock,
weight, volume, sku_image, sku_images, sort,member_price,fenxiao_price';
$sku_data = model('goods_sku')->getList([['goods_id', '=', $goods_id]], $field);
if (!empty($sku_data)) {
foreach ($sku_data as $k => $v) {
$sku_data[$k]['member_price'] = $v['member_price'] == '' ? '' : json_decode($v['member_price'], true);
if (isset($v['stock'])) {
$sku_data[$k]['stock'] = numberFormat($sku_data[$k]['stock']);
}
}
}
if (!empty($info)) {
if (isset($info['goods_stock'])) {
$info['goods_stock'] = numberFormat($info['goods_stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
$info['sku_data'] = $sku_data;
}
return $this->success($info);
}
public function cashierCalculate($data = [])
{
$where = [
['site_id', '=', $data['site_id']],
['period_type', '<>', $data['pay_type']],
['discount_method', '=', 'cashier']
];
$goods_id = model('goods')->getValue($where, 'goods_id');
if (empty($goods_id)) {
$goods_data['goods_name'] = '扫码签约先享后付';
$goods_data['goods_code'] = date('YmdHis');
$goods_data['introduction'] = '先享后付优惠买单越用越优惠';
$goods_data['keywords'] = '先享后付';
$goods_data['discount_type'] = $data['pay_type'];
$goods_data['card_type'] = 'commoncard';
$goods_data['unit'] = '';
$goods_data['is_zmxx'] = 1;
$goods_data['is_cloud_zmxx'] = 1;
$goods_data['discount_method'] = 'cashier';
$goods_data['cloud_card_type'] = $data['pay_type'];
$goods_data['use_rule'] = '优惠次卡:在指定的时间内您每次到店出示核销码核销后扣款
优惠周卡:在您签约日起次周系统自动扣款
优惠月卡:在您签约日起次月系统自动扣款
如果您在使用服务期间内取消服务,系统将扣回使用次数所优惠的价
在您签约后未使用您可以无责任取消';
$goods_data['discount_type'] = 1;
$goods_data['is_consume_discount'] = 0;
$goods_data['goods_image'] = 'public/resource/cardservice/card_service.png';
$goods_id = $this->importGoods($goods_data, $data['site_id'])['data'];
}
$store_id = $data['store_id'];
$price = $data['sku_array'][0]['money'];
$site_id = $data['site_id'];
$field = 'gs.site_id,gs.goods_id,gs.sku_id,gs.goods_name,gs.sku_name,gs.spec_name,gs.sku_image,g.goods_image,sgs.price,gs.price as sku_price,gs.sku_no,g.is_virtual,g.unit,sgs.stock,g.min_buy,g.max_buy,g.goods_class,g.goods_class_name,(sgs.sale_num + g.virtual_sale) as sale_num,g.is_unify_pirce';
$alias = 'gs';
$join = [
['goods g', 'g.goods_id = gs.goods_id', 'inner'],
[
'store_goods_sku sgs',
'sgs.sku_id = gs.sku_id and sgs.store_id = ' . $store_id,
'left'
]
];
$goods_condition = [
['gs.goods_id', '=', $goods_id],
['gs.site_id', '=', $site_id],
];
$goods_list = model('goods_sku')->getList($goods_condition, $field, '', $alias, $join);
$order_name = '';
$goods_num = 0;
foreach ($goods_list as $k => $v) {
$order_name = string_split($order_name, ",", $v['goods_name']);
$goods_num += 1;
$goods_info = $v;
$is_virtual = $is_virtual ?? $v['is_virtual'];
$goods_info['num'] = 1;
$goods_info['sale_num'] = numberFormat($goods_info['sale_num']);
$goods_info['stock'] = numberFormat($goods_info['stock']);
$goods_list[$k] = $goods_info;
}
$data['goods_list'] = $goods_list;
$data['order_name'] = $order_name;
$data['goods_num'] = $goods_num;
$goods_list = $data['goods_list'];
//具备某个参数(控制是否是单品活动)
//计算订单总额 ,订单总优惠 ,
$goods_money = 0;
$real_goods_money = 0;
foreach ($goods_list as $k => $v) {
// 计算单价 可能情况 (折扣价 会员价)
$goods_item = $v;
$v['price'] = $price;
$goods_item['price'] = $price;
$num = $goods_item['num'];//购买数量
$item_goods_money = moneyFormat($price * $num);//商品总额()
$goods_money += $item_goods_money;
$item_real_goods_money = $item_goods_money;
$real_goods_money += $item_real_goods_money;
$goods_item['goods_money'] = $item_goods_money;
$goods_item['real_goods_money'] = $item_real_goods_money;
$goods_item['sku_image'] = explode(',', $goods_item['sku_image'])[0] ?? '';
$goods_item['goods_image'] = explode(',', $goods_item['goods_image'])[0] ?? '';
$goods_list[$k] = $goods_item;
}
$data['goods_list'] = $goods_list;
$data['goods_money'] = moneyFormat($goods_money);
$data['real_goods_money'] = moneyFormat($real_goods_money);
$delivery_money = $data['delivery_money'] ?? 0;
$order_money = moneyFormat($real_goods_money + $delivery_money);
$pay_money = $order_money;
//总结计算
$data['order_money'] = $order_money;
$data['pay_money'] = $pay_money;
$data['cashier_order_type'] = 'card';
return $this->success($data);
}
/**
* 获取商品列表
* @param array $condition
* @param string $field
* @param string $order
* @param string $limit
*/
public function getGoodsList($condition = [], $field = 'goods_id,goods_class,goods_class_name,goods_attr_name,goods_name,site_id,,sort,goods_image,goods_content,goods_state,price,market_price,cost_price,goods_stock,goods_stock_alarm,is_virtual,goods_spec_format,goods_attr_format,create_time', $order = 'create_time desc', $alias = '', $join = [], $limit = null)
{
$list = model('goods')->getList($condition, $field, $order, $alias, $join, '', $limit);
if (!empty($list)) {
foreach ($list as $k => $v) {
if (isset($v['goods_stock'])) {
$list[$k]['goods_stock'] = numberFormat($list[$k]['goods_stock']);
}
if (isset($v['sale_num'])) {
$list[$k]['sale_num'] = numberFormat($list[$k]['sale_num']);
}
if (isset($v['virtual_sale'])) {
$list[$k]['virtual_sale'] = numberFormat($list[$k]['virtual_sale']);
}
if (isset($v['real_stock'])) {
$list[$k]['real_stock'] = numberFormat($list[$k]['real_stock']);
}
}
}
return $this->success($list);
}
/**
* 刷新SKU商品规格项/规格值JSON字符串
* @param int $goods_id 商品id
* @param string $goods_spec_format 商品完整规格项/规格值json
*/
private function dealGoodsSkuSpecFormat($goods_id, $goods_spec_format)
{
if (empty($goods_spec_format)) return;
$goods_spec_format = json_decode($goods_spec_format, true);
//根据goods_id查询sku商品列表查询sku_id、sku_spec_format 列
$sku_list = model('goods_sku')->getList([['goods_id', '=', $goods_id], ['sku_spec_format', '<>', '']], 'sku_id,sku_spec_format', 'sku_id asc');
if (!empty($sku_list)) {
// $temp = 0;//测试性能,勿删
//循环SKU商品列表
foreach ($sku_list as $k => $v) {
// $temp++;
$sku_format = $goods_spec_format;//最终要存储的值
$current_format = json_decode($v['sku_spec_format'], true);//当前SKU商品规格值json
$selected_data = [];//已选规格/规格值json
//1、找出已选规格/规格值json
//循环完整商品规格json
foreach ($sku_format as $sku_k => $sku_v) {
// $temp++;
//循环当前SKU商品规格json
foreach ($current_format as $current_k => $current_v) {
// $temp++;
//匹配规格项
if ($current_v['spec_id'] == $sku_v['spec_id']) {
//循环规格值
foreach ($sku_v['value'] as $sku_value_k => $sku_value_v) {
// $temp++;
//匹配规格值id
if ($current_v['spec_value_id'] == $sku_value_v['spec_value_id']) {
$sku_format[$sku_k]['value'][$sku_value_k]['selected'] = true;
$sku_format[$sku_k]['value'][$sku_value_k]['sku_id'] = $v['sku_id'];
$selected_data[] = $sku_format[$sku_k]['value'][$sku_value_k];
break;
}
}
}
}
}
//2、找出未选中的规格/规格值json
foreach ($sku_format as $sku_k => $sku_v) {
// $temp++;
foreach ($sku_v['value'] as $sku_value_k => $sku_value_v) {
// $temp++;
if (!isset($sku_value_v['selected'])) {
$refer_data = [];//参考已选中的规格/规格值json
$refer_data[] = $sku_value_v;
// 根据已选中的规格值进行参考
foreach ($selected_data as $selected_k => $selected_v) {
// $temp++;
// 排除自身,然后进行参考
if ($selected_v['spec_id'] != $sku_value_v['spec_id']) {
$refer_data[] = $selected_v;
}
}
foreach ($sku_list as $again_k => $again_v) {
// $temp++;
//排除当前SKU商品
if ($again_v['sku_id'] != $v['sku_id']) {
$current_format_again = json_decode($again_v['sku_spec_format'], true);
$count = count($current_format_again);//规格总数量
$curr_count = 0;//当前匹配规格数量
//循环当前SKU商品规格json
foreach ($current_format_again as $current_again_k => $current_again_v) {
// $temp++;
foreach ($refer_data as $fan_k => $fan_v) {
// $temp++;
if ($current_again_v['spec_value_id'] == $fan_v['spec_value_id']) {
$curr_count++;
}
}
}
// 匹配数量跟规格总数一致表示匹配成功
if ($curr_count == $count) {
$sku_format[$sku_k]['value'][$sku_value_k]['selected'] = false;
$sku_format[$sku_k]['value'][$sku_value_k]['sku_id'] = $again_v['sku_id'];
break;
}
}
}
//没有匹配到规格值,则禁用
if (!isset($sku_format[$sku_k]['value'][$sku_value_k]['selected'])) {
$sku_format[$sku_k]['value'][$sku_value_k]['disabled'] = false;
}
}
}
}
//修改ns_goods_sku表表中的goods_spec_format字段将$sku_format值传入
model('goods_sku')->update(['goods_spec_format' => json_encode($sku_format)], [['sku_id', '=', $v['sku_id']]]);
}
}
}
/************************************************************************* 购买的虚拟产品 start *******************************************************************/
/**
* 生成购买的虚拟产品
* @param $site_id
* @param $order_id
* @param $order_no
* @param $sku_id
* @param $sku_name
* @param $code
* @param $member_id
* @param $sku_image
*/
public function addGoodsVirtual($site_id, $goods_id, $sku_id, $data)
{
if (is_array($data) && count($data)) {
$virtual_goods = [];
foreach ($data as $carmichael_item) {
$carmichael_item = htmlspecialchars(addslashes($carmichael_item));
$card = explode(' ', $carmichael_item);
$card_arr = [
'cardno' => $card[0] ?? '',
'password' => $card[1] ?? ''
];
array_push($virtual_goods, [
'site_id' => $site_id,
'sku_id' => $sku_id,
'card_info' => json_encode($card_arr),
'goods_id' => $goods_id
]);
}
model("goods_virtual")->startTrans();
try {
$res = model("goods_virtual")->addList($virtual_goods);
model('goods')->setInc([['goods_id', '=', $goods_id], ['site_id', '=', $site_id]], 'goods_stock', count($virtual_goods)); // 增加商品总库存
model('goods_sku')->setInc([['sku_id', '=', $sku_id], ['site_id', '=', $site_id]], 'stock', count($virtual_goods)); // 增加sku库存
model("goods_virtual")->commit();
return $this->success($res);
} catch (\Exception $e) {
model("goods_virtual")->rollback();
return $this->error('', $e->getMessage());
}
} else {
return $this->error('', '请输入要添加的卡密数据');
}
}
/************************************************************************* 购买的虚拟产品 end *******************************************************************/
/**
* 从excel中读取卡密数据
* @param $path
*/
public function importData($path)
{
$PHPReader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader('Xlsx');
//载入文件
$PHPExcel = $PHPReader->load($path);
//获取表中的第一个工作表如果要获取第二个把0改为1依次类推
$currentSheet = $PHPExcel->getSheet(0);
//获取总行数
$allRow = $currentSheet->getHighestRow();
if ($allRow < 2) {
return $this->error('', '导入了一个空文件');
}
$data = [];
for ($i = 2; $i <= $allRow; $i++) {
//卡号
$cardno = $PHPExcel->getActiveSheet()->getCell('A' . $i)->getValue();
//卡号
$password = $PHPExcel->getActiveSheet()->getCell('B' . $i)->getValue();
array_push($data, $cardno . ' ' . $password);
}
return $this->success(implode("\n", $data));
}
/**
* 商品导入
* @param $goods_data
* @param $site_id
* @return array
*/
public function importGoods($goods_data, $site_id)
{
try {
if (empty($goods_data['goods_name'])) return $this->error('', '商品名称不能为空');
if (empty($goods_data['goods_image'])) return $this->error('', '商品主图不能为空');
// if (empty($goods_data['category_1']) && empty($goods_data['category_2']) && empty($goods_data['category_3'])) return $this->error('', '商品分类不能为空');
// 处理商品分类
$category_id = '';
$category_json = [];
if (!empty($goods_data['category_3'])) {
$category_info = model('goods_category')->getInfo([['level', '=', 3], ['site_id', '=', $site_id], ['category_full_name', '=', "{$goods_data['category_1']}/{$goods_data['category_2']}/{$goods_data['category_3']}"]], 'category_id_1,category_id_2,category_id_3');
if (!empty($category_info)) {
$category_id = "{$category_info['category_id_1']},{$category_info['category_id_2']},{$category_info['category_id_3']}";
}
}
if (!empty($goods_data['category_2']) && empty($category_id)) {
$category_info = model('goods_category')->getInfo([['level', '=', 2], ['site_id', '=', $site_id], ['category_full_name', '=', "{$goods_data['category_1']}/{$goods_data['category_2']}"]], 'category_id_1,category_id_2');
if (!empty($category_info)) {
$category_id = "{$category_info['category_id_1']},{$category_info['category_id_2']}";
}
}
if (!empty($goods_data['category_1']) && empty($category_id)) {
$category_info = model('goods_category')->getInfo([['level', '=', 1], ['site_id', '=', $site_id], ['category_name', '=', "{$goods_data['category_1']}"]], 'category_id_1');
if (!empty($category_info)) {
$category_id = "{$category_info['category_id_1']}";
}
}
$category_json = [];
if (!empty($category_id)) {
$category_json = [$category_id];
}
$sku_data = [];
$goods_spec_format = [];
$tag = 0;
// 处理sku数据
if (isset($goods_data['sku'])) {
foreach ($goods_data['sku'] as $sku_item) {
if (empty($sku_item['sku_data'])) return $this->error('', '规格数据不能为空');
$spec_name = '';
$spec_data = explode(';', $sku_item['sku_data']);
$sku_spec_format = [];
foreach ($spec_data as $item) {
$spec_item = explode(':', $item);
$spec_name .= ' ' . $spec_item[1];
// 规格项
$spec_index = array_search($spec_item[0], array_column($goods_spec_format, 'spec_name'));
if (empty($goods_spec_format) || $spec_index === false) {
$spec = [
'spec_id' => -($tag + getMillisecond()),
'spec_name' => $spec_item[0],
'value' => []
];
array_push($goods_spec_format, $spec);
$tag++;
} else {
$spec = $goods_spec_format[$spec_index];
}
// 规格值
$spec_index = array_search($spec_item[0], array_column($goods_spec_format, 'spec_name'));
$spec_value_index = array_search($spec_item[1], array_column($spec['value'], 'spec_value_name'));
if (empty($spec['value']) || $spec_value_index === false) {
$spec_value = [
'spec_id' => $spec['spec_id'],
'spec_name' => $spec['spec_name'],
'spec_value_id' => -($tag + getMillisecond()),
'spec_value_name' => $spec_item[1],
'image' => '',
];
array_push($goods_spec_format[$spec_index]['value'], $spec_value);
$tag++;
} else {
$spec_value = $spec['value'][$spec_value_index];
}
array_push($sku_spec_format, [
'spec_id' => $spec['spec_id'],
'spec_name' => $spec['spec_name'],
'spec_value_id' => $spec_value['spec_value_id'],
'spec_value_name' => $spec_value['spec_value_name'],
'image' => '',
]);
}
$sku_images_arr = explode(',', $sku_item['sku_image']);
$sku_temp = [
'spec_name' => trim($spec_name),
'sku_no' => $sku_item['sku_code'],
'sku_spec_format' => $sku_spec_format,
'price' => $sku_item['price'],
'market_price' => $sku_item['market_price'],
'cost_price' => $sku_item['cost_price'],
'stock_alarm' => $sku_item['stock_alarm'],
'sku_image' => empty($sku_item['sku_image']) ? '' : $sku_images_arr[0],
'sku_images' => empty($sku_item['sku_image']) ? '' : $sku_item['sku_image'],
'sku_images_arr' => empty($sku_item['sku_image']) ? [] : $sku_images_arr,
'is_default' => 0,
'carmichael' => empty($sku_item['carmichael']) ? [] : explode("\n", $sku_item['carmichael'])
];
array_push($sku_data, $sku_temp);
}
} else {
$goods_img = explode(',', $goods_data['goods_image']);
$sku_data = [
[
'sku_id' => 0,
'sku_name' => $goods_data['goods_name'],
'spec_name' => '',
'sku_spec_format' => '',
'price' => empty($goods_data['price']) ? 0 : $goods_data['price'],
'market_price' => empty($goods_data['market_price']) ? 0 : $goods_data['market_price'],
'cost_price' => empty($goods_data['cost_price']) ? 0 : $goods_data['cost_price'],
'sku_no' => $goods_data['goods_code'],
'stock_alarm' => empty($goods_data['stock_alarm']) ? 0 : $goods_data['stock_alarm'],
'sku_image' => $goods_img[0],
'sku_images' => $goods_data['goods_image'],
'stock' => 99999,
'stock_alarm' => 0,
'carmichael' => empty($goods_data['carmichael']) ? [] : explode("\n", $goods_data['carmichael'])
]
];
}
if (count($goods_spec_format) > 4) return $this->error('', '最多支持四种规格项');
if ($category_id != '') {
$category_id = ',' . $category_id . ',';
}
$data = [
'goods_name' => $goods_data['goods_name'],// 商品名称,
'goods_attr_class' => '',// 商品类型id,
'goods_attr_name' => '',// 商品类型名称,
'site_id' => $site_id,
'category_id' => $category_id,
'category_json' => json_encode($category_json),
'goods_image' => $goods_data['goods_image'],// 商品主图路径
'goods_content' => '',// 商品详情
'goods_state' => 0, //$goods_data['goods_state'] == 1 || $goods_data['goods_state'] == '是' ? 1 : 0,// 商品状态1.正常0下架
'price' => empty($goods_data['price']) ? 0 : $goods_data['price'],// 商品价格取第一个sku
'market_price' => empty($goods_data['market_price']) ? 0 : $goods_data['market_price'],// 市场价格取第一个sku
'cost_price' => empty($goods_data['cost_price']) ? 0 : $goods_data['cost_price'],// 成本价取第一个sku
'sku_no' => $goods_data['goods_code'],// 商品sku编码
'goods_stock_alarm' => empty($goods_data['goods_stock_alarm']) ? 0 : $goods_data['goods_stock_alarm'],// 库存预警
'goods_spec_format' => empty($goods_spec_format) ? '' : json_encode($goods_spec_format, JSON_UNESCAPED_UNICODE),// 商品规格格式
'goods_attr_format' => '',// 商品参数格式
'introduction' => $goods_data['introduction'],// 促销语
'keywords' => $goods_data['keywords'],// 关键词
'unit' => $goods_data['unit'],// 单位
'sort' => '',// 排序,
'qr_id' => empty($goods_data['qr_id']) ? 0 : $goods_data['qr_id'],// 社群二维码id
'template_id' => empty($goods_data['template_id']) ? 0 : $goods_data['template_id'],// 海报id
'is_limit' => empty($goods_data['is_limit']) ? 0 : $goods_data['is_limit'],// 是否限购
'limit_type' => empty($goods_data['limit_type']) ? 0 : $goods_data['limit_type'],// 限购类型
'video_url' => '',// 视频
'goods_sku_data' => json_encode($sku_data, JSON_UNESCAPED_UNICODE),// SKU商品数据
'goods_service_ids' => '',// 商品服务id集合
'label_id' => '',// 商品分组id
'virtual_sale' => 0,// 虚拟销量
'max_buy' => 0,// 限购
'min_buy' => 0,// 起售
'recommend_way' => 0, // 推荐方式1新品2精品3推荐
'timer_on' => 0,//定时上架
'timer_off' => 0,//定时下架
'brand_id' => 0,
'is_consume_discount' => $goods_data['is_consume_discount'] == 1 || $goods_data['is_consume_discount'] == '是' ? 1 : 0, //是否参与会员折扣
'common_num' => $goods_data['common_num'] ?? 1,// 商品类型
'periods' => $goods_data['periods'] ?? 1,// 商品类型
'is_zmxx' => $goods_data['is_zmxx'] ?? 0,// 商品类型
'cloud_card_type' => $goods_data['cloud_card_type'] ?? '',
'discount_type' => $goods_data['discount_type'] ?? '',
'card_type' => $goods_data['card_type'] ?? '',
'use_rule' => $goods_data['use_rule'] ?? '',
'is_cloud_zmxx' => $goods_data['is_cloud_zmxx'] ?? 0,
'discount_method' => $goods_data['discount_method'] ?? '',
'is_alipay_public' => 0,
'downPaymentPeriods' => '',
'downPayment' => 0,
'renew_price' => 0,
'perPeriodPriceArray' => '',
'discount_goods_type' => 'all',
'discount' => 0,
'validity_type' => 0,
'validity_day' => 0,
'relation_goods' => '[]',
'alipay_cat_id' => '',
];
$res = $this->addGoods($data);
return $res;
} catch (\Exception $e) {
return $this->error('', $e->getMessage());
}
}
/**
* 卡 详情
* @param $sku_id
* @param $site_id
* @param string $field
* @return array
*/
public function getGoodsSkuDetail($sku_id, $site_id, $field = '')
{
$condition = [['gs.sku_id', '=', $sku_id], ['gs.site_id', '=', $site_id], ['gs.is_delete', '=', 0], ['g.goods_class', '=', $this->getGoodsClass()['id']]];
if (empty($field)) {
$field = 'gs.goods_id,gs.sku_id,gs.qr_id,gs.goods_name,gs.sku_name,gs.sku_spec_format,gs.price,gs.market_price,gs.discount_price,gs.promotion_type,gs.start_time
,gs.end_time,gs.stock,gs.click_num,(g.sale_num + g.virtual_sale) as sale_num,gs.collect_num,gs.sku_image,gs.sku_images
,gc.card_type,gc.card_type_name,gc.renew_price,gc.recharge_money,gc.common_num,gc.discount_goods_type,gc.discount,gc.validity_type,gc.validity_day,gc.validity_time
,gs.goods_content,gs.goods_state,gs.is_free_shipping,gs.goods_spec_format,gs.goods_attr_format,gs.introduction,gs.unit,gs.video_url
,gs.is_virtual,gs.goods_service_ids,gs.max_buy,gs.min_buy,gs.is_limit,gs.limit_type,gs.support_trade_type,g.goods_image,g.keywords,g.stock_show,g.sale_show,g.market_price_show,g.barrage_show,g.evaluate';
}
$join = [
['goods g', 'g.goods_id = gs.goods_id', 'inner'],
['goods_card gc', 'gc.goods_id=gs.goods_id', 'left'],
];
$info = model('goods_sku')->getInfo($condition, $field, 'gs', $join);
if (!empty($info)) {
if (isset($info['stock'])) {
$info['stock'] = numberFormat($info['stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
$info['relation_goods'] = model('goods_card_item')->getList([
['gci.card_goods_id', '=', $info['goods_id']]
], 'gci.goods_id,gci.sku_id,gci.num,gci.discount,gs.sku_name,gs.price,gs.sku_image,gs.goods_class_name', 'id asc', 'gci', [
['goods_sku gs', 'gs.sku_id = gci.sku_id', 'inner']
]);
}
return $this->success($info);
}
/**
* 查询规格信息
* @param $condition
* @param string $field
* @param string $alias
* @param array $join
* @return array
*/
public function getGoodsSkuInfo($condition, $field = '*', $alias = 'a', $join = [])
{
$info = model('goods_sku')->getInfo($condition, $field, $alias, $join);
if (!empty($info)) {
if (isset($info['stock'])) {
$info['stock'] = numberFormat($info['stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
$info['relation_goods'] = model('goods_card_item')->getList([
['gci.card_goods_id', '=', $info['goods_id']]
], 'gci.goods_id,gci.sku_id,gci.num,gci.discount,gs.sku_name,gs.price,gs.sku_image,gs.goods_class_name', 'id asc', 'gci', [
['goods_sku gs', 'gs.sku_id = gci.sku_id', 'inner']
]);
return $this->success($info);
}
return $this->error();
}
/**
* 获取商品信息
* @param array $condition
* @param string $field
*/
public function getGoodsCardDetail($goods_id, $site_id, $store_data = [])
{
$condition = [
['g.goods_id', '=', $goods_id],
['g.site_id', '=', $site_id]
];
$join = [
['goods_card gc', 'g.goods_id = gc.goods_id', 'inner']
];
$field = 'g.*,gc.*';
$info = model('goods')->getInfo($condition, $field, 'g', $join);
if (!empty($info)) {
$card_service_info = $info;
if (isset($info['goods_stock'])) {
$info['goods_stock'] = numberFormat($info['goods_stock']);
}
if (isset($info['sale_num'])) {
$info['sale_num'] = numberFormat($info['sale_num']);
}
if (isset($info['virtual_sale'])) {
$info['virtual_sale'] = numberFormat($info['virtual_sale']);
}
if (isset($info['real_stock'])) {
$info['real_stock'] = numberFormat($info['real_stock']);
}
$sku_condition = [
['gci.card_goods_id', '=', $goods_id],
];
$sku_field = 'gci.goods_id,gci.sku_id,gci.num,gci.discount,gs.sku_name,gs.price,gs.sku_image,gs.goods_class_name';
$sku_join = [['goods_sku gs', 'gs.sku_id = gci.sku_id', 'inner']];
if (!empty($store_data) && $store_data['config']['store_business'] == 'store') {
$sku_join[] = ['store_goods_sku sgs', 'gs.sku_id = sgs.sku_id and sgs.store_id=' . $store_data['store_info']['store_id'], 'left'];
$sku_field = str_replace('gs.price', 'IFNULL(IF(gs.is_unify_pirce = 1,gs.price,sgs.price), gs.price) as price', $sku_field);
}
$info['relation_goods'] = model('goods_card_item')->getList($sku_condition, $sku_field, 'gci.id asc', 'gci', $sku_join);
$service_info = [
'cloud_card_type' => $card_service_info['cloud_card_type'],
'use_rule' => "<p>" . str_replace("\n", "</p><p>", $card_service_info['use_rule']) . "</p>",
'validity_day' => $card_service_info['validity_day'],
'card_type' => $card_service_info['card_type'],
'validity_type' => $card_service_info['validity_type'],
'downPaymentPeriods' => $card_service_info['downPaymentPeriods'],
'is_cloud_zmxx' => $card_service_info['is_cloud_zmxx'],
'downPayment' => $card_service_info['downPayment'],
'card_name' => $this->card_name[$card_service_info['cloud_card_type']],
'discount_type_name' => '',
'original_price' => '',
'card_desc' => [],
'expire_time' => '',
];
if ($card_service_info['validity_type'] == 1) {
$service_info['expire_time'] = date('Y-m-d', Time::nextday($card_service_info['validity_day']));
} else if ($card_service_info['validity_type'] == 2) {
$service_info['expire_time'] = date('Y-m-d', $card_service_info['validity_time']);
}
switch ($card_service_info['cloud_card_type']) {
case 'number':
case 'discount_num':
case 'year':
break;
case 'month':
case 'discount_month':
$service_info['expire_time'] = date('Y-m-d', Time::nextMonth($card_service_info['common_num']));
break;
case 'week':
case 'discount_week':
$service_info['expire_time'] = date('Y-m-d', Time::nextWeek($card_service_info['common_num']));
break;
}
$common_num = $card_service_info['periods'] ?: $card_service_info['common_num']?:1;
$downPaymentPeriods = $card_service_info['downPaymentPeriods'];//优惠次数
$downPaymentMoney = round($card_service_info['price'] / $common_num, 2);//计算平均价格
$originalMoney = round($card_service_info['market_price'] / $common_num, 2);//计算原始平均价格
$type_name = $this->card_name[$card_service_info['cloud_card_type']];
if ($card_service_info['discount_type'] == 1) {
$service_info['discount_type_name'] = '签约';
$title = $downPaymentPeriods == 1 ? '首' : '前1-' . $downPaymentPeriods;
if ($downPaymentPeriods > 1) {
$card_desc[] = [
'title' => $title . $type_name,
'desc' => $card_service_info['downPayment'] . '/' . $type_name,
'discount_money' => $card_service_info['downPayment'],
'original_price' => $originalMoney . '/' . $type_name,
];
$title = ($downPaymentPeriods + 1);
$card_desc[] = [
'title' => '第' . $title . '-' . $common_num . $type_name,
'desc' => $downPaymentMoney . '/' . $type_name,
'discount_money' => $downPaymentMoney,
'original_price' => $originalMoney . '/' . $type_name,
];
} else {
$title = '首' . $type_name;
$card_desc[] = [
'title' => $title,
'desc' => $service_info['downPayment'] . '/' . $type_name,
'discount_money' => $service_info['downPayment'],
'original_price' => $originalMoney . '/' . $type_name,
];
$next = $common_num - $downPaymentPeriods;
if ($next > 0) {
$card_desc[] = [
'title' => '第' . ($downPaymentPeriods + 1) . '/' . $common_num . $type_name,
'desc' => $downPaymentMoney . '/' . $type_name,
'discount_money' => $downPaymentMoney,
'original_price' => $originalMoney . '/' . $type_name,
];
}
}
} else if ($card_service_info['discount_type'] == 2) {
$service_info['discount_type_name'] = '越用越优惠';
if ($common_num > 1) {
$perPeriodPriceArray = explode(',', $card_service_info['perPeriodPriceArray']);
$remain = ($common_num - count($perPeriodPriceArray));
$card_desc[] = [
'title' => '第1-' . $remain . $type_name,
'desc' => $downPaymentMoney . '/' . $type_name,
'discount_money' => $downPaymentMoney,
'original_price' => $originalMoney . '/' . $type_name,
];
if ($remain) {
$title = ($remain + 1);
foreach ($perPeriodPriceArray as $item) {
$card_desc[] = [
'title' => '第' . $title . $type_name,
'desc' => $item . '/' . $type_name,
'discount_money' => $item,
'original_price' => $originalMoney . '/' . $type_name,
];
$title++;
}
}
} else {
$card_desc[] = [
'title' => $type_name,
'desc' => $downPaymentMoney . '/' . $type_name,
'discount_money' => $downPaymentMoney,
'original_price' => $originalMoney . '/' . $type_name,
];
}
}
$service_info['original_price'] = $originalMoney . '/' . $type_name;
$service_info['card_desc'] = $card_desc;
$info['card_service_info'] = $service_info;
return $this->success($info);
}
return $this->error();
}
}