How To Show The Json Data Into Dynamic Input Text Fields?

I have a JSON data coming through AJAX GET method is:The JsonData is stored in var trDataSecondTable and displayed when I did console.log(trDataSecondTable). { 'assessCatAmoun

Solution 1:

You need to copy the clone part

var types = ["","customs","vat","excise"]; // 1,2,3 must match class names
$.each(data.assessCatAmount, function(_,cat) {
  var type = types[cat.assessCatId];
  var$newDiv = $("#formContainer").find("."+type+"-table").eq(0).clone(); // clone the FIRST one
  $.each(cat,function(key,value) {
     var fieldName = key.replace("assess",type);
     var$field = $newDiv.find("."+fieldName);
     if ($field) $field.val(value);
  });
  $("#formContainer").append($newDiv)
});

You may need to hide or fill the first 3 divs since I do not fill them, I only use them to clone from

Also move the total to the bottom like I did with the submit

var types = ["", "customs", "vat", "excise"]; // 1,2,3functiongetText(str) {
  return $.trim(/\s/.test(str)?str.split(/\s+/)[1]:str);

}
var data = {
  "assessCatAmount": [{
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 1,
      "assessReason": "A",
      "assessAmount": 1,
      "assessPenalty": 2,
      "entryBy": "PCS",
      "rStatus": "1"
    },
    {
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 1,
      "assessReason": "D",
      "assessAmount": 3,
      "assessPenalty": 4,
      "entryBy": "PCS",
      "rStatus": "1"
    },
    {
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 2,
      "assessReason": "B",
      "assessAmount": 5,
      "assessPenalty": 6,
      "entryBy": "PCS",
      "rStatus": "1"
    },
    {
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 2,
      "assessReason": "E",
      "assessAmount": 7,
      "assessPenalty": 8,
      "entryBy": "PCS",
      "rStatus": "1"
    },
    {
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 3,
      "assessReason": "C",
      "assessAmount": 9,
      "assessPenalty": 10,
      "entryBy": "PCS",
      "rStatus": "1"
    },
    {
      "assessmentNo": 1,
      "assessmentType": "PRE",
      "assessCatId": 3,
      "assessReason": "F",
      "assessAmount": 10,
      "assessPenalty": 10,
      "entryBy": "PCS",
      "rStatus": "1"
    }
  ]
}


functionsumIt() {
  $("#formContainer [type=number]").each(function() {
    var $row = $(this).closest(".row");
    var $fields = $row.find("[type=number]");
    var val1 = $fields.eq(0).val();
    var val2 = $fields.eq(1).val();
    var tot = (isNaN(val1) ? 0 : +val1) + (isNaN(val2) ? 0 : +val2)
    $row.find(".sum").text(tot);
  });
  var total = 0;
  $(".sum").each(function() {
    total += isNaN($(this).text()) ? 0 : +$(this).text()
  });
  $("#tot").text(total);
  return total;
}

// data={} // test no datafunctionaddNums(i) {
  $(this).html(function() {
    var text = $(this).text();
    // Get the text without leading number - fake a space in case there are none yetvar type = getText(text);
    var length = $("."+type.toLowerCase()+"-table").length;
    return (length===1?"":i+ " ") + type; // only show numbers if more than one
  });
}


functioncleanUp() {
  $(".customs-table .remove:gt(0)").show();
  $(".vat-table     .remove:gt(0)").show();
  $(".excise-table  .remove:gt(0)").show();

  $(".customs-table.row > div > label").each(addNums);
  $(".vat-table.row > div > label").each(addNums);
  $(".excise-table.row > div > label").each(addNums);

}


$(function() {

  $(".customs-table .remove:lt(1)").hide();
  $(".vat-table     .remove:lt(1)").hide();
  $(".excise-table  .remove:lt(1)").hide();

  $("#formContainer").on("click", "button", function() {
    var selector = "div.row";
    var $div = $(this).closest(selector);
    if ($(this).is(".add")) {
      var $newDiv = $div.clone();
      $newDiv.find(":input").val(""); // clear all
      $newDiv.find("[type=number]").val(0); // clear numbers
      $newDiv.find(".sum").text(0); // clear total
      $newDiv.insertAfter($div)
    } else {
      $div.remove();
      sumIt();
    }
    cleanUp();
  });


  $("#formContainer").on("input", "[type=number]", sumIt);

  $("form").submit(function() {
    event.preventDefault();
    var user_profile = [];
    $(".row:visible").each(function() {
      var $fields = $(this).find(":input");
      if ($fields.length > 0) {
        var cat = getText($(this).find("div>label").eq(0).text()); // use the label of the rowvar catId = types.indexOf(cat.toLowerCase())
        user_profile.push({
          assessmentType: "PRE",
          assessCatID: catId,
          assessReason: $fields.eq(0).val(),
          assessAmount: $fields.eq(1).val(),
          assessPenalty: $fields.eq(2).val(),
          assessTotal: +$fields.eq(1).val() + +$fields.eq(2).val() // the leading + makes it a number
        });
      }
    });
    console.log(user_profile);
  });

  var showEmpty = true;
  $.each(data.assessCatAmount, function(_, cat) {
    showEmpty = false; // there was datavar type = types[cat.assessCatId];
    var $newDiv = $("#formContainer").find("." + type + "-table").eq(0).clone();
    $.each(cat, function(key, value) {
      var fieldName = key.replace("assess", type);
      var $field = $newDiv.find("." + fieldName);
      if ($field) $field.val(value);
    });
    $("#formContainer").append($newDiv)
  });
  $(".customs-table").eq(0).toggle(showEmpty);
  $(".vat-table").eq(0).toggle(showEmpty);
  $(".excise-table").eq(0).toggle(showEmpty);
  cleanUp();
});

<!DOCTYPE html><html><head><title></title><linkrel="stylesheet"href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"><scriptsrc="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script><scriptsrc="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script><scriptsrc="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script></head><body><formid="myForm"><divid="formContainer"class="col-md-12"style="float: none;"><!--  <button onclick="myFunction()" class="pull-right">+</button> --><divstyle="margin-bottom: 30px;"><divclass="form-group row"><divclass="col-md-1"></div><divclass="col-md-4"><label>Reason</label></div><divclass="col-md-2"><label>Amount</label></div><divclass="col-md-2"><label>Penalty</label></div><divclass="col-md-1">Total</div><divclass="col-md-2">Action</div></div><divclass="customs-table row"><divclass="col-md-1"><label>Customs</label></div><divclass="col-md-4"><inputtype="text"class="form-control customsReason" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt customsAmount"value="0"name="abc"min="0" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt customsPenalty"value="0"name="abc"min="0" /></div><divclass="col-md-1"><spanclass="sum">0</span></div><divclass="col-md-2"><buttontype="button"class="add">+</button><buttontype="button"class="remove">-</button></div></div><divclass="vat-table row"><divclass="col-md-1"><label>VAT</label></div><divclass="col-md-4"><inputtype="text"class="form-control vatReason"name="vatReason" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt1 vatAmount"value="0"name="vatAmount"min="0" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt1 vatPenalty"value="0"name="vatPenalty"min="0" /></div><divclass="col-md-1"><spanclass="sum">0</span></div><divclass="col-md-2"><buttontype="button"class="add">+</button><buttontype="button"class="remove">-</button></div></div><divclass="excise-table row"><divclass="col-md-1"><label>Excise</label></div><divclass="col-md-4"><inputtype="text"class="form-control exciseReason"name="exciseReason" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt2 exciseAmount"value="0"name="exciseAmount"min="0" /></div><divclass="col-md-2"><inputtype="number"class="form-control txt2 excisePenalty"value="0"name="excisePenalty"min="0" /></div><divclass="col-md-1"><spanclass="sum">0</span></div><divclass="col-md-2"><buttontype="button"class="add">+</button><buttontype="button"class="remove">-</button></div></div></div></div><divclass="col-md-12 pull-right"><label>Total:</label>&nbsp;<b><spanid="tot">0</span></b></div><buttontype="submit"class="btn btn-success pull-right">Submit</button></form></body></html>