158 lines
5.7 KiB
PHP
158 lines
5.7 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site406']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
|
|
unset($_SESSION['devID']);
|
|
unset($_SESSION['wellID']);
|
|
unset($_SESSION['DRSpupID']);
|
|
unset($_SESSION['DRSengID']);
|
|
unset($_SESSION['pupID']);
|
|
unset($_SESSION['pupNAME']);
|
|
unset($_SESSION['pupSN']);
|
|
|
|
unset($_SESSION['engID']);
|
|
unset($_SESSION['engNAME']);
|
|
unset($_SESSION['engSN']);
|
|
unset($_SESSION['engVol']);
|
|
unset($_SESSION['wellNAME']);
|
|
unset($_SESSION['rurType']);
|
|
|
|
unset($_SESSION['inNewHD']);
|
|
unset($_SESSION['inNewDR']);
|
|
unset($_SESSION['inNewLP']);
|
|
unset($_SESSION['inNewV']);
|
|
|
|
if (!$_POST['sr_status']) $_POST['sr_status']=3;
|
|
?>
|
|
|
|
<form action="./?pg=site406" method="post">
|
|
<div class="tag100">
|
|
<div class="head_tag">Kreator umożliwia wspomaganie operatora w doborze pompy do układu w studni.</div>
|
|
<div class="tag">
|
|
<div class="steps">
|
|
<img src="./images/ps_step_1.png" border="0" usemap="#selection">
|
|
<map name="selection">
|
|
<area shape="circle" coords="19,19,19" href="?pg=site406">
|
|
</map>
|
|
</div>
|
|
<table>
|
|
<tr>
|
|
<td style="width: 10px;"></td>
|
|
<td>Studnia:</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="text" name="sr_well" value="<?php echo $_POST['sr_well'];?>"></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> </td></tr>
|
|
<tr>
|
|
<td style="width: 10px;"></td>
|
|
<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>
|
|
<br/>
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label"><?php echo $lab_Field_site301_001 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site301_014 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site301_002 ;?></TD>
|
|
<TD class="label"><?php echo $lab_Field_site301_003 ;?></TD>
|
|
|
|
<td class="label">Q<sub>n</sub> [m<sup>3</sup>/min]</td>
|
|
|
|
<TD class="label"><?php echo $lab_Field_site301_004 ;?></TD>
|
|
<td class="label"><?php echo $lab_Field_site301_005 ;?></td>
|
|
<td class="label"><?php echo $lab_Field_site301_007 ;?></td>
|
|
</TR>
|
|
|
|
<?php
|
|
$query="select seg_dev_resources.DRS_ID,WLL_ID,WLL_NAME,SOD_UJ,WLE_PUMP_NAME,WLE_PUMP_NO,WLE_PUMP_Q_N,WLE_ENG_NAME,WLE_ENG_NO,DRS_STATUS_DIC_ID from rep_object_departments left join seg_dev_resources on seg_dev_resources.DRS_ID=rep_object_departments.DRS_ID where SOD_PLC='".$_SESSION['syndis_eq_stock']."' and WLL_NAME like '%".$_POST['sr_well']."%'";
|
|
if($_POST['sr_status']!=100) $query.=" and DRS_STATUS_DIC_ID=".$_POST['sr_status'];
|
|
$query .= " order by WLL_NAME";
|
|
if (empty($_POST['sr_all'])) $query .= " limit 10";
|
|
|
|
|
|
$wynik = mysql_query($query);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_1 = $r["RWL_WLL_ID"];
|
|
$sql_2 = $r["WLL_NAME"];
|
|
$sql_3 = $r["RWL_PUP_DRS_ID"];
|
|
$sql_4 = $r["RWL_ENG_DRS_ID"];
|
|
$sql_5 = $r["DRS_AVAILABLE_DATE"];
|
|
$sql_6 = $r["DRS_STATUS_DIC_ID"];$sql_6=setDicName($sql_6);
|
|
$sql_DRSid = $r["DRS_ID"];
|
|
|
|
|
|
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site406_2&dev=".$r["DRS_ID"]."'".chr(34).">
|
|
<TD class='field_left'>".$r["WLL_NAME"]."</TD>
|
|
<TD class='field_center'>".$r["SOD_UJ"]."</TD>
|
|
<TD class='field_center'>".$r["WLE_PUMP_NAME"]."</TD>
|
|
<TD class='field_center'>".$r["WLE_PUMP_NO"]."</TD>
|
|
|
|
<TD class='field_center'>".round($r["WLE_PUMP_Q_N"]/60,2)."</TD>
|
|
|
|
<TD class='field_center'>".$r["WLE_ENG_NAME"]."</TD>
|
|
<TD class='field_center'>".$r["WLE_ENG_NO"]."</TD>
|
|
|
|
<TD class='field_center'>".setDicName($r["DRS_STATUS_DIC_ID"])."</TD>
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
</div>
|
|
</form>
|
|
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|