基于springboot+mybatis plus+jwt的期刊管理系统后端源码+sql数据库.zip

package top.ahcdc.periodical.service.impl; import com.baomidou.mybatisplus.core.assist.ISqlRunner; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import top.ahcdc.periodical.common.lang.CommonResponse; import top.ahcdc.periodical.entity.BorrowTabelEntity; import top.ahcdc.periodical.entity.PeriodicalContentEntity; import top.ahcdc.periodical.entity.PeriodicalRegisterEntity; import top.ahcdc.periodical.entity.UserEntity; import top.ahcdc.periodical.mapper.BorrowTableMapper; import top.ahcdc.periodical.mapper.PeriodicalContentMapper; import top.ahcdc.periodical.mapper.PeriodicalRegisterMapper; import top.ahcdc.periodical.mapper.UserMapper; import top.ahcdc.periodical.service.BorrowService; import top.ahcdc.periodical.utils.CalendarString; import top.ahcdc.periodical.vo.BorrowPageVO; import top.ahcdc.periodical.vo.integration.PeriodicalNotBorrowVO; import top.ahcdc.periodical.vo.integration.UserInfoVO; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; @Service public class BorrowServiceImpl implements BorrowService { @Autowired private BorrowTableMapper borrowTableMapper; @Autowired private PeriodicalRegisterMapper periodicalRegisterMapper; @Autowired private UserMapper userMapper; @Autowired private PeriodicalContentMapper periodicalContentMapper; private CalendarString calendarString=new CalendarString(); @Override public BorrowPageVO getBorrowPageInfo(String userNum) { List<PeriodicalNotBorrowVO> ret = getNotBorrow(); QueryWrapper<UserEntity> userInfoQuery = new QueryWrapper<>(); userInfoQuery.eq("user_num", userNum); UserEntity user = userMapper.selectOne(userInfoQuery); UserInfoVO userInfo = new UserInfoVO( user.getUserNum(), user.getUserProfiles(), user.getBalance(), user.getUserEmail() ); return new BorrowPageVO(userInfo, ret); } @Override public List<PeriodicalNotBorrowVO> BorrowSearch(int type,String search_content){ List<PeriodicalContentEntity> periodicalContentEntities=new LinkedList<>();//查询出来的期刊内容记录 List<PeriodicalNotBorrowVO> ret=getNotBorrow();//未借出的期刊信息 List<PeriodicalNotBorrowVO> searchRes=new LinkedList<>();//返回的期刊查询记录 QueryWrapper<PeriodicalContentEntity> periodicalContentQuery=new QueryWrapper<>(); if(type==1){ periodicalContentQuery.eq("paper_keyword_1",search_content).or().eq("paper_keyword_2",search_content) .or().eq("paper_keyword_3",search_content).or().eq("paper_keyword_4",search_content) .or().eq("paper_keyword_5",search_content); periodicalContentEntities=periodicalContentMapper.selectList(periodicalContentQuery); for(PeriodicalNotBorrowVO periodicalNotBorrowVO:ret){ for(PeriodicalContentEntity periodicalContentEntity:periodicalContentEntities){ if(periodicalNotBorrowVO.getPeriodicalName().equals(periodicalContentEntity.getPeriodicalName())){ searchRes.add(periodicalNotBorrowVO); break; } } } } else if(type==2){ periodicalContentQuery.like("paper_author",search_content); periodicalContentEntities=periodicalContentMapper.selectList(periodicalContentQuery); for(PeriodicalNotBorrowVO periodicalNotBorrowVO:ret){ for(PeriodicalContentEntity periodicalContentEntity:periodicalContentEntities){ if(periodicalNotBorrowVO.getPeriodicalName().equals(periodicalContentEntity.getPeriodicalName())&& periodicalNotBorrowVO.getStage()==periodicalContentEntity.getStage()&&periodicalNotBorrowVO.getVolume()==periodicalContentEntity.getVolume()&& periodicalNotBorrowVO.getYear()==periodicalContentEntity.getYear()){ searchRes.add(periodicalNotBorrowVO); break; } } } } return searchRes; } @Override public String getCover(String name, int year, int volume, int stage) { QueryWrapper<PeriodicalRegisterEntity> queryWrapper = new QueryWrapper<>(); queryWrapper.eq("periodical_name", name) .eq("year", year) .eq("volume", volume) .eq("stage", stage); return periodicalRegisterMapper.selectOne(queryWrapper).getPeriodicalCover(); } @Override public List<PeriodicalNotBorrowVO> getNotBorrow(){ List<PeriodicalRegisterEntity> periodicalRegisterEntityList = periodicalRegisterMapper.selectList(null); List<BorrowTabelEntity> borrowTabelEntityList = borrowTableMapper.selectList(null); List<PeriodicalNotBorrowVO> all = new LinkedList<>(); List<PeriodicalNotBorrowVO> borrowed = new LinkedList<>(); for(PeriodicalRegisterEntity periodicalRegisterEntity:periodicalRegisterEntityList){ all.add(new PeriodicalNotBorrowVO( periodicalRegisterEntity.getPeriodicalName(), periodicalRegisterEntity.getPeriodicalCover(), periodicalRegisterEntity.getVolume(), periodicalRegisterEntity.getYear(), periodicalRegisterEntity.getStage(), periodicalRegisterEntity.getDeposit() )); } for(BorrowTabelEntity borrowTabelEntity:borrowTabelEntityList){ if(!(borrowTabelEntity.getReturnDate()==null||borrowTabelEntity.getReturnDate().isBlank())) continue; borrowed.add(new PeriodicalNotBorrowVO( borrowTabelEntity.getPeriodicalName(), getCover(borrowTabelEntity.getPeriodicalName(), borrowTabelEntity.getYear(), borrowTabelEntity.getVolume(), borrowTabelEntity.getStage()), borrowTabelEntity.getVolume(), borrowTabelEntity.getYear(), borrowTabelEntity.getStage(), 0 )); } List<PeriodicalNotBorrowVO> ret = new LinkedList<>(); for(PeriodicalNotBorrowVO a:all){ int flag = 0; for(PeriodicalNotBorrowVO b:borrowed){ if(a.getStage()==b.getStage() && a.getPeriodicalName().equals(b.getPeriodicalName()) && a.getVolume() == b.getVolume() && a.getYear() == b.getYear()){ flag = 1; break; } } if(flag == 0){ ret.add(a); } } return ret; } public List<PeriodicalContentEntity> detailDisp(String pName, int year, int volume, int stage){ QueryWrapper<PeriodicalContentEntity> detailQuerywrapper=new QueryWrapper<>(); detailQuerywrapper.eq("periodical_name",pName) .eq("volume",volume) .eq("year",year) .eq("stage",stage); List<PeriodicalContentEntity> periodicalContentEntities= periodicalContentMapper.selectList(detailQuerywrapper); return periodicalContentEntities; } @Override public void borrowBooks(String pName, String userNum, int year, int stage, int volume) { UserEntity userEntityForUpdate = new UserEntity(); QueryWrapper<PeriodicalRegisterEntity> periodicalRegisterQueryWrapper = new QueryWrapper<>(); QueryWrapper<UserEntity> userQueryWrapper = new QueryWrapper<>(); periodicalRegisterQueryWrapper.eq("periodical_name", pName) .eq("year