Forum


00:40

08/05/2012

Hi,
I would like to include a combo box in the inline editing. I am using the following code but when I select a value and I finish the edition, it changes again to the previous value. What am I doing wrong?
Thank you very much in advance.
This is the concrete line:
$grid->setSelect("CustomerID", "SELECT DISTINCT CustomerID, CustomerID FROM orders", true, true, false, array(""=>"Todas"));
This the complete code:
<?php
ini_set("display_errors","1");
require_once 'jq-config.php';
require_once "php/jqAutocomplete.php";
require_once "php/jqCalendar.php";
require_once "php/jqGrid.php";
require_once "php/jqGridPdo.php";
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
$conn->query("SET NAMES utf8");
$grid = new jqGridRender($conn);
$grid->SelectCommand = 'SELECT OrderID, OrderDate, CustomerID, Freight, ShipName FROM orders';
$grid->dataType = 'json';
$grid->table ="orders";
$grid->setPrimaryKeyId("OrderID");
$grid->setColModel();
$grid->setUrl('myfirstgrid.php');
$grid->cacheCount = true;
$grid->setGridOptions(array(
"caption"=>"This is custom Caption",
"rowNum"=>10,
"sortname"=>"OrderID",
"hoverrows"=>true,
"rowList"=>array(10,20,50),
"postData"=>array("grid_recs"=>776)
));
$grid->setColProperty("OrderID", array("label"=>"ID", "width"=>60, "editable"=>false));
$grid->setColProperty("OrderDate", array(
"formatter"=>"date",
"formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y"), "editable"=>false
)
);
$grid->setColProperty("ShipName",array("editable"=>false));
$grid->setDatepicker("OrderDate",array("buttonOnly"=>false));
$grid->setSelect("CustomerID", "SELECT DISTINCT CustomerID, CustomerID FROM orders", true, true, false, array(""=>"Todas"));
$grid->datearray = array('OrderDate');
$grouping = <<< GROUP
jQuery("#grid").jqGrid('setGroupHeaders',{
"useColSpanStyle":false,
"groupHeaders" : [
{ "startColumnName":'OrderID', "numberOfColumns":2, "titleText":'Order Info' },
{ "startColumnName":'CustomerID', "numberOfColumns":3, "titleText":'Shipping Details' }
]
});
GROUP;
$grid->setJSCode($grouping);
$grid->navigator = false;
$onselrow = <<< ONSELROW
function(rowid, selected)
{
if(rowid && rowid !== lastSelection) {
$("#grid").jqGrid('restoreRow', lastSelection);
$("#grid").jqGrid('editRow', rowid, true);
lastSelection = rowid;
}
}
ONSELROW;
$grid->setGridEvent('onSelectRow', $onselrow);
$grid->renderGrid('#grid','#pager',true, null, null, true,true);
$conn = null;
?>
Most Users Ever Online: 715
Currently Online:
66 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66