corporate business

technology software

documentation technical

finance banking

cryptocurrency blockchain

English

Within the developer-focused generic top-level domain (.dev), 'rezifixedops.pages.dev' is registered; it also runs on subdomain 'rezifixedops'. The registrable portion 'pages' spans 5 characters containing two vowels alongside 3 consonants. Segmentation suggests one word: pages. No strong language cues emerged from the frequency lists.

html/49/36/4936de84-b3c3-4fdb-ad70-251bda72f664.html.gz

sha256=:ZgsSQ3sddH4+aLi+BoXAjLcoFAEQrSE/FnsUtm+LHY4=:

e87e550794322e574a1fda0c1549a3c70dae5a93d9113417a429016838eab8cb

a8e29918d098b2b06e1012bdaeffb4aec0445c5d5654709023e0bd1f442a80e8

0e2326c6868072bec1592760c6729043caeea2960a2b46cee6a2192aac6abff0

98ccf17aa10c20bb1301762618fcc9b6ab3a4e7f26b6071d64d0b41154df3875

d0c08894bbbcac6757709212f3b605e7fd2acad7bd050d3f937a061ba8afe66c

660b12437b1d747e3e68b8be0685c08cb728140110ad213f167b14b66f8b1d8e

7ba3e66ed567219441089d2840ca74f2e68b6fd66d1d2c35dd78f1c3fac0445c

5bc1d633ff6d52df0f4b7ea80e5b01f2d05f75646bb8f6c9b9798cdb3e152ecb

9231cfbba8d041f328c26d00e22d1044ac30e863c536e89006a721eaa20f7320

48632f34324e415655b873ff974baac10355e357387676126ce8aa8894a9c226

629379cca5769fdc24d19c77586753431ed02e0cda236c183f49f29c7c581fec

3304d0cca86957df4a458a6ce230d696abfd4c256e8dc7cc8da8d8fc996f1d46

viewport

theme-color

apple-mobile-web-app-capable

apple-mobile-web-app-status-bar-style

apple-mobile-web-app-title

HSTS header missing - vulnerable to protocol downgrade attacks

CSP header missing - vulnerable to XSS attacks

Abuse Team

CloudFlare, Inc.

pages.dev

Abuse

Admin

Cloudflare-NOC

Cloudflare, Inc.

CLOUDFLARENET


// 
//  CUSTOM ALERT (replaces browser alert)
// 
(function(){
  var overlay=document.createElement('div');
  overlay.id='reziAlertOverlay';
  overlay.style.cssText='display:none;position:fixed;inset


if ('serviceWorker' in navigator) {
  navigator.serviceWorker.register('/sw.js').catch(function(){});
}

// ===== MOBILE EXECUTIVE VIEW =====
let _mobCharts = {};
const IS_MOBILE = window.innerWidth <= 768;

function showMobSection(id) {
  document.querySelectorAll('.mob-section').forEach(s => s.style.display='none');
  document.querySelectorAll('.mob-tab').forEach(t => t.classList.remove('active'));
  document.getElementById('mobSection-'+id).style.display='';
  document.getElementById('mobTab-'+id).classList.add('active');
}

function mobKPI(label, val, fmt, color, sub) {
  const fv = fmt==='dollar' ? '$'+Math.ceil(Math.abs(val)).toLocaleString() : fmt==='dec1' ? val.toFixed(1) : Math.round(val).toLocaleString();
  return `<div class="mob-kpi"><div class="mob-kpi-label">${label}</div><div class="mob-kpi-val" style="color:${color||'var(--text)'}">${fv}</div>${sub?'<div class="mob-kpi-sub">'+sub+'</div>':''}</div>`;
}

function switchToDesktop() {
  document.getElementById('mobileView').style.display='none';
  document.getElementById('dashboardWrapper').style.display='flex';
  localStorage.setItem('rezi_forceDesktop','1');
}

// Override grantAccess to detect mobile
const _origGrantAccess = typeof grantAccess === 'function' ? grantAccess : function(){};
grantAccess = function() {
  _origGrantAccess();
  if (IS_MOBILE && !localStorage.getItem('rezi_forceDesktop')) {
    document.getElementById('dashboardWrapper').style.display='none';
    document.getElementById('mobileView').style.display='';
    loadMobileData();
  }
};

async function runMobSearch() {
  var q = document.getElementById('mobSearchInput').value.trim();
  var rDiv = document.getElementById('mobSearchResults');
  if (!q || q.length < 2) { rDiv.innerHTML = '<div style="color:var(--muted);text-align:center;padding:20px;">Enter at least 2 characters</div>'; return; }
  rDiv.innerHTML = '<div style="text-align:center;padding:20px;color:var(--muted);">Searching...</div>';
  var hdr = {'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY};
  var encoded = encodeURIComponent(q);
  var isNum = /^\d+$/.test(q);
  var html = '';
  try {
    // Search open ROs by RO_ID or VIN
    var openROs = [];
    if (isNum) {
      openROs = await sbGet('open_ro', 'ro_id=eq.' + encoded, 'ro_id');
    } else if (q.length >= 6) {
      openROs = await sbGet('open_ro', 'vin=ilike.*' + encoded + '*', 'ro_id');
    }
    // Search closed CP ROs
    var cpROs = [];
    if (isNum) {
      cpROs = await sbGet('cpro_closed', 'ro_id=eq.' + encoded + '&limit=20', 'ro_id');
    } else if (q.length >= 6) {
      cpROs = await sbGet('cpro_closed', 'vin=ilike.*' + encoded + '*&limit=20', 'ro_id');
    }
    // Search customers by name
    var custs = [];
    if (!isNum && q.length >= 2) {
      custs = await sbGet('customers', 'or=(first_name.ilike.*' + encoded + '*,last_name.ilike.*' + encoded + '*)&limit=15', 'customer_id');
    }
    // Search by TAG_NO (stock number)
    var tagROs = [];
    if (q.length >= 3) {
      tagROs = await sbGet('open_ro', 'tag_no=ilike.*' + encoded + '*', 'ro_id');
      if (tagROs.length) openROs = openROs.concat(tagROs);
    }
    // Deduplicate open ROs
    var seen = {};
    openROs = openROs.filter(function(r) { var k = r.store_id+'-'+r.ro_id; if (seen[k]) return false; seen[k]=1; return true; });
    // Batch VIN lookups
    var allVins = new Set();
    openROs.forEach(function(r) { if (r.vin) allVins.add(r.vin); });
    cpROs.forEach(function(r) { if (r.vin) allVins.add(r.vin); });
    var vinMap = {};
    if (allVins.size > 0) {
      try {
        var vRows = await sbGet('vin_lookup', 'vin=in.(' + [...allVins].join(',') + ')&limit=500', 'vin');
        vRows.forEach(function(v) { vinMap[v.vin] = (v.year||'')+' '+(v.make||'')+' '+(v.model||''); });
      } catch(e) {}
    }
    // Render results
    if (openROs.length) {
      html += '<div style="font-weight:600;margin-bottom:8px;color:var(--accent);">Open ROs (' + openROs.length + ')</div>';
      openROs.forEach(function(r) {
        var veh = vinMap[r.vin] || '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">RO# ' + r.ro_id + ' <span style="font-size:11px;color:var(--muted);">' + (STORE_ABBR_MAP[r.store_id]||r.store_id) + '</span></div>';
        if (veh) html += '<div style="font-size:12px;color:var(--muted);">' + veh.trim() + '</div>';
        if (r.vin) html += '<div style="font-size:11px;color:var(--muted);font-family:monospace;">' + r.vin + '</div>';
        html += '</div>';
      });
    }
    // Dedup CP ROs by RO_ID+STORE_ID
    var cpSeen = {};
    cpROs = cpROs.filter(function(r) { var k = r.store_id+'-'+r.ro_id; if (cpSeen[k]) return false; cpSeen[k]=1; return true; });
    if (cpROs.length) {
      html += '<div style="font-weight:600;margin:12px 0 8px;color:#06b6d4;">Closed ROs (' + cpROs.length + ')</div>';
      cpROs.forEach(function(r) {
        var veh = vinMap[r.vin] || '';
        var dt = r.closed_date ? new Date(r.closed_date).toLocaleDateString('en-US',{month:'short',day:'numeric',year:'2-digit'}) : '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">RO# ' + r.ro_id + ' <span style="font-size:11px;color:var(--muted);">' + (STORE_ABBR_MAP[r.store_id]||r.store_id) + (dt ? '  ' + dt : '') + '</span></div>';
        if (veh) html += '<div style="font-size:12px;color:var(--muted);">' + veh.trim() + '</div>';
        html += '</div>';
      });
    }
    if (custs.length) {
      html += '<div style="font-weight:600;margin:12px 0 8px;color:var(--green);">Customers (' + custs.length + ')</div>';
      custs.forEach(function(c) {
        var name = ((c.first_name||'') + ' ' + (c.last_name||'')).trim() || c.customer_name || '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">' + name + ' <span style="font-size:11px;color:var(--muted);">#' + (c.customer_id||'') + '  ' + (STORE_ABBR_MAP[c.store_id]||c.store_id||'') + '</span></div>';
        html += '</div>';
      });
    }
    if (!html) html = '<div style="text-align:center;padding:20px;color:var(--muted);">No results found</div>';
  } catch(e) { html = '<div style="text-align:center;padding:20px;color:var(--red);">Search error</div>'; console.error(e); }
  rDiv.innerHTML = html;
}

async function loadMobileData() {
  const hdr = {'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY,'Content-Type':'application/json'};
  const now = new Date();
  document.getElementById('mobDate').textContent = now.toLocaleDateString('en-US',{weekday:'long',month:'long',day:'numeric',year:'numeric'});

  const curMonth = now.toISOString().slice(0,7);
  const startDate = curMonth+'-01';
  const endDate = now.toISOString().slice(0,10);
  const sIds = [1027,1029,1035,1104]; // all stores

  // Load CP data for current month
  try {
    const cpResp = await fetch(SB_URL+'/rest/v1/rpc/cp_store_monthly', {method:'POST',headers:hdr,body:JSON.stringify({p_start_date:startDate,p_end_date:endDate})});
    const cpData = await cpResp.json();
    let cpROs=0, cpGross=0, cpHours=0, cpLbrSales=0;
    cpData.forEach(r => { cpROs+=+r.ro_count; cpGross+=(+r.labor_gross)+(+r.parts_gross); cpHours+=+r.total_hours; cpLbrSales+=+r.labor_sales; });
    const elr = cpHours ? cpLbrSales/cpHours : 0;
    document.getElementById('mobServiceKPIs').innerHTML =
      mobKPI('CP ROs', cpROs, 'num', '#06b6d4', curMonth.slice(0,7)) +
      mobKPI('CP Gross', cpGross, 'dollar', '#22c55e') +
      mobKPI('CP Hours', cpHours, 'dec1', '#3b82f6') +
      mobKPI('ELR', elr, 'dollar', '#8b5cf6');

    // Mini chart - ROs by store
    const byStore = {};
    cpData.forEach(r => { byStore[r.store_id] = (byStore[r.store_id]||0)+(+r.ro_count); });
    if (_mobCharts.service) _mobCharts.service.destroy();
    _mobCharts.service = new Chart(document.getElementById('mobServiceChart').getContext('2d'), {
      type:'bar', data:{labels:Object.keys(byStore).map(s=>STORE_ABBR_MAP[s]||s), datasets:[{label:'CP ROs',data:Object.values(byStore),backgroundColor:['#3b82f6','#8b5cf6','#f59e0b','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{display:false},title:{display:true,text:'CP ROs by Store',font:{size:12}}},scales:{y:{beginAtZero:true}}}
    });
  } catch(e) { console.error('Mobile CP load error',e); }

  // Load Open ROs
  try {
    const orFilter = 'store_id=in.('+sIds.join(',')+')';
    const orResp = await fetch(SB_URL+'/rest/v1/open_ro?select=store_id,ro_id,date,days_open,ro_total,cwi_flag&'+orFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}});
    const orRaw = await orResp.json();
    const orMap = {};
    orRaw.forEach(r => { const k=r.store_id+'-'+r.ro_id; if(!orMap[k]) orMap[k]=r; });
    const orROs = Object.values(orMap);
    const orTotal = orROs.length;
    const orOver7 = orROs.filter(r=>+r.days_open>7).length;
    const orOver14 = orROs.filter(r=>+r.days_open>14).length;
    const orValue = orROs.reduce((s,r)=>s+(+(r.ro_total||0)),0);

    document.getElementById('mobOpenROKPIs').innerHTML =
      mobKPI('Open ROs', orTotal, 'num', '#3b82f6') +
      mobKPI('Total Value', orValue, 'dollar', '#22c55e') +
      mobKPI('Over 7 Days', orOver7, 'num', orOver7?'#f97316':'var(--text)') +
      mobKPI('Over 14 Days', orOver14, 'num', orOver14?'#ef4444':'var(--text)');

    // Alerts for overdue
    let alertHtml = '';
    const overdue = orROs.filter(r=>+r.days_open>14).sort((a,b)=>b.days_open-a.days_open).slice(0,5);
    overdue.forEach(r => {
      alertHtml += `<div class="mob-alert mob-alert-danger"><div><div style="font-weight:600;font-size:13px;">RO# ${r.ro_id}</div><div style="font-size:10px;color:var(--muted);">${STORE_ABBR_MAP[r.store_id]||r.store_id}  $${Math.ceil(+(r.ro_total||0)).toLocaleString()}</div></div><div style="font-size:18px;font-weight:700;color:#ef4444;">${r.days_open}d</div></div>`;
    });
    if (!overdue.length) alertHtml = '<div style="text-align:center;color:var(--muted);font-size:12px;padding:12px;">No critical ROs over 14 days</div>';
    document.getElementById('mobOpenROAlerts').innerHTML = '<div style="font-size:11px;font-weight:600;color:var(--muted);margin-bottom:6px;text-transform:uppercase;">Critical ROs</div>' + alertHtml;

    // Chart - aging buckets
    const buckets = {'0-3':0,'4-7':0,'8-14':0,'15-30':0,'31+':0};
    orROs.forEach(r => { const d=+r.days_open; if(d<=3)buckets['0-3']++;else if(d<=7)buckets['4-7']++;else if(d<=14)buckets['8-14']++;else if(d<=30)buckets['15-30']++;else buckets['31+']++; });
    if (_mobCharts.openro) _mobCharts.openro.destroy();
    _mobCharts.openro = new Chart(document.getElementById('mobOpenROChart').getContext('2d'), {
      type:'bar', data:{labels:Object.keys(buckets), datasets:[{label:'ROs',data:Object.values(buckets),backgroundColor:['#22c55e','#3b82f6','#f59e0b','#f97316','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{display:false},title:{display:true,text:'Open RO Aging',font:{size:12}}},scales:{y:{beginAtZero:true}}}
    });
  } catch(e) { console.error('Mobile Open RO load error',e); }

  // Load Used Recon (current month)
  try {
    const urResp = await fetch(SB_URL+'/rest/v1/rpc/used_recon_store_monthly', {method:'POST',headers:hdr,body:JSON.stringify({p_start_date:startDate,p_end_date:endDate})});
    const urData = await urResp.json();
    let urROs=0, urTotal=0, urDays=0, urCount=0;
    urData.forEach(r => { urROs+=+r.ro_count; urTotal+=+(r.total_ro_total||0); urDays+=+(r.avg_recon_days||0)*(+r.ro_count); urCount+=+r.ro_count; });
    const avgCost = urROs ? urTotal/urROs : 0;
    const avgDays = urCount ? urDays/urCount : 0;

    document.getElementById('mobUsedKPIs').innerHTML =
      mobKPI('Recon ROs', urROs, 'num', '#ef4444', curMonth) +
      mobKPI('Recon Total', urTotal, 'dollar', '#ef4444') +
      mobKPI('Avg RO Cost', avgCost, 'dollar', '#f97316') +
      mobKPI('Avg Recon Days', avgDays, 'dec1', '#3b82f6');

    // Chart by store
    const urByStore = {};
    urData.forEach(r => { urByStore[r.store_id]=(urByStore[r.store_id]||0)+(+r.ro_count); });
    if (_mobCharts.used) _mobCharts.used.destroy();
    _mobCharts.used = new Chart(document.getElementById('mobUsedChart').getContext('2d'), {
      type:'doughnut', data:{labels:Object.keys(urByStore).sort().map(s=>STORE_ABBR_MAP[s]||s), datasets:[{data:Object.keys(urByStore).sort().map(s=>urByStore[s]),backgroundColor:['#3b82f6','#8b5cf6','#f59e0b','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{position:'bottom',labels:{usePointStyle:true,padding:8}},title:{display:true,text:'Recon ROs by Store',font:{size:12}}}}
    });
  } catch(e) { console.error('Mobile Used Recon load error',e); }

  // Load Open Used
  try {
    const ouFilter = 'store_id=in.('+sIds.join(',')+')';
    const [ouResp, ouAssignResp] = await Promise.all([
      fetch(SB_URL+'/rest/v1/used_open?select=store_id,ro_id,date,stock_no,vin&'+ouFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}}),
      fetch(SB_URL+'/rest/v1/open_used_assignments?select=store_id,ro_id,status&'+ouFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}})
    ]);
    const ouRaw = await ouResp.json();
    const ouAssigns = await ouAssignResp.json();
    const ouAssMap = {}; ouAssigns.forEach(a=>{ouAssMap[a.store_id+'-'+a.ro_id]=a.status||'';});

    const ouMap = {};
    ouRaw.forEach(r => { const k=r.store_id+'-'+r.ro_id; if(!ouMap[k]){const days=r.date?Math.max(0,Math.round((new Date()-new Date(r.date))/86400000)):0; ouMap[k]={...r,daysOpen:days};} });
    const ouROs = Object.values(ouMap);
    const ouTotal = ouROs.length;
    const ouAvgDays = ouTotal ? ouROs.reduce((s,r)=>s+r.daysOpen,0)/ouTotal : 0;
    const ouOver7 = ouROs.filter(r=>r.daysOpen>7).length;
    const ouOver14 = ouROs.filter(r=>r.daysOpen>14).length;

    document.getElementById('mobOpenUsedKPIs').innerHTML =
      mobKPI('Open Vehicles', ouTotal, 'num', '#7c3aed') +
      mobKPI('Avg Days', ouAvgDays, 'dec1', '#7c3aed') +
      mobKPI('Over 7 Days', ouOver7, 'num', ouOver7?'#f97316':'var(--text)') +
      mobKPI('Over 14 Days', ouOver14, 'num', ouOver14?'#ef4444':'var(--text)');

    // Alerts - vehicles over 7 days
    let ouAlertHtml = '';
    const ouOverdue = ouROs.filter(r=>r.daysOpen>7).sort((a,b)=>b.daysOpen-a.daysOpen).slice(0,8);
    ouOverdue.forEach(r => {
      const status = ouAssMap[r.store_id+'-'+r.ro_id]||'Unassigned';
      const cls = r.daysOpen>14?'mob-alert-danger':'mob-alert-warn';
      const acq = parseAcqSource(r.stock_no);
      ouAlertHtml += `<div class="mob-alert ${cls}"><div><div style="font-weight:600;font-size:13px;">RO# ${r.ro_id}</div><div style="font-size:10px;color:var(--muted);">${STORE_ABBR_MAP[r.store_id]||r.store_id}  ${acq}  ${status}</div></div><div style="font-size:18px;font-weight:700;color:${r.daysOpen>14?'#ef4444':'#f97316'};">${r.daysOpen}d</div></div>`;
    });
    if (!ouOverdue.length) ouAlertHtml = '<div style="text-align:center;color:var(--muted);font-size:12px;padding:12px;">All vehicles under 7 days</div>';
    document.getElementById('mobOpenUsedAlerts').innerHTML = '<div style="font-size:11px;font-weight:600;color:var(--muted);margin-bottom:6px;text-transform:uppercase;">Vehicles Needing Attention</div>' + ouAlertHtml;

    // Status chart
    const byStat = {};
    ouROs.forEach(r => { const st = ouAssMap[r.store_id+'-'+r.ro_id]||'Unassigned'; byStat[st]=(byStat[st]||0)+1; });
    const statLabels = Object.keys(byStat).sort();
    const statColors = statLabels.map(l=>OU_STATUS_COLOR[l]||'#94a3b8');
    if (_mobCharts.openused) _mobCharts.openused.destroy();
    _mobCharts.openused = new Chart(document.getElementById('mobOpenUsedChart').getContext('2d'), {
      type:'doughnut', data:{labels:statLabels, datasets:[{data:statLabels.map(l=>byStat[l]),backgroundColor:statColors}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{position:'bottom',labels:{usePointStyle:true,padding:6,font:{size:10}}},title:{display:true,text:'By Status',font:{size:12}}}}
    });
  } catch(e) { console.error('Mobile Open Used load error',e); }
}



//  Vehicle Tracker State 
var vtScanner = null;
var vtState = {
  vin: '',
  vehicle: null,       // { year, make, model, vin }
  roInfo: null,        // { ro_id, customer, advisor, tag_no }
  locat


if ('serviceWorker' in navigator) {
  navigator.serviceWorker.register('/sw.js').catch(function(){});
}

// ===== MOBILE EXECUTIVE VIEW =====
if (typeof _mobCharts === 'undefined') _mobCharts = {};
if (typeof IS_MOBILE === 'undefined') IS_MOBILE = window.innerWidth <= 768;

function showMobSection(id) {
  document.querySelectorAll('.mob-section').forEach(s => s.style.display='none');
  document.querySelectorAll('.mob-tab').forEach(t => t.classList.remove('active'));
  document.getElementById('mobSection-'+id).style.display='';
  document.getElementById('mobTab-'+id).classList.add('active');
}

function mobKPI(label, val, fmt, color, sub) {
  const fv = fmt==='dollar' ? '$'+Math.ceil(Math.abs(val)).toLocaleString() : fmt==='dec1' ? val.toFixed(1) : Math.round(val).toLocaleString();
  return `<div class="mob-kpi"><div class="mob-kpi-label">${label}</div><div class="mob-kpi-val" style="color:${color||'var(--text)'}">${fv}</div>${sub?'<div class="mob-kpi-sub">'+sub+'</div>':''}</div>`;
}

function switchToDesktop() {
  document.getElementById('mobileView').style.display='none';
  document.getElementById('dashboardWrapper').style.display='flex';
  localStorage.setItem('rezi_forceDesktop','1');
}

// grantAccess already overridden by first mobile block - skip duplicate

async function runMobSearch() {
  var q = document.getElementById('mobSearchInput').value.trim();
  var rDiv = document.getElementById('mobSearchResults');
  if (!q || q.length < 2) { rDiv.innerHTML = '<div style="color:var(--muted);text-align:center;padding:20px;">Enter at least 2 characters</div>'; return; }
  rDiv.innerHTML = '<div style="text-align:center;padding:20px;color:var(--muted);">Searching...</div>';
  var hdr = {'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY};
  var encoded = encodeURIComponent(q);
  var isNum = /^\d+$/.test(q);
  var html = '';
  try {
    // Search open ROs by RO_ID or VIN
    var openROs = [];
    if (isNum) {
      openROs = await sbGet('open_ro', 'ro_id=eq.' + encoded, 'ro_id');
    } else if (q.length >= 6) {
      openROs = await sbGet('open_ro', 'vin=ilike.*' + encoded + '*', 'ro_id');
    }
    // Search closed CP ROs
    var cpROs = [];
    if (isNum) {
      cpROs = await sbGet('cpro_closed', 'ro_id=eq.' + encoded + '&limit=20', 'ro_id');
    } else if (q.length >= 6) {
      cpROs = await sbGet('cpro_closed', 'vin=ilike.*' + encoded + '*&limit=20', 'ro_id');
    }
    // Search customers by name
    var custs = [];
    if (!isNum && q.length >= 2) {
      custs = await sbGet('customers', 'or=(first_name.ilike.*' + encoded + '*,last_name.ilike.*' + encoded + '*)&limit=15', 'customer_id');
    }
    // Search by TAG_NO (stock number)
    var tagROs = [];
    if (q.length >= 3) {
      tagROs = await sbGet('open_ro', 'tag_no=ilike.*' + encoded + '*', 'ro_id');
      if (tagROs.length) openROs = openROs.concat(tagROs);
    }
    // Deduplicate open ROs
    var seen = {};
    openROs = openROs.filter(function(r) { var k = r.store_id+'-'+r.ro_id; if (seen[k]) return false; seen[k]=1; return true; });
    // Batch VIN lookups
    var allVins = new Set();
    openROs.forEach(function(r) { if (r.vin) allVins.add(r.vin); });
    cpROs.forEach(function(r) { if (r.vin) allVins.add(r.vin); });
    var vinMap = {};
    if (allVins.size > 0) {
      try {
        var vRows = await sbGet('vin_lookup', 'vin=in.(' + [...allVins].join(',') + ')&limit=500', 'vin');
        vRows.forEach(function(v) { vinMap[v.vin] = (v.year||'')+' '+(v.make||'')+' '+(v.model||''); });
      } catch(e) {}
    }
    // Render results
    if (openROs.length) {
      html += '<div style="font-weight:600;margin-bottom:8px;color:var(--accent);">Open ROs (' + openROs.length + ')</div>';
      openROs.forEach(function(r) {
        var veh = vinMap[r.vin] || '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">RO# ' + r.ro_id + ' <span style="font-size:11px;color:var(--muted);">' + (STORE_ABBR_MAP[r.store_id]||r.store_id) + '</span></div>';
        if (veh) html += '<div style="font-size:12px;color:var(--muted);">' + veh.trim() + '</div>';
        if (r.vin) html += '<div style="font-size:11px;color:var(--muted);font-family:monospace;">' + r.vin + '</div>';
        html += '</div>';
      });
    }
    // Dedup CP ROs by RO_ID+STORE_ID
    var cpSeen = {};
    cpROs = cpROs.filter(function(r) { var k = r.store_id+'-'+r.ro_id; if (cpSeen[k]) return false; cpSeen[k]=1; return true; });
    if (cpROs.length) {
      html += '<div style="font-weight:600;margin:12px 0 8px;color:#06b6d4;">Closed ROs (' + cpROs.length + ')</div>';
      cpROs.forEach(function(r) {
        var veh = vinMap[r.vin] || '';
        var dt = r.closed_date ? new Date(r.closed_date).toLocaleDateString('en-US',{month:'short',day:'numeric',year:'2-digit'}) : '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">RO# ' + r.ro_id + ' <span style="font-size:11px;color:var(--muted);">' + (STORE_ABBR_MAP[r.store_id]||r.store_id) + (dt ? ' \u00B7 ' + dt : '') + '</span></div>';
        if (veh) html += '<div style="font-size:12px;color:var(--muted);">' + veh.trim() + '</div>';
        html += '</div>';
      });
    }
    if (custs.length) {
      html += '<div style="font-weight:600;margin:12px 0 8px;color:var(--green);">Customers (' + custs.length + ')</div>';
      custs.forEach(function(c) {
        var name = ((c.first_name||'') + ' ' + (c.last_name||'')).trim() || c.customer_name || '';
        html += '<div style="background:var(--card);border:1px solid var(--border);border-radius:8px;padding:10px 12px;margin-bottom:8px;">';
        html += '<div style="font-weight:600;">' + name + ' <span style="font-size:11px;color:var(--muted);">#' + (c.customer_id||'') + ' \u00B7 ' + (STORE_ABBR_MAP[c.store_id]||c.store_id||'') + '</span></div>';
        html += '</div>';
      });
    }
    if (!html) html = '<div style="text-align:center;padding:20px;color:var(--muted);">No results found</div>';
  } catch(e) { html = '<div style="text-align:center;padding:20px;color:var(--red);">Search error</div>'; console.error(e); }
  rDiv.innerHTML = html;
}

async function loadMobileData() {
  const hdr = {'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY,'Content-Type':'application/json'};
  const now = new Date();
  document.getElementById('mobDate').textContent = now.toLocaleDateString('en-US',{weekday:'long',month:'long',day:'numeric',year:'numeric'});

  const curMonth = now.toISOString().slice(0,7);
  const startDate = curMonth+'-01';
  const endDate = now.toISOString().slice(0,10);
  const sIds = [1027,1029,1035,1104]; // all stores

  // Load CP data for current month
  try {
    const cpResp = await fetch(SB_URL+'/rest/v1/rpc/cp_store_monthly', {method:'POST',headers:hdr,body:JSON.stringify({p_start_date:startDate,p_end_date:endDate})});
    const cpData = await cpResp.json();
    let cpROs=0, cpGross=0, cpHours=0, cpLbrSales=0;
    cpData.forEach(r => { cpROs+=+r.ro_count; cpGross+=(+r.labor_gross)+(+r.parts_gross); cpHours+=+r.total_hours; cpLbrSales+=+r.labor_sales; });
    const elr = cpHours ? cpLbrSales/cpHours : 0;
    document.getElementById('mobServiceKPIs').innerHTML =
      mobKPI('CP ROs', cpROs, 'num', '#06b6d4', curMonth.slice(0,7)) +
      mobKPI('CP Gross', cpGross, 'dollar', '#22c55e') +
      mobKPI('CP Hours', cpHours, 'dec1', '#3b82f6') +
      mobKPI('ELR', elr, 'dollar', '#8b5cf6');

    // Mini chart - ROs by store
    const byStore = {};
    cpData.forEach(r => { byStore[r.store_id] = (byStore[r.store_id]||0)+(+r.ro_count); });
    if (_mobCharts.service) _mobCharts.service.destroy();
    _mobCharts.service = new Chart(document.getElementById('mobServiceChart').getContext('2d'), {
      type:'bar', data:{labels:Object.keys(byStore).map(s=>STORE_ABBR_MAP[s]||s), datasets:[{label:'CP ROs',data:Object.values(byStore),backgroundColor:['#3b82f6','#8b5cf6','#f59e0b','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{display:false},title:{display:true,text:'CP ROs by Store',font:{size:12}}},scales:{y:{beginAtZero:true}}}
    });
  } catch(e) { console.error('Mobile CP load error',e); }

  // Load Open ROs
  try {
    const orFilter = 'store_id=in.('+sIds.join(',')+')';
    const orResp = await fetch(SB_URL+'/rest/v1/open_ro?select=store_id,ro_id,date,days_open,ro_total,cwi_flag&'+orFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}});
    const orRaw = await orResp.json();
    const orMap = {};
    orRaw.forEach(r => { const k=r.store_id+'-'+r.ro_id; if(!orMap[k]) orMap[k]=r; });
    const orROs = Object.values(orMap);
    const orTotal = orROs.length;
    const orOver7 = orROs.filter(r=>+r.days_open>7).length;
    const orOver14 = orROs.filter(r=>+r.days_open>14).length;
    const orValue = orROs.reduce((s,r)=>s+(+(r.ro_total||0)),0);

    document.getElementById('mobOpenROKPIs').innerHTML =
      mobKPI('Open ROs', orTotal, 'num', '#3b82f6') +
      mobKPI('Total Value', orValue, 'dollar', '#22c55e') +
      mobKPI('Over 7 Days', orOver7, 'num', orOver7?'#f97316':'var(--text)') +
      mobKPI('Over 14 Days', orOver14, 'num', orOver14?'#ef4444':'var(--text)');

    // Alerts for overdue
    let alertHtml = '';
    const overdue = orROs.filter(r=>+r.days_open>14).sort((a,b)=>b.days_open-a.days_open).slice(0,5);
    overdue.forEach(r => {
      alertHtml += `<div class="mob-alert mob-alert-danger"><div><div style="font-weight:600;font-size:13px;">RO# ${r.ro_id}</div><div style="font-size:10px;color:var(--muted);">${STORE_ABBR_MAP[r.store_id]||r.store_id} ======== $${Math.ceil(+(r.ro_total||0)).toLocaleString()}</div></div><div style="font-size:18px;font-weight:700;color:#ef4444;">${r.days_open}d</div></div>`;
    });
    if (!overdue.length) alertHtml = '<div style="text-align:center;color:var(--muted);font-size:12px;padding:12px;">No critical ROs over 14 days</div>';
    document.getElementById('mobOpenROAlerts').innerHTML = '<div style="font-size:11px;font-weight:600;color:var(--muted);margin-bottom:6px;text-transform:uppercase;">Critical ROs</div>' + alertHtml;

    // Chart - aging buckets
    const buckets = {'0-3':0,'4-7':0,'8-14':0,'15-30':0,'31+':0};
    orROs.forEach(r => { const d=+r.days_open; if(d<=3)buckets['0-3']++;else if(d<=7)buckets['4-7']++;else if(d<=14)buckets['8-14']++;else if(d<=30)buckets['15-30']++;else buckets['31+']++; });
    if (_mobCharts.openro) _mobCharts.openro.destroy();
    _mobCharts.openro = new Chart(document.getElementById('mobOpenROChart').getContext('2d'), {
      type:'bar', data:{labels:Object.keys(buckets), datasets:[{label:'ROs',data:Object.values(buckets),backgroundColor:['#22c55e','#3b82f6','#f59e0b','#f97316','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{display:false},title:{display:true,text:'Open RO Aging',font:{size:12}}},scales:{y:{beginAtZero:true}}}
    });
  } catch(e) { console.error('Mobile Open RO load error',e); }

  // Load Used Recon (current month)
  try {
    const urResp = await fetch(SB_URL+'/rest/v1/rpc/used_recon_store_monthly', {method:'POST',headers:hdr,body:JSON.stringify({p_start_date:startDate,p_end_date:endDate})});
    const urData = await urResp.json();
    let urROs=0, urTotal=0, urDays=0, urCount=0;
    urData.forEach(r => { urROs+=+r.ro_count; urTotal+=+(r.total_ro_total||0); urDays+=+(r.avg_recon_days||0)*(+r.ro_count); urCount+=+r.ro_count; });
    const avgCost = urROs ? urTotal/urROs : 0;
    const avgDays = urCount ? urDays/urCount : 0;

    document.getElementById('mobUsedKPIs').innerHTML =
      mobKPI('Recon ROs', urROs, 'num', '#ef4444', curMonth) +
      mobKPI('Recon Total', urTotal, 'dollar', '#ef4444') +
      mobKPI('Avg RO Cost', avgCost, 'dollar', '#f97316') +
      mobKPI('Avg Recon Days', avgDays, 'dec1', '#3b82f6');

    // Chart by store
    const urByStore = {};
    urData.forEach(r => { urByStore[r.store_id]=(urByStore[r.store_id]||0)+(+r.ro_count); });
    if (_mobCharts.used) _mobCharts.used.destroy();
    _mobCharts.used = new Chart(document.getElementById('mobUsedChart').getContext('2d'), {
      type:'doughnut', data:{labels:Object.keys(urByStore).sort().map(s=>STORE_ABBR_MAP[s]||s), datasets:[{data:Object.keys(urByStore).sort().map(s=>urByStore[s]),backgroundColor:['#3b82f6','#8b5cf6','#f59e0b','#ef4444']}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{position:'bottom',labels:{usePointStyle:true,padding:8}},title:{display:true,text:'Recon ROs by Store',font:{size:12}}}}
    });
  } catch(e) { console.error('Mobile Used Recon load error',e); }

  // Load Open Used
  try {
    const ouFilter = 'store_id=in.('+sIds.join(',')+')';
    const [ouResp, ouAssignResp] = await Promise.all([
      fetch(SB_URL+'/rest/v1/used_open?select=store_id,ro_id,date,stock_no,vin&'+ouFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}}),
      fetch(SB_URL+'/rest/v1/open_used_assignments?select=store_id,ro_id,status&'+ouFilter+'&limit=5000', {headers:{'apikey':SB_KEY,'Authorization':'Bearer '+SB_KEY}})
    ]);
    const ouRaw = await ouResp.json();
    const ouAssigns = await ouAssignResp.json();
    const ouAssMap = {}; ouAssigns.forEach(a=>{ouAssMap[a.store_id+'-'+a.ro_id]=a.status||'';});

    const ouMap = {};
    ouRaw.forEach(r => { const k=r.store_id+'-'+r.ro_id; if(!ouMap[k]){const days=r.date?Math.max(0,Math.round((new Date()-new Date(r.date))/86400000)):0; ouMap[k]={...r,daysOpen:days};} });
    const ouROs = Object.values(ouMap);
    const ouTotal = ouROs.length;
    const ouAvgDays = ouTotal ? ouROs.reduce((s,r)=>s+r.daysOpen,0)/ouTotal : 0;
    const ouOver7 = ouROs.filter(r=>r.daysOpen>7).length;
    const ouOver14 = ouROs.filter(r=>r.daysOpen>14).length;

    document.getElementById('mobOpenUsedKPIs').innerHTML =
      mobKPI('Open Vehicles', ouTotal, 'num', '#7c3aed') +
      mobKPI('Avg Days', ouAvgDays, 'dec1', '#7c3aed') +
      mobKPI('Over 7 Days', ouOver7, 'num', ouOver7?'#f97316':'var(--text)') +
      mobKPI('Over 14 Days', ouOver14, 'num', ouOver14?'#ef4444':'var(--text)');

    // Alerts - vehicles over 7 days
    let ouAlertHtml = '';
    const ouOverdue = ouROs.filter(r=>r.daysOpen>7).sort((a,b)=>b.daysOpen-a.daysOpen).slice(0,8);
    ouOverdue.forEach(r => {
      const status = ouAssMap[r.store_id+'-'+r.ro_id]||'Unassigned';
      const cls = r.daysOpen>14?'mob-alert-danger':'mob-alert-warn';
      const acq = parseAcqSource(r.stock_no);
      ouAlertHtml += `<div class="mob-alert ${cls}"><div><div style="font-weight:600;font-size:13px;">RO# ${r.ro_id}</div><div style="font-size:10px;color:var(--muted);">${STORE_ABBR_MAP[r.store_id]||r.store_id} ======== ${acq} ======== ${status}</div></div><div style="font-size:18px;font-weight:700;color:${r.daysOpen>14?'#ef4444':'#f97316'};">${r.daysOpen}d</div></div>`;
    });
    if (!ouOverdue.length) ouAlertHtml = '<div style="text-align:center;color:var(--muted);font-size:12px;padding:12px;">All vehicles under 7 days</div>';
    document.getElementById('mobOpenUsedAlerts').innerHTML = '<div style="font-size:11px;font-weight:600;color:var(--muted);margin-bottom:6px;text-transform:uppercase;">Vehicles Needing Attention</div>' + ouAlertHtml;

    // Status chart
    const byStat = {};
    ouROs.forEach(r => { const st = ouAssMap[r.store_id+'-'+r.ro_id]||'Unassigned'; byStat[st]=(byStat[st]||0)+1; });
    const statLabels = Object.keys(byStat).sort();
    const statColors = statLabels.map(l=>OU_STATUS_COLOR[l]||'#94a3b8');
    if (_mobCharts.openused) _mobCharts.openused.destroy();
    _mobCharts.openused = new Chart(document.getElementById('mobOpenUsedChart').getContext('2d'), {
      type:'doughnut', data:{labels:statLabels, datasets:[{data:statLabels.map(l=>byStat[l]),backgroundColor:statColors}]},
      options:{responsive:true,maintainAspectRatio:false,plugins:{legend:{position:'bottom',labels:{usePointStyle:true,padding:6,font:{size:10}}},title:{display:true,text:'By Status',font:{size:12}}}}
    });
  } catch(e) { console.error('Mobile Open Used load error',e); }
}



// ========"========"========"========" Vehicle Tracker State ========"========"========"========"
var vtScanner = null;
var vtState = {
  vin: '',
  vehicle: null,       // { year, make, model, vin 

Requests	IP Address	Location	AS Autonomous System
3	104.17.25.14	United States	AS13335Cloudflare, Inc.
2	104.18.0.22	United States	AS13335Cloudflare, Inc.
2	188.114.97.3	United States	AS13335Cloudflare, Inc.
2	104.17.207.5	United States	AS13335Cloudflare, Inc.
9	4	-	-

Security Scan Report: rezifixedops.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