sitemap.php

Go to the documentation of this file.

<?php
// This file should be in UTF8 without BOM - Accents examples: éèê
// +----------------------------------------------------------------------+
// | Copyright (c) 2004-2015 Advisto SAS, service PEEL - contact@peel.fr  |
// +----------------------------------------------------------------------+
// | This file is part of PEEL Shopping 8.0.0, which is subject to an   |
// | opensource GPL license: you are allowed to customize the code           |
// | for your own needs, but must keep your changes under GPL                |
// | More information: https://www.peel.fr/lire/licence-gpl-70.html          |
// +----------------------------------------------------------------------+
// | Author: Advisto SAS, RCS 479 205 452, France, https://www.peel.fr/      |
// +----------------------------------------------------------------------+
// $Id: sitemap.php 46935 2015-09-18 08:49:48Z gboussin $
define('IN_PEEL_ADMIN', true);
include("../configuration.inc.php");
necessite_identification();
necessite_priv("admin_webmastering");

if (empty($_SESSION['session_admin_multisite']) || $_SESSION['session_admin_multisite']!=$GLOBALS['site_id']) {
     // Possibilité de générer le sitemap uniquement pour le domaine en cours d'utilisation, et pas pour le site administré.
     redirect_and_die($GLOBALS['administrer_url'] . '/');
}

if (!empty($_GET['encoding'])) {
     $file_encoding = $_GET['encoding'];
} else {
     $file_encoding = 'utf-8';
}
$GLOBALS['DOC_TITLE'] = $GLOBALS['STR_ADMIN_SITEMAP_TITLE'];
$form_error_object = new FormError();

include($GLOBALS['repertoire_modele'] . "/admin_haut.php");

$tpl = $GLOBALS['tplEngine']->createTemplate('admin_sitemap.tpl');
$tpl->assign('href', $GLOBALS['wwwroot'] . '/sitemap.xml');
$tpl->assign('STR_ADMIN_SITEMAP_TITLE', $GLOBALS['STR_ADMIN_SITEMAP_TITLE']);
$tpl->assign('STR_ADMIN_SITEMAP_OPEN', $GLOBALS['STR_ADMIN_SITEMAP_OPEN']);
echo $tpl->fetch();


switch (vb($_REQUEST['mode'])) {
     case "lire" :
          if (!verify_token($_SERVER['PHP_SELF'])) {
               $form_error_object->add('token', $GLOBALS['STR_INVALID_TOKEN']);
          }
          if (!$form_error_object->count()) {
               // Création d'un fichier sitemap.xml par sous-domaine et domaine. Le fichier sitemap sera appeler en front office via le fichier php get_sitemap.php
               // Les urls des sites dans un sous-dossier ne sont pas correctement générées.
               $langs_array_by_subdomain = array();
               foreach($GLOBALS['langs_array_by_wwwroot'] as $this_wwwroot=>$this_lang_array) {
                    // Création du tableau langue par sous domaine
                    $langs_array_by_subdomain[get_site_domain(false, $this_wwwroot, false)][] = $this_lang_array[0];
               }
               // Format du tableau
               // $langs_array_by_subdomain = array(domain1 => array('lng1', 'lng2', 'lng3'), domain2 => array('lng4'), domain3 => array('lng5','lng6'));
               foreach ($langs_array_by_subdomain as $this_domain=>$this_lang_array) {
                    // Création des fichiers sitemap.
                    create_google_sitemap($this_domain, $this_lang_array, $file_encoding);
               }
          } elseif ($form_error_object->has_error('token')) {
               echo $form_error_object->text('token');
          }
          form2xml();
          break;

     default :
          form2xml();
          break;
}

include($GLOBALS['repertoire_modele'] . "/admin_bas.php");

/* FONCTIONS */

function create_google_sitemap($this_wwwroot, $this_wwwroot_lang_array, $file_encoding)
{
     $tpl = $GLOBALS['tplEngine']->createTemplate('admin_google_sitemap.tpl');
     $tpl->assign('GENERAL_ENCODING', GENERAL_ENCODING);
     $sitemap = '';
     $tpl_products = array();
     $account_register_url_array = array();
     $product_category_url_array = array();
     $content_url_array = array();
     $content_category_url_array = array();
     $account_url_array = array();
     $wwwroot_array = array();
     $legal_url_array = array();
     $tpl->assign('date', date("Y-m-d"));
     $current_lang = $_SESSION['session_langue'];
     foreach($this_wwwroot_lang_array as $this_lang) {
          // Modification de l'environnement de langue
          $_SESSION['session_langue'] = $this_lang;
          set_lang_configuration_and_texts($this_lang, vb($GLOBALS['load_default_lang_files_before_main_lang_array_by_lang'][$this_lang]), true, false, !empty($GLOBALS['load_admin_lang']), true, defined('SKIP_SET_LANG'));

          // génération des liens pour les produits 
          $sql = "SELECT p.id AS produit_id, c.id AS categorie_id, p.nom_".(!empty($GLOBALS['site_parameters']['product_name_forced_lang'])?$GLOBALS['site_parameters']['product_name_forced_lang']:$this_lang)." AS name, c.nom_" . $this_lang . " AS categorie
               FROM peel_produits p
               INNER JOIN peel_produits_categories pc ON p.id = pc.produit_id
               INNER JOIN peel_categories c ON c.id = pc.categorie_id AND " . get_filter_site_cond('categories', 'c') . "
               WHERE p.etat=1 AND " . get_filter_site_cond('produits', 'p') . "
               ORDER BY p.position ASC";
          $created_report[] = $sql;
          $query = query($sql);
          while ($result = fetch_assoc($query)) {
               $product_object = new Product($result['produit_id'], $result, true, null, true, !check_if_module_active('micro_entreprise'));
               $tpl_products[] = $product_object->get_product_url();
               unset($product_object);
          }

          // génération des liens pour les categories de produit
          if (empty($GLOBALS['site_parameters']['disallow_main_category'])) {
               $product_category_url_array[] = get_product_category_url();
          }
          $sql = "SELECT c.id, c.nom_" .$_SESSION['session_langue']. " AS nom
               FROM peel_categories c
               WHERE c.etat=1 AND " . get_filter_site_cond('categories', 'c') . "
               ORDER BY c.position ASC";
          $created_report[] = $sql;
          $query = query($sql);
          while ($result = fetch_assoc($query)) {
               $product_category_url_array[] = get_product_category_url($result['id'], $result['nom']);
          }
          
          // génération des liens pour les articles de contenu
          $sql = "SELECT p.id, c.id AS categorie_id, p.titre_".$this_lang." AS name, c.nom_" . $this_lang . " AS categorie
               FROM peel_articles p
               INNER JOIN peel_articles_rubriques pc ON p.id = pc.article_id
               INNER JOIN peel_rubriques c ON c.id = pc.rubrique_id AND " . get_filter_site_cond('rubriques', 'c') . "
               WHERE p.etat=1 AND " . get_filter_site_cond('produits', 'p') . "
               ORDER BY p.position ASC";
          $created_report[] = $sql;
          $query = query($sql);
          while ($result = fetch_assoc($query)) {
               $content_url_array[] = get_content_url($result['id'], $result['name'], $result['categorie_id'], $result['categorie']);
          }

          // génération des liens pour les rubriques de contenu
          if (empty($GLOBALS['site_parameters']['disallow_main_content_category'])) {
               $content_category_url_array[] = get_content_category_url();
          }
          $sql = "SELECT c.id, c.nom_" .$_SESSION['session_langue']. " AS nom
               FROM peel_rubriques c
               WHERE c.etat=1 AND " . get_filter_site_cond('rubriques', 'c') . "
               ORDER BY c.position ASC";
          $created_report[] = $sql;
          $query = query($sql);
          while ($result = fetch_assoc($query)) {
               $content_category_url_array[] = get_content_category_url($result['id'], $result['nom']);
          }
          $content_url_array[] = get_url('/utilisateurs/contact.php');
          $legal_url_array[] = get_url('legal');
          $legal_url_array[] = get_url('cgv');
          $account_register_url_array[] = get_account_register_url();
          $account_url_array[] = get_account_url(false, false, false);
          $account_url_array[] = get_url('/utilisateurs/oubli_mot_passe.php');
          $wwwroot_array[] = get_url('/');
     }
     // rétablissement de la langue du back office pour l'affichage du message de confirmation
     $_SESSION['session_langue'] = $current_lang;
     set_lang_configuration_and_texts($_SESSION['session_langue'], vb($GLOBALS['load_default_lang_files_before_main_lang_array_by_lang'][$_SESSION['session_langue']]), true, false, !empty($GLOBALS['load_admin_lang']), true, defined('SKIP_SET_LANG'));

     $tpl->assign('account_register_url_array', $account_register_url_array);
     $tpl->assign('product_category_url_array', $product_category_url_array);
     $tpl->assign('content_url_array', $content_url_array);
     $tpl->assign('content_category_url_array', $content_category_url_array);
     $tpl->assign('account_url_array', $account_url_array);
     $tpl->assign('wwwroot_array', $wwwroot_array);
     $tpl->assign('products', $tpl_products);
     $tpl->assign('legal_url_array', $legal_url_array);
     $sitemap = $tpl->fetch();
     // Création du fichier. Ce fichier sera lu par le fichier php /get_sitemap.xml. Une règle de réécriture dans le htaccess rend cet appel transparent pour le client.
     $xml_filename = $GLOBALS['dirroot'] . "/sitemap_" . substr(md5($this_wwwroot), 0, 4) . ".xml";
     $create_xml = String::fopen_utf8($xml_filename, "wb");
     fwrite($create_xml, String::convert_encoding($sitemap, $file_encoding, GENERAL_ENCODING));
     fclose($create_xml);

     echo $GLOBALS['tplEngine']->createTemplate('global_success.tpl', array('message' => $GLOBALS['STR_ADMIN_SITEMAP_MSG_CREATED_OK']))->fetch();
     echo '<p>'.$GLOBALS['STR_ADMIN_SITEMAP_CREATED_REPORT'].'<br /><br />' . nl2br(implode('<hr />', $created_report)) . '</p>';
}

function form2xml()
{
     $tpl = $GLOBALS['tplEngine']->createTemplate('admin_sitemap_form2xml.tpl');
     $tpl->assign('action', get_current_url(false));
     $tpl->assign('form_token', get_form_token_input($_SERVER['PHP_SELF']));
     $tpl->assign('STR_ADMIN_SITEMAP_CREATE_BUTTON', $GLOBALS['STR_ADMIN_SITEMAP_CREATE_BUTTON']);
     echo $tpl->fetch();
}