Select credit notes to approve in bulk:
Approval Comments (Optional)
Product Return Template
Standard template for product returns and refunds.
Use Template
Billing Error Template
Template for correcting billing mistakes and overcharges.
Use Template
Damaged Goods Template
Template for damaged or defective product credits.
Use Template
Goodwill Credit Template
Template for customer satisfaction and goodwill credits.
Use Template
' + title + ' ');
printWindow.document.write('');
printWindow.document.write('' + title + ' ');
printWindow.document.write('Elinom ERP - Accounting Module
');
printWindow.document.write(table ? table.outerHTML : 'No data available
');
printWindow.document.write('Generated on ' + new Date().toLocaleString() + '
');
printWindow.document.write('<\/body><\/html>');
printWindow.document.close();
printWindow.focus();
setTimeout(function() { printWindow.print(); }, 250);
}
// Trial Balance Export Function
function exportTrialBalance() {
var trialBalanceSection = document.getElementById('trial-balance');
if (!trialBalanceSection) {
alert('Trial Balance section not found');
return;
}
var table = trialBalanceSection.querySelector('table');
if (!table) {
alert('No data to export');
return;
}
var csv = 'Account,Debit,Credit\n';
var rows = table.querySelectorAll('tbody tr');
rows.forEach(function(row) {
var cells = row.querySelectorAll('td');
var account = cells[0] ? cells[0].textContent.trim().replace(/,/g, '') : '';
var debit = cells[1] ? cells[1].textContent.trim().replace(/[$,]/g, '') : '';
var credit = cells[2] ? cells[2].textContent.trim().replace(/[$,]/g, '') : '';
csv += '"' + account + '",' + debit + ',' + credit + '\n';
});
// Add totals
var footerRow = table.querySelector('tfoot tr');
if (footerRow) {
var cells = footerRow.querySelectorAll('td');
var totalLabel = cells[0] ? cells[0].textContent.trim() : 'Total';
var totalDebit = cells[1] ? cells[1].textContent.trim().replace(/[$,]/g, '') : '';
var totalCredit = cells[2] ? cells[2].textContent.trim().replace(/[$,]/g, '') : '';
csv += '"' + totalLabel + '",' + totalDebit + ',' + totalCredit + '\n';
}
var blob = new Blob([csv], { type: 'text/csv;charset=utf-8;' });
var url = URL.createObjectURL(blob);
var a = document.createElement('a');
a.href = url;
a.download = 'Trial_Balance_' + new Date().toISOString().split('T')[0] + '.csv';
document.body.appendChild(a);
a.click();
document.body.removeChild(a);
URL.revokeObjectURL(url);
}
// Load Trial Balance from backend
function loadTrialBalance() {
var tbody = document.getElementById('trial-balance-body');
var dateSpan = document.getElementById('trial-balance-as-of');
if (!tbody) return;
tbody.innerHTML = 'No accounts found. Add accounts in Chart of Accounts. ' + (acc.account_code ? acc.account_code + ' - ' : '') + acc.name + ' ' + debit + ' ' + credit + ' Error loading data. Please make sure the backend server is running.
' +
'
' +
'
' +
'
';
container.appendChild(row);
}
function calculateInvoiceTotal() {
var rows = document.querySelectorAll('.invoice-item-row');
var subtotal = 0;
rows.forEach(function(row) {
var qty = parseFloat(row.querySelector('[name="item-qty[]"]').value) || 0;
var price = parseFloat(row.querySelector('[name="item-price[]"]').value) || 0;
subtotal += qty * price;
});
document.getElementById('inv-subtotal').textContent = window.currencySymbol() + subtotal.toFixed(2);
document.getElementById('inv-tax').textContent = '$0.00';
document.getElementById('inv-total').textContent = window.currencySymbol() + subtotal.toFixed(2);
}
function saveInvoice() {
var customer = document.getElementById('inv-customer').value.trim();
if (!customer) {
alert('Please enter a customer name.');
return;
}
var items = [];
var rows = document.querySelectorAll('.invoice-item-row');
rows.forEach(function(row) {
var desc = row.querySelector('[name="item-desc[]"]').value.trim();
var qty = parseFloat(row.querySelector('[name="item-qty[]"]').value) || 0;
var price = parseFloat(row.querySelector('[name="item-price[]"]').value) || 0;
if (desc && qty > 0 && price > 0) {
items.push({ description: desc, quantity: qty, price: price, total: qty * price });
}
});
if (items.length === 0) {
alert('Please add at least one item.');
return;
}
var subtotal = items.reduce(function(sum, item) { return sum + item.total; }, 0);
var invoice = {
invoice_number: document.getElementById('inv-number').value,
customer: customer,
customer_email: document.getElementById('inv-email').value.trim(),
date: document.getElementById('inv-date').value,
due_date: document.getElementById('inv-due-date').value,
subtotal: subtotal,
tax: 0,
total: subtotal,
notes: document.getElementById('inv-notes').value.trim(),
status: 'pending'
};
// Save to backend API
fetch('/api/invoices/', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify(invoice)
})
.then(function(response) {
if (!response.ok) throw new Error('Server error');
return response.json();
})
.then(function(data) {
var modal = document.getElementById('create-invoice-modal-bs');
var bsModal = bootstrap.Modal.getInstance(modal);
bsModal.hide();
alert('Invoice ' + data.invoice_number + ' created successfully!');
if (typeof loadInvoices === 'function') loadInvoices();
})
.catch(function(error) {
console.error('Error saving invoice:', error);
alert('Error saving invoice. Please make sure the backend server is running.');
});
}
// View All Accounts Modal Function
function showAllAccountsModal() {
var existingModal = document.getElementById('all-accounts-modal');
if (existingModal) existingModal.remove();
// Load accounts from backend API
fetch('/api/accounts/')
.then(function(response) {
if (!response.ok) throw new Error('Server error');
return response.json();
})
.then(function(data) {
var accounts = data.results || data;
var accountRows = '';
if (accounts.length === 0) {
accountRows = 'No accounts configured. Click "Add Account" to get started. ' + acc.name + ' ' + (acc.account_type || '-') + ' ' + (acc.account_number || '-') + ' $' + parseFloat(acc.balance || 0).toFixed(2) + ' ${data.error}
`
);
return;
}
const txns = data.transactions || [];
const rows = txns.length
? txns.map(t => {
const amt = parseFloat(t.amount);
const color = amt > 0 ? '#ef4444' : '#22c55e';
const sign = amt > 0 ? '-' : '+';
const cat = (t.category || '').replace(/_/g, ' ');
const status = t.pending
? 'Pending '
: 'Cleared ';
return `
${t.date}
${t.name}
${sign} $${Math.abs(amt).toFixed(2)}
${cat}
${status}
`;
}).join('')
: 'No transactions yet � click Sync to import from your bank. Showing ${txns.length} most recent transactions
Date
Description
Amount
Category
Status
${rows}
${data.total > 20 ? `${data.total} total transactions in database.
` : ''}`;
_showInfoModal(
'Could not load transactions: ${e.message}
`
);
}
}
// Disconnect a bank item
async function disconnectBank(itemId) {
if (!confirm('Are you sure you want to disconnect this account? Automatic imports will stop.')) return;
try {
const resp = await fetch(`${BANKING_API}/disconnect/${itemId}/`, {
method: 'DELETE',
credentials: 'include',
headers: _authHeaders(),
});
const data = await resp.json();
if (data.error) _bankToast(data.error, 'error');
else { _bankToast('? ' + data.message, 'warning'); loadConnectedBankAccounts(); }
} catch (e) { _bankToast('Disconnect failed: ' + e.message, 'error'); }
}
// Sync all accounts
async function syncAllBankAccounts() {
_bankToast('Syncing all accounts�', 'info');
try {
const data = await _bankPost(`${BANKING_API}/sync-all/`, {});
const ok = (data.results || []).filter(r => r.status === 'ok').length;
_bankToast(`? Sync complete. ${ok} institution(s) updated.`, 'success');
loadConnectedBankAccounts();
} catch (e) { _bankToast('Sync all failed: ' + e.message, 'error'); }
}
// Save sync settings in PostgreSQL-backed user accounting settings
function saveBankSyncSettings() {
const settings = {
frequency: document.getElementById('bank-sync-frequency').value,
category: document.getElementById('bank-default-category').value,
lookback: document.getElementById('bank-lookback').value,
autoMatch: document.getElementById('bank-auto-match').checked,
notify: document.getElementById('bank-notify-new').checked,
};
saveAccountingSettingsPatch({ bank_sync_settings: settings })
.then(function() {
_bankToast('? Sync settings saved.', 'success');
})
.catch(function(err) {
console.warn('Bank sync settings save failed:', err);
_bankToast('Could not save sync settings to PostgreSQL.', 'error');
});
}
// Load connected accounts table dynamically from backend
async function loadConnectedBankAccounts() {
const tbody = document.getElementById('connected-banks-tbody');
if (!tbody) return;
try {
const resp = await fetch(`${BANKING_API}/accounts/`, { credentials: 'include', headers: _authHeaders({'Content-Type': undefined}) });
const data = await resp.json();
if (!data.accounts || data.accounts.length === 0) {
tbody.innerHTML = 'No bank accounts connected yet. Click Connect New Bank to get started.
${a.name}
���� ${a.mask || '????'}
${a.subtype || a.type} ${a.last_synced ? new Date(a.last_synced).toLocaleString() : 'Never'}
Active
`).join('');
} catch (e) {
tbody.innerHTML = 'Could not load accounts � make sure the backend is running. Error loading data. Please make sure the backend server is running. No receipts found. Click "New Receipt" to create one.
${receipt.id}
${receipt.customer}
${receipt.date}
$${receipt.amount.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })}
${formatMethod(receipt.method)}
`).join('');
}
// Update pagination info
const showingEl = document.getElementById('receipts-showing');
if (showingEl) {
showingEl.textContent = totalReceipts === 0
? 'No receipts found'
: `Showing ${start + 1}-${end} of ${totalReceipts}`;
}
// Store receipts for pagination
window._receiptsCache = receipts;
}
function filterReceipts(searchTerm) {
if (!searchTerm) {
loadReceipts();
return;
}
fetch(`/api/receipts/?search=${encodeURIComponent(searchTerm)}`)
.then(response => response.json())
.then(data => {
let receipts = data.map(item => ({
id: item.receipt_number,
dbId: item.id,
customer: item.customer,
date: item.date,
amount: parseFloat(item.amount),
method: item.payment_method,
reference: item.reference || ''
}));
renderReceipts(receipts);
})
.catch(error => console.error('Error filtering receipts:', error));
}
function receiptsPagePrev() {
if (receiptsCurrentPage > 1) {
receiptsCurrentPage--;
if (window._receiptsCache) {
renderReceipts(window._receiptsCache);
} else {
loadReceipts();
}
}
}
function receiptsPageNext() {
const receipts = window._receiptsCache || [];
const totalPages = Math.ceil(receipts.length / receiptsPerPage);
if (receiptsCurrentPage < totalPages) {
receiptsCurrentPage++;
renderReceipts(receipts);
}
}
function viewReceipt(dbId) {
fetch(`/api/receipts/${dbId}/`)
.then(response => response.json())
.then(receipt => {
const formatMethod = (method) => {
const methods = { 'cash': 'Cash', 'check': 'Check', 'bank-transfer': 'Bank Transfer', 'credit-card': 'Credit Card' };
return methods[method] || method;
};
const modal = document.createElement('div');
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = `
Receipt #:
${receipt.receipt_number}
Customer:
${receipt.customer}
Amount:
$${parseFloat(receipt.amount).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })}
Payment Method:
${formatMethod(receipt.payment_method)}
Reference:
${receipt.reference || 'N/A'}
`;
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
modal.addEventListener('hidden.bs.modal', () => modal.remove());
})
.catch(error => alert('Error loading receipt details'));
}
function printReceipt(dbId) {
fetch(`/api/receipts/${dbId}/`)
.then(response => response.json())
.then(receipt => {
const formatMethod = (method) => {
const methods = { 'cash': 'Cash', 'check': 'Check', 'bank-transfer': 'Bank Transfer', 'credit-card': 'Credit Card' };
return methods[method] || method;
};
const printWindow = window.open('', '_blank');
printWindow.document.write(`
Receipt ${receipt.receipt_number}
Receipt #:
${receipt.receipt_number}
Customer:
${receipt.customer}
Amount:
$${parseFloat(receipt.amount).toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })}
Payment Method:
${formatMethod(receipt.payment_method)}
Reference:
${receipt.reference || 'N/A'}
${title}
${table.outerHTML}
${''}
${''}
`);
printWindow.document.close();
printWindow.print();
}
function exportAgingReport(type) {
const title = type === 'ar' ? 'Accounts_Receivable_Aging' : 'Accounts_Payable_Aging';
const tableId = type === 'ar' ? 'ar-aging-table' : 'ap-aging-table';
const table = document.getElementById(tableId);
if (!table) {
alert('Table not found');
return;
}
// Extract data from table
let csv = [];
const rows = table.querySelectorAll('tr');
rows.forEach(row => {
const cols = row.querySelectorAll('th, td');
const rowData = [];
cols.forEach(col => {
// Clean the text and escape commas/quotes
let text = col.textContent.trim().replace(/"/g, '""');
if (text.includes(',') || text.includes('"')) {
text = '"' + text + '"';
}
rowData.push(text);
});
csv.push(rowData.join(','));
});
// Create and download CSV file
const csvContent = csv.join('\n');
const blob = new Blob([csvContent], { type: 'text/csv;charset=utf-8;' });
const link = document.createElement('a');
const url = URL.createObjectURL(blob);
link.setAttribute('href', url);
link.setAttribute('download', `${title}_${new Date().toISOString().split('T')[0]}.csv`);
link.style.visibility = 'hidden';
document.body.appendChild(link);
link.click();
document.body.removeChild(link);
alert('Report exported successfully!');
}
// New Chart of Account Modal
function showNewChartAccountModal() {
const modal = document.createElement('div');
modal.id = 'new-chart-account-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = `
`;
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
modal.addEventListener('hidden.bs.modal', () => modal.remove());
}
function saveNewChartAccount() {
const code = document.getElementById('chart-code').value.trim();
const name = document.getElementById('chart-name').value.trim();
const type = document.getElementById('chart-type').value;
if (!code || !name || !type) {
alert('Please fill in all required fields.');
return;
}
const accountData = {
account_code: code,
name: name,
account_type: type,
description: document.getElementById('chart-description').value || ''
};
fetch('/api/chart-accounts/', {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify(accountData)
})
.then(response => {
if (!response.ok) throw new Error('Server error');
return response.json();
})
.then(data => {
console.log('Account saved to backend:', data);
bootstrap.Modal.getInstance(document.getElementById('new-chart-account-modal')).hide();
alert('Account created successfully!');
loadChartAccounts();
})
.catch(error => {
console.error('Error saving account:', error);
alert('Error saving account. Please make sure the backend server is running.');
});
}
// Load and display Chart of Accounts from backend
function loadChartAccounts() {
const tbody = document.getElementById('chart-accounts-table-body');
if (!tbody) return;
fetch('/api/chart-accounts/')
.then(response => {
if (!response.ok) throw new Error('Server error');
return response.json();
})
.then(data => {
let accounts = data.map(item => ({
code: item.account_code,
dbId: item.id,
name: item.name,
type: item.account_type,
description: item.description || ''
}));
renderChartAccounts(accounts);
})
.catch(error => {
console.error('Error loading accounts:', error);
tbody.innerHTML = 'Error loading data. Please make sure the backend server is running. No accounts found. Click "New Account" to create one.
${account.code}
${account.name}
${formatType(account.type)}
${account.description || '-'}
Edit
Delete
`).join('');
}
}
function filterChartAccounts(searchTerm) {
if (!searchTerm) {
loadChartAccounts();
return;
}
fetch(`/api/chart-accounts/?search=${encodeURIComponent(searchTerm)}`)
.then(response => response.json())
.then(data => {
let accounts = data.map(item => ({
code: item.account_code,
dbId: item.id,
name: item.name,
type: item.account_type,
description: item.description || ''
}));
renderChartAccounts(accounts);
})
.catch(error => console.error('Error filtering accounts:', error));
}
function editChartAccount(dbId) {
fetch(`/api/chart-accounts/${dbId}/`)
.then(response => response.json())
.then(account => {
showNewChartAccountModal();
setTimeout(() => {
document.getElementById('chart-code').value = account.account_code;
document.getElementById('chart-name').value = account.name;
document.getElementById('chart-type').value = account.account_type;
document.getElementById('chart-description').value = account.description || '';
}, 100);
})
.catch(error => alert('Error loading account details'));
}
function deleteChartAccount(dbId) {
if (!confirm('Are you sure you want to delete this account?')) return;
fetch(`/api/chart-accounts/${dbId}/`, {
method: 'DELETE'
})
.then(response => {
if (response.ok) {
alert('Account deleted successfully!');
loadChartAccounts();
} else {
throw new Error('Delete failed');
}
})
.catch(error => alert('Error deleting account'));
}
// Initialize Chart of Accounts on page load
document.addEventListener('DOMContentLoaded', function() {
loadChartAccounts();
});
// New Asset Modal
function showNewAssetModal() {
const modal = document.createElement('div');
modal.id = 'new-asset-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = `
`;
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
modal.addEventListener('hidden.bs.modal', () => modal.remove());
}
function saveNewAsset() {
const name = document.getElementById('asset-name').value.trim();
const category = document.getElementById('asset-category').value;
const date = document.getElementById('asset-date').value;
const cost = parseFloat(document.getElementById('asset-cost').value);
const life = parseInt(document.getElementById('asset-life').value);
if (!name || !category || !date || isNaN(cost) || cost <= 0 || isNaN(life) || life < 1) {
alert('Please fill in all required fields.');
return;
}
// Use PostgreSQL API
const assetData = {
name: name,
category: category,
acquisition_date: date,
acquisition_cost: cost,
useful_life: life,
depreciation_method: document.getElementById('asset-depreciation').value,
salvage_value: parseFloat(document.getElementById('asset-salvage').value) || 0,
location: document.getElementById('asset-location').value || ''
};
ElinomAPI.fixedAssets.create(assetData)
.then(function(response) {
bootstrap.Modal.getInstance(document.getElementById('new-asset-modal')).hide();
alert('Asset added successfully!');
// Reload the fixed assets table
if (typeof loadFixedAssets === 'function') {
loadFixedAssets();
}
})
.catch(function(error) {
console.error('Error creating asset:', error);
alert('Error creating asset: ' + error.message);
});
}
// Run Depreciation
function runDepreciation() {
if (!confirm('This will calculate depreciation for all assets. Continue?')) return;
// Fetch assets from PostgreSQL via API
fetch('/api/fixed-assets/')
.then(function(response) {
if (!response.ok) throw new Error('Server error');
return response.json();
})
.then(function(data) {
const assets = data.results || data;
if (!assets || assets.length === 0) {
alert('No assets found to depreciate. Please add assets first.');
return;
}
let total = 0;
assets.forEach(function(asset) {
const cost = parseFloat(asset.purchase_cost || asset.cost || 0);
const salvage = parseFloat(asset.salvage_value || asset.salvage || 0);
const life = parseFloat(asset.useful_life || asset.life || 1);
total += (cost - salvage) / life;
});
alert('Depreciation calculated successfully!\n\nTotal Annual Depreciation: $' + total.toFixed(2) + '\n\nAssets Processed: ' + assets.length);
})
.catch(function(error) {
console.error('Error fetching assets:', error);
alert('Failed to load assets. Please make sure the backend server is running.');
});
}
// Record Disposal Modal
// Global function to save disposal - called from button onclick
window.saveRecordedDisposal = function() {
try {
const assetSelect = document.getElementById('disposal-asset');
const assetId = assetSelect.value;
const selectedOption = assetSelect.options[assetSelect.selectedIndex];
const date = document.getElementById('disposal-date').value;
const method = document.getElementById('disposal-method').value;
if (!assetId || !date || !method) {
alert('Please fill in all required fields.');
return;
}
const disposalData = {
asset: parseInt(assetId),
asset_number: selectedOption.dataset.number || '',
asset_name: selectedOption.dataset.name || '',
disposal_date: date,
disposal_method: method,
sale_proceeds: parseFloat(document.getElementById('disposal-proceeds').value) || 0,
book_value_at_disposal: parseFloat(document.getElementById('disposal-book-value').value) || 0,
notes: document.getElementById('disposal-notes').value || ''
};
console.log('Saving disposal:', disposalData);
// Disable button while saving
const btn = document.getElementById('save-disposal-btn');
if (btn) {
btn.disabled = true;
btn.innerHTML = 'Loading assets... ';
const modal = document.createElement('div');
modal.id = 'record-disposal-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = `
`;
document.body.appendChild(modal);
const bsModal = new bootstrap.Modal(modal);
bsModal.show();
modal.addEventListener('hidden.bs.modal', () => {
modal.remove();
document.querySelectorAll('.modal-backdrop').forEach(b => b.remove());
});
// Fetch assets from API and populate dropdown
try {
const data = await ElinomAPI.fixedAssets.list();
const assets = data.results || data;
const select = document.getElementById('disposal-asset');
if (select && assets.length > 0) {
select.innerHTML = 'Select Asset ' +
assets
.filter(a => a.status === 'active')
.map(a => `${a.asset_number} - ${a.name} `)
.join('');
} else if (select) {
select.innerHTML = 'No active assets found ';
}
} catch (error) {
console.error('Error loading assets:', error);
const select = document.getElementById('disposal-asset');
if (select) {
select.innerHTML = 'Error loading assets ';
}
}
}
function updateDisposalBookValue() {
const select = document.getElementById('disposal-asset');
const selectedOption = select.options[select.selectedIndex];
const bookValue = selectedOption.dataset.bookValue || 0;
document.getElementById('disposal-book-value').value = bookValue;
}
// New Voucher Modal
function showNewVoucherModal() {
const modal = document.createElement('div');
modal.id = 'new-voucher-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = `
`;
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
modal.addEventListener('hidden.bs.modal', () => modal.remove());
}
function saveNewVoucher() {
const vendor = document.getElementById('voucher-vendor').value.trim();
const amount = parseFloat(document.getElementById('voucher-amount').value);
const date = document.getElementById('voucher-date').value;
if (!vendor || isNaN(amount) || amount <= 0 || !date) {
alert('Please fill in all required fields.');
return;
}
// Save to PostgreSQL via API
fetch('/api/payment-vouchers/', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({
vendor: vendor,
amount: amount,
payment_date: date,
payment_method: document.getElementById('voucher-method').value.replace('-', '_'),
description: document.getElementById('voucher-description').value
})
})
.then(response => {
if (!response.ok) throw new Error('Failed to create voucher');
return response.json();
})
.then(data => {
bootstrap.Modal.getInstance(document.getElementById('new-voucher-modal')).hide();
alert('Payment voucher created successfully!');
loadPaymentVouchersFromAPI();
})
.catch(error => {
console.error('Error creating voucher:', error);
alert('Failed to create voucher: ' + error.message);
});
}
// Load Payment Vouchers from PostgreSQL API
function loadPaymentVouchersFromAPI() {
const tbody = document.querySelector('#payment-vouchers table tbody');
if (!tbody) return;
tbody.innerHTML = 'No payment vouchers found.
${v.voucher_number} ${v.vendor}
${v.payment_date}
$${parseFloat(v.amount).toFixed(2)}
View
Delete
`).join('');
// Update pagination text
const pagination = document.querySelector('#payment-vouchers .pagination span');
if (pagination) {
pagination.textContent = 'Showing 1-' + vouchers.length + ' of ' + vouchers.length;
}
})
.catch(error => {
console.error('Error loading vouchers:', error);
tbody.innerHTML = 'Error loading vouchers.
Cash
Accounts Receivable
Inventory
Accounts Payable
Sales Revenue
Expense
Error loading data. Please make sure the backend server is running. No journal entries found. Click "New Entry" to create one.
${entry.date}
${entry.id}
${entry.description}
$${entry.debitTotal.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })}
$${entry.creditTotal.toLocaleString('en-US', { minimumFractionDigits: 2, maximumFractionDigits: 2 })}
View
Delete
`).join('');
}
const showingEl = document.getElementById('journal-entries-showing');
if (showingEl) {
showingEl.textContent = entries.length === 0
? 'No entries found'
: `Showing ${entries.length} entries`;
}
}
function filterJournalEntries(searchTerm) {
if (!searchTerm) {
loadJournalEntries();
return;
}
fetch(`/api/journal-entries/?search=${encodeURIComponent(searchTerm)}`)
.then(response => response.json())
.then(data => {
// Handle paginated response
const items = data.results || data;
let entries = items.map(item => ({
id: item.entry_number,
dbId: item.id,
date: item.date,
description: item.description,
debitTotal: parseFloat(item.debit_total),
creditTotal: parseFloat(item.credit_total),
reference: item.reference || ''
}));
renderJournalEntries(entries);
})
.catch(error => console.error('Error filtering:', error));
}
function viewJournalEntry(dbId) {
fetch(`/api/journal-entries/${dbId}/`)
.then(response => response.json())
.then(entry => {
alert(`Journal Entry: ${entry.entry_number}\nDate: ${entry.date}\nDescription: ${entry.description}\nDebit: $${parseFloat(entry.debit_total).toFixed(2)}\nCredit: $${parseFloat(entry.credit_total).toFixed(2)}\nReference: ${entry.reference || 'N/A'}`);
})
.catch(error => alert('Error loading entry details'));
}
function deleteJournalEntry(dbId) {
if (!confirm('Are you sure you want to delete this journal entry?')) return;
fetch(`/api/journal-entries/${dbId}/`, {
method: 'DELETE'
})
.then(response => {
if (response.ok) {
alert('Journal entry deleted successfully!');
loadJournalEntries();
} else {
throw new Error('Delete failed');
}
})
.catch(error => alert('Error deleting entry'));
}
// Initialize Journal Entries on page load
document.addEventListener('DOMContentLoaded', function() {
loadJournalEntries();
// Restore base-currency dropdown from DB
fetch('/api/settings/currency/')
.then(function(r){ return r.ok ? r.json() : null; })
.then(function(d){ if (d) { var bd=document.getElementById('base-currency'); if(bd) bd.value=d.code; } })
.catch(function(){});
});
// Create Bill Modal
function showCreateBillModal() {
// Remove any existing modal with the same ID
const existingModal = document.getElementById('create-bill-modal');
if (existingModal) existingModal.remove();
document.querySelectorAll('.modal-backdrop').forEach(b => b.remove());
// Remove any conflicting style elements
document.querySelectorAll('style[data-modal-style]').forEach(s => s.remove());
const modal = document.createElement('div');
modal.id = 'create-bill-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.cssText = 'z-index:99999 !important;';
// Add critical style for this modal
const styleEl = document.createElement('style');
styleEl.setAttribute('data-modal-style', 'create-bill');
styleEl.textContent = `
#create-bill-modal { z-index: 99999 !important; }
#create-bill-modal .modal-dialog { z-index: 100000 !important; pointer-events: auto !important; }
#create-bill-modal .modal-content { z-index: 100001 !important; pointer-events: auto !important; }
#create-bill-modal .modal-body { pointer-events: auto !important; position: relative !important; z-index: 100005 !important; }
#create-bill-modal .modal-body *, #create-bill-modal form, #create-bill-modal form * { pointer-events: auto !important; }
#create-bill-modal .input-group { pointer-events: auto !important; position: relative !important; z-index: 100010 !important; }
#create-bill-modal input, #create-bill-modal textarea, #create-bill-modal select {
pointer-events: auto !important;
user-select: text !important;
-webkit-user-select: text !important;
position: relative !important;
z-index: 100010 !important;
background-color: #fff !important;
color: #333 !important;
cursor: text !important;
opacity: 1 !important;
}
#create-bill-modal input:focus, #create-bill-modal textarea:focus {
outline: 2px solid #dc3545 !important;
box-shadow: 0 0 0 0.2rem rgba(220, 53, 69, 0.25) !important;
}
#create-bill-modal input[type="date"] { cursor: pointer !important; }
#create-bill-modal input[type="number"] { cursor: text !important; }
`;
document.head.appendChild(styleEl);
const inputStyle = 'pointer-events:auto !important;background:#fff !important;color:#333 !important;border:1px solid #ced4da !important;position:relative;z-index:100010;cursor:text !important;-webkit-user-select:text !important;user-select:text !important;';
const labelStyle = 'color:#333 !important;font-weight:500;';
modal.innerHTML = `
`;
document.body.appendChild(modal);
const bsModal = new bootstrap.Modal(modal);
bsModal.show();
modal.addEventListener('shown.bs.modal', function() {
const backdrop = document.querySelector('.modal-backdrop');
if (backdrop) backdrop.style.zIndex = '99998';
// Make all inputs explicitly focusable via click
modal.querySelectorAll('input, textarea, select').forEach(el => {
el.addEventListener('click', function(e) {
e.stopPropagation();
this.focus();
});
el.addEventListener('mousedown', function(e) {
e.stopPropagation();
});
});
setTimeout(() => document.getElementById('bill-vendor').focus(), 100);
});
modal.addEventListener('hidden.bs.modal', () => {
modal.remove();
const style = document.querySelector('style[data-modal-style="create-bill"]');
if (style) style.remove();
});
}
function saveNewBill() {
const vendor = document.getElementById('bill-vendor').value.trim();
const date = document.getElementById('bill-date').value;
const dueDate = document.getElementById('bill-due-date').value;
const amount = parseFloat(document.getElementById('bill-amount').value);
const description = document.getElementById('bill-description').value;
if (!vendor || !date || !dueDate || isNaN(amount) || amount <= 0) {
alert('Please fill in all required fields.');
return;
}
// Save to backend API
fetch('/api/vendor-bills/', {
method: 'POST',
headers: {
'Content-Type': 'application/json',
},
body: JSON.stringify({
vendor: vendor,
bill_date: date,
due_date: dueDate,
amount: amount,
description: description,
status: 'pending'
})
})
.then(response => {
if (!response.ok) throw new Error('Failed to create bill');
return response.json();
})
.then(newBill => {
// Add the new bill to the table
const tbody = document.querySelector('#vendor-bills-table tbody');
if (tbody) {
const row = document.createElement('tr');
row.setAttribute('data-id', newBill.id);
row.innerHTML = '' + newBill.bill_number + ' ' +
'' + newBill.vendor + ' ' +
'' + newBill.bill_date + ' ' +
'' + newBill.due_date + ' ' +
'$' + parseFloat(newBill.amount).toFixed(2) + ' ' +
'Pending ' +
'
' + b.bill_number + ' - ' + b.vendor + ' ($' + parseFloat(b.amount).toFixed(2) + ') ').join('')
: 'No pending bills available ';
const modal = document.createElement('div');
modal.id = 'bulk-payment-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.cssText = 'z-index:99999 !important;';
modal.innerHTML = `
`;
document.body.appendChild(modal);
const bsModal = new bootstrap.Modal(modal);
bsModal.show();
modal.addEventListener('shown.bs.modal', function() {
const backdrop = document.querySelector('.modal-backdrop');
if (backdrop) backdrop.style.zIndex = '99998';
});
modal.addEventListener('hidden.bs.modal', () => modal.remove());
})
.catch(error => {
console.error('Error loading pending bills:', error);
alert('Failed to load pending bills. Please make sure the backend server is running.');
});
}
function processBulkPayment() {
const select = document.getElementById('bulk-bills');
const selectedBills = Array.from(select.selectedOptions).map(opt => ({
id: opt.value,
text: opt.textContent
}));
const paymentMethod = document.getElementById('bulk-payment-method').value;
if (selectedBills.length === 0) {
alert('Please select at least one bill to pay.');
return;
}
console.log('Processing payments for:', selectedBills);
// Process each bill payment via API
const paymentPromises = selectedBills.map(bill =>
fetch('/api/vendor-bills/' + bill.id + '/pay/', {
method: 'POST',
mode: 'cors',
headers: {
'Content-Type': 'application/json',
'Accept': 'application/json'
},
body: JSON.stringify({ payment_method: paymentMethod })
}).then(async r => {
console.log('Response for bill', bill.id, ':', r.status, r.statusText);
const data = await r.json().catch(() => ({}));
console.log('Data:', data);
return { ok: r.ok, billId: bill.id, billText: bill.text, data: data, status: r.status };
}).catch(e => {
console.error('Fetch error for bill', bill.id, ':', e);
return { ok: false, billId: bill.id, billText: bill.text, error: e.message };
})
);
Promise.all(paymentPromises)
.then(results => {
console.log('All results:', results);
const succeeded = results.filter(r => r.ok);
const failed = results.filter(r => !r.ok);
const modal = document.getElementById('bulk-payment-modal');
if (modal) {
const bsModal = bootstrap.Modal.getInstance(modal);
if (bsModal) bsModal.hide();
}
if (failed.length === 0) {
alert('Bulk payment processed successfully!\n\nBills Paid: ' + succeeded.length);
} else if (succeeded.length > 0) {
const failedList = failed.map(f => '• ' + f.billText + (f.data?.error ? ' (' + f.data.error + ')' : '')).join('\n');
alert('Partial success!\n\nBills Paid: ' + succeeded.length + '\nFailed: ' + failed.length + '\n\n' + failedList);
} else {
const failedList = failed.map(f => '• ' + f.billText + (f.data?.error ? ' (' + f.data.error + ')' : '')).join('\n');
alert('Failed to process payments:\n\n' + failedList);
}
loadVendorBills();
})
.catch(error => {
console.error('Error processing bulk payment:', error);
alert('Failed to process payments. Please try again.');
});
}
// Show Overdue Bills Function
function showOverdueBills() {
// Remove any existing modal
const existingModal = document.getElementById('overdue-bills-modal');
if (existingModal) existingModal.remove();
document.querySelectorAll('.modal-backdrop').forEach(b => b.remove());
fetch('/api/vendor-bills/?status=overdue')
.then(response => response.json())
.then(data => {
const overdueBills = data.results || data;
if (overdueBills.length === 0) {
alert('No overdue bills found.\n\nAll bills are paid or not yet due.');
return;
}
const today = new Date();
const billRows = overdueBills.map(b => {
const daysOverdue = Math.floor((today - new Date(b.due_date)) / (1000 * 60 * 60 * 24));
return '' +
'' + (b.bill_number || '') + ' ' +
'' + (b.vendor || '') + ' ' +
'$' + parseFloat(b.amount || 0).toFixed(2) + ' ' +
'' + (b.due_date || '') + ' ' +
'' + daysOverdue + ' days ' +
' ';
}).join('');
const totalOverdue = overdueBills.reduce((sum, b) => sum + parseFloat(b.amount), 0);
const modal = document.createElement('div');
modal.id = 'overdue-bills-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.cssText = 'z-index:99999 !important;display:flex !important;align-items:center !important;justify-content:center !important;';
// Add style for checkboxes and centering
const styleEl = document.createElement('style');
styleEl.textContent = `
#overdue-bills-modal { display: flex !important; align-items: center !important; justify-content: center !important; }
#overdue-bills-modal.show { display: flex !important; }
#overdue-bills-modal .modal-dialog { margin: auto !important; display: flex !important; align-items: center !important; min-height: auto !important; }
#overdue-bills-modal .form-check-input { pointer-events: auto !important; position: relative !important; z-index: 100010 !important; opacity: 1 !important; }
#overdue-bills-modal td, #overdue-bills-modal th { pointer-events: auto !important; }
`;
document.head.appendChild(styleEl);
modal.innerHTML = '' +
'
' +
'' +
'
' +
'
' +
'Total Overdue Amount: $' + totalOverdue.toFixed(2) +
'
' +
'
' +
'
' +
'' +
'
' +
'
×
Set up email notifications for tax deadlines and reminders
Email Address
Reminder Frequency
Daily digest
Weekly summary
As needed (individual alerts)
Cancel
Save Alerts
`;
// Close on backdrop click
modal.addEventListener('click', (e) => {
if (e.target === modal) modal.remove();
});
}
async function saveAlertSettings() {
const TAX_API_BASE = '/api';
const email = document.getElementById('alert-email').value;
const deadlines = document.getElementById('alert-deadlines').checked;
const filings = document.getElementById('alert-filings').checked;
const overdue = document.getElementById('alert-overdue').checked;
const reports = document.getElementById('alert-reports').checked;
const frequency = document.getElementById('alert-frequency').value;
if (!email) {
alert('Please enter an email address');
return;
}
// Show loading state on button
const btn = document.getElementById('save-alerts-btn');
const originalText = btn.innerHTML;
btn.innerHTML = '
Alerts Configured!
You'll receive tax reminders at ${email}
Done
`;
} catch (error) {
console.error('Error saving alert settings:', error);
btn.innerHTML = originalText;
btn.disabled = false;
alert('Failed to save settings. Please try again.');
}
}
async function sendTestEmail() {
const TAX_API_BASE = '/api';
const email = document.getElementById('alert-email').value;
if (!email) {
alert('Please enter an email address first');
return;
}
const btn = document.getElementById('test-email-btn');
const originalText = btn.innerHTML;
btn.innerHTML = 'Receipt
ELINOM POS SYSTEM
Date: ${new Date().toLocaleString()}
Customer: ${currentCustomer}
Total: $${total.toFixed(2)}
Payment Method: ${paymentMethod}
Thank you for your business!
${''}
${''}
`);
receiptWindow.document.close();
receiptWindow.print();
}
// Global functions for onclick handlers
window.addToCart = addToCart;
window.updateQuantity = updateQuantity;
window.setQuantity = setQuantity;
// Enhanced POS Functions
function updateMetrics() {
const dailySalesElement = document.getElementById("pos-daily-sales");
const transactionsElement =
document.getElementById("pos-transactions");
const avgSaleElement = document.getElementById("pos-avg-sale");
if (dailySalesElement)
dailySalesElement.textContent = `$${dailySales.toFixed(2)}`;
if (transactionsElement)
transactionsElement.textContent = transactionCount;
if (avgSaleElement && transactionCount > 0) {
avgSaleElement.textContent = `$${(
dailySales / transactionCount
).toFixed(2)}`;
}
}
function updateCustomerInfo() {
const customer = customers.find((c) => c.id === currentCustomer);
const infoElement = document.getElementById("pos-customer-info");
if (customer && customer.id !== "walk-in" && infoElement) {
document.getElementById("customer-phone").textContent =
customer.phone;
document.getElementById("customer-email").textContent =
customer.email;
infoElement.style.display = "block";
} else if (infoElement) {
infoElement.style.display = "none";
}
}
function showPaymentModal() {
if (cart.length === 0) {
alert("Cart is empty!");
return;
}
const modal = new bootstrap.Modal(
document.getElementById("posPaymentModal")
);
updatePaymentSummary();
modal.show();
}
function updatePaymentSummary() {
const subtotal = calculateSubtotal();
const tax = taxExempt ? 0 : subtotal * taxRate;
const total = subtotal - discountAmount + tax;
document.getElementById(
"payment-subtotal"
).textContent = `$${subtotal.toFixed(2)}`;
document.getElementById(
"payment-discount"
).textContent = `-$${discountAmount.toFixed(2)}`;
document.getElementById("payment-tax").textContent = `$${tax.toFixed(
2
)}`;
document.getElementById(
"payment-total"
).textContent = `$${total.toFixed(2)}`;
}
function selectPaymentMethod(method) {
document
.querySelectorAll(".pos-payment-method")
.forEach((m) => m.classList.remove("selected"));
document
.querySelector(`[data-method="${method}"]`)
.classList.add("selected");
document
.querySelectorAll(".payment-detail")
.forEach((d) => (d.style.display = "none"));
document.getElementById("payment-details").style.display = "block";
document.getElementById(`${method}-details`).style.display = "block";
const completeBtn = document.getElementById("complete-payment");
completeBtn.disabled = false;
if (method === "cash") {
document.getElementById("cash-received").focus();
} else {
setTimeout(() => {
document.querySelector(
`#${method}-details .spinner-border`
).style.display = "inline-block";
setTimeout(() => {
document.querySelector(
`#${method}-details .spinner-border`
).style.display = "none";
completeBtn.disabled = false;
}, 2000);
}, 500);
}
}
function handleKeypadInput(value) {
const cashInput = document.getElementById("cash-received");
if (value === "clear") {
cashInput.value = "";
} else if (value === ".") {
if (!cashInput.value.includes(".")) {
cashInput.value += value;
}
} else {
cashInput.value += value;
}
calculateChange();
}
function calculateChange() {
const received =
parseFloat(document.getElementById("cash-received").value) || 0;
const total =
calculateSubtotal() -
discountAmount +
(taxExempt ? 0 : calculateSubtotal() * taxRate);
const change = received - total;
document.getElementById("change-due").value =
change >= 0 ? `$${change.toFixed(2)}` : "$0.00";
document.getElementById("complete-payment").disabled = change < 0;
}
function completePayment() {
const total =
calculateSubtotal() -
discountAmount +
(taxExempt ? 0 : calculateSubtotal() * taxRate);
// Update metrics
dailySales += total;
transactionCount++;
updateMetrics();
// Generate receipt
generateReceipt();
// Clear cart
cart = [];
discountAmount = 0;
taxExempt = false;
updateCartDisplay();
// Close payment modal and show receipt
bootstrap.Modal.getInstance(
document.getElementById("posPaymentModal")
).hide();
setTimeout(() => {
const receiptModal = new bootstrap.Modal(
document.getElementById("posReceiptModal")
);
receiptModal.show();
}, 500);
}
function generateReceipt() {
const now = new Date();
const subtotal = calculateSubtotal();
const tax = taxExempt ? 0 : subtotal * taxRate;
const total = subtotal - discountAmount + tax;
const customer = customers.find((c) => c.id === currentCustomer);
const receipt = `
ELINOM ACCOUNTING SYSTEM
Point of Sale Receipt
${"-".repeat(35)}
Date: ${now.toLocaleDateString()}
Time: ${now.toLocaleTimeString()}
Transaction #: TXN-${Date.now()}
Customer: ${customer.name}
${"-".repeat(35)}
${cart
.map(
(item) => `${item.name}
${item.quantity} x $${item.price.toFixed(2)} = $${(
item.quantity * item.price
).toFixed(2)}`
)
.join("\n\n")}
${"-".repeat(35)}
Subtotal: $${subtotal.toFixed(2)}
${discountAmount > 0 ? `Discount: -$${discountAmount.toFixed(2)}\n` : ""}${
taxExempt ? "TAX EXEMPT\n" : `Tax (8.5%): $${tax.toFixed(2)}\n`
}Total: $${total.toFixed(2)}
${"-".repeat(35)}
Thank you for your business!
Visit us again soon.
`;
document.getElementById("receipt-content").textContent = receipt;
}
function showQuickItemsModal() {
const modal = new bootstrap.Modal(
document.getElementById("posQuickItemsModal")
);
modal.show();
}
function addQuickItemToCart(name, price) {
const quickItem = {
id: Date.now(),
name: name,
price: price,
quantity: 1,
};
const existingItem = cart.find((item) => item.name === name);
if (existingItem) {
existingItem.quantity++;
} else {
cart.push(quickItem);
}
updateCartDisplay();
bootstrap.Modal.getInstance(
document.getElementById("posQuickItemsModal")
).hide();
}
function showDiscountModal() {
const modal = new bootstrap.Modal(
document.getElementById("posDiscountModal")
);
modal.show();
}
function applyDiscount() {
const type = document.getElementById("discount-type").value;
const value =
parseFloat(document.getElementById("discount-value").value) || 0;
const subtotal = calculateSubtotal();
if (type === "percentage") {
discountAmount = (subtotal * value) / 100;
} else {
discountAmount = value;
}
// Ensure discount doesn't exceed subtotal
discountAmount = Math.min(discountAmount, subtotal);
updateCartDisplay();
bootstrap.Modal.getInstance(
document.getElementById("posDiscountModal")
).hide();
}
function showAddCustomerModal() {
document
.getElementById("posAddCustomerModal")
.querySelector("form")
.reset();
const modal = new bootstrap.Modal(
document.getElementById("posAddCustomerModal")
);
modal.show();
}
function saveNewCustomer() {
const name = document.getElementById("customer-name").value;
const email = document.getElementById("customer-email").value;
const phone = document.getElementById("customer-phone").value;
if (!name.trim()) {
alert("Customer name is required!");
return;
}
const newCustomer = {
id: Date.now().toString(),
name: name.trim(),
email: email.trim(),
phone: phone.trim(),
};
customers.push(newCustomer);
// Update customer select
const select = document.getElementById("pos-customer-select");
const option = document.createElement("option");
option.value = newCustomer.id;
option.textContent = newCustomer.name;
select.appendChild(option);
select.value = newCustomer.id;
currentCustomer = newCustomer.id;
updateCustomerInfo();
bootstrap.Modal.getInstance(
document.getElementById("posAddCustomerModal")
).hide();
}
function newSale() {
cart = [];
discountAmount = 0;
taxExempt = false;
currentCustomer = "walk-in";
document.getElementById("pos-customer-select").value = "walk-in";
updateCartDisplay();
updateCustomerInfo();
}
function holdSale() {
if (cart.length === 0) {
alert("Cart is empty!");
return;
}
const heldSale = {
id: Date.now(),
cart: [...cart],
customer: currentCustomer,
discount: discountAmount,
taxExempt: taxExempt,
timestamp: new Date(),
};
heldSales.push(heldSale);
// Clear current sale
newSale();
alert("Sale held successfully!");
updateHeldSalesCount();
}
function updateHeldSalesCount() {
const countElement = document.querySelector("#pos-held-sales small");
if (countElement) {
countElement.textContent = `${heldSales.length} pending`;
}
}
function startBarcodeScanning() {
const searchInput = document.getElementById("pos-product-search");
searchInput.placeholder = "Scan barcode...";
searchInput.focus();
// Simulate barcode scanning
setTimeout(() => {
searchInput.placeholder = "Search products by name or barcode...";
}, 3000);
}
function printReceipt() {
window.print();
}
function emailReceipt() {
const customer = customers.find((c) => c.id === currentCustomer);
if (customer && customer.email) {
alert(`Receipt emailed to ${customer.email}`);
} else {
alert("Customer email not available");
}
}
// Enhanced product rendering with stock status
function renderProducts(searchTerm = "") {
const container = document.getElementById("pos-products-container");
if (!container) return;
let filteredProducts = products.filter((product) => {
const matchesCategory =
currentCategory === "all" || product.category === currentCategory;
const matchesSearch =
!searchTerm ||
product.name.toLowerCase().includes(searchTerm.toLowerCase()) ||
product.barcode.includes(searchTerm);
return matchesCategory && matchesSearch;
});
const startIndex = (currentPage - 1) * productsPerPage;
const endIndex = startIndex + productsPerPage;
const paginatedProducts = filteredProducts.slice(
startIndex,
endIndex
);
container.innerHTML = paginatedProducts
.map((product) => {
let stockStatus = "";
let cardClass = "pos-product-card";
if (product.stock === 0) {
stockStatus = "Out of Stock";
cardClass += " pos-out-of-stock";
} else if (product.stock <= 5) {
stockStatus = "Low Stock";
cardClass += " pos-low-stock";
} else {
stockStatus = `${product.stock} in stock`;
}
if (product.favorite) {
cardClass += " pos-favorite-product";
}
return `
${product.name}
$${product.price.toFixed(
2
)}
${stockStatus}
${
product.stock > 0
? '
'
: '
Out of Stock '
}
`;
})
.join("");
renderPagination(filteredProducts.length);
}
window.removeFromCart = removeFromCart;
window.changePage = function (page) {
if (page >= 1) {
currentPage = page;
renderProducts();
}
};
// Initialize POS when the section is loaded
document.addEventListener("DOMContentLoaded", function () {
const checkInterval = setInterval(function () {
if (document.getElementById("pos-products-container")) {
initPOS();
clearInterval(checkInterval);
}
}, 100);
});
})();
// Inventory Management Module
(function () {
let inventoryItems = [];
let filteredItems = [];
let currentView = "table";
let currentPage = 1;
const itemsPerPage = 10;
let selectedItems = new Set();
function initInventoryManagement() {
loadInventoryData();
setupEventListeners();
updateMetrics();
renderInventoryList();
}
function loadInventoryData() {
const savedData = window._acctStore.get("inventoryItems");
if (savedData && savedData.length > 0) {
inventoryItems = savedData;
} else {
// Sample inventory data
inventoryItems = [
{
id: 1,
name: "Wireless Headphones",
sku: "WH-001",
category: "Electronics",
location: "Warehouse A",
stock: 45,
minStock: 10,
maxStock: 100,
cost: 75.0,
price: 149.99,
lastUpdated: "2024-01-15",
movements: [
{
date: "2024-01-15",
type: "Purchase",
quantity: 50,
note: "Initial stock",
},
{
date: "2024-01-10",
type: "Sale",
quantity: -5,
note: "Customer order #1234",
},
],
},
{
id: 2,
name: "Gaming Mouse",
sku: "GM-002",
category: "Electronics",
location: "Warehouse B",
stock: 8,
minStock: 15,
maxStock: 75,
cost: 25.0,
price: 59.99,
lastUpdated: "2024-01-14",
movements: [
{
date: "2024-01-14",
type: "Purchase",
quantity: 25,
note: "Supplier restock",
},
{
date: "2024-01-12",
type: "Sale",
quantity: -17,
note: "Bulk order",
},
],
},
{
id: 3,
name: "Office Chair",
sku: "OC-003",
category: "Furniture",
location: "Warehouse A",
stock: 0,
minStock: 5,
maxStock: 30,
cost: 120.0,
price: 249.99,
lastUpdated: "2024-01-13",
movements: [
{
date: "2024-01-13",
type: "Sale",
quantity: -12,
note: "Office setup order",
},
{
date: "2024-01-08",
type: "Purchase",
quantity: 12,
note: "Monthly restock",
},
],
},
{
id: 4,
name: "Bluetooth Speaker",
sku: "BS-004",
category: "Electronics",
location: "Warehouse C",
stock: 32,
minStock: 8,
maxStock: 50,
cost: 35.0,
price: 79.99,
lastUpdated: "2024-01-16",
movements: [
{
date: "2024-01-16",
type: "Purchase",
quantity: 40,
note: "New supplier",
},
{
date: "2024-01-14",
type: "Sale",
quantity: -8,
note: "Retail orders",
},
],
},
{
id: 5,
name: "Desk Lamp",
sku: "DL-005",
category: "Furniture",
location: "Warehouse B",
stock: 18,
minStock: 12,
maxStock: 40,
cost: 15.0,
price: 34.99,
lastUpdated: "2024-01-15",
movements: [
{
date: "2024-01-15",
type: "Purchase",
quantity: 30,
note: "Regular restock",
},
{
date: "2024-01-12",
type: "Sale",
quantity: -12,
note: "Online orders",
},
],
},
];
saveInventoryData();
}
filteredItems = [...inventoryItems];
}
function saveInventoryData() {
window._acctStore.set("inventoryItems", inventoryItems);
}
function setupEventListeners() {
// Search functionality
document
.getElementById("invSearchInput")
?.addEventListener("input", handleSearch);
// Filter dropdowns
document
.getElementById("invCategoryFilter")
?.addEventListener("change", applyFilters);
document
.getElementById("invLocationFilter")
?.addEventListener("change", applyFilters);
document
.getElementById("invStockFilter")
?.addEventListener("change", applyFilters);
// View toggle
document
.getElementById("invTableView")
?.addEventListener("click", () => switchView("table"));
document
.getElementById("invGridView")
?.addEventListener("click", () => switchView("grid"));
// Bulk action buttons
document
.getElementById("invBulkAdjust")
?.addEventListener("click", showBulkAdjustModal);
document
.getElementById("invBulkMove")
?.addEventListener("click", showBulkMoveModal);
document
.getElementById("invBulkExport")
?.addEventListener("click", exportSelectedItems);
// Add new item button
document
.getElementById("addInventoryBtn")
?.addEventListener("click", showAddItemModal);
// Select all checkbox
document
.getElementById("invSelectAll")
?.addEventListener("change", handleSelectAll);
}
function handleSearch() {
const searchTerm = document
.getElementById("invSearchInput")
.value.toLowerCase();
applyFilters();
}
function applyFilters() {
const searchTerm = document
.getElementById("invSearchInput")
.value.toLowerCase();
const categoryFilter =
document.getElementById("invCategoryFilter").value;
const locationFilter =
document.getElementById("invLocationFilter").value;
const stockFilter = document.getElementById("invStockFilter").value;
filteredItems = inventoryItems.filter((item) => {
const matchesSearch =
item.name.toLowerCase().includes(searchTerm) ||
item.sku.toLowerCase().includes(searchTerm);
const matchesCategory =
!categoryFilter || item.category === categoryFilter;
const matchesLocation =
!locationFilter || item.location === locationFilter;
let matchesStock = true;
if (stockFilter === "in-stock") {
matchesStock = item.stock > item.minStock;
} else if (stockFilter === "low-stock") {
matchesStock = item.stock <= item.minStock && item.stock > 0;
} else if (stockFilter === "out-of-stock") {
matchesStock = item.stock === 0;
}
return (
matchesSearch &&
matchesCategory &&
matchesLocation &&
matchesStock
);
});
currentPage = 1;
selectedItems.clear();
updateBulkActions();
renderInventoryList();
}
function switchView(viewType) {
currentView = viewType;
// Update active button
document
.querySelectorAll(".inv-view-btn")
.forEach((btn) => btn.classList.remove("active"));
document
.getElementById(
viewType === "table" ? "invTableView" : "invGridView"
)
.classList.add("active");
renderInventoryList();
}
function updateMetrics() {
const totalItems = inventoryItems.length;
const totalValue = inventoryItems.reduce(
(sum, item) => sum + item.stock * item.cost,
0
);
const lowStockItems = inventoryItems.filter(
(item) => item.stock <= item.minStock && item.stock > 0
).length;
const locations = [
...new Set(inventoryItems.map((item) => item.location)),
].length;
document.getElementById("invTotalItems").textContent = totalItems;
document.getElementById(
"invTotalValue"
).textContent = `$${totalValue.toLocaleString()}`;
document.getElementById("invLowStock").textContent = lowStockItems;
document.getElementById("invLocations").textContent = locations;
}
function renderInventoryList() {
const container = document.getElementById("inventoryList");
if (!container) return;
const startIndex = (currentPage - 1) * itemsPerPage;
const endIndex = startIndex + itemsPerPage;
const paginatedItems = filteredItems.slice(startIndex, endIndex);
if (currentView === "table") {
container.innerHTML = renderTableView(paginatedItems);
} else {
container.innerHTML = renderGridView(paginatedItems);
}
updatePagination();
updateBulkActions();
}
function renderTableView(items) {
return `
`;
}
function renderGridView(items) {
return `
${items
.map(
(item) => `
${item.name}
SKU:
${item.sku}
Stock:
${item.stock}
Location:
${item.location}
Value:
$${(
item.stock * item.cost
).toLocaleString()}
${getStockStatusText(item)}
`
)
.join("")}
`;
}
function getStockStatus(item) {
if (item.stock === 0) return "out-of-stock";
if (item.stock <= item.minStock) return "low-stock";
return "in-stock";
}
function getStockStatusText(item) {
if (item.stock === 0) return "Out of Stock";
if (item.stock <= item.minStock) return "Low Stock";
return "In Stock";
}
function updatePagination() {
const totalPages = Math.ceil(filteredItems.length / itemsPerPage);
const startItem = (currentPage - 1) * itemsPerPage + 1;
const endItem = Math.min(
currentPage * itemsPerPage,
filteredItems.length
);
document.getElementById(
"invPaginationInfo"
).textContent = `Showing ${startItem}-${endItem} of ${filteredItems.length} items`;
const prevBtn = document.getElementById("invPrevPage");
const nextBtn = document.getElementById("invNextPage");
if (prevBtn) prevBtn.disabled = currentPage === 1;
if (nextBtn) nextBtn.disabled = currentPage === totalPages;
// Update page numbers
const pageNumbers = document.getElementById("invPageNumbers");
if (pageNumbers) {
let pageHTML = "";
for (let i = 1; i <= totalPages; i++) {
if (i === currentPage) {
pageHTML += ``;
} else {
pageHTML += ``;
}
}
pageNumbers.innerHTML = pageHTML;
}
}
function handleSelectAll(event) {
const isChecked = event.target.checked;
const startIndex = (currentPage - 1) * itemsPerPage;
const endIndex = startIndex + itemsPerPage;
const paginatedItems = filteredItems.slice(startIndex, endIndex);
if (isChecked) {
paginatedItems.forEach((item) => selectedItems.add(item.id));
} else {
paginatedItems.forEach((item) => selectedItems.delete(item.id));
}
updateBulkActions();
renderInventoryList();
}
function updateBulkActions() {
const bulkActions = document.getElementById("invBulkActions");
const selectedCount = document.getElementById("invSelectedCount");
if (selectedItems.size > 0) {
bulkActions?.classList.add("show");
if (selectedCount)
selectedCount.textContent = `${selectedItems.size} items selected`;
} else {
bulkActions?.classList.remove("show");
}
}
// Global functions for onclick handlers
window.toggleItemSelection = function (itemId) {
if (selectedItems.has(itemId)) {
selectedItems.delete(itemId);
} else {
selectedItems.add(itemId);
}
updateBulkActions();
};
window.goToPage = function (page) {
currentPage = page;
renderInventoryList();
};
window.showStockMovement = function (itemId) {
const item = inventoryItems.find((i) => i.id === itemId);
if (!item) return;
const modal = document.getElementById("stockMovementModal");
const tbody = document.getElementById("stockMovementHistory");
if (tbody) {
tbody.innerHTML = item.movements
.map(
(movement) => `
${movement.date}
${movement.type}
${movement.quantity > 0 ? "+" : ""}${movement.quantity}
${movement.note}
`
)
.join("");
}
if (modal) {
const bsModal = new bootstrap.Modal(modal);
bsModal.show();
}
};
window.showAdjustStock = function (itemId) {
const item = inventoryItems.find((i) => i.id === itemId);
if (!item) return;
document.getElementById("adjustItemName").textContent = item.name;
document.getElementById("adjustCurrentStock").textContent =
item.stock;
document.getElementById("adjustQuantity").value = "";
document.getElementById("adjustReason").value = "";
// Store item ID for later use
document.getElementById("stockAdjustModal").dataset.itemId = itemId;
const modal = new bootstrap.Modal(
document.getElementById("stockAdjustModal")
);
modal.show();
};
window.processStockAdjustment = function () {
const modal = document.getElementById("stockAdjustModal");
const itemId = parseInt(modal.dataset.itemId);
const adjustType = document.getElementById("adjustType").value;
const quantity = parseInt(
document.getElementById("adjustQuantity").value
);
const reason = document.getElementById("adjustReason").value;
if (!quantity || !reason) {
alert("Please fill in all fields");
return;
}
const item = inventoryItems.find((i) => i.id === itemId);
if (!item) return;
const adjustedQuantity = adjustType === "add" ? quantity : -quantity;
item.stock = Math.max(0, item.stock + adjustedQuantity);
item.lastUpdated = new Date().toISOString().split("T")[0];
// Add movement record
item.movements.unshift({
date: item.lastUpdated,
type: adjustType === "add" ? "Adjustment (+)" : "Adjustment (-)",
quantity: adjustedQuantity,
note: reason,
});
saveInventoryData();
updateMetrics();
renderInventoryList();
const bsModal = bootstrap.Modal.getInstance(modal);
bsModal.hide();
};
// Initialize when the inventory section is loaded
document.addEventListener("DOMContentLoaded", function () {
// Wait for the section to be available
const checkInterval = setInterval(function () {
if (document.getElementById("inventoryList")) {
initInventoryManagement();
clearInterval(checkInterval);
}
}, 100);
});
})();
// Additional Inventory Management Event Handlers
document.addEventListener("DOMContentLoaded", function () {
// Pagination event handlers
document
.getElementById("invPrevPage")
?.addEventListener("click", function () {
if (currentPage > 1) {
currentPage--;
renderInventoryList();
}
});
document
.getElementById("invNextPage")
?.addEventListener("click", function () {
const totalPages = Math.ceil(filteredItems.length / itemsPerPage);
if (currentPage < totalPages) {
currentPage++;
renderInventoryList();
}
});
// Stock adjustment form handler
document
.getElementById("processAdjustment")
?.addEventListener("click", function () {
window.processStockAdjustment();
});
// POS System with Scanner Integration
const POSSystem = (() => {
let cart = [];
let customers = [];
let transactions = [];
let products = [];
let currentCustomer = null;
let scannerConfig = {
type: "usb",
prefix: "",
suffix: "",
autoAdd: true,
offlineStorage: true,
timeout: 5,
};
let scannerMode = "auto-detect";
let isOnline = navigator.onLine;
let offlineQueue = [];
let scannerBuffer = "";
let scannerTimeout;
let isScanning = false;
// Initialize system
function init() {
loadSampleData();
loadSavedData();
renderDashboard();
renderProducts();
setupEventListeners();
setupScannerListeners();
updateOnlineStatus();
// Monitor online/offline status
window.addEventListener("online", () => {
isOnline = true;
updateOnlineStatus();
processOfflineQueue();
});
window.addEventListener("offline", () => {
isOnline = false;
updateOnlineStatus();
});
}
// Load sample data
function loadSampleData() {
products = [
{
id: 1,
name: "Coffee",
price: 5.99,
barcode: "123456789012",
stock: 50,
category: "Beverages",
},
{
id: 2,
name: "Sandwich",
price: 8.99,
barcode: "123456789013",
stock: 30,
category: "Food",
},
{
id: 3,
name: "Water Bottle",
price: 2.99,
barcode: "123456789014",
stock: 100,
category: "Beverages",
},
{
id: 4,
name: "Chips",
price: 3.49,
barcode: "123456789015",
stock: 75,
category: "Snacks",
},
{
id: 5,
name: "Energy Drink",
price: 4.99,
barcode: "123456789016",
stock: 40,
category: "Beverages",
},
{
id: 6,
name: "Protein Bar",
price: 6.99,
barcode: "123456789017",
stock: 25,
category: "Snacks",
},
{
id: 7,
name: "Fresh Salad",
price: 12.99,
barcode: "123456789018",
stock: 15,
category: "Food",
},
{
id: 8,
name: "Orange Juice",
price: 4.49,
barcode: "123456789019",
stock: 60,
category: "Beverages",
},
];
customers = [
{
id: 1,
name: "John Doe",
email: "john@example.com",
phone: "555-0101",
points: 150,
},
{
id: 2,
name: "Jane Smith",
email: "jane@example.com",
phone: "555-0102",
points: 250,
},
{
id: 3,
name: "Bob Johnson",
email: "bob@example.com",
phone: "555-0103",
points: 100,
},
];
}
// Load saved data from store
function loadSavedData() {
const savedCart = window._acctStore.get("posCart");
const savedCustomers = window._acctStore.get("posCustomers");
const savedTransactions = window._acctStore.get("posTransactions");
const savedScannerConfig = window._acctStore.get("posScannerConfig");
const savedOfflineQueue = window._acctStore.get("posOfflineQueue");
if (savedCart) cart = savedCart;
if (savedCustomers)
customers = [...customers, ...savedCustomers];
if (savedTransactions) transactions = savedTransactions;
if (savedScannerConfig)
scannerConfig = {
...scannerConfig,
...savedScannerConfig,
};
if (savedOfflineQueue) offlineQueue = savedOfflineQueue;
}
// Save data to store
function saveData() {
window._acctStore.set("posCart", cart);
window._acctStore.set("posCustomers", customers.slice(3)); // Save only new customers
window._acctStore.set("posTransactions", transactions);
window._acctStore.set("posScannerConfig", scannerConfig);
window._acctStore.set("posOfflineQueue", offlineQueue);
}
// Setup event listeners
function setupEventListeners() {
// Product search
const searchInput = document.getElementById("pos-search");
if (searchInput) {
searchInput.addEventListener("input", handleProductSearch);
}
// Cart actions
document.addEventListener("click", (e) => {
if (e.target.matches(".add-to-cart")) {
const productId = parseInt(e.target.dataset.productId);
addToCart(productId);
}
if (e.target.matches(".remove-from-cart")) {
const index = parseInt(e.target.dataset.index);
removeFromCart(index);
}
if (e.target.matches(".increase-qty")) {
const index = parseInt(e.target.dataset.index);
updateCartQuantity(index, 1);
}
if (e.target.matches(".decrease-qty")) {
const index = parseInt(e.target.dataset.index);
updateCartQuantity(index, -1);
}
});
// Payment processing
const processPaymentBtn =
document.getElementById("process-payment");
if (processPaymentBtn) {
processPaymentBtn.addEventListener("click", processPayment);
}
const clearCartBtn = document.getElementById("clear-cart");
if (clearCartBtn) {
clearCartBtn.addEventListener("click", clearCart);
}
// Scanner configuration
const saveScannerConfigBtn = document.getElementById(
"save-scanner-config"
);
if (saveScannerConfigBtn) {
saveScannerConfigBtn.addEventListener("click", saveScannerConfig);
}
// Scanner mode changes
document
.querySelectorAll('input[name="scanner-mode"]')
.forEach((radio) => {
radio.addEventListener("change", handleScannerModeChange);
});
// Manual barcode input
const manualBarcodeInput =
document.getElementById("manual-barcode");
if (manualBarcodeInput) {
manualBarcodeInput.addEventListener("keypress", (e) => {
if (e.key === "Enter") {
processBarcode(e.target.value);
e.target.value = "";
}
});
}
// Process offline queue
const processOfflineQueueBtn = document.getElementById(
"process-offline-queue"
);
if (processOfflineQueueBtn) {
processOfflineQueueBtn.addEventListener(
"click",
processOfflineQueueHandler
);
}
const clearOfflineQueueBtn = document.getElementById(
"clear-offline-queue"
);
if (clearOfflineQueueBtn) {
clearOfflineQueueBtn.addEventListener("click", clearOfflineQueue);
}
}
// Setup scanner listeners
function setupScannerListeners() {
// Global keypress listener for scanner input
document.addEventListener("keypress", (e) => {
if (
scannerMode === "auto-detect" &&
document.activeElement.tagName !== "INPUT"
) {
handleScannerInput(e);
}
});
// Hidden input for focused scanner input
const hiddenInput = document.getElementById("scanner-input");
if (hiddenInput) {
hiddenInput.addEventListener("input", (e) => {
if (scannerMode === "auto-detect") {
const value = e.target.value;
if (value.length >= 8) {
// Minimum barcode length
processBarcode(value);
e.target.value = "";
}
}
});
}
}
// Handle scanner input
function handleScannerInput(e) {
clearTimeout(scannerTimeout);
if (!isScanning) {
isScanning = true;
updateScannerStatus("scanning");
scannerBuffer = "";
}
scannerBuffer += e.key;
scannerTimeout = setTimeout(() => {
if (scannerBuffer.length >= 8) {
processBarcode(scannerBuffer);
}
isScanning = false;
scannerBuffer = "";
updateScannerStatus(isOnline ? "online" : "offline");
}, scannerConfig.timeout * 1000);
}
// Process barcode
function processBarcode(barcode) {
// Remove prefix and suffix if configured
let cleanBarcode = barcode;
if (
scannerConfig.prefix &&
cleanBarcode.startsWith(scannerConfig.prefix)
) {
cleanBarcode = cleanBarcode.substring(
scannerConfig.prefix.length
);
}
if (
scannerConfig.suffix &&
cleanBarcode.endsWith(scannerConfig.suffix)
) {
cleanBarcode = cleanBarcode.substring(
0,
cleanBarcode.length - scannerConfig.suffix.length
);
}
const product = products.find((p) => p.barcode === cleanBarcode);
if (product) {
if (scannerConfig.autoAdd) {
if (isOnline || scannerMode !== "offline") {
addToCart(product.id);
showScanFeedback("success", `Added ${product.name} to cart`);
} else {
addToOfflineQueue(product);
showScanFeedback(
"warning",
`${product.name} queued (offline)`
);
}
} else {
showScanFeedback("info", `Scanned: ${product.name}`);
}
} else {
showScanFeedback("error", "Product not found");
}
// Reset scanner state
isScanning = false;
updateScannerStatus(isOnline ? "online" : "offline");
}
// Add to offline queue
function addToOfflineQueue(product) {
const existingItem = offlineQueue.find(
(item) => item.productId === product.id
);
if (existingItem) {
existingItem.quantity++;
} else {
offlineQueue.push({
productId: product.id,
name: product.name,
price: product.price,
quantity: 1,
timestamp: new Date().toISOString(),
});
}
updateOfflineQueueDisplay();
saveData();
}
// Process offline queue
function processOfflineQueueHandler() {
if (!isOnline) {
showScanFeedback("error", "Cannot process queue while offline");
return;
}
offlineQueue.forEach((item) => {
for (let i = 0; i < item.quantity; i++) {
addToCart(item.productId);
}
});
clearOfflineQueue();
showScanFeedback("success", "Offline queue processed");
}
// Clear offline queue
function clearOfflineQueue() {
offlineQueue = [];
updateOfflineQueueDisplay();
saveData();
}
// Update scanner status
function updateScannerStatus(status) {
const statusElement = document.querySelector(".pos-scanner-status");
const indicatorElement = document.querySelector(
".pos-scan-indicator"
);
if (statusElement) {
statusElement.className = `pos-scanner-status status-${status}`;
let statusText = "";
switch (status) {
case "online":
statusText = "Scanner Online";
break;
case "offline":
statusText = "Scanner Offline";
break;
case "scanning":
statusText = "Scanning...";
break;
}
statusElement.textContent = statusText;
}
if (indicatorElement) {
indicatorElement.className = `pos-scan-indicator status-${status}`;
}
}
// Update online status
function updateOnlineStatus() {
updateScannerStatus(isOnline ? "online" : "offline");
updateOfflineQueueDisplay();
}
// Update offline queue display
function updateOfflineQueueDisplay() {
const queuePanel = document.querySelector(".pos-offline-queue");
const queueItems = document.getElementById("offline-queue-items");
const queueCount = document.getElementById("offline-queue-count");
if (queuePanel) {
if (offlineQueue.length === 0) {
queuePanel.style.display = "none";
} else {
queuePanel.style.display = "block";
if (queueCount) {
queueCount.textContent = offlineQueue.length;
}
if (queueItems) {
queueItems.innerHTML = offlineQueue
.map(
(item) => `
${item.name} (${item.quantity}x)
$${(
item.price * item.quantity
).toFixed(2)}
`
)
.join("");
}
}
}
}
// Show scan feedback
function showScanFeedback(type, message) {
// Create or update feedback element
let feedback = document.getElementById("scan-feedback");
if (!feedback) {
feedback = document.createElement("div");
feedback.id = "scan-feedback";
feedback.className =
"position-fixed top-0 start-50 translate-middle-x mt-3";
feedback.style.zIndex = "9999";
document.body.appendChild(feedback);
}
const alertClass =
type === "success"
? "success"
: type === "error"
? "danger"
: type === "warning"
? "warning"
: "info";
feedback.innerHTML = `
${message}
`;
// Auto-hide after 3 seconds
setTimeout(() => {
const alert = feedback.querySelector(".alert");
if (alert) {
try {
const bsAlert = new bootstrap.Alert(alert);
bsAlert.close();
} catch (e) {
alert.remove();
}
}
}, 3000);
}
// Handle scanner mode change
function handleScannerModeChange(e) {
scannerMode = e.target.value;
// Focus hidden input for auto-detect mode
if (scannerMode === "auto-detect") {
const hiddenInput = document.getElementById("scanner-input");
if (hiddenInput) {
hiddenInput.focus();
}
}
updateScannerStatus(isOnline ? "online" : "offline");
}
// Save scanner configuration
function saveScannerConfig() {
const typeField = document.getElementById("scanner-type");
const prefixField = document.getElementById("scanner-prefix");
const suffixField = document.getElementById("scanner-suffix");
const autoAddField = document.getElementById("scanner-auto-add");
const offlineStorageField = document.getElementById(
"scanner-offline-storage"
);
const timeoutField = document.getElementById("scanner-timeout");
if (
typeField &&
prefixField &&
suffixField &&
autoAddField &&
offlineStorageField &&
timeoutField
) {
scannerConfig = {
type: typeField.value,
prefix: prefixField.value,
suffix: suffixField.value,
autoAdd: autoAddField.checked,
offlineStorage: offlineStorageField.checked,
timeout: parseInt(timeoutField.value),
};
saveData();
try {
const modal = bootstrap.Modal.getInstance(
document.getElementById("posScannerConfigModal")
);
if (modal) {
modal.hide();
}
} catch (e) {
console.log("Modal close error:", e);
}
showScanFeedback("success", "Scanner configuration saved");
}
}
// Handle product search
function handleProductSearch(e) {
const searchTerm = e.target.value.toLowerCase();
const productGrid = document.querySelector(".pos-product-grid");
if (!productGrid) return;
if (searchTerm === "") {
renderProducts();
return;
}
const filteredProducts = products.filter(
(product) =>
product.name.toLowerCase().includes(searchTerm) ||
product.category.toLowerCase().includes(searchTerm) ||
product.barcode.includes(searchTerm)
);
productGrid.innerHTML = filteredProducts
.map(
(product) => `
${product.name}
${product.category}
$${product.price.toFixed(2)}
Stock: ${product.stock}
Barcode: ${product.barcode}
`
)
.join("");
}
// Add to cart
function addToCart(productId) {
const product = products.find((p) => p.id === productId);
if (!product) return;
const existingItem = cart.find(
(item) => item.productId === productId
);
if (existingItem) {
existingItem.quantity++;
} else {
cart.push({
productId: productId,
name: product.name,
price: product.price,
quantity: 1,
});
}
renderCart();
saveData();
}
// Remove from cart
function removeFromCart(index) {
cart.splice(index, 1);
renderCart();
saveData();
}
// Update cart quantity
function updateCartQuantity(index, change) {
if (cart[index]) {
cart[index].quantity += change;
if (cart[index].quantity <= 0) {
cart.splice(index, 1);
}
}
renderCart();
saveData();
}
// Clear cart
function clearCart() {
cart = [];
renderCart();
saveData();
}
// Calculate cart total
function calculateTotal() {
return cart.reduce(
(total, item) => total + item.price * item.quantity,
0
);
}
// Process payment
function processPayment() {
if (cart.length === 0) {
alert("Cart is empty");
return;
}
const total = calculateTotal();
const transaction = {
id: Date.now(),
items: [...cart],
total: total,
customer: currentCustomer,
timestamp: new Date().toISOString(),
paymentMethod:
document.querySelector('input[name="payment-method"]:checked')
?.value || "cash",
};
transactions.push(transaction);
clearCart();
try {
const modal = bootstrap.Modal.getInstance(
document.getElementById("posPaymentModal")
);
if (modal) {
modal.hide();
}
} catch (e) {
console.log("Modal close error:", e);
}
alert(
`Payment processed successfully! Total: $${total.toFixed(2)}`
);
renderDashboard();
}
// Render dashboard
function renderDashboard() {
const todaysSales = transactions
.filter(
(t) =>
new Date(t.timestamp).toDateString() ===
new Date().toDateString()
)
.reduce((sum, t) => sum + t.total, 0);
const todaysSalesElement =
document.getElementById("pos-daily-sales");
const totalTransactionsElement =
document.getElementById("pos-transactions");
const totalCustomersElement =
document.getElementById("total-customers");
const cartItemsElement = document.getElementById("cart-items");
if (todaysSalesElement)
todaysSalesElement.textContent = `$${todaysSales.toFixed(2)}`;
if (totalTransactionsElement)
totalTransactionsElement.textContent = transactions.length;
if (totalCustomersElement)
totalCustomersElement.textContent = customers.length;
if (cartItemsElement)
cartItemsElement.textContent = cart.reduce(
(sum, item) => sum + item.quantity,
0
);
// Initialize sales trend chart
initPosSalesTrendChart();
}
// Initialize POS Sales Trend Chart
function initPosSalesTrendChart() {
const chartCanvas = document.getElementById(
"pos-sales-trend-chart"
);
console.log(
"initPosSalesTrendChart called, chartCanvas:",
chartCanvas,
"Chart:",
typeof Chart
);
// Check if POS section is visible
const posSection = document.getElementById("pos");
if (!posSection || !posSection.classList.contains("active")) {
console.log("POS section not active, skipping chart init");
return;
}
if (!chartCanvas || typeof Chart === "undefined") {
console.error(
"Chart.js or canvas not available",
chartCanvas,
Chart
);
return;
}
// Destroy existing chart if it exists
if (window.posSalesTrendChart) {
window.posSalesTrendChart.destroy();
}
// Generate sample data for the last 7 days
const last7Days = Array.from({ length: 7 }, (_, i) => {
const date = new Date();
date.setDate(date.getDate() - (6 - i));
return date.toLocaleDateString("en-US", {
month: "short",
day: "numeric",
});
});
// Sample sales data (you can replace this with real data)
const salesData = [1200, 1800, 1400, 2200, 1900, 2400, 2100];
const transactionData = [15, 22, 18, 28, 24, 31, 27];
const ctx = chartCanvas.getContext("2d");
window.posSalesTrendChart = new Chart(ctx, {
type: "line",
data: {
labels: last7Days,
datasets: [
{
label: "Sales ($)",
data: salesData,
borderColor: "#3b82f6",
backgroundColor: "rgba(59, 130, 246, 0.1)",
borderWidth: 2,
fill: true,
tension: 0.4,
yAxisID: "y",
},
{
label: "Transactions",
data: transactionData,
borderColor: "#10b981",
backgroundColor: "rgba(16, 185, 129, 0.1)",
borderWidth: 2,
fill: false,
tension: 0.4,
yAxisID: "y1",
},
],
},
options: {
responsive: true,
maintainAspectRatio: false,
plugins: {
legend: {
position: "top",
labels: {
usePointStyle: true,
padding: 20,
},
},
tooltip: {
mode: "index",
intersect: false,
backgroundColor: "rgba(0, 0, 0, 0.8)",
titleColor: "white",
bodyColor: "white",
borderColor: "#3b82f6",
borderWidth: 1,
},
},
scales: {
x: {
grid: {
display: false,
},
ticks: {
color: "#6b7280",
},
},
y: {
type: "linear",
display: true,
position: "left",
grid: {
color: "rgba(0, 0, 0, 0.1)",
},
ticks: {
color: "#6b7280",
callback: function (value) {
return "$" + value;
},
},
},
y1: {
type: "linear",
display: true,
position: "right",
grid: {
drawOnChartArea: false,
},
ticks: {
color: "#6b7280",
},
},
},
interaction: {
mode: "nearest",
axis: "x",
intersect: false,
},
},
});
}
// Render products
function renderProducts() {
const productGrid = document.querySelector(".pos-product-grid");
if (!productGrid) return;
productGrid.innerHTML = products
.map(
(product) => `
${product.name}
${product.category}
$${product.price.toFixed(2)}
Stock: ${product.stock}
Barcode: ${product.barcode}
`
)
.join("");
}
// Render cart
function renderCart() {
const cartItems = document.querySelector(".pos-cart-items");
const cartTotal = document.querySelector(".pos-cart-total");
if (cartItems) {
if (cart.length === 0) {
cartItems.innerHTML =
'Cart is empty
';
} else {
cartItems.innerHTML = cart
.map(
(item, index) => `
${item.name}
$${item.price.toFixed(
2
)} each
-
${item.quantity}
+
$${(
item.price * item.quantity
).toFixed(2)}
`
)
.join("");
}
}
if (cartTotal) {
cartTotal.textContent = `$${calculateTotal().toFixed(2)}`;
}
// Update cart total in payment modal
const paymentTotal = document.getElementById("payment-total");
if (paymentTotal) {
paymentTotal.textContent = `$${calculateTotal().toFixed(2)}`;
}
renderDashboard();
}
return {
init,
addToCart,
removeFromCart,
clearCart,
processPayment,
initPosSalesTrendChart, // Make chart init function globally accessible
};
})();
// Initialize POS system when DOM is loaded
document.addEventListener("DOMContentLoaded", function () {
const posSystem = POSSystem.init();
// Make initPosSalesTrendChart globally accessible
window.initPosSalesTrendChart = POSSystem.initPosSalesTrendChart;
});
});
}); // _acctStoreReady
Scenario Comparison - Financial Impact Analysis
Scenario Comparison - Financial Impact Analysis
Generated on ${new Date().toLocaleDateString()} at ${new Date().toLocaleTimeString()}
${tableClone.outerHTML}
${''}
${''}
`);
doc.close();
// Print immediately
setTimeout(() => {
printFrame.contentWindow.focus();
printFrame.contentWindow.print();
}, 100);
}
window.printScenarioTable = printScenarioTable;
// ====================================================================
// PAYMENT VOUCHERS
// ====================================================================
async function loadPaymentVouchers() {
// Use PostgreSQL API
loadPaymentVouchersFromAPI();
}
function renderPaymentVouchersTable(vouchers) {
const tbody = document.querySelector('#payment-vouchers table tbody');
if (!tbody) return;
if (!vouchers || vouchers.length === 0) {
tbody.innerHTML = 'No payment vouchers found.
${v.voucher_number} ${v.supplier?.company_name || 'N/A'}
${formatDate(v.date)}
${formatCurrency(v.amount)} ${v.payment_method?.replace('_', ' ')?.toUpperCase() || '-'}
${getStatusBadge(v.status)}
`).join('');
}
// ====================================================================
// INITIALIZATION
// ====================================================================
function init() {
console.log('🚀 Initializing Accounting Module...');
// Load all data
loadDashboardStats();
loadInvoices(1);
loadCustomers(1);
// Load additional accounting data when sections are visible
loadBankAccounts();
initBankingSection();
loadTransfers();
loadJournalEntries();
loadChartOfAccounts();
loadBills();
loadCreditNotes();
loadReceipts();
loadFixedAssets();
loadDepreciation();
loadAssetDisposals();
loadPaymentVouchers();
loadBudgets();
loadScenarios();
loadSensitivityAnalysis();
// New feature auto-loads
setTimeout(() => {
if (typeof refreshAccountingDashboard === 'function') refreshAccountingDashboard();
if (typeof loadRecurringInvoices === 'function') loadRecurringInvoices();
}, 1500);
// Setup search
const searchInput = document.getElementById('invoice-search-input');
if (searchInput) {
let debounceTimer;
searchInput.addEventListener('input', (e) => {
clearTimeout(debounceTimer);
debounceTimer = setTimeout(() => {
const query = e.target.value.toLowerCase();
const filtered = state.invoices.data.filter(inv =>
inv.invoice_number?.toLowerCase().includes(query) ||
inv.customer?.company_name?.toLowerCase().includes(query) ||
inv.customer?.email?.toLowerCase().includes(query)
);
renderInvoicesTable(query ? filtered : state.invoices.data);
}, 300);
});
}
console.log('✅ Accounting Module initialized with all features');
}
// -- Stripe Card Payment ----------------------------------------------------
async function payInvoiceWithStripe(invoiceId) {
// 1. Get Stripe publishable key
let publishableKey;
try {
const res = await fetch('/api/stripe/config/');
const data = await res.json();
if (!data.success) throw new Error(data.error || 'Stripe not configured');
publishableKey = data.publishable_key;
} catch (e) {
showToast('Stripe unavailable: ' + e.message, 'danger');
return;
}
// 2. Create PaymentIntent on backend
let intentData;
try {
const token = _getErpAuthToken() || '';
const res = await fetch('/api/stripe/create-payment-intent/', {
method: 'POST',
headers: Object.assign({'Content-Type': 'application/json'}, token ? {'Authorization': 'Token ' + token} : {}),
body: JSON.stringify({ invoice_id: invoiceId })
});
intentData = await res.json();
if (!intentData.success) throw new Error(intentData.error || 'Could not create payment');
} catch (e) {
showToast('Payment setup failed: ' + e.message, 'danger');
return;
}
// 3. Show card payment modal
showStripePaymentModal(invoiceId, intentData, publishableKey);
}
function showStripePaymentModal(invoiceId, intentData, publishableKey) {
const existing = document.getElementById('stripe-payment-modal');
if (existing) existing.remove();
const displayAmt = parseFloat(intentData.amount).toFixed(2);
const displayCurr = intentData.currency || 'GBP';
const modal = document.createElement('div');
modal.id = 'stripe-payment-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '100000';
modal.innerHTML =
'' +
'
' +
'' +
'
' +
'
Customer: ' + intentData.customer + 'Amount: ' + displayCurr + ' ' + displayAmt + '
' +
'
' +
'
Card Details ' +
'
' +
'
' +
'
' +
'' +
'
' +
'
' + type + ' Report ' + content + '<\/body><\/html>');
printWindow.document.close();
printWindow.print();
};
window.exportToExcel = function(type) {
var data = getExportData(type);
var csv = convertToCSV(data);
var blob = new Blob([csv], { type: 'text/csv;charset=utf-8;' });
var link = document.createElement('a');
link.href = URL.createObjectURL(blob);
link.download = type.toLowerCase().replace(/\s+/g, '_') + '_' + new Date().toISOString().split('T')[0] + '.csv';
link.click();
showToast('Exported to CSV successfully!', 'success');
};
function generateReportContent(type) {
var html = '' + type + ' Report Generated: ' + new Date().toLocaleDateString() + '
';
if (type === 'Transactions' || type === 'Cash Flow') {
var transactions = (window._acctStore.get('elinom-transactions') || []);
html += 'Date Description Type Amount ' + t.date + ' ' + t.description + ' ' + t.type + ' ' + sign + window.currencySymbol() + t.amount.toFixed(2) + '
Net Total: $' + total.toFixed(2) + '
';
} else if (type === 'Invoices') {
var invoices = (window._acctStore.get('elinom-invoices') || []);
html += 'Invoice # Customer Date Due Date Total Status ' + inv.number + ' ' + inv.customer + ' ' + inv.date + ' ' + inv.dueDate + ' $' + (inv.total || 0).toFixed(2) + ' ' + inv.status + '
';
} else if (type === 'Inventory') {
var inventory = (window._acctStore.get('elinom-inventory') || []);
html += 'Item SKU Qty Price Value ' + item.name + ' ' + (item.sku || '-') + ' ' + item.qty + ' $' + (item.price || 0).toFixed(2) + ' $' + value.toFixed(2) + '
Total Inventory Value: $' + totalValue.toFixed(2) + '
';
}
return html;
}
function getExportData(type) {
if (type === 'Transactions') {
var transactions = (window._acctStore.get('elinom-transactions') || []);
return [['Date', 'Description', 'Type', 'Category', 'Amount']].concat(
transactions.map(function(t) { return [t.date, t.description, t.type, t.category || '', t.amount]; })
);
} else if (type === 'Invoices') {
var invoices = (window._acctStore.get('elinom-invoices') || []);
return [['Invoice #', 'Customer', 'Email', 'Date', 'Due Date', 'Total', 'Status']].concat(
invoices.map(function(inv) { return [inv.number, inv.customer, inv.email || '', inv.date, inv.dueDate, inv.total, inv.status]; })
);
} else if (type === 'Inventory') {
var inventory = (window._acctStore.get('elinom-inventory') || []);
return [['Name', 'SKU', 'Quantity', 'Price', 'Category', 'Reorder Level']].concat(
inventory.map(function(item) { return [item.name, item.sku || '', item.qty, item.price || 0, item.category || '', item.reorderLevel || 10]; })
);
}
return [];
}
function convertToCSV(data) {
return data.map(function(row) {
return row.map(function(cell) {
var str = String(cell == null ? '' : cell);
if (str.includes(',') || str.includes('"') || str.includes('\n')) {
return '"' + str.replace(/"/g, '""') + '"';
}
return str;
}).join(',');
}).join('\n');
}
// ========================================
// 5. PRINT INVOICE
// ========================================
window.printInvoice = function(id) {
var invoices = (window._acctStore.get('elinom-invoices') || []);
var inv = invoices.find(function(i) { return i.id === id; });
if (!inv) { alert('Invoice not found'); return; }
var itemsHtml = '';
(inv.items || []).forEach(function(item) {
itemsHtml += '' + item.description + ' ' + item.quantity + ' $' + item.price.toFixed(2) + ' $' + item.total.toFixed(2) + ' Invoice ' + inv.number + ' Bill To:
Description Qty Price Total ' + itemsHtml + '
Subtotal: $' + (inv.subtotal || 0).toFixed(2) + '
Tax: $' + (inv.tax || 0).toFixed(2) + '
Total: $' + (inv.total || 0).toFixed(2) + '
Notes:
' : '') + '<\/body><\/html>');
printWindow.document.close();
printWindow.print();
};
// ========================================
// 6. SEARCH/FILTER TRANSACTIONS
// ========================================
window.showTransactionsModal = function() {
var existingModal = document.getElementById('transactions-list-modal');
if (existingModal) existingModal.remove();
var transactions = (window._acctStore.get('elinom-transactions') || []);
var modal = document.createElement('div');
modal.id = 'transactions-list-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = '';
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
renderTransactionsTable(transactions);
};
window.renderTransactionsTable = function(transactions) {
var tbody = document.getElementById('txn-table-body');
if (!tbody) return;
if (transactions.length === 0) {
tbody.innerHTML = 'No transactions found ' + t.date + ' ' + t.description + ' ' + t.type + ' ' + (t.category || '-') + ' ' + sign + window.currencySymbol() + t.amount.toFixed(2) + '
Add New Recurring Transaction No recurring transactions set up
';
return;
}
container.innerHTML = 'Description Amount Type Frequency Next ' +
recurring.map(function(r, i) {
return '' + r.description + ' $' + r.amount.toFixed(2) + ' ' + r.type + ' ' + r.frequency + ' ' + r.nextDate + '
';
};
window.saveRecurring = function() {
var desc = document.getElementById('rec-desc').value.trim();
var amount = parseFloat(document.getElementById('rec-amount').value);
var next = document.getElementById('rec-next').value;
if (!desc || !amount || !next) { alert('Please fill all fields'); return; }
var recurring = (window._acctStore.get('elinom-recurring') || []);
recurring.push({
id: Date.now(),
description: desc,
amount: amount,
type: document.getElementById('rec-type').value,
frequency: document.getElementById('rec-freq').value,
nextDate: next,
active: true
});
window._acctStore.set('elinom-recurring', recurring);
document.getElementById('rec-desc').value = '';
document.getElementById('rec-amount').value = '';
renderRecurringList(recurring);
showToast('Recurring transaction added!', 'success');
};
window.deleteRecurring = function(idx) {
var recurring = (window._acctStore.get('elinom-recurring') || []);
recurring.splice(idx, 1);
window._acctStore.set('elinom-recurring', recurring);
renderRecurringList(recurring);
};
// Process recurring transactions on load
function processRecurringTransactions() {
var recurring = (window._acctStore.get('elinom-recurring') || []);
var transactions = (window._acctStore.get('elinom-transactions') || []);
var today = new Date().toISOString().split('T')[0];
var updated = false;
recurring.forEach(function(r, idx) {
if (r.nextDate <= today && r.active) {
// Create the transaction
transactions.push({
id: Date.now() + idx,
type: r.type,
date: r.nextDate,
description: r.description + ' (Recurring)',
amount: r.amount,
category: 'recurring',
createdAt: new Date().toISOString()
});
// Calculate next date
var next = new Date(r.nextDate);
if (r.frequency === 'weekly') next.setDate(next.getDate() + 7);
else if (r.frequency === 'monthly') next.setMonth(next.getMonth() + 1);
else if (r.frequency === 'quarterly') next.setMonth(next.getMonth() + 3);
else if (r.frequency === 'yearly') next.setFullYear(next.getFullYear() + 1);
recurring[idx].nextDate = next.toISOString().split('T')[0];
updated = true;
}
});
if (updated) {
window._acctStore.set('elinom-transactions', transactions);
window._acctStore.set('elinom-recurring', recurring);
}
}
// ========================================
// 8. BUDGET TRACKING
// ========================================
window.showBudgetModal = function() {
var existingModal = document.getElementById('budget-modal');
if (existingModal) existingModal.remove();
var budgets = (window._acctStore.get('elinom-budgets') || []);
var transactions = (window._acctStore.get('elinom-transactions') || []);
// Calculate spending per category this month
var thisMonth = new Date().toISOString().slice(0, 7);
var spending = {};
transactions.filter(function(t) { return t.type === 'expense' && t.date.startsWith(thisMonth); }).forEach(function(t) {
var cat = t.category || 'other';
spending[cat] = (spending[cat] || 0) + t.amount;
});
var modal = document.createElement('div');
modal.id = 'budget-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = '';
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
renderBudgetProgress(budgets, spending);
};
window.renderBudgetProgress = function(budgets, spending) {
var container = document.getElementById('budget-progress');
if (!container) return;
if (budgets.length === 0) {
container.innerHTML = 'No budgets set. Add one below!
';
return;
}
container.innerHTML = budgets.map(function(b) {
var spent = spending[b.category] || 0;
var pct = Math.min((spent / b.limit) * 100, 100);
var color = pct >= 90 ? 'danger' : pct >= 70 ? 'warning' : 'success';
return '' + b.category + ' $' + spent.toFixed(2) + ' / $' + b.limit.toFixed(2) + '
' + c + ' '; }).join('');
var modal = document.createElement('div');
modal.id = 'currency-converter-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = '';
document.body.appendChild(modal);
new bootstrap.Modal(modal).show();
convertCurrency();
};
window.convertCurrency = function() {
var from = document.getElementById('conv-from').value;
var to = document.getElementById('conv-to').value;
var amount = parseFloat(document.getElementById('conv-amount').value) || 0;
var inUSD = amount / exchangeRates[from];
var result = inUSD * exchangeRates[to];
document.getElementById('conv-result').value = result.toFixed(2);
document.getElementById('conv-rate').textContent = '1 ' + from + ' = ' + (exchangeRates[to] / exchangeRates[from]).toFixed(4) + ' ' + to;
};
// ========================================
// 10. TAX CALCULATIONS
// ========================================
window.showTaxCalculatorModal = function() {
var existingModal = document.getElementById('tax-calc-modal');
if (existingModal) existingModal.remove();
var transactions = (window._acctStore.get('elinom-transactions') || []);
var invoices = (window._acctStore.get('elinom-invoices') || []);
var totalIncome = transactions.filter(function(t) { return t.type === 'income'; }).reduce(function(s, t) { return s + t.amount; }, 0);
var totalExpenses = transactions.filter(function(t) { return t.type === 'expense'; }).reduce(function(s, t) { return s + t.amount; }, 0);
var invoiceIncome = invoices.filter(function(i) { return i.status === 'paid'; }).reduce(function(s, i) { return s + (i.total || 0); }, 0);
var grossIncome = totalIncome + invoiceIncome;
var netIncome = grossIncome - totalExpenses;
var modal = document.createElement('div');
modal.id = 'tax-calc-modal';
modal.className = 'modal fade';
modal.setAttribute('tabindex', '-1');
modal.style.zIndex = '99999';
modal.innerHTML = '
Gross Income $' + grossIncome.toFixed(2) + '
Total Expenses $' + totalExpenses.toFixed(2) + '
Net Income $' + netIncome.toFixed(2) + ' Estimate Tax Liability Ctrl + N New Transaction Ctrl + I New Invoice Ctrl + T View Transactions Ctrl + B Budget Tracking Ctrl + D Toggle Dark Mode Esc Close Modal
No invoices yet ' + inv.number + ' ' + inv.customer + ' ' + inv.date + ' ' + inv.dueDate + ' $' + (inv.total || 0).toFixed(2) + ' ' + inv.status + ' Cash Flow Statement '+
'
'+
'Cash Flow Statement Indirect Method • '+date+'
'+
preview.querySelector('table').outerHTML+
'<\/body><\/html>');
win.document.close();
win.focus();
setTimeout(function(){ win.print(); }, 400);
};
}, 100);
}, 600);
});
btn('cash-flow-scenarios-btn', function(){ modal('Scenario Operating CF Net CF Optimistic (+15%) $74,750 $39,750 Base Case $65,000 $30,000 Pessimistic (-15%) $55,250 $20,250
Close
'); });
btn('calculate-cf-ratios-btn', function(){
var b=this; loading(b,'Calculating...');
setTimeout(function(){
done(b);
// Pull live values from DOM, fall back to base figures
function domNum(id, fallback){
var el=document.getElementById(id);
if(!el) return fallback;
return parseFloat(String(el.textContent).replace(/[\$,\(\)]/g,'').replace(/K$/,'000')) || fallback;
}
var opCF = domNum('total-operating-cf', 65000);
var capex = Math.abs(domNum('total-investing-cf', -20000)); // use investing as proxy
var tl = domNum('total-financing-cf', -15000); tl = 109000 + 93000; // current+non-current liab
var cl = 109000;
var ta = 467000;
var ni = domNum('net-income-val', 30500);
var rev = 186500;
var divPd = 5000;
var depr = 7000;
var prevOpCF = 52700;
var fcf = opCF - capex;
var ocrVal = (opCF / cl).toFixed(2); // OCF / Current Liab
var coverVal = (opCF / tl).toFixed(2); // OCF / Total Debt
var fcfMarginVal = (fcf / rev * 100).toFixed(1)+'%'; // FCF / Revenue
var roaVal = (opCF / ta * 100).toFixed(1)+'%'; // OCF / Total Assets
var cashIncVal = (opCF / ni).toFixed(2); // OCF / Net Income
var capexRatVal = (capex/ opCF* 100).toFixed(1)+'%'; // CapEx / OCF
var divPayVal = (divPd/ opCF* 100).toFixed(1)+'%'; // Divs / OCF
var growthVal = ((opCF-prevOpCF)/prevOpCF*100).toFixed(1)+'%'; // YoY
var reinvVal = (capex/ depr).toFixed(2); // CapEx / Depr
// Status helper
function cfStatus(id, statusId, barId, val, rawVal, good, excellent, isReverse){
var norm = isReverse
? (rawVal<=good?'Excellent': rawVal<=excellent?'Good':'Fair')
: (rawVal>=excellent?'Excellent': rawVal>=good?'Good': rawVal>=good*0.5?'Fair':'Weak');
var col = norm==='Excellent'?'#059669': norm==='Good'?'#10b981': norm==='Fair'?'#f59e0b':'#ef4444';
var pct = Math.min(isReverse?(1-rawVal/2)*100 : rawVal/excellent*80, 97);
var vEl = document.getElementById(id);
var sEl = document.getElementById(statusId);
var bEl = document.getElementById(barId);
if(vEl){ vEl.textContent=val; flashEl(vEl); }
if(sEl){ sEl.textContent=norm; sEl.className='cf-ratio-status'; sEl.style.cssText='background:'+col+';color:#fff;padding:2px 8px;border-radius:8px;font-size:11px;font-weight:600'; flashEl(sEl); }
if(bEl){ bEl.style.width=Math.max(pct,4)+'%'; bEl.style.background=col; }
return {label:norm, color:col};
}
var s1=cfStatus('cfr-ocf-ratio','cfr-ocf-ratio-status','cfr-ocf-ratio-bar', ocrVal, parseFloat(ocrVal), 0.4, 0.6);
var s2=cfStatus('cfr-cash-coverage','cfr-cash-coverage-status','cfr-cash-coverage-bar', coverVal, parseFloat(coverVal), 0.3, 0.5);
var s3=cfStatus('cfr-fcf-margin','cfr-fcf-margin-status','cfr-fcf-margin-bar', fcfMarginVal,parseFloat(fcfMarginVal), 5, 10);
var s4=cfStatus('cfr-roa','cfr-roa-status','cfr-roa-bar', roaVal, parseFloat(roaVal), 8, 12);
var s5=cfStatus('cfr-cash-income','cfr-cash-income-status','cfr-cash-income-bar', cashIncVal, parseFloat(cashIncVal), 1, 1.5);
var s6=cfStatus('cfr-capex-ratio','cfr-capex-ratio-status','cfr-capex-ratio-bar', capexRatVal, parseFloat(capexRatVal),25, 50, true);
var s7=cfStatus('cfr-dividend-payout','cfr-dividend-payout-status','cfr-dividend-payout-bar', divPayVal, parseFloat(divPayVal), 15, 30, true);
var s8=cfStatus('cfr-cf-growth','cfr-cf-growth-status','cfr-cf-growth-bar', growthVal, parseFloat(growthVal), 10, 20);
var s9=cfStatus('cfr-reinvestment','cfr-reinvestment-status','cfr-reinvestment-bar', reinvVal, parseFloat(reinvVal), 1.5, 2.5);
// Open full visual report modal
var ts = new Date().toLocaleString();
function pill(t,c){ return ''+t+' '; }
function mbar(pct,col){ return ''; }
function row(name, formula, val, bench, pct, col, status){
return ''+
''+name+' '+
''+formula+' '+
''+val+' '+
''+bench+mbar(pct,col)+' '+
''+pill(status,col)+' '+
' ';
}
modal(
''+
'
'+
'
'+
'
Recalculated: '+ts+'
'+
'
'+
'
'+
'
'+
'
'+
'
FREE CASH FLOW
'+
'
$'+Math.round(fcf/1000)+'K
'+
'
OCF − CapEx
'+
'
'+
'
'+
'
OPERATING CF
'+
'
$'+Math.round(opCF/1000)+'K
'+
'
Current Period
'+
'
'+
'
'+
'
YoY GROWTH
'+
'
'+growthVal+'
'+
'
vs. Prior Period
'+
'
'+
'
'+
'
🔴 Quality Ratios '+
'
'+
''+
'Ratio Formula '+
'Value Benchmark '+
'Status '+
row('OCF Ratio', 'OCF ÷ Curr.Liab.', ocrVal, '≥0.40', parseFloat(ocrVal)/0.6*80, s1.color, s1.label)+
row('Cash Coverage', 'OCF ÷ Total Debt', coverVal, '≥0.30', parseFloat(coverVal)/0.5*80, s2.color, s2.label)+
row('FCF Margin', 'FCF ÷ Revenue', fcfMarginVal,'≥5%', parseFloat(fcfMarginVal)/10*80, s3.color, s3.label)+
'
'+
'
📈 Efficiency Ratios '+
'
'+
row('Cash ROA', 'OCF ÷ Total Assets',roaVal, '≥8%', parseFloat(roaVal)/12*80, s4.color, s4.label)+
row('Cash/Income', 'OCF ÷ Net Income', cashIncVal, '≥1.0x', parseFloat(cashIncVal)/1.5*80,s5.color, s5.label)+
row('CapEx Ratio', 'CapEx ÷ OCF', capexRatVal, '≤50%', (100-parseFloat(capexRatVal))/100*80, s6.color, s6.label)+
'
'+
'
🌿 Dividend & Growth '+
'
'+
row('Dividend Payout', 'Divs ÷ OCF', divPayVal, '≤30%', (100-parseFloat(divPayVal))/100*80, s7.color, s7.label)+
row('CF Growth Rate', 'YoY OCF Growth', growthVal, '≥10%', parseFloat(growthVal)/20*80, s8.color, s8.label)+
row('Reinvestment', 'CapEx ÷ Depr.', reinvVal, '1.5–3.0x', parseFloat(reinvVal)/3*80, s9.color, s9.label)+
'
'+
'
Figures based on current period statement. Free Cash Flow = $'+Math.round(fcf/1000)+'K (Operating CF $'+Math.round(opCF/1000)+'K − CapEx $'+Math.round(capex/1000)+'K).
'+
'
Close
'+
'
Revenue Growth Rate 5% monthly Cost Inflation 2% monthly Collection Period 30 days Payment Period 45 days Capital Expenditure $15,000/month
Close
'); });
btn('scenario-modeling-btn', function(){ modal('Model different cash flow scenarios:
Revenue Change (%) 0%
Cost Change (%) 0%
Investment Change (%) 0%
Close Run Model
'); });
// CF expandable sections
document.addEventListener('click', function(e){
var hdr=e.target.closest('.expandable-cf-header');
if(hdr){
var tid=hdr.dataset.target;
var row=document.getElementById(tid);
var icon=hdr.querySelector('.expand-cf-icon');
if(row){row.style.display=(!row.style.display||row.style.display==='none')?'table-row':'none';}
if(icon){icon.classList.toggle('fa-chevron-right');icon.classList.toggle('fa-chevron-down');}
}
});
// CF drill-down buttons
var cfDrills={
'net-income':{t:'Net Income Details',rows:[['Revenue','$245,000'],['COGS','($147,000)'],['Gross Profit','$98,000'],['Operating Expenses','($52,500)'],['Net Income','$30,500']]},
'depreciation':{t:'Depreciation Breakdown',rows:[['Buildings','$3,500'],['Machinery','$2,800'],['Vehicles','$700'],['Total','$7,000']]},
'receivables':{t:'Receivables Changes',rows:[['Opening AR','$95,000'],['Collections','$265,000'],['New Sales','$259,500'],['Closing AR','$89,500'],['Net Change','$5,500']]},
'inventory':{t:'Inventory Changes',rows:[['Opening','$72,000'],['Purchases','$64,300'],['COGS Used','$68,500'],['Closing','$67,800'],['Net Change','$4,200']]},
'payables':{t:'Payables Changes',rows:[['Opening AP','$52,000'],['Payments','$148,000'],['New Purchases','$152,300'],['Closing AP','$56,300'],['Net Change','$4,300']]}
};
document.addEventListener('click', function(e){
var db=e.target.closest('.cf-drill-down-btn');
if(db){
var item=db.dataset.item;
var data=cfDrills[item]||{t:(item||'Item')+' Details',rows:[['Amount','$0']]};
var rows=data.rows.map(function(r){var bold=r[0].indexOf('Total')===0||r[0].indexOf('Net')===0;return ''+r[0]+' '+r[1]+' ';}).join('');
modal('Close
');
}
});
// CF info buttons � rich per-item modals
var cfInfoData = {
'cf003-amort': {
title: 'CF003 � Amortization of Intangibles',
icon: 'fa-layer-group', color: '#6366f1',
summary: 'Non-cash charge spreading the cost of intangible assets over their useful life. Added back because it reduces net income without using cash.',
rows: [
['Intangible Asset', 'Book Value', 'Annual Amort.'],
['Customer Relationships', '$18,000', '$1,200'],
['Software Licenses', '$12,000', '$1,000'],
['Trade Marks', '$6,000', '$500'],
['Non-compete Agreement', '$3,900', '$300'],
],
note: 'Straight-line method over estimated useful life. No cash outflow occurs in the current period.'
},
'cf102-sale-equip': {
title: 'CF102 � Sale of Equipment',
icon: 'fa-tools', color: '#f59e0b',
summary: 'Proceeds from disposal of fixed assets. $0 this period; $5,000 received in prior period from sale of a forklift.',
rows: [
['Asset', 'Year Purchased', 'Book Value', 'Sale Price'],
['Forklift (Prev. Period)', '2021', '$3,200', '$5,000'],
['Current Period', '�', '�', '$0 (No disposals)'],
],
note: 'Gain on sale of $1,800 in prior period was included in net income and eliminated in operating activities.'
},
'cf103-invest': {
title: 'CF103 � Investment in Securities',
icon: 'fa-chart-pie', color: '#3b82f6',
summary: 'Cash used to purchase short-term or long-term investment securities. $0 this period; prior year included $10,000 in treasury bills.',
rows: [
['Type', 'Prior Period', 'Current Period'],
['Treasury Bills (90-day)', '$10,000', '$0'],
['Corporate Bonds', '$0', '$0'],
['Total', '$10,000', '$0'],
],
note: 'All prior-period securities matured during Q1. No new securities purchased this period.'
},
'cf201-ltd-proceeds': {
title: 'CF201 � Proceeds from Long-term Debt',
icon: 'fa-university', color: '#10b981',
summary: 'Cash received from new long-term borrowings. $0 this period; $25,000 term loan was drawn in the prior period.',
rows: [
['Facility', 'Lender', 'Prior Year', 'Current'],
['Term Loan A', 'First National Bank', '$25,000', '$0'],
['Revolving Credit', 'City Bank', '$0', '$0'],
['Total New Borrowings', '', '$25,000', '$0'],
],
note: 'Available revolving credit facility of $50,000 remains undrawn. No new debt raised this period � management strategy is to reduce leverage.'
},
'cf204-stock': {
title: 'CF204 � Issuance of Common Stock',
icon: 'fa-certificate', color: '#8b5cf6',
summary: 'Cash raised from issuing new equity shares. $0 in both periods � no share issuance activity.',
rows: [
['Share Class', 'Shares Authorised', 'Shares Issued', 'Amount'],
['Ordinary Shares ($1 par)', '500,000', '265,000', '$265,000'],
['New Issuances (Current)', '�', '0', '$0'],
['New Issuances (Prior)', '�', '0', '$0'],
],
note: 'Share capital is fully paid up. No stock options exercised or new capital raises during either period reported.'
},
'df005-interest': {
title: 'DF005 � Cash Paid for Interest',
icon: 'fa-percentage', color: '#ef4444',
summary: 'Actual cash outflow for interest on borrowings during the period. Presented separately under the Direct Method.',
rows: [
['Liability', 'Balance', 'Rate', 'Interest Paid'],
['Term Loan A', '$93,000', '6.5% p.a.', '$1,005'],
['Finance Lease', '$12,000', '4.0% p.a.', '$495'],
['Total Interest Paid', '', '', '$1,500'],
],
note: 'Interest payments on borrowings are classified as operating cash flows per IAS 7 (alternative treatment). Compare to Indirect: interest expense is already deducted from net income.'
},
'df006-taxes': {
title: 'DF006 � Income Taxes Paid',
icon: 'fa-file-invoice-dollar', color: '#dc2626',
summary: 'Cash actually paid to tax authorities during the period. May differ from income tax expense due to timing of instalment payments.',
rows: [
['Component', 'Amount'],
['Q1 Instalment Payment', '$2,250'],
['Q2 Instalment Payment', '$2,250'],
['Prior Year Balance Settled', '$4,500'],
['Total Tax Paid', '$9,000'],
],
note: 'Current year tax expense was $8,200. Difference of $800 represents a timing difference � prior year balance settled in full this period.'
},
'df007-other': {
title: 'DF007 � Other Operating Cash Flows',
icon: 'fa-ellipsis-h', color: '#6b7280',
summary: 'Miscellaneous operating cash movements not captured in other line items.',
rows: [
['Item', 'Current', 'Prior'],
['Security Deposits Paid', '-$500', '$0'],
['Insurance Refund Received', '$0', '$3,500'],
['GST/VAT Net Settlement', '-$300', '$2,000'],
['Staff Advances (Net)', '-$200', '$2,000'],
['Total', '-$1,000', '$7,500'],
],
note: 'Prior period included a one-time insurance refund of $3,500 and favourable GST settlement � these do not recur.'
}
};
document.addEventListener('click', function(e){
var ib = e.target.closest('.cf-info-btn');
if (!ib) return;
var key = ib.dataset.item || '';
var info = cfInfoData[key];
if (!info) {
modal('No additional detail available for this item.
Close
');
return;
}
var headerRow = info.rows[0];
var dataRows = info.rows.slice(1);
var thCells = headerRow.map(function(h){ return ''+h+' '; }).join('');
var tdRows = dataRows.map(function(r, i){
var isTotal = (r[0]||'').toLowerCase().indexOf('total') === 0;
var tds = r.map(function(c){ return ''+(c||'')+' '; }).join('');
return ''+ tds +'';
}).join('');
modal(
''+
'
'+
'
'+info.summary+'
'+
'
'+
''+thCells+' '+tdRows+' '+
'
'+
(info.note ? 'Note: '+info.note+'
' : '')+
'Close
'
);
});
// ---------------------------------------
// SELECT/DROPDOWN change handlers
// ---------------------------------------
var plPeriodSel = document.getElementById('pl-period-type');
if (plPeriodSel) {
plPeriodSel.addEventListener('change', function(){
var m = calcPL(this.value);
setTF('total-revenue', fmt(m.tr)); setTF('total-expenses', fmt(m.opex+m.cogs));
setTF('net-profit', fmt(m.np));
var pm=document.getElementById('profit-margin');if(pm)pm.textContent=m.nm.toFixed(1)+'%';
setTF('total-revenue-amount', fmt(m.tr)); setTF('total-cogs-amount', fmt(m.cogs));
setTF('gross-profit-amount', fmt(m.gp)); setTF('total-opex-amount', fmt(m.opex));
setTF('operating-profit-amount', fmt(m.op));
setTF('net-profit-before-tax', fmt(m.ebt)); setTF('final-net-profit', fmt(m.np));
toast('Period changed to '+this.value+'. Values updated.','info');
});
}
var chartViewSel = document.getElementById('chart-view-type');
if (chartViewSel) {
chartViewSel.addEventListener('change', function(){
var viewType = this.value;
// Use the existing updatePLChartView if available
if (window.updatePLChartView && window.plAnalysisChart) {
window.updatePLChartView(window.plAnalysisChart, viewType);
toast('Chart view: '+viewType+' selected','info');
return;
}
// Fallback: re-render chart directly
var canvas = document.getElementById('plAnalysisChart');
if (!canvas || typeof Chart === 'undefined') { toast('Chart not available','error'); return; }
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
var placeholder = document.getElementById('plAnalysisChart-placeholder');
if (placeholder) placeholder.style.display = 'none';
var cfg = {type:'bar',data:{},options:{responsive:true,maintainAspectRatio:false,plugins:{title:{display:true}}}};
switch(viewType) {
case 'waterfall':
cfg.data = {labels:['Revenue','COGS','Gross Profit','OpEx','Operating Profit','Tax','Net Profit'],
datasets:[{label:'Waterfall Analysis ($)',data:[186500,-68500,118000,-73800,44200,-13700,30500],
backgroundColor:function(ctx){return ctx.raw>0?'#10b981':'#ef4444';}}]};
cfg.options.plugins.title.text='P&L Waterfall � Monthly';
cfg.options.scales={y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}};
break;
case 'trend':
cfg.type='line';
cfg.data={labels:['Q1','Q2','Q3','Q4','Q1 (Current)'],
datasets:[{label:'Revenue Trend',data:[145000,158000,165800,172000,186500],borderColor:'#10b981',backgroundColor:'rgba(16,185,129,0.1)',fill:true,tension:0.4},
{label:'Net Profit Trend',data:[18500,22000,24100,26800,30500],borderColor:'#3b82f6',backgroundColor:'rgba(59,130,246,0.1)',fill:true,tension:0.4}]};
cfg.options.plugins.title.text='Revenue & Profit Trend';
cfg.options.scales={y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}};
break;
case 'breakdown':
cfg.type='doughnut';
cfg.data={labels:['Product Sales','Service Revenue','Subscription','Commission','Other Income'],
datasets:[{data:[125000,40000,12500,6500,2500],backgroundColor:['#10b981','#3b82f6','#8b5cf6','#f59e0b','#06b6d4'],borderWidth:2}]};
cfg.options.plugins.title.text='Revenue Breakdown';
delete cfg.options.scales;
break;
case 'margins':
cfg.data={labels:['Gross Margin','EBITDA Margin','Operating Margin','Net Margin'],
datasets:[{label:'Current Period (%)',data:[63.3,23.7,21.3,16.4],backgroundColor:['#10b981','#8b5cf6','#f59e0b','#3b82f6']},
{label:'Previous Period (%)',data:[62.4,20.6,18.9,14.5],backgroundColor:['rgba(16,185,129,0.4)','rgba(139,92,246,0.4)','rgba(245,158,11,0.4)','rgba(59,130,246,0.4)']}]};
cfg.options.plugins.title.text='Margin Analysis � Current vs Previous';
cfg.options.scales={y:{ticks:{callback:function(v){return v+'%';}},beginAtZero:true}};
break;
}
new Chart(canvas.getContext('2d'), cfg);
toast('Chart view: '+viewType+' selected','info');
});
}
// Chart type select for Balance Sheet � REAL chart re-render
var bsChartSel = document.getElementById('chart-type-select');
if (bsChartSel) {
bsChartSel.addEventListener('change', function(){
var viewType = this.value;
var canvas = document.getElementById('balanceSheetChart');
if (!canvas || typeof Chart === 'undefined') { toast('Chart not available','error'); return; }
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
var cfg;
switch(viewType) {
case 'composition':
default:
cfg = {type:'doughnut',data:{labels:['Current Assets','Non-Current Assets','Current Liabilities','Non-Current Liabilities','Equity'],datasets:[{data:[267000,200000,109000,93000,265000],backgroundColor:['#10b981','#3b82f6','#ef4444','#f59e0b','#8b5cf6'],borderWidth:2,borderColor:'#fff',hoverOffset:8}]},options:{responsive:true,maintainAspectRatio:false,plugins:{title:{display:true,text:'Balance Sheet Composition',font:{size:16,weight:'bold'}},legend:{position:'bottom',labels:{padding:16}}}}};
break;
case 'trends':
cfg = {type:'line',data:{labels:['2021','2022','2023','2024','2025'],datasets:[{label:'Total Assets',data:[450000,520000,580000,640000,667000],borderColor:'#10b981',backgroundColor:'rgba(16,185,129,0.1)',fill:true,tension:0.3},{label:'Total Liabilities',data:[280000,320000,340000,335000,202000],borderColor:'#ef4444',backgroundColor:'rgba(239,68,68,0.1)',fill:true,tension:0.3},{label:'Total Equity',data:[170000,200000,240000,305000,265000],borderColor:'#8b5cf6',backgroundColor:'rgba(139,92,246,0.1)',fill:true,tension:0.3}]},options:{responsive:true,maintainAspectRatio:false,plugins:{title:{display:true,text:'Balance Sheet Trends (5-Year)',font:{size:16,weight:'bold'}},legend:{position:'bottom'}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}};
break;
case 'ratios':
cfg = {type:'bar',data:{labels:['Current Ratio','Quick Ratio','D/E Ratio','ROE (%)','ROA (%)'],datasets:[{label:'Current',data:[2.45,1.88,0.76,11.5,4.6],backgroundColor:['#10b981','#3b82f6','#f59e0b','#8b5cf6','#06b6d4'],borderRadius:6},{label:'Industry Avg',data:[2.0,1.5,1.0,12.0,6.0],backgroundColor:['rgba(16,185,129,0.3)','rgba(59,130,246,0.3)','rgba(245,158,11,0.3)','rgba(139,92,246,0.3)','rgba(6,182,212,0.3)'],borderRadius:6}]},options:{responsive:true,maintainAspectRatio:false,plugins:{title:{display:true,text:'Financial Ratios vs Industry Average',font:{size:16,weight:'bold'}},legend:{position:'bottom'}},scales:{y:{beginAtZero:true}}}};
break;
case 'comparison':
cfg = {type:'bar',data:{labels:['Current Assets','Non-Current Assets','Current Liab.','Non-Current Liab.','Equity'],datasets:[{label:'Current Period ($)',data:[267000,200000,109000,93000,265000],backgroundColor:'rgba(16,185,129,0.8)',borderRadius:6},{label:'Previous Period ($)',data:[251000,185000,115000,101000,220000],backgroundColor:'rgba(59,130,246,0.5)',borderRadius:6}]},options:{responsive:true,maintainAspectRatio:false,plugins:{title:{display:true,text:'Period Comparison',font:{size:16,weight:'bold'}},legend:{position:'bottom'}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}};
break;
}
new Chart(canvas.getContext('2d'), cfg);
toast('Chart view: '+viewType,'info');
});
}
// Trend period select � re-render trend chart
var trendPeriodSel = document.getElementById('trend-period-select');
if (trendPeriodSel) {
trendPeriodSel.addEventListener('change', function(){
var period = this.value;
var canvas = document.getElementById('trendChart');
if (!canvas || typeof Chart === 'undefined') { toast('Chart not available','error'); return; }
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
var labels, assets, liabilities, equity;
switch(period) {
case 'monthly':
labels=['Jan','Feb','Mar','Apr','May','Jun','Jul'];
assets=[620000,625000,635000,642000,648000,655000,662700];
liabilities=[340000,338000,335000,332000,330000,329000,328000];
equity=[280000,287000,300000,310000,318000,326000,334400];
break;
case 'quarterly':
labels=['Q1 2024','Q2 2024','Q3 2024','Q4 2024','Q1 2025','Q2 2025'];
assets=[580000,605000,625000,645000,655000,662700];
liabilities=[360000,352000,345000,338000,332000,328000];
equity=[220000,253000,280000,307000,323000,334400];
break;
case 'yearly':
default:
labels=['2021','2022','2023','2024','2025'];
assets=[450000,520000,580000,640000,662700];
liabilities=[280000,320000,340000,335000,328000];
equity=[170000,200000,240000,305000,334400];
break;
}
new Chart(canvas.getContext('2d'),{type:'line',data:{labels:labels,datasets:[{label:'Total Assets',data:assets,borderColor:'#10b981',backgroundColor:'rgba(16,185,129,0.1)',fill:true,tension:0.3},{label:'Total Liabilities',data:liabilities,borderColor:'#ef4444',backgroundColor:'rgba(239,68,68,0.1)',fill:true,tension:0.3},{label:'Total Equity',data:equity,borderColor:'#8b5cf6',backgroundColor:'rgba(139,92,246,0.1)',fill:true,tension:0.3}]},options:{responsive:true,plugins:{title:{display:true,text:'Balance Sheet Trend � '+period.charAt(0).toUpperCase()+period.slice(1),font:{size:16}},legend:{position:'bottom'}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}});
toast('Trend view: '+period,'info');
});
}
// BS View Type select
var bsViewType = document.getElementById('bs-view-type');
if (bsViewType) {
bsViewType.addEventListener('change', function(){
var view = this.value;
var section = document.getElementById('balance-sheet');
if (!section) return;
var detailRows = section.querySelectorAll('tr[data-detail-level]');
detailRows.forEach(function(r){
var level = parseInt(r.dataset.detailLevel) || 1;
if (view === 'summary') r.style.display = level > 1 ? 'none' : '';
else if (view === 'condensed') r.style.display = level > 0 ? 'none' : '';
else r.style.display = '';
});
toast('Balance Sheet view: '+view,'info');
});
}
// BS Currency select � show conversion toast
var bsCurrency = document.getElementById('bs-currency');
if (bsCurrency) {
bsCurrency.addEventListener('change', function(){
var cur = this.value;
var rates = {usd:1, eur:0.92, gbp:0.79, ngn:1580.50};
var symbols = {usd:'$', eur:'�', gbp:'�', ngn:'?'};
var rate = rates[cur] || 1;
var sym = symbols[cur] || '$';
// Update BS amount displays
var bsAmounts = {
'total-current-assets':294700, 'total-non-current-assets':368000,
'total-assets':662700, 'total-current-liabilities':116000,
'total-non-current-liabilities':212000, 'total-liabilities':328000,
'total-equity':334400
};
Object.keys(bsAmounts).forEach(function(id){
var el = document.getElementById(id);
if (el) {
var val = Math.round(bsAmounts[id] * rate);
el.textContent = sym + val.toLocaleString('en-US', {minimumFractionDigits:2, maximumFractionDigits:2});
flashEl(el);
}
});
toast('Currency changed to '+cur.toUpperCase()+' (rate: '+rate.toFixed(2)+')','info');
});
}
// Compare Balance Sheet � MISSING handler
btn('compare-balance-sheet-btn', function(){
var b=this;loading(b,'Comparing...');
setTimeout(function(){done(b);
var currentDate = (document.getElementById('bs-report-date')||{}).value || '2025-07-09';
var compDate = (document.getElementById('bs-comparison-date')||{}).value || '2024-07-09';
var current = {ca:294700, nca:368000, ta:662700, cl:116000, ncl:212000, tl:328000, eq:334400};
var prev = {ca:268500, nca:342000, ta:610500, cl:128000, ncl:225000, tl:353000, eq:257500};
function varPct(c,p){return p===0?'N/A':((c-p)/p*100).toFixed(1)+'%';}
function varColor(c,p,inv){var d=c-p;if(inv)d=-d;return d>=0?'color:#198754':'color:#dc3545';}
var rows = [
['Current Assets', current.ca, prev.ca, false],
['Non-Current Assets', current.nca, prev.nca, false],
['Total Assets', current.ta, prev.ta, false],
['Current Liabilities', current.cl, prev.cl, true],
['Non-Current Liabilities', current.ncl, prev.ncl, true],
['Total Liabilities', current.tl, prev.tl, true],
['Total Equity', current.eq, prev.eq, false]
];
var rowsHtml = rows.map(function(r){
var bold = r[0].indexOf('Total')===0 ? ' style="font-weight:bold;background:#f8f9fa"' : '';
return ''+r[0]+' '+fmt(r[1])+' '+fmt(r[2])+' '+fmt(r[1]-r[2])+' '+varPct(r[1],r[2])+' ';
}).join('');
modal(''+currentDate+' vs '+compDate+'
'+
'Item Current Previous Variance % Change '+rowsHtml+'
'+
'Summary: Total Assets grew '+varPct(current.ta,prev.ta)+' while Total Liabilities decreased '+varPct(current.tl,prev.tl)+'. Equity increased by '+fmt(current.eq-prev.eq)+' ('+varPct(current.eq,prev.eq)+').
'+
'Close
');
window._bsCompCSV = function(){
var csv = 'Balance Sheet Comparison\\nGenerated: '+new Date().toLocaleDateString()+'\\n\\nItem,Current,Previous,Variance,Change %\\n';
rows.forEach(function(r){ csv += r[0]+','+r[1]+','+r[2]+','+(r[1]-r[2])+','+varPct(r[1],r[2])+'\\n'; });
downloadCSV('BS_Comparison_'+new Date().toISOString().slice(0,10)+'.csv', csv);
toast('Comparison exported!','success');
};
},1000);
});
// BS Report Date and Comparison Date change handlers
var bsReportDate = document.getElementById('bs-report-date');
if (bsReportDate) {
bsReportDate.addEventListener('change', function(){
toast('Report date set to '+this.value+'. Click "Generate Balance Sheet" to update.','info');
});
}
var bsCompDate = document.getElementById('bs-comparison-date');
if (bsCompDate) {
bsCompDate.addEventListener('change', function(){
toast('Comparison date set to '+this.value+'. Click "Compare Periods" to view.','info');
});
}
// CF Method select
var cfMethod = document.getElementById('cf-method');
if (cfMethod) {
cfMethod.addEventListener('change', function(){
toast('Cash flow method changed to: '+this.options[this.selectedIndex].text+'. Click "Generate Statement" to apply.','info');
});
}
// CF Currency select
var cfCurrency = document.getElementById('cf-currency');
if (cfCurrency) {
cfCurrency.addEventListener('change', function(){
var cur = this.value;
var rates = {usd:1, eur:0.92, gbp:0.79, ngn:1580.50};
var symbols = {usd:'$', eur:'�', gbp:'�', ngn:'?'};
var rate = rates[cur] || 1; var sym = symbols[cur] || '$';
var cfAmounts = {'operating-cash-flow':65000,'investing-cash-flow':-20000,'financing-cash-flow':-15000,'net-cash-flow':30000};
Object.keys(cfAmounts).forEach(function(id){
var el = document.getElementById(id);
if (el) { var val = Math.round(cfAmounts[id]*rate); el.textContent = sym+Math.abs(val).toLocaleString('en-US')+(val<0?' ':''); flashEl(el); }
});
toast('Cash flow currency changed to '+cur.toUpperCase(),'info');
});
}
// CF Period dates
var cfStart = document.getElementById('cf-period-start');
if (cfStart) { cfStart.addEventListener('change', function(){ toast('Period start: '+this.value+'. Click "Generate Statement" to apply.','info'); }); }
var cfEnd = document.getElementById('cf-period-end');
if (cfEnd) { cfEnd.addEventListener('change', function(){ toast('Period end: '+this.value+'. Click "Generate Statement" to apply.','info'); }); }
// CF Chart Type select � REAL chart re-render
var cfChartType = document.getElementById('cf-chart-type-select');
if (cfChartType) {
cfChartType.addEventListener('change', function(){
var viewType = this.value;
var canvas = document.getElementById('cashFlowAnalysisChart');
if (!canvas || typeof Chart === 'undefined') { toast('Chart not available','error'); return; }
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
var cfg;
switch(viewType) {
case 'waterfall':
default:
cfg = {type:'bar',data:{labels:['Operating','Investing','Financing','Net Change'],datasets:[{label:'Cash Flow ($)',data:[65000,-20000,-15000,30000],backgroundColor:['#10b981','#3b82f6','#f59e0b','#8b5cf6'],borderRadius:6}]},options:{responsive:true,plugins:{legend:{display:false},title:{display:true,text:'Cash Flow Waterfall',font:{size:16}}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}};
break;
case 'trends':
cfg = {type:'line',data:{labels:['Jan','Feb','Mar','Apr','May','Jun','Jul'],datasets:[{label:'Operating CF',data:[52000,55000,58000,60000,62000,63000,65000],borderColor:'#10b981',tension:0.3,fill:false},{label:'Net CF',data:[22000,24000,25000,27000,28000,29000,30000],borderColor:'#8b5cf6',tension:0.3,fill:false}]},options:{responsive:true,plugins:{title:{display:true,text:'Cash Flow Trends',font:{size:16}}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}};
break;
case 'composition':
cfg = {type:'doughnut',data:{labels:['Operating','Investing (abs)','Financing (abs)'],datasets:[{data:[65000,20000,15000],backgroundColor:['#10b981','#3b82f6','#f59e0b'],borderWidth:2}]},options:{responsive:true,plugins:{title:{display:true,text:'Cash Flow Composition',font:{size:16}},legend:{position:'bottom'}}}};
break;
case 'forecast':
cfg = {type:'line',data:{labels:['M1','M2','M3','M4','M5','M6','M7','M8','M9','M10','M11','M12'],datasets:[{label:'Projected Net CF',data:[30000,32000,35000,37000,38000,40000,42000,44000,45000,47000,48000,50000],borderColor:'#3b82f6',backgroundColor:'rgba(59,130,246,0.1)',fill:true,tension:0.3,borderDash:[5,5]},{label:'Projected Operating CF',data:[65000,67000,69000,71000,72000,74000,75000,77000,78000,80000,81000,83000],borderColor:'#10b981',tension:0.3,fill:false}]},options:{responsive:true,plugins:{title:{display:true,text:'12-Month Cash Flow Forecast',font:{size:16}}},scales:{y:{ticks:{callback:function(v){return window.currencySymbol()+(v/1000).toFixed(0)+'K';}}}}}};
break;
}
new Chart(canvas.getContext('2d'), cfg);
toast('Cash flow chart: '+viewType,'info');
});
}
// --- REFRESH RATIOS � real recalculation ---
// (Overrides the earlier btn('refresh-ratios-btn'...) with real logic)
(function(){
var rrBtn = document.getElementById('refresh-ratios-btn');
if (!rrBtn) return;
// Remove existing listeners by cloning
var newBtn = rrBtn.cloneNode(true);
rrBtn.parentNode.replaceChild(newBtn, rrBtn);
newBtn.addEventListener('click', function(){
var b=this; b.innerHTML='Email Address
Frequency Daily Weekly Monthly
Cancel Schedule
'); };
window.showNewTransactionModal = function(){ modal('Type Income Expense Transfer
Amount
Description
Cancel
'); };
console.log('[MASTER] All buttons wired � total: 47+ ID buttons + delegated class buttons');
// --- INIT BALANCE SHEET CHART (default composition view) ---
window.initBalanceSheetChart = function() {
var canvas = document.getElementById('balanceSheetChart');
if (!canvas || typeof Chart === 'undefined') return;
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
new Chart(canvas.getContext('2d'), {
type: 'doughnut',
data: {
labels: ['Current Assets','Non-Current Assets','Current Liabilities','Non-Current Liabilities','Equity'],
datasets: [{
data: [267000, 200000, 109000, 93000, 265000],
backgroundColor: ['#10b981','#3b82f6','#ef4444','#f59e0b','#8b5cf6'],
borderWidth: 2,
borderColor: '#fff',
hoverOffset: 8
}]
},
options: {
responsive: true,
maintainAspectRatio: false,
plugins: {
legend: { position: 'bottom', labels: { padding: 16, font: { size: 13 } } },
title: { display: true, text: 'Balance Sheet Composition', font: { size: 16, weight: 'bold' } },
tooltip: {
callbacks: {
label: function(ctx) {
var v = ctx.parsed;
var total = ctx.dataset.data.reduce(function(a,b){return a+b;},0);
return ' ' + ctx.label + ': $' + v.toLocaleString('en-US') + ' (' + (v/total*100).toFixed(1) + '%)';
}
}
}
}
}
});
};
// Auto-init when canvas first enters the viewport
(function(){
var canvas = document.getElementById('balanceSheetChart');
if (!canvas) return;
if ('IntersectionObserver' in window) {
var obs = new IntersectionObserver(function(entries, o) {
entries.forEach(function(entry) {
if (entry.isIntersecting) {
var existing = typeof Chart !== 'undefined' && Chart.getChart ? Chart.getChart(canvas) : null;
if (!existing) window.initBalanceSheetChart();
o.disconnect();
}
});
}, { threshold: 0.1 });
obs.observe(canvas);
} else {
setTimeout(window.initBalanceSheetChart, 800);
}
})();
// -- Cash Flow Impact Chart ------------------------------------------
window.initCashFlowImpactChart = function() {
var canvas = document.getElementById('cashFlowImpactChart');
if (!canvas || typeof Chart === 'undefined') return;
var existing = Chart.getChart ? Chart.getChart(canvas) : null;
if (existing) existing.destroy();
var months = ['Aug','Sep','Oct','Nov','Dec','Jan'];
new Chart(canvas.getContext('2d'), {
type: 'bar',
data: {
labels: months,
datasets: [
{
label: 'Cash Inflows',
data: [210000, 215000, 225000, 198000, 232000, 241000],
backgroundColor: 'rgba(16, 185, 129, 0.75)',
borderColor: '#059669',
borderWidth: 1.5,
borderRadius: 4,
order: 2
},
{
label: 'Cash Outflows',
data: [-175000, -180000, -178000, -191000, -185000, -196000],
backgroundColor: 'rgba(239, 68, 68, 0.70)',
borderColor: '#dc2626',
borderWidth: 1.5,
borderRadius: 4,
order: 2
},
{
label: 'Net Cash',
data: [35000, 35000, 47000, 7000, 47000, 45000],
type: 'line',
borderColor: '#3b82f6',
backgroundColor: 'rgba(59,130,246,0.10)',
borderWidth: 2.5,
pointBackgroundColor: '#3b82f6',
pointRadius: 4,
tension: 0.35,
fill: true,
order: 1,
yAxisID: 'yNet'
}
]
},
options: {
responsive: true,
maintainAspectRatio: false,
interaction: { mode: 'index', intersect: false },
plugins: {
legend: { position: 'bottom', labels: { padding: 14, font: { size: 12 } } },
title: { display: true, text: 'Monthly Cash Flow (6-Month View)', font: { size: 14, weight: '600' }, color: '#1e40af', padding: { bottom: 10 } },
tooltip: {
callbacks: {
label: function(ctx) {
var v = Math.abs(ctx.parsed.y);
return ' ' + ctx.dataset.label + ': $' + (v/1000).toFixed(0) + 'K';
}
}
}
},
scales: {
x: { grid: { display: false }, ticks: { font: { size: 12 } } },
y: {
position: 'left',
ticks: {
callback: function(v) { return window.currencySymbol() + (Math.abs(v)/1000).toFixed(0) + 'K'; },
font: { size: 11 }
},
grid: { color: 'rgba(0,0,0,0.05)' }
},
yNet: {
position: 'right',
grid: { drawOnChartArea: false },
ticks: {
callback: function(v) { return window.currencySymbol() + (v/1000).toFixed(0) + 'K'; },
font: { size: 11 }, color: '#3b82f6'
}
}
}
}
});
};
(function(){
var cfCanvas = document.getElementById('cashFlowImpactChart');
if (!cfCanvas) return;
if ('IntersectionObserver' in window) {
var obs = new IntersectionObserver(function(entries, o) {
entries.forEach(function(entry) {
if (entry.isIntersecting) {
var existing = typeof Chart !== 'undefined' && Chart.getChart ? Chart.getChart(cfCanvas) : null;
if (!existing) window.initCashFlowImpactChart();
o.disconnect();
}
});
}, { threshold: 0.1 });
obs.observe(cfCanvas);
} else {
setTimeout(window.initCashFlowImpactChart, 1000);
}
})();
})();
Bill ' + b.bill_number + ' ' +
'
' +
'' +
'Field Value Vendor ' + b.vendor + ' Bill Date ' + b.bill_date + ' Due Date ' + b.due_date + ' Amount $' + parseFloat(b.amount||0).toFixed(2) + ' Status ' + b.status + ' Description ' + b.description + '