package com.panzhihua.service_community.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.panzhihua.common.constants.PayCpmstant;
import com.panzhihua.common.model.vos.common.ComBatteryCommodityOrderCollageTeamPeopleVo;
import com.panzhihua.common.model.vos.common.ComBatteryCommodityOrderCollageTeamVo;
import com.panzhihua.common.utlis.Snowflake;
import com.panzhihua.common.utlis.WxPayUtils;
import com.panzhihua.service_community.dao.*;
import com.panzhihua.service_community.entity.*;
import com.panzhihua.service_community.service.ComBatteryCommodityOrderCollageTeamService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.service_community.service.ComBatteryTradeOrderService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import com.panzhihua.common.model.dtos.common.*;
import com.panzhihua.common.model.vos.R;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import javax.annotation.Resource;
import java.math.BigDecimal;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* title: 电动车商城-拼团订单团队表表服务实现类
*
* projectName 成都呐喊信息技术有限公司-智慧社区项目
*
* description: 电动车商城-拼团订单团队表表服务实现类
*
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Slf4j
@Service("comBatteryCommodityOrderCollageTeamService")
public class ComBatteryCommodityOrderCollageTeamServiceImpl extends ServiceImpl implements ComBatteryCommodityOrderCollageTeamService {
@Resource
private ComBatteryCommodityActivityMapper commodityActivityMapper;
@Resource
private ComBatteryCommodityOrderCollageTeamMapper orderCollageTeamMapper;
@Resource
private ComBatteryCommodityOrderCollageTeamPeopleMapper orderCollageTeamPeopleMapper;
@Resource
private ComBatteryUserAddressMapper userAddressMapper;
@Resource
private SysUserMapper userMapper;
@Resource
private ComBatteryTradeOrderService tradeOrderService;
@Value("${min.app.isTest}")
private Boolean isTest;
@Value("${min.app.appid}")
private String appid;
@Value("${min.app.payKey}")
private String payKey;
@Value("${min.app.mchId}")
private String mchId;
// @Value("${min.app.currencyNotifyUrl}")
// private String currencyNotifyUrl;
@Resource
private ComBatteryCommodityMapper commodityMapper;
@Resource
private ComBatteryCommoditySpecsMapper commoditySpecsMapper;
@Resource
private ComBatteryCommodityOrderMapper commodityOrderMapper;
/**
* description queryByPage 分页查询
*
* @param comBatteryCommodityOrderCollageTeam 请求参数
* @return 分页查询列表数据
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R queryByPage(PageComBatteryCommodityOrderCollageTeamDto comBatteryCommodityOrderCollageTeam) {
IPage orderCollageTeamVoIPage = this.baseMapper.queryAllByLimit(comBatteryCommodityOrderCollageTeam
, new Page(comBatteryCommodityOrderCollageTeam.getPageNum(), comBatteryCommodityOrderCollageTeam.getPageSize()));
//判断该用户是否参与了以下拼团
if(comBatteryCommodityOrderCollageTeam.getUserId() != null && comBatteryCommodityOrderCollageTeam.getUserId() != 0L){
Long userId = comBatteryCommodityOrderCollageTeam.getUserId();
orderCollageTeamVoIPage.getRecords().forEach(orderCollageTeam -> {
Map resultMap = this.baseMapper.getUserCollageDetail(orderCollageTeam.getId(),userId);
if(resultMap != null){
if(Integer.parseInt(resultMap.get("ktCount").toString()) > 0){
orderCollageTeam.setIsPartake(2);
}
if(Integer.parseInt(resultMap.get("ptCount").toString()) > 0){
orderCollageTeam.setIsPartake(2);
}
}
});
}
return R.ok(orderCollageTeamVoIPage);
}
/**
* description insert 新增数据
*
* @param comBatteryCommodityOrderCollageTeam 请求参数
* @return 新增结果
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R insert(AddComBatteryCommodityOrderCollageTeamDto comBatteryCommodityOrderCollageTeam) {
ComBatteryCommodityOrderCollageTeam entity = new ComBatteryCommodityOrderCollageTeam();
BeanUtils.copyProperties(comBatteryCommodityOrderCollageTeam, entity);
if (this.baseMapper.insert(entity) > 0) {
return R.ok();
}
return R.fail("添加失败");
}
/**
* description update 修改数据
*
* @param editDto 请求参数
* @return 修改结果
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R update(EditComBatteryCommodityOrderCollageTeamDto editDto) {
ComBatteryCommodityOrderCollageTeam entity = this.baseMapper.selectById(editDto.getId());
if (entity == null) {
return R.fail("未查询到该记录");
}
BeanUtils.copyProperties(editDto, entity);
if (this.baseMapper.updateById(entity) > 0) {
return R.ok();
}
return R.fail("修改失败");
}
/**
* description deleteById 通过主键删除数据
*
* @param id 主键id
* @return 删除结果
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R deleteById(Long id) {
if (this.baseMapper.deleteById(id) > 0) {
return R.ok();
}
return R.fail("删除失败");
}
/**
* description detailById 查询详情
*
* @param id 主键id
* @return 详情数据
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R detailById(Long id,Long userId) {
ComBatteryCommodityOrderCollageTeamVo orderCollageTeamVo = this.baseMapper.queryById(id);
if(orderCollageTeamVo != null){
List collageTeamPeopleList = orderCollageTeamPeopleMapper.queryAllByTeamId(id);
orderCollageTeamVo.setOrderCollageTeamPeopleList(collageTeamPeopleList);
//判断该用户是否参与了以下拼团
if(userId != null && userId != 0L){
Map resultMap = this.baseMapper.getUserCollageDetail(orderCollageTeamVo.getId(),userId);
if(resultMap != null){
if(Integer.parseInt(resultMap.get("ktCount").toString()) > 0){
orderCollageTeamVo.setIsPartake(2);
}
if(Integer.parseInt(resultMap.get("ptCount").toString()) > 0){
orderCollageTeamVo.setIsPartake(2);
}
}
}
}
return R.ok(orderCollageTeamVo);
}
/**
* description queryByPage 查询列表
*
* @param comBatteryCommodityOrderCollageTeam 请求参数
* @return 列表数据
* @author lyq
* @date 2022-03-29 16:06:58
*/
@Override
public R queryByList(PageComBatteryCommodityOrderCollageTeamDto comBatteryCommodityOrderCollageTeam) {
return R.ok(this.baseMapper.queryAllByList(comBatteryCommodityOrderCollageTeam));
}
/**
* 创建拼团订单
* @param orderDto 请求参数
* @return 创建订单结果
*/
@Override
public synchronized R startFight(StartFightOrderDto orderDto) {
//查询拼团活动
ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(orderDto.getActivityId());
if(commodityActivity == null){
return R.fail("未查询到拼团活动");
}
if(commodityActivity.getStatus().equals(ComBatteryCommodityActivity.Status.YXJ)){
return R.fail("该活动已下架");
}
if(commodityActivity.getEndTime().getTime() - System.currentTimeMillis() <= 0
|| commodityActivity.getStatus().equals(ComBatteryCommodityActivity.Status.YJS)){
return R.fail("该活动已结束");
}
if(orderDto.getType().equals(StartFightOrderDto.Type.PT)){
//判断该团队人数是否已满
Integer count = orderCollageTeamPeopleMapper.selectCount(new QueryWrapper().lambda()
.eq(ComBatteryCommodityOrderCollageTeamPeople::getTeamId,orderDto.getTeamId()));
if(count >= commodityActivity.getCollagePeopleNum()){
return R.fail("拼团人数已满");
}
//判断该团是否已参与
Integer userCount = orderCollageTeamPeopleMapper.selectCount(new QueryWrapper().lambda()
.eq(ComBatteryCommodityOrderCollageTeamPeople::getTeamId,orderDto.getTeamId())
.eq(ComBatteryCommodityOrderCollageTeamPeople::getUserId,orderDto.getUserId()));
if(userCount >= commodityActivity.getCollagePeopleNum()){
return R.fail("您已参与该拼团,不可重复参与");
}
//查询拼团团队
ComBatteryCommodityOrderCollageTeam orderCollageTeam = orderCollageTeamMapper.selectById(orderDto.getTeamId());
if(orderCollageTeam == null){
return R.fail("该拼团不存在");
}
if(orderDto.getUserId().equals(orderCollageTeam.getUserId())){
return R.fail("您不可拼自己的团");
}
if(!orderCollageTeam.getStatus().equals(ComBatteryCommodityOrderCollageTeam.Status.DDPT)){
return R.fail("该拼团已成功");
}
}else{
Integer count = orderCollageTeamMapper.selectCount(new QueryWrapper().lambda()
.eq(ComBatteryCommodityOrderCollageTeam::getActivityId,orderDto.getActivityId())
.eq(ComBatteryCommodityOrderCollageTeam::getStatus,ComBatteryCommodityOrderCollageTeam.Status.DDPT)
.eq(ComBatteryCommodityOrderCollageTeam::getUserId,orderDto.getUserId()));
if(count > 0){
return R.fail("当前活动商品您正在拼团中,不可重复开团");
}
Integer maxCount = orderCollageTeamMapper.selectCount(new QueryWrapper().lambda()
.eq(ComBatteryCommodityOrderCollageTeam::getActivityId,orderDto.getActivityId())
.eq(ComBatteryCommodityOrderCollageTeam::getStatus,ComBatteryCommodityOrderCollageTeam.Status.DDPT));
if(maxCount >= commodityActivity.getCollageNum()){
return R.fail("当前正在拼团的数量已达到最大值,不可在开团");
}
}
//查询商品
ComBatteryCommodity commodity = commodityMapper.selectById(orderDto.getCommodityId());
if(commodity == null){
return R.fail("未查询到商品信息");
}
//查询用户信息
SysUser user = userMapper.selectOne(new QueryWrapper().lambda().eq(SysUser::getUserId,orderDto.getUserId()));
if(user == null){
return R.fail("未查询到用户信息");
}
//查询商品规格信息
ComBatteryCommoditySpecs commoditySpecs = commoditySpecsMapper.selectById(commodityActivity.getSpecsId());
if(commoditySpecs == null){
return R.fail("未查询到商品规格信息");
}
if(commoditySpecs.getStock() < orderDto.getCount()){
return R.fail("该商品库存不足,无法下单");
}
//查询用户收货地址
ComBatteryUserAddress userAddress = userAddressMapper.selectById(orderDto.getAddressId());
if(userAddress == null){
return R.fail("未查询到用户收货地址");
}
Date nowDate = new Date();
//初始化订单数据
ComBatteryCommodityOrder commodityOrder = getCreateOrder(commodity,userAddress,user,commoditySpecs,orderDto,nowDate,commodityActivity);
Map resultMap = new HashMap<>(2);
if(commodityOrderMapper.insert(commodityOrder) > 0){
//更新商品库存
commoditySpecs.setStock(commoditySpecs.getStock() - orderDto.getCount());
commoditySpecsMapper.updateById(commoditySpecs);
//微信支付需要调取小程序微信支付
String result = getWxPayResult(commodityOrder.getFinalAmount(),commodityOrder.getOpenId()
,commodityOrder.getOrderNo(),"购买商品",orderDto.getType().toString());
resultMap.put("payResult",result);
resultMap.put("orderId",commodityOrder.getId());
// 添加微信支付交易流水
String wxTradeOrderNo = "wx" + Snowflake.getId();
tradeOrderService.addOrderTradeRecord(user.getUserId(), user.getOpenid(), wxTradeOrderNo, ComBatteryTradeOrder.PayType.WX,
commodityOrder.getFinalAmount(), ComBatteryTradeOrder.TradeType.DDC_SHOP, commodityOrder.getId(),
commodityOrder.getOrderNo(), user.getUserId(), nowDate);
}
return R.ok(resultMap);
}
/**
* 小程序唤起微信支付
*
* @param money
* 需要支付的金额
* @param openId
* 用户唤起微信支付的openid
* @param orderNo
* 业务订单号
* @param remark
* 交易备注
* @return 小程序支付参数
*/
private String getWxPayResult(BigDecimal money, String openId, String orderNo, String remark,String type) {
String result = "";
// 将剩余金额调起微信支付
if (isTest) {
money = BigDecimal.valueOf(0.01);
}
// 调用wx支付
// result = WxPayUtils.getUnifiedorder(appid, mchId, payKey, currencyNotifyUrl + PayCpmstant.BATTERY_STORE_ACTIVITY_PAY_NOTIFY_URL
// , remark, openId, orderNo, money,type);
log.info("用户购买商品微信支付返回参数:" + result);
return result;
}
/**
* 初始化订单数据
* @param commodity 商品数据
* @param userAddress 用户收货地址信息
* @param user 用户数据
* @param commoditySpecs 商品规格数据
* @param orderDto 用户请求参数
* @param nowDate 操作时间
* @param commodityActivity 拼团活动数据
* @return 初始化订单数据
*/
public static ComBatteryCommodityOrder getCreateOrder(ComBatteryCommodity commodity, ComBatteryUserAddress userAddress
, SysUser user, ComBatteryCommoditySpecs commoditySpecs, StartFightOrderDto orderDto, Date nowDate
,ComBatteryCommodityActivity commodityActivity){
ComBatteryCommodityOrder commodityOrder = new ComBatteryCommodityOrder();
commodityOrder.setUserId(user.getUserId());
commodityOrder.setOpenId(user.getOpenid());
commodityOrder.setStoreId(commodity.getStoreId());
commodityOrder.setActivityId(commodityActivity.getId());
commodityOrder.setCommodityId(commodity.getId());
commodityOrder.setSpecsId(commoditySpecs.getId());
commodityOrder.setOrderNo("PT" + Snowflake.getId());
commodityOrder.setActivityType(commodityActivity.getType());
commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFK);
commodityOrder.setPayStatus(ComBatteryCommodityOrder.PayStatus.WZF);
commodityOrder.setIsDel(ComBatteryCommodityOrder.IsDel.NO);
commodityOrder.setPayType(ComBatteryCommodityOrder.PayType.WX);
commodityOrder.setCount(orderDto.getCount());
commodityOrder.setPrice(commodityActivity.getPrice());
commodityOrder.setAmount(commodityActivity.getPrice().multiply(BigDecimal.valueOf(orderDto.getCount())));
commodityOrder.setFreight(commodity.getPostage());
commodityOrder.setFinalAmount(commodityOrder.getAmount().add(commodityOrder.getFreight()));
commodityOrder.setCreateAt(nowDate);
commodityOrder.setCreateBy(user.getUserId());
commodityOrder.setRemark(orderDto.getRemark());
//收货地址
commodityOrder.setAddressId(userAddress.getId());
commodityOrder.setReceivingName(userAddress.getName());
commodityOrder.setReceivingPhone(userAddress.getPhone());
commodityOrder.setReceivingRegionCode(userAddress.getProvinceAdcode() + "-" + userAddress.getCityAdcode() + "-" + userAddress.getDistrictAdcode());
commodityOrder.setReceivingRegion(userAddress.getProvinceName() + userAddress.getCityName() + userAddress.getDistrictName());
commodityOrder.setReceivingAddress(userAddress.getAddress());
if(orderDto.getTeamId() != null){
commodityOrder.setTeamId(orderDto.getTeamId());
}
return commodityOrder;
}
}