other:patch sql

许鹏程

2025-01-21 7a4f77f7e13481a93533a7116accc6b590452be7

 product-server-data-sync/src/main/java/com/product/data/sync/service/FeDataDSService.java

@@ -532,6 +532,9 @@

      Map<String, FieldSetEntity> staffsMap = Maps.newHashMap();
      for (int i = 0; i < data.getRows(); i++) {
         if (i > 70) {
            System.out.println(1);
         }
         FieldSetEntity userFs = data.getFieldSetEntity(i);
         FieldSetEntity usersFs = new FieldSetEntity();
         //创建 user 数据
@@ -546,12 +549,12 @@
            //签名
            String su23 = userFs.getString("su23");
            if (!BaseUtil.strIsNull(su23)) {
               usersFs.setValue("user_signature", this.signatureAndThumbnail(su23, clientUUID, "user_signature"));
               fieldSetByFilter.setValue("user_signature", this.signatureAndThumbnail(su23, clientUUID, "user_signature"));
            }
            //头像
            String su28 = userFs.getString("su28");
            if (!BaseUtil.strIsNull(su28)) {
               usersFs.setValue("thumbnail_img", this.signatureAndThumbnail(su28, clientUUID, "thumbnail_img"));
               fieldSetByFilter.setValue("thumbnail_img", this.signatureAndThumbnail(su28, clientUUID, "thumbnail_img"));
            }
            baseDao.executeUpdate("update product_sys_staffs set staff_status=? where user_id=?", new Object[]{userFs.getString("su08"), fieldSetByFilter.getString("user_id")});
            baseDao.saveFieldSetEntity(fieldSetByFilter);