ProcureService.java 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249
  1. package com.caimei.modules.groupbuy.service;
  2. import com.caimei.modules.club.entity.CmUser;
  3. import com.caimei.modules.club.entity.Page;
  4. import com.caimei.modules.groupbuy.dao.ProcureRepository;
  5. import com.caimei.modules.groupbuy.entity.AdditionalPo;
  6. import com.caimei.modules.groupbuy.entity.BuyerDto;
  7. import com.caimei.modules.groupbuy.entity.ProcurePo;
  8. import com.caimei.modules.shiro.dao.UserDao;
  9. import com.caimei.utils.ResponseJson;
  10. import lombok.extern.slf4j.Slf4j;
  11. import org.apache.commons.lang3.StringUtils;
  12. import org.springframework.beans.BeanUtils;
  13. import org.springframework.data.domain.PageImpl;
  14. import org.springframework.data.domain.PageRequest;
  15. import org.springframework.data.domain.Pageable;
  16. import org.springframework.data.domain.Sort;
  17. import org.springframework.data.mongodb.core.MongoTemplate;
  18. import org.springframework.data.mongodb.core.query.Criteria;
  19. import org.springframework.stereotype.Service;
  20. import org.springframework.data.mongodb.core.query.Query;
  21. import sun.util.calendar.BaseCalendar;
  22. import javax.annotation.Resource;
  23. import javax.xml.ws.Response;
  24. import java.text.DateFormat;
  25. import java.text.ParseException;
  26. import java.text.SimpleDateFormat;
  27. import java.time.Instant;
  28. import java.time.temporal.ChronoUnit;
  29. import java.util.*;
  30. import java.util.regex.Pattern;
  31. @Slf4j
  32. @Service
  33. public class ProcureService {
  34. @Resource
  35. private ProcureRepository procureRepository;
  36. @Resource
  37. private MongoTemplate mongoTemplate;
  38. @Resource
  39. private AdditionalService additionalService;
  40. @Resource
  41. private UserDao userDao;
  42. /**
  43. * 保存
  44. *
  45. * @param procure
  46. */
  47. public void save(ProcurePo procure) {
  48. //如果需要自定义主键,可以在这里指定主键;如果不指定主键,MongoDB会自动生成主键
  49. //设置一些默认初始值。。。
  50. //调用dao
  51. procureRepository.save(procure);
  52. }
  53. /**
  54. * 修改
  55. *
  56. * @param procure
  57. */
  58. public void update(ProcurePo procure) {
  59. //调用dao
  60. procureRepository.save(procure);
  61. }
  62. /**
  63. * 根据id删除
  64. *
  65. * @param id
  66. */
  67. public void deleteById(String id) {
  68. //调用dao
  69. procureRepository.deleteById(id);
  70. }
  71. /**
  72. * 查询所有集采
  73. *
  74. * @return
  75. */
  76. public Page<ProcurePo> findList(int pageNo, int pageSize) {
  77. //调用dao
  78. Pageable pageable = PageRequest.of(pageNo, pageSize);
  79. Query query = new Query();
  80. query.addCriteria(Criteria.where("delFlag").is("0"));
  81. query.with(Sort.by(Sort.Direction.DESC, "saveTime"));
  82. List<ProcurePo> procurePos = mongoTemplate.find(query.with(pageable), ProcurePo.class);
  83. long count = mongoTemplate.count(query, ProcurePo.class);
  84. PageImpl<ProcurePo> page = new PageImpl<>(procurePos, pageable, count);
  85. return pageCopy(page, procurePos);
  86. }
  87. /**
  88. * 根据id查询
  89. *
  90. * @param id
  91. * @return
  92. */
  93. public ProcurePo findById(String id) {
  94. //调用dao
  95. return procureRepository.findById(id).get();
  96. }
  97. /**
  98. * 我参与的集采
  99. *
  100. * @param userId
  101. * @return
  102. */
  103. public List<ProcurePo> findInvolvedList(Integer userId) {
  104. Query query = new Query();
  105. query.addCriteria(Criteria.where("userId").is(userId));
  106. query.addCriteria(Criteria.where("createUserId").not().is(userId));
  107. query.with(Sort.by(Sort.Direction.DESC, "saveTime"));
  108. query.with(Sort.by(Sort.Direction.DESC, "isAchieve"));
  109. List<ProcurePo> procureList = mongoTemplate.find(query, ProcurePo.class);
  110. procureList.forEach(p -> {
  111. });
  112. return mongoTemplate.find(query, ProcurePo.class);
  113. }
  114. /**
  115. * 我发起的集采
  116. *
  117. * @param userId
  118. * @return
  119. */
  120. public List<ProcurePo> findUserList(Integer userId) {
  121. Query query = new Query();
  122. query.addCriteria(Criteria.where("createUserId").is(userId));
  123. query.with(Sort.by(Sort.Direction.DESC, "saveTime"));
  124. query.with(Sort.by(Sort.Direction.DESC, "isAchieve"));
  125. return mongoTemplate.find(query, ProcurePo.class);
  126. }
  127. public ProcurePo editData(Integer id, Integer userId) {
  128. Query query = new Query();
  129. query.addCriteria(Criteria.where("id").is(id));
  130. query.addCriteria(Criteria.where("userId").is(userId));
  131. return mongoTemplate.find(query, ProcurePo.class).get(0);
  132. }
  133. public Page<BuyerDto> findBuyListByPro(BuyerDto dto, Integer pageNum, Integer pageSize) {
  134. Pageable pageable = PageRequest.of(pageNum - 1, pageSize);
  135. Query query = new Query();
  136. setCriteriaVal(query, dto);
  137. query.with(Sort.by(Sort.Direction.DESC, "saveTime")).with(pageable);
  138. List<ProcurePo> procurePos = mongoTemplate.find(query, ProcurePo.class);
  139. List<BuyerDto> buyerDtos = new ArrayList<>();
  140. // 定义格式化字符串
  141. SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  142. procurePos.forEach(p -> {
  143. BuyerDto buyerDto = new BuyerDto();
  144. String format = dateFormat.format(new Date(p.getSaveTime()));
  145. buyerDto.setSaveTime(format);
  146. int count = (int) mongoTemplate.count(Query.query(Criteria.where("procureId").is(p.getId())), AdditionalPo.class);
  147. CmUser linkMan = userDao.findLinkMan(p.getUserId());
  148. buyerDto.setLinkMan(linkMan.getLinkMan());
  149. buyerDto.setMobile(linkMan.getMobile());
  150. buyerDto.setClubCount(count);
  151. // 1未完成 2已完成 3已删除
  152. Integer status = "0".equals(p.getIsAchieve()) ? 1 : 2;
  153. status = !"0".equals(p.getDelFlag()) ? 3 : status;
  154. buyerDto.setStatus(status);
  155. BeanUtils.copyProperties(p, buyerDto);
  156. buyerDtos.add(buyerDto);
  157. });
  158. long count = mongoTemplate.count(query, ProcurePo.class);
  159. PageImpl<BuyerDto> page = new PageImpl<>(buyerDtos, pageable, count);
  160. return pageCopy(page, buyerDtos);
  161. }
  162. public <T> Page<T> pageCopy(PageImpl<T> page, List<T> info) {
  163. Page<T> result = new Page<>();
  164. result.setTotalPage(page.getTotalPages());
  165. result.setPageSize(page.getSize());
  166. result.setHasNextPage(page.hasNext());
  167. result.setHasPreviousPage(page.hasPrevious());
  168. result.setIndex(page.getPageable().getPageNumber());
  169. result.setPageSize(page.getPageable().getPageSize());
  170. result.setResults(info);
  171. return result;
  172. }
  173. public Query setCriteriaVal(Query query, BuyerDto dto) {
  174. // 发布者有创建者id
  175. query.addCriteria(Criteria.where("createUserId").ne(null));
  176. if (StringUtils.isNotBlank(dto.getClubName())) {
  177. Pattern pattern = Pattern.compile("^.*" + dto.getClubName() + ".*$", Pattern.CASE_INSENSITIVE);
  178. query.addCriteria(Criteria.where("clubName").regex(pattern));
  179. }
  180. if (StringUtils.isNotBlank(dto.getProductName())) {
  181. Pattern pattern = Pattern.compile("^.*" + dto.getProductName() + ".*$", Pattern.CASE_INSENSITIVE);
  182. query.addCriteria(Criteria.where("productName").regex(pattern));
  183. }
  184. if (null != dto.getStatus()) {
  185. if (3 == dto.getStatus()) {
  186. query.addCriteria(Criteria.where("delFlag").is("1"));
  187. } else {
  188. query.addCriteria(Criteria.where("isAchieve").is(dto.getStatus().toString()));
  189. query.addCriteria(Criteria.where("delFlag").is("0"));
  190. }
  191. }
  192. if (StringUtils.isNotBlank(dto.getLinkMan())) {
  193. query.addCriteria(Criteria.where("clubName").regex(".*" + dto.getLinkMan() + ".*"));
  194. }
  195. if (StringUtils.isNotBlank(dto.getStartSaveTime()) && StringUtils.isNotBlank(dto.getEndSaveTime())) {
  196. /**
  197. * 传入结束时间为当日0点,加一天改为当日结束时间
  198. */
  199. Instant start = Instant.parse(dto.getStartSaveTime());
  200. Instant end = Instant.parse(dto.getEndSaveTime());
  201. end = end.plus(1, ChronoUnit.DAYS);
  202. long st = start.toEpochMilli();
  203. long ed = end.toEpochMilli();
  204. query.addCriteria(Criteria.where("saveTime").gte(st).lte(ed));
  205. }
  206. return query;
  207. }
  208. public Map<String, Object> findDetail(String id) {
  209. // 发起者
  210. ProcurePo byId = findById(id.toString());
  211. // 参与者
  212. List<AdditionalPo> procureById = additionalService.findProcureById(byId.getId());
  213. List<ProcurePo> procurePos = new ArrayList<>();
  214. procureById.forEach(p -> {
  215. ProcurePo byId1 = findById(p.getAdditionalId());
  216. procurePos.add(byId1);
  217. });
  218. Map<String, Object> map = new HashMap<>(2);
  219. map.put("publishMan", byId);
  220. map.put("followMan", procurePos);
  221. return map;
  222. }
  223. public ResponseJson checkDone(String id) {
  224. ProcurePo byId = findById(id);
  225. byId.setIsAchieve("1");
  226. update(byId);
  227. return ResponseJson.success();
  228. }
  229. }