protected function _gridRead($params) { if (1 == count($this->_iaCore->requestPath) && 'registration-email' == $this->_iaCore->requestPath[0]) { return $this->_resendRegistrationEmail(); } return parent::_gridRead($params); }
protected function _gridRead($params) { if ('usergroup' == $params['sort']) { $params['sort'] = 'usergroup_id'; } return parent::_gridRead($params); }
protected function _gridRead($params) { $action = 1 == count($this->_iaCore->requestPath) ? $this->_iaCore->requestPath[0] : null; switch ($action) { case 'items': $output = array('data' => null); if ($items = $this->_iaCore->factory('item')->getItems(true)) { foreach ($items as $key => $item) { $output['data'][] = array('title' => iaLanguage::get($item), 'value' => $item); } } break; case 'plans': $output = array('data' => null); $stmt = ''; if (!isset($params['itemname']) || isset($params['itemname']) && iaUsers::getItemName() == $params['itemname']) { $stmt = iaDb::convertIds(iaUsers::getItemName(), 'item'); $output['data'][] = array('title' => iaLanguage::get('funds'), 'value' => 0); } elseif (!empty($params['itemname'])) { $stmt = iaDb::convertIds($params['itemname'], 'item'); } $this->_iaCore->factory('plan'); if ($planIds = $this->_iaDb->onefield(iaDb::ID_COLUMN_SELECTION, $stmt, null, null, iaPlan::getTable())) { foreach ($planIds as $planId) { $output['data'][] = array('title' => iaLanguage::get('plan_title_' . $planId), 'value' => $planId); } } break; case 'gateways': $output = array('data' => null); if ($items = $this->getHelper()->getPaymentGateways()) { foreach ($items as $name => $title) { $output['data'][] = array('value' => $name, 'title' => $title); } } break; case 'members': $output = array('data' => null); if (!empty($params['query'])) { $where[] = 'CONCAT(`username`, `fullname`) LIKE :username'; $values['username'] = '******' . iaSanitize::sql($params['query']) . '%'; } $where || ($where[] = iaDb::EMPTY_CONDITION); $where = implode(' AND ', $where); $this->_iaDb->bind($where, $values); if ($members = $this->_iaDb->all(array('id', 'username', 'fullname'), $where, null, null, iaUsers::getTable())) { foreach ($members as $member) { $output['data'][] = array('title' => $member['username'], 'value' => $member['id']); } } break; default: $output = parent::_gridRead($params); } return $output; }
protected function _gridRead($params) { $output = array(); $iaDb =& $this->_iaDb; switch ($params['get']) { case 'plugins': if ($plugins = $this->_iaDb->onefield('name', null, null, null, 'extras')) { $output['data'][] = array('value' => iaCore::CORE, 'title' => iaLanguage::get('core', 'Core')); foreach ($plugins as $plugin) { $output['data'][] = array('value' => $plugin, 'title' => iaLanguage::get($plugin, ucfirst($plugin))); } } break; case 'comparison': if (isset($params['lang1']) && isset($params['lang2']) && $params['lang1'] != $params['lang2'] && array_key_exists($params['lang1'], $this->_iaCore->languages) && array_key_exists($params['lang2'], $this->_iaCore->languages)) { $start = isset($params['start']) ? (int) $params['start'] : 0; $limit = isset($params['limit']) ? (int) $params['limit'] : 15; $values = array(); if (!empty($params['key'])) { $conditions[] = '`key` LIKE :key OR `value` LIKE :key'; $values['key'] = '%' . $params['key'] . '%'; } if (!empty($params['category'])) { $conditions[] = '`category` = :category'; $values['category'] = $params['category']; } if (!empty($params['plugin'])) { if (iaCore::CORE == $params['plugin']) { $params['plugin'] = ''; } $conditions[] = '`extras` = :plugin'; $values['plugin'] = $params['plugin']; } $where = empty($conditions) ? iaDb::EMPTY_CONDITION : implode(' AND ', $conditions); $iaDb->bind($where, $values); $rows = $iaDb->all('SQL_CALC_FOUND_ROWS DISTINCT `key`, `category`', $where, $start, $limit); $output = array('data' => array(), 'total' => $iaDb->foundRows()); $keys = array(); foreach ($rows as $row) { $keys[] = $row['key']; } $stmt = "`code` = ':lang' AND `key` IN('" . implode("','", $keys) . "')"; $lang1 = $iaDb->keyvalue(array('key', 'value'), iaDb::printf($stmt, array('lang' => $params['lang1']))); $lang2 = $iaDb->keyvalue(array('key', 'value'), iaDb::printf($stmt, array('lang' => $params['lang2']))); foreach ($rows as $row) { $key = $row['key']; $output['data'][] = array('key' => $key, 'lang1' => isset($lang1[$key]) ? $lang1[$key] : null, 'lang2' => isset($lang2[$key]) ? $lang2[$key] : null, 'category' => $row['category']); } } break; default: $params['lang'] = isset($_GET['lang']) && array_key_exists($_GET['lang'], $this->_iaCore->languages) ? $_GET['lang'] : $this->_iaCore->iaView->language; $output = parent::_gridRead($params); } return $output; }
protected function _gridRead($params) { if (isset($params['get']) && 'groups' == $params['get']) { return $this->_iaDb->all(array('id', 'name'), iaDb::convertIds($_GET['item'], 'item'), null, null, iaField::getTableGroups()); } if ($this->getName() != $this->_iaCore->iaView->name()) { $params['item'] = str_replace('_fields', '', $this->_iaCore->iaView->name()); } return parent::_gridRead($params); }
protected function _gridRead($params) { $action = empty($this->_iaCore->requestPath[0]) ? null : $this->_iaCore->requestPath[0]; if (!is_null($action)) { $methodName = '_getJson' . ucfirst($action); if (is_callable(array($this, $methodName))) { return call_user_func(array($this, $methodName), $params); } } return parent::_gridRead($params); }
protected function _gridRead($params) { $action = 1 == count($this->_iaCore->requestPath) ? $this->_iaCore->requestPath[0] : null; switch ($action) { case 'url': return $this->_getJsonUrl($params); case 'plugins': return $this->_getJsonPlugins(); default: return parent::_gridRead($params); } }
protected function _gridRead($params) { if (isset($_POST['action'])) { $output = array(); switch ($_POST['action']) { case 'get': $output['code'] = $this->_iaDb->one_bind('`code`', iaDb::convertIds((int) $_POST['id'])); break; case 'set': $output['result'] = (bool) $this->_iaDb->update(array('code' => $_POST['code']), iaDb::convertIds($_POST['id'])); $output['message'] = iaLanguage::get($output['result'] ? 'saved' : 'db_error'); } return $output; } return parent::_gridRead($params); }
protected function _gridRead($params) { $output = array(); switch ($this->_iaCore->requestPath[0]) { case 'get': $output['code'] = $this->_iaDb->one_bind('`code`', iaDb::convertIds((int) $_GET['id'])); break; case 'set': $this->_iaDb->update(array('code' => $_POST['code']), iaDb::convertIds($_POST['id'])); $output['result'] = 0 == $this->_iaDb->getErrorNumber(); $output['message'] = iaLanguage::get($output['result'] ? 'saved' : 'db_error'); break; default: $output = parent::_gridRead($params); } return $output; }
protected function _gridRead($params) { $output = array(); switch ($params['action']) { case 'pages': $pageGroups = $this->_iaCore->factory('page', iaCore::ADMIN)->getGroups(); foreach ($pageGroups as $groupId => $group) { $children = array(); foreach ($group['children'] as $pageId => $pageTitle) { $children[] = array('text' => $pageTitle, 'leaf' => true, 'id' => $pageId); } $output[] = array('text' => $group['title'], 'id' => 'group_' . $groupId, 'cls' => 'folder', 'draggable' => false, 'children' => $children); } $output[0]['expanded'] = true; break; case 'menus': function recursiveRead($list, $pid = 0) { $result = array(); if (isset($list[$pid])) { foreach ($list[$pid] as $child) { $title = iaLanguage::get('page_title_' . $child['el_id'], 'none'); if ($title == 'none') { $title = iaLanguage::get('page_title_' . $child['page_name'], 'none'); if ($title == 'none' || $child['page_name'] == 'node') { $title = iaLanguage::get('_page_removed_'); } } else { $title .= (int) $child['el_id'] > 0 ? ' (custom)' : ' (no link)'; } $item = array('text' => $title, 'id' => $child['el_id'], 'expanded' => true, 'children' => recursiveRead($list, $child['el_id'])); $result[] = $item; } } return $result; } $output = array(); if ($name = (int) $params['id']) { $rows = $this->_iaDb->all(iaDb::ALL_COLUMNS_SELECTION, '`menu_id` = ' . $name . ' ORDER BY `id`', null, null, 'menus'); foreach ($rows as $row) { $output[$row['parent_id']][] = $row; } $output = recursiveRead($output); } break; case 'titles': $output['languages'] = array(); $languagesList = $this->_iaCore->languages; $node = isset($params['id']) ? iaSanitize::sql($params['id']) : false; $entry = isset($params['menu']) ? iaSanitize::sql($params['menu']) : false; if (isset($params['new']) && $params['new']) { ksort($languagesList); foreach ($languagesList as $code => $language) { $output['languages'][] = array('fieldLabel' => $language['title'], 'name' => $code, 'value' => ''); } } elseif ($node && $entry) { $key = false; $title = iaLanguage::get('page_title_' . $node, 'none'); if ($title != 'none') { $key = 'page_title_' . $node; } else { if ($pageId = (int) $node) { $page = $this->_iaDb->one('`name`', iaDb::convertIds($pageId), 'pages'); $key = 'page_title_' . $page; } else { $current = isset($params['current']) ? $params['current'] : ''; ksort($languagesList); foreach ($languagesList as $code => $language) { $output['languages'][] = array('fieldLabel' => $language['title'], 'name' => $code, 'value' => $current); } } } if ($key) { $titles = $this->_iaDb->all(iaDb::ALL_COLUMNS_SELECTION, "`key` = '{$key}' ORDER BY `code`", null, null, iaLanguage::getTable()); foreach ($titles as $row) { if (isset($languagesList[$row['code']])) { $output['languages'][] = array('fieldLabel' => $languagesList[$row['code']]['title'], 'name' => $row['code'], 'value' => $row['value']); } } } $output['key'] = $key; } break; case 'save': $output['message'] = iaLanguage::get('invalid_parameters'); $menu = isset($params['menu']) ? $params['menu'] : null; $node = isset($params['node']) ? $params['node'] : null; if ($menu && $node) { $rows = array(); foreach ($_POST as $code => $value) { $rows[] = array('code' => $code, 'value' => $value, 'extras' => $menu, 'key' => 'page_title_' . $node, 'category' => iaLanguage::CATEGORY_PAGE); } $this->_iaDb->setTable(iaLanguage::getTable()); $this->_iaDb->delete('`key` = :key', null, array('key' => 'page_title_' . $node)); $this->_iaDb->insert($rows); $this->_iaDb->resetTable(); $output['message'] = iaLanguage::get('saved'); $output['success'] = true; $this->_iaCore->iaCache->remove('menu_' . $menu . '.inc'); } break; default: $output = parent::_gridRead($params); } return $output; }
protected function _gridRead($params) { return $this->_iaCore->requestPath && 'store' == end($this->_iaCore->requestPath) ? $this->_getUsergroups() : parent::_gridRead($params); }
protected function _gridRead($params) { return count($this->_iaCore->requestPath) == 1 && 'positions' == $this->_iaCore->requestPath[0] ? $this->_getPositions() : parent::_gridRead($params); }
protected function _gridRead($params) { return isset($params['get']) && 'tabs' == $params['get'] ? $this->_iaDb->onefield('name', "`item` = '{$params['item']}' AND `name` != '{$params['name']}' AND `tabview` = 1") : parent::_gridRead($params); }