|  |  | 
 |  |  |                 "meeting_user_rel ur\n" + | 
 |  |  |                 "LEFT JOIN `SYSTEM_USER` su ON ur.USER_ID = su.id \n" + | 
 |  |  |                 "LEFT JOIN meeting_book b ON ur.OBJ_ID = b.id \n" + | 
 |  |  |                 "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS = 0" + | 
 |  |  |                 "WHERE DATE_FORMAT(b.START_TIME,'%Y') = #{yearNum} AND b.STATUS in(0,2) and b.isdeleted=0" + | 
 |  |  |                 "<if test='userId != null'>"+ | 
 |  |  |                 "and ur.USER_ID = #{userId}\n" + | 
 |  |  |                 "</if>"+ | 
 |  |  | 
 |  |  |         LW_FK(0,"劳务访客"), | 
 |  |  |         PT_FK(1,"普通访客"), | 
 |  |  |         NB_FK(2,"内部人员"), | 
 |  |  |  | 
 |  |  |         COMPANY_TYPE_REL(0,"相关方组织"), | 
 |  |  |         COMPANY_TYPE_INTERNAL(1,"内部人员"), | 
 |  |  |         COMPANY_TYPE_FK(3,"访客"), | 
 |  |  |  | 
 |  |  |         /** 进场类型 **/ | 
 |  |  |         OUT(0,"出"), | 
 |  |  | 
 |  |  |         HIDDEN_DANGER_SUBMIT(0, "隐患随手拍提报", "隐患随手拍提报"), | 
 |  |  |         HIDDEN_DANGER_DEAL_BEFORE(1, "隐患随手拍处理前", "隐患随手拍处理前"), | 
 |  |  |         HIDDEN_DANGER_DEAL_AFTER(2, "隐患随手拍处理后 ", "隐患随手拍处理后 "), | 
 |  |  |         MEETING_BOOKS(4, "会议文件 ", "会议文件 "), | 
 |  |  |         ; | 
 |  |  |         // 成员变量 | 
 |  |  |         private String name; |