<?php
namespace app\api\controller\user;
use app\admin\model\store\ProductCode;
use app\admin\model\store\StoreProduct as ProductModel;
use app\admin\model\store\StoreProductAttr;
use app\admin\model\store\StoreProductCate;
use app\admin\model\ump\WriteOff;
use app\http\validates\user\AddressValidate;
use app\models\store\StoreCoupon;
use app\models\store\StoreProduct;
use app\models\system\SystemCity;
use app\models\system\SystemStoreStaff;
use app\models\user\UserVisit;
use crmeb\services\JsonService as Json;
use think\db\exception\DataNotFoundException;
use think\db\exception\DbException;
use think\db\exception\ModelNotFoundException;
use think\exception\ValidateException;
use app\Request;
use app\models\user\UserLevel;
use app\models\user\UserSign;
use app\models\store\StoreBargain;
use app\models\store\StoreCombination;
use app\models\store\StoreCouponUser;
use app\models\store\StoreOrder;
use app\models\store\StoreProductRelation;
use app\models\store\StoreSeckill;
use app\models\user\User;
use app\models\user\UserAddress;
use app\models\user\UserBill;
use app\models\user\UserExtract;
use app\models\user\UserNotice;
use crmeb\services\GroupDataService;
use crmeb\services\UtilService;
use think\facade\Db;
use think\facade\Validate;
/**
* 用户类
* Class UserController
* @package app\api\controller\store
*/
class UserController
{
/**
* 获取用户信息
* @param Request $request
* @return mixed
*/
public function userInfo(Request $request)
{
$info = $request->user()->toArray();
StoreCouponUser::checkInvalidCoupon();
$broken_time = intval(sys_config('extract_time'));
$search_time = time() - 86400 * $broken_time;
//返佣 +
$brokerage_commission = UserBill::where(['uid' => $info['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
->where('add_time', '>', $search_time)
->where('pm', 1)
->sum('number');
//退款退的佣金 -
$refund_commission = UserBill::where(['uid' => $info['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
->where('add_time', '>', $search_time)
->where('pm', 0)
->sum('number');
$info['broken_commission'] = bcsub($brokerage_commission, $refund_commission, 2);
if ($info['broken_commission'] < 0)
$info['broken_commission'] = 0;
$info['commissionCount'] = bcsub($info['brokerage_price'], $info['broken_commission'], 2);
if ($info['commissionCount'] < 0)
$info['commissionCount'] = 0;
if ($info['level'] == 1){
$info['level_name'] = '会员';
}elseif ($info['level'] == 2){
$info['level_name'] = '创业合伙人';
}else{
$info['level_name'] = '普通用户';
}
$info['spread_nickname'] = User::where('uid', $info['spread_uid'])->value('nickname')?? '';
$info['clerk_type'] = 0;
if (SystemStoreStaff::where('uid', $info['uid'])->find()) $info['clerk_type'] = 1;
return app('json')->success($info);
}
/**
* 用户资金统计
* @param Request $request
* @return mixed
* @throws \think\Exception
* @throws DataNotFoundException
* @throws ModelNotFoundException
* @throws \think\exception\DbException
*/
public function balance(Request $request)
{
$uid = $request->uid();
$user['now_money'] = User::getUserInfo($uid, 'now_money')['now_money'];//当前总资金
$user['recharge'] = UserBill::getRecharge($uid);//累计充值
$user['orderStatusSum'] = StoreOrder::getOrderStatusSum($uid);//累计消费
return app('json')->successful($user);
}
/**
* 个人中心
* @param Request $request
* @return mixed
*/
public function user(Request $request)
{
$user = $request->user();
$user = $user->toArray();
$user['couponCount'] = StoreCouponUser::getUserValidCouponCount($user['uid']);
$user['like'] = StoreProductRelation::getUserIdCollect($user['uid']);
$user['orderStatusNum'] = StoreOrder::getOrderData($user['uid']);
$user['notice'] = UserNotice::getNotice($user['uid']);
// $user['brokerage'] = UserBill::getBrokerage($user['uid']);//获取总佣金
$user['recharge'] = UserBill::getRecharge($user['uid']);//累计充值
$user['orderStatusSum'] = StoreOrder::getOrderStatusSum($user['uid']);//累计消费
$user['extractTotalPrice'] = UserExtract::userExtractTotalPrice($user['uid']);//累计提现
$user['extractPrice'] = $user['brokerage_price'];//可提现
$user['statu'] = (int)sys_config('store_brokerage_statu');
$broken_time = intval(sys_config('extract_time'));
$search_time = time() - 86400 * $broken_time;
if (!$user['is_promoter'] && $user['statu'] == 2) {
$price = StoreOrder::where(['paid' => 1, 'refund_status' => 0, 'uid' => $user['uid']])->sum('pay_price');
$status = is_brokerage_statu($price);
if ($status) {
User::where('uid', $user['uid'])->update(['is_promoter' => 1]);
$user['is_promoter'] = 1;
} else {
$storeBrokeragePrice = sys_config('store_brokerage_price', 0);
$user['promoter_price'] = bcsub($storeBrokeragePrice, $price, 2);
}
}
//可提现佣金
//返佣 +
$brokerage_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
->where('add_time', '>', $search_time)
->where('pm', 1)
->sum('number');
//退款退的佣金 -
$refund_commission = UserBill::where(['uid' => $user['uid'], 'category' => 'now_money', 'type' => 'brokerage'])
->where('add_time', '>', $search_time)
->where('pm', 0)
->sum('number');
$user['broken_commission'] = bcsub($brokerage_commission, $refund_commission, 2);
if ($user['broken_commission'] < 0)
$user['broken_commission'] = 0;
$user['commissionCount'] = bcsub($user['brokerage_price'], $user['broken_commission'], 2);
if ($user['commissionCount'] < 0)
$user['commissionCount'] = 0;
if (!sys_config('vip_open'))
$user['vip'] = false;
else {
$vipId = UserLevel::getUserLevel($user['uid']);
$user['vip'] = $vipId !== false ? true : false;
if ($user['vip']) {
$user['vip_id'] = $vipId;
$user['vip_icon'] = UserLevel::getUserLevelInfo($vipId, 'icon');
$user['vip_name'] = UserLevel::getUserLevelInfo($vipId, 'name');
}
}
$user['yesterDay'] = UserBill::yesterdayCommissionSum($user['uid']);
$user['recharge_switch'] = (int)sys_config('recharge_switch');//充值开关
$user['adminid'] = (boolean)\app\models\store\StoreService::orderServiceStatus($user['uid']);
if ($user['phone'] && $user['user_type'] != 'h5') {
$user['switchUserInfo'][] = $request->user();
if ($h5UserInfo = User::where('account', $user['phone'])->where('user_type', 'h5')->find()) {
$user['switchUserInfo'][] = $h5UserInfo;
}
} else if ($user['phone'] && $user['user_type'] == 'h5') {
if ($wechatUserInfo = User::where('phone', $user['phone'])->where('user_type', '<>', 'h5')->find()) {
$user['switchUserInfo'][] = $wechatUserInfo;
}
$user['switchUserInfo'][] = $request->user();
} else if (!$user['phone']) {
$user['switchUserInfo'][] = $request->user();
}
return app('json')->successful($user);
}
/**
* 地址 获取单个
* @param Request $request
* @param $id
* @return mixed
* @throws DataNotFoundException
* @throws ModelNotFoundException
* @throws \think\exception\DbException
*/
public function address(Request $request, $id)
{
$addressInfo = [];
if ($id && is_numeric($id) && UserAddress::be(['is_del' => 0, 'id' => $id, 'uid' => $request->uid()])) {
$addressInfo = UserAddress::find($id)->toArray();
}
return app('json')->successful($addressInfo);
}
/**
* 地址列表
* @param Request $request
* @param $page
* @param $limit
* @return mixed
*/
public function address_list(Request $request)
{
list($page, $limit) = UtilService::getMore([['page', 0], ['limit', 20]], $request, true);
$list = UserAddress::getUserValidAddressList($request->uid(), $page, $limit, 'id,real_name,phone,province,city,district,detail,is_default');
return app('json')->successful($list);
}
/**
* 设置默认地址
*
* @param Request $request
* @return mixed
*/
public function address_default_set(Request $request)
{
list($id) = UtilService::getMore([['id', 0]], $request, true);
if (!$id || !is_numeric($id)) return app('json')->fail('参数错误!');
if (!UserAddress::be(['is_del' => 0, 'id' => $id, 'uid' => $request->uid()]))
return app('json')->fail('地址不存在!');
$res = UserAddress::setDefaultAddress($id, $request->uid());
if (!$res)
return app('json')->fail('地址不存在!');
else
return app('json')->successful();
}
/**
* 获取默认地址
* @param Request $request
* @return mixed
*/
public function address_default(Request $request)
{
$defaultAddress = UserAddress::getUserDefaultAddress($request->uid(), 'id,real_name,phone,province,city,district,detail,is_default');
if ($defaultAddress) {
$defaultAddress = $defaultAddress->toArray();
return app('json')->successful('ok', $defaultAddress);
}
return app('json')->successful('empty', []);
}
/**
* 修改 添加地址
* @param Request $request
* @return mixed
*/
public function address_edit(Request $request)
{
$addressInfo = UtilService::postMore([
['address', []],
['is_default', false],
['real_name', ''],
['post_code', ''],
['phone', ''],
['detail', ''],
['id', 0],
['type', 0]
], $request);
if (!isset($addressInfo['address']['province'])) return app('json')->fail('收货地址格式错误!');
if (!isset($addressInfo['address']['city'])) return app('json')->fail('收货地址格式错误!');
if (!isset($addressInfo['address']['district'])) return app('json')->fail('收货地址格式错误!');
if (!isset($addressInfo['address']['city_id']) && $addressInfo['type'] == 0) {
return app('json')->fail('收货地址格式错误!请重新选择!');
} else if ($addressInfo['type'] == 1) {
$city = $addressInfo['address']['city'];
$cityId = SystemCity::where('name', $city)->where('parent_id', '<>', 0)->value('city_id');
if ($cityId) {
$addressInfo['address']['city_id'] = $cityId;
} else {
if (!($cityId = SystemCity::where('parent_id', '<>', 0)->where('name', 'like', "%$city%")->value('city_id'))) {
return app('json')->fail('收货地址格式错误!修改后请重新导入!');
}
$addressInfo['address']['city_id'] = $cityId;
}
}
$addressInfo['province'] = $addressInfo['address']['province'];
$addressInfo['city'] = $addressInfo['address']['city'];
$addressInfo['city_id'] = $addressInfo['address']['city_id'] ?? 0;
$addressInfo['district'] = $addressInfo['address']['district'];
$addressInfo['is_default'] = (int)$addressInfo['is_default'] == true ? 1 : 0;
$addressInfo['uid'] = $request->uid();
unset($addressInfo['address'], $addressInfo['type']);
try {
validate(AddressValidate::class)->check($addressInfo);
} catch (ValidateException $e) {
return app('json')->fail($e->getError());
}
if ($addressInfo['id'] && UserAddress::be(['id' => $addressInfo['id'], 'uid' => $request->uid(), 'is_del' => 0])) {
$id = $addressInfo['id'];
unset($addressInfo['id']);
if (UserAddress::edit($addressInfo, $id, 'id')) {
if ($addressInfo['is_default'])
UserAddress::setDefaultAddress($id, $request->uid());
return app('json')->successful();
} else
return app('json')->fail('编辑收货地址失败!');
} else {
$addressInfo['add_time'] = time();
if ($address = UserAddress::create($addressInfo)) {
if ($addressInfo['is_default']) {
UserAddress::setDefaultAddress($address->id, $request->uid());
}
return app('json')->successful(['id' => $address->id]);
} else {
return app('json')->fail('添加收货地址失败!');
}
}
}
/**
* 删除地址
*
* @param Request $request
* @return mixed
*/
public function address_del(Request $request)
{
list($id) = UtilService::postMore([['id', 0]], $request, true);
if (!$id || !is_numeric($id)) return app('json')->fail('参数错误!');
if (!UserAddress::be(['is_del' => 0, 'id' => $id, 'uid' => $request->uid()]))
return app('json')->fail('地址不存在!');
if (UserAddress::edit(['is_del' => '1'], $id, 'id'))
return app('json')->successful();
else
return app('json')->fail('删除地址失败!');
}
/**
* 获取收藏产品
*
* @param Request $request
* @return mixed
*/
public function collect_user(Request $request)
{
list($page, $limit) = UtilService::getMore([
['page', 0],
['limit', 0]
], $request, true);
if (!(int)$limit) return app('json')->successful([]);
$productRelationList = StoreProductRelation::getUserCollectProduct($request->uid(), (int)$page, (int)$limit);
return app('json')->successful($productRelationList);
}
/**
* 添加收藏
* @param Request $request
* @param $id
* @param $category
* @return mixed
*/
public function collect_add(Request $request)
{
list($id, $category) = UtilService::postMore([['id', 0], ['category', 'product']], $request, true);
if (!$id || !is_numeric($id)) return app('json')->fail('参数错误');
$res = StoreProductRelation::productRelation($id, $request->uid(), 'collect', $category);
if (!$res) return app('json')->fail(StoreProductRelation::getErrorInfo());
else return app('json')->successful();
}
/**
* 取消收藏
*
* @param Request $request
* @return mixed
*/
public function collect_del(Request $request)
{
list($id, $category) = UtilService::postMore([['id', 0], ['category', 'product']], $request, true);
if (!$id || !is_numeric($id)) return app('json')->fail('参数错误');
$res = StoreProductRelation::unProductRelation($id, $request->uid(), 'collect', $category);
if (!$res) return app('json')->fail(StoreProductRelation::getErrorInfo());
else return app('json')->successful();
}
/**
* 批量收藏
* @param Request $request
* @return mixed
*/
public function collect_all(Request $request)
{
$collectInfo = UtilService::postMore([
['id', []],
['category', 'product'],
], $request);
if (!count($collectInfo['id'])) return app('json')->fail('参数错误');
$productIdS = $collectInfo['id'];
$res = StoreProductRelation::productRelationAll($productIdS, $request->uid(), 'collect', $collectInfo['category']);
if (!$res) return app('json')->fail(StoreProductRelation::getErrorInfo());
else return app('json')->successful('收藏成功');
}
/**
* 添加点赞
*
* @param Request $request
* @return mixed
*/
// public function like_add(Request $request)
// {
// list($id, $category) = UtilService::postMore([['id',0], ['category','product']], $request, true);
// if(!$id || !is_numeric($id)) return app('json')->fail('参数错误');
// $res = StoreProductRelation::productRelation($id,$request->uid(),'like',$category);
// if(!$res) return app('json')->fail(StoreProductRelation::getErrorInfo());
// else return app('json')->successful();
// }
/**
* 取消点赞
*
* @param Request $request
* @return mixed
*/
// public function like_del(Request $request)
// {
// list($id, $category) = UtilService::postMore([['id',0], ['category','product']], $request, true);
// if(!$id || !is_numeric($id)) return app('json')->fail('参数错误');
// $res = StoreProductRelation::unProductRelation($id, $request->uid(),'like',$category);
// if(!$res) return app('json')->fail(StoreProductRelation::getErrorInfo());
// else return app('json')->successful();
// }
/**
* 签到 配置
* @return mixed
* @throws DataNotFoundException
* @throws ModelNotFoundException
* @throws \think\exception\DbException
*/
public function sign_config()
{
$signConfig = sys_data('sign_day_num') ?? [];
return app('json')->successful($signConfig);
}
/**
* 签到 列表
* @param Request $request
* @param $page
* @param $limit
* @return mixed
*/
public function sign_list(Request $request)
{
list($page, $limit) = UtilService::getMore([
['page', 0],
['limit', 0]
], $request, true);
if (!$limit) return app('json')->successful([]);
$signList = UserSign::getSignList($request->uid(), (int)$page, (int)$limit);
if ($signList) $signList = $signList->toArray();
return app('json')->successful($signList);
}
/**
* 签到
* @param Request $request
* @return mixed
*/
public function sign_integral(Request $request)
{
$signed = UserSign::getIsSign($request->uid());
if ($signed) return app('json')->fail('已签到');
if (false !== ($integral = UserSign::sign($request->uid())))
return app('json')->successful('签到获得' . floatval($integral) . '积分', ['integral' => $integral]);
return app('json')->fail(UserSign::getErrorInfo('签到失败'));
}
/**
* 签到用户信息
* @param Request $request
* @return mixed
*/
public function sign_user(Request $request)
{
list($sign, $integral, $all) = UtilService::postMore([
['sign', 0],
['integral', 0],
['all', 0],
], $request, true);
$user = $request->user();
//是否统计签到
if ($sign || $all) {
$user['sum_sgin_day'] = UserSign::getSignSumDay($user['uid']);
$user['is_day_sgin'] = UserSign::getIsSign($user['uid']);
$user['is_YesterDay_sgin'] = UserSign::getIsSign($user['uid'], 'yesterday');
if (!$user['is_day_sgin'] && !$user['is_YesterDay_sgin']) {
$user['sign_num'] = 0;
}
}
//是否统计积分使用情况
if ($integral || $all) {
$user['sum_integral'] = (int)UserBill::getRecordCount($user['uid'], 'integral', 'sign,system_add,gain');
$user['deduction_integral'] = (int)UserBill::getRecordCount($user['uid'], 'integral', 'deduction', '', true) ?? 0;
$user['today_integral'] = (int)UserBill::getRecordCount($user['uid'], 'integral', 'sign,system_add,gain', 'today');
}
unset($user['pwd']);
if (!$user['is_promoter']) {
$user['is_promoter'] = (int)sys_config('store_brokerage_statu') == 2 ? true : false;
}
return app('json')->successful($user->hidden(['account', 'real_name', 'birthday', 'card_id', 'mark', 'partner_id', 'group_id', 'add_time', 'add_ip', 'phone', 'last_time', 'last_ip', 'spread_uid', 'spread_time', 'user_type', 'status', 'level', 'clean_time', 'addres'])->toArray());
}
/**
* 签到列表（年月）
*
* @param Request $request
* @return mixed
*/
public function sign_month(Request $request)
{
list($page, $limit) = UtilService::getMore([
['page', 0],
['limit', 0]
], $request, true);
if (!$limit) return app('json')->successful([]);
$userSignList = UserSign::getSignMonthList($request->uid(), (int)$page, (int)$limit);
return app('json')->successful($userSignList);
}
/**
* 获取活动状态
* @return mixed
*/
public function activity()
{
$data['is_bargin'] = StoreBargain::validBargain() ? true : false;
$data['is_pink'] = StoreCombination::getPinkIsOpen() ? true : false;
$data['is_seckill'] = StoreSeckill::getSeckillCount() ? true : false;
return app('json')->successful($data);
}
/**
* 用户修改信息
* @param Request $request
* @return mixed
*/
public function edit(Request $request)
{
list($avatar, $nickname) = UtilService::postMore([
['avatar', ''],
['nickname', ''],
], $request, true);
if (User::editUser($avatar, $nickname, $request->uid())) return app('json')->successful('修改成功');
return app('json')->fail('修改失败');
}
/**
* 推广人排行
* @param Request $request
* @return mixed
* @throws DataNotFoundException
* @throws ModelNotFoundException
* @throws \think\exception\DbException
*/
public function rank(Request $request)
{
$data = UtilService::getMore([
['page', ''],
['limit', ''],
['type', '']
], $request);
$users = User::getRankList($data);
return app('json')->success($users);
}
/**
* 佣金排行
* @param Request $request
* @return mixed
*/
public function brokerage_rank(Request $request)
{
$data = UtilService::getMore([
['page', ''],
['limit'],
['type']
], $request);
return app('json')->success([
'rank' => User::brokerageRank($data),
'position' => User::currentUserRank($data['type'], $request->user()['brokerage_price'])
]);
}
/**
* 添加访问记录
* @param Request $request
* @return mixed
*/
public function set_visit(Request $request)
{
$data = UtilService::postMore([
['url', ''],
['stay_time', 0]
], $request);
if ($data['url'] == '') return app('json')->fail('未获取页面路径');
$data['uid'] = $request->uid();
$data['ip'] = $request->ip();
$data['add_time'] = time();
$res = UserVisit::insert($data);
if ($res) {
return app('json')->success('添加访问记录成功');
} else {
return app('json')->fail('添加访问记录失败');
}
}
/**
* 静默绑定推广人
* @param Request $request
* @return mixed
* @throws DataNotFoundException
* @throws DbException
* @throws ModelNotFoundException
*/
public function spread(Request $request)
{
$puid = $request->post('puid/d', 0);
return app('json')->success(User::setSpread($puid, $request->uid()));
}
/**
* 核销记录
* @param Request $request
* @return mixed
*/
public function write_off(Request $request)
{
$data = UtilService::postMore([
['page', 1],
['limit', 10]
], $request);
$model = new WriteOff();
$list = $model->alias('a')
->field('a.*,us.nickname,c.coupon_title,c.coupon_price,d.name as d_name')
->leftJoin('user b', 'b.uid = a.uid')
->leftJoin('store_coupon_user c', 'c.id = a.coupon_id')
->leftJoin('user us', 'us.uid = c.uid')
->leftJoin('system_store d', 'd.id = c.store_id')
->where('a.uid', $request->uid())
->page($data['page'], $data['limit'])
->select();
if ($list){
$list = $list->toArray();
foreach ($list as &$v){
$v['add_time'] = $v['add_time'] > 0 ? date('Y-m-d H:i:s', $v['add_time']) : 0;
}
}
return app('json')->success($list);
}
/**
* 用户优惠券
* @param Request $request
* @return mixed
* @throws DataNotFoundException
* @throws DbException
* @throws ModelNotFoundException
*/
public function coupon_user(Request $request)
{
$data = UtilService::postMore([
['status', 0],
['page', 1],
['limit', 10]
], $request);
$coupon = StoreCouponUser::alias('a')
->field('a.*,c.id as c_id,c.name,c.image,c.latitude,c.longitude,c.detailed_address')
->order('a.id DESC')
->leftJoin('store_coupon b', 'a.cid = b.id')
->leftJoin('system_store c', 'b.store_id = c.id')
->where('a.uid', $request->uid())
->where('a.status', $data['status'])
->select();
$coupon = count($coupon) > 0?$coupon->toArray() : [];
return app('json')->success($coupon);
}
/**
* 分享领取优惠券
* @param Request $request
* @return mixed
* @throws DataNotFoundException
* @throws DbException
* @throws ModelNotFoundException
*/
public function share(Request $request)
{
$data = UtilService::postMore([
['code', ''],
], $request);
if (!$data['code']) return app('json')->fail('优惠券不存在');
$coupon = StoreCouponUser::where('code', $data['code'])->find();
if ($coupon['status'] == 1) return app('json')->fail('优惠券已使用');
if ($coupon['status'] == 2) return app('json')->fail('优惠券已过期');
if ($coupon['uid'] == $request->uid()) return app('json')->fail('自己不能领取自己的优惠券');
if ($coupon['share_status'] == 1) return app('json')->fail('优惠券已分享');
$coupon['uid'] = $request->uid();
$coupon['share_status'] = 1;
$order = StoreOrder::where('order_id', $coupon['order_id'])->find();
if ($order['use'] < 1){
$order_coupon = StoreCouponUser::where('order_id', $coupon['order_id'])->where('uid', $order['uid'])->where('code', '<>', $data['code'])->where('status', '<', 1)->count();
// 如果购买用户本人优惠券分享出去后没有可用的优惠券订单变为已完成
if ($order_coupon == 0) StoreOrder::where('order_id', $coupon['order_id'])->update(['status' => 3, 'use' => 1]);
}
$res = $coupon->save();
if ($res) return app('json')->success('领取成功');
return app('json')->fail('领取失败');
}
public function coupon_datalis(Request $request)
{
$data = UtilService::postMore([
['code', ''],
], $request);
$coupon = StoreCouponUser::where('code', $data['code'])->find();
if (!$coupon) return app('json')->fail('优惠券不存在');
return app('json')->success($coupon->toArray());
}
/**
* 兑换码兑换
* @param Request $request
* @return mixed
* @throws DataNotFoundException
* @throws DbException
* @throws ModelNotFoundException
*/
public function exchange(Request $request)
{
$data = UtilService::postMore([
['code'],
], $request);
if (!$data['code']) return app('json')->fail('请输入兑换码');
$product_code = ProductCode::where('code', $data['code'])->find();
if (!$product_code) return app('json')->fail('兑换码不存在');
if ($product_code['status'] == 1) return app('json')->fail('兑换码已使用');
$product = StoreProduct::where('id', $product_code['product_id'])->find();
$coupon = StoreCoupon::where('id', 'in', $product['coupon'])->select();
if ($coupon) {
foreach ($coupon as $value) {
$save[] = [
'cid' => $value['id'],
'uid' => $request->uid(),
'order_id' => '',
'coupon_title' => $value['title'],
'coupon_price' => $value['coupon_price'],
'use_min_price' => $value['use_min_price'],
'add_time' => $value['start_time'] == 0 ? 0 : $value['start_time'],
'end_time' => $value['end_time'] == 0 ? 0 : $value['end_time'],
'code' => generate_promotion_code(1),
'store_id' => $value['store_id'],
];
}
}
$model = new StoreCouponUser();
try {
Db::startTrans();
$product_code['status'] = 1;
$product_code['end_time'] = time();
$product_code->save();
$model->saveAll($save);
Db::commit();
return app('json')->success('兑换成功');
} catch (\Exception $e) {
Db::rollback();
return app('json')->fail('兑换失败');
}
}
/**
* 添加优惠券
* @param Request $request
* @return void
* @throws DataNotFoundException
* @throws DbException
* @throws ModelNotFoundException
*/
public function store_coupon(Request $request)
{
$user = SystemStoreStaff::where('uid', $request->uid())->find();
if (!$user) return app('json')->fail('不是店员不能添加优惠券');
if ($user['coupon_status'] == 0) return app('json')->fail('未开启添加优惠券功能');
$data = UtilService::postMore([
['title', ''],
['price', 0],
['ot_price', 0],
['coupon_price', ''],
['start_time', ''],
['end_time', ''],
['store_info', ''],
['stock', 0]
]);
$validate = Validate::rule(['title' => 'require', 'price' => 'require', 'ot_price' => 'require', 'coupon_price' => 'require', 'start_time' => 'require', 'end_time' => 'require', 'store_info' => 'require', 'stock' => 'require',]);
$validate->message([
'title.require' => '请填写优惠券名称',
'price.require' => '请填写价格',
'ot_price.require' => '请填写原价',
'coupon_price.require' => '请填写优惠券面值',
'start_time.require' => '请填写开始时间',
'end_time.require' => '请填写结束时间',
'store_info.require' => '请填写优惠券介绍',
'stock.require' => '请填写数量',
]);
if (!$validate->check($data)) return app('json')->fail($validate->getError());
ProductModel::beginTrans();
$coupon = StoreCoupon::create([
'title' => $data['title'],
'coupon_price' => $data['coupon_price'],
'start_time' => strtotime($data['start_time']),
'end_time' => strtotime($data['end_time']),
'store_id' => $user['store_id'],
'status' => 1
]);
$product = StoreProduct::create([
'image' => 'https://xxl.liuniu946.com/uploads/attach/2022/05/20220530/945747d7123723eb38e584a41050d452.png',
'slider_image' => json_encode([]),
'store_name' => $data['title'],
'store_info' => $data['store_info'],
'cate_id' => 4,
'price' => $data['price'],
'ot_price' => $data['ot_price'],
'activity' => '1,2,3',
'store_type' => 1,
'coupon' => $coupon['id'],
'stock' => $data['stock'],
'ficti' => 0
]);
$cateData[] = ['product_id' => $product['id'], 'cate_id' => 4, 'add_time' => time()];
StoreProductCate::insertAll($cateData);
$attr = [
[
'value' => '规格',
'detailValue' => '',
'attrHidden' => '',
'detail' => ['默认']
]
];
$detail[] = [
'pic' => 'https://xxl.liuniu946.com/uploads/attach/2022/05/20220530/945747d7123723eb38e584a41050d452.png',
'price' => $data['price'],
'integral' => 0,
'cost' => 0,
'ot_price' => $data['ot_price'],
'stock' => $data['stock'],
'bar_code' => '',
'volume' => 0,
'weight' => 0,
'brokerage' => 0,
'brokerage_two' => 0,
'value1' => '规格',
'detail' => [
'规格' => '默认'
]
];
$attr_res = StoreProductAttr::createProductAttr($attr, $detail, $product['id']);
if ($attr_res) {
ProductModel::commitTrans();
return Json::success('添加产品成功!');
} else {
ProductModel::rollbackTrans();
return Json::fail(StoreProductAttr::getErrorInfo());
}
}
}