ID_,FULLNAME_,ACCOUNT_,PASSWORD_,EMAIL_,MOBILE_,CREATE_TIME_,ADDRESS_,PHOTO_,SEX_,FROM_,STATUS_,HAS_SYNC_TO_WX_, NOTIFY_TYPE_,USER_NUMBER_,ID_CARD_,PHONE_, BIRTHDAY_,ENTRY_DATE_,LEAVE_DATE_,EDUCATION_,UPDATE_TIME_,IS_DELE_,VERSION_,WEIXIN_,PWD_CREATE_TIME_,tenant_id_, create_by_,update_by_, CLIENT_ID_,CLIENT_TOKEN_, LOCKED_STATUS_,LOCKED_TIME_,USER_TYPE_,LAST_LOGIN_TIME_ SELECT FROM UC_USER WHERE ACCOUNT_=#{account} AND IS_DELE_!='1' SELECT count(1) FROM UC_USER WHERE ACCOUNT_ = #{account} AND IS_DELE_!='1' SELECT FROM uc_user WHERE MOBILE_=#{mobile} AND IS_DELE_!='1' select u.*, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where uu.OPEN_ID_ = #{openId} select u.*, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_,uu.MP_OPEN_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where uu.MP_OPEN_ID_ = #{openId} SELECT FROM uc_user WHERE USER_NUMBER_=#{userNumber,jdbcType=VARCHAR} AND IS_DELE_!='1' SELECT org.ID_ "ORG_ID_", org.NAME_ "ORG_NAME_" ,org.CODE_ "ORG_CODE_",orguser.IS_MASTER_ "IS_MASTER_",orguser.POS_ID_ "relId",orguser.ID_ "orgUserId", u.*,rel.POS_NAME_ "relName" FROM uc_user u inner JOIN UC_ORG_USER orguser on u.ID_=orguser.USER_ID_ inner join UC_ORG org on org.ID_=orguser.ORG_ID_ inner join UC_ORG_POST rel ON orguser.POS_ID_=rel.ID_ and orguser.POS_ID_=#{postId} where orguser.IS_REL_ACTIVE_=1 AND org.IS_DELE_!='1' AND orguser.IS_DELE_!='1' AND u.IS_DELE_!='1' AND rel.IS_DELE_!='1' AND u.STATUS_ =1 SELECT org.ID_ "ORG_ID_", org.NAME_ "ORG_NAME_" ,org.CODE_ "ORG_CODE_",orguser.IS_MASTER_ "IS_MASTER_",orguser.POS_ID_ "relId",orguser.ID_ "orgUserId", u.*,rel.POS_NAME_ "relName" FROM uc_user u inner JOIN UC_ORG_USER orguser on u.ID_=orguser.USER_ID_ inner join UC_ORG org on org.ID_=orguser.ORG_ID_ inner join UC_ORG_POST rel ON orguser.POS_ID_=rel.ID_ and rel.CODE_=#{postCode} where orguser.IS_REL_ACTIVE_=1 AND org.IS_DELE_!='1' AND orguser.IS_DELE_!='1' AND u.IS_DELE_!='1' AND rel.IS_DELE_!='1' AND u.STATUS_ =1 SELECT u.*,r.CODE_ from uc_user u inner JOIN uc_user_role ur on u.ID_=ur.USER_ID_ inner join UC_ROLE r on ur.ROLE_ID_=r.ID_ and ur.ROLE_ID_=#{roleId} WHERE u.IS_DELE_!='1' AND ur.IS_DELE_!='1' AND r.IS_DELE_!='1' AND u.STATUS_ =1 SELECT u.*,r.CODE_ from uc_user u inner JOIN uc_user_role ur on u.ID_=ur.USER_ID_ inner join UC_ROLE r on ur.ROLE_ID_=r.ID_ WHERE u.IS_DELE_!='1' AND ur.IS_DELE_!='1' AND r.IS_DELE_!='1' AND u.STATUS_ =1 and (r.CODE_=#{roleCode} or r.ID_=#{roleCode} ) SELECT u.*,r.CODE_ from uc_user u inner JOIN uc_user_role ur on u.ID_=ur.USER_ID_ inner join UC_ROLE r on ur.ROLE_ID_=r.ID_ WHERE u.IS_DELE_!='1' AND ur.IS_DELE_!='1' AND r.IS_DELE_!='1' AND u.STATUS_ =1 and (r.CODE_=#{ew.paramNameValuePairs.role_code_} or r.ID_=#{ew.paramNameValuePairs.role_code_} ) AND ${@com.artfess.base.ognl.Ognl@withOutWhere(ew.customSqlSegment)} SELECT DISTINCT ID_,FULLNAME_,ACCOUNT_,MOBILE_,EMAIL_,UPDATE_TIME_,STATUS_,SEX_,LOCKED_STATUS_,LOCKED_TIME_,USER_TYPE_,LAST_LOGIN_TIME_ FROM ( SELECT u.*, t1.ORG_ID_, t1.DEM_ID_, t2.POS_NAME_ POST_NAME_, t3.NAME_ JOB_NAME_, t4.NAME_ ROLE_NAME_ FROM ( SELECT ID_,FULLNAME_,ACCOUNT_,MOBILE_,EMAIL_,STATUS_,UPDATE_TIME_,SEX_,LOCKED_STATUS_,LOCKED_TIME_,USER_TYPE_,LAST_LOGIN_TIME_ FROM uc_user WHERE IS_DELE_ != '1' ) u LEFT JOIN ( SELECT orguser.ORG_ID_, orguser.USER_ID_, orguser.POS_ID_, org.DEM_ID_ FROM ( SELECT DISTINCT ORG_ID_, USER_ID_,POS_ID_ FROM UC_ORG_USER WHERE IS_DELE_ != '1' ) orguser INNER JOIN ( select ID_,DEM_ID_ from uc_org where IS_DELE_ != '1' ) org ON org.ID_ = orguser.ORG_ID_ INNER JOIN ( select ID_ from uc_demension where IS_DELE_ != '1' ) dem ON org.DEM_ID_ = dem.ID_ ) t1 ON u.ID_ = t1.USER_ID_ LEFT JOIN ( SELECT ID_,post.POS_NAME_, post.ORG_ID_, post.JOB_ID_ FROM uc_org_post post WHERE IS_DELE_ != '1' ) t2 ON t1.POS_ID_ = t2.ID_ LEFT JOIN ( SELECT job.ID_, job.NAME_ FROM uc_org_job job WHERE IS_DELE_ != '1' ) t3 ON t2.JOB_ID_ = t3.ID_ LEFT JOIN ( SELECT roleuser.USER_ID_, role.NAME_ FROM uc_user_role roleuser INNER JOIN uc_role role ON roleuser.ROLE_ID_ = role.ID_ WHERE roleuser.IS_DELE_ != '1' AND role.IS_DELE_ != '1' ) t4 ON u.ID_ = t4.USER_ID_ ) t5 ${ew.customSqlSegment} SELECT orguser.ID_ "orgUserId", org.ID_ "orgId", org.NAME_ "orgName" ,org.CODE_ "orgCode", orguser.IS_MASTER_ "isMaster",rel.POS_NAME_ "relName",rel.ID_ "relId",orguser.USER_ID_ "userId" FROM uc_org_user orguser join UC_ORG org on org.ID_=orguser.ORG_ID_ LEFT JOIN UC_ORG_POST rel ON orguser.POS_ID_=rel.ID_ and rel.IS_DELE_!='1' ${ew.customSqlSegment} SELECT org.ID_ "ORG_ID_", org.name_ "org_name_" ,org.CODE_ "org_CODE_", u.* FROM uc_user u inner JOIN (select DISTINCT ORG_ID_,USER_ID_ from UC_ORG_USER WHERE IS_DELE_!='1' ) orguser on u.ID_=orguser.USER_ID_ inner join UC_ORG org on org.ID_=orguser.ORG_ID_ ${ew.customSqlSegment} SELECT org.ID_ "ORG_ID_", org.NAME_ "ORG_NAME_" ,org.CODE_ "org_CODE_", u.* FROM uc_user u inner JOIN (select DISTINCT ORG_ID_,USER_ID_ from UC_ORG_USER WHERE IS_DELE_!='1') orguser on u.ID_=orguser.USER_ID_ inner join UC_ORG org on org.ID_=orguser.ORG_ID_ and org.ID_=#{orgId} WHERE org.IS_DELE_!='1' AND u.IS_DELE_!='1' AND u.STATUS_ =1 update UC_USER set IS_DELE_='0' where ID_ = #{id} update UC_USER set STATUS_=#{status},UPDATE_TIME_ = #{updateTime,jdbcType=TIMESTAMP} where IS_DELE_!='1' AND ACCOUNT_ in #{account} DELETE FROM uc_user WHERE IS_DELE_='1' select from uc_user where EMAIL_=#{email} AND IS_DELE_!='1' select from uc_user u WHERE u.ID_ in (select ud.USER_ID_ from uc_user_under ud WHERE ud.UNDER_USER_ID_ = #{underUserId} AND ud.IS_DELE_!='1') AND u.IS_DELE_!='1' select from uc_user u WHERE u.ID_ in (select ud.USER_ID_ from uc_user_under ud WHERE ud.UNDER_USER_ID_ = #{underUserId,jdbcType=VARCHAR} and ud.ORG_ID_=#{orgId,jdbcType=VARCHAR} AND ud.IS_DELE_!='1') AND u.IS_DELE_!='1' select from uc_user u WHERE u.ID_ in(select ud.UNDER_USER_ID_ from uc_user_under ud WHERE ud.USER_ID_ = #{upUserId} AND ud.IS_DELE_!='1') AND u.IS_DELE_!='1' select from uc_user u WHERE u.ID_ in (select ud.UNDER_USER_ID_ from uc_user_under ud WHERE ud.USER_ID_ = #{upUserId,jdbcType=VARCHAR} and ud.ORG_ID_=#{orgId,jdbcType=VARCHAR} AND ud.IS_DELE_!='1') AND u.IS_DELE_!='1' select DISTINCT u.* from UC_USER u inner join uc_org_user orguser on u.ID_ = orguser.USER_ID_ where orguser.IS_REL_ACTIVE_ = 1 AND u.IS_DELE_!='1' AND orguser.IS_DELE_!='1' AND u.STATUS_ =1 and orguser.ORG_ID_ = #{orgId} and orguser.IS_MASTER_ =#{isMain} select from uc_user where ID_ in ( select DISTINCT USER_ID_ from uc_org_user where POS_ID_ in( select a.ID_ from uc_org_post a left join uc_org_job b on a.JOB_ID_= b.ID_ LEFT JOIN uc_org c on a.ORG_ID_ = c.ID_ where c.CODE_=#{orgCode,jdbcType=VARCHAR} and b.CODE_=#{jobCode,jdbcType=VARCHAR} AND c.IS_DELE_!='1' AND b.IS_DELE_!='1' AND a.IS_DELE_!='1' ) AND IS_DELE_!='1') AND IS_DELE_!='1' AND STATUS_ =1 select a.* from uc_user a LEFT JOIN uc_org_user b on a.ID_=b.USER_ID_ LEFT JOIN uc_org_post c on b.POS_ID_=c.ID_ where c.CODE_=#{postCode} and a.IS_DELE_!='1' and b.IS_DELE_!='1' and c.IS_DELE_!='1' AND a.STATUS_ =1 select a.* from uc_user a LEFT JOIN uc_org_user b on a.ID_=b.USER_ID_ LEFT JOIN uc_org_post c on b.POS_ID_=c.ID_ where c.CODE_ in #{item} and a.IS_DELE_!='1' and b.IS_DELE_!='1' and c.IS_DELE_!='1' AND a.STATUS_ =1 SELECT DISTINCT u.* FROM uc_user u LEFT JOIN uc_org_user uco ON u.ID_= uco.USER_ID_ LEFT JOIN uc_org_user ucp ON u.ID_= ucp.USER_ID_ LEFT JOIN uc_user_role ur ON u.ID_= ur.USER_ID_ WHERE u.IS_DELE_!='1' AND u.STATUS_ =1 AND ( u.ID_ in #{item} OR ( uco.ORG_ID_ in #{item} and uco.IS_DELE_!='1' ) OR( ur.ROLE_ID_ in #{item} and ur.IS_DELE_!='1' ) OR ( ucp.POS_ID_ in #{item} and ucp.IS_DELE_!='1' ) ) and ${whereSql} ORDER BY ${orderBySql} ORDER BY u.ID_ DESC SELECT * from( SELECT FROM uc_user ${ew.customSqlSegment} ) tmp where 1=1 ${ew.paramNameValuePairs.dimSql} SELECT count(1) FROM uc_user WHERE ACCOUNT_=#{account} AND IS_DELE_!='1' SELECT count(1) FROM uc_user WHERE USER_NUMBER_=#{userNumber,jdbcType=VARCHAR} AND IS_DELE_!='1' AND ACCOUNT_!=#{account} SELECT DISTINCT u.* FROM uc_user u inner JOIN (select DISTINCT ORG_ID_,USER_ID_ from UC_ORG_USER WHERE IS_DELE_!='1') orguser on u.ID_=orguser.USER_ID_ AND u.STATUS_ =1 inner join UC_ORG org on org.ID_=orguser.ORG_ID_ inner join UC_DEMENSION d on d.ID_ = org.DEM_ID_ ${ew.paramNameValuePairs.customSqlSegment} WHERE AND org.IS_DELE_!='1' AND u.IS_DELE_!='1' AND u.STATUS_ =1 AND org.ID_ in #{item} AND org.CODE_ = #{ew.paramNameValuePairs.orgCode} AND d.CODE_ = #{ew.paramNameValuePairs.demCode} AND org.DEM_ID_ = #{ew.paramNameValuePairs.dem_id_} AND org.ID_ in #{item} AND d.CODE_ = #{ew.paramNameValuePairs.dem_code_} SELECT DISTINCT u.* FROM uc_user u inner JOIN (select DISTINCT ORG_ID_,USER_ID_ from UC_ORG_USER WHERE IS_DELE_!='1') orguser on u.ID_=orguser.USER_ID_ AND u.STATUS_ =1 inner join UC_ORG org on org.ID_=orguser.ORG_ID_ inner join UC_DEMENSION d on d.ID_ = org.DEM_ID_ ${ew.paramNameValuePairs.customSqlSegment} WHERE AND org.IS_DELE_!='1' AND u.IS_DELE_!='1' AND u.STATUS_ =1 AND org.DEM_ID_ = #{ew.paramNameValuePairs.demId} AND org.ID_ = #{ew.paramNameValuePairs.orgId} AND org.CODE_ = #{ew.paramNameValuePairs.orgCode} AND d.CODE_ = #{ew.paramNameValuePairs.demCode} AND org.DEM_ID_ = #{ew.paramNameValuePairs.dem_id_} AND org.ID_ = #{ew.paramNameValuePairs.org_id_} AND d.CODE_ = #{ew.paramNameValuePairs.dem_code_} SELECT FROM uc_user WHERE ACCOUNT_=#{account} AND IS_DELE_='1' SELECT FROM uc_user WHERE ACCOUNT_=#{account} SELECT ACCOUNT_ FROM uc_user WHERE IS_DELE_='1' SELECT DISTINCT ucuser.ID_,ucuser.FULLNAME_,ucuser.ACCOUNT_,ucuser.EMAIL_,ucuser.MOBILE_,ucuser.CREATE_TIME_,ucuser.ADDRESS_,ucuser.PHOTO_,ucuser.SEX_,ucuser.FROM_,ucuser.STATUS_,ucuser.HAS_SYNC_TO_WX_, ucuser.NOTIFY_TYPE_,ucuser.USER_NUMBER_,ucuser.ID_CARD_,ucuser.PHONE_,ucuser.WEIXIN_, ucuser.BIRTHDAY_,ucuser.ENTRY_DATE_,ucuser.EDUCATION_,ucuser.UPDATE_TIME_,ucuser.IS_DELE_,ucuser.VERSION_ ,ucuserrole.role_id_ ,orguser.org_id_ ,orguser.pos_id_ ,org.dem_id_ ,org.path_ FROM uc_user ucuser LEFT JOIN uc_user_role ucuserrole on ucuserrole.user_id_ = ucuser.ID_ and ucuserrole.IS_DELE_!='1' LEFT JOIN uc_org_user orguser on ucuser.ID_=orguser.USER_ID_ and orguser.IS_DELE_!='1' LEFT JOIN uc_org_user orguser on ucuser.ID_=orguser.USER_ID_ and orguser.IS_DELE_!='1' LEFT JOIN uc_org org on org.ID_= orguser.org_id_ ${ew.customSqlSegment} SELECT u.* FROM uc_user u LEFT JOIN uc_user_under under on u.ID_=under.USER_ID_ and under.IS_DELE_!='1' left JOIN uc_org org on under.ORG_ID_=org.ID_ and org.IS_DELE_!='1' LEFT JOIN uc_demension dem on org.DEM_ID_ = dem.ID_ and dem.IS_DELE_!='1' where u.IS_DELE_!='1' and under.UNDER_USER_ID_=#{userId} AND ( org.DEM_ID_ = #{demId} or dem.code_ = #{demId} ) AND ( org.ID_ = #{orgId} or org.code_ = #{orgId}) AND ${whereSql} SELECT u.* FROM uc_user u left join uc_user_under under on u.ID_=under.user_id_ and under.is_dele_!='1' where u.is_dele_!='1' and under.under_user_id_=#{userId} and (under.dimen_id_ = #{demId}) SELECT ucuser.FULLNAME_ as fullName, ucorg.NAME_ as orgName FROM uc_user AS ucuser LEFT JOIN uc_org_user AS ucorguser ON ucuser.ID_ = ucorguser.USER_ID_ AND ucorguser.IS_DELE_ = '1' AND ucorguser.IS_MASTER_ = '1' LEFT JOIN uc_org AS ucorg ON ucorg.ID_ = ucorguser.ORG_ID_ WHERE ucuser.ID_ = #{userId} SELECT * FROM uc_user t WHERE t.FULLNAME_ like #{query} OR t.EMAIL_ like #{query} select u.* from uc_user u left join uc_shift_user su on su.user_id_ = u.id_ ${ew.customSqlSegment} select u.id_ userId,u.FULLNAME_,u.ACCOUNT_,u.EMAIL_,u.MOBILE_,u.SEX_, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where (u.mobile_ is not null and u.mobile_ != '' ) and (uu.WX_WORK_ID_ is null or uu.WX_WORK_ID_ = '') select u.id_ userId,u.FULLNAME_,u.ACCOUNT_,u.EMAIL_,u.MOBILE_,u.SEX_, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where u.mobile_ is not null and uu.WX_WORK_ID_ is null select u.id_ userId,u.FULLNAME_,u.ACCOUNT_,u.EMAIL_,u.MOBILE_,u.SEX_, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where (u.mobile_ is not null and u.mobile_ != '' ) and (uu.DINGTALK_ID_ is null or uu.DINGTALK_ID_ = '') select u.id_ userId,u.FULLNAME_,u.ACCOUNT_,u.EMAIL_,u.MOBILE_,u.SEX_, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where u.mobile_ is not null and uu.DINGTALK_ID_ is null select u.*, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where uu.WX_WORK_ID_ = #{wxWorkId} select u.*, uu.OPEN_ID_,uu.WX_WORK_ID_,uu.DINGTALK_ID_ from uc_user u left join uc_user_unite uu on u.id_ = uu.user_id_ where uu.DINGTALK_ID_ = #{dingtalkId} SELECT DISTINCT u.* FROM uc_user u LEFT JOIN uc_org_user ou on u.ID_=ou.user_id_ AND u.is_dele_!='1' LEFT JOIN uc_org o on o.id_=ou.org_id_ AND o.is_dele_!='1' LEFT JOIN uc_user_role ur on u.id_=ur.user_id_ LEFT JOIN uc_role r on r.id_=ur.role_id_ AND r.is_dele_!='1' where o.code_=#{orgCode} and r.code_=#{roleCode} SELECT FROM uc_user WHERE ACCOUNT_ IN #{account} AND IS_DELE_ != '1' INSERT INTO uc_user ( ID_,FULLNAME_,ACCOUNT_,PASSWORD_,EMAIL_,MOBILE_,CREATE_TIME_,ADDRESS_,PHOTO_,SEX_,FROM_,STATUS_,HAS_SYNC_TO_WX_, NOTIFY_TYPE_,USER_NUMBER_,ID_CARD_,PHONE_, BIRTHDAY_,ENTRY_DATE_,LEAVE_DATE_,EDUCATION_,UPDATE_TIME_,IS_DELE_,VERSION_,WEIXIN_,PWD_CREATE_TIME_,create_by_, create_org_id_,update_by_,CLIENT_ID_,CLIENT_TOKEN_ ) VALUES (#{item.id,jdbcType=VARCHAR}, #{item.fullname,jdbcType=VARCHAR}, #{item.account,jdbcType=VARCHAR}, #{item.password,jdbcType=VARCHAR}, #{item.email,jdbcType=VARCHAR}, #{item.mobile,jdbcType=VARCHAR}, #{item.createTime,jdbcType=TIMESTAMP}, #{item.address,jdbcType=VARCHAR}, #{item.photo,jdbcType=VARCHAR}, #{item.sex,jdbcType=VARCHAR}, #{item.from,jdbcType=VARCHAR}, #{item.status,jdbcType=NUMERIC}, #{item.hasSyncToWx,jdbcType=NUMERIC}, #{item.notifyType,jdbcType=VARCHAR},#{item.userNumber,jdbcType=VARCHAR},#{item.idCard,jdbcType=VARCHAR}, #{item.phone,jdbcType=VARCHAR},#{item.birthday,jdbcType=TIMESTAMP},#{item.entryDate,jdbcType=TIMESTAMP},#{item.leaveDate,jdbcType=TIMESTAMP}, #{item.education,jdbcType=VARCHAR},#{item.updateTime,jdbcType=TIMESTAMP},#{item.isDelete,jdbcType=VARCHAR},#{item.version,jdbcType=NUMERIC},#{item.weixin,jdbcType=VARCHAR}, #{item.pwdCreateTime,jdbcType=TIMESTAMP},#{item.createBy,jdbcType=VARCHAR},#{item.createOrgId,jdbcType=VARCHAR},#{item.updateBy,jdbcType=VARCHAR},#{item.clientId,jdbcType=VARCHAR},#{item.clientToken,jdbcType=VARCHAR}) INSERT INTO uc_user ( ID_,FULLNAME_,ACCOUNT_,PASSWORD_,EMAIL_,MOBILE_,CREATE_TIME_,ADDRESS_,PHOTO_,SEX_,FROM_,STATUS_,HAS_SYNC_TO_WX_, NOTIFY_TYPE_,USER_NUMBER_,ID_CARD_,PHONE_, BIRTHDAY_,ENTRY_DATE_,LEAVE_DATE_,EDUCATION_,UPDATE_TIME_,IS_DELE_,VERSION_,WEIXIN_,PWD_CREATE_TIME_,create_by_, create_org_id_,update_by_,CLIENT_ID_,CLIENT_TOKEN_ ) ( select #{item.id,jdbcType=VARCHAR}, #{item.fullname,jdbcType=VARCHAR}, #{item.account,jdbcType=VARCHAR}, #{item.password,jdbcType=VARCHAR}, #{item.email,jdbcType=VARCHAR}, #{item.mobile,jdbcType=VARCHAR}, #{item.createTime,jdbcType=TIMESTAMP}, #{item.address,jdbcType=VARCHAR}, #{item.photo,jdbcType=VARCHAR}, #{item.sex,jdbcType=VARCHAR}, #{item.from,jdbcType=VARCHAR}, #{item.status,jdbcType=NUMERIC}, #{item.hasSyncToWx,jdbcType=NUMERIC}, #{item.notifyType,jdbcType=VARCHAR},#{item.userNumber,jdbcType=VARCHAR},#{item.idCard,jdbcType=VARCHAR}, #{item.phone,jdbcType=VARCHAR},#{item.birthday,jdbcType=TIMESTAMP},#{item.entryDate,jdbcType=TIMESTAMP},#{item.leaveDate,jdbcType=TIMESTAMP}, #{item.education,jdbcType=VARCHAR},#{item.updateTime,jdbcType=TIMESTAMP},#{item.isDelete,jdbcType=VARCHAR},#{item.version,jdbcType=NUMERIC},#{item.weixin,jdbcType=VARCHAR}, #{item.pwdCreateTime,jdbcType=TIMESTAMP},#{item.createBy,jdbcType=VARCHAR},#{item.createOrgId,jdbcType=VARCHAR},#{item.updateBy,jdbcType=VARCHAR},#{item.clientId,jdbcType=VARCHAR},#{item.clientToken,jdbcType=VARCHAR} FROM DUAL ) UPDATE uc_user FULLNAME_=#{item.fullname,jdbcType=VARCHAR}, EMAIL_=#{item.email,jdbcType=VARCHAR}, MOBILE_=#{item.mobile,jdbcType=VARCHAR}, ADDRESS_=#{item.address,jdbcType=VARCHAR}, PHOTO_=#{item.photo,jdbcType=VARCHAR}, SEX_=#{item.sex,jdbcType=VARCHAR}, STATUS_=#{item.status,jdbcType=NUMERIC}, HAS_SYNC_TO_WX_=#{item.hasSyncToWx,jdbcType=NUMERIC}, WEIXIN_=#{item.weixin,jdbcType=VARCHAR}, NOTIFY_TYPE_=#{item.notifyType,jdbcType=VARCHAR}, USER_NUMBER_=#{item.userNumber,jdbcType=VARCHAR}, ID_CARD_=#{item.idCard,jdbcType=VARCHAR}, PHONE_=#{item.phone,jdbcType=VARCHAR}, BIRTHDAY_=#{item.birthday,jdbcType=TIMESTAMP}, ENTRY_DATE_=#{item.entryDate,jdbcType=TIMESTAMP}, LEAVE_DATE_=#{item.leaveDate,jdbcType=TIMESTAMP}, EDUCATION_=#{item.education,jdbcType=VARCHAR}, UPDATE_TIME_ = #{item.updateTime,jdbcType=TIMESTAMP}, VERSION_ = #{item.version,jdbcType=NUMERIC} WHERE ID_=#{item.id} SELECT * from UC_USER WHERE ID_ in ( SELECT USER_ID_ from UC_ORG_USER WHERE ORG_ID_ in ( SELECT ID_ from UC_ORG WHERE instr(PATH_,(SELECT ID_ from UC_ORG WHERE CODE_=#{orgCode}))>0 ) AND UC_ORG_USER.IS_DELE_ = '0' )