Files
2026-09-03 11:24:19 +02:00

279 lines
18 KiB
PHP

<?php
if (!empty($_SESSION['site309']))
{
?>
<?php
if (!empty($_GET['dev'])) $_GET['dev'] = $_POST['dev'];
// Dodawanie nowego piezometru
if (!empty($_POST['inRePieName']) && $_POST['subRePieSave']==$lab_ButtonName_Save )
{
$ujName = sqlStringValue("select SWI_NAME from seg_water_intakes where SWI_ID=".$_POST['inPieBariera'],"SWI_NAME");
mysql_query("INSERT INTO seg_reservoirs_piezometers SET SRP_NAME='".$_POST['inRePieName']."',SRP_SWI_ID=".$_POST['inPieBariera'].",SRP_BARIERA='".$ujName."',SRP_TYPE_DIC_ID=601,SRP_LATITUDE='".getFloatValue($_POST['inRePieLat'])."',SRP_LONGITUDE='".getFloatValue($_POST['inRePieLong'])."', SRP_SYS_TYPE='".$_POST['inPieSysType']."'");
$maxSRPid = sqlValue("select max(SRP_ID) from seg_reservoirs_piezometers");
//mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=$maxSRPid,DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='PIEZOMETER'),DRS_SN_NUMBER='".$_POST['inRePieSN']."',DRS_BUY_DATE='".$_POST['inRePieBuyDate']."',DRS_STATUS_DIC_ID=".$_POST['inRePieStatus'].",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=$maxSRPid,DRS_DEV_TYPE=601,DRS_SN_NUMBER='".$_POST['inRePieSN']."',DRS_BUY_DATE=now(),DRS_AVAILABLE_DATE=now(),DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=".$_POST['inRePieStatus'].",DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."',DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()");
$maxDRSid = sqlValue("select max(DRS_ID) from seg_dev_resources");
//poziomy wody - położenie
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$maxDRSid.",DRD_VALUE='".getFloatValue($_POST['inRePieRepair'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='REPAIR_LEVEL'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$maxDRSid.",DRD_VALUE='".str_replace(",",".",$_POST['inRePieFlUp'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_UP'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$maxDRSid.",DRD_VALUE='".str_replace(",",".",$_POST['inRePieFlDown'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_DOWN'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// środek trwały
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".$_POST['inRePieAsset']."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// głębokość
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".getFloatValue($_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DEPTH'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".getFloatValue($_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LS'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// średnica
//mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".getFloatValue($_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DIAMETER'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".getFloatValue($_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='DST'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// dodaje wartość początkową lustra wody dla piezometru - PUSTY głębokość dziury
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".getFloatValue($_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_PARAMETERS' and DIC_NAME='WATER_LEVEL'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// dodaje wartość początkową zasilania - NIEPODŁĄCZONY ZERO
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='0',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_PARAMETERS' and DIC_NAME='VOLTAGE'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// sonda
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$maxDRSid.",DRD_VALUE='".getFloatValue($_POST['inSonda'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='LPM'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
//dodaje do Whole cards
mysql_query("INSERT INTO seg_object_hole_cards SET OHC_DRS_ID=".$maxDRSid.",OHC_UJ='".$ujName."',OHC_NAME='".$_POST['inRePieName']."',OHC_DATA_ODDANIA=now(),OHC_DL_GEOGR='".getFloatValue($_POST['inRePieLat'])."',OHC_SZER_GEOGR='".getFloatValue($_POST['inRePieLong'])."',OHC_PLC='".$_SESSION['syndis_eq_stock']."'");
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
}
// Aktualizacja zbiornika
if (!empty($_POST['inRePieName']) && $_POST['subRePieUpdate']==$lab_ButtonName_Update )
{
mysql_query("update seg_reservoirs_piezometers SET SRP_MCF_ID=".$_POST['inRePieNManufID'].",SRP_NAME='".$_POST['inRePieName']."',SRP_TYPE_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='PIEZOMETER'),SRP_LATITUDE='".getFloatValue($_POST['inRePieLat'])."',SRP_LONGITUDE='".getFloatValue($_POST['inRePieLong'])."' where SRP_ID=".$_POST['sprid']);
mysql_query("update seg_dev_resources SET DRS_SN_NUMBER='".$_POST['inRePieSN']."',DRS_BUY_DATE='".$_POST['inRePieBuyDate']."',DRS_STATUS_DIC_ID=".$_POST['inRePieStatus'].",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_POST['dev']);
//poziomy wody - położenie
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMaxAcc'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MAX_ACCEPTABLE'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMaxWar'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MAX_WARNING'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMinWar'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MIN_WARNING'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieMinAcc'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='MIN_ACCEPTABLE'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// środek trwały
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".$_POST['inRePieAsset']."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// głębokość
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DEPTH'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
// średnica
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".getFloatValue($_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DIAMETER'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
}
// zamiana piezometru w studnię
if (!empty($_GET['piezo2stu']))
{
//piezo2stu=2840,a78482ce76496fcf49085f2190e675b4,piezo2stu
unset($piezo2stuArray);
$piezo2stuArray = explode(',',$_GET['piezo2stu']);
if ($piezo2stuArray[1]==md5($piezo2stuArray[0]) && $piezo2stuArray[2]=='piezo2stu')
{
unset($piezoArray);
$piezoArray = sqlGetResAsArray("select * from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and DRS_ID=".$piezo2stuArray[0]);
// zakłada nową studnie
if (sqlValue("select count(*) from seg_wells where WLL_NAME='".$piezoArray[0]['SRP_NAME']."'")==0)
{
mysql_query("INSERT INTO seg_wells SET WLL_SWI_ID=".$piezoArray[0]['SRP_SWI_ID'].",WLL_BARIERA='".$piezoArray[0]['SRP_BARIERA']."',WLL_NAME='".$piezoArray[0]['SRP_NAME']."',WLL_CAT_DIC_ID=20,WLL_LATITUDE='".$piezoArray[0]['SRP_LATITUDE']."',WLL_LONGITUDE='".$piezoArray[0]['SRP_LONGITUDE']."',WLL_PP_SCOPE='500'");
$newID = getMaxIDfromMySqlTable('seg_wells');
mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$newID.",DRS_DEV_TYPE=12,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=902,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$piezo2stuArray[0]);
}
else // aktualizuje istniejącą
{
unset($curWell);
$curWell = sqlGetResAsArray("select WLL_ID from seg_wells where WLL_NAME='".$piezoArray[0]['SRP_NAME']."'");
mysql_query("UPDATE seg_dev_resources SET DRS_DEV_ID=".$curWell[0]['WLL_ID'].",DRS_DEV_TYPE=12,DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=902,DRS_AUDIT_USR='przekształcenie - ".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$piezo2stuArray[0]);
unset($curWell);
}
echo"<div class='actionOK'>Piezometr został pomyślnie przekształcony w studnię.</div>";
}
unset($piezo2stuArray);
}
if (!$_POST['sr_status']) $_POST['sr_status']=3;
?>
<?php
//paginacja
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); }
if ($_POST['sub_search']=='Szukaj') $_SESSION['site309_input'] = $_POST['sr_well'];
?>
<form action="./?pg=site309&pgn=1" method="post">
<div class="tag100">
<table>
<tr>
<td>Piezometr:</td>
<td style="width: 10px;"></td>
<td><input type="text" name="sr_well" value="<?php echo $_SESSION['site309_input'];?>"></td>
<td style="width: 10px;"></td>
<td>status:</td>
<td style="width: 5px;"></td>
<td>
<select name="sr_status">
<?php
$wynik = mysql_query("select DIC_ID,DIC_POL_LANG from sys_dictionaries where DIC_ID in (3,4)");
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$resID=$r["DIC_ID"];
$resDESC=$r["DIC_POL_LANG"];
if ($_POST['sr_status']==$resID)
echo"<option value='$resID' selected>$resDESC</option>";
else
echo"<option value='$resID'>$resDESC</option>";
}
if ($_POST['sr_status']==100)
echo"<option value='100' selected>Wszystkie</option>";
else
echo"<option value='100'>Wszystkie</option>";
?>
</select>
</td>
<td style="width: 10px;"></td>
<td><input type="submit" name="sub_search" value="Szukaj" class="btn btn-default btn-sm"></td>
<td></td>
</tr>
<tr><td>&nbsp;</td></tr>
<tr>
<td colspan="3">
<?php
if (!empty($_POST['sr_all'])) echo"<input type='checkbox' name='sr_all' value='1' checked>";
else echo"<input type='checkbox' name='sr_all' value='1'>";
?>
Pokaż wszystkie</td>
</tr>
</table>
</div>
</form>
<div class="tag100">
<div class="head_tag"><?php echo $lab_Tag_site309_001 ;?></div>
<div class="tag">
<table WIDTH="100%" class="tag">
<TR>
<TD class="label">Lp.</TD>
<TD class="label"><?php echo $lab_Tag_site309_003 ;?></TD>
<td class="label"><?php echo $lab_Field_site301_014 ;?></td>
<td class="label"><?php echo $lab_Field_site802_002 ;?></td>
<td class="label"><?php echo $lab_Field_site302_004 ;?></td>
<td class="label"><?php echo $lab_Tag_site302_003 ;?></td>
<td class="label">Sterowanie</td>
</TR>
<?php
if (empty($_SESSION['site309_array']) || $_POST['sub_search']=='Szukaj')
{
$query="select DRS_ID,SRP_MCF_ID,SRP_NAME,SRP_BARIERA,DRS_SN_NUMBER,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,SRP_SYS_TYPE from seg_dev_resources,seg_reservoirs_piezometers where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and DRS_DEPARTMENT='".$_SESSION['eq_stock_param3_1']."'and SRP_NAME like '%".$_POST['sr_well']."%'";
if($_POST['sr_status']!=100) $query.=" and DRS_STATUS_DIC_ID=".$_POST['sr_status'];
$query .= " order by SRP_NAME";
if (empty($_POST['sr_all'])) $query .= " limit 100";
$res=null;
$wynik = mysql_query($query);
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$res[]=array(
'drs_id' => $r["DRS_ID"],
'name' => $r["SRP_NAME"],
'bariera' => $r["SRP_BARIERA"],
'rodzaj' => $r["SRP_SYS_TYPE"],
'status' => setDicName($r["DRS_STATUS_DIC_ID"]),
'typ' => setDicName($r["DRS_RESOURCES_DIC_ID"]),
'ster' => setDicName($r["SRP_MCF_ID"])
);
}
unset($_SESSION['site309_array']);
$_SESSION['site309_array']=$res;
}
$start=($_GET['pgn']-1)*20;
$stop = $_GET['pgn']*20;
if ($stop>count($_SESSION['site309_array'])) $stop=count($_SESSION['site309_array']);
for($i=$start;$i<$stop;$i++)
{
echo"
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site309inf&dev=".$_SESSION['site309_array'][$i]['drs_id']."'".chr(34).">
<TD class='field_left'>".($i+1).".</TD>
<TD class='field_left'>".$_SESSION['site309_array'][$i]['name']."</TD>
<TD class='field_center'>".$_SESSION['site309_array'][$i]['bariera']."</TD>
<TD class='field_center'>".$_SESSION['site309_array'][$i]['rodzaj']."</TD>
<TD class='field_center'>".$_SESSION['site309_array'][$i]['status']."</TD>
<TD class='field_center'>".$_SESSION['site309_array'][$i]['typ']."</TD>
<TD class='field_center'>".$_SESSION['site309_array'][$i]['ster']."</TD>
</TR>
";
}
?>
</table>
<table style="width:100%; background-color: #f5f5f5">
<tr>
<td style="width: 25%; text-align: left;"><span class="resume">Wyników: <?php echo count($_SESSION['site309_array']); ?></span></td>
<td style="width: 50%; text-align: center;">
<?php
if (count($_SESSION['site309_array'])>20)
echo pagination_grid('?pg=site309', $_GET['pgn'], count($_SESSION['site309_array']));
?>
</td>
<td style="width: 25%; text-align: right;">
<a href="./export/site309_xls.php" target="_blank" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>&nbsp;
<a href="./export/site309_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>&nbsp;
</td>
</tr>
</table>
</div>
<?php
if (!empty($_SESSION['site309_edit']))
echo"
<div class=tag_buttons>
<a href='?pg=site309A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
</div>
";
?>
</div>
<?php
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>