php - JQgrid how do I change background color of row based on server data? -

-

i'm trying change background color of multiple rows based on data returned sql query. i'm using json data type , have tried using loadcomplete iterate through grid , color rows adding css class after grid loaded. works have 1000's of rows returned , method slows down loading of grid. user has wait long time before grid loaded.

i haven't tried using customer formatter color rows because i'm told grid not available yet when customer formatter triggered there error? have seen documentation on setting timeout period grid available in dom customer formatter sounds slow loading of grid i'm trying avoid.

ideally assign class row during server call (php) based on table data , when grid loaded on client side colors row based on css style. seems assigning class on server side efficient way don't have cycle through data more once or draw grid more once? other techniques available doing this? thanks!

the best way want use rowattr. described in the answer need. in more old versions have iterate it's described in more old answer , set class rows.

the important understand every change of 1 elements on page follows recalculating of position of all other elements existing on page. minimum need done reflow (see here). in case of usage gridview: true option of jqgrid all rows of grid body created string first , placed on page one operation (something assign innerhtml property). improve performance dramatically in case of usage large number of rows without paging. if use custom formatter, cellattr or rowattr can customize default process of building of grid body without performance disadvantages.

the usage of custom formatter correct in general, problem have defines formatter every column. if want use many columns of different types (checkboxes, numbers, currency) usage of custom formatter not good, because have implement 1 more time formatters or call predefined formatters custom formattres, make unneeded code.

the usage of cellattr better (see here, here or here) have set class attribute of all cells (columns) instead of setting class attribute of rows (<tr>).

so find best use rowattr suggested @ beginning of answer. in the answer find need.


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more