technology software

download file sharing

government public service

adult content

documentation technical

Chinese

The domain 'sdd-data-editor.pages.dev' uses the developer-focused generic top-level domain (.dev), featuring subdomain 'sdd-data-editor'. The core label 'pages' covers 5 characters containing two vowels alongside three consonants. Segmentation suggests 1 word: pages. No strong language cues emerged from the frequency lists.

html/10/8f/108f3d1a-4d7d-4113-a30d-e1566d257f42.html.gz

cc015130aa8521e7f088f88898eba949ccdcbfb38df0bd129b44b7273c3a6f41

c3dc6a337be3dbdaf7076010e854bb0767ffee5bd352c6f7a96a2e502f7095b3

Abuse Team

CloudFlare, Inc.

pages.dev

Abuse

Admin

Cloudflare-NOC

Cloudflare, Inc.

CLOUDFLARENET


// ─────────────────────────────────────────────────────────────
//  SDD Data Converter - V5 Logic
//  Filters: IF count into SDD=Y, uses Final_destination mapping
// ─────────────────────────────────────────────────────────────

const FD_TO_DEST = {
  'BROWNSBURG': 'BROWNSBURG', 'EVANSVILLE': 'EVANSVILLE',
  'CHARLOTTE': 'CHARLOTTE', 'JEFFERSON': 'JEFFERSON',
  'LORDSTOWN': 'LORDSTOWN', 'WORCESTER': 'WORCESTER',
  'PITTSTON': 'PITTSTON',
  'SAN PEDRO': 'SAN PEDRO',
  'BLOOMFIELD': 'BLOOMFIELD', 'CARTERET': 'CARTERET',
  'PHILADELPHIA': 'PHILADELPHIA', 'WOBURN': 'WOBURN',
  'DECATUR': 'Decatur', 'SAN ANTONIO': 'SAN ANTONIO',
  'PHOENIX': 'PHOENIX', 'EL PASO': 'EL PASO', 'TUCSON': 'TUCSON',
  'FORT WORTH': 'FORT WORTH', 'BROOKS BEND': 'FORT WORTH',
};

const DEST_TO_DC = {
  'CHARLOTTE': 40, 'JEFFERSON': 40,
  'LORDSTOWN': 60, 'WORCESTER': 60,
  'BROWNSBURG': 70, 'EVANSVILLE': 70,
  'PITTSTON': 30,
  'SAN PEDRO': 20, 'BLOOMFIELD': 20, 'CARTERET': 20, 'PHILADELPHIA': 20, 'WOBURN': 20,
  'Decatur': 50, 'SAN ANTONIO': 50,
  'PHOENIX': 50, 'EL PASO': 50, 'TUCSON': 50,
  'FORT WORTH': 50,
};

const DC_SPLIT_DEST = {
  40: ['CHARLOTTE', 'JEFFERSON'],
  60: ['LORDSTOWN', 'WORCESTER'],
  70: ['BROWNSBURG', 'EVANSVILLE'],
};

const CARRIER_NORM = {
  'MAERSK': 'Maersk', 'MAERSK LINE': 'Maersk',
  'CMA CGM': 'CMA CGM', 'CMA CGM GROUP': 'CMA CGM',
  'HAPAG': 'Hapag', 'HAPAG-LLOYD': 'Hapag', 'HAPAG LLOYD': 'Hapag',
};

const COUNTRY_NORM = {
  'CHINA': 'China', 'CN': 'China', 'MAINLAND CHINA': 'China',
  'VIETNAM': 'Vietnam', 'VN': 'Vietnam', 'VIET NAM': 'Vietnam',
};

const WEST_COAST = new Set(['LA', 'LB', 'LOS ANGELES', 'LONG BEACH', 'NEWARK', 'NEW YORK', 'NORTH YORK', 'SAVANNAH', 'CHARLESTON', 'HOUSTON']);

function log(msg) {
  const el = document.getElementById('log');
  el.innerHTML += `<div>> ${msg}</div>`;
  el.scrollTop = el.scrollHeight;
}

function setProgress(pct) {
  document.getElementById('progressBar').style.width = pct + '%';
}

function showCard(id) {
  ['uploadCard','processingCard','resultCard','errorCard'].forEach(c => {
    document.getElementById(c).classList.add('hidden');
  });
  document.getElementById(id).classList.remove('hidden');
}

function reset() {
  document.getElementById('fileInput').value = '';
  document.getElementById('log').innerHTML = '';
  setProgress(0);
  showCard('uploadCard');
}

function error(msg) {
  document.getElementById('errorMsg').textContent = msg;
  showCard('errorCard');
}

function convert(data) {
  // data: array of arrays from SheetJS
  const headers = data[0].map(h => String(h || '').trim());
  
  // Find column indices
  const findCol = (names) => {
    for (const n of names) {
      const idx = headers.findIndex(h => h.includes(n));
      if (idx >= 0) return idx;
    }
    return -1;
  };

  const etdWkCol = findCol(['ETD', 'WK', 'Week', 'ETD_WK']);
  const fdCol = findCol(['Final', 'Destination', 'FINAL DEST', 'Final_Destination', 'FD']);
  const carrierCol = findCol(['Carrier', 'CARRIER', '船公司']);
  const countryCol = findCol(['Country', 'COUNTRY', '国家', 'CN/VN']);
  const countCol = findCol(['IF count', 'Count', 'COUNT', 'SDD']);
  const feuCol = findCol(['FEU', 'feu', 'Teu', 'TEU']);

  log(`ETD_WK=${etdWkCol} FD=${fdCol} Carrier=${carrierCol} Country=${countryCol} Count=${countCol} FEU=${feuCol}`);

  if (etdWkCol < 0 || fdCol < 0 || countCol < 0 || feuCol < 0) {
    throw new Error('找不到必要的列！需要：ETD_WK、Final_destination、IF count into SDD、FEU');
  }

  const rows = data.slice(1).filter(r => r.length > 1);
  const aggregated = [];

  rows.forEach((row, i) => {
    const etdWk = parseInt(row[etdWkCol]);
    const fdRaw = String(row[fdCol] || '').trim().toUpperCase();
    const countFlag = String(row[countCol] || '').trim();
    const feuRaw = parseFloat(row[feuCol]) || 0;

    if (countFlag !== 'Y') return;
    if (feuRaw === 0) return;

    let country = 'China';
    if (countryCol >= 0) {
      const cRaw = String(row[countryCol] || '').trim().toUpperCase();
      country = COUNTRY_NORM[cRaw] || (cRaw.includes('VIET') ? 'Vietnam' : 'China');
    }

    let carrier = 'Maersk';
    if (carrierCol >= 0) {
      const cRaw = String(row[carrierCol] || '').trim().toUpperCase();
      carrier = CARRIER_NORM[cRaw] || (cRaw.includes('CMA') ? 'CMA CGM' : cRaw.includes('HAPAG') ? 'Hapag' : 'Maersk');
    }

    let dest = FD_TO_DEST[fdRaw];
    if (!dest) {
      // Try to find by DC code
      if (fdRaw && !WEST_COAST.has(fdRaw) && isNaN(parseInt(fdRaw))) {
        dest = fdRaw; // use as-is if not West Coast
      } else {
        return; // skip West Coast
      }
    }

    if (!dest) return;

    aggregated.push({ ETD_WK: etdWk, Dest: dest, Carrier: carrier, Country: country, FEU: feuRaw });
  });

  // Sort by WK, Dest, Carrier, Country
  aggregated.sort((a, b) => {
    if (a.ETD_WK !== b.ETD_WK) return a.ETD_WK - b.ETD_WK;
    if (a.Dest !== b.Dest) return a.Dest.localeCompare(b.Dest);
    if (a.Carrier !== b.Carrier) return a.Carrier.localeCompare(b.Carrier);
    return a.Country.localeCompare(b.Country);
  });

  return { aggregated, with_loadport: [] };
}

function checkWeeklyTotals(data) {
  const weeks = [...new Set(data.aggregated.map(r => r.ETD_WK))].sort();
  const container = document.getElementById('weeklyCheck');
  container.innerHTML = `<h3 style="margin:16px 0 8px;font-size:14px;color:#475569">周数据汇总（供核对）</h3>`;
  
  weeks.forEach(wk => {
    const cn = data.aggregated.filter(r => r.ETD_WK === wk && r.Country === 'China').reduce((s,r) => s+r.FEU, 0);
    const vn = data.aggregated.filter(r => r.ETD_WK === wk && r.Country === 'Vietnam').reduce((s,r) => s+r.FEU, 0);
    const div = document.createElement('div');
    div.className = 'week-row';
    div.innerHTML = `<span class="wk">WK${wk}</span><span class="nums"><span class="cn">CN=${cn.toFixed(1)}</span> &nbsp;<span class="vn">VN=${vn.toFixed(1)}</span></span>`;
    container.appendChild(div);
  });
}

async function processFile(file) {
  showCard('processingCard');
  log(`读取文件: ${file.name}`);
  setProgress(20);

  let workbook;
  try {
    const buffer = await file.arrayBuffer();
    setProgress(40);
    log('解析 Excel...');
    workbook = XLSX.read(buffer, { type: 'array', cellDates: true });
    setProgress(60);
    log(`找到 ${workbook.SheetNames.length} 个工作表`);
  } catch(e) {
    error('文件读取失败：' + e.message);
    return;
  }

  // Find the right sheet - prefer the one with ETD data
  let sheetName = workbook.SheetNames[0];
  for (const name of workbook.SheetNames) {
    const sheet = workbook.Sheets[name];
    const range = sheet['!ref'];
    if (range && (range.includes('ETD') || range.includes('WK') || range.includes('Week'))) {
      sheetName = name;
      break;
    }
  }
  log(`使用工作表: ${sheetName}`);
  setProgress(70);

  const sheet = workbook.Sheets[sheetName];
  const data = XLSX.utils.sheet_to_json(sheet, { header: 1, defval: '' });
  
  log(`共 ${data.length} 行，开始转换...`);
  setProgress(80);

  let result;
  try {
    result = convert(data);
    log(`转换完成：${result.aggregated.length} 条记录`);
  } catch(e) {
    error('转换失败：' + e.message);
    return;
  }

  setProgress(100);

  // Show result
  document.getElementById('resultMsg').textContent = 
    `生成了 ${result.aggregated.length} 条数据记录，涵盖 WK ${Math.min(...result.aggregated.map(r=>r.ETD_WK))} ~ WK ${Math.max(...result.aggregated.map(r=>r.ETD_WK))}`;

  const json = JSON.stringify(result, null, 2);
  const blob = new Blob([json], { type: 'application/json' });
  const url = URL.createObjectURL(blob);
  document.getElementById('downloadBtn').href = url;

  checkWeeklyTotals(result);
  showCard('resultCard');
}

// Drag & drop
const dropZone = document.getElementById('dropZone');
const fileInput = document.getElementById('fileInput');

dropZone.addEventListener('dragover', e => { e.preventDefault(); dropZone.classList.add('dragover'); });
dropZone.addEventListener('dragleave', () => dropZone.classList.remove('dragover'));
dropZone.addEventListener('drop', e => {
  e.preventDefault();
  dropZone.classList.remove('dragover');
  const file = e.dataTransfer.files[0];
  if (file) processFile(file);
});

fileInput.addEventListener('change', e => {
  const file = e.target.files[0];
  if (file) processFile(file);
});


Requests	IP Address	Location	AS Autonomous System
2	172.66.47.79	United States	AS13335Cloudflare, Inc.
1	104.21.80.4	United States	AS13335Cloudflare, Inc.
3	2	-	-

Security Scan Report: sdd-data-editor.pages.dev

Summary

AI Security Verdict

Low Risk

Risk Factors

Safety Factors

Details

Screenshot

Page Load Overview

Language Analysis

Primary Language

Detection Details

Website Classification

Primary Category

All Detected Categories

Detected Features

Domain & IP Information

Detected Technologies3

Content Similarity HashesFor malware variant detection

TLSH (Trend Micro Locality Sensitive Hash)

ssdeep (Context Triggered Piecewise Hashing)

sdhash (Similarity Digest Hashing)

Image Hashes

Perceptual Hashes

Other Hashes

Scan History