获取赋码规则

zxl

2025-04-01 293d4315ce81fc556d90eae06e3d87ebea754878

获取赋码规则

 business/src/main/java/com/ycl/mapper/CodingRulerMapper.java

@@ -4,7 +4,6 @@
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ycl.domain.vo.CodingRulerVO;
import com.ycl.domain.form.CodingRulerForm;
import com.ycl.domain.query.CodingRulerQuery;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
@@ -31,4 +30,6 @@
    */
    IPage getPage(IPage page, @Param("query") CodingRulerQuery query);

    List<CodingRulerVO> getStartRuler();

}

 business/src/main/resources/mapper/CodingRulerMapper.xml

@@ -13,11 +13,21 @@
        <result column="status" property="status"/>
    </resultMap>






    <select id="getStartRuler" resultMap="BaseResultMap">
        select
            TCR.project_code_type,
            TCR.interval_type,
            TCR.left_symbol,
            TCR.left_value,
            TCR.right_symbol,
            TCR.right_value,
            TCR.id,
            TCR.status
        FROM
            t_coding_ruler TCR
        WHERE
            TCR.status = 1 AND TCR.deleted = 0;
    </select>

    <select id="getById" resultMap="BaseResultMap">
        SELECT

 common/src/main/java/com/ycl/common/enums/business/CodingRulerCodeTypeEnum.java

@@ -11,7 +11,7 @@
@Getter
public enum CodingRulerCodeTypeEnum {
    RED("red", "红码"),
    GREEN("green","绿码");
    YELLOW("yellow","黄码");

    @EnumValue
    @JsonValue

 flowable/src/main/java/com/ycl/domain/vo/ProcessCodingVO.java

@@ -53,6 +53,11 @@
    @ApiModelProperty("任务状态green/red/yellow")
    private String status;

    /** 任务状态0进行中1结束 */
    @ApiModelProperty("超时任务数")
    private Long taskOvertimeNum;


    /** 任务超时状态 */
    @ApiModelProperty("任务超时状态")
    private String overtimeStatus;

 flowable/src/main/java/com/ycl/mapper/ProcessCodingMapper.java

@@ -38,4 +38,10 @@
    void updateBatch(@Param("list") List<ProcessCoding> list);

    List<ProcessCoding> findByTaskId(@Param("taskId") String taskId);

    /**
     * 查询出每个流程实例id中超时的任务数，流程实例id
     * @return
     */
    List<ProcessCodingVO> countProjectOverTimeNum();
}

 flowable/src/main/resources/mapper/ProcessCodingMapper.xml

@@ -14,6 +14,21 @@
        <result column="status" property="status" />
        <result column="overtime_status" property="overtimeStatus" />
    </resultMap>
    <resultMap id="projectProcessTaskOverNum" type="com.ycl.domain.vo.ProcessCodingVO">
        <id column="id" property="id"/>
        <result column="task_overtime_num" property="taskOvertimeNum"/>
        <result column="process_ins_id" property="processInsId"/>
    </resultMap>

    <select id="countProjectOverTimeNum" resultMap="projectProcessTaskOverNum">
        select TPC.id,
               TPC.process_ins_id,
               COUNT(TPC.overtime_status) as task_overtime_num
        FROM t_process_coding TPC
        where
                TPC.overtime_status = 'overtime'
        GROUP BY TPC.process_ins_id
    </select>


    <select id="getById" resultMap="BaseResultMap">