| | |
| | | package com.chinaztt.mes.basic.service.impl; |
| | | |
| | | import cn.hutool.core.collection.CollectionUtil; |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.toolkit.StringUtils; |
| | | import com.baomidou.mybatisplus.core.toolkit.Wrappers; |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.baomidou.mybatisplus.extension.toolkit.SqlHelper; |
| | | import com.chinaztt.mes.basic.entity.*; |
| | | import com.chinaztt.mes.basic.entity.Company; |
| | | import com.chinaztt.mes.basic.entity.Division; |
| | | import com.chinaztt.mes.basic.entity.Factory; |
| | | import com.chinaztt.mes.basic.entity.Post; |
| | | import com.chinaztt.mes.basic.excel.PostData; |
| | | import com.chinaztt.mes.basic.excel.StaffData; |
| | | import com.chinaztt.mes.basic.mapper.CompanyMapper; |
| | | import com.chinaztt.mes.basic.mapper.DivisionMapper; |
| | | import com.chinaztt.mes.basic.mapper.FactoryMapper; |
| | |
| | | import org.springframework.transaction.annotation.Transactional; |
| | | |
| | | import java.util.List; |
| | | import java.util.Objects; |
| | | |
| | | /** |
| | | * 岗位表 |
| | |
| | | List<Factory> factories = factoryMapper.selectList(null); |
| | | List<Division> divisions = divisionMapper.selectList(null); |
| | | for (PostData data : list) { |
| | | QueryWrapper<Post>QueryWrapper = new QueryWrapper<>(); |
| | | QueryWrapper.lambda().eq(Post::getPostNo,data.getPostNo()); |
| | | Post post1 = baseMapper.selectOne(QueryWrapper); |
| | | if(!Objects.isNull(post1)){ |
| | | log.error("岗位编号重复=====》"+data.getPostNo()); |
| | | continue; |
| | | } |
| | | Post post = new Post(); |
| | | BeanUtils.copyProperties(data, post); |
| | | post.setPostName(data.getWorkShops()+"-"+data.getPostName()); |
| | | //TODO: data.getDivisionName()+"-"+ 岗位组合 部门+岗位 |
| | | post.setPostName(data.getPostName()); |
| | | for (int i = 0; i <companies.size() ; i++) { |
| | | if (companies.get(i).getCompanyName().equals(data.getCompanyName())){ |
| | | post.setCompanyId(companies.get(i).getId()); |