${ratio === Infinity ? 'N/A (Equity is $0)' : ratio.toFixed(2)}
Interpretation
${interpretation}
`;
} else {
summaryHtml = `
No data available. Please add data in the "Data Configuration" tab.
`;
}
currentRatioSummaryDiv.innerHTML = summaryHtml;
}
/**
* Renders the table of all historical D/E data.
*/
function renderDETable() {
if (!debtEquityTableBody) return; // Null check
debtEquityTableBody.innerHTML = ''; // Clear existing rows
// Sort data by date in descending order for display
const sortedData = [...deData].sort((a, b) => new Date(b.date) - new Date(a.date));
sortedData.forEach(entry => {
const ratio = calculateDERatio(entry.totalDebt, entry.shareholderEquity);
const interpretation = interpretDERatio(ratio);
const row = debtEquityTableBody.insertRow();
row.innerHTML = `
`;
});
}
/**
* Renders the entire dashboard content.
*/
function renderDashboard() {
renderCurrentRatioSummary();
renderDETable();
}
// --- Data Configuration Logic ---
/**
* Generates a unique ID for a new entry.
* @returns {string} A unique ID.
*/
function generateUniqueId() {
return 'de' + Date.now() + Math.floor(Math.random() * 1000);
}
// Add/Update D/E Form Submission
if (addUpdateDEForm) {
addUpdateDEForm.addEventListener('submit', function(event) {
event.preventDefault(); // Prevent default form submission
const id = document.getElementById('entryId').value;
const date = document.getElementById('entryDate').value;
const totalDebt = parseFloat(document.getElementById('totalDebt').value);
const shareholderEquity = parseFloat(document.getElementById('shareholderEquity').value);
if (shareholderEquity < 0) {
showCustomModal('Error', 'Shareholder Equity cannot be negative.');
return;
}
const newEntry = {
id: id || generateUniqueId(), // Use existing ID if editing, otherwise generate new
date: date,
totalDebt: totalDebt,
shareholderEquity: shareholderEquity
};
if (id) {
// Update existing entry
const index = deData.findIndex(entry => entry.id === id);
if (index > -1) {
deData[index] = newEntry;
} else {
console.error('Entry not found for update:', id);
}
} else {
// Add new entry
deData.push(newEntry);
}
renderDashboard(); // Re-render dashboard with new/updated data
addUpdateDEForm.reset(); // Clear the form
entryIdInput.value = ''; // Clear hidden ID
formSubmitBtn.textContent = 'Add Data'; // Reset button text
switchTab('dashboard'); // Switch back to dashboard to see changes
});
}
/**
* Populates the form for editing an existing entry.
* @param {string} id - The ID of the entry to edit.
*/
window.editEntry = function(id) {
const entryToEdit = deData.find(entry => entry.id === id);
if (!entryToEdit) {
console.error('Entry not found for editing:', id);
return;
}
document.getElementById('entryId').value = entryToEdit.id;
document.getElementById('entryDate').value = entryToEdit.date;
document.getElementById('totalDebt').value = entryToEdit.totalDebt;
document.getElementById('shareholderEquity').value = entryToEdit.shareholderEquity;
formSubmitBtn.textContent = 'Update Data'; // Change button text
switchTab('data-config'); // Switch to data config tab
};
/**
* Deletes an entry from the array after confirmation.
* @param {string} id - The ID of the entry to delete.
*/
window.deleteEntry = function(id) {
showCustomModal('Confirm Deletion', 'Are you sure you want to delete this data entry?', () => {
deData = deData.filter(entry => entry.id !== id);
renderDashboard(); // Re-render dashboard
});
};
// --- Custom Modal Logic (replaces alert/confirm) ---
let currentConfirmCallback = null;
/**
* Shows a custom modal with a message and optional confirmation.
* @param {string} title - The title of the modal.
* @param {string} message - The message to display.
* @param {function} [onConfirm] - Callback function to execute on confirm. If null, it's an alert.
*/
function showCustomModal(title, message, onConfirm = null) {
if (!confirmModal || !modalTitle || !modalMessage || !confirmActionBtn) return;
modalTitle.textContent = title;
modalMessage.textContent = message;
if (onConfirm) {
confirmActionBtn.style.display = 'inline-block'; // Show confirm button
confirmActionBtn.textContent = 'Confirm';
confirmActionBtn.classList.remove('btn-primary');
confirmActionBtn.classList.add('btn-danger');
currentConfirmCallback = onConfirm;
} else {
confirmActionBtn.style.display = 'none'; // Hide confirm button for alerts
currentConfirmCallback = null;
}
confirmModal.style.display = 'flex'; // Show modal
}
/**
* Closes the specified modal.
* @param {string} modalId - The ID of the modal to close.
*/
window.closeModal = function(modalId) {
const modal = document.getElementById(modalId);
if (modal) {
modal.style.display = 'none';
}
};
// Event listener for the custom modal's confirm button
if (confirmActionBtn) {
confirmActionBtn.addEventListener('click', function() {
if (currentConfirmCallback) {
currentConfirmCallback();
}
closeModal('confirmModal');
});
}
// Close modal when clicking outside of it
window.onclick = function(event) {
if (event.target === confirmModal) {
closeModal('confirmModal');
}
};
// --- PDF Download Logic ---
/**
* Downloads the dashboard content as a PDF.
*/
if (downloadPdfBtn) {
downloadPdfBtn.addEventListener('click', function() {
const input = document.getElementById('dashboardTabContent'); // Target the dashboard content
if (!input) {
console.error('Dashboard content element not found for PDF generation.');
return;
}
// Temporarily hide elements that should not be in the PDF
const elementsToHide = input.querySelectorAll('.no-print');
elementsToHide.forEach(el => el.style.display = 'none');
// Use html2canvas to capture the content as an image
html2canvas(input, {
scale: 2, // Increase scale for better quality
useCORS: true, // Needed if external images are used (not in this case, but good practice)
logging: false // Disable logging for cleaner console
}).then(canvas => {
const imgData = canvas.toDataURL('image/png');
const pdf = new window.jspdf.jsPDF('p', 'mm', 'a4'); // 'p' for portrait, 'mm' for units, 'a4' for size
const imgWidth = 210; // A4 width in mm
const pageHeight = 297; // A4 height in mm
const imgHeight = canvas.height * imgWidth / canvas.width;
let heightLeft = imgHeight;
let position = 0;
// Add image to PDF
pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight);
heightLeft -= pageHeight;
// If content spans multiple pages, add new pages
while (heightLeft >= 0) {
position = heightLeft - imgHeight;
pdf.addPage();
pdf.addImage(imgData, 'PNG', 0, position, imgWidth, imgHeight);
heightLeft -= pageHeight;
}
pdf.save('Debt_to_Equity_Dashboard.pdf');
// Restore visibility of hidden elements
elementsToHide.forEach(el => el.style.display = '');
}).catch(error => {
console.error('Error generating PDF:', error);
// Restore visibility of hidden elements in case of error
elementsToHide.forEach(el => el.style.display = '');
});
});
}
// Initial render of the dashboard when the page loads
renderDashboard();
});
