/** * @param int $dataset_id * @return array */ public function getDatasetInfo($dataset_id) { $dataset_id = (int) $dataset_id; if (!$dataset_id) { return array(); } $sql = "SELECT dataset_name, dataset_key FROM " . $this->db->table("datasets") . " WHERE dataset_id = " . $dataset_id; $result = $this->db->query($sql); if (!$result->row['dataset_name']) { return array(); } $dataset = new ADataset($result->row['dataset_name'], $result->row['dataset_key']); $output['dataset_name'] = $result->row['dataset_name']; $output['dataset_key'] = $result->row['dataset_key']; $output['num_rows'] = sizeof($dataset->getRows()); $output['dataset_properties'] = $dataset->getDatasetProperties(); if (!$output['dataset_properties']) { unset($output['dataset_properties']); } $cols = $dataset->getColumnDefinitions(); if ($cols) { foreach ($cols as $column) { $output['dataset_column_definition'][] = array($column['dataset_column_name'] => $column['dataset_column_type']); } } $output['dataset_column_properties'] = $dataset->getColumnsProperties(); if (!$output['dataset_column_properties']) { unset($output['dataset_column_properties']); } return $output; }
public function main() { $this->loadLanguage('common/header'); $cache_name = 'admin_menu'; //$this->data['menu_items'] = $this->cache->get($cache_name); if (!$this->data['menu_items']) { $menu = new ADataset('menu', 'admin'); $this->data['menu_items'] = $menu->getRows(); // need to resort by sort_order property and exlude disabled extension items $enabled_extension = $this->extensions->getEnabledExtensions(); $offset = 0; // it needs for process repeating order numbers $tmp = array(); foreach ($this->data['menu_items'] as $i => $item) { if ($i > 0) { if ($this->data['menu_items'][$i - 1]['parent_id'] != $item['parent_id']) { $offset = 0; } } //checks for disabled extension if ($item['item_type'] == 'extension') { // looks for this name in enabled extensions list. if is not there - skip it if (!$this->_find_itemId_in_extensions($item['item_id'], $enabled_extension)) { continue; } else { // if all fine - loads language of extension for menu item text show if (strpos($item['item_url'], 'http') === false) { $this->loadLanguage($item['item_id'] . '/' . $item['item_id'], 'silent'); $item['language'] = $item['item_id'] . '/' . $item['item_id']; } } } if (isset($tmp[$item['parent_id']][$item['sort_order']])) { $offset++; } $tmp[$item['parent_id']][$item['sort_order'] + $offset] = $item; } $this->data['menu_items'] = array(); foreach ($tmp as $item) { ksort($item); $this->data['menu_items'] = array_merge($this->data['menu_items'], $item); } unset($tmp); // now set menu array $this->cache->set($cache_name, $this->data['menu_items']); } $this->data['admin_menu'] = $this->_buildMenuArray($this->data['menu_items']); $this->view->assign('menu', $this->data['admin_menu']); $this->processTemplate('common/menu.tpl'); //use to update data before render $this->extensions->hk_UpdateData($this, __FUNCTION__); }
public function getLog($data = array()) { if (!isset($data['sort'])) { $data['sort'] = 'date_added'; } if ($data['offset'] < 0) { $data['offset'] = 0; } if ($data['limit'] < 1) { $data['limit'] = 10; } $dataset = new ADataset('install_upgrade_history', 'admin'); $rows = $dataset->getRows(array(), $data['sort'], $data['limit'], $data['offset']); return $rows; }