<?php

require dirname(__FILE__) . '/_init.php';

if (!empty($_POST['delete']) && is_array($_POST['delete']))
{
    foreach ($_POST['delete'] as $id)
    {
        user::deleteUser($id);
    }

    utils::redirect('/admin/');
}

$expire = time() - (7 * 24 * 3600);

if (isset($_GET['no_journal']))
{
    $membres = DB::aQuery('SELECT m.id, m.email, m.date
        FROM membres AS m LEFT JOIN journaux AS j ON j.auteur = m.id
        WHERE j.id IS NULL AND m.date_inscription < "'.$expire.'"
        GROUP BY m.id ORDER BY m.email;', false, DB::FETCH_ASSOC);
}
else
{
    $membres = DB::aQuery('SELECT id, email, date_inscription FROM membres
        WHERE date IS NULL AND date_inscription < "'.$expire.'"
        ORDER BY date_inscription DESC;', false, DB::FETCH_ASSOC);
}

$tpl->assign('membres', $membres);

$tpl->display('admin/m_menage.tpl');

?>