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
|
<?php
namespace Dhtmlx\Connector;
/*! Connector class for dhtmlxGantt
**/
class GanttConnector extends Connector {
protected $extra_output="";//!< extra info which need to be sent to client side
protected $options=array();//!< hash of OptionsConnector
protected $links_mode = false;
/*! assign options collection to the column
@param name
name of the column
@param options
array or connector object
*/
public function set_options($name,$options){
if (is_array($options)){
$str="";
foreach($options as $k => $v)
$str.="<item value='".$this->xmlentities($k)."' label='".$this->xmlentities($v)."' />";
$options=$str;
}
$this->options[$name]=$options;
}
/*! 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.
* @param render_type
name of class which will be used for rendering.
*/
public function __construct($res,$type=false,$item_type=false,$data_type=false,$render_type=false){
if (!$item_type) $item_type="Dhtmlx\\Connector\\Data\\GanttDataItem";
if (!$data_type) $data_type="Dhtmlx\\Connector\\DataProcessor\\GanttDataProcessor";
if (!$render_type) $render_type="Dhtmlx\\Connector\\Output\\RenderStrategy";
parent::__construct($res,$type,$item_type,$data_type,$render_type);
$this->event->attach("afterDelete", array($this, "delete_related_links"));
$this->event->attach("afterOrder", array($this, "order_set_parent"));
}
//parse GET scoope, all operations with incoming request must be done here
function parse_request(){
parent::parse_request();
if (isset($_GET["gantt_mode"]) && $_GET["gantt_mode"] == "links")
$this->links_mode = true;
if (count($this->config->text)){
if (isset($_GET["to"]))
$this->request->set_filter($this->config->text[0]["name"],$_GET["to"],"<");
if (isset($_GET["from"]))
$this->request->set_filter($this->config->text[1]["name"],$_GET["from"],">");
}
}
function order_set_parent($action){
$value = $action->get_id();
$parent = $action->get_value("parent");
$table = $this->request->get_source();
$id = $this->config->id["db_name"];
$this->sql->query("UPDATE $table SET parent = $parent WHERE $id = $value");
}
function delete_related_links($action){
if (isset($this->options["links"])){
$links = $this->options["links"];
$value = $this->sql->escape($action->get_new_id());
$table = $links->get_request()->get_source();
$this->sql->query("DELETE FROM $table WHERE source = '$value'");
$this->sql->query("DELETE FROM $table WHERE target = '$value'");
}
}
public function render_links($table,$id="",$fields=false,$extra=false,$relation_id=false) {
$links = new GanttLinksConnector($this->get_connection(),$this->names["db_class"]);
$links->render_table($table,$id,$fields,$extra);
$this->set_options("links", $links);
}
}
|