285 lines
12 KiB
PHP
285 lines
12 KiB
PHP
<?php
|
||
if (!empty($_SESSION['site207']))
|
||
{
|
||
?>
|
||
|
||
<?php
|
||
|
||
if (!empty($_POST['eq'])) $_GET['eq'] = $_POST['eq'];
|
||
|
||
// dodawanie nowego przedmiotu do katalogu
|
||
if (!empty($_POST['inCableName']) && $_POST['subPipingSave']==$lab_ButtonName_Save)
|
||
{
|
||
mysql_query("INSERT INTO seg_equipments SET EQU_MCF_ID=".$_POST['inCableManufID'].",EQU_NAME='".$_POST['inCableName']."',EQU_DESCRIPTION='".$_POST['inCableDesc']."',EQU_PARAM_01='".$_POST['inPipingDiameter']."',EQU_PARAM_02='".$_POST['inPipingLength']."',EQU_TYPE_ID=15");
|
||
$maxEQUid = sqlValue("select max(EQU_ID) from seg_equipments");
|
||
|
||
if (!empty($_FILES['inCableCatalogueFile']['name']))
|
||
{
|
||
$fileName = $_FILES['inCableCatalogueFile']['name'];
|
||
$tmpName = $_FILES['inCableCatalogueFile']['tmp_name'];
|
||
$fileSize = $_FILES['inCableCatalogueFile']['size'];
|
||
$fileType = $_FILES['inCableCatalogueFile']['type'];
|
||
$fp = fopen($tmpName, 'r');
|
||
$content = fread($fp, filesize($tmpName));
|
||
$content = addslashes($content);
|
||
fclose($fp);
|
||
$fileName = addslashes($fileName);
|
||
mysql_query("INSERT INTO seg_equipments_files SET EQF_EQU_ID=$maxEQUid,EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now()");
|
||
}
|
||
if (!empty($_FILES['inCableImageFile']['name']))
|
||
{
|
||
$fileName = $_FILES['inCableImageFile']['name'];
|
||
$tmpName = $_FILES['inCableImageFile']['tmp_name'];
|
||
$fileSize = $_FILES['inCableImageFile']['size'];
|
||
$fileType = $_FILES['inCableImageFile']['type'];
|
||
$fp = fopen($tmpName, 'r');
|
||
$content = fread($fp, filesize($tmpName));
|
||
$content = addslashes($content);
|
||
fclose($fp);
|
||
$fileName = addslashes($fileName);
|
||
mysql_query("INSERT INTO seg_equipments_files SET EQF_EQU_ID=$maxEQUid,EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now()");
|
||
}
|
||
echo"<div class='actionOK'>$lab_SaveRecordNotification_001</div>";
|
||
delSearchSessionData();
|
||
}
|
||
|
||
|
||
// aktualizacja przedmiotu do katalogu
|
||
if (!empty($_POST['inCableName']) && $_POST['subPipingUpdate']==$lab_ButtonName_Update)
|
||
{
|
||
mysql_query("update seg_equipments SET EQU_MCF_ID=".$_POST['inCableManufID'].",EQU_NAME='".$_POST['inCableName']."',EQU_DESCRIPTION='".$_POST['inCableDesc']."',EQU_PARAM_01='".$_POST['inPipingDiameter']."',EQU_PARAM_02='".$_POST['inPipingLength']."' where EQU_ID=".$_POST['eq']);
|
||
|
||
if (!empty($_FILES['inCableCatalogueFile']['name']))
|
||
{
|
||
$fileName = $_FILES['inCableCatalogueFile']['name'];
|
||
$tmpName = $_FILES['inCableCatalogueFile']['tmp_name'];
|
||
$fileSize = $_FILES['inCableCatalogueFile']['size'];
|
||
$fileType = $_FILES['inCableCatalogueFile']['type'];
|
||
$fp = fopen($tmpName, 'r');
|
||
$content = fread($fp, filesize($tmpName));
|
||
$content = addslashes($content);
|
||
fclose($fp);
|
||
$fileName = addslashes($fileName);
|
||
|
||
if (sqlValue("select count(1) from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('application') and EQF_EQU_ID=".$_POST['eq'])>0)
|
||
mysql_query("update seg_equipments_files SET EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now() where EQF_EQU_ID=".$_POST['eq']);
|
||
else
|
||
mysql_query("INSERT INTO seg_equipments_files SET EQF_EQU_ID=".$_POST['eq'].",EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now()");
|
||
}
|
||
if (!empty($_FILES['inCableImageFile']['name']))
|
||
{
|
||
$fileName = $_FILES['inCableImageFile']['name'];
|
||
$tmpName = $_FILES['inCableImageFile']['tmp_name'];
|
||
$fileSize = $_FILES['inCableImageFile']['size'];
|
||
$fileType = $_FILES['inCableImageFile']['type'];
|
||
$fp = fopen($tmpName, 'r');
|
||
$content = fread($fp, filesize($tmpName));
|
||
$content = addslashes($content);
|
||
fclose($fp);
|
||
$fileName = addslashes($fileName);
|
||
if (sqlValue("select count(1) from seg_equipments_files where LOWER(SUBSTRING_INDEX(EQF_FILE_TYPE, '/', 1))=lower('image') and EQF_EQU_ID=".$_POST['eq'])>0)
|
||
mysql_query("update seg_equipments_files SET EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now() where EQF_EQU_ID=".$_POST['eq']);
|
||
else
|
||
mysql_query("INSERT INTO seg_equipments_files SET EQF_EQU_ID=".$_POST['eq'].",EQF_FILE='$content',EQF_FILE_TYPE='$fileType',EQF_FILE_SIZE='$fileSize',EQF_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),EQF_STATUS='1',EQF_AUDIT_CU='".$_SESSION['user']."',EQF_AUDIT_CD=now()");
|
||
}
|
||
echo"<div class='actionOK'>$lab_UpdateRecordNotification_001</div>";
|
||
delSearchSessionData();
|
||
}
|
||
|
||
//usuwanie
|
||
// ==================================================================================
|
||
if (!empty($_GET['param']))
|
||
{
|
||
$tpmArray=explode(',', $_GET['param']);
|
||
|
||
if ($tpmArray[0]>0 && $tpmArray[1]=='del' && $tpmArray[2]==md5($tpmArray[0]))
|
||
{
|
||
// Sprawdza warunek, czy nie jest powiązany z jakimś stanem
|
||
if (sqlValue("select count(*) from seg_equipments_stock where SES_EQU_ID=".$tpmArray[0])>0)
|
||
{
|
||
echo"<div class='actionERROR'>$lab_DeleteRecordNotification_003</div>";
|
||
delSearchSessionData();
|
||
}
|
||
else {
|
||
mysql_query("DELETE FROM seg_equipments WHERE EQU_ID=".$tpmArray[0]);
|
||
mysql_query("DELETE FROM seg_equipments_files WHERE EQF_EQU_ID=".$tpmArray[0]);
|
||
echo"<div class='actionOK'>$lab_DeleteRecordNotification_001</div>";
|
||
delSearchSessionData();
|
||
}
|
||
|
||
}
|
||
}
|
||
// ==================================================================================
|
||
|
||
|
||
|
||
?>
|
||
|
||
|
||
|
||
<?php
|
||
if (!$_POST['sr_status']) $_POST['sr_status']=100;
|
||
|
||
//paginacja
|
||
if (!$_GET['pgn']) {$_GET['pgn']=1; delSearchSessionData(); }
|
||
if ($_POST['sub_search']=='Szukaj') $_SESSION['site207_input'] = $_POST['sr_well'];
|
||
?>
|
||
|
||
|
||
|
||
<form action="./?pg=site207&pgn=1" method="post">
|
||
<div class="tag100">
|
||
<table>
|
||
<tr>
|
||
<td>Typ orurowania – armatury:</td>
|
||
<td style="width: 10px;"></td>
|
||
<td><input type="text" name="sr_well" value="<?php echo $_SESSION['site207_input'];?>"></td>
|
||
|
||
<td style="width: 10px;"></td>
|
||
<td>producent:</td>
|
||
<td style="width: 5px;"></td>
|
||
<td>
|
||
<select name="sr_status">
|
||
<?php
|
||
$wynik = mysql_query("select MCF_ID,MCF_NAME from seg_manufacturers order by MCF_NAME");
|
||
if($wynik)while ($r = mysql_fetch_array($wynik))
|
||
{
|
||
$resID=$r["MCF_ID"];
|
||
$resDESC=$r["MCF_NAME"];
|
||
|
||
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>Wszyscy</option>";
|
||
else
|
||
echo"<option value='100'>Wszyscy</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'> ";
|
||
|
||
echo $lab_HistoricalData_007;
|
||
?>
|
||
</td>
|
||
</tr>
|
||
</table>
|
||
</div>
|
||
</form>
|
||
|
||
|
||
|
||
|
||
|
||
<div class="tag100">
|
||
<div class="head_tag"><?php echo $lab_Tag_site207_001 ;?></div>
|
||
<div class="tag">
|
||
<table WIDTH="100%" class="tag">
|
||
<TR>
|
||
<TD class="label">Lp.</TD>
|
||
<TD class="label"><?php echo $lab_Field_site207_001 ;?></TD>
|
||
<TD class="label"><?php echo $lab_Field_site207_002 ;?></TD>
|
||
<TD class="label"><?php echo $lab_Field_site207_003 ;?></TD>
|
||
<TD class="label"><?php echo $lab_Field_site207_004 ;?></TD>
|
||
</TR>
|
||
|
||
<?php
|
||
|
||
if (empty($_SESSION['site207_array']) || $_POST['sub_search']=='Szukaj')
|
||
{
|
||
$query = "select EQU_ID,EQU_NAME,EQU_PARAM_01,EQU_PARAM_02,MCF_NAME from seg_equipments left join seg_manufacturers on EQU_MCF_ID=MCF_ID where EQU_TYPE_ID=15 and EQU_NAME like '%".$_SESSION['site207_input']."%'";
|
||
if($_POST['sr_status']!=100) $query.=" and MCF_ID=".$_POST['sr_status'];
|
||
$query .= " order by EQU_NAME,EQU_PARAM_01";
|
||
if (empty($_POST['sr_all'])) $query .= " limit 100";
|
||
|
||
$res=null;
|
||
$wynik = mysql_query($query);
|
||
if($wynik)while ($r = mysql_fetch_array($wynik))
|
||
{
|
||
$res[]=array(
|
||
'eq_id' => $r["EQU_ID"],
|
||
'eq_name' => $r["EQU_NAME"],
|
||
'eq_param_01' => $r["EQU_PARAM_01"],
|
||
'eq_param_02' => $r["EQU_PARAM_02"],
|
||
'eq_mfc' => $r["MCF_NAME"],
|
||
);
|
||
}
|
||
unset($_SESSION['site207_array']);
|
||
$_SESSION['site207_array']=$res;
|
||
}
|
||
|
||
|
||
$start=($_GET['pgn']-1)*20;
|
||
$stop = $_GET['pgn']*20;
|
||
if ($stop>count($_SESSION['site207_array'])) $stop=count($_SESSION['site207_array']);
|
||
|
||
for($i=$start;$i<$stop;$i++)
|
||
{
|
||
echo"
|
||
<TR STYLE='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site207inf&eq=".$_SESSION['site207_array'][$i]['eq_id']."'".chr(34).">
|
||
<TD class='field_left'>".($i+1).".</TD>
|
||
<TD class='field_left'>".$_SESSION['site207_array'][$i]['eq_name']."</TD>
|
||
<TD class='field_center'>".$_SESSION['site207_array'][$i]['eq_param_01']."</TD>
|
||
<TD class='field_center'>".$_SESSION['site207_array'][$i]['eq_param_02']."</TD>
|
||
<TD class='field_left'>".$_SESSION['site207_array'][$i]['eq_mfc']."</TD>
|
||
</TR>
|
||
";
|
||
}
|
||
?>
|
||
</table>
|
||
|
||
|
||
<table style="width:100%; background-color: #f5f5f5">
|
||
<tr>
|
||
<td style="width: 25%; text-align: left;"><span class="resume"><?php echo $lab_NumberResults_001.": ".count($_SESSION['site207_array']); ?></span></td>
|
||
<td style="width: 50%; text-align: center;">
|
||
<?php
|
||
if (count($_SESSION['site207_array'])>20)
|
||
echo pagination_grid('?pg=site207', $_GET['pgn'], count($_SESSION['site207_array']));
|
||
?>
|
||
</td>
|
||
<td style="width: 25%; text-align: right;">
|
||
<a href="#" target="_blank" title="Export do EXCEL"><img src="./images/excel_ico.png" style="max-width: 20px; border: 0;"></a>
|
||
<a href="#" target="_blank" title="Wydruk"><img src="./images/printer-icon.png" style="max-width: 20px; border: 0;"></a>
|
||
</td>
|
||
</tr>
|
||
</table>
|
||
|
||
|
||
|
||
|
||
</div>
|
||
|
||
<?php
|
||
if (!empty($_SESSION['site207_edit']))
|
||
echo"
|
||
<div class=tag_buttons>
|
||
<a href='?pg=site207A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
||
</div>
|
||
";
|
||
?>
|
||
|
||
</div>
|
||
|
||
<?php
|
||
}
|
||
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
||
?>
|