File "html_35f6b8442f6ef1fa5b4d9560712f57b6.php"
Full path: /home/argothem/www/cache/skel/log/html_35f6b8442f6ef1fa5b4d9560712f57b6.php
File size: 18.62 KB
MIME-type: text/x-php
Charset: utf-8
<?php
/*
* Squelette : ../plugins/auto/mailsubscribers/v3.5.0/prive/objets/liste/mailsubscribers.html
* Date : Tue, 28 Nov 2023 16:20:34 GMT
* Compile : Sat, 24 Feb 2024 18:30:03 GMT
* Boucles : _mailsubscribers
*/
function BOUCLE_mailsubscribershtml_35f6b8442f6ef1fa5b4d9560712f57b6(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
if (!(is_array($a = (($Pile[0]['id_mailsubscriber'] ?? null)))))
$in[]= $a;
else $in = array_merge($in, $a);
$in1 = array();
if (!(is_array($a = (($Pile[0]['id_mot'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
$in2 = array();
if (!(is_array($a = (($Pile[0]['email'] ?? null)))))
$in2[]= $a;
else $in2 = array_merge($in2, $a);
$in3 = array();
if (!(is_array($a = (($Pile[0]['id_mailsubscribinglist'] ?? null)))))
$in3[]= $a;
else $in3 = array_merge($in3, $a);
$in4 = array();
if (!(is_array($a = (($Pile[0]['id_segment'] ?? null)))))
$in4[]= $a;
else $in4 = array_merge($in4, $a);
// 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"]:"")), "mailsubscribers", "1","",array (
'criteres' =>
array (
'id_mailsubscriber' => true,
'email' => true,
'statut' => true,
),
'lien' => true,
),"id_mailsubscriber");
}
$senstri = '';
$tri = (($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):'');
if ($tri){
$senstri = ((intval($t=(isset($Pile[0]['sens'.'_mailsubscribers']))?$Pile[0]['sens'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('sens'.'_mailsubscribers'))?session_get('sens'.'_mailsubscribers'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),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_mailsubscribers']) ? $Pile[0]['debut_mailsubscribers'] : null), (($a = intval(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true)))) ? $a : 10));
if (!isset($command['table'])) {
$command['table'] = 'mailsubscribers';
$command['id'] = '_mailsubscribers';
$command['from'] = array('mailsubscribers' => 'spip_mailsubscribers','L1' => 'spip_mots_liens','L2' => 'spip_mailsubscriptions','resultats' => 'spip_resultats');
$command['type'] = array();
$command['groupby'] = array("mailsubscribers.id_mailsubscriber");
$command['join'] = array('L1' => array('mailsubscribers','id_objet','id_mailsubscriber','L1.objet='.sql_quote('mailsubscriber')), 'L2' => array('mailsubscribers','id_mailsubscriber'), 'resultats' => array('mailsubscribers','id','id_mailsubscriber'));
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("".((@$Pile[0]["id_mailsubscribinglist"] or @$Pile[0]["statut"]=='prop')?'L2.statut':'mailsubscribers.statut')." as statut_subscription",
"mailsubscribers.id_mailsubscriber",
"$rech_select",
"".tri_champ_select($tri)."",
"mailsubscribers.email",
"mailsubscribers.statut",
"mailsubscribers.email AS titre_rang",
"mailsubscribers.date");
$command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri), 'mailsubscribers.email');
$command['where'] =
array((!is_whereable(($Pile[0]['id_mailsubscriber'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mailsubscriber'] ?? null))) ? sql_in('mailsubscribers.id_mailsubscriber', $in) :
array('=', 'mailsubscribers.id_mailsubscriber', sql_quote(($Pile[0]['id_mailsubscriber'] ?? null), '','bigint(21) NOT NULL AUTO_INCREMENT')))), 'JOIN-L1' =>
array('=', 'L1.objet', sql_quote('mailsubscriber')), (!is_whereable(($Pile[0]['id_mot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mot'] ?? null))) ? sql_in('L1.id_mot', $in1) :
array('=', 'L1.id_mot', sql_quote(($Pile[0]['id_mot'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (($zzw = spip_sanitize_from_request(@$Pile[0]["where"],"where","vide")) ? $zzw : ''), (!is_whereable(($Pile[0]['email'] ?? null)) ? '' : ((is_array(($Pile[0]['email'] ?? null))) ? sql_in('mailsubscribers.email', $in2) :
array('=', 'mailsubscribers.email', sql_quote(($Pile[0]['email'] ?? null), '','varchar(255) NOT NULL DEFAULT \'\'')))), (!is_whereable(($Pile[0]['id_mailsubscribinglist'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mailsubscribinglist'] ?? null))) ? sql_in('L2.id_mailsubscribinglist', $in3) :
array('=', 'L2.id_mailsubscribinglist', sql_quote(($Pile[0]['id_mailsubscribinglist'] ?? null), '','bigint(21) NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['id_segment'] ?? null)) ? '' : ((is_array(($Pile[0]['id_segment'] ?? null))) ? sql_in('L2.id_segment', $in4) :
array('=', 'L2.id_segment', sql_quote(($Pile[0]['id_segment'] ?? null), '','smallint(6) NOT NULL DEFAULT \'0\'')))), ((!@$Pile[0]["statut"] or !in_array(@$Pile[0]["statut"],array('all','poubelle')))?((@$Pile[0]["id_mailsubscribinglist"] or @$Pile[0]["statut"]=='prop')?'L2.statut':'mailsubscribers.statut').'!='.sql_quote('poubelle'):'1=1'), ((@$Pile[0]["statut"] and @$Pile[0]["statut"]!=='all')?((@$Pile[0]["id_mailsubscribinglist"] or @$Pile[0]["statut"]=='prop')?'L2.statut':'mailsubscribers.statut').'='.sql_quote(@$Pile[0]["statut"]):'1=1'), $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/mailsubscribers/v3.5.0/prive/objets/liste/mailsubscribers.html','html_35f6b8442f6ef1fa5b4d9560712f57b6','_mailsubscribers',22,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_mailsubscribers']['compteur_boucle'] = 0;
$Numrows['_mailsubscribers']['command'] = $command;
$Numrows['_mailsubscribers']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_mailsubscribers']) ? $Pile[0]['debut_mailsubscribers'] : _request('debut_mailsubscribers');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_mailsubscribers'] = quete_debut_pagination('id_mailsubscriber',$Pile[0]['@id_mailsubscriber'] = substr($debut_boucle,1),(($a = intval(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['_mailsubscribers']['total']-1)/((($a = intval(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true)))) ? $a : 10)))*((($a = intval(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['_mailsubscribers']['total'] : $debut_boucle+(($a = intval(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true)))) ? $a : 10) - 1), $Numrows['_mailsubscribers']['total'] - 1);
$Numrows['_mailsubscribers']['grand_total'] = $Numrows['_mailsubscribers']['total'];
$Numrows['_mailsubscribers']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_mailsubscribers']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_mailsubscribers']['compteur_boucle'] = $debut_boucle;
$l1 = _T('public|spip|ecrire:info_numero_abbreviation');$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_mailsubscribers']['compteur_boucle']++;
if ($Numrows['_mailsubscribers']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_mailsubscribers']['compteur_boucle']-1 > $fin_boucle) break;
$t0 .= (
'
<tr class=\'' .
alterner(($Numrows['_mailsubscribers']['compteur_boucle'] ?? 0),'row_odd','row_even') .
'\'>
<td class=\'picto\'>' .
filtre_balise_img_dist(chemin_image((string)'mailsubscriber-16.png')) .
'</td>
<td class=\'statut\'>' .
interdire_scripts((entites_html(table_valeur($Pile[0]??[], (string)'id_mailsubscribinglist', null),true) ? filtre_puce_statut_dist($Pile[$SP]['statut_subscription'],'mailsubscriber'):interdire_scripts(filtre_puce_statut_dist($Pile[$SP]['statut'],'mailsubscriber',$Pile[$SP]['id_mailsubscriber'])))) .
'</td>
<td class=\'email principale\'>' .
filtrer('image_graver',filtrer('image_reduire',quete_html_logo(quete_logo('id_mailsubscriber', 'ON', $Pile[$SP]['id_mailsubscriber'], ''), '', ''),'20','26')) .
'<a href="' .
parametre_url(generer_url_entite($Pile[$SP]['id_mailsubscriber'],'mailsubscriber'),'email',interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'email', null),true))) .
'" title="' .
attribut_html($l1) .
' ' .
$Pile[$SP]['id_mailsubscriber'] .
'">' .
(($t1 = strval(calculer_rang_smart($Pile[$SP]['titre_rang'], 'mailsubscriber', $Pile[$SP]['id_mailsubscriber'], $Pile[0])))!=='' ?
($t1 . '. ') :
'') .
interdire_scripts($Pile[$SP]['email']) .
'</a></td>
<td class=\'date secondaire\'>' .
interdire_scripts(affdate_jourcourt(normaliser_date($Pile[$SP]['date']))) .
'</td>
<td class=\'id\'>' .
invalideur_session($Cache, (((function_exists("autoriser")||include_spip("inc/autoriser"))&&autoriser('modifier', 'mailsubscriber', invalideur_session($Cache, $Pile[$SP]['id_mailsubscriber']))?" ":"") ? ( '<a href="' .
invalideur_session($Cache, generer_url_ecrire('mailsubscriber_edit',( 'id_mailsubscriber=' .
invalideur_session($Cache, $Pile[$SP]['id_mailsubscriber'])))) .
'">' .
invalideur_session($Cache, $Pile[$SP]['id_mailsubscriber']) .
'</a>'):( invalideur_session($Cache, $Pile[$SP]['id_mailsubscriber']) .
'
'))) .
'</td>
</tr>
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_mailsubscribers @ ../plugins/auto/mailsubscribers/v3.5.0/prive/objets/liste/mailsubscribers.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette ../plugins/auto/mailsubscribers/v3.5.0/prive/objets/liste/mailsubscribers.html
// Temps de compilation total: 10.166 ms
//
function html_35f6b8442f6ef1fa5b4d9560712f57b6($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)'defaut_tri'] = array('email' => '1', 'date' => '-1', 'id_mailsubscriber' => '1', 'points' => '-1
')) .
(($t1 = BOUCLE_mailsubscribershtml_35f6b8442f6ef1fa5b4d9560712f57b6($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
' .
filtre_pagination_dist($Numrows["_mailsubscribers"]["grand_total"],
'_mailsubscribers',
isset($Pile[0]['debut_mailsubscribers'])?$Pile[0]['debut_mailsubscribers']:intval(_request('debut_mailsubscribers')),
(($a = intval(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true)))) ? $a : 10), false, '', '', array()) .
'
' .
(($t3 = strval(interdire_scripts(table_valeur($Pile[0]??[], (string)'titre_liste', null))))!=='' ?
('<h3>' . $t3 . '</h3>') :
'') .
'
<div class="liste-objets mailsubscribers">
<table class=\'spip liste\'>
' .
(($t3 = strval(interdire_scripts(sinon(table_valeur($Pile[0]??[], (string)'titre', null), singulier_ou_pluriel(($Numrows['_mailsubscribers']['grand_total'] ?? $Numrows['_mailsubscribers']['total'] ?? 0),'mailsubscriber:info_1_mailsubscriber','mailsubscriber:info_nb_mailsubscribers')))))!=='' ?
('<caption><strong class="caption">' . $t3 . '</strong></caption>') :
'') .
'
<thead>
<tr class=\'first_row\'>
<th class=\'picto\' scope=\'col\'></th>
<th class=\'statut\' scope=\'col\'>' .
calculer_balise_tri('statut', ( '<span title="' .
attribut_html(_T('public|spip|ecrire:lien_trier_statut')) .
'">#</span>'), 'ajax', '_mailsubscribers', (($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailsubscribers']))?$Pile[0]['sens'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('sens'.'_mailsubscribers'))?session_get('sens'.'_mailsubscribers'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)) .
'</th>
<th class=\'email\' scope=\'col\'>' .
calculer_balise_tri('num email', _T('mailsubscriber:label_email'), 'ajax', '_mailsubscribers', (($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailsubscribers']))?$Pile[0]['sens'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('sens'.'_mailsubscribers'))?session_get('sens'.'_mailsubscribers'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)) .
'</th>
<th class=\'date\' scope=\'col\'>' .
calculer_balise_tri('date', _T('public|spip|ecrire:date'), 'ajax', '_mailsubscribers', (($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailsubscribers']))?$Pile[0]['sens'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('sens'.'_mailsubscribers'))?session_get('sens'.'_mailsubscribers'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)) .
'</th>
<th class=\'id\' scope=\'col\'>' .
calculer_balise_tri('id_mailsubscriber', _T('public|spip|ecrire:info_numero_abbreviation'), 'ajax', '_mailsubscribers', (($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailsubscribers']))?$Pile[0]['sens'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('sens'.'_mailsubscribers'))?session_get('sens'.'_mailsubscribers'):(is_array($s=table_valeur($Pile["vars"]??[], (string)'defaut_tri', null))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailsubscribers']))?$Pile[0]['tri'.'_mailsubscribers']:((strncmp('_mailsubscribers','session',7)==0 AND session_get('tri'.'_mailsubscribers'))?session_get('tri'.'_mailsubscribers'):interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'num email'),true))))?tri_protege_champ($t):'')])?$s[$st]:reset($s)):$s)))==-1 OR $t=='inverse')?-1:1), table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)) .
'</th>
</tr>
</thead>
<tbody>
') . $t1 . ( '
</tbody>
</table>
' .
(($t3 = strval(filtre_pagination_dist($Numrows["_mailsubscribers"]["grand_total"],
'_mailsubscribers',
isset($Pile[0]['debut_mailsubscribers'])?$Pile[0]['debut_mailsubscribers']:intval(_request('debut_mailsubscribers')),
(($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(interdire_scripts(sinon(table_valeur($Pile[0]??[], (string)'sinon', null), ''))))!=='' ?
(( '
' .
(($t3 = strval(interdire_scripts(table_valeur($Pile[0]??[], (string)'titre_liste', null))))!=='' ?
('<h3>' . $t3 . '</h3>') :
'') .
'
<div class="liste-objets mailsubscribers caption-wrap"><strong class="caption">') . $t2 . '</strong></div>
') :
''))) .
'
');
return analyse_resultat_skel('html_35f6b8442f6ef1fa5b4d9560712f57b6', $Cache, $page, '../plugins/auto/mailsubscribers/v3.5.0/prive/objets/liste/mailsubscribers.html');
}