package com.panzhihua.service_dangjian.dao;
|
|
import com.panzhihua.common.model.vos.community.ComActVO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
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.partybuilding.west.PartyCommitteeVO;
|
import com.panzhihua.common.model.vos.user.SysUserVO;
|
import com.panzhihua.service_dangjian.model.dos.ComPbMemberRoleDO;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 党委
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-12-01 14:36
|
**/
|
@Mapper
|
public interface ComPbMemberRoleDAO extends BaseMapper<ComPbMemberRoleDO> {
|
|
/**
|
* 分页查询党委列表
|
* @param page 分页参数
|
* @param partyCommitteeVO 请求参数
|
* @return 党委列表
|
*/
|
IPage<PartyCommitteeVO> pagePartyOrganization(Page page,
|
@Param("partyCommitteeVO") PartyCommitteeVO partyCommitteeVO);
|
|
|
|
IPage<com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO> pagePartyOrganizations(Page page,
|
@Param("partyCommitteeVO") com.panzhihua.common.model.vos.partybuilding.PartyCommitteeVO partyCommitteeVO);
|
|
|
@Select("select * from sys_user where phone=#{phone} AND app_id = #{appid} and type=1")
|
SysUserVO getSysUserByPhone(@Param("phone") String phone, @Param("appid") String appid);
|
|
/**
|
* 根据身份证查询小程序用户id
|
* @param idCard 身份证
|
* @param areaCode
|
* @return 小程序用户id
|
*/
|
Long getUserIdByIdCard(@Param("idCard") String idCard, @Param("areaCode") String areaCode);
|
|
/**
|
* 根据手机号查询小程序用户id
|
* @param phone 手机号
|
* @param appid
|
* @return 小程序用户id
|
*/
|
Long getSysUserIdByPhone(@Param("phone") String phone, @Param("appid") String appid);
|
|
@Update("update sys_user u set u.phone=#{newphone} where u.phone=#{oldphone}")
|
void updateUserPhone(@Param("newphone") String newphone, @Param("oldphone") String oldphone);
|
|
@Select("select * from com_pb_member_role where id=#{id}")
|
PartyCommitteeVO selectPartyCommitteeById(@Param("id") Long id);
|
|
/**
|
* 根据身份证查询用户数量
|
* @param idCard 身份证号码
|
* @param areaCode
|
* @return 用户数量
|
*/
|
Integer getSysUserByIdCardCount(@Param("idCard") String idCard, @Param("areaCode") String areaCode);
|
|
/**
|
* 获取社区信息
|
* @param communityId
|
* @return
|
*/
|
ComActVO selectActById(@Param("communityId") Long communityId);
|
}
|
