90 lines
3.7 KiB
PHP
Executable File
90 lines
3.7 KiB
PHP
Executable File
<?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 " 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;
|
|
?>
|