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/genius/tmp/cache/skel/ |
<?php
/*
* Squelette : ../plugins/auto/agenda/prive/objets/liste/evenements-post.html
* Date : Fri, 28 Jul 2023 07:24:47 GMT
* Compile : Thu, 12 Oct 2023 14:07:48 GMT
* Boucles : _un, _debut, _last
*/
function BOUCLE_unhtml_237c923fdba30994ea40a6923504c478(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
if (!(is_array($a = (($Pile[0]['id_article'] ?? null)))))
$in[]= $a;
else $in = array_merge($in, $a);
$in1 = array();
if (!(is_array($a = (($Pile[0]['id_rubrique'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
$in2 = array();
if (!(is_array($a = (($Pile[0]['id_mot'] ?? null)))))
$in2[]= $a;
else $in2 = array_merge($in2, $a);
$in3 = array();
if (!(is_array($a = (($Pile[0]['id_evenement_source'] ?? null)))))
$in3[]= $a;
else $in3 = array_merge($in3, $a);
if (!isset($command['table'])) {
$command['table'] = 'evenements';
$command['id'] = '_un';
$command['from'] = array('evenements' => 'spip_evenements','L1' => 'spip_articles','L2' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array("evenements.id_evenement");
$command['select'] = array("evenements.id_evenement");
$command['orderby'] = array();
$command['join'] = array('L1' => array('evenements','id_article'), 'L2' => array('evenements','id_objet','id_evenement','L2.objet='.sql_quote('evenement')));
$command['limit'] = '';
$command['having'] =
array();
}
$command['where'] =
array(
array('REGEXP', 'evenements.statut', "'.*'"),
array('=', 'evenements.id_evenement', sql_quote(($Pile[0]['id_evenement'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')), (!is_whereable(($Pile[0]['id_article'] ?? null)) ? '' : ((is_array(($Pile[0]['id_article'] ?? null))) ? sql_in('evenements.id_article', $in) :
array('=', 'evenements.id_article', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_rubrique'] ?? null)) ? '' : ((is_array(($Pile[0]['id_rubrique'] ?? null))) ? sql_in('L1.id_rubrique', $in1) :
array('=', 'L1.id_rubrique', sql_quote(($Pile[0]['id_rubrique'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), 'JOIN-L2' =>
array('=', 'L2.objet', sql_quote('evenement')), (!is_whereable(($Pile[0]['id_mot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mot'] ?? null))) ? sql_in('L2.id_mot', $in2) :
array('=', 'L2.id_mot', sql_quote(($Pile[0]['id_mot'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_evenement_source'] ?? null)) ? '' : ((is_array(($Pile[0]['id_evenement_source'] ?? null))) ? sql_in('evenements.id_evenement_source', $in3) :
array('=', 'evenements.id_evenement_source', sql_quote(($Pile[0]['id_evenement_source'] ?? null), '','bigint(21) NOT NULL')))));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('../plugins/auto/agenda/prive/objets/liste/evenements-post.html','html_237c923fdba30994ea40a6923504c478','_un',7,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$t0 .= (
'
' .
vide($Pile['vars'][$_zzz=(string)'id_evenement'] = $Pile[$SP]['id_evenement']));
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_un @ ../plugins/auto/agenda/prive/objets/liste/evenements-post.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_debuthtml_237c923fdba30994ea40a6923504c478(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
if (!(is_array($a = (($Pile[0]['id_article'] ?? null)))))
$in[]= $a;
else $in = array_merge($in, $a);
$in1 = array();
if (!(is_array($a = (($Pile[0]['id_rubrique'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
$in2 = array();
if (!(is_array($a = (($Pile[0]['id_mot'] ?? null)))))
$in2[]= $a;
else $in2 = array_merge($in2, $a);
$in3 = array();
if (!(is_array($a = (($Pile[0]['id_evenement_source'] ?? null)))))
$in3[]= $a;
else $in3 = array_merge($in3, $a);
if (!isset($si_init)) { $command['si'] = array(); $si_init = true; }
$command['si'][] = interdire_scripts(((entites_html(table_valeur($Pile[0]??[], (string)'pagination', null),true)) ?'' :' '));
$senstri = '';
$tri = (($t=(isset($Pile[0]['tri'.'session_evenements']))?$Pile[0]['tri'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('tri'.'session_evenements'))?session_get('tri'.'session_evenements'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'date_debut'),true))))?tri_protege_champ($t):'');
if ($tri){
$senstri = ((intval($t=(isset($Pile[0]['sens'.'session_evenements']))?$Pile[0]['sens'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('sens'.'session_evenements'))?session_get('sens'.'session_evenements'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'session_evenements']))?$Pile[0]['tri'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('tri'.'session_evenements'))?session_get('tri'.'session_evenements'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'date_debut'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1);
$senstri = ($senstri<0)?' DESC':'';
};
if (!isset($command['table'])) {
$command['table'] = 'evenements';
$command['id'] = '_debut';
$command['from'] = array('evenements' => 'spip_evenements','L1' => 'spip_articles','L2' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array("evenements.id_evenement");
$command['join'] = array('L1' => array('evenements','id_article'), 'L2' => array('evenements','id_objet','id_evenement','L2.objet='.sql_quote('evenement')));
$command['limit'] = '0,1';
$command['having'] =
array();
}
$command['select'] = array("".tri_champ_select($tri)."",
"evenements.id_evenement");
$command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri), 'evenements.id_evenement');
$command['where'] =
array(
array('OR',
array('AND',
array('=', 'horaire', sql_quote('oui')),
array('>', 'evenements.date_debut', sql_quote(table_valeur($Pile["vars"]??[], (string)'date_debut', null)))),
array('AND',
array('!=', 'horaire', sql_quote('oui')),
array('>', 'evenements.date_debut', sql_quote(date('Y-m-d 23:59:59', strtotime(table_valeur($Pile["vars"]??[], (string)'date_debut', null))))))),
array('OR',
array('AND',
array('=', 'horaire', sql_quote('oui')),
array('<=', 'evenements.date_debut', sql_quote(table_valeur($Pile["vars"]??[], (string)'date_fin', null)))),
array('AND',
array('!=', 'horaire', sql_quote('oui')),
array('<=', 'evenements.date_debut', sql_quote(date('Y-m-d 23:59:59', strtotime(table_valeur($Pile["vars"]??[], (string)'date_fin', null))))))),
array('REGEXP', 'evenements.statut', "'.*'"), (!is_whereable(($Pile[0]['id_article'] ?? null)) ? '' : ((is_array(($Pile[0]['id_article'] ?? null))) ? sql_in('evenements.id_article', $in) :
array('=', 'evenements.id_article', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_rubrique'] ?? null)) ? '' : ((is_array(($Pile[0]['id_rubrique'] ?? null))) ? sql_in('L1.id_rubrique', $in1) :
array('=', 'L1.id_rubrique', sql_quote(($Pile[0]['id_rubrique'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), 'JOIN-L2' =>
array('=', 'L2.objet', sql_quote('evenement')), (!is_whereable(($Pile[0]['id_mot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mot'] ?? null))) ? sql_in('L2.id_mot', $in2) :
array('=', 'L2.id_mot', sql_quote(($Pile[0]['id_mot'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_evenement_source'] ?? null)) ? '' : ((is_array(($Pile[0]['id_evenement_source'] ?? null))) ? sql_in('evenements.id_evenement_source', $in3) :
array('=', 'evenements.id_evenement_source', sql_quote(($Pile[0]['id_evenement_source'] ?? null), '','bigint(21) NOT NULL')))));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('../plugins/auto/agenda/prive/objets/liste/evenements-post.html','html_237c923fdba30994ea40a6923504c478','_debut',17,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$t0 .= (
'
' .
vide($Pile['vars'][$_zzz=(string)'id_evenement'] = $Pile[$SP]['id_evenement']));
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_debut @ ../plugins/auto/agenda/prive/objets/liste/evenements-post.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
function BOUCLE_lasthtml_237c923fdba30994ea40a6923504c478(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
if (!(is_array($a = (($Pile[0]['id_article'] ?? null)))))
$in[]= $a;
else $in = array_merge($in, $a);
$in1 = array();
if (!(is_array($a = (($Pile[0]['id_rubrique'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
$in2 = array();
if (!(is_array($a = (($Pile[0]['id_mot'] ?? null)))))
$in2[]= $a;
else $in2 = array_merge($in2, $a);
$in3 = array();
if (!(is_array($a = (($Pile[0]['id_evenement_source'] ?? null)))))
$in3[]= $a;
else $in3 = array_merge($in3, $a);
if (!isset($si_init)) { $command['si'] = array(); $si_init = true; }
$command['si'][] = interdire_scripts(((entites_html(table_valeur($Pile[0]??[], (string)'pagination', null),true)) ?'' :' '));
$senstri = '';
$tri = (($t=(isset($Pile[0]['tri'.'session_evenements']))?$Pile[0]['tri'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('tri'.'session_evenements'))?session_get('tri'.'session_evenements'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'date_debut'),true))))?tri_protege_champ($t):'');
if ($tri){
$senstri = ((intval($t=(isset($Pile[0]['sens'.'session_evenements']))?$Pile[0]['sens'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('sens'.'session_evenements'))?session_get('sens'.'session_evenements'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'session_evenements']))?$Pile[0]['tri'.'session_evenements']:((strncmp('session_evenements','session',7)==0 AND session_get('tri'.'session_evenements'))?session_get('tri'.'session_evenements'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'date_debut'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1);
$senstri = ($senstri<0)?' DESC':'';
};
if (!isset($command['table'])) {
$command['table'] = 'evenements';
$command['id'] = '_last';
$command['from'] = array('evenements' => 'spip_evenements','L1' => 'spip_articles','L2' => 'spip_mots_liens');
$command['type'] = array();
$command['groupby'] = array("evenements.id_evenement");
$command['join'] = array('L1' => array('evenements','id_article'), 'L2' => array('evenements','id_objet','id_evenement','L2.objet='.sql_quote('evenement')));
$command['limit'] = '0,1';
$command['having'] =
array();
}
$command['select'] = array("".tri_champ_select($tri)."",
"evenements.id_evenement");
$command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri), 'evenements.id_evenement');
$command['where'] =
array(
array('OR',
array('AND',
array('=', 'horaire', sql_quote('oui')),
array('<=', 'evenements.date_debut', sql_quote(table_valeur($Pile["vars"]??[], (string)'date_fin', null)))),
array('AND',
array('!=', 'horaire', sql_quote('oui')),
array('<=', 'evenements.date_debut', sql_quote(date('Y-m-d 23:59:59', strtotime(table_valeur($Pile["vars"]??[], (string)'date_fin', null))))))),
array('REGEXP', 'evenements.statut', "'.*'"), (!is_whereable(($Pile[0]['id_article'] ?? null)) ? '' : ((is_array(($Pile[0]['id_article'] ?? null))) ? sql_in('evenements.id_article', $in) :
array('=', 'evenements.id_article', sql_quote(($Pile[0]['id_article'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_rubrique'] ?? null)) ? '' : ((is_array(($Pile[0]['id_rubrique'] ?? null))) ? sql_in('L1.id_rubrique', $in1) :
array('=', 'L1.id_rubrique', sql_quote(($Pile[0]['id_rubrique'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), 'JOIN-L2' =>
array('=', 'L2.objet', sql_quote('evenement')), (!is_whereable(($Pile[0]['id_mot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mot'] ?? null))) ? sql_in('L2.id_mot', $in2) :
array('=', 'L2.id_mot', sql_quote(($Pile[0]['id_mot'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_evenement_source'] ?? null)) ? '' : ((is_array(($Pile[0]['id_evenement_source'] ?? null))) ? sql_in('evenements.id_evenement_source', $in3) :
array('=', 'evenements.id_evenement_source', sql_quote(($Pile[0]['id_evenement_source'] ?? null), '','bigint(21) NOT NULL')))));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('../plugins/auto/agenda/prive/objets/liste/evenements-post.html','html_237c923fdba30994ea40a6923504c478','_last',20,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$t0 .= (
'
' .
vide($Pile['vars'][$_zzz=(string)'id_evenement'] = $Pile[$SP]['id_evenement']));
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_last @ ../plugins/auto/agenda/prive/objets/liste/evenements-post.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette ../plugins/auto/agenda/prive/objets/liste/evenements-post.html
// Temps de compilation total: 1.374 ms
//
function html_237c923fdba30994ea40a6923504c478($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 = (
'
' .
vide($Pile['vars'][$_zzz=(string)'date_debut'] = interdire_scripts(agenda_dateplus(affdate(entites_html(sinon(table_valeur($Pile[0]??[], (string)'date_debut', null), interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'date', null),true))),true),'Y-m-d 00:00:00'),'-1'))) .
vide($Pile['vars'][$_zzz=(string)'date_fin'] = agenda_moisdecal(table_valeur($Pile["vars"]??[], (string)'date_debut', null),'1')) .
(($t1 = BOUCLE_unhtml_237c923fdba30994ea40a6923504c478($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
$t1 :
(( '
' .
vide($Pile['vars'][$_zzz=(string)'defaut_tri'] = array('date_debut' => interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'date_sens', null), '-1'),true)), 'titre' => '1', 'id_evenement' => '1', 'points' => '-1
')) .
'
' .
(($t2 = BOUCLE_debuthtml_237c923fdba30994ea40a6923504c478($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
$t2 :
(( '
' .
BOUCLE_lasthtml_237c923fdba30994ea40a6923504c478($Cache, $Pile, $doublons, $Numrows, $SP) .
'
'))) .
'
'))) .
'
' .
recuperer_fond( 'prive/objets/liste/evenements' , array_merge($Pile[0],array('debut_liste_evt' => interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'debut_liste_evt', null), (table_valeur($Pile["vars"]??[], (string)'id_evenement', null) ? ( '@' .
table_valeur($Pile["vars"]??[], (string)'id_evenement', null)):'')),true)) ,
'id_evenement' => interdire_scripts(eval('return '.'null'.';')) )), array('compil'=>array('../plugins/auto/agenda/prive/objets/liste/evenements-post.html','html_237c923fdba30994ea40a6923504c478','',5,$GLOBALS['spip_lang'])), _request('connect') ?? '') .
'
');
return analyse_resultat_skel('html_237c923fdba30994ea40a6923504c478', $Cache, $page, '../plugins/auto/agenda/prive/objets/liste/evenements-post.html');
}