serivce:
public DemandDTO getDemandById(Long demandId) {
DemandInfo demandInfo = demandService.getDemandById(demandId);
List<DemandAttachmentDTO> demandAttachmentDTOList = Lists
.newArrayList();
List<DemandInfoFile> listDemandInfoFile = demandService
.listDemandInfoFile(demandInfo.getId(),
Constant.ATTACHMENT_TYPE_DEMAND);
if (null != listDemandInfoFile && listDemandInfoFile.size() > 0) {
demandAttachmentDTOList = Lists.transform(listDemandInfoFile,
new Function<DemandInfoFile, DemandAttachmentDTO>() {
@Override
public DemandAttachmentDTO apply(
DemandInfoFile demandInfoFile) {
return new DemandAttachmentDTO(demandInfoFile);
}
});
}
DemandDTO demandDTO = DemandDTOAssembler.toDemandDTO(demandInfo,
demandAttachmentDTOList);
/**计算时间**/
calculationDuration(demandInfo,demandDTO);
/**计算时间end**/
//???????????????承接时长是否是从第一次操作跟进记录算起,
int forwardNumber = 0;
if(null != demandInfo){
// 如果需求状态为"待跟进",就查询出需求转发的次数
if(Constant.DEMAND_STATUS_TO_FOLLOW.equals(demandInfo.getDemandStatus())){
forwardNumber = demandService.getDemandViceForwardActionCount(demandId);
demandDTO.setForwardNumber(forwardNumber);
}
}
return demandDTO;
}
数据的封装:
public static DemandDTO toDemandDTO(DemandInfo demandInfo,List<DemandAttachmentDTO> demandAttachmentDTOList){
SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
DemandDTO demandDTO = new DemandDTO();
demandDTO.setDemandId(demandInfo.getId());//需求主键
demandDTO.setDemandNumber(demandInfo.getDemandNumber());//需求编号
demandDTO.setDemandTitle(demandInfo.getDemandTitle());//需求标题
demandDTO.setCreator(new DemandUserDTO(demandInfo.getCreator()));//创建人
demandDTO.setCreatorWorknumber(demandInfo.getCreatorWorknumber());//创建人工号
demandDTO.setCreatorName(demandInfo.getCreatorName());//创建人名称
demandDTO.setForwardUser(new DemandUserDTO(demandInfo.getForwardUser()));//提出人
demandDTO.setForwardWorknum(demandInfo.getForwardWorknum());//提出人工号
demandDTO.setForwardName(demandInfo.getForwardName());//提出人名称
demandDTO.setForwardDate(dateFormat.format(demandInfo.getForwardDate()));//提出日期
demandDTO.setPhone(demandInfo.getPhone());//电话
demandDTO.setEmail(demandInfo.getEmail());//邮箱
demandDTO.setExpectCompleteDate(dateFormat.format(demandInfo.getExpectCompleteDate()));//期望完成时间
demandDTO.setDemandContent(demandInfo.getRequirements());//需求内容
demandDTO.setCreatorDeptName(demandInfo.getCreatorDeptName());//发起人部门
demandDTO.setDemandUndertakeDeptName(demandInfo.getDemandUndertakeDeptName());//承接人所在部门
String demandType = demandInfo.getDemandValueType();//需求价值
List<String> demandTypes = new ArrayList<String>();
if(demandType !=null){//拼接类型
String[] strs = demandType.split(",");
for(int i=0;i<strs.length;i++){
if(strs[i]!=null){
demandTypes.add(strs[i]);
}
}
}
demandDTO.setDemandTypes(demandTypes);//类型
demandDTO.setDemandTypeOther(demandInfo.getDemandValue());//其他
demandDTO.setDemandStatus(demandInfo.getDemandStatus());//状态
demandDTO.setSponsorDept(new OrganizationDTO(demandInfo.getSponsorDept()));//发起部门
demandDTO.setSponsorDeptName(demandInfo.getSponsorDeptName());//发起部门名称
demandDTO.setAcceptDeptId(new OrganizationDTO(demandInfo.getAcceptDeptId()));//承接id
demandDTO.setAcceptDeptName(demandInfo.getAcceptDeptName());//承接部门名称
if(demandInfo.getAcceptPeopleId() !=null){//承接人
demandDTO.setAcceptPeopleId(new DemandUserDTO(demandInfo.getAcceptPeopleId()));
demandDTO.setAcceptPeopleWorknum(demandInfo.getAcceptPeopleWorknum());//承接人工号
demandDTO.setAcceptPeopleName(demandInfo.getAcceptPeopleName());//承接人名称
}
if(null != demandAttachmentDTOList && demandAttachmentDTOList.size()>0){
demandDTO.setDemandAttachments(demandAttachmentDTOList);//附件
}
demandDTO.setReviewDate(demandInfo.getReViewDate());
demandDTO.setEstimateCompleteDate(demandInfo.getEstimateCompleteDate()==null?"":dateFormat.format(demandInfo.getEstimateCompleteDate()));
return demandDTO;
}
public class DemandAttachmentDTO implements Serializable {
private Long demandInfoFileId;
private Long businessId;
private String fileType;
private Long fileId;
private String name;
private String contentType;
private String path;
private Long size;
private Long uploader;
----------------------------------------------------------------------------------------------------------------------------------------------
jpa:
List<MeetingSummary> meetingSummaries = meetingSummaryDao.getMeetingSummariesByUser(workNumber,meetingSummaryStatus, queryCriteria,idList);
public List<MeetingSummary> getMeetingSummariesByUser(String workNumber,
MeetingSummaryStatus meetingSummaryStatus,
QueryCriteria queryCriteria,List<Long> idList) {
idList = CollectionUtils.isEmpty(idList) ? Lists.newArrayList(0L) : idList;//为了防止list为空这个情况
CriteriaBuilder criteriaBuilder = entityManager().getCriteriaBuilder();
CriteriaQuery<MeetingSummary> query = criteriaBuilder
.createQuery(MeetingSummary.class);
Root<MeetingSummaryUser> root = query.from(MeetingSummaryUser.class);
Join<MeetingSummaryUser, MeetingSummary> meetingSummary = root
.join("meetingSummary");
CriteriaPathBuilder pathBuilder = new CriteriaPathBuilder(root,
MeetingSummaryUser.class);
Order order;
Order idOrder;
if (queryCriteria.orderType() == OrderType.ASC) {
order = criteriaBuilder.asc(pathBuilder
.build(getOrderedField(queryCriteria.orderBy())));
idOrder = criteriaBuilder.asc(meetingSummary.get("id"));
} else if (queryCriteria.orderType() == OrderType.DESC) {
order = criteriaBuilder.desc(pathBuilder
.build(getOrderedField(queryCriteria.orderBy())));
idOrder = criteriaBuilder.desc(meetingSummary.get("id"));
} else {
throw new IllegalArgumentException(format("Unknown order type {0}",
queryCriteria.orderType()));
}
List<Predicate> predicatesList = Lists.newArrayList();
if (meetingSummaryStatus != null) {
if(meetingSummaryStatus==MeetingSummaryStatus.NORMAL){
predicatesList.add(criteriaBuilder.equal(root.get("userWorkNumber"),workNumber));
predicatesList.add(criteriaBuilder.equal(meetingSummary.get("status"),meetingSummaryStatus));
}else if(meetingSummaryStatus == MeetingSummaryStatus.SHARE){
predicatesList.add(criteriaBuilder.equal(root.get("userRole"),MeetingSummaryUserRole.RECORDER));
predicatesList.add(criteriaBuilder.isTrue(meetingSummary.get("id").in(idList)));
}else{
predicatesList.add(criteriaBuilder.equal(root.get("userWorkNumber"),workNumber));
predicatesList.add(criteriaBuilder.equal(meetingSummary.get("status"),meetingSummaryStatus));
predicatesList.add(criteriaBuilder.equal(root.get("userRole"), MeetingSummaryUserRole.RECORDER));
}
} else {
predicatesList.add(criteriaBuilder.equal(root.get("userWorkNumber"), workNumber));
}
query.select(meetingSummary).
where(predicatesList.toArray(new Predicate[predicatesList.size()])).
orderBy(order, idOrder);
return entityManager()
.createQuery(query)
.setFirstResult(
queryCriteria.pageSize()
* (queryCriteria.pageNum() - 1))
.setMaxResults(queryCriteria.pageSize()).getResultList();
}
----------------------------------------------------
List<MeetingSummaryListRowDTO> dtos = newArrayList();
dtos = MeetingSummaryListRowDTO.toDTOs(meetingSummaries, workNumber, unreadFlagMap);
public static List<MeetingSummaryListRowDTO> toDTOs(List<MeetingSummary> meetingSummaries, final String workNumber, final Map<Long, Boolean> unreadFlagMap) {
return Lists.transform(meetingSummaries, new Function<MeetingSummary, MeetingSummaryListRowDTO>() {
@Override
public MeetingSummaryListRowDTO apply(MeetingSummary input) {
MeetingSummaryListRowDTO summaryDTO = new MeetingSummaryListRowDTO(input);
for (MeetingSummaryUser user : input.getUsers()) {
if (workNumber.equals(user.getUserWorkNumber())) {
summaryDTO.currentUser = MeetingSummaryUserDTO.convertFromMeetSummaryUser(user);
break;
}
}
if(unreadFlagMap!=null){
summaryDTO.isUnread = unreadFlagMap.get(input.getId());
}
return summaryDTO;
}
});
}