package org.jeecg.modules.system.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import lombok.extern.slf4j.Slf4j; import org.apache.shiro.SecurityUtils; import org.jeecg.common.api.vo.Result; import org.jeecg.common.aspect.annotation.AutoLog; import org.jeecg.common.constant.CommonConstant; import org.jeecg.common.system.base.controller.JeecgController; import org.jeecg.common.system.query.QueryGenerator; import org.jeecg.common.system.vo.LoginUser; import org.jeecg.common.util.oConvertUtils; import org.jeecg.modules.system.entity.MdcProduction; import org.jeecg.modules.system.model.MdcProductionTreeModel; import org.jeecg.modules.system.model.ProductionIdModel; import org.jeecg.modules.system.service.IMdcProductionService; import org.springframework.cache.annotation.CacheEvict; import org.springframework.web.bind.annotation.*; import org.springframework.web.servlet.ModelAndView; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.Arrays; import java.util.List; import java.util.stream.Collectors; /** * @Description: 产线表 * @Author: liuS * @Date: 2023-03-23 * @Version: V1.0 */ @Slf4j @Api(tags = "产线表") @RestController @RequestMapping("/mdc/mdcProduction") public class MdcProductionController extends JeecgController { @Resource private IMdcProductionService mdcProductionService; /** * 分页列表查询 * * @param mdcProduction * @param pageNo * @param pageSize * @param req * @return */ @AutoLog(value = "产线表-分页列表查询") @ApiOperation(value = "产线表-分页列表查询", notes = "产线表-分页列表查询") @GetMapping(value = "/list") public Result queryPageList(MdcProduction mdcProduction, @RequestParam(name = "pageNo", defaultValue = "1") Integer pageNo, @RequestParam(name = "pageSize", defaultValue = "10") Integer pageSize, HttpServletRequest req) { QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(mdcProduction, req.getParameterMap()); Page page = new Page(pageNo, pageSize); IPage pageList = mdcProductionService.page(page, queryWrapper); return Result.OK(pageList); } @AutoLog(value = "产线表-树形列表") @ApiOperation(value = "产线表-树形列表", notes = "产线表-树形列表") @GetMapping(value = "/queryTreeList") public Result> queryTreeList(@RequestParam(name = "ids", required = false) String ids) { Result> result = new Result<>(); try { if (oConvertUtils.isNotEmpty(ids)) { List productionList = mdcProductionService.queryTreeList(ids); result.setResult(productionList); } else { List list = mdcProductionService.queryTreeList(); result.setResult(list); } result.setSuccess(true); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } @AutoLog(value = "产线表-树形列表(MDC)") @ApiOperation(value = "产线表-树形列表(MDC)", notes = "产线表-树形列表(MDC)") @GetMapping(value = "/queryTreeListByMdc") public Result> queryTreeListByMdc(@RequestParam(name = "ids", required = false) String ids) { Result> result = new Result<>(); try { if (oConvertUtils.isNotEmpty(ids)) { List productionList = mdcProductionService.queryTreeListByMdc(ids); result.setResult(productionList); } else { List list = mdcProductionService.queryTreeListByMdc(); result.setResult(list); } result.setSuccess(true); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } @AutoLog(value = "产线表-树形列表(添加系统配置)") @ApiOperation(value = "产线表-树形列表(添加系统配置)", notes = "产线表-树形列表(添加系统配置)") @GetMapping(value = "/queryTreeListByConfig") public Result> queryTreeListByConfig(@RequestParam(name = "ids", required = false) String ids) { Result> result = new Result<>(); try { if (oConvertUtils.isNotEmpty(ids)) { List productionList = mdcProductionService.queryTreeList(ids); result.setResult(productionList); } else { List list = mdcProductionService.queryTreeListByConfig(); result.setResult(list); } result.setSuccess(true); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } @AutoLog(value = "产线表-根据用户id获取产线下拉树选项") @ApiOperation(value = "产线表-根据用户id获取产线下拉树选项", notes = "产线表-根据用户id获取产线下拉树选项") @GetMapping(value = "/loadProductionTreeOptions") public Result> loadProductionTreeOptions() { Result> result = new Result<>(); LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal(); String userId = user.getId(); try { List list = mdcProductionService.loadProductionTreeOptions(userId); result.setSuccess(true); result.setResult(list); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } @AutoLog(value = "产线表-id集合") @ApiOperation(value = "产线表-id集合", notes = "产线表-id集合") @GetMapping(value = "/queryTreeIdList") public Result> queryTreeIdList() { Result> result = new Result<>(); try { List productionList = mdcProductionService.list(new LambdaQueryWrapper().eq(MdcProduction::getDelFlag, CommonConstant.DEL_FLAG_0).orderByAsc(MdcProduction::getProductionOrder)); List ids = productionList.stream().map(MdcProduction::getId).collect(Collectors.toList()); result.setSuccess(true); result.setResult(ids); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } /** * 添加 * * @param mdcProduction * @return */ @AutoLog(value = "产线表-添加") @ApiOperation(value = "产线表-添加", notes = "产线表-添加") @PostMapping(value = "/add") @CacheEvict(value = {"mdc:cache:production:alldata", "mdc:cache:production:allids"}, allEntries = true) public Result add(@RequestBody MdcProduction mdcProduction) { Result result = new Result<>(); try { mdcProductionService.saveProductionData(mdcProduction); result.success("添加成功!"); } catch (Exception e) { log.error(e.getMessage(), e); result.error500("操作失败"); } return result; } /** * 编辑 * * @param mdcProduction * @return */ @AutoLog(value = "产线表-编辑") @ApiOperation(value = "产线表-编辑", notes = "产线表-编辑") @RequestMapping(value = "/edit", method = {RequestMethod.PUT, RequestMethod.POST}) @CacheEvict(value = {"mdc:cache:production:alldata", "mdc:cache:production:allids"}, allEntries = true) public Result edit(@RequestBody MdcProduction mdcProduction) { Result result = new Result<>(); MdcProduction mdcProductionEntity = mdcProductionService.getById(mdcProduction.getId()); if (mdcProductionEntity == null) { result.error500("未找到对应实体"); } else { boolean ok = mdcProductionService.updateProductionDataById(mdcProduction); if (ok) { result.success("修改成功!"); } } return result; } /** * 通过id删除 * * @param id * @return */ @AutoLog(value = "产线表-通过id删除") @ApiOperation(value = "产线表-通过id删除", notes = "产线表-通过id删除") @DeleteMapping(value = "/delete") @CacheEvict(value = {"mdc:cache:production:alldata", "mdc:cache:production:allids"}, allEntries = true) public Result delete(@RequestParam(name = "id", required = true) String id) { Result result = new Result<>(); MdcProduction mdcProduction = mdcProductionService.getById(id); if (mdcProduction == null) { result.error500("未找到对应实体"); } else { boolean ok = mdcProductionService.delete(id); if (ok) { result.success("删除成功!"); } } return result; } /** * 批量删除 * * @param ids * @return */ @AutoLog(value = "产线表-批量删除") @ApiOperation(value = "产线表-批量删除", notes = "产线表-批量删除") @DeleteMapping(value = "/deleteBatch") @CacheEvict(value = {"mdc:cache:production:alldata", "mdc:cache:production:allids"}, allEntries = true) public Result deleteBatch(@RequestParam(name = "ids", required = true) String ids) { Result result = new Result<>(); if (ids == null || "".equals(ids.trim())) { result.error500("参数不识别!"); } else { this.mdcProductionService.deleteBatchWithChildren(Arrays.asList(ids.split(","))); result.success("删除成功!"); } return result; } @AutoLog(value = "产线表-查询树形结构所有产线名称") @ApiOperation(value = "产线表-查询树形结构所有产线名称", notes = "产线表-查询树形结构所有产线名称") @GetMapping(value = "/queryIdTree") public Result> queryIdTree() { Result> result = new Result<>(); try { List list = mdcProductionService.queryProductionIdTreeList(); result.setResult(list); result.setSuccess(true); } catch (Exception e) { log.error(e.getMessage(), e); } return result; } @AutoLog(value = "产线表-根据关键字模糊搜索相关产线") @ApiOperation(value = "产线表-根据关键字模糊搜索相关产线", notes = "产线表-根据关键字模糊搜索相关产线") @GetMapping(value = "/searchBy") public Result> searchBy(@RequestParam(name = "keyWord", required = true) String keyWord) { Result> result = new Result<>(); List treeList = mdcProductionService.searchByKeyWord(keyWord); if (treeList == null || treeList.isEmpty()) { result.setSuccess(false); result.setMessage("未查询匹配数据!"); return result; } result.setResult(treeList); return result; } /** * 通过id查询 * * @param id * @return */ @AutoLog(value = "产线表-通过id查询") @ApiOperation(value = "产线表-通过id查询", notes = "产线表-通过id查询") @GetMapping(value = "/queryById") public Result queryById(@RequestParam(name = "id", required = true) String id) { MdcProduction mdcProduction = mdcProductionService.getById(id); return Result.OK(mdcProduction); } /** * 导出excel * * @param request * @param mdcProduction */ @AutoLog(value = "产线表-导出excel") @ApiOperation(value = "产线表-导出excel", notes = "产线表-导出excel") @RequestMapping(value = "/exportXls") public ModelAndView exportXls(HttpServletRequest request, MdcProduction mdcProduction) { return super.exportXls(request, mdcProduction, MdcProduction.class, "产线表"); } /** * 通过excel导入数据 * * @param request * @param response * @return */ @AutoLog(value = "产线表-通过excel导入数据") @ApiOperation(value = "产线表-通过excel导入数据", notes = "产线表-通过excel导入数据") @PostMapping(value = "/importExcel") @CacheEvict(value = {"mdc:cache:production:alldata", "mdc:cache:production:allids"}, allEntries = true) public Result importExcel(HttpServletRequest request, HttpServletResponse response) { return super.importExcel(request, response, MdcProduction.class); } }