java/zhihuishenqu.git

			@@ -1,5 +1,12 @@
			package com.panzhihua.service_dangjian.dao;

			import java.util.List;

			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;
			@@ -8,12 +15,6 @@
			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
			@@ -23,162 +24,88 @@
			**/
			@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> " +
			// " <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.orgId != null'>" +
			" and o.id = #{pagePartyOrganizationVO.orgId} "+
			" </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("<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.orgId != null'>" + " and o.id = #{pagePartyOrganizationVO.orgId} "
			+ " </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.id,m.org_id,m.name,m.id_card,m.join_time,m.employment_time,m.audit_result,m.create_at,m.update_at,m.community_id,m.user_id,m.refuse_reason,u.image_url as photoPath 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 \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> "
			+ "<if test='pagePartyBuildingMemberVO.communityId != null'>"
			+ " and m.community_id = #{pagePartyBuildingMemberVO.communityId}" + " </if> " + " order by m.join_time desc "
			+ "</script>")
			IPage<PartyBuildingMemberVO> pagePartyBuildingMembersVO(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> " +
			"<if test='pagePartyBuildingMemberVO.communityId != null'>" +
			" and m.community_id = #{pagePartyBuildingMemberVO.communityId}"+
			" </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>")
			@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);
			}