CompanyServiceImpl.java 22 KB

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