<?php
require_once '../../../jq-config.php';
require_once ABSPATH . "php/jqUtils.php";
require_once ABSPATH . "php/jqGridPdo.php";
require_once ABSPATH . "php/jqChart.php";
ini_set("display_errors", "1");
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
jqGridDB::query($conn, "SET NAMES utf8");
$chart = new jqChart($conn);
$chart->setChartOptions(array("defaultSeriesType" => "line"))->setTitle(array('text' => 'Freight by Month 1997', "x" => -20))->setyAxis(array("title" => array("text" => "Freight")))->setTooltip(array("formatter" => "function(){return '<b>'+ this.series.name +'</b><br/>'+this.x +': '+ this.y;}"))->addSeries('Blauer See Delikatessen', "SELECT MONTH(OrderDate), SUM(Freight) FROM orders WHERE CustomerID =? AND OrderDate BETWEEN '1997-01-01' AND '1997-12-31' GROUP BY MONTH(OrderDate)", array('BERGS'))->addSeries('White Clover Markets', "SELECT MONTH(OrderDate), SUM(Freight) FROM orders WHERE CustomerID =? AND OrderDate BETWEEN '1997-01-01' AND '1997-12-31' GROUP BY MONTH(OrderDate)", array('WHITC'));
echo $chart->renderChart('', true, 700, 350);
<?php
require_once '../../../jq-config.php';
require_once ABSPATH . "php/jqGridPdo.php";
$country = $_GET['q'];
if ($country) {
try {
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
$SQL = "SELECT DISTINCT(City) id, City value FROM customers WHERE Country='" . $country . "' ORDER BY City";
$collation = jqGridDB::query($conn, "SET NAMES utf8");
$city = jqGridDB::query($conn, $SQL);
$result = jqGridDB::fetch_object($city, true, $conn);
echo json_encode($result);
} catch (Exception $e) {
echo $e->getMessage();
}
}
public function setSelect($colname, $data, $formatter = true, $editing = true, $seraching = true, $defvals = array())
{
$s1 = array();
$prop = array();
$oper = $this->GridParams["oper"];
$goper = jqGridUtils::GetParam($oper, 'nooper');
if ($goper == 'nooper' || $goper == $this->GridParams["excel"]) {
$runme = true;
} else {
$runme = !in_array($goper, array_values($this->GridParams));
}
if (!$this->runSetCommands && !$runme) {
return false;
}
if (count($this->colModel) > 0 && $runme) {
if (is_string($data)) {
$aset = jqGridDB::query($this->pdo, $data);
if ($aset) {
while ($row = jqGridDB::fetch_num($aset)) {
$s1[$row[0]] = $row[1];
}
jqGridDB::closeCursor($aset);
}
} else {
if (is_array($data)) {
$s1 = $data;
}
}
if ($editing) {
$prop = array_merge($prop, array('edittype' => 'select', 'editoptions' => array('value' => $s1)));
}
if ($formatter) {
$prop = array_merge($prop, array('formatter' => 'select', 'editoptions' => array('value' => $s1)));
}
if ($seraching) {
if (is_array($defvals) && count($defvals) > 0) {
$s1 = $defvals + $s1;
}
$prop = array_merge($prop, array("stype" => "select", "searchoptions" => array("value" => $s1)));
}
if (count($prop) > 0) {
$this->setColProperty($colname, $prop);
}
return true;
}
return false;
}
/**
*
* Construct the select used in the grid. The select element can be used in the
* editing modules, in formatter or in search module
* @param string $colname (requiered) valid colname in colmodel
* @param mixed $data can be array (with pair key value) or string which is
* the SQL command which is executed to obtain the values. The command should contain a
* minimun two fields. The first is the key and the second is the value whch will
* be displayed in the select
* @param boolean $formatter deternines that the select should be used in the
* formatter of type select. Default is true
* @param boolean $editing determines if the select should be used in editing
* modules. Deafult is true
* @param boolean $seraching determines if the select should be present in
* the search module. Deafult is true.
* @param array $defvals Set the default value if none is selected. Typically this
* is usefull in serch modules. Can be something like arrar(""=>"All");
* @return boolean
*/
public function setSelect($colname, $data, $formatter = true, $editing = true, $seraching = true, $defvals = array(), $sep = ":", $delim = ";")
{
$s1 = "";
//array();
//new stdClass();
$prop = array();
//$oper = $this->GridParams["oper"];
$goper = $this->oper ? $this->oper : 'nooper';
if ($goper == 'nooper' || $goper == $this->GridParams["excel"]) {
$runme = true;
} else {
$runme = !in_array($goper, array_values($this->GridParams));
}
if (!$this->runSetCommands && !$runme) {
return false;
}
if (count($this->colModel) > 0 && $runme) {
if (is_string($data)) {
$aset = jqGridDB::query($this->pdo, $data);
if ($aset) {
$i = 0;
$s = '';
while ($row = jqGridDB::fetch_num($aset)) {
if ($i == 0) {
$s1 .= $row[0] . $sep . $row[1];
} else {
$s1 .= $delim . $row[0] . $sep . $row[1];
}
$i++;
}
}
jqGridDB::closeCursor($aset);
} else {
if (is_array($data)) {
$i = 0;
foreach ($data as $k => $v) {
if ($i == 0) {
$s1 .= $k . $sep . $v;
} else {
$s1 .= $delim . $k . $sep . $v;
}
$i++;
}
//$s1 = $data;
}
}
if ($editing) {
$prop = array_merge($prop, array('edittype' => 'select', 'editoptions' => array('value' => $s1, 'separator' => $sep, 'delimiter' => $delim)));
}
if ($formatter) {
$prop = array_merge($prop, array('formatter' => 'select', 'editoptions' => array('value' => $s1, 'separator' => $sep, 'delimiter' => $delim)));
}
if ($seraching) {
if (is_array($defvals) && count($defvals) > 0) {
//$s1 = $defvals+$s1;
foreach ($defvals as $k => $v) {
$s1 = $k . $sep . $v . $delim . $s1;
}
}
$prop = array_merge($prop, array("stype" => "select", "searchoptions" => array("value" => $s1, 'separator' => $sep, 'delimiter' => $delim)));
}
if (count($prop) > 0) {
$this->setColProperty($colname, $prop);
}
return true;
}
return false;
}
include_once "../ip-config.php";
require_once '../jq-config.php';
// include the jqGrid Class
require_once ABSPATH . "php/jqGrid.php";
// include the driver class
require_once ABSPATH . "php/jqGridPdo.php";
// Connection to the server
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");
$rowid = jqGridUtils::Strip($_REQUEST["rowid"]);
if (!$rowid) {
die("Missed parameters");
}
// Get details
$SQL = "SELECT notes FROM project, priority, status WHERE id =" . (int) $rowid;
$qres = jqGridDB::query($conn, $SQL);
$result = jqGridDB::fetch_assoc($qres, $conn);
$s = "<table width='60%' align='left'><tbody>";
$s .= "<tr><td width='15%'><b>Notes</b></td><td width='85%'>" . $result["notes"] . "</td></tr>";
$s .= "<tr><td width='15%'><b> </b></td><td width='85%'> </td></tr>";
$s .= "<tr><td width='15%'><b>Priority</b></td><td width='85%'>" . $result["priority"] . "</td></tr>";
$s .= "<tr><td width='15%'><b> </b></td><td width='85%'> </td></tr>";
$s .= "<tr><td width='15%'><b>Status</b></td><td width='85%'>" . $result["status"] . "</td></tr>";
$s .= "<tr><td width='15%'><b> </b></td><td width='85%'> </td></tr>";
$s .= "</tbody></table>";
echo $s;
jqGridDB::closeCursor($qres);
?>
