{ "keyColumn": "emp_main_id", "wildsearch": "true", "dataSource": "external", "dataSourceFunction": "Cmshelper::fetchEmployeeDetails", "dataSourceCountFunction": "Cmshelper::fetchEmployeeDetailsCount", "detailHeaderColumnPrefix": "Employees: ", "handleFile": "true", "detailHeaderColumns": [ "emp_code" ], "breadCrumbColumn": "emp_code", "orderBy": { "id": "DESC" }, "relations": { "Leave Requests": { "name": "Leave", "section": "lrequestemp", "child_table": "tbl_emp_leaves", "parent_join_column": "emp_main_id", "child_join_column": "emp_id" }, "Attendance": { "name": "Attendance", "section": "attendance", "child_table": "tbl_attendance", "parent_join_column": "emp_main_id", "child_join_column": "emp_id" } }, "listColumns": [ "profile_pic", "emp_code", "name", "dep_name", "desig_name" ], "showColumns": [ "id", "emp_code", "name", "dep_name", "desig_name" ], "detailColumns": [ "id", "emp_code", "name", "dep_name", "desig_name", "profile_pic" ], "columns": { "id": { "name": "ID" }, "profile_pic": { "name": "", "customColumn": "true", "customaction": "Cmshelper::getProfilePic" }, "name": { "searchable": "true", "sortable": "true", "name": "NAME" }, "emp_code": { "searchable": "true", "sortable": "true", "name": "EMP CODE" }, "dep_name": { "searchable": "true", "sortable": "true", "name": "DEPARTMENT" }, "desig_name": { "searchable": "true", "sortable": "true", "name": "DESIGNATION" } }, "opertations": [ "view" ] }