代码提交

杜洪波

2025-09-18 22d8b68b19e35bdd2086fd047296abe440639f32

 src/main/java/com/product/administration/service/CooperatesService.java

@@ -17,6 +17,8 @@
import com.product.core.websocket.service.WebsocketMesssageServiceThread;
import com.product.module.sys.service.UserService;
import com.product.util.BaseUtil;
import com.product.util.UnifySQLFunction;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import com.product.tool.flow.service.FlowCoordinationService;
@@ -79,11 +81,21 @@
      FieldSetEntity fse = baseDao.getFieldSetEntity(CmnConst.PRODUCT_OA_COOPERATES, fs.getString(CmnConst.UUID), true);
      DataTableEntity copsub = fse.getSubDataTable(CmnConst.PRODUCT_OA_COOPERATE_SUB);
      baseDao.loadPromptData(copsub);

      for (int i = 0; i <copsub.getRows() ; i++) {
         String userId = copsub.getString(i, "created_by_save_value");
         String userAvatar = userService.getUserAvatar(userId);
         if (!StringUtils.isEmpty(userAvatar)) {
               copsub.setFieldValue(i, "avatar", userAvatar);
         }
      }
      StringBuilder stringBuilder = new StringBuilder();
      stringBuilder.append(" select ifnull(concat(tricode,'-',receiver) ,receiver) code,uuid,title,cooperate_uuid,grade,receiver as id,receiver,sender, ");
      stringBuilder.append(" receiver_name,(select user_name FROM product_sys_users where user_id=receiver) label,sender_name,status, ");
      stringBuilder.append(" tricode,opinion,handle_time,type,attachments,is_hide_commentss from product_oa_cooperate_flow_node where cooperate_uuid=? ORDER BY tricode ");
      stringBuilder.append("\nSELECT ");
      stringBuilder.append("\n  uuid,title,cooperate_uuid,grade,receiver as id,receiver,sender,receiver_name,sender_name,status, ");
      stringBuilder.append("\n  tricode,opinion,handle_time,type,attachments,is_hide_commentss, ");
      stringBuilder.append("\n  (select user_name FROM product_sys_users where user_id=receiver) label,");
      stringBuilder.append("\n  ").append(UnifySQLFunction.ifnull("concat(tricode,'-',receiver)", "receiver")).append(" AS code");
      stringBuilder.append("\nFROM product_oa_cooperate_flow_node where cooperate_uuid=? ");
      stringBuilder.append("\nORDER BY tricode ");
      DataTableEntity dt = baseDao.listTable(stringBuilder.toString(), new Object[]{fs.getString("uuid")});
      JSONArray json = null;
      if (dt != null && dt.getRows() > 0) {