| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006 |
- package com.goafanti.common.controller;
- import com.goafanti.admin.service.AdminService;
- import com.goafanti.admin.service.AttachmentService;
- import com.goafanti.common.bo.Error;
- import com.goafanti.common.bo.*;
- import com.goafanti.common.constant.AFTConstants;
- import com.goafanti.common.constant.ErrorConstants;
- import com.goafanti.common.enums.UserType;
- import com.goafanti.common.model.User;
- import com.goafanti.common.service.DistrictGlossoryService;
- import com.goafanti.common.service.ImageService;
- import com.goafanti.common.service.IndustryCategoryService;
- import com.goafanti.common.service.PovertyService;
- import com.goafanti.common.utils.*;
- import com.goafanti.common.utils.excel.FileUtils;
- import com.goafanti.common.utils.excel.NewExcelUtil;
- import com.goafanti.core.mybatis.JDBCIdGenerator;
- import com.goafanti.core.shiro.token.TokenManager;
- import com.goafanti.core.websocket.SystemWebSocketHandler;
- import com.goafanti.customer.service.UserOutboundService;
- import com.goafanti.expenseAccount.service.ExpenseAccountService;
- import com.goafanti.order.service.OrderNewService;
- import com.goafanti.order.service.OrderProjectService;
- import com.goafanti.user.service.UserService;
- import org.apache.commons.collections4.map.HashedMap;
- import org.apache.commons.lang3.StringUtils;
- import org.apache.poi.ss.usermodel.Cell;
- import org.apache.poi.ss.usermodel.Row;
- import org.apache.poi.ss.usermodel.Sheet;
- import org.apache.poi.ss.usermodel.Workbook;
- import org.apache.poi.xssf.usermodel.XSSFWorkbook;
- import org.springframework.beans.factory.annotation.Autowired;
- import org.springframework.beans.factory.annotation.Value;
- import org.springframework.context.annotation.Scope;
- import org.springframework.http.MediaType;
- import org.springframework.stereotype.Controller;
- import org.springframework.web.bind.annotation.*;
- import org.springframework.web.multipart.MultipartFile;
- import org.springframework.web.socket.TextMessage;
- import javax.annotation.Resource;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import java.io.*;
- import java.util.*;
- @Controller
- @Scope(value = "prototype")
- @RequestMapping("/open")
- public class PublicController extends CertifyApiController {
- @Value(value = "${accessKey}")
- private String accessKey = null;
- @Value(value = "${accessSecret}")
- private String accessSecret = null;
- @Value(value = "${upload.path}")
- private String uploadPath = null;
- @Value(value = "${upload.private.path}")
- private String uploadPrivatePath = null;
- @Value(value = "${static.host}")
- private String staticHost = null;
- @Value(value = "${mobileCodeTemplate}")
- private String mobileCodeTemplate = null;
- @Value(value = "${mobileRemindCodeTemplate}")
- private String mobileRemindCodeTemplate = null;
- @Value(value = "${wx.clockInRange}")
- private Integer clockInRange;
- @Resource
- private UserService userService;
- @Resource
- private AttachmentService aftFileService;
- @Resource
- private AdminService adminService;
- @Resource
- private PovertyService povertyService;
- @Autowired
- private IndustryCategoryService industryCategoryService;
- @Autowired
- private DistrictGlossoryService districtGlossoryService;
- @Autowired
- private ExpenseAccountService expenseAccountService;
- @Autowired
- private OrderNewService orderNewService;
- @Autowired
- private OrderProjectService orderProjectService;
- @Resource
- private UserOutboundService userOutboundService;
- @Resource
- private ImageService imageService;
- @Value(value = "${patentTemplate}")
- private String patentTemplate = null;
- @Autowired
- private JDBCIdGenerator jdbcIdGenerator;
- @Resource(name = "passwordUtil")
- private PasswordUtil passwordUtil;
- /** 上传图片 **/
- @RequestMapping(value = "/upload", method = RequestMethod.POST)
- public Result uploadOrderInvoiceFile(HttpServletRequest req){
- Result res = new Result();
- res.setData(handleFile(res, "/publicRelease/", false, req, "publicRelease"));
- return res;
- }
- /**
- * 获取验证码
- *
- * @param response
- */
- @RequestMapping(value = "/getVCode", method = RequestMethod.GET)
- public void getVCode(HttpServletResponse response, HttpServletRequest request) {
- try {
- response.setHeader("Pragma", "No-cache");
- response.setHeader("Cache-Control", "no-cache");
- response.setDateHeader("Expires", 0);
- response.setContentType("image/jpg");
- // 生成随机字串
- String verifyCode = VerifyCodeUtils.generateVerifyCode(4);
- // 存入Shiro会话session
- TokenManager.setVal2Session(VerifyCodeUtils.V_CODE, verifyCode.toLowerCase());
- // 生成图片
- int w = 146, h = 33;
- VerifyCodeUtils.outputImage(w, h, response.getOutputStream(), verifyCode);
- } catch (Exception e) {
- LoggerUtils.fmtError(getClass(), e, "获取验证码异常:%s", e.getMessage());
- }
- }
- /**
- * 手机验证码
- *
- * @param mobile
- * @param sign
- * 是否用与找回密码
- * @param type
- * @return
- */
- @RequestMapping(value = "/getMCode", method = RequestMethod.GET)
- @ResponseBody
- public Result getMcode(String mobile, boolean sign, Integer type, String verificationCode) {
- Result res = new Result();
- // 用于找回密码
- if (sign) {
- if (null == userService.selectByMobieAndType(mobile.trim(), type)) {
- res.getError().add(buildError(ErrorConstants.NON_REGISTER, "", "该用户未注册!"));
- return res;
- }
- }
- if (!sign) {
- if (StringUtils.isBlank(verificationCode)) {
- res.getError().add(buildError(ErrorConstants.VCODE_EMPTY_ERROR, "", "图像验证码不能为空!"));
- return res;
- }
- if (!VerifyCodeUtils.verifyCode(verificationCode)) {
- res.getError().add(buildError(ErrorConstants.VCODE_ERROR, "", "图形验证码输入错误!"));
- return res;
- }
- }
- if (TokenManager.getSession().getAttribute(VerifyCodeUtils.M_CODE_TIME) == null
- || TokenManager.getSession().getAttribute(VerifyCodeUtils.M_CODE_TIME) == "") {
- sendMessage(mobile, res,VerifyCodeUtils.M_CODE);
- } else if (TimeUtils.checkOverTime("getMCode")) {
- VerifyCodeUtils.clearMobileCode();
- VerifyCodeUtils.clearMobileCodeTime();
- sendMessage(mobile, res,VerifyCodeUtils.M_CODE);
- } else {
- res.getError().add(buildError(ErrorConstants.MCODE_FREQUENCY_ERROR, "", "手机验证码发送频繁!"));
- }
- return res;
- }
- /**
- *
- * @param mobile
- * @param res
- * @return
- */
- private Result sendMessage(String mobile, Result res,String codeType) {
- String mobileVerifyCode = VerifyCodeUtils.generateMobileVerifyCode(6); // 生成随机字串
- if(VerifyCodeUtils.M_CODE.equals(codeType)){
- TokenManager.setVal2Session(VerifyCodeUtils.M_CODE, mobileVerifyCode);// 存入Shiro会话session
- TokenManager.setVal2Session(VerifyCodeUtils.M_CODE_TIME, System.currentTimeMillis());
- }else if(VerifyCodeUtils.RESET_CODE.equals(codeType)){
- TokenManager.setVal2Session(VerifyCodeUtils.RESET_CODE, mobileVerifyCode);// 存入Shiro会话session
- TokenManager.setVal2Session(VerifyCodeUtils.RESET_CODE_TIME, System.currentTimeMillis());
- }
- String paramString = "{\"code\":\"" + mobileVerifyCode + "\",\"product\":\"技淘网\"}";
- String ret = MobileMessageUtils.sendMessage(mobileCodeTemplate, paramString, mobile, accessKey, accessSecret);
- if (StringUtils.isNotBlank(ret)) {
- res.getError().add(buildError(ErrorConstants.M_CODE_ERROR));
- }
- return res;
- }
- /**
- * 下载图片
- *
- * @param response
- * @param path
- * @param request
- */
- @RequestMapping(value = "/downLoadPicture", method = RequestMethod.GET)
- public Result downLoadPicture(HttpServletResponse response, String path, HttpServletRequest request) {
- Result res = new Result();
- if (StringUtils.isBlank(path)) {
- res.getError().add(buildError(ErrorConstants.FILE_NON_EXISTENT));
- return res;
- }
- String filename = Long.toString(System.nanoTime()) + ".jpg";
- InputStream in = null;
- OutputStream out = null;
- byte[] buffer = new byte[8 * 1024];
- String fileSaveRootPath = "";
- try {
- fileSaveRootPath = uploadPrivatePath + path;
- File file = new File(fileSaveRootPath);
- in = new FileInputStream(file);
- out = response.getOutputStream();
- // 设置文件MIME类型
- response.setContentType("application/octet-stream");
- response.setHeader("Content-Disposition", "attachment; filename=" + filename);
- for (;;) {
- int bytes = in.read(buffer);
- if (bytes == -1) {
- break;
- }
- out.write(buffer, 0, bytes);
- }
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- } finally {
- try {
- if (null != in) {
- in.close();
- }
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- }
- try {
- if (null != out) {
- out.close();
- }
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- }
- }
- return res;
- }
- /**
- * 删除图片文件(public图片)
- *
- * @param path
- * @return
- */
- @RequestMapping(value = "/deleteUploadPicture", method = RequestMethod.POST)
- public boolean deleteUploadPicture(String path) {
- boolean flag = false;
- path = uploadPath + path;
- File file = new File(path);
- // 判断目录或文件是否存在
- if (!file.exists() || !file.isFile()) { // 不存在返回 false
- return flag;
- } else {
- return file.delete();
- }
- }
- /**
- * 获取并输出private图片
- */
- @RequestMapping(value = "/writeImage", method = RequestMethod.GET)
- public void writeImage(HttpServletResponse response, HttpServletRequest request, String path) {
- try {
- String realPath = uploadPrivatePath + path;
- PictureUtils.outputImage(response, realPath);
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "获取图片异常:%s", e.getMessage());
- }
- }
- /**
- * 下载文件
- *
- * @param fileName
- * @param response
- * @param path
- * @return
- */
- @RequestMapping(value = "/downloadFile", method = RequestMethod.GET)
- public Result downloadFile(String fileName, HttpServletResponse response, String path) {
- Result res = new Result();
- return handleDownloadFile(response, fileName, path, res);
- }
- /**
- * 下载模版文件
- *
- * @param response
- * @return
- */
- @RequestMapping(value = "/downloadTemplateFile", method = RequestMethod.GET)
- public Result downloadTemplateFile(HttpServletResponse response, String sign) {
- Result res = new Result();
- String fileName = "";
- String path = aftFileService.selectAftFileBySign(sign).getFilePath();
- String suffix = path.substring(path.lastIndexOf("."));
- if (sign.equals("patent_prory_statement")) {
- fileName = "专利代理委托书模版" + suffix;
- } else {
- fileName = System.nanoTime() + " ";
- }
- if (!StringUtils.isBlank(path)) {
- return handleDownloadFile(response, fileName, path, res);
- } else {
- res.getError().add(buildError(ErrorConstants.FILE_NON_EXISTENT, "", "下载文件不存在!"));
- return res;
- }
- }
- private Result handleDownloadFile(HttpServletResponse response, String fileName, String path, Result res) {
- String fileSaveRootPath = uploadPrivatePath + path;
- InputStream in = null;
- OutputStream out = null;
- byte[] buffer = new byte[8 * 1024];
- try {
- File file = new File(fileSaveRootPath);
- in = new FileInputStream(file);
- out = response.getOutputStream();
- response.setContentType("multipart/form-data");
- fileName = java.net.URLEncoder.encode(fileName, "UTF-8");
- response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
- for (;;) {
- int bytes = in.read(buffer);
- if (bytes == -1) {
- break;
- }
- out.write(buffer, 0, bytes);
- }
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- } finally {
- try {
- in.close();
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- }
- try {
- out.close();
- } catch (IOException e) {
- LoggerUtils.fmtError(getClass(), e, "IO错误:%s", e.getMessage());
- }
- }
- return res;
- }
- @RequestMapping(value = "/findIndustryCategory", method = RequestMethod.GET)
- @ResponseBody
- public Result findIndustryCategory(String id, String noCache) {
- Integer pid = 0;
- if (StringUtils.isNumeric(id)) {
- try {
- pid = Integer.parseInt(id);
- } catch (Exception e) {
- pid = 0;
- }
- }
- if (StringUtils.isNotBlank(noCache)) {
- industryCategoryService.clear(pid);
- }
- return new Result().data(industryCategoryService.list(pid));
- }
- @RequestMapping(value = "/findDistrict", method = RequestMethod.GET)
- @ResponseBody
- public Result findDistrictGlossory(String id, String noCache) {
- Integer pid = 0;
- if (StringUtils.isNumeric(id)) {
- try {
- pid = Integer.parseInt(id);
- } catch (Exception e) {
- pid = 0;
- }
- }
- if (StringUtils.isNotBlank(noCache)) {
- districtGlossoryService.clear(pid);
- }
- return new Result().data(districtGlossoryService.list(pid));
- }
- /**
- *
- * @param mobileCode
- * @return
- */
- @RequestMapping(value = "/checkMCode", method = RequestMethod.POST)
- @ResponseBody
- public Result checkMCode(String mobileCode) {
- Result res = new Result();
- if (StringUtils.isBlank(mobileCode)) {
- res.getError().add(buildError(ErrorConstants.MCODE_EMPTY_ERROR, "", "手机验证码"));
- return res;
- }
- if (TimeUtils.checkOverTime(VerifyCodeUtils.M_CODE)) {
- res.getError().add(buildError(ErrorConstants.MCODE_OVERTIME_ERROR, "", "手机验证码超时失效!"));
- VerifyCodeUtils.clearMobileCode();
- VerifyCodeUtils.clearMobileCodeTime();
- return res;
- }
- if (!TokenManager.getSession().getAttribute(VerifyCodeUtils.M_CODE).equals(mobileCode)) {
- res.getError().add(buildError(ErrorConstants.MCODE_ERROR, "", "手机验证码错误"));
- return res;
- }
- // resetCode
- if (res.getError().isEmpty()) {
- String resetCode = UUID.randomUUID().toString();
- TokenManager.setVal2Session(VerifyCodeUtils.RESET_CODE, resetCode);
- TokenManager.setVal2Session(VerifyCodeUtils.RESET_CODE_TIME, System.currentTimeMillis());
- res.setData(resetCode);
- }
- return res;
- }
- /**
- * 重置密码
- *
- * @param resetCode
- * @param mobile
- * @param type
- * @param newPwd
- * @return
- */
- @RequestMapping(value = "/resetPwd", method = RequestMethod.POST)
- @ResponseBody
- public Result resetPwd(String resetCode, String mobile, Integer type, String newPwd) {
- Result res = new Result();
- if (TimeUtils.checkOverTime(VerifyCodeUtils.M_CODE)) {
- res.getError().add(buildError(ErrorConstants.RESET_CODE_OVERTIME, "", "页面超时失效,请重新获取验证码!"));
- cleanCodeSession();
- return res;
- }
- if(null == TokenManager.getSession().getAttribute(VerifyCodeUtils.RESET_CODE)){
- res.getError().add(buildError(ErrorConstants.RESET_CODE_OVERTIME, "", "页面超时失效,请重新获取验证码!"));
- cleanCodeSession();
- return res;
- }else if(!TokenManager.getSession().getAttribute(VerifyCodeUtils.RESET_CODE).equals(resetCode)){
- res.getError().add(buildError(ErrorConstants.RESET_CODE_ERROR, "", "验证码错误,请重新获取验证码!"));
- cleanCodeSession();
- return res;
- }
- if (StringUtils.isBlank(newPwd)) {
- res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "新密码"));
- return res;
- }
- if (StringUtils.isBlank(mobile)) {
- res.getError().add(buildError(ErrorConstants.PARAM_EMPTY_ERROR, "", "mobile"));
- return res;
- }
- if (!UserType.ORGANIZATION.getCode().equals(type) && !UserType.PERSONAL.getCode().equals(type)) {
- res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "type"));
- return res;
- }
- User user = userService.selectByMobieAndType(mobile, type);
- if (null == user) {
- res.getError().add(buildError(ErrorConstants.PARAM_ERROR, "", "mobile"));
- return res;
- }
- user.setPassword(newPwd);
- user.setPassword(passwordUtil.getEncryptPwd(user));
- userService.updateByPrimaryKeySelective(user);
- VerifyCodeUtils.clearResetCode();
- VerifyCodeUtils.clearResetCodeTime();
- return res;
- }
- private void cleanCodeSession() {
- VerifyCodeUtils.clearResetCode();
- VerifyCodeUtils.clearResetCodeTime();
- VerifyCodeUtils.clearMobileCode();
- VerifyCodeUtils.clearMobileCodeTime();
- }
- @RequestMapping(value = "/getRegisterMCode", method = RequestMethod.GET )
- @ResponseBody
- public Result getRegisterMCode(String mobile){
- Result res = new Result();
- if (TokenManager.getSession().getAttribute(VerifyCodeUtils.M_CODE_TIME) == null
- || TokenManager.getSession().getAttribute(VerifyCodeUtils.M_CODE_TIME) == "") {
- sendMessage(mobile, res,VerifyCodeUtils.M_CODE);
- } else if (TimeUtils.checkOverTime("getMCode")) {
- VerifyCodeUtils.clearMobileCode();
- VerifyCodeUtils.clearMobileCodeTime();
- sendMessage(mobile, res,VerifyCodeUtils.M_CODE);
- } else {
- res.getError().add(buildError(ErrorConstants.MCODE_FREQUENCY_ERROR, "", "手机验证码发送频繁!"));
- }
- return res;
- }
- @RequestMapping(value = "/getResetMCode", method = RequestMethod.GET )
- @ResponseBody
- public Result getResetMCode(String mobile, Integer type) {
- Result res = new Result();
- if (null == userService.selectByMobieAndType(mobile.trim(), type)) {
- res.getError().add(buildError(ErrorConstants.NON_REGISTER, "", "该用户未注册!"));
- return res;
- }
- if (TokenManager.getSession().getAttribute(VerifyCodeUtils.RESET_CODE_TIME) == null
- || TokenManager.getSession().getAttribute(VerifyCodeUtils.RESET_CODE_TIME) == "") {
- sendMessage(mobile, res,VerifyCodeUtils.RESET_CODE);
- } else if (TimeUtils.checkOverTime("resetCode")) {
- VerifyCodeUtils.clearMobileCode();
- VerifyCodeUtils.clearMobileCodeTime();
- sendMessage(mobile, res,VerifyCodeUtils.RESET_CODE);
- } else {
- res.getError().add(buildError(ErrorConstants.MCODE_FREQUENCY_ERROR, "", "手机验证码发送频繁!"));
- }
- return res;
- }
- /** 省市区查询 **/
- @RequestMapping(value = "/listAllProvince" , method = RequestMethod.POST)
- @ResponseBody
- public Result listAllProvince(){
- Result res = new Result();
- res.setData(districtGlossoryService.getProvince());
- return res;
- }
- @RequestMapping(value = "/listDefaultPassword" , method = RequestMethod.GET)
- @ResponseBody
- public Result listDefaultPassword(String depId){
- Result res=new Result();
- res.setData(adminService.getListDefaultPassword(depId));
- return res;
- }
- /** 省市区查询 **/
- @RequestMapping(value = "/sendWeb" , method = RequestMethod.POST)
- @ResponseBody
- public Result sendWeb(String str){
- Result res = new Result();
- SystemWebSocketHandler sys=new SystemWebSocketHandler();
- TextMessage text=new TextMessage(str.getBytes());
- sys.sendMessageToUsers(text);
- res.setData(1);
- return res;
- }
- /**
- * 导入流水
- * @param file
- * @param request
- * @return
- */
- @SuppressWarnings("unchecked")
- @RequestMapping(value = "/import" , method = RequestMethod.POST)
- @ResponseBody
- public Result importTeacher(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request) {
- Result res=new Result();
- String fileName = file.getOriginalFilename();
- if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
- res.error(new Error("", "格式不正确"));
- }
- //检查文件
- try {
- checkFile(file);
- } catch (IOException e) {
- e.printStackTrace();
- }
- //获得Workbook工作薄对象
- Workbook workbook = getWorkBook(file);
- //创建返回对象,把每行中的值作为一个数组,所有行作为一个集合返回
- List<List<String>> list = new ArrayList<>();
- if(workbook != null){
- for(int sheetNum = 0;sheetNum < workbook.getNumberOfSheets();sheetNum++){
- //获得当前sheet工作表
- Sheet sheet = workbook.getSheetAt(sheetNum);
- if(sheet == null){
- continue;
- }
- //获得当前sheet的开始行
- int firstRowNum = sheet.getFirstRowNum();
- //获得当前sheet的结束行
- int lastRowNum = sheet.getLastRowNum();
- //循环除了第2行的所有行
- for(int rowNum = firstRowNum+2;rowNum <= lastRowNum;rowNum++){
- //获得当前行
- Row row = sheet.getRow(rowNum);
- if(row == null){
- continue;
- }
- //获得当前行的开始列
- int firstCellNum = row.getFirstCellNum();
- //获得当前行的列数
- int lastCellNum = row.getLastCellNum();
- @SuppressWarnings("rawtypes")
- ArrayList arrayList = new ArrayList();
- //循环当前行 cellNum = (firstCellNum+1) 则是除开第一例
- for(int cellNum = (firstCellNum); cellNum < lastCellNum;cellNum++){
- Cell cell = row.getCell(cellNum);
- arrayList.add(getCellValue(cell));
- }
- list.add(arrayList);
- }
- }
- }
- return res;
- }
- public static void checkFile(MultipartFile file) throws IOException{
- //判断文件是否存在
- if(null == file){
- throw new FileNotFoundException("文件不存在!");
- }
- //获得文件名
- String fileName = file.getOriginalFilename();
- //判断文件是否是excel文件
- if(!fileName.endsWith("xls") && !fileName.endsWith("xlsx")){
- throw new IOException(fileName + "不是excel文件");
- }
- }
- public static Workbook getWorkBook(MultipartFile file) {
- //创建Workbook工作薄对象,表示整个excel
- Workbook workbook = null;
- try {
- //获取excel文件的io流
- InputStream is = file.getInputStream();
- //如果是xls,使用HSSFWorkbook;如果是xlsx,使用XSSFWorkbook
- workbook = new XSSFWorkbook(is);
- } catch (IOException e) {
- }
- return workbook;
- }
- @SuppressWarnings("deprecation")
- public static String getCellValue(Cell cell){
- String cellValue = "";
- if(cell == null){
- return cellValue;
- }
- //把数字当成String来读,避免出现1读成1.0的情况
- if(cell.getCellType() == Cell.CELL_TYPE_NUMERIC){
- cell.setCellType(Cell.CELL_TYPE_STRING);
- }
- //判断数据的类型
- switch (cell.getCellType()){
- case Cell.CELL_TYPE_NUMERIC: //数字
- cellValue = String.valueOf(cell.getNumericCellValue());
- break;
- case Cell.CELL_TYPE_STRING: //字符串
- cellValue = String.valueOf(cell.getStringCellValue());
- break;
- case Cell.CELL_TYPE_BOOLEAN: //Boolean
- cellValue = String.valueOf(cell.getBooleanCellValue());
- break;
- case Cell.CELL_TYPE_FORMULA: //公式
- cellValue = String.valueOf(cell.getCellFormula());
- break;
- case Cell.CELL_TYPE_BLANK: //空值
- cellValue = "未知";
- break;
- case Cell.CELL_TYPE_ERROR: //故障
- cellValue = "非法字符";
- break;
- default:
- cellValue = "未知类型";
- break;
- }
- return cellValue;
- }
- /**
- * 通用下载请求
- *
- * @param fileName 文件名称
- * @param delete 是否删除
- */
- @RequestMapping("/download")
- public void fileDownload(String fileName, Boolean delete,String attName,
- HttpServletResponse response, HttpServletRequest request)
- {
- try
- {
- if (!FileUtils.checkAllowDownload(fileName))
- {
- throw new Exception("文件名称非法,不允许下载。 ");
- }
- String realFileName =DateUtils.parseDateToStr(AFTConstants.YYYYMMDDHHMMSS, new Date())+fileName.substring(fileName.indexOf("_") + 1);
- String filePath = uploadPath +"/"+ fileName;
- response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
- FileUtils.setAttachmentResponseHeader(response, realFileName,attName);
- FileUtils.writeBytes(filePath, response.getOutputStream());
- if(delete==null)delete=true;
- if (delete)
- {
- FileUtils.deleteFile(filePath);
- }
- }
- catch (Exception e)
- {
- LoggerUtils.error(PublicController.class,"下载文件失败", e);
- }
- }
- /**
- * 通用下载请求
- *
- * @param fileName 文件名称
- */
- @RequestMapping("/deleteFile")
- public Result deleteFile(String fileName) {
- Result res = new Result();
- if (StringUtils.isBlank(fileName)) {
- res.getError().add(buildError("文件路径错误"));
- return res;
- }
- try {
- if (!FileUtils.checkAllowDownload(fileName)) {
- throw new Exception("文件名称非法,不允许删除。 ");
- }
- String filePath = uploadPath + "/" + fileName;
- FileUtils.deleteFile(filePath);
- res.setData(1);
- } catch (Exception e) {
- LoggerUtils.error(PublicController.class, "删除文件失败", e);
- }
- return res;
- }
- @RequestMapping("/getWxConfig")
- public Result getWxConfig() {
- Result res =new Result();
- Map<String, Object> config= new HashedMap<>();
- config.put("clockInRange", clockInRange);
- res.data(config);
- return res;
- }
- @RequestMapping("/getUser")
- public Result getUser() {
- List<OutUser> list=userService.getuser();
- NewExcelUtil<OutUser> excel=new NewExcelUtil<OutUser>(OutUser.class);
- return excel.exportExcel(list, "客户列表",uploadPath);
- }
- /**
- * 补充发票报销查询编号
- */
- @RequestMapping("/supplementCheckNo")
- public Result supplementCheckNo() {
- Result res=new Result();
- res.data(expenseAccountService.pushSupplementCheckNo());
- return res;
- }
- /**
- * 查询贫困信息
- */
- @RequestMapping("/selectPoverty")
- public Result selectPoverty(@RequestParam(value = "file", required = false) MultipartFile file) {
- Result res=new Result();
- //判断文件是否存在
- if(null == file){
- res.getError().add(buildError("文件不存在!","文件不存在!"));
- return res;
- }
- String fileName = file.getOriginalFilename();
- if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
- res.getError().add(buildError("格式不正确","格式不正确"));
- return res;
- }
- String id = jdbcIdGenerator.generateId().toString();
- res.data(povertyService.selectPoverty(file,id));
- return res;
- }
- /**
- * 查询贫困信息
- * @param id 贫困信息编号
- * @param type 0=所有 ,1=只看有效数据
- */
- @RequestMapping("/selectPovertyById/export")
- public Result selectPovertyByIdExport(String id,Integer type) {
- Map<String,Object> o = povertyService.selectPoverty(null, id);
- if (type==null)type=0;
- List<OutPoverty> resList=new ArrayList<>();
- if (type==1){
- List<OutPoverty> list = (List<OutPoverty>) o.get("list");
- for (OutPoverty outPoverty : list) {
- if (com.goafanti.common.utils.StringUtils.isNotEmpty(outPoverty.getId())){
- resList.add(outPoverty);
- }
- }
- }else {
- resList = (List<OutPoverty>) o.get("list");
- }
- NewExcelUtil<OutPoverty> newExcelUtil=new NewExcelUtil<>(OutPoverty.class);
- return newExcelUtil.exportExcel(resList,"广西贫困信息表",uploadPath);
- }
- @RequestMapping("/selectPovertyById")
- public Result selectPovertyById(String id,Integer type) {
- Result res=new Result();
- Map<String,Object> o = povertyService.selectPoverty(null, id);
- if (type==null)type=0;
- if (type==1){
- List<OutPoverty> list = (List<OutPoverty>) o.get("list");
- List<OutPoverty> resList=new ArrayList<>();
- for (OutPoverty outPoverty : list) {
- if (com.goafanti.common.utils.StringUtils.isNotEmpty(outPoverty.getId())){
- resList.add(outPoverty);
- }
- }
- o.remove("list");
- o.put("list",resList);
- }
- res.data(o);
- return res;
- }
- /**
- * 批量导入回款模版
- *
- */
- @RequestMapping(value = "/downloadPovertyTemplate", method = RequestMethod.GET)
- public void downloadTemplate(HttpServletResponse response) {
- StringBuilder url= new StringBuilder(uploadPath);
- url.append("/tmp").append("/poverty_template.xls");
- try {
- response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
- FileUtils.setAttachmentResponseHeader(response, url.toString(),"poverty导入模版.xls");
- FileUtils.writeBytes(url.toString(), response.getOutputStream());
- }
- catch (Exception e) {
- LoggerUtils.error(PublicController.class,"下载文件失败", e);
- }
- }
- /**
- * 查询贫困信息
- */
- @RequestMapping("/selectFlag")
- public Result selectFlag(@RequestParam(value = "file", required = false) MultipartFile file) {
- Result res=new Result();
- //判断文件是否存在
- if(null == file){
- res.getError().add(buildError("文件不存在!","文件不存在!"));
- return res;
- }
- String fileName = file.getOriginalFilename();
- if (!fileName.matches("^.+\\.(?i)(xls)$") && !fileName.matches("^.+\\.(?i)(xlsx)$")) {
- res.getError().add(buildError("格式不正确","格式不正确"));
- return res;
- }
- String id = jdbcIdGenerator.generateId().toString();
- Map<String, Object> map = povertyService.selectFlag(file, id);
- List<OutPovertyFlag> falseList = (List<OutPovertyFlag>) map.get("falseList");
- List<OutPovertyFlag> list = (List<OutPovertyFlag>) map.get("trueList");
- list.addAll(falseList);
- map.put("list",list);
- map.remove("falseList");
- map.remove("trueList");
- res.data(map);
- return res;
- }
- /**
- * 查询贫困信息
- * @param id 贫困信息编号
- * @param type 0=所有 ,1=只看有效数据
- */
- @RequestMapping("/selectPovertyFlagById")
- public Result selectPovertyFlagById(String id,Integer type) {
- Result res =new Result();
- Map<String,Object> map = povertyService.selectFlag(null, id);
- if (type==null)type=0;
- if (type==1){
- map.put("list",map.get("trueList"));
- }else {
- map.put("list",map.get("falseList"));
- }
- map.remove("trueList");
- map.remove("falseList");
- return res.data(map);
- }
- /**
- * 查询贫困信息
- * @param id 贫困信息编号
- * @param type 0=所有 ,1=只看有效数据
- */
- @RequestMapping("/selectPovertyFlagById/export")
- public Result selectPovertyFlagByIdExport(String id,Integer type) {
- Map<String,Object> map = povertyService.selectFlag(null, id);
- if (type==null)type=0;
- List<OutPovertyFlag> resList=new ArrayList<>();
- if (type==1){
- map.put("list",map.get("trueList"));
- }else {
- map.put("list",map.get("falseList"));
- }
- map.remove("trueList");
- map.remove("falseList");
- NewExcelUtil<OutPovertyFlag> newExcelUtil=new NewExcelUtil<>(OutPovertyFlag.class);
- return newExcelUtil.exportExcel(resList,"全国贫困信息表",uploadPath);
- }
- @RequestMapping("/pushStatistics3")
- public Result pushStatistics (){
- Result res =new Result();
- res.data(adminService.pushStatistics());
- return res;
- }
- /**
- * 处理催款节点详情
- */
- @RequestMapping(value = "/pushDunNodeContent",method = RequestMethod.GET)
- @ResponseBody
- public Result pushDunNodeContent(){
- Result res =new Result();
- orderNewService.pushDunNodeContent();
- res.data("ok");
- return res;
- }
- /**
- * 处理项目完成时间
- */
- @RequestMapping(value = "/pushProjectCompleteDate",method = RequestMethod.GET)
- @ResponseBody
- public Result pushProjectCompleteDate(){
- Result res =new Result();
- orderProjectService.pushProjectCompleteDate();
- res.data("ok");
- return res;
- }
- /**
- * 处理订单最大公出小时
- */
- @RequestMapping(value = "/pushOrderMaxDuration",method = RequestMethod.GET)
- @ResponseBody
- public Result pushOrderMaxDuration(){
- Result res =new Result();
- orderNewService.pushOrderMaxDuration();
- res.data("ok");
- return res;
- }
- /**
- * 呼叫完成回调
- *
- */
- @PostMapping("/callCompleted")
- @ResponseBody
- public Result callCompleted(@RequestBody InputCallCompleter in) {
- System.out.println(in);
- return new Result<>().data(userOutboundService.pushCallCompleted(in));
- }
- // /**
- // * OCR识别
- // */
- // @PostMapping("/OCR")
- // @ResponseBody
- // public Result ImageOCR(@RequestParam(value = "file", required = false) MultipartFile file) {
- //
- // return new Result<>().data(imageService.ImageOCR(file));
- // }
- }
|