<?php
require_once 'includes/db.php';
require_once 'includes/functions.php';

// Simulate a company ID
$companyId = 1; 
$companyWhere = " WHERE company_id = $companyId";

echo "Testing Deals Query...\n";
try {
    $sql = "SELECT COUNT(*) FROM deals $companyWhere";
    echo "SQL: $sql\n";
    $count = $pdo->query($sql)->fetchColumn();
    echo "Deals Count: $count\n";
} catch (Exception $e) {
    echo "Error in Deals: " . $e->getMessage() . "\n";
}

echo "\nTesting Properties Query...\n";
try {
    $sql = "SELECT status, COUNT(*) as count FROM properties $companyWhere GROUP BY status";
    echo "SQL: $sql\n";
    $stmt = $pdo->query($sql);
    $data = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);
    echo "Properties Data: " . print_r($data, true) . "\n";
} catch (Exception $e) {
    echo "Error in Properties: " . $e->getMessage() . "\n";
}
?>