package com.kede.visitingCustomers.service.impl; import java.util.HashMap; import java.util.List; import java.util.Map; import com.kede.common.bo.Result; import com.kede.common.utils.excel.NewExcelUtil; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; import org.springframework.stereotype.Service; import com.kede.common.dao.VisitingCustomersMapper; import com.kede.common.model.VisitingCustomers; import com.kede.core.mybatis.BaseMybatisDao; import com.kede.core.mybatis.page.Pagination; import com.kede.recruitment.bo.OutRecruitment; import com.kede.visitingCustomers.bo.InputVisitingCustomers; import com.kede.visitingCustomers.bo.OutVisitingCustomers; import com.kede.visitingCustomers.service.VisitingCustomersService; @Service public class VisitingCustomersServiceImpl extends BaseMybatisDao implements VisitingCustomersService { @Value(value = "${upload.path}") public String downloadPath = ""; @Autowired private VisitingCustomersMapper visitingCustomersMapper; @Override public int addVisitingCustomers(VisitingCustomers vc) { return visitingCustomersMapper.insertSelective(vc); } @Override public int updateVisitingCustomers(VisitingCustomers vc) { VisitingCustomers v=new VisitingCustomers(); v.setId(vc.getId()); v.setStatus(vc.getStatus()); v.setRemark(vc.getRemark()); return visitingCustomersMapper.updateByPrimaryKeySelective(v); } @Override public int deleteVisitingCustomers(Integer id) { return visitingCustomersMapper.deleteByPrimaryKey(id); } @SuppressWarnings("unchecked") @Override public Pagination listVisitingCustomers(InputVisitingCustomers vc) { Map params=new HashMap<>(); params.put("startTime", vc.getStartTime()); params.put("endTime", vc.getEndTime()+" 23:59:59"); params.put("name", vc.getName()); return (Pagination) findPage("findVisitingCustomersList", "findVisitingCustomersCount", params, vc.getPageNo(), vc.getPageSize()); } private void setParams(InputVisitingCustomers vc, Map params) { if(vc.getStartTime()!=null) params.put("startTime", vc.getStartTime()); if(vc.getEndTime()!=null) params.put("endTime", vc.getEndTime()+" 23:59:59"); if(vc.getName()!=null) params.put("name", vc.getName()); if(vc.getStatus()!=null) params.put("status", vc.getStatus()); } @Override public Result listRecruitmentExport(InputVisitingCustomers vc) { Map params=new HashMap<>(); setParams(vc, params); List list = (List) findList("findVisitingCustomersList", params, vc.getPageNo(), vc.getPageSize()); NewExcelUtil newExcelUtil=new NewExcelUtil(OutVisitingCustomers.class); StringBuffer str=new StringBuffer("搜索条件=>"); if(vc.getStartTime()!=null&&vc.getEndTime()!=null){ str=str.append("提交日期:").append(vc.getStartTime()).append("~").append(vc.getEndTime()).append(" 23:59:59,"); } if(vc.getName()!=null) str=str.append("姓名:").append(vc.getName()).append(","); if(vc.getStatus()!=null) str=str.append("是否查看:").append(vc.getStatus()==0?"否":"是").append(","); return newExcelUtil.exportExcel(list,"客户访问列表",downloadPath,str.substring(0,str.length()-1)); } }