$id_rdv = CTableRdv::get_idrdv_of_user($id);
$trdv = new CTableRdv(array('id' => $id_rdv));
$rdv = $trdv->select_row();
$type_rdv = $rdv['type'];
$etat_rdv = $rdv['etat'];
$date_rdv = $rdv['date'];
$heure_rdv = $rdv['heure'];
$nom_rdv = $rdv['nom'];
break;
case 55 : // Modifier 2
//user
if(!empty($_POST['id'])) $id = $_POST['id'];
if(!empty($_POST['login'])) $login = CFunctions::formate_chaine(trim($_POST['login']),'');
if(!empty($_POST['passe'])) $passe = CFunctions::formate_chaine(trim($_POST['passe']),'');
if(!empty($_POST['etat'])) $etat = $_POST['etat'];
if(!empty($_POST['type'])) $type = $_POST['type'];
if(!empty($_POST['civilite'])) $civilite = $_POST['civilite'];
if(!empty($_POST['nom'])) $nom = $_POST['nom'];
if(!empty($_POST['prenom'])) $prenom = $_POST['prenom'];
if(!empty($_POST['adresse'])) $adresse = $_POST['adresse'];
if(!empty($_POST['cp'])) $cp =$_POST['cp'];
if(!empty($_POST['ville'])) $ville = $_POST['ville'];
if(!empty($_POST['pays'])) $pays = $_POST['pays'];
if(!empty($_POST['email'])) $email = trim($_POST['email']);
if(!empty($_POST['telephone'])) $telephone = trim($_POST['telephone']);
if(!empty($_POST['mobile'])) $mobile = trim($_POST['mobile']);
if(!empty($_POST['societe'])) $societe = $_POST['societe'];
if(!empty($_POST['web'])) $web = $_POST['web'];
if(!empty($_POST['commentaire'])) $commentaire = $_POST['commentaire'];
break;
case 55 : // Modifier 2
//user
if(!empty($_POST['id'])) $id = $_POST['id'];
// PARTIE GAUCHE
if(!empty($_POST['login'])) $login = CFunctions::formate_chaine(trim($_POST['login']),'');
if(!empty($_POST['passe'])) $passe = CFunctions::formate_chaine(trim($_POST['passe']),'');
if(!empty($_POST['etat'])) $etat = $_POST['etat'];
if(!empty($_POST['type'])) $type = $_POST['type'];
$paiement_abo = CFunctions::getUserParam('paiement_abo', 0) ;
$ent = CFunctions::getUserParam('ent', 0) ;
$paye_p = CFunctions::getUserParam('paye_p', 0) ;
$montant_vignette = CFunctions::formate_chaine(CFunctions::getUserParam('montant_vignette', '')) ;
$montant_p = CFunctions::formate_chaine(CFunctions::getUserParam('montant_p', '')) ;
if(isset($_POST['url'])) {
$url_2 = $_POST['url'];
$url_3=str_replace("http://","",$url_2);
$url_4=str_replace("www.","",$url_3);
www.
$url_1='http://'.$url_4;
}
// PARTIE CENTRE
if(!empty($_POST['nom_sec'])) $nom_sec = CFunctions::clean($_POST['nom_sec']);
if(!empty($_POST['nom_cat'])) $nom_cat = CFunctions::clean($_POST['nom_cat']);
if(!empty($_POST['responsable'])) $responsable = CFunctions::clean($_POST['responsable']);
if(!empty($_POST['adresse'])) $adresse = CFunctions::clean($_POST['adresse']);
if(!empty($_POST['cp'])) $cp = CFunctions::clean($_POST['cp']);
function export() {
$id_groupe = $this->table['id'];
$nom_groupe = self::get_element($id_groupe);
$nom_csv = CFunctions::formate_chaine($nom_groupe) . ".csv";
header("Content-Type: application/csv-tab-delimited-table");
header("Content-disposition: filename=" . $nom_csv);
$resQuery = CBdd::select("SELECT civilite, nom, prenom, societe, adresse, cp, ville, pays, email, telephone, mobile, web FROM hbclients WHERE id IN (" . implode(",", self::get_array_id_user($id_groupe)) . ")");
if ($resQuery) {
// titre des colonnes
$fields = mysql_num_fields($resQuery);
$i = 0;
$field_name = '';
while ($i < $fields) {
$field_name .= '"' . mysql_field_name($resQuery, $i).'",';
$i++;
}
$field_name = trim($field_name, ',');
echo $field_name . "\r\n";
// donn�es de la table
while ($arrSelect = mysql_fetch_array($resQuery, MYSQL_ASSOC)) {
$data = '';
foreach($arrSelect as $key=>$elem) {
if($key == "civilite") {
$elem = CTableCivilite::get_name($elem);
} elseif ($key == "pays") {
$elem = CTablePays::get_name($elem);
}
$data .= '"' . utf8_decode($elem) . '",';
}
$data = trim($data, ",");
echo $data . "\r\n";
}
return 1;
} else {
return 0;
}
}
