| | |
| | | import com.flow.service.OperationLogService; |
| | | import com.github.pagehelper.PageHelper; |
| | | import com.github.pagehelper.PageInfo; |
| | | |
| | | import java.text.ParseException; |
| | | import java.text.SimpleDateFormat; |
| | | import java.util.ArrayList; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | | import org.springframework.beans.factory.annotation.Autowired; |
| | | import org.springframework.stereotype.Service; |
| | | import org.springframework.transaction.annotation.Transactional; |
| | |
| | | return cardList; |
| | | } |
| | | |
| | | public PageInfo<Card> FindCarda(Integer page, Integer limit) { |
| | | public PageInfo<Card> FindCarda(Integer page, Integer limit,String daoqi,String entry) throws ParseException { |
| | | if (entry!=null && entry!=""){ |
| | | if (Objects.equals(daoqi, "yes")){ |
| | | PageHelper.startPage(page, limit); |
| | | List<Card> cardList = this.cardMapper.findAllUsers(); |
| | | List<Card> cardList = this.cardMapper.findAllUsersdaoqi(entry); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | }else{ |
| | | PageHelper.startPage(page, limit); |
| | | List<Card> cardList = this.cardMapper.findAllUsers(entry); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | } |
| | | |
| | | public PageInfo<Card> FindCardaZi(Card card, Integer page, Integer limit) { |
| | | }else{ |
| | | if (Objects.equals(daoqi, "yes")){ |
| | | 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); |
| | | List<Card> cardList = this.cardMapper.findAllUsersdaoqi1(); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | }else{ |
| | | PageHelper.startPage(page, limit); |
| | | List<Card> cardList = this.cardMapper.findAllUsers2(); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | |
| | | public PageInfo<Card> FindCardaZi(Card card, Integer page, Integer limit,String daoqi) { |
| | | if (Objects.equals(daoqi, "yes")){ |
| | | PageHelper.startPage(page, limit); |
| | | List<Card> cardList = this.cardMapper.findAllUsersdaoqizi(card.getCompany()); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | }else{ |
| | | PageHelper.startPage(page, limit); |
| | | List<Card> cardList = this.cardMapper.findAllUsersZi(card.getCompany()); |
| | | PageInfo<Card> info = new PageInfo(cardList); |
| | | return info; |
| | | } |
| | | } |
| | | |
| | | public int DeleteCard(String num,String caozuoname) { |
| | |
| | | |
| | | for (int i=0;i<card.getCardnumber().split(",").length;i++){ |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | System.out.println(card.getCardnumber().split(",")[i]); |
| | | queryWrapper.eq("cardnumber", card.getCardnumber().split(",")[i]); |
| | | queryWrapper.eq("none","0"); |
| | | Card card1 = cardMapper.selectOne(queryWrapper); |
| | | card1.setCarddate(card.getCarddate()); |
| | | card1.setUnitprice(card.getUnitprice()); |
| | |
| | | |
| | | public Card findnum(String num) { |
| | | QueryWrapper queryWrapper = new QueryWrapper(); |
| | | |
| | | queryWrapper.eq("cardnumber", num); |
| | | return (Card)((CardMapper)this.baseMapper).selectOne(queryWrapper); |
| | | } |
| | |
| | | // 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); |
| | | } |
| | | |
| | |
| | | info = new PageInfo(this.cardMapper.FindSearch1(card.getCardnumber())); |
| | | |
| | | }else{ |
| | | info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany())); |
| | | info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany().replaceAll("\\s", ""))); |
| | | |
| | | } |
| | | } else if (card.getCompany() != "") { |
| | | if (card.getCompany().equals("华星智控")) { |
| | | info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany())); |
| | | info = new PageInfo(this.cardMapper.FindSearch(card.getCardnumber(), card.getCompany().replaceAll("\\s", ""))); |
| | | } else if (card.getCompany().equals("访客")){ |
| | | info = new PageInfo(this.cardMapper.FindSearch1(card.getCardnumber())); |
| | | |
| | | }else { |
| | | queryWrapper.like("company", card.getCompany()); |
| | | queryWrapper.like("company", card.getCompany().replaceAll("\\s", "")); |
| | | queryWrapper.eq("none", 0); |
| | | info = new PageInfo(((CardMapper)this.baseMapper).selectList(queryWrapper)); |
| | | } |
| | | } else { |
| | | queryWrapper.eq("company", card.getCompany()); |
| | | |
| | | queryWrapper.eq("company", card.getCompany().replaceAll("\\s", "")); |
| | | queryWrapper.eq("none", 0); |
| | | info = new PageInfo(((CardMapper)this.baseMapper).selectList(queryWrapper)); |
| | | } |