kopalnia_2014/sites/site406_2.php

<?php
if (!empty($_SESSION['site406']))
{
?>

<?php
    if (empty($_GET['dev'])) $_GET['dev']=$_SESSION['devID'];


    $wynik = mysql_query("select DRS_ID,RWL_WLL_ID,RWL_PUP_DRS_ID,RWL_ENG_DRS_ID from seg_dev_resources left join seg_well_pump_eng_rel on RWL_WLL_ID=DRS_DEV_ID where DRS_ID=".$_GET['dev']);
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
        $_SESSION['devID'] = $r["DRS_ID"];
        $_SESSION['wellID'] = $r["RWL_WLL_ID"];
        $_SESSION['DRSpupID'] = $r["RWL_PUP_DRS_ID"];
        $_SESSION['DRSengID'] = $r["RWL_ENG_DRS_ID"];
    }

    $wynik = mysql_query("select DRS_DEV_ID,DRS_SN_NUMBER,PUP_NAME from seg_dev_resources left join seg_pumps on PUP_ID=DRS_DEV_ID where DRS_ID=".$_SESSION['DRSpupID']);
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
        $_SESSION['pupID'] = $r["DRS_DEV_ID"];
        $_SESSION['pupNAME'] = $r["PUP_NAME"];
        $_SESSION['pupSN'] = $r["DRS_SN_NUMBER"];
    }
    $wynik = mysql_query("select DRS_DEV_ID,DRS_SN_NUMBER,ENG_NAME,ENG_VOLTAGE from seg_dev_resources left join seg_engines on DRS_DEV_ID=ENG_ID where DRS_ID=".$_SESSION['DRSengID']);
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
        $_SESSION['engID'] = $r["DRS_DEV_ID"];
        $_SESSION['engNAME'] = $r["ENG_NAME"];
        $_SESSION['engSN'] = $r["DRS_SN_NUMBER"];
        $_SESSION['engVol'] = $r["ENG_VOLTAGE"];
    }

    $_SESSION['wellNAME'] = sqlValue("select WLL_NAME from seg_wells where WLL_ID=".$_SESSION['wellID']);




?>

<form action="./?pg=site406_3" 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_2.png"  border="0" usemap="#selection">
          <map name="selection">
              <area shape="circle" coords="19,19,19" href="?pg=site406">
          </map>
      </div>

      <TABLE class="desc_val">
          <TR>
              <TD class="desc">Studnia</TD>
              <TD CLASS="desc_value"><?php echo$_SESSION['wellNAME']; ?></TD>
          </TR>
          <TR>
              <TD class="desc">Typ pompy</TD>
              <TD CLASS="desc_value"><?php echo $_SESSION['pupNAME']; ?></TD>
          </TR>
          <TR>
              <TD class="desc">Numer pompy</TD>
              <TD CLASS="desc_value"><?php echo $_SESSION['pupSN']; ?></TD>
          </TR>
          <TR>
              <TD class="desc">Typ silnika</TD>
              <TD CLASS="desc_value"><?php echo $_SESSION['engNAME']; ?></TD>
          </TR>
          <TR>
              <TD class="desc">Numer silnika</TD>
              <TD CLASS="desc_value"><?php echo $_SESSION['engSN']; ?></TD>
          </TR>

          <TR>
              <TD class="desc">Data zabudowy</TD>
              <TD CLASS="desc_value"><?php echo sqlStringValue("select DRS_AVAILABLE_DATE from seg_dev_resources where DRS_ID=".$_SESSION['devID'], "DRS_AVAILABLE_DATE"); ?></TD>
          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='LS'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_TECHNICAL_PARAMETERS","LS",$_SESSION['devID']),2) ; ?></TD>


          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_TECHNICAL_PARAMETERS' and DIC_NAME='DST'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_TECHNICAL_PARAMETERS","DST",$_SESSION['devID']),2) ; ?></TD>
          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='DR'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_PARAMETERS","DR",$_SESSION['devID']),2) ; ?></TD>
          </TR>
          <TR>
              <TD class="desc">Rodzaj rurociągu</TD>
              <TD CLASS="desc_value"><?php selectFromDictionary('inRurType','PIPELINE_TYPE',727); ?></TD>
          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='P1M'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_PARAMETERS","P1M",$_SESSION['devID']),2); ?></TD>
          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='P2M'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_PARAMETERS","P2M",$_SESSION['devID']),2); ?></TD>
          </TR>


          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='HDM'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_PARAMETERS","HDM",$_SESSION['devID']),2); ?></TD>
          </TR>
          <TR>
              <TD class="desc"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='HSTM'","DIC_POL_LANG") ; ?></TD>
              <TD CLASS="desc_value"><?php echo round(getLastValueFromDevResourceDetail("WELL_PARAMETERS","HSTM",$_SESSION['devID']),2); ?></TD>
          </TR>


      </TABLE>





  </div>

    <?php
    if (!empty($_SESSION['site406']))
        echo"
            <div class=tag_buttons>
                <INPUT class='btn btn-success btn-sm' TYPE='submit' name='subStep2' VALUE='$lab_ButtonName_Next'>
            </div>
        ";
    ?>

</div>
</form>



<?php
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>