ltkj_peis.git - gitblit

			@@ -45,6 +45,7 @@
			import org.springframework.beans.factory.annotation.Autowired;
			import org.springframework.beans.factory.annotation.Value;
			import org.springframework.security.access.prepost.PreAuthorize;
			import org.springframework.transaction.NoTransactionException;
			import org.springframework.transaction.annotation.Transactional;
			import org.springframework.transaction.interceptor.TransactionAspectSupport;
			import org.springframework.web.bind.annotation.*;
			@@ -95,6 +96,12 @@
			private ISysDictDataService dictDataService;
			@Autowired
			private ISysConfigService configService;
			@Autowired
			private IDictCompService dictCompService;
			@Autowired
			private ITjDwDeptService tjDwDeptService;
			@Autowired
			private ITjDwGroupingService tjDwGroupingService;

			@Value("${path.filePath}")
			private String value;
			@@ -103,56 +110,61 @@
			@ApiOperation(value = "导出excel表模板")
			public void importTemplate(HttpServletResponse response) {
			//原来的下载模板调用接口
			String base64String = PDFBinaryUtil.getPDFBinary(configService.selectConfigByKey("default_excelTemplate"));
			if (null != base64String) {
			PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + File.separator + "团体预约Excel模版.xls");
			String filePath = value + File.separator + "团体预约Excel模版.xls";
			File f = new File(filePath);
			BufferedInputStream br = null;
			OutputStream out = null;
			FileInputStream fileInputStream = null;
			try {
			fileInputStream = new FileInputStream(f);
			br = new BufferedInputStream(fileInputStream);
			byte[] bs = new byte[1024];
			int len = 0;
			response.reset(); // 非常重要
			if (true) {
			// 在线打开方式
			URL u = new URL("file:///" + filePath);
			//System.out.println(u);
			String contentType = u.openConnection().getContentType();
			response.setContentType(contentType);
			response.setHeader("Content-Disposition", "inline;filename=团体预约Excel模版.xls");
			} else {
			// 纯下载方式
			response.setContentType("application/x-msdownload");
			response.setContentType("application/pdf;charset=utf-8");
			response.setHeader("Content-Disposition", "attachment;filename=团体预约Excel模版.xls");
			}
			out = response.getOutputStream();
			while ((len = br.read(bs)) > 0) {
			out.write(bs, 0, len);
			}
			out.flush();
			out.close();
			br.close();
			fileInputStream.close();
			} catch (IOException e) {
			e.printStackTrace();
			//System.out.println("pdf处理文件异常" + e);
			} finally {
			if (out != null) {
			try {
			out.close();
			br.close();
			fileInputStream.close();
			try {
			String base64String = PDFBinaryUtil.getPDFBinary(value + File.separator + "西安路泰机电科技有限公司.xls");
			if (null != base64String) {
			PDFBinaryUtil.base64StringToPDF(base64String, FileUtil.mkdir(value).getPath() + File.separator + "团体预约Excel模版.xls");
			String filePath = value + File.separator + "团体预约Excel模版.xls";
			File f = new File(filePath);
			BufferedInputStream br = null;
			OutputStream out = null;
			FileInputStream fileInputStream = null;
			try {
			fileInputStream = new FileInputStream(f);
			br = new BufferedInputStream(fileInputStream);
			byte[] bs = new byte[1024];
			int len = 0;
			response.reset(); // 非常重要
			if (true) {
			// 在线打开方式
			URL u = new URL("file:///" + filePath);
			//System.out.println(u);
			String contentType = u.openConnection().getContentType();
			response.setContentType(contentType);
			response.setHeader("Content-Disposition", "inline;filename=团体预约Excel模版.xls");
			} else {
			// 纯下载方式
			response.setContentType("application/x-msdownload");
			response.setContentType("application/pdf;charset=utf-8");
			response.setHeader("Content-Disposition", "attachment;filename=团体预约Excel模版.xls");
			}
			out = response.getOutputStream();
			while ((len = br.read(bs)) > 0) {
			out.write(bs, 0, len);
			}
			out.flush();
			out.close();
			br.close();
			fileInputStream.close();
			} catch (IOException e) {
			e.printStackTrace();
			//System.out.println("pdf处理文件异常" + e);
			} finally {
			if (out != null) {
			try {
			out.close();
			br.close();
			fileInputStream.close();

			} catch (IOException e) {
			e.printStackTrace();
			} catch (IOException e) {
			e.printStackTrace();
			}
			}
			}
			}
			} catch (Exception e) {
			ExcelUtils.exportTemplate(response,"团体预约Excel模版",TjReservation.class);
			throw new RuntimeException(e);
			}
			}

			@@ -270,7 +282,11 @@
			//年龄
			tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
			//出生日期
			tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
			try {
			tjReservation.setBirthday(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()));
			} catch (Exception e) {
			return AjaxResult.error("身份证号不正确");
			}

			if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex()))) {

			@@ -380,40 +396,43 @@
			return AjaxResult.error("分组信息有误请重新分组!");
			}

			String sfjysfzh = configService.selectConfigByKey("sfjysfzh");
			String sfjysjh = configService.selectConfigByKey("sfjysjh");
			try {
			String sfjysfzh = configService.selectConfigByKey("sfjysfzh");
			String sfjysjh = configService.selectConfigByKey("sfjysjh");

			//计算合计
			BigDecimal hjMoney = new BigDecimal("0.00");
			//男组金额
			BigDecimal manMoney = new BigDecimal("0.00");
			//女组金额
			BigDecimal woManMoney = new BigDecimal("0.00");
			int count = 0;//总计人数
			int manCount = 0;//男组人数
			int woManCount = 0;//女组人数
			List<String> ids=new ArrayList<>();
			//计算合计
			BigDecimal hjMoney = new BigDecimal("0.00");
			//男组金额
			BigDecimal manMoney = new BigDecimal("0.00");
			//女组金额
			BigDecimal woManMoney = new BigDecimal("0.00");
			int count = 0;//总计人数
			int manCount = 0;//男组人数
			int woManCount = 0;//女组人数
			List<String> ids=new ArrayList<>();

			for (TjReservation tjReservation : tjReservations) {
			String idCard = tjReservation.getIdCard();
			String phoe = tjReservation.getPhoe();
			idCard= idCard.replaceAll("[',，;.。 ‘“]","");
			String errMsg="";
			for (TjReservation tjReservation : tjReservations) {
			String idCard = tjReservation.getIdCard();
			String phoe = tjReservation.getPhoe();
			idCard= idCard.replaceAll("[',，;.。 ‘“]","");

			if (!StringUtils.isBlank(idCard) \|\| !StringUtils.isBlank(phoe) \|\| null != tjReservation.getDwxm()) {
			//将科学计数的手机号转换成文本形式
			phoe = MatchUtils.translateToPlainStr(tjReservation.getPhoe());
			if (!StringUtils.isBlank(idCard) \|\| !StringUtils.isBlank(phoe) \|\| null != tjReservation.getDwxm()) {
			//将科学计数的手机号转换成文本形式
			phoe = MatchUtils.translateToPlainStr(tjReservation.getPhoe());

			if(!ids.isEmpty() && ids.contains(tjReservation.getIdCard())){
			TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
			return AjaxResult.error("此身份证号: "+tjReservation.getIdCard()+" 重复,请核对后上传!");
			}
			if(!ids.isEmpty() && ids.contains(tjReservation.getIdCard())){
			TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
			return AjaxResult.error("此身份证号: "+tjReservation.getIdCard()+" 重复,请核对后上传!");
			}

			ids.add(tjReservation.getIdCard());
			ids.add(tjReservation.getIdCard());

			// if (sfjysfzh.equalsIgnoreCase("Y") \|\| sfjysjh.equalsIgnoreCase("Y")) {
			// if (sfjysfzh.equalsIgnoreCase("Y") \|\| sfjysjh.equalsIgnoreCase("Y")) {
			if ((sfjysfzh.equalsIgnoreCase("Y") && !MatchUtils.isIdCard(idCard)) \|\|
			(sfjysjh.equalsIgnoreCase("Y") && !MatchUtils.isMobileNO(phoe))) {
			wrongList.add(tjReservation.getName());
			errMsg="身份证号/手机号格式不准确";
			log.info(tjReservation.getName()+idCard+MatchUtils.isIdCard(idCard)+MatchUtils.isMobileNO(phoe));
			}else {

			@@ -423,9 +442,13 @@
			//年龄
			tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
			//出生日期
			tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
			try {
			tjReservation.setBirthday(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()));
			} catch (Exception e) {
			return AjaxResult.error("身份证号不正确");
			}

			TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm()));
			TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm().trim()));
			if (null != dwDept) {
			for (TjDwGrouping groupingMan : groupingMans) {
			if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
			@@ -482,102 +505,109 @@
			rightList.add(tjReservation);
			} else {
			wrongList.add(tjReservation.getName());
			errMsg="所选项目名不正确";
			}
			}
			// }
			// else {
			// //将科学计数的手机号转换成文本形式
			// String str = MatchUtils.translateToPlainStr(tjReservation.getPhoe());
			// tjReservation.setPhoe(str);
			//
			// //年龄
			// tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
			// //出生日期
			// tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
			//
			// TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm()));
			// if (null != dwDept) {
			// for (TjDwGrouping groupingMan : groupingMans) {
			// if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingMan.getId());
			// tjReservation.setGroupingName(groupingMan.getGroupingName());
			// tjReservation.setYsPrice(groupingMan.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingMan.getYsPrice());
			// count += 1;
			// //男组人数
			// manMoney = manMoney.add(groupingMan.getYsPrice());
			// manCount += 1;
			// }
			// }
			//
			// for (TjDwGrouping groupingWoMan : groupingWoMans) {
			// if (null != groupingWoMan && groupingWoMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingWoMan.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingWoMan.getId());
			// tjReservation.setGroupingName(groupingWoMan.getGroupingName());
			// tjReservation.setYsPrice(groupingWoMan.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingWoMan.getYsPrice());
			// count += 1;
			// woManMoney = woManMoney.add(groupingWoMan.getYsPrice());
			// woManCount += 1;
			// }
			// }
			// for (TjDwGrouping groupingWz : groupingWzs) {
			// if (null != groupingWz && groupingWz.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingWz.getId());
			// tjReservation.setGroupingName(groupingWz.getGroupingName());
			// tjReservation.setYsPrice(groupingWz.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingWz.getYsPrice());
			// count += 1;
			// if (tjReservation.getSex() == 0) {
			// manMoney = manMoney.add(groupingWz.getYsPrice());
			// manCount += 1;
			// }
			// if (tjReservation.getSex() == 1) {
			// woManMoney = woManMoney.add(groupingWz.getYsPrice());
			// woManCount += 1;
			// }
			//
			// }
			// }
			// LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
			// wq.eq(TjReservation::getIdCard, tjReservation.getIdCard());
			// wq.eq(TjReservation::getIsExpire, 2);
			// TjReservation one = tjReservationService.getOne(wq);
			// if (null != one) {
			// yyList.add(one);
			// }
			// rightList.add(tjReservation);
			// } else {
			// wrongList.add(tjReservation.getName());
			// }
			// }
			// }
			// else {
			// //将科学计数的手机号转换成文本形式
			// String str = MatchUtils.translateToPlainStr(tjReservation.getPhoe());
			// tjReservation.setPhoe(str);
			//
			// //年龄
			// tjReservation.setAge(String.valueOf(MatchUtils.getAgeByIdCard(tjReservation.getIdCard())));
			// //出生日期
			// tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
			//
			// TjDwDept dwDept = dwDeptService.getOne(new LambdaQueryWrapper<TjDwDept>().eq(TjDwDept::getDwDeptName, tjReservation.getDwxm()));
			// if (null != dwDept) {
			// for (TjDwGrouping groupingMan : groupingMans) {
			// if (null != groupingMan && groupingMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingMan.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingMan.getId());
			// tjReservation.setGroupingName(groupingMan.getGroupingName());
			// tjReservation.setYsPrice(groupingMan.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingMan.getYsPrice());
			// count += 1;
			// //男组人数
			// manMoney = manMoney.add(groupingMan.getYsPrice());
			// manCount += 1;
			// }
			// }
			//
			// for (TjDwGrouping groupingWoMan : groupingWoMans) {
			// if (null != groupingWoMan && groupingWoMan.getSex().equals(String.valueOf(tjReservation.getSex())) && groupingWoMan.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingWoMan.getId());
			// tjReservation.setGroupingName(groupingWoMan.getGroupingName());
			// tjReservation.setYsPrice(groupingWoMan.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingWoMan.getYsPrice());
			// count += 1;
			// woManMoney = woManMoney.add(groupingWoMan.getYsPrice());
			// woManCount += 1;
			// }
			// }
			// for (TjDwGrouping groupingWz : groupingWzs) {
			// if (null != groupingWz && groupingWz.getDwDeptId().equals(dwDept.getId())) {
			// tjReservation.setGroupingId(groupingWz.getId());
			// tjReservation.setGroupingName(groupingWz.getGroupingName());
			// tjReservation.setYsPrice(groupingWz.getYsPrice());
			// //合计
			// hjMoney = hjMoney.add(groupingWz.getYsPrice());
			// count += 1;
			// if (tjReservation.getSex() == 0) {
			// manMoney = manMoney.add(groupingWz.getYsPrice());
			// manCount += 1;
			// }
			// if (tjReservation.getSex() == 1) {
			// woManMoney = woManMoney.add(groupingWz.getYsPrice());
			// woManCount += 1;
			// }
			//
			// }
			// }
			// LambdaQueryWrapper<TjReservation> wq = new LambdaQueryWrapper<>();
			// wq.eq(TjReservation::getIdCard, tjReservation.getIdCard());
			// wq.eq(TjReservation::getIsExpire, 2);
			// TjReservation one = tjReservationService.getOne(wq);
			// if (null != one) {
			// yyList.add(one);
			// }
			// rightList.add(tjReservation);
			// } else {
			// wrongList.add(tjReservation.getName());
			// }
			// }

			} else {
			wrongList.add(tjReservation.getName());
			} else {
			wrongList.add(tjReservation.getName());
			errMsg="身份证号/手机号/项目名为空";
			}
			}
			}
			if (!yyList.isEmpty()) {
			map.put("list", yyList);
			map.put("hjMoney", hjMoney);
			return AjaxResult.error("操作失败,以上人员已经预约无需导入!!!", map);
			}
			if (!yyList.isEmpty()) {
			map.put("list", yyList);
			map.put("hjMoney", hjMoney);
			return AjaxResult.error("操作失败,以上人员已经预约无需导入!!!", map);
			}

			if (!wrongList.isEmpty()) {
			map.put("list", wrongList);
			map.put("hjMoney", hjMoney);
			return AjaxResult.error("操作失败, 请认真核对信息后重新导入!!!", map);
			} else {
			map.put("list", rightList);
			map.put("count", count);
			map.put("hjMoney", hjMoney);
			map.put("manCount", manCount);
			map.put("manMoney", manMoney);
			map.put("woManCount", woManCount);
			map.put("woManMoney", woManMoney);
			return AjaxResult.success("操作成功", map);
			if (!wrongList.isEmpty()) {
			map.put("list", wrongList);
			map.put("hjMoney", hjMoney);
			return AjaxResult.error("操作失败, 请认真核对信息后重新导入!!!"+errMsg, map);
			} else {
			map.put("list", rightList);
			map.put("count", count);
			map.put("hjMoney", hjMoney);
			map.put("manCount", manCount);
			map.put("manMoney", manMoney);
			map.put("woManCount", woManCount);
			map.put("woManMoney", woManMoney);
			return AjaxResult.success("操作成功", map);
			}
			} catch (NoTransactionException e) {
			// throw new RuntimeException(e);
			log.error(String.valueOf(e),e.getMessage());
			return AjaxResult.error();
			}
			}

			@@ -610,7 +640,7 @@
			if (null != reservation) return AjaxResult.success("您已成功预约,无需再约");
			//tjReservation.setAge(MatchUtils.getAgeByIdCard(tjReservation.getIdCard()));
			try {
			tjReservation.setBirthday(DateUtil.parse(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()), "yyyy-MM-dd"));
			tjReservation.setBirthday(MatchUtils.getBirthDayByIdCard(tjReservation.getIdCard()));
			} catch (Exception e) {
			e.printStackTrace();
			}
			@@ -743,11 +773,11 @@
			LambdaQueryWrapper<TjGroupingPro> wq = new LambdaQueryWrapper<>();
			wq.eq(TjGroupingPro::getGroupingId, groupingId);
			List<TjGroupingPro> proList = groupingProService.list(wq);
			if (null != proList && proList.size() > 0) {
			if (null != proList && !proList.isEmpty()) {
			for (TjGroupingPro groupingPro : proList) {
			TjProject project = projectService.getById(groupingPro.getProId());
			if (null != project) {
			if (project.getProType() == null \|\| project.getProType().equals("")) {
			if (project.getProType() == null \|\| project.getProType().isEmpty()) {
			groupingPro.setProType("2");
			} else {
			groupingPro.setProType(project.getProType());
			@@ -947,7 +977,7 @@
			}


			reservation.setPacId(dwDept.getId());
			reservation.setPacId(dwGrouping.getId());
			compPay = compPay.add(dwGrouping.getYsPrice());
			// reservation.setTjType(String.valueOf(1));
			reservation.setTeamNo(teamNo);
			@@ -1014,4 +1044,46 @@
			return AjaxResult.error("请选择预约对象");
			}

			/**
			* 团体预约体检信息联动下拉框
			* @param pid
			* @param type
			* @return
			*/
			@GetMapping("/linkage")
			public String linkage(@RequestParam("pid") String pid, @RequestParam("type") String type) {
			switch (type){
			case "1":
			List<DictComp> list = dictCompService.list();
			List<HashMap<String, Object>> collect = list.stream().map(i -> {
			HashMap<String, Object> hashMap = new HashMap<>();
			hashMap.put("value", i.getDrugManufacturerId());
			hashMap.put("text", i.getCnName());
			return hashMap;
			}).collect(Collectors.toList());
			return JSONUtil.toJsonStr(collect);
			case "2":
			List<TjDwDept> list1 = tjDwDeptService.getDwDeptListByTjDwDeptId(pid);
			List<HashMap<String, Object>> collect1 = list1.stream().map(i -> {
			HashMap<String, Object> hashMap = new HashMap<>();
			hashMap.put("value", i.getId());
			hashMap.put("text", i.getDwDeptName());
			return hashMap;
			}).collect(Collectors.toList());
			return JSONUtil.toJsonStr(collect1);
			case "3":
			LambdaQueryWrapper<TjDwGrouping> wrapper = new LambdaQueryWrapper<>();
			wrapper.eq(TjDwGrouping::getDwDeptId,pid);
			List<TjDwGrouping> list2 = tjDwGroupingService.list(wrapper);
			List<HashMap<String, Object>> collect2 = list2.stream().map(i -> {
			HashMap<String, Object> hashMap = new HashMap<>();
			hashMap.put("value", i.getId());
			hashMap.put("text", i.getGroupingName());
			return hashMap;
			}).collect(Collectors.toList());
			return JSONUtil.toJsonStr(collect2);
			}
			return null;
			}

			}