Average Cost Per Warehouse/Unit (${overallBudgetPeriod}): ${currency}${(grandTotalCostForPeriod / totalWarehouses).toFixed(2)}
`;
}
html += '
';
html += '
Detailed Cost Breakdown:
';
html += '
| Category | Expense Item | Basis & Frequency Details | Est. Cost for Period |
|---|
';
if (allItems.length === 0) {
html += '| No expenses entered. |
';
} else {
const groupedByCategory = allItems.reduce((acc, item) => {
(acc[item.category] = acc[item.category] || []).push(item);
return acc;
}, {});
for (const category in groupedByCategory) {
html += ``;
let categorySubtotal = 0;
groupedByCategory[category].forEach(item => {
html += `
|
${item.name} |
${item.basisDetails} |
${currency}${item.calculatedCost.toFixed(2)} |
`;
categorySubtotal += item.calculatedCost;
});
html += `| Subtotal for ${category}: | ${currency}${categorySubtotal.toFixed(2)} |
`;
}
}
html += `| GRAND TOTAL: | ${currency}${grandTotalCostForPeriod.toFixed(2)} |
`;
html += '
';
summaryOutput.innerHTML = html;
downloadPdfButton.disabled = allItems.length === 0;
}
// PDF Download
downloadPdfButton.addEventListener('click', function () {
if (typeof jspdf === 'undefined' || typeof jspdf.jsPDF === 'undefined') {
alert('Error: jsPDF library is not loaded.'); return;
}
const { jsPDF } = jspdf;
const doc = new jsPDF('p');
const currency = currencySymbolInput.value || '$';
const overallBudgetPeriod = getVal('wsc-budget-period');
const totalEmployees = getNum('wsc-num-employees', true); // Although not directly used in item calc, good for context
const totalWarehouses = getNum('wsc-num-warehouses', true);
const totalArea = getNum('wsc-total-area', true);
const areaUnit = getVal('wsc-area-unit') || 'unit';
const primaryColor = getComputedStyle(document.documentElement).getPropertyValue('--wsc-primary-color').trim();
const secondaryColor = getComputedStyle(document.documentElement).getPropertyValue('--wsc-secondary-color').trim();
const textColor = getComputedStyle(document.documentElement).getPropertyValue('--wsc-text-color').trim();
const buttonTextColor = getComputedStyle(document.documentElement).getPropertyValue('--wsc-button-text-color').trim();
doc.setFontSize(18);
doc.setTextColor(primaryColor);
doc.text('Warehouse & Storage Cost Budget', doc.internal.pageSize.getWidth() / 2, 20, { align: 'center' });
doc.setFontSize(12);
doc.setTextColor(textColor);
let lastY = 30;
doc.text(`Business Name: ${getVal('wsc-business-name') || 'N/A'}`, 14, lastY); lastY += 7;
doc.text(`Budget Name/ID: ${getVal('wsc-budget-name') || 'N/A'}`, 14, lastY); lastY += 7;
doc.text(`Budget Period: ${overallBudgetPeriod}`, 14, lastY); lastY += 7;
doc.text(`Currency: ${currency}`, 14, lastY); lastY += 7;
doc.text(`Number of Warehouses/Units: ${totalWarehouses}`, 14, lastY); lastY += 7;
doc.text(`Total Storage Area: ${totalArea} ${areaUnit}`, 14, lastY); lastY += 10;
const allItemsPdf = [];
let grandTotalCostForPeriodPdf = 0;
// Re-calculate for PDF to ensure data accuracy
document.querySelectorAll('.wsc-expense-item').forEach(itemEl => {
const itemName = itemEl.querySelector('.wsc-item-name').value || 'Unnamed Item';
const itemCategory = itemEl.dataset.itemCategory;
const costAmount = getNum(itemEl.querySelector('.wsc-item-cost-amount').value);
const costBasis = itemEl.querySelector('.wsc-item-cost-basis').value;
const itemFrequency = itemEl.querySelector('.wsc-item-frequency').value;
let baseCostForFrequency = costAmount;
if (costBasis === 'perSqFt') baseCostForFrequency = costAmount * totalArea;
else if (costBasis === 'perWarehouseUnit') baseCostForFrequency = costAmount * totalWarehouses;
let itemAnnualEquivalentCost = baseCostForFrequency;
if (itemFrequency === 'Monthly') itemAnnualEquivalentCost = baseCostForFrequency * 12;
else if (itemFrequency === 'Quarterly') itemAnnualEquivalentCost = baseCostForFrequency * 4;
else if (itemFrequency === 'Annually') itemAnnualEquivalentCost = baseCostForFrequency * 1;
else if (itemFrequency === 'OneTime') { // For PDF one-time interpretation
if (overallBudgetPeriod === 'Monthly') itemAnnualEquivalentCost = baseCostForFrequency * 12;
else if (overallBudgetPeriod === 'Quarterly') itemAnnualEquivalentCost = baseCostForFrequency * 4;
else itemAnnualEquivalentCost = baseCostForFrequency;
}
let costForThisItemForPeriod = 0;
if (itemFrequency === 'OneTime') {
costForThisItemForPeriod = baseCostForFrequency;
} else {
if (overallBudgetPeriod === 'Monthly') costForThisItemForPeriod = itemAnnualEquivalentCost / 12;
else if (overallBudgetPeriod === 'Quarterly') costForThisItemForPeriod = itemAnnualEquivalentCost / 4;
else if (overallBudgetPeriod === 'Annually') costForThisItemForPeriod = itemAnnualEquivalentCost;
}
let basisDetails = `${currency}${costAmount.toFixed(2)}`;
if(costBasis !== 'totalSetAmount') basisDetails += ` / ${costBasis.replace('per','').toLowerCase().replace('sqft', areaUnit)}`;
basisDetails += ` (${itemFrequency})`;
allItemsPdf.push({ category: itemCategory, name: itemName, basisDetails, calculatedCost: costForThisItemForPeriod });
grandTotalCostForPeriodPdf += costForThisItemForPeriod;
});
doc.setFontSize(10);
doc.text(`Total Estimated Costs (${overallBudgetPeriod}): ${currency}${grandTotalCostForPeriodPdf.toFixed(2)}`, 14, lastY); lastY += 7;
if (totalArea > 0) {
doc.text(`Avg Cost Per ${areaUnit} (${overallBudgetPeriod}): ${currency}${(grandTotalCostForPeriodPdf / totalArea).toFixed(2)}`, 14, lastY); lastY += 7;
}
if (totalWarehouses > 0) {
doc.text(`Avg Cost Per Warehouse/Unit (${overallBudgetPeriod}): ${currency}${(grandTotalCostForPeriodPdf / totalWarehouses).toFixed(2)}`, 14, lastY); lastY += 7;
}
lastY += 3;
const tableBody = [];
const groupedByCategoryPdf = allItemsPdf.reduce((acc, item) => {
(acc[item.category] = acc[item.category] || []).push(item);
return acc;
}, {});
for (const category in groupedByCategoryPdf) {
tableBody.push([{ content: category, colSpan: 3, styles: { fontStyle: 'bold', fillColor: '#f0f0f0' } }]);
let categorySubtotalPdf = 0;
groupedByCategoryPdf[category].forEach(item => {
tableBody.push([item.name, item.basisDetails, `${currency}${item.calculatedCost.toFixed(2)}`]);
categorySubtotalPdf += item.calculatedCost;
});
tableBody.push([
{ content: `Subtotal for ${category}`, colSpan: 2, styles: { halign: 'right', fontStyle: 'bold'} },
{ content: `${currency}${categorySubtotalPdf.toFixed(2)}`, styles: { halign: 'right', fontStyle: 'bold' } }
]);
}
tableBody.push([
{ content: `GRAND TOTAL`, colSpan: 2, styles: { halign: 'right', fontStyle: 'bold', fillColor: primaryColor, textColor: buttonTextColor } },
{ content: `${currency}${grandTotalCostForPeriodPdf.toFixed(2)}`, styles: { halign: 'right', fontStyle: 'bold', fillColor: primaryColor, textColor: buttonTextColor } }
]);
doc.autoTable({
startY: lastY,
head: [['Expense Item', 'Basis & Frequency', `Est. Cost for ${overallBudgetPeriod}`]],
body: tableBody,
theme: 'grid',
headStyles: { fillColor: secondaryColor, textColor: buttonTextColor, fontSize: 9 },
styles: { fontSize: 8, cellPadding: 2 },
columnStyles: { 2: { halign: 'right' } },
didDrawCell: (data) => {
if (data.cell.raw && data.cell.raw.colSpan === 3) { // Category Header Row styling
// Autotable handles colSpan styling
}
}
});
doc.save(`Warehouse_Storage_Budget_${getVal('wsc-budget-name').replace(/\s+/g, '_') || 'Report'}.pdf`);
});
// Initial setup for empty states
const initialCategoriesContainers = [
"wsc-space-items-container", "wsc-utilities-items-container", "wsc-equipment-items-container",
"wsc-labor-items-container", "wsc-tech-items-container", "wsc-maintenance-items-container",
"wsc-operational-items-container", "wsc-custom-items-container"
];
initialCategoriesContainers.forEach(id => checkEmptyState(id));
showTab(0);
updateAllCurrencyPrefixes();
});
