package com.smartgwt.sample.showcase.client.dataintegration.java.sql; import com.google.gwt.user.client.Timer; import com.smartgwt.client.data.Criteria; 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.form.DynamicForm; import com.smartgwt.client.widgets.form.fields.BooleanItem; import com.smartgwt.client.widgets.form.fields.events.ChangedEvent; import com.smartgwt.client.widgets.form.fields.events.ChangedHandler; import com.smartgwt.client.widgets.grid.ListGrid; import com.smartgwt.client.widgets.grid.ListGridField; import com.google.gwt.core.client.EntryPoint; public class AdaptiveSortSample implements EntryPoint { @Override public void onModuleLoad() { 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.setDataPageSize(20); 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 ); final DynamicForm form = new DynamicForm(); form.setWidth(300); form.setTop(310); final BooleanItem restrictField = new BooleanItem(); restrictField.setTitle("Limit to Electronics"); restrictField.addChangedHandler(new ChangedHandler() { public void onChanged(ChangedEvent e) { Criteria c = new Criteria(); if (restrictField.getValue() != null && restrictField.getValueAsBoolean() == Boolean.TRUE) { c.addCriteria("category", "Office Machines and Electronics"); } supplyItemGrid.fetchData(c); } }); form.setFields(restrictField); Canvas canvas = new Canvas(); canvas.addChild(supplyItemGrid); canvas.addChild(form); canvas.addChild(serverCountLabel); canvas.draw(); } class ServerCountLabel extends Label { private int count = 0; ServerCountLabel() { setContents("
Number of server trips : 0
"); setTop(350); 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 + "
"); } } }