BIM-Monitor/script/php/getCompareChartData.php

<?php    
	if(isset($_GET["option"])){
		include "connectSQL.php";
		$option = $_GET["option"];
		$m_date = array();
		$chart_data = array();
		$row_count = 0;
		
    
		$label = [];
		$sql_Table = "SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('[C3].[dbo].[".$option."data]') ";
		$fetchResult_Table = sqlsrv_query($conn, $sql_Table);
		while($column_name_table = sqlsrv_fetch_array($fetchResult_Table)){
			array_push($label,$column_name_table[0]);        
		}
		
		$sqlELP = "SELECT * FROM [C3].[dbo].[ELPdata]";
		$sqlOW = "SELECT * FROM [C3].[dbo].[OWdata]";
		if($option == "ELP"){			
			$fetchResult = sqlsrv_query($conn, $sqlELP);
			while($row = sqlsrv_fetch_array($fetchResult)){
				array_push($m_date,$row[0]);
				for($i = 1; $i < 15; $i++){
					$chart_data[$i][$row_count] = $row[$i];
				}
				$row_count++;
			}			
		}else if($option == "OW"){
			$fetchResult = sqlsrv_query($conn, $sqlOW);
			while($row = sqlsrv_fetch_array($fetchResult)){
				array_push($m_date,$row[0]);
				for($i = 1; $i < 8; $i++){
					$chart_data[$i][$row_count] = $row[$i];
				}
				$row_count++;
			}
		}		
		
		$array = array();
		$array['m_date'] = $m_date;
		$array['chart_data'] = $chart_data;
		$array['label'] = $label;
		echo json_encode($array);
		sqlsrv_close( $conn );
		
	}
	
?>