210 lines
12 KiB
PHP
210 lines
12 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site302']))
|
|
{
|
|
?>
|
|
<?php
|
|
|
|
if (!empty($_GET['dev'])) $_GET['dev'] = $_POST['dev'];
|
|
|
|
// Dodawanie nowego zbiornika
|
|
if (!empty($_POST['inRePieName']) && $_POST['subRePieSave']==$lab_ButtonName_Save )
|
|
{
|
|
|
|
mysql_query("INSERT INTO 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='RESERVOIR'),SRP_LATITUDE='".$_POST['inRePieLat']."',SRP_LONGITUDE='".$_POST['inRePieLong']."',SRP_PHONE_NO='".$telok."',SRP_SCOP_GS='".str_replace(',', '.', $_POST['inGS'])."',SRP_SCOP_GZ='".str_replace(',', '.', $_POST['inGZ'])."'");
|
|
$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='RESERVOIR'),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()");
|
|
$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='".str_replace(",",".",$_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=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_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=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_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=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_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=$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()");
|
|
// wysokość zbiornika
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_POST['inRePieHeight'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='HEIGHT'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
|
|
// głębokość zabudowy
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_POST['inGZ'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='RESERVOIR_PIEZOMETER_WATER_LEVEL' and DIC_NAME='PROBE_DEPTH_INSTALLATION'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
|
|
|
|
// dodaje wartość początkową lustra wody dla zbiornika - PUSTY ZERO
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=$maxDRSid,DRD_VALUE='".str_replace(",",".",$_POST['inRePieMinWar'])."',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()");
|
|
|
|
// wpisywanie do bazy - nowych parametrów dla zbiornika
|
|
setReservoirParameters($maxDRSid);
|
|
|
|
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
|
|
}
|
|
|
|
if (!$_POST['sr_status']) $_POST['sr_status']=100;
|
|
?>
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); }
|
|
if ($_POST['sub_search']=='Szukaj') $_SESSION['site302_input'] = $_POST['sr_well'];
|
|
?>
|
|
|
|
<form action="./?pg=site302" method="post">
|
|
<div class="tag100">
|
|
<table>
|
|
<tr>
|
|
<td>Zbiornik:</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="text" name="sr_well" value="<?php echo $_SESSION['site302_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_TYPE='DEV_STATUS'");
|
|
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> </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'> ";
|
|
|
|
echo $lab_Field_site203_022;
|
|
?>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
</div>
|
|
</form>
|
|
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site302_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Lp.</TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_002 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_003 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site302_004 ;?></TD>
|
|
|
|
</TR>
|
|
|
|
<?php
|
|
if (empty($_SESSION['site302_array']) || $_POST['sub_search']=='Szukaj')
|
|
{
|
|
if (!empty($_POST['sr_well']))
|
|
{
|
|
$query="select SRP_ID,SRP_NAME,DRS_BUY_DATE,DRS_STATUS_DIC_ID, MCF_NAME,DRS_ID from seg_dev_resources,seg_reservoirs_piezometers left join seg_manufacturers on SRP_MCF_ID=MCF_ID where DRS_DEV_TYPE=600 and DRS_DEV_ID=SRP_ID 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 50";
|
|
}
|
|
else
|
|
{
|
|
$query="select SRP_ID,SRP_NAME,DRS_BUY_DATE,DRS_STATUS_DIC_ID, MCF_NAME,DRS_ID from seg_dev_resources,seg_reservoirs_piezometers left join seg_manufacturers on SRP_MCF_ID=MCF_ID where DRS_DEV_TYPE=600 and DRS_DEV_ID=SRP_ID";
|
|
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 50";
|
|
}
|
|
|
|
$res=null;
|
|
$wynik = mysql_query($query);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$res[]=array(
|
|
'devID' => $r["DRS_ID"],
|
|
'resID' => $r["SRP_ID"],
|
|
'resName'=> $r["SRP_NAME"],
|
|
'mcfName' => $r["MCF_NAME"],
|
|
'buyDate' => $r["DRS_BUY_DATE"],
|
|
'avaDate' => $r["DRS_AVAILABLE_DATE"],
|
|
'stat' => setDicName($r["DRS_STATUS_DIC_ID"]),
|
|
'res' => setDicName($r["DRS_RESOURCES_DIC_ID"])
|
|
);
|
|
}
|
|
unset($_SESSION['site302_array']);
|
|
$_SESSION['site302_array']=$res;
|
|
}
|
|
|
|
|
|
$start=($_GET['pgn']-1)*20;
|
|
$stop = $_GET['pgn']*20;
|
|
if ($stop>count($_SESSION['site302_array'])) $stop=count($_SESSION['site302_array']);
|
|
|
|
for($i=$start;$i<$stop;$i++)
|
|
{
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site302inf&dev=".$_SESSION['site302_array'][$i]['devID']."'".chr(34).">
|
|
<TD class='field_left'>".($i+1).".</TD>
|
|
<TD class='field_left'>".$_SESSION['site302_array'][$i]['resName']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site302_array'][$i]['mcfName']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site302_array'][$i]['buyDate']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site302_array'][$i]['stat']."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
<table style="width:100%; background-color: #f5f5f5">
|
|
<tr>
|
|
<td style="width: 25%; text-align: left;"><span class="resume"><?php echo $lab_NumberResults_001.": ".count($_SESSION['site302_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site302_array'])>20)
|
|
echo pagination_grid('?pg=site302', $_GET['pgn'], count($_SESSION['site302_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
<a href="./export/site302_xls.php" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<a href="./export/site302_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site302_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site302A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|