'UNIX_TIMESTAMP(date_time) AS d',
'FROM' => 'spip_signatures',
'WHERE' => $where,
'ORDER BY' => $order);
$debut = navigation_trouve_date($date, 'd', $pas, $query);
}
$signatures = charger_fonction('signatures', 'inc');
$res = $signatures('controle_petition', $id_article, $debut, $pas, $where, $order, $type);
if (_AJAX) {
ajax_retour($res);
} else {
$count = ($type != 'interne') ? 0 : sql_countsel("spip_signatures", $where);
controle_petition_page($id_article, $titre, $id_signature ? '' : $type, $res, $count);
}
}
// http://doc.spip.org/@controle_petition_page
function controle_petition_page($id_article, $titre, $type, $corps, $count)
{
$args = array();
$rac = '';
if (!(autoriser('modererpetition')
OR (
$id_article > 0
AND autoriser('modererpetition', 'article', $id_article)
))) {
$ong = '';
} else {
$ong = controle_petition_onglet($id_article, $debut, $type, '');
if ($id_article) {
$h = generer_url_ecrire("statistiques_visites","id_article=$id_article");
$rac = icone_horizontale(_T('icone_statistiques_visites'), $h, "statistiques-24.gif","rien.gif", false);
if ($type !== 'public') {
$h = redirige_action_auteur('editer_signatures', $id_article . 'A', 'controle_petition', "id_article=$id_article&type=interne");
$rac .= icone_horizontale(_T('icone_relancer_signataire') . " ($count)", $h, "envoi-message-24.gif","rien.gif", false);
}
$rac = bloc_des_raccourcis($rac);
$titre = "" .
typo($titre) .
"" .
" (" .
_T('info_numero_abbreviation') .
$id_article .
")";
if (!sql_countsel('spip_petitions', "id_article=$id_article"))
$titre .= '
' . _T('info_petition_close');
$args = array('id_article' => $id_article);
} else {
$q = sql_select('A.titre, A.date, A.id_article, count(*) AS n',
'spip_signatures AS S LEFT JOIN spip_articles AS A ON A.id_article=S.id_article',
'',
'A.id_article',
'n desc',
"0,10");
while ($r = sql_fetch($q)) {
$id = $r['id_article'];
$h = generer_url_entite($id, 'article');
$title = affdate_jourcourt($r['date']) . "\n" .$r['titre'];
$rac .= "