Datadefinition

{ "datadefID": "mycustomer", "table": "er_customer", "name": "er_customer", "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": 0, "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, "fieldname": "estimatedturnover", "myextra": "" }, { "Field": "firstcontact", "Type": "date", "Null": "YES", "Key": "", "Default": null, "Extra": "", "mytype": "DATE", "size": 0, "fieldname": "firstcontact", "myextra": "" }, { "Field": "datetimecreated", "Type": "datetime", "Null": "NO", "Key": "", "Default": null, "Extra": "", "mytype": "DATETIME", "size": 0, "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" }, "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 } ] }, "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" }, { "name": "firstcontact", "type": "date", "label": "firstcontact" } ] } }