'NULL' AND [WarningValue] <> '---'
) o
PIVOT (
MAX([TotalDisplacement])
FOR [Depth] IN ([0.5] ${depth})
) n;";
break;
case "TI":
$sql = "SELECT *
FROM (
SELECT [Date], [Direction], [TotalTilt], '±264' AS [WarningValue], '±330' AS [ActionValue]
FROM [BIMMonitor].[dbo].[TI_Data]
WHERE [EquipmentID] like '%{$monitor}%'
) o
PIVOT (
MAX([TotalTilt])
FOR [Direction] IN ([1-3], [2-4])
) n;";
break;
case "SB":
$sql = "SELECT [SB_Data].[Date], [TotalSettlement], [WarningValue], [ActionValue]
FROM [SB_Data] JOIN [SB_Warning] ON [SB_Data].[EquipmentID] = [SB_Warning].[EquipmentID]
WHERE [SB_Data].[EquipmentID] = '{$monitor}';";
break;
case "SM":
$sql = "SELECT [Date], [TotalSettlement], '±30' AS [WarningValue], '±50' AS [ActionValue]
FROM [SM_Data]
WHERE [EquipmentID] = '{$monitor}';";
break;
case "SP":
$sql = "SELECT [SP_Data].[Date], [WaterPressure], [HighWarningValue], [LowWarningValue],[HighActionValue],[LowActionValue]
FROM [SP_Data] JOIN [SP_Warning] ON [SP_Data].[EquipmentID] = [SP_Warning].[EquipmentID]
WHERE [SP_Data].[EquipmentID] = '{$monitor}';";
break;
}
$fetchResult = sqlsrv_query($conn, $sql);
while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_ASSOC)) {
array_push($chart, $row);
}
if ($fetchResult === false) {
if (($errors = sqlsrv_errors()) != null) {
foreach ($errors as $error) {
echo "SQLSTATE: " . $error['SQLSTATE'] . "
";
echo "code: " . $error['code'] . "
";
echo "message: " . $error['message'] . "
";
echo ($sql . "
");
var_dump($row);
}
}
}
$ajax["label"] = $label;
$ajax["unit"] = $unit;
$ajax["chart"] = $chart;
echo (json_encode($ajax));