12/23 三社联动开发相关

101captain

2021-12-23 682ebd53987c1368c9e47476a76c0ab6449a171c

12/23  三社联动开发相关

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

New file
@@ -0,0 +1,76 @@
package com.panzhihua.common.model.vos.community.social;

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;


/**
 * 项目人员(ComActSocialProjectMember)表实体类
 *
 * @author makejava
 * @since 2021-12-23 15:16:42
 */
@Data
@ApiModel("项目人员")
public class ComActSocialProjectMemberVO implements Serializable {

    private Long id;

    /**
     * 姓名
     */
    @ApiModelProperty(value = "姓名")
    private String name;

    /**
     * 年龄
     */
    @ApiModelProperty(value = "年龄")
    private Integer age;

    /**
     * 照片
     */
    @ApiModelProperty(value = "照片")
    private String image;

    /**
     * 手机号
     */
    @ApiModelProperty(value = "手机号")
    private String phone;

    /**
     * 类型 1社工 2志愿者
     */
    @ApiModelProperty(value = "类型 1社工 2志愿者")
    private Integer type;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

    /**
     * 所属社区
     */
    @ApiModelProperty(value = "社区名称")
    private String communityName;

    @ApiModelProperty(value = "人员Id")
    private Long paramId;
}

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

New file
@@ -0,0 +1,68 @@
package com.panzhihua.common.model.vos.community.social;

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;


/**
 * 项目宣传表(ComActSocialProjectPublicity)表实体类
 *
 * @author makejava
 * @since 2021-12-23 14:30:54
 */
@Data
@ApiModel("项目宣传表")
public class ComActSocialProjectPublicityVO {


    private Long id;

    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    private String title;

    /**
     * 封面图
     */
    @ApiModelProperty(value = "封面图")
    private String image;

    /**
     * 内容
     */
    @ApiModelProperty(value = "内容")
    private String content;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 浏览量
     */
    @ApiModelProperty(value = "浏览量")
    private Integer views;

    /**
     * 是否置顶 0否 1是
     */
    @ApiModelProperty(value = "是否置顶")
    private Integer isTop;
}

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

New file
@@ -0,0 +1,50 @@
package com.panzhihua.common.model.vos.community.social;

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;


/**
 * 项目进度表(ComActSocialProjectSchedule)表实体类
 *
 * @author makejava
 * @since 2021-12-23 14:31:15
 */
@Data
@ApiModel("项目进度表")
public class ComActSocialProjectScheduleVO{

    private Long id;

    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    private String title;

    /**
     * 内容
     */
    @ApiModelProperty(value = "内容")
    private String content;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

}

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

New file
@@ -0,0 +1,116 @@
package com.panzhihua.common.model.vos.community.social;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import java.util.Date;

/**
 * @author zzj
 */
@Data
@ApiModel("项目实体")
public class SocialProjectVO {

    private Long id;

    /**
     * 项目名称
     */
    @ApiModelProperty(value = "项目名称")
    private String name;

    /**
     * 项目类型 1公共文化 2社会组织参与 3 社会企业带动 4其他
     */
    @ApiModelProperty(value = "项目类型 1公共文化 2社会组织参与 3 社会企业带动 4其他")
    private Integer type;

    /**
     * 项目状态  1初创项目 2公开发布 3运作中 4 已结束
     */
    @ApiModelProperty(value = "项目状态  1初创项目 2公开发布 3运作中 4 已结束")
    private Integer status;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createTime;

    /**
     * 社区id
     */
    @ApiModelProperty(value = "社区id")
    private Long communityId;

    /**
     * 街道id
     */
    @ApiModelProperty(value = "街道id")
    private Long streetId;

    /**
     * 责任方
     */
    @ApiModelProperty(value = "责任方")
    private String responsibility;

    /**
     * 父项目id
     */
    @ApiModelProperty(value = "父项目id")
    private Long parentId;

    /**
     * 附件
     */
    @ApiModelProperty(value = "附件")
    private String url;

    /**
     * 封面
     */
    @ApiModelProperty(value = "封面")
    private String image;

    /**
     * 介绍
     */
    @ApiModelProperty(value = "介绍")
    private String content;

    /**
     * 项目等级
     */
    @ApiModelProperty(value = "项目等级")
    private Integer level;

    /**
     * 浏览量
     */
    @ApiModelProperty(value = "浏览量")
    private Integer views;

    /**
     * 社区名字
     */
    @ApiModelProperty(value = "社区名字")
    private String communityName;

    /**
     * 街道名字
     */
    @ApiModelProperty(value = "街道名字")
    private String streetName;

    /**
     * 街道电话
     */
    @ApiModelProperty(value = "街道电话")
    private String streetPhone;
}

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

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


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.vos.community.social.SocialProjectVO;
import com.panzhihua.service_community.entity.ComActSocialProject;
import com.panzhihua.service_community.service.ComActSocialProjectService;
import org.springframework.beans.BeanUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * 三社联动项目表(ComActSocialProject)表控制层
 *
 * @author makejava
 * @since 2021-12-22 14:02:48
 */
@RestController
@RequestMapping("comActSocialProject")
public class ComActSocialProjectApi {
    /**
     * 服务对象
     */
    @Resource
    private ComActSocialProjectService comActSocialProjectService;

    /**
     * 分页查询所有数据
     *
     * @param commonPage 查询实体
     * @return 所有数据
     */
    @PostMapping("queryAll")
    public R selectAll(@RequestBody CommonPage commonPage) {
        return this.comActSocialProjectService.pageList(commonPage);
    }

    /**
     * 平台详情接口
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable("id") Long id) {
        return R.ok(this.comActSocialProjectService.getById(id));
    }
    /**
     * 根据项目id分页获取关联项目
     */
    @PostMapping("/getRelation")
    public R getRelation(@RequestBody CommonPage commonPage){
        return this.comActSocialProjectService.getProject(commonPage);
    }

    /**
     * 新增数据
     *
     * @param socialProjectVO 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody SocialProjectVO socialProjectVO) {
        ComActSocialProject comActSocialProject=new ComActSocialProject();
        BeanUtils.copyProperties(socialProjectVO,comActSocialProject);
        comActSocialProject.setCreateTime(new Date());
        return R.ok(this.comActSocialProjectService.save(comActSocialProject));
    }

    /**
     * 修改数据
     *
     * @param socialProjectVO 实体对象
     * @return 修改结果
     */
    @PostMapping("/update")
    public R update(@RequestBody SocialProjectVO socialProjectVO) {
        ComActSocialProject comActSocialProject=new ComActSocialProject();
        BeanUtils.copyProperties(socialProjectVO,comActSocialProject);
        return R.ok(this.comActSocialProjectService.updateById(comActSocialProject));
    }

    /**
     * 删除数据
     *
     * @param id 主键结合
     * @return 删除结果
     */
    @GetMapping("del")
    public R delete(@RequestParam("id") Long id) {
        return R.ok(this.comActSocialProjectService.removeById(id));
    }

    /**
     * 小程序详情接口
     * @param id
     * @return
     */
    @GetMapping("/getApplet")
    public R getApplet(@RequestParam("id") Long id){
        return this.comActSocialProjectService.getByApplet(id);
    }
}

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

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


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectMemberVO;
import com.panzhihua.service_community.entity.ComActSocialProjectMember;
import com.panzhihua.service_community.service.ComActSocialProjectMemberService;
import org.springframework.beans.BeanUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.List;

/**
 * 项目人员(ComActSocialProjectMember)表控制层
 *
 * @author makejava
 * @since 2021-12-23 15:16:43
 */
@RestController
@RequestMapping("comActSocialProjectMember")
public class ComActSocialProjectMemberApi {
    /**
     * 服务对象
     */
    @Resource
    private ComActSocialProjectMemberService comActSocialProjectMemberService;

    /**
     * 分页查询所有数据
     *
     * @param commonPage 查询实体
     * @return 所有数据
     */
    @PostMapping("queryAll")
    public R selectAll(@RequestBody CommonPage commonPage) {
        return this.comActSocialProjectMemberService.pageList(commonPage);
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable("id") Long id) {
        return R.ok(this.comActSocialProjectMemberService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param comActSocialProjectMemberVO 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody ComActSocialProjectMemberVO comActSocialProjectMemberVO) {
        return this.comActSocialProjectMemberService.insert(comActSocialProjectMemberVO);
    }

    /**
     * 修改数据
     *
     * @param comActSocialProjectMemberVO 实体对象
     * @return 修改结果
     */
    @PostMapping("/update")
    public R update(@RequestBody ComActSocialProjectMemberVO comActSocialProjectMemberVO) {
        ComActSocialProjectMember comActSocialProjectMember=new ComActSocialProjectMember();
        BeanUtils.copyProperties(comActSocialProjectMemberVO,comActSocialProjectMember);
        return R.ok(this.comActSocialProjectMemberService.updateById(comActSocialProjectMember));
    }

    /**
     * 删除数据
     *
     * @param id 主键结合
     * @return 删除结果
     */
    @GetMapping("del")
    public R delete(@RequestParam("id") Long id) {
        return R.ok(this.comActSocialProjectMemberService.removeById(id));
    }
}

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

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


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectPublicityVO;
import com.panzhihua.service_community.entity.ComActSocialProjectPublicity;
import com.panzhihua.service_community.service.ComActSocialProjectPublicityService;
import org.springframework.beans.BeanUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * 项目宣传表(ComActSocialProjectPublicity)表控制层
 *
 * @author makejava
 * @since 2021-12-23 14:30:55
 */
@RestController
@RequestMapping("comActSocialProjectPublicity")
public class ComActSocialProjectPublicityApi {
    /**
     * 服务对象
     */
    @Resource
    private ComActSocialProjectPublicityService comActSocialProjectPublicityService;

    /**
     * 分页查询所有数据
     *
     * @param commonPage 查询实体
     * @return 所有数据
     */
    @PostMapping("queryAll")
    public R selectAll(@RequestBody CommonPage commonPage) {
        return this.comActSocialProjectPublicityService.pageList(commonPage);
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable("id") Long id) {
        return R.ok(this.comActSocialProjectPublicityService.getById(id));
    }

    /**
     * 小程序通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("/getByApplet/{id}")
    public R getByApplet(@PathVariable("id") Long id) {
        ComActSocialProjectPublicity comActSocialProjectPublicity=this.comActSocialProjectPublicityService.getById(id);
        comActSocialProjectPublicity.setViews(comActSocialProjectPublicity.getViews()+1);
        this.comActSocialProjectPublicityService.updateById(comActSocialProjectPublicity);
        return R.ok(this.comActSocialProjectPublicityService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param comActSocialProjectPublicityVO 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody ComActSocialProjectPublicityVO comActSocialProjectPublicityVO) {
        ComActSocialProjectPublicity comActSocialProjectPublicity=new ComActSocialProjectPublicity();
        BeanUtils.copyProperties(comActSocialProjectPublicityVO,comActSocialProjectPublicity);
        comActSocialProjectPublicity.setCreateTime(new Date());
        return R.ok(this.comActSocialProjectPublicityService.save(comActSocialProjectPublicity));
    }

    /**
     * 修改数据
     *
     * @param comActSocialProjectPublicityVO 实体对象
     * @return 修改结果
     */
    @PostMapping("/update")
    public R update(@RequestBody ComActSocialProjectPublicityVO comActSocialProjectPublicityVO) {
        ComActSocialProjectPublicity comActSocialProjectPublicity=new ComActSocialProjectPublicity();
        BeanUtils.copyProperties(comActSocialProjectPublicityVO,comActSocialProjectPublicity);
        return R.ok(this.comActSocialProjectPublicityService.updateById(comActSocialProjectPublicity));
    }

    /**
     * 删除数据
     *
     * @param id 主键结合
     * @return 删除结果
     */
    @GetMapping("del")
    public R delete(@RequestParam("id") Long id) {
        return R.ok(this.comActSocialProjectPublicityService.removeById(id));
    }
    /**
     * 多条删除数据
     *
     * @param ids 主键结合
     * @return 删除结果
     */
    @GetMapping("delBatch")
    public R delBatch(@RequestParam("ids") List<Long> ids) {
        return R.ok(this.comActSocialProjectPublicityService.removeByIds(ids));
    }
}

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

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


import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.api.ApiController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectPublicityVO;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectScheduleVO;
import com.panzhihua.service_community.entity.ComActSocialProjectSchedule;
import com.panzhihua.service_community.service.ComActSocialProjectScheduleService;
import org.springframework.beans.BeanUtils;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.io.Serializable;
import java.util.Date;
import java.util.List;

/**
 * 项目进度表(ComActSocialProjectSchedule)表控制层
 *
 * @author makejava
 * @since 2021-12-23 14:31:16
 */
@RestController
@RequestMapping("comActSocialProjectSchedule")
public class ComActSocialProjectScheduleApi {
    /**
     * 服务对象
     */
    @Resource
    private ComActSocialProjectScheduleService comActSocialProjectScheduleService;

    /**
     * 根据projectId查询所有进度
     *
     * @param commonPage 查询实体
     * @return 所有数据
     */
    @PostMapping("queryAll")
    public R selectAll(@RequestBody CommonPage commonPage) {
        return this.comActSocialProjectScheduleService.pageList(commonPage);
    }

    /**
     * 通过主键查询单条数据
     *
     * @param id 主键
     * @return 单条数据
     */
    @GetMapping("{id}")
    public R selectOne(@PathVariable("id") Long id) {
        return R.ok(this.comActSocialProjectScheduleService.getById(id));
    }

    /**
     * 新增数据
     *
     * @param comActSocialProjectScheduleVO 实体对象
     * @return 新增结果
     */
    @PostMapping
    public R insert(@RequestBody ComActSocialProjectScheduleVO comActSocialProjectScheduleVO) {
        ComActSocialProjectSchedule comActSocialProjectSchedule=new ComActSocialProjectSchedule();
        BeanUtils.copyProperties(comActSocialProjectScheduleVO,comActSocialProjectSchedule);
        comActSocialProjectSchedule.setCreateTime(new Date());
        return R.ok(this.comActSocialProjectScheduleService.save(comActSocialProjectSchedule));
    }

    /**
     * 修改数据
     *
     * @param comActSocialProjectScheduleVO 实体对象
     * @return 修改结果
     */
    @PostMapping("/update")
    public R update(@RequestBody ComActSocialProjectScheduleVO comActSocialProjectScheduleVO) {
        ComActSocialProjectSchedule comActSocialProjectSchedule=new ComActSocialProjectSchedule();
        BeanUtils.copyProperties(comActSocialProjectScheduleVO,comActSocialProjectSchedule);
        return R.ok(this.comActSocialProjectScheduleService.updateById(comActSocialProjectSchedule));
    }

    /**
     * 删除数据
     *
     * @param id 主键结合
     * @return 删除结果
     */
    @GetMapping("del")
    public R delete(@RequestParam("id") Long id) {
        return R.ok(this.comActSocialProjectScheduleService.removeById(id));
    }
}

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

New file
@@ -0,0 +1,36 @@
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.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.social.SocialProjectVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialProject;
import org.apache.ibatis.annotations.Param;

/**
 * 三社联动项目表(ComActSocialProject)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-22 14:02:46
 */
@Mapper
public interface ComActSocialProjectDao extends BaseMapper<ComActSocialProject> {

    /**
     * 分页查询
     * @param page
     * @param commonPage
     * @return
     */
    IPage<SocialProjectVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);

    /**
     * 小程序查询项目详情
     * @param id
     * @return
     */
    SocialProjectVO getByApplet(Long id);

}

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

New file
@@ -0,0 +1,28 @@
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.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectMemberVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialProjectMember;
import org.apache.ibatis.annotations.Param;

/**
 * 项目人员(ComActSocialProjectMember)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-23 15:16:42
 */
@Mapper
public interface ComActSocialProjectMemberDao extends BaseMapper<ComActSocialProjectMember> {

    /**
     * 分页查询
     * @param page
     * @param commonPage
     * @return
     */
    IPage<ComActSocialProjectMemberVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);
}

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

New file
@@ -0,0 +1,27 @@
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.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectPublicityVO;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialProjectPublicity;
import org.apache.ibatis.annotations.Param;

/**
 * 项目宣传表(ComActSocialProjectPublicity)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-23 14:30:54
 */
@Mapper
public interface ComActSocialProjectPublicityDao extends BaseMapper<ComActSocialProjectPublicity> {
    /**
     * 分页查询
     * @param page
     * @param commonPage
     * @return
     */
    IPage<ComActSocialProjectPublicityVO> pageList(Page page, @Param("commonPage")CommonPage commonPage);
}

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

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

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComActSocialProjectSchedule;

/**
 * 项目进度表(ComActSocialProjectSchedule)表数据库访问层
 *
 * @author makejava
 * @since 2021-12-23 14:31:15
 */
@Mapper
public interface ComActSocialProjectScheduleDao extends BaseMapper<ComActSocialProjectSchedule> {

}

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

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

import java.util.Date;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
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;


/**
 * 三社联动项目表(ComActSocialProject)表实体类
 *
 * @author makejava
 * @since 2021-12-22 14:02:46
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("三社联动项目表")
public class ComActSocialProject implements Serializable {

    private static final long serialVersionUID = -24945028672614601L;

    @TableId(type = IdType.AUTO)
    private Long id;

    /**
     * 项目名称
     */
    @ApiModelProperty(value = "项目名称")
    private String name;

    /**
     * 项目类型 1公共文化 2社会组织参与 3 社会企业带动 4其他
     */
    @ApiModelProperty(value = "项目类型 1公共文化 2社会组织参与 3 社会企业带动 4其他")
    private Integer type;

    /**
     * 项目状态  1初创项目 2公开发布 3运作中 4 已结束
     */
    @ApiModelProperty(value = "项目状态  1初创项目 2公开发布 3运作中 4 已结束")
    private Integer status;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 社区id
     */
    @ApiModelProperty(value = "社区id")
    private Long communityId;

    /**
     * 街道id
     */
    @ApiModelProperty(value = "街道id")
    private Long streetId;

    /**
     * 责任方
     */
    @ApiModelProperty(value = "责任方")
    private String responsibility;

    /**
     * 父项目id
     */
    @ApiModelProperty(value = "父项目id")
    private Long parentId;

    /**
     * 附件
     */
    @ApiModelProperty(value = "附件")
    private String url;

    /**
     * 封面
     */
    @ApiModelProperty(value = "封面")
    private String image;

    /**
     * 介绍
     */
    @ApiModelProperty(value = "介绍")
    private String content;

    /**
     * 项目等级
     */
     @ApiModelProperty(value = "项目等级")
    private Integer level;

    /**
     * 浏览量
     */
    @ApiModelProperty(value = "浏览量")
    private Integer views;
}

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

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

import java.util.Date;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
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;


/**
 * 项目人员(ComActSocialProjectMember)表实体类
 *
 * @author makejava
 * @since 2021-12-23 15:16:42
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("项目人员")
public class ComActSocialProjectMember implements Serializable {

    private static final long serialVersionUID = 982451898968415899L;

    @TableId(type = IdType.AUTO)
    private Long id;

    /**
     * 姓名
     */
    @ApiModelProperty(value = "姓名")
    private String name;

    /**
     * 年龄
     */
    @ApiModelProperty(value = "年龄")
    private Integer age;

    /**
     * 照片
     */
    @ApiModelProperty(value = "照片")
    private String image;

    /**
     * 手机号
     */
    @ApiModelProperty(value = "手机号")
    private String phone;

    /**
     * 类型 1社工 2志愿者
     */
    @ApiModelProperty(value = "类型 1社工 2志愿者")
    private Integer type;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

}

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

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

import java.util.Date;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
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;


/**
 * 项目宣传表(ComActSocialProjectPublicity)表实体类
 *
 * @author makejava
 * @since 2021-12-23 14:30:54
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("项目宣传表")
public class ComActSocialProjectPublicity implements Serializable {

    private static final long serialVersionUID = -90937393082259077L;

    @TableId(type = IdType.AUTO)
    private Long id;

    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    private String title;

    /**
     * 封面图
     */
    @ApiModelProperty(value = "封面图")
    private String image;

    /**
     * 内容
     */
    @ApiModelProperty(value = "内容")
    private String content;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 浏览量
     */
    @ApiModelProperty(value = "浏览量")
    private Integer views;

    /**
     * 是否置顶 0否 1是
     */
    @ApiModelProperty(value = "是否置顶")
    private Integer isTop;
}

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

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

import java.util.Date;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
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;


/**
 * 项目进度表(ComActSocialProjectSchedule)表实体类
 *
 * @author makejava
 * @since 2021-12-23 14:31:15
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("项目进度表")
public class ComActSocialProjectSchedule implements Serializable {

    private static final long serialVersionUID = -17588094441653342L;

    @TableId(type = IdType.AUTO)
    private Long id;

    /**
     * 标题
     */
    @ApiModelProperty(value = "标题")
    private String title;

    /**
     * 内容
     */
    @ApiModelProperty(value = "内容")
    private String content;

    /**
     * 创建时间
     */
    @ApiModelProperty(value = "创建时间")
    private Date createTime;

    /**
     * 项目id
     */
    @ApiModelProperty(value = "项目id")
    private Long projectId;

}

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

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

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.panzhihua.common.model.vos.community.social.SocialProjectVO;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

import java.util.List;

/**
 * @author zzj
 */
@Data
@ApiModel("相关项目")
public class ProjectRelationVO {
    @ApiModelProperty("一级父类项目")
    private SocialProjectVO fatherProjectLevelOne;
    @ApiModelProperty("二级父类项目")
    private SocialProjectVO fatherProjectLevelTwo;
    @ApiModelProperty("子类项目")
    private IPage<SocialProjectVO> socialProjectVOIPage;
}

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

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

import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectMemberVO;
import com.panzhihua.service_community.entity.ComActSocialProjectMember;

/**
 * 项目人员(ComActSocialProjectMember)表服务接口
 *
 * @author makejava
 * @since 2021-12-23 15:16:43
 */
public interface ComActSocialProjectMemberService extends IService<ComActSocialProjectMember> {
    /**
     * 分页查询
     *
     * @param commonPage
     * @return
     */
    R pageList(CommonPage commonPage);

    /**
     * 添加人员
     * @param comActSocialProjectMemberVO
     * @return
     */
    R insert(ComActSocialProjectMemberVO comActSocialProjectMemberVO);
}

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

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

import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.service_community.entity.ComActSocialProjectPublicity;

/**
 * 项目宣传表(ComActSocialProjectPublicity)表服务接口
 *
 * @author makejava
 * @since 2021-12-23 14:30:54
 */
public interface ComActSocialProjectPublicityService extends IService<ComActSocialProjectPublicity> {
    /**
     * 分页查询
     *
     * @param commonPage
     * @return
     */
    R pageList(CommonPage commonPage);
}

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

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

import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.service_community.entity.ComActSocialProjectSchedule;

/**
 * 项目进度表(ComActSocialProjectSchedule)表服务接口
 *
 * @author makejava
 * @since 2021-12-23 14:31:16
 */
public interface ComActSocialProjectScheduleService extends IService<ComActSocialProjectSchedule> {
    /**
     * 分页查询
     *
     * @param commonPage
     * @return
     */
    R pageList(CommonPage commonPage);
}

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

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

import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.service_community.entity.ComActSocialProject;

/**
 * 三社联动项目表(ComActSocialProject)表服务接口
 *
 * @author makejava
 * @since 2021-12-22 14:02:47
 */
public interface ComActSocialProjectService extends IService<ComActSocialProject> {
    /**
     * 分页查询
     *
     * @param commonPage
     * @return
     */
    R pageList(CommonPage commonPage);

    /**
     * 小程序获取详情
     * @param id
     * @return
     */
    R getByApplet(Long id);

    /**
     * 根据项目id分页查询关联项目
     * @param commonPage
     * @return
     */
    R getProject(CommonPage commonPage);
}

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

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

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.social.ComActSocialProjectMemberVO;
import com.panzhihua.common.utlis.DateUtils;
import com.panzhihua.service_community.dao.ComActSocialWorkerDao;
import com.panzhihua.service_community.dao.ComMngVolunteerMngDAO;
import com.panzhihua.service_community.entity.ComActSocialProjectMember;
import com.panzhihua.service_community.dao.ComActSocialProjectMemberDao;
import com.panzhihua.service_community.entity.ComActSocialWorker;
import com.panzhihua.service_community.model.dos.ComMngVolunteerMngDO;
import com.panzhihua.service_community.service.ComActSocialProjectMemberService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.Date;

/**
 * 项目人员(ComActSocialProjectMember)表服务实现类
 *
 * @author makejava
 * @since 2021-12-23 15:16:43
 */
@Slf4j
@Service
public class ComActSocialProjectMemberServiceImpl extends ServiceImpl<ComActSocialProjectMemberDao, ComActSocialProjectMember> implements ComActSocialProjectMemberService {

    @Resource
    private ComActSocialProjectMemberDao comActSocialProjectMemberDao;
    @Resource
    private ComActSocialWorkerDao comActSocialWorkerDao;
    @Resource
    private ComMngVolunteerMngDAO comMngVolunteerMngDAO;
    @Override
    public R pageList(CommonPage commonPage) {
        return R.ok(this.comActSocialProjectMemberDao.pageList(new Page(commonPage.getPage(),commonPage.getSize()),commonPage));
    }

    @Override
    public R insert(ComActSocialProjectMemberVO comActSocialProjectMemberVO) {
        if(comActSocialProjectMemberVO.getType()==1){
            ComActSocialWorker comActSocialWorker=comActSocialWorkerDao.selectById(comActSocialProjectMemberVO.getParamId());
            if(comActSocialWorker!=null){
                ComActSocialProjectMember comActSocialProjectMember=new ComActSocialProjectMember();
                BeanUtils.copyProperties(comActSocialProjectMemberVO,comActSocialProjectMember);
                comActSocialProjectMember.setAge(getAge(comActSocialWorker.getIdCard()));
                comActSocialProjectMember.setImage(comActSocialWorker.getImage());
                comActSocialProjectMember.setName(comActSocialWorker.getName());
                comActSocialProjectMember.setPhone(comActSocialWorker.getTelephone());
                comActSocialProjectMember.setCreateTime(new Date());
                comActSocialProjectMemberDao.insert(comActSocialProjectMember);
                return R.ok();
            }
        }
        else {
            ComMngVolunteerMngDO comMngVolunteerMngDO=comMngVolunteerMngDAO.selectById(comActSocialProjectMemberVO.getParamId());
            if(comMngVolunteerMngDO!=null){
                ComActSocialProjectMember comActSocialProjectMember=new ComActSocialProjectMember();
                BeanUtils.copyProperties(comActSocialProjectMemberVO,comActSocialProjectMember);
                comActSocialProjectMember.setAge(comMngVolunteerMngDO.getAge());
                comActSocialProjectMember.setImage(comMngVolunteerMngDO.getPhotoPath());
                comActSocialProjectMember.setName(comMngVolunteerMngDO.getName());
                comActSocialProjectMember.setPhone(comMngVolunteerMngDO.getPhone());
                comActSocialProjectMember.setCreateTime(new Date());
                comActSocialProjectMemberDao.insert(comActSocialProjectMember);
                return R.ok();
            }
        }
        return R.fail("参数异常");
    }

    public Integer getAge(String idCard){
        Integer year=Integer.parseInt(idCard.substring(5,9));
        Integer nowYear= DateUtils.getYear(new Date());
        return nowYear-year;
    }
}

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

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

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.service_community.entity.ComActSocialProjectPublicity;
import com.panzhihua.service_community.dao.ComActSocialProjectPublicityDao;
import com.panzhihua.service_community.service.ComActSocialProjectPublicityService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * 项目宣传表(ComActSocialProjectPublicity)表服务实现类
 *
 * @author makejava
 * @since 2021-12-23 14:30:55
 */
@Slf4j
@Service
public class ComActSocialProjectPublicityServiceImpl extends ServiceImpl<ComActSocialProjectPublicityDao, ComActSocialProjectPublicity> implements ComActSocialProjectPublicityService {

    @Resource
    private ComActSocialProjectPublicityDao comActSocialProjectPublicityDao;
    @Override
    public R pageList(CommonPage commonPage) {
        return R.ok(comActSocialProjectPublicityDao.pageList(new Page(commonPage.getPage(),commonPage.getSize()),commonPage));
    }
}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.service_community.entity.ComActSocialProjectSchedule;
import com.panzhihua.service_community.dao.ComActSocialProjectScheduleDao;
import com.panzhihua.service_community.service.ComActSocialProjectScheduleService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * 项目进度表(ComActSocialProjectSchedule)表服务实现类
 *
 * @author makejava
 * @since 2021-12-23 14:31:16
 */
@Slf4j
@Service
public class ComActSocialProjectScheduleServiceImpl extends ServiceImpl<ComActSocialProjectScheduleDao, ComActSocialProjectSchedule> implements ComActSocialProjectScheduleService {

    @Resource
    private ComActSocialProjectScheduleDao comActSocialProjectScheduleDao;
    @Override
    public R pageList(CommonPage commonPage) {
        return R.ok(comActSocialProjectScheduleDao.selectList(new QueryWrapper<ComActSocialProjectSchedule>().lambda().eq(ComActSocialProjectSchedule::getProjectId,commonPage.getParamId()).orderByDesc(ComActSocialProjectSchedule::getCreateTime)));
    }
}

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

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

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
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.dtos.property.CommonPage;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.social.SocialProjectVO;
import com.panzhihua.service_community.entity.ComActSocialProject;
import com.panzhihua.service_community.dao.ComActSocialProjectDao;
import com.panzhihua.service_community.entity.ProjectRelationVO;
import com.panzhihua.service_community.service.ComActSocialProjectService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

/**
 * 三社联动项目表(ComActSocialProject)表服务实现类
 *
 * @author makejava
 * @since 2021-12-22 14:02:48
 */
@Slf4j
@Service
public class ComActSocialProjectServiceImpl extends ServiceImpl<ComActSocialProjectDao, ComActSocialProject> implements ComActSocialProjectService {

    @Resource
    private ComActSocialProjectDao comActSocialProjectDao;
    @Override
    public R pageList(CommonPage commonPage) {
        return R.ok(comActSocialProjectDao.pageList(new Page(commonPage.getPage(),commonPage.getSize()),commonPage));
    }

    @Override
    public R getByApplet(Long id) {
        ComActSocialProject comActSocialProject=this.comActSocialProjectDao.selectById(id);
        comActSocialProject.setViews(comActSocialProject.getViews()+1);
        comActSocialProjectDao.updateById(comActSocialProject);
        return R.ok(comActSocialProjectDao.getByApplet(id));
    }

    @Override
    public R getProject(CommonPage commonPage) {
        if(commonPage.getParamId()==null){
            return R.fail("数据异常");
        }
        ProjectRelationVO projectRelationVO=new ProjectRelationVO();
        ComActSocialProject comActSocialProject=this.comActSocialProjectDao.selectById(commonPage.getParamId());
        if(comActSocialProject.getLevel()==1){
            ComActSocialProject comActSocialProject1=this.comActSocialProjectDao.selectOne(new QueryWrapper<ComActSocialProject>().lambda().eq(ComActSocialProject::getId,comActSocialProject.getParentId()));
            if(comActSocialProject1!=null){
                SocialProjectVO socialProjectVO=new SocialProjectVO();
                BeanUtils.copyProperties(comActSocialProject1,socialProjectVO);
                projectRelationVO.setFatherProjectLevelOne(socialProjectVO);
            }

        }
        if(comActSocialProject.getLevel()==2){
            ComActSocialProject comActSocialProject1=this.comActSocialProjectDao.selectOne(new QueryWrapper<ComActSocialProject>().lambda().eq(ComActSocialProject::getId,comActSocialProject.getParentId()));
            if(comActSocialProject1!=null){
                SocialProjectVO socialProjectVO=new SocialProjectVO();
                BeanUtils.copyProperties(comActSocialProject1,socialProjectVO);
                projectRelationVO.setFatherProjectLevelTwo(socialProjectVO);
                ComActSocialProject comActSocialProject2=this.comActSocialProjectDao.selectOne(new QueryWrapper<ComActSocialProject>().lambda().eq(ComActSocialProject::getId,comActSocialProject1.getParentId()));
                if(comActSocialProject2!=null){
                    SocialProjectVO socialProjectVO1=new SocialProjectVO();
                    BeanUtils.copyProperties(comActSocialProject2,socialProjectVO1);
                    projectRelationVO.setFatherProjectLevelOne(socialProjectVO1);
                }
            }
        }
        IPage<SocialProjectVO> socialProjectVOIPage=this.comActSocialProjectDao.pageList(new Page(commonPage.getPage(),commonPage.getSize()),commonPage);
        projectRelationVO.setSocialProjectVOIPage(socialProjectVOIPage);
        return R.ok(projectRelationVO);
    }
}

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

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

    <resultMap type="com.panzhihua.service_community.entity.ComActSocialProject" id="ComActSocialProjectBaseResultMap">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="type" column="type"/>
        <result property="status" column="status"/>
        <result property="createTime" column="create_time"/>
        <result property="communityId" column="community_id"/>
        <result property="streetId" column="street_id"/>
        <result property="responsibility" column="responsibility"/>
        <result property="parentId" column="parent_id"/>
        <result property="url" column="url"/>
        <result property="image" column="image"/>
        <result property="content" column="content"/>
    </resultMap>

    <select id="pageList" resultType="com.panzhihua.common.model.vos.community.social.SocialProjectVO">
        select * from com_act_social_project
        <where>
            1=1
            <if test="commonPage.communityId !=0 and commonPage.communityId ！=null">
                and community_id =#{commmonPage.communityId}
            </if>
            <if test="commonPage.streetId !=0 and commonPage.streetId ！=null">
                and street_id =#{commmonPage.streetId}
            </if>
            <if test="commonPage.status ！=null">
                and status =#{commmonPage.status}
            </if>
            <if test="commonPage.type ！=null">
                and type =#{commmonPage.type}
            </if>
            <if test="commonPage.keyword ！=null and commonPage.keyword !=''">
                and (name like concat('%',#{commmonPage.keyword},'%')  or responsibility like concat('%',#{commmonPage.keyword},'%') )
            </if>
            <if test="commonPage.beginTime ！=null">
                and create_time >= #{commonPage.beginTime}
            </if>
            <if test="commonPage.endTime ！=null">
                and #{commonPage.endTime} >= create_time
            </if>
            <if test="commonPage.paramId !=null">
                and parent_id = #{commonPage.paramId}
            </if>
        </where>
        order by create_time desc
    </select>

    <select id="getByApplet" resultType="com.panzhihua.common.model.vos.community.social.SocialProjectVO">
        select t.*,t1.phone as streetPhone from com_act_social_project t LEFT JOIN com_street t1 on t.street_id = t1.street_id where t.id =#{id}
    </select>
</mapper>

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

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

    <resultMap type="com.panzhihua.service_community.entity.ComActSocialProjectMember"
               id="ComActSocialProjectMemberBaseResultMap">
        <result property="id" column="id"/>
        <result property="name" column="name"/>
        <result property="age" column="age"/>
        <result property="image" column="image"/>
        <result property="phone" column="phone"/>
        <result property="type" column="type"/>
        <result property="createTime" column="create_time"/>
        <result property="projectId" column="project_id"/>
        <result property="communityId" column="community_id"/>
    </resultMap>

    <select id="pageList" resultType="com.panzhihua.common.model.vos.community.social.ComActSocialProjectMemberVO">
        select t.*,t1.name as communityName from com_act_social_project_member t left join com_act t1 on t.community_id = t1.community_id where t.project_id = #{commonPage.paramId}
        <if test="commonPage.type !=null">
            and t1.type=#{commonPage.type}
        </if>
        order by t.create_time desc
    </select>

</mapper>

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

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

    <resultMap type="com.panzhihua.service_community.entity.ComActSocialProjectPublicity"
               id="ComActSocialProjectPublicityBaseResultMap">
        <result property="id" column="id"/>
        <result property="title" column="title"/>
        <result property="image" column="image"/>
        <result property="content" column="content"/>
        <result property="projectId" column="project_id"/>
        <result property="createTime" column="create_time"/>
        <result property="views" column="views"/>
    </resultMap>

    <select id="pageList" resultType="com.panzhihua.common.model.vos.community.social.ComActSocialProjectPublicityVO">
        select * from com_act_social_project_publicity where project_id = #{commonPage.paramId} order by is_top desc,create_time desc
    </select>

</mapper>

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

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

    <resultMap type="com.panzhihua.service_community.entity.ComActSocialProjectSchedule"
               id="ComActSocialProjectScheduleBaseResultMap">
        <result property="id" column="id"/>
        <result property="title" column="title"/>
        <result property="content" column="content"/>
        <result property="createTime" column="create_time"/>
        <result property="projectId" column="project_id"/>
    </resultMap>

</mapper>