getThirdZzytransaction function
dynamic
getThirdZzytransaction(
- dynamic dbData,
- dynamic datamodel
Implementation
getThirdZzytransaction(dbData, datamodel) {
dynamic data = dbData;
if (isNull(data)) {
data = [];
}
return [
{
"action": "processTab",
"data": [
{
"type": "table",
"label": "droplist",
"actionid": "Zzycompany",
"body": {
"Zzycompany": {
"timestamp": 1702420682992,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"detail": "Zzycompanydetail",
"label": "Company",
"parenttab": "Configuration",
"isCommon": true,
"needCache": false,
"inheritData": false,
"icon": 61195,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "name",
"dbid": "name",
"type": "text",
"label": "name",
"defaultValue": "",
"required": true,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "email",
"dbid": "email",
"type": "email",
"label": "email",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "email",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "shipto",
"dbid": "shipto",
"type": "Address",
"label": "shipto",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Address",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "billto",
"dbid": "billto",
"type": "Address",
"label": "billto",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Address",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "cell",
"dbid": "cell",
"type": "phone",
"label": "cell",
"defaultValue": "",
"required": false,
"minLength": 10,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "phone",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 60,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "url",
"dbid": "url",
"type": "url",
"label": "url",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "url",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 70,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "logo",
"dbid": "logo",
"type": "icon",
"label": "logo",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "icon",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 80,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "currency",
"dbid": "currency",
"type": "text",
"label": "currency",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycurrency",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 90,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "balance",
"dbid": "balance",
"type": "Money",
"label": "balance",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Money",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 100,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 110,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "paymentid",
"dbid": "paymentid",
"type": "text",
"label": "paymentid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycompanypayment",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 120,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 130,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
},
{
"id": "parentid",
"dbid": "parentid",
"type": "text",
"label": "parentid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycompany",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 140,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "industryid",
"dbid": "industryid",
"type": "text",
"label": "industryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyindustry",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 150,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
}
],
"data": [
{
"id": appParam[gCompanyid],
"name": "amerchant",
"email": "null",
"shipto": "null",
"billto": "null",
"cell": "null",
"url": "null",
"logo": "null",
"currency": "CAD",
"balance": "348801",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"paymentid": "null",
"entrytime": "1701378388600",
"parentid": "6",
"industryid": "f12f6225-6bee-41c5-9acf-c98dbf2378cb"
}
]
}
}
},
{
"type": "table",
"label": "droplist",
"actionid": "Zzyuser",
"body": {
"Zzyuser": {
"timestamp": 1702420682994,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"label": "User",
"parenttab": "Configuration",
"isCommon": true,
"needCache": true,
"inheritData": false,
"icon": 62075,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "email",
"dbid": "email",
"type": "email",
"label": "email",
"defaultValue": "",
"required": true,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "email",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": true,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "birthday",
"dbid": "birthday",
"type": "date",
"label": "birthday",
"defaultValue": "",
"required": true,
"minLength": 10,
"length": 10,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "date",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "address",
"dbid": "address",
"type": "Address",
"label": "address",
"defaultValue": "",
"required": true,
"minLength": 5,
"length": 250,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Address",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "phone",
"dbid": "phone",
"type": "phone",
"label": "phone",
"defaultValue": "",
"required": true,
"minLength": 10,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "phone",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 60,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "balance",
"dbid": "balance",
"type": "Money",
"label": "balance",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Money",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 70,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "firstname",
"dbid": "firstname",
"type": "text",
"label": "firstname",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 80,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "middlename",
"dbid": "middlename",
"type": "text",
"label": "middlename",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 90,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "username",
"dbid": "username",
"type": "text",
"label": "username",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 100,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "countrycode",
"dbid": "countrycode",
"type": "text",
"label": "countrycode",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 2,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycountrycode",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 110,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "gender",
"dbid": "gender",
"type": "text",
"label": "gender",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 10,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzygender",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 120,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "code",
"dbid": "code",
"type": "hidden",
"label": "code",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 130,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "selfie",
"dbid": "selfie",
"type": "selfie",
"label": "selfie",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "selfie",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 140,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "token",
"dbid": "token",
"type": "hidden",
"label": "token",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 150,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "url",
"dbid": "url",
"type": "url",
"label": "url",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "url",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 160,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "msgtoken",
"dbid": "msgtoken",
"type": "hidden",
"label": "msgtoken",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 170,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 180,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 190,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
},
{
"id": "Zzyuserrole_roleid",
"dbid": "Zzyuserrole_roleid",
"type": "text",
"label": "roleid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyrole",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
}
],
"data": [
{
"id": "c46d41b5-5106-4817-ac34-aef34ea14ee7",
"email": "mdls0owner@mdl.com",
"birthday": "1978-02-11",
"address": "mdls0 owner Avenue,Surrey,BC,Canada",
"phone": "(604)777-7700",
"balance": "0",
"firstname": "mdls0",
"middlename": "null",
"username": "s0owner",
"countrycode": "CA",
"gender": "male",
"code": "null",
"selfie": "null",
"token": "f7c77c01-9900-42bc-9068-f4803aa4887d",
"url": "null",
"msgtoken":
"dbKGbNBfTD6qdOlJ--Ol7w:APA91bGl8CYyipZp8Jko_cmX87on4D5QR2bBrUNSrnZ_2UXsKBxRFbbMoSdaggNv9nmC1IH8g6B6a0wb5QsSg0KqZWlkvBVYf9kySeGavmT4KQjhHqTrq3XV9sXGMMkAUEP6fJr9RN5Q",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378390556",
"Zzyuserrole_roleid": "f37c7732-75cb-4096-be2a-f19cb6a04fd9"
},
{
"id": appParam[gTargetid],
"email": appParam['$gLogin$gValue'],
"birthday": "1978-02-11",
"address": "mdls0 employee Avenue,Surrey,BC,Canada",
"phone": "(604)777-7771",
"balance": "0",
"firstname": "mdls0",
"middlename": "null",
"username": "s0employee",
"countrycode": "CA",
"gender": "male",
"code": "null",
"selfie": "null",
"token": "7093c43f-6413-4908-8846-95713dda1a2a",
"url": "null",
"msgtoken": "null",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378394527",
"Zzyuserrole_roleid": "9f43a12c-fdc2-4578-9073-f13043072fd9"
}
]
}
}
},
{
"type": "table",
"label": "droplist",
"actionid": "Zzyrole",
"body": {
"Zzyrole": {
"timestamp": 1702420683000,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"detail": "Zzyuser(roleid)",
"label": "Role",
"logmerge": "Y",
"parenttab": "Configuration",
"isCommon": false,
"needCache": true,
"inheritData": false,
"icon": 62251,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "label",
"dbid": "label",
"type": "text",
"label": "label",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "parentid",
"dbid": "parentid",
"type": "text",
"label": "parentid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist":
"Zzyrole[roleid from Zzyuserrole where parentid='@uID']",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "image",
"dbid": "image",
"type": "icon",
"label": "image",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "icon",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 60,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
}
],
"data": [
{
"id": "f37c7732-75cb-4096-be2a-f19cb6a04fd9",
"label": "owner",
"parentid": "null",
"image": "61868",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378388698"
},
{
"id": "9f43a12c-fdc2-4578-9073-f13043072fd9",
"label": "employee",
"parentid": "f37c7732-75cb-4096-be2a-f19cb6a04fd9",
"image": "62467",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378396276"
}
]
}
}
},
{
"type": "table",
"label": "droplist",
"actionid": "Zzyuserrole",
"body": {
"Zzyuserrole": {
"timestamp": 1702420683000,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"label": "User Role",
"logmerge": "Y",
"isCommon": false,
"needCache": false,
"inheritData": false,
"icon": 61719,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "parentid",
"dbid": "parentid",
"type": "text",
"label": "parentid",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "roleid",
"dbid": "roleid",
"type": "text",
"label": "roleid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyrole",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
}
],
"data": [
{
"id": "78a33857-1fb3-4dde-bf14-ccef5496bfb1",
"parentid": "c46d41b5-5106-4817-ac34-aef34ea14ee7",
"roleid": "f37c7732-75cb-4096-be2a-f19cb6a04fd9",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378391747"
},
{
"id": "92d4651a-0f20-4c7e-ad25-44ab2bfaa508",
"parentid": appParam[gTargetid],
"roleid": "9f43a12c-fdc2-4578-9073-f13043072fd9",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378394567"
}
]
}
}
},
{
"type": "table",
"label": "droplist",
"actionid": "Zzycompanypayment",
"body": {
"Zzycompanypayment": {
"timestamp": 1702420683002,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"detail": "Zzycompanydetail",
"label": "Payment",
"parenttab": "Configuration",
"isCommon": true,
"needCache": false,
"inheritData": false,
"icon": 62169,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "name",
"dbid": "name",
"type": "text",
"label": "name",
"defaultValue": "",
"required": true,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "email",
"dbid": "email",
"type": "email",
"label": "email",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "email",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "shipto",
"dbid": "shipto",
"type": "Address",
"label": "shipto",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Address",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "billto",
"dbid": "billto",
"type": "Address",
"label": "billto",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Address",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "cell",
"dbid": "cell",
"type": "phone",
"label": "cell",
"defaultValue": "",
"required": false,
"minLength": 10,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "phone",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 60,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "url",
"dbid": "url",
"type": "url",
"label": "url",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "url",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 70,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "logo",
"dbid": "logo",
"type": "icon",
"label": "logo",
"defaultValue": "",
"required": false,
"minLength": 5,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "icon",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 80,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "currency",
"dbid": "currency",
"type": "text",
"label": "currency",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycurrency",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 90,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "balance",
"dbid": "balance",
"type": "Money",
"label": "balance",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "Money",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 100,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 110,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 120,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
},
{
"id": "parentid",
"dbid": "parentid",
"type": "text",
"label": "parentid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyindustry",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 130,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
}
],
"data": []
}
}
},
{
"type": "table",
"label": "droplist",
"actionid": "Zzyindustry",
"body": {
"Zzyindustry": {
"timestamp": 1702420683004,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": true,
"detail": "Zzyindustryprogram",
"label": "Industry",
"logmerge": "Y",
"parenttab": "Configuration",
"isCommon": true,
"needCache": true,
"inheritData": false,
"icon": 61239,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "label",
"dbid": "label",
"type": "text",
"label": "label",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "text",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": true,
"isKeyword": true,
"droplist": "",
"uniqueKey": "",
"isUnique": true,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entryid",
"dbid": "entryid",
"type": "label",
"label": "entryid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzyuser",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
}
],
"data": [
{
"id": "cc675de2-943e-4f84-aa8e-fb5466bc36fd",
"label": "Resteraunt",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239666"
},
{
"id": "ced16f77-ec9d-4559-92c8-6bc61120c777",
"label": "saveX customer",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239882"
},
{
"id": "fb52766f-0cd5-4dbc-87ad-249e5ffc0343",
"label": "saveX",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239733"
},
{
"id": "7e6d021c-8b45-47a2-b2e2-5352f77ecc78",
"label": "school",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239408"
},
{
"id": "f12f6225-6bee-41c5-9acf-c98dbf2378cb",
"label": "saveX merchant",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239800"
},
{
"id": "61124d71-3f5e-4889-85f2-267ad1f01e5c",
"label": "distributor",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378239580"
},
{
"id": "18506b3a-127e-474e-a99b-5942b2c44842",
"label": "payment",
"entryid": "756a6fd0-81d7-47c6-9496-8252aad3cdeb",
"entrytime": "1701378238045"
}
]
}
}
},
{
"colorIndex": 0,
"label": "Transaction",
"type": "table",
"actionid": "Zzytransaction",
"param0": "hometab",
"where":
"parentid='17' and transtype='giftcard' and targettype='customer' and action='consume' and targetid='${appParam[gTargetid]}'",
"transpass": null,
"body": {
"Zzytransaction": {
"timestamp": 1702420682989,
"attr": {
"canInsert": true,
"canEdit": true,
"canDelete": false,
"label": "Transaction",
"parenttab": "Business",
"isCommon": false,
"needCache": false,
"inheritData": false,
"icon": 61195,
"namereal": null
},
"columns": [
{
"id": "id",
"dbid": "id",
"type": "hidden",
"label": "id",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "hidden",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 10,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "parentid",
"dbid": "parentid",
"type": "drop",
"label": "parentid",
"defaultValue": "17",
"required": true,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzycompany",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 20,
"canshow": true,
"fromsource": "",
"isFrozen": true,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "targettype",
"dbid": "targettype",
"type": "drop",
"label": "targettype",
"defaultValue": "customer",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzytargettype",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 30,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "transtype",
"dbid": "transtype",
"type": "drop",
"label": "transtype",
"defaultValue": "giftcard",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzytransactiontype",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 40,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "action",
"dbid": "action",
"type": "drop",
"label": "action",
"defaultValue": "consume",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "Zzytransactionaction",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 50,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "targetid",
"dbid": "targetid",
"type": "drop",
"label": "targetid",
"defaultValue": appParam[gTargetid],
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "dynamic",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 60,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": gOrderno,
"dbid": gOrderno,
"type": "text",
"label": gOrder,
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 50,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gText,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 65,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": gOrderno,
gReadonlyAfter: gPaid,
"showrange": ""
},
{
"id": "amount",
"dbid": "amount",
"type": "money",
"label": "amount",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "money",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 70,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": true,
"after": "",
"showrange": "",
"sumtype": "sum",
gReadonlyAfter: gPaid
},
{
"id": "tip",
"dbid": "tip",
"type": "tip",
"label": "Tip",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gNumber,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 80,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": appParam['$gTip$gIsWholePage'],
"after": "amount",
"showrange": "",
"sumtype": "sum",
gReadonlyAfter: gPaid
},
{
"id": "total",
"dbid": "total",
"type": "money",
"label": "Total",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "money",
"fontSize": 24.0,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 81,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "tip",
"showrange": "",
"sumtype": "sum",
"compute": "amount+tip",
},
{
"id": "paid",
"dbid": "paid",
"type": "money",
"label": "Paid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "money",
"fontSize": 24.0,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 82,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": gOrderno,
"showrange": "",
gReadonlyAfter: gPaid,
},
{
"id": "unpaid",
"dbid": "unpaid",
"type": "money",
"label": "Unpaid",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "money",
"fontSize": 24.0,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 83,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "paid",
"sumtype": "sum",
"compute": "amount+tip-paid",
"showrange": "form",
gAfterExpression: {
gAction: "amount+tip-paid",
gValue: 0,
gOperator: '>'
},
},
{
"id": "barcode",
"dbid": "barcode",
"type": "scan",
"label": "Qr code",
"defaultValue": "",
"required": true,
"minLength": 0,
"length": 180,
"hash": false,
"unit": "character",
"prefixIcon": 62169,
"inputType": "scan",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.String",
"isFile": false,
"seq": 90,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": 'amount',
gAfterExpression: {
gAction: "amount+tip-paid",
gValue: 0,
gOperator: '>'
},
"showrange": "form"
},
{
"id": "pin",
"dbid": "pin",
"type": "number",
"label": "Pin",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 4,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "code", //gNumber,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Integer",
"isFile": false,
"seq": 100,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "barcode",
"afterExpression": {
gAction: "amount+tip-paid",
gValue: 0,
gOperator: '>'
},
"showrange": "form"
},
{
"id": "originalamount",
"dbid": "originalamount",
"type": "money",
"label": "originalamount",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 80,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gHidden,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 100,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": ""
},
{
"id": "entrytime",
"dbid": "entrytime",
"type": "label",
"label": "entrytime",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": "datetime",
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 120,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "",
"showrange": "table"
},
{
"id": "btncontinuepay",
"dbid": "btncontinuepay",
"type": gBtn,
"label": "Continue Pay [$gUnpaid]",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gBtn,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 130,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "unpaid,paid",
"showrange": "form",
gFunction: [
{gAction: 'continuepayTransaction', gData: []}
],
},
{
"id": "btnprintreceipt",
"dbid": "btnprintreceipt",
"type": gBtn,
"label": "Print receipt and Exit",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gBtn,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 140,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"after": "paid",
"showrange": "form",
gFunction: [
{
gAction: 'printReceiptTransaction',
gData: [
{gIsselected: true}
]
}
],
},
{
"id": "btnexit",
"dbid": "btnexit",
"type": gBtn,
"label": "Cancel",
"defaultValue": "",
"required": false,
"minLength": 0,
"length": 255,
"hash": false,
"unit": "character",
"prefixIcon": null,
"inputType": gBtn,
"fontSize": null,
"letterSpacing": 0.0,
"isPrimary": false,
"isKeyword": false,
"droplist": "",
"uniqueKey": "",
"isUnique": false,
"colType": "java.lang.Long",
"isFile": false,
"seq": 150,
"canshow": true,
"fromsource": "",
"isFrozen": false,
"addNewCheck": false,
"isWholePage": false,
"showrange": "form",
gFunction: [
{gAction: gBackContext, gData: []},
{
gAction: gTableAddNewCommon,
gData: [
{
gTableID: gZzytransaction,
gType: gTable,
gLabel: gPay,
gWhere:
"parentid='${datamodel.globalParam[gGlobalCompanyid]}' and transtype='$gCustomer' and targettype='$gCustomer' and action='$gConsume' and targetid='targetfakeid'",
}
]
}
],
}
],
"data": data
}
}
},
]
},
{
"action": "runfutureSeq",
"data": [
{"seq": 0}
]
}
];
}