displayName = $this->getDisplayName($item); parent::__construct($item['name'], $type, $isGroup); $this->icon = Util::getImage($this->getColumnIcon($item['key']), __('Column')); $this->links = [ 'text' => 'tbl_structure.php?server=' . $GLOBALS['server'] . '&db=%3$s&table=%2$s&field=%1$s' . '&change_column=1', 'icon' => 'tbl_structure.php?server=' . $GLOBALS['server'] . '&db=%3$s&table=%2$s&field=%1$s' . '&change_column=1', 'title' => __('Structure'), ]; } /** * Get customized Icon for columns in navigation tree * * @param string $key The key type - (primary, foreign etc.) * * @return string Icon name for required key. */ private function getColumnIcon($key) { switch ($key) { case 'PRI': $retval = 'b_primary'; break; case 'UNI': $retval = 'bd_primary'; break; default: $retval = 'pause'; break; } return $retval; } /** * Get displayable name for navigation tree (key_type, data_type, default) * * @param array $item Item is array containing required info * * @return string Display name for navigation tree */ private function getDisplayName($item) { $retval = $item['name']; $flag = 0; foreach ($item as $key => $value) { if (! empty($value) && $key != 'name') { $flag == 0 ? $retval .= ' (' : $retval .= ', '; $flag = 1; $retval .= $this->getTruncateValue($key, $value); } } $retval .= ')'; return $retval; } /** * Get truncated value for display in node column view * * @param string $key key to identify default,datatype etc * @param string $value value corresponding to key * * @return string truncated value */ public function getTruncateValue($key, $value) { $retval = ''; switch ($key) { case 'default': strlen($value) > 6 ? $retval .= substr($value, 0, 6) . '...' : $retval = $value; break; default: $retval = $value; break; } return $retval; } }