| | |
| | | queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString()); |
| | | } |
| | | queryWrapper.lambda().orderByDesc(GdWorkOrderFlowEntity::getCreateTime); |
| | | |
| | | // 调用服务层方法获取分层结构的流程数据 |
| | | List<WorkOrderStageVO> stages = gdWorkOrderFlowService.getHierarchicalFlow(queryWrapper); |
| | | |
| | |
| | | @ApiOperationSupport(order = 2) |
| | | @ApiOperation(value = "巡查流程列表", notes = "传入gdWorkOrderFlow") |
| | | public R<List<GdWorkOrderFlowVO>> patrolList(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow) { |
| | | List<GdWorkOrderFlowEntity> list = gdWorkOrderFlowService.list(Condition.getQueryWrapper(gdWorkOrderFlow, GdWorkOrderFlowEntity.class)); |
| | | // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误 |
| | | QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED); |
| | | |
| | | // 处理 workOrderId (Long 类型,使用 EQ 而非 LIKE) |
| | | Object workOrderId = gdWorkOrderFlow.get("workOrderId"); |
| | | if (workOrderId != null && !"".equals(workOrderId.toString())) { |
| | | queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getWorkOrderId, Long.parseLong(workOrderId.toString())); |
| | | } |
| | | |
| | | // 处理 type 字段 (String 类型,可以使用 LIKE) |
| | | Object type = gdWorkOrderFlow.get("type"); |
| | | if (type != null && !"".equals(type.toString())) { |
| | | queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString()); |
| | | } |
| | | queryWrapper.lambda().orderByAsc(GdWorkOrderFlowEntity::getCreateTime); |
| | | List<GdWorkOrderFlowEntity> list = gdWorkOrderFlowService.list(queryWrapper); |
| | | return R.data(GdWorkOrderFlowWrapper.build().entityVOList(list)); |
| | | } |
| | | |
| | |
| | | @ApiOperation(value = "导出数据", notes = "传入gdWorkOrderFlow") |
| | | @ApiIgnore |
| | | public void exportGdWorkOrderFlow(@ApiIgnore @RequestParam Map<String, Object> gdWorkOrderFlow, BladeUser bladeUser, HttpServletResponse response) { |
| | | QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = Condition.getQueryWrapper(gdWorkOrderFlow, GdWorkOrderFlowEntity.class); |
| | | //if (!AuthUtil.isAdministrator()) { |
| | | // queryWrapper.lambda().eq(GdWorkOrderFlow::getTenantId, bladeUser.getTenantId()); |
| | | //} |
| | | // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误 |
| | | QueryWrapper<GdWorkOrderFlowEntity> queryWrapper = new QueryWrapper<>(); |
| | | queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getIsDeleted, BladeConstant.DB_NOT_DELETED); |
| | | |
| | | // 处理 workOrderId (Long 类型,使用 EQ 而非 LIKE) |
| | | Object workOrderId = gdWorkOrderFlow.get("workOrderId"); |
| | | if (workOrderId != null && !"".equals(workOrderId.toString())) { |
| | | queryWrapper.lambda().eq(GdWorkOrderFlowEntity::getWorkOrderId, Long.parseLong(workOrderId.toString())); |
| | | } |
| | | |
| | | // 处理 type 字段 (String 类型,可以使用 LIKE) |
| | | Object type = gdWorkOrderFlow.get("type"); |
| | | if (type != null && !"".equals(type.toString())) { |
| | | queryWrapper.lambda().like(GdWorkOrderFlowEntity::getType, type.toString()); |
| | | } |
| | | |
| | | List<GdWorkOrderFlowExcel> list = gdWorkOrderFlowService.exportGdWorkOrderFlow(queryWrapper); |
| | | ExcelUtil.export(response, "流程记录表数据" + DateUtil.time(), "流程记录表数据表", list, GdWorkOrderFlowExcel.class); |
| | | } |