新增网格员管理 网格管理模块

lidongdong

2023-10-27 c2c210204de6fa75f11990d3ff4fac893cdc9993

新增网格员管理   网格管理模块

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/model/vos/jinhui/JinhuiReseauPeopleVO.java

New file
@@ -0,0 +1,45 @@
package com.panzhihua.common.model.vos.jinhui;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.Date;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("金汇网格员")
public class JinhuiReseauPeopleVO implements Serializable {
    private static final long serialVersionUID = -70884515430727555L;

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


    @ApiModelProperty(value = "绑定用户id")
    private String userId;

    @ApiModelProperty(value = "网格员名称")
    private String reseauName;

    @ApiModelProperty(value = "负责网格")
    private String reseauIds;

    @ApiModelProperty(value = "联系电话")
    private String phone;

    @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;
}

 springcloud_k8s_panzhihuazhihuishequ/common/src/main/java/com/panzhihua/common/service/jinhui/JinhuiCommunityService.java

@@ -963,4 +963,115 @@




    /********************************************************************************************************
     *
     *
     *                             金汇网格
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @GetMapping("/jinhuiReseau/getReseauList")
    public R getReseauList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize);


    @GetMapping("/jinhuiReseau/getReseauDetails")
    public R getReseauDetails(@RequestParam("id")String id);

    /**
     * 新增
     * @param
     * @return
     */
    @PostMapping("/jinhuiReseau/addReseauData")
    public R addReseauData(@RequestBody JinhuiReseauVO item);


    @PostMapping("/jinhuiReseau/editReseauData")
    public R editReseauData(@RequestBody JinhuiReseauVO item);

    @PostMapping("/jinhuiReseau/expurgateReseauData")
    public R expurgateReseauData(@RequestParam("id") String id);




    /********************************************************************************************************
     *
     *
     *                             金汇网格员
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     * @param
     * @return
     */
    @GetMapping("/jinhuiReseau/getPeopleList")
    public R getPeopleList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize);


    /**
     * 分页查询
     * 获取本社区用户
     * @param
     * @return
     */
    @GetMapping("/getPeopleUserList")
    public R getPeopleUserList(@RequestParam("pageNum") int pageNum,
                               @RequestParam("pageSize") int pageSize);

    /**
     * 详情
     * @param id
     * @return
     */
    @GetMapping("/jinhuiReseau/getPeopleDetails")
    public R getPeopleDetails(@RequestParam("id") String id);

    /**
     * 新增
     * @param
     * @return
     */
    @PostMapping("/jinhuiReseau/addPeopleData")
    public R addPeopleData(@RequestBody JinhuiReseauPeopleVO item);


    /**
     * 编辑
     * @param item
     * @return
     */
    @PostMapping("/jinhuiReseau/editPeopleData")
    public R editPeopleData(@RequestBody JinhuiReseauPeopleVO item);

    /**
     * 删除
     * @param id
     * @return
     */
    @DeleteMapping("/jinhuiReseau/expurgatePeopleData")
    public R expurgatePeopleData(@RequestParam("id") String id);










}

 springcloud_k8s_panzhihuazhihuishequ/community_backstage/src/main/java/com/panzhihua/community_backstage/api/JinhuiAppi.java

@@ -4,6 +4,7 @@
import com.panzhihua.common.model.dtos.community.ComActWorkGuideDTO;
import com.panzhihua.common.model.dtos.community.PageActWorkGuideDTO;
import com.panzhihua.common.model.dtos.community.convenient.JinhuiPageConvenientMerchantDTO;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.community.ComActWorkGuideClassifyVO;
import com.panzhihua.common.model.vos.community.ComActWorkGuideVO;
@@ -1270,4 +1271,158 @@
        return jinhuiCommunityService.answerExpurgateData(id);
    }




    /********************************************************************************************************
     *
     *
     *                             金汇网格
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @ApiOperation(value = "金汇网格列表",response = JinhuiReseauVO.class)
    @GetMapping("/getReseauList")
    public R getReseauList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize)
    {
        return jinhuiCommunityService.getReseauList(pageNum,pageSize);
    }


    @ApiOperation(value = "金汇网格详情",response = JinhuiReseauVO.class)
    @GetMapping("/getReseauDetails")
    public R getReseauDetails(@RequestParam("id")String id)
    {
        return jinhuiCommunityService.getReseauDetails(id);
    }

    /**
     * 新增
     * @param
     * @return
     */
    @ApiOperation(value = "金汇网格新增")
    @PostMapping("/addReseauData")
    public R addReseauData(@RequestBody JinhuiReseauVO item)
    {
        return jinhuiCommunityService.addReseauData(item);
    }


    @ApiOperation(value = "金汇网格编辑")
    @PostMapping("/editReseauData")
    public R editReseauData(@RequestBody JinhuiReseauVO item)
    {
        return jinhuiCommunityService.editReseauData(item);
    }


    @ApiOperation(value = "金汇网格删除")
    @PostMapping("/expurgateReseauData")
    public R expurgateReseauData(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.expurgateReseauData(id);
    }




    /********************************************************************************************************
     *
     *
     *                             金汇网格员
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     * @param
     * @return
     */
    @ApiOperation(value = "金汇网格员管理列表",response = JinhuiReseauPeopleVO.class)
    @GetMapping("/jinhuiReseau/getPeopleList")
    public R getPeopleList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize)
    {
        return jinhuiCommunityService.getPeopleList(pageNum,pageSize);
    }


    /**
     * 分页查询
     * 获取本社区用户
     * @param
     * @return
     */
    @ApiOperation(value = "金汇网格员管理社区用户列表",response = LoginUserInfoVO.class)
    @GetMapping("/getPeopleUserList")
    public R getPeopleUserList(@RequestParam("pageNum") int pageNum,
                               @RequestParam("pageSize") int pageSize)
    {
        return jinhuiCommunityService.getPeopleUserList(pageNum,pageSize);
    }

    /**
     * 详情
     * @param id
     * @return
     */
    @ApiOperation(value = "金汇网格员管理详情",response = JinhuiReseauPeopleVO.class)
    @GetMapping("/jinhuiReseau/getPeopleDetails")
    public R getPeopleDetails(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.getPeopleDetails(id);
    }

    /**
     * 新增
     * @param
     * @return
     */
    @ApiOperation(value = "金汇网格员管理新增")
    @PostMapping("/jinhuiReseau/addPeopleData")
    public R addPeopleData(@RequestBody JinhuiReseauPeopleVO item)
    {
        return jinhuiCommunityService.addPeopleData(item);
    }


    /**
     * 编辑
     * @param item
     * @return
     */

    @ApiOperation(value = "金汇网格员管理编辑")
    @PostMapping("/jinhuiReseau/editPeopleData")
    public R editPeopleData(@RequestBody JinhuiReseauPeopleVO item)
    {
        return jinhuiCommunityService.editPeopleData(item);
    }

    /**
     * 删除
     * @param id
     * @return
     */
    @ApiOperation(value = "金汇网格员管理删除")
    @DeleteMapping("/jinhuiReseau/expurgatePeopleData")
    public R expurgatePeopleData(@RequestParam("id") String id)
    {
        return jinhuiCommunityService.expurgatePeopleData(id);
    }





}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/api/JinhuiReseauPeopleApi.java

New file
@@ -0,0 +1,166 @@
package com.panzhihua.service_jinhui_community.api;


import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauPeopleVO;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauVO;
import com.panzhihua.service_jinhui_community.service.JinhuiReseauPeopleService;
import com.panzhihua.service_jinhui_community.service.JinhuiReseauService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

/**
 * @auther llming
 * @describe 金汇网格Api
 */
@Slf4j
@RestController
@RequestMapping("/jinhuiReseau")
public class JinhuiReseauPeopleApi extends BaseController
{
    @Resource
    private JinhuiReseauPeopleService peopleService;


    @Resource
    private JinhuiReseauService reseauService;



    /********************************************************************************************************
     *
     *
     *                             金汇网格
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @GetMapping("/getReseauList")
    public R getReseauList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize) {
        return reseauService.getList(pageNum, pageSize);
    }


    @GetMapping("/getReseauDetails")
    public R getReseauDetails(@RequestParam("id") String id)
    {
        return R.ok(reseauService.getDetails(id));
    }

    /**
     * 新增
     * @param
     * @return
     */
    @PostMapping("/addReseauData")
    public R addReseauData(@RequestBody JinhuiReseauVO item)
    {
        return reseauService.addData(item);
    }


    @PostMapping("/editReseauData")
    public R editReseauData(@RequestBody JinhuiReseauVO item)
    {
        return reseauService.editData(item);
    }

    @PostMapping("/expurgateReseauData")
    public R expurgateReseauData(@RequestParam("id") String id)
    {
        return reseauService.expurgateData(id);
    }




    /********************************************************************************************************
     *
     *
     *                             金汇网格员
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     * @param
     * @return
     */
    @GetMapping("/getPeopleList")
    public R getPeopleList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize)
    {
        return peopleService.getList(pageNum,pageSize);
    }


    /**
     * 分页查询
     * 获取本社区用户
     * @param
     * @return
     */
    @GetMapping("/getPeopleUserList")
    public R getPeopleUserList(@RequestParam("pageNum") int pageNum,
                           @RequestParam("pageSize") int pageSize)
    {
        return peopleService.getUserList(pageNum,pageSize,getCommunityId()+"");
    }

    /**
     * 详情
     * @param id
     * @return
     */
    @GetMapping("/getPeopleDetails")
    public R getPeopleDetails(@RequestParam("id") String id)
    {
        return R.ok(peopleService.getDetails(id));
    }

    /**
     * 新增
     * @param
     * @return
     */
    @PostMapping("/addPeopleData")
    public R addPeopleData(@RequestBody JinhuiReseauPeopleVO item)
    {
        return peopleService.addData(item);
    }


    /**
     * 编辑
     * @param item
     * @return
     */
    @PostMapping("/editPeopleData")
    public R editPeopleData(@RequestBody JinhuiReseauPeopleVO item)
    {
        return peopleService.editData(item);
    }

    /**
     * 删除
     * @param id
     * @return
     */
    @DeleteMapping("/expurgatePeopleData")
    public R expurgatePeopleData(@RequestParam("id") String id)
    {
        return peopleService.expurgateData(id);
    }

}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/api/JinhuiSnapshotApi.java

@@ -2,14 +2,10 @@

import com.panzhihua.common.controller.BaseController;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauVO;
import com.panzhihua.common.model.vos.jinhui.JinhuiSnapshotClassifyVO;
import com.panzhihua.common.model.vos.jinhui.JinhuiSnapshotVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiReseau;
import com.panzhihua.service_jinhui_community.entity.JinhuiSnapshot;
import com.panzhihua.service_jinhui_community.entity.JinhuiSnapshotClassify;
import com.panzhihua.service_jinhui_community.service.JinhuiComActWorkGuideService;
import com.panzhihua.service_jinhui_community.service.JinhuiReseauService;
import com.panzhihua.service_jinhui_community.service.JinhuiSnapshotClassifyService;
import com.panzhihua.service_jinhui_community.service.JinhuiSnapshotService;
import lombok.extern.slf4j.Slf4j;
@@ -32,8 +28,7 @@
    @Resource
    private JinhuiSnapshotService snapshotService;

    @Resource
    private JinhuiReseauService reseauService;


    /************************************************************************************************************
     *
@@ -146,55 +141,7 @@
    }


    /********************************************************************************************************
     *
     *
     *                             金汇网格员
     *
     *
     ****************************************************************************************************/

    /**
     * 分页查询
     *
     * @param
     * @return
     */
    @GetMapping("/getReseauList")
    public R getReseauList(int pageNum, int pageSize) {
        return reseauService.getList(pageNum, pageSize);
    }


    @GetMapping("/getReseauDetails")
    public R getReseauDetails(String id)
    {
        return R.ok(reseauService.getDetails(id));
    }

    /**
     * 新增
     * @param
     * @return
     */
    @PostMapping("/addReseauData")
    public R addReseauData(JinhuiReseauVO item)
    {
        return reseauService.addData(item);
    }


    @PostMapping("/editReseauData")
    public R editReseauData(JinhuiReseauVO item)
    {
        return reseauService.editData(item);
    }

    @PostMapping("/expurgateReseauData")
    public R expurgateReseauData(String id)
    {
        return reseauService.expurgateData(id);
    }




 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/dao/JinhuiReseauPeopleDao.java

New file
@@ -0,0 +1,55 @@
package com.panzhihua.service_jinhui_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.LoginUserInfoVO;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauPeopleVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiReseauPeople;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface JinhuiReseauPeopleDao extends BaseMapper<JinhuiReseauPeople>
{
    /**
     * 列表
     * @param
     * @return
     */
    IPage<JinhuiReseauPeople> getList(Page page);


    IPage<LoginUserInfoVO> getUserList(Page page,@Param("communityId") String communityId);

    /**
     * 详情
     * @param id
     * @return
     */
    JinhuiReseauPeople getDetails(@Param("id") String id);

    /**
     * 新增
     * @param
     * @return
     */
    int addData(@Param("item") JinhuiReseauPeopleVO item);


    /**
     * 编辑
     * @param item
     * @return
     */
    int editData(@Param("item") JinhuiReseauPeopleVO item);

    /**
     * 删除
     * @param id
     * @return
     */
    int expurgateData(@Param("id") String id);


}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/entity/JinhuiReseauPeople.java

New file
@@ -0,0 +1,45 @@
package com.panzhihua.service_jinhui_community.entity;

import com.fasterxml.jackson.annotation.JsonFormat;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;
import java.util.Date;

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@ApiModel("金汇网格员")
public class JinhuiReseauPeople implements Serializable {
    private static final long serialVersionUID = -70884515430727555L;

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


    @ApiModelProperty(value = "绑定用户id")
    private String userId;

    @ApiModelProperty(value = "网格员名称")
    private String reseauName;

    @ApiModelProperty(value = "负责网格")
    private String reseauIds;

    @ApiModelProperty(value = "联系电话")
    private String phone;

    @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;
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/JinhuiReseauPeopleService.java

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

import com.baomidou.mybatisplus.extension.service.IService;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauPeopleVO;
import com.panzhihua.service_jinhui_community.entity.JinhuiReseauPeople;

public interface JinhuiReseauPeopleService extends IService<JinhuiReseauPeople>
{
    /**
     * 分页查询
     * @param
     * @return
     */
    R getList(int pageNum,int pageSize);

    R getUserList(int pageNum,int pageSize,String communityId);

    JinhuiReseauPeople getDetails(String id);
    /**
     * 新增
     * @param
     * @return
     */
    R addData(JinhuiReseauPeopleVO item);

    R editData(JinhuiReseauPeopleVO item);

    R expurgateData(String id);
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/java/com/panzhihua/service_jinhui_community/service/impl/JinhuiReseauPeopleServiceImpl.java

New file
@@ -0,0 +1,72 @@
package com.panzhihua.service_jinhui_community.service.impl;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.common.model.vos.LoginUserInfoVO;
import com.panzhihua.common.model.vos.R;
import com.panzhihua.common.model.vos.jinhui.JinhuiReseauPeopleVO;
import com.panzhihua.service_jinhui_community.dao.JinhuiReseauPeopleDao;
import com.panzhihua.service_jinhui_community.entity.JinhuiReseauPeople;
import com.panzhihua.service_jinhui_community.entity.JinhuiSnapshot;
import com.panzhihua.service_jinhui_community.service.JinhuiReseauPeopleService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;


@Slf4j
@Service
public class JinhuiReseauPeopleServiceImpl extends ServiceImpl<JinhuiReseauPeopleDao,
        JinhuiReseauPeople> implements JinhuiReseauPeopleService
{

    @Override
    public R getList(int pageNum,int pageSize)
    {
        Page page = new Page<JinhuiSnapshot>(pageNum,pageSize);
        return R.ok(baseMapper.getList(page));
    }

    @Override
    public R getUserList(int pageNum, int pageSize, String communityId)
    {
        Page page = new Page<LoginUserInfoVO>(pageNum,pageSize);
        return R.ok(baseMapper.getUserList(page,communityId));
    }

    @Override
    public JinhuiReseauPeople getDetails(String id) {
        return baseMapper.getDetails(id);
    }


    @Override
    public R addData(JinhuiReseauPeopleVO item)
    {
        int num= baseMapper.addData(item);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }

    @Override
    public R editData(JinhuiReseauPeopleVO item) {
        int num= baseMapper.editData(item);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }

    @Override
    public R expurgateData(String id) {
        int num= baseMapper.expurgateData(id);
        if(num>0)
        {
            return R.ok();
        }
        return R.fail("添加失败");
    }
}

 springcloud_k8s_panzhihuazhihuishequ/service_jinhui_community/src/main/resources/mapper/JinhuiReseauPeopleMapper.xml

New file
@@ -0,0 +1,161 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.panzhihua.service_jinhui_community.dao.JinhuiReseauPeopleDao">

    <resultMap type="com.panzhihua.service_jinhui_community.entity.JinhuiReseauPeople" id="itemMap">
        <result property="id" column="id" />
        <result property="userId" column="user_id" />
        <result property="reseauName" column="reseau_name" />
        <result property="reseauIds" column="reseau_ids" />
        <result property="phone" column="phone" />
        <result property="creationTime" column="creation_time" />
        <result property="updateTime" column="update_time" />
    </resultMap>


    <!-- 分页查询 -->
    <select id="getList" resultMap="itemMap">
        select
            id,
            reseau_name,
            reseau_ids,
            phone,
            creation_time,
            update_time,
            user_id
        from jinhui_reseau_people
        order by creation_time desc
    </select>


    <select id="getDetails" resultMap="itemMap">
        select
            id,
            reseau_name,
            reseau_ids,
            phone,
            creation_time,
            update_time,
            user_id
        from jinhui_reseau_people
        where
            id=#{id}
    </select>

    <insert id="addData">
        insert into jinhui_reseau_people
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="item.id != null and item.id != '' ">
                id,
            </if>
            <if test="item.userId != null and item.userId != '' ">
                user_id,
            </if>
            <if test="item.reseauName != null and item.reseauName != '' ">
                reseau_name,
            </if>

            <if test="item.reseauIds != null and item.reseauIds != '' ">
                reseau_ids,
            </if>
            <if test="item.phone != null and item.phone != '' ">
                phone,
            </if>
            creation_time
        </trim>
        values
        <trim prefix="("  suffix=")" suffixOverrides=",">
            <if test="item.id != null and item.id != '' ">
                #{item.id},
            </if>
            <if test="item.userId != null and item.userId != '' ">
                #{item.userId},
            </if>
            <if test="item.reseauName != null and item.reseauName != '' ">
                #{item.reseauName},
            </if>
            <if test="item.reseauIds != null and item.reseauIds != '' ">
                #{item.reseauIds},
            </if>
            <if test="item.phone != null and item.phone != '' ">
                #{item.phone},
            </if>
            sysdate()
        </trim>
    </insert>

    <update id="editData">
        update jinhui_reseau_people
        <set>
            <if test="jinhui_snapshot_classify.id != null and item.id != '' ">
                id=#{item.id},
            </if>
            <if test="item.userId != null and item.userId != '' ">
                user_id=#{item.userId},
            </if>
            <if test="item.reseauName != null and item.reseauName != '' ">
                reseau_name=#{item.reseauName},
            </if>
            <if test="item.reseauIds != null and item.reseauIds != '' ">
                reseau_ids=#{item.reseauIds},
            </if>
            <if test="item.phone != null and item.phone != '' ">
                phone=#{item.phone},
            </if>
            update_time=sysdate()
        </set>
        where id = #{item.id}
    </update>

    <delete id="expurgateData" parameterType="String">
        delete from jinhui_reseau_people where id=#{id}
    </delete>


    <select id="getUserList" resultType="com.panzhihua.common.model.vos.LoginUserInfoVO">
        select
            user_id,
            phone,
            nick_name,
            `name`,
            community_id,
            sex,
            id_card,
            birthday,
            image_url,
            `type`,
            job,
            is_volunteer,
            is_partymember,
            status,
            create_at,
            last_login_time,
            tags,
            family_id,
            face_url,
            face_state,
            reject_reson,
            area_id,
            card_photo_front,
            card_photo_back,
            family_book,
            continuous_landing_days,
            is_tips,
            work_status,
            work_start_time,
            work_end_time,
            big_age_tips,
            street_id,
            relation_name,
            app_id,
            is_accept,
            binding_check_unit_id,
            love_integral
        from sys_user
        where
            community_id=#{communityId}
    </select>



</mapper>