jquery - Put specific data in jqgrid summary view header -


i have working jqgrid table has summary view on header, example implemented in this plunkr here http://plnkr.co/edit/wjilavmsa9vusmfhgfl1?p=preview.

the summary view header works fine, , data displayed comes (sum) function in jqgrid.

however, instead of letting jqgrid calculate summary itself, want display own data in summary row (and still per column, dont want colspan summary header). easiest example be: suppose data under columns text. still want have grouping & summary view header & show data per column on summary header, don't want jqgrid calculate summary me (since it's text). want display own summary data, comes data json.

i dont think using 

summarytpl: '<b>{0}<b>'

will work me since data want display comes json data.

is possible? let me know if explanation not clear enough. thank you!

the demo posted uses jqgrid 4.6 version. have not possibility set custom summary value in case. can use custom formatter in column need place custom summary value. described approach in the old answer. it's tricky.

alternatively can suggest use free jqgrid 4.8 (see readme , wiki). free jqgrid supports summarytype defined function. show how works created jsfiddle examples you. the first one consist original demo. the second one contains

summarytype: function (v, cn, record) {     var fielddata = parseint(record[cn], 10);     return v === "" ? fielddata : fielddata + v;  }

instead of summarytype: "sum". results in summary column close original one, used parseint(record[cn], 10) instead of parsefloat(record[cn]). integer part of input numbers , results integer too.

the next demo contains static variable

var mysummary = {     alfki: 12,     anatr: 23,     arout: 34,     bergs: 45,     blaus: 56 };

and summarytype looks 

summarytype: function (v, cn, record) {     return mysummary[record.customerid]; }

in way summary results every group displayed based on mysummary map. remind values formatted same formatter defined in column. because use formatter: 'number' in column freight, results should numbers or string can converted numbers.

the last demo uses modified json data

{     "userdata": {         "alfki": 12.34,         "anatr": 23.45,         "arout": 34.56,         "bergs": 45.67,         "blaus": 56.78     },     "rows":[         ....     ] }

the summarytype defined 

summarytype: function (v, cn, record) {     var userdata = $(this).jqgrid("getgridparam", "userdata");     return userdata[record.customerid]; }

as result values displayed in grouping summary come userdata part of server. think it's want.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more