EasyUI Forum
May 14, 2024, 05:21:02 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: how to get specific field value of row on edatagrid to pass in URL editor  (Read 22721 times)
putusundika
Newbie
*
Posts: 13


View Profile Email
« on: August 11, 2012, 10:04:15 PM »

hi there..
i have datagrid (edatagrid), retrieve from table PART (part,idsupplier)
edatagrid has 2 column with only one is inline editing (combobox).
This combobox will retrieve data from table SUPPLIER (idsupplier,namesupplier) through URL supplier.php. and everythings OK.
But, since datagrid only for editing (no addrow), and each supplier have a category, I need to add parameter on url. so the new URL is supplier.php?idcat=XX.  (contains of each combobox is different each row, depends on idcat.

"XX" will be the value of field idpart on table PART.

How do I write down this XX value ?

Code:
<table id="dlgt"
toolbar="#toolbartag" pagination="true"
rownumbers="true" fitColumns="false" singleSelect="true" idField="idpart">
<thead>
<tr>
<th field="part" width="200" sortable="true">Part</th>
<th field="namesupplier" width="350" sortable="true"
editor="{type:'combobox', options{url:'supplier.php?idcat=XX', valueField:'idsupplier',
                                textField:'namesupplier', required:true}}">Supplier</th>
</tr>
</thead>
</table>


thanks for your great support..
best regards
Putu
Logged
stworthy
Administrator
Hero Member
*****
Posts: 3581


View Profile Email
« Reply #1 on: August 12, 2012, 07:17:22 PM »

When editing a row, the 'onEdit' event will be triggered, in which the 'idcat' field value is available. Please download the updated edatagrid plugin from below link:
http://www.jeasyui.com/extension/downloads/jquery-easyui-edatagrid.zip

Code:
$('#dlgt').edatagrid({
onEdit:function(index,row){
var ed = $(this).edatagrid('getEditor',{
index:index,
field:'namesupplier'
});
$(ed.target).combobox('reload','supplier.php?idcat='+row.idcat);
}
});
Logged
putusundika
Newbie
*
Posts: 13


View Profile Email
« Reply #2 on: August 15, 2012, 09:03:53 AM »

awesome, thank you stworthy

this is my final code :
Code:
function tagData(){
 var row = $('#dg').datagrid('getSelected');
  if (row){
   $('#dlgtag').dialog('open').dialog('setTitle','Set Supplier');
    $(function(){
$('#dlgt').edatagrid({
  onEdit:function(index,row){
   var ed = $(this).edatagrid('getEditor',{
index:index,
field:'name_supplier'
});
$(ed.target).combobox('reload','supplier.php?id='+row.id_part_cat);
},
url: 'get_data1.php?id='+row.idfbrequestpo,
updateUrl: 'update_ing.php?idx='+row.idfbrequestpo,
columns:[[
{field:'name_part',title:'name of part',width:100,
editor:{type:'text'}},
{field:'name_supplier',title:'supplier',width:100,
editor:{type:'combobox',options:{
valueField:'id_supplier',textField:'name_supplier',required:true}}
}
]],
});
    });}
}

now, only related part category will be listed in combobox.
regards
putu
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!