package com.doumee.service.business.impl;
|
|
import com.doumee.core.constants.ResponseStatus;
|
import com.doumee.core.exception.BusinessException;
|
import com.doumee.core.model.LoginUserInfo;
|
import com.doumee.core.model.PageData;
|
import com.doumee.core.model.PageWrap;
|
import com.doumee.core.utils.Constants;
|
import com.doumee.core.utils.DateUtil;
|
import com.doumee.core.utils.ID;
|
import com.doumee.core.utils.Utils;
|
import com.doumee.dao.business.CardMapper;
|
import com.doumee.dao.business.CardParamMapper;
|
import com.doumee.dao.business.join.CardJoinMapper;
|
import com.doumee.dao.business.model.Card;
|
import com.doumee.dao.business.model.CardParam;
|
import com.doumee.dao.business.model.Scan;
|
import com.doumee.dao.web.dto.AddCardDTO;
|
import com.doumee.dao.web.dto.CardDTO;
|
import com.doumee.dao.web.dto.QueryCardDTO;
|
import com.doumee.dao.web.request.DealIntegralRequest;
|
import com.doumee.service.business.CardService;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.doumee.service.business.IntegralService;
|
import com.github.yulichang.wrapper.MPJLambdaWrapper;
|
import org.apache.commons.lang3.StringUtils;
|
import org.apache.shiro.SecurityUtils;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.util.CollectionUtils;
|
|
import java.time.LocalDateTime;
|
import java.time.LocalTime;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Objects;
|
|
/**
|
* 充值卡信息表Service实现
|
* @author 江蹄蹄
|
* @date 2023/04/13 11:22
|
*/
|
@Service
|
public class CardServiceImpl implements CardService {
|
|
@Autowired
|
private CardMapper cardMapper;
|
|
@Autowired
|
private CardParamMapper cardParamMapper;
|
|
@Autowired
|
private CardJoinMapper cardJoinMapper;
|
|
@Autowired
|
private IntegralService integralService;
|
|
@Transactional(rollbackFor = {Exception.class,BusinessException.class})
|
@Override
|
public List<Integer> create(AddCardDTO card) {
|
|
LoginUserInfo loginUserInfo = (LoginUserInfo) SecurityUtils.getSubject().getPrincipal();
|
|
CardParam cardParam = cardParamMapper.selectById(card.getParamId());
|
if (Objects.isNull(cardParam)){
|
throw new BusinessException(ResponseStatus.BAD_REQUEST.getCode(),"卡类型参议异常");
|
}
|
Integer num = card.getNum();
|
|
int startNo = Integer.valueOf(cardParam.getStartNo());
|
Card count = new Card();
|
count.setParamId(card.getParamId());
|
long countNum = Constants.formatLongNum(count(count));
|
startNo = countNum != 0 ? (int) (startNo + countNum) : startNo;
|
|
List<Integer> list = new ArrayList<>();
|
for (int i = 0; i <num; i++) {
|
Card insert = new Card();
|
insert.setParamId(card.getParamId());
|
insert.setCreator(loginUserInfo.getId());
|
insert.setEditor(loginUserInfo.getId());
|
|
String code = cardParam.getIndexNo()+String.format("%07d", startNo+i);
|
String password = ID.nextGUID().substring(0, 8);
|
|
insert.setCode(code);
|
insert.setPassword(password);
|
insert.setMoney(card.getMoney());
|
insert.setIsUsed(Constants.ZERO);
|
Date validDate = Objects.isNull(card.getValidDate()) ? null : DateUtil.toDate(LocalDateTime.of(card.getValidDate(), LocalTime.of(23, 59, 59)));
|
insert.setValidDate(validDate);
|
insert.setStatus(Constants.ZERO);
|
insert.setSortnum(startNo+i);
|
cardMapper.insert(insert);
|
list.add(insert.getId());
|
}
|
|
return list;
|
}
|
|
@Override
|
public void deleteById(Integer id) {
|
Card card = new Card();
|
card.setId(id);
|
card.setIsdeleted(Constants.ONE);
|
cardMapper.updateById(card);
|
}
|
|
@Override
|
public void delete(Card card) {
|
UpdateWrapper<Card> deleteWrapper = new UpdateWrapper<>(card);
|
cardMapper.delete(deleteWrapper);
|
}
|
|
@Override
|
public void deleteByIdInBatch(List<Integer> ids) {
|
if (CollectionUtils.isEmpty(ids)) {
|
return;
|
}
|
cardMapper.deleteBatchIds(ids);
|
}
|
|
@Override
|
public void updateById(AddCardDTO card) {
|
Card update = new Card();
|
update.setId(card.getId());
|
update.setStatus(card.getStatus());
|
Date validDate = Objects.isNull(card.getValidDate()) ? null : DateUtil.toDate(LocalDateTime.of(card.getValidDate(), LocalTime.of(23, 59, 59)));
|
update.setValidDate(validDate);
|
cardMapper.updateById(update);
|
}
|
|
@Override
|
public void updateByIdInBatch(List<AddCardDTO> cards) {
|
if (CollectionUtils.isEmpty(cards)) {
|
return;
|
}
|
for (AddCardDTO card: cards) {
|
this.updateById(card);
|
}
|
}
|
|
@Override
|
public Card findById(Integer id) {
|
return cardMapper.selectById(id);
|
}
|
|
@Override
|
public Card findOne(Card card) {
|
QueryWrapper<Card> wrapper = new QueryWrapper<>(card);
|
return cardMapper.selectOne(wrapper);
|
}
|
|
@Override
|
public List<Card> findList(Card card) {
|
QueryWrapper<Card> wrapper = new QueryWrapper<>(card);
|
return cardMapper.selectList(wrapper);
|
}
|
|
@Override
|
public PageData<CardDTO> findPage(PageWrap<QueryCardDTO> pageWrap) {
|
IPage<Card> page = new Page<>(pageWrap.getPage(), pageWrap.getCapacity());
|
MPJLambdaWrapper<Card> queryWrapper = new MPJLambdaWrapper<>();
|
Utils.MP.blankToNull(pageWrap.getModel());
|
queryWrapper.eq(Card::getIsdeleted,Constants.ZERO);
|
if (pageWrap.getModel().getStartDateTime() != null && pageWrap.getModel().getEndDateTime() != null) {
|
queryWrapper.ge(Card::getCreateDate, pageWrap.getModel().getStartDateTime());
|
queryWrapper.le(Card::getCreateDate, pageWrap.getModel().getEndDateTime());
|
}
|
|
if (pageWrap.getModel().getCode() != null) {
|
queryWrapper.likeRight(Card::getCode, pageWrap.getModel().getCode());
|
}
|
|
if (pageWrap.getModel().getIsUsed() != null) {
|
queryWrapper.eq(Card::getIsUsed, pageWrap.getModel().getIsUsed());
|
}
|
|
if (pageWrap.getModel().getStatus() != null) {
|
queryWrapper.eq(Card::getStatus, pageWrap.getModel().getStatus());
|
}
|
queryWrapper.selectAll(Card.class)
|
.selectAs(CardParam::getName,CardDTO::getParamName);
|
|
queryWrapper.leftJoin(CardParam.class,CardParam::getId,Card::getParamId);
|
queryWrapper.orderByDesc(Card::getCreateDate);
|
// for(PageWrap.SortData sortData: pageWrap.getSorts()) {
|
// if (sortData.getDirection().equalsIgnoreCase(PageWrap.DESC)) {
|
// queryWrapper.orderByDesc(sortData.getProperty());
|
// } else {
|
// queryWrapper.orderByAsc(sortData.getProperty());
|
// }
|
// }
|
|
return PageData.from(cardJoinMapper.selectJoinPage(page, CardDTO.class,queryWrapper));
|
}
|
|
@Override
|
public Long count(Card card) {
|
QueryWrapper<Card> wrapper = new QueryWrapper<>(card);
|
return cardMapper.selectCount(wrapper);
|
}
|
|
@Transactional(rollbackFor = {Exception.class,BusinessException.class})
|
@Override
|
public void exchangeCard(String code, String password, Integer memberId) {
|
|
QueryWrapper<Card> wrapper = new QueryWrapper<>();
|
wrapper.lambda().eq(Card::getCode,code)
|
// .eq(Card::getPassword,password.toUpperCase())
|
// .eq(Card::getIsdeleted,Constants.ZERO)
|
.last("limit 1");
|
Card card = cardMapper.selectOne(wrapper);
|
if (Objects.isNull(card)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"卡号不正确");
|
}
|
|
if (Constants.equalsInteger(card.getIsdeleted(),Constants.ONE)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"卡已删除");
|
}
|
|
if ((!Objects.isNull(card)) && Constants.equalsInteger(card.getIsUsed(),Constants.ONE)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"充值卡已使用");
|
}
|
|
if (Constants.equalsInteger(card.getStatus(),Constants.ONE)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"充值卡已经被禁用");
|
}
|
|
if (Objects.nonNull(card.getValidDate()) && card.getValidDate().before(new Date())){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"充值卡已经过期");
|
}
|
|
if (!card.getPassword().equalsIgnoreCase(password)){
|
throw new BusinessException(ResponseStatus.DATA_EMPTY.getCode(),"密码错误");
|
}
|
|
|
UpdateWrapper<Card> updateWrapper = new UpdateWrapper<>();
|
updateWrapper.lambda().set(Card::getIsUsed,Constants.ONE)
|
.set(Card::getMemberId,memberId)
|
.set(Card::getUseDate,new Date());
|
updateWrapper.lambda().eq(Card::getId,card.getId());
|
cardMapper.update(null,updateWrapper);
|
|
DealIntegralRequest dealIntegralRequest = new DealIntegralRequest();
|
dealIntegralRequest.setIntegralObjType(Constants.IntegralObjType.EXCHANGE_CARD);
|
dealIntegralRequest.setIntegralNum(card.getMoney());
|
dealIntegralRequest.setMemberId(memberId);
|
dealIntegralRequest.setObjId(card.getId());
|
dealIntegralRequest.setDealType(Constants.ZERO);
|
integralService.dealIntegral(dealIntegralRequest);
|
}
|
}
|
