File "html_113b4228b5103e37d89109783abb5e44.php"
Full path: /home/argothem/www/organecyberpresse/tmp/cache/skel/html_113b4228b5103e37d89109783abb5e44.php
File size: 16.02 KB
MIME-type: text/x-php
Charset: utf-8
<?php
/*
* Squelette : ../plugins/auto/mailshot/v4.0.1/prive/objets/liste/mailshots_destinataires.html
* Date : Wed, 23 Jul 2025 08:34:50 GMT
* Compile : Mon, 25 Aug 2025 15:24:16 GMT
* Boucles : _mailshot_dest
*/
function BOUCLE_mailshot_desthtml_113b4228b5103e37d89109783abb5e44(&$Cache, &$Pile, &$doublons, &$Numrows, $SP) {
static $command = array();
static $connect;
$command['connect'] = $connect = '';
$in = array();
if (!(is_array($a = (($Pile[0]['id_mailshot'] ?? null)))))
$in[]= $a;
else $in = array_merge($in, $a);
$in1 = array();
if (!(is_array($a = (($Pile[0]['email'] ?? null)))))
$in1[]= $a;
else $in1 = array_merge($in1, $a);
$in2 = array();
if (!(is_array($a = (($Pile[0]['statut'] ?? null)))))
$in2[]= $a;
else $in2 = array_merge($in2, $a);
$senstri = '';
$tri = (($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'email'),true)))))?tri_protege_champ($t):'');
if ($tri){
$senstri = ((intval($t=(isset($Pile[0]['sens'.'_mailshot_dest']))?$Pile[0]['sens'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('sens'.'_mailshot_dest'))?session_get('sens'.'_mailshot_dest'):(is_array($s=retablir_echappements_modeles(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):retablir_echappements_modeles(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), '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_mailshot_dest']) ? $Pile[0]['debut_mailshot_dest'] : 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'] = 'mailshots_destinataires';
$command['id'] = '_mailshot_dest';
$command['from'] = array('mailshots_destinataires' => 'spip_mailshots_destinataires');
$command['type'] = array();
$command['groupby'] = array();
$command['join'] = array();
$command['limit'] = '';
$command['having'] =
array();
}
$command['select'] = array("".tri_champ_select($tri)."",
"mailshots_destinataires.id_mailshot",
"mailshots_destinataires.email",
"mailshots_destinataires.date",
"mailshots_destinataires.statut");
$command['orderby'] = array(tri_champ_order($tri,$command['from'],$senstri));
$command['where'] =
array((!is_whereable(($Pile[0]['id_mailshot'] ?? null)) ? '' : ((is_array(($Pile[0]['id_mailshot'] ?? null))) ? sql_in('mailshots_destinataires.id_mailshot', $in) :
array('=', 'mailshots_destinataires.id_mailshot', sql_quote(($Pile[0]['id_mailshot'] ?? null), '','bigint NOT NULL DEFAULT \'0\'')))), (!is_whereable(($Pile[0]['email'] ?? null)) ? '' : ((is_array(($Pile[0]['email'] ?? null))) ? sql_in('mailshots_destinataires.email', $in1) :
array('=', 'mailshots_destinataires.email', sql_quote(($Pile[0]['email'] ?? null), '','varchar(255) NOT NULL DEFAULT \'\'')))), (($zzw = spip_sanitize_from_request(@$Pile[0]["where"],"where","vide")) ? $zzw : ''), (!is_whereable(($Pile[0]['statut'] ?? null)) ? '' : ((is_array(($Pile[0]['statut'] ?? null))) ? sql_in('mailshots_destinataires.statut', $in2) :
array('=', 'mailshots_destinataires.statut', sql_quote(($Pile[0]['statut'] ?? null), '','char(4) NOT NULL DEFAULT \'todo\'')))),
array('LIKE', 'mailshots_destinataires.email', sql_quote(retablir_echappements_modeles(table_valeur($Pile["vars"]??[], (string)'recherche', null)), '', 'char')));
if (defined("_BOUCLE_PROFILER")) $timer = time()+(float)microtime();
$t0 = "";
// REQUETE
$iter = Spip\Compilateur\Iterateur\Factory::create(
"SQL",
$command,
array('../plugins/auto/mailshot/v4.0.1/prive/objets/liste/mailshots_destinataires.html','html_113b4228b5103e37d89109783abb5e44','_mailshot_dest',21,$GLOBALS['spip_lang'])
);
if (!$iter->err()) {
// COMPTEUR
$Numrows['_mailshot_dest']['compteur_boucle'] = 0;
$Numrows['_mailshot_dest']['command'] = $command;
$Numrows['_mailshot_dest']['total'] = @intval($iter->count());
$debut_boucle = isset($Pile[0]['debut_mailshot_dest']) ? $Pile[0]['debut_mailshot_dest'] : _request('debut_mailshot_dest');
if ($debut_boucle && $debut_boucle[0] === '@') {
$debut_boucle = $Pile[0]['debut_mailshot_dest'] = quete_debut_pagination('id_mailshot,email',$Pile[0]['@id_mailshot,email'] = 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['_mailshot_dest']['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['_mailshot_dest']['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['_mailshot_dest']['total'] - 1);
$Numrows['_mailshot_dest']['grand_total'] = $Numrows['_mailshot_dest']['total'];
$Numrows['_mailshot_dest']["total"] = max(0,$fin_boucle - $debut_boucle + 1);
if ($debut_boucle>0 AND $debut_boucle < $Numrows['_mailshot_dest']['grand_total'] AND $iter->seek($debut_boucle,'continue'))
$Numrows['_mailshot_dest']['compteur_boucle'] = $debut_boucle;
$SP++;
// RESULTATS
while ($Pile[$SP]=$iter->fetch()) {
$Numrows['_mailshot_dest']['compteur_boucle']++;
if ($Numrows['_mailshot_dest']['compteur_boucle'] <= $debut_boucle) continue;
if ($Numrows['_mailshot_dest']['compteur_boucle']-1 > $fin_boucle) break;
$t0 .= (
'
<tr class=\'' .
retablir_echappements_modeles(alterner(($Numrows['_mailshot_dest']['compteur_boucle'] ?? 0),'row_odd','row_even')) .
'\'>
<td class=\'id_mailshot\'><a href="' .
retablir_echappements_modeles(generer_url_entite($Pile[$SP]['id_mailshot'],'mailshot')) .
'">' .
retablir_echappements_modeles($Pile[$SP]['id_mailshot']) .
'</a></td>
<td class=\'email\'>' .
retablir_echappements_modeles(interdire_scripts(mailshot_link_admin_email($Pile[$SP]['email']))) .
'</td>
<td class=\'date secondaire\'>' .
retablir_echappements_modeles(interdire_scripts(affdate_heure(normaliser_date($Pile[$SP]['date'])))) .
'</td>
<td class=\'statut\'>' .
retablir_echappements_modeles(_T(concat('mailshot:info_statut_destinataire_',(interdire_scripts($Pile[$SP]['statut']))))) .
'</td>
</tr>
' .
(($t1 = strval(retablir_echappements_modeles(interdire_scripts(((($Pile[$SP]['statut'] == 'processing')) ?' ' :'')))))!=='' ?
($t1 . retablir_echappements_modeles(vide($Pile['vars'][$_zzz=(string)'autoreload'] = ' '))) :
'') .
'
');
}
$iter->free();
}
if (defined("_BOUCLE_PROFILER")
AND 1000*($timer = (time()+(float)microtime())-$timer) > _BOUCLE_PROFILER)
spip_log(intval(1000*$timer)."ms BOUCLE_mailshot_dest @ ../plugins/auto/mailshot/v4.0.1/prive/objets/liste/mailshots_destinataires.html","profiler"._LOG_AVERTISSEMENT);
return $t0;
}
//
// Fonction principale du squelette ../plugins/auto/mailshot/v4.0.1/prive/objets/liste/mailshots_destinataires.html
// Temps de compilation total: 7.057 ms
//
function html_113b4228b5103e37d89109783abb5e44($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 = (
retablir_echappements_modeles(vide($Pile['vars'][$_zzz=(string)'defaut_tri'] = (array('id_mailshot' => '-1', 'email' => '1', 'date' => '-1', 'points' => '-1
')))) .
retablir_echappements_modeles(vide($Pile['vars'][$_zzz=(string)'autoreload'] = '')) .
retablir_echappements_modeles(vide($Pile['vars'][$_zzz=(string)'recherche'] = (interdire_scripts((entites_html(table_valeur($Pile[0]??[], (string)'recherche', null),true) ? (($t3 = strval((interdire_scripts(entites_html(table_valeur($Pile[0]??[], (string)'recherche', null),true)))))!=='' ?
('%' . $t3 . '%') :
''):'%'))))) .
(($t1 = BOUCLE_mailshot_desthtml_113b4228b5103e37d89109783abb5e44($Cache, $Pile, $doublons, $Numrows, $SP))!=='' ?
(( '
' .
retablir_echappements_modeles(filtre_pagination_dist($Numrows["_mailshot_dest"]["grand_total"],
'_mailshot_dest',
isset($Pile[0]['debut_mailshot_dest'])?$Pile[0]['debut_mailshot_dest']:intval(_request('debut_mailshot_dest')),
(($a = intval((interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'nb', null), '10'),true))))) ? $a : 10), false, '', '', array())) .
'
' .
(($t3 = strval(retablir_echappements_modeles(interdire_scripts(table_valeur($Pile[0]??[], (string)'titre_liste', null)))))!=='' ?
('<h3>' . $t3 . '</h3>') :
'') .
'
<div class="liste-objets mailshots_destinataires">
<table class=\'spip liste\'>
' .
(($t3 = strval(retablir_echappements_modeles(interdire_scripts(sinon(table_valeur($Pile[0]??[], (string)'titre', null), (singulier_ou_pluriel(($Numrows['_mailshot_dest']['grand_total'] ?? $Numrows['_mailshot_dest']['total'] ?? 0),'mailshot:info_1_mailshot_destinataire','mailshot:info_nb_mailshots_destinataires')))))))!=='' ?
('<caption><strong class="caption">' . $t3 . '</strong></caption>') :
'') .
'
<thead>
<tr class=\'first_row\'>
<th class=\'id_mailshot\' scope=\'col\'>' .
retablir_echappements_modeles(calculer_balise_tri('id_mailshot', _T('public|spip|ecrire:info_numero_abbreviation'), 'ajax', '_mailshot_dest', (($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'email'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailshot_dest']))?$Pile[0]['sens'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('sens'.'_mailshot_dest'))?session_get('sens'.'_mailshot_dest'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), '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)), '_mailshot_dest')) .
'</th>
<th class=\'email\' scope=\'col\'>' .
retablir_echappements_modeles(calculer_balise_tri('email', _T('public|spip|ecrire:email'), 'ajax', '_mailshot_dest', (($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'email'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailshot_dest']))?$Pile[0]['sens'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('sens'.'_mailshot_dest'))?session_get('sens'.'_mailshot_dest'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), '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)), '_mailshot_dest')) .
'</th>
<th class=\'date\' scope=\'col\'>' .
retablir_echappements_modeles(calculer_balise_tri('date', _T('public|spip|ecrire:date'), 'ajax', '_mailshot_dest', (($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'email'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailshot_dest']))?$Pile[0]['sens'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('sens'.'_mailshot_dest'))?session_get('sens'.'_mailshot_dest'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), '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)), '_mailshot_dest')) .
'</th>
<th class=\'statut\' scope=\'col\'>' .
retablir_echappements_modeles(calculer_balise_tri('statut', ( '<span title="' .
attribut_html(_T('public|spip|ecrire:lien_trier_statut')) .
'">#</span>'), 'ajax', '_mailshot_dest', (($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), 'email'),true)))))?tri_protege_champ($t):''), ((intval($t=(isset($Pile[0]['sens'.'_mailshot_dest']))?$Pile[0]['sens'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('sens'.'_mailshot_dest'))?session_get('sens'.'_mailshot_dest'):(is_array($s=(table_valeur($Pile["vars"]??[], (string)'defaut_tri', null)))?(isset($s[$st=(($t=(isset($Pile[0]['tri'.'_mailshot_dest']))?$Pile[0]['tri'.'_mailshot_dest']:((strncmp('_mailshot_dest','session',7)==0 AND session_get('tri'.'_mailshot_dest'))?session_get('tri'.'_mailshot_dest'):(interdire_scripts(entites_html(sinon(table_valeur($Pile[0]??[], (string)'par', null), '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)), '_mailshot_dest')) .
'</th>
</tr>
</thead>
<tbody>
') . $t1 . ( '
</tbody>
</table>
' .
(($t3 = strval(retablir_echappements_modeles(filtre_pagination_dist($Numrows["_mailshot_dest"]["grand_total"],
'_mailshot_dest',
isset($Pile[0]['debut_mailshot_dest'])?$Pile[0]['debut_mailshot_dest']:intval(_request('debut_mailshot_dest')),
(($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 mailshot caption-wrap"><strong class="caption">' . $t2 . '</strong></div>
') :
''))));
return analyse_resultat_skel('html_113b4228b5103e37d89109783abb5e44', $Cache, $page, '../plugins/auto/mailshot/v4.0.1/prive/objets/liste/mailshots_destinataires.html');
}