认领人员列表2

lidongdong

2023-11-14 a6b461cfa9c6309fd4b6d78bf136313b70272f38

认领人员列表2

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/dtos/partybuilding/NeedProblemClaimDTO.java

@@ -23,6 +23,12 @@
    @ApiModelProperty("领取人员id")
    private String userId;

    @ApiModelProperty("领取人员姓名")
    private String userNmae;

    @ApiModelProperty("领取人员头像")
    private String userImage;

    @ApiModelProperty("服务时间")
    private String serviceTime;


 springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NeedProblemClaimMapper.xml

@@ -18,19 +18,30 @@

    <select id="getList" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemClaimDTO">
        SELECT
            <include refid="Base_Column_List" />
            nfnpc.id,
            nfnpc.task_id,
            nfnpc.user_id,
            su.name as userNmae,
            su.image_url as userImage,
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            nfnpc.service_time,
            nfnpc.unit_id,
            nfnpc.creation_time,
            nfnpc.update_time
        FROM
            new_fight_need_problem_claim
            new_fight_need_problem_claim as nfnpc
        LEFT JOIN sys_user ON su.user_id=nfnpc.user_id
        <where>
            1=1
            <if test="taskId !=null and taskId != '' ">
                and task_id =#{taskId}
                and nfnpc.task_id =#{taskId}
            </if>
            <if test="userId !=null and userId != '' ">
                and user_id =#{userId}
                and nfnpc.user_id =#{userId}
            </if>
            <if test="unitId !=null and unitId != '' ">
                and unit_id =#{unitId}
                and nfnpc.unit_id =#{unitId}
            </if>
        </where>
    </select>
@@ -38,13 +49,24 @@

    <select id="getDetails" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemClaimDTO">
        SELECT
            <include refid="Base_Column_List" />
            nfnpc.id,
            nfnpc.task_id,
            nfnpc.user_id,
            su.name as userNmae,
            su.image_url as userImage,
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            nfnpc.service_time,
            nfnpc.unit_id,
            nfnpc.creation_time,
            nfnpc.update_time
        FROM
            new_fight_need_problem_claim
        new_fight_need_problem_claim as nfnpc
        LEFT JOIN sys_user ON su.user_id=nfnpc.user_id
        <where>
            1=1
            <if test="id !=null and id != '' ">
                and id =#{id}
                and nfnpc.id =#{id}
            </if>
        </where>
    </select>
@@ -53,16 +75,27 @@

    <select id="getUserIdDetails" resultType="com.panzhihua.common.model.dtos.partybuilding.NeedProblemClaimDTO">
        SELECT
        <include refid="Base_Column_List" />
            nfnpc.id,
            nfnpc.task_id,
            nfnpc.user_id,
            su.name as userNmae,
            su.image_url as userImage,
            nfnpc.punch_start_time,
            nfnpc.punch_end_time,
            nfnpc.service_time,
            nfnpc.unit_id,
            nfnpc.creation_time,
            nfnpc.update_time
        FROM
        new_fight_need_problem_claim
        new_fight_need_problem_claim as nfnpc
        LEFT JOIN sys_user ON su.user_id=nfnpc.user_id
        <where>
            1=1
            <if test="taskId !=null and taskId != '' ">
                and task_id =#{taskId}
                and nfnpc.task_id =#{taskId}
            </if>
            <if test="userId !=null and userId != '' ">
                and user_id =#{userId}
                and nfnpc.user_id =#{userId}
            </if>
        </where>
        LIMIT 1