"""增量数据获取服务"""

  
  import pandas as pd

  import logging

  import time

  import threading
  from typing import Dict, Any, Optional, List, Tuple
  from sqlalchemy import text, bindparam

  from indexer.indexing_utils import load_category_mapping, create_document_transformer

  from indexer.bulk_indexer import BulkIndexer
  from indexer.mapping_generator import DEFAULT_INDEX_NAME
  from indexer.indexer_logger import (
      get_indexer_logger, log_index_request, log_index_result, log_spu_processing
  )

  from config import ConfigLoader

  
  # Configure logger
  logger = logging.getLogger(__name__)

  # Indexer专用日志器
  indexer_logger = get_indexer_logger()

  
  
  class IncrementalIndexerService:

      """增量索引服务，提供SPU数据获取功能。"""

  
      def __init__(self, db_engine: Any):

          """初始化增量索引服务"""

          self.db_engine = db_engine
          
          # 预加载分类映射（全局，所有租户共享）

          self.category_id_to_name = load_category_mapping(db_engine)

          logger.info(f"Preloaded {len(self.category_id_to_name)} category mappings")

          # 缓存：避免频繁增量请求重复加载config / 构造transformer
          self._config: Optional[Any] = None
          self._config_lock = threading.Lock()
          # tenant_id -> (transformer, encoder, enable_embedding)
          self._transformer_cache: Dict[str, Tuple[Any, Optional[Any], bool]] = {}
          self._transformer_cache_lock = threading.Lock()
  
      def _get_config(self) -> Any:
          """Load config once per process (thread-safe)."""
          if self._config is not None:
              return self._config
          with self._config_lock:
              if self._config is None:
                  self._config = ConfigLoader().load_config()
          return self._config
  
      def _get_transformer_bundle(self, tenant_id: str) -> Tuple[Any, Optional[Any], bool]:
          """
          Get a cached document transformer for tenant_id.
  
          - Transformer is built once per tenant (in-process cache).
          - We disable per-document embedding generation inside transformer, and instead
            batch-generate embeddings in index_spus_to_es for performance.
          """
          with self._transformer_cache_lock:
              cached = self._transformer_cache.get(str(tenant_id))
              if cached is not None:
                  return cached
  
          config = self._get_config()
          enable_embedding = bool(getattr(config.query_config, "enable_text_embedding", False))
  
          encoder: Optional[Any] = None
          if enable_embedding:
              try:
                  from embeddings.text_encoder import BgeEncoder
                  encoder = BgeEncoder()
              except Exception as e:
                  logger.warning(f"Failed to initialize BgeEncoder for tenant_id={tenant_id}: {e}")
                  encoder = None
                  enable_embedding = False
  
          transformer = create_document_transformer(
              category_id_to_name=self.category_id_to_name,
              tenant_id=tenant_id,
              encoder=encoder,
              enable_title_embedding=False,  # batch fill later
              config=config,
          )
  
          bundle = (transformer, encoder, enable_embedding)
          with self._transformer_cache_lock:
              # simple unbounded cache; tenant count is typically small in one node
              self._transformer_cache[str(tenant_id)] = bundle
          return bundle
  
      @staticmethod
      def _normalize_spu_ids(spu_ids: List[str]) -> List[int]:
          """Normalize SPU IDs to ints for DB queries; skip non-int IDs."""
          out: List[int] = []
          for x in spu_ids:
              try:
                  out.append(int(x))
              except Exception:
                  continue
          return out
  

      def get_spu_document(self, tenant_id: str, spu_id: str) -> Optional[Dict[str, Any]]:

          """获取SPU的ES文档数据"""

          try:
              # 加载SPU数据
              spu_row = self._load_single_spu(tenant_id, spu_id)
              if spu_row is None:
                  logger.warning(f"SPU {spu_id} not found for tenant_id={tenant_id}")
                  return None
  
              # 加载SKU数据
              skus_df = self._load_skus_for_spu(tenant_id, spu_id)
  
              # 加载Option数据
              options_df = self._load_options_for_spu(tenant_id, spu_id)
  

              transformer, encoder, enable_embedding = self._get_transformer_bundle(tenant_id)

              
              # 转换为ES文档
              doc = transformer.transform_spu_to_doc(
                  tenant_id=tenant_id,
                  spu_row=spu_row,
                  skus=skus_df,
                  options=options_df
              )
              
              if doc is None:
                  logger.warning(f"Failed to transform SPU {spu_id} for tenant_id={tenant_id}")
                  return None
  

              # 单条场景下也可补齐 embedding（仍走缓存）
              if enable_embedding and encoder:
                  title_text = doc.get("title_en") or doc.get("title_zh")
                  if title_text and str(title_text).strip():
                      try:
                          embeddings = encoder.encode(title_text)
                          if embeddings is not None and len(embeddings) > 0:
                              doc["title_embedding"] = embeddings[0].tolist()
                      except Exception as e:
                          logger.warning(f"Failed to generate embedding for spu_id={spu_id}: {e}")
  

              return doc
  
          except Exception as e:
              logger.error(f"Error getting SPU document for tenant_id={tenant_id}, spu_id={spu_id}: {e}", exc_info=True)
              raise
  

      def _load_single_spu(self, tenant_id: str, spu_id: str, include_deleted: bool = False) -> Optional[pd.Series]:
          """
          加载单个SPU数据
          
          Args:
              tenant_id: 租户ID
              spu_id: SPU ID
              include_deleted: 是否包含已删除的记录（用于检查删除状态）
          
          Returns:
              SPU数据Series，如果不存在返回None
          """
          if include_deleted:
              # 查询所有记录（包括已删除的），用于检查删除状态
              query = text("""
                  SELECT 
                      id, shop_id, shoplazza_id, title, brief, description,
                      spu, vendor, vendor_url,
                      image_src, image_width, image_height, image_path, image_alt,
                      tags, note, category, category_id, category_google_id,
                      category_level, category_path,
                      fake_sales, display_fake_sales,
                      tenant_id, creator, create_time, updater, update_time, deleted
                  FROM shoplazza_product_spu
                  WHERE tenant_id = :tenant_id AND id = :spu_id
                  LIMIT 1
              """)
          else:
              # 只查询未删除的记录
              query = text("""
                  SELECT 
                      id, shop_id, shoplazza_id, title, brief, description,
                      spu, vendor, vendor_url,
                      image_src, image_width, image_height, image_path, image_alt,
                      tags, note, category, category_id, category_google_id,
                      category_level, category_path,
                      fake_sales, display_fake_sales,
                      tenant_id, creator, create_time, updater, update_time, deleted
                  FROM shoplazza_product_spu
                  WHERE tenant_id = :tenant_id AND id = :spu_id AND deleted = 0
                  LIMIT 1
              """)

          
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_id": spu_id})
          
          if df.empty:
              return None
          
          return df.iloc[0]

      
      def check_spu_deleted(self, tenant_id: str, spu_id: str) -> bool:
          """
          检查SPU是否在数据库中被标记为删除
          
          Args:
              tenant_id: 租户ID
              spu_id: SPU ID
          
          Returns:
              True表示已删除，False表示未删除或不存在
          """
          spu_row = self._load_single_spu(tenant_id, spu_id, include_deleted=True)
          if spu_row is None:
              # SPU不存在，视为需要删除
              return True
          # 检查deleted字段（可能是bit类型，需要转换为int或bool）
          deleted = spu_row.get('deleted', 0)
          # 处理bit类型：可能是b'\x00'或b'\x01'，或者直接是0/1
          if isinstance(deleted, bytes):
              return deleted == b'\x01' or deleted == 1
          return bool(deleted)

  
      def _load_spus_for_spu_ids(self, tenant_id: str, spu_ids: List[str], include_deleted: bool = True) -> pd.DataFrame:
          """Batch load SPU rows for a list of spu_ids using IN (...)"""
          spu_ids_int = self._normalize_spu_ids(spu_ids)
          if not spu_ids_int:
              return pd.DataFrame()
  
          if include_deleted:
              query = text(
                  """
                  SELECT 
                      id, shop_id, shoplazza_id, title, brief, description,
                      spu, vendor, vendor_url,
                      image_src, image_width, image_height, image_path, image_alt,
                      tags, note, category, category_id, category_google_id,
                      category_level, category_path,
                      fake_sales, display_fake_sales,
                      tenant_id, creator, create_time, updater, update_time, deleted
                  FROM shoplazza_product_spu
                  WHERE tenant_id = :tenant_id AND id IN :spu_ids
                  """
              ).bindparams(bindparam("spu_ids", expanding=True))
          else:
              query = text(
                  """
                  SELECT 
                      id, shop_id, shoplazza_id, title, brief, description,
                      spu, vendor, vendor_url,
                      image_src, image_width, image_height, image_path, image_alt,
                      tags, note, category, category_id, category_google_id,
                      category_level, category_path,
                      fake_sales, display_fake_sales,
                      tenant_id, creator, create_time, updater, update_time, deleted
                  FROM shoplazza_product_spu
                  WHERE tenant_id = :tenant_id AND deleted = 0 AND id IN :spu_ids
                  """
              ).bindparams(bindparam("spu_ids", expanding=True))
  
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_ids": spu_ids_int})
          return df
  
      def _load_skus_for_spu_ids(self, tenant_id: str, spu_ids: List[str]) -> pd.DataFrame:
          """Batch load all SKUs for a list of spu_ids"""
          spu_ids_int = self._normalize_spu_ids(spu_ids)
          if not spu_ids_int:
              return pd.DataFrame()
  
          query = text(
              """
              SELECT 
                  id, spu_id, shop_id, shoplazza_id, shoplazza_product_id,
                  shoplazza_image_id, title, sku, barcode, position,
                  price, compare_at_price, cost_price,
                  option1, option2, option3,
                  inventory_quantity, weight, weight_unit, image_src,
                  wholesale_price, note, extend,
                  shoplazza_created_at, shoplazza_updated_at, tenant_id,
                  creator, create_time, updater, update_time, deleted
              FROM shoplazza_product_sku
              WHERE tenant_id = :tenant_id AND deleted = 0 AND spu_id IN :spu_ids
              """
          ).bindparams(bindparam("spu_ids", expanding=True))
  
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_ids": spu_ids_int})
          return df
  
      def _load_options_for_spu_ids(self, tenant_id: str, spu_ids: List[str]) -> pd.DataFrame:
          """Batch load all options for a list of spu_ids"""
          spu_ids_int = self._normalize_spu_ids(spu_ids)
          if not spu_ids_int:
              return pd.DataFrame()
  
          query = text(
              """
              SELECT 
                  id, spu_id, shop_id, shoplazza_id, shoplazza_product_id,
                  position, name, `values`, tenant_id,
                  creator, create_time, updater, update_time, deleted
              FROM shoplazza_product_option
              WHERE tenant_id = :tenant_id AND deleted = 0 AND spu_id IN :spu_ids
              ORDER BY spu_id, position
              """
          ).bindparams(bindparam("spu_ids", expanding=True))
  
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_ids": spu_ids_int})
          return df

      def _delete_spu_from_es(

          self,
          es_client,
          tenant_id: str,

          spu_id: str,
          index_name: str,
          log_prefix: str = ""

      ) -> Dict[str, Any]:
          """

          从ES中删除单个SPU文档（通用方法）

          
          Returns:

              {"status": "deleted|not_found|failed", "msg": "错误信息（可选）"}

          """

          try:
              response = es_client.client.delete(
                  index=index_name,
                  id=str(spu_id),
                  ignore=[404]
              )
              
              result = response.get('result')
              if result == 'deleted':
                  log_spu_processing(indexer_logger, tenant_id, spu_id, 'deleted', log_prefix)
                  return {"status": "deleted"}
              elif result == 'not_found':
                  return {"status": "not_found"}
              else:
                  msg = f"Unexpected result: {result}"
                  log_spu_processing(indexer_logger, tenant_id, spu_id, 'delete_failed', msg)
                  return {"status": "failed", "msg": msg}
                  
          except Exception as e:
              if hasattr(e, 'status_code') and e.status_code == 404:
                  return {"status": "not_found"}
              else:
                  msg = str(e)
                  logger.error(f"[IncrementalDeletion] Error deleting SPU {spu_id}: {e}", exc_info=True)
                  log_spu_processing(indexer_logger, tenant_id, spu_id, 'delete_failed', msg)
                  return {"status": "failed", "msg": msg}

  
      def _load_skus_for_spu(self, tenant_id: str, spu_id: str) -> pd.DataFrame:

          """加载指定SPU的所有SKU数据"""

          query = text("""
              SELECT 
                  id, spu_id, shop_id, shoplazza_id, shoplazza_product_id,
                  shoplazza_image_id, title, sku, barcode, position,
                  price, compare_at_price, cost_price,
                  option1, option2, option3,
                  inventory_quantity, weight, weight_unit, image_src,
                  wholesale_price, note, extend,
                  shoplazza_created_at, shoplazza_updated_at, tenant_id,
                  creator, create_time, updater, update_time, deleted
              FROM shoplazza_product_sku
              WHERE tenant_id = :tenant_id AND spu_id = :spu_id AND deleted = 0
          """)
          
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_id": spu_id})
          
          return df
  
      def _load_options_for_spu(self, tenant_id: str, spu_id: str) -> pd.DataFrame:

          """加载指定SPU的所有Option数据"""

          query = text("""
              SELECT 
                  id, spu_id, shop_id, shoplazza_id, shoplazza_product_id,
                  position, name, `values`, tenant_id,
                  creator, create_time, updater, update_time, deleted
              FROM shoplazza_product_option
              WHERE tenant_id = :tenant_id AND spu_id = :spu_id AND deleted = 0
              ORDER BY position
          """)
          
          with self.db_engine.connect() as conn:
              df = pd.read_sql(query, conn, params={"tenant_id": tenant_id, "spu_id": spu_id})
          
          return df
  

      def index_spus_to_es(
          self,
          es_client,
          tenant_id: str,
          spu_ids: List[str],
          index_name: str = DEFAULT_INDEX_NAME,

          batch_size: int = 100,
          delete_spu_ids: List[str] = None

      ) -> Dict[str, Any]:
          """
          批量索引SPU到ES（增量索引）
          

          支持两种删除方式：
          1. 自动检测删除：根据数据库deleted字段自动检测并删除ES中的文档
          2. 显式删除：通过delete_spu_ids参数显式指定要删除的SPU
          

          Args:
              es_client: Elasticsearch客户端
              tenant_id: 租户ID

              spu_ids: SPU ID列表（要索引的）

              index_name: 索引名称
              batch_size: 批量写入ES的批次大小

              delete_spu_ids: 显式指定要删除的SPU ID列表（可选）

              
          Returns:

              包含成功/失败列表的字典，以及删除结果

          """

          # 去重但保持顺序（避免重复DB/翻译/embedding/写ES）
          if spu_ids:
              spu_ids = list(dict.fromkeys(spu_ids))
  

          start_time = time.time()
          total_count = len(spu_ids)

          delete_count = len(delete_spu_ids) if delete_spu_ids else 0
          
          # spu_ids 对应的响应列表（状态：indexed, deleted, failed）
          spu_results = []
          # delete_spu_ids 对应的响应列表（状态：deleted, not_found, failed）
          delete_results = []
          

          documents = []

          
          # 记录请求开始
          log_index_request(
              indexer_logger,
              index_type='incremental',
              tenant_id=tenant_id,
              request_params={
                  'spu_count': total_count,

                  'delete_count': delete_count,

                  'index_name': index_name,
                  'batch_size': batch_size
              }
          )
          

          logger.info(
              f"[IncrementalIndexing] Starting bulk index for tenant_id={tenant_id}, "

              f"spu_count={total_count}, delete_count={delete_count}"

          )

          # 步骤0: 处理显式删除请求（delete_spu_ids）

          if delete_spu_ids:
              logger.info(f"[IncrementalIndexing] Processing explicit deletions: {len(delete_spu_ids)} SPUs")

              for spu_id in delete_spu_ids:
                  result = self._delete_spu_from_es(es_client, tenant_id, spu_id, index_name, "explicit")
                  delete_results.append({"spu_id": spu_id, **result})

          # 步骤1: 批量获取SPU/SKU/Option数据，并自动检测删除
          if spu_ids:
              log_spu_processing(indexer_logger, tenant_id, ",".join(spu_ids[:10]), 'fetching')
  
              # 批量加载SPU（包含deleted字段，用于判断删除）
              spu_df = self._load_spus_for_spu_ids(tenant_id, spu_ids, include_deleted=True)
              if spu_df.empty:
                  # 所有SPU都不存在，按“需要删除”处理
                  for spu_id in spu_ids:
                      logger.info(f"[IncrementalIndexing] SPU {spu_id} not found in DB, removing from ES")
                      result = self._delete_spu_from_es(es_client, tenant_id, spu_id, index_name, "auto_missing")

                      status = "deleted" if result["status"] != "failed" else "failed"
                      spu_results.append({
                          "spu_id": spu_id,
                          "status": status,
                          **({"msg": result["msg"]} if status == "failed" else {})
                      })

              else:
                  # 建立索引：id -> row
                  spu_df = spu_df.copy()
                  # Normalize deleted column to bool
                  def _is_deleted_value(v: Any) -> bool:
                      if isinstance(v, bytes):
                          return v == b"\x01" or v == 1
                      return bool(v)
  
                  spu_df["_is_deleted"] = spu_df["deleted"].apply(_is_deleted_value)
                  spu_df.set_index("id", inplace=True, drop=False)
  
                  found_ids = set(int(x) for x in spu_df.index.tolist())
                  requested_ids_int = set(self._normalize_spu_ids(spu_ids))
                  missing_ids_int = requested_ids_int - found_ids
  
                  # missing -> delete from ES
                  for missing_id in sorted(missing_ids_int):
                      spu_id_str = str(missing_id)
                      logger.info(f"[IncrementalIndexing] SPU {spu_id_str} not found in DB, removing from ES")
                      result = self._delete_spu_from_es(es_client, tenant_id, spu_id_str, index_name, "auto_missing")
                      status = "deleted" if result["status"] != "failed" else "failed"

                      spu_results.append({

                          "spu_id": spu_id_str,
                          "status": status,
                          **({"msg": result["msg"]} if status == "failed" else {})

                      })

  
                  # deleted -> delete from ES
                  deleted_rows = spu_df[spu_df["_is_deleted"]]
                  for _, row in deleted_rows.iterrows():
                      spu_id_str = str(int(row["id"]))
                      logger.info(f"[IncrementalIndexing] SPU {spu_id_str} is deleted in DB, removing from ES")
                      result = self._delete_spu_from_es(es_client, tenant_id, spu_id_str, index_name, "auto")
                      status = "deleted" if result["status"] != "failed" else "failed"
                      spu_results.append({
                          "spu_id": spu_id_str,
                          "status": status,
                          **({"msg": result["msg"]} if status == "failed" else {})
                      })
  
                  # active -> batch load sku/option then transform
                  active_spu_df = spu_df[~spu_df["_is_deleted"]]
                  active_ids_str = [str(int(x)) for x in active_spu_df["id"].tolist()]
  
                  skus_df = self._load_skus_for_spu_ids(tenant_id, active_ids_str)
                  options_df = self._load_options_for_spu_ids(tenant_id, active_ids_str)
                  sku_groups = skus_df.groupby("spu_id") if not skus_df.empty else None
                  option_groups = options_df.groupby("spu_id") if not options_df.empty else None
  
                  transformer, encoder, enable_embedding = self._get_transformer_bundle(tenant_id)
  
                  # 按输入顺序处理 active SPUs
                  for spu_id in spu_ids:
                      try:
                          spu_id_int = int(spu_id)
                      except Exception:
                          continue
                      if spu_id_int not in active_spu_df.index:
                          continue
  
                      log_spu_processing(indexer_logger, tenant_id, spu_id, 'transforming')
                      spu_row = active_spu_df.loc[spu_id_int]
                      skus_for_spu = sku_groups.get_group(spu_id_int) if sku_groups is not None and spu_id_int in sku_groups.groups else pd.DataFrame()
                      opts_for_spu = option_groups.get_group(spu_id_int) if option_groups is not None and spu_id_int in option_groups.groups else pd.DataFrame()
  
                      doc = transformer.transform_spu_to_doc(
                          tenant_id=tenant_id,
                          spu_row=spu_row,
                          skus=skus_for_spu,
                          options=opts_for_spu,
                      )
                      if doc is None:
                          error_msg = "SPU transform returned None"
                          log_spu_processing(indexer_logger, tenant_id, spu_id, 'failed', error_msg)
                          spu_results.append({"spu_id": spu_id, "status": "failed", "msg": error_msg})
                          continue
  
                      documents.append((spu_id, doc))
  
                  # 批量生成 embedding（保持翻译逻辑不变；embedding 走缓存）
                  if enable_embedding and encoder and documents:
                      title_texts: List[str] = []
                      title_doc_indices: List[int] = []
                      for i, (_, doc) in enumerate(documents):
                          title_text = doc.get("title_en") or doc.get("title_zh")
                          if title_text and str(title_text).strip():
                              title_texts.append(str(title_text))
                              title_doc_indices.append(i)
  
                      if title_texts:
                          try:
                              embeddings = encoder.encode_batch(title_texts, batch_size=32)
                              for j, emb in enumerate(embeddings):
                                  doc_idx = title_doc_indices[j]
                                  documents[doc_idx][1]["title_embedding"] = emb.tolist()
                          except Exception as e:
                              logger.warning(f"[IncrementalIndexing] Batch embedding failed for tenant_id={tenant_id}: {e}", exc_info=True)

          
          logger.info(f"[IncrementalIndexing] Transformed {len(documents)}/{total_count} documents")
          
          # 步骤2: 批量写入ES
          if documents:
              try:

                  # 提取doc列表用于批量写入
                  doc_list = [doc for _, doc in documents]
                  logger.info(f"[IncrementalIndexing] Indexing {len(doc_list)} documents to ES (batch_size={batch_size})")

                  indexer = BulkIndexer(es_client, index_name, batch_size=batch_size, max_retries=3)
                  bulk_results = indexer.index_documents(

                      doc_list,

                      id_field="spu_id",
                      show_progress=False
                  )
                  

                  # 根据ES返回的结果更新spu_results

                  es_success_count = bulk_results.get('success', 0)
                  es_failed_count = bulk_results.get('failed', 0)
                  

                  # 由于BulkIndexer返回的是总体统计，我们假设：

                  # - 如果ES返回成功数等于文档数，则所有文档都成功
                  # - 否则，失败的文档可能在ES错误信息中，但我们无法精确映射

                  # 这里采用简化处理：将成功写入ES的文档标记为indexed

                  if es_failed_count == 0:
                      # 全部成功

                      for spu_id, doc in documents:
                          spu_results.append({
                              "spu_id": spu_id,

                              "status": "indexed"
                          })
                  else:
                      # 有失败的情况，我们标记已处理的文档为成功，未处理的可能失败

                      logger.warning(f"[IncrementalIndexing] ES bulk index had {es_failed_count} failures")

                      for spu_id, doc in documents:

                          # 由于无法精确知道哪些失败，我们假设全部成功（实际应该改进）

                          spu_results.append({
                              "spu_id": spu_id,

                              "status": "indexed"
                          })
                      

                      # 如果有ES错误，记录日志

                      if bulk_results.get('errors'):
                          logger.error(f"[IncrementalIndexing] ES errors: {bulk_results['errors'][:5]}")
                  
              except Exception as e:
                  error_msg = f"ES bulk index failed: {str(e)}"
                  logger.error(f"[IncrementalIndexing] {error_msg}", exc_info=True)
                  # 所有文档都失败

                  for spu_id, doc in documents:
                      # 检查是否已经在spu_results中（可能之前已经标记为failed）
                      existing = next((r for r in spu_results if r.get('spu_id') == spu_id), None)
                      if existing:
                          # 如果已存在，更新状态
                          existing['status'] = 'failed'
                          existing['msg'] = error_msg
                      else:
                          spu_results.append({
                              "spu_id": spu_id,
                              "status": "failed",
                              "msg": error_msg
                          })

          else:
              logger.warning(f"[IncrementalIndexing] No documents to index for tenant_id={tenant_id}")
          
          elapsed_time = time.time() - start_time

          # 统计结果（简化）
          total_processed = total_count + delete_count
          total_success = len([r for r in spu_results + delete_results if r.get('status') in ('indexed', 'deleted', 'not_found')])
          total_failed = len([r for r in spu_results + delete_results if r.get('status') == 'failed'])
          
          # 记录最终结果
          deleted_count = len([r for r in spu_results + delete_results if r.get('status') == 'deleted'])

          log_index_result(
              indexer_logger,
              index_type='incremental',
              tenant_id=tenant_id,

              total_count=total_processed,
              success_count=total_success,
              failed_count=total_failed,

              elapsed_time=elapsed_time,
              index_name=index_name,

              errors=[r.get('msg') for r in spu_results + delete_results if r.get('status') == 'failed'][:10],
              deleted_count=deleted_count

          )
          

          logger.info(
              f"[IncrementalIndexing] Completed for tenant_id={tenant_id}: "

              f"total={total_processed}, success={total_success}, failed={total_failed}, "

              f"elapsed={elapsed_time:.2f}s"
          )
          
          return {

              "spu_ids": spu_results,  # spu_ids对应的响应列表
              "delete_spu_ids": delete_results,  # delete_spu_ids对应的响应列表
              "total": total_processed,
              "success_count": total_success,
              "failed_count": total_failed,

              "elapsed_time": elapsed_time,
              "index_name": index_name,
              "tenant_id": tenant_id
          }