89 lines
3.7 KiB
PHP
89 lines
3.7 KiB
PHP
<?php
|
|
require_once("./func.php");
|
|
require_once("./dbaccess.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");
|
|
|
|
header('refresh: 1;');
|
|
echo"START: ".date('Y-m-d H:i:m')."<br/>";
|
|
|
|
unset($wellArray);
|
|
$wellArray = sqlGetResAsArray("select * from aaa_aaa_wells where STAT=0 order by WLL_NAME limit 20");
|
|
//print_r($wellArray);
|
|
for($i=0; $i<count($wellArray); $i++)
|
|
//for($i=0; $i<1; $i++)
|
|
{
|
|
unset($oldData);
|
|
unset($singleArray);
|
|
$valH1='null';$valH2='null';$valHD='null';$valHST='null';$valQ='null';$valIR='null';$valE='null';$valFI='null';$valPE='null';$valURS='null';$valV='null';$valH0S='null';$valDGN='null';
|
|
|
|
$singleArray = sqlGetResAsArray("select * from stp_stpar where stp_stpar_var in ('H1','H2','HD','HST','Q','IR','E','FI','PE','URS','V','H0S','DGN') and stp_stpar_stud='".$wellArray[$i]['WLL_NAME']."' order by stp_stpar_data");
|
|
for($s=0; $s<count($singleArray); $s++)
|
|
{
|
|
if ($s==0) $oldData = $singleArray[$s]['stp_stpar_data'];
|
|
|
|
if ($singleArray[$s]['stp_stpar_data'] != $oldData)
|
|
{
|
|
|
|
|
|
mysql_query("
|
|
INSERT INTO rep_his_data_everyday_his SET
|
|
RHD_DRS_ID=".$wellArray[$i]['DRS_ID'].",
|
|
RHD_DATE='".$oldData."',
|
|
RHD_HST0_VAL=".$valH0S.",
|
|
RHD_HST_VAL=".$valHST.",
|
|
RHD_HD_VAL=".$valHD.",
|
|
RHD_Q_VAL=".$valQ.",
|
|
RHD_P1_VAL=".$valH1.",
|
|
RHD_P2_VAL=".$valH2.",
|
|
RHD_I_VAL=".$valIR.",
|
|
RHD_U_VAL=".$valURS.",
|
|
RHD_PE_VAL=".$valPE.",
|
|
RHD_COS_VAL=".$valFI.",
|
|
RHD_VM3_VAL=".$valV.",
|
|
RHD_DGN_VAL=".$valDGN.",
|
|
RHD_AUDIT_CD=now()
|
|
");
|
|
|
|
|
|
$oldData = $singleArray[$s]['stp_stpar_data'];
|
|
$valH1='null';$valH2='null';$valHD='null';$valHST='null';$valQ='null';$valIR='null';$valE='null';$valFI='null';$valPE='null';$valURS='null';$valV='null';$valH0S='null';$valDGN='null';
|
|
}
|
|
|
|
if ($singleArray[$s]['stp_stpar_var'] == 'H1')$valH1 = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'H2') $valH2 = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'HD') $valHD = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'HST') $valHST = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'Q') $valQ = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'IR') $valIR = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'E') $valE = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'FI') $valFI = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'PE') $valPE = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'URS') $valURS = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'V') $valV = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'H0S') $valH0S = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
elseif ($singleArray[$s]['stp_stpar_var'] == 'DGN') $valDGN = getFloatValue($singleArray[$s]['stp_stpar_val1']);
|
|
|
|
|
|
|
|
}
|
|
|
|
|
|
|
|
mysql_query("UPDATE aaa_aaa_wells SET STAT=1 WHERE DRS_ID=".$wellArray[$i]['DRS_ID']);
|
|
|
|
//select * from stp_stpar where stp_stpar_var in ('H1','H2','HD','HST','Q','IR','E','FI','PE','URS','V','H0S','DGN') and stp_stpar_stud='G50' order by stp_stpar_data
|
|
|
|
// getParentAndValue4rep003($przelicz[$p]['DRS_ID']);
|
|
|
|
|
|
|
|
}
|
|
|
|
echo"STOP: ".date('Y-m-d H:i:m')."<br/>";
|
|
|
|
|
|
mysql_close($polacz);
|
|
?>
|