springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/VolunteerActivityVO.java
New file @@ -0,0 +1,126 @@ package com.panzhihua.common.model.vos.community; import com.fasterxml.jackson.annotation.JsonFormat; import io.swagger.annotations.ApiModel; import io.swagger.annotations.ApiModelProperty; import lombok.Data; import java.util.Date; @Data @ApiModel("志愿者活动") public class VolunteerActivityVO { /** * 主键 */ @ApiModelProperty(value = "主键") private String id; /** * 活动名称 */ @ApiModelProperty(value = "活动名称") private String name; /** * 活动状态 */ @ApiModelProperty(value = "活动状态") private String acType; /** * 活动地址 */ @ApiModelProperty(value = "活动地址") private String address; /** * 志愿者人数 */ @ApiModelProperty(value = "志愿者人数") private String volunteerNum; /** * 活动状态 */ @ApiModelProperty(value = "活动状态") private String acState; /** * 奖励发放状态 */ @ApiModelProperty(value = "奖励发放状态") private String awardState; /** * 发布时间 */ @ApiModelProperty(value = "发布时间") private String issueTime; /** * 报名开始时间 */ @ApiModelProperty(value = "报名开始时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date applyBeginTime; /** * 报名结束时间 */ @ApiModelProperty(value = "报名结束时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date applyEndTime; /** * 活动开始时间 */ @ApiModelProperty(value = "活动开始时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date actityBeginTime; /** * 活动结束时间 */ @ApiModelProperty(value = "活动结束时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date actityEndTime; /** * 志愿者上限（0无限 大于0 就是限制） */ @ApiModelProperty(value = "志愿者上限（0无限 大于0 就是限制）") private String volunteerLimit; /** * 奖励积分 */ @ApiModelProperty(value = "奖励积分") private String bonusPoints; /** * 是否可以报名后取消（0 不可以 1可以） */ @ApiModelProperty(value = "是否可以报名后取消（0 不可以 1可以）") private String isCancelled; /** * 联系人姓名 */ @ApiModelProperty(value = "联系人姓名") private String contactName; /** * 联系人电话 */ @ApiModelProperty(value = "联系人电话") private String contactPhone; /** * 活动封面 */ @ApiModelProperty(value = "活动封面") private String activitCoverUrl; /** * 活动内容 */ @ApiModelProperty(value = "活动内容") private String activityContent; /** * 创建时间 */ @ApiModelProperty(value = "创建时间") @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8") private Date creationTime; /** * 社区id */ @ApiModelProperty(value = "社区id") private String communityId; } springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java
@@ -1,5 +1,6 @@ package com.panzhihua.common.service.community; import java.util.Date; import java.util.List; import com.panzhihua.common.model.dtos.PageBaseDTO; @@ -11265,8 +11266,50 @@ public R deleteById(@RequestParam("id") String Id); /******************************************************************************************************************** * * * 志愿者活动 * * *******************************************************************************************************************/ /** * 获取单个详情 * @param id * @return */ @GetMapping("Volunteer/queryById") R volunteerQueryById(@RequestParam("id") String id); /** * 分页查询 * @param * @return */ @GetMapping("Volunteer/queryList") R volunteerQueryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize") int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "acState", required = false) String acState, @RequestParam(value = "acType", required = false) String acType, @RequestParam(value = "actityBeginTime", required = false) Date actityBeginTime, @RequestParam(value = "actityEndTime", required = false) Date actityEndTime); /** * 新增 * @param * @return */ @PostMapping("Volunteer/insertVolunteer") R insertVolunteer(@RequestBody VolunteerActivityVO volunteerActivityVO); @PostMapping("Volunteer/updateById") R volunteerUpdateById(@RequestBody VolunteerActivityVO volunteerActivityVO); @DeleteMapping("Volunteer/deleteById") R volunteerDeleteById(@RequestParam("id") String id); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/VolunteerActivityApi.java
New file @@ -0,0 +1,72 @@ package com.panzhihua.community_backstage.api; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.VolunteerActivityVO; import com.panzhihua.common.service.community.CommunityService; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.Date; @Slf4j @RestController @RequestMapping("/Volunteer") public class VolunteerActivityApi { @Resource private CommunityService communityService; /** * 获取单个详情 * @param id * @return */ @GetMapping("/queryById") public R queryById(@RequestParam("id") String id) { return communityService.volunteerQueryById(id); } /** * 分页查询 * @param * @return */ @GetMapping("/queryList") R queryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize") int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "acState", required = false) String acState, @RequestParam(value = "acType", required = false) String acType, @RequestParam(value = "actityBeginTime", required = false) Date actityBeginTime, @RequestParam(value = "actityEndTime", required = false) Date actityEndTime) { return communityService.volunteerQueryList(pageNum, pageSize, name, acState, acType, actityBeginTime, actityEndTime); } /** * 新增 * @param * @return */ @PostMapping("/insertVolunteer") R insertVolunteer(@RequestBody VolunteerActivityVO volunteerActivityVO) { return communityService.insertVolunteer(volunteerActivityVO); } @PostMapping("/updateById") R updateById(@RequestBody VolunteerActivityVO volunteerActivityVO) { return communityService.volunteerUpdateById(volunteerActivityVO); } @DeleteMapping("/deleteById") R deleteById(@RequestParam("id") String id) { return communityService.volunteerDeleteById(id); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/VolunteerActivityApi.java
New file @@ -0,0 +1,88 @@ package com.panzhihua.service_community.api; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.VolunteerActivityVO; import com.panzhihua.service_community.service.VolunteerActivityService; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; import java.util.Date; @Slf4j @RestController @RequestMapping("/Volunteer") public class VolunteerActivityApi { @Resource private VolunteerActivityService volunteerActivityService; /** * 获取单个详情 * @param id * @return */ @GetMapping("/queryById") public R queryById(@RequestParam("id") String id) { return R.ok(volunteerActivityService.queryById(id)); } /** * 分页查询 * @param * @return */ @GetMapping("/queryList") R queryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize") int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "acState", required = false) String acState, @RequestParam(value = "acType", required = false) String acType, @RequestParam(value = "actityBeginTime", required = false) Date actityBeginTime, @RequestParam(value = "actityEndTime", required = false) Date actityEndTime) { return R.ok(volunteerActivityService.queryList(pageNum, pageSize, name, acState, acType, actityBeginTime, actityEndTime)); } /** * 新增 * @param * @return */ @PostMapping("/insertVolunteer") R insertVolunteer(@RequestBody VolunteerActivityVO volunteerActivityVO) { int num = volunteerActivityService.insertVolunteer(volunteerActivityVO); if(num>0) { return R.ok(); } return R.fail(); } @PostMapping("/updateById") R updateById(@RequestBody VolunteerActivityVO volunteerActivityVO) { int num = volunteerActivityService.updateById(volunteerActivityVO); if(num>0) { return R.ok(); } return R.fail(); } @DeleteMapping("/deleteById") R deleteById(@RequestParam("id") String id) { int num = volunteerActivityService.deleteById(id); if(num>0) { return R.ok(); } return R.fail(); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/MostBeautifulVolunteerDao.java
@@ -3,15 +3,10 @@ import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.vos.community.ComActActivityTypeVO; import com.panzhihua.common.model.vos.community.MostBeautifulVolunteerVO; import com.panzhihua.service_community.entity.McsEvaluate; import com.panzhihua.service_community.entity.MostBeautifulVolunteer; import com.panzhihua.service_community.entity.SysUser; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; /** * 用户表 后台用户+小程序用户(SysUser)表数据库访问层 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/VolunteerActivityDao.java
New file @@ -0,0 +1,50 @@ package com.panzhihua.service_community.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.panzhihua.common.model.vos.community.VolunteerActivityVO; import com.panzhihua.service_community.entity.VolunteerActivity; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.Date; @Mapper public interface VolunteerActivityDao extends BaseMapper<VolunteerActivity> { /** * 获取单个详情 * @param id * @return */ VolunteerActivity queryById(@Param("id") String id); /** * 分页查询 * @param * @return */ IPage<VolunteerActivity> queryList(Page page, @Param("name") String name, @Param("acState") String acState, @Param("acType") String acType, @Param("actityBeginTime") Date actityBeginTime, @Param("actityEndTime") Date actityEndTime); /** * 新增 * @param * @return */ int insertVolunteer(@Param("volunteerActivityVO") VolunteerActivityVO volunteerActivityVO); int updateById(@Param("volunteerActivityVO") VolunteerActivityVO volunteerActivityVO); int deleteById(@Param("id") String id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/VolunteerActivity.java
@@ -58,27 +58,27 @@ * 发布时间 */ @ApiModelProperty(value = "发布时间") private String issueTime; private Date issueTime; /** * 报名开始时间 */ @ApiModelProperty(value = "报名开始时间") private String applyBeginTime; private Date applyBeginTime; /** * 报名结束时间 */ @ApiModelProperty(value = "报名结束时间") private String applyEndTime; private Date applyEndTime; /** * 活动开始时间 */ @ApiModelProperty(value = "活动开始时间") private String actityBeginTime; private Date actityBeginTime; /** * 活动结束时间 */ @ApiModelProperty(value = "活动结束时间") private String actityEndTime; private Date actityEndTime; /** * 志愿者上限（0无限 大于0 就是限制） */ @@ -119,6 +119,12 @@ */ @ApiModelProperty(value = "创建时间") private Date creationTime; /** * 更新时间 */ @ApiModelProperty(value = "更新时间") private Date updateTime; /** * 社区id */ springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/VolunteerActivityService.java
New file @@ -0,0 +1,46 @@ package com.panzhihua.service_community.service; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.IService; import com.panzhihua.common.model.vos.community.VolunteerActivityVO; import com.panzhihua.service_community.entity.VolunteerActivity; import java.util.Date; public interface VolunteerActivityService extends IService<VolunteerActivity> { /** * 获取单个详情 * @param id * @return */ VolunteerActivity queryById( String id); /** * 分页查询 * @param * @return */ IPage<VolunteerActivity> queryList(int pageNum,int pageSize, String name, String acState, String acType, Date actityBeginTime, Date actityEndTime); /** * 新增 * @param * @return */ int insertVolunteer(VolunteerActivityVO volunteerActivityVO); int updateById(VolunteerActivityVO volunteerActivityVO); int deleteById(String id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/VolunteerActivityServiceImpl.java
New file @@ -0,0 +1,56 @@ package com.panzhihua.service_community.service.impl; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.panzhihua.common.model.vos.community.MostBeautifulVolunteerVO; import com.panzhihua.common.model.vos.community.VolunteerActivityVO; import com.panzhihua.service_community.dao.MostBeautifulVolunteerDao; import com.panzhihua.service_community.dao.VolunteerActivityDao; import com.panzhihua.service_community.entity.MostBeautifulVolunteer; import com.panzhihua.service_community.entity.VolunteerActivity; import com.panzhihua.service_community.service.MostBeautifulVolunteerService; import com.panzhihua.service_community.service.VolunteerActivityService; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import java.util.Date; @Slf4j @Service public class VolunteerActivityServiceImpl extends ServiceImpl<VolunteerActivityDao, VolunteerActivity> implements VolunteerActivityService { @Override public VolunteerActivity queryById(String Id) { return baseMapper.queryById(Id); } @Override public IPage<VolunteerActivity> queryList(int pageNum,int pageSize, String name, String acState, String acType, Date actityBeginTime, Date actityEndTime) { Page page = new Page<VolunteerActivity>(pageNum,pageSize); return baseMapper.queryList(page, name, acState, acType, actityBeginTime, actityEndTime); } @Override public int insertVolunteer(VolunteerActivityVO mostBeautifulVolunteerVO) { return baseMapper.insertVolunteer(mostBeautifulVolunteerVO); } @Override public int updateById(VolunteerActivityVO mostBeautifulVolunteerVO) { return baseMapper.updateById(mostBeautifulVolunteerVO); } @Override public int deleteById(String Id) { return baseMapper.deleteById(Id); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/MostBeautifulVolunteerMapper.xml
@@ -47,10 +47,10 @@ from most_beautiful_volunteer <where> 1=1 <if test="name!=null and name !=''"> <if test="name!=null "> and (`name` like concat('%',#{name},'%') </if> <if test="unmountType!=null and unmountType !=''"> <if test="unmountType!=null "> and unmount_type =# {unmountType} </if> @@ -133,7 +133,7 @@ self_introduction=#{mostBeautifulVolunteerVO.selfIntroduction}, </if> <if test="mostBeautifulVolunteerVO.volunteerStyle != null"> volunteer_style=#{mostBeautifulVolunteerVO.weightSorting}, volunteer_style=#{mostBeautifulVolunteerVO.volunteerStyle}, </if> <if test="mostBeautifulVolunteerVO.weightSorting != null"> weight_sorting=#{mostBeautifulVolunteerVO.weightSorting}, springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerActivityMapper.xml
New file @@ -0,0 +1,317 @@ <?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_community.dao.VolunteerActivityDao"> <resultMap type="com.panzhihua.service_community.entity.VolunteerActivity" id="VolunteerActivityMap"> <result property="id" column="id" /> <result property="name" column="name" /> <result property="acType" column="ac_type" /> <result property="address" column="address" /> <result property="volunteerNum" column="volunteer_num" /> <result property="acState" column="ac_state" /> <result property="awardState" column="award_state" /> <result property="issueTime" column="issue_time" /> <result property="applyBeginTime" column="apply_begin_time" /> <result property="applyEndTime" column="apply_end_time" /> <result property="actityBeginTime" column="actity_begin_time" /> <result property="actityEndTime" column="actity_end_time" /> <result property="communityId" column="community_id" /> <result property="volunteerLimit" column="volunteer_limit" /> <result property="bonusPoints" column="bonus_points" /> <result property="isCancelled" column="is_cancelled" /> <result property="contactName" column="contact_name" /> <result property="contactPhone" column="contact_phone" /> <result property="activitCoverUrl" column="activity_cover_url" /> <result property="activityContent" column="activity_content" /> <result property="creationTime" column="creation_time" /> <result property="updateTime" column="update_time" /> </resultMap> <!--查询单个--> <select id="queryById" resultMap="VolunteerActivityMap"> select id, name, ac_type, address, volunteer_num, ac_state, award_state, issue_time, apply_begin_time, apply_end_time, actity_begin_time, actity_end_time, community_id, volunteer_limit, bonus_points, is_cancelled, contact_name, contact_phone, activity_cover_url, activity_content, creation_time, update_time from volunteer_activity where id= #{id} </select> <!-- 分页查询 --> <select id="queryList" resultMap="VolunteerActivityMap"> select id, name, ac_type, address, volunteer_num, ac_state, award_state, issue_time, apply_begin_time, apply_end_time, actity_begin_time, actity_end_time, community_id, volunteer_limit, bonus_points, is_cancelled, contact_name, contact_phone, activity_cover_url, activity_content, creation_time, update_time from volunteer_activity @Param("actityBeginTime") Date , @Param("actityEndTime") Date actityEndTime <where> 1=1 <if test="name!=null"> and (`name` like concat('%',#{name},'%') </if> <if test="acState!=null"> and ac_state =# {acState} </if> <if test="acType!=null"> and ac_type =# {acType} </if> <if test="actityBeginTime!=null"> and actity_begin_time >= #{actityBeginTime} </if> <if test="actityEndTime!=null"> and actity_end_time <![CDATA[ <= ]]> # {actityEndTime} </if> </where> order by weight_sorting asc,creation_time desc </select> <insert id="insertVolunteer"> insert into volunteer_activity <trim prefix="(" suffix=")" suffixOverrides=","> <if test="volunteerActivityVO.id != null"> id, </if> <if test="volunteerActivityVO.name != null"> name, </if> <if test="volunteerActivityVO.acType != null"> ac_type, </if> <if test="volunteerActivityVO.address != null"> address, </if> <if test="volunteerActivityVO.volunteerNum != null"> volunteer_num, </if> <if test="volunteerActivityVO.acState != null"> ac_state, </if> <if test="volunteerActivityVO.awardState != null"> award_state, </if> <if test="volunteerActivityVO.issueTime != null"> issue_time, </if> <if test="volunteerActivityVO.applyBeginTime != null"> apply_begin_time, </if> <if test="volunteerActivityVO.applyEndTime != null"> apply_end_time, </if> <if test="volunteerActivityVO.actityBeginTime != null"> actity_begin_time, </if> <if test="volunteerActivityVO.actityEndTime != null"> actity_end_time, </if> <if test="volunteerActivityVO.communityId != null"> community_id, </if> <if test="volunteerActivityVO.volunteerLimit != null"> volunteer_limit, </if> <if test="volunteerActivityVO.bonusPoints != null"> bonus_points, </if> <if test="volunteerActivityVO.isCancelled != null"> is_cancelled, </if> <if test="volunteerActivityVO.contactName != null"> contact_name, </if> <if test="volunteerActivityVO.contactPhone != null"> contact_phone, </if> <if test="volunteerActivityVO.activitCoverUrl != null"> activity_cover_url, </if> <if test="volunteerActivityVO.activityContent != null"> activity_content, </if> creationTime </trim> values <trim prefix="(" suffix=")" suffixOverrides=","> <if test="volunteerActivityVO.id != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.name != null"> #{volunteerActivityVO.name}, </if> <if test="volunteerActivityVO.acType != null"> #{volunteerActivityVO.acType}, </if> <if test="volunteerActivityVO.address != null"> #{volunteerActivityVO.address}, </if> <if test="volunteerActivityVO.volunteerNum != null"> #{volunteerActivityVO.volunteerNum}, </if> <if test="volunteerActivityVO.acState != null"> #{volunteerActivityVO.acState}, </if> <if test="volunteerActivityVO.awardState != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.issueTime != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.applyBeginTime != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.applyEndTime != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.actityBeginTime != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.actityEndTime != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.communityId != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.volunteerLimit != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.bonusPoints != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.isCancelled != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.contactName != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.contactPhone != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.activitCoverUrl != null"> #{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.activityContent != null"> #{volunteerActivityVO.id}, </if> sysdate() </trim> </insert> <update id="updateById"> update volunteer_activity <set> <if test="volunteerActivityVO.id != null"> id=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.name != null"> name=#{volunteerActivityVO.name}, </if> <if test="volunteerActivityVO.acType != null"> ac_type=#{volunteerActivityVO.acType}, </if> <if test="volunteerActivityVO.address != null"> address=#{volunteerActivityVO.address}, </if> <if test="volunteerActivityVO.volunteerNum != null"> volunteer_num=#{volunteerActivityVO.volunteerNum}, </if> <if test="volunteerActivityVO.acState != null"> ac_state=#{volunteerActivityVO.acState}, </if> <if test="volunteerActivityVO.awardState != null"> award_state=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.issueTime != null"> issue_time=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.applyBeginTime != null"> apply_begin_time=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.applyEndTime != null"> apply_end_time=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.actityBeginTime != null"> actity_begin_time=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.actityEndTime != null"> actity_end_time=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.communityId != null"> community_id=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.volunteerLimit != null"> volunteer_limit=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.bonusPoints != null"> bonus_points=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.isCancelled != null"> is_cancelled=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.contactName != null"> contact_name=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.contactPhone != null"> contact_phone=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.activitCoverUrl != null"> activity_cover_url=#{volunteerActivityVO.id}, </if> <if test="volunteerActivityVO.activityContent != null"> activity_content=#{volunteerActivityVO.id}, </if> update_time=sysdate() </set> where id = #{volunteerActivityVO.id} </update> <delete id="deleteById" parameterType="String"> delete from volunteer_activity where id=#{id} </delete> </mapper>
