package com.panzhihua.service_dangjian.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.partybuilding.ComPbMemberExcelVO;
|
import com.panzhihua.common.model.vos.partybuilding.PagePartyBuildingMemberVO;
|
import com.panzhihua.common.model.vos.partybuilding.PagePartyOrganizationVO;
|
import com.panzhihua.common.model.vos.partybuilding.PartyBuildingMemberVO;
|
import com.panzhihua.service_dangjian.model.dos.ComPbMemberDO;
|
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 java.util.List;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 党员
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2020-11-30 10:52
|
**/
|
@Mapper
|
public interface ComPbMemberDAO extends BaseMapper<ComPbMemberDO> {
|
// -------------------动态模板-------------
|
// @Select("<script> " +
|
// " <where>" +
|
// "<if test='nameCn != null and nameCn.trim() != ""'>" +
|
// " </if> " +
|
// "<if test='nameCn != null and nameCn.trim() != ""'>" +
|
// " </if> " +
|
// "<if test='nameCn != null and nameCn.trim() != ""'>" +
|
// " </if> " +
|
// " </where>" +
|
// "</script>")
|
|
@Select("<script> " +
|
"SELECT\n" +
|
"o.`name` orgName,\n" +
|
"m.org_id,\n"+
|
"m.id_card,\n"+
|
"m.`id`,\n" +
|
"u.phone,\n" +
|
"m.`name`,\n" +
|
"m.photo_path,\n" +
|
"TIMESTAMPDIFF(\n" +
|
"YEAR,\n" +
|
"m.employment_time,\n" +
|
"DATE_FORMAT( NOW(), '%Y-%m-%d' )) partyAge,\n" +
|
"m.join_time,\n" +
|
"m.employment_time,\n" +
|
"CASE\n" +
|
"WHEN u.id_card IS NULL THEN\n" +
|
"'未注册' ELSE '已注册' \n" +
|
"END STATUS \n" +
|
"FROM\n" +
|
"com_pb_member m\n" +
|
"LEFT JOIN sys_user u ON m.id_card = u.id_card\n" +
|
"LEFT JOIN com_pb_org o ON m.org_id = o.id"+
|
" where m.community_id=#{pagePartyOrganizationVO.communityId} and m.audit_result='1' " +
|
"<if test='pagePartyOrganizationVO.orgName != null and pagePartyOrganizationVO.orgName != ""'>" +
|
"and o.name like concat(#{pagePartyOrganizationVO.orgName},'%') "+
|
" </if> " +
|
"<if test='pagePartyOrganizationVO.account != null and pagePartyOrganizationVO.account != ""'>" +
|
"and u.phone like concat (#{pagePartyOrganizationVO.account},'%')"+
|
" </if> " +
|
"<if test='pagePartyOrganizationVO.name != null and pagePartyOrganizationVO.name != ""'>" +
|
"and m.name like concat (#{pagePartyOrganizationVO.name},'%')"+
|
" </if> " +
|
"order by m.create_at desc "+
|
"</script>")
|
IPage<PartyBuildingMemberVO> pagePartyOrganization(Page page, @Param("pagePartyOrganizationVO") PagePartyOrganizationVO pagePartyOrganizationVO);
|
|
@Select("select m.* from sys_user u join com_pb_member m on u.id_card=m.id_card where u.user_id=#{userId}")
|
ComPbMemberDO selectByUserId(Long userId);
|
|
@Select("select name from sys_user where user_id=#{createBy}")
|
String selectNameByUserId(Long createBy);
|
@Update("update sys_user u set u.is_partymember=0 where u.id_card=#{idCard}")
|
void updateUserIsPartymember(String idCard);
|
|
|
@Select("<script> " +
|
"SELECT\n" +
|
"o.`name` orgName,\n" +
|
"m.org_id,\n"+
|
"m.id_card,\n"+
|
"m.`id`,\n" +
|
"u.phone,\n" +
|
"m.`name`,\n" +
|
"m.photo_path,\n" +
|
"TIMESTAMPDIFF(\n" +
|
"YEAR,\n" +
|
"m.employment_time,\n" +
|
"DATE_FORMAT( NOW(), '%Y-%m-%d' )) partyAge,\n" +
|
"m.join_time,\n" +
|
"m.audit_result, \n" +
|
"m.employment_time,\n" +
|
"CASE\n" +
|
"WHEN u.id_card IS NULL THEN\n" +
|
"'未注册' ELSE '已注册' \n" +
|
"END STATUS \n" +
|
"FROM\n" +
|
"com_pb_member m\n" +
|
"LEFT JOIN sys_user u ON m.id_card = u.id_card\n" +
|
"LEFT JOIN com_pb_org o ON m.org_id = o.id"+
|
" where m.user_id is not null " +
|
"<if test='pagePartyBuildingMemberVO.phone != null and pagePartyBuildingMemberVO.phone != ""'>" +
|
"and u.phone = #{pagePartyBuildingMemberVO.phone} "+
|
" </if> " +
|
"<if test='pagePartyBuildingMemberVO.name != null and pagePartyBuildingMemberVO.name != ""'>" +
|
"and u.name like concat (#{pagePartyBuildingMemberVO.name},'%')"+
|
" </if> " +
|
"<if test='pagePartyBuildingMemberVO.auditStatus != null and pagePartyBuildingMemberVO.auditStatus != ""'>" +
|
"and m.audit_result = #{pagePartyBuildingMemberVO.auditStatus}"+
|
" </if> " +
|
"order by m.join_time desc "+
|
"</script>")
|
IPage<PartyBuildingMemberVO> pagePartyBuildingMemberVO(Page page, @Param("pagePartyBuildingMemberVO") PagePartyBuildingMemberVO pagePartyBuildingMemberVO);
|
|
@Select("<script> " +
|
"SELECT\n" +
|
"o.`name` orgName,\n" +
|
"m.org_id,\n"+
|
"m.id_card,\n"+
|
"m.`id`,\n" +
|
"u.phone,\n" +
|
"m.`name`,\n" +
|
"m.photo_path,\n" +
|
"TIMESTAMPDIFF(\n" +
|
"YEAR,\n" +
|
"m.employment_time,\n" +
|
"DATE_FORMAT( NOW(), '%Y-%m-%d' )) partyAge,\n" +
|
"m.join_time,\n" +
|
"m.audit_result, \n" +
|
"m.employment_time,\n" +
|
"CASE\n" +
|
"WHEN u.id_card IS NULL THEN\n" +
|
"'未注册' ELSE '已注册' \n" +
|
"END STATUS," +
|
" m.create_at \n" +
|
"FROM\n" +
|
"com_pb_member m\n" +
|
"LEFT JOIN sys_user u ON m.id_card = u.id_card\n" +
|
"LEFT JOIN com_pb_org o ON m.org_id = o.id"+
|
" where m.audit_result in (0,3) " +
|
"<if test='pagePartyBuildingMemberVO.phone != null and pagePartyBuildingMemberVO.phone != ""'>" +
|
" and u.phone LIKE CONCAT('%',#{pagePartyBuildingMemberVO.phone},'%') "+
|
" </if> " +
|
"<if test='pagePartyBuildingMemberVO.name != null and pagePartyBuildingMemberVO.name != ""'>" +
|
" and u.name like concat ('%',#{pagePartyBuildingMemberVO.name},'%')"+
|
" </if> " +
|
"<if test='pagePartyBuildingMemberVO.auditStatus != null'>" +
|
" and m.audit_result = #{pagePartyBuildingMemberVO.auditStatus}"+
|
" </if> " +
|
" order by m.join_time desc "+
|
"</script>")
|
IPage<PartyBuildingMemberVO> pagePartyBuildingMembersVO(Page page, @Param("pagePartyBuildingMemberVO") PagePartyBuildingMemberVO pagePartyBuildingMemberVO);
|
|
@Select("<script> " +
|
"select cpm.name as comName,cpm.id_card,cpm.join_time,cpm.employment_time,ca.`name` as communityName,cpo.name as orgName from com_pb_member as cpm " +
|
" left join com_act as ca on ca.community_id = cpm.community_id " +
|
" left join com_pb_org as cpo on cpo.id = cpm.org_id " +
|
" LEFT JOIN sys_user u ON cpm.id_card = u.id_card " +
|
" where cpm.community_id = #{organizationVO.communityId} and cpm.audit_result = 1 " +
|
"<if test='organizationVO.orgName != null'>" +
|
" and cpo.name LIKE CONCAT('%',#{organizationVO.orgName},'%') "+
|
" </if> " +
|
"<if test='organizationVO.account != null and organizationVO.account != ""'>" +
|
" and u.phone like concat (#{organizationVO.account},'%')"+
|
" </if> " +
|
"<if test='organizationVO.name != null and organizationVO.name != ""'>" +
|
" and cpm.name like concat (#{organizationVO.name},'%')"+
|
" </if> " +
|
"</script>")
|
List<ComPbMemberExcelVO> exportPbMember(@Param("organizationVO") PagePartyOrganizationVO organizationVO);
|
}
|
