{
    "keyColumn": "project_id",
    "reportPanel": "true",
    "reportTitle": "Project Report ",
    "defaultDateRange": "weekly",
    "dateRange": [
        "weekly",
        "monthly",
        "custom"
    ],
    "dateField": "worked_on",
    "dataSource": {
        "queryFunction": "Cmshelper::getProjectResourceAnalatics"
    },
    "export": "true",
    "listColumns": [
        "project_name",
        "project_category",
        "total_allocated_hours",
        "total_worked_hours",
        "details",
        "details_task"
    ],
    "exportColumns": [
        "project_name",
        "project_category",
        "project_start_date",
        "total_allocated_hours",
        "total_worked_hours"
    ],
    "detailColumns": [
        "project_name",
        "project_category",
        "total_allocated_hours",
        "total_worked_hours",
        "details",
        "details_task"
    ],
    "columns": {
        "project_name": {
            "name": "Project",
            "type": "text",
            "defaultText": "Admin",
            "sortable": "true",
            "searchable": "searchable"
        },
        "project_category": {
            "name": "Category",
            "defaultText": "0",
            "type": "text",
            "sortable": "true",
            "searchable": "searchable"
        },
        "total_allocated_hours": {
            "name": "Total Allocated Hours",
            "defaultText": "0",
            "type": "text"
        },
        "total_worked_hours": {
            "name": "Total Worked Hours",
            "defaultText": "0",
            "type": "text"
        },
        "details": {
            "name": "Resource Details",
            "customColumn": "true",
            "customaction": "Cmshelper::getDetailsText",
            "popupoptions": {
                "type": "popup",
                "customaction": "Cmshelper::getProjectDetailsURL"
            }
        },
        "details_task": {
            "name": "Task Details",
            "customColumn": "true",
            "customaction": "Cmshelper::getDetailsText",
            "popupoptions": {
                "type": "popup",
                "customaction": "Cmshelper::getProjectTaskDetailsURL"
            }
        }
    }
}