<?php
if (!empty($_SESSION['site401']))
{
?>

<?php

if (!empty($_GET['direct']) && $_GET['direct']=='site301inf')
{
	delSearchSessionData();
}


//warunek na przekazywanie nazw obiektów (G54)
if (empty($_GET['dev']) && !empty($_GET['obj']))
{
    delSearchSessionData();
    $_GET['dev'] = sqlStringValue("select DRS_ID from seg_dev_resources,seg_wells where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and WLL_NAME='".$_GET['obj']."'", "DRS_ID");
    
    if ($_GET['dev']>0) $_GET['dev']=$_GET['dev'];
    else {
    	$tmp = explode('=', $_SERVER['REQUEST_URI']);
    	$lastVal = count($tmp)-1;
    	$_GET['dev'] = sqlStringValue("select DRS_ID from seg_dev_resources,seg_wells where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and WLL_NAME='".$tmp[$lastVal]."'", "DRS_ID");
    	unset($tmp);
    }
}

//załączaie wylączanie pompy
if (!empty($_GET['pa']) && $_GET['dev']>0 && $_POST['inEncrypted']==md5($_GET['dev']) && $_POST['subWellParamSave']==$lab_ButtonName_Next)
{
	$onOffDate = $_POST['inOnOffDate'].' '.$_POST['inOnOffTimeH'].':'.$_POST['inOnOffTimeM'].':00';
	
    if ($_GET['pa']=='on')
    {
    	//kasuje wcześniejsze wpisy (z datą późnijszą niż aktualnie wstawiona)
    	mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=507 and  DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE>='".$onOffDate."'");
    	mysql_query("DELETE FROM seg_wells_manual_work WHERE WMS_DRS_ID=".$_GET['dev']." and WMS_DATETIME>='".$onOffDate."'");
    	mysql_query("DELETE FROM seg_wells_manual_work_syndis WHERE SLA_DRS_ID=".$_GET['dev']." and SLA_DATETIME>='".$onOffDate."'");
    	// ===================================================================================
    	
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=507,DRD_VALUE='ON',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$onOffDate."'");
        mysql_query("INSERT INTO seg_wells_manual_work SET WMS_WLL_ID=".$_SESSION['well_details']['wellID'].",WMS_DRS_ID=".$_GET['dev'].",WMS_NAME='".$_SESSION['well_details']['wellName']."',WMS_WORK_STATUS='ON',WMS_DATETIME='".$onOffDate."'");
        
        // Dodaje do tabeli liczników - Łata dla syndis na liczenie czasów
        mysql_query("INSERT INTO seg_wells_manual_work_syndis SET SLA_WLL_ID=".$_SESSION['well_details']['wellID'].",SLA_DRS_ID=".$_GET['dev'].",SLA_NAME='".$_SESSION['well_details']['wellName']."',SLA_WORK_STATUS='ON',SLA_DATETIME='".$onOffDate."',SLA_AUDIT_CD=now()");
        mysql_query("INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$_GET['dev'].",RHD_DATE='".$onOffDate."',RHD_Q_VAL=getLastValue(200,".$_GET['dev']."),RHD_AUDIT_CD=now()");
        
        // dodaje wpis, czy aktualizować czasy pracy - 2018-01-06 (syndis_onoff_time)
        mysql_query("INSERT INTO softspm_rep.rep_002_is_set_new_onoff_signals SET ISN_STATUS_VAL='ON',ISN_DRS_ID=".$_GET['dev'].",ISN_DATE=now()");
        // czyści informcję w polu RHD_SPM_WT - w celu przeliczenia czasu i wody jeszcze raz - dla załącz/wyłącz wpisywanych wstecznie
        mysql_query("UPDATE rep_his_data_everyday SET RHD_SPM_WT=NULL WHERE RHD_DRS_ID=".$_GET['dev']." and RHD_DATE>='".$onOffDate."'");
        
    }
    elseif ($_GET['pa']=='off')
    {
    	//kasuje wcześniejsze wpisy (z datą późnijszą niż aktualnie wstawiona)
    	mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=507 and  DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE>='".$onOffDate."'");
    	mysql_query("DELETE FROM seg_wells_manual_work WHERE WMS_DRS_ID=".$_GET['dev']." and WMS_DATETIME>='".$onOffDate."'");
    	mysql_query("DELETE FROM seg_wells_manual_work_syndis WHERE SLA_DRS_ID=".$_GET['dev']." and SLA_DATETIME>='".$onOffDate."'");
    	// ===================================================================================
    	
    	mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='".$_POST['inOnOffReason']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$onOffDate."'");
        mysql_query("INSERT INTO seg_wells_manual_work SET WMS_WLL_ID=".$_SESSION['well_details']['wellID'].",WMS_DRS_ID=".$_GET['dev'].",WMS_NAME='".$_SESSION['well_details']['wellName']."',WMS_WORK_STATUS='OFF',WMS_DATETIME='".$onOffDate."'");
        
        // Dodaje do tabeli liczników - Łata dla syndis na liczenie czasów
        mysql_query("INSERT INTO seg_wells_manual_work_syndis SET SLA_WLL_ID=".$_SESSION['well_details']['wellID'].",SLA_DRS_ID=".$_GET['dev'].",SLA_NAME='".$_SESSION['well_details']['wellName']."',SLA_WORK_STATUS='OFF',SLA_DATETIME='".$onOffDate."',SLA_AUDIT_CD=now()");

        // dodaje wpis, czy aktualizować czasy pracy - 2018-01-06 (syndis_onoff_time)
        mysql_query("INSERT INTO softspm_rep.rep_002_is_set_new_onoff_signals SET ISN_STATUS_VAL='OFF',ISN_DRS_ID=".$_GET['dev'].",ISN_DATE=now()");
        // czyści informcję w polu RHD_SPM_WT - w celu przeliczenia czasu i wody jeszcze raz - dla załącz/wyłącz wpisywanych wstecznie
        mysql_query("UPDATE rep_his_data_everyday SET RHD_SPM_WT=NULL WHERE RHD_DRS_ID=".$_GET['dev']." and RHD_DATE>='".$onOffDate."'");
        
    }
    elseif ($_GET['pa']=='reson')
    {
    	$drdID = sqlValue("select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE=(select max(DRD_AUDIT_DATE) from  seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_GET['dev'].")");
    	mysql_query("UPDATE seg_dev_resources_det SET DRD_DESCRIPTION='".$_POST['inOnOffReason']."', DRD_AUDIT_USR='".$_SESSION['user']."'  WHERE DRD_ID=".$drdID);
    }
}


    // kasuje zmianne sesyjne dla historii ocen
    unset($_SESSION['site401mhis_working_params']);
    unset($_SESSION['site401mhis_inDate']);
    unset($_SESSION['site401mhis_sel_data']);

   
require_once('./polynomial/PolynomialRegression.php' );


unset($_SESSION['well_details']);
//wpisuje do tablicy podstawowe informacje o studni
$wynik = mysql_query("select DRS_ID,WLL_ID,WLL_NAME,WLL_CAT_DIC_ID,RWL_PUP_DRS_ID,RWL_ENG_DRS_ID,round(getLastValue(235,DRS_ID)/1000,3) DR, getLastValue(240,DRS_ID) LPM from seg_wells left join seg_dev_resources on DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 left join seg_well_pump_eng_rel on RWL_WLL_ID=WLL_ID where DRS_ID=".$_GET['dev']);
if($wynik)while ($r = mysql_fetch_array($wynik))
{
	 
	unset($pupTmpArray);
	if ($r["RWL_PUP_DRS_ID"]>0)
		$pupTmpArray = sqlGetResAsArray("select PUP_ID,PUP_NAME,DRS_SN_NUMBER,PUP_Q_N from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID and DRS_DEV_TYPE=10 where DRS_ID=".$r["RWL_PUP_DRS_ID"]);
	unset($engTmpArray);
	if ($r["RWL_ENG_DRS_ID"]>0)
		$engTmpArray = sqlGetResAsArray("select ENG_ID,ENG_NAME,ENG_ELECTRICITY,ENG_VOLTAGE,ENG_COS_FI,DRS_SN_NUMBER from seg_dev_resources left join seg_engines on ENG_ID=DRS_DEV_ID and DRS_DEV_TYPE=11 where DRS_ID=".$r["RWL_ENG_DRS_ID"]);
	unset($workStatusArray);
	//$workStatusArray = sqlGetResAsArray("select DRD_VALUE,DRD_DESCRIPTION,DRD_AUDIT_DATE,(select DIC_POL_LANG from sys_dictionaries where DIC_ID=DRD_DESCRIPTION limit 1) DRD_DESC from viw_pump_working_status where DRD_AUDIT_DATE=(select max(DRD_AUDIT_DATE) from viw_pump_working_status where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_GET['dev'].") and DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_GET['dev']." limit 1");
	$workStatusArray = sqlGetResAsArray("select * from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_GET['dev'].")");	
	//$tstID = sqlValue("select TST_ID from tst_tests where TST_PUP_ID=".$r["PUP_ID"]." and TST_PUP_SN_NO='".$r["WLE_PUMP_NO"]."' and TST_ENG_ID=".$r["ENG_ID"]." and TST_ENG_SN_NO='".$r["WLE_ENG_NO"]."'");
	if ($r["RWL_PUP_DRS_ID"]>0 && $r["RWL_ENG_DRS_ID"]>0)
	{
		$tstID = sqlValue("select max(TST_ID) TST_ID from tst_tests where TST_PUP_ID=".$pupTmpArray[0]['PUP_ID']." and TST_PUP_SN_NO='".$pupTmpArray[0]['DRS_SN_NUMBER']."' and TST_ENG_SN_NO='".$engTmpArray[0]['DRS_SN_NUMBER']."'");
		if (empty($tstID)) $tstID = sqlValue("select max(TST_ID) TST_ID from tst_tests where TST_PUP_ID=".$pupTmpArray[0]['PUP_ID']." and TST_PUP_SN_NO='".$pupTmpArray[0]['DRS_SN_NUMBER']."'");
	}

	$_SESSION['well_details']=array(
			'devID'     => $r["DRS_ID"],
			'wellID'    => $r["WLL_ID"],
			'wellName'  => $r["WLL_NAME"],
			'wellTypeID'=> $r["WLL_CAT_DIC_ID"],
			'pumpID'    => $pupTmpArray[0]['PUP_ID'],
			'pumpName'  => $pupTmpArray[0]['PUP_NAME'],
			'pumpSN'    => $pupTmpArray[0]['DRS_SN_NUMBER'],
			'QnVal'     => $pupTmpArray[0]['PUP_Q_N'],
			'engID'     => $engTmpArray[0]['ENG_ID'],
			'engName'   => $engTmpArray[0]['ENG_NAME'],
			'eng_I'     => $engTmpArray[0]['ENG_ELECTRICITY'],
			'eng_U'   	=> $engTmpArray[0]['ENG_VOLTAGE'],
			'eng_CF'   	=> $engTmpArray[0]['ENG_COS_FI'],
			'engSN'     => $engTmpArray[0]['DRS_SN_NUMBER'],
			'LpVal'     => $r["LPM"],
			'DrVal'     => $r["DR"],
			'testID'    => $tstID,
			'onOff'		=> $workStatusArray[0]['DRD_VALUE']
	);
	
}
unset($pupTmpArray);
unset($engTmpArray);


    //2016-09-10
    // pobiera informacje do tablicy o wiarygodności danych z SYNDIS
    unset($qualDataArray);
    if ($_SESSION['well_details']['wellTypeID']!=20)
    {
    	$qualDataArray = sqlGetResAsArray("select * from rep_soap_syndis_quality_data where SQD_DRS_ID=".$_GET['dev']);
    	$getLastDyndisData = $qualDataArray[0]['SQD_AUDIT_CD'];
    }
    	
    if ($_SESSION['well_details']['wellTypeID']==18)
    	$imgSPM="SPM_BASE_polish.png";
    elseif ($_SESSION['well_details']['wellTypeID']==19)
    	$imgSPM="SPM_OPT_polish.png";
    else
    	$imgSPM="SPM_FULL_polish.png";
    	 
    	
// jeśli mamy zabudowany agregat i jest próba dla niego
if ($_SESSION['well_details']['testID']>0)
{
	
	//zakresy dla wykresów
	//if (empty($_SESSION['site401_scope']))
	{
		$wynik = mysql_query("select PEP_X_PARAM from seg_pump_eng_param where PEP_TYPE='H' and PEP_PUP_ID=".$_SESSION['well_details']['pumpID']." order by PEP_X_PARAM");
		if($wynik)while ($r = mysql_fetch_array($wynik))
		{
			$_SESSION['site401_scope'][] = (float) $r["PEP_X_PARAM"]/60;
			$dataP[] = (float) $r["PEP_X_PARAM"];
		}
	
	}	
	
	
// punkty pomiarowe dla Hp, Eta, Pe ze stacji prób
    $wynik = mysql_query("select TSD_VAL_04/60 TSD_VAL_04,TSD_VAL_08,TSD_VAL_14,TSD_VAL_18 from tst_tests left join tst_test_details on TSD_TST_ID=TST_ID where TST_ID=".$tstID." order by TSD_MSR_STEP");
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
    	$testArray[] = array(
    			'q'	=>	(float) $r["TSD_VAL_04"],
    			'h'	=>	(float) $r["TSD_VAL_08"],
    			'p'	=>	(float) $r["TSD_VAL_14"],
    			'n'	=>	(float) $r["TSD_VAL_18"]
    	);
    
	    $dataH[] = array(
	    		$r["TSD_VAL_04"]*60,
	    		$r["TSD_VAL_08"]
	    );
	    	
	    $dataEta[] = array(
	    		(float) $r["TSD_VAL_04"]*60,
	    		(float) $r["TSD_VAL_18"]
	    );
    
   }
    
   //$_SESSION['site401_lift_xy']
   //$_SESSION['site401_eta_xy']
   //$_SESSION['site401_minmax_params']
    unset($maxPiontOfTest);   
   $maxPiontOfTest =sqlGetResAsArray("select max(TSD_VAL_04)/60 X_MAX, max(TSD_VAL_08) Y_MAX from tst_tests left join tst_test_details on TSD_TST_ID=TST_ID where TST_ID=".$_SESSION['well_details']['testID']);

   
}   
    
?>

    <?php
    include("./pChart/pData.class.php");
    include("./pChart/pDraw.class.php");
    include("./pChart/pImage.class.php");
    include("./pChart/pScatter.class.php");


    $wynik = mysql_query("select RHD_Q_VAL,RHD_HD_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_PP_VAL,RHD_HH_VAL,RHD_PE_VAL,RHD_DGN_VAL,RHD_DATE from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_DRS_ID=".$_SESSION['well_details']['devID'].")");
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
    	$qParam =  $r["RHD_Q_VAL"];
    	$P1param = $r["RHD_P1_VAL"];
    	$P2param = $r["RHD_P2_VAL"];
    	$PEparam = $r["RHD_PE_VAL"];
    	$PPparam = $r["RHD_PP_VAL"];
    	$HHparam = $r["RHD_HH_VAL"];
    	$resHD = $r["RHD_HD_VAL"];
    	$isDiagOK = $r["RHD_DGN_VAL"];
    	$resWorkStatus = $r["RHD_DATE"];
    
    	if (empty($qualDataArray)) $getLastDyndisData = $r["RHD_DATE"];
    }

    
    // =============================================================== //
    $Evaluation4_q = wellEvaluation4_q($_SESSION['well_details']['QnVal'], $qParam);
    // =============================================================== //
    //$resHP = (setPumpHparameterForQ($_SESSION['well_details']['pumpID'],$qParam)-($PPparam-$HHparam))/($PPparam-$HHparam);
    //$resHP = (getPolynomialValue($_SESSION['site401_lift_xy'],$qParam/60)-($PPparam-$HHparam))/($PPparam-$HHparam);
    
   
    //$Evaluation4_HfQ = wellEvaluation4_HfQ($resHP,$PPparam);
    $HPparam = (float) ($PPparam - $HHparam);
    if ($_SESSION['well_details']['testID']>0)
    	$HPSparam = (float) getPolynomialHp_second($testArray,$qParam/60);
   
    $Evaluation4_HfQ = wellEvaluation4_HfQ_new($HPSparam,$PPparam,$HHparam);
    
    // =============================================================== //
    $Evaluation4_Throt = wellEvaluation4_Throt($resHD,$P1param,$P2param);
    // =============================================================== //
    $Evaluation4_LineLoss = wellEvaluation4_LineLoss($P1param,$PPparam,$_SESSION['well_details']['LpVal'],$_SESSION['well_details']['DrVal']);
    // =============================================================== //
    //$qRZ = $qParam;
    
    //$fileName0="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_chart_401inf_01.png";
    //if (file_exists( $fileName0)) unlink($fileName0);

    // =============================================================== //
    if (empty($PEparam)) $PEparam=1;
    $resETA = ($qParam*($resHD+$P2param))/(367*$PEparam);
    $RedYellowParam = setRedYellowLimes($_SESSION['well_details']['QnVal']);
    $YellowGreenParam = setYellowGreenLimes($_SESSION['well_details']['QnVal']);
    // =============================================================== //


    // Jeśli mamy odchyłke CH na czerwono, wtedy obrazek jest szary
    // =============================================================== //
    /*
    if ($greyChart==1 || $_SESSION['well_details']['wellTypeID']==20)
        pumpImageGreyBell($fileName0);
    else pumpImageStatus($fileName0, $RedYellowParam, $YellowGreenParam, $resETA);
    */
    // =============================================================== //

    // nowe podejście
    $fileName0=createChartFileNamePng("site401mark_01");
    
    if ($greyChart==1 || $_SESSION['well_details']['wellTypeID']==20)
    	pumpImageEnergyGreyBell($fileName0);
    else pumpImageEnergy($fileName0, $RedYellowParam, $YellowGreenParam, $resETA);
    
    
    // nowe podejście
    $fileName1_new=createChartFileNamePng("site401mark_02");
    $fileName2_new=createChartFileNamePng("site401mark_03");
    
    if (file_exists( $fileName1_new)) unlink($fileName1_new);
    if (file_exists( $fileName2_new)) unlink($fileName2_new);
    
    //podnoszenie - wykres
    // =======================================================================================//
    if ($_SESSION['well_details']['testID']>0)
    {
    	include("./polynomial/hpCharts.php");
    	createHpChart($dataP, $dataH, $qParam, $fileName1_new, 470, 330, 8, 10, 1, $Evaluation4_HfQ['point_value']);
    
    //sprawność - wykres
    // =======================================================================================//
    	include("./polynomial/etaCharts.php");
    	createEtaAssesChart($dataP, $dataEta, $qParam, $fileName2_new, 470, 330, 8, 10, 1);
    }    
    
    
?>

<?php
    //tworzy nazwę pliku rysunku jaki ma podstawić w zalezności od stanu pompy (Throt i Loss)
    if (strlen($Evaluation4_Throt['image'])>0 && strlen($Evaluation4_LineLoss['image'])>0 && !strstr($imgSPM,"SEGAP"))
        $imgSPM = "./images/".$Evaluation4_Throt['image']."".$Evaluation4_LineLoss['image']."_".$imgSPM;
    else $imgSPM = "./images/".$imgSPM;

    $fileName="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_site401inf.png";
    if (file_exists($fileName)) unlink($fileName);
    $imageSPM=imagecreatefrompng($imgSPM);
    $image=imagecreatetruecolor(imagesx($imageSPM),imagesy($imageSPM));
    imagecopy($image,$imageSPM,0,0,0,0,imagesx($imageSPM),imagesy($imageSPM));
    $color=imagecolorallocate($image,255,255,255);
    imagefill($image,0,0,$color);
    $font = './fonts/verdana.ttf';

    // sprawdza stan diagnostyki i podstawia odpowiedni obrazek
    //$isDiagOK = getLastValueFromDevResourceDetail('WELL_HIDDEN_PARAMETERS','DGN',$var_DRSid);
    if ($isDiagOK==1) $imgToDiag = imagecreatefrompng("./images/diag_warning.png");
    elseif ($isDiagOK==2) $imgToDiag = imagecreatefrompng("./images/diag_error.png");
    else $imgToDiag = imagecreatefrompng("./images/diag_ok.png");
    //diag_warning
    
    
    if ($_SESSION['well_details']['wellTypeID']==18)
    {
        imagecopy($image,$imgToDiag,105,450,0,0,13,13);
        imagettftext($image, 10, 0, 75, 635, imagecolorallocate($image, 0, 0, 255), $font, "Data odpytania SYNDIS: ".$getLastDyndisData);
    }
    elseif ($_SESSION['well_details']['wellTypeID']==19)
    {
        imagecopy($image,$imgToDiag,81,450,0,0,13,13);
        imagettftext($image, 10, 0, 75, 635, imagecolorallocate($image, 0, 0, 255), $font, "Data odpytania SYNDIS: ".$getLastDyndisData);
    }
    imagepng($image,$fileName);
    
    
    // Jeśli mamy typ "SPM - inne"
    if ($_SESSION['well_details']['wellTypeID']==20)
    {
    	unset($Evaluation4_HfQ);
    	unset($Evaluation4_Throt);
    	unset($Evaluation4_LineLoss);
    	//pumpImageGreyBell($fileName0);
    }
    
?>


<?php 
if ($_SESSION['well_details']['testID']>0)
{
// =========================================================================================================================================
	

$spacja = "&nbsp;&nbsp;&nbsp;&nbsp;"; unset($algSPM);
//analiza, czy wszystkie wartości z ostatniego pomiaru z SYNDIS są prawidłowe i wiarygodne:
// =========================================================================================================================================
// analiza hydrauliczna
// =========================================================================================================================================
$isInfoWATER = false;
if (!empty($qualDataArray) && (
		$qualDataArray[0]['SQD_FLG_Q']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_P1']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_P2']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_PP']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_HH']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_HD']!='CORRECT'
		
		|| $qualDataArray[0]['SQD_VAL_Q']<=0
		|| $qualDataArray[0]['SQD_VAL_PP']<=0
		|| $qualDataArray[0]['SQD_VAL_HH']<=0
		|| $qualDataArray[0]['SQD_VAL_HD']<=0
	))
{
	$isInfoWATER = true;
	$infoWATER_text = "";
	
	if ($qualDataArray[0]['SQD_FLG_Q']!='CORRECT' || $qualDataArray[0]['SQD_VAL_Q']<=0)
		$infoWATER_text .="<br/> - Wydajność Q=".round($qualDataArray[0]['SQD_VAL_Q']/60,3)." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_Q']."]."; 
	if ($qualDataArray[0]['SQD_FLG_P1']!='CORRECT')
		$infoWATER_text .="<br/> - Ciśnienie p1=".$qualDataArray[0]['SQD_VAL_P1']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_P1']."].";
	if ($qualDataArray[0]['SQD_FLG_P2']!='CORRECT')
		$infoWATER_text .="<br/> - Ciśnienie p2=".$qualDataArray[0]['SQD_VAL_P2']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_P2']."].";		
	if ($qualDataArray[0]['SQD_FLG_PP']!='CORRECT' || $qualDataArray[0]['SQD_VAL_PP']<=0)
		$infoWATER_text .="<br/> - Ciśnienie Pp=".$qualDataArray[0]['SQD_VAL_PP']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_PP']."].";
	if ($qualDataArray[0]['SQD_FLG_HH']!='CORRECT' || $qualDataArray[0]['SQD_VAL_HH']<=0)
		$infoWATER_text .="<br/> - Wysokość Hh=".$qualDataArray[0]['SQD_VAL_HH']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_HH']."].";		
	if ($qualDataArray[0]['SQD_FLG_HD']!='CORRECT' || $qualDataArray[0]['SQD_VAL_HD']<=0)
		$infoWATER_text .="<br/> - Zwierciadło dynamiczne Hd=".$qualDataArray[0]['SQD_VAL_HD']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_HD']."].";	
}
// =========================================================================================================================================
// analiza elektryczna
// =========================================================================================================================================
$isInfoENERGETIC = false;
if (!empty($qualDataArray) && (
		$qualDataArray[0]['SQD_FLG_I']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_U']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_CF']!='CORRECT'
		|| $qualDataArray[0]['SQD_FLG_PE']!='CORRECT'

		|| $qualDataArray[0]['SQD_VAL_I']<=0
		|| $qualDataArray[0]['SQD_VAL_U']<=0
		|| $qualDataArray[0]['SQD_VAL_CF']<=0
		|| $qualDataArray[0]['SQD_VAL_CF']>=1
		|| $qualDataArray[0]['SQD_VAL_PE']<=0
		
		))
{
	$isInfoENERGETIC = true;
	$infoENERGETIC_text = "";

	if ($qualDataArray[0]['SQD_FLG_I']!='CORRECT' || $qualDataArray[0]['SQD_VAL_I']<=0)
		$infoENERGETIC_text .="<br/> - Pobór prądu I=".$qualDataArray[0]['SQD_VAL_I']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_I']."].";
	if ($qualDataArray[0]['SQD_FLG_U']!='CORRECT' || $qualDataArray[0]['SQD_VAL_U']<=0)
		$infoENERGETIC_text .="<br/> - Napięcie zasilania U=".$qualDataArray[0]['SQD_VAL_U']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_U']."]";	
	if ($qualDataArray[0]['SQD_FLG_CF']!='CORRECT' || $qualDataArray[0]['SQD_VAL_CF']<=0 || $qualDataArray[0]['SQD_VAL_CF']>=1)
		$infoENERGETIC_text .="<br/> - cos(φ)=".$qualDataArray[0]['SQD_VAL_CF']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_CF']."]";		
	if ($qualDataArray[0]['SQD_FLG_PE']!='CORRECT' || $qualDataArray[0]['SQD_VAL_PE']<=0)
		$infoENERGETIC_text .="<br/> - Moc czynna Pe=".$qualDataArray[0]['SQD_VAL_PE']." ".$spacja."[SYNDIS=".$qualDataArray[0]['SQD_FLG_PE']."]";		
}
// =========================================================================================================================================
// =========================================================================================================================================
/*
// jeśli analiza jakości i poprawności danych przeszła poprawnie sprawdza algorytmem SoftSPM
if (!empty($qualDataArray) && !$isInfoWATER && !$isInfoENERGETIC)
{
	// =====================================================================================================================================
	// analiza hydrauliczna
	// =====================================================================================================================================
	$test_Hp = (float) $qualDataArray[0]['SQD_VAL_PP'] - $qualDataArray[0]['SQD_VAL_HH'];
	$test_Hps = (float) getPolynomialHp($testArray,($qualDataArray[0]['SQD_VAL_Q']/60)); //wysokość ze stacji
	
	
	if ( 
			//($test_Hp < (0.8*$test_Hps) || $test_Hp > (1.08*$test_Hps))
			$test_Hp > (1.08*$test_Hps)
			|| (($qualDataArray[0]['SQD_VAL_P2']-1.5)>$qualDataArray[0]['SQD_VAL_P1'])
			
	    )
	{
		$isInfoWATER = true;
		$infoWATER_text = "";
		$algSPM = "według algorytmu SoftSPM";
		
		
		//if ($test_Hp < (0.8*$test_Hps) || $test_Hp > (1.08*$test_Hps))
		//if ($qualDataArray[0]['SQD_VAL_P2']>$qualDataArray[0]['SQD_VAL_P1'])
		if (($qualDataArray[0]['SQD_VAL_P2']-1.5)>$qualDataArray[0]['SQD_VAL_P1'])
			$infoWATER_text .="<br/> - Ciśnienie P2>P1 ".$spacja."[SYNDIS].";
		if ($test_Hp > (1.08*$test_Hps))
		{
			$infoWATER_text .="<br/> - Głębokość zabudowy pompy Lp=".$_SESSION['well_details']['LpVal']." ".$spacja."[SoftSPM].";
			$infoWATER_text .="<br/> - Ciśnienie Pp=".$qualDataArray[0]['SQD_VAL_PP']." [SYNDIS].";
			$infoWATER_text .="<br/> - Zwierciadło dynamiczne Hd=".$qualDataArray[0]['SQD_VAL_HD']." ".$spacja."[SYNDIS].";
		}
		
		
	}
	// =====================================================================================================================================
	
	
	// =====================================================================================================================================
	// analiza elektryczna
	// =====================================================================================================================================
	$test_Pes = (float) getPolynomialPe_second($testArray,($qualDataArray[0]['SQD_VAL_Q']/60)); //moc ze stacji	
	
	if (
			$qualDataArray[0]['SQD_VAL_PE'] < (0.83*$test_Pes) || $qualDataArray[0]['SQD_VAL_PE'] > (1.25*$test_Pes)
			//|| ((0.92*$_SESSION['well_details']['eng_CF'])>$qualDataArray[0]['SQD_VAL_CF'] || $qualDataArray[0]['SQD_VAL_CF']>(1.07*$_SESSION['well_details']['eng_CF']))
			//|| ((0.93*$_SESSION['well_details']['eng_U']) > $qualDataArray[0]['SQD_VAL_U'] || $qualDataArray[0]['SQD_VAL_U']>(1.08*$_SESSION['well_details']['eng_U']))
			//|| ((0.85*$_SESSION['well_details']['eng_I']) > $qualDataArray[0]['SQD_VAL_I'] || $qualDataArray[0]['SQD_VAL_I']>(1.15*$_SESSION['well_details']['eng_I']))
		)
	{
		$isInfoENERGETIC = true;
		$infoENERGETIC_text = "";
		$algSPM = "według algorytmu SoftSPM";

		if ($qualDataArray[0]['SQD_VAL_PE'] < (0.83*$test_Pes) || $qualDataArray[0]['SQD_VAL_PE'] > (1.25*$test_Pes))
			$infoENERGETIC_text .="<br/> - Moc czynna Pe=".$qualDataArray[0]['SQD_VAL_PE']." ".$spacja."[SYNDIS]";
//		if ((0.92*$_SESSION['well_details']['eng_CF'])>$qualDataArray[0]['SQD_VAL_CF'] || $qualDataArray[0]['SQD_VAL_CF']>(1.07*$_SESSION['well_details']['eng_CF']))
//			$infoENERGETIC_text .="<br/> - cos(φ)=".$qualDataArray[0]['SQD_VAL_CF']." ".$spacja."[SYNDIS]";
//		if ((0.93*$_SESSION['well_details']['eng_U']) > $qualDataArray[0]['SQD_VAL_U'] || $qualDataArray[0]['SQD_VAL_U']>(1.08*$_SESSION['well_details']['eng_U']))
//			$infoENERGETIC_text .="<br/> - Napięcie zasilania U=".$qualDataArray[0]['SQD_VAL_U']." ".$spacja."[SYNDIS]";
//		if ((0.85*$_SESSION['well_details']['eng_I']) > $qualDataArray[0]['SQD_VAL_I'] || $qualDataArray[0]['SQD_VAL_I']>(1.15*$_SESSION['well_details']['eng_I']))
//			$infoENERGETIC_text .="<br/> - Pobór prądu I=".$qualDataArray[0]['SQD_VAL_I']." ".$spacja."[SYNDIS]";
	}
	// =====================================================================================================================================
}
// =========================================================================================================================================
*/

if ($isInfoWATER)
	echo "<div class='infoWATER'>Parametry hydrauliczne lub techniczne wymagające analizy ".$algSPM.":".$infoWATER_text."</div>";

if ($isInfoENERGETIC)
	echo "<div class='infoENERGETIC'>Parametry elektryczne wymagające analizy ".$algSPM.":".$infoENERGETIC_text."</div>";

if ($isInfoWATER || $isInfoENERGETIC)
	echo "<div class='actionERROR'>Brak oceny!</div>";
	
	
// - wyłączone na serwerze backupowym
/*
if ($qualDataArray[0]['SQD_VAL_ONOFF']==0 || $isInfoWATER || $isInfoENERGETIC)
{
	if (file_exists( $fileName0)) unlink($fileName0);
	pumpImageEnergyGreyBell($fileName0);
}
*/


// =========================================================================================================================================
}
?>


<?php
// pobieranie aktualnych danych
if ($_GET['data']=='refresh')
{

    $refreshTime=15;
    echo"<meta http-equiv='refresh' content='".$refreshTime.";url=./?pg=site401mark&dev=".$_GET['dev']."'>";
    ?>
    <div class="tag100">
        <div class="head_tag">Pobór aktualnych danych dla <?php echo $_SESSION['well_details']['wellName']; ?> – proszę czekać.</div>
        <div class="tag_center"></br>
            <progress id="progressBar" value="0" max="100"></progress>
            <span id="status"></span>
            <h1 id="finalMessage"></h1>
            <script type="text/javascript" language="javascript">
                function progressBarSim(al) {
                    var bar = document.getElementById('progressBar');
                    var status = document.getElementById('status');
                    status.innerHTML = al+"%";
                    bar.value = al;
                    al++;
                    var sim = setTimeout("progressBarSim("+al+")",<?php echo $refreshTime*10; ?>  );
                    if(al == 100){
                        status.innerHTML = "100%";
                        bar.value = 100;
                        clearTimeout(sim);
                        //var finalMessage = document.getElementById('finalMessage');
                        //finalMessage.innerHTML = "Process is complete";
                    }
                }
                var amountLoaded = 0;
                progressBarSim(amountLoaded);
            </script></br>
        </div>
    </div>
    
	<script src="./bootstrap.min.js"></script>
	<script>

	
    $(window).load(function() {
        // Animate loader off screen
        //$('#preloader').hide();
        //$('#loader').hide();
    	$.post( "./ajax_getdata4well.php", { post_action: "ajax", done: "insert", well_name: "<?php echo $_SESSION['well_details']['wellName'];?>"}).done(function(data) 
    	    {
				
    	    }
	    );
    });

    </script>    
    
    
    <?php
}


if ($workStatusArray[0]['DRD_VALUE']=="ON")
{
	$imgONOFF_g = "./images/green_ONOFF_ON.png";
	$imgONOFF_r = "./images/red_ONOFF.png";
	$stringONOFF = "Stan pracy - Załączona";

	if (!empty($_SESSION['site401_well_onoff']) && $_SESSION['well_details']['wellTypeID']==20)
		$btmAcction = '
                        <img style="padding: 9px;" src="./images/green_ONOFF_ON.png">
                        <a href="./?pg=site401Eonf&dev='.$_SESSION['well_details']['devID'].'&pa=off"><img style="padding: 9px;" src="./images/red_ONOFF.png" title="Wyłącz pompe"></a>
                      ';
	else
		$btmAcction = '
                    <img style="padding: 9px;" src="./images/green_ONOFF_ON.png">
                    <img style="padding: 9px;" src="./images/red_ONOFF.png">
                  ';
}
else
{
	$imgONOFF_g = "./images/green_ONOFF.png";
	$imgONOFF_r = "./images/red_ONOFF_OFF.png";
	$stringONOFF = "Stan pracy - Wyłączona";

	if (!empty($_SESSION['site401_well_onoff']) && $_SESSION['well_details']['wellTypeID']==20)
		$btmAcction = '
                        <a href="./?pg=site401Eonf&dev='.$_SESSION['well_details']['devID'].'&pa=on"><img style="padding: 9px;" src="./images/green_ONOFF.png" title="Załącz pompe"></a>
                        <img style="padding: 9px;" src="./images/red_ONOFF_OFF.png">
                      ';
	else
		$btmAcction = '
                        <img style="padding: 9px;" src="./images/green_ONOFF.png">
                        <img style="padding: 9px;" src="./images/red_ONOFF_OFF.png">
                      ';
}


?>


    <div class="tag50_left">

        <div class="head_tag">Oceny pracy układu pompowego</div>
        <div class="tag">
            <TABLE class="desc_val">
                <TR>
                    <TD class="desc"><?php echo $lab_Field_site401_005; ?></TD>
                    <TD class="<?php echo $Evaluation4_q['grid_style']; ?>"><?php echo $Evaluation4_q['grid_text']; ?></TD>
                </TR>
                <TR>
                    <TD class="desc"><?php echo $lab_Field_site401_009; ?></TD>
                    <TD class="<?php echo $Evaluation4_HfQ['grid_style']; ?>"><?php echo $Evaluation4_HfQ['grid_text']; ?></TD>
                </TR>
                <TR>
                    <TD class="desc"><?php echo $lab_Field_site401_012; ?></TD>
                    <TD class="<?php echo $Evaluation4_Throt['grid_style']; ?>"><?php echo $Evaluation4_Throt['grid_text']; ?></TD>
                </TR>
                <TR>
                    <TD class="desc"><?php echo $lab_Field_site401_015; ?></TD>
                    <TD class="<?php echo $Evaluation4_LineLoss['grid_style']; ?>"><?php echo $Evaluation4_LineLoss['grid_text']; ?></TD>
                </TR>
            </table>
        </div>

        <div class="head_tag"><?php echo $lab_Tag_site301_004." - ".$_SESSION['well_details']['wellName'];?></div>
        <div class="tag_center">
            <a href="?pg=site401inf&dev=<?php echo $_GET['dev']?>"><img SRC="<?php echo $fileName; ?>" border="0"></a>
        </div>

	    <div class="head_tag"><?php echo $stringONOFF ;?> [<?php echo $workStatusArray[0]['DRD_AUDIT_DATE'];?>]</div>
	    <div class="tag_center">
	        <?php echo $btmAcction; ?>
	        <?php
	        if ($workStatusArray[0]['DRD_DESCRIPTION']>0)
	        	echo"<br/>Powód: <i><b><a style='text-decoration: none;' href='./?pg=site401Eonf&dev=".$_SESSION['well_details']['devID']."&pa=reson'>".setDicName($workStatusArray[0]['DRD_DESCRIPTION'])."</a></b></i>";
	        elseif ($workStatusArray[0]['DRD_VALUE']!="ON" && empty($workStatusArray[0]['DRD_DESCRIPTION']))
	        	echo"<br/><a style='text-decoration: none; color: #ff0000;' href='./?pg=site401Eonf&dev=".$_SESSION['well_details']['devID']."&pa=reson'>Kliknij, aby wprowadzić przyczynę wyłączenia</a>";
	        	
	        ?>
	    </div>


    </div>


<div class="tag50_right">


	<div class="head_tag">Ocena energochłonności</div>
    <div class="tag_center">
		<TABLE class="desc_val">
		<TR><TD><a href="?pg=site401mhis&dev=<?php echo$_GET['dev']; ?>"><img SRC="<?php echo $fileName0; ?>" border="0"></a></TD></TR>
		</table>
    </div>

  <div class="head_tag"><?php echo $lab_Tag_site203_004 ;?></div>
  <div class="tag_center">
  	   <?php 
	   		 if ($_SESSION['well_details']['testID']>0 && ($_SESSION['well_details']['wellTypeID']==18 || $_SESSION['well_details']['wellTypeID']==19))
			 	echo"<a href='?pg=site401lift&t=".$_SESSION['well_details']['testID']."&d=".$_SESSION['well_details']['devID']."&q=".$qParam."'><img SRC=".$fileName1_new."></a>";
			 elseif ($_SESSION['well_details']['testID']>0 && $_SESSION['well_details']['wellTypeID']==20)
			 	echo"<img SRC=".$fileName1_new.">";
			 else
			 	 echo $lab_Field_site203_017;
	   ?>

  </div>
  <div class="head_tag"><?php echo $lab_Tag_site203_005 ;?></div>
  <div class="tag_center">
  	   <?php 
	   		 if ($_SESSION['well_details']['testID']>0)
			 	echo"<img SRC=$fileName2_new>";
			 else
			 	 echo $lab_Field_site203_017;
	   ?>
  </div>

<?php
//$workStatusArray = sqlGetResAsArray("select DRD_VALUE,DRD_DESCRIPTION,(select DIC_POL_LANG from sys_dictionaries where DIC_ID=DRD_DESCRIPTION limit 1) DRD_DESC from seg_dev_resources_det where DRD_AUDIT_DATE=(select max(DRD_AUDIT_DATE) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_SESSION['well_details']['devID'].") and DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$_SESSION['well_details']['devID']." limit 1");
//$well_work_status = getLastValueFromDevResourceDetail('WELL_STATUSES','ON_OFF',$_SESSION['well_details']['devID']);


?>

    <div class=tag_ChemicalButtons>
        <a href='?pg=site401inf&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Parametry pracy układu'></A>
        
        <?php if ($_SESSION['well_details']['wellTypeID']!=20): ?>		
	        &nbsp;&nbsp;&nbsp;
	        <a href='?pg=site401mark&dev=<?php echo $_SESSION['well_details']['devID'];?>&data=refresh'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Pobierz aktualne dane'></A>
		<?php endif; ?>

    </div>

</div>

<?php
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>