"; echo"START: ".date('Y-m-d H:i:m')."
"; //sprawdza w danym momencie zabudowane agregaty unset($wellManualArray); $wellManualArray = sqlGetResAsArray("select * from seg_dev_resources,seg_wells left join seg_wells_exchanged on WLL_ID=WLE_WLL_ID where DRS_DEV_TYPE=12 and DRS_DEV_ID=WLL_ID and WLL_CAT_DIC_ID=20 and WLE_DATE_FROM<=now() and (WLE_DATE_TO>=now() or WLE_DATE_TO is null) group by WLL_ID"); for ($i=0; $i0 and RHD_DATE>='".$wellManualArray[$i]['WLE_DATE_FROM']."')"); if ($lastMeasurment[0]['RHD_Q_VAL']>0) { // sprawdza, czy w danym dniu była już kopiowana wartość z poprzedniego pomiaru - jeśli nie to wstawia unset($checkTodayInput); $checkTodayInput = sqlGetResAsArray("select count(*) ILE from rep_his_data_everyday where RHD_DRS_ID=".$wellManualArray[$i]['DRS_ID']." and RHD_Q_VAL>0 and RHD_DATE>='".date('Y-m-d')." 00:00:00'"); if($checkTodayInput[0]['ILE']==0) { // wstawia poprzednią wartość unset($query); $query = "INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$wellManualArray[$i]['DRS_ID'].",RHD_DATE=now()"; if ($lastMeasurment[0]['RHD_HD_VAL']>0) $query .= ",RHD_HD_VAL=".$lastMeasurment[0]['RHD_HD_VAL']; if ($lastMeasurment[0]['RHD_Q_VAL']>0) $query .= ",RHD_Q_VAL=".$lastMeasurment[0]['RHD_Q_VAL']; if ($lastMeasurment[0]['RHD_P1_VAL']>0) $query .= ",RHD_P1_VAL=".$lastMeasurment[0]['RHD_P1_VAL']; if ($lastMeasurment[0]['RHD_P2_VAL']>0) $query .= ",RHD_P2_VAL=".$lastMeasurment[0]['RHD_P2_VAL']; if ($lastMeasurment[0]['RHD_I_VAL']>0) $query .= ",RHD_I_VAL=".$lastMeasurment[0]['RHD_I_VAL']; if ($lastMeasurment[0]['RHD_U_VAL']>0) $query .= ",RHD_U_VAL=".$lastMeasurment[0]['RHD_U_VAL']; if ($lastMeasurment[0]['RHD_COS_VAL']>0) $query .= ",RHD_COS_VAL=".$lastMeasurment[0]['RHD_COS_VAL']; $query .= ",RHD_AUDIT_CD=now();"; mysql_query($query); } } } } echo"STOP: ".date('Y-m-d H:i:m')."
"; mysql_close($polacz); ?>