I'll continue here from the previous post (you can find it here:
http://www.jeasyui.com/forum/index.php?topic=2079.0)marked as solved from the owner.
Summary:
I've a combobox (provincia) chained to another one (comune).
Both comboboxes are populated from data in mysql.
Actually the chained comboboxes work correctly but when I save on db (in the relate table I've 2 colums (provincia and comune), also using the code in the example presented here:
http://jsfiddle.net/hrvKP/, and the row is not anymore editable, I see on the "provincia" column the valueField value and not textField string as expected.
Here the code:
<script type="text/javascript">
$(function(){
$('#dgb').edatagrid({
url: 'leggi_records_b.php',
saveUrl: 'salva_records_b.php',
updateUrl: 'aggiorna_records_b.php',
destroyUrl: 'cancella_records_b.php',
columns:[[
{field:'provincia',
title:'PROVINCIA',
width:15,
align:'center',
sortable:'true',
formatter:function(value,row){
return row.provincia;
},
editor:{
type:'combobox',
options:{
url:'combobox_provincia.php',
valueField:'idprovincia',
textField:'siglaprovincia',
required:true,
editable:false,
onChange:function(value){
var index = $(this).closest('tr.datagrid-row').attr('datagrid-row-index');
var ed = $('#dgb').edatagrid('getEditor',{index:index,field:'comune'});
$(ed.target).combobox('reload','combobox_comuninew.php?prov='+value);
var row = $('#dgb').datagrid('getRows')[index];
row['tmpname'] = value;
var data = $(this).combobox('getData');
for(var i=0; i<data.length; i++){
var d = data[i];
if (d['idprovincia'] == value){
row['tmpname'] = d['siglaprovincia'];
return;
}
}
}
}}},
{field:'comune',
title:'COMUNE INTERESSATO',
width:40,
align:'center',
sortable:'true',
editor:{
type:'combobox',
options:{
valueField:'nomecomune',
textField:'nomecomune',
required:true,
editable:false
}
}
}
]],
onAfterEdit:function(index,row){
$(this).edatagrid('updateRow',{
index:index,
row:{provincia:row.tmpname}
});
}
Thanks in advance to anyone can help me to find the definitive solution to this code nightmare
