VisitingCustomersServiceImpl.java 3.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
  1. package com.kede.visitingCustomers.service.impl;
  2. import java.util.HashMap;
  3. import java.util.List;
  4. import java.util.Map;
  5. import com.kede.common.bo.Result;
  6. import com.kede.common.utils.excel.NewExcelUtil;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.beans.factory.annotation.Value;
  9. import org.springframework.stereotype.Service;
  10. import com.kede.common.dao.VisitingCustomersMapper;
  11. import com.kede.common.model.VisitingCustomers;
  12. import com.kede.core.mybatis.BaseMybatisDao;
  13. import com.kede.core.mybatis.page.Pagination;
  14. import com.kede.recruitment.bo.OutRecruitment;
  15. import com.kede.visitingCustomers.bo.InputVisitingCustomers;
  16. import com.kede.visitingCustomers.bo.OutVisitingCustomers;
  17. import com.kede.visitingCustomers.service.VisitingCustomersService;
  18. @Service
  19. public class VisitingCustomersServiceImpl extends BaseMybatisDao<VisitingCustomersMapper> implements VisitingCustomersService {
  20. @Value(value = "${upload.path}")
  21. public String downloadPath = "";
  22. @Autowired
  23. private VisitingCustomersMapper visitingCustomersMapper;
  24. @Override
  25. public int addVisitingCustomers(VisitingCustomers vc) {
  26. return visitingCustomersMapper.insertSelective(vc);
  27. }
  28. @Override
  29. public int updateVisitingCustomers(VisitingCustomers vc) {
  30. VisitingCustomers v=new VisitingCustomers();
  31. v.setId(vc.getId());
  32. v.setStatus(vc.getStatus());
  33. v.setRemark(vc.getRemark());
  34. return visitingCustomersMapper.updateByPrimaryKeySelective(v);
  35. }
  36. @Override
  37. public int deleteVisitingCustomers(Integer id) {
  38. return visitingCustomersMapper.deleteByPrimaryKey(id);
  39. }
  40. @SuppressWarnings("unchecked")
  41. @Override
  42. public Pagination<OutVisitingCustomers> listVisitingCustomers(InputVisitingCustomers vc) {
  43. Map<String, Object> params=new HashMap<>();
  44. params.put("startTime", vc.getStartTime());
  45. params.put("endTime", vc.getEndTime()+" 23:59:59");
  46. params.put("name", vc.getName());
  47. return (Pagination<OutVisitingCustomers>) findPage("findVisitingCustomersList", "findVisitingCustomersCount", params, vc.getPageNo(), vc.getPageSize());
  48. }
  49. private void setParams(InputVisitingCustomers vc, Map<String, Object> params) {
  50. if(vc.getStartTime()!=null) params.put("startTime", vc.getStartTime());
  51. if(vc.getEndTime()!=null) params.put("endTime", vc.getEndTime()+" 23:59:59");
  52. if(vc.getName()!=null) params.put("name", vc.getName());
  53. if(vc.getStatus()!=null) params.put("status", vc.getStatus());
  54. }
  55. @Override
  56. public Result listRecruitmentExport(InputVisitingCustomers vc) {
  57. Map<String, Object> params=new HashMap<>();
  58. setParams(vc, params);
  59. List<OutVisitingCustomers> list = (List<OutVisitingCustomers>) findList("findVisitingCustomersList", params, vc.getPageNo(), vc.getPageSize());
  60. NewExcelUtil newExcelUtil=new NewExcelUtil(OutVisitingCustomers.class);
  61. StringBuffer str=new StringBuffer("搜索条件=>");
  62. if(vc.getStartTime()!=null&&vc.getEndTime()!=null){
  63. str=str.append("提交日期:").append(vc.getStartTime()).append("~").append(vc.getEndTime()).append(" 23:59:59,");
  64. }
  65. if(vc.getName()!=null) str=str.append("姓名:").append(vc.getName()).append(",");
  66. if(vc.getStatus()!=null) str=str.append("是否查看:").append(vc.getStatus()==0?"否":"是").append(",");
  67. return newExcelUtil.exportExcel(list,"客户访问列表",downloadPath,str.substring(0,str.length()-1));
  68. }
  69. }