"; mysql_query("delete from rep_his_data_everyday where RHD_DATE>='2016-10-01 00:00:00' and RHD_DATE<='2016-10-23 23:59:59' and RHD_DRS_ID in (select distinct DRS_ID from a_ademb_wyniki_pom_01)"); unset($wellArray); $wellArray = sqlGetResAsArray("select * from a_ademb_wyniki_pom_04 order by data_pom"); for($i=0; $i0 && $wellArray[$i]['Q']>0) { unset($czas); $czas = getGlobalWorkingTimeInDate($wellArray[$i]['DRS_ID'], $wellArray[$i]['data_pom']); $czas = round($czas/3600,2); $wellArray[$i]['Q'] = floatval($wellArray[$i]['Q']*60); mysql_query("INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$wellArray[$i]['DRS_ID'].",RHD_DATE='".$wellArray[$i]['data_pom']."',RHD_HD_VAL=".$wellArray[$i]['HD'].",RHD_Q_VAL=".$wellArray[$i]['Q'].",RHD_VM3_VAL=".$wellArray[$i]['V3MIN'].",RHD_WORK_TIME_VAL=".$czas.",RHD_AUDIT_CD=now()"); echo("INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$wellArray[$i]['DRS_ID'].",RHD_DATE='".$wellArray[$i]['data_pom']."',RHD_HD_VAL=".$wellArray[$i]['HD'].",RHD_Q_VAL=".$wellArray[$i]['Q'].",RHD_VM3_VAL=".$wellArray[$i]['V3MIN'].",RHD_WORK_TIME_VAL=".$czas.",RHD_AUDIT_CD=now()"); echo"
"; } } $wellArray = sqlGetResAsArray("select * from rep_his_data_everyday,seg_dev_resources where DRS_ID=RHD_DRS_ID and DRS_DEPARTMENT='Dębina' and RHD_DATE>='206-0-0 00:00:00'"); for($i=0; $i0 || $wellArray[$i]['RHD_I_VAL']>0) { unset($czas); $czas = getGlobalWorkingTimeInDate($wellArray[$i]['RHD_DRS_ID'], $wellArray[$i]['RHD_DATE']); $czas = round($czas/3600,2); mysql_query("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']); echo("UPDATE rep_his_data_everyday SET RHD_WORK_TIME_VAL=".$czas." WHERE RHD_ID=".$wellArray[$i]['RHD_ID']); echo"
"; } } ?>