<?php
	// ---------------------------------------------------
	// Chargement paramettres generaux
	// ---------------------------------------------------
	if (!isset($refresh)) $refresh='N';
	if (!isset($admMsg)) $admMsg=' ';
	if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['refresh' => $refresh],  '02-init.variableGene.php');}

	if (empty($_SESSION['nom_facture']) || empty($_SESSION['paramGene']) || ($refresh=='Oui') ) {
		$i=0;
		if (empty($lg)) {$lg='FRA';}
		$reqSelect="SELECT id, description, " .$lg. " FROM languenav WHERE variable='general' AND afficher=1 order by id;";
		
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['reqSelect' => $reqSelect], '');}
		$resConn=$idPdo->query($reqSelect);
		if ($resConn) {
			while ($tabResult = $resConn->fetch(PDO::FETCH_ASSOC)) {
				$paramGene[$i]=$tabResult[$lg];
				$paramGeneID[$i]=$tabResult['id'];
				$paramGeneDesc[$i]=$tabResult['description'];
				if (isset($debug[10]) && $debug[10] == '1' ) {
					$debugMsg .= monDebug (1,['num' => $i ,'paramGene' => $paramGene[$i],'paramGeneID' => $paramGeneID[$i],'paramGeneDesc' => $paramGeneDesc[$i] ],'');
				}
				$i++;
			}
			$_SESSION['paramGene']= $paramGene;
			$_SESSION['paramGeneID']= $paramGeneID;
			$_SESSION['paramGeneDesc']= $paramGeneDesc;
			if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session re-chargée' => 'Oui'],'');}

			// ---------------------------------------------------
			// Charger en session
			// ---------------------------------------------------
			include ("02-variableGeneConst.php");
		}
		else
		if (isset($debug[9]) && $debug[9] == '1') { $debugMsg .= monDebug(2, ['&#160;Impossible de récupérer les données de la table' => 'languenav'], '');}
	}
	else {
		$paramGene=$_SESSION['paramGene'];
		$paramGeneID=$_SESSION['paramGeneID'];
		$paramGeneDesc=$_SESSION['paramGeneDesc'];
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session déjà chargée' => 'Oui'],'');}
	}

?>