<?php 
// 1. UTILISATION DU HEADER UNIVERSEL (Gère la session, la DB et l'auto-logout)
require_once dirname(__DIR__) . '/header_universel.php'; 

// Protection admin
if (!isset($_SESSION['admin']) || $_SESSION['admin'] < 1) { 
    header('Location: ' . URL_ROOT . '/librairie.php'); 
    exit; 
}

if (isset($_POST['total_ventes'])){
	$dol_can = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
	$vendant_can=$dol_can->formatCurrency($_POST['total_ventes'], "CAN")."\n";
}

// 2. REQUÊTES SQL (Identiques à votre code)
$sqlQueryCD = 'SELECT SUM(coutant * quant_stock) AS somme_cd FROM inventaire2025 WHERE categorie LIKE "%cd%"';
$itemsStatementCD = $mysqlClient->prepare($sqlQueryCD);
$itemsStatementCD->execute();
$itemCD= $itemsStatementCD->fetch(PDO::FETCH_ASSOC);
$fmt_cd = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_cd=$fmt_cd->formatCurrency($itemCD['somme_cd'], "CAD");

$sqlQueryDVD = 'SELECT SUM(coutant * quant_stock) AS somme_dvd FROM inventaire2025 WHERE categorie LIKE "%dvd%"';
$itemsStatementDVD = $mysqlClient->prepare($sqlQueryDVD);
$itemsStatementDVD->execute();
$itemDVD= $itemsStatementDVD->fetch(PDO::FETCH_ASSOC);
$fmt_dvd = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_dvd=$fmt_dvd->formatCurrency($itemDVD['somme_dvd'], "CAD");

$sqlQueryLivreF = 'SELECT SUM(coutant * quant_stock) AS somme_livre_f FROM inventaire2025 WHERE categorie ="livre_francais"';
$itemsStatementLivreF = $mysqlClient->prepare($sqlQueryLivreF);
$itemsStatementLivreF->execute();
$itemLivreF= $itemsStatementLivreF->fetch(PDO::FETCH_ASSOC);
$fmt_livre_f = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_livre_f=$fmt_livre_f->formatCurrency($itemLivreF['somme_livre_f'], "CAD");

$sqlQueryLivreA = 'SELECT SUM(coutant * quant_stock) AS somme_livre_a FROM inventaire2025 WHERE categorie ="livre_anglais"';
$itemsStatementLivreA = $mysqlClient->prepare($sqlQueryLivreA);
$itemsStatementLivreA->execute();
$itemLivreA= $itemsStatementLivreA->fetch(PDO::FETCH_ASSOC);
$fmt_livre_a = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_livre_a=$fmt_livre_a->formatCurrency($itemLivreA['somme_livre_a'], "CAD");

$sqlQueryLivreFamille = 'SELECT SUM(coutant * quant_stock) AS somme_livre_famille FROM inventaire2025 WHERE categorie ="livre_famille"';
$itemsStatementLivreFamille = $mysqlClient->prepare($sqlQueryLivreFamille);
$itemsStatementLivreFamille->execute();
$itemLivreFamille= $itemsStatementLivreFamille->fetch(PDO::FETCH_ASSOC);
$fmt_livre_famille = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_livre_famille=$fmt_livre_famille->formatCurrency($itemLivreFamille['somme_livre_famille'], "CAD");

$sqlQueryPHOTO = 'SELECT SUM(coutant * quant_stock) AS somme_photo FROM inventaire2025 WHERE categorie LIKE "%photo%"';
$itemsStatementPHOTO = $mysqlClient->prepare($sqlQueryPHOTO);
$itemsStatementPHOTO->execute();
$itemPHOTO= $itemsStatementPHOTO->fetch(PDO::FETCH_ASSOC);
$fmt_photo = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_photo=$fmt_photo->formatCurrency($itemPHOTO['somme_photo'], "CAD");

$sqlQueryMALA = 'SELECT SUM(coutant * quant_stock) AS somme_mala FROM inventaire2025 WHERE categorie = "mala"';
$itemsStatementMALA = $mysqlClient->prepare($sqlQueryMALA);
$itemsStatementMALA->execute();
$itemMALA= $itemsStatementMALA->fetch(PDO::FETCH_ASSOC);
$fmt_mala = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_mala=$fmt_mala->formatCurrency($itemMALA['somme_mala'], "CAD");

$sqlQueryDIVERS = 'SELECT SUM(coutant * quant_stock) AS somme_divers FROM inventaire2025 WHERE categorie = "divers"';
$itemsStatementDIVERS = $mysqlClient->prepare($sqlQueryDIVERS);
$itemsStatementDIVERS->execute();
$itemDIVERS= $itemsStatementDIVERS->fetch(PDO::FETCH_ASSOC);
$fmt_divers = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$total_divers=$fmt_divers->formatCurrency($itemDIVERS['somme_divers'], "CAD");

$sqlQueryTotale = 'SELECT SUM(coutant * quant_stock) AS somme_totale FROM inventaire2025'	;
$itemsStatementTotale = $mysqlClient->prepare($sqlQueryTotale);
$itemsStatementTotale->execute();
$itemTotale= $itemsStatementTotale->fetch(PDO::FETCH_ASSOC);
$fmt_methode_2 = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$Methode_2=$fmt_methode_2->formatCurrency($itemTotale['somme_totale'], "CAD");

$methode_1=$itemCD['somme_cd']+$itemDVD['somme_dvd']+$itemLivreF['somme_livre_f']+$itemLivreA['somme_livre_a']+
$itemLivreFamille['somme_livre_famille']+$itemPHOTO['somme_photo']+$itemMALA['somme_mala']+$itemDIVERS['somme_divers'];

$fmt_methode_1 = new NumberFormatter( 'en_CA', NumberFormatter::CURRENCY );
$Methode_1=$fmt_methode_1->formatCurrency($methode_1, "CAD");
?>

<!DOCTYPE html>
<html lang="fr">
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<title>Inventaire Annuel - Système Librairie</title>
    <!-- Utilisation de URL_ROOT pour les CSS -->
	<link rel="stylesheet" href="<?= URL_ROOT; ?>/css/cmsy/global.css">
	<style>
		.container-grille {
			max-width: 800px;
			margin: 20px auto;
		}
		.grid-container-content {
			display: grid;
			grid-template-columns: 1fr 1fr;
			grid-gap: 1px;
			background-color: #7b1c8d;
			border: 2px solid #7b1c8d;
			border-radius: 8px;
			overflow: hidden;
		}
		.grid-container-content > div {
			background-color: white;
			padding: 10px 15px;
			font-size: 16px;
			display: flex;
			align-items: center;
		}
		.grid-container-content > div:nth-child(even) { justify-content: flex-end; }
		.bold { font-weight: bold; background-color: #fdf7ff !important; }
		.total-row { font-weight: bold; font-size: 1.1em; background-color: #f0e6f5 !important; }
	</style>
</head>
<body>

    <?php require_once dirname(__DIR__) . '/include/banniere_universelle.php'; ?>

    <div class="container container-grille">
		<h1 style="text-align: center; color: #7b1c8d;">Inventaire de la librairie (2025)</h1>

		<div class="grid-container-content shadow">
			<div class="bold" style="justify-content: center;">Catégorie</div>
            <div class="bold" style="justify-content: center;">Montant</div>		
			
			<div>Livre Français</div>	<div><?= $total_livre_f; ?></div>
			<div>Livre Famille</div>	<div><?= $total_livre_famille; ?></div>
			<div>Livre Anglais</div>	<div><?= $total_livre_a; ?></div>
			<div>CD</div>				<div><?= $total_cd; ?></div>
			<div>DVD</div>				<div><?= $total_dvd; ?></div>
			<div>Photo</div>			<div><?= $total_photo; ?></div>
			<div>Mala</div>				<div><?= $total_mala; ?></div>
			<div>Divers</div>			<div><?= $total_divers; ?></div>
			
			<div class="total-row">Total Calculé (Catégories)</div>			
            <div class="total-row"><?= $Methode_1; ?></div>
		</div>

		<div class="no_print" style="margin-top: 30px; text-align: center;">
			<h3>Validation Croisée (Méthode 2)</h3>
			<p>Total brut en base de données : <strong><?= $Methode_2 ?></strong></p>
		</div>
    </div>

    <?php require_once dirname(__DIR__) . '/footer_universel.php'; ?>