132 lines
6.6 KiB
PHP
132 lines
6.6 KiB
PHP
<!DOCTYPE html>
|
|
<html lang="pl">
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<link rel="shortcut icon" href="../images/SoftSPM.ico">
|
|
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
|
|
<title>Bad SYNDIS to SoftSPM</title>
|
|
|
|
<!-- Bootstrap -->
|
|
<link href="bootstrap.min.css" rel="stylesheet">
|
|
|
|
<meta http-equiv="Refresh" content="3" />
|
|
|
|
</head>
|
|
<body>
|
|
<?php
|
|
|
|
date_default_timezone_set('Europe/Warsaw');
|
|
require_once("./func.php");
|
|
require_once("./dbaccess.php");
|
|
require_once('./polynomial/PolynomialRegression.php' );
|
|
|
|
$polacz = mysql_connect($db_host, $db_user, $db_user_pass) or die ('cannot connect to db');
|
|
mysql_select_db($db_name);
|
|
mysql_query("SET NAMES utf8");
|
|
mysql_query("SET CHARACTER_SET utf8_general_ci");
|
|
|
|
|
|
|
|
|
|
|
|
?>
|
|
|
|
<h1>Przeliczanie czasu pracy oraz ilości wypompowanej wody dla Wysadu solnego DĘBINA</h1>
|
|
|
|
<?php
|
|
|
|
//studnie
|
|
//$wellArray = sqlGetResAsArray("select * from rep_his_data_everyday,seg_dev_resources where DRS_ID=RHD_DRS_ID and DRS_DEPARTMENT='Dębina' and (RHD_WORK_TIME_VAL=0 or RHD_WORK_TIME_VAL is null) limit 300");
|
|
$wellArray = sqlGetResAsArray("select * from rep_his_data_everyday,seg_dev_resources where DRS_ID=RHD_DRS_ID and DRS_DEPARTMENT='Dębina' and RHD_Q_VAL>0 and RHD_DATE>=ADDDATE(now(), INTERVAL -12 HOUR) and (RHD_SPM_WT=0 or RHD_SPM_WT is null or RHD_WORK_TIME_VAL=0 or RHD_WORK_TIME_VAL is null) limit 100");
|
|
for($i=0; $i<count($wellArray); $i++)
|
|
{
|
|
if ($wellArray[$i]['RHD_Q_VAL']>0 || $wellArray[$i]['RHD_I_VAL']>0)
|
|
{
|
|
if (substr($wellArray[$i]['RHD_DATE'],5,2)=='09') $tbaName = "rep_002_data_wrze";
|
|
elseif (substr($wellArray[$i]['RHD_DATE'],5,2)=='10') $tbaName = "rep_002_data_pazd";
|
|
elseif (substr($wellArray[$i]['RHD_DATE'],5,2)=='11') $tbaName = "rep_002_data_list";
|
|
elseif (substr($wellArray[$i]['RHD_DATE'],5,2)=='12') $tbaName = "rep_002_data_grud";
|
|
else $tbaName = "rep_002_data_grud";
|
|
|
|
unset($czasArray);
|
|
$czasArray = sqlGetResAsArray("select WLE_DATE_FROM,WLE_DATE_TO from seg_wells_exchanged,seg_dev_resources where WLE_WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and DRS_ID=".$wellArray[$i]['RHD_DRS_ID']." and WLE_DATE_FROM<='".$wellArray[$i]['RHD_DATE']."' and (WLE_DATE_TO>='".$wellArray[$i]['RHD_DATE']."' or WLE_DATE_TO is null)");
|
|
unset($czas);
|
|
if (strlen($czasArray[0]['WLE_DATE_TO']>8))
|
|
{
|
|
if ( (strtotime($wellArray[$i]['RHD_DATE']) - strtotime($rep008_his_Array_01[$i]['WLE_DATE_TO']))>0 )
|
|
$wellArray[$i]['RHD_DATE'] = $rep008_his_Array_01[$i]['WLE_DATE_TO'];
|
|
}
|
|
|
|
$czas = liczCzasu($wellArray[$i]['RHD_DRS_ID'], $czasArray[0]['WLE_DATE_FROM'], $wellArray[$i]['RHD_DATE']);
|
|
$czas = round($czas/3600,2);
|
|
|
|
//echo "Studnia: ".$wellArray[$i]['RHD_DRS_ID'].", data: ".$wellArray[$i]['RHD_DATE'].", CZAS=".$czas."<br>";
|
|
|
|
$woda=0;
|
|
if($czas>0)
|
|
{
|
|
$woda=sqlStringValue("select AVG(RHD_Q_VAL) RHD_Q_VAL from softspm_rep.".$tbaName." where RHD_Q_VAL>0 and RHD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']." and RHD_DATE>='".$czasArray[0]['WLE_DATE_FROM']."' and RHD_DATE<='".$wellArray[$i]['RHD_DATE']."'", "RHD_Q_VAL");
|
|
if (empty($woda) || $woda<=0)
|
|
$woda=sqlStringValue("select RHD_Q_VAL from rep_his_data_everyday where RHD_ID=(select max(RHD_ID) from rep_his_data_everyday where RHD_Q_VAL>0 and RHD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']." and RHD_DATE<='".$wellArray[$i]['RHD_DATE']."')", "RHD_Q_VAL");
|
|
}
|
|
|
|
//echo "Studnia: ".$wellArray[$i]['RHD_DRS_ID'].", data: ".$wellArray[$i]['RHD_DATE'].", WODA=".($woda*$czas)."<br><br>";
|
|
|
|
mysql_query("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.", RHD_VM3_VAL=".($woda*$czas).",RHD_SPM_WT=".$czas.",RHD_SPM_PW=".($woda*$czas)." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']);
|
|
echo("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.", RHD_VM3_VAL=".($woda*$czas).",RHD_SPM_WT=".$czas.",RHD_SPM_PW=".($woda*$czas)." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']);
|
|
echo"<br>";
|
|
|
|
//czas
|
|
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=290 and DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']);
|
|
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=290,DRD_VALUE=round(".$czas.",2),DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water',DRD_AUDIT_DATE='".$insDate."'");
|
|
|
|
|
|
//woda
|
|
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=230 and DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']);
|
|
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=230,DRD_VALUE=round(".($woda*$czas).",2),DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water',DRD_AUDIT_DATE='".$insDate."'");
|
|
|
|
|
|
|
|
/*
|
|
*
|
|
*
|
|
//UPDATE rep_his_data_everyday SET RHD_VM3_VAL=NULL,RHD_WORK_TIME_VAL=NULL, RHD_SPM_WT=NULL,RHD_SPM_PW=NULL WHERE RHD_DRS_ID in (select DRS_ID from seg_dev_resources where DRS_DEPARTMENT='Dębina' and DRS_DEV_TYPE=12)
|
|
unset($woda);
|
|
$woda = getGlobalPumpedWaterRangeDate($wellArray[$i]['RHD_DRS_ID'], $wellArray[$i]['RHD_DATE']);
|
|
|
|
mysql_query("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.",RHD_VM3_VAL=".$woda." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']);
|
|
echo("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.",RHD_VM3_VAL=".$woda." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']);
|
|
echo"<br>";
|
|
|
|
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=230 and DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']);
|
|
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=230,DRD_VALUE=".$woda.",DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water.php',DRD_AUDIT_DATE=now()");
|
|
echo("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=230,DRD_VALUE=".$woda.",DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water.php',DRD_AUDIT_DATE=now()");
|
|
echo"<br>";
|
|
|
|
|
|
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=290 and DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID']);
|
|
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=290,DRD_VALUE=".$czas.",DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water.php',DRD_AUDIT_DATE=now()");
|
|
echo("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[$i]['RHD_DRS_ID'].",DRD_RESOURCES_DETAIL=290,DRD_VALUE=".$czas.",DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='debina_time_water.php',DRD_AUDIT_DATE=now()");
|
|
echo"<br>";
|
|
echo"<br>";
|
|
*/
|
|
|
|
|
|
|
|
}
|
|
}
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
|
|
<?php
|
|
mysql_close($polacz);
|
|
|
|
?>
|
|
</body>
|
|
</html>
|