| | |
| | | import com.alibaba.fastjson.JSONArray; |
| | | import com.alibaba.fastjson.JSONObject; |
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.zy.asrs.common.wms.entity.WrkMastLog; |
| | | import com.zy.asrs.common.wms.service.WrkMastLogService; |
| | |
| | | @RequestParam(required = false) String condition, |
| | | @RequestParam(required = false) String timeRange, |
| | | @RequestParam Map<String, Object> param) { |
| | | LambdaQueryWrapper<WrkMastLog> wrapper = new LambdaQueryWrapper<>(); |
| | | QueryWrapper<WrkMastLog> wrapper = new QueryWrapper<>(); |
| | | // wrapper.eq(WrkMastLog::getHostId, getHostId()); |
| | | if (!Cools.isEmpty(condition)) { |
| | | wrapper.like(WrkMastLog::getWrkNo, condition); |
| | | } |
| | | if (!Cools.isEmpty(timeRange)) { |
| | | String[] range = timeRange.split(RANGE_TIME_LINK); |
| | | wrapper.ge(WrkMastLog::getAppeTime, DateUtils.convert(range[0])); |
| | | wrapper.le(WrkMastLog::getAppeTime, DateUtils.convert(range[1])); |
| | | wrapper.ge("appe_time", DateUtils.convert(range[0])); |
| | | wrapper.le("appe_time", DateUtils.convert(range[1])); |
| | | } |
| | | if (!Cools.isEmpty(param.get("wrkNo"))) { |
| | | wrapper.eq(WrkMastLog::getWrkNo, param.get("wrkNo")); |
| | | if (!Cools.isEmpty(param.get("barcode"))) { |
| | | wrapper.eq("barcode", param.get("barcode")); |
| | | } |
| | | if (!Cools.isEmpty(param.get("wrkSts"))) { |
| | | wrapper.eq(WrkMastLog::getWrkSts, param.get("wrkSts")); |
| | | if (!Cools.isEmpty(param.get("wrk_no"))) { |
| | | wrapper.eq("wrk_no", param.get("wrk_no")); |
| | | } |
| | | if (!Cools.isEmpty(param.get("ioType"))) { |
| | | wrapper.eq(WrkMastLog::getIoType, param.get("ioType")); |
| | | if (!Cools.isEmpty(param.get("wrk_sts"))) { |
| | | wrapper.eq("wrk_sts", param.get("wrk_sts")); |
| | | } |
| | | if (!Cools.isEmpty(param.get("manuType"))) { |
| | | wrapper.like(WrkMastLog::getManuType, param.get("manuType")); |
| | | if (!Cools.isEmpty(param.get("io_type"))) { |
| | | wrapper.eq("iotype", param.get("io_type")); |
| | | } |
| | | wrapper.orderByDesc(WrkMastLog::getId); |
| | | if (!Cools.isEmpty(param.get("manu_type"))) { |
| | | wrapper.like("manu_type", param.get("manu_type")); |
| | | } |
| | | allLike(WrkMastLog.class, param.keySet(), wrapper, condition); |
| | | wrapper.orderByDesc("id"); |
| | | return R.ok(wrkMastLogService.page(new Page<>(curr, limit), wrapper)); |
| | | } |
| | | |