package com.boying.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.toolkit.StringUtils; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.boying.common.R; import com.boying.entity.ViolationType; import com.boying.entity.WhiteList; import com.boying.service.ParkService; import com.boying.service.WhiteListService; import lombok.RequiredArgsConstructor; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; @RestController @RequestMapping("ffzf/whiteList") @RequiredArgsConstructor public class WhiteListController{ private final WhiteListService whiteListService; private final ParkService parkService; @PostMapping("/findPage") //@Operation(summary = "分页查询" , description = "分页查询" ) public Object findPage(Page page, String carNo) { QueryWrapper wrapper = new QueryWrapper<>(); wrapper.lambda() .like(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo) .orderByDesc(WhiteList::getId); Page page1 = whiteListService.page(page, wrapper); for (WhiteList record : page1.getRecords()) { if(record.getParkId() != null){ record.setName(parkService.getById(record.getParkId()).getName()); } } return R.ok(page1); } @PostMapping("/findPageNew") public Object findPageNew(Page page, String carNo,Integer type,String date) throws ParseException { SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); if(StringUtils.isNotBlank(date)){ System.out.println(date); Date parse = sdf.parse(date); date = sdf.format(parse); } QueryWrapper wrapper = new QueryWrapper<>(); wrapper.lambda() .orderByDesc(WhiteList::getId) .like(StringUtils.isNotBlank(carNo),WhiteList::getCarNo,carNo) .eq(type!=null,WhiteList::getType,type) .le(StringUtils.isNotBlank(date),WhiteList::getEndTime,date); Page page1 = whiteListService.page(page, wrapper); for (WhiteList record : page1.getRecords()) { if(StringUtils.isNotBlank(record.getParkIds())){ String s = ""; String parkIds = record.getParkIds(); String[] split = parkIds.split(","); for (int i = 0; i < split.length; i++) { int id = Integer.parseInt(split[i]); if(i != split.length -1){ s += parkService.getById(id).getName()+","; }else { s += parkService.getById(id).getName(); } } record.setName(s); } } return R.ok(page1); } @PostMapping("/save") public Object save(WhiteList whiteList) { whiteListService.saveOrUpdate(whiteList); return R.ok("保存成功"); } @PostMapping("/delete") public Object delete(Long id) { whiteListService.removeById(id); return R.ok("删除成功"); } }