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();
}
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();
}
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");
}
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');
}
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"));
}
<?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");
<?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");
<?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");
<?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");
<?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");
<?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");
<?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");
<?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");
?>
<?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");
?>
<?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");
<?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");
<?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");
<?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");
<?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");
<?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");
<?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");
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
}
<?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");
<?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");
<?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");
<?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");
<?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);
<?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");
<?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");
<?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");
