BIM-Monitor/script/php/getChartData2.php

<?php
    include "connectSQL.php";

    $output_m_date = array();
    $output_m_value = array();
    $output_m_date_count = 0;
    $output_m_value_count = 0;
    //ELP-1A
    $outputA_m_date = array();
    $outputA_m_value = array();
    $outputA_m_date_count = 0;
    $outputA_m_value_count = 0;
    //ELP-1-1
    $output_1_1_m_date = array();
    $output_1_1_m_value = array();
    $output_1_1_m_date_count = 0;
    $output_1_1_m_value_count = 0;
    //SISSID
    $output_depth_SISSID = array();
    $output_m_date_SISSID = array();
    $output_m_value_SISSID = array();
    $output_m_date_SISSID_count = 0;
    $output_m_value_SISSID_count = 0;
    //TI2~4
    $output24_m_date = array();
    $output24_m_value = array();
    $output24_m_date_count = 0;
    $output24_m_value_count = 0;
    //B~F
    $outputB_m_date = array();
    $outputB_m_value = array();
    $outputB_m_date_count = 0;
    $outputB_m_value_count = 0;
    $outputC_m_date = array();
    $outputC_m_value = array();
    $outputC_m_date_count = 0;
    $outputC_m_value_count = 0;
    $outputD_m_date = array();
    $outputD_m_value = array();
    $outputD_m_date_count = 0;
    $outputD_m_value_count = 0;
    $outputE_m_date = array();
    $outputE_m_value = array();
    $outputE_m_date_count = 0;
    $outputE_m_value_count = 0;
    $outputF_m_date = array();
    $outputF_m_value = array();
    $outputF_m_date_count = 0;
    $outputF_m_value_count = 0;

    if(isset($_GET['q'])){
        $wellName = $_GET["q"];
        $wellNameA = str_replace("A","-1A",$wellName); 
        $sqlWellName = str_replace("-", "_", $wellName);
        $sqlWellNameA = str_replace("-", "_", $wellNameA);
        if(contains($wellName, "ELP") ||contains($wellName, "OW") || contains($wellName, "SM") || contains($wellName, "SB") || contains($wellName, "SBM") || contains($wellName, "VG") || contains($wellName, "HM")){
            if(contains($wellName, "OW")){
                $sqlOW = "SELECT * FROM [C3].[dbo].[OWdata]";
                $fetchResult = sqlsrv_query($conn, $sqlOW);
            }else if(contains($wellName, "SM")){
                $sqlSM = "SELECT * FROM [C3].[dbo].[SMdata]";
                $fetchResult = sqlsrv_query($conn, $sqlSM);
            }else if(contains($wellName, "SBM")){
                $sqlSBM = "SELECT * FROM [C3].[dbo].[SBMdata]";
                $fetchResult = sqlsrv_query($conn, $sqlSBM);
            }else if(contains($wellName, "SB")){
                $sqlSB = "SELECT * FROM [C3].[dbo].[SBdata]";
                $fetchResult = sqlsrv_query($conn, $sqlSB);
            }else if(contains($wellName, "VG")){
                $sqlVG = "SELECT * FROM [C3].[dbo].[VGdata]";
                $fetchResult = sqlsrv_query($conn, $sqlVG);
            }else if(contains($wellName, "HM")){
                $sqlHM = "SELECT * FROM [C3].[dbo].[HMdata]";
                $fetchResult = sqlsrv_query($conn, $sqlHM);
            }else if(contains($wellName, "ELP")){
                $sqlELP = "SELECT * FROM [C3].[dbo].[ELPdata]";
                $fetchResult = sqlsrv_query($conn, $sqlELP);
            }
            
            while($row = sqlsrv_fetch_array($fetchResult)){
                $output_m_date[$output_m_date_count] = $row["m_date"];
                $output_m_value[$output_m_value_count] = $row[$sqlWellName];
                $output_m_date_count++;
                $output_m_value_count++;
            }
        }else if(contains($wellName, "SID") || contains($wellName, "SIS")){

            $columnCount = 0;

            if(contains($wellName, "SID")){
                $sqlSID = "SELECT * FROM [C3].[dbo].[SIDdata] WHERE e_name = '".$wellName."'";
                $fetchResult = sqlsrv_query($conn, $sqlSID);
            }else if(contains($wellName, "SIS")){
                $sqlSIS = "SELECT * FROM [C3].[dbo].[SISdata] WHERE e_name = '".$wellName."'";
                $fetchResult = sqlsrv_query($conn, $sqlSIS);
            }
            
            while($row = sqlsrv_fetch_array($fetchResult)){

                $columnCount = count(array_filter($row))/2-1;
                $output_m_date_SISSID[$output_m_date_SISSID_count++] = $row["m_date"];
                $output_m_value_SISSID[$output_m_value_SISSID_count++] = valueSISSID($row, $columnCount);
                
            }

            $output_depth_SISSID = depthSISSID($columnCount);

        }else if(contains($wellName, "TI")){
            $sqlTI = "SELECT * FROM [C3].[dbo].[TIdata]";
            $fetchResult = sqlsrv_query($conn, $sqlTI);

            while($row = sqlsrv_fetch_array($fetchResult)){
                $output_m_date[$output_m_date_count] = $row["m_date"];
                $output_m_value[$output_m_value_count] = $row[$sqlWellName];
                $output_m_date_count++;
                $output_m_value_count++;

                $output24_m_date[$output_m_date_count] = $row["m_date"];
                $output24_m_value[$output_m_value_count] = $row[$sqlWellName."(2~4)"];
                $output24_m_date_count++;
                $output24_m_value_count++;
            }
        }else if(contains($wellName, "RS")){
            $sqlRS = "SELECT * FROM [C3].[dbo].[RSdata]";
            $fetchResult = sqlsrv_query($conn, $sqlRS);
            
            $sqlWellName = substr($sqlWellName, 0 , -2);

            while($row = sqlsrv_fetch_array($fetchResult)){

                $output_m_date[$output_m_date_count] = $row["m_date"];
                $output_m_value[$output_m_value_count] = $row[$sqlWellName."_A"];
                $output_m_date_count++;
                $output_m_value_count++;

                $outputB_m_date[$outputB_m_date_count] = $row["m_date"];
                $outputB_m_value[$outputB_m_value_count] = $row[$sqlWellName."_B"];
                $outputB_m_date_count++;
                $outputB_m_value_count++;

                $outputC_m_date[$outputC_m_date_count] = $row["m_date"];
                $outputC_m_value[$outputC_m_value_count] = $row[$sqlWellName."_C"];
                $outputC_m_date_count++;
                $outputC_m_value_count++;

                $outputD_m_date[$outputD_m_date_count] = $row["m_date"];
                $outputD_m_value[$outputD_m_value_count] = $row[$sqlWellName."_D"];
                $outputD_m_date_count++;
                $outputD_m_value_count++;

                $outputE_m_date[$outputE_m_date_count] = $row["m_date"];
                $outputE_m_value[$outputE_m_value_count] = $row[$sqlWellName."_E"];
                $outputE_m_date_count++;
                $outputE_m_value_count++;

                $outputF_m_date[$outputF_m_date_count] = $row["m_date"];
                $outputF_m_value[$outputF_m_value_count] = $row[$sqlWellName."_F"];
                $outputF_m_date_count++;
                $outputF_m_value_count++;

            }
        }

        if(contains($wellName, "ELP") || contains($wellName, "OW") || contains($wellName, "SM") || contains($wellName, "SB") || contains($wellName, "VG") || contains($wellName, "HM")){
            $wellName = str_replace("_", "-", $wellName);
            echo $wellName;
            echo "*";
            $i = 0;
            foreach($output_m_date as $value){
                echo $value;
                if(++$i != count($output_m_date)){
                    echo " ";
                }
            }
            echo "*";
            $j = 0;
            foreach($output_m_value as $value){
                echo $value;
                if(++$j != count($output_m_value)){
                    echo " ";
                }
            }
        }else if(contains($wellName, "SIS") || contains($wellName, "SID")){
            $i = 0;
            foreach ($output_m_date_SISSID as $date){
                echo $date;
                if(++$i != count($output_m_date_SISSID)){
                    echo " ";
                }
            }
            
            echo "*";
            $j = 0;
            foreach ($output_depth_SISSID as $depth){
                echo $depth;
                if(++$j != count($output_depth_SISSID)){
                    echo " ";
                }
            }
            echo "*";
            $k = 0;
            foreach ($output_m_value_SISSID as $value){
                foreach($value as $data){
                    echo $data;
                    if(++$k != count($output_m_value_SISSID)){
                        echo " ";
                    }
                }
                echo "//";
            }
            
        }else if(contains($wellName, "TI")){
            echo $wellName."(1~3)";
            echo "*";
            $i = 0;
            foreach($output_m_date as $value){
                echo $value;
                if(++$i != count($output_m_date)){
                    echo " ";
                }
            }
            echo "*";
            $j = 0;
            foreach($output_m_value as $value){
                echo $value;
                if(++$j != count($output_m_value)){
                    echo " ";
                }
            }
            echo "*";
            echo $wellName."(2~4)";
            echo "*";
            $i = 0;
            foreach($output24_m_date as $value){
                echo $value;
                if(++$i != count($output24_m_date)){
                    echo " ";
                }
            }
            echo "*";
            $j = 0;
            foreach($output24_m_value as $value){
                echo $value;
                if(++$j != count($output24_m_value)){
                    echo " ";
                }
            }
        }else if(contains($wellName, "RS")){
            $wellName = substr($wellName, 0 , -2);
            displayRS($wellName."-A", $output_m_date, $output_m_value);
            echo "*";
            displayRS($wellName."-B", $outputB_m_date, $outputB_m_value);
            echo "*";
            displayRS($wellName."-C", $outputC_m_date, $outputC_m_value);
            echo "*";
            displayRS($wellName."-D", $outputD_m_date, $outputD_m_value);
            echo "*";
            displayRS($wellName."-E", $outputE_m_date, $outputE_m_value);
            echo "*";
            displayRS($wellName."-F", $outputF_m_date, $outputF_m_value);

        }
        
        
    }

    function contains($str, $target)
    {
        if (stripos($str, $target) !== false){
            return true;
        }
        return false;
    }

    function depthSISSID($columnCount){
        $output_depth = array();
        for($i = 0; $i < $columnCount; $i++){
            if($i == 0){
                array_push($output_depth, $i);
            }else{
                array_push($output_depth, $i/2*(-1));
            }
        }
        return $output_depth;
    }

    function valueSISSID($row, $columnCount){
        $output = array();
        $str = "";
        for($i = 0; $i < $columnCount; $i++){
            $str = "depth_".($i);           
            $output[$i] = $row[$str];
        }
        return $output;
    }

    function displayRS($wellName, $output_date, $output_value){
        echo $wellName;
        echo "*";
        $i = 0;
        foreach($output_date as $value){
            echo $value;
            if(++$i != count($output_date)){
                echo " ";
            }
        }
        echo "*";
        $j = 0;
        foreach($output_value as $value){
            echo $value;
            if(++$j != count($output_value)){
                echo " ";
            }
        }
    }
    
    sqlsrv_close( $conn );
?>