New file |
| | |
| | | package com.panzhihua.common.model.vos.jinhui; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.Builder; |
| | | import lombok.Data; |
| | | import lombok.NoArgsConstructor; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | @Builder |
| | | @AllArgsConstructor |
| | | @NoArgsConstructor |
| | | @ApiModel("金汇社区商家配置") |
| | | public class JinhuiConfigVO implements Serializable { |
| | | private static final long serialVersionUID = -70884515430727555L; |
| | | |
| | | @ApiModelProperty(value = "主键") |
| | | private String id; |
| | | |
| | | |
| | | @ApiModelProperty(value = "社区id") |
| | | private String communityId; |
| | | |
| | | @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; |
| | | |
| | | @ApiModelProperty(value = "创建时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date creationTime; |
| | | |
| | | @ApiModelProperty(value = "更新时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date updateTime; |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | @ApiModelProperty(value = "电话") |
| | | private String phone; |
| | | |
| | | |
| | | @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; |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | public R orderExpurgateData(@RequestParam("id") String id); |
| | | |
| | | |
| | | /*************************************************************************************************************** |
| | | * |
| | | * |
| | | * 社区配置兑换地址 时间 |
| | | * |
| | | * ******************************************************************************************************* |
| | | * @return |
| | | */ |
| | | |
| | | @GetMapping("/jinhuiConfig/configGetDetails") |
| | | public R configGetDetails(@RequestParam("communityId") String communityId); |
| | | |
| | | |
| | | @PostMapping("/jinhuiConfig/configAddData") |
| | | public R configAddData(@RequestBody JinhuiConfigVO item); |
| | | |
| | | @PostMapping("/jinhuiConfig/configEditData") |
| | | public R configEditData(@RequestBody JinhuiConfigVO item); |
| | | |
| | | @DeleteMapping("/jinhuiConfig/configExpurgateData") |
| | | public R configExpurgateData(@RequestParam("communityId") String communityId); |
| | | |
| | | } |
| | |
| | | |
| | | |
| | | |
| | | /*************************************************************************************************************** |
| | | * |
| | | * |
| | | * 社区配置兑换地址 时间 |
| | | * |
| | | * ******************************************************************************************************* |
| | | * @param item |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "社区配置兑换地址详情", response = JinhuiConfigVO.class) |
| | | @GetMapping("/configGetDetails") |
| | | public R configGetDetails() |
| | | { |
| | | return jinhuiCommunityService.configGetDetails(getCommunityId()+""); |
| | | } |
| | | |
| | | |
| | | @ApiOperation(value = "社区配置兑换地址添加") |
| | | @PostMapping("/configAddData") |
| | | public R configAddData(@RequestBody JinhuiConfigVO item) |
| | | { |
| | | item.setCommunityId(getCommunityId()+""); |
| | | return jinhuiCommunityService.configAddData(item); |
| | | } |
| | | |
| | | @ApiOperation(value = "社区配置兑换地址编辑") |
| | | @PostMapping("/configEditData") |
| | | public R configEditData(@RequestBody JinhuiConfigVO item) |
| | | { |
| | | item.setCommunityId(getCommunityId()+""); |
| | | return jinhuiCommunityService.configEditData(item); |
| | | } |
| | | |
| | | @ApiOperation(value = "社区配置兑换地址删除") |
| | | @DeleteMapping("/configExpurgateData") |
| | | public R configExpurgateData() |
| | | { |
| | | return jinhuiCommunityService.configExpurgateData(getCommunityId()+""); |
| | | } |
| | | |
| | | |
| | | |
| | | } |
New file |
| | |
| | | package com.panzhihua.service_jinhui_community.api; |
| | | |
| | | |
| | | import com.panzhihua.common.model.vos.R; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiConfigVO; |
| | | import com.panzhihua.service_jinhui_community.service.JinhuiConfigService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.web.bind.annotation.*; |
| | | |
| | | import javax.annotation.Resource; |
| | | |
| | | @Slf4j |
| | | @RestController |
| | | @RequestMapping("/jinhuiConfig") |
| | | public class JinhuiConfigApi |
| | | { |
| | | |
| | | @Resource |
| | | private JinhuiConfigService configService; |
| | | |
| | | @GetMapping("/configGetDetails") |
| | | public R configGetDetails(@RequestParam("communityId") String communityId) |
| | | { |
| | | return R.ok(configService.getDetails(communityId)); |
| | | } |
| | | |
| | | /** |
| | | * 新增 |
| | | * @param |
| | | * @return |
| | | */ |
| | | @PostMapping("/configAddData") |
| | | public R configAddData(@RequestBody JinhuiConfigVO item) |
| | | { |
| | | return configService.addData(item); |
| | | } |
| | | |
| | | @PostMapping("/configEditData") |
| | | public R configEditData(@RequestBody JinhuiConfigVO item) |
| | | { |
| | | return configService.editData(item); |
| | | } |
| | | |
| | | @DeleteMapping("/configExpurgateData") |
| | | public R configExpurgateData(@RequestParam("communityId") String communityId) |
| | | { |
| | | return configService.expurgateData(communityId); |
| | | } |
| | | |
| | | } |
| | |
| | | @RequestParam(value = "name", required = false)String name, |
| | | @RequestParam(value = "cancelType", required = false)String cancelType) |
| | | { |
| | | return orderService.getList(pageNum,pageSize,userId,goodsId,orderNumber,goodName,name,cancelType); |
| | | return orderService.getList(pageNum,pageSize,userId,goodsId,orderNumber, |
| | | goodName,name,cancelType,getCommunityId()+""); |
| | | } |
| | | |
| | | /** |
| | |
| | | @GetMapping("/orderGetDetails") |
| | | public R orderGetDetails(@RequestParam("id") String id) |
| | | { |
| | | return R.ok(orderService.getDetails(id)); |
| | | return R.ok(orderService.getDetails(id,getCommunityId()+"")); |
| | | } |
| | | |
| | | /** |
| | |
| | | @GetMapping("/orderCancelOrder") |
| | | public R orderCancelOrder(@RequestParam("orderId") String orderId) |
| | | { |
| | | return orderService.cancelOrder(orderId); |
| | | return orderService.cancelOrder(orderId,getCommunityId()+""); |
| | | } |
| | | |
| | | |
| | |
| | | @DeleteMapping("/orderExpurgateData") |
| | | public R orderExpurgateData(@RequestParam("id") String id) |
| | | { |
| | | return orderService.expurgateData(id); |
| | | return orderService.expurgateData(id,getCommunityId()+""); |
| | | } |
| | | |
| | | |
New file |
| | |
| | | package com.panzhihua.service_jinhui_community.dao; |
| | | |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiConfigVO; |
| | | import com.panzhihua.service_jinhui_community.entity.JinhuiConfig; |
| | | import org.apache.ibatis.annotations.Mapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | @Mapper |
| | | public interface JinhuiConfigDao extends BaseMapper<JinhuiConfig> |
| | | { |
| | | |
| | | /** |
| | | * 详情 |
| | | * @param communityId |
| | | * @return |
| | | */ |
| | | JinhuiConfig getDetails(@Param("communityId") String communityId); |
| | | |
| | | /** |
| | | * 新增 |
| | | * @param |
| | | * @return |
| | | */ |
| | | int addData(@Param("item") JinhuiConfigVO item); |
| | | |
| | | |
| | | /** |
| | | * 编辑 |
| | | * @param item |
| | | * @return |
| | | */ |
| | | int editData(@Param("item") JinhuiConfigVO item); |
| | | |
| | | /** |
| | | * 删除 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | int expurgateData(@Param("communityId") String communityId); |
| | | |
| | | |
| | | } |
| | |
| | | @Param("orderNumber") String orderNumber, |
| | | @Param("goodName") String goodName, |
| | | @Param("name") String name, |
| | | @Param("cancelType") String cancelType); |
| | | @Param("cancelType") String cancelType, |
| | | @Param("community_id") String communityId); |
| | | |
| | | /** |
| | | * 详情 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | JinhuiShoppingOrder getDetails(@Param("id") String id); |
| | | JinhuiShoppingOrder getDetails(@Param("id") String id, |
| | | @Param("community_id") String communityId); |
| | | |
| | | /** |
| | | * 新增 |
New file |
| | |
| | | package com.panzhihua.service_jinhui_community.entity; |
| | | |
| | | import com.fasterxml.jackson.annotation.JsonFormat; |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.Builder; |
| | | import lombok.Data; |
| | | import lombok.NoArgsConstructor; |
| | | |
| | | import java.io.Serializable; |
| | | import java.util.Date; |
| | | |
| | | @Data |
| | | @Builder |
| | | @AllArgsConstructor |
| | | @NoArgsConstructor |
| | | @ApiModel("金汇社区商家配置") |
| | | public class JinhuiConfig implements Serializable { |
| | | private static final long serialVersionUID = -70884515430727555L; |
| | | |
| | | @ApiModelProperty(value = "主键") |
| | | private String id; |
| | | |
| | | |
| | | @ApiModelProperty(value = "社区id") |
| | | private String communityId; |
| | | |
| | | @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; |
| | | |
| | | @ApiModelProperty(value = "创建时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date creationTime; |
| | | |
| | | @ApiModelProperty(value = "更新时间") |
| | | @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") |
| | | private Date updateTime; |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | |
| | | @ApiModelProperty(value = "电话") |
| | | private String phone; |
| | | |
| | | |
| | | |
| | | @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; |
| | | } |
New file |
| | |
| | | package com.panzhihua.service_jinhui_community.service; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.IService; |
| | | import com.panzhihua.common.model.vos.R; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiConfigVO; |
| | | import com.panzhihua.service_jinhui_community.entity.JinhuiConfig; |
| | | |
| | | public interface JinhuiConfigService extends IService<JinhuiConfig> |
| | | { |
| | | |
| | | JinhuiConfig getDetails(String id); |
| | | /** |
| | | * 新增 |
| | | * @param |
| | | * @return |
| | | */ |
| | | R addData(JinhuiConfigVO item); |
| | | |
| | | R editData(JinhuiConfigVO item); |
| | | |
| | | R expurgateData(String id); |
| | | } |
| | |
| | | * @return |
| | | */ |
| | | R getList(int pageNum,int pageSize,String userId,String goodsId,String orderNumber, |
| | | String goodName,String name,String cancelType); |
| | | String goodName,String name,String cancelType,String communityId); |
| | | |
| | | JinhuiShoppingOrder getDetails(String id); |
| | | JinhuiShoppingOrder getDetails(String id,String communityId); |
| | | /** |
| | | * 新增 |
| | | * @param |
| | |
| | | |
| | | R editData(JinhuiShoppingOrderVO item); |
| | | |
| | | R cancelOrder(String orderId); |
| | | R cancelOrder(String orderId,String communityId); |
| | | |
| | | |
| | | |
| | | R expurgateData(String id); |
| | | R expurgateData(String id,String communityId); |
| | | } |
New file |
| | |
| | | package com.panzhihua.service_jinhui_community.service.impl; |
| | | |
| | | import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; |
| | | import com.panzhihua.common.model.vos.R; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiConfigVO; |
| | | import com.panzhihua.service_jinhui_community.dao.JinhuiConfigDao; |
| | | import com.panzhihua.service_jinhui_community.entity.JinhuiConfig; |
| | | import com.panzhihua.service_jinhui_community.service.JinhuiConfigService; |
| | | import lombok.extern.slf4j.Slf4j; |
| | | import org.springframework.stereotype.Service; |
| | | |
| | | |
| | | @Slf4j |
| | | @Service |
| | | public class JinhuiConfigServiceImpl extends ServiceImpl<JinhuiConfigDao, |
| | | JinhuiConfig> implements JinhuiConfigService |
| | | { |
| | | |
| | | @Override |
| | | public JinhuiConfig getDetails(String id) { |
| | | return baseMapper.getDetails(id); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public R addData(JinhuiConfigVO item) |
| | | { |
| | | int num= baseMapper.addData(item); |
| | | if(num>0) |
| | | { |
| | | return R.ok(); |
| | | } |
| | | return R.fail("添加失败"); |
| | | } |
| | | |
| | | @Override |
| | | public R editData(JinhuiConfigVO item) { |
| | | int num= baseMapper.editData(item); |
| | | if(num>0) |
| | | { |
| | | return R.ok(); |
| | | } |
| | | return R.fail("添加失败"); |
| | | } |
| | | |
| | | @Override |
| | | public R expurgateData(String id) { |
| | | int num= baseMapper.expurgateData(id); |
| | | if(num>0) |
| | | { |
| | | return R.ok(); |
| | | } |
| | | return R.fail("添加失败"); |
| | | } |
| | | } |
| | |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiCoinGeneralTableVO; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiGoldCoinRecordVO; |
| | | import com.panzhihua.common.model.vos.jinhui.JinhuiShoppingOrderVO; |
| | | import com.panzhihua.common.utlis.Snowflake; |
| | | import com.panzhihua.service_jinhui_community.dao.JinhuiShoppingOrderDao; |
| | | import com.panzhihua.service_jinhui_community.entity.JinhuiCoinGeneralTable; |
| | | import com.panzhihua.service_jinhui_community.entity.JinhuiShopping; |
| | |
| | | |
| | | @Override |
| | | public R getList(int pageNum,int pageSize,String userId,String goodsId,String orderNumber, |
| | | String goodName,String name,String cancelType) |
| | | String goodName,String name,String cancelType,String communityId) |
| | | { |
| | | Page page = new Page<JinhuiShopping>(pageNum,pageSize); |
| | | return R.ok(baseMapper.getList(page,userId,goodsId,orderNumber,goodName,name,cancelType)); |
| | | return R.ok(baseMapper.getList(page,userId,goodsId,orderNumber,goodName,name,cancelType,communityId)); |
| | | } |
| | | |
| | | @Override |
| | | public JinhuiShoppingOrder getDetails(String id) { |
| | | return baseMapper.getDetails(id); |
| | | public JinhuiShoppingOrder getDetails(String id,String communityId) { |
| | | return baseMapper.getDetails(id,communityId); |
| | | } |
| | | |
| | | |
| | | @Override |
| | | public R addData(JinhuiShoppingOrderVO item) |
| | | { |
| | | item.setOrderNumber(Snowflake.getId()+""); |
| | | JinhuiCoinGeneralTable generalTable=tableService.getDetails(item.getUserId()); |
| | | JinhuiShopping goods=shoppingService.getDetails(item.getGoodsId()); |
| | | |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R cancelOrder(String orderId) |
| | | public R cancelOrder(String orderId,String communityId) |
| | | { |
| | | JinhuiShoppingOrder order=baseMapper.getDetails(orderId); |
| | | JinhuiShoppingOrder order=baseMapper.getDetails(orderId,communityId); |
| | | |
| | | if(!StringUtils.equals("0",order.getCancelType())) |
| | | { |
| | |
| | | } |
| | | |
| | | @Override |
| | | public R expurgateData(String id) |
| | | public R expurgateData(String id,String communityId) |
| | | { |
| | | JinhuiShoppingOrder order=baseMapper.getDetails(id); |
| | | JinhuiShoppingOrder order=baseMapper.getDetails(id,communityId); |
| | | |
| | | if(StringUtils.equals("0",order.getCancelType())) |
| | | { |
| | |
| | | jso.user_id, |
| | | su.name, |
| | | su.phone, |
| | | vcc.address, |
| | | vcc.lat, |
| | | vcc.lng, |
| | | vcc.business_type, |
| | | vcc.business_start_time, |
| | | vcc.business_end_time, |
| | | jso.creation_time, |
| | | jso.cancel_type, |
| | | jso.update_time, |
| | |
| | | from jinhui_shopping_order as jso |
| | | LEFT JOIN sys_user su ON jso.user_id = su.user_id |
| | | LEFT JOIN jinhui_shopping js ON js.id = jso.goods_id |
| | | LEFT JOIN volunteer_community_config as vcc ON vcc.community_id=#{communityId} |
| | | <where> |
| | | 1=1 |
| | | <if test="userId !=null and userId !='' "> |
| | |
| | | jso.user_id, |
| | | su.name, |
| | | su.phone, |
| | | vcc.address, |
| | | vcc.lat, |
| | | vcc.lng, |
| | | vcc.business_type, |
| | | vcc.business_start_time, |
| | | vcc.business_end_time, |
| | | jso.creation_time, |
| | | jso.cancel_type, |
| | | jso.update_time, |
| | |
| | | from jinhui_shopping_order as jso |
| | | LEFT JOIN sys_user su ON jso.user_id = su.user_id |
| | | LEFT JOIN jinhui_shopping js ON js.id = jso.goods_id |
| | | LEFT JOIN volunteer_community_config as vcc ON vcc.community_id=#{communityId} |
| | | where |
| | | jso.id=#{id} |
| | | </select> |
New file |
| | |
| | | <?xml version="1.0" encoding="UTF-8"?> |
| | | <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> |
| | | <mapper namespace="com.panzhihua.service_jinhui_community.dao.JinhuiConfigDao"> |
| | | |
| | | <resultMap type="com.panzhihua.service_jinhui_community.entity.JinhuiConfig" id="itemMap"> |
| | | <result property="id" column="id" /> |
| | | <result property="communityId" column="community_id" /> |
| | | <result property="address" column="address" /> |
| | | <result property="lat" column="lat" /> |
| | | <result property="lng" column="lng" /> |
| | | <result property="businessType" column="business_type" /> |
| | | <result property="businessStartTime" column="business_start_time" /> |
| | | <result property="businessEndTime" column="business_end_time" /> |
| | | |
| | | <result property="creationTime" column="creation_time" /> |
| | | <result property="updateTime" column="update_time" /> |
| | | </resultMap> |
| | | |
| | | |
| | | <select id="getDetails" resultMap="itemMap"> |
| | | select |
| | | id, |
| | | community_id, |
| | | address, |
| | | lat, |
| | | lng, |
| | | creation_time, |
| | | update_time, |
| | | business_type, |
| | | business_start_time, |
| | | business_end_time |
| | | from volunteer_community_config |
| | | where community_id=#{communityId} |
| | | </select> |
| | | |
| | | <insert id="addData"> |
| | | insert into volunteer_community_config |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="item.id != null and item.id != '' "> |
| | | id, |
| | | </if> |
| | | <if test="item.communityId != null and item.communityId != '' "> |
| | | community_id, |
| | | </if> |
| | | <if test="item.address != null and item.address != '' "> |
| | | address, |
| | | </if> |
| | | <if test="item.lat != null and item.lat != '' "> |
| | | lat, |
| | | </if> |
| | | <if test="item.lng != null and item.lng != '' "> |
| | | lng, |
| | | </if> |
| | | <if test="item.businessType != null and item.businessType != '' "> |
| | | business_type, |
| | | </if> |
| | | <if test="item.businessStartTime != null and item.businessStartTime != '' "> |
| | | business_start_time, |
| | | </if> |
| | | <if test="item.businessEndTime != null and item.businessEndTime != '' "> |
| | | business_end_time, |
| | | </if> |
| | | creation_time |
| | | </trim> |
| | | values |
| | | <trim prefix="(" suffix=")" suffixOverrides=","> |
| | | <if test="item.id != null and item.id != '' "> |
| | | #{item.id}, |
| | | </if> |
| | | <if test="item.communityId != null and item.communityId != '' "> |
| | | #{item.communityId}, |
| | | </if> |
| | | <if test="item.address != null and item.address != '' "> |
| | | #{item.address}, |
| | | </if> |
| | | <if test="item.lat != null and item.lat != '' "> |
| | | #{item.lat}, |
| | | </if> |
| | | <if test="item.lng != null and item.lng != '' "> |
| | | #{item.lng}, |
| | | </if> |
| | | <if test="item.businessType != null and item.businessType != '' "> |
| | | #{item.businessType}, |
| | | </if> |
| | | <if test="item.businessStartTime != null and item.businessStartTime != '' "> |
| | | #{item.businessStartTime}, |
| | | </if> |
| | | <if test="item.businessEndTime != null and item.businessEndTime != '' "> |
| | | #{item.businessEndTime}, |
| | | </if> |
| | | sysdate() |
| | | </trim> |
| | | </insert> |
| | | |
| | | <update id="editData"> |
| | | update volunteer_community_config |
| | | <set> |
| | | <if test="item.id != null and item.id != '' "> |
| | | id=#{item.id}, |
| | | </if> |
| | | <if test="item.communityId != null and item.communityId != '' "> |
| | | community_id=#{item.communityId}, |
| | | </if> |
| | | <if test="item.address != null and item.address != '' "> |
| | | address=#{item.address}, |
| | | </if> |
| | | <if test="item.lat != null and item.lat != '' "> |
| | | lat=#{item.lat}, |
| | | </if> |
| | | <if test="item.lng != null and item.lng != '' "> |
| | | lng=#{item.lng}, |
| | | </if> |
| | | <if test="item.businessType != null and item.businessType != '' "> |
| | | business_type=#{item.businessType}, |
| | | </if> |
| | | <if test="item.businessStartTime != null and item.businessStartTime != '' "> |
| | | business_start_time=#{item.businessStartTime}, |
| | | </if> |
| | | <if test="item.businessEndTime != null and item.businessEndTime != '' "> |
| | | business_end_time=#{item.businessEndTime}, |
| | | </if> |
| | | update_time=sysdate() |
| | | </set> |
| | | where community_id = #{item.communityId} |
| | | </update> |
| | | |
| | | <delete id="expurgateData" parameterType="String"> |
| | | delete from volunteer_community_config where community_id=#{communityId} |
| | | </delete> |
| | | |
| | | </mapper> |