<?php
$ADMIN_PASS = "Dantell729!";
$INTERAC_EMAIL = "paiement@cashockey.cash";
$db = new PDO('sqlite:' . __DIR__ . '/boutique_serveur.sqlite');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);$up = __DIR__ . '/uploads_cartes/';
if (!is_dir($up)) @mkdir($up, 0755, true);$db->exec("CREATE TABLE IF NOT EXISTS cartes (id INTEGER PRIMARY KEY AUTOINCREMENT, titre TEXT, prix REAL, poste REAL, recto TEXT, verso TEXT, statut TEXT, cree_le TEXT)");
$db->exec("CREATE TABLE IF NOT EXISTS commandes (id INTEGER PRIMARY KEY AUTOINCREMENT, carte_id INTEGER, carte_titre TEXT, total REAL, nom_client TEXT, courriel TEXT, adresse_postale TEXT, statut TEXT, date_cmd TEXT)");
$db->exec("CREATE TABLE IF NOT EXISTS membres (id INTEGER PRIMARY KEY AUTOINCREMENT, nom_client TEXT, numero_carte_lnh TEXT UNIQUE, date_activation TEXT)");
session_start(); $msg = ""; $err = ""; $act =$_POST['action'] ?? '';
if ($act === 'admin_login') { if (($_POST['pass'] ?? '') ===$ADMIN_PASS) $_SESSION['is_admin'] = true; else$err = "Mot de passe invalide."; }
if (isset($_GET['logout'])) { unset($_SESSION['is_admin'], $_SESSION['membre_nom'],$_SESSION['membre_num']); header("Location: boutique.php"); exit; }
if ($act === 'ajouter_carte' && !empty($_SESSION['is_admin'])) {
    $t = trim($_POST['titre'] ?? ''); $p = floatval($_POST['prix'] ?? 0); $po = floatval($_POST['poste'] ?? 0);
    if ($t && $p > 0 && !empty($_FILES['recto']['tmp_name']) && !empty($_FILES['verso']['tmp_name'])) {$ts = time() . "_" . rand(100,999); $nr = "r_$ts.jpg"; $nv = "v_$ts.jpg";
        if (move_uploaded_file($_FILES['recto']['tmp_name'],$up.$nr) && move_uploaded_file($_FILES['verso']['tmp_name'], $up.$nv)) {
            $db->prepare("INSERT INTO cartes (titre,prix,poste,recto,verso,statut,cree_le) VALUES (?,?,?,?,?,'DISPONIBLE',?)")->execute([$t,$p,$po,"uploads_cartes/$nr","uploads_cartes/$nv",date('Y-m-d H:i')]);
            $msg = "Carte publiée sur le serveur (recto/verso).";
        } else $err = "Erreur upload serveur.";
    } else $err = "Titre, prix et 2 photos requis.";
}
if ($act === 'ajouter_membre' && !empty($_SESSION['is_admin'])) {
    $nm = trim($_POST['nom_membre'] ?? ''); $nc = strtoupper(trim($_POST['numero_carte'] ?? ''));
    if ($nm &&$nc) { try { $db->prepare("INSERT INTO membres (nom_client,numero_carte_lnh,date_activation) VALUES (?,?,?)")->execute([$nm,$nc,date('Y-m-d')]);$msg = "Membre activé : $nm (#$nc)."; } catch (Exception $e) {$err = "Numéro déjà utilisé."; } }
}
if ($act === 'expedier_cmd' && !empty($_SESSION['is_admin'])) {$db->prepare("UPDATE commandes SET statut='EXPEDIEE_POSTE' WHERE id=?")->execute([intval($_POST['cmd_id']??0)]);$msg = "Commande marquée postée."; }
if ($act === 'membre_login') {
    $st =$db->prepare("SELECT * FROM membres WHERE LOWER(nom_client)=LOWER(?) AND UPPER(numero_carte_lnh)=UPPER(?)");
    $st->execute([trim($_POST['nom_client']??''), trim($_POST['numero_carte_lnh']??'')]);
    if ($m = $st->fetch(PDO::FETCH_ASSOC)) {$_SESSION['membre_nom']=$m['nom_client'];$_SESSION['membre_num']=$m['numero_carte_lnh'];$msg="Membre connecté : ".$m['nom_client']; }
    else $err = "Nom ou numéro de carte LNH invalide.";
}
if ($act === 'commander_carte') {
    $cid = intval($_POST['carte_id']??0); $nom = trim($_POST['nom_client']??''); $mail = trim($_POST['courriel']??''); $adr = trim($_POST['adresse_postale']??'');
    $st =$db->prepare("SELECT * FROM cartes WHERE id=? AND statut='DISPONIBLE'"); $st->execute([$cid]);
    if (($c = $st->fetch(PDO::FETCH_ASSOC)) &&$nom && $mail &&$adr) {
        $tot =$c['prix'] + $c['poste'];$db->prepare("INSERT INTO commandes (carte_id,carte_titre,total,nom_client,courriel,adresse_postale,statut,date_cmd) VALUES (?,?,?,?,?,?,'EN_ATTENTE_INTERAC',?)")->execute([$cid,$c['titre'],$tot,$nom,$mail,$adr,date('Y-m-d H:i')]);
        $num =$db->lastInsertId(); $db->prepare("UPDATE cartes SET statut='RESERVEE' WHERE id=?")->execute([$cid]);
        $msg = "Commande #$num confirmée ! Déposez ".number_format($tot,2)." $ par Interac à $INTERAC_EMAIL (Réf: CMD-$num). Envoi postal à : $adr";
    } else $err = "Nom, courriel et adresse postale requis.";
}
$cartes =$db->query("SELECT * FROM cartes ORDER BY id DESC")->fetchAll(PDO::FETCH_ASSOC);
?>
<!DOCTYPE html><html lang="fr"><head><meta charset="UTF-8"><meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>CASHOCKEY — Volet 2 : Boutique Cartes LNH</title>
<style>body{background:#060b14;color:#f1f5f9;font-family:sans-serif;margin:0;padding:16px}.wrap{max-width:920px;margin:auto}.nav{display:flex;gap:10px;margin-bottom:16px}.nav a{flex:1;text-align:center;padding:12px;border-radius:10px;font-weight:800;text-decoration:none}.box{background:#0f172a;border:1px solid #1e293b;border-radius:12px;padding:15px;margin-bottom:15px}.grid{display:grid;grid-template-columns:repeat(auto-fill,minmax(270px,1fr));gap:14px}.item{background:#0b1220;border:1px solid #334155;border-radius:12px;padding:12px;text-align:center}.photos{display:flex;gap:6px;margin-bottom:8px}.photos img{width:49%;height:165px;object-fit:cover;border-radius:8px}.btn{display:block;width:100%;background:#10b981;color:#041019;font-weight:800;padding:11px;border:none;border-radius:8px;cursor:pointer;margin-top:8px}input,textarea{width:100%;box-sizing:border-box;background:#060b14;color:#fff;border:1px solid #334155;border-radius:8px;padding:9px;margin:5px 0 9px}.ok{background:#064e3b;border:1px solid #10b981;padding:11px;border-radius:8px;margin-bottom:12px}.err{background:#7f1d1d;border:1px solid #ef4444;padding:11px;border-radius:8px;margin-bottom:12px}</style></head>
<body><div class="wrap">
<div class="nav"><a href="index.html" style="background:#0f172a;color:#38bdf8;border:1px solid #38bdf8;">VOLET 1 : LE CUBE</a><a href="boutique.php" style="background:#10b981;color:#041019;">VOLET 2 : BOUTIQUE CARTES LNH</a></div>
<h1 style="text-align:center;">BOUTIQUE DE CARTES LNH</h1>
<?php if($msg):?><div class="ok"><?=$msg?></div><?php endif; if($err):?><div class="err"><?=$err?></div><?php endif;?>
<div class="box"><h3 style="margin-top:0;color:#facc15;">Connexion Membre (Carte LNH reçue par la poste)</h3>
<?php if(!empty($_SESSION['membre_nom'])):?><strong><?=htmlspecialchars($_SESSION['membre_nom'])?> · Carte #<?=htmlspecialchars($_SESSION['membre_num'])?></strong> <a href="?logout=1" style="color:#94a3b8;">Quitter</a>
<?php else:?><form method="post"><input type="hidden" name="action" value="membre_login"><input type="text" name="nom_client" placeholder="Nom du client" required><input type="text" name="numero_carte_lnh" placeholder="Numéro derrière la carte LNH" required><button type="submit" style="background:#facc15;color:#041019;font-weight:800;padding:10px;border:none;border-radius:8px;">Valider ma carte</button></form><?php endif;?></div>
<h2>Cartes en vente (Recto / Verso)</h2>
<?php if(empty($cartes)):?><div class="box" style="text-align:center;color:#94a3b8;">Aucune carte publiée.</div>
<?php else:?><div class="grid"><?php foreach($cartes as $c):?><div class="item"><div class="photos"><img src="<?=htmlspecialchars($c['recto'])?>"><img src="<?=htmlspecialchars($c['verso'])?>"></div><strong><?=htmlspecialchars($c['titre'])?></strong><br><small>Poste : <?=number_format($c['poste'],2)?> $</small>
<?php if($c['statut']==='DISPONIBLE'):?><button class="btn" onclick="ouvrirAchat(<?=$c['id']?>,'<?=htmlspecialchars(addslashes($c['titre']))?>',<?=$c['prix']+$c['poste']?>)">Acheter — <?=number_format($c['prix'],2)?> $</button>
<?php else:?><div style="background:#334155;padding:9px;border-radius:8px;margin-top:8px;">Réservée / Vendue</div><?php endif;?></div><?php endforeach;?></div><?php endif;?>
<div id="bloc-achat" class="box" style="display:none;border-color:#10b981;margin-top:16px;"><h3 style="margin-top:0;color:#10b981;">Adresse postale & Dépôt Interac</h3><p id="resume-achat" style="font-weight:700;"></p>
<form method="post"><input type="hidden" name="action" value="commander_carte"><input type="hidden" name="carte_id" id="achat-id"><input type="text" name="nom_client" value="<?=htmlspecialchars($_SESSION['membre_nom']??'')?>" placeholder="Nom complet *" required><input type="email" name="courriel" placeholder="Courriel *" required><textarea name="adresse_postale" rows="3" placeholder="Adresse postale complète *" required></textarea><button type="submit" class="btn">Confirmer & Obtenir infos Interac</button></form></div>
<div class="box" style="margin-top:20px;border-color:#38bdf8;"><h3 style="margin-top:0;color:#38bdf8;">Scanner & Gestion Serveur (Admin)</h3>
<?php if(empty($_SESSION['is_admin'])):?><form method="post"><input type="hidden" name="action" value="admin_login"><input type="password" name="pass" placeholder="Mot de passe Admin" required><button type="submit" style="background:#38bdf8;color:#041019;font-weight:800;padding:10px;border:none;border-radius:8px;">Ouvrir Scanner</button></form>
<?php else:?><h4>1. Scanner une carte (Recto + Verso)</h4><form method="post" enctype="multipart/form-data"><input type="hidden" name="action" value="ajouter_carte"><input type="text" name="titre" placeholder="Titre de la carte" required><input type="number" step="0.01" name="prix" placeholder="Prix ($)" required><input type="number" step="0.01" name="poste" value="3.00"><label>RECTO :</label><input type="file" name="recto" accept="image/*" capture="environment" required><label>VERSO :</label><input type="file" name="verso" accept="image/*" capture="environment" required><button type="submit" class="btn">Publier la carte</button></form>
<h4>2. Associer carte de membre LNH</h4><form method="post"><input type="hidden" name="action" value="ajouter_membre"><input type="text" name="nom_membre" placeholder="Nom du client" required><input type="text" name="numero_carte" placeholder="Numéro derrière carte LNH" required><button type="submit" style="background:#facc15;color:#041019;font-weight:800;padding:10px;border:none;border-radius:8px;">Activer membre</button></form>
<h4>3. Commandes & Adresses</h4><?php foreach($db->query("SELECT * FROM commandes ORDER BY id DESC") as $cm):?><div style="background:#060b14;border:1px solid #334155;padding:9px;border-radius:8px;margin-bottom:8px;"><strong>#<?=$cm['id']?> <?=htmlspecialchars($cm['carte_titre'])?> (<?=number_format($cm['total'],2)?> $)</strong><br><?=$cm['nom_client']?> · <?=$cm['courriel']?><br><em><?=nl2br(htmlspecialchars($cm['adresse_postale']))?></em><br>Statut : <strong><?=$cm['statut']?></strong><?php if($cm['statut']!=='EXPEDIEE_POSTE'):?> <form method="post" style="display:inline;"><input type="hidden" name="action" value="expedier_cmd"><input type="hidden" name="cmd_id" value="<?=$cm['id']?>"><button type="submit">Postée</button></form><?php endif;?></div><?php endforeach;?><?php endif;?></div>
</div><script>function ouvrirAchat(id,t,tot){document.getElementById('bloc-achat').style.display='block';document.getElementById('achat-id').value=id;document.getElementById('resume-achat').innerText=t+' — Total : '+tot.toFixed(2)+' $';document.getElementById('bloc-achat').scrollIntoView({behavior:'smooth'});}</script></body></html>
