package com.dy.pipIrrSell.recharge;
|
|
import com.dy.common.webUtil.QueryResultVo;
|
import com.dy.pipIrrGlobal.daoSe.SeRechargeHistoryMapper;
|
import com.dy.pipIrrGlobal.daoSe.SeRechargeMapper;
|
import com.dy.pipIrrGlobal.pojoSe.SeRecharge;
|
import com.dy.pipIrrGlobal.pojoSe.SeRechargeHistory;
|
import com.dy.pipIrrGlobal.voSe.VoRecharge;
|
import lombok.extern.slf4j.Slf4j;
|
import org.apache.dubbo.common.utils.PojoUtils;
|
import org.apache.ibatis.annotations.Param;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author ZhuBaoMin
|
* @date 2023/12/4 17:20
|
* @LastEditTime 2023/12/4 17:20
|
* @Description
|
*/
|
|
@Slf4j
|
@Service
|
public class RechargeSv {
|
@Autowired
|
private SeRechargeMapper seRechargeMapper;
|
|
@Autowired
|
private SeRechargeHistoryMapper seRechargeHistoryMapper;
|
|
public QueryResultVo<List<VoRecharge>> getRecharges(QueryVo queryVo) {
|
//完善查询充值记录的起止时间
|
String rechargeTimeStart = queryVo.rechargeTimeStart;
|
String rechargeTimeStop = queryVo.rechargeTimeStop;
|
if(rechargeTimeStart != null) {
|
rechargeTimeStart = rechargeTimeStart + " 00:00:00";
|
queryVo.setRechargeTimeStart(rechargeTimeStart);
|
}
|
if(rechargeTimeStop != null) {
|
rechargeTimeStop = rechargeTimeStop + " 23:59:59";
|
queryVo.setRechargeTimeStop(rechargeTimeStop);
|
}
|
|
Map<String, Object> params = (Map<String, Object>) PojoUtils.generalize(queryVo);
|
|
Long itemTotal = seRechargeMapper.getRecordCount(params);
|
|
QueryResultVo<List<VoRecharge>> rsVo = new QueryResultVo<>() ;
|
rsVo.pageSize = queryVo.pageSize ;
|
rsVo.pageCurr = queryVo.pageCurr ;
|
|
rsVo.calculateAndSet(itemTotal, params);
|
rsVo.obj = seRechargeMapper.getRecharges(params);
|
return rsVo ;
|
}
|
|
/**
|
* 根据水卡编号（主键）删除充值记录
|
* @param cardId
|
* @return
|
*/
|
//public Integer deleteByPrimaryKey(Long cardId) {
|
// return seRechargeMapper.deleteByPrimaryKey(cardId);
|
//}
|
|
/**
|
* 添加充值记录
|
* @param po
|
* @return
|
*/
|
public Long add(SeRecharge po) {
|
seRechargeMapper.insert(po);
|
return po.getId();
|
}
|
|
/**
|
* 根据水卡编号删除充值记录
|
* @param cardId
|
* @return
|
*/
|
public Integer deleteByCardId(Long cardId) {
|
return seRechargeMapper.deleteByCardId(cardId);
|
}
|
//public Integer deleteByCardNum(String cardNum) {
|
// return seRechargeMapper.deleteByCardNum(cardNum);
|
//}
|
|
/**
|
* 添加充值历史表
|
* @param po
|
* @return
|
*/
|
public Long addHistory(SeRechargeHistory po){
|
seRechargeHistoryMapper.insert(po);
|
return po.getId();
|
}
|
|
/**
|
* 根据水卡id获取最近一条充值记录id
|
* @param cardId
|
* @return
|
*/
|
public Long selectIdByCardId(Long cardId){
|
SeRecharge seRecharge = seRechargeMapper.selectByCardId(cardId);
|
return seRecharge.getId();
|
}
|
}
|
