Volkan FileManager

Back Back Up Advanced Editor

<?php

/*
 * Squelette : ../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html
 * Date :      Sat, 06 Dec 2025 00:47:06 GMT
 * Compile :   Wed, 26 Aug 2026 18:19:00 GMT
 * Boucles :   _contenus, _liste_selections
 */

function BOUCLE_contenushtml_c73d88e3cebf83a32019b56b6363204f(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	if (!isset($command['table'])) {
		$command['table'] = 'selections_contenus';
		$command['id'] = '_contenus';
		$command['from'] = array('selections_contenus' => 'spip_selections_contenus');
		$command['type'] = array();
		$command['groupby'] = array();
		$command['select'] = array("count(*)");
		$command['orderby'] = array();
		$command['join'] = array();
		$command['limit'] = '';
		$command['having'] = 
			array();
	}
	$command['where'] = 
			array(
			array('=', 'selections_contenus.id_selection', sql_quote($Pile[$SP]['id_selection'], '','bigint NOT NULL DEFAULT \'0\'')));
	if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
	$t0 = "";
	// REQUETE
	$iter = Spip\Compilateur\Iterateur\Factory::create(
		"SQL",
		$command,
		array('../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html','html_c73d88e3cebf83a32019b56b6363204f','_contenus',30,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	$Numrows['_contenus']['command'] = $command;
	$Numrows['_contenus']['total'] = @intval($iter->count());
	$SP++;
	// RESULTATS
	
	$t0 = str_repeat(' ', $Numrows['_contenus']['total']);
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_contenus @ ../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

function BOUCLE_liste_selectionshtml_c73d88e3cebf83a32019b56b6363204f(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {

static $command = array();
	static $connect;
	$command['connect'] = $connect = '';
	// RECHERCHE
	if (!strlen((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")))){
		list($rech_select, $rech_where) = array("0 as points","");
	} else
	{
		$prepare_recherche = charger_fonction('prepare_recherche', 'inc');
		list($rech_select, $rech_where) = $prepare_recherche((isset($Pile[0]["recherche"])?$Pile[0]["recherche"]:(isset($GLOBALS["recherche"])?$GLOBALS["recherche"]:"")), "selections", "1","",array (
),"id_selection");
	}
	
	$senstri = '';
	$tri = (($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):'');
	if ($tri){
		$senstri = ((intval($t=(isset($Pile[0]['sens'.'_liste_selections']))?$Pile[0]['sens'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('sens'.'_liste_selections'))?session_get('sens'.'_liste_selections'):(is_array($s=retablir_echappements_modeles(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1);
		$senstri = ($senstri<0)?' DESC':'';
	};
	
	$command['pagination'] = array((isset($Pile[0]['debut_liste_selections']) ? $Pile[0]['debut_liste_selections'] : null), (($a = intval(retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10));
	if (!isset($command['table'])) {
		$command['table'] = 'selections';
		$command['id'] = '_liste_selections';
		$command['from'] = array('selections' => 'spip_selections','resultats' => 'spip_resultats','L1' => 'spip_selections_liens');
		$command['type'] = array();
		$command['groupby'] = array("selections.id_selection");
		$command['join'] = array('resultats' => array('selections','id','id_selection'), 'L1' => array('selections','id_selection'));
		$command['limit'] = '';
		$command['having'] = 
			array();
	}
	$command['select'] = array("selections.id_selection",
		"$rech_select",
		"".tri_champ_select($tri)."",
		"L1.id_objet",
		"L1.objet",
		"selections.titre AS titre_rang",
		"selections.titre",
		"selections.limite");
	$command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri), 'L1.id_objet');
	$command['where'] = 
			array('selections.id_selection  IN (SELECT * FROM(
SELECT DISTINCT id_selection
FROM spip_selections_liens as oooo) AS subquery)', (($zzw = spip_sanitize_from_request(@$Pile[0]["where"],"where","vide")) ? $zzw : ''), $rech_where?$rech_where:'');
	if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
	$t0 = "";
	// REQUETE
	$iter = Spip\Compilateur\Iterateur\Factory::create(
		"SQL",
		$command,
		array('../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html','html_c73d88e3cebf83a32019b56b6363204f','_liste_selections',26,$GLOBALS['spip_lang'])
	);
	if (!$iter->err()) {
	
	// COMPTEUR
	$Numrows['_liste_selections']['compteur_boucle'] = 0;
	$Numrows['_liste_selections']['command'] = $command;
	$Numrows['_liste_selections']['total'] = @intval($iter->count());
	$debut_boucle = isset($Pile[0]['debut_liste_selections']) ? $Pile[0]['debut_liste_selections'] : _request('debut_liste_selections');
	if ($debut_boucle && $debut_boucle[0] === '@') {
		$debut_boucle = $Pile[0]['debut_liste_selections'] = quete_debut_pagination('id_selection',$Pile[0]['@id_selection'] = substr($debut_boucle,1),(($a = intval(retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10),$iter);
		$iter->seek(0);
	}
	$debut_boucle = intval($debut_boucle);
	$debut_boucle = (($tout=($debut_boucle == -1))?0:($debut_boucle));
	$debut_boucle = max(0,min($debut_boucle,floor(($Numrows['_liste_selections']['total']-1)/((($a = intval(retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10)))*((($a = intval(retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10))));
	$debut_boucle = intval($debut_boucle);
	$fin_boucle = min(($tout ? $Numrows['_liste_selections']['total'] : $debut_boucle+(($a = intval(retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10) - 1), $Numrows['_liste_selections']['total'] - 1);
	$Numrows['_liste_selections']['grand_total'] = $Numrows['_liste_selections']['total'];
	$Numrows['_liste_selections']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
	if ($debut_boucle>0 AND $debut_boucle < $Numrows['_liste_selections']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
		$Numrows['_liste_selections']['compteur_boucle'] = $debut_boucle;
	
	
	$l1 = _T('public|spip|ecrire:info_numero_abbreviation');$SP++;
	// RESULTATS
	while ($Pile[$SP]=$iter->fetch()) {

$Numrows['_liste_selections']['compteur_boucle']++;
		if ($Numrows['_liste_selections']['compteur_boucle'] <= $debut_boucle) continue;
		if ($Numrows['_liste_selections']['compteur_boucle']-1 > $fin_boucle) break;
		$t0 .= (
'
		<tr class=\'' .
retablir_echappements_modeles(alterner(($Numrows['_liste_selections']['compteur_boucle'] ?? 0),'row_odd','row_even')) .
'\'>
			<td class=\'titre principale\'><a href="' .
retablir_echappements_modeles(generer_objet_url($Pile[$SP]['id_objet'],(interdire_scripts($Pile[$SP]['objet'])))) .
'">' .
retablir_echappements_modeles(interdire_scripts(generer_objet_info(($Pile[$SP]['id_objet']), (interdire_scripts($Pile[$SP]['objet'])), 'titre', '', []))) .
' (' .
retablir_echappements_modeles(interdire_scripts(_T(objet_info($Pile[$SP]['objet'],'texte_objet')))) .
')</a></td>
			<td class=\'titre principale\'><a href="' .
retablir_echappements_modeles(generer_objet_url($Pile[$SP]['id_selection'],'selection')) .
'" title="' .
attribut_html($l1) .
' ' .
retablir_echappements_modeles($Pile[$SP]['id_selection']) .
'">' .
(($t1 = strval(retablir_echappements_modeles(calculer_rang_smart($Pile[$SP]['titre_rang'], 'selection', $Pile[$SP]['id_selection'], $Pile[0]))))!=='' ?
		($t1 . '. ') :
		'') .
retablir_echappements_modeles(interdire_scripts(titres_typographies_supprimer_liens(trim(PtoBR(propre(supprimer_numero($Pile[$SP]['titre']), $connect, $Pile[0])))))) .
'</a></td>
			<td class=\'nb_contenus id\'>' .
(($t1 = BOUCLE_contenushtml_c73d88e3cebf83a32019b56b6363204f($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		($t1 . retablir_echappements_modeles(($Numrows['_contenus']['total'] ?? 0))) :
		('0')) .
(($t1 = strval(retablir_echappements_modeles(interdire_scripts(((($Pile[$SP]['limite'] > '0')) ?' ' :'')))))!=='' ?
		((	'/' .
	retablir_echappements_modeles(interdire_scripts($Pile[$SP]['limite']))) . $t1) :
		'') .
'</td>
			<td class=\'id\'>' .
retablir_echappements_modeles(invalideur_session($Cache, (((function_exists("autoriser")||include_spip("inc/autoriser"))&&autoriser('modifier', 'selection', (invalideur_session($Cache, $Pile[$SP]['id_selection'])))?" ":"") ? (	'<a href="' .
	(invalideur_session($Cache, generer_url_ecrire('selection_edit',(	'id_selection=' .
		(invalideur_session($Cache, $Pile[$SP]['id_selection'])))))) .
	'">' .
	(invalideur_session($Cache, $Pile[$SP]['id_selection'])) .
	'</a>'):(	(invalideur_session($Cache, $Pile[$SP]['id_selection'])) .
	'
			')))) .
'</td>
		</tr>
	');
	}
	$iter->free();
	}
	if (defined("_BOUCLE_PROFILER")
	AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
		spip_log(intval(1000*$timer)."ms BOUCLE_liste_selections @ ../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html","profiler"._LOG_AVERTISSEMENT);
	return $t0;
}

//
// Fonction principale du squelette ../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html
// Temps de compilation total: 6.015 ms
//

function html_c73d88e3cebf83a32019b56b6363204f($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 = (
(($t1 = strval(retablir_echappements_modeles('')))!=='' ?
		($t1 . '

Liste des sélections liées à au moins un objet

') :
		'') .
retablir_echappements_modeles(vide($Pile['vars'][$_zzz=(string)'defaut_tri'] = (array('titre' => '1', 'id_selection' => '1', 'points' => '-1', 'id_objet' => '1', 'objet' => '1')))) .
'
' .
(($t1 = BOUCLE_liste_selectionshtml_c73d88e3cebf83a32019b56b6363204f($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
		((	'
' .
		retablir_echappements_modeles(filtre_pagination_dist($Numrows["_liste_selections"]["grand_total"],
 		'_liste_selections',
		isset($Pile[0]['debut_liste_selections'])?$Pile[0]['debut_liste_selections']:intval(_request('debut_liste_selections')),
		(($a = intval((interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10), false, '', '', array())) .
		'
<div class="liste-objets selections">
<table class=\'spip liste\'>
	' .
		(($t3 = strval(retablir_echappements_modeles(interdire_scripts(sinon(table_valeur($Pile[0]??[], (string)'titre', null), (singulier_ou_pluriel(($Numrows['_liste_selections']['grand_total'] ?? $Numrows['_liste_selections']['total'] ?? 0),'selection:info_1_selection','selection:info_nb_selections')))))))!=='' ?
				('<caption><strong class="caption">' . $t3 . '</strong></caption>') :
				'') .
		'
	<thead>
		<tr class=\'first_row\'>
			<th class=\'titre\' scope=\'col\'>' .
		retablir_echappements_modeles(calculer_balise_tri('objet', _T('public|spip|ecrire:onglet_contenu'), 'ajax', '_liste_selections', (($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_liste_selections']))?$Pile[0]['sens'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('sens'.'_liste_selections'))?session_get('sens'.'_liste_selections'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), (table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)), '_liste_selections')) .
		'</th>
			<th class=\'titre\' scope=\'col\'>' .
		retablir_echappements_modeles(calculer_balise_tri('titre', _T('selection:champ_titre_label'), 'ajax', '_liste_selections', (($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_liste_selections']))?$Pile[0]['sens'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('sens'.'_liste_selections'))?session_get('sens'.'_liste_selections'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), (table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)), '_liste_selections')) .
		'</th>
			<th class=\'nb_contenus\' scope=\'col\'>' .
		_T('selection:champ_nombre_contenus') .
		'</th>
			<th class=\'id\' scope=\'col\'>' .
		retablir_echappements_modeles(calculer_balise_tri('id_selection', _T('public|spip|ecrire:info_numero_abbreviation'), 'ajax', '_liste_selections', (($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_liste_selections']))?$Pile[0]['sens'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('sens'.'_liste_selections'))?session_get('sens'.'_liste_selections'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_liste_selections']))?$Pile[0]['tri'.'_liste_selections']:((strncmp('_liste_selections','session',7)==0 AND session_get('tri'.'_liste_selections'))?session_get('tri'.'_liste_selections'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num titre'),true)))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), (table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)), '_liste_selections')) .
		'</th>
		</tr>
	</thead>
	<tbody>
	') . $t1 . (	'
	</tbody>
</table>
' .
		(($t3 = strval(retablir_echappements_modeles(filtre_pagination_dist($Numrows["_liste_selections"]["grand_total"],
 		'_liste_selections',
		isset($Pile[0]['debut_liste_selections'])?$Pile[0]['debut_liste_selections']:intval(_request('debut_liste_selections')),
		(($a = intval((interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10), true, 'prive', '', array()))))!=='' ?
				('<nav class=\'pagination\'>' . $t3 . '</nav>') :
				'') .
		'
</div>
')) :
		((($t2 = strval(retablir_echappements_modeles(interdire_scripts(sinon(table_valeur($Pile[0]??[], (string)'sinon', null), '')))))!=='' ?
			('
<div class="liste-objets selections caption-wrap"><strong class="caption">' . $t2 . '</strong></div>
') :
			''))) .
'
');

return analyse_resultat_skel('html_c73d88e3cebf83a32019b56b6363204f', $Cache, $page, '../plugins/auto/selections_editoriales-3.1.1/prive/objets/liste/selections_objets.html');
}