添加活动详情 用户是否参加

lidongdong

2023-10-23 41548c00e1b896f9944de4db283a6c8507dc07f8

添加活动详情  用户是否参加

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiExperienceActivityVO.java

@@ -65,6 +65,8 @@
    @ApiModelProperty(value = "封面")
    private String coverImgUrl;

    @ApiModelProperty(value = "是否参加（0 未参加   1已参加）")
    private String isJoin;

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

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/entity/JinhuiExperienceActivity.java

@@ -67,6 +67,11 @@
    private String number;


    @TableField(exist = false)
    @ApiModelProperty(value = "是否参加（0 未参加   1已参加）")
    private String isJoin;


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

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiExperienceActivityMapper.xml

@@ -49,27 +49,28 @@

    <select id="getDetails" resultMap="itemMap">
        select
            id,
            title,
            address,
            lat,
            lon,
            apply_start_time,
            apply_end_time,
            activity_start_time,
            activity_end_time,
            people_number,
            (select count(jae.id) from jinhui_apply_experience as jae
             where jae.activity_id=jinhui_experience_activity.id) as number,
            phone,
            award,
            cover_img_url,
            creation_time,
            update_time,
            activity_type
        from jinhui_experience_activity
            jeeea.id,
            jeeea.title,
            jeeea.address,
            jeeea.lat,
            jeeea.lon,
            jeeea.apply_start_time,
            jeeea.apply_end_time,
            jeeea.activity_start_time,
            jeeea.activity_end_time,
            jeeea.people_number,
            (count(jae.id)) as number,
            IF(jae.id == null , '0', '1') as isJoin,
            jeeea.phone,
            jeeea.award,
            jeeea.cover_img_url,
            jeeea.creation_time,
            jeeea.update_time,
            jeeea.activity_type
        from jinhui_experience_activity as jeeea
        Left join jinhui_apply_experience as jae on jae.activity_id=jeeea.id
        where
            id=#{id}
            jeeea.id=#{id}
    </select>

    <insert id="addData">