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.community.ExcelElderAuthDTO;
|
import com.panzhihua.common.model.dtos.community.PageEldersAuthDTO;
|
import com.panzhihua.common.model.vos.R;
|
import com.panzhihua.common.model.vos.community.EldersAuthDetailsVO;
|
import com.panzhihua.common.model.vos.community.EldersAuthVO;
|
import com.panzhihua.service_community.model.dos.EldersAuthDO;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
/**
|
* DAO
|
*
|
* @author cedoo email:cedoo(a)qq.com
|
* @version 1.0
|
* @since 1.0
|
* */
|
@Mapper
|
public interface EldersAuthDAO extends BaseMapper<EldersAuthDO> {
|
|
@Select("<script> " +
|
"SELECT ea.id, ea.create_at, ea.create_by, ea.update_by, ea.update_at," +
|
" ea.AUTH_USER_NAME , ea.ID_CARD, ea.BIRTH_DAY, ea.FAMILY_USER_ID ," +
|
" ea.DOMICILE, ea.SUMIT_USER_ID, u.phone as submitUserAccount ," +
|
" u.name as submitUserName, ROUND(DATEDIFF(CURDATE(), ea.BIRTH_DAY)/365.2422) as age \n" +
|
"FROM com_elders_auth ea LEFT JOIN sys_user u ON ea.SUMIT_USER_ID = u.user_id\n" +
|
" <where> " +
|
"<if test='pageEldersAuthDTO.sumitUserId != null'>" +
|
" AND ea.SUMIT_USER_ID = #{pageEldersAuthDTO.sumitUserId} " +
|
" </if> " +
|
"<if test='pageEldersAuthDTO.idCard != null'>" +
|
" AND ea.ID_CARD = #{pageEldersAuthDTO.idCard} " +
|
" </if> " +
|
"<if test='pageEldersAuthDTO.authUserName != null'>" +
|
" AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.authUserName} " +
|
" </if> " +
|
" </where>" +
|
" ORDER BY ea.${pageEldersAuthDTO.sortBy} ${pageEldersAuthDTO.order} " +
|
"</script>")
|
IPage<EldersAuthVO> selectByPage(Page page, @Param("pageEldersAuthDTO") PageEldersAuthDTO pageEldersAuthDTO);
|
|
|
@Select("<script> " +
|
"SELECT ea.id, ea.create_at, ea.create_by, ea.update_by, ea.update_at," +
|
" ea.AUTH_USER_NAME , ea.ID_CARD, ea.BIRTH_DAY, ea.FAMILY_USER_ID, " +
|
" ea.DOMICILE, ea.SUMIT_USER_ID, u.phone as submitUserAccount ," +
|
" u.name as submitUserName, ROUND(DATEDIFF(CURDATE(), ea.BIRTH_DAY)/365.2422) as age \n" +
|
"FROM com_elders_auth ea LEFT JOIN sys_user u ON ea.SUMIT_USER_ID = u.user_id\n" +
|
" where ea.id = #{id}" +
|
"</script>")
|
EldersAuthDetailsVO selectDetails(@Param("id") Long id);
|
|
@Select("<script> " +
|
"SELECT ea.id, ea.create_at, ea.create_by, ea.update_by, ea.update_at," +
|
" ea.AUTH_USER_NAME , ea.ID_CARD, ea.BIRTH_DAY, ea.FAMILY_USER_ID ," +
|
" ea.DOMICILE, ea.SUMIT_USER_ID, u.phone as submitUserAccount ," +
|
" u.name as submitUserName, ROUND(DATEDIFF(CURDATE(), ea.BIRTH_DAY)/365.2422) as age \n" +
|
"FROM com_elders_auth ea LEFT JOIN sys_user u ON ea.SUMIT_USER_ID = u.user_id\n" +
|
" <where> " +
|
"<if test='pageEldersAuthDTO.sumitUserId != null'>" +
|
" AND ea.SUMIT_USER_ID = #{pageEldersAuthDTO.sumitUserId} " +
|
" </if> " +
|
"<if test='pageEldersAuthDTO.idCard != null'>" +
|
" AND ea.ID_CARD = #{pageEldersAuthDTO.idCard} " +
|
" </if> " +
|
"<if test='pageEldersAuthDTO.authUserName != null'>" +
|
" AND ea.AUTH_USER_NAME = #{pageEldersAuthDTO.authUserName} " +
|
" </if> " +
|
" </where>" +
|
" ORDER BY ea.${pageEldersAuthDTO.sortBy} ${pageEldersAuthDTO.order} " +
|
"</script>")
|
List<ExcelElderAuthDTO> selectByParams(PageEldersAuthDTO pageEldersAuthDTO);
|
}
|