springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComActDynVO.java
@@ -110,7 +110,7 @@ @ApiModelProperty("是否培训公共") private Integer isOrgHatch; @ApiModelProperty("类别（1.社区动态 2.招募公告 3.考察记录 4.评审公示 5.孵化培育 6.出壳成果）") @ApiModelProperty("类别（1.社区动态 2.招募公告 3.考察记录 4.评审公示 5.孵化培育 6.出壳成果 10.社区主题）") private Integer category; @ApiModelProperty("显示时间") springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/MostBeautifulVolunteerVO.java
New file @@ -0,0 +1,60 @@ 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 MostBeautifulVolunteerVO { /** * 主键 */ @ApiModelProperty(value = "主键") private String id; /** * 志愿者姓名 */ @ApiModelProperty(value = "志愿者姓名") private String name; /** * 志愿者证件url */ @ApiModelProperty(value = "志愿者证件url") private String certificateUrl; /** * 自我介绍 */ @ApiModelProperty(value = "自我介绍") private String selfIntroduction; /** * 志愿者风采 */ @ApiModelProperty(value = "志愿者风采") private String volunteerStyle; /** * 权重排序 */ @ApiModelProperty(value = "权重排序") private String weightSorting; /** * 上下架状态( 0 下架 1 上架 ) */ @ApiModelProperty(value = "上下架状态( 0 下架 1 上架 )") private String unmountType; /** * 创建时间 */ @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
@@ -26,6 +26,7 @@ import com.panzhihua.common.model.dtos.property.PropertyWorkerDTO; import com.panzhihua.common.model.dtos.shop.*; import com.panzhihua.common.model.vos.civil.ComActSocialWorkerVO; import com.panzhihua.common.model.vos.community.*; import com.panzhihua.common.model.vos.community.acid.ComActAcidCheckRecordVO; import com.panzhihua.common.model.vos.community.acid.ComActAcidMemberVO; import com.panzhihua.common.model.vos.community.acid.ComActAcidRecordVO; @@ -218,68 +219,6 @@ import com.panzhihua.common.model.vos.DictionaryVO; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.SystemmanagementConfigVO; import com.panzhihua.common.model.vos.community.ActivitySignVO; import com.panzhihua.common.model.vos.community.BatchhouseVO; import com.panzhihua.common.model.vos.community.ComActActEvaluateVO; import com.panzhihua.common.model.vos.community.ComActActRegistVO; import com.panzhihua.common.model.vos.community.ComActActivityTypeVO; import com.panzhihua.common.model.vos.community.ComActActivityVO; import com.panzhihua.common.model.vos.community.ComActAnnouncementVO; import com.panzhihua.common.model.vos.community.ComActColumnVO; import com.panzhihua.common.model.vos.community.ComActCommiteeVO; import com.panzhihua.common.model.vos.community.ComActDynVO; import com.panzhihua.common.model.vos.community.ComActEasyPhotoVO; import com.panzhihua.common.model.vos.community.ComActFourMemberVO; import com.panzhihua.common.model.vos.community.ComActMessageBackVO; import com.panzhihua.common.model.vos.community.ComActMessageVO; import com.panzhihua.common.model.vos.community.ComActMicroWishVO; import com.panzhihua.common.model.vos.community.ComActReserveCommitVO; import com.panzhihua.common.model.vos.community.ComActSocialOrgVO; import com.panzhihua.common.model.vos.community.ComActVO; import com.panzhihua.common.model.vos.community.ComActWorkGuideClassifyVO; import com.panzhihua.common.model.vos.community.ComActWorkGuideVO; import com.panzhihua.common.model.vos.community.ComCvtServeExcelVO; import com.panzhihua.common.model.vos.community.ComElderAuthRecordImportExcelVO; import com.panzhihua.common.model.vos.community.ComElderAuthRecordVO; import com.panzhihua.common.model.vos.community.ComEldersAuthElderlyDetailsVO; import com.panzhihua.common.model.vos.community.ComMngBuildingExcelVO; import com.panzhihua.common.model.vos.community.ComMngCarExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationCorrectExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationCultExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationDisabilityExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationDrugExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationElderExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationKeyExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationLowSecurityExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationMajorExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationPensionExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationRehabilitationExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationSentenceExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationServeExcelVO; import com.panzhihua.common.model.vos.community.ComMngPopulationVO; import com.panzhihua.common.model.vos.community.ComMngPopulationVeteransExcelVO; import com.panzhihua.common.model.vos.community.ComMngRealAssetsExcelVO; import com.panzhihua.common.model.vos.community.ComMngRealAssetsVO; import com.panzhihua.common.model.vos.community.ComMngRealCompanyExcelVO; import com.panzhihua.common.model.vos.community.ComMngRealCompanyVO; import com.panzhihua.common.model.vos.community.ComMngStructAreaVO; import com.panzhihua.common.model.vos.community.ComMngStructHouseVO; import com.panzhihua.common.model.vos.community.ComMngStructOtherBuildVO; import com.panzhihua.common.model.vos.community.ComMngVillageServeExcelVO; import com.panzhihua.common.model.vos.community.ComMngVillageVO; import com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO; import com.panzhihua.common.model.vos.community.ComOpsHouseUndercarriageVO; import com.panzhihua.common.model.vos.community.ComOpsHouseVO; import com.panzhihua.common.model.vos.community.ComPensionAuthRecordImportExcelVO; import com.panzhihua.common.model.vos.community.ComPensionAuthRecordVO; import com.panzhihua.common.model.vos.community.ComPropertyVO; import com.panzhihua.common.model.vos.community.ComStreetVO; import com.panzhihua.common.model.vos.community.ComSwRotaExcelVO; import com.panzhihua.common.model.vos.community.EldersAuthDetailsVO; import com.panzhihua.common.model.vos.community.EldersAuthElderlyExcelVO; import com.panzhihua.common.model.vos.community.QRActivityCodeVO; import com.panzhihua.common.model.vos.community.ResetComActMessageVO; import com.panzhihua.common.model.vos.community.SignactivityVO; import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStatisticAgeGender; import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStatisticPartyActivity; import com.panzhihua.common.model.vos.community.bigscreen.BigScreenStatisticPartyBuild; @@ -11243,7 +11182,6 @@ /** * 通过洗车订单查询银联订单 * * @param Id * @return */ @GetMapping("/unionpay/detail") @@ -11253,7 +11191,6 @@ /** * 通过银联订单查询洗车订单 * * @param Id * @return */ @GetMapping("/unionpay/unionpayDetail") @@ -11272,4 +11209,64 @@ @RequestParam("money") String money); /********************************************************************************************************* * * * 最美志愿者 * * * *********************************************************************************************************/ @GetMapping("/MostBeautifu/queryById") public R queryById2(@RequestParam("id") String Id); /** * 分页查询 * @param name * @param unmountType * @return */ @GetMapping("/MostBeautifu/getqueryList") public R queryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize")int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "unmountType", required = false) String unmountType); /** * 新增 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/MostBeautifu/addMostBeautiful") public R insertMostBeautifulVolunteer(@RequestBody MostBeautifulVolunteerVO mostBeautifulVolunteerVO); /** * 更新 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/MostBeautifu/upMostBeautiful") public R updateById(MostBeautifulVolunteerVO mostBeautifulVolunteerVO); /** * 删除 * @param Id * @return */ @DeleteMapping("/MostBeautifu/delectVuId") public R deleteById(@RequestParam("id") String Id); } springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/MostBeautifulApi.java
New file @@ -0,0 +1,108 @@ package com.panzhihua.community_backstage.api; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.MostBeautifulVolunteerVO; import com.panzhihua.common.service.community.CommunityService; import com.panzhihua.common.utlis.StringUtils; import io.swagger.annotations.Api; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @Slf4j @Api(tags = {"最美志愿者API"}) @RestController @RequestMapping("/mostBeautifulVolunteer") public class MostBeautifulApi { @Resource private CommunityService communityService; /** * 查询单个 * @param Id * @return */ @GetMapping("/queryById") public R queryById(@RequestParam("id") String Id) { if(StringUtils.isEmpty(Id)) { return R.fail("id不能为空"); } return communityService.queryById2(Id); } /** * 分页查询 * @param name * @param unmountType * @return */ @GetMapping("/getqueryList") public R queryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize")int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "unmountType", required = false) String unmountType) { return communityService.queryList(pageNum,pageSize,name,unmountType); } /** * 新增 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/addMostBeautiful") public R insertMostBeautifulVolunteer(@RequestBody MostBeautifulVolunteerVO mostBeautifulVolunteerVO) { return communityService.insertMostBeautifulVolunteer(mostBeautifulVolunteerVO); } /** * 更新 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/upMostBeautiful") public R updateById(MostBeautifulVolunteerVO mostBeautifulVolunteerVO) { if(mostBeautifulVolunteerVO==null) { return R.fail("参数不能为空"); } if(StringUtils.isEmpty(mostBeautifulVolunteerVO.getId())) { return R.fail("id不能为空"); } if(StringUtils.isEmpty(mostBeautifulVolunteerVO.getCommunityId())) { return R.fail("社区id不能为空"); } return communityService.updateById(mostBeautifulVolunteerVO); } /** * 删除 * @param Id * @return */ @DeleteMapping("/delectVuId") public R deleteById(@RequestParam("id") String Id) { return communityService.deleteById(Id); } } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/MostBeautifulVolunteerApi.java
New file @@ -0,0 +1,122 @@ package com.panzhihua.service_community.api; import com.panzhihua.common.model.vos.R; import com.panzhihua.common.model.vos.community.MostBeautifulVolunteerVO; import com.panzhihua.common.utlis.StringUtils; import com.panzhihua.service_community.service.MostBeautifulVolunteerService; import lombok.extern.slf4j.Slf4j; import org.springframework.web.bind.annotation.*; import javax.annotation.Resource; @Slf4j @RestController @RequestMapping("/MostBeautifu") public class MostBeautifulVolunteerApi { @Resource private MostBeautifulVolunteerService mostBeautifulVolunteerService; /** * 查询单个 * @param Id * @return */ @GetMapping("/queryById") public R queryById(@RequestParam("id") String Id) { if(StringUtils.isEmpty(Id)) { return R.fail("id不能为空"); } return R.ok(mostBeautifulVolunteerService.queryById(Id)); } /** * 分页查询 * @param name * @param unmountType * @return */ @GetMapping("/getqueryList") public R queryList(@RequestParam("pageNum") int pageNum, @RequestParam("pageSize")int pageSize, @RequestParam(value = "name", required = false) String name, @RequestParam(value = "unmountType", required = false) String unmountType) { return R.ok(mostBeautifulVolunteerService.queryList(pageNum,pageSize,name,unmountType)); } /** * 新增 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/addMostBeautiful") public R insertMostBeautifulVolunteer(@RequestBody MostBeautifulVolunteerVO mostBeautifulVolunteerVO) { int num= mostBeautifulVolunteerService.insertMostBeautifulVolunteer(mostBeautifulVolunteerVO); if(num>0) { return R.ok(); } return R.fail(); } /** * 更新 * @param mostBeautifulVolunteerVO * @return */ @PostMapping("/upMostBeautiful") public R updateById(MostBeautifulVolunteerVO mostBeautifulVolunteerVO) { if(mostBeautifulVolunteerVO==null) { return R.fail("参数不能为空"); } if(StringUtils.isEmpty(mostBeautifulVolunteerVO.getId())) { return R.fail("id不能为空"); } if(StringUtils.isEmpty(mostBeautifulVolunteerVO.getCommunityId())) { return R.fail("社区id不能为空"); } int num= mostBeautifulVolunteerService.updateById(mostBeautifulVolunteerVO); if(num>0) { return R.ok(); } return R.fail(); } /** * 删除 * @param Id * @return */ @DeleteMapping("/delectVuId") public R deleteById(@RequestParam("id") String Id) { int num= mostBeautifulVolunteerService.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
New file @@ -0,0 +1,42 @@ 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.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)表数据库访问层 * projectName 成都呐喊信息技术有限公司-智慧社区项目 * description: 用户表 后台用户+小程序用户相关功能 * * @author zzj * @since 2022-06-10 15:34:17 */ @Mapper public interface MostBeautifulVolunteerDao extends BaseMapper<MostBeautifulVolunteer> { //查询单个详情 MostBeautifulVolunteer queryById(@Param("id") String Id); //获取列表 IPage<MostBeautifulVolunteer> queryList(Page page, @Param("name") String name, @Param("unmountType") String unmountType); int insertMostBeautifulVolunteer(@Param("mostBeautifulVolunteerVO") MostBeautifulVolunteerVO mostBeautifulVolunteerVO); int updateById(@Param("mostBeautifulVolunteerVO") MostBeautifulVolunteerVO mostBeautifulVolunteerVO); int deleteById(@Param("Id") String Id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/MostBeautifulVolunteer.java
New file @@ -0,0 +1,69 @@ package com.panzhihua.service_community.entity; 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 MostBeautifulVolunteer implements Serializable { private static final long serialVersionUID = -70884515430727555L; /** * 主键 */ @ApiModelProperty(value = "主键") private String id; /** * 志愿者姓名 */ @ApiModelProperty(value = "志愿者姓名") private String name; /** * 志愿者证件url */ @ApiModelProperty(value = "志愿者证件url") private String certificateUrl; /** * 自我介绍 */ @ApiModelProperty(value = "自我介绍") private String selfIntroduction; /** * 志愿者风采 */ @ApiModelProperty(value = "志愿者风采") private String volunteerStyle; /** * 权重排序 */ @ApiModelProperty(value = "权重排序") private String weightSorting; /** * 上下架状态( 0 下架 1 上架 ) */ @ApiModelProperty(value = "上下架状态( 0 下架 1 上架 )") private String unmountType; /** * 创建时间 */ @ApiModelProperty(value = "创建时间") private Date creationTime; /** * 社区id */ @ApiModelProperty(value = "社区id") private String communityId; } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/MostBeautifulVolunteerService.java
New file @@ -0,0 +1,54 @@ package com.panzhihua.service_community.service; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.service.IService; import com.panzhihua.common.model.vos.community.MostBeautifulVolunteerVO; import com.panzhihua.service_community.entity.MostBeautifulVolunteer; import org.apache.ibatis.annotations.Param; public interface MostBeautifulVolunteerService extends IService<MostBeautifulVolunteer> { /** * 查询单个 * @param Id * @return */ MostBeautifulVolunteer queryById(String Id); /** * 分页查询 * @param name * @param unmountType * @return */ IPage<MostBeautifulVolunteer> queryList(int pageNum, int pageSize, String name, String unmountType); /** * 新增 * @param mostBeautifulVolunteerVO * @return */ int insertMostBeautifulVolunteer(MostBeautifulVolunteerVO mostBeautifulVolunteerVO); /** * 更新 * @param mostBeautifulVolunteerVO * @return */ int updateById(MostBeautifulVolunteerVO mostBeautifulVolunteerVO); /** * 删除 * @param Id * @return */ int deleteById(String Id); } springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/MostBeautifulVolunteerServiceImpl.java
New file @@ -0,0 +1,45 @@ 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.service_community.dao.MostBeautifulVolunteerDao; import com.panzhihua.service_community.entity.MostBeautifulVolunteer; import com.panzhihua.service_community.service.MostBeautifulVolunteerService; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; @Slf4j @Service public class MostBeautifulVolunteerServiceImpl extends ServiceImpl<MostBeautifulVolunteerDao, MostBeautifulVolunteer> implements MostBeautifulVolunteerService { @Override public MostBeautifulVolunteer queryById(String Id) { return baseMapper.queryById(Id); } @Override public IPage<MostBeautifulVolunteer> queryList(int pageNum,int pageSize, String name, String unmountType) { Page page = new Page<MostBeautifulVolunteer>(pageNum,pageSize); return baseMapper.queryList(page, name,unmountType); } @Override public int insertMostBeautifulVolunteer(MostBeautifulVolunteerVO mostBeautifulVolunteerVO) { return baseMapper.insertMostBeautifulVolunteer(mostBeautifulVolunteerVO); } @Override public int updateById(MostBeautifulVolunteerVO 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
New file @@ -0,0 +1,155 @@ <?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.MostBeautifulVolunteerDao"> <resultMap type="com.panzhihua.service_community.entity.MostBeautifulVolunteer" id="MostBeautifulVolunteerMap"> <result property="id" column="id"/> <result property="name" column="name"/> <result property="certificateUrl" column="certificate_url"/> <result property="selfIntroduction" column="self_introduction"/> <result property="volunteerStyle" column="volunteer_style"/> <result property="weightSorting" column="weight_sorting"/> <result property="unmountType" column="unmount_type"/> <result property="creationTime" column="creation_time"/> <result property="communityId" column="community_id"/> </resultMap> <!--查询单个--> <select id="queryById" resultMap="MostBeautifulVolunteerMap"> select id, name, certificate_url, self_introduction, volunteer_style, weight_sorting, unmount_type, creation_time, community_id from most_beautiful_volunteer where id= #{Id} </select> <!--查询单个--> <select id="queryList" resultMap="MostBeautifulVolunteerMap"> select id, name, certificate_url, self_introduction, volunteer_style, weight_sorting, unmount_type, creation_time, community_id from most_beautiful_volunteer <where> 1=1 <if test="name!=null and name !=''"> and (`name` like concat('%',#{name},'%') </if> <if test="unmountType!=null and unmountType !=''"> and unmount_type =# {unmountType} </if> </where> order by weight_sorting asc,creation_time desc </select> <insert id="insertMostBeautifulVolunteer"> insert into most_beautiful_volunteer <trim prefix="(" suffix=")" suffixOverrides=","> <if test="mostBeautifulVolunteerVO.id != null"> id, </if> <if test="mostBeautifulVolunteerVO.name != null"> name, </if> <if test="mostBeautifulVolunteerVO.certificateUrl != null"> certificate_url, </if> <if test="mostBeautifulVolunteerVO.selfIntroduction != null"> self_introduction, </if> <if test="mostBeautifulVolunteerVO.volunteerStyle != null"> volunteer_style, </if> <if test="mostBeautifulVolunteerVO.weightSorting != null"> weight_sorting, </if> <if test="mostBeautifulVolunteerVO.unmountType != null"> unmount_type, </if> <if test="mostBeautifulVolunteerVO.communityId != null"> community_id, </if> creationTime </trim> values <trim prefix="(" suffix=")" suffixOverrides=","> <if test="mostBeautifulVolunteerVO.id != null"> #{mostBeautifulVolunteerVO.id}, </if> <if test="mostBeautifulVolunteerVO.name != null"> #{mostBeautifulVolunteerVO.name}, </if> <if test="mostBeautifulVolunteerVO.certificateUrl != null"> #{mostBeautifulVolunteerVO.certificateUrl}, </if> <if test="mostBeautifulVolunteerVO.selfIntroduction != null"> #{mostBeautifulVolunteerVO.selfIntroduction}, </if> <if test="mostBeautifulVolunteerVO.volunteerStyle != null"> #{mostBeautifulVolunteerVO.weightSorting}, </if> <if test="mostBeautifulVolunteerVO.weightSorting != null"> #{mostBeautifulVolunteerVO.weightSorting}, </if> <if test="mostBeautifulVolunteerVO.unmountType != null"> #{mostBeautifulVolunteerVO.unmountType}, </if> <if test="mostBeautifulVolunteerVO.communityId != null"> #{mostBeautifulVolunteerVO.communityId}, </if> sysdate() </trim> </insert> <update id="updateById"> update most_beautiful_volunteer <set> <if test="mostBeautifulVolunteerVO.id != null"> #{mostBeautifulVolunteerVO.id}, </if> <if test="mostBeautifulVolunteerVO.name != null"> #{mostBeautifulVolunteerVO.name}, </if> <if test="mostBeautifulVolunteerVO.certificateUrl != null"> #{mostBeautifulVolunteerVO.certificateUrl}, </if> <if test="mostBeautifulVolunteerVO.selfIntroduction != null"> #{mostBeautifulVolunteerVO.selfIntroduction}, </if> <if test="mostBeautifulVolunteerVO.volunteerStyle != null"> #{mostBeautifulVolunteerVO.weightSorting}, </if> <if test="mostBeautifulVolunteerVO.weightSorting != null"> #{mostBeautifulVolunteerVO.weightSorting}, </if> <if test="mostBeautifulVolunteerVO.unmountType != null"> #{mostBeautifulVolunteerVO.unmountType}, </if> update_time=sysdate() </set> where id = #{mostBeautifulVolunteerVO.id} </update> <delete id="deleteById" parameterType="String"> delete from most_beautiful_volunteer where id=#{Id} </delete> </mapper>
