<?php
	// Pour l'ecran contenu/textes on a un autre fichier qui tri par description car plus cohérent pour afficher dans l'ordre les messages.
	//  Il faudrait homogénéiser, cela implique de reprendre tous les N° id pour chaque envoi mail.
	// Pour le moment, on force unb refresh et detruire tableaux existants
	
	$refreshTmp=$refresh;
	$refresh='Oui';
	// dans contenu ==> $_SESSION['refreshMail']='N';
	if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['refresh tjrs oui' => $refresh],  '14-init.mailMsgList.php');	}
	if ( $_SESSION['refreshMail'] !='Oui' || empty($_SESSION['mailMsg']) || empty($_SESSION['mailImgPt']) || ($refresh=='Oui')) {
		$_SESSION['refreshMail']='Oui';
		$i=0;
		$mailMsg=array();
		$mailDesc=array();
		$mailAfficher=array();
		$mailTitle=array();
		$mailLien=array();
		$mailAlt=array();
		$mailImgPt=array();
		$mailClasse=array();
		$mailLien=array();
		$mailStyle=array();

		
		//flitrer que sur une langue
		$sqlCols = "SELECT GROUP_CONCAT(COLUMN_NAME)   FROM INFORMATION_SCHEMA.COLUMNS    WHERE TABLE_SCHEMA = '" .$_SESSION['bdd']. "' AND TABLE_NAME = 'languenav'  AND COLUMN_NAME LIKE '%".$lg."'";
		$cols = $idPdo->query($sqlCols)->fetchColumn();
		$colsArray = explode(',', $cols);
		// echo 'REQ  = '.$sqlCols;
		$tabResult = dynRequete_select("SELECT", 'languenav', [ 'id' ,'variable', 'description' ,'num' ,'afficher' , 'class' , 'style', 'lien', $cols ], ['variable LIKE' => '%mail%'], 'ORDER BY id', '14-init.mailMsgList.php', 0, 0, 'tabResult'); 

		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1, ['sql' => $sql],  '14-init.mailMsgList.php');	}

		if ($tabResult) {
			foreach ($tabResult as $result) {
				$mailID[$i]=$result['id'];
				// $mailVar[$i]=$result['variable'];
				$mailDesc[$i]=$result['description'];
				$mailAfficher[$i]=$result['afficher'];
				$mailMsg[$i]=$result[$lg];
				$mailTitle[$i]=$result['title' .$lg];
				$mailLien[$i]=$result['lien'];
				$mailAlt[$i]=$result['alt' .$lg];
				$mailImgPt[$i]=$result['imgPt' .$lg];
				$mailLien[$i]=$result['lien'];
				$mailClasse[$i]=$result['class'];
				$mailStyle[$i]=$result['style'];
				if (isset($debug[10]) && $debug[10] == '1' ) { $debugMsg .= monDebug(1, ['mailID-' .$i => $mailID[$i] ], '');}
				$i++;
			}
			$_SESSION['mailID']= $mailID;
			$_SESSION['mailDesc']= $mailDesc;
			$_SESSION['mailAfficher']= $mailAfficher;
			$_SESSION['mailMsg']= $mailMsg;
			$_SESSION['mailTitle']= $mailTitle;
			$_SESSION['mailAlt']= $mailAlt;
			$_SESSION['mailImgPt']= $mailImgPt;
			$_SESSION['mailLien']= $mailLien;
			$_SESSION['mailClasse']= $mailClasse;
			$_SESSION['mailStyle']= $mailStyle;
			$tabResult='';
			if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session re-chargée' => 'Oui'],'');}
		}
		else {
			echo "&#160;Impossible de récupérer les données mails de la table";
		}
	}
	else {
		if (isset($debug[9]) && $debug[9] == '1' ) { $debugMsg .= monDebug (1,['session déjà chargée' => 'Oui'],'');}
		$mailID=$_SESSION['mailID'];
		$mailDesc=$_SESSION['mailDesc'];
		// $mailVar=$_SESSION['mailVar'];
		$mailAfficher=$_SESSION['mailAfficher'];
		$mailMsg=$_SESSION['mailMsg'];
		$mailTitle=$_SESSION['mailTitle'];
		$mailAlt=$_SESSION['mailAlt'];
		$mailImgPt=$_SESSION['mailImgPt'];
		$mailLien=$_SESSION['mailLien'];
		$mailClasse=$_SESSION['mailClasse'];
		$mailStyle=$_SESSION['mailStyle'];
	}

	// ---------------------------------------------------
	// On charge les admin ici
	// ---------------------------------------------------
	if (empty($_SESSION['tableLibAdmin']) || ($refresh=='Oui')) {
		include ($includePath. "/req/15-init.adminMsgList.php");
	}
	$refresh=$refreshTmp;
?>