1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Functionality for the navigation tree
*
* @package PhpMyAdmin-Navigation
*/
declare(strict_types=1);
namespace PhpMyAdmin\Navigation\Nodes;
use PhpMyAdmin\Util;
/**
* Represents a columns node in the navigation tree
*
* @package PhpMyAdmin-Navigation
*/
class NodeColumn extends Node
{
/**
* Initialises the class
*
* @param array $item array to identify the column node
* @param int $type Type of node, may be one of CONTAINER or OBJECT
* @param bool $isGroup Whether this object has been created
* while grouping nodes
*/
public function __construct($item, $type = Node::OBJECT, $isGroup = false)
{
$this->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;
}
}
|
