<th><a href="?">Rang</a></th> <th>Publié</th> <th>Modif</th> <th title="suppr"> Suppr </th> </tr> <?php $i = 0; while ($article = mysql_fetch_array($r_article)) { ?> <tr> <td><a href="?a=5&id=<?php echo $article['id'] ?>"><?php echo $article['id'] ?></a></td> <td height><?php echo stripslashes($article['nom']) ?></td> <td align="center"><?php echo $article['loginreda'] ?></td> <td align="center"><?php echo $article['loginlecteur'] ?></td> <td align="center"><?php echo $article['nomcat'] ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($article['date'])) ?></td> <td align="center"><?php echo CHtmlSession::get_rang('article', $article['id'], $article['idreda']) ?></td> <td align="center"><?php echo CHtmlSession::get_etat($article['id'], $article['etat'], $article['idreda']) ?></td> <td align="center"><?php echo CHtmlSession::get_editbutton($article['id'], $article['idreda']) ?></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $article['id'], $id, $article['idreda']) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?>
<?php $i = 0; while ($opportunite = mysql_fetch_array($r_opportunite)) { $xzsql = "SELECT nom from texte where id=".$opportunite['texId']; //print_r($xzsql); $text = CBdd::select_one($xzsql,'nom'); $xzsql = "SELECT piece from hbpiecesjointes where id=".$opportunite['pieId']; //print_r($xzsql); $piece= CBdd::select_one($xzsql,'piece'); ?> <tr> <td><a href="?a=5&id=<?=$opportunite['id'] ?>"><?=$opportunite['id'] ?></a></td> <td><?=utf8_encode ($opportunite['nom']); ?></td> <td><?=$text ; ?></td> <td><?=str_replace('../../userfiles/pieces_jointes/', '',$piece); ?></td> <td align="center"><?=CDate::date_switch(CDate::formate_date($opportunite['date'])) ?></td> <td align="center"><?=CHtml::get_etat($opportunite['id'], $opportunite['etat'], $opportunite['id']); ?></td> <td align="center"><?=CHtmlSession::get_editbutton($opportunite['id'], $opportunite['id']) ?></td> <td align="center"><?=CHtml::get_delbutton($a, $opportunite['id'], $id, $opportunite['id']) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?> <form id="form_ajout" method="post" action="opportunite.php">
$nomSec=CBdd::select_one($sql_nomSec, 'nom_sec'); ?> <div class="bulle"> <?php echo utf8_encode($nomSec); ?> </div> </td> <td class="zinfo"> <?php echo $user['categorie_ent']; $sql_nomCat='select nom_cat FROM cat WHERE id_cat='.$user['categorie_ent']; $nomCat=CBdd::select_one($sql_nomCat, 'nom_cat'); ?> <div class="bulle"> <?php echo utf8_encode($nomCat); ?> </div> </td> <td align="center"><?php if ($user['dateajout_ent'] != "00-00-0000") echo CDate::date_switch($user['dateajout_ent']) ?></td> <td align="center"><?php echo CHtmlUser::get_etat_contact($user['id_ent'], $user['etat_contact'], 0) ?></td> <td style="text-align: center;"> <?php echo $opp_num[$user['idopportunite']]; ?> </td> <td align="center"><a href="contact.php?a=5&id=<?php echo $user['id_ent'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $user['id_ent'], $id, $user['id_ent']) ?></td> <td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></a></td> <td align="center"><?php if(CBdd::select_one("SELECT count(id) AS nb_reponse FROM reponse WHERE iduser = "******"../src/reponse.php?id=<?php echo $user['id_ent'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a> <?php } ?></td> <td><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id_ent'] ?>"/></td>
function forceGetOrPost ($_zVarName, $_zDefault = '') { if (isset ($_GET[$_zVarName])) { return $_GET[$_zVarName]; } elseif (isset ($_POST[$_zVarName])) { return $_POST[$_zVarName]; } else { CSession::get($_zVarName, $_zDefault); } } $id_groupe = isset($id_groupe) ? $id_groupe : CFunctions::getUserParam($id_groupe, 0) ; $filtre_etat_contact = forceGetOrPost('filtre_etat_contact', $etat_contact); $filtre_date_debut = CDate::date_switch(forceGetOrPost ('filtre_date_debut')); $filtre_date_fin = CDate::date_switch(forceGetOrPost ('filtre_date_fin')); $filtre_id_groupe = forceGetOrPost ('filtre_id_groupe', $id_groupe); $filtre_email = forceGetOrPost ('filtre_email', -1); $filtre_nom = forceGetOrPost ('filtre_nom', '%%'); $filtre_prenom = forceGetOrPost ('filtre_prenom', '%%'); $filtre_societe = forceGetOrPost ('filtre_societe', '%%'); if (isset($_GET['alphaA'])) $_SESSION['alphaA'] = $_GET['alphaA']; $filtre_idopportunite = forceGetOrPost ('filtre_idopportunite', array(0)); if (empty ($filtre_idopportunite)) { $filtre_idopportunite = array (0); } ?> <script type="text/javascript"> $(function () { $('body').css ({'margin-top': '-14px'}); $('#filtre_email').val ('<?=$filtre_email ;?>');
while ($listeCom = mysql_fetch_assoc($requetCcom)) { //----------- Owen recuperation nom pays pour commune $sqlNomCat = "select pays FROM departement WHERE id_dep='".$listeCom['departement']."'"; $id_pays = CBdd::select_one($sqlNomCat, 'pays'); $Zsql = "SELECT nom FROM pays WHERE id_pays=".$id_pays; $nom_pays = CBdd::select_one($Zsql, 'nom'); ?> <tr> <td><a href="?a=5&id=<?php echo $listeCom['id_com'] ?>"><?php echo $listeCom['id_com'] ?></a></td> <td><?php echo utf8_encode($listeCom['nom_com']) ?></td> <td><?php echo $listeCom['CP'] ?></td> <td><?php echo $nom_pays ?></td> <td><?php echo $listeCom['urlCommune'] ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($listeCom['date_com'])) ?></td> <td align="center"><a href="commune.php?a=5&id=<?php echo $listeCom['id_com'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $listeCom['id_com'], $id, $listeCom['idreda']) ?></td> <td align="center"><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $listeCom['id_com'] ?>"/></td> </tr> <?php $i++; } ?> </table> <p> <?php echo CForm::get_hidden(7); ?> </p> <p> <input type="hidden" name="id_groupe" value="<?php echo $_SESSION['id_groupe']; ?>"/> </p> </form>
</tr> <?php $i = 0; foreach (CUserFile::sort($arr_urlrep) as $urlrep) { $info_file = CUserFile::get_info_file($urlrep); $file_name = $info_file['name']; $file_mtime= $info_file['mtime']; $file_type = $info_file['type']; $file_url = $info_file['url']; $file_base = $info_file['base']; $actif_btn = CTableUser::is_admin($_SESSION['idmbr'])?1:0; ?> <tr> <td><a href="fichier.php?a=66&url_base_fils=<?php echo $file_url ?>&url_base=<?php echo $file_base ?>"><?php echo $file_name ?></a></td> <td align="center"><?php echo $file_url ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($file_mtime)) ?></td> <td align="center"><?php echo CHtml::get_editbutton($urlrep, $actif_btn) ?></td> <td align="center"><?php echo CHtml::get_delbutton($a, $urlrep, $id, $actif_btn) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?> <form id="form_ajout" method="post" action="dossier.php"> <p> <?php echo CForm::get_hidden(44) ?> </p> <fieldset>
<?php for($c = 0; $c < 194; $c++) echo " ";?> <input type="submit" value="Supprimer" /> </p> <table style="width: 875px; margin-left: 1px;" border="1" cellpadding="0" cellspacing="0"> <tr align="center"> <th align="left" width="40px"><a href="?order=id">Id</a></th> <th align="left"><a href="?order=nom">Fichier</a></th> <th width="80px">Date d'ajout</th> <th title="suppr" width="40px"> Suppr </th> <th width="80px">Checkbox</th> </tr> <?php foreach($oFics as $ik=>$fics){?> <tr> <td><?php echo $fics['tmp_id'];?></td> <td><?php echo CTableMoulListe::get_nom_by_id($fics['tmp_fic']);?></td> <td><?php echo CDate::date_switch(CDate::formate_date($fics['tmp_date']));?></td> <td><a href='?a=555&idtmp=<?php echo $fics['tmp_id'];?>' title='suppr'><img src='../img/delete.png' alt='delete' /></a></td> <td><input class="caseacocher" name="tab_fic[<?php echo $ik ?>]" type="checkbox" id="tab_fic[<?php echo $fics['tmp_id'] ?>]" value="<?php echo $fics['tmp_id'];?>" /></td> <input type="hidden" name="igp" value="<?php echo $fics['tmp_grp'];?>" /> </tr> <?php }?> </table> </form> <?php }?> <!-- InstanceEndEditable --> </div> </div> <hr class="clearfloat" /> </div> </div> </body>
<th align="left"><a href="?order=nom">Fichier</a></th> <th align="left" width="100px"><a href="?order=mtp_zDateCreation">Date de création</a></th> <th width="80px">Emails initiale</th> <th width="80px">Email Valide</th> <th width="40px">Suppr</th> </tr> <?php foreach($oDatas as $ikey=>$datas){ $iNbml = CTableMoultmp::get_iEmail($datas['mtp_iListId']); $zDate = CTableMoultmp::select_date($datas['mtp_iListId']); $iNbmlVl = CTableMoulGp::get_iEmail($datas['mtp_iListId']); $zFichier = CTableMoulListe::get_nom_by_id($datas['mtp_iListId']); ?> <tr> <td><?php echo$ikey+1;?></td> <td><?php echo $zFichier ;?></td> <td><?php echo CDate::date_switch(CDate::formate_date($zDate));?></td> <td><?php echo $iNbml;?></td> <td><?php echo $iNbmlVl;?></td> <td> <?php if($a == 3 ){ if($datas['mtp_iListId'] == $zFic){?> <a href='?a=33&fic=<?php echo $datas['mtp_iListId'];?>' title='suppr'>ok?</a> <?php } else {?> <a href='?a=3&fic=<?php echo $datas['mtp_iListId'];?>' title='suppr'><img src='../img/delete.png' alt='delete' /></a> <?php } }?> <?php if($a != 3) {?> <a href='?a=3&fic=<?php echo $datas['mtp_iListId'];?>' title='suppr'><img src='../img/delete.png' alt='delete' /></a> <?php }?> </td>
<?php include("../inc/init.php"); if(!empty($_GET['message_number'])) $message_number = $_GET['message_number']; if(!empty($_GET['passe'])) $passe = $_GET['passe']; $imap = new CImap(CTableConfiguration::get_value_by_element('POP_SERVER'), CTableUser::get_email_admin(), $passe); if(@$imap->connect()) { $info = @$imap->get_info($message_number); $email_id = $imap->load($message_number); echo "Sauvegarde du message " . $message_number; ?> <script type="text/javascript"> $('first').insert({after:'<tr><td><a href="show_reception.php?id=<?php echo $email_id ?>" target="popup" onclick="popup(this.href, this.target, 800, 600);"><?php echo $email_id ?></a></td><td><?php echo CTableGroupe::get_href($info['from']) ?></td><td><?php echo utf8_encode($info['subject']) ?></td><td><?php echo CDate::date_switch(CDate::formate_date($info['date'])) ?></td><td align="center" class="info etat <?php echo 'etat_0'?>"><div class="bulle"><img src="../img/publish_x.png" alt="Non lu" /> Non lu<br /><a href="reception.php?a=2&id=<?php echo $email_id ?>&etat=1"><img src="../img/publish_g.png" alt="Lu" /> Lu</a><br /><a href="reception.php?a=2&id=<?php echo $email_id ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a></div></td></tr>'}); </script> <?php } else { echo "Echec de chargement du message " . $message_number; } ?> <a href="show_reception.php?id=<?php echo stripslashes($email['id']) ?>" target="popup" onclick="popup(this.href, this.target, '800', '600');"> <?php echo $email['id'] ?> </a>
CSession::init(); $etat_contact = isset($etat_contact) ? $etat_contact : CFunctions::getUserParam('etat_contact', 0) ; $id_groupe = isset($id_groupe) ? $id_groupe : CFunctions::getUserParam('id_groupe', 0) ; $filtre_date_debut = isset($filtre_date_debut) ? $filtre_date_debut : CFunctions::getUserParam('filtre_date_debut', '') ; $filtre_date_fin = isset($filtre_date_fin) ? $filtre_date_fin : CFunctions::getUserParam('filtre_date_fin', '') ; $filtre_email = isset($filtre_email) ? $filtre_email : CFunctions::getUserParam('filtre_email', -1) ; $filtre_nom = isset($filtre_nom) ? $filtre_nom : CFunctions::getUserParam('filtre_nom', '%%') ; $filtre_prenom = isset($filtre_prenom) ? $filtre_prenom : CFunctions::getUserParam('filtre_prenom', '%%') ; $filtre_idopportunite = isset($filtre_idopportunite) ? $filtre_idopportunite : CFunctions::getUserParam('filtre_idopportunite', array(0)) ; $filtre_etat_contact = CSession::get('filtre_etat_contact', $etat_contact); $filtre_id_groupe = CSession::get('filtre_id_groupe', $id_groupe); $filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut', $filtre_date_debut)); $filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin', $filtre_date_fin)); $filtre_email = CSession::get('filtre_email', $filtre_email); $filtre_nom = CSession::get('filtre_nom', $filtre_nom); $filtre_prenom = CSession::get('filtre_prenom', $filtre_prenom); $filtre_idopportunite = CSession::get('filtre_idopportunite', $filtre_idopportunite); $filtre = array(); switch ($filtre_id_groupe) { case '0': $liste_user_all_groupe = '(' . trim (implode (',', CTableGrGroupe::get_array_id_user_all_groupe ()), ',') . ')'; $listeGroupe__ = str_replace (array ('(,', ',)', ',,'), array ('(', ')', ''), ($liste_user_all_groupe)); $Test = str_replace (array ('(', ',', ')'), array ('', '', ''), $listeGroupe__); if ($Test) { $filtre_groupe = " AND id NOT IN " . $listeGroupe__;
$i = 0; while ($listeCat = mysql_fetch_array($requetCat)) { //----------- Owen recuperation nom secteur pour categorie $sqlNomCat='select nom_sec FROM secteur WHERE id_sec='.$listeCat['cat_motcle']; $secteur=CBdd::select_one($sqlNomCat, 'nom_sec'); // SELECTION CATEGORIE $zsql = "SELECT nom_cat FROM cat where id_cat=".$listeCat['cat_motcle']; $nomCat = CBdd::select_one($zsql, 'nom_cat'); ?> <tr> <td><a href="?a=5&id=<?php echo $listeCat['id_mocle'] ?>"><?php echo $listeCat['id_motcle'] ?></a></td> <td><?php echo $listeCat['nom_motcle'] ?></td> <td><?php echo $nomCat ?></td> <td align="center"><?php echo CDate::date_switch(CDate::formate_date($listeCat['date_motcle'])) ?></td> <td align="center"><?php echo CHtmlSession::get_editbutton($listeCat['id_motcle'], $listeCat['idreda']) ?></td> <td align="center"><?php echo CHtmlSession::get_delbutton($a, $listeCat['id_motcle'], $id, $listeCat['idreda']) ?></td> </tr> <?php } ?> </table> <?php } ?> <?php //---------------------------------------------------------------------------------------------- // AJOUT //---------------------------------------------------------------------------------------------- ?> <?php if($a == 4) { ?> <form id="form_ajout" method="post" action="motcle.php" enctype="multipart/form-data"> <p> <?php echo CForm::get_hidden(44) ?> </p>
<tr align="center"> <th align="left">Url du fichier</th> <th>Fréquence changement</th> <th>Priorité d'exploration</th> <th>Derniere modification</th> </tr> <?php $xml = simplexml_load_file($url); foreach($xml->url as $url) { $loc = strtolower(utf8_decode($url->loc)); $lastmod = strtolower(utf8_decode($url->lastmod)); $changefreq = utf8_decode($url->changefreq); $priority = utf8_decode($url->priority);?> <tr> <td><?php echo $loc ?></td> <td><?php echo $changefreq ?></td> <td><?php echo $priority ?></td> <td><?php echo CDate::date_switch($lastmod) ?></td> </tr> <?php } ?> </table> <?php } ?> <!-- InstanceEndEditable --></div> </div> <hr class="clearfloat" /> </div> </div> </body> <!-- InstanceEnd --></html>
<th>Modif</th> <th>Suppr</th> </tr> <?php $i = 0; if($r_galerie) { while ($galerie = mysql_fetch_array($r_galerie)) { $page = CBdd::select_one("SELECT nom FROM page WHERE id = ".$galerie['idpage'], "nom"); $article = CBdd::select_one("SELECT nom FROM article WHERE id = (SELECT idart FROM page WHERE id = ".$galerie['idpage'].")", "nom"); $categorie = CBdd::select_one("SELECT nomcat FROM article_cat WHERE id = (SELECT idart FROM page WHERE id = ".$galerie['idpage'].")", "nomcat"); $nb_image = CBdd::select_one("SELECT COUNT(id) as nb FROM image WHERE idgal = ".$galerie['id'], "nb"); ?> <tr> <td> <?php echo $galerie['id'] ?> </td> <td><?php echo CDate::date_switch(CDate::formate_date($galerie['date'])) ?></td> <td align="center"><?php echo CFunction::clean(stripslashes($galerie['nom'])); ?></td> <td align="center"><?php echo $categorie; ?></td> <td align="center"><?php echo $article; ?></td> <td align="center"><?php echo $page; ?></td> <td style="text-align: center;"><?php echo $nb_image; ?></td> <td style="text-align: center;"><?php echo CHtmlSession::get_etat($galerie['id'], $galerie['etat_diaporama'], $galerie['idreda'], 7) ?></td> <td style="text-align: center;"><?php echo CHtmlSession::get_rang('galerie', $galerie['id'], $galerie['idreda']) ?></td> <td style="text-align: center;"><?php echo CHtmlSession::get_etat($galerie['id'], $galerie['etat'], $galerie['idreda']) ?></td> <td style="text-align: center;"><?php echo CHtmlSession::get_editbutton($galerie['id'], $galerie['idreda']) ?></td> <td style="text-align: center;"><?php echo CHtmlSession::get_delbutton($a, $galerie['id'], $id, $galerie['idreda']) ?></td> </tr> <?php } } ?> </table>
} </style> </head> <body> <?php $sql = "SELECT * FROM user WHERE id=" . $id; $user = CBdd::select_row($sql); ?> <h1>Réponse de : <?php echo CFunction::clean($user['nom']) . " " . CFunction::clean($user['prenom']) . " - Tel : " . $user['telephone'] ?></h1> <?php $sql = "SELECT * FROM reponse WHERE iduser = "******" AND date = (SELECT max(date) FROM reponse WHERE iduser = "******") ORDER BY id ASC"; $res = CBdd::select($sql); $date = ""; ?> <ol> <?php while($reponse = mysql_fetch_array($res)) { $date = $reponse['date']; ?> <li> <p><?php echo CFunction::clean( CFunction::force_stripslashes($reponse["question"])) ?></p> <p>=> <?php echo CFunction::clean( CFunction::force_stripslashes($reponse["nom"])) ?></p> </li> <?php } ?> </ol> <hr /> <p>Réponses réalisées le : <?php echo CDate::date_switch(CDate::formate_date($date)) ?></p> </body> </html>
?> </td> <td><?php echo utf8_encode(stripslashes($email['exp_prenom'])); ?></td> <td><?php echo utf8_encode(stripslashes($email['exp_societe'])); ?></td> <td> <?php if($groupe) { echo $groupe['nom']; } else { echo ' '; } ?> </td> <td><?php echo utf8_encode(stripslashes($email['nom'])) ?></td> <td><?php echo CDate::date_switch(CDate::formate_date($email['date'])) ?></td> <td align="center" class="info etat <?php echo 'etat_' . $email['etat']?>"><div class="bulle"> <?php if($email['etat'] != 0) { ?> <a href="reception.php?a=2&id=<?php echo $email['id'] ?>&etat=0"><img src="../img/publish_x.png" alt="Non lu" />Non lu</a> <?php } else { ?> <img src="../img/publish_x.png" alt="Non envoyé" /> Non lu <?php } ?> <br /> <?php if($email['etat'] != 1) { ?> <a href="reception.php?a=2&id=<?php echo $email['id'] ?>&etat=1"><img src="../img/publish_g.png" alt="Lu" /> Lu</a> <?php } else { ?> <img src="../img/publish_g.png" alt="Envoyé" /> Lu <?php } ?> <br /> <?php if($email['etat'] != 2) { ?> <a href="reception.php?a=2&id=<?php echo $email['id'] ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a>
<tr style="height: 20px;"> <td colspan="5"> </td> </tr> <!-- FILTRE PERIODE --> <table style="height: 45px;"> <tr style="height: 25px;"> <td class="col1">Période</td> <td style="width: 800px;"> <div> <p> <label>Du</label> <input type="text" id="filtre_date_debut" name="filtre_date_debut" value="<?php echo CDate::date_switch(CDate::formate_date($filtre_date_debut)); ?>" onmousedown="javascript:openDate(this);"/> </p> <p> <label>Au</label> <input type="text" id="filtre_date_fin" name="filtre_date_fin" value="<?php echo CDate::date_switch(CDate::formate_date($filtre_date_debut)); ?>" onmousedown="javascript:openDate(this);"/> </p> </div> </td> </tr> </table> </div> </form> </div> </div> </div> </div> </body> </html>