<?php
/**
* mobiCMS (https://mobicms.org/)
* This file is part of mobiCMS Content Management System.
*
* @license https://opensource.org/licenses/GPL-3.0 GPL-3.0 (see the LICENSE.md file)
* @link http://mobicms.org mobiCMS Project
* @copyright Copyright (C) mobiCMS Community
*/
defined('MOBICMS') or die('Error: restricted access');
use Library\Tree;
/** @var Psr\Container\ContainerInterface $container */
$container = App::getContainer();
/** @var PDO $db */
$db = $container->get(PDO::class);
/** @var Mobicms\Checkpoint\UserConfig $userConfig */
$userConfig = $container->get(Mobicms\Api\UserInterface::class)->getConfig();
/** @var Mobicms\Api\ToolsInterface $tools */
$tools = $container->get(Mobicms\Api\ToolsInterface::class);
echo '<div class="phdr"><strong><a href="?">' . _t('Library') . '</a></strong> | ' . _t('Moderation Articles') . '</div>';
if ($db->query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=0')->fetchColumn()) {
if ($id && isset($input_request['yes'])) {
$sql = 'UPDATE `library_texts` SET `premod`=1 WHERE `id`=' . $id;
echo '<div class="rmenu">' . _t('Article') . ' <strong>' . $tools->checkout($db->query("SELECT `name` FROM `library_texts` WHERE `id`=" . $id)->fetchColumn()) . '</strong> ' . _t('Added to the database') . '</div>';
} elseif (isset($input_request['all'])) {
$sql = 'UPDATE `library_texts` SET `premod`=1';
echo '<div>' . _t('All Articles added in database') . '</div>';
}
if (isset($input_request['yes']) || isset($input_request['all'])) {
$db->exec($sql);
}
}
$total = $db->query('SELECT COUNT(*) FROM `library_texts` WHERE `premod`=0')->fetchColumn();
$page = $page >= ceil($total / $userConfig->kmess) ? ceil($total / $userConfig->kmess) : $page;
$start = $page == 1 ? 0 : ($page - 1) * $userConfig->kmess;
if ($total) {
$stmt = $db->query('SELECT `id`, `name`, `time`, `uploader`, `uploader_id`, `cat_id` FROM `library_texts` WHERE `premod`=0 ORDER BY `time` DESC LIMIT ' . $start . ',' . $userConfig->kmess);
$i = 0;
while ($row = $stmt->fetch()) {
$dir_nav = new Tree($row['cat_id']);
$dir_nav->processNavPanel();
echo '<div class="list' . (++$i % 2 ? 2 : 1) . '">'
. (file_exists('../uploads/library/images/small/' . $row['id'] . '.png')
? '<div class="avatar"><img src="../uploads/library/images/small/' . $row['id'] . '.png" alt="screen" /></div>'
: '')
. '<div class="righttable"><a href="index.php?id=' . $row['id'] . '">' . $tools->checkout($row['name']) . '</a></div>'
. '<div class="sub">' . _t('Who added') . ': ' . $tools->checkout($row['uploader']) . ' (' . $tools->displayDate($row['time']) . ')</div>'
. '<div>' . $dir_nav->printNavPanel() . '</div>'
. '<a href="?act=premod&yes&id=' . $row['id'] . '">' . _t('Approve') . '</a> | <a href="?act=del&type=article&id=' . $row['id'] . '">' . _t('Delete') . '</a>'
. '</div>';
}
}
echo '<div class="phdr">' . _t('Total') . ': ' . intval($total) . '</div>';
echo ($total > $userConfig->kmess) ? '<div class="topmenu">' . $tools->displayPagination('?act=premod&', $total) . '</div>' : '';
echo $total ? '<div><a href="?act=premod&all">' . _t('Approve all') . '</a></div>' : '';
echo '<p><a href="?">' . _t('To Library') . '</a></p>' . PHP_EOL;