| | |
| | | import com.panzhihua.service_community.model.dos.ComMngVolunteerMngDO; |
| | | import com.panzhihua.service_community.service.ComMngVolunteerMngService; |
| | | |
| | | import static java.util.Objects.nonNull; |
| | | |
| | | /** |
| | | * @program: springcloud_k8s_panzhihuazhihuishequ |
| | | * @description: 志愿者 |
| | |
| | | ComMngVolunteerOrgTeam orgVo = comMngVolunteerOrgTeamMapper.selectOne(new QueryWrapper<ComMngVolunteerOrgTeam>().lambda() |
| | | .eq(ComMngVolunteerOrgTeam::getName,excel.getOrgName()).eq(ComMngVolunteerOrgTeam::getCommunityId,communityId) |
| | | .eq(ComMngVolunteerOrgTeam::getParentId,0)); |
| | | if(orgVo == null){ |
| | | ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | BeanUtils.copyProperties(excel,errorExcelVO); |
| | | errorExcelVO.setError("该志愿者组织不存在,请先通过后台添加该志愿者组织"); |
| | | errorList.add(errorExcelVO); |
| | | continue; |
| | | } |
| | | // if(orgVo == null){ |
| | | // ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | // BeanUtils.copyProperties(excel,errorExcelVO); |
| | | // errorExcelVO.setError("该志愿者组织不存在,请先通过后台添加该志愿者组织"); |
| | | // errorList.add(errorExcelVO); |
| | | // continue; |
| | | // } |
| | | //查询队伍 |
| | | ComMngVolunteerOrgTeam teamVo = comMngVolunteerOrgTeamMapper.selectOne(new QueryWrapper<ComMngVolunteerOrgTeam>().lambda() |
| | | .eq(ComMngVolunteerOrgTeam::getName,excel.getTeamName()).eq(ComMngVolunteerOrgTeam::getCommunityId,communityId) |
| | | .eq(ComMngVolunteerOrgTeam::getParentId,orgVo.getId())); |
| | | if(teamVo == null){ |
| | | ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | BeanUtils.copyProperties(excel,errorExcelVO); |
| | | errorExcelVO.setError("该志愿者队伍不存在,请先通过后台添加该志愿者队伍"); |
| | | errorList.add(errorExcelVO); |
| | | continue; |
| | | } |
| | | .eq(ComMngVolunteerOrgTeam::getParentId, nonNull(orgVo) ? orgVo.getId() : null)); |
| | | // if(teamVo == null){ |
| | | // ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | // BeanUtils.copyProperties(excel,errorExcelVO); |
| | | // errorExcelVO.setError("该志愿者队伍不存在,请先通过后台添加该志愿者队伍"); |
| | | // errorList.add(errorExcelVO); |
| | | // continue; |
| | | // } |
| | | //查询技能 |
| | | ComMngVolunteerSkill skillVo = comMngVolunteerSkillMapper.selectOne(new QueryWrapper<ComMngVolunteerSkill>().lambda() |
| | | .eq(ComMngVolunteerSkill::getName,excel.getSkillName()).eq(ComMngVolunteerSkill::getCommunityId,communityId)); |
| | | if(skillVo == null){ |
| | | ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | BeanUtils.copyProperties(excel,errorExcelVO); |
| | | errorExcelVO.setError("该志愿者技能不存在,请先通过后台添加该志愿者技能"); |
| | | errorList.add(errorExcelVO); |
| | | continue; |
| | | } |
| | | // if(skillVo == null){ |
| | | // ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | | // BeanUtils.copyProperties(excel,errorExcelVO); |
| | | // errorExcelVO.setError("该志愿者技能不存在,请先通过后台添加该志愿者技能"); |
| | | // errorList.add(errorExcelVO); |
| | | // continue; |
| | | // } |
| | | Date nowDate = new Date(); |
| | | ComMngVolunteerMngDO comMngVolunteerMngDO = comMngVolunteerMngDAO.selectOne(new QueryWrapper<ComMngVolunteerMngDO>().lambda() |
| | | .eq(ComMngVolunteerMngDO::getIdCard,excel.getIdCard()).in(ComMngVolunteerMngDO::getState,1,2)); |
| | |
| | | if(comMngVolunteerMngDO.getState().equals(1)){ |
| | | BeanUtils.copyProperties(excel,comMngVolunteerMngDO); |
| | | comMngVolunteerMngDO.setState(2); |
| | | comMngVolunteerMngDO.setOrgId(orgVo.getId()); |
| | | comMngVolunteerMngDO.setTeamId(teamVo.getId()); |
| | | comMngVolunteerMngDO.setSkillId(skillVo.getId()); |
| | | comMngVolunteerMngDO.setOrgId(nonNull(orgVo) ? orgVo.getId() : null); |
| | | comMngVolunteerMngDO.setTeamId(nonNull(teamVo) ? teamVo.getId() : null); |
| | | comMngVolunteerMngDO.setSkillId(nonNull(skillVo) ? skillVo.getId() : null); |
| | | comMngVolunteerMngDAO.updateById(comMngVolunteerMngDO); |
| | | }else{ |
| | | ComMngVolunteerErrorExcelVO errorExcelVO = new ComMngVolunteerErrorExcelVO(); |
| | |
| | | BeanUtils.copyProperties(excel,comMngVolunteerMngDO); |
| | | comMngVolunteerMngDO.setCommunityId(communityId); |
| | | comMngVolunteerMngDO.setState(2); |
| | | comMngVolunteerMngDO.setOrgId(orgVo.getId()); |
| | | comMngVolunteerMngDO.setTeamId(teamVo.getId()); |
| | | comMngVolunteerMngDO.setSkillId(skillVo.getId()); |
| | | comMngVolunteerMngDO.setOrgId(nonNull(orgVo) ? orgVo.getId() : null); |
| | | comMngVolunteerMngDO.setTeamId(nonNull(teamVo) ? teamVo.getId() : null); |
| | | comMngVolunteerMngDO.setSkillId(nonNull(skillVo) ? skillVo.getId() : null); |
| | | comMngVolunteerMngDO.setCreateAt(nowDate); |
| | | //查询用户id,如果存在则需要绑定 |
| | | Long volunteerUserId = comMngVolunteerMngDAO.selectUserIdByIdCard(excel.getIdCard()); |