package com.whyc.service;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import com.whyc.dto.Response;
|
import com.whyc.dto.WorksheetDTO;
|
import com.whyc.mapper.WorksheetLinkMapper;
|
import com.whyc.mapper.WorksheetMainMapper;
|
import com.whyc.pojo.WorksheetLink;
|
import com.whyc.pojo.WorksheetMain;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.text.SimpleDateFormat;
|
import java.util.Date;
|
import java.util.List;
|
|
@Service
|
public class WorksheetMainService {
|
@Resource
|
private WorksheetMainMapper mainMapper;
|
@Resource
|
private WorksheetLinkMapper linkMapper;
|
|
/**
|
* 获取工单号
|
* WS-210907-00009
|
* @return
|
*/
|
public String getSheetId(){
|
String datetime = new SimpleDateFormat("yyMMdd").format(new Date());
|
String sheetId = mainMapper.getSheetId();
|
if(sheetId==null || "".equals(sheetId)) {
|
sheetId = "WS-" + datetime + "-00001";
|
}else{
|
sheetId = "WS-" + datetime +"-"+ String.format("%05d",Integer.parseInt(sheetId.substring(sheetId.length()-4))+1);
|
}
|
return sheetId;
|
}
|
|
public Response add(WorksheetMain main){
|
main.setCreateTime(new Date());
|
main.setStatus(0);
|
String sheetId = getSheetId();
|
main.setSheetId(sheetId);
|
mainMapper.insert(main);
|
//T0处理
|
WorksheetLink link = new WorksheetLink();
|
link.setMainId(main.getId());
|
link.setSheetId(sheetId);
|
link.setProcessLevel("T0");
|
link.setProcessLevelName("工单派发");
|
link.setDealUserId(main.getDealUserId());
|
link.setDealUser(main.getDealUser());
|
link.setLinkStatus(5);
|
link.setDealType(0);
|
link.setDealDesc("派单给T1");
|
linkMapper.insert(link);
|
//T1处理
|
WorksheetLink link1 = new WorksheetLink();
|
link1.setParentId(link.getId());
|
link1.setSheetId(sheetId);
|
link1.setMainId(main.getId());
|
link1.setProcessLevel("T1");
|
link1.setProcessLevelName("T1处理");
|
link1.setDealUserId(main.getDealUserId());
|
link1.setDealUser(main.getDealUser());
|
link1.setDealRoleId(main.getDealRoleId());
|
link1.setDealRole(main.getDealRole());
|
link1.setLinkStatus(0);
|
link1.setDealAndClose(1);
|
linkMapper.insert(link1);
|
return new Response().setII(1,"添加成功");
|
}
|
|
|
public PageInfo<WorksheetDTO> getWorksheetList(int pageNum, int pageSize, WorksheetDTO worksheetDto){
|
PageHelper.startPage(pageNum,pageSize);
|
QueryWrapper<WorksheetDTO> queryWrapper = new QueryWrapper();
|
queryWrapper.eq("l.deal_user_id",worksheetDto.getDealUserId());
|
if("待处理".equals(worksheetDto.getFlag())) {
|
queryWrapper.in("l.link_status", new int[]{0, 1, 3, 4});
|
}else if ("已处理".equals(worksheetDto.getFlag())){
|
queryWrapper.eq("l.link_status",5);
|
}else{//已归档 撤销先不做
|
queryWrapper.eq("m.status",5);
|
}
|
if (worksheetDto.getTitle()!=null&&worksheetDto.getTitle()!=""){
|
queryWrapper.like("m.title",worksheetDto.getTitle());
|
}
|
queryWrapper.like(worksheetDto.getTitle()!=null,"m.title",worksheetDto.getTitle());
|
queryWrapper.ge(worksheetDto.getStartTime()!=null,"m.create_time",worksheetDto.getStartTime())
|
.le(worksheetDto.getEndTime()!=null,"m.create_time",worksheetDto.getEndTime());
|
|
List<WorksheetDTO> list = mainMapper.getWorksheetsByPage(queryWrapper);
|
PageInfo<WorksheetDTO> pageInfo = new PageInfo<>(list);
|
return pageInfo;
|
}
|
|
|
|
|
|
}
|
