admin/reviews.php
<?php
/*
You may not change or alter any portion of this comment or credits
of supporting developers from this source code or any supporting source code
which is considered copyrighted (c) material of the original comment or credit authors.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
*/
/**
* Wfdownloads module
*
* @copyright XOOPS Project (https://xoops.org)
* @license GNU GPL 2 or later (https://www.gnu.org/licenses/gpl-2.0.html)
* @package wfdownload
* @since 3.23
* @author Xoops Development Team
*/
use Xmf\Module\Admin;
use Xmf\Request;
use XoopsModules\Wfdownloads\{
Helper,
Utility
};
/** @var Helper $helper */
/** @var Utility $utility */
$currentFile = basename(__FILE__);
require_once __DIR__ . '/admin_header.php';
/** @var \XoopsMemberHandler $memberHandler */
$memberHandler = xoops_getHandler('member');
$op = Request::getString('op', 'reviews.list');
switch ($op) {
case 'review.delete':
$review_id = Request::getInt('review_id', 0);
$ok = Request::getBool('ok', false, 'POST');
if (!$reviewObj = $helper->getHandler('Review')->get($review_id)) {
redirect_header($currentFile, 4, _AM_WFDOWNLOADS_ERROR_REVIEWNOTFOUND);
}
if (true === $ok) {
if (!$GLOBALS['xoopsSecurity']->check()) {
redirect_header($currentFile, 3, implode(',', $GLOBALS['xoopsSecurity']->getErrors()));
}
if ($helper->getHandler('Review')->delete($reviewObj)) {
redirect_header($currentFile, 1, sprintf(_AM_WFDOWNLOADS_FILE_FILEWASDELETED, $reviewObj->getVar('title')));
} else {
echo $reviewObj->getHtmlErrors();
exit();
}
} else {
Utility::getCpHeader();
xoops_confirm(['op' => 'review.delete', 'review_id' => $review_id, 'ok' => true], $currentFile, _AM_WFDOWNLOADS_FILE_REALLYDELETEDTHIS . '<br><br>' . $reviewObj->getVar('title'), _AM_WFDOWNLOADS_BDELETE);
xoops_cp_footer();
}
break;
case 'review.approve':
$review_id = Request::getInt('review_id', 0);
$ok = Request::getBool('ok', false, 'POST');
if (!$reviewObj = $helper->getHandler('Review')->get($review_id)) {
redirect_header($currentFile, 4, _AM_WFDOWNLOADS_ERROR_REVIEWNOTFOUND);
}
if (true === $ok) {
$reviewObj->setVar('submit', 1); // true
$helper->getHandler('Review')->insert($reviewObj);
redirect_header($currentFile, 1, sprintf(_AM_WFDOWNLOADS_REV_REVIEW_UPDATED, $reviewObj->getVar('title')));
} else {
Utility::getCpHeader();
xoops_confirm(['op' => 'review.approve', 'review_id' => $reviewObj->getVar('review_id'), 'ok' => true], $currentFile, _AM_WFDOWNLOADS_REVIEW_APPROVETHIS . '<br><br>' . $reviewObj->getVar('title'), _AM_WFDOWNLOADS_REVIEW_APPROVETHIS);
xoops_cp_footer();
}
break;
case 'review.edit':
$review_id = Request::getInt('review_id', 0);
if (!$reviewObj = $helper->getHandler('Review')->get($review_id)) {
redirect_header($currentFile, 4, _AM_WFDOWNLOADS_ERROR_REVIEWNOTFOUND);
}
Utility::getCpHeader();
$adminObject = Admin::getInstance();
$adminObject->displayNavigation($currentFile);
$sform = $reviewObj->getForm();
$sform->display();
xoops_cp_footer();
break;
case 'review.save':
$review_id = Request::getInt('review_id', 0);
if (!$reviewObj = $helper->getHandler('Review')->get($review_id)) {
redirect_header($currentFile, 4, _AM_WFDOWNLOADS_ERROR_REVIEWNOTFOUND);
}
$reviewObj->setVar('title', trim($_POST['title']));
$reviewObj->setVar('review', trim($_POST['review']));
$reviewObj->setVar('rated', Request::getInt('rated', 0, 'POST'));
$reviewObj->setVar('submit', Request::getInt('approve', 0, 'POST'));
$helper->getHandler('Review')->insert($reviewObj);
redirect_header($currentFile, 1, _AM_WFDOWNLOADS_REV_REVIEW_UPDATED);
break;
case 'reviews.list':
default:
$start_waiting = Request::getInt('start_waiting', 0);
$start_published = Request::getInt('start_published', 0);
$criteria_waiting = new Criteria('submit', 0); // false
$waiting_count = $helper->getHandler('Review')->getCount($criteria_waiting);
$criteria_waiting->setSort('date');
$criteria_waiting->setOrder('DESC');
$criteria_waiting->setLimit($helper->getConfig('admin_perpage'));
$criteria_waiting->setStart($start_waiting);
$reviews_waiting = $helper->getHandler('Review')->getObjects($criteria_waiting);
$criteria_published = new Criteria('submit', 1); // true
$published_count = $helper->getHandler('Review')->getCount($criteria_published);
$criteria_published->setSort('date');
$criteria_published->setOrder('DESC');
$criteria_published->setLimit($helper->getConfig('admin_perpage'));
$criteria_published->setStart($start_published);
$reviews_published = $helper->getHandler('Review')->getObjects($criteria_published);
Utility::getCpHeader();
$adminObject = Admin::getInstance();
$adminObject->displayNavigation($currentFile);
$GLOBALS['xoopsTpl']->assign('reviews_waiting_count', $waiting_count);
$GLOBALS['xoopsTpl']->assign('reviews_published_count', $published_count);
if ($waiting_count > 0) {
foreach ($reviews_waiting as $review_waiting) {
$lids_waiting[] = $review_waiting->getVar('lid');
$uids_waiting[] = $review_waiting->getVar('uid');
}
if (isset($lids_waiting)) {
$downloads = $helper->getHandler('Download')->getObjects(new Criteria('lid', '(' . implode(',', array_unique($lids_waiting)) . ')', 'IN'), true, false);
}
if (isset($uids_waiting)) {
$users = $memberHandler->getUserList(new Criteria('uid', '(' . implode(',', $uids_waiting) . ')'));
}
foreach ($reviews_waiting as $review_waiting) {
$review_waiting_array = $review_waiting->toArray();
$review_waiting_array['download_title'] = isset($downloads[$review_waiting->getVar('lid')]) ? $downloads[$review_waiting->getVar('lid')]['title'] : '';
$review_waiting_array['reviewer_uname'] = XoopsUserUtility::getUnameFromId($review_waiting->getVar('uid'));
$reviewer = $memberHandler->getUser($review_waiting->getVar('uid'));
$review_waiting_array['reviewer_email'] = is_object($reviewer) ? $reviewer->email() : '';
$review_waiting_array['formatted_date'] = formatTimestamp($review_waiting->getVar('date'), 'l');
$GLOBALS['xoopsTpl']->append('reviews_waiting', $review_waiting_array);
}
//Include page navigation
require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$pagenav_waiting = new XoopsPageNav($waiting_count, $helper->getConfig('admin_perpage'), $start_waiting, 'start_waiting');
$GLOBALS['xoopsTpl']->assign('reviews_waiting_pagenav', $pagenav_waiting->renderNav());
}
if ($published_count > 0) {
foreach ($reviews_published as $review_published) {
$lids_published[] = $review_published->getVar('lid');
$uids_published[] = $review_published->getVar('uid');
}
if (isset($lids_published)) {
$downloads = $helper->getHandler('Download')->getObjects(new Criteria('lid', '(' . implode(',', array_unique($lids_published)) . ')', 'IN'), true, false);
}
if (isset($uids_published)) {
$users = $memberHandler->getUserList(new Criteria('uid', '(' . implode(',', $uids_published) . ')'));
}
foreach ($reviews_published as $review_published) {
$review_published_array = $review_published->toArray();
$review_published_array['download_title'] = isset($downloads[$review_published->getVar('lid')]) ? $downloads[$review_published->getVar('lid')]['title'] : '';
$review_published_array['reviewer_uname'] = XoopsUserUtility::getUnameFromId($review_published->getVar('uid'));
$reviewer = $memberHandler->getUser($review_published->getVar('uid'));
$review_published_array['reviewer_email'] = is_object($reviewer) ? $reviewer->email() : '';
$review_published_array['formatted_date'] = formatTimestamp($review_published->getVar('date'), 'l');
$GLOBALS['xoopsTpl']->append('reviews_published', $review_published_array);
}
//Include page navigation
require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
$pagenav_published = new XoopsPageNav($published_count, $helper->getConfig('admin_perpage'), $start_published, 'start_published');
$GLOBALS['xoopsTpl']->assign('reviews_published_pagenav', $pagenav_published->renderNav());
}
$xoopsTpl->assign('use_mirrors', $helper->getConfig('enable_mirrors'));
$xoopsTpl->assign('use_ratings', $helper->getConfig('enable_ratings'));
$xoopsTpl->assign('use_reviews', $helper->getConfig('enable_reviews'));
$xoopsTpl->assign('use_brokenreports', $helper->getConfig('enable_brokenreports'));
$GLOBALS['xoopsTpl']->display("db:{$helper->getModule()->dirname()}_am_reviewslist.tpl");
require_once __DIR__ . '/admin_footer.php';
break;
}