525234 and RHD_ID<525540
mysql_query("delete from `rep_his_data_everyday` where `RHD_ID`>525540 and RHD_ID<525840");
mysql_query("drop table if exists a_tmp_data_02092016_01");
mysql_query("create table a_tmp_data_02092016_01 select DRS_ID,WLL_ID,WLL_NAME,WLE_DATE_TO from seg_wells_exchanged,seg_wells left join seg_dev_resources on DRS_DEV_ID=WLL_ID where WLL_ID=WLE_WLL_ID and WLL_CAT_DIC_ID=20 and WLE_DATE_FROM<='2016-09-01 00:00:01' and WLE_DATE_TO>='2016-09-01 00:00:01' and DRS_DEV_TYPE=12");
mysql_query("drop table if exists a_tmp_data_02092016_02");
mysql_query("create table a_tmp_data_02092016_02 select WMS_DRS_ID,WMS_WORK_STATUS,WMS_DATETIME from seg_wells_manual_work");
mysql_query("truncate table a_tmp_data_02092016_02");
mysql_query("");
mysql_query("");
mysql_query("");
mysql_query("");
mysql_query("INSERT INTO rep_his_data_everyday SET RHD_ID=525541,RHD_DRS_ID=1,RHD_DATE='2016-09-01 00:00:10',RHD_VM3_VAL=1,RHD_WORK_TIME_VAL=1,RHD_AUDIT_CD='2016-09-01 00:00:10';");
$id = 525541;
unset($rep002Array);
$rep002Array = sqlGetResAsArray("select * from a_tmp_data_02092016_01");
for ($i=0; $i0)
{
mysql_query("INSERT INTO rep_his_data_everyday SET RHD_ID=".$id.",RHD_DRS_ID=".$rep002Array[$i]['DRS_ID'].",RHD_DATE='2016-09-01 00:00:10',RHD_VM3_VAL=pw_tmp_01(".$rep002Array[$i]['DRS_ID'].",'2016-09-01 00:00:10'),RHD_WORK_TIME_VAL=round(wt_tmp_01(".$rep002Array[$i]['DRS_ID'].",'2016-09-01 00:00:10')/3600,2),RHD_AUDIT_CD='2016-09-01 00:00:10';");
$id++;
mysql_query("INSERT INTO rep_his_data_everyday SET RHD_ID=".$id.",RHD_DRS_ID=".$rep002Array[$i]['DRS_ID'].",RHD_DATE='".$rep002Array[$i]['WLE_DATE_TO']."',RHD_VM3_VAL=pw_tmp_01(".$rep002Array[$i]['DRS_ID'].",'".$rep002Array[$i]['WLE_DATE_TO']."'),RHD_WORK_TIME_VAL=round(wt_tmp_01(".$rep002Array[$i]['DRS_ID'].",'".$rep002Array[$i]['WLE_DATE_TO']."')/3600,2),RHD_AUDIT_CD='".$rep002Array[$i]['WLE_DATE_TO']."';");
$id++;
}
echo "Wprowadzono dane dla studni: ".$rep002Array[$i]['WLL_NAME'].", DRS: ".$rep002Array[$i]['DRS_ID'].", DATE: ".$rep002Array[$i]['WLE_DATE_TO']."
";
}
mysql_query("drop table if exists a_tmp_data_02092016_01");
mysql_query("drop table if exists a_tmp_data_02092016_02");
//print_r($rep002Array);
?>
DONE