';
statsEl.innerHTML = html;
}
// Columns
PIPELINE_PHASES.forEach(function(phase) {
var body = document.getElementById('body-' + phase);
var countEl = document.getElementById('count-' + phase);
if (!body) return;
var phaseJobs = phases[phase];
if (countEl) countEl.textContent = phaseJobs.length;
if (!phaseJobs.length) {
body.innerHTML = '
' + PIPELINE_ICONS[phase] + '
No ' + PIPELINE_LABELS[phase].toLowerCase() + ' jobs
';
return;
}
// Sort: urgent first, then by date
phaseJobs.sort(function(a, b) {
var aU = (a.notes||'').toLowerCase().indexOf('urgent') >= 0 || (a.title||'').toLowerCase().indexOf('urgent') >= 0 ? 0 : 1;
var bU = (b.notes||'').toLowerCase().indexOf('urgent') >= 0 || (b.title||'').toLowerCase().indexOf('urgent') >= 0 ? 0 : 1;
if (aU !== bU) return aU - bU;
return (a.date||'').localeCompare(b.date||'');
});
var html = '';
phaseJobs.forEach(function(job) {
var isUrgent = (job.notes||'').toLowerCase().indexOf('urgent') >= 0 || (job.title||'').toLowerCase().indexOf('urgent') >= 0 || (job.date && isTodayOrTomorrow(job.date));
var src = job.source || 'Other';
var srcCls = sourceClass(src);
var price = job.price ? '$' + (typeof job.price === 'number' ? job.price.toLocaleString() : job.price) : '';
var customer = job.customer || job.title || 'Unknown';
var title = job.title || job.type || '';
var dateStr = job.date ? formatDateShort(job.date) : '';
html += '
';
html += '
' + formatSource(src) + '
';
html += '
' + escHtml(customer) + '
';
html += '
' + escHtml(title) + '
';
html += '
';
if (price) html += '' + price + '';
if (dateStr) html += '📅 ' + dateStr + '';
if (isUrgent) html += '⚡ URGENT';
html += '
';
// Action buttons based on phase
html += '
';
if (phase === 'leads') {
html += '';
html += '';
} else if (phase === 'contacted') {
html += '';
} else if (phase === 'scheduled') {
html += '';
} else if (phase === 'active') {
html += '';
} else if (phase === 'done') {
html += '';
}
html += '
';
html += '
';
});
body.innerHTML = html;
});
}
function advancePipeline(jobId, newPhase) {
var jobs = loadJobs();
for (var i = 0; i < jobs.length; i++) {
if (jobs[i].id === jobId) {
jobs[i].pipelinePhase = newPhase;
// Also update status for backwards compat
var statusMap = {leads:'open',contacted:'contacted',scheduled:'accepted',active:'inprogress',done:'completed',followup:'completed'};
if (statusMap[newPhase]) jobs[i].status = statusMap[newPhase];
break;
}
}
saveJobs(jobs);
syncToSheet();
renderPipeline();
showToast('✅ Moved to ' + PIPELINE_LABELS[newPhase]);
}
function isTodayOrTomorrow(dateStr) {
if (!dateStr) return false;
var d = new Date(dateStr);
var now = new Date();
var tomorrow = new Date(now);
tomorrow.setDate(tomorrow.getDate() + 1);
return d.toDateString() === now.toDateString() || d.toDateString() === tomorrow.toDateString();
}
function formatDateShort(dateStr) {
if (!dateStr) return '';
var d = new Date(dateStr + 'T12:00:00');
var days = ['Sun','Mon','Tue','Wed','Thu','Fri','Sat'];
var months = ['1/','2/','3/','4/','5/','6/','7/','8/','9/','10/','11/','12/'];
return days[d.getDay()] + ' ' + months[d.getMonth()] + d.getDate();
}
function escHtml(str) {
var div = document.createElement('div');
div.appendChild(document.createTextNode(str));
return div.innerHTML;
}
// Register the pipeline tab
var originalSwitchTab = switchTab;
switchTab = function(tabName) {
if (tabName === 'pipeline') {
var tabs = document.querySelectorAll('.tab');
tabs.forEach(function(t){t.classList.remove('active');});
var contents = document.querySelectorAll('.tab-content');
contents.forEach(function(c){c.classList.remove('active');});
// Find or create pipeline tab button
var pipeTab = document.querySelector('[data-tab="pipeline"]');
if (pipeTab) pipeTab.classList.add('active');
document.getElementById('tab-pipeline').classList.add('active');
renderPipeline();
} else {
originalSwitchTab(tabName);
}
};