Function processFile

main.js:5788–5924

(filePath, index)

        params.push(v);
        posParts.push(`LOWER(TRIM(${column})) = LOWER(TRIM(?))`);
      } else {
        params.push(v);
        posParts.push(`${column} = ?`);
      }
    }
    conditions.push(posParts.length === 1 ? posParts[0] : `(${posParts.join(posJoin)})`);
    return;
  }
  const negJoin = combineOp === 'OR' ? ' AND ' : ' OR ';
  const negParts = [];
  for (const v of values) {
    if (v === '__none__') {
      negParts.push(`(${column} IS NOT NULL AND ${column} != '')`);
    } else if (useLowerTrim) {
      params.push(v);
      negParts.push(`(${column} IS NULL OR ${column} = '' OR LOWER(TRIM(${column})) != LOWER(TRIM(?)))`);
    } else {
      params.push(v);
      negParts.push(`(${column} IS NULL OR ${column} = '' OR ${column} != ?)`);
    }
  }
  conditions.push(negParts.length === 1 ? negParts[0] : `(${negParts.join(negJoin)})`);
}

function pushTagListSQL(conditions, params, filters) {
  const tagNames = normalizeTagNameList(filters);
  if (!tagNames.length) return false;
  const combine = filters.tagCombine === 'AND' ? 'AND' : 'OR';
  const inverted = !!filters.tagInverted;
  let inner;
  if (combine === 'OR') {
    const ph = tagNames.map(() => '?').join(', ');
    inner = `EXISTS (SELECT 1 FROM model_tags mt INNER JOIN tags t ON t.id = mt.tag_id WHERE mt.model_id = models.id AND t.name IN (${ph}))`;
    params.push(...tagNames);
  } else {
    const existsParts = [];
    for (const tn of tagNames) {
      params.push(tn);
      existsParts.push(
        'EXISTS (SELECT 1 FROM model_tags mt INNER JOIN tags t ON t.id = mt.tag_id WHERE mt.model_id = models.id AND t.name = ?)'
      );
    }
    inner = `(${existsParts.join(' AND ')})`;
  }
  if (inverted) {
    conditions.push(`NOT (${inner})`);
  } else {
    conditions.push(inner);
  }
  return true;
}

function normalizeFilamentIdList(filters) {
  const raw = [];
  if (Array.isArray(filters?.filaments)) raw.push(...filters.filaments);
  else if (filters?.filament != null && filters.filament !== '') raw.push(filters.filament);
  return raw.map((v) => {
    if (v && typeof v === 'object') return Number(v.id);