|
ExtJS в разрезе апекса. за и против.
#36272069
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
Ссылка на профиль пользователя:
|
|
|
|
2 kasik
и будешь прав! правильный выбор!
вот пример создания таблици, если кому интересно
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
Ext.onReady(function(){
var store = new Ext.data.Store({
remoteSort: true,
sortInfo: {field:'st', direction:'DESC'},
autoLoad: {params:{start: 0 ,limit: 10 }},
baseParams:{ApexDemandName:'JSON_GRID',ApexNameItem:'USER_SEARCH_STRING',ApexDataType:'json'},
proxy: new Ext.data.ApexProxy(),
reader: new Ext.data.JsonReader({
root: 'strec',
totalProperty: 'totalCount',
idProperty: 'ST',
fields: ['ST','STATE_NAME']
})
});
var grid = new Ext.grid.GridPanel({
renderTo: 'st-grid',
width: 700 ,
height: 500 ,
frame:true,
loadMask:true,
title:'STATE',
trackMouseOver:false,
autoExpandColumn: 'ST',
store: store,
columns: [new Ext.grid.RowNumberer({width: 30 }),{
id: 'ST',
header: "St",
dataIndex: 'ST',
width: 10 ,
sortable:true
},{
header: "State name",
dataIndex: 'STATE_NAME',
width: 500 ,
sortable:true
}],
bbar: new Ext.PagingToolbar({
store: store,
pageSize: 10 ,
displayInfo:true
})
});
});
Это у нас прокси
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
Ext.data.ApexProxy = function(config){
Ext.data.ApexProxy.superclass.constructor.call(this);
Ext.apply(this, config);
};
Ext.extend(Ext.data.ApexProxy, Ext.data.DataProxy, {
load : function(params, reader, callback, scope, arg){
if(this.fireEvent("beforeload", this, params) !== false){
params = params || {};
var result;
if (params.ApexDemandName !== undefined) {
try {
var get;
var response;
get = new htmldb_Get(null, document.getElementById("pFlowId").value, 'APPLICATION_PROCESS='+params.ApexDemandName, 0 );
if (params.ApexNameItem !== undefined) {get.add(params.ApexNameItem, Ext.util.JSON.encode(params));}
if(params.ApexDataType == 'json') {
response = get.get();
result = reader.readRecords(Ext.util.JSON.decode(response));
}else if(params.ApexDataType == 'xml'){
response = get.get('XML');
result = reader.readRecords(response);
}else{
response = get.get();
result = reader.readRecords(response);
}
get = null;if (params.ShowResponse){alert(response);}
}
catch (e) {
this.fireEvent("loadexception", this, arg, this.response, e);
callback.call(scope, null, arg, false);
return;
}
callback.call(scope, result, arg, true);
}else{callback.call(scope, null, arg, false);};
}else{callback.call(scope, null, arg, false);}
},
update : function(params, records){
}
});
а это Application Processes
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
declare
obj json:= json();
mylist json_list:=json_list();
st_obj json;
kol varchar2( 10 );
qry VARCHAR2( 1000 ):='select a.ST, a.STATE_NAME from (SELECT rownum rn, b.* from ( select ST, STATE_NAME FROM DEMO_STATES ';
qry_kol varchar2( 1000 ):= 'begin SELECT to_char(count(*)) into :kol FROM DEMO_STATES; end;';
start_rows number;
end_rows number;
TYPE CurTyp IS REF CURSOR;
v_dstat_cursor CurTyp;
dstat_record DEMO_STATES%ROWTYPE;
main_param json;
field VARCHAR2( 100 );
direction VARCHAR2( 5 );
start_page NUMBER;
limit_row NUMBER;
begin
if :USER_SEARCH_STRING is not null then
select replace(:USER_SEARCH_STRING,'"','"') into :USER_SEARCH_STRING from dual;
main_param:=json(:USER_SEARCH_STRING);
field :=json.to_varchar2(main_param.get('sort'));
direction :=json.to_varchar2(main_param.get('dir'));
start_page:=json.to_number(main_param.get('start'));
limit_row :=json.to_number(main_param.get('limit'));
end if;
start_rows:=nvl(start_page, 0 );
end_rows:=nvl(start_rows+limit_row, 10 );
if field is not null then qry:=qry||' order by '||field;
if direction is not null then qry:=qry||' '||direction; end if;
end if;
qry:=qry||') b ) a where a.rn>:start_rows and a.rn<=:end_rows';
EXECUTE IMMEDIATE qry_kol USING OUT kol;
obj.put('totalCount',kol);
BEGIN
OPEN v_dstat_cursor FOR qry USING start_rows, end_rows;
LOOP
FETCH v_dstat_cursor INTO dstat_record;
EXIT WHEN v_dstat_cursor%NOTFOUND;
st_obj:= json();
st_obj.put('ST',dstat_record.ST);
st_obj.put('STATE_NAME',dstat_record.STATE_NAME);
mylist.add_elem(st_obj.to_anydata);
END LOOP;
CLOSE v_dstat_cursor;
EXCEPTION WHEN OTHERS THEN
CLOSE v_dstat_cursor;
END;
obj.put('strec',mylist);
htp.p(obj.to_char());
end;
работа с json под ораклом взята отсюда http://json.org/ |
|
|
