SELECT a.ID_,a.USER_ID_,a.ORG_ID_,a.DEM_ID_, a.ORG_PERMS_, a.USER_PERMS_,a.POS_PERMS_,a.ORGAUTH_PERMS_,a.LAYOUT_PERMS_, b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as ORGNAME ,d.DEM_NAME_ as DEM_NAME FROM uc_org_auth a left join uc_user b on a.USER_ID_ = b.ID_ left join uc_org c on a.ORG_ID_ = c.ID_ left join uc_demension d on a.DEM_ID_ = d.ID_ ${ew.customSqlSegment} SELECT * FROM uc_org_auth ${ew.customSqlSegment} DELETE FROM uc_org_auth WHERE IS_DELE_='1' SELECT a.ID_,a.USER_ID_,a.ORG_ID_,a.DEM_ID_, a.ORG_PERMS_, a.USER_PERMS_,a.POS_PERMS_,a.ORGAUTH_PERMS_,a.LAYOUT_PERMS_, b.FULLNAME_ as USER_NAME,c.NAME_ as ORGNAME ,d.DEM_NAME_ as DEM_NAME,d.CODE_ as demCode FROM uc_org_auth a inner join uc_user b on a.USER_ID_ = b.ID_ inner join uc_org c on a.ORG_ID_ = c.ID_ inner join uc_demension d on a.DEM_ID_ = d.ID_ ${ew.customSqlSegment} select a.*,b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as ORGNAME,d.DEM_NAME_ as DEM_NAME , c.PATH_ as orgPath from uc_org_auth a inner join uc_user b on a.USER_ID_ = b.ID_ INNER JOIN uc_org c ON a.ORG_ID_ = c.ID_ INNER JOIN uc_demension d ON d.ID_ = a.DEM_ID_ where a.ORG_ID_ = #{orgId} and a.USER_ID_ = #{userId} AND a.IS_DELE_!='1' select a.*,b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT,c.NAME_ as ORGNAME,d.DEM_NAME_ as DEM_NAME , c.PATH_ as orgPath from uc_org_auth a inner join uc_user b on a.USER_ID_ = b.ID_ INNER JOIN uc_org c ON a.ORG_ID_ = c.ID_ INNER JOIN uc_demension d ON d.ID_ = a.DEM_ID_ where a.ORG_ID_ = #{orgId} and a.USER_ID_ = #{userId} AND a.IS_DELE_!='1' UPDATE uc_org_auth SET IS_DELE_='1',UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} WHERE ORG_ID_=#{orgId} SELECT a.ID_,a.USER_ID_,a.ORG_ID_,a.DEM_ID_,a.LAYOUT_PERMS_, b.FULLNAME_ as USER_NAME,c.NAME_ as ORGNAME ,d.DEM_NAME_ as DEM_NAME FROM uc_org_auth a inner join uc_user b on a.USER_ID_ = b.ID_ inner join uc_org c on a.ORG_ID_ = c.ID_ inner join uc_demension d on a.DEM_ID_ = d.ID_ WHERE a.USER_ID_ =#{userId} and (a.LAYOUT_PERMS_ IS NOT NULL or a.LAYOUT_PERMS_ != '') AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1' AND d.IS_DELE_!='1' ORDER BY ID_ DESC SELECT a.ID_,a.USER_ID_,a.ORG_ID_,a.DEM_ID_, a.ORG_PERMS_, a.USER_PERMS_,a.POS_PERMS_,a.ORGAUTH_PERMS_, b.FULLNAME_ as userName,c.NAME_ as orgName,d.DEM_NAME_ as demName,c.PATH_ as orgPath FROM uc_org_auth a left join uc_user b on a.USER_ID_ = b.ID_ left join uc_org c on a.ORG_ID_ = c.ID_ left join uc_demension d on a.DEM_ID_ = d.ID_ where a.USER_ID_ = #{userId} AND a.IS_DELE_!='1' AND b.IS_DELE_!='1' AND c.IS_DELE_!='1' AND d.IS_DELE_!='1' select a.*,b.FULLNAME_ as USER_NAME,b.ACCOUNT_ as USER_ACCOUNT, c.NAME_ as ORGNAME ,c.PATH_ as orgPath,d.DEM_NAME_ as DEM_NAME from uc_org_auth a LEFT JOIN uc_user b on a.USER_ID_ = b.ID_ left join uc_org c on a.ORG_ID_ = c.ID_ left join uc_demension d on a.DEM_ID_ = d.ID_ WHERE b.ACCOUNT_=#{account} AND d.code_=#{demCode} AND a.IS_DELE_!='1'