<?php
include("connectSQL_Component.php");
if (isset($_GET["object"]) && isset($_GET["type"])) {
    $type = $_GET["type"];
    $name = $_GET["object"];
    $table_header = [];
    $table_value = [];
    $COLUMN_NAME = [];
    $table= [];
    $sql = "SELECT COLUMN_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE TABLE_NAME = 'Arch_MEP_" . $type . "' ";
    $fetchResult = sqlsrv_query($conn, $sql);
    while ($row = sqlsrv_fetch_array($fetchResult)) {
        array_push($COLUMN_NAME, $row["COLUMN_NAME"]);
    }
    $sql = "SELECT * FROM [BIMComponents].[dbo].[Arch_MEP_" . $type . "] Where [fileName] = '" . $name . "';";
    $fetchResult = sqlsrv_query($conn, $sql);
    $string = file_get_contents("../../assets/columnTable.json");
    $json = json_decode($string, true);
    while ($row = sqlsrv_fetch_array($fetchResult, SQLSRV_FETCH_NUMERIC)) {
        $table = $row;
    }
    foreach ($table as $key => $value) {
        if ($key != 0) {
            array_push($table_header, $json[0][$COLUMN_NAME[$key]]);
            array_push($table_value, $value);
        }
    }

    $array = array();
    $array["header"] = $table_header;
    $array["value"] = $table_value;
    echo json_encode($array);
}

sqlsrv_close($conn);