package org.sxkj.gd.workorder.controller; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.github.xiaoymin.knife4j.annotations.ApiOperationSupport; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.AllArgsConstructor; import org.springblade.core.boot.ctrl.BladeController; import org.springblade.core.excel.util.ExcelUtil; import org.springblade.core.mp.support.Condition; import org.springblade.core.secure.BladeUser; import org.springblade.core.tool.api.R; import org.springblade.core.tool.constant.BladeConstant; import org.springblade.core.tool.utils.DateUtil; import org.springframework.web.bind.annotation.*; import org.sxkj.gd.workorder.entity.GdWorkOrderFlowEntity; import org.sxkj.gd.workorder.excel.GdWorkOrderFlowExcel; import org.sxkj.gd.workorder.service.IGdWorkOrderFlowService; import org.sxkj.gd.workorder.vo.GdWorkOrderFlowVO; import org.sxkj.gd.workorder.vo.WorkOrderStageVO; import org.sxkj.gd.workorder.wrapper.GdWorkOrderFlowWrapper; import springfox.documentation.annotations.ApiIgnore; import javax.servlet.http.HttpServletResponse; import javax.validation.Valid; import java.util.List; import java.util.Map; /** * 流程记录表 控制器 * * @author lw * @since 2026-01-14 */ @RestController @AllArgsConstructor @RequestMapping("workOrder/gdWorkOrderFlow") @Api(value = "流程记录表", tags = "流程记录表接口") public class GdWorkOrderFlowController extends BladeController { private final IGdWorkOrderFlowService gdWorkOrderFlowService; /** * 流程记录表 详情 */ @GetMapping("/detail") @ApiOperationSupport(order = 1) @ApiOperation(value = "详情", notes = "传入gdWorkOrderFlow") public R detail(GdWorkOrderFlowEntity gdWorkOrderFlow) { GdWorkOrderFlowEntity detail = gdWorkOrderFlowService.getOne(Condition.getQueryWrapper(gdWorkOrderFlow)); return R.data(GdWorkOrderFlowWrapper.build().entityVO(detail)); } /** * 流程记录表 列表 * 返回分层结构的流程数据,包含所有状态(已到达和未到达的) * * @param gdWorkOrderFlow 查询参数 * @return 分层结构的流程数据 */ @GetMapping("/list") @ApiOperationSupport(order = 2) @ApiOperation(value = "工单流程列表", notes = "传入gdWorkOrderFlow") public R> list(@ApiIgnore @RequestParam Map gdWorkOrderFlow) { // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误 QueryWrapper 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().orderByDesc(GdWorkOrderFlowEntity::getCreateTime); // 调用服务层方法获取分层结构的流程数据 List stages = gdWorkOrderFlowService.getHierarchicalFlow(queryWrapper); return R.data(stages); } /** * 流程记录表 列表 */ @GetMapping("/patrolList") @ApiOperationSupport(order = 2) @ApiOperation(value = "巡查流程列表", notes = "传入gdWorkOrderFlow") public R> patrolList(@ApiIgnore @RequestParam Map gdWorkOrderFlow) { // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误 QueryWrapper 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 list = gdWorkOrderFlowService.list(queryWrapper); return R.data(GdWorkOrderFlowWrapper.build().entityVOList(list)); } /** * 流程记录表 自定义分页 */ // @GetMapping("/page") // @ApiOperationSupport(order = 3) // @ApiOperation(value = "分页", notes = "传入gdWorkOrderFlow") // public R> page(GdWorkOrderFlowVO gdWorkOrderFlow, Query query) { // IPage pages = gdWorkOrderFlowService.selectGdWorkOrderFlowPage(Condition.getPage(query), gdWorkOrderFlow); // return R.data(pages); // } /** * 流程记录表 新增 */ @PostMapping("/save") @ApiOperationSupport(order = 4) @ApiOperation(value = "新增", notes = "传入gdWorkOrderFlow") public R save(@Valid @RequestBody GdWorkOrderFlowEntity gdWorkOrderFlow) { return R.status(gdWorkOrderFlowService.save(gdWorkOrderFlow)); } /** * 流程记录表 修改 */ // @PostMapping("/update") // @ApiOperationSupport(order = 5) // @ApiOperation(value = "修改", notes = "传入gdWorkOrderFlow") // public R update(@Valid @RequestBody GdWorkOrderFlowEntity gdWorkOrderFlow) { // return R.status(gdWorkOrderFlowService.updateById(gdWorkOrderFlow)); // } /** * 流程记录表 新增或修改 */ // @PostMapping("/submit") // @ApiOperationSupport(order = 6) // @ApiOperation(value = "新增或修改", notes = "传入gdWorkOrderFlow") // public R submit(@Valid @RequestBody GdWorkOrderFlowEntity gdWorkOrderFlow) { // return R.status(gdWorkOrderFlowService.saveOrUpdate(gdWorkOrderFlow)); // } /** * 流程记录表 删除 */ // @PostMapping("/remove") // @ApiOperationSupport(order = 7) // @ApiOperation(value = "逻辑删除", notes = "传入ids") // public R remove(@ApiParam(value = "主键集合", required = true) @RequestParam String ids) { // return R.status(gdWorkOrderFlowService.deleteLogic(Func.toLongList(ids))); // } /** * 导出数据 */ @GetMapping("/export-gdWorkOrderFlow") @ApiOperationSupport(order = 9) @ApiOperation(value = "导出数据", notes = "传入gdWorkOrderFlow") @ApiIgnore public void exportGdWorkOrderFlow(@ApiIgnore @RequestParam Map gdWorkOrderFlow, BladeUser bladeUser, HttpServletResponse response) { // 手动构建查询条件,避免 Long 类型字段使用 LIKE 导致 Kingbase8 类型错误 QueryWrapper 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 list = gdWorkOrderFlowService.exportGdWorkOrderFlow(queryWrapper); ExcelUtil.export(response, "流程记录表数据" + DateUtil.time(), "流程记录表数据表", list, GdWorkOrderFlowExcel.class); } }