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


<?php
if(!empty($_POST['dev'])) $_GET['dev'] = $_POST['dev'];

//Aktualizacja danych
// ========================================================================================================
if ($_POST['dev']>0 && $_POST['subEquipSave']==$lab_ButtonName_Update)
{
    $query = "update seg_dev_resources SET DRS_AUDIT_DATE=now()";
    if (strlen($_POST['inEquipSN'])>0) $query .=" ,DRS_SN_NUMBER='".$_POST['inEquipSN']."'";
    if (strlen($_POST['inEquipBuyDate'])>0) $query .=" ,DRS_BUY_DATE='".$_POST['inEquipBuyDate']."'";
    if (strlen($_POST['inEquipDevRes'])>0) $query .=" ,DRS_RESOURCES_DIC_ID=".$_POST['inEquipDevRes'];
    if (strlen($_POST['inEquipAtt'])>0) $query .=" ,DRS_DEV_ATTENTION='".$_POST['inEquipAtt']."'";
    $query .=",DRS_AUDIT_USR='".$_SESSION['user']."' where DRS_ID=".$_POST['dev'];
    mysql_query($query);

    if (strlen($_POST['inEquipEST'])>0)
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'),DRD_VALUE='".$_POST['inEquipEST']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
    if (strlen($_POST['inEquipSCOPE'])>0)
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='SCOPE'),DRD_VALUE='".$_POST['inEquipSCOPE']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");

    //dla sondy SGP-21
    // ===================================================================
    //sprawdza, czy jest przypisana studnia do sondy
    if (strlen($_POST['inSCOPE_PP'])>0 || strlen($_POST['inSCOPE_HH'])>0)
        $tpmWellID = sqlStringValue("select DRS_DEV_ID from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$_POST['dev'],"DRS_DEV_ID");

    if (strlen($_POST['inSCOPE_PP'])>0)
    {
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='SGP_21_PP'),DRD_VALUE='".$_POST['inSCOPE_PP']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
        mysql_query("UPDATE seg_wells SET WLL_PP_SCOPE='".$_POST['inSCOPE_PP']."' WHERE WLL_ID=".$tpmWellID);

    }
    if (strlen($_POST['inSCOPE_HH'])>0)
    {
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='SGP_21_HH'),DRD_VALUE='".$_POST['inSCOPE_HH']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
        mysql_query("UPDATE seg_wells SET WLL_HH_SCOPE='".$_POST['inSCOPE_HH']."' WHERE WLL_ID=".$tpmWellID);
    }

    if (strlen($_POST['inWire'])>0)
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='SG_P_21_WIRE'),DRD_VALUE='".$_POST['inWire']."',DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
    // ===================================================================

    mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_POST['dev']);
}
// ========================================================================================================


$wynik = mysql_query("select DRS_ID,EQU_ID,DRS_SN_NUMBER,DRS_BUY_DATE,EQU_NAME,MCF_NAME,EQU_DESCRIPTION from seg_dev_resources left join seg_equipments on DRS_DEV_ID=EQU_ID left join seg_manufacturers on EQU_MCF_ID=MCF_ID where DRS_ID=".$_GET['dev']);
if($wynik)while ($r = mysql_fetch_array($wynik))
  {
  	$sql_1 = $r["EQU_ID"];
  	$sql_2 = $r["EQU_NAME"];
  	$sql_3 = $r["EQU_DESCRIPTION"]; $sql_3= str_replace(".", ",", $sql_3);
    $sql_4 = $r["MCF_NAME"];
    $sql_DRSid = $r["DRS_ID"];
    $sql_SNo = $r["DRS_SN_NUMBER"];
    $sql_BuyDate = $r["DRS_BUY_DATE"];
  }
?>


<div class="tag50_left">
  <div class="head_tag"><?php echo $lab_Tag_site208_002 ;?></div>
  <div class="tag">
  	   <TABLE class="desc_val">
  		<TR>
			<TD class="desc_equipment"><?php echo $lab_Field_site802_001; ?></TD>
			<TD CLASS="desc_value"><?php echo $sql_2; ?></TD>
		</TR> 
  		<TR>
			<TD class="desc_equipment"><?php echo $lab_Field_site206_002; ?></TD>
			<TD CLASS="desc_value"><?php echo $sql_4; ?></TD>
		</TR>
        <TR>
            <TD class="desc_equipment"><?php echo $lab_Field_site206_003; ?></TD>
            <TD CLASS="desc_value"><?php echo str_replace(chr(13), "<br/>", $sql_3); ?></TD>
        </TR>
        <TR>
            <TD class="desc_equipment"><?php echo $lab_Field_site303_001; ?></TD>
            <TD CLASS="desc_value"><?php echo $sql_SNo; ?></TD>
        </TR>
        <TR>
            <TD class="desc_equipment"><?php echo $lab_Field_site303_013; ?></TD>
            <TD CLASS="desc_value"><?php echo getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','ASSET',$sql_DRSid); ?></TD>
        </TR>
        <TR>
            <TD class="desc_equipment"><?php echo $lab_Field_site303_002; ?></TD>
            <TD CLASS="desc_value"><?php echo $sql_BuyDate; ?></TD>
        </TR>


         <?php
           if (strstr($sql_2,"SGP"))
           {
               echo"
                    <TR>
                         <TD class='desc_equipment'>".$lab_Field_site303_015."</TD>
                         <TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SGP_21_PP',$sql_DRSid)."</TD>
                    </TR>
                    <TR>
                         <TD class='desc_equipment'>".$lab_Field_site303_016."</TD>
                         <TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SGP_21_HH',$sql_DRSid)."</TD>
                    </TR>
                ";

           }
            else
            {
                echo"
                    <TR>
                         <TD class='desc_equipment'>".$lab_Field_site303_014."</TD>
                         <TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SCOPE',$sql_DRSid)."</TD>
                    </TR>
                ";
            }


         if (strstr($sql_2,"SGP") || strstr($sql_2,"SG") || strstr($sql_2,"PA"))
         {
             echo"
                    <TR>
                         <TD class='desc_equipment'>".$lab_Field_site303_017."</TD>
                         <TD CLASS='desc_value'>".getLastValueFromDevResourceDetail('DEV_RESOURCES_DETAIL','SG_P_21_WIRE',$sql_DRSid)."</TD>
                    </TR>
                ";

         }


         ?>


           <?php
           if (sqlValue("select count(1) from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('application') and EQF_EQU_ID=$sql_1")>0)
           {
               echo"
               <TR>
                <TD class='desc'>$lab_Field_site206_004</TD>
                <TD CLASS='desc_value'>";
                   $wynik = mysql_query("select EQF_ID,SUBSTRING_INDEX(EQF_FILE_NAME, '.', -1) ICO,EQF_FILE_NAME from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('application') and EQF_EQU_ID=$sql_1");
                   if($wynik)while ($r = mysql_fetch_array($wynik))
                   {
                       $eq_1 = $r["EQF_ID"];
                       $vICO = $r["ICO"];
                       $eq_2 = $r["EQF_FILE_NAME"];

                       if ($vICO=='pdf') $icoFile = './images/pdf_ico.png';
                       else if ($vICO=='doc' || $vICO=='docx') $icoFile = './images/word_ico.png';
                       else if ($vICO=='xls' || $vICO=='xlsx') $icoFile = './images/excel_ico.png';
                       else if ($vICO=='ppt' || $vICO=='pptx' || $vICO=='pps' || $vICO=='ppsx') $icoFile = './images/ppoint_ico.png';
                       else if ($vICO=='jpg' || $vICO=='png' || $vICO=='bmp' || $vICO=='jpeg' || $vICO=='gif' || $vICO=='jfif' || $vICO=='tiff' || $vICO=='dib') $icoFile = './images/photo_ico.png';
                       else if ($vICO=='mpg' || $vICO=='divx' || $vICO=='avi' || $vICO=='mp3'  || $vICO=='mp4'  || $vICO=='mov') $icoFile = './images/divx_ico.png';
                       else $icoFile = './images/file_ico.png';

                       echo"<img src=$icoFile><a class='knowledge' href='./sites/eqdocgeneratefromdb.php?fno=$eq_1' target='_blank'>$eq_2</a><br/>";
                   }


                echo"</TD>
               </TR>


               ";

           }

           ?>
       </table>
  </div>


    <?php
    $wynik = mysql_query("select DRS_DEV_ID,DRS_DEV_TYPE,SDE_DRS_DEV_ID from seg_dev_equipments_rel left join seg_dev_resources on DRS_ID=SDE_DRS_DEV_ID where SDE_DRS_EQU_ID=".$sql_DRSid);
    if($wynik)while ($r = mysql_fetch_array($wynik))
    {
        $obID = $r["DRS_DEV_ID"];
        $obTYPE = $r["DRS_DEV_TYPE"];
        $obDrsIS = $r["SDE_DRS_DEV_ID"];

    }

    if ($obTYPE==12)
        $obNAME = sqlStringValue("select WLL_NAME from seg_wells where WLL_ID=".$obID,"WLL_NAME");
    else
        $obNAME = sqlStringValue("select SRP_NAME from seg_reservoirs_piezometers where SRP_ID=".$obID,"SRP_NAME");

    if (strlen($obNAME)==0) $obNAME="Brak powiązanego obiektu";

    ?>


    <div class="head_tag"> <?php echo $lab_Tag_site308_005 ;?></div>
    <div class="tag">
        <TABLE class="desc_val">
            <TR>
                <TD class="desc_equipment"><?php echo sqlStringValue("select DIC_POL_LANG from sys_dictionaries where DIC_ID=".$obTYPE,"DIC_POL_LANG"); ?></TD>

                <?php
                if ($obTYPE==12)
                    echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site401mark&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
                else if ($obTYPE==600)
                    echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site402inf&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
                else if ($obTYPE==601)
                    echo"<td STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site404inf&dev=$obDrsIS'".chr(34)." CLASS='desc_value'>$obNAME</td>";
                else
                    echo"<td CLASS='desc_value'>$obNAME</td>";
                ?>


            </TR>
        </TABLE>
    </div>


</div>


<div class="tag50_right">

  <div class="head_tag"><?php echo $lab_Field_site206_005 ;?></div>
  <div class="tag_center">

		<?php
			  $wynik = mysql_query("select EQF_FILE_TYPE,EQF_FILE from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('image') and EQF_EQU_ID=$sql_1");
			  if($wynik)while ($r = mysql_fetch_array($wynik))
			  	{
				 	$param_1 = $r["EQF_FILE_TYPE"];
				 	$param_2 = $r["EQF_FILE"];

                    $im = imagecreatefromstring($param_2);
                    $fileName="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_chart_308inf_01.png";
                    imagePNG( $im,$fileName);
                    list($width, $height) = getimagesize($fileName);
                    if ($width>450)
                        echo"<img src='$fileName' width='450'>";
                    else
                        echo"<img src='$fileName'>";

                    //$imgData = base64_encode($param_2);
                    //$src = 'data: $param_1;base64,'.$imgData;
                    //echo"<img src='$src' >";
				}
		?>
  </div>
</div>


<div class="tag50_left">
  <div class="tag_buttons" style="text-align: left;">
	  <button type="button" class="btn btn-default btn-sm" onclick="window.print();">Drukuj</button>  
  </div>
</div>


<div class="tag50_right">
  <div class="tag_buttons">
      <?php echo "<a href=?pg=site308>"; ?><INPUT class='btn btn-info btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Back; ?>"></A>

      <?php if (!empty($_SESSION['site308_edit'])) { ?>
      <a href="?pg=site308&dev=<?php echo $_GET['dev']; ?>&act=del" onclick="return confirm('Jesteś pewien, że chcesz usunąć?');"><INPUT class='btn btn-danger btn-sm' TYPE='BUTTON' VALUE='<?php echo$lab_ButtonName_Delete; ?>'></a>
      <?php echo "<a href=?pg=site308E&eq=".$_GET['dev'].">"; ?><INPUT class='btn btn-success btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Modify; ?>"></A>
      <?php  } ?>

  </div>
</div>


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