| | |
| | | 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; |
| | |
| | | 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 = PropertiesUtil.getString(AppConstance.FILES_TORAGE_PATH); |
| | | |
| | | File saveFile = new File(dirPath + "/" + fileName); |
| | | file.transferTo(saveFile); |
| | |
| | | |
| | | List<ExcelSheetPO> excelSheetPOList = ExcelUtil.readExcel(saveFile, null, null); |
| | | |
| | | /* |
| | | |
| | | //项目资料导入 |
| | | List<List<Object>> dataList = excelSheetPOList.get(0).getDataList(); |
| | | List<SysProjUse> projUseList = new ArrayList<>(); |
| | |
| | | //套餐资料导入=======end=== |
| | | |
| | | |
| | | */ |
| | | //充值卡资料导入 |
| | | List<List<Object>> cardList = excelSheetPOList.get(2).getDataList(); |
| | | List<MoneyCardUse> cardUseArrayList = new ArrayList<>(); |
| | |
| | | Object tel = objects.get(1); |
| | | if (tel != null) { |
| | | String telStr = tel.toString(); |
| | | SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr); |
| | | SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr,sysUsers.getCompanyId()); |
| | | if (vipInfo == null) { |
| | | vipInfo = new SysVipInfo(); |
| | | vipInfo.setShopId(sysUsers.getShopId()); |
| | |
| | | Object tel = objects.get(1); |
| | | if (tel != null) { |
| | | String telStr = tel.toString(); |
| | | SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr); |
| | | SysVipInfo vipInfo = vipInfoDao.selectByPhone(telStr,sysUsers.getCompanyId()); |
| | | if (vipInfo == null) { |
| | | vipInfo = new SysVipInfo(); |
| | | vipInfo.setShopId(sysUsers.getShopId()); |
| | |
| | | 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()); |