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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
|
<?php
/*
@author dhtmlx.com
@license GPL, see license.txt
*/
require_once("grid_connector.php");
/*! DataItem class for TreeGrid component
**/
class TreeGridDataItem extends GridDataItem{
private $kids=-1;//!< checked state
function __construct($data,$config,$index){
parent::__construct($data,$config,$index);
$this->im0=false;
}
/*! return id of parent record
@return
id of parent record
*/
function get_parent_id(){
return $this->data[$this->config->relation_id["name"]];
}
/*! assign image to treegrid's item
longer description
@param img
relative path to the image
*/
function set_image($img){
$this->set_cell_attribute($this->config->text[0]["name"],"image",$img);
}
/*! return count of child items
-1 if there is no info about childs
@return
count of child items
*/
function has_kids(){
return $this->kids;
}
/*! sets count of child items
@param value
count of child items
*/
function set_kids($value){
$this->kids=$value;
if ($value)
$this->set_row_attribute("xmlkids",$value);
}
}
/*! Connector for dhtmlxTreeGrid
**/
class TreeGridConnector extends GridConnector{
private $id_swap = array();
/*! constructor
Here initilization of all Masters occurs, execution timer initialized
@param res
db connection resource
@param type
string , which hold type of database ( MySQL or Postgre ), optional, instead of short DB name, full name of DataWrapper-based class can be provided
@param item_type
name of class, which will be used for item rendering, optional, DataItem will be used by default
@param data_type
name of class which will be used for dataprocessor calls handling, optional, DataProcessor class will be used by default.
*/
public function __construct($res,$type=false,$item_type=false,$data_type=false){
if (!$item_type) $item_type="TreeGridDataItem";
if (!$data_type) $data_type="TreeGridDataProcessor";
parent::__construct($res,$type,$item_type,$data_type);
$this->event->attach("afterInsert",array($this,"parent_id_correction_a"));
$this->event->attach("beforeProcessing",array($this,"parent_id_correction_b"));
}
/*! store info about ID changes during insert operation
@param dataAction
data action object during insert operation
*/
public function parent_id_correction_a($dataAction){
$this->id_swap[$dataAction->get_id()]=$dataAction->get_new_id();
}
/*! update ID if it was affected by previous operation
@param dataAction
data action object, before any processing operation
*/
public function parent_id_correction_b($dataAction){
$relation = $this->config->relation_id["db_name"];
$value = $dataAction->get_value($relation);
if (array_key_exists($value,$this->id_swap))
$dataAction->set_value($relation,$this->id_swap[$value]);
}
/*! process treegrid specific options in incoming request
*/
public function parse_request(){
parent::parse_request();
if (isset($_GET["id"]))
$this->request->set_relation($_GET["id"]);
else
$this->request->set_relation("0");
$this->request->set_limit(0,0); //netralize default reaction on dyn. loading mode
}
/*! process treegrid specific options in incoming request
*/
protected function render_set($res){
$output="";
$index=0;
while ($data=$this->sql->get_next($res)){
$data = new $this->names["item_class"]($data,$this->config,$index);
$this->event->trigger("beforeRender",$data);
//there is no info about child elements,
//if we are using dyn. loading - assume that it has,
//in normal mode juse exec sub-render routine
if ($data->has_kids()===-1 && $this->dload)
$data->set_kids(true);
$output.=$data->to_xml_start();
if ($data->has_kids()===-1 || ( $data->has_kids()==true && !$this->dload)){
$sub_request = new DataRequestConfig($this->request);
$sub_request->set_relation($data->get_id());
$output.=$this->render_set($this->sql->select($sub_request));
}
$output.=$data->to_xml_end();
$index++;
}
return $output;
}
/*! renders self as xml, starting part
*/
protected function xml_start(){
return "<rows parent='".$this->request->get_relation()."'>";
}
}
/*! DataProcessor class for Grid component
**/
class TreeGridDataProcessor extends GridDataProcessor{
function __construct($connector,$config,$request){
parent::__construct($connector,$config,$request);
$request->set_relation(false);
}
/*! convert incoming data name to valid db name
converts c0..cN to valid field names
@param data
data name from incoming request
@return
related db_name
*/
function name_data($data){
if ($data=="gr_pid")
return $this->config->relation_id["name"];
else return parent::name_data($data);
}
}
?>
|
