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);