Arbeit mit JSON 

var htmlLogbuch =  getLogbuch($$F124) ;

function getLogbuch(logbuch) {

    var html = "";

    try {

        if (logbuch == "" || logbuch == "null" || logbuch == "[]") {

            html = "- keine Ereignisse -";

        } else {

            try {

                var liste = JSON.parse(logbuch.replace(/'/g, '"'));

                liste.sort(GetSortOrder("1"));

                html += "<table  style='width: 670px; border: 1px solid #650723; background-color:#fff;padding:4px;margin:5px;font-family: Roboto, Arial, sans-serif;color: #000000; '>";

                html += "<tr>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>..</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9; padding:4px'>S</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px' width='140px'>Datum</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Notiz </th>";

                html += "</tr>";

                for (var i = 0; i < liste.length; i++) {

                    html += "<tr>";

                    var row = liste[i];

                    var status = "+";

                    if (row[4] == "0") {

                        status = "..";

                    }

                    var datex = new Date();

                    datex.setTime(Number(row['1']));

                    html += "<td>" + status + "</td>";

                    html += "<td>" + row['21'] + "</td>";

                    html += "<td align='right'>" + datex.getDate() + '.' + (datex.getMonth() + 1) + '.' + datex.getFullYear() + ' (' + datex.getHours() + '.' + datex.getMinutes() + ')' + "</td>";

                    html += "<td>" + row['3'] + "</td>";

                    html += "</tr>";

                }

                html += "</table>";

            } catch (err) {}

        }

    } catch (err) {}

    return html;

}

function GetSortOrder(prop) {

    return function(a, b) {

        if (a[prop] < b[prop]) {

            return 1;

        } else if (a[prop] > b[prop]) {

            return -1;

        }

        return 0;

    }

}

var htmlAktion = getAktionenNamen(JSON_$$F609);

function getAktionenNamen(aktionen) {

    var html = "";

    try {

        if (aktionen == "" || aktionen == "null" || aktionen == "[]") {

            html = "- keine Aktion -";

        } else {

            try {

                var liste = JSON.parse(aktionen.replace(/'/g, '"'));

                for (var i = 0; i < liste.length; i++) {

                    var row = liste[i];

                    if (html != "") {

                        html += "<br>";

                    }

                    html += row['name'];

                }

            } catch (err) {}

        }

    } catch (err) {}

    return html;

}

var htmlProdukte = getProductListFieldHTML(JSON_$$F123);

function getProductListFieldHTML(produkte) {

    var html = "";

    try {

        if (produkte == "" || produkte == "null" || produkte == "[]") {

            html = "- keine Produkte -";

        } else {

            try {

                var liste = JSON.parse(produkte.replace(/'/g, '"'));

                html += "<table  style='width:670px; border: 1px solid #650723; background-color:#fff;padding:2px;margin:5px;font-family: Roboto, Arial, sans-serif;color: #000000; '>";

                html += "<tr>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Pos.</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Produkt Nr.</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Produkt </th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Menge</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Einheit</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Preis</th>";

                html += "<th style='color: #fff;background-color: #858585; font-size:.9em; padding:4px'>Summe</th>";

                html += "</tr>";

                var total = 0

                for (var i = 0; i < liste.length; i++) {

                    html += "<tr>";

                    html += "<td>" + (i + 1) + "</td>";

                    html += "<td>" + liste[i].ProductNo + "</td>";

                    html += "<td>" + liste[i].ProductName + "</td>";

                    html += "<td align='right'>" + liste[i].Quantity + "</td>";

                    html += "<td>" + liste[i].Unit + "</td>";

                    html += "<td align='right'>" + liste[i].Price + "</td>";

                    sum = (liste[i].Price * liste[i].Quantity);

                    total += sum;

                    sum = Math.round((sum) * 100) / 100;

                    html += "<td align='right'>" + sum + "</td>";

                    html += "</tr>";

                }

                total = Math.round((total) * 100) / 100;

                html += "<tr >";

                html += "<td colspan='6' align='right'>" + "Summe" + "</td>";

                html += "<td style='border-top:1px solid black; border-bottom:1px double black;' align='right'>" + total + "</td>";

                html += "</table>";

            } catch (err) {}

        }

    } catch (err) {}

    return html;

}

var jsonS = $$F251;

if (jsonS == "" || jsonS == "null"){

 jsonS = "{}";

}

var json = JSON.parse( jsonS .replace(/'/g, '"') );

var key = "sport" ;

json[key] = "American football";

$$F251 = JSON.stringify(json);

[{"id":"0","duevalue":"4.76","duedate":"1605135600000","duenote":"kostenlos !","payvalue":"0.0","paydate":"0","paynote":""}]

var payplanTEXT = PAYPLAN_JSON$$F144;
if (payplanTEXT == "" || payplanTEXT == "null"){
payplanTEXT = "{}";
}
var xnote +="JSON: "+ payplanTEXT+";"; // original json String
var payplan = JSON.parse( payplanTEXT.replace(/'/g, '"') ); 

Lesen der Zahlungsplanzeilen

xnote += "transaction rows:"+payplan.length+";";

for (var i = 0; i < payplan.length; i++) {
var dueValue = payplan[i].duevalue;
var dueDate = payplan[i].duedate;
var dueNote = payplan[i].duenote;
var transactionId = payplan[i].id;
var payValue = payplan[i].payvalue;
var payDate = payplan[i].paydate;
var payNote = payplan[i].paynote;

var datePlaned = new Date(Number(dueDate));
var datePayed = new Date(Number(payDate));
var showDatePlaned = datePlaned.getDate() + '.'+(datePlaned.getMonth()+1) + '.'+ datePlaned.getFullYear();
var showDatePayed= datePayed.getDate() + '.'+(datePayed.getMonth()+1) + '.'+ datePayed.getFullYear();
xnote += ";plan amount:"+dueValue+" date:"+showDatePlaned+" note:"+dueNote;
xnote += ";payed amount:"+payValue+" date:"+showDatePayed+" note:"+payNote;
xnote += ";related id of bankbooking:"+transactionId+";";
}

work$wipNote = xnote; // to display the values

Einzelne Zahlungsplanzeilen ändern und speichern

for (var i = 0; i < payplan.length; i++) {
if (Number(payplan[i].payvalue) == 0){
payplan[i].paynote = "this should be payed"; // set Value
}else{
payplan[i].paynote = "payed this !"; // set Value
}
}
 

Zeile hinzufügen

var today = new Date();
var newRow = {'id':'','duevalue':'','duedate':'','duenote':'','payvalue':'2000','paydate':'"+today.getTime()+"','paynote':'payed'};
payplan.push(newRow); // new paytransaction row

JSON als String speichern

$$F144 = JSON.stringify(payplan); // save changed payplan

JSON   Zahlungsplan löschen (wird automatisch auf eine Zahlung aktualisiert)

$$F144 = "[]"