Przeliczanie czasu pracy oraz ilości wypompowanej wody dla studni
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");
//$wellArray = sqlGetResAsArray("select * from rep_his_data_everyday where RHD_Q_VAL>0 and RHD_DATE>='2016-09-01 00:00:00' and RHD_DATE>ADDDATE(now(), INTERVAL -12 HOUR) and (RHD_SPM_WT is null or RHD_WORK_TIME_VAL=0 or RHD_WORK_TIME_VAL is null) order by RHD_DATE desc limit 100");
unset($rowID);
$rowID = sqlGetResAsArray("select max(RHD_ID) RHD_ID from rep_his_data_everyday where RHD_Q_VAL>0 and RHD_DATE>ADDDATE(now(), INTERVAL -12 HOUR) and RHD_DATE>='2016-09-01 00:00:00' and (RHD_SPM_WT is null or RHD_WORK_TIME_VAL=0 or RHD_WORK_TIME_VAL is null) GROUP by RHD_DRS_ID limit 1000");
for($i=0; $i='".$wellArray[0]['RHD_DATE']."' or WLE_DATE_TO is null)");
unset($czas);
if (strlen($czasArray[0]['WLE_DATE_TO']>8))
{
if ( (strtotime($wellArray[0]['RHD_DATE']) - strtotime($czasArray[0]['WLE_DATE_TO']))>0 )
$wellArray[0]['RHD_DATE'] = $czasArray[0]['WLE_DATE_TO'];
}
$czas = fCzas($wellArray[0]['RHD_DRS_ID'], $czasArray[0]['WLE_DATE_FROM'], $wellArray[0]['RHD_DATE']);
$czas = round($czas/3600,2);
//echo "Studnia: ".$wellArray[0]['RHD_DRS_ID'].", data: ".$wellArray[0]['RHD_DATE'].", CZAS=".$czas."
";
$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[0]['RHD_DRS_ID']." and RHD_DATE>='".$czasArray[0]['WLE_DATE_FROM']."' and RHD_DATE<='".$wellArray[0]['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[0]['RHD_DRS_ID']." and RHD_DATE<='".$wellArray[0]['RHD_DATE']."')", "RHD_Q_VAL");
//$woda=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$wellArray[0]['RHD_DRS_ID']." and AVG_DATE>='".$czasArray[0]['WLE_DATE_FROM']."' and AVG_DATE<='".$wellArray[0]['RHD_DATE']."'", "AVG_Q_VAL");
$woda=sqlStringValue("select AVG(AVG_Q_VAL) AVG_Q_VAL from softspm_rep.rep_002_avg_efficiency where AVG_DRS_ID=".$wellArray[0]['RHD_DRS_ID']." and AVG_DATE>=ADDDATE('".$czasArray[0]['WLE_DATE_FROM']."', INTERVAL -1 DAY) and AVG_DATE<='".$wellArray[0]['RHD_DATE']."'", "AVG_Q_VAL");
}
//echo "Studnia: ".$wellArray[0]['RHD_DRS_ID'].", data: ".$wellArray[0]['RHD_DATE'].", WODA=".($woda*$czas)."
";
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[0]['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[0]['RHD_ID']);
echo"
";
//czas
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=290 and DRD_DRS_ID=".$wellArray[0]['RHD_DRS_ID']);
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[0]['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[0]['RHD_DRS_ID']);
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[0]['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[0]['RHD_DRS_ID'], $wellArray[0]['RHD_DATE']);
mysql_query("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.",RHD_VM3_VAL=".$woda." WHERE RHD_ID=".$wellArray[0]['RHD_ID']);
echo("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas.",RHD_VM3_VAL=".$woda." WHERE RHD_ID=".$wellArray[0]['RHD_ID']);
echo"
";
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=230 and DRD_DRS_ID=".$wellArray[0]['RHD_DRS_ID']);
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[0]['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[0]['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"
";
mysql_query("delete FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL=290 and DRD_DRS_ID=".$wellArray[0]['RHD_DRS_ID']);
mysql_query("insert INTO seg_dev_resources_det SET DRD_DRS_ID=".$wellArray[0]['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[0]['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"
";
echo"
";
*/
}
}
?>