321 lines
14 KiB
PHP
321 lines
14 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site401']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
if (empty($_SESSION['well_details']))
|
|
header("Location: /?pg=site401");
|
|
?>
|
|
|
|
|
|
<?php
|
|
if ($_POST['subWellParamSave']==$lab_ButtonName_Save)
|
|
{
|
|
$_GET['dev'] = $_POST['dev'];
|
|
// $_GET['dic'] = $_POST['dic'];
|
|
|
|
mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=".$_POST['dic'].",DRD_VALUE='".str_replace(',','.',$_POST['inWellParamValue'])."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE='".$_POST['inWellParamDate']." ".date('H:i:s')."';");
|
|
echo"<div class='actionOK'>$lab_Field_site803_013</div>";
|
|
}
|
|
|
|
//updateWellTimeWorking($_GET['dev']);
|
|
?>
|
|
|
|
|
|
|
|
<?php
|
|
//kasuje daty w histori pomiarów
|
|
unset($_SESSION['site401ahis_from']);
|
|
unset($_SESSION['site401ahis_to']);
|
|
unset($_SESSION['site401ahis_array']);
|
|
|
|
require_once('./polynomial/PolynomialRegression.php' );
|
|
|
|
if ($_SESSION['lang']=='polish')
|
|
$imgSPM = sqlStringValue("select DIC_NAME from sys_dictionaries where DIC_ID=(select WLL_CAT_DIC_ID from seg_wells where WLL_ID=".$_SESSION['well_details']['wellID'].")","DIC_NAME")."_polish.png";
|
|
else
|
|
$imgSPM = sqlStringValue("select DIC_NAME from sys_dictionaries where DIC_ID=(select WLL_CAT_DIC_ID from seg_wells where WLL_ID=".$_SESSION['well_details']['wellID'].")","DIC_NAME")."_english.png";
|
|
|
|
|
|
?>
|
|
|
|
|
|
|
|
<div class="tag50_left">
|
|
|
|
<div class="head_tag"><?php echo $lab_Tag_site301_005 ;?></div>
|
|
<div class="tag">
|
|
<TABLE class="desc_val">
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_002; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $_SESSION['well_details']['pumpName']; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_003; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $_SESSION['well_details']['pumpSN']; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_004; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $_SESSION['well_details']['engName']; ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_005; ?></TD>
|
|
<TD CLASS="desc_value"><?php echo $_SESSION['well_details']['engSN']; ?></TD>
|
|
|
|
<!--
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_well_param"><img src=./images/pdf_ico.png></TD>
|
|
<TD CLASS="desc_value"><a class='knowledge' href='./charts/GC_5_07_tests.pdf' target='_blank'><?php echo $lab_Field_site401_019; ?></a></TD>
|
|
</TR>
|
|
-->
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<?php
|
|
if ($_SESSION['lang'] == 'polish') $decFieldLang = 'DIC_POL_LANG';
|
|
else if ($_SESSION['lang'] == 'english') $decFieldLang = 'DIC_ENG_LANG';
|
|
else if ($_SESSION['lang'] == 'german') $decFieldLang = 'DIC_GER_LANG';
|
|
?>
|
|
|
|
|
|
<div class="head_tag"><?php echo $lab_Tag_site301_006 ;?></div>
|
|
<div class="tag">
|
|
<TABLE class="desc_val">
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_016; ?></TD>
|
|
<TD CLASS="desc_value" colspan="2"><?php echo $_SESSION['well_details']['wellName']; ?></TD>
|
|
</TR>
|
|
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_017; ?></TD>
|
|
<TD CLASS="desc_value" colspan="2"><?php echo sqlStringValue("select DIC_ENG_LANG from sys_dictionaries where DIC_ID=(select WLL_CAT_DIC_ID from seg_wells where WLL_ID=".$_SESSION['well_details']['wellID'].")","DIC_ENG_LANG"); ?></TD>
|
|
</TR>
|
|
<TR>
|
|
<TD class="desc_well_param"><?php echo $lab_Field_site301_006; ?></TD>
|
|
<TD CLASS="desc_value" colspan="2"><?php echo sqlStringValue("select DRS_AVAILABLE_DATE from seg_dev_resources where DRS_ID=".$_SESSION['well_details']['devID'], "DRS_AVAILABLE_DATE"); ?></TD>
|
|
</TR>
|
|
|
|
|
|
<?php
|
|
$result = mysql_query("select DIC_ID,DIC_NAME from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' order by DIC_ID");
|
|
if($result)while ($r = mysql_fetch_array($result))
|
|
{
|
|
$var_DIC_ID = $r["DIC_ID"];
|
|
$var_DIC_NAME = $r["DIC_NAME"];
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_well_param'>".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_ID=".$var_DIC_ID,$decFieldLang)."</TD>
|
|
<TD CLASS='desc_value'>".getLinkToShowHistoricalData('WELL_TECHNICAL_PARAMETERS',$var_DIC_NAME,$_SESSION['well_details']['devID'],'site401inf')."</TD>";
|
|
if (!empty($_SESSION['site401_edit']))
|
|
echo"<td CLASS='desc_value' width='5%'><img style='cursor: pointer;' src='./images/edit.png' title='$lab_ButtonName_Modify' onclick=".chr(34)."document.location.href='?pg=site401E&dev=".$_SESSION['well_details']['devID']."&dic=$var_DIC_ID'".chr(34)."></td>";
|
|
|
|
echo"
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
|
|
|
|
<?php
|
|
$result = mysql_query("select DIC_ID,DIC_NAME,DIC_TYPE from sys_dictionaries where DIC_ID in (235,240,285) order by DIC_ID");
|
|
if($result)while ($r = mysql_fetch_array($result))
|
|
{
|
|
$var_DIC_ID = $r["DIC_ID"];
|
|
$var_DIC_NAME = $r["DIC_NAME"];
|
|
$var_DIC_TYPE = $r["DIC_TYPE"];
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_well_param'>".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_ID=".$var_DIC_ID,$decFieldLang)."</TD>
|
|
<TD CLASS='desc_value'>".getLinkToShowHistoricalData($var_DIC_TYPE,$var_DIC_NAME,$_SESSION['well_details']['devID'],'site401inf')."</TD>";
|
|
if (!empty($_SESSION['site401_edit']))
|
|
echo"<td CLASS='desc_value' width='5%'><img style='cursor: pointer;' src='./images/edit.png' title='$lab_ButtonName_Modify' onclick=".chr(34)."document.location.href='?pg=site401E&dev=".$_SESSION['well_details']['devID']."&dic=$var_DIC_ID'".chr(34)."></td>";
|
|
|
|
echo"
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
|
|
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<div class="head_tag">
|
|
|
|
<div style="display:inline-block; font-size: 14px; color: #ffffff;"><?php echo $lab_Tag_site401_002 ;?></div>
|
|
<?php if (!empty($_SESSION['site401_edit'])): ?>
|
|
<div style="display:inline-block; float:right; padding-right: 5px;" id="imgEditAction"><img style='cursor: pointer;' src='./images/edit.png' title='<?php echo $lab_ButtonName_Modify;?>'></div>
|
|
<div style="display:inline-block; float:right; padding-right: 5px;" id="imgSaveAction"><img style='cursor: pointer;' src='./images/save-icon.png' title='<?php echo $lab_Field_site803_011;?>'></div>
|
|
<input type="hidden" id="inDevID" value="<?php echo $_GET['dev'];?>">
|
|
<?php endif; ?>
|
|
|
|
|
|
</div>
|
|
<div class="tag">
|
|
<TABLE class="desc_val">
|
|
<?php
|
|
$result = mysql_query("select DIC_ID,DIC_NAME from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_ID<>235 and DIC_ID<>240 order by DIC_ID");
|
|
if($result)while ($r = mysql_fetch_array($result))
|
|
{
|
|
$var_DIC_ID = $r["DIC_ID"];
|
|
$var_DIC_NAME = $r["DIC_NAME"];
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_well_param'>".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='$var_DIC_NAME'",$decFieldLang)."</TD>";
|
|
|
|
if ($_SESSION['well_details']['turnOnOff']=='OFF' && ($var_DIC_ID==200 || $var_DIC_ID==205))
|
|
echo"<TD class='desc_value'></TD>";
|
|
elseif ($_SESSION['well_details']['turnOnOff']=='ON' && $var_DIC_ID==210)
|
|
echo"<TD class='desc_value'></TD>";
|
|
else
|
|
echo"<TD class='desc_value'><input class='readonly_hide' type='text' value='".getLastValueFromDevResourceDetail('WELL_PARAMETERS',$var_DIC_NAME,$_SESSION['well_details']['devID'],'site401inf')."' id='in401_".$var_DIC_ID."' disabled></TD>";
|
|
|
|
echo"</TR>";
|
|
}
|
|
?>
|
|
<TR><TD COLSPAN="3" CLASS="desc_value"><HR ></TD></TR>
|
|
<?php
|
|
$result = mysql_query("select DIC_ID,DIC_NAME from sys_dictionaries where DIC_TYPE='WELL_ELECTRICAL_PARAMETERS' and DIC_ID<>285 order by DIC_ID");
|
|
if($result)while ($r = mysql_fetch_array($result))
|
|
{
|
|
$var_DIC_ID = $r["DIC_ID"];
|
|
$var_DIC_NAME = $r["DIC_NAME"];
|
|
echo"
|
|
<TR>
|
|
<TD class='desc_well_param'>".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='WELL_ELECTRICAL_PARAMETERS' and DIC_NAME='$var_DIC_NAME'",$decFieldLang)."</TD>";
|
|
|
|
if ($_SESSION['well_details']['turnOnOff']=='OFF' && ($var_DIC_ID==260 || $var_DIC_ID==270))
|
|
echo"<TD class='desc_value'></TD>";
|
|
else
|
|
echo"<TD class='desc_value'><input class='readonly_hide' type='text' value='".getLastValueFromDevResourceDetail('WELL_ELECTRICAL_PARAMETERS',$var_DIC_NAME,$_SESSION['well_details']['devID'],'site401inf')."' id='in401_".$var_DIC_ID."' disabled></TD>";
|
|
|
|
echo"</TR>";
|
|
}
|
|
?>
|
|
|
|
|
|
</table>
|
|
</div>
|
|
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
//tworzy nazwę pliku rysunku jaki ma podstawić w zalezności od stanu pompy (Throt i Loss)
|
|
if (strlen($imgThrot)>0 && strlen($imgLoss)>0)
|
|
$imgSPM = "./images/".$imgThrot."".$imgLoss."_".$imgSPM;
|
|
else $imgSPM = "./images/".$imgSPM;
|
|
?>
|
|
|
|
|
|
<div class="tag50_right">
|
|
|
|
<div class="head_tag">Studnia</div>
|
|
<div class="tag_WellName">
|
|
<?php echo $_SESSION['well_details']['wellName']; ?>
|
|
</div>
|
|
|
|
<div class="head_tag"><?php echo $lab_Tag_site301_004 ;?></div>
|
|
<div class="tag_center">
|
|
<img SRC="<?php echo $imgSPM; ?>" >
|
|
</div>
|
|
|
|
|
|
<div class="head_tag"><?php echo $lab_Tag_site401_008 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<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"></TD>
|
|
|
|
</TR>
|
|
|
|
<?php
|
|
$wynik = mysql_query("select SRP_ID,SRP_NAME,DRS_BUY_DATE,DRS_STATUS_DIC_ID, MCF_NAME,DRS_ID from seg_res_piezo_wells_rel left join seg_dev_resources on RPW_RP_DRS_ID =DRS_ID and DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='RESERVOIR') left join seg_reservoirs_piezometers on DRS_DEV_ID=SRP_ID left join seg_manufacturers on SRP_MCF_ID=MCF_ID where RPW_WELL_DRS_ID=".$_SESSION['well_details']['devID']);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_1 = $r["SRP_ID"];
|
|
$sql_2 = $r["SRP_NAME"];
|
|
$sql_3 = $r["DRS_BUY_DATE"];
|
|
$sql_4 = $r["MCF_NAME"];
|
|
$sql_5 = $r["DRS_STATUS_DIC_ID"];$sql_5=setDicName($sql_5);
|
|
$sql_DRSid = $r["DRS_ID"];
|
|
|
|
|
|
|
|
$maxAcc = getLastValueFromDevResourceDetail('RESERVOIR_PIEZOMETER_WATER_LEVEL','MAX_ACCEPTABLE',$sql_DRSid);
|
|
$maxWar = getLastValueFromDevResourceDetail('RESERVOIR_PIEZOMETER_WATER_LEVEL','MAX_WARNING',$sql_DRSid);
|
|
$minWar = getLastValueFromDevResourceDetail('RESERVOIR_PIEZOMETER_WATER_LEVEL','MIN_WARNING',$sql_DRSid);
|
|
$minAcc = getLastValueFromDevResourceDetail('RESERVOIR_PIEZOMETER_WATER_LEVEL','MIN_ACCEPTABLE',$sql_DRSid);
|
|
$waterLevel = getLastValueFromDevResourceDetail('RESERVOIR_PIEZOMETER_PARAMETERS','WATER_LEVEL',$sql_DRSid);
|
|
|
|
if ($waterLevel<=$minAcc || $waterLevel>=$maxAcc)
|
|
$image_zb = "<img src='./images/redRes_mini.png'>";
|
|
else if (($waterLevel>$minAcc && $waterLevel<=$minWar) || ($waterLevel>=$maxWar && $waterLevel<$maxAcc))
|
|
$image_zb = "<img src='./images/yellowRes_mini.png'>";
|
|
else
|
|
$image_zb = "<img src='./images/greenRes_mini.png'>";
|
|
|
|
|
|
|
|
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site402inf&dev=$sql_DRSid'".chr(34).">
|
|
<TD class='field_left'>$sql_2</TD>
|
|
<TD class='field_left'>$sql_4</TD>
|
|
<TD class='field_center'>$sql_3</TD>
|
|
<TD class='field_center'>$image_zb</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<div class=tag_ChemicalButtons>
|
|
<a href='?pg=site401mark&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Ocena pracy układu'></A>
|
|
|
|
<a href='?pg=site401CL&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Kalibracja'></A>
|
|
|
|
<br/><br/>
|
|
<a href='?pg=site401mhis&dev<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Historia ocen'></A>
|
|
|
|
<a href='?pg=site401ahis&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Historia pomiarów'></A>
|
|
|
|
<br/><br/>
|
|
<a href='?pg=site401CH&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Parametry chemiczne'></A>
|
|
|
|
<a href='?pg=site401HP&dev=<?php echo $_SESSION['well_details']['devID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Harmonogram płukań'></A>
|
|
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
if (!empty($_GET['dev']) && !empty($_GET['dic']))
|
|
getHistoryData($_GET['dev'], $_GET['dic']);
|
|
?>
|
|
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|
|
|