| | |
| | | @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; |
| | | |
| | | |
| | | } |
| | |
| | | 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; |
| | | |
| | | |
| | | } |
| | |
| | | <!-- 分页查询 --> |
| | | <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"> |