$lab_Field_site803_013"; unset($maxWELLid); unset($maxDRSid); } */ //zatopienie agregatu if ($_POST['subSinkSave']==$lab_ButtonName_Save && $_GET['dev']>0 && $_GET['sink']==md5($_GET['dev']) && ($_POST['inSinkPump']>0 || $_POST['inSinkEng']>0) ) { unset($chechWellArray); unset($maxEX); unset($currWellagg); $chechWellArray = sqlGetResAsArray("select * from seg_wells,seg_dev_resources where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and DRS_ID=".$_GET['dev']); $currWellagg = sqlGetResAsArray("select * from seg_well_pump_eng_rel where RWL_WLL_ID=".$chechWellArray[0]['WLL_ID']); $maxEX = sqlValue("select max(WLE_NR_EXCHANGE) from seg_wells_exchanged where WLE_WLL_ID=".$chechWellArray[0]['WLL_ID']); //Jeśli zaznaczono pompę if ($_POST['inSinkPump']==1) mysql_query("UPDATE seg_dev_resources SET DRS_CASSATION_DATE='".$_POST['inSinkDate']."',DRS_STATUS_DIC_ID=9,DRS_RESOURCES_DIC_ID=40,DRS_DEV_ATTENTION='1401' WHERE DRS_ID=".$currWellagg[0]['RWL_PUP_DRS_ID']); else $currWellagg[0]['RWL_PUP_DRS_ID']='null'; //================================================= //Jeśli zaznaczono silnik if ($_POST['inSinkEng']==1) mysql_query("UPDATE seg_dev_resources SET DRS_CASSATION_DATE='".$_POST['inSinkDate']."',DRS_STATUS_DIC_ID=9,DRS_RESOURCES_DIC_ID=40,DRS_DEV_ATTENTION='1401' WHERE DRS_ID=".$currWellagg[0]['RWL_ENG_DRS_ID']); else $currWellagg[0]['RWL_ENG_DRS_ID']='null'; //================================================= mysql_query("INSERT INTO seg_wellsink_pump_eng_rel SET RWS_WLL_ID=".$chechWellArray[0]['WLL_ID'].",RWS_DRS_ID=".$chechWellArray[0]['DRS_ID'].",RWS_PUP_DRS_ID=".$currWellagg[0]['RWL_PUP_DRS_ID'].",RWS_ENG_DRS_ID=".$currWellagg[0]['RWL_ENG_DRS_ID'].",RWS_DESC='".$_POST['inSinkReasonAdd']."',RWS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."',RWS_AUDIT_USR='".$_SESSION['user']."',RWS_AUDIT_DATE='".$_POST['inSinkDate']." ".$_POST['inSinkTimeH'].":".$_POST['inSinkTimeM'].":00'"); mysql_query("UPDATE seg_wells_exchanged SET WLE_DATE_TO='".$_POST['inSinkDate']." ".$_POST['inSinkTimeH'].":".$_POST['inSinkTimeM'].":00',WLE_REASON='Zatopienie' WHERE WLE_WLL_ID=".$chechWellArray[0]['WLL_ID']." and WLE_NR_EXCHANGE=".$maxEX); // zmiania status dla studni mysql_query("UPDATE seg_dev_resources SET DRS_AVAILABLE_DATE=NULL,DRS_RESOURCES_DIC_ID=902 WHERE DRS_ID=".$_GET['dev']); //usuwa relacje z studnia-pompa-silnik mysql_query("DELETE FROM seg_well_pump_eng_rel WHERE RWL_WLL_ID=".$chechWellArray[0]['WLL_ID']); // dodaje dodatkowy "pusty" wpis do tabeli pomiarów, (10 sekund póżniej po wybudowie) żeby nie kopiwał w przyszłości innych mysql_query("INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$_GET['dev'].",RHD_DATE='".$_POST['inSinkDate']." ".$_POST['inSinkTimeH'].":".$_POST['inSinkTimeM'].":10',RHD_AUDIT_CD=now()"); echo"

Agregat (Pompa/Silnik) został pomyślnie oznaczony jako zatopiony.

"; delSearchSessionData(); unset($chechWellArray); unset($maxEX); unset($currWellagg); unset($_GET['dev']); } //wybudowa agregatu if($_POST['subBuildOutSave']==$lab_ButtonName_Save && !empty($_POST['inBuildDate']) && $_GET['dev']>0) { $chechWellArray = sqlGetResAsArray("select WLL_ID,WLL_CAT_DIC_ID from seg_wells,seg_dev_resources where DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 and DRS_ID=".$_GET['dev']." limit 1"); //print_r($_SESSION['site301inf_array']); $maxEX = sqlValue("select max(WLE_NR_EXCHANGE) from seg_wells_exchanged where WLE_WLL_ID=".$chechWellArray[0]['WLL_ID']); //aktualizauje informacje w historii agregatów if (strlen($_POST['inBuildReasonAdd'])>1) $_POST['inBuildReason'] .= " [".$_POST['inBuildReasonAdd']."]"; mysql_query("UPDATE seg_wells_exchanged SET WLE_DATE_TO='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00',WLE_REASON='".$_POST['inBuildReason']."' WHERE WLE_WLL_ID=".$chechWellArray[0]['WLL_ID']." and WLE_NR_EXCHANGE=".$maxEX); //zmiania statusy dla pompy i silnika (nie zmianiemy statusu - pozostaje wirtualny PRZEGLĄD - jako niepowiązany z żadną studnią) //mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=30,DRS_RESOURCES_DIC_ID=707 WHERE DRS_ID=".$_SESSION['well_details']['pumpDrsID']); //mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=30,DRS_RESOURCES_DIC_ID=707 WHERE DRS_ID=".$_SESSION['well_details']['engDrsID']); // zmiania status dla studni mysql_query("UPDATE seg_dev_resources SET DRS_AVAILABLE_DATE=NULL,DRS_RESOURCES_DIC_ID=902 WHERE DRS_ID=".$_GET['dev']); //usuwa relacje z studnia-pompa-silnik mysql_query("DELETE FROM seg_well_pump_eng_rel WHERE RWL_WLL_ID=".$chechWellArray[0]['WLL_ID']); //wyłącza pompę //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_SESSION['well_details']['devID'].",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='".$_POST['inBuildReason']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'"); //zapisuje ostatni pomiar, jeśli studnia jest w kategorii SPM inne // 2018-04-24 - usuwamy if ($chechWellArray[0]['WLL_CAT_DIC_ID']==20) { //insert into rep_his_data_everyday select null,RHD_DRS_ID,'2016-09-10 10:00:00' NEW_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_PP_VAL,RHD_HH_VAL,getWellPumpedWaterInDate(RHD_DRS_ID,'2016-09-10 10:00:00') VM3_VAL,RHD_WTEMP_VAL,RHD_DGN_VAL,round(getWellWorkingTimeInDate(RHD_DRS_ID,'2016-09-10 10:00:00')/3600,2) WORK_TIME_VAL, now() from rep_his_data_everyday where RHD_DATE=(select max(RHD_DATE) from rep_his_data_everyday where RHD_DRS_ID=2858) and RHD_DRS_ID=2858; //mysql_query("insert into rep_his_data_everyday select null,RHD_DRS_ID,'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00' NEW_DATE,RHD_HST0_VAL,RHD_HST_VAL,RHD_HD_VAL,RHD_Q_VAL,RHD_P1_VAL,RHD_P2_VAL,RHD_I_VAL,RHD_U_VAL,RHD_PE_VAL,RHD_COS_VAL,RHD_PP_VAL,RHD_HH_VAL,getWellPumpedWaterInDate(RHD_DRS_ID,'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00') VM3_VAL,RHD_WTEMP_VAL,RHD_DGN_VAL,round(getWellWorkingTimeInDate(RHD_DRS_ID,'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00')/3600,2) WORK_TIME_VAL, now() from rep_his_data_everyday where RHD_DATE=(select max(RHD_DATE) from rep_his_data_everyday where RHD_DRS_ID=".$_GET['dev'].") and RHD_DRS_ID=".$_GET['dev']); // wpisuje do tabeli countersów - czas pracy //mysql_query("INSERT INTO seg_dev_counters SET SDC_DRS_ID=".$_GET['dev'].",SDC_VALUE=round(getWellWorkingTimeInDate(".$_GET['dev'].",'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00')/3600,2),SDC_TYPE_DIC_ID=290,SDC_DESC='".$_POST['inBuildReason']."',SDC_DEPARTMENT='".$_SESSION['syndis_eq_stock']."',SDC_MEASURE_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00',SDC_AUDIT_USR='".$_SESSION['user']."',SDC_AUDIT_DATE=now()"); // wpisuje do tabeli countersów - ilość wypompowanej wody //mysql_query("INSERT INTO seg_dev_counters SET SDC_DRS_ID=".$_GET['dev'].",SDC_VALUE=getWellPumpedWaterInDate(".$_GET['dev'].",'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'),SDC_TYPE_DIC_ID=230,SDC_DESC='".$_POST['inBuildReason']."',SDC_DEPARTMENT='".$_SESSION['syndis_eq_stock']."',SDC_MEASURE_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00',SDC_AUDIT_USR='".$_SESSION['user']."',SDC_AUDIT_DATE=now()"); } // dodaje dodatkowy "pusty" wpis do tabeli pomiarów, (10 sekund póżniej po wybudowie) żeby nie kopiwał w przyszłości innych mysql_query("INSERT INTO rep_his_data_everyday SET RHD_DRS_ID=".$_GET['dev'].",RHD_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":10',RHD_AUDIT_CD=now()"); //usuwa wszystkie wpisy w tabeli seg_wells_manual_work mysql_query("INSERT INTO rep_his_data_todelete SET DTD_DRS_ID=".$_GET['dev'].",DTD_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'"); // aktualizacja statusu zlecenia - zamyka mysql_query("UPDATE seg_orders SET ORD_STATUS_DIC_ID=853,ORD_FINISH_USR='".$_SESSION['user']."',ORD_FINISH_DATE=now() WHERE ORD_SCOPE_DIC_ID=802 and ORD_DRS_ID=".$_GET['dev']); // call data_todelete(); //mysql_query("DELETE FROM seg_wells_manual_work WHERE WMS_DRS_ID=".$_GET['dev']); //Jeśli były jakieś nowsze wpisy do tabel niż data wybudowy - automatycznie to usuwa //mysql_query("DELETE FROM rep_his_data_everyday WHERE RHD_DRS_ID=".$_GET['dev']." and RHD_DATE>'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'"); //mysql_query("DELETE FROM seg_dev_resources_det WHERE DRD_RESOURCES_DETAIL in (200,205,210,215,220,225,230,245,401,402,730,270,275,280,290,260,721,265) and DRD_DRS_ID=".$_GET['dev']." and DRD_AUDIT_DATE>'".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'"); //dodaje POSTÓJ - domyślnie przyjmując status "Oczekująca na uruchomienie" mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_GET['dev'].",DRD_RESOURCES_DETAIL=507,DRD_VALUE='OFF',DRD_DESCRIPTION='1525',DRD_EXPORT_SEGAP='1',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inBuildDate']." ".$_POST['inBuildTimeH'].":".$_POST['inBuildTimeM'].":00'"); echo"

$lab_Field_site301_022

"; delSearchSessionData(); unset($chechWellArray); unset($_GET['dev']); } //zdjęcie z exploatacji if($_SESSION['well_details']['devID']>0 && $_POST['subOperateOut']==$lab_ButtonName_Save && !empty($_POST['inBuildDate'])) { mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=4,DRS_RESOURCES_DIC_ID=902,DRS_DEV_ATTENTION='".$_POST['inBuildReason']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$_SESSION['well_details']['devID']); mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE='".$_POST['inBuildDate']."' WHERE OHC_DRS_ID=".$_SESSION['well_details']['devID']); mysql_query("UPDATE seg_wells SET WLL_SYS_TYPE='".$lab_Field_site301_027."',WLL_STAT_DESC='".$_POST['inBuildReason']."' WHERE WLL_ID=".$_SESSION['well_details']['wellID']); echo"

$lab_UpdateRecordNotification_001

"; } if (!empty($_GET['param'])) { $paramArray = explode(',',$_GET['param']); //usuwanie studni if ($paramArray[0]==md5($paramArray[1]) && $paramArray[1]==$_GET['dev'] && $paramArray[2]=='del') { mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=-1 WHERE DRS_ID=".$_GET['dev']); //mysql_query("DELETE FROM seg_dev_resources_his WHERE DRS_ID=".$_GET['dev']); echo"

$lab_DeleteRecordNotification_001

"; } //wprowadzanie studni do exploatacji if ($paramArray[0]==md5($paramArray[1]) && $paramArray[1]==$_GET['dev'] && $paramArray[2]=='oin') { mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=3,DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$_SESSION['well_details']['devID']); mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE=null WHERE OHC_DRS_ID=".$_SESSION['well_details']['devID']); mysql_query("UPDATE seg_wells SET WLL_SYS_TYPE=null,WLL_STAT_DESC=null WHERE WLL_ID=".$_SESSION['well_details']['wellID']); echo"

$lab_UpdateRecordNotification_001

"; } unset($paramArray); } // zamiana studni w piezometr if (!empty($_GET['stu2piezo'])) { //stu2piezo=2840,a78482ce76496fcf49085f2190e675b4,stu2piezo unset($stu2piezoArray); $stu2piezoArray = explode(',',$_GET['stu2piezo']); if ($stu2piezoArray[1]==md5($stu2piezoArray[0]) && $stu2piezoArray[2]=='stu2piezo') { unset($stuArray); $stuArray = sqlGetResAsArray("select * from seg_wells,seg_dev_resources where WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and DRS_ID=".$stu2piezoArray[0]); // zakłada nowy piezometr if (sqlValue("select count(*) from seg_reservoirs_piezometers where SRP_NAME='".$stuArray[0]['WLL_NAME']."'")==0) { mysql_query("INSERT INTO seg_reservoirs_piezometers SET SRP_SWI_ID=".$stuArray[0]['WLL_SWI_ID'].",SRP_MCF_ID=1500,SRP_BARIERA='".$stuArray[0]['WLL_BARIERA']."',SRP_NAME='".$stuArray[0]['WLL_NAME']."',SRP_TYPE_DIC_ID=601,SRP_LATITUDE='".$stuArray[0]['WLL_LATITUDE']."',SRP_LONGITUDE='".$stuArray[0]['WLL_LONGITUDE']."'"); $newID = getMaxIDfromMySqlTable('seg_reservoirs_piezometers'); mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$newID.",DRS_DEV_TYPE=601,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=941,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$stu2piezoArray[0]); } else // aktualizuje istniejący { unset($curPiezo); $curPiezo = sqlGetResAsArray("select SRP_ID from seg_reservoirs_piezometers where SRP_NAME='".$stuArray[0]['WLL_NAME']."'"); mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$curPiezo[0]['SRP_ID'].",DRS_DEV_TYPE=601,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=941,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$stu2piezoArray[0]); unset($curPiezo); } echo"

Studnia została pomyślnie przekształcona w piezometr.

"; } unset($stu2piezoArray); } if (!$_POST['sr_status']) $_POST['sr_status']=3; ?>

Studnia:				status:

"; else echo""; ?> Pokaż wszystkie

$r["DRS_ID"], 'well_name' => $r["WLL_NAME"], 'well_id' => $r["RWL_WLL_ID"], 'pup_drs_id' => $r["RWL_PUP_DRS_ID"], 'eng_drs_id' => $r["RWL_ENG_DRS_ID"], 'bariera' => $r["WLL_BARIERA"], 'katSpm' => setDicName($r["WLL_CAT_DIC_ID"]), 'status' => setDicName($r["DRS_STATUS_DIC_ID"]), 'stat_typ' => setDicName($r["DRS_RESOURCES_DIC_ID"]), 'pup_name' => sqlStringValue("select PUP_NAME from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID where DRS_ID=".$r["RWL_PUP_DRS_ID"], "PUP_NAME"), 'pup_no' => sqlStringValue("select DRS_SN_NUMBER from seg_dev_resources left join seg_pumps on DRS_DEV_ID=PUP_ID where DRS_ID=".$r["RWL_PUP_DRS_ID"], "DRS_SN_NUMBER"), 'eng_name' => sqlStringValue("select ENG_NAME from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID where DRS_ID=".$r["RWL_ENG_DRS_ID"], "ENG_NAME"), 'eng_no' => sqlStringValue("select DRS_SN_NUMBER from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID where DRS_ID=".$r["RWL_ENG_DRS_ID"], "DRS_SN_NUMBER") ); } unset($_SESSION['site301_array']); $_SESSION['site301_array']=$res; } $start=($_GET['pgn']-1)*20; $stop = $_GET['pgn']*20; if ($stop>count($_SESSION['site301_array'])) $stop=count($_SESSION['site301_array']); for($i=$start;$i<$stop;$i++) { echo" "; } ?>

Lp.
".($i+1).".	".$_SESSION['site301_array'][$i]['well_name']."	".$_SESSION['site301_array'][$i]['bariera']."	".$_SESSION['site301_array'][$i]['pup_name']."	".$_SESSION['site301_array'][$i]['pup_no']."	".$_SESSION['site301_array'][$i]['eng_name']."	".$_SESSION['site301_array'][$i]['eng_no']."	".$_SESSION['site301_array'][$i]['status']."	".$_SESSION['site301_array'][$i]['katSpm']."

Wyników:

20) echo pagination_grid('?pg=site301', $_GET['pgn'], count($_SESSION['site301_array'])); ?>

"; unset($_SESSION['exdev']); ?>