function export($separator = ',') { $id_groupe = $this->table['id']; $nom_groupe = self::get_element($id_groupe); $nom_csv = CFunction::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 user 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).'"'.$separator; $i++; } $field_name = trim($field_name, $separator); 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 .= '"' . html_entity_decode($elem) . '"'.$separator; } $data = trim($data, $separator); echo $data . "\r\n"; } return 1; } else { return 0; } }
function export($separator = ',') { $id_groupe = $this->table['id']; $nom_groupe = self::get_element($id_groupe); $nom_csv = CFunction::formate_chaine($nom_groupe) . ".csv"; header("Content-Type: application/csv-tab-delimited-table"); header("Content-disposition: filename=" . $nom_csv); $resQuery = CBdd::select("SELECT nom_ent, categorie_ent, resp_ent, tel_ent, fax_ent, mail_ent, web_ent, descr_ent, rue_adr, cp_adr, actif_ent, dateajout_ent, datecontact_ent, idopportunite, cmtr_ent, paiement_abo, paiement_pre, fin_abo, debut_abo, ent, url, montant_v, montant_pre, type, commune_alias, etatcontact_ent, date_contact FROM entreprise WHERE id_ent 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).'"'.$separator; $i++; } $field_name = trim($field_name, $separator); 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 .= '"' . html_entity_decode($elem) . '"'.$separator; } $data = trim($data, $separator); echo $data . "\r\n"; } return 1; } else { return 0; } }