新增党员参加项目模块1

lidongdong

2023-11-13 bebfc5c657b0a5aac2319aa0d044b1baa3a375d1

新增党员参加项目模块1

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

@@ -21,6 +21,12 @@
    @ApiModelProperty("参与用户id")
    private String userId;

    @ApiModelProperty("参与用户姓名")
    private String userName;

    @ApiModelProperty("参与用户头像")
    private String userImg;

    @ApiModelProperty("创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date creationTime;

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

@@ -12,23 +12,39 @@
    </sql>

    <select id="getList" resultType="com.panzhihua.common.model.dtos.partybuilding.NewFightProjectJoinDTO">
        SELECT <include refid="Base_Column_List"></include>
        FROM new_fight_project_join
        SELECT
            nfpj.id,
            nfpj.project_id,
            nfpj.user_id,
            su.name as userName,
            su.image_url as userImg,
            nfpj.creation_time,
            nfpj.update_time
        FROM new_fight_project_join as nfpj
        LEFT JOIN sys_user as su ON su.user_id=nfpj.user_id
        <where>
            1=1
            <if test="projectId !=null and projectId != '' ">
                and project_id=#{projectId}
                and nfpj.project_id=#{projectId}
            </if>
        </where>
    </select>

    <select id="getDetails" resultType="com.panzhihua.common.model.dtos.partybuilding.NewFightProjectJoinDTO">
        SELECT <include refid="Base_Column_List"></include>
        FROM new_fight_project_join
        SELECT
            nfpj.id,
            nfpj.project_id,
            nfpj.user_id,
            su.name as userName,
            su.image_url as userImg,
            nfpj.creation_time,
            nfpj.update_time
        FROM new_fight_project_join as nfpj
        LEFT JOIN sys_user as su ON su.user_id=nfpj.user_id
        <where>
            1=1
            <if test="id !=null and id != '' ">
                and id =#{id}
                and nfpj.id =#{id}
            </if>
        </where>
    </select>