$lab_SaveRecordNotification_001";
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"$lab_UpdateRecordNotification_001
";
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"$lab_DeleteRecordNotification_003
";
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"$lab_DeleteRecordNotification_001
";
delSearchSessionData();
}
}
}
// ==================================================================================
?>
";
?>
