getConnection();
// Query 1: Numero totale di prodotti
$totalProductsQuery = "SELECT COUNT(DISTINCT p.idproducts) AS totalProducts FROM products p WHERE 1=1";
$stmt = $pdo->query($totalProductsQuery);
$totalProducts = $stmt->fetch(PDO::FETCH_ASSOC)['totalProducts'];
// Query 2: Numero totale di report
$totalReportsQuery = "
SELECT COUNT(DISTINCT r.idreports) AS totalReports
FROM reports r
LEFT JOIN products p ON r.idproducts = p.idproducts";
$stmt = $pdo->query($totalReportsQuery);
$totalReports = $stmt->fetch(PDO::FETCH_ASSOC)['totalReports'];
// Query 3: Numero di report "fail"
$failedReportsQuery = "
SELECT COUNT(DISTINCT r.idreports) AS failedReports
FROM reports r
LEFT JOIN products p ON r.idproducts = p.idproducts
WHERE UPPER(r.reportsRating) IN ('FAIL', 'F', 'DOESN\'T COMPLY')";
$stmt = $pdo->query($failedReportsQuery);
$failedReports = $stmt->fetch(PDO::FETCH_ASSOC)['failedReports'];
// Query 4: Numero totale di test
$totalTestsQuery = "
SELECT COUNT(DISTINCT ap.idreports, ap.idPart, ap.result_TestName) AS totalTests
FROM analysis_project ap
LEFT JOIN result_project rp ON ap.idAnalysis_Project = rp.idanalysis_project
LEFT JOIN reports r ON ap.idreports = r.idreports
LEFT JOIN products p ON r.idproducts = p.idproducts";
$stmt = $pdo->query($totalTestsQuery);
$totalTests = $stmt->fetch(PDO::FETCH_ASSOC)['totalTests'];
// Query per ottenere i moduli attivi e disattivi
$query = "
SELECT idmodules, activemod
FROM activemodules
WHERE idcompany = :idcompany
";
$stmt = $pdo->prepare($query);
$stmt->execute(['idcompany' => $idcompany]);
$modulesStatus = [];
while ($row = $stmt->fetch()) {
$modulesStatus[$row['idmodules']] = $row['activemod'];
}
?>