BIM-Monitor/script/php/getEquipmentName.php

<?php
if(isset($_GET["equipment"])){
    include "connectSQL.php";
    $equipment = $_GET["equipment"];
    //$equipment = "OW";
    $column_name = "";
    if($equipment == "SIS" || $equipment == "SID"){
        $sql = "SELECT DISTINCT [e_name] FROM [C3].[dbo].[".$equipment."data]";
    }else{
        $sql = "SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('[C3].[dbo].[".$equipment."data]') ";
        //$sql要改成BIMMonitor的資料
    }
    $fetchResult = sqlsrv_query($conn, $sql);
    while($row = sqlsrv_fetch_array($fetchResult)){
        if($row[0] != "m_date" && !str_contains($row[0], "(2~4)")){
            if($column_name == ""){
                $column_name = $column_name . $row[0];  
            }else{
                $column_name = $column_name . "," . $row[0];  
            }
        }
    }

    echo $column_name;   
    sqlsrv_close( $conn );
}
    
    
?>