{
    "reportPanel": "true",
    "reportTitle": "Staff Report ",
    "defaultDateRange": "weekly",
    "dateRange": [
        "weekly",
        "monthly",
        "custom"
    ],
    "dateField": "worked_on",
    "dataSource": {
        "queryFunction": "Cmshelper::getStaffAnalaticsQuery"
    },
    "export": "true",
    "keyColumn": "user_id",
    "listColumns": [
        "staff_name",
        "total_available_hours",
        "total_allocated_hours",
        "total_worked_hours",
        "total_efficiency",
        "total_utilization"
    ],
    "exportColumns": [
        "staff_name",
        "total_available_hours",
        "total_allocated_hours",
        "total_worked_hours",
        "total_efficiency",
        "total_utilization"
    ],
    "detailColumns": [
        "staff_name",
        "total_available_hours",
        "total_allocated_hours",
        "total_worked_hours",
        "total_efficiency",
        "total_utilization"
    ],
    "columns": {
        "staff_name": {
            "name": "Name",
            "type": "text",
            "defaultText": "Admin",
            "sortable": "true",
            "searchable": "searchable"
        },
        "total_available_hours": {
            "name": "Total Available Hours",
            "defaultText": "0",
            "type": "text"
        },
        "total_allocated_hours": {
            "name": "Total Allocated Hours",
            "defaultText": "0",
            "type": "text"
        },
        "total_worked_hours": {
            "name": "Total Worked Hours",
            "defaultText": "0",
            "type": "text"
        },
        "total_efficiency": {
            "name": "Total Efficiency (%)",
            "defaultText": "0",
            "type": "text"
        },
        "total_utilization": {
            "name": "Total Utilization (%)",
            "defaultText": "0",
            "type": "text"
        },
        "worked_on": {
            "name": "Added On",
            "type": "datetime",
            "dbFormat": "datetime",
            "displayFormat": "m/d/Y H:i a",
            "sortable": "true"
        }
    }
}