新曾小程序活动报名 取消接口

lidongdong

2023-08-18 8d61de34f7cb466aa548799eec5925803dc1c314

新曾小程序活动报名  取消接口

 springcloud_k8s_panzhihuazhihuishequ/applets/src/main/java/com/panzhihua/applets/api/VolunteerActivitiesPeopleApi.java

New file
@@ -0,0 +1,141 @@
package com.panzhihua.applets.api;

import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.VolunteerActivitiesPeopleVO;
import com.panzhihua.common.service.community.CommunityService;
import com.panzhihua.common.utlis.StringUtils;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

@Slf4j
@RestController
@RequestMapping("/VolunteerActivitiesPeople")
public class VolunteerActivitiesPeopleApi extends BaseController
{
    @Resource
    private CommunityService volunteerActivitiesPeople;

    /**
     * 志愿者单个详情
     * @param id
     * @return
     */
    @GetMapping("/vapGetById")
    public R vapGetById(@RequestParam("id") String id)
    {
        if(StringUtils.isEmpty(id))
        {
            return R.fail("id不能为空");
        }
        return R.ok(volunteerActivitiesPeople.vapGetById(id));
    }

    /**
     * 参与人员列表
     * @param activityId
     * @param communityId
     * @return
     */
    @GetMapping("/vapGetList")
    public R  vapGetList(@RequestParam("activityId") String activityId,
                         @RequestParam("communityId") String communityId)
    {
        if(StringUtils.isEmpty(activityId))
        {
            return R.fail("活动id不能为空");
        }

        if(StringUtils.isEmpty(communityId))
        {
            communityId=getLoginUserInfo().getCommunityId()+"";
        }

        return R.ok(volunteerActivitiesPeople.vapGetList(activityId, communityId));
    }

    /**
     * 添加参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/vapInsert")
    public R  vapInsert(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO)
    {
        if(volunteerActivitiesPeopleVO==null)
        {
            return R.fail("参数不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getActivityId()))
        {
            return R.fail("活动id不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getVolunteerId()))
        {
            return R.fail("志愿者id不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getCommunityId()))
        {
            volunteerActivitiesPeopleVO.setCommunityId(getLoginUserInfo().getCommunityId()+"");
        }

        return volunteerActivitiesPeople.vapInsert(volunteerActivitiesPeopleVO);
    }

    /**
     * 修改参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/vapUpdate")
    public R  vapUpdate(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO)
    {
        if(volunteerActivitiesPeopleVO==null)
        {
            return R.fail("参数不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getId()))
        {
            return R.fail("id不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getActivityId()))
        {
            return R.fail("活动id不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getVolunteerId()))
        {
            return R.fail("志愿者id不能为空");
        }

        if(StringUtils.isEmpty(volunteerActivitiesPeopleVO.getCommunityId()))
        {
            volunteerActivitiesPeopleVO.setCommunityId(getLoginUserInfo().getCommunityId()+"");
        }

        return volunteerActivitiesPeople.vapUpdate(volunteerActivitiesPeopleVO);
    }

    /**
     * 删除参与人员
     * @param id
     * @return
     */
    @DeleteMapping("/vapDelete")
    public R vapDelete(@RequestParam("id") String id)
    {
        if(StringUtils.isEmpty(id))
        {
            return R.fail("id不能为空");
        }
        return volunteerActivitiesPeople.vapDelete(id);
    }
}


 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/ComMngVolunteerMngVO.java

@@ -130,4 +130,8 @@
    private String communityName;
    @ApiModelProperty("物业公司Id")
    private Long propertyId;

    @ApiModelProperty("爱心积分")
    private String loveIntegral;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/community/VolunteerActivitiesPeopleVO.java

New file
@@ -0,0 +1,68 @@
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 VolunteerActivitiesPeopleVO
{
    /**
     * 主键
     */
    @ApiModelProperty(value = "主键")
    private String id;

    /**
     * 活动id
     */
    @ApiModelProperty(value = "主键")
    private String activityId;
    /**
     * 活动名称
     */
    @ApiModelProperty(value = "志愿者id")
    private String volunteerId;

    /**
     * 联系人姓名
     */
    @ApiModelProperty(value = "联系人姓名")
    private String contactName;
    /**
     * 联系人电话
     */
    @ApiModelProperty(value = "联系人电话")
    private String contactPhone;


    /**
     * 创建时间
     */
    @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;
    /**
     * 社区id
     */
    @ApiModelProperty(value = "社区id")
    private String communityId;

    @ApiModelProperty(value = "奖励发放状态( 0 未发放   1已发放 )")
    private String issueStatus;

    @ApiModelProperty(value = "发放积分")
    private String issuePoints;

}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/community/CommunityService.java

@@ -11353,7 +11353,53 @@
    @DeleteMapping("/VolunteerType/volunteerTypeDelete")
    public R volunteerTypeDelete(@RequestParam("id") String id);

    /*****************************************************************************************************************
     *
     *
     *                                      志愿者参加活动
     *
     *
     ****************************************************************************************************************/
    /**
     * 志愿者单个详情
     * @param id
     * @return
     */
    @GetMapping("/VolunteerActivitiesPeople/vapGetById")
    public R vapGetById(@RequestParam("id") String id);

    /**
     * 参与人员列表
     * @param activityId
     * @param communityId
     * @return
     */
    @GetMapping("/VolunteerActivitiesPeople/vapGetList")
    public R  vapGetList(@RequestParam("activityId") String activityId,
                         @RequestParam("communityId") String communityId);

    /**
     * 添加参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/VolunteerActivitiesPeople/vapInsert")
    public R  vapInsert(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 修改参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/VolunteerActivitiesPeople/vapUpdate")
    public R  vapUpdate(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 删除参与人员
     * @param id
     * @return
     */
    @DeleteMapping("/VolunteerActivitiesPeople/vapDelete")
    public R vapDelete(@RequestParam("id") String id);

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/api/VolunteerActivitiesPeopleApi.java

New file
@@ -0,0 +1,91 @@
package com.panzhihua.service_community.api;


import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.VolunteerActivitiesPeopleVO;
import com.panzhihua.service_community.service.VolunteerActivitiesPeopleService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

@Slf4j
@RestController
@RequestMapping("/VolunteerActivitiesPeople")
public class VolunteerActivitiesPeopleApi
{
    @Resource
    private VolunteerActivitiesPeopleService volunteerActivitiesPeople;

    /**
     * 志愿者单个详情
     * @param id
     * @return
     */
    @GetMapping("/vapGetById")
    public R vapGetById(@RequestParam("id") String id)
    {
        return R.ok(volunteerActivitiesPeople.vapGetById(id));
    }

    /**
     * 参与人员列表
     * @param activityId
     * @param communityId
     * @return
     */
    @GetMapping("/vapGetList")
    public R  vapGetList(@RequestParam("activityId") String activityId,
                         @RequestParam("communityId") String communityId)
    {
        return R.ok(volunteerActivitiesPeople.vapGetList(activityId, communityId));
    }

    /**
     * 添加参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/vapInsert")
    public R  vapInsert(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO)
    {
        int num = volunteerActivitiesPeople.vapInsert(volunteerActivitiesPeopleVO);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail();
    }

    /**
     * 修改参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    @PostMapping("/vapUpdate")
    public R  vapUpdate(@RequestBody VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO)
    {
        int num = volunteerActivitiesPeople.vapUpdate(volunteerActivitiesPeopleVO);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail();
    }

    /**
     * 删除参与人员
     * @param id
     * @return
     */
    @DeleteMapping("/vapDelete")
    public R vapDelete(@RequestParam("id") String id)
    {
        int num = volunteerActivitiesPeople.vapDelete(id);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail();
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/VolunteerActivitiesPeopleDao.java

New file
@@ -0,0 +1,54 @@
package com.panzhihua.service_community.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.panzhihua.common.model.vos.community.VolunteerActivitiesPeopleVO;
import com.panzhihua.service_community.entity.VolunteerActivitiesPeople;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface VolunteerActivitiesPeopleDao extends BaseMapper<VolunteerActivitiesPeople>
{
    /**
     * 志愿者单个详情
     * @param id
     * @return
     */
    VolunteerActivitiesPeople vapGetById(@Param("id") String id);

    /**
     * 参与人员列表
     * @param activityId
     * @param communityId
     * @return
     */
    List<VolunteerActivitiesPeople> vapGetList(@Param("activityId") String activityId,
                                               @Param("communityId") String communityId);

    /**
     * 添加参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    int vapInsert(@Param("volunteerActivitiesPeopleVO") VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 修改参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    int vapUpdate(@Param("volunteerActivitiesPeopleVO") VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 删除参与人员
     * @param id
     * @return
     */
    int vapDelete(@Param("id") String id);




}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/entity/VolunteerActivitiesPeople.java

New file
@@ -0,0 +1,80 @@
package com.panzhihua.service_community.entity;

import com.baomidou.mybatisplus.annotation.TableField;
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 VolunteerActivitiesPeople  implements Serializable {
    private static final long serialVersionUID = -70884515430727555L;

    /**
     * 主键
     */
    @ApiModelProperty(value = "主键")
    private String id;

    /**
     * 活动id
     */
    @ApiModelProperty(value = "主键")
    private String activityId;
    /**
     * 活动名称
     */
    @ApiModelProperty(value = "志愿者id")
    private String volunteerId;

    /**
     * 联系人姓名
     */
    @TableField(exist = false)
    @ApiModelProperty(value = "联系人姓名")
    private String contactName;
    /**
     * 联系人电话
     */
    @TableField(exist = false)
    @ApiModelProperty(value = "联系人电话")
    private String contactPhone;


    /**
     * 创建时间
     */
    @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;
    /**
     * 社区id
     */
    @ApiModelProperty(value = "社区id")
    private String communityId;

    @ApiModelProperty(value = "奖励发放状态( 0 未发放   1已发放 )")
    private String issueStatus;

    @ApiModelProperty(value = "发放积分")
    private String issuePoints;


}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/model/dos/ComMngVolunteerMngDO.java

@@ -117,4 +117,10 @@
     * 所属物业公司id
     * */
    private Long propertyId;

    /**
     * 爱心积分
     */
    private String loveIntegral;

}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/VolunteerActivitiesPeopleService.java

New file
@@ -0,0 +1,46 @@
package com.panzhihua.service_community.service;

import com.panzhihua.common.model.vos.community.VolunteerActivitiesPeopleVO;
import com.panzhihua.service_community.entity.VolunteerActivitiesPeople;

import java.util.List;

public interface VolunteerActivitiesPeopleService
{
    /**
     * 志愿者单个详情
     * @param id
     * @return
     */
    VolunteerActivitiesPeople vapGetById(String id);

    /**
     * 参与人员列表
     * @param activityId
     * @param communityId
     * @return
     */
    List<VolunteerActivitiesPeople> vapGetList(String activityId,
                                               String communityId);

    /**
     * 添加参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    int vapInsert(VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 修改参与人员
     * @param volunteerActivitiesPeopleVO
     * @return
     */
    int vapUpdate(VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO);

    /**
     * 删除参与人员
     * @param id
     * @return
     */
    int vapDelete(String id);
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/VolunteerActivitiesPeopleServiceImpl.java

New file
@@ -0,0 +1,44 @@
package com.panzhihua.service_community.service.impl;

import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.vos.community.VolunteerActivitiesPeopleVO;
import com.panzhihua.service_community.dao.VolunteerActivitiesPeopleDao;
import com.panzhihua.service_community.entity.VolunteerActivitiesPeople;
import com.panzhihua.service_community.service.VolunteerActivitiesPeopleService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import java.util.List;

@Slf4j
@Service
public class VolunteerActivitiesPeopleServiceImpl extends ServiceImpl<VolunteerActivitiesPeopleDao,
        VolunteerActivitiesPeople> implements VolunteerActivitiesPeopleService
{

    @Override
    public VolunteerActivitiesPeople vapGetById(String id)
    {
        return baseMapper.vapGetById(id);
    }

    @Override
    public List<VolunteerActivitiesPeople> vapGetList(String activityId, String communityId) {
        return baseMapper.vapGetList(activityId,communityId);
    }

    @Override
    public int vapInsert(VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO) {
        return baseMapper.vapInsert(volunteerActivitiesPeopleVO);
    }

    @Override
    public int vapUpdate(VolunteerActivitiesPeopleVO volunteerActivitiesPeopleVO) {
        return baseMapper.vapUpdate(volunteerActivitiesPeopleVO);
    }

    @Override
    public int vapDelete(String id) {
        return baseMapper.vapDelete(id);
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComMngVolunteerMngDOMapper.xml

@@ -23,11 +23,13 @@
        <result column="org_id" property="orgId" />
        <result column="team_id" property="teamId" />
        <result column="skill_id" property="skillId" />
        <result column="love_integral" property="loveIntegral" />
    </resultMap>

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        id, create_at, state, name, phone, photo_path, political_face, reject_reson, apply_reson, address, age, job, integral, community_id, submit_user_id, id_card, org_id, team_id, skill_id
        id, create_at, state, name, phone, photo_path, political_face, reject_reson, apply_reson, address, age,
        job, integral, community_id, submit_user_id, id_card, org_id, team_id, skill_id,love_integral
    </sql>

    <select id="pageVolunteer" resultType="com.panzhihua.common.model.vos.community.ComMngVolunteerMngVO">
@@ -49,6 +51,7 @@
        cmvst.`name` as serviceTypeName,
        cmvs.`name` as skillName,
        cmvm.create_at,
        cmvm.love_integral,
        t.name as communityName
        FROM
        com_mng_volunteer_mng as cmvm

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/VolunteerActivitiesPeopleInvolvedMapper.xml

New file
@@ -0,0 +1,138 @@
<?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.VolunteerActivitiesPeopleDao">

    <resultMap type="com.panzhihua.service_community.entity.VolunteerActivitiesPeople" id="VolunteerActivitiesPeopleMap">
        <result property="id" column="id" />
        <result property="volunteerId" column="volunteer_id" />
        <result property="issueStatus" column="issue_status" />
        <result property="issuePoints" column="issue_points" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
        <result property="communityId" column="community_id" />
        <result property="activityId" column="activity_id" />

    </resultMap>

    <!--查询单个-->
    <select id="vapGetById" resultMap="VolunteerActivitiesPeopleMap">
        select
            id,
            community_id,
            volunteer_id,
            issue_status,
            issue_points,
            (select cmvm.name from com_mng_volunteer_mng cmvm where cmvm.id=volunteer_id) as contactName,
            (select cmvm.phone from com_mng_volunteer_mng cmvm where cmvm.id=volunteer_id) as contactPhone,
            creation_time,
            activity_id,
            update_time
        from volunteer_activities_people_involved
        where id= #{id}
    </select>

    <!-- 分页查询 -->
    <select id="vapGetList" resultMap="VolunteerActivitiesPeopleMap">
        select
            id,
            community_id,
            volunteer_id,
            issue_status,
            issue_points,
            (select cmvm.name from com_mng_volunteer_mng cmvm where cmvm.id=volunteer_id) as contactName,
            (select cmvm.phone from com_mng_volunteer_mng cmvm where cmvm.id=volunteer_id) as contactPhone,
            creation_time,
            activity_id,
            update_time
        from volunteer_activities_people_involved
        <where>
            1=1
            <if test="communityId != null and communityId!='' ">
                and community_id=#{communityId}
            </if>

            <if test="activityId != null  and activityId != '' ">
                and activity_id=#{activityId}
            </if>
        </where>
        order by issue_status desc
    </select>

    <insert id="vapInsert">
        insert into volunteer_activities_people_involved
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="volunteerActivitiesPeopleVO.id != null">
                id,
            </if>
            <if test="volunteerActivitiesPeopleVO.volunteerId != null">
                volunteer_id,
            </if>
            <if test="volunteerActivitiesPeopleVO.communityId != null">
                community_id,
            </if>
            <if test="volunteerActivitiesPeopleVO.issueStatus != null">
                issue_status,
            </if>
            <if test="volunteerActivitiesPeopleVO.issuePoints != null">
                issue_points,
            </if>
            <if test="volunteerActivitiesPeopleVO.activityId != null">
                activity_id,
            </if>
            creation_time
        </trim>
        values
        <trim prefix="("  suffix=")" suffixOverrides=",">
            <if test="volunteerActivitiesPeopleVO.id != null">
                #{volunteerActivitiesPeopleVO.id},
            </if>
            <if test="volunteerActivitiesPeopleVO.volunteerId != null">
                #{volunteerActivitiesPeopleVO.volunteerId},
            </if>
            <if test="volunteerActivitiesPeopleVO.communityId != null">
                #{volunteerActivitiesPeopleVO.communityId},
            </if>
            <if test="volunteerActivitiesPeopleVO.issueStatus != null">
                #{volunteerActivitiesPeopleVO.issueStatus},
            </if>
            <if test="vvolunteerActivitiesPeopleVO.issuePoints != null">
                #{volunteerActivitiesPeopleVO.issuePoints},
            </if>
            <if test="volunteerActivitiesPeopleVO.activityId != null">
                #{volunteerActivitiesPeopleVO.activityId},
            </if>
            sysdate()
        </trim>
    </insert>

    <update id="vapUpdate">
        update volunteer_activities_people_involved
        <set>
            <if test="volunteerActivitiesPeopleVO.id != null">
                id=#{volunteerActivitiesPeopleVO.id},
            </if>
            <if test="volunteerActivitiesPeopleVO.volunteerId != null">
                volunteer_id=#{volunteerActivitiesPeopleVO.volunteerId},
            </if>
            <if test="volunteerActivitiesPeopleVO.communityId != null">
                community_id=#{volunteerActivitiesPeopleVO.communityId},
            </if>
            <if test="volunteerActivitiesPeopleVO.issueStatus != null">
                issue_status=#{volunteerActivitiesPeopleVO.issueStatus},
            </if>
            <if test="volunteerActivitiesPeopleVO.issuePoints != null">
                issue_points=#{volunteerActivitiesPeopleVO.issuePoints},
            </if>
            <if test="volunteerActivitiesPeopleVO.activityId != null">
                activity_id=#{volunteerActivitiesPeopleVO.activityId},
            </if>
            update_time=sysdate()
        </set>
        where id = #{volunteerActivitiesPeopleVO.id}
    </update>

    <delete id="vapDelete" parameterType="String">
        delete from volunteer_activities_people_involved where id=#{id}
    </delete>

</mapper>