Datadefinition

{
    "datadefID": "catalogcustomer",
    "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",
    "displaycolumn": "name1",
    "key": "accountID",
    "rightcheck": 1,
    "headtitlecolumn": "name1",
    "headdescriptioncolumn": "city",
    "headimagecolumn": "image_file",
    "searchcolumn": "searchcolumn",
    "head": [],
    "head_end": [
        "<script src=\"{{root}}masterdata\/templates\/detail_template.js\"><\/script>"
    ],
    "masterdata": {
        "htmlout": "catalog",
        "edittype": 4,
        "search_mode": 1,
        "detail-carousel": false,
        "catalog_detaillink": true,
        "pagination": "external",
        "paginationsize": 2,
        "paginationalways": true,
        "defaultvalues": {
            "image_file": ""
        },
        "upload": {
            "enabled": true
        },
        "url_new": "index.php?page=form&datadefID=catalogcustomer&process_action=New&page_mode=2",
        "url_edit": "index.php?page=form&datadefID=catalogcustomer&process_action=Edit&page_mode=2",
        "url_detail": "index.php?page=detail&datadefID=catalogcustomer",
        "url_load": "masterdata\/ProcessData.php?datadefID=catalogcustomer&process_action=Load",
        "url_save": "masterdata\/ProcessData.php?datadefID=catalogcustomer&process_action=Save",
        "url_del": "masterdata\/ProcessData.php?datadefID=catalogcustomer&process_action=Del",
        "url_readfilter": "masterdata\/ProcessData.php",
        "data_readfilter": {
            "datadefID": "catalogcustomer",
            "process_action": "ReadFilter"
        },
        "sql_derived": "SELECT er_customer.*,'' as k8select,concat_ws(',',er_customer.`accountnumber`,er_customer.`name1`,er_customer.`name2`,er_customer.`street`,er_customer.`country`,er_customer.`code`,er_customer.`city`,er_customer.`phone`,er_customer.`mobile`,er_customer.`email`,er_customer.`website`,er_customer.`fax`,er_customer.`facebook`) as searchcolumn,k8login.username FROM er_customer LEFT OUTER JOIN k8login ON er_customer.creatorID=k8login.userID WHERE 1=1",
        "rightuser_create": 0
    },
    "html": {
        "catalog": {
            "container": "<div class=\"k8-example-catalog\"> <div class=\"pb-1 js_rec_container rec_container catalog\" data-rec_indexmax=\"-1\"> <div class=\"row js_rec_head js_catalog\" id=\"searcharea\"> <div class=\"col-sm-4 mt-3\"> <h1>#datadef#title#<\/h1> <\/div> <div class=\"col-sm-8 mt-3\"> <form id=\"filterform\" method=\"GET\"> <input type=\"hidden\" name=\"datadefID\"> <input type=\"hidden\" name=\"page\"> <input type=\"hidden\" name=\"table\"> <input type=\"hidden\" name=\"headtitlecolumn\"> <input type=\"hidden\" name=\"headdescriptioncolumn\"> <div class=\"input-group mt-1\" id=\"searchlineb5\"> <input type=\"search\" class=\"form-control\" placeholder=\"Search\" id=\"search\" name=\"search\" value=\"\"\/> <div class=\"input-group-btn\"> <button type=\"submit\" class=\"js_rec_search btn btn-primary\"><i class=\"bi-search\"><\/i><\/button> {{control_new}} <\/div> <\/div> <\/form> <\/div> <\/div> <div class=\"js_rec_head js_member\" style=\"display: none\"> <div class=\"k8-flex-row\"> <div class=\"k8-flex-100\"> <h2>#ls#In Preparation#<\/h2> <\/div> <div class=\"k8-flex-100 text-end\"> <button type=\"button\" class=\"js_rec_new btn btn-primary\">#ls#New#<\/button> <\/div> <\/div> <\/div> <hr> <div class=\"js_rec_records rec_records\"><\/div> <\/div> <\/div>",
            "record": "<div class=\"js_rec_record rec_record\" data-keyvalue=\"{{keyvalue}}\" data-rec_index=\"{{index}}\"> <div class=\"js_inlineform\"> <div class=\"row\"> <div class=\"col-sm-4\"> <div class=\"k8-box-square\"> <div class=\"k8-box-content\"> <img class=\"k8-image-{{image_orientation}}\" src=\"{{image_file}}\"> <\/div> <\/div> <\/div> <div class=\"col-sm-8\"> <div class=\"k8-padding-side-small\"> <div class=\"k8-link-main\"> {{control_edit}} <a class=\"js_detaillink\" href=\"{{masterdata_url_detail}}\">{{name1}}<\/a> {{control_delete}} <\/div> <div class=\"k8-content\"> <p>{{city}}<\/p>{{more_columns}} <\/div> <\/div> <\/div> <\/div> <\/div> <hr> <\/div>",
            "ALTrecord": "<div class=\"js_rec_record rec_record\" data-keyvalue=\"{{keyvalue}}\" data-rec_index=\"{{index}}\"> <div class=\"js_inlineform\"> <div class=\"row\"> <div class=\"col-sm-4\"> <div class=\"k8-box-square\"> <div class=\"k8-box-content\"> <img class=\"k8-image-{{image_orientation}}\" src=\"{{image_file}}\"> <\/div> <\/div> <\/div> <div class=\"col-sm-8\"> <div class=\"k8-padding-side-small\"> <div class=\"k8-link-main\"> {{control_edit}} <a class=\"js_detaillink\" href=\"\">{{name1}}<\/a> {{control_delete}} <\/div> <div class=\"k8-content\"> <p>{{city}}<\/p> <\/div> <\/div> <\/div> <\/div> <\/div> <hr> <\/div>"
        },
        "detail": {
            "container": "<div class=\"k8-detail\"> <div class=\"js_rec_container rec_container\" data-rec_indexmax=\"-1\" data-rec_object=\"\"> <div class=\"k8-padding-top-normal\"><a href=\"javascript:history.back()\"><span class=\"\"><i class=\"bi-arrow-left\"><\/i><\/span> #ls#back to results#<\/a><\/div> <div class=\"js_rec_records rec_records\">  <\/div> <\/div> <\/div>",
            "record": "<div class=\"js_rec_record rec_record\" data-keyvalue=\"{{keyvalue}}\" data-rec_index=\"{{index}}\"> <div class=\"row\"> <div class=\"col-sm-6 k8-margin-top-normal k8-margin-bottom-6\" style=\"\"> <div class=\"k8-box-square\"> <div class=\"k8-box-content\"> <img class=\"k8-image-{{image_orientation}}\" src=\"{{image_file}}\"> <\/div> <\/div> <div data-v_if=\"dat['image_array'].length>1\"> <div class=\"k8-image-list k8-hor-scrolling-wrapper\" data-loop_object=\"image_array\"> <div class=\"k8-hor-scrolling-card\"> <div class=\"k8-box-square\" style=\"width: 80px;\"> <div class=\"k8-box-content\"> <img style=\"cursor: pointer\" class=\"js_image_click k8-image-{{image_orientation*}}\" src=\"\" data-src=\"{{image_file*}}\"> <\/div> <\/div> <\/div> <\/div> <\/div> <\/div> <div class=\"col-sm-6 k8-margin-bottom-6\"> <div class=\"k8-padding-side-small\"> <div class=\"k8-link-main\"> <h1>{{name1}}<\/h1> <\/div> <div class=\"k8-content k8-padding-bottom-normal\"> <p>{{city}}<\/p> <div class=\"text-end\"> <button type=\"button\" class=\"js_mybtn btn btn-secondary\">Choose<\/button> <\/div> <\/div> <\/div> <\/div> <\/div> <hr style=\"margin-top: 10px\"> <div class=\"row k8-margin-bottom-normal\"> <div class=\"col-sm-12\"> <p>Place here more details<\/p> <\/div> <\/div> <div class=\"offer_list k8-margin-bottom-normal\"><\/div> <\/div>",
            "recinput": "<div class=\"js_rec_record rec_record\" data-keyvalue=\"{{keyvalue}}\" data-rec_index=\"{{index}}\"><div class=\"js_inlineform\">{{js_dataform}}<\/div><hr><\/div>"
        }
    },
    "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
        }
    ],
    "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"
            }
        ]
    }
}

the copy clipboard method is not supported in IE8 and earlier.