224 lines
6.5 KiB
PHP
224 lines
6.5 KiB
PHP
<?php session_start();
|
|
error_reporting(E_ALL);
|
|
|
|
function sqlGetResAsArray($query)
|
|
{
|
|
$res=null;
|
|
$res = array();
|
|
|
|
if(!$results = mysqli_query($GLOBALS['dbconn'],$query)){
|
|
echo mysqli_error($GLOBALS['dbconn']);
|
|
return false;
|
|
}
|
|
for($i=0; $row=mysqli_fetch_assoc($results); $i++)
|
|
$res[$i]=$row;
|
|
|
|
return $res;
|
|
}
|
|
// ========================================================== //
|
|
function sqlQuery($query)
|
|
{
|
|
mysqli_query($GLOBALS['dbconn'],$query);
|
|
}
|
|
// ========================================================== //
|
|
function getFloatValue($inParam)
|
|
{
|
|
unset($outParam);
|
|
if (!empty($inParam) || strlen($inParam)>0)
|
|
{
|
|
$inParam = str_replace(array('\'', '\"'), array('', ''), $inParam);
|
|
$inParam = (float)str_replace(',', '.', $inParam);
|
|
$outParam = round($inParam, 2);
|
|
}
|
|
else
|
|
$outParam = 0;
|
|
|
|
return $outParam;
|
|
}
|
|
// ========================================================== //
|
|
function toDate($inParam)
|
|
{
|
|
unset($outParam);
|
|
$outParam = date_format($inParam,"Y-m-d H:i:s");
|
|
|
|
return $outParam;
|
|
}
|
|
// ========================================================== //
|
|
|
|
|
|
// ========================================================== //
|
|
|
|
date_default_timezone_set('Europe/Warsaw');
|
|
$GLOBALS['dbconn'] = mysqli_connect("localhost", "spm_local", "ff8efe59e7265fe9680b0c325e44cb53") or die ('cannot connect to db');
|
|
mysqli_select_db($GLOBALS['dbconn'],"softspm_naprawa");
|
|
sqlQuery("SET NAMES utf8");
|
|
sqlQuery("SET CHARACTER_SET utf8_general_ci");
|
|
|
|
|
|
//studnie
|
|
//$paramName = "Q";
|
|
//$tb_pName = "RHD_Q_VAL";
|
|
|
|
//$paramName = "Hs";
|
|
//$tb_pName = "RHD_HD_VAL";
|
|
|
|
|
|
unset($p_belchatowArray);
|
|
$p_Q = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','Q') ORDER BY PARAM,NAME");
|
|
$p_Hd = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','Hd') ORDER BY PARAM,NAME");
|
|
|
|
$p_P1 = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','p1') ORDER BY PARAM,NAME");
|
|
$p_P2 = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','p2') ORDER BY PARAM,NAME");
|
|
|
|
$p_I2 = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','I2') ORDER BY PARAM,NAME");
|
|
$p_U12 = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','U12') ORDER BY PARAM,NAME");
|
|
$p_Pe = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','P') ORDER BY PARAM,NAME");
|
|
$p_cos = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','cos') ORDER BY PARAM,NAME");
|
|
$p_pp = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','pp') ORDER BY PARAM,NAME");
|
|
$p_diagnostyka = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','diagnostyka') ORDER BY PARAM,NAME");
|
|
$p_HH = sqlGetResAsArray("SELECT * FROM s_szczercow WHERE PARAM IN ('','HH') ORDER BY PARAM,NAME");
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
//foreach ($p_belchatowArray as $tb)
|
|
for ($z=0; $z<count($p_Q); $z++)
|
|
{
|
|
unset($pDetailsBel);
|
|
$pDetailsBel = sqlGetResAsArray("SELECT * FROM softspm.seg_wells,softspm.seg_dev_resources where WLL_ID=DRS_DEV_ID AND DRS_DEV_TYPE=12 AND WLL_NAME='".$p_Q[$z]['NAME']."'");
|
|
|
|
echo("SELECT * FROM softspm.seg_wells,softspm.seg_dev_resources where WLL_ID=DRS_DEV_ID AND DRS_DEV_TYPE=12 AND WLL_NAME='".$p_Q[$z]['NAME']."'");
|
|
echo'<br/>';
|
|
|
|
if($pDetailsBel[0]['DRS_ID']>0)
|
|
{
|
|
echo"DRS: ".$pDetailsBel[0]['DRS_ID']."<br/>";
|
|
|
|
unset($lpArray);
|
|
$lpArray = sqlGetResAsArray("SELECT * FROM softspm.seg_dev_resources_det WHERE DRD_ID=(SELECT MAX(DRD_ID) FROM softspm.seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=240 AND DRD_DRS_ID=".$pDetailsBel[0]['DRS_ID'].")");
|
|
|
|
$lastVAL = 0;
|
|
|
|
for($i=1; $i<89; $i++)
|
|
{
|
|
if ($i<10) $fied = "TIME_0".$i;
|
|
else $fied = "TIME_".$i;
|
|
|
|
//echo"Data: ".$p_belchatowArray[0][$fied]." >>> Wynik: ".getFloatValue($tb[$fied]);
|
|
|
|
//if ( $lastVAL!=getFloatValue($tb[$fied]) && getFloatValue($tb[$fied])>0 )
|
|
if (getFloatValue($p_Q[$z][$fied])>0 && getFloatValue($p_I2[$z][$fied])>0 && getFloatValue($p_U12[$z][$fied])>10)
|
|
{
|
|
sqlQuery("INSERT INTO softspm_naprawa.his_data_p_szczercow SET RHD_DRS_ID=".$pDetailsBel[0]['DRS_ID']."
|
|
,RHD_DATE='".$p_Q[0][$fied]."'
|
|
,RHD_Q_VAL='".(60* getFloatValue($p_Q[$z][$fied]))."'
|
|
,RHD_HD_VAL='".getFloatValue($p_Hd[$z][$fied])."'
|
|
,RHD_P1_VAL='".getFloatValue($p_P1[$z][$fied])."'
|
|
,RHD_P2_VAL='".getFloatValue($p_P2[$z][$fied])."'
|
|
,RHD_I_VAL='".getFloatValue($p_I2[$z][$fied])."'
|
|
,RHD_U_VAL='".getFloatValue($p_U12[$z][$fied])."'
|
|
,RHD_PE_VAL='".getFloatValue($p_Pe[$z][$fied])."'
|
|
,RHD_COS_VAL='".getFloatValue($p_cos[$z][$fied])."'
|
|
,RHD_PP_VAL='".getFloatValue($p_pp[$z][$fied])."'
|
|
,RHD_DGN_VAL='".getFloatValue($p_diagnostyka[$z][$fied])."'
|
|
,RHD_HH_VAL='".(getFloatValue($lpArray[0]['DRD_VALUE']) - getFloatValue($p_Hd[$z][$fied]))."'
|
|
,RHD_AUDIT_CD='".$p_Q[0][$fied]."'");
|
|
|
|
|
|
|
|
/*
|
|
sqlQuery("UPDATE softspm_naprawa.his_data_p_belchatow SET ".$tb_pName."='".getFloatValue($tb[$fied])."'
|
|
WHERE RHD_DRS_ID=".$pDetailsBel[0]['DRS_ID']."
|
|
AND RHD_AUDIT_CD='".$p_belchatowArray[0][$fied]."'");
|
|
*/
|
|
// $lastVAL=getFloatValue($tb[$fied]);
|
|
|
|
echo"<br/>";
|
|
|
|
}
|
|
|
|
|
|
}
|
|
|
|
//echo "<br/><br/>";
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
// piezometry
|
|
// DIC_ID = 210 - poziom wody
|
|
// DIC_ID = 1500 - AUTO; 1501 - MANUAL
|
|
|
|
// dla bełchatowa
|
|
|
|
/*
|
|
unset($p_belchatowArray);
|
|
$p_belchatowArray = sqlGetResAsArray("SELECT * FROM p_szczercow");
|
|
foreach ($p_belchatowArray as $tb)
|
|
{
|
|
|
|
|
|
unset($pDetailsBel);
|
|
$pDetailsBel = sqlGetResAsArray("SELECT * FROM softspm.seg_reservoirs_piezometers,softspm.seg_dev_resources WHERE SRP_ID=DRS_DEV_ID AND DRS_DEV_TYPE=SRP_TYPE_DIC_ID AND SRP_NAME='".$tb['NAME']."'");
|
|
|
|
echo "Z bazy naprawczej: ".$tb['NAME'].", =>".$pDetailsBel[0]['SRP_NAME']." , ID= ".$pDetailsBel[0]['DRS_ID']." oarz typ: ".$pDetailsBel[0]['SRP_MCF_ID']."<br/>";
|
|
|
|
if($pDetailsBel[0]['DRS_ID']>0 && $pDetailsBel[0]['SRP_MCF_ID']==1500)
|
|
{
|
|
$lastHST = 0;
|
|
|
|
for($i=1; $i<88; $i++)
|
|
{
|
|
if ($i<10) $fied = "TIME_0".$i;
|
|
else $fied = "TIME_".$i;
|
|
|
|
echo"Data: ".$p_belchatowArray[0][$fied]." >>> Wynik: ".getFloatValue($tb[$fied]);
|
|
|
|
if ( $lastHST!=getFloatValue($tb[$fied]) )
|
|
{
|
|
sqlQuery("INSERT INTO softspm_naprawa.resources_det_p_szczercow SET DRD_DRS_ID=".$pDetailsBel[0]['DRS_ID']."
|
|
,DRD_RESOURCES_DETAIL='210'
|
|
,DRD_VALUE='".getFloatValue($tb[$fied])."'
|
|
,DRD_EXPORT_SEGAP='1'
|
|
,DRD_AUDIT_USR='naprawa po backupie'
|
|
,DRD_AUDIT_DATE='".$p_belchatowArray[0][$fied]."'");
|
|
|
|
echo" --- DODAJE";
|
|
$lastHST=getFloatValue($tb[$fied]);
|
|
}
|
|
|
|
|
|
echo"<br/>";
|
|
}
|
|
|
|
echo "<br/><br/>";
|
|
|
|
}
|
|
|
|
|
|
|
|
}
|
|
*/
|
|
|
|
|
|
|
|
mysqli_close($GLOBALS['dbconn']);
|
|
|
|
|
|
|
|
?>
|