Datadefinition

{ "datadefID": "mycustomer", "table": "er_customer", "name": "er_customer", "headtitle": "er_customer", "headdescription": "This is element wast created with K8 Web Kit", "revision": 2, "objectclass": "data_accessclass", "requiredfile": "masterdata\/class_data_accessclass.php", "rightcheck": 1, "key": "accountID", "columns": [ { "Field": "accountID", "Type": "int(10)", "Null": "NO", "Key": "PRI", "Default": null, "Extra": "auto_increment", "mytype": "INT", "size": "10", "fieldname": "accountID", "myextra": "auto_increment", "noupdate": 1, "noinsert": 1 }, { "Field": "clientID", "Type": "int(10)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "INT", "size": "10", "fieldname": "clientID", "myextra": "", "noupdate": 1, "noinsert": 1 }, { "Field": "accountnumber", "Type": "varchar(50)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "accountnumber", "myextra": "" }, { "Field": "name1", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "name1", "myextra": "" }, { "Field": "name2", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "name2", "myextra": "" }, { "Field": "street", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "street", "myextra": "" }, { "Field": "country", "Type": "varchar(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "10", "fieldname": "country", "myextra": "" }, { "Field": "code", "Type": "varchar(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "10", "fieldname": "code", "myextra": "" }, { "Field": "city", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "city", "myextra": "" }, { "Field": "phone", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "phone", "myextra": "" }, { "Field": "mobile", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "mobile", "myextra": "" }, { "Field": "email", "Type": "varchar(250)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "250", "fieldname": "email", "myextra": "" }, { "Field": "website", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "100", "fieldname": "website", "myextra": "" }, { "Field": "fax", "Type": "varchar(50)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "50", "fieldname": "fax", "myextra": "" }, { "Field": "facebook", "Type": "varchar(100)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "VARCHAR", "size": "100", "fieldname": "facebook", "myextra": "" }, { "Field": "memo", "Type": "text", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "TEXT", "size": "", "fieldname": "memo", "myextra": "" }, { "Field": "categoryID", "Type": "int(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "INT", "size": "10", "fieldname": "categoryID", "myextra": "" }, { "Field": "representativeID", "Type": "int(10)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "INT", "size": "10", "fieldname": "representativeID", "myextra": "" }, { "Field": "estimatedturnover", "Type": "decimal(10,2)", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "DECIMAL", "size": "10,2", "fieldname": "estimatedturnover", "myextra": "" }, { "Field": "firstcontact", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "DATE", "size": "", "fieldname": "firstcontact", "myextra": "" }, { "Field": "datetimecreated", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "DATETIME", "size": "", "fieldname": "datetimecreated", "myextra": "" }, { "Field": "creatorID", "Type": "int(10)", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "INT", "size": "10", "fieldname": "creatorID", "myextra": "", "noupdate": 1, "noinsert": 1 } ], "masterdata": { "url_new": "index.php?page=form&datadefID=mycustomer&process_action=New&page_mode=2", "url_edit": "index.php?page=form&datadefID=mycustomer&process_action=Edit&page_mode=2", "url_detail": "index.php?page=detail&datadefID=mycustomer", "url_load": "masterdata\/ProcessData.php?datadefID=mycustomer&process_action=Load", "url_save": "masterdata\/ProcessData.php?datadefID=mycustomer&process_action=Save", "url_del": "masterdata\/ProcessData.php?datadefID=mycustomer&process_action=Del", "url_readfilter": "masterdata\/ProcessData.php", "data_readfilter": { "datadefID": "mycustomer", "process_action": "ReadFilter" }, "sql_derived": "SELECT er_customer.*,'' as k8select,k8login.username FROM er_customer LEFT OUTER JOIN k8login ON er_customer.creatorID=k8login.userID WHERE 1=1", "rightuser_create": 0 }, "tabulator": { "columns": [ { "title": "accountID", "field": "accountID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "accountnumber", "field": "accountnumber", "headerFilter": true }, { "title": "name1", "field": "name1", "headerFilter": true }, { "title": "name2", "field": "name2", "headerFilter": true }, { "title": "street", "field": "street", "headerFilter": true }, { "title": "country", "field": "country", "headerFilter": true }, { "title": "code", "field": "code", "headerFilter": true }, { "title": "city", "field": "city", "headerFilter": true }, { "title": "phone", "field": "phone", "headerFilter": true }, { "title": "mobile", "field": "mobile", "headerFilter": true, "visible": false }, { "title": "email", "field": "email", "headerFilter": true, "visible": false }, { "title": "website", "field": "website", "headerFilter": true, "visible": false }, { "title": "fax", "field": "fax", "headerFilter": true, "visible": false }, { "title": "facebook", "field": "facebook", "headerFilter": true, "visible": false }, { "title": "memo", "field": "memo", "headerFilter": true, "visible": false }, { "title": "categoryID", "field": "categoryID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "representativeID", "field": "representativeID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "estimatedturnover", "field": "estimatedturnover", "headerFilter": true, "hozAlign": "right", "width": "80", "formatter": "money", "formatterParams": { "decimal": "GLOBALS_decimal_point", "thousand": "GLOBALS_thousands_sep", "precision": "2" }, "visible": false }, { "title": "firstcontact", "field": "firstcontact", "headerFilter": "input", "width": 120, "formatter": "datetime", "formatterParams": { "inputFormat": "yyyy-MM-dd", "outputFormat": "GLOBALS_tabulatordateformat" }, "visible": false }, { "title": "datetimecreated", "field": "datetimecreated", "headerFilter": "input", "width": 160, "formatter": "datetime", "formatterParams": { "inputFormat": "yyyy-MM-dd HH:mm:ss", "outputFormat": "GLOBALS_tabulatordatetimeformat" }, "visible": false }, { "title": "creatorID", "field": "creatorID", "headerFilter": true, "hozAlign": "right", "width": "80", "visible": false }, { "title": "creatorname", "field": "username", "headerFilter": true } ] }, "k8form": { "selector": ".js_dataform", "templatetype": "masterform", "fields": [ { "name": "accountID", "type": "hidden", "label": "accountID" }, { "name": "accountnumber", "type": "text", "label": "accountnumber", "attributes": { "maxlength": "50" } }, { "name": "name1", "type": "text", "label": "name1", "attributes": { "maxlength": "50" } }, { "name": "name2", "type": "text", "label": "name2", "attributes": { "maxlength": "50" } }, { "name": "street", "type": "text", "label": "street", "attributes": { "maxlength": "50" } }, { "name": "country", "type": "text", "label": "country", "attributes": { "maxlength": "10" } }, { "name": "code", "type": "text", "label": "code", "attributes": { "maxlength": "10" } }, { "name": "city", "type": "text", "label": "city", "attributes": { "maxlength": "50" } }, { "name": "phone", "type": "text", "label": "phone", "attributes": { "maxlength": "50" } }, { "name": "mobile", "type": "text", "label": "mobile", "attributes": { "maxlength": "50" } }, { "name": "email", "type": "text", "label": "email", "attributes": { "maxlength": "250" } }, { "name": "website", "type": "text", "label": "website", "attributes": { "maxlength": "100" } }, { "name": "fax", "type": "text", "label": "fax", "attributes": { "maxlength": "50" } }, { "name": "facebook", "type": "text", "label": "facebook", "attributes": { "maxlength": "100" } }, { "name": "memo", "tagName": "textarea", "label": "memo" }, { "name": "categoryID", "type": "number", "label": "categoryID" }, { "name": "representativeID", "type": "number", "label": "representativeID" }, { "name": "estimatedturnover", "type": "number", "label": "estimatedturnover", "decimals": "2", "attributes": { "step": "0.01" } }, { "name": "firstcontact", "type": "date", "label": "firstcontact" } ] } }