Auftragserfassung
-1
supervisor
-1
supervisor
Start
false
End
false
Auftrag erfassen
de.aristaflow.form.WebForm
WebForm
WebForm
de.aristaflow.adept2.extensions.webforms.environments.WebFormComponent
NON_SHARED
HTMLContext
true
true
false
true
false
H4sIAAAAAAAAAO1c727bRhL/HiDvsGEPPRu1rD+WbDmWWjixkuaSOKmdtsAdDsZSXEpbU6SOXNpx2gJ9jTvcxz7Dfeo3v0mf5Gb/kOKKlERRsuUATNFEXO4OZ2d+M7OzO2Tnm48jB10RP6Ce2zXquzUDEbfvWdQddI3vP7yotA0UMOxa2PFc0jVcz/jm68ePOi88f4QGPoV2OoCRLUOjwv8zoB9Cnb/hK3ze9+mYfW2Hbp9BF0Rdyra20eNHP8P/qFpF31KLoJ5v4yAgLjoObebjQTD2Asr7Q9NXyKIBNh2C/qruIuw6ZEBcg5PA9kVA2Hlo2sAXELOIu2XMoWfsIOaHZPtoMvhE0re2DCy7X6gHXJghY5425NfHjx4/imfTH5L+Zc/lo5+JrtrU3sMgm+0gz0SvQxcYc8PRiPgIfseMWZiFIE4CbHxiKKBwSw7mnYL+EDuMMDQY2LsICCD5FPTnb/+ZksWfv/0b2T6hfDS10RbMbIiDH7ATki3j0nL9C0Y+MtP7aGyjL/FofCT+Qlo3nOTpAv4mxvb2UmKysRMo0RL4VVjEEwF745sTYEST6/fEJL5LRyOGcBgMyPXt70MQUzAlVOoiBYsGH3iFfSRvdDlTA8LmTDuBjpm9GsC0uJJcowTbV2AbvIt6fm0KFrd/QM+BAEbUA115jhOw299diw7ktOzbPxyHoevQt8iuGvsCQy/0E95B4Uihw4XedkSnfif6/3mmoR1LLUaSzzCupSwzgR8YjUGYVxMpzh8sR/2qQc8hPgMeVWciRoPgEQ0Y2FdS4k+M2UrkDm+OAnunJ4j4Dg5N0BXxuZVeYteNFPFkniZ++QU9WUYF+Sf0VHc53u6UcdgETEbNGvmEhb4rpT8lRpgC/NySBgOKYNyMf6Dk+sy7fu6FboKd915wkezBkeawI1RPTeA1oS7J8vVyRnn4mtzlgJt2G5d87i/JNeaz3CIOGcX6427A965fnYAb4Dd2qbUbjB2ISsZTY/sfjX8ecRX/nVAnFt7tH+BvIAoRBKMs8DM9GEdcFqAh8cFUbcolrcBhCws1RGQgFmAargl4aYv40Oe5aKYu829/HxDk3P4PrBjaubd/7UEzqJAbPzZhzCULAYIBFSMFnLgeaCCJgC8VKtZk/vQ4DK7x0HlqQNwU00zAh099hD+C5l7BuI+xH8xWa5q40grYItritChQqB/BP1zN3SRpaPzqq+3IBCh60lXMpNzqginQHaH8dGQBScPjFdl4htB6+19QFscVyOxH+EV4HEjaQuWDNL9IItwkp0NCBlenYnBCrkcJAnhE8pCAbtkEYJ1lsRwUznm/aRKaPDUHsyMmt300u0tj0ieDEvCr04KGNDXBfKLf40eqLeGSdb88h2EjwxHDXM/BVPsMMK/ZcnFDzeEFVjDnHTV4eYv+wKfzGjNYcw901eO1GfbMZ9yFfeeb0JrMfDqiAApNwvWlZMQEWFLWPptHMYBaWUZrY99MGf1sSqJ7Fh3JU4YDWcCVO8OZjCEJCPLTEt0zPAq2rKgfKH1ekI+f7AqQLQDfAjoadmb1VQKQzlg+dSfS7TJkJjqJiIiW5TmJVKHzIp1lblITTURkRIskkfSjv3aqicxaZNo/PJNXVXkpLwJxAZe9K/CBx9KXYvFP15B5+JGhGtjNGFJ8Oc5A8spzHQ9bRnUeGX2NvIBcEJojyhTBTjXJZeeE2Dh02BuvD2vEry3Sqeotcl7heOyBrVuiEVJKYeSK3ht844UMcbF3U3kJAjl3DbUxAZ2fS8+MAOY+GXlXMES4HoNndNjEAflXSPybLqQcAeMuJFpDwFMZ70UCwb0QghHtUFgxlYHvhWOIaPzmUKQ+8S3JYMbqCnmCHnbirj7BFmjhZtLgXQd8GihQA7vG5YSti6hVTJfHOnh+PZK/9iwlB5DES+KNCPNvIETSwZDBgBbQd4gNP/kv5o27xgH8uKYWG3aNJm/85EGe43Pi1QmlExLQgYtM3L/se44Ht1+oPwbEFJdVTM+ZSEi0UPBItK+3Sfm8pX3fCzyboXPsBuic+NRWHQL6CTrU+T6TbOAS8B3qkgQhn8Q81MSfJKfvfa9PguAEVB038gnA9bkX+n3C/RmV8k2MU11gnoy6WOWIGf061awHxJjr4xg3almRAh/wHo4ksnQ4ygap0Gfv3r3pHZ9moE/ZgAywcBmOTK6tWh6IRRiKWIip8DUaZ0A+XKxYnsGSjafJIZ9/UkwpUDUmAGrVpkT6ucBmJnByQScveGbBJ+XWVWOWV9bTXzbkUWS+a+6DPC+nuJh+XKeqEJyGtNgK5ittAbIY4DJnSsOar/lze9oY769OP/Re9s4y8G5Txxl5FvQ5UTQNvloFWgOOOGBpBJGEarqWeIk4jEykXsREXlunfiRKnlwWMov90ixWM4vqKkAFKWXCVGvPC9TzD2evTl+uF6eCkQiljYIoFURWxGl9WvklUO8RqGIDKAupgX5jg1BVLEZY3SuGVUWlBOtnDNZnHiSZmGTg1Uzd2eQiYMJnBNpmEdBOyKyI2nYJ2jsE7VSf6R4xqPPkYkun/W/4hmSuRaaewYvcSzMJiTFBb14230gn880J0g7LXL5YLr95EOWKqxkgehmVS6Bk2rIMjvYygFSvN0sk3SmS9BhbBFeTAAmLK0b7c5GWL3Jqh3dL43FBlMwAYSsNwoPkau+wBGEGCIWh5wVikmTW3lJGyduivaUhdgdEY2DqgGIW5vnOv2thEBUv8si7PUp4sRAGkFjW7tu3uzfwp4iXzSjFWRrhdBQzE8njRBAqCPY6b0zkNiXa02gXRz4nXGnrw3xchbgs1B+AEd3JEmRGFWexJUmqrFedb0iay5pIuwwIi0xkbYaRrnNd8pxhPoo7VXmom3HAO68UVB721tOHvXOXUJmHEsdR5U6iztiXexM5tyDWusbKtfG7tkXWYWRTrVoZddZlUptJGcWJ4IUjsrwVNh+eFsgX95oKRfvaGXAJos1lizMOth6Gs0sWnd6nt2vUstxdu0TqZpGafbD1IKCqFz7fJ1b32llYbZZY/QxDswiluQ6cZqdOcpOiSHSeJE7lIu8ekfTAdrbm5xWSxbvY2dpvlOjbRMxdVPUs3he4lO8LrKHYefYbJ8VqnlmCvfUUPYvFn4qtk83WdiJhKTG5pqrnuKD4Touf8VqKn3FZ/PzASjt0oll7ksm3BTdX+ixc3mlG7bN6pWyRy73LCr2YhZWqngXDr6yyRm/jNrFKjd4L/sZbGqW23rwAo3dRlKc4WKnkWU2urMz/fPH5jHwitD90Q3cww5dmbmXetzd1tfr8QjXPMmKso0S/UXrUDSL2PX9rN43Vsd58/zhVDKxU4qzmVjrUBwzPjW5mMg3PhbY0kyZR6Lwxzt9rZaFzftTd9ZbSGraRZn47otguEp5Ujqx9E6l1UO4iLVmyJxWbf0Np2cR77nZSjngbFU0vsyr0V9x/iidT5tjrD7kJ1P0SCXrDafdcjObJspcD6VSOXWgbqMyx7wOfUsoPIunehB9d/e13bUplfn23aE0Ke8Np9/2idSrHLrQPVObY9wFRKeX7Auex+0kcI2443mPFxkp7QNFcSoDeKUCVmO9nW0h/0SJBvvMe+yBRRvy3eDym7iBxJvrKHYcs8cx3IRsrEqpFjUHjiEgqj5/ASy9N0nLy5Ly0h4BAZrDXiXL2BL9Rk74R8RwAz4jFP7qoFctPf1IvOS/1Wdnp76zplQnV2SOSb15HVj6/e+JYQAWtuf21r6csHjD95Yo0T51qJL0C8swu15nNDl5aoFNn0YtnrGUtOVSQOpxZ/Agtjqe6ryTQTCtZxLx/d9LJWFyvKp+0lWlhJwdCJw2xU+AuD4On9yduEJpcIgtIolDcNRwy8EDAIDXfMg1EIe7027hWr7fblUPSrFealn1QaTftw0qr2cam3Wo22mY7Uo9l9vm7kGMcBNeeD4NBT2zgE+7tiH/FI6/DP2A6hOanreZeI5rVe9nv/Ls3BgqDyF3Goydz/Y6vFlDfG42wa8lt8/Pem97zD+Jj3tGnuneiL4vvoOiDO19+cXj04uzdWzQOTYidu9LVIfTlF/XaEb/57uykd4bMGxS9IwJTcfMLgPfcx+1D22xalWaNtCrNPdusHDZNu4JJu9U0D1tWv7kXiSr7ez9ZMWSyZOrLwJX5DdVqzqGZLj4JJiHhwgKPxSyfE0v3x297Z73oi/N/Sb7Z95cikm6Rg7pJ7Hqldtg2K02C9yvtBki6DUImNqm32g0r8TXQmW9MzBNaAgdKdPorOnMlLt+pTA5NvMq4YKR68SMxWH/fopC2xruq+GkHfortrx3EduNNBt4qP6AttCfauWm6CAeIoZ886sqvMgvk8MaxNJ13pxEZaoFq48eg2J5Uw1ERPbcPsLlH2vuVQ7tOKs0D66ByiPfMSv2gYe/t2wT3a02t1jY6gctpDbPrc2cJWSwfleNUK0i1auxU+beg4cf/AREgYQhhagAA
GENERIC
AuftrDatum
DATE
ffffffff-ffff-ffff-8000-000000000000
false
Default
AuftragsPos
USERDEFINED
ffffffff-ffff-ffff-8000-000000000000
false
subtable
Default
KdNr
INTEGER
ffffffff-ffff-ffff-8000-000000000000
false
Default
false
Auftrag -> DB
Role(name='Automatic Client')
de.aristaflow.tools.Scripting
executeScript
executeScript
de.aristaflow.adept2.extensions.scripting.component.ScriptingComponent
SHARE_EXECUTABLE_COMPONENT
AQ==
NullContext
false
false
false
false
false
org.postgresql.Driver
postgres
jdbc:postgresql://localhost:5432/legotrailerdb
postgres
jdbc
import de.aristaflow.adept2.extensions.datatypes.WebFormSubtable;
import java.sql.Timestamp;
def con = _jdbc.getConnection();
def sql = new Sql(con);
def auftrnr = sql.firstRow("SELECT MAX(auftrnr) + 1 AS auftrnr FROM auftraege")['auftrnr'];
def datum = new Timestamp($AuftrDatum.getTime())
sql.executeInsert("""
INSERT INTO auftraege (auftrnr, kdnr, auftrdatum)
VALUES (${auftrnr}, ${$KdNr}, ${datum})
""");
WebFormSubtable st = new WebFormSubtable();
st.loadFromUDTValue($AuftragsPos);
var anzahlPos = st.getRowCount();
for (i = 0; i < anzahlPos; i++)
{
def pos = i + 1;
def teileid = st.getValue("TeileNr", i);
def farbe = st.getValue("Farbe", i);
def anzahl = st.getValue("Anzahl", i);
sql.executeInsert("""
INSERT INTO auftragspos (auftrnr, pos, teileid, farbe, anzahl)
VALUES (${auftrnr}, ${pos}, ${teileid}, ${farbe}, ${anzahl})
""");
}
groovy
groovy
GENERIC
AuftrDatum
DATE
ffffffff-ffff-ffff-8000-000000000000
false
AuftragsPos
USERDEFINED
ffffffff-ffff-ffff-8000-000000000000
false
subtable
KdNr
INTEGER
ffffffff-ffff-ffff-8000-000000000000
false
false
INTEGER
KdNr
ffffffff-ffff-ffff-8000-000000000000
false
DATE
AuftrDatum
ffffffff-ffff-ffff-8000-000000000000
false
USERDEFINED
AuftragsPos
ffffffff-ffff-ffff-8000-000000000000
false
subtable
ET_CONTROL
ET_CONTROL
ET_CONTROL
WRITE
false
WRITE
false
WRITE
false
READ
false
READ
false
READ
false
n0
n1
NT_STARTFLOW
0
0
n1
NT_ENDFLOW
3
0
n0
NT_NORMAL
1
1
n0
n0
NT_NORMAL
2
1
n0
n0