{ "keyColumn": "id", "wildsearch": "true", "detailHeaderColumnPrefix": "Attendace: ", "handleFile": "true", "detailHeaderColumns": [ "username" ], "breadCrumbColumn": "username", "orderBy": { "id": "DESC" }, "reference": { "referenceTable": "tbl_employee", "referenceColumn": "emp_id", "referenceTableForiegnKey": "emp_main_id" }, "listColumns": [ "date", "emp_id", "shift_type", "check_in", "check_out", "hours_worked" ], "showColumns": [ "id", "date", "emp_id", "shift_type", "check_in", "check_out" ], "detailColumns": [ "date", "emp_id", "shift_type", "check_in", "check_out", "hours_worked" ], "columns": { "id": { "name": "ID", "editoptions": { "type": "hidden" } }, "date": { "name": "Date", "searchable": "true", "sortable": "true", "dbFormat": "date", "displayFormat": "m/d/Y", "editoptions": { "dbFormat": "date", "displayFormat": "m/d/Y", "type": "datepicker", "label": "Date", "class": "", "validations": [ "required" ] } }, "emp_id": { "name": "Username", "searchable": "true", "sortable": "true", "external": "true", "externalOptions": { "externalTable": "tbl_employee", "externalColumn": "emp_main_id", "externalShowColumn": "first_name" } }, "shift_type": { "name": "Shift", "external": "true", "externalOptions": { "externalTable": "tbl_shifts", "externalColumn": "id", "externalShowColumn": "title" } }, "check_in": { "name": "Check In", "dbFormat": "datetime", "displayFormat": "m/d/Y h: ia", "editoptions": { "dbFormat": "date", "displayFormat": "m/d/Y", "type": "textbox", "label": "Check In", "hint": "Y-m-d h:i:s", "class": "", "validations": [ "required" ] } }, "check_out": { "name": "Check Out", "customColumn": "true", "customaction": "Cmshelper::getCheckoutTime", "editoptions": { "dbFormat": "date", "displayFormat": "m/d/Y", "type": "textbox", "label": "Check Out", "hint": "Y-m-d h:i:s", "class": "", "validations": [ "required" ] } }, "hours_worked": { "name": "Time", "customColumn": "true", "customaction": "Cmshelper::getAttndcTimeFromat" } }, "customActions": { "beforeAddRecord": "Cmshelper::checkAttndcCondtn" }, "opertations": [ "view" ], "operationLabel": { "viewTitle": "View" } }