228 lines
12 KiB
PHP
228 lines
12 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site401']))
|
|
{
|
|
?>
|
|
|
|
<?php
|
|
// Po wybraniu wydziału przypisuje tylko dostęp do jednego
|
|
if (!empty($_GET['seldep']))
|
|
{
|
|
$_SESSION['syndis_eq_stock'] = $_GET['seldep'];
|
|
$_SESSION['eq_stock_param3_1'] = $_GET['seldep'];
|
|
$_POST['wydz'] = $_GET['seldep'];
|
|
unset($_SESSION['eq_stock_param3_2']);
|
|
unset($_SESSION['eq_stock_param3_3']);
|
|
}
|
|
?>
|
|
|
|
|
|
<?php
|
|
if ($_POST['subWellSave']==$lab_ButtonName_Save && !empty($_POST['inWellPumpID']) && !empty($_POST['inWellEngineID']) && !empty($_POST['inWellName']))
|
|
{
|
|
mysql_query("INSERT INTO seg_wells SET WLL_NAME='".$_POST['inWellName']."',WLL_DIAMETER=".$_POST['inWellDiame'].",WLL_DEPTH=".$_POST['inWellDepth'].",WLL_LATITUDE='".$_POST['inWellLat']."',WLL_LONGITUDE='".$_POST['inWellLong']."'");
|
|
$maxWELLid = sqlValue("select max(WLL_ID) from seg_wells");
|
|
mysql_query("INSERT INTO seg_well_pump_eng_rel SET RWL_WLL_ID=$maxWELLid,RWL_PUP_DRS_ID=".$_POST['inWellPumpID'].",RWL_ENG_DRS_ID=".$_POST['inWellEngineID']);
|
|
mysql_query("INSERT INTO seg_dev_resources SET DRS_DEV_ID=$maxWELLid,DRS_DEV_TYPE=(select DIC_ID from sys_dictionaries where DIC_TYPE='DRS_DEV_TYPE' and DIC_NAME='WELL'),DRS_AVAILABLE_DATE='".$_POST['inWellAVdate']."',DRS_STATUS_DIC_ID=".$_POST['inWellStatus'].",DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now()");
|
|
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources where DRS_ID=(select max(DRS_ID) from seg_dev_resources)");
|
|
|
|
mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_STATUS' and DIC_NAME='USABLE'),DRS_RESOURCES_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES' and DIC_NAME='OPERATION'),DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$_POST['inWellPumpID']);
|
|
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources WHERE DRS_ID=".$_POST['inWellPumpID']);
|
|
mysql_query("UPDATE seg_dev_resources SET DRS_STATUS_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_STATUS' and DIC_NAME='USABLE'),DRS_RESOURCES_DIC_ID=(select DIC_ID from sys_dictionaries where DIC_TYPE='DEV_RESOURCES' and DIC_NAME='OPERATION'),DRS_AUDIT_USR='".$_SESSION['user']."',DRS_AUDIT_DATE=now() WHERE DRS_ID=".$_POST['inWellEngineID']);
|
|
mysql_query("insert into seg_dev_resources_his select * from seg_dev_resources WHERE DRS_ID=".$_POST['inWellEngineID']);
|
|
|
|
echo"<div class='actionOK'>$lab_Field_site803_013</div>";
|
|
unset($maxWELLid);
|
|
unset($maxDRSid);
|
|
}
|
|
|
|
//if (empty($_POST['wydz'])) $_POST['wydz']=sqlStringValue("select URG_DESC from sys_users_regions where URG_USR_ID=".$_SESSION['user_id']." limit 1","URG_DESC");
|
|
//if (empty($_POST['wydz'])) $_POST['wydz']=$_SESSION['eq_stock_param3_1']
|
|
|
|
if (!$_POST['sr_status']) $_POST['sr_status']=3;
|
|
|
|
?>
|
|
|
|
|
|
<?php
|
|
//paginacja
|
|
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); }
|
|
if ($_POST['sub_search']=='Szukaj') $_SESSION['site401_input'] = $_POST['sr_well'];
|
|
?>
|
|
|
|
|
|
|
|
<form action="./?pg=site401&pgn=1" method="post">
|
|
<div class="tag100">
|
|
<table>
|
|
<tr>
|
|
<td>Studnia:</td>
|
|
<td style="width: 10px;"></td>
|
|
<td><input type="text" name="sr_well" value="<?php echo $_SESSION['site401_input'];?>"></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 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>
|
|
</div>
|
|
</form>
|
|
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site401_013 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<TR>
|
|
<TD class="label">Lp.</TD>
|
|
<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"><?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>
|
|
<td class="label"></td>
|
|
</TR>
|
|
|
|
<?php
|
|
|
|
|
|
if (empty($_SESSION['site401_array']) || $_POST['sub_search']=='Szukaj')
|
|
{
|
|
// $query="select DRS_ID,RWL_WLL_ID,WLL_NAME,WLL_BARIERA,RWL_PUP_DRS_ID,RWL_ENG_DRS_ID,DRS_RESOURCES_DIC_ID,WLL_SYS_TYPE from seg_dev_resources,seg_well_pump_eng_rel left join seg_wells on RWL_WLL_ID=WLL_ID where RWL_WLL_ID=DRS_DEV_ID and DRS_DEV_TYPE=12 and DRS_STATUS_DIC_ID=3 and DRS_DEPARTMENT='".$_SESSION['syndis_eq_stock']."' and WLL_NAME like '%".$_POST['sr_well']."%'";
|
|
$query="select DRS_ID,RWL_WLL_ID,WLL_NAME,WLL_BARIERA,RWL_PUP_DRS_ID,RWL_ENG_DRS_ID,DRS_RESOURCES_DIC_ID,DRS_STATUS_DIC_ID,WLL_SYS_TYPE from seg_wells left join seg_dev_resources on DRS_DEV_ID=WLL_ID and DRS_DEV_TYPE=12 left join seg_well_pump_eng_rel on RWL_WLL_ID=WLL_ID where DRS_DEPARTMENT='".$_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 100";
|
|
|
|
|
|
$res=null;
|
|
$wynik = mysql_query($query);
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
unset($pupArray);
|
|
if ($r["RWL_PUP_DRS_ID"]>0)
|
|
$pupArray = sqlGetResAsArray("select * from seg_dev_resources,seg_pumps where DRS_DEV_TYPE=10 and PUP_ID=DRS_DEV_ID and DRS_ID=".$r["RWL_PUP_DRS_ID"]);
|
|
unset($engArray);
|
|
if ($r["RWL_ENG_DRS_ID"]>0)
|
|
$engArray = sqlGetResAsArray("select * from seg_dev_resources,seg_engines where DRS_DEV_TYPE=11 and ENG_ID=DRS_DEV_ID and DRS_ID=".$r["RWL_ENG_DRS_ID"]);
|
|
unset($onOffArray);
|
|
$onOffArray = sqlGetResAsArray("select DRD_VALUE from seg_dev_resources_det where DRD_ID=(select max(DRD_ID) from seg_dev_resources_det where DRD_RESOURCES_DETAIL=507 and DRD_DRS_ID=".$r["DRS_ID"].")");
|
|
|
|
$res[]=array(
|
|
'drs_id' => $r["DRS_ID"],
|
|
'well_name' => $r["WLL_NAME"],
|
|
'well_id' => $r["RWL_WLL_ID"],
|
|
'pup_name' => $pupArray[0]['PUP_NAME'],
|
|
'pup_no' => $pupArray[0]['DRS_SN_NUMBER'],
|
|
'eng_name' => $engArray[0]['ENG_NAME'],
|
|
'eng_no' => $engArray[0]['DRS_SN_NUMBER'],
|
|
'desc' => $r["WLL_SYS_TYPE"],
|
|
'desc_info' => setDicName($r["DRS_RESOURCES_DIC_ID"]),
|
|
'bariera' => $r["WLL_BARIERA"],
|
|
'onoff' => $onOffArray[0]['DRD_VALUE'],
|
|
|
|
);
|
|
|
|
|
|
}
|
|
unset($_SESSION['site401_array']);
|
|
$_SESSION['site401_array']=$res;
|
|
}
|
|
|
|
|
|
$start=($_GET['pgn']-1)*20;
|
|
$stop = $_GET['pgn']*20;
|
|
if ($stop>count($_SESSION['site401_array'])) $stop=count($_SESSION['site401_array']);
|
|
|
|
for($i=$start;$i<$stop;$i++)
|
|
{
|
|
echo"
|
|
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site401mark&dev=".$_SESSION['site401_array'][$i]['drs_id']."'".chr(34).">
|
|
<TD class='field_left'>".($i+1).".</TD>
|
|
<TD class='field_left'>".$_SESSION['site401_array'][$i]['well_name']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['bariera']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['pup_name']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['pup_no']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['eng_name']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['eng_no']."</TD>
|
|
<TD class='field_center'>".$_SESSION['site401_array'][$i]['desc']."</TD>";
|
|
|
|
if ($_SESSION['site401_array'][$i]['onoff'] == "ON")
|
|
echo"<TD class='field_center'><img src='./images/power_on.png' border=0></TD>";
|
|
else
|
|
echo"<TD class='field_center'><img src='./images/power_off.png' border=0></TD>";
|
|
|
|
echo"
|
|
</TR>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
|
|
|
|
|
|
<table style="width:100%; background-color: #f5f5f5">
|
|
<tr>
|
|
<td style="width: 25%; text-align: left;"><span class="resume">Wyników: <?php echo count($_SESSION['site401_array']); ?></span></td>
|
|
<td style="width: 50%; text-align: center;">
|
|
<?php
|
|
if (count($_SESSION['site401_array'])>20)
|
|
echo pagination_grid('?pg=site401', $_GET['pgn'], count($_SESSION['site401_array']));
|
|
?>
|
|
</td>
|
|
<td style="width: 25%; text-align: right;">
|
|
<a href="./export/site401_xls.php" target="_blank" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
|
<!--<a href="./export/site401_pdf.php" target="_blank" title="Export do PDF"><img src="./images/pdf_ico.png" style="max-width: 20px; border: 0;"></a> -->
|
|
<a href="./export/site401_print.php" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
|
|
|
|
</div>
|
|
|
|
</div>
|
|
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|