package com.smartgwt.sample.showcase.client.dataintegration.java.sql; import com.google.gwt.user.client.Timer; import com.smartgwt.client.data.DSRequest; import com.smartgwt.client.data.DSResponse; import com.smartgwt.client.data.DataSource; import com.smartgwt.client.data.ResponseTransformer; import com.smartgwt.client.types.DSOperationType; import com.smartgwt.client.widgets.Canvas; import com.smartgwt.client.widgets.Label; import com.smartgwt.client.widgets.grid.ListGrid; import com.smartgwt.client.widgets.grid.ListGridField; import com.google.gwt.core.client.EntryPoint; public class AdaptiveFilterSample implements EntryPoint { @Override public void onModuleLoad() { Canvas canvas = new Canvas(); final ServerCountLabel serverCountLabel = new ServerCountLabel(); DataSource ds = DataSource.get("supplyItem", null, new ResponseTransformer() { protected void transformResponse(DSResponse response, DSRequest request, Object data) { if(request.getOperationType() == DSOperationType.FETCH) { int totalRows = response.getTotalRows(); int startRow = response.getStartRow(); int endRow = response.getEndRow(); serverCountLabel.incrementAndUpdate(totalRows, startRow, endRow); serverCountLabel.setBackgroundColor("ffff77"); new Timer() { public void run() { serverCountLabel.setBackgroundColor("ffffff"); } }.schedule(500); } defaultTransformResponse(response, request, data); }}); final ListGrid supplyItemGrid = new ListGrid(); supplyItemGrid.setWidth(660); supplyItemGrid.setHeight(300); supplyItemGrid.setAutoFetchData(true); supplyItemGrid.setShowFilterEditor(true); supplyItemGrid.setFilterOnKeypress(true); supplyItemGrid.setFetchDelay(500); supplyItemGrid.setDataSource(ds); ListGridField skuField = new ListGridField("SKU", 64); ListGridField nameField = new ListGridField("itemName", 192); ListGridField descriptionField = new ListGridField("description", 256); ListGridField categoryField = new ListGridField("category", 128); supplyItemGrid.setFields(skuField, nameField, descriptionField, categoryField ); canvas.addChild(supplyItemGrid); canvas.addChild(serverCountLabel); canvas.draw(); } class ServerCountLabel extends Label { private int count = 0; ServerCountLabel() { setContents("
Number of server trips : 0
"); setTop(320); setPadding(10); setWidth(500); setHeight(30); setBorder("1px solid #6a6a6a"); } public void incrementAndUpdate(int totalRows, int startRow, int endRow) { count++; setContents("
Number of server trips: " + count + "
Total rows in this filter set: " + totalRows + "
Last range of records returned: " + startRow + " to " + endRow + "
"); } } }