Blame view

indexer/document_transformer.py 29 KB
0064e946   tangwang   feat: 增量索引服务、租户配置...
1
2
3
4
  """
  SPU文档转换器 - 公共转换逻辑。
  
  提取全量和增量索引共用的文档转换逻辑,避免代码冗余。
2e48a32d   tangwang   doc
5
6
7
  输出文档结构与 mappings/search_products.json  索引字段说明v2 一致,
   search/searcher  search/es_query_builder 使用。
  - 多语言字段:title, brief, description, vendor, category_path, category_name_text
e7a2c0b7   tangwang   img encode
8
  - 嵌套:specifications, skus;向量:title_embeddingimage_embedding(可选,需提供 image_encoder
0064e946   tangwang   feat: 增量索引服务、租户配置...
9
10
11
  """
  
  import pandas as pd
b2e50710   tangwang   BgeEncoder.encode...
12
  import numpy as np
0064e946   tangwang   feat: 增量索引服务、租户配置...
13
  import logging
d54b0467   tangwang   feat: 为商品索引补充 qan...
14
  import re
0064e946   tangwang   feat: 增量索引服务、租户配置...
15
16
  from typing import Dict, Any, Optional, List
  from config import ConfigLoader
d54b0467   tangwang   feat: 为商品索引补充 qan...
17
  from indexer.process_products import analyze_products, SUPPORTED_LANGS
0064e946   tangwang   feat: 增量索引服务、租户配置...
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
  
  logger = logging.getLogger(__name__)
  
  # Try to import translator (optional dependency)
  try:
      from query.translator import Translator
      TRANSLATOR_AVAILABLE = True
  except ImportError:
      TRANSLATOR_AVAILABLE = False
      Translator = None
  
  
  class SPUDocumentTransformer:
      """SPU文档转换器,将SPU、SKU、Option数据转换为ES文档格式。"""
  
      def __init__(
          self,
          category_id_to_name: Dict[str, str],
          searchable_option_dimensions: List[str],
          tenant_config: Optional[Dict[str, Any]] = None,
          translator: Optional[Any] = None,
453992a8   tangwang   需求:
39
40
          translation_prompts: Optional[Dict[str, str]] = None,
          encoder: Optional[Any] = None,
e7a2c0b7   tangwang   img encode
41
42
43
          enable_title_embedding: bool = True,
          image_encoder: Optional[Any] = None,
          enable_image_embedding: bool = False,
0064e946   tangwang   feat: 增量索引服务、租户配置...
44
45
46
47
48
49
50
51
52
53
      ):
          """
          初始化文档转换器。
  
          Args:
              category_id_to_name: 分类ID到名称的映射
              searchable_option_dimensions: 可搜索的option维度列表
              tenant_config: 租户配置(包含主语言和翻译配置)
              translator: 翻译器实例(可选,如果提供则启用翻译功能)
              translation_prompts: 翻译提示词配置(可选)
453992a8   tangwang   需求:
54
55
              encoder: 文本编码器实例(可选,用于生成title_embedding
              enable_title_embedding: 是否启用标题向量化(默认True
e7a2c0b7   tangwang   img encode
56
57
              image_encoder: 图片编码器实例(可选,需实现 encode_image_urls(urls) -> List[Optional[np.ndarray]]
              enable_image_embedding: 是否启用图片向量化(默认False
0064e946   tangwang   feat: 增量索引服务、租户配置...
58
59
60
61
62
63
          """
          self.category_id_to_name = category_id_to_name
          self.searchable_option_dimensions = searchable_option_dimensions
          self.tenant_config = tenant_config or {}
          self.translator = translator
          self.translation_prompts = translation_prompts or {}
453992a8   tangwang   需求:
64
65
          self.encoder = encoder
          self.enable_title_embedding = enable_title_embedding
e7a2c0b7   tangwang   img encode
66
67
          self.image_encoder = image_encoder
          self.enable_image_embedding = bool(enable_image_embedding and image_encoder is not None)
0064e946   tangwang   feat: 增量索引服务、租户配置...
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
  
      def transform_spu_to_doc(
          self,
          tenant_id: str,
          spu_row: pd.Series,
          skus: pd.DataFrame,
          options: pd.DataFrame
      ) -> Optional[Dict[str, Any]]:
          """
          将单个SPU行和其SKUs转换为ES文档。
  
          Args:
              tenant_id: 租户ID
              spu_row: SPU行数据
              skus: SKU数据DataFrame
              options: Option数据DataFrame
  
          Returns:
              ES文档字典
          """
          doc = {}
  
          # Tenant ID (required)
          doc['tenant_id'] = str(tenant_id)
  
          # SPU ID
          spu_id = spu_row['id']
          doc['spu_id'] = str(spu_id)
          
          # Validate required fields
          if pd.isna(spu_row.get('title')) or not str(spu_row['title']).strip():
              logger.error(f"SPU {spu_id} has no title, this may cause search issues")
  
          # 获取租户配置
2739b281   tangwang   多语言索引调整
102
          primary_lang = self.tenant_config.get('primary_language', 'en')
0064e946   tangwang   feat: 增量索引服务、租户配置...
103
  
453992a8   tangwang   需求:
104
105
106
107
108
109
          # 文本字段处理(使用translator的内部逻辑自动处理多语言翻译)
          self._fill_text_fields(doc, spu_row, primary_lang)
          
          # 标题向量化处理(如果启用)
          if self.enable_title_embedding and self.encoder:
              self._fill_title_embedding(doc)
0064e946   tangwang   feat: 增量索引服务、租户配置...
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
  
          # Tags
          if pd.notna(spu_row.get('tags')):
              tags_str = str(spu_row['tags'])
              doc['tags'] = [tag.strip() for tag in tags_str.split(',') if tag.strip()]
  
          # Category相关字段
          self._fill_category_fields(doc, spu_row)
  
          # Option名称(从option表获取)
          self._fill_option_names(doc, options)
  
          # Image URL
          self._fill_image_url(doc, spu_row)
  
e7a2c0b7   tangwang   img encode
125
126
127
128
          # Image embedding(与 mappings/search_products.json 中 image_embedding 嵌套结构一致)
          if self.enable_image_embedding:
              self._fill_image_embedding(doc, spu_row, skus)
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
          # Sales (fake_sales)
          if pd.notna(spu_row.get('fake_sales')):
              try:
                  doc['sales'] = int(spu_row['fake_sales'])
              except (ValueError, TypeError):
                  doc['sales'] = 0
          else:
              doc['sales'] = 0
  
          # Process SKUs and build specifications
          skus_list, prices, compare_prices, sku_prices, sku_weights, sku_weight_units, total_inventory, specifications = \
              self._process_skus(skus, options)
  
          doc['skus'] = skus_list
          doc['specifications'] = specifications
  
          # 提取option值(根据配置的searchable_option_dimensions)
          self._fill_option_values(doc, skus)
  
          # Calculate price ranges
          if prices:
              doc['min_price'] = float(min(prices))
              doc['max_price'] = float(max(prices))
          else:
              doc['min_price'] = 0.0
              doc['max_price'] = 0.0
  
89638140   tangwang   重构 indexer 文档构建接口...
156
157
          # SPU 不再读取 compare_at_price 字段;ES 的 compare_at_price 使用所有 SKU 中的最大对比价
          if compare_prices:
0064e946   tangwang   feat: 增量索引服务、租户配置...
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
              doc['compare_at_price'] = float(max(compare_prices))
          else:
              doc['compare_at_price'] = None
  
          # SKU扁平化字段
          doc['sku_prices'] = sku_prices
          doc['sku_weights'] = sku_weights
          doc['sku_weight_units'] = list(set(sku_weight_units))  # 去重
          doc['total_inventory'] = total_inventory
  
          # Time fields - convert datetime to ISO format string for ES DATE type
          if pd.notna(spu_row.get('create_time')):
              create_time = spu_row['create_time']
              if hasattr(create_time, 'isoformat'):
                  doc['create_time'] = create_time.isoformat()
              else:
                  doc['create_time'] = str(create_time)
          
          if pd.notna(spu_row.get('update_time')):
              update_time = spu_row['update_time']
              if hasattr(update_time, 'isoformat'):
                  doc['update_time'] = update_time.isoformat()
              else:
                  doc['update_time'] = str(update_time)
  
d54b0467   tangwang   feat: 为商品索引补充 qan...
183
184
185
          # 基于 LLM 的锚文本与语义属性(默认开启,失败时仅记录日志)
          self._fill_llm_attributes(doc, spu_row)
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
186
187
188
189
190
191
          return doc
  
      def _fill_text_fields(
          self,
          doc: Dict[str, Any],
          spu_row: pd.Series,
453992a8   tangwang   需求:
192
          primary_lang: str
0064e946   tangwang   feat: 增量索引服务、租户配置...
193
      ):
453992a8   tangwang   需求:
194
          """
038e4e2f   tangwang   refactor(i18n): t...
195
196
          填充文本字段(根据租户 index_languages 处理多语言翻译)。
          仅写入 primary_language  index_languages 中配置的语言。
453992a8   tangwang   需求:
197
          """
038e4e2f   tangwang   refactor(i18n): t...
198
199
200
201
          index_langs = self.tenant_config.get("index_languages") or ["en", "zh"]
  
          def _set_lang_obj(field_name: str, source_text: Optional[str], translations: Optional[Dict[str, Optional[str]]] = None):
              """写入多语言对象 doc[field_name] = {"zh": "...", "en": "...", ...},仅包含 index_languages。"""
d7d48f52   tangwang   改动(mapping + 灌入结构)
202
203
              if not source_text or not str(source_text).strip():
                  return
d7d48f52   tangwang   改动(mapping + 灌入结构)
204
205
206
              obj: Dict[str, str] = {}
              src = str(source_text)
              obj[primary_lang] = src
d7d48f52   tangwang   改动(mapping + 灌入结构)
207
              tr = translations or {}
038e4e2f   tangwang   refactor(i18n): t...
208
209
210
211
212
213
              for lang in index_langs:
                  if lang == primary_lang:
                      continue
                  val = tr.get(lang)
                  if val and str(val).strip():
                      obj[lang] = str(val)
d7d48f52   tangwang   改动(mapping + 灌入结构)
214
215
216
              if obj:
                  doc[field_name] = obj
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
217
218
219
          # Title
          if pd.notna(spu_row.get('title')):
              title_text = str(spu_row['title'])
038e4e2f   tangwang   refactor(i18n): t...
220
              translations: Dict[str, Optional[str]] = {}
453992a8   tangwang   需求:
221
              if self.translator:
453992a8   tangwang   需求:
222
223
                  prompt_zh = self.translation_prompts.get('product_title_zh') or self.translation_prompts.get('default_zh')
                  prompt_en = self.translation_prompts.get('product_title_en') or self.translation_prompts.get('default_en')
453992a8   tangwang   需求:
224
225
226
227
                  translations = self.translator.translate_for_indexing(
                      title_text,
                      shop_language=primary_lang,
                      source_lang=primary_lang,
345d960b   tangwang   1. 删除全局 enable_tr...
228
                      prompt=prompt_zh if primary_lang == 'zh' else prompt_en,
038e4e2f   tangwang   refactor(i18n): t...
229
                      index_languages=index_langs,
d7d48f52   tangwang   改动(mapping + 灌入结构)
230
                  ) or {}
d7d48f52   tangwang   改动(mapping + 灌入结构)
231
              _set_lang_obj("title", title_text, translations)
0064e946   tangwang   feat: 增量索引服务、租户配置...
232
233
234
235
  
          # Brief
          if pd.notna(spu_row.get('brief')):
              brief_text = str(spu_row['brief'])
038e4e2f   tangwang   refactor(i18n): t...
236
              translations = {}
453992a8   tangwang   需求:
237
238
239
240
241
242
              if self.translator:
                  prompt = self.translation_prompts.get('default_zh') or self.translation_prompts.get('default_en')
                  translations = self.translator.translate_for_indexing(
                      brief_text,
                      shop_language=primary_lang,
                      source_lang=primary_lang,
345d960b   tangwang   1. 删除全局 enable_tr...
243
                      prompt=prompt,
038e4e2f   tangwang   refactor(i18n): t...
244
                      index_languages=index_langs,
d7d48f52   tangwang   改动(mapping + 灌入结构)
245
246
                  ) or {}
              _set_lang_obj("brief", brief_text, translations)
0064e946   tangwang   feat: 增量索引服务、租户配置...
247
248
249
250
  
          # Description
          if pd.notna(spu_row.get('description')):
              desc_text = str(spu_row['description'])
038e4e2f   tangwang   refactor(i18n): t...
251
              translations = {}
453992a8   tangwang   需求:
252
253
254
255
256
257
              if self.translator:
                  prompt = self.translation_prompts.get('default_zh') or self.translation_prompts.get('default_en')
                  translations = self.translator.translate_for_indexing(
                      desc_text,
                      shop_language=primary_lang,
                      source_lang=primary_lang,
345d960b   tangwang   1. 删除全局 enable_tr...
258
                      prompt=prompt,
038e4e2f   tangwang   refactor(i18n): t...
259
                      index_languages=index_langs,
d7d48f52   tangwang   改动(mapping + 灌入结构)
260
261
                  ) or {}
              _set_lang_obj("description", desc_text, translations)
0064e946   tangwang   feat: 增量索引服务、租户配置...
262
263
264
265
  
          # Vendor
          if pd.notna(spu_row.get('vendor')):
              vendor_text = str(spu_row['vendor'])
038e4e2f   tangwang   refactor(i18n): t...
266
              translations = {}
453992a8   tangwang   需求:
267
268
269
270
271
272
              if self.translator:
                  prompt = self.translation_prompts.get('default_zh') or self.translation_prompts.get('default_en')
                  translations = self.translator.translate_for_indexing(
                      vendor_text,
                      shop_language=primary_lang,
                      source_lang=primary_lang,
345d960b   tangwang   1. 删除全局 enable_tr...
273
                      prompt=prompt,
038e4e2f   tangwang   refactor(i18n): t...
274
                      index_languages=index_langs,
d7d48f52   tangwang   改动(mapping + 灌入结构)
275
276
                  ) or {}
              _set_lang_obj("vendor", vendor_text, translations)
0064e946   tangwang   feat: 增量索引服务、租户配置...
277
278
279
  
      def _fill_category_fields(self, doc: Dict[str, Any], spu_row: pd.Series):
          """填充类目相关字段。"""
92d5eb07   tangwang   fix:前端直接显示了类目ID。 ...
280
281
282
283
          # 数据质量兜底:
          # - 当商品的类目ID在映射中不存在时,视为“不合法类目”,整条类目相关字段都不写入(当成没有类目)
          # - 仅记录错误日志,不阻塞索引流程
  
2739b281   tangwang   多语言索引调整
284
          primary_lang = self.tenant_config.get('primary_language', 'en')
d7d48f52   tangwang   改动(mapping + 灌入结构)
285
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
286
287
288
289
290
          if pd.notna(spu_row.get('category_path')):
              category_path = str(spu_row['category_path'])
              
              # 解析category_path - 这是逗号分隔的类目ID列表
              category_ids = [cid.strip() for cid in category_path.split(',') if cid.strip()]
92d5eb07   tangwang   fix:前端直接显示了类目ID。 ...
291
              # 将ID映射为名称,如果找不到映射则记录错误并跳过
0064e946   tangwang   feat: 增量索引服务、租户配置...
292
              category_names = []
92d5eb07   tangwang   fix:前端直接显示了类目ID。 ...
293
              missing_ids = []
0064e946   tangwang   feat: 增量索引服务、租户配置...
294
295
296
297
              for cid in category_ids:
                  if cid in self.category_id_to_name:
                      category_names.append(self.category_id_to_name[cid])
                  else:
92d5eb07   tangwang   fix:前端直接显示了类目ID。 ...
298
299
300
301
302
303
304
305
306
307
                      missing_ids.append(cid)
              
              # 如果有缺失的类目ID,记录错误日志,不写入类目字段(当成没有类目)
              if missing_ids:
                  logger.error(
                      f"Category ID(s) not found in mapping for SPU {spu_row.get('id')} "
                      f"(title: {spu_row.get('title', 'N/A')}), missing_ids={missing_ids}, "
                      f"category_path={category_path}. Treating as no-category."
                  )
                  return
0064e946   tangwang   feat: 增量索引服务、租户配置...
308
309
310
311
              
              # 构建类目路径字符串(用于搜索)
              if category_names:
                  category_path_str = '/'.join(category_names)
d7d48f52   tangwang   改动(mapping + 灌入结构)
312
                  doc['category_path'] = {primary_lang: category_path_str}
2e48a32d   tangwang   doc
313
314
                  # 与查询使用的 category_name_text.zh/en 对齐,便于类目搜索
                  doc['category_name_text'] = {primary_lang: category_path_str}
0064e946   tangwang   feat: 增量索引服务、租户配置...
315
316
317
318
319
320
321
322
323
324
325
                  
                  # 填充分层类目名称
                  if len(category_names) > 0:
                      doc['category1_name'] = category_names[0]
                  if len(category_names) > 1:
                      doc['category2_name'] = category_names[1]
                  if len(category_names) > 2:
                      doc['category3_name'] = category_names[2]
          elif pd.notna(spu_row.get('category')):
              # 如果category_path为空,使用category字段作为category1_name的备选
              category = str(spu_row['category'])
d7d48f52   tangwang   改动(mapping + 灌入结构)
326
              doc['category_name_text'] = {primary_lang: category}
0064e946   tangwang   feat: 增量索引服务、租户配置...
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
              doc['category_name'] = category
              
              # 尝试从category字段解析多级分类
              if '/' in category:
                  path_parts = category.split('/')
                  if len(path_parts) > 0:
                      doc['category1_name'] = path_parts[0].strip()
                  if len(path_parts) > 1:
                      doc['category2_name'] = path_parts[1].strip()
                  if len(path_parts) > 2:
                      doc['category3_name'] = path_parts[2].strip()
              else:
                  # 如果category不包含"/",直接作为category1_name
                  doc['category1_name'] = category.strip()
  
          if pd.notna(spu_row.get('category')):
              # 确保category相关字段都被设置(如果前面没有设置)
              category_name = str(spu_row['category'])
d7d48f52   tangwang   改动(mapping + 灌入结构)
345
346
              if 'category_name_text' not in doc:
                  doc['category_name_text'] = {primary_lang: category_name}
0064e946   tangwang   feat: 增量索引服务、租户配置...
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
              if 'category_name' not in doc:
                  doc['category_name'] = category_name
  
          if pd.notna(spu_row.get('category_id')):
              doc['category_id'] = str(int(spu_row['category_id']))
  
          if pd.notna(spu_row.get('category_level')):
              doc['category_level'] = int(spu_row['category_level'])
  
      def _fill_option_names(self, doc: Dict[str, Any], options: pd.DataFrame):
          """填充Option名称字段。"""
          if not options.empty:
              # 按position排序获取option名称
              sorted_options = options.sort_values('position')
              if len(sorted_options) > 0 and pd.notna(sorted_options.iloc[0].get('name')):
                  doc['option1_name'] = str(sorted_options.iloc[0]['name'])
              if len(sorted_options) > 1 and pd.notna(sorted_options.iloc[1].get('name')):
                  doc['option2_name'] = str(sorted_options.iloc[1]['name'])
              if len(sorted_options) > 2 and pd.notna(sorted_options.iloc[2].get('name')):
                  doc['option3_name'] = str(sorted_options.iloc[2]['name'])
  
      def _fill_image_url(self, doc: Dict[str, Any], spu_row: pd.Series):
          """填充图片URL字段。"""
          if pd.notna(spu_row.get('image_src')):
              image_src = str(spu_row['image_src'])
              if not image_src.startswith('http'):
cd6d887e   tangwang   reranker doc
373
374
                  # 仅当尚未是协议相对 URL 时才补 "//",避免 "//host" 变成 "////host"
                  image_src = f"//{image_src}" if not image_src.startswith('//') else image_src
0064e946   tangwang   feat: 增量索引服务、租户配置...
375
376
              doc['image_url'] = image_src
  
e7a2c0b7   tangwang   img encode
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
      def _fill_image_embedding(
          self, doc: Dict[str, Any], spu_row: pd.Series, skus: pd.DataFrame
      ) -> None:
          """
          填充 image_embedding 嵌套字段,与 mappings/search_products.json 一致:
          [{ "vector": [float, ...], "url": "..." }, ...]
          收集 SPU 主图 + SKU 图片 URL,去重后调用 image_encoder 生成向量。
          """
          urls: List[str] = []
          seen: set = set()
  
          def _add(url: str) -> None:
              if not url or not str(url).strip():
                  return
              u = str(url).strip()
              if u.startswith("//"):
                  u = "https:" + u
              if u not in seen:
                  seen.add(u)
                  urls.append(u)
  
          if doc.get("image_url"):
              _add(doc["image_url"])
          if pd.notna(spu_row.get("image_src")):
              _add(str(spu_row["image_src"]))
          if not skus.empty and "image_src" in skus.columns:
              for _, row in skus.iterrows():
                  if pd.notna(row.get("image_src")):
                      _add(str(row["image_src"]))
  
          if not urls:
              return
ed948666   tangwang   tidy
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
          vectors = self.image_encoder.encode_image_urls(urls, batch_size=8)
          if not vectors or len(vectors) != len(urls):
              raise RuntimeError(
                  f"image_embedding response length mismatch for SPU {doc.get('spu_id')}: "
                  f"expected {len(urls)}, got {0 if vectors is None else len(vectors)}"
              )
          out = []
          for url, vec in zip(urls, vectors):
              arr = np.asarray(vec, dtype=np.float32)
              if arr.ndim != 1 or arr.size == 0 or not np.isfinite(arr).all():
                  raise RuntimeError(
                      f"Invalid image embedding for SPU {doc.get('spu_id')} and URL {url}"
                  )
              out.append({"vector": arr.tolist(), "url": url})
          doc["image_embedding"] = out
e7a2c0b7   tangwang   img encode
424
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
      def _process_skus(
          self,
          skus: pd.DataFrame,
          options: pd.DataFrame
      ) -> tuple:
          """处理SKU数据,返回处理结果。"""
          skus_list = []
          prices = []
          compare_prices = []
          sku_prices = []
          sku_weights = []
          sku_weight_units = []
          total_inventory = 0
          specifications = []
  
          # 构建option名称映射(position -> name)
          option_name_map = {}
          if not options.empty:
              for _, opt_row in options.iterrows():
                  position = opt_row.get('position')
                  name = opt_row.get('name')
                  if pd.notna(position) and pd.notna(name):
                      option_name_map[int(position)] = str(name)
  
          for _, sku_row in skus.iterrows():
              sku_data = self._transform_sku_row(sku_row, option_name_map)
              if sku_data:
                  skus_list.append(sku_data)
                  
                  # 收集价格信息
                  if 'price' in sku_data and sku_data['price'] is not None:
                      try:
                          price_val = float(sku_data['price'])
                          prices.append(price_val)
                          sku_prices.append(price_val)
                      except (ValueError, TypeError):
                          pass
                  
                  if 'compare_at_price' in sku_data and sku_data['compare_at_price'] is not None:
                      try:
                          compare_prices.append(float(sku_data['compare_at_price']))
                      except (ValueError, TypeError):
                          pass
                  
                  # 收集重量信息
                  if 'weight' in sku_data and sku_data['weight'] is not None:
                      try:
                          sku_weights.append(int(float(sku_data['weight'])))
                      except (ValueError, TypeError):
                          pass
                  
                  if 'weight_unit' in sku_data and sku_data['weight_unit']:
                      sku_weight_units.append(str(sku_data['weight_unit']))
                  
                  # 收集库存信息
                  if 'stock' in sku_data and sku_data['stock'] is not None:
                      try:
                          total_inventory += int(sku_data['stock'])
                      except (ValueError, TypeError):
                          pass
                  
                  # 构建specifications(从SKU的option值和option表的name)
                  sku_id = str(sku_row['id'])
                  if pd.notna(sku_row.get('option1')) and 1 in option_name_map:
                      specifications.append({
                          'sku_id': sku_id,
                          'name': option_name_map[1],
                          'value': str(sku_row['option1'])
                      })
                  if pd.notna(sku_row.get('option2')) and 2 in option_name_map:
                      specifications.append({
                          'sku_id': sku_id,
                          'name': option_name_map[2],
                          'value': str(sku_row['option2'])
                      })
                  if pd.notna(sku_row.get('option3')) and 3 in option_name_map:
                      specifications.append({
                          'sku_id': sku_id,
                          'name': option_name_map[3],
                          'value': str(sku_row['option3'])
                      })
  
          return skus_list, prices, compare_prices, sku_prices, sku_weights, sku_weight_units, total_inventory, specifications
  
      def _fill_option_values(self, doc: Dict[str, Any], skus: pd.DataFrame):
          """填充option值字段。"""
          option1_values = []
          option2_values = []
          option3_values = []
          
          for _, sku_row in skus.iterrows():
              if pd.notna(sku_row.get('option1')):
                  option1_values.append(str(sku_row['option1']))
              if pd.notna(sku_row.get('option2')):
                  option2_values.append(str(sku_row['option2']))
              if pd.notna(sku_row.get('option3')):
                  option3_values.append(str(sku_row['option3']))
          
          # 去重并根据配置决定是否写入索引
          if 'option1' in self.searchable_option_dimensions:
              doc['option1_values'] = list(set(option1_values)) if option1_values else []
          else:
              doc['option1_values'] = []
          
          if 'option2' in self.searchable_option_dimensions:
              doc['option2_values'] = list(set(option2_values)) if option2_values else []
          else:
              doc['option2_values'] = []
          
          if 'option3' in self.searchable_option_dimensions:
              doc['option3_values'] = list(set(option3_values)) if option3_values else []
          else:
              doc['option3_values'] = []
  
d54b0467   tangwang   feat: 为商品索引补充 qan...
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
      def _fill_llm_attributes(self, doc: Dict[str, Any], spu_row: pd.Series) -> None:
          """
          调用 indexer.process_products.analyze_products,为当前 SPU 填充:
          - qanchors.{lang}
          - semantic_attributes (lang/name/value)
          """
          try:
              index_langs = self.tenant_config.get("index_languages") or ["en", "zh"]
          except Exception:
              index_langs = ["en", "zh"]
  
          # 只在支持的语言集合内调用
          llm_langs = [lang for lang in index_langs if lang in SUPPORTED_LANGS]
          if not llm_langs:
              return
  
          spu_id = str(spu_row.get("id") or "").strip()
          title = str(spu_row.get("title") or "").strip()
          if not spu_id or not title:
              return
  
          semantic_list = doc.get("semantic_attributes") or []
          qanchors_obj = doc.get("qanchors") or {}
  
          dim_keys = [
              "tags",
              "target_audience",
              "usage_scene",
              "season",
              "key_attributes",
              "material",
              "features",
          ]
  
501066e1   tangwang   redis 缓存 LLM结果
573
574
          tenant_id = doc.get("tenant_id")
  
d54b0467   tangwang   feat: 为商品索引补充 qan...
575
576
577
578
579
580
          for lang in llm_langs:
              try:
                  rows = analyze_products(
                      products=[{"id": spu_id, "title": title}],
                      target_lang=lang,
                      batch_size=1,
501066e1   tangwang   redis 缓存 LLM结果
581
                      tenant_id=str(tenant_id),
d54b0467   tangwang   feat: 为商品索引补充 qan...
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
                  )
              except Exception as e:
                  logger.warning(
                      "LLM attribute fill failed for SPU %s, lang=%s: %s",
                      spu_id,
                      lang,
                      e,
                  )
                  continue
  
              if not rows:
                  continue
              row = rows[0] or {}
  
              # qanchors.{lang}
              anchor_text = str(row.get("anchor_text") or "").strip()
              if anchor_text:
                  qanchors_obj[lang] = anchor_text
  
              # 语义属性:按各维度拆分为短语
              for name in dim_keys:
                  raw = row.get(name)
                  if not raw:
                      continue
                  parts = re.split(r"[,;|/\n\t]+", str(raw))
                  for part in parts:
                      value = part.strip()
                      if not value:
                          continue
                      semantic_list.append(
                          {
                              "lang": lang,
                              "name": name,
                              "value": value,
                          }
                      )
  
          if qanchors_obj:
              doc["qanchors"] = qanchors_obj
          if semantic_list:
              doc["semantic_attributes"] = semantic_list
  
0064e946   tangwang   feat: 增量索引服务、租户配置...
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
      def _transform_sku_row(self, sku_row: pd.Series, option_name_map: Dict[int, str] = None) -> Optional[Dict[str, Any]]:
          """
          SKU行转换为SKU对象。
  
          Args:
              sku_row: SKU行数据
              option_name_map: positionoption名称的映射
  
          Returns:
              SKU字典
          """
          sku_data = {}
  
          # SKU ID
          sku_data['sku_id'] = str(sku_row['id'])
  
          # Price
          if pd.notna(sku_row.get('price')):
              try:
                  sku_data['price'] = float(sku_row['price'])
              except (ValueError, TypeError):
                  sku_data['price'] = None
          else:
              sku_data['price'] = None
  
          # Compare at price
          if pd.notna(sku_row.get('compare_at_price')):
              try:
                  sku_data['compare_at_price'] = float(sku_row['compare_at_price'])
              except (ValueError, TypeError):
                  sku_data['compare_at_price'] = None
          else:
              sku_data['compare_at_price'] = None
  
          # SKU Code
          if pd.notna(sku_row.get('sku')):
              sku_data['sku_code'] = str(sku_row['sku'])
  
          # Stock
          if pd.notna(sku_row.get('inventory_quantity')):
              try:
                  sku_data['stock'] = int(sku_row['inventory_quantity'])
              except (ValueError, TypeError):
                  sku_data['stock'] = 0
          else:
              sku_data['stock'] = 0
  
          # Weight
          if pd.notna(sku_row.get('weight')):
              try:
                  sku_data['weight'] = float(sku_row['weight'])
              except (ValueError, TypeError):
                  sku_data['weight'] = None
          else:
              sku_data['weight'] = None
  
          # Weight unit
          if pd.notna(sku_row.get('weight_unit')):
              sku_data['weight_unit'] = str(sku_row['weight_unit'])
  
          # Option values
          if pd.notna(sku_row.get('option1')):
              sku_data['option1_value'] = str(sku_row['option1'])
          if pd.notna(sku_row.get('option2')):
              sku_data['option2_value'] = str(sku_row['option2'])
          if pd.notna(sku_row.get('option3')):
              sku_data['option3_value'] = str(sku_row['option3'])
          
          # Image src
          if pd.notna(sku_row.get('image_src')):
              sku_data['image_src'] = str(sku_row['image_src'])
  
          return sku_data
453992a8   tangwang   需求:
697
698
699
700
701
      
      def _fill_title_embedding(self, doc: Dict[str, Any]) -> None:
          """
          填充标题向量化字段。
          
d7d48f52   tangwang   改动(mapping + 灌入结构)
702
          使用英文标题(title.en)生成embedding。如果title.en不存在,则使用title.zh
453992a8   tangwang   需求:
703
704
705
706
          
          Args:
              doc: ES文档字典
          """
d7d48f52   tangwang   改动(mapping + 灌入结构)
707
708
709
710
711
712
713
714
715
716
717
          # 优先使用英文标题,如果没有则使用中文标题;再没有则取任意可用语言
          title_obj = doc.get("title") or {}
          if isinstance(title_obj, dict):
              title_text = title_obj.get("en") or title_obj.get("zh")
              if not title_text:
                  for v in title_obj.values():
                      if v and str(v).strip():
                          title_text = str(v)
                          break
          else:
              title_text = None
453992a8   tangwang   需求:
718
719
720
721
722
          
          if not title_text or not title_text.strip():
              logger.debug(f"No title text available for embedding, SPU: {doc.get('spu_id')}")
              return
          
ed948666   tangwang   tidy
723
724
725
726
727
728
729
730
731
732
733
          # 使用文本向量编码器生成 embedding
          # encode方法返回numpy数组,形状为(n, d)
          embeddings = self.encoder.encode(title_text)
          if embeddings is None or len(embeddings) == 0:
              raise RuntimeError(f"Failed to generate title embedding for SPU {doc.get('spu_id')}")
  
          embedding = np.asarray(embeddings[0], dtype=np.float32)
          if embedding.ndim != 1 or embedding.size == 0 or not np.isfinite(embedding).all():
              raise RuntimeError(f"Invalid title embedding for SPU {doc.get('spu_id')}")
          doc['title_embedding'] = embedding.tolist()
          logger.debug(f"Generated title_embedding for SPU: {doc.get('spu_id')}, title: {title_text[:50]}...")