javascript - Calculation is not working with custom Cell Rendering with AJAX in Handsontable -


in table(handsontable) have 4 columns cars, a, b , c. data cars , a columns loaded mysql database. (like php demo).

data of column b populated mysql database via ajax depending on value of cars. code follows:

{type: { renderer : function (instance, td, row, col, prop, value, cellproperties) {                 handsontable.textcell.renderer.apply(this, arguments);                 var cr,prc;                 cr = instance.getdataatcell(row, 0);                 prc = instance.getdataatcell(row, 1);                 $.ajax({                     url: "php/act-go-t.php",                     data: {cars: cr, price: prc},                      datatype: 'json',                     type: 'post',                     success: function (res) {                         if (res.result[0].tax === null) {                             td.innerhtml = '0.000';                             }                             else {                             td.innerhtml = res.result[0].tax;                             }                         },                         error: function () {                         td.innerhtml = '0.000';                         }                     });                                  }}}

the c column sum of a , b , code is:

{type : { renderer : function (instance, td, row, col, prop, value, cellproperties) {                     handsontable.textcell.renderer.apply(this, arguments);                     var a,b;                     = instance.getdataatcell(row, 1);                     b = instance.getdataatcell(row, 2);                                          td.innerhtml = +a + +b;                 }}}

the problem although value loaded in b addition not working. if set type of b column numeric({type: numeric}) except ajax, addition working fine.

result ajax:

+----------+------+-------+--------------+ | cars     |    |    b  |            c |  +----------+------+-------+--------------+ | nissan   |   20 |    10 |          20  |   | honda    |    5 |     6 |           5  |     +----------+------+-------+--------------+

result without ajax:

+----------+------+-------+-------------+ | cars     |    |    b  |           c | +----------+------+-------+-------------+ | nissan   |   20 |    10 |         30  |   | honda    |    5 |     6 |          11 |    - +----------+------+-------+-------------+

can please tell me if missing something?

in case td.innerhtml = res.result[0].tax; displaying data, not inserts data datamap.

you may try set id cell , value of jquery , summing them up. codes that:

{type: { renderer : function (instance, td, row, col, prop, value, cellproperties) {                  var cr,prc;                 cr = instance.getdataatcell(row, 0);                 prc = instance.getdataatcell(row, 1);                 $.ajax({                     url: "php/act-go-t.php",                     data: {cars: cr, price: prc},                      datatype: 'json',                     type: 'post',                     success: function (res) {                         if (res.result[0].tax === null) {                             td.innerhtml = '0.000';                                                             }                             else {                             td.innerhtml = res.result[0].tax;                                                             }                         },                         error: function () {                         td.innerhtml = '0.000';                                                     }                     });                   arguments[5] = td.innerhtml;                 td.id = row+'_'+col;                 handsontable.textcell.renderer.apply(this, arguments);                  }}}

and

{type : { renderer : function (instance, td, row, col, prop, value, cellproperties) {                     handsontable.textcell.renderer.apply(this, arguments);                     var a,b;                     = $('#'+row+'_1').text();                     b = $('#'+row+'_2').text();                                          td.innerhtml = +a + +b;                 }}}

-

Comments

Post a Comment

Popular posts from this blog

java - SSE Emitter : Manage timeouts and complete() -

i writing web app multiple listeners(evcentsource sse clients js) connected server . want store sse emitter per connected listener : can done in memory or other means assigning id each client able achieve far now question ; how send response/event specific client connected web app ? while doing sseemmiters stored either getting completed or timed out. how prevent ? how keep sseemmiter available open infinite time (till client closes) , send events selectively .
Read more

jquery - uncaught exception: DataTables Editor - remote hosting of code not allowed -

i'm trying implement crud operation using datatableseditor using datatables.but i'm getting error messages: 1)uncaught exception: datatables editor - remote hosting of code not allowed. please see http://editor.datatables.net details on how purchase editor license 2)typeerror: a.editor undefined 3) $.fn.datatable.editor not constructor" what reason? here configuration: <%@ page language="java" contenttype="text/html; charset=iso-8859-1" pageencoding="iso-8859-1"%> <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.12/css/jquery.datatables.min.css"> <link re...
Read more

java - How to resolve error - package com.squareup.okhttp3 doesn't exist? -

i trying convert json java object use of gson in maven, following youtube video guidance - https://www.youtube.com/watch?v=vqgghm9pwe0 , theres error occurs when in main class error - package com.squareup.okhttp3 doesn't exist. code below: java package com.codebeasty.json; import com.squareup.okhttp3.okhttpclient; public class main { private static okhttpclient client = new okhttpclient(); public static void main (string [] args) { } } i put in dependency in pom.xml: <dependencies> <dependency> <groupid>com.squareup.okhttp3</groupid> <artifactid>okhttp</artifactid> <version>3.4.2</version> </dependency> <dependency> <groupid>com.google.code.gson</groupid> <artifactid>gson</artifactid> <version>2.8.0</version> </dependency> </dependencies> i dont understand why doesn't recognize com.squareup. there may need download? have downl...
Read more