Skip to content
Snippets Groups Projects
onDBDelete.js 593 B
import("system.neon");
import("system.vars");
import("system.db");
import("Order_lib");
import("Sql_lib");

var oid = vars.get("$field.SALESORDER_ID");
if(oid != "")
{
    var oiid = vars.get("$field.SALESORDERITEMID");
    var oiUtils = new OrderItemUtils(oid);
    var deletedIds = oiUtils.deletePartsList(oiid);
    oiUtils.reOrgItems();
    
    deletedIds.push(oiid);
    var cols = ["NET", "VAT"];
    var vals = oiUtils.getNetAndVat(deletedIds);
    
    db.updateData("SALESORDER", cols, null, vals, SqlCondition.equals("SALESORDER.SALESORDERID", oid, "1 = 2"));

    neon.refresh();
}