package com.zhongzheng.controller.common; import cn.hutool.core.util.StrUtil; import com.zhongzheng.common.config.RuoYiConfig; import com.zhongzheng.common.constant.Constants; import com.zhongzheng.common.core.domain.AjaxResult; import com.zhongzheng.common.core.domain.model.LoginBody; import com.zhongzheng.common.utils.ServletUtils; import com.zhongzheng.common.utils.ToolsUtils; import com.zhongzheng.common.utils.file.FileUploadUtils; import com.zhongzheng.common.utils.file.FileUtils; import com.zhongzheng.common.utils.poi.ExcelUtil; import com.zhongzheng.framework.config.ServerConfig; import com.zhongzheng.modules.course.vo.CourseMenuVo; import com.zhongzheng.modules.goods.bo.GoodsQueryBo; import com.zhongzheng.modules.goods.service.IGoodsService; import com.zhongzheng.modules.goods.vo.GoodsJzsVo; import com.zhongzheng.modules.grade.bo.RollBackPeriodBo; import com.zhongzheng.modules.grade.bo.UserPeriodEditBo; import com.zhongzheng.modules.grade.service.IUserPeriodService; import com.zhongzheng.modules.grade.vo.ClassPeriodStudentExportAllVo; import com.zhongzheng.modules.grade.vo.SyncGoodsExport; import com.zhongzheng.modules.order.bo.OrderAddBo; import com.zhongzheng.modules.order.service.IOrderService; import com.zhongzheng.modules.order.service.impl.OrderServiceImpl; import com.zhongzheng.modules.system.service.ISysUserService; import com.zhongzheng.modules.user.vo.UserExportVo; import io.swagger.annotations.ApiOperation; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.http.MediaType; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestBody; import org.springframework.web.bind.annotation.RestController; import org.springframework.web.multipart.MultipartFile; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.util.ArrayList; import java.util.List; /** * 通用请求处理 * * @author zhongzheng */ @RestController public class CommonController { private static final Logger log = LoggerFactory.getLogger(CommonController.class); @Autowired private ServerConfig serverConfig; @Autowired private IGoodsService iGoodsService; @Autowired private IUserPeriodService iUserPeriodService; @Autowired private IOrderService iOrderService; /** * 通用下载请求 * * @param fileName 文件名称 * @param delete 是否删除 */ @GetMapping("common/download") public void fileDownload(String fileName, Boolean delete, HttpServletResponse response, HttpServletRequest request) { try { if (!FileUtils.checkAllowDownload(fileName)) { throw new Exception(StrUtil.format("文件名称({})非法,不允许下载。 ", fileName)); } String realFileName = System.currentTimeMillis() + fileName.substring(fileName.indexOf("_") + 1); String filePath = RuoYiConfig.getDownloadPath() + fileName; response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE); FileUtils.setAttachmentResponseHeader(response, realFileName); FileUtils.writeBytes(filePath, response.getOutputStream()); /* if (delete) { FileUtils.deleteFile(filePath); }*/ FileUtils.deleteFile(filePath); } catch (Exception e) { log.error("下载文件失败", e); } } /** * 通用上传请求 */ @PostMapping("/common/upload") public AjaxResult uploadFile(MultipartFile file) throws Exception { try { // 上传文件路径 String filePath = RuoYiConfig.getUploadPath(); // 上传并返回新文件名称 String fileName = FileUploadUtils.upload(filePath, file); String url = serverConfig.getUrl() + fileName; AjaxResult ajax = AjaxResult.success(); ajax.put("fileName", fileName); ajax.put("url", url); return ajax; } catch (Exception e) { return AjaxResult.error(e.getMessage()); } } /** * 本地资源通用下载 */ @GetMapping("/common/download/resource") public void resourceDownload(String resource, HttpServletRequest request, HttpServletResponse response) throws Exception { try { if (!FileUtils.checkAllowDownload(resource)) { throw new Exception(StrUtil.format("资源文件({})非法,不允许下载。 ", resource)); } // 本地资源路径 String localPath = RuoYiConfig.getProfile(); // 数据库资源地址 String downloadPath = localPath + StrUtil.subAfter(resource, Constants.RESOURCE_PREFIX,false); // 下载名称 String downloadName = StrUtil.subAfter(downloadPath, "/",true); response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE); FileUtils.setAttachmentResponseHeader(response, downloadName); FileUtils.writeBytes(downloadPath, response.getOutputStream()); } catch (Exception e) { log.error("下载文件失败", e); } } @ApiOperation("获取继教二建的商品结构列表") @GetMapping("common/jzs/goodsList") public AjaxResult goodsList() { GoodsQueryBo queryBo = new GoodsQueryBo(); List goodsJzsVoList = iGoodsService.selectRjJzsList(queryBo); ExcelUtil util = new ExcelUtil(SyncGoodsExport.class); // ExcelUtil util = new ExcelUtil<>(SyncGoodsExport.class); return util.exportEasyExcel(util.exportEasyData(goodsJzsVoList), "继建商品"); } @ApiOperation("测试列表") @GetMapping("common/jzs/test") public AjaxResult testList() { UserPeriodEditBo queryBo = new UserPeriodEditBo(); queryBo.setGoodsId(916L); queryBo.setGradeId(794L); queryBo.setUserId(114L); iUserPeriodService.syncStudyLogToOld(queryBo); return AjaxResult.success(); } @ApiOperation("旧系统打回重审") @PostMapping("common/rollback/period") public AjaxResult rollbackPeriod(@RequestBody RollBackPeriodBo bo) { String sign = bo.getStamp().toString()+"pubilc2022"; if(!bo.getSign().equals(ToolsUtils.EncoderByMd5(sign))){ return AjaxResult.error("签名错误"); } return AjaxResult.success(); } @ApiOperation("测试分班") @GetMapping("common/jzs/grade") public AjaxResult testGrade() { iOrderService.arrangeGrade("安管继续教育网络班B类",890L,3097L,null,114L,"",174L); return AjaxResult.success(); } }