summaryrefslogtreecommitdiffstats
path: root/codebase/gantt_connector.php
diff options
context:
space:
mode:
authorKirylka <kirylanoshko@gmail.com>2015-03-31 17:56:47 +0300
committerKirylka <kirylanoshko@gmail.com>2015-03-31 17:56:47 +0300
commitf5f99c335707d9b11d40f1eb0f6ddb5a993fd31a (patch)
treed9c0d3532ec9f0f2fb68e31d2611282ae0642181 /codebase/gantt_connector.php
parent458f0aead573842f1df00ce2ae00334c27f66585 (diff)
downloadconnector-php-f5f99c335707d9b11d40f1eb0f6ddb5a993fd31a.zip
connector-php-f5f99c335707d9b11d40f1eb0f6ddb5a993fd31a.tar.gz
connector-php-f5f99c335707d9b11d40f1eb0f6ddb5a993fd31a.tar.bz2
Creating a new connector for yii2.
Diffstat (limited to 'codebase/gantt_connector.php')
-rw-r--r--codebase/gantt_connector.php364
1 files changed, 0 insertions, 364 deletions
diff --git a/codebase/gantt_connector.php b/codebase/gantt_connector.php
deleted file mode 100644
index 3577835..0000000
--- a/codebase/gantt_connector.php
+++ /dev/null
@@ -1,364 +0,0 @@
-<?php
-/*
- @author dhtmlx.com
- @license GPL, see license.txt
-*/
-require_once("base_connector.php");
-require_once("data_connector.php");
-
-/*! DataItem class for Gantt component
-**/
-class GanttDataItem extends DataItem{
-
- /*! return self as XML string
- */
- function to_xml(){
- if ($this->skip) return "";
-
- $str="<task id='".$this->get_id()."' >";
- $str.="<start_date><![CDATA[".$this->data[$this->config->text[0]["name"]]."]]></start_date>";
- $str.="<".$this->config->text[1]["name"]."><![CDATA[".$this->data[$this->config->text[1]["name"]]."]]></".$this->config->text[1]["name"].">";
- $str.="<text><![CDATA[".$this->data[$this->config->text[2]["name"]]."]]></text>";
- for ($i=3; $i<sizeof($this->config->text); $i++){
- $extra = $this->config->text[$i]["name"];
- $str.="<".$extra."><![CDATA[".$this->data[$extra]."]]></".$extra.">";
- }
- if ($this->userdata !== false)
- foreach ($this->userdata as $key => $value)
- $str.="<".$key."><![CDATA[".$value."]]></".$key.">";
-
- return $str."</task>";
- }
-}
-
-
-/*! 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="GanttDataItem";
- if (!$data_type) $data_type="GanttDataProcessor";
- if (!$render_type) $render_type="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);
- }
-}
-
-/*! DataProcessor class for Gantt component
-**/
-class GanttDataProcessor extends DataProcessor{
- function name_data($data){
- if ($data=="start_date")
- return $this->config->text[0]["name"];
- if ($data=="id")
- return $this->config->id["name"];
- if ($data=="duration" && $this->config->text[1]["name"] == "duration")
- return $this->config->text[1]["name"];
- if ($data=="end_date" && $this->config->text[1]["name"] == "end_date")
- return $this->config->text[1]["name"];
- if ($data=="text")
- return $this->config->text[2]["name"];
-
- return $data;
- }
-}
-
-
-class JSONGanttDataItem extends GanttDataItem{
- /*! return self as XML string
- */
- function to_xml(){
- if ($this->skip) return "";
-
- $obj = array();
- $obj['id'] = $this->get_id();
- $obj['start_date'] = $this->data[$this->config->text[0]["name"]];
- $obj[$this->config->text[1]["name"]] = $this->data[$this->config->text[1]["name"]];
- $obj['text'] = $this->data[$this->config->text[2]["name"]];
- for ($i=3; $i<sizeof($this->config->text); $i++){
- $extra = $this->config->text[$i]["name"];
- $obj[$extra]=$this->data[$extra];
- }
-
- if ($this->userdata !== false)
- foreach ($this->userdata as $key => $value)
- $obj[$key]=$value;
-
- return $obj;
- }
-}
-
-
-class JSONGanttConnector extends GanttConnector {
-
- protected $data_separator = ",";
-
- /*! 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,$render_type=false){
- if (!$item_type) $item_type="JSONGanttDataItem";
- if (!$data_type) $data_type="GanttDataProcessor";
- if (!$render_type) $render_type="JSONRenderStrategy";
- parent::__construct($res,$type,$item_type,$data_type,$render_type);
- }
-
- protected function xml_start() {
- return '{ "data":';
- }
-
- protected function xml_end() {
- $this->fill_collections();
- $end = (!empty($this->extra_output)) ? ', "collections": {'.$this->extra_output.'}' : '';
- foreach ($this->attributes as $k => $v)
- $end.=", \"".$k."\":\"".$v."\"";
- $end .= '}';
- return $end;
- }
-
- /*! 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=array();
- foreach($options as $k => $v)
- $str[]='{"id":"'.$this->xmlentities($k).'", "value":"'.$this->xmlentities($v).'"}';
- $options=implode(",",$str);
- }
- $this->options[$name]=$options;
- }
-
-
- /*! generates xml description for options collections
-
- @param list
- comma separated list of column names, for which options need to be generated
- */
- protected function fill_collections($list=""){
- $options = array();
- foreach ($this->options as $k=>$v) {
- $name = $k;
- $option="\"{$name}\":[";
- if (!is_string($this->options[$name])){
- $data = json_encode($this->options[$name]->render());
- $option.=substr($data,1,-1);
- } else
- $option.=$this->options[$name];
- $option.="]";
- $options[] = $option;
- }
- $this->extra_output .= implode($this->data_separator, $options);
- }
-
-
- /*! output fetched data as XML
- @param res
- DB resultset
- */
- protected function output_as_xml($res){
- $result = $this->render_set($res);
- if ($this->simple) return $result;
-
- $data=$this->xml_start().json_encode($result).$this->xml_end();
-
- if ($this->as_string) return $data;
-
- $out = new OutputWriter($data, "");
- $out->set_type("json");
- $this->event->trigger("beforeOutput", $this, $out);
- $out->output("", true, $this->encoding);
- }
-
- public function render_links($table,$id="",$fields=false,$extra=false,$relation_id=false) {
- $links = new JSONGanttLinksConnector($this->get_connection(),$this->names["db_class"]);
- $links->render_table($table,$id,$fields,$extra);
- $this->set_options("links", $links);
- }
-
-
- /*! render self
- process commands, output requested data as XML
- */
- public function render(){
- $this->event->trigger("onInit", $this);
- EventMaster::trigger_static("connectorInit",$this);
-
- if (!$this->as_string)
- $this->parse_request();
- $this->set_relation();
-
- if ($this->live_update !== false && $this->updating!==false) {
- $this->live_update->get_updates();
- } else {
- if ($this->editing){
- if ($this->links_mode && isset($this->options["links"])) {
- $this->options["links"]->save();
- } else {
- $dp = new $this->names["data_class"]($this,$this->config,$this->request);
- $dp->process($this->config,$this->request);
- }
- } else {
- if (!$this->access->check("read")){
- LogMaster::log("Access control: read operation blocked");
- echo "Access denied";
- die();
- }
- $wrap = new SortInterface($this->request);
- $this->apply_sorts($wrap);
- $this->event->trigger("beforeSort",$wrap);
- $wrap->store();
-
- $wrap = new FilterInterface($this->request);
- $this->apply_filters($wrap);
- $this->event->trigger("beforeFilter",$wrap);
- $wrap->store();
-
- if ($this->model && method_exists($this->model, "get")){
- $this->sql = new ArrayDBDataWrapper();
- $result = new ArrayQueryWrapper(call_user_func(array($this->model, "get"), $this->request));
- $out = $this->output_as_xml($result);
- } else {
- $out = $this->output_as_xml($this->get_resource());
-
- if ($out !== null) return $out;
- }
-
- }
- }
- $this->end_run();
- }
-}
-
-
-class GanttLinksConnector extends OptionsConnector {
- public function render(){
- if (!$this->init_flag){
- $this->init_flag=true;
- return "";
- }
-
- $res = $this->sql->select($this->request);
- return $this->render_set($res);
- }
-
- public function save() {
- $dp = new $this->names["data_class"]($this,$this->config,$this->request);
- $dp->process($this->config,$this->request);
- }
-}
-
-
-class JSONGanttLinksConnector extends JSONOptionsConnector {
- public function render(){
- if (!$this->init_flag){
- $this->init_flag=true;
- return "";
- }
-
- $res = $this->sql->select($this->request);
- return $this->render_set($res);
- }
-
- public function save() {
- $dp = new $this->names["data_class"]($this,$this->config,$this->request);
- $dp->process($this->config,$this->request);
- }
-}
-
-?> \ No newline at end of file