CompanyServiceImpl.java 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433
  1. package com.hssx.cloudmodel.service.impl;
  2. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  3. import com.github.pagehelper.PageHelper;
  4. import com.github.pagehelper.PageInfo;
  5. import com.hssx.cloudmodel.constant.Constant;
  6. import com.hssx.cloudmodel.entity.*;
  7. import com.hssx.cloudmodel.entity.vo.CompanyVO;
  8. import com.hssx.cloudmodel.entity.vo.ProjectVO;
  9. import com.hssx.cloudmodel.entity.vo.UserVO;
  10. import com.hssx.cloudmodel.mapper.*;
  11. import com.hssx.cloudmodel.service.CompanyService;
  12. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  13. import com.hssx.cloudmodel.util.HttpRespMsg;
  14. import com.hssx.cloudmodel.util.ListUtil;
  15. import com.hssx.cloudmodel.util.PageUtil;
  16. import org.springframework.beans.BeanUtils;
  17. import org.springframework.stereotype.Service;
  18. import javax.annotation.Resource;
  19. import java.util.ArrayList;
  20. import java.util.List;
  21. import java.util.stream.Collectors;
  22. import java.util.stream.Stream;
  23. /**
  24. * <p>
  25. * 服务实现类
  26. * </p>
  27. *
  28. * @author 吴涛涛
  29. * @since 2019-07-26
  30. */
  31. @Service
  32. public class CompanyServiceImpl extends ServiceImpl<CompanyMapper, Company> implements CompanyService {
  33. @Resource
  34. CompanyMapper companyMapper;
  35. @Resource
  36. UserMapper userMapper;
  37. @Resource
  38. LngLatCompanyMapper lngLatCompanyMapper;
  39. @Resource
  40. ProjectMapper projectMapper;
  41. @Resource
  42. MouldMapper mouldMapper;
  43. @Resource
  44. ProjectUserMapper projectUserMapper;
  45. @Resource
  46. ProjectApproveMapper projectApproveMapper;
  47. @Resource
  48. AssetCustomCompanyMapper assetCustomCompanyMapper;
  49. @Resource
  50. CustomCompanyMapper customCompanyMapper;
  51. @Override
  52. public HttpRespMsg addAndUpdateRole(CompanyVO companyVO, Integer flag, String companyIds) {
  53. HttpRespMsg msg = new HttpRespMsg();
  54. Company company = new Company();
  55. if (flag == 0) {
  56. //添加公司
  57. QueryWrapper<Company> qw = new QueryWrapper<>();
  58. qw.eq("company_name", companyVO.getCompanyName());
  59. int count = companyMapper.selectCount(qw);
  60. if (count > 0) {
  61. msg.setError("公司已存在,请勿重复添加");
  62. return msg;
  63. } else {
  64. if (companyVO.getCompanyType() == 0) {
  65. //资产方直接添加
  66. BeanUtils.copyProperties(companyVO, company);
  67. companyMapper.insert(company);
  68. if (companyIds != null && !"".equals(companyIds)) {
  69. List<Integer> ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  70. for (Integer ide : ides) {
  71. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()).eq("custom_id", ide)) == 0) {
  72. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  73. assetCustomCompany.setAssertId(company.getId());
  74. assetCustomCompany.setCustomId(ide);
  75. assetCustomCompanyMapper.insert(assetCustomCompany);
  76. }
  77. }
  78. }
  79. } else if (companyVO.getCompanyType() == 1) {
  80. //生产方
  81. BeanUtils.copyProperties(companyVO, company);
  82. companyMapper.insert(company);
  83. if (companyIds != null && !"".equals(companyIds)) {
  84. List<Integer> ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  85. for (Integer ide : ides) {
  86. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", ide).eq("custom_id", company.getId())) == 0) {
  87. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  88. assetCustomCompany.setAssertId(ide);
  89. assetCustomCompany.setCustomId(company.getId());
  90. assetCustomCompanyMapper.insert(assetCustomCompany);
  91. }
  92. }
  93. }
  94. LngLatCompany factory = new LngLatCompany();
  95. factory.setxLat(companyVO.getXLat());
  96. factory.setyLng(companyVO.getYLng());
  97. factory.setCompanyId(company.getId());
  98. lngLatCompanyMapper.insert(factory);
  99. }
  100. msg.data = company;
  101. }
  102. } else if (flag == 1) {
  103. //更新公司信息
  104. BeanUtils.copyProperties(companyVO, company);
  105. if (companyVO.getCompanyType() == 0) {
  106. //修改资产方
  107. BeanUtils.copyProperties(companyVO, company);
  108. List<AssetCustomCompany> list = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()));
  109. //判断所关联的生产方是否已被应用到项目
  110. List<Integer> cousIds = list.stream().map(AssetCustomCompany::getCustomId).collect(Collectors.toList());
  111. cousIds.add(-1);
  112. List<Integer> noMouldCompanyIds = new ArrayList<>();
  113. noMouldCompanyIds = mouldMapper.selectList(new QueryWrapper<Mould>().in("produce_company_id", cousIds).eq("company_id",company.getId())).stream().map(Mould::getProduceCompanyId).collect(Collectors.toList());
  114. noMouldCompanyIds.add(-1);
  115. List<Integer> ides = new ArrayList<>();
  116. if (companyIds != null && !"".equals(companyIds)) {
  117. ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  118. }
  119. ides.add(-1);
  120. if (!ides.containsAll(noMouldCompanyIds)) {
  121. msg.setError("当前公司所关联的生产方公司中已被用用到项目,不可执行修改操作。");
  122. return msg;
  123. }
  124. //删除之前的关联公司
  125. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()));
  126. if (companyIds != null && !"".equals(companyIds)) {
  127. ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  128. for (Integer ide : ides) {
  129. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()).eq("custom_id", ide)) == 0) {
  130. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  131. assetCustomCompany.setAssertId(company.getId());
  132. assetCustomCompany.setCustomId(ide);
  133. assetCustomCompanyMapper.insert(assetCustomCompany);
  134. }
  135. }
  136. }
  137. companyMapper.updateById(company);
  138. } else if (companyVO.getCompanyType() == 1) {
  139. //生产方
  140. BeanUtils.copyProperties(companyVO, company);
  141. QueryWrapper<LngLatCompany> qw = new QueryWrapper<>();
  142. qw.eq("company_id", companyVO.getId());
  143. LngLatCompany lngLatCompany = lngLatCompanyMapper.selectOne(qw);
  144. LngLatCompany factory = new LngLatCompany();
  145. factory.setxLat(companyVO.getXLat());
  146. factory.setyLng(companyVO.getYLng());
  147. factory.setCompanyId(company.getId());
  148. factory.setId(lngLatCompany.getId());
  149. lngLatCompanyMapper.updateById(factory);
  150. List<AssetCustomCompany> list = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>().eq("custom_id", company.getId()));
  151. //判断所关联的生产方是否已被应用到项目
  152. List<Integer> cousIds = list.stream().map(AssetCustomCompany::getAssertId).collect(Collectors.toList());
  153. cousIds.add(-1);
  154. List<Integer> noMouldCompanyIds = new ArrayList<>();
  155. noMouldCompanyIds = mouldMapper.selectList(new QueryWrapper<Mould>().eq("produce_company_id", company.getId()).in("company_id",cousIds)).stream().map(Mould::getCompanyId).collect(Collectors.toList());
  156. noMouldCompanyIds.add(-1);
  157. List<Integer> ides = new ArrayList<>();
  158. if (companyIds != null && !"".equals(companyIds)) {
  159. ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  160. }
  161. ides.add(-1);
  162. if (!ides.containsAll(noMouldCompanyIds)) {
  163. msg.setError("当前公司所关联的资产方公司已被用用到项目,不可执行修改操作。");
  164. return msg;
  165. }
  166. //删除之前的关联公司
  167. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("custom_id", companyVO.getId()));
  168. if (companyIds != null && !"".equals(companyIds)) {
  169. ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  170. for (Integer ide : ides) {
  171. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()).eq("custom_id", ide)) == 0) {
  172. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  173. assetCustomCompany.setAssertId(ide);
  174. assetCustomCompany.setCustomId(company.getId());
  175. assetCustomCompanyMapper.insert(assetCustomCompany);
  176. }
  177. }
  178. }
  179. companyMapper.updateById(company);
  180. }
  181. msg.data = company;
  182. }
  183. return msg;
  184. }
  185. @Override
  186. public HttpRespMsg pageList(PageUtil page, String keyName, Integer companyType) {
  187. HttpRespMsg msg = new HttpRespMsg();
  188. List<CompanyVO> list = new ArrayList<>();
  189. PageHelper.startPage(page.getPageNum(), page.getPageSize());
  190. list = companyMapper.getCustomerListByKeyName(keyName, companyType);
  191. PageInfo<CompanyVO> pageInfos = new PageInfo<>(list);
  192. msg.data = pageInfos;
  193. return msg;
  194. }
  195. @Override
  196. public List<Company> getIdAndNamelist(User user) {
  197. QueryWrapper<Company> qw = new QueryWrapper<>();
  198. qw.select("id", "company_name", "company_type");
  199. if (Constant.SYS_ID == user.getParentId()) {
  200. //此时是admin创建用户,返回可选的生产方公司,查询出当前admin的信息并获取他的公司id
  201. User admin = userMapper.selectOne(new QueryWrapper<User>().eq("id", user.getId()));
  202. qw.eq("company_type", Constant.PRODUCER_COMPANY).or().eq("id", admin.getCompanyId());
  203. } else if (Constant.SYS_PARENT_ID == user.getParentId()) {
  204. //系统管理员创建admin,返回资产方公司
  205. qw.eq("company_type", Constant.ASSETS_COMPANY);
  206. } else {
  207. //此时是项目经理创建其他用户
  208. User admin = userMapper.selectOne(new QueryWrapper<User>().eq("id", user.getParentId()));
  209. qw.eq("company_type", Constant.PRODUCER_COMPANY).or().eq("id", admin.getCompanyId());
  210. }
  211. return companyMapper.selectList(qw);
  212. }
  213. @Override
  214. public List<Company> addCompanyListToProject(User user) {
  215. QueryWrapper<Company> qw = new QueryWrapper<>();
  216. qw.eq("company_type", Constant.PRODUCER_COMPANY);
  217. return companyMapper.selectList(qw);
  218. }
  219. @Override
  220. public HttpRespMsg getCoutomCompanyAndMouldsByUser(UserVO userVO) {
  221. HttpRespMsg msg = new HttpRespMsg();
  222. List<CompanyVO> companyVOS = new ArrayList<>();
  223. List<Integer> mouldIds = new ArrayList<>();
  224. mouldIds.add(-1);
  225. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", userVO.getToken()));
  226. if (Constant.SYS_ID == currentUser.getParentId()) {
  227. //此时是admin,可看到自己公司下的模具和交于生产的公司
  228. QueryWrapper<Mould> qw = new QueryWrapper<>();
  229. List<Mould> moulds = mouldMapper.selectList(qw.eq("company_id", currentUser.getCompanyId()));
  230. for (Mould mould : moulds) {
  231. mouldIds.add(mould.getId());
  232. }
  233. companyVOS = companyMapper.getListMould(mouldIds);
  234. } else if (Constant.SYS_PARENT_ID == currentUser.getParentId()) {
  235. //系统管理员创建admin,返回资产方公司
  236. List<Mould> moulds = mouldMapper.selectList(new QueryWrapper<Mould>());
  237. for (Mould mould : moulds) {
  238. mouldIds.add(mould.getId());
  239. }
  240. companyVOS = companyMapper.getListMould(mouldIds);
  241. } else {
  242. //此时是项目经理
  243. QueryWrapper<Project> qw = new QueryWrapper<>();
  244. qw.eq("manager_id", currentUser.getId());
  245. List<Integer> set = new ArrayList<>();
  246. set.add(-1);
  247. List<Project> projects = projectMapper.selectList(qw);
  248. if (projects.size() > 0) {
  249. for (Project project : projects) {
  250. set.add(project.getId());
  251. }
  252. }
  253. // //充当普通人员参与的项目
  254. List<ProjectUser> projectUsers = projectUserMapper.selectList(new QueryWrapper<ProjectUser>().eq("user_id", currentUser.getId()));
  255. if (projectUsers.size() > 0) {
  256. for (ProjectUser projectUser : projectUsers) {
  257. set.add(projectUser.getProjectId());
  258. }
  259. }
  260. //充当审批人员参与的项目
  261. List<ProjectApprove> projectss = projectApproveMapper.selectList(new QueryWrapper<ProjectApprove>().eq("approver_id", currentUser.getId()));
  262. if (projectss.size() > 0) {
  263. for (ProjectApprove projectUser : projectss) {
  264. set.add(projectUser.getProjectId());
  265. }
  266. }
  267. List<Mould> moulds = mouldMapper.selectList(new QueryWrapper<Mould>().in("project_id", set));
  268. for (Mould mould : moulds) {
  269. mouldIds.add(mould.getId());
  270. }
  271. companyVOS = companyMapper.getListMould(mouldIds);
  272. }
  273. msg.data = companyVOS;
  274. return msg;
  275. }
  276. @Override
  277. public HttpRespMsg relationList(Integer companyType) {
  278. HttpRespMsg msg = new HttpRespMsg();
  279. msg.data = companyMapper.selectList(new QueryWrapper<Company>().eq("company_type", companyType));
  280. return msg;
  281. }
  282. @Override
  283. public HttpRespMsg detail(UserVO userVO) {
  284. HttpRespMsg msg = new HttpRespMsg();
  285. // Company company = companyMapper.selectById(userVO.getCompanyId());
  286. // if (company != null) {
  287. // if (0 == company.getCompanyType()) {
  288. // //资产方
  289. // CompanyVO
  290. //
  291. // }
  292. // } else {
  293. // msg.setError("公司不存在");
  294. // }
  295. return msg;
  296. }
  297. @Override
  298. public HttpRespMsg getOwnerRelateCompany(CompanyVO companyVO) {
  299. HttpRespMsg msg = new HttpRespMsg();
  300. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", companyVO.getToken()));
  301. List<Integer> ides = new ArrayList<>();
  302. ides.add(-1);
  303. if (null == currentUser) {
  304. msg.setError("当前用户不存在或者不存在");
  305. return msg;
  306. } else {
  307. Company company = companyMapper.selectById(companyVO.getId());
  308. if (Constant.PRODUCER_COMPANY == company.getCompanyType()) {
  309. //生产方公司,返回关联的资产方公司列表
  310. ides = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>()
  311. .eq("custom_id", company.getId()))
  312. .stream()
  313. .map(AssetCustomCompany::getAssertId)
  314. .collect(Collectors.toList());
  315. msg.data = companyMapper.selectList(new QueryWrapper<Company>().in("id", ides));
  316. } else if (Constant.ASSETS_COMPANY == company.getCompanyType()) {
  317. //资产方公司,返回关联的生产方公司列表
  318. ides = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>()
  319. .eq("assert_id", company.getId()))
  320. .stream()
  321. .map(AssetCustomCompany::getCustomId)
  322. .collect(Collectors.toList());
  323. msg.data = companyMapper.selectList(new QueryWrapper<Company>().in("id", ides));
  324. }
  325. }
  326. return msg;
  327. }
  328. @Override
  329. public HttpRespMsg getProduceCompany(UserVO userVO) {
  330. HttpRespMsg msg = new HttpRespMsg();
  331. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", userVO.getToken()));
  332. if (null == currentUser) {
  333. msg.setError("当前用户不存在或者不存在");
  334. return msg;
  335. } else {
  336. Integer ownerCompany = projectMapper.selectById(userVO.getProjectId()).getOwnerCompany();
  337. List<Integer> companyIds = customCompanyMapper.selectList(new QueryWrapper<CustomCompany>()
  338. .eq("project_id", userVO.getProjectId()))
  339. .stream()
  340. .map(CustomCompany::getCompanyId)
  341. .collect(Collectors.toList());
  342. companyIds.add(ownerCompany);
  343. List<Company> list = companyMapper.selectList(new QueryWrapper<Company>().in("id", companyIds));
  344. msg.data = list;
  345. }
  346. return msg;
  347. }
  348. @Override
  349. public HttpRespMsg getProduceCompanyByCurrentUser(UserVO userVO) {
  350. HttpRespMsg msg = new HttpRespMsg();
  351. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", userVO.getToken()));
  352. List<Company> companies = new ArrayList<>();
  353. if (null == currentUser) {
  354. msg.setError("当前用户不存在或者不存在");
  355. return msg;
  356. } else {
  357. if (Constant.SYS_PARENT_ID == currentUser.getParentId()) {
  358. companies = companyMapper.selectList(new QueryWrapper<Company>());
  359. } else if (Constant.SYS_ID == currentUser.getParentId()) {
  360. if (currentUser.getSubordinateType() == 0) {
  361. List<Integer> customCompanyIds = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>().eq("assert_id", currentUser.getCompanyId())).stream().map(AssetCustomCompany::getCustomId).collect(Collectors.toList());
  362. customCompanyIds.add(currentUser.getCompanyId());
  363. companies = companyMapper.selectList(new QueryWrapper<Company>().in("id",customCompanyIds));
  364. }else if(currentUser.getSubordinateType() == 1){
  365. List<Integer> assetCompanyIds = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>().eq("custom_id", currentUser.getCompanyId())).stream().map(AssetCustomCompany::getAssertId).collect(Collectors.toList());
  366. assetCompanyIds.add(currentUser.getCompanyId());
  367. companies = companyMapper.selectList(new QueryWrapper<Company>().in("id",assetCompanyIds));
  368. }
  369. }else{
  370. List<Integer> projectIds = new ArrayList<>();
  371. QueryWrapper<Project> qwPro = new QueryWrapper<>();
  372. qwPro.eq("manager_id", currentUser.getId());
  373. projectIds = projectMapper.selectList(qwPro).stream().map(Project::getId).collect(Collectors.toList());
  374. projectIds.add(-1);
  375. //项目经理或者普通用户
  376. projectIds.addAll(projectUserMapper.selectList(new QueryWrapper<ProjectUser>()
  377. .eq("user_id", currentUser.getId()))
  378. .stream()
  379. .map(ProjectUser::getProjectId)
  380. .collect(Collectors.toList()));
  381. //作为审批人
  382. projectIds.addAll(projectApproveMapper.selectList(new QueryWrapper<ProjectApprove>()
  383. .eq("approver_id", currentUser.getId()))
  384. .stream()
  385. .map(ProjectApprove::getProjectId)
  386. .collect(Collectors.toList()));
  387. String keyName = null;
  388. List<ProjectVO> projects = projectMapper.getProjectListByUidInProjectIds(keyName, projectIds);
  389. List<Integer> ids = projects.stream().map(Project::getOwnerCompany).collect(Collectors.toList());
  390. ids.add(-1);
  391. companies = companyMapper.selectList(new QueryWrapper<Company>().in("id",ids));
  392. }
  393. msg.data = companies;
  394. }
  395. return msg;
  396. }
  397. @Override
  398. public HttpRespMsg deleteById(Integer id) {
  399. HttpRespMsg msg = new HttpRespMsg();
  400. Integer count = userMapper.selectCount(new QueryWrapper<User>().eq("company_id", id));
  401. if (count > 0) {
  402. msg.setError("该公司已被应用到用户中,暂不提供删除操作");
  403. return msg;
  404. } else {
  405. Company company = companyMapper.selectById(id);
  406. companyMapper.deleteById(id);
  407. if (company.getCompanyType() == 0) {
  408. //删除资产方关联的生产方公司
  409. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("assert_id", id));
  410. } else if (company.getCompanyType() == 1) {
  411. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("custom_id", id));
  412. }
  413. }
  414. return msg;
  415. }
  416. }