Загрузка данных


(async function () {
  'use strict';

  // ============ КОНФИГ ============
  const DELAY_BETWEEN_ROWS   = 1500;   // пауза между заявками (мс)
  const PANEL_LOAD_TIMEOUT   = 20000;  // максимум ждём загрузки панели
  const COMMENTS_TIMEOUT     = 15000;  // максимум ждём догрузки комментариев
  const SCROLL_STEP          = 300;    // шаг скролла при сборе списка
  const SCROLL_WAIT          = 600;    // ожидание после скролла
  const MAX_IDLE_SCROLLS     = 3;      // шагов без новых строк — стоп
  const MAX_SCROLL_ITER      = 500;    // защита от бесконечного цикла

  // ============ УТИЛИТЫ ============
  const sleep = (ms) => new Promise(r => setTimeout(r, ms));

  function log(...args) {
    console.log('%c[TFS-Report]', 'color:#0a0;font-weight:bold', ...args);
  }
  function warn(...args) {
    console.warn('%c[TFS-Report]', 'color:#c80;font-weight:bold', ...args);
  }

  function waitFor(selector, { root = document, timeout = 10000 } = {}) {
    return new Promise((resolve, reject) => {
      const found = root.querySelector(selector);
      if (found) return resolve(found);
      const obs = new MutationObserver(() => {
        const el = root.querySelector(selector);
        if (el) { obs.disconnect(); clearTimeout(timer); resolve(el); }
      });
      obs.observe(root, { childList: true, subtree: true });
      const timer = setTimeout(() => {
        obs.disconnect();
        reject(new Error('timeout waiting for: ' + selector));
      }, timeout);
    });
  }

  function waitForCondition(checkFn, { timeout = 10000, label = '', pollMs = 300 } = {}) {
    return new Promise((resolve, reject) => {
      let done = false;
      let lastDiag = '';

      const check = () => {
        try {
          const v = checkFn();
          if (v === true || (v && v.ok)) return { ok: true, value: v };
          if (v && typeof v === 'object' && v.diag) lastDiag = v.diag;
        } catch (e) {
          lastDiag = 'exception: ' + e.message;
        }
        return { ok: false };
      };

      const tryResolve = () => {
        if (done) return;
        const r = check();
        if (r.ok) { done = true; cleanup(); resolve(r.value); }
      };

      const obs = new MutationObserver(tryResolve);
      obs.observe(document.body, {
        childList: true, subtree: true, characterData: true, attributes: true
      });

      const poll = setInterval(tryResolve, pollMs);

      function cleanup() {
        obs.disconnect();
        clearInterval(poll);
        clearTimeout(timer);
      }

      const timer = setTimeout(() => {
        if (done) return;
        done = true;
        cleanup();
        reject(new Error(`timeout: ${label}${lastDiag ? ` (lastDiag="${lastDiag}")` : ''}`));
      }, timeout);

      tryResolve();
    });
  }

  // ============ 1. СКРОЛЛ-КОНТЕЙНЕР СПИСКА ============
  function ancestors(el, depth = 8) {
    const arr = [];
    let p = el;
    for (let i = 0; i < depth && p; i++) { p = p.parentElement; if (p) arr.push(p); }
    return arr;
  }

  function getScroller() {
    const spacer = document.querySelector('.grid-content-spacer');
    if (!spacer) {
      warn('grid-content-spacer не найден');
      return document.scrollingElement;
    }

    for (const el of [spacer, spacer.parentElement, ...ancestors(spacer, 8)]) {
      if (!el || el === document.body || el === document.documentElement) continue;
      const st = getComputedStyle(el);
      if ((st.overflowY === 'auto' || st.overflowY === 'scroll') &&
          el.scrollHeight > el.clientHeight + 5) return el;
    }

    let el = spacer.parentElement;
    while (el && el !== document.body) {
      if (el.scrollHeight > el.clientHeight + 5) return el;
      el = el.parentElement;
    }
    return spacer.parentElement || document.scrollingElement;
  }

  async function scrollToTop(scroller) {
    if (!scroller) return;
    scroller.scrollTop = 0;
    scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
    await sleep(SCROLL_WAIT);
  }

  // ============ 2. СБОР СПИСКА ЗАЯВОК ============
  function readVisibleRows() {
    const result = [];
    document.querySelectorAll('.grid-row').forEach(row => {
      const a = row.querySelector('a.work-item-title-link');
      if (!a) return;
      const m = (a.getAttribute('href') || '').match(/\/edit\/(\d+)/);
      if (!m) return;
      result.push({
        id: m[1],
        title: a.textContent.trim(),
        href: a.getAttribute('href')
      });
    });
    return result;
  }

  async function collectAllRows(scroller) {
    log('Сбор списка заявок...');
    const map = new Map();
    let idle = 0;
    let iter = 0;

    await scrollToTop(scroller);

    while (iter++ < MAX_SCROLL_ITER) {
      const before = map.size;
      readVisibleRows().forEach(r => { if (!map.has(r.id)) map.set(r.id, r); });
      if (map.size > before) idle = 0;

      const atBottom = !scroller ||
        scroller.scrollTop + scroller.clientHeight >= scroller.scrollHeight - 10;

      if (atBottom) {
        idle++;
        if (idle >= MAX_IDLE_SCROLLS) break;
        scroller.scrollTop = scroller.scrollTop + 5;
        scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
        await sleep(SCROLL_WAIT);
        continue;
      }

      scroller.scrollTop = Math.min(scroller.scrollTop + SCROLL_STEP, scroller.scrollHeight);
      scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
      await sleep(SCROLL_WAIT);
    }

    readVisibleRows().forEach(r => { if (!map.has(r.id)) map.set(r.id, r); });
    log(`Найдено заявок: ${map.size}`);
    return Array.from(map.values());
  }

  // ============ 3. ЧТЕНИЕ ПОЛЕЙ ПАНЕЛИ ============
  const findInput = (panel, aria) => panel.querySelector(`input[aria-label="${aria}"]`);
  const getPanel = () => document.querySelector('.rightPane');

  function readInputOrDisplay(panel, aria, displaySelector) {
    const v = findInput(panel, aria)?.value?.trim();
    if (v) return v;
    return panel.querySelector(displaySelector)?.textContent?.trim() || '';
  }

  function getTitle(panel) {
    const v = findInput(panel, 'Поле заголовка')?.value?.trim()
           || panel.querySelector('#witc_221_txt')?.value?.trim();
    if (v) return v;
    return panel.querySelector('.workitem-info-bar .caption')?.textContent?.trim() || '';
  }

  const getState = (panel) => readInputOrDisplay(panel, 'Поле состояния', '.workitem-state-value');

  const getAssignedTo = (panel) =>
    panel.querySelector('.work-item-form-assignedTo .identity-picker-resolved-name')?.textContent?.trim() || '';

  function getArea(panel) {
    const inp = findInput(panel, 'Путь области') || panel.querySelector('#witc_225_txt');
    return inp?.value?.trim() || '';
  }

  function getIteration(panel) {
    const inp = findInput(panel, 'Путь итерации') || panel.querySelector('#witc_229_txt');
    return inp?.value?.trim() || '';
  }

  function getChangedBy(panel) {
    for (const el of panel.querySelectorAll('.freshness-indicator')) {
      const t = el.textContent.trim();
      if (t && el.offsetParent !== null) return t;
    }
    return '';
  }

  // ============ 4. КОММЕНТАРИИ ============

  function getExpectedCommentCount(panel) {
    const adorn = panel.querySelector('.discussion-adornment-control');
    if (adorn) {
      const s = (adorn.getAttribute('aria-label') || '') + ' ' + (adorn.textContent || '');
      const m = s.match(/(\d+)/);
      if (m) return parseInt(m[1], 10);
    }
    const badge = panel.querySelector('.discussion-adornment-container .text');
    if (badge) {
      const m = badge.textContent.match(/(\d+)/);
      if (m) return parseInt(m[1], 10);
    }
    const tabCount = panel.querySelector('.work-item-form-tab .link-count, .work-item-form-tab .attachment-count');
    if (tabCount) {
      const m = tabCount.textContent.match(/(\d+)/);
      if (m) return parseInt(m[1], 10);
    }
    return null;
  }

  async function ensureDiscussionExpanded(panel) {
    const header = Array.from(panel.querySelectorAll('.tfs-collapsible-header'))
      .find(h => /Обсуждени/i.test(h.textContent));
    if (!header) return;

    const content = header.parentElement?.querySelector('.tfs-collapsible-content');
    if (content && content.style.display === 'none') {
      (header.querySelector('.headerlabel') || header).click();
      await sleep(500);
    }

    const discTab = Array.from(panel.querySelectorAll('.work-item-form-tab'))
      .find(t => /обсужд|discussion/i.test(t.getAttribute('aria-labelledby') || t.textContent || ''));
    if (discTab && !discTab.classList.contains('selected-tab')) {
      const discVisible = content && content.offsetParent !== null;
      if (!discVisible) {
        discTab.click();
        await sleep(500);
      }
    }
  }

  function parseRelativeTime(s) {
    if (!s) return Infinity;
    const m = s.toLowerCase().match(/(\d+)\s*(сек|мин|ч|дн|час|день|недел)/);
    if (!m) return Infinity;
    const n = parseInt(m[1], 10);
    const u = m[2];
    if (/сек/.test(u)) return n;
    if (/мин/.test(u)) return n * 60;
    if (/ч|час/.test(u)) return n * 3600;
    if (/дн|день/.test(u)) return n * 86400;
    if (/недел/.test(u)) return n * 604800;
    return Infinity;
  }

  function extractCommentBody(ci) {
    const content = ci.querySelector('.comment-content');
    if (content) {
      const inner = content.querySelector('.rooster-editor, .lean-rooster');
      const txt = (inner ? inner.innerText : content.innerText || '').trim();
      if (txt) return txt;
    }
    const rooster = ci.querySelector('.rooster-editor, .lean-rooster');
    if (rooster) {
      const txt = (rooster.innerText || '').trim();
      if (txt) return txt;
    }
    const clone = ci.cloneNode(true);
    clone.querySelectorAll('.comment-header, .comment-toolbar, .comment-timestamp, .user-display-name')
      .forEach(n => n.remove());
    return (clone.innerText || '').trim();
  }

  function extractCommentData(ci) {
    const author = ci.querySelector('.user-display-name')?.textContent.trim() || '';
    const tsRaw  = ci.querySelector('.comment-timestamp')?.textContent.trim() || '';
    const body   = extractCommentBody(ci);
    const idAttr = ci.querySelector('[data-comment-id]')?.getAttribute('data-comment-id');
    const id     = idAttr ? parseInt(idAttr, 10) : null;
    return { id, author, tsRaw, ts: parseRelativeTime(tsRaw), body };
  }

  function pickLatest(comments) {
    if (!comments.length) return null;
    const withId = comments.filter(c => c.id != null);
    if (withId.length) return withId.reduce((a, b) => (b.id > a.id ? b : a));
    return comments.reduce((a, b) => (b.ts < a.ts ? b : a));
  }

  function findDiscussionScroller(panel) {
    const roots = [
      panel.querySelector('.discussion-messages'),
      panel.querySelector('.discussion-messages-container'),
      panel.querySelector('.discussion-control'),
      panel.querySelector('.witform-layout-scrollable-frame')
    ].filter(Boolean);

    for (const root of roots) {
      let el = root;
      while (el && el !== document.body) {
        const st = getComputedStyle(el);
        if ((st.overflowY === 'auto' || st.overflowY === 'scroll') &&
            el.scrollHeight > el.clientHeight + 2) {
          return el;
        }
        el = el.parentElement;
      }
    }
    return null;
  }

  async function scrollDiscussionToBottom(scroller, { step = 200, pause = 120 } = {}) {
    if (!scroller) return;
    let stable = 0;
    for (let i = 0; i < 50; i++) {
      const before = scroller.scrollHeight;
      scroller.scrollTop = Math.min(scroller.scrollTop + step, scroller.scrollHeight);
      scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
      await sleep(pause);

      if (scroller.scrollHeight === before) stable++; else stable = 0;

      const atBottom = scroller.scrollTop + scroller.clientHeight >= scroller.scrollHeight - 5;
      if (atBottom && stable >= 2) break;
    }
    scroller.scrollTop = scroller.scrollHeight;
    scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
    await sleep(300);
  }

  async function loadAllComments(panel, { timeout = COMMENTS_TIMEOUT, previousCommentIds = [] } = {}) {
    await ensureDiscussionExpanded(panel);
    const expected = getExpectedCommentCount(panel);
    const prevSet = new Set(previousCommentIds.map(String));

    // Если ожидаемое = 0 — ждём, пока «чужие» комментарии уйдут из DOM
    if (expected === 0) {
      for (let t = 0; t < 15; t++) {
        const hasStale = Array.from(panel.querySelectorAll('.comment-item [data-comment-id]'))
          .some(el => prevSet.has(el.getAttribute('data-comment-id')));
        if (!hasStale && panel.querySelectorAll('.comment-item').length === 0) break;
        await sleep(200);
      }
      return [];
    }

    const messagesRoot =
      panel.querySelector('.discussion-messages') ||
      panel.querySelector('.discussion-messages-container') ||
      panel.querySelector('.discussion-control');
    if (!messagesRoot) return [];

    const scroller = findDiscussionScroller(panel) || messagesRoot;

    const started = performance.now();
    const maxTicks = Math.ceil(timeout / 300);
    let lastCount = -1;
    let stableTicks = 0;
    let lastHeight = -1;
    let heightStableTicks = 0;

    for (let tick = 0; tick < maxTicks; tick++) {
      const items = Array.from(panel.querySelectorAll('.comment-item'));
      const count = items.length;
      const curHeight = scroller.scrollHeight;

      const bodies = items.map(extractCommentBody);
      const emptyBodies = bodies.filter(b => !b).length;

      const hasStale = Array.from(panel.querySelectorAll('.comment-item [data-comment-id]'))
        .some(el => prevSet.has(el.getAttribute('data-comment-id')));

      const countOk = expected != null
        ? count >= expected
        : (count > 0 && stableTicks >= 3);

      if (countOk && emptyBodies === 0 && !hasStale) break;

      // диагностика раз в 3 тика
      if (tick % 3 === 0) {
        log(`   [tick ${tick}] expected=${expected}, count=${count}, empty=${emptyBodies}, stale=${hasStale}, h=${curHeight}`);
      }

      await scrollDiscussionToBottom(scroller, { step: 200, pause: 120 });

      if (count === lastCount) stableTicks++; else stableTicks = 0;
      if (curHeight === lastHeight) heightStableTicks++; else heightStableTicks = 0;
      lastCount = count;
      lastHeight = curHeight;

      if (performance.now() - started > timeout) break;
    }

    const all = Array.from(panel.querySelectorAll('.comment-item')).map(extractCommentData);

    if (expected != null && all.length < expected) {
      warn(`   ⚠ Собрано ${all.length} из ${expected} комментариев (timeout)`);
    }
    const empty = all.filter(c => !c.body).length;
    if (empty) warn(`   ⚠ ${empty} комментариев с пустым текстом`);

    return all;
  }

  async function waitForComments(panel, opts = {}) {
    const all = await loadAllComments(panel, opts);
    return { all, latest: pickLatest(all) };
  }

  // ============ 5. ОЖИДАНИЕ ЗАГРУЗКИ ПАНЕЛИ ============
  async function waitForPanelLoaded(expectedId, previousCommentIds = [], { timeout = PANEL_LOAD_TIMEOUT } = {}) {
    await waitFor('.rightPane', { timeout });
    const started = performance.now();

    await waitForCondition(() => {
      const panel = document.querySelector('.rightPane');
      if (!panel) return { ok: false, diag: 'no panel' };

      const caption = panel.querySelector('.workitem-info-bar .caption');
      if (!caption) return { ok: false, diag: 'no caption' };
      const m = caption.textContent.match(/(\d{4,})/);
      if (!m) return { ok: false, diag: 'caption without id' };
      if (expectedId && m[1] !== String(expectedId)) {
        return { ok: false, diag: `caption id ${m[1]} != ${expectedId}` };
      }

      const stateText =
        (findInput(panel, 'Поле состояния')?.value || '').trim() ||
        (panel.querySelector('#witc_223_txt')?.value || '').trim() ||
        (panel.querySelector('.workitem-state-value')?.textContent || '').trim();
      if (!stateText) return { ok: false, diag: 'state empty' };

      if (panel.querySelectorAll('.work-item-form-tab').length < 3) {
        return { ok: false, diag: 'tabs < 3' };
      }
      if (!panel.querySelector('.work-item-form-tab.selected-tab')) {
        return { ok: false, diag: 'no active tab' };
      }
      if (!panel.querySelector('.discussion-control, .discussion-messages-container')) {
        return { ok: false, diag: 'no discussion' };
      }

      // Ключевая проверка: не остались ли комментарии предыдущей заявки
      if (previousCommentIds.length) {
        const prevSet = new Set(previousCommentIds.map(String));
        const currentIds = Array.from(panel.querySelectorAll('.comment-item [data-comment-id]'))
          .map(el => el.getAttribute('data-comment-id'));
        const stale = currentIds.filter(id => prevSet.has(id));
        if (stale.length) {
          return { ok: false, diag: `stale comments from prev work item (${stale.length})` };
        }
      }

      return { ok: true };
    }, { timeout, label: 'panel fields ready' });

    log(`Панель загружена за ${Math.round(performance.now() - started)} мс (id=${expectedId})`);
  }

  // ============ 6. ОТКРЫТИЕ ЗАЯВКИ ============
  async function findRowLink(itemId, scroller) {
    const sel = `a.work-item-title-link[href*="/edit/${itemId}"]`;
    let link = document.querySelector(sel);
    if (link) return link;

    if (scroller) {
      scroller.scrollTop = 0;
      scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
      await sleep(300);
      for (let pos = 0; pos <= scroller.scrollHeight; pos += SCROLL_STEP) {
        scroller.scrollTop = pos;
        scroller.dispatchEvent(new Event('scroll', { bubbles: true }));
        await sleep(250);
        link = document.querySelector(sel);
        if (link) return link;
      }
    }
    return null;
  }

  async function openWorkItem(item, scroller, previousCommentIds = []) {
    const link = await findRowLink(item.id, scroller);
    if (!link) throw new Error(`Не найдена строка для заявки ${item.id}`);

    link.scrollIntoView({ block: 'center' });
    await sleep(200);

    const opts = { bubbles: true, cancelable: true, view: window, button: 0 };
    link.dispatchEvent(new MouseEvent('mousedown', opts));
    link.dispatchEvent(new MouseEvent('mouseup', opts));
    link.dispatchEvent(new MouseEvent('click', opts));

    await waitForPanelLoaded(item.id, previousCommentIds);
  }

  // ============ 7. ГЛАВНЫЙ ЦИКЛ ============
  async function main() {
    const scroller = getScroller() || document.scrollingElement;
    log('Скролл-контейнер:', scroller);

    await scrollToTop(scroller);

    const items = await collectAllRows(scroller);
    if (!items.length) { warn('Заявок не найдено'); return; }

    const report = [];
    let previousCommentIds = [];   // id комментариев предыдущей заявки

    for (let i = 0; i < items.length; i++) {
      const it = items[i];
      log(`(${i + 1}/${items.length}) Открываю ${it.id} — ${it.title}`);

      try {
        await openWorkItem(it, scroller, previousCommentIds);
        const panel = getPanel();
        const { all: comments, latest } = await waitForComments(panel, {
          previousCommentIds
        });

        // обновляем «предыдущие» id комментариев
        previousCommentIds = comments.map(c => c.id).filter(Boolean).map(String);

        const data = {
          id: it.id,
          title: getTitle(panel),
          state: getState(panel),
          assignedTo: getAssignedTo(panel),
          area: getArea(panel),
          iteration: getIteration(panel),
          changedBy: getChangedBy(panel),
          commentsCount: comments.length,
          latestComment: latest ? latest.body : '',
          latestAuthor: latest ? latest.author : '',
          latestTime: latest ? latest.tsRaw : '',
          comments
        };

        report.push(data);
        log(`   ✓ ${data.state || '?'} | ${data.assignedTo || '?'} | комм.: ${data.commentsCount}, свежий: "${data.latestComment.slice(0, 60)}"`);
      } catch (e) {
        warn(`   ✗ Ошибка ${it.id}: ${e.message}`);
        report.push({ id: it.id, title: it.title, error: e.message });
      }

      await sleep(DELAY_BETWEEN_ROWS);
    }

    // ============ ВЫГРУЗКА ============

    console.table(report.map(r => ({
      id: r.id,
      title: r.title,
      state: r.state,
      assignedTo: r.assignedTo,
      'комм. всего': r.commentsCount ?? '—',
      'последний': r.latestComment ? r.latestComment.slice(0, 100) : '—',
      error: r.error || ''
    })));

    // Группировка по одинаковому тексту последнего комментария
    const grouped = new Map();
    const noComment = [];
    const errored = [];

    for (const r of report) {
      if (r.error) { errored.push(r); continue; }
      const text = (r.latestComment || '').trim();
      if (!text) { noComment.push(r); continue; }
      if (!grouped.has(text)) grouped.set(text, []);
      grouped.get(text).push(r);
    }

    const groupedLines = [];
    for (const [text, items] of grouped) {
      items.sort((a, b) => a.id.localeCompare(b.id, undefined, { numeric: true }));
      const ids = items.map(x => x.id).join(', ');
      groupedLines.push(`${ids} - ${text}`);
    }

    console.log('%c=== Сгруппированные комментарии ===', 'color:#0a0;font-weight:bold');
    if (groupedLines.length) {
      groupedLines.forEach(line => console.log(line));
    } else {
      console.log('(нет заявок с комментариями)');
    }

    if (noComment.length) {
      console.log('%c--- Без комментариев ---', 'color:#888;font-weight:bold');
      console.log(noComment.map(r => r.id).join(', '));
    }
    if (errored.length) {
      console.log('%c--- Ошибки ---', 'color:#c00;font-weight:bold');
      errored.forEach(r => console.log(`${r.id} — ${r.error}`));
    }

    window.__tfsReport    = report;
    window.__tfsGrouped   = groupedLines;
    window.__tfsNoComment = noComment.map(r => r.id);
    window.__tfsErrored   = errored;

    // JSON
    const blobJson = new Blob([JSON.stringify(report, null, 2)], { type: 'application/json' });
    const aJson = document.createElement('a');
    aJson.href = URL.createObjectURL(blobJson);
    aJson.download = `tfs_report_${Date.now()}.json`;
    document.body.appendChild(aJson);
    aJson.click();
    aJson.remove();

    // TXT с группировкой
    const txt = groupedLines.join('\n')
      + (noComment.length ? `\n\nБез комментариев:\n${noComment.map(r => r.id).join(', ')}` : '')
      + (errored.length ? `\n\nОшибки:\n${errored.map(r => `${r.id} — ${r.error}`).join('\n')}` : '');

    const blobTxt = new Blob(['\ufeff' + txt], { type: 'text/plain;charset=utf-8' });
    const aTxt = document.createElement('a');
    aTxt.href = URL.createObjectURL(blobTxt);
    aTxt.download = `tfs_grouped_${Date.now()}.txt`;
    document.body.appendChild(aTxt);
    aTxt.click();
    aTxt.remove();

    // CSV
    const csvEsc = (s) => `"${String(s ?? '').replace(/"/g, '""').replace(/\r?\n/g, ' ')}"`;
    const csv = [
      ['id', 'title', 'state', 'assignedTo', 'area', 'iteration', 'changedBy',
       'commentsCount', 'latestComment', 'latestAuthor', 'latestTime', 'error']
        .map(csvEsc).join(';'),
      ...report.map(r => [
        r.id, r.title, r.state, r.assignedTo, r.area, r.iteration, r.changedBy,
        r.commentsCount ?? '',
        r.latestComment ?? '',
        r.latestAuthor ?? '',
        r.latestTime ?? '',
        r.error || ''
      ].map(csvEsc).join(';'))
    ].join('\r\n');

    const blobCsv = new Blob(['\ufeff' + csv], { type: 'text/csv;charset=utf-8' });
    const aCsv = document.createElement('a');
    aCsv.href = URL.createObjectURL(blobCsv);
    aCsv.download = `tfs_report_${Date.now()}.csv`;
    document.body.appendChild(aCsv);
    aCsv.click();
    aCsv.remove();

    log('Готово. window.__tfsReport, window.__tfsGrouped');
  }

  main().catch(e => console.error('[TFS-Report] FATAL:', e));
})();