public function getStaffStats($tenantId)
{
require __DIR__ . "/../../config/database.php";


// Today's sales
$stmt = $pdo->prepare("SELECT COALESCE(SUM(total_amount),0) as today_sales
FROM sales
WHERE tenant_id = ?
AND DATE(created_at) = CURDATE()");
$stmt->execute([$tenantId]);
$todaySales = $stmt->fetch()['today_sales'];


// Total transactions today
$stmt = $pdo->prepare("SELECT COUNT(*) as total_orders
FROM sales
WHERE tenant_id = ?
AND DATE(created_at) = CURDATE()");
$stmt->execute([$tenantId]);
$orders = $stmt->fetch()['total_orders'];


return [
'today_sales' => $todaySales,
'orders' => $orders
];
}