PHP GridConnector Examples

Example #1

File: grid.php Project: FAVHYAN/a3workout

 public function data()
 {
     //data feed
     $this->load->database();
     $connector = new GridConnector($this->db, "phpCI");
     $connector->configure("events", "event_id", "start_date, end_date, event_name");
     $connector->event->attach($this);
     $connector->render();
 }

Example #2

File: gridmodel.php Project: FAVHYAN/a3workout

 public function data()
 {
     //data feed
     $this->load->database();
     $this->load->model("event_model");
     $connector = new GridConnector($this->db, "PHPCI");
     $connector->configure("events", "event_id", "start_date, end_date, event_name");
     $connector->useModel($this->event_model);
     $connector->render();
 }

Example #3

File: DBController.php Project: AxelANGENAULT/CoreBundle

 public function filter_gridAction()
 {
     require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/grid_connector.php';
     $database_host = $this->container->getParameter('database_host');
     $database_port = $this->container->getParameter('database_port');
     $database_name = $this->container->getParameter('database_name');
     $database_user = $this->container->getParameter('database_user');
     $database_password = $this->container->getParameter('database_password');
     $conn = mysql_connect($database_host, $database_user, $database_password);
     mysql_select_db($database_name);
     $data = new \GridConnector($conn);
     $data->render_table('arii_filter', "ID", "filter,title,spooler,job,job_chain,order_id,status");
 }

Example #4

File: DBController.php Project: cleverage/JOEBundle

 public function jobsAction()
 {
     require_once '../vendor/dhtmlx/dhtmlxConnector/codebase/grid_connector.php';
     $database_host = $this->container->getParameter('database_host');
     $database_port = $this->container->getParameter('database_port');
     $database_name = $this->container->getParameter('database_name');
     $database_user = $this->container->getParameter('database_user');
     $database_password = $this->container->getParameter('database_password');
     $conn = mysql_connect($database_host, $database_user, $database_password);
     mysql_select_db($database_name);
     $data = new \GridConnector($conn);
     $qry = "select name,title,spooler_id,process_class,visible from joe_job order by name";
     $data->event->attach("beforeRender", array($this, "render_jobs"));
     $data->render_sql($qry, 'ID', 'name,title,spooler_id,process_class,visible');
 }

Example #5

File: keygrid_connector.php Project: elsonvinicius/huab

 public function __construct($res, $type = false, $item_type = false, $data_type = false)
 {
     if (!$item_type) {
         $item_type = "GridDataItem";
     }
     if (!$data_type) {
         $data_type = "KeyGridDataProcessor";
     }
     parent::__construct($res, $type, $item_type, $data_type);
     $this->event->attach("beforeProcessing", array($this, "before_check_key"));
     $this->event->attach("afterProcessing", array($this, "after_check_key"));
 }

Example #6

File: 05_select_filter_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res, "PDO");
$grid->dynamic_loading(100);
$grid->render_table("countries", "item_id", "item_nm,item_cd");

Example #7

File: xx_sample_postgresql_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
$postrgre_connection = "host=192.168.1.251 port=5432 dbname=sampledb user=pguser password=pgpass";
$res = pg_connect($postrgre_connection);
require "../../codebase/grid_connector.php";
require "../../codebase/db_postgre.php";
$grid = new GridConnector($res, "PDO", "Postgre");
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #8

File: contacts.php Project: xgbj/share_platom_upload

<?php

require "../codebase/connector/grid_connector.php";
$res = mysql_connect("localhost", "root", "");
mysql_select_db("dhtmlx_tutorial");
$conn = new GridConnector($res, "MySQL");
$conn->render_table("contacts", "contact_id", "fname,lname,email");

Example #9

File: 06_combo_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->dynamic_loading(100);
/*$filter1 = new OptionsConnector($res);
	$filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
	$grid->set_options("item_nm",$filter1);*/
$filter1 = new OptionsConnector($res);
$filter1->render_table("countries", "item_id", "item_id(value),item_nm(label)");
$grid->set_options("item_nm", $filter1);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #10

File: xx_sample_sqlite3_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
$db = new SQLite3('mysqlitedb.db');
require "../../codebase/grid_connector.php";
require "../../codebase/db_sqlite3.php";
$grid = new GridConnector($db, "SQLite3");
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #11

File: xx_sample_mysqli_connector.php Project: quantrocket/planlogiq

<?php

require "../config.php";
require "../../codebase/db_mysqli.php";
require "../../codebase/grid_connector.php";
$mysqli = new mysqli($server, $user, $pass, $mysql_db);
if (mysqli_connect_errno()) {
    printf("Подключение к серверу MySQL невозможно. Код ошибки: %s\n", mysqli_connect_error());
    exit;
}
$grid = new GridConnector($mysqli, "MySQLi");
$grid->enable_log("temp.log", true);
$grid->render_table("events", "event_id", "event_name,details");

Example #12

File: xx_sample_sasql_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = sasql_connect($sasql_conn);
require "../../codebase/grid_connector.php";
require "../../codebase/db_sasql.php";
$grid = new GridConnector($res, "SaSQL");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_table("Contacts", "ID", "Surname,GivenName,Title");

Example #13

File: gridGenerators.php Project: neohusky/NMIS

<?php

require_once 'config.php';
require_once "../codebase/dhtmlx/grid_connector.php";
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_table("Generators", "generator_id", "generator_id,batch_number ,supplier_name ,arrival_date ,arrival_username,decommission_date,decommission_username");
?>

Example #14

File: gridGeneratorsActive.php Project: neohusky/NMIS

<?php

require_once 'config.php';
require_once "../codebase/dhtmlx/grid_connector.php";
$conn = new GridConnector($conn);
$conn->enable_log("log.txt", true);
$conn->render_complex_sql("SELECT * FROM generators WHERE decommission_date IS NULL", "generator_id", "generator_id,batch_number ,supplier_name ,arrival_date ,arrival_username,decommission_date,decommission_username,return_date,qc_moly_status,qc_alum__status,qc_visual_status,site");
?>

Example #15

File: 10_auto_config.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res, "PDO");
$grid->set_config(false);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #16

File: 13_filesystem_grid_connector.php Project: quantrocket/planlogiq

<?php

require "../../codebase/db_filesystem.php";
require "../../codebase/grid_connector.php";
$grid = new GridConnector("c:/", "FileSystem");
$grid->render_table("../", "safe_name", "filename,full_filename,size,name,extention,date,is_folder");

Example #17

File: 05_live_update_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require "../../codebase/db_pdo.php";
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/treegrid_connector.php";
$treegrid = new GridConnector($res, "PDO");
$treegrid->enable_log("temp.log", true);
$treegrid->enable_live_update("actions_table");
$treegrid->render_table("tasks", "taskId", "taskName,duration,complete", "", "parentId");

Example #18

File: xx_sample_oracle_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = oci_connect($oci_dbuser, $oci_dbpass, $oci_dbname);
require "../../codebase/grid_connector.php";
require "../../codebase/db_oracle.php";
$grid = new GridConnector($res, "Oracle");
$grid->dynamic_loading(50);
$grid->sql->sequence("EMPLOYEES_INC.nextVal");
$grid->render_table("EMPLOYEES", "EMPLOYEE_ID", "FIRST_NAME,LAST_NAME");

Example #19

File: excel.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
require "../../codebase/convert.php";
$convert = new ConvertService("http://dhtmlxgrid.appspot.com/export/excel");
$convert->excel();
$grid = new GridConnector($res);
$config = new GridConfiguration();
$grid = new GridConnector($res);
$grid->set_config($config);
$grid->render_table("grid50");

Example #20

File: xx_sample_postgresql_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = pg_connect($postrgre_connection);
require "../../codebase/grid_connector.php";
require "../../codebase/db_postgre.php";
$grid = new GridConnector($res, "Postgre");
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #21

File: 02_easyfilter_connector.php Project: slothfk/connector-php

<?php

require_once "../config.php";
require_once '../../codebase/db_pdo.php';
$res = new PDO($mysql_server, $mysql_user, $mysql_pass);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res, "PDO");
$grid->dynamic_loading(100);
$grid->filter("item_nm", "member");
//	$grid->filter("item_nm='member'");
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");

Example #22

File: treegrid_connector.php Project: elsonvinicius/huab

 public function parse_request()
 {
     parent::parse_request();
     if (isset($_GET[$this->parent_name])) {
         $this->request->set_relation($_GET[$this->parent_name]);
     } else {
         $this->request->set_relation($this->rootId);
     }
     $this->request->set_limit(0, 0);
     //netralize default reaction on dyn. loading mode
 }

Example #23

File: 06a_combo_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
/*$filter1 = new OptionsConnector($res);
	$filter1->render_table("countries","item_id","item_id(value),item_nm(label)");
	$grid->set_options("item_nm",$filter1);*/
$grid->set_options("item_nm", array("1", "two", "3"));
$grid->set_options("item_cd", array("91" => "one", "75" => "two"));
$grid->sql->set_transaction_mode("record");
$grid->render_table("grid50", "item_id", "item_nm,item_cd");

Example #24

File: pdf.php Project: quantrocket/planlogiq

<?php

require_once "../../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../../codebase/grid_connector.php";
require "../../../codebase/convert.php";
$convert = new ConvertService("http://192.168.1.16/dhtmlxdev/ExportTools/grid2pdf/generate.php");
$grid = new GridConnector($res);
$grid->set_config(new GridConfiguration());
$grid->render_table("grid50");

Example #25

File: 11_live_update_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$grid->enable_live_update('actions_table');
$grid->render_table("grid50", "item_id", "item_nm,item_cd");

Example #26

File: 01a_sql_basic_connector.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$gridConn = new GridConnector($res);
$sql = "SELECT * FROM grid50";
$gridConn->render_sql($sql, "item_id", "item_nm,item_cd");

Example #27

File: sql.php Project: quantrocket/planlogiq

<?php

require_once '../../../codebase/grid_connector.php';
require_once '../../config.php';
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
$grid = new GridConnector($res);
$grid->enable_log("sql.log");
$grid->configure("grid50000", "item_id", "item_nm,item_cd");
$sql = $grid->sql;
echo $id = $grid->insert(array("item_nm" => "1", "item_cd" => Null));
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next());
echo "<hr>";
echo $grid->update(array("item_id" => $id, "item_nm" => "2"));
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next());
echo "<hr>";
echo $grid->delete($id);
echo "<hr>";
$sql->query("SELECT * FROM grid50000 WHERE item_id=" . $id);
print_r($sql->get_next() == Null);

Example #28

File: gridWorklist.php Project: neohusky/NMIS

<?php

require_once 'config.php';
require_once '../codebase/dhtmlx/grid_connector.php';
$grid = new GridConnector($conn);
$grid->enable_log("log.txt", true);
$grid->render_complex_sql("SELECT `DicomWorklist`.* FROM DicomWorklist INNER JOIN DicomWorklistExclude ON `DicomWorklist`.`RequestedProcedureDescription` = `DicomWorklistExclude`.`RequestedProcedureDescription`", "StudyInstanceUID", "PatientName, PatientID, PatientDOB, PatientSex, RequestedProcedureDescription, CurrentPatientLocation, Modality");

Example #29

File: 01a_sql_basic_connector.php Project: quantrocket/planlogiq

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
$grid = new GridConnector($res);
$grid->enable_log("temp.log", true);
$grid->dynamic_loading(100);
$grid->render_sql("SELECT grid50000.item_id as ID , grid50000.item_nm FROM grid50000", "item_id(ID)", "grid50000.item_id(ID),item_nm");

Example #30

File: grid_csrf.php Project: elsonvinicius/framework

<?php

require_once "../config.php";
$res = mysql_connect($mysql_server, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);
require "../../codebase/grid_connector.php";
ConnectorSecurity::$security_key = true;
$grid = new GridConnector($res);
$grid->set_limit(10);
$grid->render_table("grid50000", "item_id", "item_nm,item_cd");