public function listAction()
{
$NS = new Zend_Session_Namespace('Default');
$form = $this->getRequest()->getParams();
$arrSort = array();
$params = array();
$page = $this->getRequest()->getParam('page');
$sort = $this->getRequest()->getParam('sort');
if (!empty($sort)) {
$arrSort[] = $this->SortingData($sort);
$arrSort[] = $sort;
} else {
$arrSort[] = "status_id asc, DATEDIFF(expiring_date, CURRENT_DATE) asc";
}
if (!empty($NS->search_domains)) {
$params = array_merge($params, $NS->search_domains);
$this->view->searchactive = 1;
} else {
$this->view->searchactive = 0;
// $params ['search'] ['status_id'] ['method'] = "andWhere";
// $params ['search'] ['status_id'] ['criteria'] = "d.status_id <> ? AND d.status_id <> ?";
// $params ['search'] ['status_id'] ['value'] = array(Statuses::id('suspended', 'domains'), Statuses::id('expired', 'domains')); // Do not show the expired domain as default
}
$params['search'][] = array('method' => 'andWhere', 'criteria' => "(c.customer_id = ? OR c.parent_id = ?)", 'value' => array($NS->customer['customer_id'], $NS->customer['customer_id']));
if (isset($form['domain'])) {
$params['search'][] = array('method' => 'andWhere', 'criteria' => 'd.domain like ?', 'value' => '%' . $form['domain'] . '%');
}
$page = !empty($page) && is_numeric($page) ? $page : 1;
$data = $this->domains->findAll("d.domain_id, \n\t\t\t\t\t\t\t CONCAT(d.domain, '.', ws.tld) as domain,\n\t\t\t\t\t\t\t DATE_FORMAT(d.expiring_date, '%d/%m/%Y') as endingdate, \n\t\t\t\t\t\t\t DATEDIFF(expiring_date, CURRENT_DATE) as days,\n\t\t\t\t\t\t\t s.status_id as status_id, s.status as status,\n\t\t\t\t\t\t\t d.autorenew as renew", $page, $NS->recordsperpage, $arrSort, $params['search']);
$data['tags'] = Tags::getList($this->customer['customer_id']);
$data['currentpage'] = $page;
// Get all the status of the domains in order to fill the batch list
$data['statuses'] = Statuses::getList('domains', true);
$data['show_action_box'] = false;
// This hide the status/action select box from the grid.
$this->view->mex = $this->getRequest()->getParam('mex');
$this->view->mexstatus = $this->getRequest()->getParam('status');
$this->view->title = $this->translator->translate("Domain Listing");
$this->view->description = $this->translator->translate("Here you can see all the list of your domains.");
$this->view->domains = $data;
}
$objects = sFileMgr()->getList($obj_id, array('SUBNODES'), 'group2.LFT', $maxlevels, $roleid);
$objects = sFileMgr()->getAdditionalTreeInfo(false, $objects);
$filetypes = $filetypeMgr->getList();
foreach ($objects as $objects_idx => $objects_item) {
foreach ($filetypes as $filetypes_item) {
if ($objects_item['FILETYPE'] == $filetypes_item['OBJECTID']) {
$objects[$objects_idx]['TYPEINFO'] = $filetypes_item;
}
}
}
sUserMgr()->unimpersonate();
break;
case 'tags':
sUserMgr()->impersonate(sUserMgr()->getAdministratorID());
$tagMgr = new Tags();
$objects = $tagMgr->getList($obj_id, array('SUBNODES'), true, $maxlevels, $roleid);
$objects = $tagMgr->getAdditionalTreeInfo(false, $objects);
sUserMgr()->unimpersonate();
break;
case 'usergroups':
// No subnodes
break;
case 'system':
// No subnodes
break;
}
$smarty->assign('isRORole', $isRORole);
$smarty->assign("objects", $objects);
$smarty->assign("site", $siteID);
$smarty->assign("objecttype", $yg_type);
$smarty->assign("maxlevels", $maxlevels);
$tagInfo = $tagMgr->get($source);
$koala->callJSFunction('Koala.yg_selectTreeNode', $parentwindow, 'page', $source[0]);
}
}
}
break;
case 'addTagChildFolder':
$tag = $this->params['tag'];
$tagName = $this->params['tagName'];
if (!$tagName) {
$tagName = $itext['TXT_TAG_NEW'];
}
// Check if root node is selected
if ($tag === 'root') {
// Get real Page-ID of Root-Node
$tags = $tagMgr->getList();
$tag = $tags[0]['ID'];
}
// Add new child node
$new_id = $tagMgr->add($tag, $tagName);
if ($new_id != false) {
$icons = new Icons();
$jsQueue->add($new_id, HISTORYTYPE_TAG, 'TAG_ADD', sGuiUS(), NULL);
} else {
$koala->alert($itext['TXT_ERROR_ACCESS_DENIED']);
}
break;
case 'deleteTag':
$tagID = $this->params['tagID'];
$siteID = $this->params['site'];
// Delete tag
$objects = $fileMgr->getAdditionalTreeInfo(false, $objects);
$filetypes = $filetypeMgr->getList();
foreach ($objects as $objects_idx => $objects_item) {
foreach ($filetypes as $filetypes_item) {
if ($objects_item['FILETYPE'] == $filetypes_item['OBJECTID']) {
$objects[$objects_idx]['TYPEINFO'] = $filetypes_item;
}
}
}
// Use translated name for root-node
$objects[0]['NAME'] = $itext['TXT_FILES'] != '' ? $itext['TXT_FILES'] : '$TXT_FILES';
break;
case 'tab_usergroup_tags':
$objecttype = $site = 'tags';
$tagMgr = new Tags();
$objects = $tagMgr->getList(0, array(), true, $maxlevels, $roleid);
$objects = $tagMgr->getAdditionalTreeInfo(false, $objects);
// Use translated name for root-node
$objects[0]['NAME'] = $itext['TXT_TAGS'] != '' ? $itext['TXT_TAGS'] : '$TXT_TAGS';
break;
case 'tab_usergroup_mailings':
$objecttype = $site = 'mailings';
$mailingMgr = new MailingMgr();
$objects = $mailingMgr->getList(0, array(), $maxlevels, $roleid);
$objects = $mailingMgr->getAdditionalTreeInfo(false, $objects);
$objects = array_reverse($objects, false);
$objects[0]['FOLDER'] = 1;
// Use translated name for root-node
$objects[0]['NAME'] = $itext['TXT_MAILINGS'] != '' ? $itext['TXT_MAILINGS'] : '$TXT_MAILINGS';
break;
case 'tab_usergroup_usergroups':
