],
- fields : [
- {
- 'name': 'active',
- 'type': 'boolean'
- },
- {
- 'name': 'dataIndex',
- 'type': 'string'
- },
- {
- 'name': 'type',
- 'type': 'string'
- },
- {
- 'name': 'title',
- 'type': 'string'
- },
- {
- 'name': 'width',
- 'type': 'int'
- },
- {
- 'name': 'ftype',
- 'type': 'string'
- },
- {
- 'name': 'display_field',
- 'type': 'string'
- }
+ fields : [
+ 'active',
+ 'dataIndex',
+ 'type',
+ 'title',
+ 'width',
+ 'ftype',
+ 'display_field',
+ 'relates_to_table',
+ 'relates_to_col',
+ 'relates_to_schema'
],
id : 'dataindex',
xns : Roo.data,
store : {
'|xns' : 'Roo.data',
data : [
- [ 'ComboBox', "ComboBox"],
- [ 'Text' , "TextField"],
- [ 'Number', "NumberField"],
- [ 'TextArea', "TextArea"],
- [ 'Html', "HtmlEntry"]
-
+ ['id']
],
- fields : [ 'ftype', 'fname'],
+ fields : [ 'dfield'],
xns : Roo.data,
xtype : 'SimpleStore'
},
'|xns' : 'Roo.form',
allowBlank : false,
- displayField : 'fname',
+ displayField : 'dfield',
editable : false,
hiddenName : 'status',
listWidth : 200,
mode : 'local',
name : 'display_field',
triggerAction : 'all',
- valueField : 'ftype',
+ valueField : 'dfield',
width : 150,
xns : Roo.form,
xtype : 'ComboBox',
}
],
listeners : {
+ beforeedit : function (e)
+ {
+ Roo.log('before edit!!!');
+ Roo.log(e);
+
+ if(e.field != 'dfield'){
+ return false;
+ }
+
+ _this.grid.colModel.getCellEditor(e.column, e.row).field.store.loadData(e.record.data.relates_to_schema);
+ },
cellclick : function (_self, rowIndex, columnIndex, e)
{
//alert("IPC:TEST:" + JSON.stringify(data,null,4));
- var ar = [];
+ var fields = _this.grid.dataSource.reader.recordType.prototype.fields;
+
+
+ var d = [];
+
for (var k in data) {
var r = data[k];
- var has_s = typeof(r.relates_to_schema) != 'undefined'
+ var has_s = typeof(r.relates_to_schema) != 'undefined';
- var d = {
- active : !has_s,
- dataIndex : r.Field
+ var rt = '', rc = '', rs = [];
+
+ if(has_s){
+ for (var kk in r.relates_to_schema) {
+ var rr = r.relates_to_schema[kk];
+
+ rt = r.relates_to_table;
+ rc = r.relates_to_col;
+
+ rs.push([rr.Field]);
+
+ }
}
- ar.push(d);
- /*
- ar.push([ !has_s , r.Field, r.Type, r.Field, 100 , 'TextField', r.Field + '_display_name'] );
+
+ var o = {
+ active : !has_s,
+ dataIndex : r.Field,
+ type : r.Type,
+ title : r.Field,
+ width : 100,
+ ftype : 'TextField',
+ display_field : r.Field + '_display_name',
+ relates_to_table : rt,
+ relates_to_col : rc,
+ relates_to_schema : rs
+ };
+
+ d.push(o);
+
if (!has_s) {
continue;
}
if (rr.Field == r.relates_to_col) {
continue;
}
- ar.push([ false, r.Field + '_'+ rr.Field, rr.Type, rr.Field, 100] );
+
+ var o = {
+ active : false,
+ dataIndex : r.Field + '_'+ rr.Field,
+ type : r.Type,
+ title : r.Field,
+ width : 100
+ };
+
+ d.push(o);
}
- */
}
+
+ var ar = [];
+
+ Roo.each(d, function(dd){
+
+ var a = [];
+
+ for(var j = 0; j < fields.length; j++){
+ var f = fields.items[j];
+
+ if(dd.hasOwnProperty(f.name)){
+ a.push(dd[f.name]);
+ }
+ }
+
+ ar.push(a);
+ });
+
+
Roo.log(ar);
this.schema = data;