$xoops = Xoops::getInstance();
$itemid = isset($_POST['itemid']) ? (int) $_POST['itemid'] : 0;
$pick = isset($_GET['pick']) ? (int) $_GET['pick'] : 0;
$pick = isset($_POST['pick']) ? (int) $_POST['pick'] : $pick;
$statussel = isset($_GET['statussel']) ? (int) $_GET['statussel'] : 0;
$statussel = isset($_POST['statussel']) ? (int) $_POST['statussel'] : $statussel;
$sortsel = isset($_GET['sortsel']) ? $_GET['sortsel'] : 'itemid';
$sortsel = isset($_POST['sortsel']) ? $_POST['sortsel'] : $sortsel;
$ordersel = isset($_GET['ordersel']) ? $_GET['ordersel'] : 'DESC';
$ordersel = isset($_POST['ordersel']) ? $_POST['ordersel'] : $ordersel;
$module_id = $publisher->getModule()->mid();
$gperm_handler = $xoops->getHandlerGroupPermission();
$groups = $xoops->getUserGroups();
// Code for the page
$startentry = isset($_GET['startentry']) ? (int) $_GET['startentry'] : 0;
PublisherUtils::cpHeader();
//publisher_adminMenu(0, _AM_PUBLISHER_INDEX);
// Total ITEMs -- includes everything on the table
$totalitems = $publisher->getItemHandler()->getItemsCount();
// Total categories
$totalcategories = $publisher->getCategoryHandler()->getCategoriesCount(-1);
// Total submitted ITEMs
$totalsubmitted = $publisher->getItemHandler()->getItemsCount(-1, array(_PUBLISHER_STATUS_SUBMITTED));
// Total published ITEMs
$totalpublished = $publisher->getItemHandler()->getItemsCount(-1, array(_PUBLISHER_STATUS_PUBLISHED));
// Total offline ITEMs
$totaloffline = $publisher->getItemHandler()->getItemsCount(-1, array(_PUBLISHER_STATUS_OFFLINE));
// Total rejected
$totalrejected = $publisher->getItemHandler()->getItemsCount(-1, array(_PUBLISHER_STATUS_REJECTED));
// Check Path Configuration
if (PublisherUtils::getPathStatus('root', true) < 0 || PublisherUtils::getPathStatus('images', true) < 0 || PublisherUtils::getPathStatus('images/category', true) < 0 || PublisherUtils::getPathStatus('images/item', true) < 0 || PublisherUtils::getPathStatus('content', true) < 0) {
function search()
{
$publisher = Publisher::getInstance();
$xoops = Xoops::getInstance();
global $limit, $start, $imagearray, $aSearchBy, $aOrderBy, $aLimitBy, $aSortBy;
if (isset($_POST['deleteMimes'])) {
$aMimes = $_POST['mimes'];
$crit = new Criteria('mime_id', "(" . implode($aMimes, ',') . ")", "IN");
if ($publisher->getMimetypeHandler()->deleteAll($crit)) {
header("Location: " . PUBLISHER_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}");
} else {
$xoops->redirect(PUBLISHER_ADMIN_URL . "/mimetypes.php?limit={$limit}&start={$start}", 3, _AM_PUBLISHER_MESSAGE_DELETE_MIME_ERROR);
}
}
if (isset($_POST['add_mime'])) {
header("Location: " . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=add&start={$start}&limit={$limit}");
exit;
}
if (isset($_REQUEST['order'])) {
$order = $_REQUEST['order'];
} else {
$order = "ASC";
}
if (isset($_REQUEST['sort'])) {
$sort = $_REQUEST['sort'];
} else {
$sort = "mime_name";
}
PublisherUtils::cpHeader();
//publisher_adminMenu(4, _AM_PUBLISHER_MIMETYPES . " > " . _AM_PUBLISHER_BUTTON_SEARCH);
PublisherUtils::openCollapsableBar('mimemsearchtable', 'mimesearchicon', _AM_PUBLISHER_MIME_SEARCH);
if (!isset($_REQUEST['mime_search'])) {
echo "<form action='mimetypes.php?op=search' method='post'>";
echo "<table width='100%' cellspacing='1' class='outer'>";
echo "<tr><th colspan='2'>" . _AM_PUBLISHER_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr><td class='head' width='20%'>" . _AM_PUBLISHER_TEXT_SEARCH_BY . "</td>\n <td class='even'>\n <select name='search_by'>";
foreach ($aSortBy as $value => $text) {
echo "<option value='{$value}'>{$text}</option>";
}
echo "</select>\n </td>\n </tr>";
echo "<tr><td class='head'>" . _AM_PUBLISHER_TEXT_SEARCH_TEXT . "</td>\n <td class='even'>\n <input type='text' name='search_text' id='search_text' value='' />\n </td>\n </tr>";
echo "<tr class='foot'>\n <td colspan='2'>\n <input type='submit' name='mime_search' id='mime_search' value='" . _AM_PUBLISHER_BUTTON_SEARCH . "' />\n </td>\n </tr>";
echo "</table></form>";
} else {
$search_field = $_REQUEST['search_by'];
$search_text = $_REQUEST['search_text'];
$crit = new Criteria($search_field, "%{$search_text}%", 'LIKE');
$crit->setSort($sort);
$crit->setOrder($order);
$crit->setLimit($limit);
$crit->setStart($start);
$mime_count = $publisher->getMimetypeHandler()->getCount($crit);
$mimetypes = $publisher->getMimetypeHandler()->getObjects($crit);
$nav = new XoopsPageNav($mime_count, $limit, $start, 'start', "op=search&limit={$limit}&order={$order}&sort={$sort}&mime_search=1&search_by={$search_field}&search_text={$search_text}");
// Display results
echo '<script type="text/javascript" src="' . PUBLISHER_URL . '/include/functions.js"></script>';
echo "<table width='100%' cellspacing='1' class='outer'>";
echo "<tr><td colspan='6' align='right'>";
echo "<form action='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=search' style='margin:0; padding:0;' method='post'>";
echo "<table>";
echo "<tr>";
echo "<td align='right'>" . _AM_PUBLISHER_TEXT_SEARCH_BY . "</td>";
echo "<td align='left'><select name='search_by'>";
foreach ($aSearchBy as $value => $text) {
$search_field == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select></td>";
echo "<td align='right'>" . _AM_PUBLISHER_TEXT_SEARCH_TEXT . "</td>";
echo "<td align='left'><input type='text' name='search_text' id='search_text' value='{$search_text}' /></td>";
echo "<td><input type='submit' name='mime_search' id='mime_search' value='" . _AM_PUBLISHER_BUTTON_SEARCH . "' /></td>";
echo "</tr></table></form></td></tr>";
echo "<tr><td colspan='6'>";
echo "<form action='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=search' style='margin:0; padding:0;' method='post'>";
echo "<table width='100%'>";
echo "<tr><td align='right'>" . _AM_PUBLISHER_TEXT_SORT_BY . "\n <select name='sort'>";
foreach ($aSortBy as $value => $text) {
$sort == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n \n " . _AM_PUBLISHER_TEXT_ORDER_BY . "\n <select name='order'>";
foreach ($aOrderBy as $value => $text) {
$order == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n \n " . _AM_PUBLISHER_TEXT_NUMBER_PER_PAGE . "\n <select name='limit'>";
foreach ($aLimitBy as $value => $text) {
$limit == $value ? $selected = "selected='selected'" : ($selected = '');
echo "<option value='{$value}' {$selected}>{$text}</option>";
}
echo "</select>\n <input type='submit' name='mime_sort' id='mime_sort' value='" . _AM_PUBLISHER_BUTTON_SUBMIT . "' />\n <input type='hidden' name='mime_search' id='mime_search' value='1' />\n <input type='hidden' name='search_by' id='search_by' value='{$search_field}' />\n <input type='hidden' name='search_text' id='search_text' value='{$search_text}' />\n </td>\n </tr>";
echo "</table>";
echo "</td></tr>";
if (count($mimetypes) > 0) {
echo "<tr><th colspan='6'>" . _AM_PUBLISHER_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr class='head'>\n <td>" . _AM_PUBLISHER_MIME_ID . "</td>\n <td>" . _AM_PUBLISHER_MIME_NAME . "</td>\n <td>" . _AM_PUBLISHER_MIME_EXT . "</td>\n <td>" . _AM_PUBLISHER_MIME_ADMIN . "</td>\n <td>" . _AM_PUBLISHER_MIME_USER . "</td>\n <td>" . _AM_PUBLISHER_MINDEX_ACTION . "</td>\n </tr>";
foreach ($mimetypes as $mime) {
echo "<tr class='even'>\n <td><input type='checkbox' name='mimes[]' value='" . $mime->getVar('mime_id') . "' />" . $mime->getVar('mime_id') . "</td>\n <td>" . $mime->getVar('mime_name') . "</td>\n <td>" . $mime->getVar('mime_ext') . "</td>\n <td>\n <a href='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=updateMimeValue&id=" . $mime->getVar('mime_id') . "&mime_admin=" . $mime->getVar('mime_admin') . "&limit=" . $limit . "&start=" . $start . "'>\n " . ($mime->getVar('mime_admin') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td>\n <a href='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=updateMimeValue&id=" . $mime->getVar('mime_id') . "&mime_user="******"&limit=" . $limit . "&start=" . $start . "'>\n " . ($mime->getVar('mime_user') ? $imagearray['online'] : $imagearray['offline']) . "</a>\n </td>\n <td>\n <a href='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=edit&id=" . $mime->getVar('mime_id') . "&limit=" . $limit . "&start=" . $start . "'>" . $imagearray['editimg'] . "</a>\n <a href='" . PUBLISHER_ADMIN_URL . "/mimetypes.php?op=delete&id=" . $mime->getVar('mime_id') . "&limit=" . $limit . "&start=" . $start . "'>" . $imagearray['deleteimg'] . "</a>\n </td>\n </tr>";
}
echo "<tr class='foot'>\n <td colspan='6' valign='top'>\n <a href='http://www.filext.com' style='float: right' target='_blank'>" . _AM_PUBLISHER_MIME_FINDMIMETYPE . "</a>\n <input type='checkbox' name='checkAllMimes' value='0' onclick='selectAll(this.form,\"mimes[]\",this.checked);' />\n <input type='submit' name='deleteMimes' id='deleteMimes' value='" . _AM_PUBLISHER_BUTTON_DELETE . "' />\n <input type='submit' name='add_mime' id='add_mime' value='" . _AM_PUBLISHER_MIME_CREATEF . "' class='formButton' />\n </td>\n </tr>";
} else {
echo "<tr><th>" . _AM_PUBLISHER_TEXT_SEARCH_MIME . "</th></tr>";
echo "<tr class='even'>\n <td>" . _AM_PUBLISHER_TEXT_NO_RECORDS . "</td>\n </tr>";
}
echo "</table>";
echo "<div id='pagenav'>" . $nav->renderNav() . "</div>";
}
PublisherUtils::closeCollapsableBar('mimesearchtable', 'mimesearchicon');
$xoops->footer();
}
