function manage()
{
global $my, $mainframe, $database, $option, $priTask, $subTask;
global $WBG_CONFIG, $wbGalleryDB_cat;
$limit = intval($mainframe->getUserStateFromRequest("viewlistlimit", 'limit', $mainframe->getCfg('list_limit')));
$limitstart = intval($mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0));
$cat_id = intval($mainframe->getUserStateFromRequest("view{$option}cat_id", 'cat_id', 0));
$view_mode = trim($mainframe->getUserStateFromRequest("view{$option}view_mode", 'view_mode', 'image'));
$searchkw = trim(strtolower($mainframe->getUserStateFromRequest("view{$option}searchkw", 'searchkw', '')));
$where = array();
if ($cat_id > 0) {
$where[] = 'i.cat_id = ' . $cat_id;
}
if ($cat_id < 0) {
$where[] = 'i.cat_id = 0';
}
if ($searchkw) {
$where[] = "(i.name LIKE '%{$searchkw}%' OR i.sku LIKE '%{$searchkw}%')";
}
// Get Total
$database->setQuery("\r\r\n SELECT COUNT(DISTINCT i.id) AS total\r\r\n FROM #__wbgallery_img AS i\r\r\n LEFT JOIN #__wbgallery_cat AS c ON c.id = i.cat_id\r\r\n " . (count($where) ? "WHERE " . join(" AND ", $where) : '') . "\r\r\n ");
$total = $database->loadResult();
echo $database->getErrorMsg();
// Page Navigation
require_once $mainframe->getCfg('absolute_path') . '/administrator/includes/pageNavigation.php';
$pageNav = new mosPageNav($total, $limitstart, $limit);
// Get Records
$database->setQuery("\r\r\n SELECT i.*, c.name AS cat_name, c.title AS cat_title\r\r\n FROM #__wbgallery_img AS i\r\r\n LEFT JOIN #__wbgallery_cat AS c ON c.id = i.cat_id\r\r\n " . (count($where) ? "WHERE " . join(" AND ", $where) : '') . "\r\r\n GROUP BY i.id\r\r\n ORDER BY c.name, i.ordering, i.name\r\r\n " . ($limit ? "LIMIT {$limitstart}, {$limit}" : '') . "\r\r\n ");
$rows = $database->loadObjectList();
echo $database->getErrorMsg();
// Build Select Lists
$lists = array();
$catTree = $wbGalleryDB_cat->getCategoryTree();
$tList = array(mosHTML::makeOption('0', 'All Categories...', 'id', 'name'), mosHTML::makeOption('-1', 'No Category Images...', 'id', 'name'));
$tList = array_merge($tList, $catTree);
$lists['cat_id'] = mosHTML::selectList($tList, 'cat_id', 'onchange="document.adminForm.submit();"', 'id', 'name', $cat_id);
$tList = array(mosHTML::makeOption('0', 'Select Destination...', 'id', 'name'));
$tList = array_merge($tList, $catTree);
$lists['moveid'] = mosHTML::selectList($tList, 'moveid', '', 'id', 'name', null);
if ($cat_id) {
$lists['active_cat'] = new wbGalleryDB_cat($database);
$lists['active_cat']->load($cat_id);
}
$tList = array(mosHTML::makeOption('list', 'List', 'id', 'name'), mosHTML::makeOption('image', 'Image', 'id', 'name'));
$lists['view_mode'] = mosHTML::selectList($tList, 'view_mode', 'onchange="document.adminForm.submit();"', 'id', 'name', $view_mode);
$lists['view_mode_opt'] = $view_mode;
$lists['searchkw'] = $searchkw;
wbGallery_img_html::manage($rows, $pageNav, $lists);
}
