From 0940d5f4527735be64f2151a2d95c8bf1dc4d64e Mon Sep 17 00:00:00 2001 From: 姜友瑶 <935090232@qq.com> Date: Thu, 05 May 2022 07:34:52 +0800 Subject: [PATCH] fix:添加跟进记录服务端查询接口 --- zq-erp/src/main/java/com/matrix/system/hive/action/ProjUseController.java | 45 ++++++++++++++++++++++++++++----------------- 1 files changed, 28 insertions(+), 17 deletions(-) diff --git a/zq-erp/src/main/java/com/matrix/system/hive/action/ProjUseController.java b/zq-erp/src/main/java/com/matrix/system/hive/action/ProjUseController.java index 29c757c..6921eb5 100644 --- a/zq-erp/src/main/java/com/matrix/system/hive/action/ProjUseController.java +++ b/zq-erp/src/main/java/com/matrix/system/hive/action/ProjUseController.java @@ -1,27 +1,26 @@ package com.matrix.system.hive.action; +import cn.hutool.core.util.StrUtil; import com.matrix.core.constance.MatrixConstance; import com.matrix.core.exception.GlobleException; import com.matrix.core.pojo.AjaxResult; import com.matrix.core.pojo.PaginationVO; -import com.matrix.core.tools.DateUtil; -import com.matrix.core.tools.LogUtil; -import com.matrix.core.tools.StringUtils; -import com.matrix.core.tools.WebUtil; +import com.matrix.core.tools.*; import com.matrix.core.tools.excl.ExcelSheetPO; import com.matrix.core.tools.excl.ExcelUtil; import com.matrix.system.common.bean.SysUsers; +import com.matrix.system.common.constance.AppConstance; import com.matrix.system.constance.Dictionary; import com.matrix.system.hive.bean.*; import com.matrix.system.hive.dao.MoneyCardUseDao; import com.matrix.system.hive.dao.ShoppingGoodsDao; import com.matrix.system.hive.dao.SysProjUseDao; import com.matrix.system.hive.dao.SysVipInfoDao; -import com.matrix.system.hive.plugin.message.StringUtil; import com.matrix.system.hive.plugin.util.CollectionUtils; import com.matrix.system.hive.service.MoneyCardUseService; import com.matrix.system.hive.service.SysProjUseService; import com.matrix.system.hive.service.SysProjuseFreezeService; +import jodd.util.StringUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Controller; @@ -237,6 +236,8 @@ } + @Value("${file_storage_path}") + private String fileStoragePath; @@ -246,17 +247,24 @@ public AjaxResult importVipInfo(HttpServletResponse response, HttpServletRequest request, @RequestParam(value = "file", required = false) MultipartFile file) throws IOException { String fileName = file.getOriginalFilename(); - String dirPath = "E:"; - //PropertiesUtil.getString(AppConstance.FILES_TORAGE_PATH); +// String dirPath = "E:"; + String dirPath = fileStoragePath; - File saveFile = new File(dirPath + "/" + fileName); - file.transferTo(saveFile); + File saveFile =new File (new File(dirPath).getAbsolutePath() + File.separator + fileName); + if (!saveFile.exists()) + { + if (!saveFile.getParentFile().exists()) + { + saveFile.getParentFile().mkdirs(); + } + } + file.transferTo(saveFile.getAbsoluteFile()); SysUsers sysUsers = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY); List<ExcelSheetPO> excelSheetPOList = ExcelUtil.readExcel(saveFile, null, null); -/* + //项目资料导入 List<List<Object>> dataList = excelSheetPOList.get(0).getDataList(); List<SysProjUse> projUseList = new ArrayList<>(); @@ -281,7 +289,7 @@ List<Object> objects = taocanDataList.get(j); LogUtil.info("导入套餐第" + j + "行" + objects); Object vipName = objects.get(0); - String vipNameStr = vipName.toString(); + String vipNameStr = vipName==null?"":vipName.toString(); if (taocan == null || (taocan != null && StringUtils.isNotBlank(vipNameStr))) { //切换下一个套餐 @@ -300,7 +308,6 @@ //套餐资料导入=======end=== -*/ //充值卡资料导入 List<List<Object>> cardList = excelSheetPOList.get(2).getDataList(); List<MoneyCardUse> cardUseArrayList = new ArrayList<>(); @@ -323,7 +330,7 @@ Object tel = objects.get(1); if (tel != null) { String telStr = tel.toString(); - SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr); + SysVipInfo vipInfo = vipInfoDao.selectByPhone(StrUtil.trim(telStr),sysUsers.getCompanyId()); if (vipInfo == null) { vipInfo = new SysVipInfo(); vipInfo.setShopId(sysUsers.getShopId()); @@ -380,7 +387,7 @@ Object tel = objects.get(1); if (tel != null) { String telStr = tel.toString(); - SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr); + SysVipInfo vipInfo = vipInfoDao.selectByPhone(StrUtil.trim(telStr),sysUsers.getCompanyId()); if (vipInfo == null) { vipInfo = new SysVipInfo(); vipInfo.setShopId(sysUsers.getShopId()); @@ -390,10 +397,14 @@ vipInfoDao.insert(vipInfo); } String goodNo = String.valueOf(objects.get(3)); - String goodName = String.valueOf(objects.get(2)).trim(); - - ShoppingGoods goods = shoppingGoodsDao.findByCode(goodNo); + + String goodName = String.valueOf(objects.get(2)).trim(); + if("储值卡".equals(goodName)){ + goods= shoppingGoodsDao.selectVipCzGoods(); + } + + if (goods != null || "储值卡".equals(goodName)) { moneyCardUse.setVipId(vipInfo.getId()); -- Gitblit v1.9.1