From 094a9290c836827bc1f45fd3549e7cd2ea1e1e45 Mon Sep 17 00:00:00 2001 From: qushaowei <qushaowei@163.com> Date: 星期二, 07 十一月 2023 09:45:36 +0800 Subject: [PATCH] Merge branch 'master' of http://117.34.109.166:18448/r/mdc_430 into develop --- lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/SysFileNameController.java | 251 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 251 insertions(+), 0 deletions(-) diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/SysFileNameController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/SysFileNameController.java new file mode 100644 index 0000000..4923d61 --- /dev/null +++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/SysFileNameController.java @@ -0,0 +1,251 @@ +package org.jeecg.modules.eam.controller; + +import java.math.BigDecimal; +import java.util.Arrays; +import java.util.Date; +import java.util.List; +import java.util.Map; +import java.util.stream.Collectors; +import java.io.IOException; +import java.io.UnsupportedEncodingException; +import java.net.URLDecoder; +import javax.servlet.http.HttpServletRequest; +import javax.servlet.http.HttpServletResponse; + +import com.baomidou.mybatisplus.core.toolkit.StringUtils; +import org.jeecg.common.api.vo.Result; +import org.jeecg.common.system.query.QueryGenerator; +import org.jeecg.common.util.oConvertUtils; +import org.jeecg.modules.eam.entity.MaintenanceCycle; +import org.jeecg.modules.eam.entity.SysFileName; +import org.jeecg.modules.eam.model.DepartVo; +import org.jeecg.modules.eam.service.ISysFileNameService; + +import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; +import lombok.extern.slf4j.Slf4j; + +import org.jeecg.modules.eam.vo.SysFileNameVo; +import org.jeecgframework.poi.excel.ExcelImportUtil; +import org.jeecgframework.poi.excel.def.NormalExcelConstants; +import org.jeecgframework.poi.excel.entity.ExportParams; +import org.jeecgframework.poi.excel.entity.ImportParams; +import org.jeecgframework.poi.excel.view.JeecgEntityExcelView; +import org.jeecg.common.system.base.controller.JeecgController; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.bind.annotation.*; +import org.springframework.web.multipart.MultipartFile; +import org.springframework.web.multipart.MultipartHttpServletRequest; +import org.springframework.web.servlet.ModelAndView; +import com.alibaba.fastjson.JSON; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.jeecg.common.aspect.annotation.AutoLog; + + /** + * @Description: 鏂囦欢鍚嶇О绠$悊 + * @Author: jeecg-boot + * @Date: 2023-11-03 + * @Version: V1.0 + */ +@Api(tags="鏂囦欢鍚嶇О绠$悊") +@RestController +@RequestMapping("/eam/sysFileName") +@Slf4j +public class SysFileNameController extends JeecgController<SysFileName, ISysFileNameService> { + @Autowired + private ISysFileNameService sysFileNameService; + + /** + * 鍒嗛〉鍒楄〃鏌ヨ + * + * @param sysFileName + * @param pageNo + * @param pageSize + * @param req + * @return + */ + //@AutoLog(value = "鏂囦欢鍚嶇О绠$悊-鍒嗛〉鍒楄〃鏌ヨ") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-鍒嗛〉鍒楄〃鏌ヨ", notes="鏂囦欢鍚嶇О绠$悊-鍒嗛〉鍒楄〃鏌ヨ") + @GetMapping(value = "/list") + public Result<IPage<SysFileName>> queryPageList(SysFileName sysFileName, + @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, + @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, + HttpServletRequest req) { + if(StringUtils.isBlank(sysFileName.getVersionStatus())){ + sysFileName.setVersionStatus("2"); + } + QueryWrapper<SysFileName> queryWrapper = QueryGenerator.initQueryWrapper(sysFileName, req.getParameterMap()); + Page<SysFileName> page = new Page<SysFileName>(pageNo, pageSize); + IPage<SysFileName> pageList = sysFileNameService.page(page, queryWrapper); + return Result.OK(pageList); + } + + /** + * 娣诲姞 + * + * @param sysFileName + * @return + */ + @AutoLog(value = "鏂囦欢鍚嶇О绠$悊-娣诲姞") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-娣诲姞", notes="鏂囦欢鍚嶇О绠$悊-娣诲姞") + //@RequiresPermissions("org.jeecg.modules.mdc:sys_file_name:add") + @PostMapping(value = "/add") + public Result<String> add(@RequestBody SysFileName sysFileName) { + sysFileNameService.save(sysFileName); + return Result.OK("娣诲姞鎴愬姛锛�"); + } + + /** + * 缂栬緫 + * + * @param sysFileName + * @return + */ + @AutoLog(value = "鏂囦欢鍚嶇О绠$悊-缂栬緫") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-缂栬緫", notes="鏂囦欢鍚嶇О绠$悊-缂栬緫") + //@RequiresPermissions("org.jeecg.modules.mdc:sys_file_name:edit") + @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST}) + public Result<String> edit(@RequestBody SysFileName sysFileName) { + sysFileNameService.updateById(sysFileName); + return Result.OK("缂栬緫鎴愬姛!"); + } + + + /** + * 鐗堟湰鍗囩骇 + * qsw 2023-11-3 + */ + @PostMapping(value = "/revise") + public Result<String> revise(@RequestBody SysFileName sysFileName) { + sysFileName.setId(""); + boolean b = sysFileNameService.save(sysFileName); + if(b){ + return Result.OK("鐗堟湰鍗囩骇鎴愬姛锛�"); + }else{ + return Result.error("鐗堟湰鍗囩骇澶辫触锛�"); + } + } + + /** + * 鍗囩増 + * qsw 2023-11-3 + */ + @RequestMapping("/getReviseVersion") + public Result<?> getReviseVersion(@RequestBody SysFileName sysFileName) { + List<SysFileName> sysFileNames = sysFileNameService.lambdaQuery() + .eq(SysFileName::getName, sysFileName.getName()) + .orderByDesc(SysFileName::getVersion) + .list(); + String version = sysFileNames.get(0).getVersion(); + BigDecimal versionB = new BigDecimal(version); + BigDecimal versionCode = versionB.add(new BigDecimal(1)); + return Result.ok(versionCode.toString()); + } + + /** + * 鐗堟湰鐢熸晥 + * qsw 2023-7-26 + */ + @RequestMapping(value = "/versionTakeEffect", method = {RequestMethod.PUT,RequestMethod.POST}) + @Transactional(rollbackFor = { Exception.class }) + public Result<String> versionTakeEffect(@RequestBody SysFileName sysFileName) { + List<SysFileName> sysFileNames = sysFileNameService.lambdaQuery() + .eq(SysFileName::getName, sysFileName.getName()).list(); + for (SysFileName fileName : sysFileNames) { + fileName.setVersionStatus("3"); + sysFileNameService.updateById(fileName); + } + boolean b = sysFileNameService.updateById(sysFileName); + if (b){ + return Result.OK("鐢熸晥鎴愬姛!"); + }else{ + return Result.error("鐢熸晥澶辫触!"); + } + } + + /** + * 閫氳繃鍗曟嵁绫诲瀷鑾峰彇鍗曟嵁缂栫爜 + * qsw 2023-11-3 + */ + @GetMapping("getSysFileName") + public Result<?> getSysFileName(@RequestParam(name="name",required=true) String name) { + List<SysFileNameVo> sysFileName = sysFileNameService.getSysFileName(name); + return Result.ok(sysFileName); + } + + /** + * 閫氳繃id鍒犻櫎 + * + * @param id + * @return + */ + @AutoLog(value = "鏂囦欢鍚嶇О绠$悊-閫氳繃id鍒犻櫎") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-閫氳繃id鍒犻櫎", notes="鏂囦欢鍚嶇О绠$悊-閫氳繃id鍒犻櫎") + //@RequiresPermissions("org.jeecg.modules.mdc:sys_file_name:delete") + @DeleteMapping(value = "/delete") + public Result<String> delete(@RequestParam(name="id",required=true) String id) { + sysFileNameService.removeById(id); + return Result.OK("鍒犻櫎鎴愬姛!"); + } + + /** + * 鎵归噺鍒犻櫎 + * + * @param ids + * @return + */ + @AutoLog(value = "鏂囦欢鍚嶇О绠$悊-鎵归噺鍒犻櫎") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-鎵归噺鍒犻櫎", notes="鏂囦欢鍚嶇О绠$悊-鎵归噺鍒犻櫎") + //@RequiresPermissions("org.jeecg.modules.mdc:sys_file_name:deleteBatch") + @DeleteMapping(value = "/deleteBatch") + public Result<String> deleteBatch(@RequestParam(name="ids",required=true) String ids) { + this.sysFileNameService.removeByIds(Arrays.asList(ids.split(","))); + return Result.OK("鎵归噺鍒犻櫎鎴愬姛!"); + } + + /** + * 閫氳繃id鏌ヨ + * + * @param id + * @return + */ + //@AutoLog(value = "鏂囦欢鍚嶇О绠$悊-閫氳繃id鏌ヨ") + @ApiOperation(value="鏂囦欢鍚嶇О绠$悊-閫氳繃id鏌ヨ", notes="鏂囦欢鍚嶇О绠$悊-閫氳繃id鏌ヨ") + @GetMapping(value = "/queryById") + public Result<SysFileName> queryById(@RequestParam(name="id",required=true) String id) { + SysFileName sysFileName = sysFileNameService.getById(id); + if(sysFileName==null) { + return Result.error("鏈壘鍒板搴旀暟鎹�"); + } + return Result.OK(sysFileName); + } + + /** + * 瀵煎嚭excel + * + * @param request + * @param sysFileName + */ + //@RequiresPermissions("org.jeecg.modules.mdc:sys_file_name:exportXls") + @RequestMapping(value = "/exportXls") + public ModelAndView exportXls(HttpServletRequest request, SysFileName sysFileName) { + return super.exportXls(request, sysFileName, SysFileName.class, "鏂囦欢鍚嶇О绠$悊"); + } + + /** + * 閫氳繃excel瀵煎叆鏁版嵁 + * + * @param request + * @param response + * @return + */ + //@RequiresPermissions("sys_file_name:importExcel") + @RequestMapping(value = "/importExcel", method = RequestMethod.POST) + public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) { + return super.importExcel(request, response, SysFileName.class); + } + +} -- Gitblit v1.9.3