${item.title}

${item.value}

`; dashboardSummary.appendChild(card); }); // Populate customer insights table (sorted by last purchase date descending) const sortedInsightsData = [...customerInsightsData].sort((a, b) => new Date(b.lastPurchaseDate) - new Date(a.lastPurchaseDate)); sortedInsightsData.forEach(item => { const row = customerInsightsTableBody.insertRow(); row.innerHTML = ` ${item.customerId} ${item.name} ${item.segment} $${item.cltv.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })} ${item.npsScore} ${item.lastPurchaseDate} ${item.preferredProductCategory} ${item.churnRisk} `; }); } // --- Data Configuration Table Rendering and Editing --- /** * Renders the data in the configuration table. */ function renderConfigTable() { // Null check for config data table body if (!configDataTableBody) { console.error("Config data table body not found."); return; } configDataTableBody.innerHTML = ''; // Clear existing rows customerInsightsData.forEach((item, index) => { const row = configDataTableBody.insertRow(); row.innerHTML = ` ${item.customerId} ${item.name} ${item.segment} $${item.cltv.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })} ${item.npsScore} ${item.lastPurchaseDate} ${item.preferredProductCategory} ${item.churnRisk} Edit Delete `; }); } /** * Adds a new row or updates an existing row in the customer insights data. */ window.addRow = function() { // Null checks for input fields if (!customerIdInput || !customerNameInput || !customerSegmentSelect || !cltvInput || !npsScoreInput || !lastPurchaseDateInput || !preferredProductCategoryInput || !churnRiskSelect) { console.error("One or more input fields not found."); return; } const newInsight = { customerId: customerIdInput.value.trim(), name: customerNameInput.value.trim(), segment: customerSegmentSelect.value.trim(), cltv: parseFloat(cltvInput.value) || 0, npsScore: parseInt(npsScoreInput.value) || 0, lastPurchaseDate: lastPurchaseDateInput.value.trim(), preferredProductCategory: preferredProductCategoryInput.value.trim(), churnRisk: churnRiskSelect.value.trim() }; // Simple validation if (!newInsight.customerId || !newInsight.name || !newInsight.segment || newInsight.cltv < 0 || newInsight.npsScore < 0 || newInsight.npsScore > 10 || !newInsight.lastPurchaseDate || !newInsight.preferredProductCategory || !newInsight.churnRisk) { showModal("Please fill in all required fields with valid values."); return; } // Check for duplicate Customer ID if adding a new row if (editingIndex === -1) { const isDuplicate = customerInsightsData.some(customer => customer.customerId === newInsight.customerId); if (isDuplicate) { showModal(`Customer ID "${newInsight.customerId}" already exists. Please use a unique ID.`); return; } customerInsightsData.push(newInsight); } else { // Update existing row customerInsightsData[editingIndex] = newInsight; editingIndex = -1; // Reset editing state updateRowButton.classList.add('hidden'); cancelEditButton.classList.add('hidden'); addRowButton.classList.remove('hidden'); customerIdInput.disabled = false; // Re-enable customer ID for new entries } clearForm(); renderConfigTable(); updateDashboard(); // Keep dashboard in sync }; /** * Populates the form with data from the row to be edited. * @param {HTMLElement} button - The edit button clicked. */ window.editRow = function(button) { // Null checks for input fields and edit buttons if (!customerIdInput || !customerNameInput || !customerSegmentSelect || !cltvInput || !npsScoreInput || !lastPurchaseDateInput || !preferredProductCategoryInput || !churnRiskSelect || !addRowButton || !updateRowButton || !cancelEditButton) { console.error("One or more form/button elements not found for editing."); return; } const index = parseInt(button.dataset.index); editingIndex = index; const item = customerInsightsData[index]; customerIdInput.value = item.customerId; customerNameInput.value = item.name; customerSegmentSelect.value = item.segment; cltvInput.value = item.cltv; npsScoreInput.value = item.npsScore; lastPurchaseDateInput.value = item.lastPurchaseDate; preferredProductCategoryInput.value = item.preferredProductCategory; churnRiskSelect.value = item.churnRisk; addRowButton.classList.add('hidden'); updateRowButton.classList.remove('hidden'); cancelEditButton.classList.remove('hidden'); customerIdInput.disabled = true; // Disable editing Customer ID during update }; /** * Deletes a row from the customer insights data. * @param {HTMLElement} button - The delete button clicked. */ window.deleteRow = function(button) { const index = parseInt(button.dataset.index); showModal("Are you sure you want to delete this customer insight record?", true, (confirmed) => { if (confirmed) { customerInsightsData.splice(index, 1); renderConfigTable(); updateDashboard(); // Keep dashboard in sync clearForm(); // Clear form if the deleted item was being edited editingIndex = -1; updateRowButton.classList.add('hidden'); cancelEditButton.classList.add('hidden'); addRowButton.classList.remove('hidden'); customerIdInput.disabled = false; // Re-enable customer ID } }); }; /** * Clears the input form fields. */ function clearForm() { // Null checks for input fields if (!customerIdInput || !customerNameInput || !customerSegmentSelect || !cltvInput || !npsScoreInput || !lastPurchaseDateInput || !preferredProductCategoryInput || !churnRiskSelect) { console.error("One or more input fields not found for clearing."); return; } customerIdInput.value = ''; customerNameInput.value = ''; customerSegmentSelect.value = 'High Value'; // Reset to default segment cltvInput.value = ''; npsScoreInput.value = ''; lastPurchaseDateInput.value = ''; preferredProductCategoryInput.value = ''; churnRiskSelect.value = 'Low'; // Reset to default churn risk } /** * Cancels the current edit operation and clears the form. */ window.cancelEdit = function() { editingIndex = -1; clearForm(); updateRowButton.classList.add('hidden'); cancelEditButton.classList.add('hidden'); addRowButton.classList.remove('hidden'); customerIdInput.disabled = false; // Re-enable customer ID }; // --- PDF Download Functionality --- /** * Downloads the dashboard content as a PDF. */ window.downloadPdf = async function() { // Null check for dashboard content if (!dashboardTabContent) { console.error("Dashboard content for PDF not found."); return; } // Temporarily show the dashboard content if it's hidden, for accurate PDF generation const wasHidden = dashboardTabContent.classList.contains('hidden'); if (wasHidden) { dashboardTabContent.classList.remove('hidden'); } const { jsPDF } = window.jspdf; const doc = new jsPDF('p', 'pt', 'letter'); // 'p' for portrait, 'pt' for points, 'letter' size const element = dashboardTabContent; // The element to convert to PDF // Use html2canvas to render the HTML element to a canvas await html2canvas(element, { scale: 2, // Increase scale for better quality useCORS: true, // Important for images/external resources if any (though we don't use them here) logging: false // Disable logging for cleaner console }).then(canvas => { const imgData = canvas.toDataURL('image/png'); const imgWidth = 550; // A fixed width for the image in PDF const pageHeight = doc.internal.pageSize.height; const imgHeight = (canvas.height * imgWidth) / canvas.width; let heightLeft = imgHeight; let position = 30; // Initial Y position for content doc.setFontSize(22); doc.setTextColor(31, 41, 55); // Gray 900 equivalent doc.text("Customer Insights Dashboard", doc.internal.pageSize.getWidth() / 2, position, { align: "center" }); position += 30; // Move down for image doc.addImage(imgData, 'PNG', 30, position, imgWidth, imgHeight); heightLeft -= pageHeight; // If content overflows, add new pages while (heightLeft >= 0) { position = heightLeft - imgHeight + 30; // Adjust position for new page doc.addPage(); doc.addImage(imgData, 'PNG', 30, position, imgWidth, imgHeight); heightLeft -= pageHeight; } doc.save('Customer_Insights_Dashboard.pdf'); }); // Restore hidden state if it was hidden initially if (wasHidden) { dashboardTabContent.classList.add('hidden'); } }; // --- Event Listeners --- if (addRowButton) { addRowButton.addEventListener('click', addRow); } else { console.error("Add Row Button not found."); } if (updateRowButton) { updateRowButton.addEventListener('click', addRow); // addRow function handles both add and update based on editingIndex } else { console.error("Update Row Button not found."); } if (cancelEditButton) { cancelEditButton.addEventListener('click', cancelEdit); } else { console.error("Cancel Edit Button not found."); } // Initial rendering and setup openTab('dashboard'); // Open dashboard by default updateDashboard(); // Populate dashboard with initial data renderConfigTable(); // Populate config table with initial data });