CompanyServiceImpl.java 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367
  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.UserVO;
  9. import com.hssx.cloudmodel.mapper.*;
  10. import com.hssx.cloudmodel.service.CompanyService;
  11. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  12. import com.hssx.cloudmodel.util.HttpRespMsg;
  13. import com.hssx.cloudmodel.util.ListUtil;
  14. import com.hssx.cloudmodel.util.PageUtil;
  15. import org.springframework.beans.BeanUtils;
  16. import org.springframework.beans.factory.annotation.Autowired;
  17. import org.springframework.stereotype.Service;
  18. import sun.plugin.com.event.COMEventHandler;
  19. import javax.annotation.Resource;
  20. import java.util.ArrayList;
  21. import java.util.List;
  22. import java.util.Map;
  23. import java.util.stream.Collectors;
  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. } 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> idess = new ArrayList<>();
  111. idess.add(-1);
  112. for (AssetCustomCompany assetCustomCompany : list) {
  113. idess.add(assetCustomCompany.getCustomId());
  114. }
  115. Integer count = customCompanyMapper.selectCount(new QueryWrapper<CustomCompany>().in("company_id", idess));
  116. if (count > 0) {
  117. msg.setError("当前公司所生产方公司已被用用到项目,不可执行修改操作。");
  118. return msg;
  119. }
  120. //删除之前的关联公司
  121. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("assert_id",companyVO.getId()));
  122. if (companyIds != null && !"".equals(companyIds)) {
  123. List<Integer> ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  124. for (Integer ide : ides) {
  125. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()).eq("custom_id", ide)) == 0) {
  126. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  127. assetCustomCompany.setAssertId(company.getId());
  128. assetCustomCompany.setCustomId(ide);
  129. assetCustomCompanyMapper.insert(assetCustomCompany);
  130. }
  131. }
  132. }
  133. companyMapper.updateById(company);
  134. } else if (companyVO.getCompanyType() == 1) {
  135. //生产方
  136. BeanUtils.copyProperties(companyVO, company);
  137. companyMapper.updateById(company);
  138. QueryWrapper<LngLatCompany> qw = new QueryWrapper<>();
  139. qw.eq("company_id", companyVO.getId());
  140. LngLatCompany lngLatCompany = lngLatCompanyMapper.selectOne(qw);
  141. LngLatCompany factory = new LngLatCompany();
  142. factory.setxLat(companyVO.getXLat());
  143. factory.setyLng(companyVO.getYLng());
  144. factory.setCompanyId(company.getId());
  145. factory.setId(lngLatCompany.getId());
  146. lngLatCompanyMapper.updateById(factory);
  147. List<AssetCustomCompany> list = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()));
  148. //判断所关联的生产方是否已被应用到项目
  149. List<Integer> idess = new ArrayList<>();
  150. idess.add(-1);
  151. for (AssetCustomCompany assetCustomCompany : list) {
  152. idess.add(assetCustomCompany.getCustomId());
  153. }
  154. Integer count = customCompanyMapper.selectCount(new QueryWrapper<CustomCompany>().eq("company_id", company.getId()));
  155. if (count > 0) {
  156. msg.setError("当前公司已和所关联的资产方合作相关项目,不可执行修改操作。");
  157. return msg;
  158. }
  159. //删除之前的关联公司
  160. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("custom_id",companyVO.getId()));
  161. if (companyIds != null && !"".equals(companyIds)) {
  162. List<Integer> ides = ListUtil.convertIntegerIdsArrayToList(companyIds);
  163. for (Integer ide : ides) {
  164. if (assetCustomCompanyMapper.selectCount(new QueryWrapper<AssetCustomCompany>().eq("assert_id", company.getId()).eq("custom_id", ide)) == 0) {
  165. AssetCustomCompany assetCustomCompany = new AssetCustomCompany();
  166. assetCustomCompany.setAssertId(company.getId());
  167. assetCustomCompany.setCustomId(ide);
  168. assetCustomCompanyMapper.insert(assetCustomCompany);
  169. }
  170. }
  171. }
  172. }
  173. msg.data = company;
  174. }
  175. return msg;
  176. }
  177. @Override
  178. public HttpRespMsg pageList(PageUtil page, String keyName, Integer companyType) {
  179. HttpRespMsg msg = new HttpRespMsg();
  180. List<CompanyVO> list = new ArrayList<>();
  181. PageHelper.startPage(page.getPageNum(),page.getPageSize());
  182. list = companyMapper.getCustomerListByKeyName(keyName, companyType);
  183. PageInfo<CompanyVO> pageInfos = new PageInfo<>(list);
  184. msg.data = pageInfos;
  185. return msg;
  186. }
  187. @Override
  188. public List<Company> getIdAndNamelist(User user) {
  189. QueryWrapper<Company> qw = new QueryWrapper<>();
  190. qw.select("id", "company_name", "company_type");
  191. if (Constant.SYS_ID == user.getParentId()) {
  192. //此时是admin创建用户,返回可选的生产方公司,查询出当前admin的信息并获取他的公司id
  193. User admin = userMapper.selectOne(new QueryWrapper<User>().eq("id", user.getId()));
  194. qw.eq("company_type", Constant.PRODUCER_COMPANY).or().eq("id", admin.getCompanyId());
  195. } else if (Constant.SYS_PARENT_ID == user.getParentId()) {
  196. //系统管理员创建admin,返回资产方公司
  197. qw.eq("company_type", Constant.ASSETS_COMPANY);
  198. } else {
  199. //此时是项目经理创建其他用户
  200. User admin = userMapper.selectOne(new QueryWrapper<User>().eq("id", user.getParentId()));
  201. qw.eq("company_type", Constant.PRODUCER_COMPANY).or().eq("id", admin.getCompanyId());
  202. }
  203. return companyMapper.selectList(qw);
  204. }
  205. @Override
  206. public List<Company> addCompanyListToProject(User user) {
  207. QueryWrapper<Company> qw = new QueryWrapper<>();
  208. qw.eq("company_type", Constant.PRODUCER_COMPANY);
  209. return companyMapper.selectList(qw);
  210. }
  211. @Override
  212. public HttpRespMsg getCoutomCompanyAndMouldsByUser(UserVO userVO) {
  213. HttpRespMsg msg = new HttpRespMsg();
  214. List<CompanyVO> companyVOS = new ArrayList<>();
  215. List<Integer> mouldIds = new ArrayList<>();
  216. mouldIds.add(-1);
  217. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", userVO.getToken()));
  218. if (Constant.SYS_ID == currentUser.getParentId()) {
  219. //此时是admin,可看到自己公司下的模具和交于生产的公司
  220. QueryWrapper<Mould> qw = new QueryWrapper<>();
  221. List<Mould> moulds = mouldMapper.selectList(qw.eq("company_id", currentUser.getCompanyId()));
  222. for (Mould mould : moulds) {
  223. mouldIds.add(mould.getId());
  224. }
  225. companyVOS = companyMapper.getListMould(mouldIds);
  226. } else if (Constant.SYS_PARENT_ID == currentUser.getParentId()) {
  227. //系统管理员创建admin,返回资产方公司
  228. List<Mould> moulds = mouldMapper.selectList(new QueryWrapper<Mould>());
  229. for (Mould mould : moulds) {
  230. mouldIds.add(mould.getId());
  231. }
  232. companyVOS = companyMapper.getListMould(mouldIds);
  233. } else {
  234. //此时是项目经理
  235. QueryWrapper<Project> qw = new QueryWrapper<>();
  236. qw.eq("manager_id", currentUser.getId());
  237. List<Integer> set = new ArrayList<>();
  238. set.add(-1);
  239. List<Project> projects = projectMapper.selectList(qw);
  240. if (projects.size() > 0) {
  241. for (Project project : projects) {
  242. set.add(project.getId());
  243. }
  244. }
  245. // //充当普通人员参与的项目
  246. List<ProjectUser> projectUsers = projectUserMapper.selectList(new QueryWrapper<ProjectUser>().eq("user_id", currentUser.getId()));
  247. if (projectUsers.size() > 0) {
  248. for (ProjectUser projectUser : projectUsers) {
  249. set.add(projectUser.getProjectId());
  250. }
  251. }
  252. //充当审批人员参与的项目
  253. List<ProjectApprove> projectss = projectApproveMapper.selectList(new QueryWrapper<ProjectApprove>().eq("approver_id", currentUser.getId()));
  254. if (projectss.size() > 0) {
  255. for (ProjectApprove projectUser : projectss) {
  256. set.add(projectUser.getProjectId());
  257. }
  258. }
  259. List<Mould> moulds = mouldMapper.selectList(new QueryWrapper<Mould>().in("project_id", set));
  260. for (Mould mould : moulds) {
  261. mouldIds.add(mould.getId());
  262. }
  263. companyVOS = companyMapper.getListMould(mouldIds);
  264. }
  265. msg.data = companyVOS;
  266. return msg;
  267. }
  268. @Override
  269. public HttpRespMsg relationList(Integer companyType) {
  270. HttpRespMsg msg = new HttpRespMsg();
  271. msg.data = companyMapper.selectList(new QueryWrapper<Company>().eq("company_type", companyType));
  272. return msg;
  273. }
  274. @Override
  275. public HttpRespMsg detail(UserVO userVO) {
  276. HttpRespMsg msg = new HttpRespMsg();
  277. // Company company = companyMapper.selectById(userVO.getCompanyId());
  278. // if (company != null) {
  279. // if (0 == company.getCompanyType()) {
  280. // //资产方
  281. // CompanyVO
  282. //
  283. // }
  284. // } else {
  285. // msg.setError("公司不存在");
  286. // }
  287. return msg;
  288. }
  289. @Override
  290. public HttpRespMsg getOwnerRelateCompany(CompanyVO companyVO) {
  291. HttpRespMsg msg = new HttpRespMsg();
  292. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", companyVO.getToken()));
  293. List<Integer> ides = new ArrayList<>();
  294. ides.add(-1);
  295. if(null == currentUser){
  296. msg.setError("当前用户不存在或者不存在");
  297. return msg;
  298. }else{
  299. Company company = companyMapper.selectById(companyVO.getId());
  300. if(Constant.PRODUCER_COMPANY == company.getCompanyType()){
  301. //生产方公司,返回关联的资产方公司列表
  302. ides = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>()
  303. .eq("custom_id", company.getId()))
  304. .stream()
  305. .map(AssetCustomCompany::getAssertId)
  306. .collect(Collectors.toList());
  307. msg.data = companyMapper.selectList(new QueryWrapper<Company>().in("id",ides));
  308. }else if(Constant.ASSETS_COMPANY == company.getCompanyType()){
  309. //资产方公司,返回关联的生产方公司列表
  310. ides = assetCustomCompanyMapper.selectList(new QueryWrapper<AssetCustomCompany>()
  311. .eq("assert_id", company.getId()))
  312. .stream()
  313. .map(AssetCustomCompany::getCustomId)
  314. .collect(Collectors.toList());
  315. msg.data = companyMapper.selectList(new QueryWrapper<Company>().in("id",ides));
  316. }
  317. }
  318. return msg;
  319. }
  320. @Override
  321. public HttpRespMsg getProduceCompany(UserVO userVO) {
  322. HttpRespMsg msg = new HttpRespMsg();
  323. User currentUser = userMapper.selectOne(new QueryWrapper<User>().eq("head_imgurl", userVO.getToken()));
  324. if(null == currentUser){
  325. msg.setError("当前用户不存在或者不存在");
  326. return msg;
  327. }else{
  328. msg.data = customCompanyMapper.selectList(new QueryWrapper<CustomCompany>().eq("project_id",userVO.getProjectId()));
  329. }
  330. return msg;
  331. }
  332. @Override
  333. public HttpRespMsg deleteById(Integer id) {
  334. HttpRespMsg msg = new HttpRespMsg();
  335. Integer count = userMapper.selectCount(new QueryWrapper<User>().eq("company_id", id));
  336. if (count > 0) {
  337. msg.setError("该公司已被应用到用户中,暂不提供删除操作");
  338. return msg;
  339. } else {
  340. Company company = companyMapper.selectById(id);
  341. companyMapper.deleteById(id);
  342. if(company.getCompanyType()==0){
  343. //删除资产方关联的生产方公司
  344. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("assert_id",id));
  345. }else if(company.getCompanyType()==1){
  346. assetCustomCompanyMapper.delete(new QueryWrapper<AssetCustomCompany>().eq("custom_id",id));
  347. }
  348. }
  349. return msg;
  350. }
  351. }