static function is_max($max = null) {
$tuser = new CTableUser();
if($max === null) {
$max = CTableConfiguration::get_value_by_element('USER_MAX_NUMBER');
}
if($max <= 0) {
return false;
}
return ($tuser->get_nb() >= $max);
}
static function get_toolbar($options=array('add'=>'1','cancel'=>'1','send'=>'1')) {
$toolbar = "<ul>";
if(!empty($options['send'])) {
switch($options['send']) {
case 1 :
$toolbar .= "<li><a href='?a=5&expediteur=" . CTableUser::get_email_admin() . "'><img src='../img/quicksend.gif' /> Envoi rapide</a></li>";
break;
case 2 :
$toolbar .= "<li><img src='../img/quicksend.png' class='grise'/> Envoi rapide</li>";
break;
}
}
if(!empty($options['add'])) {
switch($options['add']) {
case 1 :
$toolbar .= "<li><a href='?a=4'><img src='../img/ajouter.gif' />Planifier un envoi groupé</a></li>";
break;
case 2 :
$toolbar .= "<li><img src='../img/ajouter.gif' class='grise'/>Planifier un envoi groupé</li>";
break;
}
}
if(!empty($options['cancel'])) {
switch($options['cancel']) {
case 1 :
$toolbar .= "<li><a href='?a=0'><img src='../img/annuler.gif' />Annuler</a></li>";
break;
case 2 :
$toolbar .= "<li><img src='../img/cancel.png' class='grise'/>Annuler</li>";
break;
}
}
$toolbar .= "</ul>";
return $toolbar;
}
static function page_protect($url_redirection='../src/login.php') {
if(!CLogin::est_logue()) {
CFunction::redirection($url_redirection);
}
else if(!CTableUser::is_admin($_SESSION['idmbr'])) {
if(!in_array(basename($_SERVER['SCRIPT_NAME']), array('categorie.php', 'article.php', 'page.php', 'fichier.php', 'dossier.php', 'login.php', 'index.php', 'menu_semaine.php', 'image_menu.php'))) {
CFunction::redirection('../src/index.php');
}
}
}
function load_all() {
$ok = true;
$imap_keys = CTableEmail::get_imapkeys();
$mails_users = CTableUser::get_array_email();
$nb_msg = $this->get_nb_msg();
$sql_0 = "INSERT INTO email(id, nom, text, expediteur, destinataire, date, imap) VALUES ";
$sql_1 = "";
for($i=$nb_msg; $i>=1 ; $i--) {
$info = $this->get_info($i);
if(in_array($info['from'], $mails_users) && !in_array($info['message_id'], $imap_keys)) {
$res = $this->load($i);
$ok = $ok && $res;
}
}
return $ok;
}
<?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>
$zColIdUser = '******';
$zTableGroupe = 'gr_groupe';
}
$zStr = 'destinataire';
$zSqlText = "SELECT text FROM " . $zTableGroupe . " WHERE nom ='" . str_replace ("'", "''", $oEmail[$zStr]) . "'";
$zResSQLText = mysql_query($zSqlText);
$zResUsers = mysql_fetch_array($zResSQLText);
$zStr = 'text';
$toUsers = explode("|", $zResUsers[$zStr]);
if (sizeof($toUsers) > 0) {
foreach ($toUsers as $zUser) {
// Par défaut l'adresse mail est à vérifier
$mail_checked = 0;
$email_to_check = ($zColIdUser == 'retour_email_id_user') ? CTableUser::get_element($zUser, "email") : CTableGrUser::get_element($zUser, "email");
// Vérification des adresses mails
if(mailCheck($email_to_check)){
$zStr = 'id';
$zSql2 = "SELECT COUNT(*) AS COUNT FROM retour_email WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'";
$zResSQL = mysql_query($zSql2);
$oResult = mysql_fetch_array($zResSQL);
$iNbRowMatch = $oResult['COUNT'];
if ( (int)($iNbRowMatch) > 0 ) {
$zSql3 = "UPDATE retour_email SET retour_email_statut = '1', retour_email_lien='0' WHERE retour_email_id_email ='".$oEmail[$zStr]."' AND " . $zColIdUser . " ='".$zUser."'";
mysql_query($zSql3);
}
else {
$zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('" . $oEmail[$zStr] . "', '" . $zUser . "', '1', '0')";
}
$obj->update();
array_push($tab_user, $id_user);
}
else {
$obj = new CTableUser(array(
'nom'=>CFunction::clean_user_input($nom),
'prenom'=>CFunction::clean_user_input($prenom),
'societe'=>CFunction::clean_user_input($societe),
'adresse'=>CFunction::clean_user_input($adresse),
'cp'=>CFunction::clean_user_input($cp),
'ville'=>CFunction::clean_user_input($ville),
'email'=>CFunction::clean_user_input($email),
'telephone'=>CFunction::clean_user_input($telephone),
'mobile'=>CFunction::clean_user_input($mobile),
'web'=>CFunction::clean_user_input($web),
'pays'=>CFunction::clean_user_input($code_pays),
'civilite'=>CFunction::clean_user_input($id_civilite),
'etat'=>1,
'login'=>$login,
'passe'=>$passe));
//pour limiter le nombre d'import
if(CTableUser::is_max()) {
//erreur de type nb max utilisateurs atteint
$msginfo = "Impossible d'ajouter un nouvel utilisateur car le nombre maximum d'enregistrements autorisés est atteint : " . CTableConfiguration::get_value_by_element('MAX_NUMBER_USER');
$a = 0;
break;
}
<th><a href="?order=date">Date</a></th>
<th><a href="?order=heure">Horaire</a></th>
<th><a href="?order=type">Type</a></th>
<th>Nom Utilisateur</th>
<th><a href="?order=prenom">Prenom</a></th>
<th>Pays</th>
<th align="left"><a href="?order=telephone">Téléphone</a></th>
<th align="left">Com.</th>
<th><a href="?order=etat">Effectué</a></th>
<th>Modif</th>
<th title="suppr"> Suppr </th>
</tr>
<?php
$i = 0;
while ($rdv = mysql_fetch_array($r_rdv)) {
$tuser = new CTableUser(array('id'=>$rdv['iduser']));
$user = $tuser->select_row();
?>
<tr>
<td align="center"><a href="?a=5&id=<?php echo $rdv['id'] ?>"><?php echo $rdv['id'] ?></a></td>
<td><?php echo $rdv['nom']; ?></td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($rdv['date'])) ?></td>
<td align="center"><?php echo $rdv['heure'] ?></td>
<td align="center"><?php echo $rdv['type']==0 ? "Téléphone" : ($rdv['type']==1 ? "Skype" : "Domicile") ?></td>
<td align="center"><?php echo @$rdv['nomuser'] ?></td>
<td align="center"><?php echo @$rdv['prenom'] ?></td>
<td style="text-align: center;"><?php echo $user['pays']; ?></td>
<td><?php echo @$rdv['telephone'] ?></td>
<?php
if($user['commentaire']) {
?>
<a href="envoi.php?a=2&id=<?php echo $email['id'] ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a>
<?php } else { ?>
<img src="../img/publish_u.png" alt="Archivé" /> Archivé
<?php } ?>
<br />
<?php if($email['etat'] != 3) { ?>
<a href="envoi.php?a=2&id=<?php echo $email['id'] ?>&etat=3"><img src="../img/publish_q.png" alt="Fuile d'attente" /> File d'attente</a>
<?php } else { ?>
<img src="../img/publish_q.png" alt="File d'attente" /> File d'attente
<?php } ?>
</div></td>
<td align="center"><?php if($email['etat'] == 0) { ?>
<a href="envoi.php?id=<?php echo $email['id'] ?>&a=5">>></a>
<?php } ?></td>
<td align="center"><a href="envoi.php?id=<?php echo $email['id'] ?>&a=7">>></a></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $email['id'], $id, CTableUser::is_admin($_SESSION['idmbr'])) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="envoi.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire d'ajout d'email</legend>
<p>
/*---------------------------------------------------------------------
PROTECTION : permet de proteger la texte avec session
----------------------------------------------------------------------*/
CLogin::page_protect();
$a = $_REQUEST['a'] + 0;
$id = (!empty($_REQUEST['id']))?$_REQUEST['id']:0;
$bIsGrGrp = (!empty ($_REQUEST['isGr'])) ? $_REQUEST['isGr']: 0;
$destinataire = (!empty($_REQUEST['id_groupe']))?trim($_REQUEST['id_groupe']):'';
$id_texte = (!empty($_REQUEST['id_texte']))?$_REQUEST['id_texte']:0;
$date = (!empty($_REQUEST['date']))?trim($_REQUEST['date']):'';
$id_campagne = (!empty($_REQUEST['id_campagne']))? trim($_REQUEST['id_campagne']):'';
$nom = (!empty($_REQUEST['nom']))?trim($_REQUEST['nom']):'';
$expediteur = CTableUser::get_email_admin();
$periode = 0;
$zDateNow = date("Ymd");
$zDateNowBar = date("Y/m/d");
$texte = CBdd::select_row('SELECT * FROM texte WHERE id = '.$id_texte);
if($a == 44 || $a == 55) {
$campagne = CTableEmail::checkDouble($id, $destinataire, $texte['nom'], $date);
$sql = "SELECT date FROM email WHERE `date` > '".$date."' AND id_campagne = ".$id_campagne;
$res = CBdd::select($sql);
if(!preg_match('/(\d{4})-(\d{2})-(\d{2})/', $date)){
echo 'DATE_ERROR', ',', 0;
/*---------------------------------------------------------------------
IMPORTATIONS
----------------------------------------------------------------------*/
include_once("../inc/init.php");
/*---------------------------------------------------------------------
VARIABLES HTTP
----------------------------------------------------------------------*/
$idart = !empty($_GET['idart']) ? $_GET['idart'] : 0;
/*--------------------------------------------------------------------
TRAITEMENTS
----------------------------------------------------------------------*/
echo CForm::get_option($idart, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart));
?>
<?php
session_start();
/*---------------------------------------------------------------------
IMPORTATIONS
----------------------------------------------------------------------*/
include_once("../inc/init.php");
/*---------------------------------------------------------------------
VARIABLES HTTP
----------------------------------------------------------------------*/
$idart = !empty($_GET['idart']) ? $_GET['idart'] : 0;
/*--------------------------------------------------------------------
TRAITEMENTS
----------------------------------------------------------------------*/
echo CForm::get_option($idart, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND text LIKE \'%<!--GALERIE-->%\' AND idart = ' . $idart));
?>
<p>
<label style="padding-right:0;">URL (http://)</label>
<input id="url" name="url" type="text" value="<? if (($url_ok=='NULL') or ($url_ok=='')) echo 'communesgenevoises.ch'; else echo $url_rpl;?>" style="width:150px;padding-left:2px;color: #003399;font-family: sans-serif;font-size: 11px;"/>
<? echo CHtml::get_msginfo($error_signe['url'])?>
</p>
<? // Centre
?>
</div>
<div class="floatleft margin-left">
<h2>Informations personnelles</h2>
<p>
<label>Secteur</label>
<select name="nom_sec" onchange="load_secteur(document.forms['form_ajout'].elements['nom_sec'].options[document.forms['form_ajout'].elements['nom_sec'].selectedIndex].value, 'form_ajout');">
<option value="0" >Secteur</option>
<? echo utf8_encode(CForm::get_option($nom_sec, 'secteur', 'id_sec', 'nom_sec', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr'])); ?>
</select>
<? echo CHtml::get_msginfo($error_signe['nom_cat'])?>
</p>
<p id="cat">
</p>
<p>
<label>Grouper dans</label>
<select name="id_groupe" id="id_groupe">
<option value="0" >Choisir groupe</option>
<? echo CForm::get_option($id_groupe, 'groupeUtilitaire', 'id', 'nom', ' etat = 1') ?>
</select>
<? echo CHtml::get_msginfo($error_signe['id_groupe'])?>
</p>
<p>
<label>Résponsable </label>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="cat.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire d'ajout de menu </legend>
<p id="menu">
<label>Secteur</label>
<select name="idcat">
<?php echo CForm::get_option($idcat, 'secteur', 'id_sec', 'nom_sec', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['idcat'])?>
</p>
<p>
<label>Titre </label>
<input name="nom" type="text" value="<?php echo $nom ?>" />
<p>
<input name="creer" type="submit" value="Ajouter >>"/>
</p>
</fieldset>
</form>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
<label>Menu </label>
<select name="idcat" onchange="update_select_art(document.forms['form_ajout'].elements['idcat'].options[document.forms['form_ajout'].elements['idcat'].selectedIndex].value, 'form_ajout');">
<option value="0">Choisir le menu</option>
<?php echo CForm::get_option($idcat, 'categorie', 'id', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['idcat'])?></p>
<p>
<label>Sous-menu </label>
<select name="idart" id="idart" onchange="update_page(document.forms['form_ajout'].elements['idart'].options[document.forms['form_ajout'].elements['idart'].selectedIndex].value, 'form_ajout');">
<?php echo CForm::get_option($idart, 'article', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idcat = ' . $idcat : ' idreda = ' . $_SESSION['idmbr'] . ' AND idcat = ' . $idcat)); ?>
</select>
</p>
<p>
<label>Page </label>
<select name="idpage" id="idpage">
<?php echo CForm::get_option($idpage, 'page', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idart = ' . $idart : ' idreda = ' . $_SESSION['idmbr'] . ' AND idart = ' . $idart)); ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['page'])?></p>
<p>
<label>Date </label>
<input id="dateevent" name="dateevent" type="text" value="<?php echo $dateevent ?>" />
<?php echo $error_signe['dateevent']?>
</p>
</div>
<hr class="clearfloat" />
<!--<p>
<label>Texte défilant</label>
<input name="text" type="text" value="<?php echo $text?>" />
<?php echo CHtml::get_msginfo($error_signe['text'])?>
</p>
<p>
<?php
//----------------------------------------------------------------------------------------------
// MODIF
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 5) { ?>
<form id="form_modif" method="post" action="categorie.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(55) ?> </p>
<p> <?php echo CForm::get_hidden($id, 'id') ?> </p>
<fieldset>
<legend>Formulaire de modification de menu </legend>
<p>
<label>Titre </label>
<input name="nom" type="text" value="<?php echo $nom?>" />
<?php echo CHtml::get_msginfo($error_signe['nom'])?> </p>
<?php if(CTableUser::is_admin($_SESSION['idmbr'])) { ?>
<p>
<label>Rédacteur</label>
<select name="idreda">
<?php echo CForm::get_option($idreda, 'user', 'id', 'login', ' type = 1 OR type = 2') ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['idreda'])?> </p>
<?php } ?>
<p>
<label>Membre</label>
<select name="idlecteur">
<option value="all" <?php echo CForm::get_selected($idlecteur, 'all'); ?>>public</option>
<option value="0" <?php echo CForm::get_selected($idlecteur, '0'); ?>>tous les membres</option>
<?php echo CForm::get_option($idlecteur, 'user', 'id', 'login', ' type = 0 OR type = 3') ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['idreda'])?> </p>
<p>
<label>Relever les</label>
<input name="nb_traitement" type="text" id="nb_traitement" value="<?php echo $nb_traitement ?>"/>
derniers messages ( Par défaut et Maximum : <?php echo MAIL_MAX_RECEPT ?>)
</p>
<p>
<input name="creer" type="submit" value="Relever >>"/>
</p>
</fieldset>
</form>
<?php } ?>
<?php if($a==44) {
for($i = $nb_msg; $i >= $nb_msg - $nb_traitement; $i--) { ?>
<script type="text/javascript">$('over').innerHTML = "Accès au message <?php echo $i ?>";</script><?php
$mails_users = CTableUser::get_array_email();
$imap_keys = CTableEmail::get_imapkeys();
$info = $imap->get_info($i);
if(in_array($info['from'], $mails_users) && !in_array($info['message_id'], $imap_keys)) { ?>
<script type="text/javascript">
$('over').innerHTML = "Demande de sauvegarde du message <?php echo $i ?>";
new Ajax.Updater('over', 'load_mail.php?passe=<?php echo $passe ?>&message_number=<?php echo $i ?>', {evalScripts:true});
</script><?php
} else { ?>
<script type="text/javascript">$('over').innerHTML = "Rien à faire pour le message <?php echo $i ?>";</script><?php
}
}
$imap->close();
} ?>
</div>
</div>
<th align="left">Nom</th>
<th>Emplacement</th>
<th>Date d'ajout </th>
<th>Modif</th>
<th title="suppr"> Suppr </th>
</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
//----------------------------------------------------------------------------------------------
<td align="center">
<?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?>
<!--<?php echo !$user['etat_contact'] ? "NC" : ($user['etat_contact'] == 1 ? "C" : ($user['etat_contact'] == 2 ? "NI" : "A")) ?>-->
</td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($user['date'])) ?></td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($rdv['date'])) ?></td>
<td align="center"><?php echo $rdv['heure'] ?></td>
<td align="center"><?php echo $rdv['type']==0 ? "Téléphone" : ($rdv['type']==1 ? "Skype" : "Domicile") ?></td>
<td align="center"><a href="gr_user.php?a=5&id=<?php echo $user['id'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td>
<td align="center">
<?php
if($user['type']==2) {
echo ' ';
}
else {
echo CHtmlSession::get_delbutton($a, $user['id'], $id, CTableUser::is_admin($_SESSION['idmbr']));
}
?>
</td>
<td align="center"><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></a></td>
<td>
<?php
if($user['type']==2) {
?> <?php
}
else {
?>
<input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id'] ?>"/>
<?php
}
?>
<?
//----------------------------------------------------------------------------------------------
// MODIF
//----------------------------------------------------------------------------------------------
?>
<? if($a == 5) { ?>
<form id="form_modif" method="post" action="departement.php" enctype="multipart/form-data">
<p> <? echo CForm::get_hidden(55) ?> </p>
<p> <? echo CForm::get_hidden($id, 'id') ?> </p>
<fieldset>
<legend>Formulaire de modification de menu </legend>
<p id="menu">
<label>Pays</label>
<select name="pays">
<? echo CForm::get_option($pays, 'pays', 'code', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?>
</select>
<? echo CHtml::get_msginfo($error_signe['pays'])?>
</p>
<p>
<label>Titre </label>
<input name="nom" type="text" value="<? echo $nom ?>" />
<? echo CHtml::get_msginfo($error_signe['nom'])?> </p>
<p>
<input name="creer" type="submit" value="Modifier >>"/>
</p>
</fieldset>
</form>
<? }
?>
<!-- InstanceEndEditable --></div>
}
?>
</td>
<td align="center"><?php echo $user['pays'] ?></td>
<td align="center"><?php echo date("d-m-20y", strtotime($user['date']));?></td>
<td align="center"><?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?></td>
<td align="center">R<?php echo $user['relance']; ?></td>
<td style="text-align: center;"><?php echo $opp_num[$user['idopportunite']]; ?></td>
<?php if ($user['commentaire']) { ?>
<td align="center" class="info"><div class="bulle"><?php echo nl2br($user['commentaire']) ?></div></td>
<?php } else { ?>
<td align="center"></td>
<?php } ?>
<td><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id'])) ? CHtmlSession::get_etat($user['id'], $user['etat'], $user['id']) : CHtml::get_etat($user['id'], $user['etat']) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($user['id'], $user['id']) ?></td>
<td align="center"><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id']))
? CHtmlSession::get_delbutton($a, $user['id'], $id, $user['id']) : CHtml::get_delbutton($a, $user['id'], $id) ?></td>
<td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4&isGr=1">>></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'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a>
<?php } ?></td>
<td align="center"><input class="caseacocher" name="tab_user[<?php echo $i ?>]" type="checkbox" id="contact[<?php echo $i ?>]" value="<?php echo $user['id'] ?>" checked /></td>
</tr>
<?php $i++; } ?>
</table>
<?php
//----------------------------------------------------------------------------------------------
// GROUPE
//----------------------------------------------------------------------------------------------
?>
<div class="floatright">
$liste_user_new = implode("|", $tab_user_new);
$groupe = new CTableGroupe(array('id' => $id_groupe, 'text' => $liste_user_new));
$groupe->update();
$msginfo = "Enregistrement bien effectué";
break;
case 8 : // Modifier etat contact
if(!empty($_GET['id'])) $id = $_GET['id'];
$use = new CTableUser(array('id' => $id));
$use->reverse_etat_contact();
break;
case 9 : // Modifier opportunité
if(!empty($_GET['id'])) $id = $_GET['id'];
if(!empty($_GET['idopportunite'])) $idopportunite = $_GET['idopportunite'];
$use = new CTableUser(array('id' => $id, 'idopportunite' => $idopportunite));
$use->update();
break;
}
function forceGetOrPost ($_zVarName, $_zDefault = '') {
if (isset ($_GET[$_zVarName])) {
return $_GET[$_zVarName];
}
elseif (isset ($_POST[$_zVarName])) {
return $_POST[$_zVarName];
}
else {
CSession::get($_zVarName, $_zDefault);
}
function send_mail($destinataire, $sujet, $message, $expediteur, $arr_pj = array(), $headers='', $ct="text/html") {
$nom = CTableUser::get_name_by_email($expediteur);
$mail = new CNmail();
if(is_array($destinataire) && count($destinataire) > 1) {
$destinataire = array_unique($destinataire); // Dédoublement des destinataires
foreach($destinataire as $_dest) {
if($_dest <> $expediteur) { // Evite que l'administrateur recoit 2 mail
$mail->addTo($_dest);
}
}
}
else {
$mail->addTo($destinataire);
}
$mail->setSubject($sujet);
$mail->setFrom($expediteur, $nom);
$mail->setTextBody($message);
$mail->setHtmlBody($message);
if(!empty($arr_pj[0])) {
foreach($arr_pj as $url_file) {
$mail->addAttachement($url_file);
}
}
return $mail->send();
/*
// instanciation de la classe
$mail = new CMail();
// parametres
$mail->to = $destinataire;
$mail->subject = $sujet;
$mail->body = $message;
$mail->from = $expediteur;
$mail->headers = $headers;
$mail->type;
// ouverture et lecture du fichier
if(!empty($arr_pj[0])) {
foreach($arr_pj as $url_file) {
$file = file_get_contents($url_file);
$mail->attach($file, basename($url_file));
}
}
// envoi du message
return ($mail->send());
*/
}
if(CBdd::insert($sql)) {
$msginfo = $msgconfirm;
/**/
if($iduser = CBdd::select_one("SELECT id FROM user WHERE email = '" . $expediteur . "'", "id")) {
/*$sql = "UPDATE user SET nom = '"
. htmlentities(addslashes($nom),ENT_COMPAT ,'UTF-8') . "', prenom = '"
. htmlentities(addslashes($prenom),ENT_COMPAT ,'UTF-8') . "', ville = '', pays = '".$pays."', telephone = '' WHERE email = '"
. htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "'";
CBdd::update($sql);*/
} else {
$login = CTableUser::create_login($nom);
$passe = CFonction::get_password();
$sql1 = "INSERT INTO user(id, login, passe, nom, prenom, ville, pays, email, telephone) VALUES(NULL, '" . $login . "', '" . $passe . "', '"
. htmlentities(addslashes($nom),ENT_COMPAT ,'UTF-8') . "', '"
. htmlentities(addslashes($prenom),ENT_COMPAT ,'UTF-8') . "', '', '".$pays."', '"
. htmlentities(addslashes($expediteur),ENT_COMPAT ,'UTF-8') . "', '')";
if(!CBdd::insert($sql1)) exit;
}
/**/
}
else {
$msginfo = $msgerreur;
}
}
static function is_admin($userid) {
$usertype = CTableUser::get_usertype($userid);
if($usertype == 2) $ok = true;
else $ok = false;
return $ok;
}
<?php
session_start();
/*---------------------------------------------------------------------
IMPORTATIONS
----------------------------------------------------------------------*/
include_once("../inc/init.php");
/*---------------------------------------------------------------------
VARIABLES HTTP
----------------------------------------------------------------------*/
$idcat = !empty($_GET['idcat']) ? $_GET['idcat'] : 0;
$idart = 0;
/*--------------------------------------------------------------------
TRAITEMENTS
----------------------------------------------------------------------*/
?>
<option value="0">Choisir le sous-menu</option>
<?php
echo CForm::get_option($idart, 'article_cat', 'id', 'nom', (CTableUser::is_admin($_SESSION['idmbr']) ? '1 AND idcat = ' . $idcat : ' idreda = ' . $_SESSION['idmbr'] . ' AND idcat = ' . $idcat));
?>
function create_login($nom)
{
$login = '';
$id = null;
do {
list($usec, $sec) = explode(' ', microtime());
$init = (float) $sec + ((float) $usec * 100000);
mt_srand($init);
$rand = mt_rand();
$salt = strtolower(substr(md5($rand),0,5));
$login = CFunction::chaine_to_ascii($nom).'_'.$salt;
$id = CTableUser::get_id($login);
}
while($id);
return $login;
}
<?php
$oFCKeditor = new FCKeditor('text') ;
$oFCKeditor->BasePath = '../plug/fckeditor/';
$oFCKeditor->Value = $text;
$oFCKeditor->Height = '300';
$oFCKeditor->Width = '850';
$oFCKeditor->Config['EditorAreaCSS'] = '';
$oFCKeditor->ToolbarSet = 'Page';
$oFCKeditor->Create() ;
?>
<?php echo CHtml::get_msginfo($error_signe['text'])?></p>
<p>
<label>Publier </label>
<input type="radio" name="etat" value="0" <?php echo CForm::get_checked($etat,0) ?> <?php echo (CTableUser::is_admin($_SESSION['idmbr'])) ? "" : "disabled = 'disabled'" ?>/>
non
<input type="radio" name="etat" value="1" <?php echo CForm::get_checked($etat,1) ?> <?php echo (CTableUser::is_admin($_SESSION['idmbr'])) ? "" : "disabled = 'disabled'" ?>/>
oui <?php echo $error_signe['etat']?></p>
<p>
<input name="creer" type="submit" value="Modifier >>"/>
</p>
</fieldset>
</form>
<?php } ?>
<!-- InstanceEndEditable --></div>
</div>
<hr class="clearfloat" />
</div>
</div>
</body>
<!-- InstanceEnd --></html>
$obj = new CTableGroupe(array('id'=>$_SESSION['id_groupe']));
$obj->delete_user($id);
break;
case 5 : // Modifier 1
break;
case 6 : // Filtrer
CSession::save($_GET);
break;
case 7 :
if(!empty($_POST['ids'])) $ids = $_POST['ids'];
if(is_array($ids)) {
foreach($ids as $id) {
$obj = new CTableUser(array('id'=>$id));
$obj->delete();
}
}
$a = 0;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
$filtre_etat_contact = CSession::get('filtre_etat_contact', $etat_contact);
$filtre_date_debut = CDate::date_switch(CSession::get('filtre_date_debut'));
$filtre_date_fin = CDate::date_switch(CSession::get('filtre_date_fin'));
$filtre_id_groupe = CSession::get('filtre_id_groupe', $id_groupe);
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 5) { ?>
<form id="form_modif" method="post" action="article.php">
<p> <?php echo CForm::get_hidden(55) ?> </p>
<p> <?php echo CForm::get_hidden($id, 'id') ?> </p>
<fieldset>
<legend>Formulaire de modification de sous-menu</legend>
<p>
<label>Titre </label>
<input name="nom" type="text" value="<?php echo $nom?>" />
<?php echo CHtml::get_msginfo($error_signe['nom'])?></p>
<p>
<label>Menu </label>
<select name="idcat">
<?php echo CForm::get_option($idcat, 'categorie', 'id', 'nom', CTableUser::is_admin($_SESSION['idmbr']) ? '1' : ' idreda = ' . $_SESSION['idmbr']); ?>
</select>
<?php echo CHtml::get_msginfo($error_signe['idcat'])?> </p>
<p>
<label>Publier </label>
<input type="radio" name="etat" value="0" <?php echo CForm::get_checked($etat,0) ?> />non
<input type="radio" name="etat" value="1" <?php echo CForm::get_checked($etat,1) ?> />oui <?php echo $error_signe['etat']?></p>
<p>
<input name="creer" type="submit" value="Modifier >>"/>
</p>
</fieldset>
</form>
<?php } ?>
<!-- InstanceEndEditable --></div>
</div>
<hr class="clearfloat" />
*/
include("../inc/init.php");
$id = isset($_REQUEST['a'])?$_REQUEST['a']:0; // Id de la table email
$mail = isset($_REQUEST['m'])?$_REQUEST['m']:''; // Adresse mail
$url = isset($_REQUEST['u'])?$_REQUEST['u']:''; // Lien dans le mail automatique
if($id > 0) {
$zQuery = "SELECT id_groupe, type_envoi FROM email WHERE id = " . $id;
$tzData = mysql_fetch_assoc (mysql_query ($zQuery));
if ( ($tzData['type_envoi'] == TYPE_ENVOI_GROUPE) || ($tzData['type_envoi'] == TYPE_ENVOI_USER) ) {
$zColIdUser = '******';
$zTableUser = '******';
$user_id = CTableUser::get_id_by_email($mail);
}
else {
$zColIdUser = '******';
$zTableUser = '******';
$user_id = CTableGrUser::get_id_by_email($mail);
}
// Par précaution sur l'existence de l'utilisateur dans la base
if ( $user_id != '' ){
$zSql2 = "SELECT COUNT(*) AS num FROM retour_email WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " ='".$user_id."'";
$iNbRowMatch = CBdd::select_one($zSql2,'num');
if ((int)($iNbRowMatch) > 0) {
$zSql3 = "UPDATE retour_email SET retour_email_statut='2', retour_email_lien='1' WHERE retour_email_id_email ='".$id."' AND " . $zColIdUser . " = ". $user_id;
$resUpdate = CBdd::update($zSql3);
