查询所有的审批工单,允许通过申请人，申请时间（时间段， 默认最近7天），流程状态（默认全部）进行筛选

glperry

2023-10-26 28c0cb536f804bc0b1ac5005d479d400ec3c000b

查询所有的审批工单,允许通过申请人，申请时间（时间段， 默认最近7天），流程状态（默认全部）进行筛选

 src/main/java/com/whyc/pojo/WorksheetMain.java

@@ -81,6 +81,12 @@
    @TableField(exist = false)
    private ProcedureDoc procedureDoc;

    @TableField(exist = false)
    private Integer pageNum;

    @TableField(exist = false)
    private Integer pageSize;

    public Integer getId() {
        return id;
    }
@@ -240,4 +246,20 @@
    public void setProcedureDoc(ProcedureDoc procedureDoc) {
        this.procedureDoc = procedureDoc;
    }

    public void setPageNum(Integer pageNum) {
        this.pageNum = pageNum;
    }

    public void setPageSize(Integer pageSize) {
        this.pageSize = pageSize;
    }

    public Integer getPageNum() {
        return pageNum;
    }

    public Integer getPageSize() {
        return pageSize;
    }
}

 src/main/java/com/whyc/service/WorksheetMainService.java

@@ -892,4 +892,32 @@
            e.printStackTrace();
        }*/
    }

    /**
     * 查询所有的工单,所有人可见
     * @param param
     * @return
     */
    public Response getList(WorksheetMain param) {
        Integer pageNum = param.getPageNum();
        Integer pageSize = param.getPageSize();
        PageHelper.startPage(pageNum,pageSize);

        int createUserId = param.getCreateUserId().intValue();
        Date beginTime = param.getBeginTime();
        Date endTime = param.getEndTime();
        Integer type = param.getType();
        QueryWrapper<WorksheetMain> query = Wrappers.query();
        if(createUserId>0){
            query.eq("create_user_id",createUserId);
        }
        query.ge("begin_time",beginTime);
        query.le("end_time",endTime);
        if(type!=null && type>=0){
            query.eq("type",type);
        }
        List<WorksheetMain> worksheetMains = mainMapper.selectList(query);
        PageInfo pageInfo = new PageInfo(worksheetMains);
        return new Response().set(1,pageInfo);
    }
}

 src/main/java/com/whyc/webSocket/WorksheetAllSocket.java

New file
@@ -0,0 +1,107 @@
package com.whyc.webSocket;

import com.whyc.config.WebSocketConfig;
import com.whyc.dto.Response;
import com.whyc.pojo.WorksheetMain;
import com.whyc.service.WorksheetMainService;
import com.whyc.util.ActionUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import javax.websocket.*;
import javax.websocket.server.ServerEndpoint;
import java.util.HashMap;
import java.util.Map;

/**
 * 所有审批单查询
 */
@Component
@ServerEndpoint(value = "/worksheetAll",encoders = WebSocketEncoder.class,configurator = WebSocketConfig.class)
public class WorksheetAllSocket {

    private Session session;

    private static final int executeTime = 4000;

    private Thread thread;

    private volatile boolean runFlag=true;

    private volatile Map<String,Thread> threadMap = new HashMap<>();

    private volatile Map<Long,Boolean> threadFlagMap = new HashMap<>();

    private static WorksheetMainService mainService;

    @Autowired
    public void setMainService(WorksheetMainService mainService) {
        WorksheetAllSocket.mainService = mainService;
    }

    @OnOpen
    public void onOpen(Session session){
        this.session=session;
    }

    @OnMessage
    public void onMessage(Session session, String message){
        this.session=session;
        WorksheetMain param= ActionUtil.getGson().fromJson(message, WorksheetMain.class);
        thread = new Thread("Thread_RealTime") {
            @Override
            public void run() {
                while (runFlag && !isInterrupted()) {
                    Thread thread = currentThread();
                    threadFlagMap.put(thread.getId(), true);
                    try {
                        Response res = mainService.getList(param);
                        if (session.isOpen()) {
                            //推送信息
                            synchronized (session) {
                                session.getBasicRemote().sendObject(res);
                            }
                            threadFlagMap.put(thread.getId(), false);
                        }

                        sleep(executeTime);
                        //} catch (IOException | InterruptedException | EncodeException e) {
                    } catch (Exception e) {
                        interrupt();
                    }
                }
            }
        };
        thread.start();
        threadFlagMap.put(thread.getId(),true);
        //停止老的socket线程
        Thread threadBefore = threadMap.get(session.getId());
        if(threadBefore !=null && threadBefore.isAlive()){
            while (threadFlagMap.get(threadBefore.getId())){
            }
            threadBefore.interrupt();
        }
        //将线程存储,便于调用定位
        threadMap.put(session.getId(), this.thread);
    }

    @OnClose
    public void onClose(CloseReason closeReason){
        System.err.println("closeReason = " + closeReason);
        runFlag = false;
        if (thread != null && thread.isAlive()) {
            thread.interrupt();
        }
        threadMap.remove(session.getId());
    }

    @OnError
    public void onError(Throwable error) {
        error.printStackTrace();
        if (thread != null && thread.isAlive()) {
            thread.interrupt();
        }
        threadMap.remove(session.getId());
    }

}