lidongdong
2023-11-24 0432f70f7236438a470cf3e0e41d533bda67c296
商品详情增加  兑换地址信息
3个文件已修改
99 ■■■■ 已修改文件
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/building/NewFightShoppingVO.java 16 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/entity/NewFightShopping.java 17 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightShoppingMapper.xml 66 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/building/NewFightShoppingVO.java
@@ -48,7 +48,23 @@
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date updateTime;
    @ApiModelProperty(value = "地址")
    private String address;
    @ApiModelProperty(value = "纬度")
    private String lat;
    @ApiModelProperty(value = "经度")
    private String lng;
    @ApiModelProperty(value = "兑换状态(1每天  2周一到周五   3周末)")
    private String businessType;
    @ApiModelProperty(value = "兑换开始时间")
    private String businessStartTime;
    @ApiModelProperty(value = "兑换结束时间")
    private String businessEndTime;
}
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/java/com/panzhihua/service_dangjian/entity/NewFightShopping.java
@@ -49,6 +49,23 @@
    private Date updateTime;
    @ApiModelProperty(value = "地址")
    private String address;
    @ApiModelProperty(value = "纬度")
    private String lat;
    @ApiModelProperty(value = "经度")
    private String lng;
    @ApiModelProperty(value = "兑换状态(1每天  2周一到周五   3周末)")
    private String businessType;
    @ApiModelProperty(value = "兑换开始时间")
    private String businessStartTime;
    @ApiModelProperty(value = "兑换结束时间")
    private String businessEndTime;
}
springcloud_k8s_panzhihuazhihuishequ/service_partybuilding/src/main/resources/mapper/NewFightShoppingMapper.xml
@@ -18,49 +18,63 @@
    <!-- 分页查询 -->
    <select id="getList" resultMap="itemMap">
        select
            id,
            good_name,
            good_price,
            good_type,
            cover_img_url,
            content,
            community_id,
            creation_time,
            update_time
        from new_fight_shopping
            nfs.id,
            nfs.good_name,
            nfs.good_price,
            nfs.good_type,
            nfs.cover_img_url,
            nfs.content,
            nfs.community_id,
            nfs.creation_time,
            nfs.update_time,
            vcc.address,
            vcc.lat,
            vcc.lng,
            vcc.business_type,
            vcc.business_start_time,
            vcc.business_end_time
        from new_fight_shopping as nfs
        LEFT JOIN new_fight_community_config as vcc ON vcc.community_id=jso.community_id
        <where>
            1=1
            <if test="communityId !=null and communityId !='' ">
                and community_id=#{communityId}
                and nfs.community_id=#{communityId}
            </if>
            <if test="goodName !=null and goodName !='' ">
                and good_name LIKE CONCAT('%', #{goodName}, '%')
                and nfs.good_name LIKE CONCAT('%', #{goodName}, '%')
            </if>
            <if test="goodType !=null and goodType !='' ">
                and good_type=#{goodType}
                and nfs.good_type=#{goodType}
            </if>
            <if test="id !=null and id !='' ">
                and id=#{id}
                and nfs.id=#{id}
            </if>
        </where>
        order by creation_time desc
        order by nfs.creation_time desc
    </select>
    <select id="getDetails" resultMap="itemMap">
        select
            id,
            good_name,
            good_price,
            good_type,
            cover_img_url,
            content,
            community_id,
            creation_time,
            update_time
        from new_fight_shopping
            nfs.id,
            nfs.good_name,
            nfs.good_price,
            nfs.good_type,
            nfs.cover_img_url,
            nfs.content,
            nfs.community_id,
            nfs.creation_time,
            nfs.update_time,
            vcc.address,
            vcc.lat,
            vcc.lng,
            vcc.business_type,
            vcc.business_start_time,
            vcc.business_end_time
        from new_fight_shopping as nfs
        LEFT JOIN new_fight_community_config as vcc ON vcc.community_id=jso.community_id
        where
            id=#{id}
            nfs.id=#{id}
    </select>
    <insert id="addData">