工单节点查询

lxw

2023-08-14 4cd30c6c3c7602089c3c0c53cf6e540baf81c86c

工单节点查询

 src/main/java/com/whyc/controller/WorkflowLinkController.java

@@ -41,7 +41,7 @@

    @GetMapping("searchTmp")
    @ApiOperation(value = "查询节点(除放电计划之外的)")
    public Response searchTmp(@RequestParam int pageNum, @RequestParam int pageSize) {
        return service.searchTmp(pageNum, pageSize);
    public Response searchTmp(@RequestParam int type, @RequestParam int pageNum, @RequestParam int pageSize) {
        return service.searchTmp(type, pageNum, pageSize);
    }
}

 src/main/java/com/whyc/mapper/WorkflowLinkMapper.java

@@ -10,5 +10,5 @@
    List<WorkflowLink> getReceivedList(int type, UserInf user);

    //查询自己需要处理或者审批的
    List<WorkflowLink> searchTmp(int uId, int uRole);
    List<WorkflowLink> searchTmp(int uId, int uRole, int type);
}

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

@@ -210,15 +210,15 @@
                updateLinkFieldAndFinish(link);
            }
        }
        return new Response().setII(1, "更新完成");
        return new Response().set(1, true);
    }

    //查询节点(除放电计划之外的)
    public Response searchTmp(int pageNum, int pageSize) {
    public Response searchTmp(int type, int pageNum, int pageSize) {
        UserInf uinf = ActionUtil.getUser();
        //查询自己需要处理或者审批的
        PageHelper.startPage(pageNum, pageSize);
        List<WorkflowLink> list = mapper.searchTmp(uinf.getUId().intValue(), uinf.getURole());
        List<WorkflowLink> list = mapper.searchTmp(uinf.getUId().intValue(), uinf.getURole(), type);
        PageInfo pageInfo = new PageInfo(list);
        return new Response().setII(1, list == null ? false : true, list, "查询节点(除放电计划之外的)");
    }

 src/main/resources/mapper/WorkflowLinkMapper.xml

@@ -1,16 +1,77 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.whyc.mapper.WorkflowLinkMapper">


    <resultMap id="disTemp" type="Fbs9100SetParamTemp">
        <id column="num" property="num"></id>
        <result column="dev_id" property="devId"></result>
        <result column="TestCmd" property="TestCmd"></result>
        <result column="DisCurr" property="DisCurr"></result>
        <result column="DisCap" property="DisCap"></result>
        <result column="DisTime" property="DisTime"></result>
        <result column="GroupVol_LOW" property="groupvolLow"></result>
        <result column="MonomerVol_LOW" property="monomervolLow"></result>
        <result column="MonomerTmp_High" property="monomertmpHigh"></result>
        <result column="DCVolHighLimit" property="DCVolHighLimit"/>
        <result column="ChargeCurrSet" property="ChargeCurrSet"/>
        <result column="is_charge" property="isCharge"/>
        <result column="main_id" property="mainId"/>
        <association property="workflowMain" javaType="WorkflowMain">
            <id column="mid" property="id"></id>
            <result column="order_id" property="orderId"></result>
            <result column="title" property="title"></result>
            <result column="task_desc" property="taskDesc"></result>
            <result column="create_user_id" property="createUserId"></result>
            <result column="create_time" property="createTime"></result>
            <result column="plan_begin_time" property="planBeginTime"></result>
            <result column="plan_end_time" property="planEndTime"></result>
            <result column="begin_time" property="beginTime"></result>
            <result column="end_time" property="endTime"></result>
            <result column="task_level" property="taskLevel"></result>
            <result column="is_in_time" property="inTime"></result>
            <result column="mstatus" property="status"></result>
            <result column="file_name" property="fileName"></result>
            <result column="file_url" property="fileUrl"></result>
            <result column="pic_name" property="picName"></result>
            <result column="pic_url" property="picUrl"></result>
            <result column="end_reason" property="endReason"></result>
            <result column="is_auto" property="auto"></result>
            <result column="type" property="type"></result>
        </association>
        <association property="workflowLink" javaType="WorkflowLink">
            <id column="lid" property="id"></id>
            <result column="main_id" property="mainId"></result>
            <result column="parent_id" property="parentId"></result>
            <result column="process_level" property="processLevel"></result>
            <result column="process_level_name" property="processLevelName"></result>
            <result column="create_time" property="createTime"></result>
            <result column="deal_user_id" property="dealUserId"></result>
            <result column="deal_type" property="dealType"></result>
            <result column="deal_desc" property="dealDesc"></result>
            <result column="deal_file_name" property="dealFileName"></result>
            <result column="deal_file_url" property="dealFileUrl"></result>
            <result column="deal_pic_name" property="dealPicName"></result>
            <result column="deal_pic_url" property="dealPicUrl"></result>
            <result column="lstatus" property="status"></result>
            <result column="deal_role_id" property="dealRoleId"></result>
            <result column="deal_and_close" property="dealAndClose"></result>
            <result column="deal_reject_reason" property="dealRejectReason"></result>
            <result column="deal_task_num" property="dealTaskNum"></result>
            <result column="deal_task_reply_num" property="dealTaskReplyNum"></result>
            <result column="deal_reason" property="dealReason"></result>
            <result column="required_finish_time" property="requiredFinishTime"></result>
            <result column="deal_time" property="dealTime"></result>
            <result column="reply_content" property="replyContent"></result>
            <result column="reply_time" property="replyTime"></result>
        </association>
    </resultMap>
    <select id="getReceivedList" resultType="com.whyc.pojo.WorkflowLink">
        (
            SELECT l.*
            SELECT l.*, m.*
            FROM web_site.tb_workflow_main m,
                 web_site.tb_workflow_link l
            where m.id = l.main_id
                 web_site.tb_workflow_link l,
                 where m.id = l.main_id
              and m.type = #{type}
              and l.deal_user_id = #{user.uId}
                and l.deal_user_id = #{user.uId}
        )
        union all
        (
@@ -26,23 +87,33 @@
    <select id="searchTmp" resultType="com.whyc.pojo.WorkflowLink">
        (
            SELECT l.*
            FROM web_site.tb_workflow_main m,
                 web_site.tb_workflow_link l
            where m.id = l.main_id
              and m.type in (2, 3)
              and l.status in (0, 6)
                 , l.id     as lid
                 , l.status as lstatus
                 , m.*
                 , m.id     as mid
                 , p.*
            FROM web_site.tb_workflow_link l
                     LEFT OUTER JOIN web_site.tb_workflow_main m on m.id = l.main_id
                     LEFT OUTER JOIN web_site.tb_fbs9100_setparam_temp p on p.main_id = l.main_id
            where l.status in (0, 6)
              and l.deal_user_id = #{uId}
              and m.type = #{type}
        )
        union all
        (
            SELECT l.*
            FROM web_site.tb_workflow_main m,
                 web_site.tb_workflow_link l
            where m.id = l.main_id
              and m.type in (2, 3)
              and l.status in (0, 6)
                 , l.id     as lid
                 , l.status as lstatus
                 , m.*
                 , m.id     as mid
                 , p.*
            FROM web_site.tb_workflow_link l
                     LEFT OUTER JOIN web_site.tb_workflow_main m on m.id = l.main_id
                     LEFT OUTER JOIN web_site.tb_fbs9100_setparam_temp p on p.main_id = l.main_id
            where l.status in (0, 6)
              and l.deal_role_id = #{uRole}
              and l.deal_user_id is null
              and m.type = #{type}
        )
    </select>
</mapper>