Server : Apache System : Linux webd348.cluster026.gra.hosting.ovh.net 5.15.148-ovh-vps-grsec-zfs-classid #1 SMP Thu Feb 8 09:41:04 UTC 2024 x86_64 User : hednacluml ( 122243) PHP Version : 8.3.9 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl Directory : /home/hednacluml/petits/tmp/cache/skel/ |
<?php
/*
* Squelette : plugins/auto/escal/inclusions/inc-hierarchie_art.html
* Date : Wed, 30 Aug 2023 22:33:44 GMT
* Compile : Thu, 31 Aug 2023 01:24:26 GMT
* Boucles : _testrub, _hierarchie, _contexte, _chemin_article, _testget
*/
function BOUCLE_testrubhtml_10d6dde5f99576f37a8ef51e173d65b8(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!isset($command['table'])) {
$command['table'] = 'rubriques';
$command['id'] = '_testrub';
$command['from'] = array('rubriques' => 'spip_rubriques','L1' => 'spip_mots_liens','L2' => 'spip_mots');
$command['type'] = array();
$command['groupby'] = array("rubriques.id_rubrique");
$command['select'] = array("rubriques.lang",
"rubriques.titre");
$command['orderby'] = array();
$command['join'] = array('L1' => array('rubriques','id_objet','id_rubrique','L1.objet='.sql_quote('rubrique')), 'L2' => array('L1','id_mot'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
quete_condition_statut('rubriques.statut','!','publie',''),
array('=', 'rubriques.id_rubrique', sql_quote($Pile[$SP]['id_rubrique'], '','bigint(21) NOT NULL AUTO_INCREMENT')), 'JOIN-L1' =>
array('=', 'L1.objet', sql_quote('rubrique')),
array('=', 'L2.titre', "'invisible'"));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-hierarchie_art.html','html_10d6dde5f99576f37a8ef51e173d65b8','_testrub',5,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
' .
vide($Pile['vars'][$_zzz=(string)'visible'] = 'non'));
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_testrub @ plugins/auto/escal/inclusions/inc-hierarchie_art.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_hierarchiehtml_10d6dde5f99576f37a8ef51e173d65b8(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!($id_rubrique = intval($Pile[$SP]['id_rubrique'])))
return '';
include_spip('inc/rubriques');
$hierarchie = calcul_hierarchie_in($id_rubrique,true);
if (!$hierarchie) return "";
if (!isset($command['table'])) {
$command['table'] = 'rubriques';
$command['id'] = '_hierarchie';
$command['from'] = array('rubriques' => 'spip_rubriques');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("rubriques.id_rubrique",
"rubriques.lang",
"rubriques.titre");
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['orderby'] = array("FIELD(rubriques.id_rubrique, $hierarchie)");
$command['where'] =
array(
array('IN', 'rubriques.id_rubrique', "($hierarchie)"));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-hierarchie_art.html','html_10d6dde5f99576f37a8ef51e173d65b8','_hierarchie',4,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
' .
BOUCLE_testrubhtml_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons, $Numrows, $SP) .
'
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_hierarchie @ plugins/auto/escal/inclusions/inc-hierarchie_art.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_contextehtml_10d6dde5f99576f37a8ef51e173d65b8(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!isset($command['table'])) {
$command['table'] = 'articles';
$command['id'] = '_contexte';
$command['from'] = array('articles' => 'spip_articles');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("articles.id_rubrique",
"articles.lang",
"articles.titre");
$command['orderby'] = array();
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''),
quete_condition_postdates('articles.date',''),
array('=', 'articles.id_article', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-hierarchie_art.html','html_10d6dde5f99576f37a8ef51e173d65b8','_contexte',3,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
' .
BOUCLE_hierarchiehtml_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons, $Numrows, $SP) .
'
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_contexte @ plugins/auto/escal/inclusions/inc-hierarchie_art.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_chemin_articlehtml_10d6dde5f99576f37a8ef51e173d65b8(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!($id_rubrique = intval($Pile[$SP]['id_rubrique'])))
return '';
include_spip('inc/rubriques');
$hierarchie = calcul_hierarchie_in($id_rubrique,true);
if (!$hierarchie) return "";
if (!isset($command['table'])) {
$command['table'] = 'rubriques';
$command['id'] = '_chemin_article';
$command['from'] = array('rubriques' => 'spip_rubriques');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("rubriques.id_rubrique",
"rubriques.descriptif",
"rubriques.titre",
"rubriques.lang");
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['orderby'] = array("FIELD(rubriques.id_rubrique, $hierarchie)");
$command['where'] =
array(
array('IN', 'rubriques.id_rubrique', "($hierarchie)"));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-hierarchie_art.html','html_10d6dde5f99576f37a8ef51e173d65b8','_chemin_article',12,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
<a href="' .
interdire_scripts((((include_spip('inc/config')?lire_config('gerer_trad',null,false):'') == 'oui') ? parametre_url(vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_rubrique'], 'rubrique', '', '', true))),'lang',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'lang', null),true))):vider_url(urlencode_1738(generer_objet_url($Pile[$SP]['id_rubrique'], 'rubrique', '', '', true))))) .
'" title="' .
interdire_scripts(entites_html(textebrut(propre($Pile[$SP]['descriptif'], $connect, $Pile[0])))) .
'" >' .
interdire_scripts(supprimer_numero(typo($Pile[$SP]['titre'], "TYPO", $connect, $Pile[0]))) .
'</a>
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_chemin_article @ plugins/auto/escal/inclusions/inc-hierarchie_art.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_testgethtml_10d6dde5f99576f37a8ef51e173d65b8(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
if (!isset($si_init)) { $command['si'] = array(); $si_init = true; }
$command['si'][] = (((table_valeur($Pile["vars"]??[], (string)'visible', null) == 'oui')) ?' ' :'');
if (!isset($command['table'])) {
$command['table'] = 'articles';
$command['id'] = '_testget';
$command['from'] = array('articles' => 'spip_articles');
$command['type'] = array();
$command['groupby'] = array();
$command['select'] = array("articles.id_rubrique",
"articles.lang",
"articles.titre");
$command['orderby'] = array();
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
quete_condition_statut('articles.statut','publie,prop,prepa/auteur','publie',''),
quete_condition_postdates('articles.date',''),
array('=', 'articles.id_article', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('plugins/auto/escal/inclusions/inc-hierarchie_art.html','html_10d6dde5f99576f37a8ef51e173d65b8','_testget',11,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
lang_select($GLOBALS['spip_lang']);
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
lang_select_public($Pile[$SP]['lang'], '', $Pile[$SP]['titre']);
$t0 .= (
'
' .
BOUCLE_chemin_articlehtml_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons, $Numrows, $SP) .
'
');
lang_select();
}
lang_select();
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_testget @ plugins/auto/escal/inclusions/inc-hierarchie_art.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette plugins/auto/escal/inclusions/inc-hierarchie_art.html
// Temps de compilation total: 0.750 ms
//
function html_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons = array(), $Numrows = array(), $SP = 0) {
if (isset($Pile[0]["doublons"]) AND is_array($Pile[0]["doublons"]))
$doublons = nettoyer_env_doublons($Pile[0]["doublons"]);
$connect = '';
$page = (
'<nav class="ariane">
' .
vide($Pile['vars'][$_zzz=(string)'visible'] = 'oui') .
BOUCLE_contextehtml_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons, $Numrows, $SP) .
'
' .
BOUCLE_testgethtml_10d6dde5f99576f37a8ef51e173d65b8($Cache, $Pile, $doublons, $Numrows, $SP) .
'
</nav>');
return analyse_resultat_skel('html_10d6dde5f99576f37a8ef51e173d65b8', $Cache, $page, 'plugins/auto/escal/inclusions/inc-hierarchie_art.html');
}