finance banking

documentation technical

corporate business

English

The domain name 'ogquote.com' uses the commercial generic top-level domain (.com). Count 7 characters in 'ogquote' with four vowels and three consonants. Segmentation suggests two words: og, quote. Average segment length settles at 3.5 characters. No strong language cues emerged from the frequency lists.

html/4f/2c/4f2c5d52-cb70-4f6d-b9f6-1cd3c82983d2.html.gz

require-trusted-types-for 'script'; report-uri https://csp.withgoogle.com/csp/apps-themes

98ccf17aa10c20bb1301762618fcc9b6ab3a4e7f26b6071d64d0b41154df3875

27a9c3b61843c6312b87f142d40fe77c0f0f054c9f3cdeccc4bfd5f3322859c8

c9506197caf809a075b6dee1da0d36fb19da7158ffe8a88e7b0c96c5d8623c99

2d0069631ee7eed30af14f026f4792555380607760bf5b60fbf2218b2e295ee2

viewport

NameCheap, Inc.

OGQUOTE.COM

Abuse

Admin

Cloudflare-NOC

Cloudflare, Inc.

CLOUDFLARENET


// ─── STATE ───────────────────────────────────────────────────────────────────
let rows = [];
let nextId = 1;
const globalMarginLocked = {}; // rowId => true if user manually set sell price

// ─── NAVIGATION ──────────────────────────────────────────────────────────────
function showPage(name) {
  document.querySelectorAll('.page').forEach(p => p.classList.remove('active'));
  document.querySelectorAll('.nav-pill').forEach(p => p.classList.remove('active'));
  document.getElementById('page-' + name).classList.add('active');
  const idx = name === 'import' ? 0 : 1;
  document.querySelectorAll('.nav-pill')[idx].classList.add('active');
  if (name === 'builder') refreshTable();
}

// ─── FILE UPLOAD ──────────────────────────────────────────────────────────────
const uploadZone = document.getElementById('uploadZone');
uploadZone.addEventListener('dragover', e => { e.preventDefault(); uploadZone.classList.add('drag-over'); });
uploadZone.addEventListener('dragleave', () => uploadZone.classList.remove('drag-over'));
uploadZone.addEventListener('drop', e => {
  e.preventDefault();
  uploadZone.classList.remove('drag-over');
  const file = e.dataTransfer.files[0];
  if (file) processFile(file);
});

function handleFileUpload(input) {
  if (input.files[0]) processFile(input.files[0]);
}

async function processFile(file) {
  const fileDisplay = document.getElementById('fileNameDisplay');
  document.getElementById('fileNameText').textContent = file.name;
  fileDisplay.classList.add('visible');

  const ext = file.name.split('.').pop().toLowerCase();
  setStatus('loading', 'Reading file...', file.name);

  try {
    let textContent = '';

    if (ext === 'csv' || ext === 'txt') {
      textContent = await file.text();
    } else if (ext === 'xls' || ext === 'xlsx') {
      textContent = await readExcel(file);
      if (!textContent || textContent.trim().length < 5) {
        throw new Error('Could not read spreadsheet — make sure it has data on the first sheet');
      }
    } else if (ext === 'pdf' || ext === 'doc' || ext === 'docx') {
      textContent = await file.text().catch(() => '');
      // Strip binary garbage characters that cause API 400 errors
      textContent = textContent.replace(/[^\x09\x0A\x0D\x20-\x7E]/g, ' ').replace(/\s+/g, ' ');
      if (textContent.trim().length < 20) {
        throw new Error('Could not extract text from this file. Try saving it as CSV or copying data into a new spreadsheet.');
      }
    } else {
      throw new Error(`File type .${ext} is not supported. Use CSV, XLSX, XLS, PDF, DOC, DOCX, or TXT.`);
    }

    // Sanitize: remove non-printable chars, keep newlines and tabs
    textContent = textContent.replace(/[^\x09\x0A\x0D\x20-\x7E]/g, '').trim();

    // Truncate to safe size (avoid API token limits)
    if (textContent.length > 12000) {
      textContent = textContent.substring(0, 12000) + '\n[truncated...]';
    }

    setStatus('loading', 'Extracting line items with AI...', 'Analyzing product data');
    const extracted = await callClaudeAPI(textContent, file.name);

    if (extracted && extracted.length > 0) {
      extracted.forEach(item => addRow(item));
      setStatus('success', `✓ Imported ${extracted.length} items`, 'Ready to build your quote');
      toast(`${extracted.length} items imported successfully`, 'success');
      setTimeout(() => showPage('builder'), 1200);
    } else {
      setStatus('error', 'No line items found', 'Check that the file has product/part data, or add items manually');
    }
  } catch (err) {
    setStatus('error', 'Error processing file', err.message);
    toast('Error: ' + err.message, 'error');
    console.error('File processing error:', err);
  }
}

async function readExcel(file) {
  return new Promise((resolve, reject) => {
    const reader = new FileReader();
    reader.onload = e => {
      try {
        const data = new Uint8Array(e.target.result);
        const wb = XLSX.read(data, { type: 'array' });
        const ws = wb.Sheets[wb.SheetNames[0]];

        // Convert to JSON rows for better control
        const jsonRows = XLSX.utils.sheet_to_json(ws, { header: 1, defval: '', blankrows: false });

        // Filter out rows that are basically empty (less than 2 non-empty cells)
        const cleanRows = jsonRows.filter(row => {
          const nonEmpty = row.filter(cell => String(cell).trim() !== '');
          return nonEmpty.length >= 2;
        });

        // Trim each cell, remove trailing empty cells per row
        const trimmedRows = cleanRows.map(row => {
          const cells = row.map(c => String(c).trim().replace(/"/g, "'"));
          while (cells.length && cells[cells.length-1] === '') cells.pop();
          return cells;
        });

        // Cap at 200 rows, convert to compact CSV, hard cap at 6000 chars
        const csv = trimmedRows.slice(0, 200).map(row => row.join(',')).join('\n');
        resolve(csv.substring(0, 6000));

      } catch(err) { reject(new Error('Failed to parse spreadsheet: ' + err.message)); }
    };
    reader.onerror = () => reject(new Error('Failed to read file'));
    reader.readAsArrayBuffer(file);
  });
}

// ─── CLAUDE API ───────────────────────────────────────────────────────────────
async function callClaudeAPI(content, filename) {
  const prompt = `You are a data extraction assistant. Extract product/part line items from this document.

File: ${filename}
Content:
${content}

Extract ALL product line items and return ONLY a valid JSON array with no markdown, no explanation, no backticks. Use exactly this structure:
[{"partNumber":"","description":"","unitCost":0,"quantity":1}]

Rules:
- partNumber: part number, SKU, or model number as a string (empty string if none)
- description: product or service description as a string
- unitCost: numeric price or cost (0 if not found) — no dollar signs, just the number
- quantity: numeric quantity (1 if not specified)
- Include every distinct product, part, or service line you find
- If no products found, return []
- Return ONLY the JSON array, nothing else`;

  let respText = '';
  try {
    const resp = await fetch('api-proxy.php', {
      method: 'POST',
      headers: { 'Content-Type': 'application/json' },
      body: JSON.stringify({
        model: 'claude-sonnet-4-20250514',
        max_tokens: 4000,
        messages: [{ role: 'user', content: prompt }]
      })
    });

    respText = await resp.text();

    if (!resp.ok) {
      let errMsg = `API error ${resp.status}`;
      try {
        const errData = JSON.parse(respText);
        if (errData.error?.message) {
          errMsg = `API ${resp.status}: ${errData.error.message}`;
        } else if (errData.error?.type) {
          errMsg = `API ${resp.status}: ${errData.error.type}`;
        }
      } catch(e) {}
      // Log full response to console for debugging
      console.error('API error response:', respText);
      throw new Error(errMsg);
    }

    const data = JSON.parse(respText);
    const text = data.content?.[0]?.text || '[]';
    // Strip any accidental markdown fences
    const clean = text.replace(/```json|```/gi, '').trim();
    // Find the JSON array in the response
    const match = clean.match(/\[[\s\S]*\]/);
    if (!match) return [];
    return JSON.parse(match[0]);

  } catch(err) {
    // If it's a JSON parse error on the result, return empty
    if (err.message.includes('JSON')) {
      console.warn('JSON parse issue:', respText);
      return [];
    }
    throw err;
  }
}

// ─── ROW MANAGEMENT ───────────────────────────────────────────────────────────
function addRow(item = {}) {
  const globalPct = parseFloat(document.getElementById('globalMargin').value) / 100;
  const cost = parseFloat(item.unitCost) || 0;
  const sell = cost > 0 ? cost / (1 - globalPct) : 0;

  rows.push({
    id: nextId++,
    partNumber: item.partNumber || '',
    description: item.description || '',
    quantity: parseFloat(item.quantity) || 1,
    unitCost: cost,
    sellPrice: parseFloat(item.sellPrice) || sell,
    locked: !!item.sellPrice
  });
  refreshTable();
}

function addManualRow() {
  const part = document.getElementById('m_part').value.trim();
  const desc = document.getElementById('m_desc').value.trim();
  const cost = parseFloat(document.getElementById('m_cost').value) || 0;
  const qty  = parseFloat(document.getElementById('m_qty').value) || 1;

  if (!desc && !part) { toast('Enter at least a description or part #', 'error'); return; }

  addRow({ partNumber: part, description: desc, unitCost: cost, quantity: qty });
  document.getElementById('m_part').value = '';
  document.getElementById('m_desc').value = '';
  document.getElementById('m_cost').value = '';
  document.getElementById('m_qty').value = '1';
  toast('Item added', 'success');
}

function addBlankRow() {
  addRow({});
}

function deleteRow(id) {
  rows = rows.filter(r => r.id !== id);
  refreshTable();
}

function updateField(id, field, value) {
  const row = rows.find(r => r.id === id);
  if (!row) return;

  if (field === 'unitCost') {
    row.unitCost = parseFloat(value) || 0;
    if (!row.locked) {
      const pct = parseFloat(document.getElementById('globalMargin').value) / 100;
      row.sellPrice = row.unitCost / (1 - pct);
    }
  } else if (field === 'sellPrice') {
    row.sellPrice = parseFloat(value) || 0;
    row.locked = true;
  } else if (field === 'quantity') {
    row.quantity = parseFloat(value) || 1;
  } else {
    row[field] = value;
  }

  refreshSummary();
  refreshMarginCell(id);
  refreshLineTotal(id);
}

function applyGlobalMargin(val) {
  document.getElementById('globalMarginDisplay').textContent = val + '%';
  const pct = parseFloat(val) / 100;
  rows.forEach(row => {
    if (!row.locked) {
      row.sellPrice = row.unitCost > 0 ? row.unitCost / (1 - pct) : 0;
      const input = document.querySelector(`[data-id="${row.id}"][data-field="sellPrice"]`);
      if (input) input.value = row.sellPrice.toFixed(2);
      refreshMarginCell(row.id);
      refreshLineTotal(row.id);
    }
  });
  refreshSummary();
}

// ─── TABLE RENDER ─────────────────────────────────────────────────────────────
function refreshTable() {
  const body = document.getElementById('quoteBody');
  const empty = document.getElementById('emptyState');
  document.getElementById('itemCountLabel').textContent = rows.length + ' line item' + (rows.length !== 1 ? 's' : '');

  if (rows.length === 0) {
    body.innerHTML = '';
    empty.style.display = 'block';
    refreshSummary();
    return;
  }
  empty.style.display = 'none';

  body.innerHTML = rows.map(row => {
    const margin = calcMargin(row);
    const marginClass = margin >= 30 ? 'margin-good' : margin >= 15 ? 'margin-warn' : 'margin-bad';
    const lineTotal = row.sellPrice * row.quantity;

    return `<tr data-row="${row.id}">
      <td><input type="text" value="${esc(row.partNumber)}" data-id="${row.id}" data-field="partNumber" onchange="updateField(${row.id},'partNumber',this.value)" placeholder="Part #"></td>
      <td><input type="text" value="${esc(row.description)}" data-id="${row.id}" data-field="description" onchange="updateField(${row.id},'description',this.value)" placeholder="Description" style="width:100%"></td>
      <td><input type="number" class="num" value="${row.quantity}" data-id="${row.id}" data-field="quantity" oninput="updateField(${row.id},'quantity',this.value)" min="1" style="width:70px"></td>
      <td><input type="number" class="num" value="${row.unitCost.toFixed(2)}" data-id="${row.id}" data-field="unitCost" oninput="updateField(${row.id},'unitCost',this.value)" min="0" step="0.01" style="width:100px"></td>
      <td><input type="number" class="num" value="${row.sellPrice.toFixed(2)}" data-id="${row.id}" data-field="sellPrice" oninput="updateField(${row.id},'sellPrice',this.value)" min="0" step="0.01" style="width:100px"></td>
      <td class="margin-cell ${marginClass}" id="margin_${row.id}">${margin.toFixed(1)}%</td>
      <td class="line-total" id="total_${row.id}">$${fmt(lineTotal)}</td>
      <td><button class="del-btn" onclick="deleteRow(${row.id})" title="Remove">
        <svg width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2"><polyline points="3 6 5 6 21 6"/><path d="M19 6v14a2 2 0 01-2 2H7a2 2 0 01-2-2V6m3 0V4a1 1 0 011-1h4a1 1 0 011 1v2"/></svg>
      </button></td>
    </tr>`;
  }).join('');

  refreshSummary();
}

function refreshMarginCell(id) {
  const row = rows.find(r => r.id === id);
  if (!row) return;
  const el = document.getElementById('margin_' + id);
  if (!el) return;
  const m = calcMargin(row);
  el.textContent = m.toFixed(1) + '%';
  el.className = 'margin-cell ' + (m >= 30 ? 'margin-good' : m >= 15 ? 'margin-warn' : 'margin-bad');
}

function refreshLineTotal(id) {
  const row = rows.find(r => r.id === id);
  if (!row) return;
  const el = document.getElementById('total_' + id);
  if (el) el.textContent = '$' + fmt(row.sellPrice * row.quantity);
}

function refreshSummary() {
  const totalCost = rows.reduce((s, r) => s + r.unitCost * r.quantity, 0);
  const totalRev  = rows.reduce((s, r) => s + r.sellPrice * r.quantity, 0);
  const gp = totalRev - totalCost;
  const margin = totalRev > 0 ? (gp / totalRev) * 100 : 0;

  document.getElementById('sum_cost').textContent   = '$' + fmt(totalCost);
  document.getElementById('sum_rev').textContent    = '$' + fmt(totalRev);
  document.getElementById('sum_gp').textContent     = '$' + fmt(gp);
  document.getElementById('sum_margin').textContent = margin.toFixed(1) + '%';
}

// ─── EXPORT ───────────────────────────────────────────────────────────────────
function exportCSV() {
  const header = ['Part #','Description','Qty','Unit Cost','Sell Price','Margin %','Line Total'];
  const data = rows.map(r => [
    r.partNumber,
    r.description,
    r.quantity,
    r.unitCost.toFixed(2),
    r.sellPrice.toFixed(2),
    calcMargin(r).toFixed(1) + '%',
    (r.sellPrice * r.quantity).toFixed(2)
  ]);

  const csv = [header, ...data].map(row =>
    row.map(v => `"${String(v).replace(/"/g,'""')}"`).join(',')
  ).join('\n');

  download('quote-export.csv', 'text/csv', csv);
  toast('CSV exported', 'success');
}

function exportQuoteTxt() {
  const customer = document.getElementById('q_customer').value || 'Customer';
  const qnum = document.getElementById('q_num').value || 'Q-001';
  const date = document.getElementById('q_date').value || new Date().toISOString().split('T')[0];
  const totalRev = rows.reduce((s, r) => s + r.sellPrice * r.quantity, 0);
  const totalCost = rows.reduce((s, r) => s + r.unitCost * r.quantity, 0);
  const gp = totalRev - totalCost;
  const margin = totalRev > 0 ? (gp / totalRev * 100).toFixed(1) : '0.0';

  let txt = `QUOTE SUMMARY\n`;
  txt += `=================================\n`;
  txt += `Quote #:    ${qnum}\n`;
  txt += `Customer:   ${customer}\n`;
  txt += `Date:       ${date}\n`;
  txt += `=================================\n\n`;
  txt += `LINE ITEMS\n`;
  txt += `---------------------------------\n`;
  rows.forEach(r => {
    txt += `${r.partNumber ? r.partNumber + ' — ' : ''}${r.description}\n`;
    txt += `  Qty: ${r.quantity}  |  Unit: $${r.sellPrice.toFixed(2)}  |  Total: $${fmt(r.sellPrice * r.quantity)}\n\n`;
  });
  txt += `=================================\n`;
  txt += `Total Revenue:  $${fmt(totalRev)}\n`;
  txt += `Gross Profit:   $${fmt(gp)}\n`;
  txt += `Overall Margin: ${margin}%\n`;

  download(`quote-${qnum}.txt`, 'text/plain', txt);
  toast('Quote summary exported', 'success');
}

function download(filename, type, content) {
  const blob = new Blob([content], { type });
  const a = document.createElement('a');
  a.href = URL.createObjectURL(blob);
  a.download = filename;
  a.click();
}

// ─── UTILS ────────────────────────────────────────────────────────────────────
function calcMargin(row) {
  if (!row.sellPrice || row.sellPrice <= 0) return 0;
  return ((row.sellPrice - row.unitCost) / row.sellPrice) * 100;
}
function fmt(n) { return n.toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ','); }
function esc(s) { return String(s||'').replace(/"/g,'&quot;').replace(/</g,'&lt;'); }

function setStatus(type, title, sub) {
  const el = document.getElementById('parseStatus');
  const spinner = document.getElementById('statusSpinner');
  el.className = 'parse-status visible ' + type;
  document.getElementById('statusTitle').textContent = title;
  document.getElementById('statusSub').textContent = sub;
  spinner.style.display = type === 'loading' ? 'block' : 'none';
}

function toast(msg, type = 'success') {
  const el = document.getElementById('toast');
  el.textContent = msg;
  el.className = 'toast ' + type + ' show';
  setTimeout(() => el.classList.remove('show'), 3000);
}

function clearAll() {
  if (rows.length > 0 && !confirm('Start a new quote? Current data will be cleared.')) return;
  rows = [];
  nextId = 1;
  document.getElementById('q_customer').value = '';
  document.getElementById('q_num').value = '';
  document.getElementById('q_date').value = '';
  document.getElementById('parseStatus').className = 'parse-status';
  document.getElementById('fileNameDisplay').classList.remove('visible');
  document.getElementById('fileInput').value = '';
  showPage('import');
  refreshTable();
}


// ─── ACCESS CODE ──────────────────────────────────────────────────────────────
// Change this to whatever code you want users to enter:
const ACCESS_CODE = 'quotepro2026';

function checkCode() {
  const input = document.getElementById('gateInput').value.trim();
  const errorEl = document.getElementById('gateError');
  if (input === ACCESS_CODE) {
    sessionStorage.setItem('qp_auth', '1');
    document.getElementById('accessGate').style.display = 'none';
  } else {
    const inp = document.getElementById('gateInput');
    inp.classList.remove('shake');
    void inp.offsetWidth; // trigger reflow
    inp.classList.add('shake');
    errorEl.textContent = 'Incorrect code — try again.';
    inp.value = '';
    setTimeout(() => inp.classList.remove('shake'), 400);
  }
}

// Auto-unlock if already authenticated this session
if (sessionStorage.getItem('qp_auth') === '1') {
  document.getElementById('accessGate').style.display = 'none';
}

// ─── INIT ─────────────────────────────────────────────────────────────────────
document.getElementById('q_date').value = new Date().toISOString().split('T')[0];
document.getElementById('q_num').value = 'Q-' + new Date().getFullYear() + '-001';


Requests	IP Address	Location	AS Autonomous System
6	198.187.31.148	United States	AS22612Namecheap, Inc.
2	192.178.170.95	United States	AS15169Google LLC
2	104.18.1.22	United States	AS13335Cloudflare, Inc.
2	104.17.24.14	United States	AS13335Cloudflare, Inc.
2	142.251.20.94	United States	AS15169Google LLC
14	5	-	-

Security Scan Report: ogquote.com

Summary

AI Security Verdict

Moderate 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