Confluence用户同步逻辑

<!-- 查询正常用户的username-->
<select id="getWiKiUserNameList" parameterType="org.muyuan.core.boot.vo.Dto" resultType="String">
  select distinct user_name from cwd_user where active = 'T'
  <if test=" workNo!= null and workNo != '' ">
      and user_name = #{workNo}
  </if>
</select>

<update id="updateWiKiUserLeaving" parameterType="org.muyuan.core.boot.vo.Dto">
  update cwd_user set active='F' where user_name = #{username}
</update>


<insert id="insertUser1" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `user_mapping` VALUES (#{MJobNo}, #{JobNo}, #{JobNo});
</insert>

<insert id="insertUser2" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `CONTENT` VALUES (#{JobNo}, 1, 'USERINFO', NULL, NULL, 1, 'ff8080817049c7ce017049c8d8bd0000', '2020-02-16 10:36:27', 'ff8080817049c7ce017049c8d8bd0000', '2020-02-16 10:36:27', '', NULL, 'current', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, #{MJobNo});
</insert>

<insert id="insertUser3" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `OS_PROPERTYENTRY` VALUES ('confluence_ContentEntityObject', #{JobNo}, 'confluence.user.profile.department', 5, b'0', 0, #{DeptName}, '', 0, 0, NULL);
</insert>

<insert id="insertUser4" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `OS_PROPERTYENTRY` VALUES ('confluence_ContentEntityObject', #{JobNo}, 'confluence.user.profile.phone', 5, b'0', 0, #{Tel}, '', 0, 0, NULL);
</insert>

<insert id="insertUser5" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `OS_PROPERTYENTRY` VALUES ('confluence_ContentEntityObject', #{JobNo}, 'confluence.user.profile.position', 5, b'0', 0, #{FPostname}, '', 0, 0, NULL);
</insert>

<insert id="insertUser6" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `cwd_user` VALUES (#{JobNo}, #{JobNo}, #{JobNo}, 'T', '2020-02-16 10:36:27', '2020-02-16 10:37:11', '', '', #{Name}, #{Name}, #{Name}, #{Name}, #{Email}, #{Email}, #{JobNo}, 98305, '{PKCS5S2}uEfR1LnJrgQWvzshW0TfUc4MyXkrpS/hxl+QnnmTzB22ML8l/2MgvlPW91L4DF+w');
</insert>

<insert id="insertUser7" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `cwd_membership` VALUES (#{JobNo}, 983041, NULL, #{JobNo});
</insert>

<insert id="insertUser8" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `cwd_user_attribute` VALUES (#{JobNoAattributeId1}, #{JobNo}, 98305, 'requiresPasswordChange', 'false', 'false');
</insert>

<insert id="insertUser9" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `cwd_user_attribute` VALUES (#{JobNoAattributeId2}, #{JobNo}, 98305, 'invalidPasswordAttempts', '0', '0');
</insert>

<insert id="insertUser10" parameterType="org.muyuan.core.boot.vo.Dto">
  INSERT INTO `cwd_user_attribute` VALUES (#{JobNoAattributeId3}, #{JobNo}, 98305, 'passwordLastChanged', '1581829259896', '1581829259896');
</insert>