package com.zy.asrs.controller; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.plugins.Page; import com.core.annotations.ManagerAuth; import com.core.common.Cools; import com.core.common.DateUtils; import com.core.common.R; import com.zy.asrs.entity.AllLocDetl; import com.zy.asrs.service.AllLocDetlService; import com.zy.common.web.BaseController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import java.util.Map; @RestController @RequestMapping("/all") public class AllLocDetlController extends BaseController { @Autowired private AllLocDetlService allLocDetlService; @RequestMapping(value = "/locDetl/list/auth") @ManagerAuth public R list(@RequestParam(defaultValue = "1")Integer curr, @RequestParam(defaultValue = "10")Integer limit, @RequestParam(required = false)String orderByField, @RequestParam(required = false)String orderByType, @RequestParam(required = false)String condition, @RequestParam Map param, @RequestParam(required = false)Boolean unreason){ if (!Cools.isEmpty(unreason) && unreason) { return R.ok(allLocDetlService.selectPage(new Page<>(curr, limit), new EntityWrapper() .where(" DATALENGTH( batch ) != 11 or\n" + " batch LIKE '%[a-z]%'"))); } param.remove("unreason"); String row = ""; EntityWrapper wrapper = new EntityWrapper<>(); if (param.get("row") != null) { String chooseRow = (String) param.get("row"); if (chooseRow.length() == 1) { row = "0" + chooseRow; param.remove("row"); }else { row = chooseRow; param.remove("row"); } } excludeTrash(param); convert(param, wrapper); allLike(AllLocDetl.class, param.keySet(), wrapper, condition); if (!Cools.isEmpty(orderByField)){wrapper.orderBy(humpToLine(orderByField), "asc".equals(orderByType));} if (!row.equals("")){ wrapper.and() .where("loc_no like '" +row +"%'"); } return R.ok(allLocDetlService.selectPage(new Page<>(curr, limit), wrapper)); } private void convert(Map map, EntityWrapper wrapper){ for (Map.Entry entry : map.entrySet()){ String val = String.valueOf(entry.getValue()); if (val.contains(RANGE_TIME_LINK)){ String[] dates = val.split(RANGE_TIME_LINK); wrapper.ge(entry.getKey(), DateUtils.convert(dates[0])); wrapper.le(entry.getKey(), DateUtils.convert(dates[1])); } else { if (entry.getKey().equals("locNo")) { wrapper.eq("loc_no", String.valueOf(entry.getValue())); } else { wrapper.like(entry.getKey(), String.valueOf(entry.getValue())); } } } } }