//
|
// Source code recreated from a .class file by IntelliJ IDEA
|
// (powered by FernFlower decompiler)
|
//
|
|
package com.flow.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.flow.mapper.CardMapper;
|
import com.flow.pojo.Card;
|
import com.flow.pojo.OperationLog;
|
import com.flow.service.CardService;
|
import com.flow.service.OperationLogService;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import java.text.SimpleDateFormat;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
public class CardServiceImpl extends ServiceImpl<CardMapper, Card> implements CardService {
|
@Autowired
|
CardMapper cardMapper;
|
|
@Autowired
|
OperationLogService operationLogService;
|
public CardServiceImpl() {
|
}
|
|
public List<Card> FindCard() {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("none", "0");
|
List<Card> cardList = ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
return cardList;
|
}
|
|
public PageInfo<Card> FindCarda(Integer page, Integer limit) {
|
PageHelper.startPage(page, limit);
|
List<Card> cardList = this.cardMapper.findAllUsers();
|
PageInfo<Card> info = new PageInfo(cardList);
|
return info;
|
}
|
|
public PageInfo<Card> FindCardaZi(Card card, Integer page, Integer limit) {
|
PageHelper.startPage(page, limit);
|
String n = null;
|
System.out.println(n);
|
System.out.println("北极星云空间技术股份有限公司");
|
System.out.println(card.getCompany());
|
List<Card> cardList = this.cardMapper.findAllUsersZi(card.getCompany());
|
System.out.println(cardList);
|
PageInfo<Card> info = new PageInfo(cardList);
|
return info;
|
}
|
|
public int DeleteCard(String num,String caozuoname) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("num", num);
|
Card card1 = (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper);
|
Card card = new Card();
|
card.setNone("1");
|
OperationLog operationLog = new OperationLog();
|
operationLog.setCaozuotype("删除");
|
operationLog.setCaozuocontent("删除卡号："+card1.getCardnumber());
|
operationLog.setCaozuoname(caozuoname);
|
operationLogService.addOperationLog(operationLog);
|
|
return ((CardMapper)this.baseMapper).update(card, queryWrapper);
|
}
|
|
public int UpdateCard(Card card) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("num", card.getNum());
|
// Card card1 = (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper);
|
// OperationLog operationLog = new OperationLog();
|
// operationLog.setCaozuotype("修改");
|
// operationLog.setCaozuocontent("修改卡号："+card1.getCardnumber());
|
// operationLog.setCaozuoname(card1.getCaozuoname());
|
// operationLogService.addOperationLog(operationLog);
|
return ((CardMapper)this.baseMapper).update(card, queryWrapper);
|
}
|
|
public int UpdateCardChong(Card card) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", card.getCardnumber());
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
card.setEnterdate(formatter.format(date));
|
return ((CardMapper)this.baseMapper).update(card, queryWrapper);
|
}
|
|
@Transactional(rollbackFor = Exception.class)
|
@Override
|
public boolean updateBatchById(Card card) {
|
List<Card> list = new ArrayList<>();
|
|
for (int i=0;i<card.getCardnumber().split(",").length;i++){
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", card.getCardnumber().split(",")[i]);
|
Card card1 = cardMapper.selectOne(queryWrapper);
|
card1.setCarddate(card.getCarddate());
|
card1.setUnitprice(card.getUnitprice());
|
card1.setEnddate(card.getEnddate());
|
// Date date = new Date();
|
// SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
card1.setEnterdate(formatter.format(date));
|
// operationLog.setCaozuodate(formatter.format(date));
|
list.add(card1);
|
|
}
|
|
cardMapper.updateBatchById(list);
|
// QueryWrapper queryWrapper = new QueryWrapper();
|
// queryWrapper.eq("cardnumber", card.getCardnumber());
|
// Date date = new Date();
|
// SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
// card.setEnterdate(formatter.format(date));
|
return true;
|
}
|
|
public int UpdateCardNum(Card card) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", card.getCardnumber());
|
return ((CardMapper)this.baseMapper).update(card, queryWrapper);
|
}
|
|
public Card findnum(String num) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", num);
|
return (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper);
|
}
|
|
public Card ifCard(Card card) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", card.getCardnumber());
|
queryWrapper.eq("none", 0);
|
return (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper);
|
}
|
|
public List<Card> findDaoQi(String company) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("company", company);
|
queryWrapper.lt("syll", "150");
|
queryWrapper.eq("status", "已激活");
|
return ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
}
|
|
public List<Card> findDaoQi1(String company) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("company", company);
|
queryWrapper.eq("status", "已到期");
|
return ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
}
|
|
public int addCard(Card card) {
|
Date date = new Date();
|
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
card.setEnterdate(formatter.format(date));
|
// Card card1 = (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper);
|
// Card card = new Card();
|
// card.setNone("1");
|
OperationLog operationLog = new OperationLog();
|
operationLog.setCaozuotype("新增");
|
operationLog.setCaozuocontent("新增卡号："+card.getCardnumber());
|
operationLog.setCaozuoname(card.getCaozuoname());
|
operationLogService.addOperationLog(operationLog);
|
return ((CardMapper)this.baseMapper).insert(card);
|
}
|
|
public PageInfo<Card> tableSearch(Card card, int page, int limit) throws Exception {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
PageHelper.startPage(page, limit);
|
PageInfo<Card> info = null;
|
if (card.getCardnumber() != "" && card.getCompany() != "") {
|
if (card.getCompany().equals("华星智控")){
|
info = new PageInfo(this.cardMapper.FindSearch1(card.getCardnumber()));
|
}else if (card.getCompany().equals("访客")){
|
info = new PageInfo(this.cardMapper.FindSearch1(card.getCardnumber()));
|
|
}else{
|
info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany()));
|
|
}
|
} else if (card.getCompany() != "") {
|
if (card.getCompany().equals("华星智控")) {
|
info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany()));
|
} else if (card.getCompany().equals("访客")){
|
info = new PageInfo(this.cardMapper.FindSearch1(card.getCardnumber()));
|
|
}else {
|
queryWrapper.like("company", card.getCompany());
|
queryWrapper.eq("none", 0);
|
info = new PageInfo(((CardMapper)this.baseMapper).selectList(queryWrapper));
|
}
|
} else {
|
queryWrapper.eq("company", card.getCompany());
|
queryWrapper.eq("none", 0);
|
info = new PageInfo(((CardMapper)this.baseMapper).selectList(queryWrapper));
|
}
|
System.out.println(info);
|
return info;
|
}
|
|
public List chaWu() {
|
List list = new ArrayList();
|
list.add(this.cardMapper.findCardNum1());
|
list.add(this.cardMapper.findCardNum2());
|
list.add(this.cardMapper.findCardNum3());
|
list.add(this.cardMapper.findCardNum4());
|
list.add(this.cardMapper.findCardNum5());
|
return list;
|
}
|
|
public List chaWu1(String qb) {
|
List list = new ArrayList();
|
list.add(this.cardMapper.findCardNum1z(qb));
|
list.add(this.cardMapper.findCardNum2z(qb));
|
list.add(this.cardMapper.findCardNum3z(qb));
|
list.add(this.cardMapper.findCardNum4z(qb));
|
list.add(this.cardMapper.findCardNum5z(qb));
|
return list;
|
}
|
|
public void proxyCardList(String card) {
|
Card card1 = new Card();
|
card1.setCardnumber(card);
|
((CardMapper)this.baseMapper).insert(card1);
|
}
|
|
public void proxyCardcompanyUp(String card, String name) throws Exception {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("iccid", card);
|
Card card1 = new Card();
|
card1.setCardnumber(card);
|
card1.setCompany(name);
|
((CardMapper)this.baseMapper).update(card1, queryWrapper);
|
}
|
|
public List<Card> proxyfindCard() {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
List<Card> cardList = ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
return ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
}
|
|
public int proxyupXinXi(Card card) {
|
QueryWrapper queryWrapper = new QueryWrapper();
|
queryWrapper.eq("cardnumber", card.getCardnumber());
|
List<Card> cardList = ((CardMapper)this.baseMapper).selectList(queryWrapper);
|
return ((CardMapper)this.baseMapper).update(card, queryWrapper);
|
}
|
}
|
