package com.dy.pipIrrSell.cardOperate;
|
|
import com.alibaba.fastjson2.JSON;
|
import com.alibaba.fastjson2.JSONObject;
|
import com.dy.common.aop.SsoAop;
|
import com.dy.common.webUtil.BaseResponse;
|
import com.dy.common.webUtil.BaseResponseUtils;
|
import com.dy.common.webUtil.QueryResultVo;
|
import com.dy.common.webUtil.ResultCodeMsg;
|
import com.dy.pipIrrGlobal.pojoBa.BaClient;
|
import com.dy.pipIrrGlobal.pojoSe.SeCardOperate;
|
import com.dy.pipIrrGlobal.pojoSe.SeClientCard;
|
import com.dy.pipIrrGlobal.pojoSe.SeManagerCard;
|
import com.dy.pipIrrGlobal.util.AmountToChinese;
|
import com.dy.pipIrrGlobal.voSe.VoActiveCard;
|
import com.dy.pipIrrGlobal.voSe.VoOperate;
|
import com.dy.pipIrrGlobal.voSe.VoRecharge;
|
import com.dy.pipIrrGlobal.voSe.VoReissueCard;
|
import com.dy.pipIrrSell.cardOperate.dto.*;
|
import com.dy.pipIrrSell.cardOperate.enums.OperateTypeENUM;
|
import com.dy.pipIrrSell.cardOperate.qo.*;
|
import com.dy.pipIrrSell.clientCard.CardStateENUM;
|
import com.dy.pipIrrSell.clientCard.ClientCardSv;
|
import com.dy.pipIrrSell.clientCard.LastOperateENUM;
|
import com.dy.pipIrrSell.result.SellResultCode;
|
import io.swagger.v3.oas.annotations.Operation;
|
import io.swagger.v3.oas.annotations.media.Content;
|
import io.swagger.v3.oas.annotations.media.Schema;
|
import io.swagger.v3.oas.annotations.responses.ApiResponse;
|
import io.swagger.v3.oas.annotations.responses.ApiResponses;
|
import io.swagger.v3.oas.annotations.tags.Tag;
|
import jakarta.validation.Valid;
|
import lombok.RequiredArgsConstructor;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Value;
|
import org.springframework.http.MediaType;
|
import org.springframework.transaction.annotation.Transactional;
|
import org.springframework.validation.BindingResult;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.math.BigDecimal;
|
import java.util.*;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2024-01-18 19:36
|
* @LastEditTime 2024-01-18 19:36
|
* @Description
|
*/
|
|
@Slf4j
|
@Tag(name = "水卡操作管理", description = "水卡各种操作")
|
@RestController
|
@RequestMapping(path="card")
|
@RequiredArgsConstructor
|
public class CardOperateCtrl {
|
private final CardOperateSv cardOperateSv;
|
private final ClientCardSv clientCardSv;
|
|
@Value("${project.divisionCode}")
|
private String divisionCode;
|
|
@Value("${project.projectNo}")
|
private Integer projectNo;
|
/**
|
* 开卡
|
* @param po 开卡传入对象
|
* @param bindingResult
|
* @return 水卡编号
|
*/
|
@PostMapping(path = "active", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_active(@RequestBody @Valid ActiveCard po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
// 依据水卡地址判断该卡是否可以开卡，未开过卡或不是正常状态、挂失状态的可开卡
|
if(!cardOperateSv.canActiveCard(po.getCardAddr())) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.ACTIVE_FAIL_CARD_ESIST.getMessage());
|
}
|
|
Long clientId = po.getClientId();
|
|
// 获取5级行政区划串areaCode
|
Long areaCodeL = cardOperateSv.getAreaCodeById(clientId);
|
if(areaCodeL == null) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.AREA_CODE_MISTAKE.getMessage());
|
}
|
String areaCode = String.valueOf(areaCodeL);
|
|
/**
|
* 根据行政区划串（areaCode）在水卡表中针对水卡编号（cardNum）进行模糊查询
|
* 如果顺序号已经达到最大值，提示用户联系系统管理员
|
* 如果顺序号未达到最大值，则加1
|
* cardNum为新的卡号
|
*/
|
String cardNum = Optional.ofNullable(cardOperateSv.getCardNumOfMax(areaCode)).orElse("");
|
if(cardNum != null && cardNum.trim().length() > 0) {
|
Integer number = Integer.parseInt(cardNum.substring(12));
|
number = number + 1;
|
if(number > 65535) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_OVERRUN.getMessage());
|
}
|
cardNum = cardNum.substring(0, 12) + String.format("%05d", number);
|
} else {
|
cardNum = areaCode + "00001";
|
}
|
|
/**
|
* cardAddr 水卡地址（仅仅写入，无业务）
|
* cardCost 卡片费用
|
* originalCardId 原水卡ID
|
* amount 充值金额，充值接口为输入参数，补卡接口为原卡退还金额
|
* reissueAmount 补卡金额，补卡时使用
|
* paymentId 支付方式编号
|
* remarks 备注
|
* operator 操作人编号
|
* activeTime 开卡时间
|
*/
|
String protocol = po.getProtocol();
|
String cardAddr = po.getCardAddr();
|
Integer cardCost = po.getCardCost();
|
Long originalCardId = po.getOriginalCardId();
|
Float amount = po.getAmount();
|
Long paymentId = po.getPaymentId();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date activeTime = new Date();
|
|
/**
|
* 添加农户卡记录，退还金额作为当前余额
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setProtocol(protocol);
|
seClientCard.setCardaddr(cardAddr);
|
seClientCard.setCardnum(cardNum);
|
seClientCard.setClientid(clientId);
|
seClientCard.setMoney(amount);
|
seClientCard.setState(CardStateENUM.NORMAL.getCode());
|
if(originalCardId != null) {
|
seClientCard.setOriginalCardId(originalCardId);
|
}
|
seClientCard.setCreatedt(activeTime);
|
seClientCard.setLastoper(LastOperateENUM.ACTIVE.getCode());
|
Long cardId = Optional.ofNullable(clientCardSv.add(seClientCard)).orElse(0L) ;
|
if(cardId == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.ACTIVE_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加开卡记录，退还金额作为充值金额
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setMoney(0f);
|
seCardOperate.setCardCost(cardCost);
|
seCardOperate.setPaymentId(paymentId);
|
if(originalCardId != null) {
|
// 补卡
|
seCardOperate.setOperateType(OperateTypeENUM.REISSUE.getCode());
|
}else {
|
// 开新卡
|
seCardOperate.setOperateType(OperateTypeENUM.ACTIVE.getCode());
|
}
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(activeTime);
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.ACTIVE_FAIL_WRITE_ACTIVE_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 如果操作人员开卡时输入了充值金额，则开卡后调用充值功能
|
* 补卡除外，补卡的退还金额是从挂失卡中转移过来的，没有实际金钱交易
|
*/
|
if(amount != null && amount > 0 && originalCardId == null) {
|
DtoRecharge dtoRecharge = new DtoRecharge();
|
dtoRecharge.setCardNum(Long.parseLong(cardNum));
|
dtoRecharge.setAmount(amount);
|
dtoRecharge.setPaymentId(paymentId);
|
dtoRecharge.setRemarks(remarks);
|
dtoRecharge.setOperator(operator);
|
dtoRecharge.setMoney(0f);
|
dtoRecharge.setGift(0f);
|
dtoRecharge.setPrice(0f);
|
BaseResponse<Boolean> job = cardOperateSv.addRecharge(dtoRecharge);
|
if(!job.getCode().equals("0001")) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.ACTIVE_FAIL_RECHARGE_EXCEPTION.getMessage());
|
}
|
}
|
|
Map map = new HashMap();
|
// map.put("projectNo", String.format("%02x", Integer.parseInt(cardOperateSv.getProjectNo())));
|
map.put("projectNo", String.format("%02x", projectNo));
|
map.put("orderNumber", rec);
|
map.put("cardNum", cardNum);
|
return BaseResponseUtils.buildSuccess(map) ;
|
}
|
|
/**
|
* 补卡
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "reissue", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_reissue(@RequestBody @Valid DtoReissue po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardAddr 新的水卡地址（仅仅写入，无业务）
|
* clientNum 农户编号，开新卡使用，通过老卡号获取
|
* cardNum 水卡编号，传入的是老卡号，返回的是新卡号
|
* cardId 原水卡（挂失水卡）ID，转移余额后需要更新卡余额为0
|
* moeny 余额，挂失时使用
|
* cardCost 卡片费用
|
* reissueAmount 退还金额
|
* paymentId 支付方式编号
|
* remarks 备注
|
* operator 操作人编号
|
*/
|
|
String protocol;
|
String cardAddr = po.getCardAddr();
|
String clientNum = "";
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Long cardId = 0L;
|
Integer cardCost = Optional.ofNullable(po.getCardCost()).orElse(0);
|
Float reissueAmount = po.getReissueAmount();
|
Long paymentId = po.getPaymentId();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
|
// 判断当前水卡是否为挂失状态且未补卡，仅已经挂失且未补卡的可以补卡
|
if(!cardOperateSv.isLostAndUnreplaced(cardNum)) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
// 如果传入了退还金额，需要判断老卡（被挂失的水卡）挂失时是否已经退款，无论退款多少都提示用户挂失时已退款
|
if(reissueAmount != null && reissueAmount > 0) {
|
Double tradeAmount = cardOperateSv.getTradeAmountByCardNo(cardNum);
|
if(tradeAmount != null && tradeAmount > 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.THE_FEE_CANNOT_BE_REFUNDED.getMessage());
|
}
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
clientNum = map.get("clientNum").toString();
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
protocol = map.get("protocol").toString();
|
|
/**
|
* 如果是补卡调用的开卡且转移了退还金额，需修改挂失卡余额为0
|
*/
|
if(reissueAmount != null) {
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setMoney(0f);
|
cardOperateSv.updateClientCard(seClientCard);
|
}
|
|
/**
|
* 添加开卡记录，退还金额冲到新卡中
|
*/
|
ActiveCard activeCard = new ActiveCard();
|
activeCard.setProtocol(protocol);
|
activeCard.setCardAddr(cardAddr);
|
activeCard.setClientId(clientId);
|
activeCard.setOriginalCardId(cardId);
|
activeCard.setCardCost(cardCost);
|
activeCard.setAmount(reissueAmount);
|
activeCard.setPaymentId(paymentId);
|
activeCard.setRemarks(remarks);
|
activeCard.setOperator(operator);
|
BaseResponse<java.lang.Boolean> baseResponse_addActive = add_active(activeCard, null);
|
|
if(!baseResponse_addActive.getCode().equals("0001")) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.REPLACE_FAIL_WRITE_RECHARGE_ERROR.getMessage());
|
}
|
|
JSONObject job_content = (JSONObject) JSON.toJSON( baseResponse_addActive.getContent());
|
cardNum = job_content.getLong("cardNum");
|
String orderNumber = job_content.getString("orderNumber");
|
String projectNo = job_content.getString("projectNo");
|
|
Map map_response = new HashMap();
|
map_response.put("projectNo", projectNo);
|
map_response.put("orderNumber", orderNumber);
|
map_response.put("cardNum", cardNum);
|
map_response.put("protocol", protocol);
|
return BaseResponseUtils.buildSuccess(map_response) ;
|
}
|
|
/**
|
* 充值
|
* @param po 充值传输对象
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "recharge", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_recharge(@RequestBody @Valid DtoRecharge po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
return cardOperateSv.addRecharge(po);
|
}
|
|
/**
|
* 销卡
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "cancel", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_cancel(@RequestBody @Valid DtoCancel po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardId 水卡编号（非传入参数，由cardNum反查，修改农户卡使用）
|
* clientId 农户编号（非传入参数，由cardNum反查）
|
* cardNum 水卡编号
|
* refund 退款金额
|
* refundType 退款方式
|
* remarks 备注
|
* operator 操作人编号
|
* cancelTime 注销时间
|
*/
|
Long cardId = 0L;
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Float refund = po.getRefund();
|
Byte refundType = po.getRefundType();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date cancelTime = new Date();
|
|
// 验证水卡状态是否支持当前操作
|
String stateName = Optional.ofNullable(clientCardSv.getCardStateByCardNum(cardNum)).orElse("");
|
if(stateName.length() == 0 || !stateName.equals("正常")) {
|
return BaseResponseUtils.buildErrorMsg(stateName + ", " + SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
|
/**
|
* 修改农户卡信息：
|
* 注销时间
|
* 最后操作类型-4
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setCanceldt(cancelTime);
|
seClientCard.setMoney(0f);
|
seClientCard.setState(CardStateENUM.CANCELLED.getCode());
|
seClientCard.setLastoper(LastOperateENUM.CANCEL.getCode());
|
Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0);
|
if(rec_updateClientCard == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CANCEL_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加注销记录
|
* 支付方式为现金
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setTradeAmount(-refund);
|
seCardOperate.setPaymentId(1L);
|
seCardOperate.setOperateType(OperateTypeENUM.CANCEL.getCode());
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(cancelTime);
|
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CANCEL_FAIL_WRITE_CANCELL_ERROR.getMessage());
|
}
|
|
Map map_response = new HashMap();
|
map_response.put("projectNo", String.format("%02x", projectNo));
|
map_response.put("orderNumber", rec);
|
map_response.put("cardNum", cardNum);
|
return BaseResponseUtils.buildSuccess(map_response) ;
|
}
|
|
/**
|
* 挂失
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "loss", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_loss(@RequestBody @Valid DtoLoss po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardId 水卡编号（非传入参数，由cardNum反查）
|
* clientId 农户编号（非传入参数，由cardNum反查）
|
* cardNum 要挂失的水卡编号
|
* money 余额
|
* refund 退款金额
|
* remarks 备注
|
* operator 操作人编号
|
* lossTime 挂失时间
|
*/
|
Long cardId = 0L;
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Float money = Optional.ofNullable(po.getMoney()).orElse(0f);
|
Float refund = Optional.ofNullable(po.getRefund()).orElse(0f);
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date lossTime = new Date();
|
|
// 验证水卡状态是否支持当前操作
|
String stateName = Optional.ofNullable(clientCardSv.getCardStateByCardNum(cardNum)).orElse("");
|
if(stateName.length() == 0 || !stateName.equals("正常")) {
|
return BaseResponseUtils.buildErrorMsg(stateName + ", " + SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
|
/**
|
* 修改农户卡信息：
|
* 余额
|
* 挂失时间
|
* 状态
|
* 最后操作类型-6
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setMoney(money);
|
seClientCard.setLossdtdt(lossTime);
|
seClientCard.setState(CardStateENUM.LOSS.getCode());
|
seClientCard.setLastoper(LastOperateENUM.LOSS.getCode());
|
Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0);
|
if(rec_updateClientCard == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.LOSS_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加挂失记录
|
* 如果退款金额不为空，则传入负值
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setMoney(money);
|
seCardOperate.setTradeAmount(-refund);
|
seCardOperate.setPaymentId(1L);
|
seCardOperate.setOperateType(OperateTypeENUM.LOSS.getCode());
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(lossTime);
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.LOSS_FAIL_WRITE_LOSS_ERROR.getMessage());
|
}
|
|
Map map_response = new HashMap();
|
map_response.put("projectNo", String.format("%02x", projectNo));
|
map_response.put("orderNumber", rec);
|
map_response.put("cardNum", cardNum);
|
return BaseResponseUtils.buildSuccess(map_response) ;
|
}
|
|
/**
|
* 冲正
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "reversal", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_reversal(@RequestBody @Valid DtoReversal po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardId 水卡编号（非传入参数，由cardNum反查，修改农户卡使用）
|
* clientId 农户编号（非传入参数，由cardNum反查）
|
* cardNum 水卡编号
|
* cardBalance 卡片余额
|
* systemBalance 系统余额
|
* remarks 备注
|
* operator 操作人编号
|
* reversalTime 冲正时间
|
*/
|
Long cardId = 0L;
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Float cardBalance = po.getCardBalance();
|
Float systemBalance = po.getSystemBalance();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date reversalTime = new Date();
|
|
// 验证水卡状态是否支持当前操作
|
String stateName = Optional.ofNullable(clientCardSv.getCardStateByCardNum(cardNum)).orElse("");
|
if(stateName.length() == 0 || !stateName.equals("正常")) {
|
return BaseResponseUtils.buildErrorMsg(stateName + ", " + SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
|
/**
|
* 修改农户卡信息：
|
* 挂失时间
|
* 最后操作类型-4
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setReversaldt(reversalTime);
|
seClientCard.setMoney(cardBalance);
|
seClientCard.setLastoper(LastOperateENUM.REVERSAL.getCode());
|
Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0);
|
if(rec_updateClientCard == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.RECHARGE_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加冲正记录
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setMoney(cardBalance);
|
seCardOperate.setSystemBalance(systemBalance);
|
seCardOperate.setOperateType(OperateTypeENUM.REVERSAL.getCode());
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(reversalTime);
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.REVERSAL_FAIL_WRITE_REVERSAL_ERROR.getMessage());
|
}
|
|
Map map_response = new HashMap();
|
map_response.put("projectNo", String.format("%02x", projectNo));
|
map_response.put("orderNumber", rec);
|
map_response.put("cardNum", cardNum);
|
return BaseResponseUtils.buildSuccess(map_response) ;
|
|
}
|
|
/**
|
* 补扣
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "refund", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_refund(@RequestBody @Valid DtoRefund po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardId 水卡编号（非传入参数，由cardNum反查，修改农户卡使用）
|
* clientId 农户编号（非传入参数，由cardNum反查）
|
* cardNum 水卡编号
|
* money 卡片余额
|
* refund 补扣余额
|
* remarks 备注
|
* operator 操作人编号
|
* refundTime 补扣时间
|
*/
|
Long cardId = 0L;
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Float money = po.getMoney();
|
Float refund = po.getRefund();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date refundTime = new Date();
|
|
// 验证水卡状态是否支持当前操作
|
String stateName = Optional.ofNullable(clientCardSv.getCardStateByCardNum(cardNum)).orElse("");
|
if(stateName.length() == 0 || !stateName.equals("正常")) {
|
return BaseResponseUtils.buildErrorMsg(stateName + ", " + SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
|
/**
|
* 修改农户卡信息：
|
* 挂失时间
|
* 最后操作类型-4
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setRefunddt(refundTime);
|
seClientCard.setMoney(money + refund);
|
seClientCard.setLastoper(LastOperateENUM.REFUND.getCode());
|
Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0);
|
if(rec_updateClientCard == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.RECHARGE_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加补扣记录
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setMoney(money);
|
seCardOperate.setRefundAmount(refund);
|
seCardOperate.setOperateType(OperateTypeENUM.REFUND.getCode());
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(refundTime);
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.REFUND_FAIL_WRITE_REFUND_ERROR.getMessage());
|
}
|
|
return BaseResponseUtils.buildSuccess(true) ;
|
}
|
|
/**
|
* 解锁
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "unlock", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> add_unlock(@RequestBody @Valid DtoUnlock po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* cardId 水卡主键（非传入参数，由cardNum反查，修改农户卡使用）
|
* clientId 农户编号（非传入参数，由cardNum反查）
|
* cardNum 水卡编号
|
* money 余额
|
* remarks 备注
|
* operator 操作人编号
|
* unlockTime 解锁时间
|
*/
|
Long cardId = 0L;
|
Long clientId = 0L;
|
Long cardNum = po.getCardNum();
|
Float money = po.getMoney();
|
String remarks = po.getRemarks();
|
Long operator = po.getOperator();
|
Date unlockTime = new Date();
|
|
// 判断当前水卡是否为挂失状态且未补卡，仅已经挂失其未补卡的可以解锁
|
if(!cardOperateSv.isLostAndUnreplaced(cardNum)) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.THE_CARD_NOT_SUPPORT_THIS_OPERATION.getMessage());
|
}
|
|
/**
|
* 依据水卡编号获取水卡表主键及农户编号
|
*/
|
Map map = Optional.ofNullable(clientCardSv.getCardIdAndClientNum(cardNum)).orElse(new HashMap());
|
if(map == null || map.size() <= 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_MISTAKE.getMessage());
|
}
|
cardId = Long.parseLong(map.get("cardId").toString());
|
clientId = Long.parseLong(map.get("clientId").toString());
|
|
/**
|
* 修改农户卡信息：
|
* 挂失时间
|
* 最后操作类型-4
|
*/
|
SeClientCard seClientCard = new SeClientCard();
|
seClientCard.setId(cardId);
|
seClientCard.setUnlockdt(unlockTime);
|
seClientCard.setMoney(money);
|
seClientCard.setState(CardStateENUM.NORMAL.getCode());
|
seClientCard.setLastoper(LastOperateENUM.UNLOCK.getCode());
|
Integer rec_updateClientCard = Optional.ofNullable(clientCardSv.UpdateClientCard(seClientCard)).orElse(0);
|
if(rec_updateClientCard == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.UNLOCK_FAIL_WRITE_CLIENT_CARD_ERROR.getMessage());
|
}
|
|
/**
|
* 添加解锁记录
|
*/
|
SeCardOperate seCardOperate = new SeCardOperate();
|
seCardOperate.setCardId(cardId);
|
seCardOperate.setClientId(clientId);
|
seCardOperate.setMoney(money);
|
seCardOperate.setOperateType(OperateTypeENUM.UNLOCK.getCode());
|
seCardOperate.setRemarks(remarks);
|
seCardOperate.setOperator(operator);
|
seCardOperate.setOperateDt(unlockTime);
|
Long rec = Optional.ofNullable(cardOperateSv.add(seCardOperate)).orElse(0L);
|
if(rec == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.UNLOCK_FAIL_WRITE_UNLOCK_ERROR.getMessage());
|
}
|
|
Map map_response = new HashMap();
|
map_response.put("projectNo", String.format("%02x", projectNo));
|
map_response.put("orderNumber", rec);
|
map_response.put("cardNum", cardNum);
|
return BaseResponseUtils.buildSuccess(map_response) ;
|
|
}
|
|
/**
|
* 创建管理卡
|
* @param po
|
* @param bindingResult
|
* @return
|
*/
|
@PostMapping(path = "create_manager_card", consumes = MediaType.APPLICATION_JSON_VALUE)
|
@Transactional(rollbackFor = Exception.class)
|
@SsoAop()
|
public BaseResponse<Boolean> createManagerCard(@RequestBody @Valid ManagerCard po, BindingResult bindingResult){
|
if(bindingResult != null && bindingResult.hasErrors()){
|
return BaseResponseUtils.buildErrorMsg(Objects.requireNonNull(bindingResult.getFieldError()).getDefaultMessage());
|
}
|
|
/**
|
* 根据行政区划串（divisionCode）在管理卡表中针对卡片编号（cardNum）进行模糊查询
|
* 如果顺序号已经达到最大值，提示用户联系系统管理员
|
* 如果顺序号未达到最大值，则加1
|
* cardNum为新的卡号
|
*/
|
String cardNum = Optional.ofNullable(cardOperateSv.getManagerCardNumOfMax(divisionCode)).orElse("");
|
if(cardNum != null && cardNum.trim().length() > 0) {
|
Integer number = Integer.parseInt(cardNum.substring(12));
|
number = number + 1;
|
if(number > 65535) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CARD_NUMBER_OVERRUN.getMessage());
|
}
|
cardNum = cardNum.substring(0, 12) + String.format("%05d", number);
|
} else {
|
cardNum = divisionCode + "00001";
|
}
|
|
SeManagerCard seManagerCard = new SeManagerCard();
|
seManagerCard.setCardAddr(po.getCardAddr());
|
seManagerCard.setCardNum(cardNum);
|
seManagerCard.setCardType(po.getCardType());
|
seManagerCard.setCreateTime(new Date());
|
seManagerCard.setRemarks(po.getRemarks());
|
Long managerCardId = cardOperateSv.addManagerCard(seManagerCard);
|
if(managerCardId == 0) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.CREATE_MANAGER_CARD_ERROR.getMessage());
|
}
|
|
return BaseResponseUtils.buildSuccess(cardNum);
|
|
//Map map = new HashMap();
|
//map.put("cardNum", cardNum);
|
//return BaseResponseUtils.buildSuccess(map) ;
|
}
|
|
|
/**
|
* 获取充值记录
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获取充值记录", description = "返回充值记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页充值数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoRecharge.class))}
|
)
|
})
|
@GetMapping(path = "/getRecharges")
|
@SsoAop()
|
public BaseResponse<QueryResultVo<List<VoRecharge>>> get(QoRecharge vo){
|
try {
|
QueryResultVo<List<VoRecharge>> res = cardOperateSv.getRecharges(vo);
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取充值记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 根据指定条件获取交易明细
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获得交易记录明细", description = "返回交易记录明细")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页农户数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = BaClient.class))}
|
)
|
})
|
@GetMapping(path = "getTransactions")
|
@SsoAop()
|
public BaseResponse<Map> getOperates(QoTransaction vo){
|
try {
|
Map res = cardOperateSv.getTransactions(vo);
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("查询交易记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 根据指定条件获取开卡记录
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获取开卡记录", description = "返回开卡记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页开卡数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoActiveCard.class))}
|
)
|
})
|
@GetMapping(path = "/getActiveCards")
|
@SsoAop()
|
public BaseResponse<QueryResultVo<List<VoActiveCard>>> getActiveCards(QoActiveCard vo){
|
try {
|
QueryResultVo<List<VoActiveCard>> res = cardOperateSv.getActiveCards(vo);
|
// if(res.itemTotal == 0) {
|
// return BaseResponseUtils.buildErrorMsg(SellResultCode.No_ActiveCards.getMessage());
|
// }
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取开卡记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 根据指定条件获取补卡记录
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获取补卡记录", description = "返回补卡记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页补卡数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoActiveCard.class))}
|
)
|
})
|
@GetMapping(path = "/getReissueCards")
|
@SsoAop()
|
public BaseResponse<QueryResultVo<List<VoReissueCard>>> getReissueCards(QoReissueCard vo){
|
try {
|
QueryResultVo<List<VoReissueCard>> res = cardOperateSv.getReissueCards(vo);
|
// if(res.itemTotal == 0) {
|
// return BaseResponseUtils.buildErrorMsg(SellResultCode.No_ReissueCards.getMessage());
|
// }
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取补卡记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 根据指定条件获取通用操作记录
|
* 注销、挂失、冲正、解锁通用
|
* 注销-3，挂失-6，冲正-7，解锁-8
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获取通用操作记录", description = "返回通用操作记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页开卡数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoActiveCard.class))}
|
)
|
})
|
@GetMapping(path = "/getOptions")
|
@SsoAop()
|
public BaseResponse<QueryResultVo<List<VoOperate>>> getCommonOperations(QoCommonOperate vo){
|
// 验证操作类型是否正确
|
Integer operateType = Optional.ofNullable(vo.getOperateType()).orElse(0);
|
if(operateType != 3 && operateType != 6 && operateType != 7 && operateType != 8) {
|
return BaseResponseUtils.buildErrorMsg(SellResultCode.PARAMS_ERROR.getMessage());
|
}
|
|
try {
|
QueryResultVo<List<VoOperate>> res = cardOperateSv.getCommonOperations(vo);
|
// if(res.itemTotal == 0) {
|
// return BaseResponseUtils.buildErrorMsg(SellResultCode.No_CANCELS.getMessage());
|
// }
|
return BaseResponseUtils.buildSuccess(res);
|
} catch (Exception e) {
|
log.error("获取开卡记录异常", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 根据指定条件获取收据列表
|
* @param vo
|
* @return
|
*/
|
@Operation(summary = "获取收据记录", description = "返回收据记录")
|
@ApiResponses(value = {
|
@ApiResponse(
|
responseCode = ResultCodeMsg.RsCode.SUCCESS_CODE,
|
description = "返回一页补卡数据（BaseResponse.content:QueryResultVo[{}]）",
|
content = {@Content(mediaType = MediaType.APPLICATION_JSON_VALUE,
|
schema = @Schema(implementation = VoActiveCard.class))}
|
)
|
})
|
@GetMapping(path = "/get_receipts")
|
@SsoAop()
|
public BaseResponse<Map> getReceipts(QoReceipt vo){
|
try {
|
// Map res = Optional.ofNullable(cardOperateSv.getReceipts(vo)).orElse(new HashMap());
|
// if(res.size() == 0) {
|
// return BaseResponseUtils.buildErrorMsg(SellResultCode.No_RECEIPTS.getMessage());
|
// }
|
return BaseResponseUtils.buildSuccess(cardOperateSv.getReceipts(vo));
|
} catch (Exception e) {
|
log.error("获取电子钱包账户记录", e);
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
}
|
|
/**
|
* 金额转大写
|
* @param amount
|
* @return
|
*/
|
|
@GetMapping(path = "/amount_to_chinese")
|
public BaseResponse<Boolean> amountToChinese(BigDecimal amount) {
|
try {
|
AmountToChinese amountToChinese = new AmountToChinese();
|
String chinese = amountToChinese.toChinese(amount);
|
return BaseResponseUtils.buildSuccess(chinese) ;
|
} catch (Exception e) {
|
return BaseResponseUtils.buildException(e.getMessage()) ;
|
}
|
|
}
|
}
|
