Test your pricing by entering an LOI. Uses the saved rates above and live exchange rates.
INR Price
—
USD Price
—
EUR Price
—
query("SELECT p.id, p.project_id as project_code, p.client_id FROM projects p LEFT JOIN invoices i ON i.project_id=p.id WHERE p.status='Closed' AND i.id IS NULL");
foreach ($stmt->fetchAll(PDO::FETCH_ASSOC) as $m) {
if (function_exists('generateProjectInvoice')) generateProjectInvoice($pdo, $m['id'], $m['project_code'], $m['client_id']);
}
} catch (Exception $e) {}
// Update statuses
if (function_exists('updateInvoiceStatuses')) updateInvoiceStatuses($pdo);
// Handle invoice POST actions
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
$invAction = $_POST['action'];
$invId = intval($_POST['invoice_id'] ?? 0);
if ($invAction === 'mark_paid' && $invId) {
$pdo->prepare("UPDATE invoices SET status='paid', paid_date=?, payment_reference=?, remarks=?, updated_at=NOW() WHERE id=?")->execute([$_POST['paid_date'] ?? date('Y-m-d'), trim($_POST['payment_reference'] ?? ''), trim($_POST['remarks'] ?? ''), $invId]);
$success = 'Invoice marked as paid.';
logActivity($_SESSION['admin_id'], 'update', "Marked invoice #$invId as paid", 'invoice', $invId);
}
if ($invAction === 'save_remarks' && $invId) {
$pdo->prepare("UPDATE invoices SET remarks=?, updated_at=NOW() WHERE id=?")->execute([trim($_POST['remarks'] ?? ''), $invId]);
$success = 'Remarks saved.';
}
if ($invAction === 'revert_unpaid' && $invId) {
$pdo->prepare("UPDATE invoices SET status='invoiced', paid_date=NULL, payment_reference=NULL, updated_at=NOW() WHERE id=?")->execute([$invId]);
if (function_exists('updateInvoiceStatuses')) updateInvoiceStatuses($pdo);
$success = 'Invoice reverted to unpaid.';
}
}
// Ban enforcement
try {
$bannedClients = $pdo->query("SELECT DISTINCT client_id FROM invoices WHERE status != 'paid' AND due_date < DATE_SUB(CURDATE(), INTERVAL 90 DAY)")->fetchAll(PDO::FETCH_COLUMN);
if (!empty($bannedClients)) {
$ph = implode(',', array_fill(0, count($bannedClients), '?'));
$pdo->prepare("UPDATE projects SET status='On hold' WHERE client_id IN ($ph) AND status='Live'")->execute($bannedClients);
}
} catch (Exception $e) {}
// Invoice filters
$fStatus=$_GET['inv_status']??''; $fClient=$_GET['inv_client']??''; $fDateFrom=$_GET['inv_from']??'';
$fDateTo=$_GET['inv_to']??''; $fSearch=trim($_GET['inv_search']??''); $fCurrency=$_GET['inv_currency']??'';
$fDueFrom=$_GET['inv_due_from']??''; $fDueTo=$_GET['inv_due_to']??'';
$invSort=$_GET['inv_sort']??'invoice_date'; $invDir=($_GET['inv_dir']??'desc')==='asc'?'ASC':'DESC';
$invAllowed=['invoice_number','invoice_date','due_date','total_amount','status','project_code','client_name'];
if (!in_array($invSort,$invAllowed)) $invSort='invoice_date';
$invWhere=["1=1"]; $invParams=[];
if($fStatus){$invWhere[]="i.status=?";$invParams[]=$fStatus;}
if($fClient){$invWhere[]="i.client_id=?";$invParams[]=(int)$fClient;}
if($fCurrency){$invWhere[]="i.currency=?";$invParams[]=$fCurrency;}
if($fDateFrom){$invWhere[]="i.invoice_date>=?";$invParams[]=$fDateFrom;}
if($fDateTo){$invWhere[]="i.invoice_date<=?";$invParams[]=$fDateTo;}
if($fDueFrom){$invWhere[]="i.due_date>=?";$invParams[]=$fDueFrom;}
if($fDueTo){$invWhere[]="i.due_date<=?";$invParams[]=$fDueTo;}
if($fSearch){$invWhere[]="(i.invoice_number LIKE ? OR p.project_name LIKE ? OR i.project_code LIKE ? OR c.company_name LIKE ?)";$s="%$fSearch%";$invParams=array_merge($invParams,[$s,$s,$s,$s]);}
$invWc=implode(' AND ',$invWhere);
$stmt=$pdo->prepare("SELECT i.*,p.project_name,p.industry,c.company_name as client_company,c.contact_person FROM invoices i INNER JOIN projects p ON i.project_id=p.id INNER JOIN clients c ON i.client_id=c.id WHERE $invWc ORDER BY $invSort $invDir");
$stmt->execute($invParams);
$allInvoices=$stmt->fetchAll(PDO::FETCH_ASSOC);
$invSumAll=$invSumPaid=$invSumOut=0;
$invSc=['invoiced'=>0,'paid'=>0,'due'=>0,'overdue'=>0,'critical'=>0,'banned'=>0];
foreach($allInvoices as $inv){
$invSumAll+=$inv['total_amount'];
if($inv['status']==='paid')$invSumPaid+=$inv['total_amount'];else $invSumOut+=$inv['total_amount'];
$invSc[$inv['status']]=($invSc[$inv['status']]??0)+1;
}
$allClients=$pdo->query("SELECT id,company_name FROM clients ORDER BY company_name")->fetchAll(PDO::FETCH_ASSOC);
?>