static function is_max($max = null) {
$tuser = new CTableGrUser();
if($max === null) {
$max = CTableConfiguration::get_value_by_element('USER_MAX_NUMBER');
}
if($max <= 0) {
return false;
}
return ($tuser->get_nb() >= $max);
}
}
$tuse->update();
//-- MAJ contact GR
if ($tzUser = mysql_fetch_assoc (mysql_query ("SELECT id FROM gr_user WHERE user_id = " . $id))) {
$tuse = new CTableGrUser(
array (
'id' => $tzUser['id'],
'login' => $login,
'passe' => $passe,
'civilite' => $civilite,
'nom'=>CFunctions::addslashes($nom),
'prenom'=>CFunctions::addslashes($prenom),
'adresse'=>CFunctions::addslashes($adresse),
'cp'=>CFunctions::addslashes($cp),
'ville'=>CFunctions::addslashes($ville),
'pays' => $pays,
'email'=>CFunctions::addslashes($email),
'telephone'=>CFunctions::addslashes($telephone),
'mobile'=>CFunctions::addslashes($mobile),
'societe'=>CFunctions::addslashes($societe),
'web'=>CFunctions::addslashes($web),
'etat_contact' => $etat_contact,
'date_contact' => $date_contact,
'commentaire'=>CFunctions::addslashes($commentaire),
'idopportunite' => $idopportunite)
);
$tuse->update();
}
CTableRdv::delete_rdv_of_user($id);
$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')";
$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);
}
else {
$zSql3 = "INSERT INTO retour_email (retour_email_id_email, " . $zColIdUser . ", retour_email_statut, retour_email_lien) VALUES ('".$id."', '".$user_id."', '2', '1')";
$resInsert = CBdd::insert($zSql3);
}
$obj = new CTableGrGroupe(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 CTableGrUser(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);
