function create($sitemap_name = '') {
if(!$sitemap_name) $sitemap_name = SS_ADMIN_TO_USERFILE . "/sitemap.xml";
if(empty($sitemap_name)) $sitemap_name = "sitemap_" . $rep_name . ".xml";
$changefreq = array('daily', 'weekly', 'monthly');
$priority = array('0.1', '0.5', '1.0');
$tab_archive = array();
rsort($tab_archive);
$xml = simplexml_load_file(SS_ADMIN_TO_USERFILE . '/google/sitemap_base.xml');
//scan bdd
$sql = "SELECT * FROM page WHERE etat = 1";
$res = CBdd::select($sql);
while($page = mysql_fetch_array($res)) {
$url = $xml->addChild('url');
$url->addChild('loc', CUrl::get_urlsite() . "/" . CFunction::formate_chaine(utf8_decode($page['nom']), '-') . "_p" . $page['id']. ".html");
$url->addChild('lastmod', CDate::formate_date($page['date']));
$url->addChild('changefreq', $changefreq[rand(0, 2)]);
$url->addChild('priority', $priority[rand(0, 2)]);
}
$html = $xml->asXML();
file_put_contents($sitemap_name, $html);
}
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 upload_file($file, $url_rep="", $unzip=FALSE) {
$error_type = 0;
$file_name = "";
if(!empty($file['name'])) {
$file_name = $file['name'];
$file_tmp = $file['tmp_name'];
$tab = explode(".",$file_name);
$file_ext = strtolower($tab[1]);
$file_name_noext=$tab[0];
}
if($file_name == ""){
return 0;
}
$nom_file = CFunction::formate_chaine($file_name_noext) . "." . $file_ext;
$url_file = self::addendslash($url_rep) . $nom_file;
if(is_file($url_file)) return 0;
@move_uploaded_file($file_tmp, $url_file);
$ret = $url_file;
if($unzip) {
self::unzip($url_file, $url_rep);
}
return $ret ;
}
$msginfo = "";
$error_type = 0;
$url_dest = "../userfiles/image/reference";
$msginfo = "";
$error_signe = array('file'=>"");
$value = "";
$name = "";
/*--------------------------------------------------------------------
TRAITEMENTS
----------------------------------------------------------------------*/
if(!empty($_POST['upload'])) { // upload
$name = $_FILES['file']['name'];
if(!CUserFile::upload_file($_FILES['file'], $url_dest)) {
$error_signe['file'] = "*";
$msginfo = " Echec";
} else {
$name = CFunction::formate_chaine($name, "_");
$name[strlen($name)-4] = '.';
?>
<script type='text/javascript'>insertOption('<?php echo $name ?>', 'img')</script>
<?php
}
}
?>
<form action="" method="post" enctype="multipart/form-data" name="form_upload">
<input type="file" name="file" /><input name="upload" type="submit" value="upload" /><?php echo CHtml::get_msginfo($msginfo) ?>
</form>
</body>
</html>
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;
}
}
