HIMS ERP 1.0

Step wise implementation Process

View Charts

*Step 1:

https://qa.satragroup.in/HIMS_RRAMS/services/chart*

Dropdown -> Bind ObjectName

{
"Id": 2,
"ObjectName": "Road network",
"Module": "LRMS",
"ViewName": "nmVWRoadClassbyRoadLength",
"ChartType": "column",
"SubChartType": "",
"Xaxis": "Road Class",
"Yaxis": "Length in km",
"Zaxis": "",
"ChartQuery": "select [Road Class],SUMas [Length in km] from [nmVWRoadClassbyRoadLength] group by [Road Class]",
"ChartColor": "#00ff00",
"ChartLabelsColor": "#000000",
"ChartFontType": "Arial",
"ChartBackgroundColor": "#ffffff",
"ChartGridlineColor": "#000000",
"ChartTitle": "Road network",
"YFontSize": "11",
"YFontWeight": "False",
"YFontColor": "#000000",
"XFontSize": "11",
"XFontWeight": "False",
"XFontColor": "#000000",
"XaxisOrientation": null,
"DataLabelShowAll": "True",
"DataLabelPercent": "False",
"DataLabelFontSize": "11",
"DataLabelColor": "#000000",
"YListItems": "",
"YStatus": "False",
"XListItems": "",
"XStatus": "False",
"ZListItems": "",
"ZStatus": "False",
"Radio_Y": "Sum",
"Radio_X": "",
"Datatable": null,
"ColumnDetails": null,
"Xaxis_Title": "Road Class",
"Yaxis_Title": "Length (in km)",
"Zaxis_Title": "",
"ThresholdValue": 0.0,
"ChartLength": null,
"Length": null
}

Step2: https://qa.satragroup.in/HIMS_RRAMS/services/chart/GetChartData/61
Pass the ID from the above Object

[
{
        "Id": 61,
        "ObjectName": "Roughness",
        "Module": "RIS",
        "ViewName": "risVWStateWiseRghbyR1",
        "ChartType": "column",
        "SubChartType": "",
        "Xaxis": "Catg",
        "Yaxis": "Length",
        "Zaxis": "",
        "ChartQuery": "select [Catg],COUNT([Length])as [Length] from [risVWStateWiseRghbyR1] group by [Catg]",
        "ChartColor": "#67b7dc",
        "ChartLabelsColor": "#000000",
        "ChartFontType": "Arial",
        "ChartBackgroundColor": "#ffffff",
        "ChartGridlineColor": "#000000",
        "ChartTitle": "Roughness",
        "YFontSize": "11",
        "YFontWeight": "False",
        "YFontColor": "#000000",
        "XFontSize": "11",
        "XFontWeight": "False",
        "XFontColor": "#000000",
        "XaxisOrientation": "0",
        "DataLabelShowAll": "False",
        "DataLabelPercent": "False",
        "DataLabelFontSize": "11",
        "DataLabelColor": "#000000",
        "YListItems": "",
        "YStatus": "False",
        "XListItems": "",
        "XStatus": "False",
        "ZListItems": "",
        "ZStatus": "False",
        "Radio_Y": "Count",
        "Radio_X": "",
        "Datatable": null,
        "ColumnDetails": [
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "RoadCode",
                "Data_Type": "nvarchar" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "linkcode",
                "Data_Type": "nvarchar" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Direction",
                "Data_Type": "nvarchar" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Startch",
                "Data_Type": "int" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Endch",
                "Data_Type": "int" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Length",
                "Data_Type": "decimal" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Catg",
                "Data_Type": "nvarchar" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "Colour",
                "Data_Type": "nvarchar" 
            },
        {
                "ViewName": "risVWStateWiseRghbyR1",
                "Column_Name": "surveyid",
                "Data_Type": "nvarchar" 
            }
        ],
        "Xaxis_Title": "Catg",
        "Yaxis_Title": "Length",
        "Zaxis_Title": "",
        "ThresholdValue": 0.0,
        "ChartLength": null,
        "Length": null
    }
]

Step 3:
https://qa.satragroup.in/HIMS_RRAMS/services/assets/GetChartData/DynamicQuery

https://qa.satragroup.in/HIMS_RRAMS/services/assets/GetChartData/DynamicQuery
select [Catg],COUNTas [Length] from [risVWStateWiseRghbyR1] group by [Catg]

Post : payload pass ChartQuery from above Response

{
"Data": [ {
"Name": "Good",
"chked": "false"
}, {
"Name": "Very Poor",
"chked": "false"
}, {
"Name": "Fair",
"chked": "false"
}, {
"Name": "Very Good",
"chked": "false"
}, {
"Name": "Poor",
"chked": "false"
}
],
"Status": true,
"Message": null,
"Caption": "Data",
"Id": 0
}

STEP 3: http://{}HIMSERPAPI/services/assets/GetChartData/DynamicQuery

BODY: "select [Catg],COUNTas [Length] from [risVWStateWiseRghbyR1] group by [Catg]"

RESPONSE

{
"Data": [ {
"Catg": "Fair",
"Length": 38436
}, {
"Catg": "Very Good",
"Length": 17443
}, {
"Catg": "Very Poor",
"Length": 6346
}, {
"Catg": "Poor",
"Length": 13785
}, {
"Catg": "Good",
"Length": 74853
}
],
"Status": true,
"Message": null,
"Caption": "Data",
"Id": 0
}

Added RIS View Column Chart