<?php
    include "connectSQL.php";
    session_start();
    $_SESSION['wellTBA'] = array();
  if (isset($_GET['table_name'])){
    $table_name = $_GET['table_name'];
    $method = $_GET['method'];
    $warning1 = $_GET['warning1'];
    $warning2 = $_GET['warning2'];
    $warning_Count = $_GET['warning_Count'];
    $phase = $_GET['phase'];

	$SIS_array = ['SIS-1','SIS-2-1','SIS-2-2','SIS-3','SIS-4','SIS-6','SIS-7'];
	$SID_array = ['SID-1','SID-2-1','SID-2-2','SID-3-1','SID-3-2','SID-4','SID-5-1','SID-5-2','SID-6','SID-7'];
    $OWFirstData = [-1.81, -1.59, -6.3, -3.67, -3.16, -1.78, -3.31, 0];
    $ELPwarning = [0, -4.6, -10, -15.3, -23.2, 0];
    $ELP_1warning = [0, -7.9, -13.3, 0, 0, 0];

    if($phase == 2){
        $SID_data = [1.85, 1.128, 1.128, 1.128, 1.698, 1.698, 1.698, 1.186, 1.186, 1.032];
        $SIS_data = [1.85, 1.128, 1.128, 1.128, 1.698, 1.186, 1.032];
    }else if($phase == 3){
        $SID_data = [2.39, 1.434, 1.434, 1.434, 2.304, 2.304, 2.304, 1.7, 1.7, 1.569];
        $SIS_data = [2.39, 1.434, 1.434, 1.434, 2.304, 1.7, 1.569];
        $ELPwarning1 = -4.6;
        $ELPwarning2 = -7.9;
    }else if($phase == 4){
        $SID_data = [2.89, 1.856, 1.856, 1.856, 2.968, 2.968, 2.968, 2.267, 2.267, 2.176];
        $SIS_data = [2.89, 1.856, 1.856, 1.856, 2.968, 2.267, 2.176];
        $ELPwarning1 = -10;
        $ELPwarning2 = -13.3;
    }else if($phase == 5){
        $SID_data = [3.36, 2.626, 2.626, 2.626, 4.531, 4.531, 4.531, 3.727, 3.727, 3.285];
        $SIS_data = [3.36, 2.626, 2.626, 2.626, 4.531, 3.727, 3.285];
        $ELPwarning1 = -15.3;
    }else if($phase == 6){
        $SID_data = [4.015, 3.832, 3.832, 3.832, 7.966, 7.966, 7.966, 5.049, 5.049, 5.208];
        $SIS_data = [4.015, 3.832, 3.832, 3.832, 7.966, 5.049, 5.208];
        $ELPwarning1 = -23.2;
    }else if($phase == 7){
        $SID_data = [4.918, 4.458, 4.458, 4.458, 8.909, 8.909, 8.909, 5.797, 5.797, 5.988];
        $SIS_data = [4.918, 4.458, 4.458, 4.458, 8.909, 5.797, 5.988];
    }
    
    $wellTBA = [];    
    $column_name = [];
    $normal_count = 0;
    $abnormal_count = 0;
    $i = 1;
	$j = 0;
    $end = true;
	
    /*$method = "init";
    $table_name = 'OWdata';
    $warning1 = -2;
    $warning2 = -0.00106;
    $warning_Count = 1;*/
    
    if($table_name == 'SISdata' || $table_name == 'SIDdata'){
		$i = 0;
		$data = [];
		if($table_name == 'SISdata')
			$column_name = $SIS_array;
		if($table_name == 'SIDdata')
			$column_name = $SID_array;
		foreach($column_name as $value){
			$sql = "SELECT TOP 1 * FROM  [C3].[dbo].[".$table_name."]  WHERE [e_name] = '".$value."' ORDER BY [m_date] DESC ";
			$fetchResult = sqlsrv_query($conn, $sql);
			$result = sqlsrv_fetch_array($fetchResult);
			array_push($data,$result);
			$j++;
		}		
		
	}else{
		$sql_Table = "SELECT name FROM sys.columns WHERE object_id = OBJECT_ID('[C3].[dbo].[".$table_name."]') ";
		$fetchResult_Table = sqlsrv_query($conn, $sql_Table);
		while($column_name_table = sqlsrv_fetch_array($fetchResult_Table)){
			array_push($column_name,$column_name_table[0]);        
		}
		$sql = "SELECT * FROM  [C3].[dbo].[".$table_name."]  ORDER BY [m_date] DESC";
		$fetchResult = sqlsrv_query($conn, $sql);
		$data = sqlsrv_fetch_array($fetchResult);
	}	

    while($end){ 
        $is_normal = true;        
        switch($method){
            case "init":
				if($table_name == "ELPdata"){
					if($column_name[$i] != "ELP_1" && strpos($column_name[$i],'_1')){
						if($ELP_1warning[$phase-2] == 0){
							$normal_count++;
						}else{
							if($data[$i] > $ELP_1warning[$phase-2]){
								$abnormal_count++;
								array_push($wellTBA,$column_name[$i]);
							}else{
								$normal_count++;
							}
						}
					}else{
						if($ELPwarning[$phase-2] == 0){
							$normal_count++;
						}else{
							if($data[$i] > $ELPwarning[$phase-2]){
								$abnormal_count++;
								array_push($wellTBA,$column_name[$i]);
							}else{
								$normal_count++;
							}
						}
					}					
				}else{
					if($warning_Count == 1){
						if($data[$i] > $warning1){
							$abnormal_count++;
							array_push($wellTBA,$column_name[$i]);
						}else{
							$normal_count++;
						}
					}else{
						if($table_name == "OWdata"){
							$warning1 = $OWFirstData[$i-1] + 2;
                            $warning2 = $OWFirstData[$i-1] - 2;
						}
						if($data[$i] > $warning1 || $data[$i] < $warning2){
							if($column_name[$i] != "OW_4A"){
								$abnormal_count++;
								array_push($wellTBA,$column_name[$i]);
							}
						}else{
							$normal_count++;
						}
					}    
				}          
                $i++;
                break;
            case "init2":
                /*if($warning_Count == 1){
                    if(($phase == 2 || $phase == 7) && $table_name == "ELPdata"){
                        $normal_count++;
                    }else if($table_name == "ELPdata"){
                        if($data[$i] > $ELPwarning1){
                            $is_normal = false;
                        }
                        if($phase == 3 || $phase == 4){
                            if($data[$i+1] > $ELPwarning2){
                                $is_normal = false;
                            }
                        }
                        if($is_normal){
                            $normal_count++;
                        }
                        else{
                            $abnormal_count++;
                            array_push($wellTBA,$column_name[$i]);
                        }
                    }else{
                        if($data[$i] > $warning1){
                            $is_normal = false;
                        }
                        if($data[$i+1] > $warning2){
                            $is_normal = false;
                        }
                        if($is_normal){
                            $normal_count++;
                        }
                        else{
                            $abnormal_count++;
                            array_push($wellTBA,$column_name[$i]);
                        }
                    }
                }else{*/
                    if($data[$i] > $warning1 || $data[$i] < $warning2){
                        $is_normal = false;
                    }if($data[$i+1] > $warning1 || $data[$i+1] < $warning2){
                        $is_normal = false;
                    }if($is_normal){
                        $normal_count++;
                    }else{
                        $abnormal_count++;
                        array_push($wellTBA,$column_name[$i]);
                    }
                //}                
                $i = $i + 2;
                break;
            case "init6":                
                if($warning_Count == 1){
                    for( $j = 0; $j < 6; $j++){
                        if($data[$i + $j] > $warning1){
                            $is_normal = false;
                        }
                    }
                    if($is_normal){
                        $normal_count++;
                    }else{
                        $abnormal_count++;
                        array_push($wellTBA,$column_name[$i]);
                    }
                }else{
                    for( $j = 0; $j < 6; $j++){
                        if($data[$i + $j] > $warning1 || $data[$i + $j] < $warning2){
                            $is_normal = false;
                        }
                    }
                    if($is_normal){
                        $normal_count++;
                    }else{
                        $abnormal_count++;
                        array_push($wellTBA,$column_name[$i]);
                    }
                }                
                $i = $i + 6;
                break;
            case "initSISSID":                
                if($data[$i][0] == $SID_array[$i]){
                    $warning1 = $SID_data[$i];
                }else if($data[$i][0] == $SIS_array[$i]){
                    $warning1 = $SIS_data[$i];
                }
				for($k = 2; $k < count($data[$i])/2; $k++){					
					if($data[$i][$k] > $warning1){
						$is_normal = false;
					}
				}				
				if($is_normal){
                       $normal_count++;
                }else{
                    $abnormal_count++;
                    array_push($wellTBA,$column_name[$i]);
                }			
                $i++;
                break;
        }
        
                
        
        if(empty($data[$i]))			
            $end = false;
		

    }    

   $array = array();
   $array['wellTBA'] = $wellTBA;
   $array['normal_count'] = $normal_count;
   $array['abnormal_count'] = $abnormal_count;
   echo json_encode($array);

    sqlsrv_close( $conn );
    }
?>