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

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

    //dodaje opomiarowanie
    //=========================================================
    if ($_GET['up']>0 && $_GET['acc']=='add' && sqlValue("select count(1) from seg_dev_equipments_rel where SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_DRS_EQU_ID=".$_GET['up']." and SDE_TYPE=14")==0)
    {
    mysql_query("INSERT INTO seg_dev_equipments_rel SET SDE_TYPE=14,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_GET['up']);
    mysql_query("INSERT INTO seg_dev_equipments_rel_his SET SDE_TYPE=14,SDE_DRS_DEV_ID=".$_GET['dev'].",SDE_DRS_EQU_ID=".$_GET['up'].",SDE_AUDIT_CU='".$_SESSION['user']."',SDE_AUDIT_CD=now()");
    mysql_query("UPDATE seg_dev_resources SET DRS_RESOURCES_DIC_ID=3 WHERE DRS_ID=".$_GET['up']);
    mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_GET['up']);
    }
    //usuwa opomiarowanie
    if ($_GET['up']>0 && $_GET['acc']=='del' && $_GET['tp']==14)
    {
    mysql_query("DELETE FROM seg_dev_equipments_rel WHERE SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_TYPE=14 and SDE_DRS_EQU_ID=".$_GET['up']);
    mysql_query("UPDATE seg_dev_equipments_rel_his SET SDE_AUDIT_DU='".$_SESSION['user']."',SDE_AUDIT_DD=now() WHERE SDE_DRS_DEV_ID=".$_GET['dev']." and SDE_TYPE=14 and SDE_DRS_EQU_ID=".$_GET['up']);
    mysql_query("UPDATE seg_dev_resources SET DRS_RESOURCES_DIC_ID=2 WHERE DRS_ID=".$_GET['up']);
    mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_GET['up']);
    }
    //=========================================================


//delSearchSessionData();
?>


    <?php
    // aktualizacja pierometru
    if (!empty($_POST['inRePieName']) && $_POST['subRePieUpdate']==$lab_ButtonName_Update)
    {
        $ujName = sqlStringValue("select SWI_NAME from seg_water_intakes where SWI_ID=".$_POST['inPieBariera'],"SWI_NAME");

        mysql_query("update seg_reservoirs_piezometers SET SRP_SWI_ID=".$_POST['inPieBariera'].",SRP_BARIERA='".$ujName."',SRP_LATITUDE='".$_POST['inRePieLat']."',SRP_LONGITUDE='".$_POST['inRePieLong']."',SRP_SYS_TYPE='".$_POST['inPieSysType']."',SRP_STAT_DESC='".$_POST['inPieDesc']."',SRP_MCF_ID=".$_POST['inRePieStering']." where SRP_ID=".$_POST['sprid']);

        mysql_query("UPDATE seg_object_hole_cards SET OHC_UJ='".$ujName."',OHC_DL_GEOGR='".$_POST['inRePieLat']."',OHC_SZER_GEOGR='".$_POST['inRePieLong']."' WHERE OHC_DRS_ID=".$_POST['dev']);

        mysql_query("update seg_dev_resources SET DRS_SN_NUMBER='".$_POST['inRePieSN']."',DRS_RESOURCES_DIC_ID=".$_POST['inRePieStatus'].",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() where DRS_ID=".$_POST['dev']);
        mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=".$_POST['dev']);

        //poziomy wody - położenie
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieRepair'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='REPAIR_LEVEL'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
//        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieFlUp'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_UP'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
//        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieFlDown'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_DOWN'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");

        // środek trwały
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",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()");

        // głębokość
        //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DEPTH'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
        //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieDepth'])."',DRD_RESOURCES_DETAIL=110,DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
        // średnica
        //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DIAMETER'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");
        //mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inRePieDiameter'])."',DRD_RESOURCES_DETAIL=100,DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");

        // sonda
        mysql_query("INSERT INTO seg_dev_resources_det SET DRD_DRS_ID=".$_POST['dev'].",DRD_VALUE='".str_replace(",",".",$_POST['inSonda'])."',DRD_RESOURCES_DETAIL=(select DIC_ID from sys_dictionaries where DIC_TYPE='WELL_PARAMETERS' and DIC_NAME='LPM'),DRD_AUDIT_USR='".$_SESSION['user']."',DRD_AUDIT_DATE=now()");


        echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";


    }

    ?>


<?php 
// zdjęcie/wprowadzenie do ponownej eksploatacji
if (!empty($_GET['param']))
{
	$paramArray = explode(',', $_GET['param']);
	// wprowadzenie do exploatacji
	
	if ($paramArray[0]==md5($paramArray[1]) && $paramArray[2]=='in' && $_GET['dev']>0)
	{
		mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=3,DRS_RESOURCES_DIC_ID=941 WHERE DRS_ID=".$_GET['dev']);
		mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE=null WHERE OHC_DRS_ID=".$_GET['dev']);

		$id = sqlStringValue("select SRP_ID from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and DRS_ID=".$_GET['dev'], "SRP_ID");
		mysql_query("UPDATE seg_reservoirs_piezometers SET SRP_STAT_DESC=null WHERE SRP_ID=".$id);
		
		echo"<div class='actionOK'>Piezometr został pomyślnie wprowadzony do eksploatacji.</div>";
	}

	if ($paramArray[0]==md5($paramArray[1]) && $paramArray[2]=='out' && $_GET['dev']>0)
	{
		mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=4,DRS_RESOURCES_DIC_ID=942 WHERE DRS_ID=".$_GET['dev']);
		mysql_query("UPDATE seg_object_hole_cards SET OHC_ZDJECIE_EXPL_DATE='".$_POST['inBuildDate']."' WHERE OHC_DRS_ID=".$_GET['dev']);
		
		$id = sqlStringValue("select SRP_ID from seg_reservoirs_piezometers,seg_dev_resources where SRP_ID=DRS_DEV_ID and DRS_DEV_TYPE=601 and DRS_ID=".$_GET['dev'], "SRP_ID");
		mysql_query("UPDATE seg_reservoirs_piezometers SET SRP_STAT_DESC='".$_POST['inBuildReason']."' WHERE SRP_ID=".$id);		
		echo"<div class='actionOK'>Piezometr został pomyślnie zdjęty z eksploatacji.</div>";
	}
	
	
}

?>


<?php
    $_SESSION['site309inf_array'] = sqlGetResAsArray("select DRS_ID,SRP_ID,SRP_NAME,SRP_SWI_ID,SRP_BARIERA,DRS_STATUS_DIC_ID,DRS_RESOURCES_DIC_ID,DRS_SN_NUMBER,SRP_ID,OHC_DL_GEOGR,OHC_SZER_GEOGR,SRP_SYS_TYPE,SRP_STAT_DESC,getLastValue(16,DRS_ID) ASSET,getLastValue(999,DRS_ID) REPAIR_LEVEL,getLastValue(240,DRS_ID) SONDA, SRP_MCF_ID from seg_dev_resources left join seg_reservoirs_piezometers on DRS_DEV_ID=SRP_ID left join seg_object_hole_cards on OHC_DRS_ID=DRS_ID where DRS_ID=".$_GET['dev']);
    //$_SESSION['site309inf_filters'] = sqlGetResAsArray("select CLF_FROM,CLF_TO from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev']);
    $_SESSION['site309inf_filters'] = sqlGetResAsArray("select CLF_FROM,CLF_TO from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev']." and CLF_TO=(select max(CLF_TO) from seg_object_column_filters where CLF_DRS_ID=".$_GET['dev'].") limit 1");    
    $decFieldLang = setDictionaryFieldLanguage($_SESSION['lang']);

    unset($piezDiameter);
    $piezDiameter = getDiameterDepthAsArray($_GET['dev']);
    
?>


<div class="tag50_left">
    <div class="head_tag"><?php echo $lab_Tag_site309_003 ;?></div>
    <div class="tag">
  	   <TABLE class="desc_val">
           <TR>
               <TD class="desc_well_param"><?php echo $lab_Tag_site302_004; ?></TD>
               <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["SRP_NAME"]; ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo $lab_Field_site303_001; ?></TD>
               <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["DRS_SN_NUMBER"]; ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='ASSET'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["ASSET"]; ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DEPTH'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo getGlebokoscAct($_GET['dev']); ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='DEV_RESOURCES_DETAIL' and DIC_NAME='DIAMETER'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo $piezDiameter['diameter']; ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo $lab_Field_site309_001; ?></TD>
               <TD CLASS="desc_value"><?php echo getStringFloatRound($_SESSION['site309inf_array'][0]["SONDA"]); ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='REPAIR_LEVEL'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo getStringFloatRound($_SESSION['site309inf_array'][0]["REPAIR_LEVEL"]); ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_UP'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo getFloatValue($_SESSION['site309inf_filters'][0]["CLF_FROM"])-getSciecie($_GET['dev']); ?></TD>
           </TR>
           <TR>
               <TD class="desc_well_param"><?php echo sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_TYPE='PIEZOMETER_WATER_LEVEL' and DIC_NAME='FILTER_DOWN'", $decFieldLang); ?></TD>
               <TD CLASS="desc_value"><?php echo getFloatValue($_SESSION['site309inf_filters'][0]["CLF_TO"])-getSciecie($_GET['dev']); ?></TD>
           </TR>
       </table>
  </div>

    <div class="head_tag"><?php echo $_SESSION['site309inf_array'][0]["SRP_NAME"] ;?></div>
    <div class="tag">
        <TABLE class="desc_val">

            <TR>
                <TD class="desc_equipment"><?php echo $lab_Field_site301_014; ?></TD>
                <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["SRP_BARIERA"]; ?></TD>
            </TR>

            <TR>
                <TD class="desc_equipment"><?php echo $lab_Field_site301_008; ?></TD>
                <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["OHC_DL_GEOGR"]; ?></TD>
            </TR>
            <TR>
                <TD class="desc_equipment"><?php echo $lab_Field_site301_009; ?></TD>
                <TD CLASS="desc_value"><?php echo $_SESSION['site309inf_array'][0]["OHC_SZER_GEOGR"]; ?></TD>
            </TR>


            <TR>
                <TD class="desc_equipment">Sterowanie</TD>
                <TD CLASS="desc_value" colspan="2"><?php echo setDicName($_SESSION['site309inf_array'][0]["SRP_MCF_ID"]); ?></TD>
            </TR>            


            <TR>
                <TD class="desc_equipment"><?php echo $lab_Tag_site302_003; ?></TD>
                <TD CLASS="desc_value" colspan="2"><?php echo setDicName($_SESSION['site309inf_array'][0]["DRS_RESOURCES_DIC_ID"]); ?></TD>
            </TR>
            
            <TR>
                <TD class="desc_equipment"><?php echo $lab_Field_site301_025; ?></TD>
                <TD CLASS="desc_value" colspan="2"><?php echo $_SESSION['site309inf_array'][0]["SRP_SYS_TYPE"]; ?></TD>
            </TR>

            <TR>
                <TD class="desc_equipment"><?php echo $lab_Field_site802_002; ?></TD>
                <TD CLASS="desc_value" colspan="2"><?php echo $_SESSION['site309inf_array'][0]["SRP_STAT_DESC"]; ?></TD>
            </TR>

        </table>
    </div>


    <div class="head_tag">Powiązane urządzenia pomiarowe</div>
    <div class="tag">
        <table WIDTH="100%" class="tag">
            <TR>
                <TD class="label">Urządzenie</TD>
                <TD class="label">Numer seryjny</TD>
                <?php if (!empty($_SESSION['site309_edit'])) echo"<TD class='label'>&nbsp;</TD>"; ?>
            </TR>

            <?php
            $result = mysql_query("select DRS_ID,EQU_NAME,DRS_SN_NUMBER from seg_dev_equipments_rel left join seg_dev_resources on SDE_DRS_EQU_ID=DRS_ID and DRS_DEV_TYPE=14 left join seg_equipments on DRS_DEV_ID=EQU_ID where SDE_TYPE=14 and SDE_DRS_DEV_ID=".$_SESSION['site309inf_array'][0]["DRS_ID"]);
            if($result)while ($r = mysql_fetch_array($result))
            {
                $var_01 = $r["DRS_ID"];
                $var_02 = $r["EQU_NAME"];
                $var_03 = $r["DRS_SN_NUMBER"];

                echo"
                    <tr>
                        <TD class='field_center'>$var_02 &nbsp;</TD>
                        <TD class='field_center'>$var_03 &nbsp;</TD>";
                if (!empty($_SESSION['site301_edit'])) echo"<TD style='width: 17px;' class='field_right'>

                        <a href=?pg=site309inf&dev=".$_SESSION['site309inf_array'][0]["DRS_ID"]."&up=".$var_01."&tp=14&acc=del onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz usunąć powiązane urządzenie?');".chr(34)."><img src='./images/remove_ico.png'></a></TD>";
                echo"
                    </tr>

                ";
            }
            ?>

            <?php if (!empty($_SESSION['site309_edit']))echo"<tr><td colspan='4' class='field_right'><a href='?pg=site309infApom&dev=".$_SESSION['site309inf_array'][0]["DRS_ID"]."' title='Dodaj'><img src='./images/add_ico.png'></a> </td></tr>"; ?>
        </table>
    </div>


</div>

    <?php
    $fileName1="./charts/".$_SESSION['user']."_".date("Ymd")."_".date("His")."_chart_309inf_01.png";
    generatePiezometer($_GET['dev'], $fileName1);

    ?>


<div class="tag50_right">


    <div class="head_tag"><?php echo $_SESSION['site309inf_array'][0]["SRP_NAME"] ;?></div>
    <div class="tag_center">
        <img SRC="<?php echo $fileName1; ?>" >
    </div>

    <div class=tag_ChemicalButtons>
        <a href='./?pg=site404inf&dev=<?php echo $_GET['dev'];?>&direct=404'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='<?php echo $lab_SubMenu_404; ?>'></A>
        &nbsp;&nbsp;&nbsp;
        <a href='?pg=site310&dev=<?php echo $_SESSION['site309inf_array'][0]['DRS_ID']; ?>'><INPUT class='well_extra_button' TYPE='BUTTON' VALUE='Karta otworu &raquo;'></A>
    </div>


</div>


    <?php if (!empty($_SESSION['site309_edit'])) { ?>
    <div class="tag100">
        <div class="tag_buttons">
            <?php echo "<a href=?pg=site309>"; ?><INPUT class='btn btn-info btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Back; ?>"></A>
            
            <?php 
	            echo"<a href='./?pg=site309&piezo2stu=".$_GET['dev'].",".md5($_GET['dev']).",piezo2stu'  onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz przekształcić piezometr w studnię?');".chr(34)."><INPUT class='btn btn-default btn-sm' style='background-color: #B8860B; color: #ffffff;' TYPE='BUTTON' VALUE='$lab_ButtonName_Operate2Studn'></A> ";
            ?>
            
            
            <?php 
            //zdjęcie/powrót do exploatacji
            if ($_SESSION['site309inf_array'][0]['DRS_STATUS_DIC_ID']==3)
            	echo"<a href='./?pg=site309EXO&dev=".$_SESSION['site309inf_array'][0]['DRS_ID']."'  onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz zdjąć piezometr z eksploatacji?');".chr(34)."><INPUT class='btn btn-danger btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_OperateOut'></A> ";
            elseif ($_SESSION['site309inf_array'][0]['DRS_STATUS_DIC_ID']==4)
           		echo"<a href='./?pg=site309inf&dev=".$_SESSION['site309inf_array'][0]['DRS_ID']."&param=".md5($_SESSION['site309inf_array'][0]['DRS_ID']).",".$_SESSION['site309inf_array'][0]['DRS_ID'].",in'  onclick=".chr(34)."return confirm('Jesteś pewien, że chcesz wprowadzić piezometr do eksploatacji?');".chr(34)."><INPUT class='btn btn-primary btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_OperateIn'></A> ";
            ?>
            
            
            <?php echo "<a href=?pg=site309E&dev=".$_GET['dev'].">"; ?><INPUT class='btn btn-success btn-sm' TYPE="BUTTON" VALUE="<?php echo $lab_ButtonName_Modify; ?>"></A>
        </div>
    </div>
    <?php  } ?>

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