105 lines
4.6 KiB
PHP
105 lines
4.6 KiB
PHP
<?php
|
|
if (!empty($_SESSION['site805']))
|
|
{
|
|
?>
|
|
|
|
|
|
<?php
|
|
if (!empty($_FILES['inKnowledgeFile']['name']) && $_POST['subKnowledgerSave']==$lab_ButtonName_Add )
|
|
{
|
|
$fileName = $_FILES['inKnowledgeFile']['name'];
|
|
$tmpName = $_FILES['inKnowledgeFile']['tmp_name'];
|
|
$fileSize = $_FILES['inKnowledgeFile']['size'];
|
|
$fileType = $_FILES['inKnowledgeFile']['type'];
|
|
$fp = fopen($tmpName, 'r');
|
|
$content = fread($fp, filesize($tmpName));
|
|
$content = addslashes($content);
|
|
fclose($fp);
|
|
$fileName = addslashes($fileName);
|
|
mysql_query("INSERT INTO seg_knowledge_base SET SKB_CATEGORY_ID='".$_POST['inKnowledgeCat']."',SKB_FILE_TYPE='$fileType',SKB_FILE_SIZE='$fileSize',SKB_FILE_NAME=LOWER('".delPolishAndBlankCharactersFromFileName($fileName)."'),SKB_FILE_DESC='".$_POST['inKnowledgeNAme']."',SKB_FILE='$content',SKB_STATUS='1',SKB_AUDIT_CU='".$_SESSION['user']."',SKB_AUDIT_CD=now()");
|
|
echo"<div class='actionOK'>$lab_Field_site805_005</div>";
|
|
}
|
|
?>
|
|
<?php
|
|
if (!empty($_SESSION['site805_edit']) && $_GET['del']>0)
|
|
mysql_query("UPDATE seg_knowledge_base SET SKB_STATUS='0' WHERE SKB_ID=".$_GET['del']);
|
|
?>
|
|
|
|
<?php
|
|
if ($_SESSION['lang'] == 'polish') $decFieldLang = 'DIC_POL_LANG';
|
|
else if ($_SESSION['lang'] == 'english') $decFieldLang = 'DIC_ENG_LANG';
|
|
else if ($_SESSION['lang'] == 'german') $decFieldLang = 'DIC_GER_LANG';
|
|
?>
|
|
|
|
|
|
|
|
<div class="tag100">
|
|
<div class="head_tag"><?php echo $lab_Tag_site801_001 ;?></div>
|
|
<div class="tag">
|
|
<table WIDTH="100%" class="tag">
|
|
<tr>
|
|
<td class="label"></td>
|
|
<td class="label"><?php echo $lab_Field_site805_006 ;?></td>
|
|
<td class="label"><?php echo $lab_Field_site805_007 ;?></td>
|
|
<td class="label"><?php echo $lab_Field_site805_008 ;?></td>
|
|
<td class="label"><?php echo $lab_Field_site805_009 ;?></td>
|
|
<?php
|
|
if (!empty($_SESSION['site805_edit']))
|
|
echo"<td class='label'></td>";
|
|
?>
|
|
|
|
</tr>
|
|
|
|
<?php
|
|
$wynik = mysql_query("select SKB_ID,SUBSTRING_INDEX(SKB_FILE_NAME, '.', -1) ICO,SKB_FILE_DESC,SKB_FILE_SIZE,SKB_CATEGORY_ID,SKB_AUDIT_CU,SKB_AUDIT_CD from seg_knowledge_base where SKB_STATUS=1 order by SKB_CATEGORY_ID,SKB_FILE_DESC,ICO");
|
|
if($wynik)while ($r = mysql_fetch_array($wynik))
|
|
{
|
|
$sql_1 = $r["SKB_ID"];
|
|
$vICO = $r["ICO"];
|
|
$sql_3 = $r["SKB_FILE_DESC"];
|
|
$sql_4 = $r["SKB_FILE_SIZE"];
|
|
$sql_5 = $r["SKB_CATEGORY_ID"];
|
|
$sql_7 = $r["SKB_AUDIT_CU"];
|
|
$sql_8 = $r["SKB_AUDIT_CD"];
|
|
|
|
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"
|
|
<tr>
|
|
<td class='field_center'><img src=$icoFile></td>
|
|
<td class='field_left'>$sql_3</td>
|
|
<td class='field_center'>".sqlStringValue("select $decFieldLang from sys_dictionaries where DIC_ID=$sql_5",$decFieldLang)."</td>
|
|
<td class='field_right'>$sql_4</td>
|
|
<td class='field_center'>$sql_7<br/>$sql_8</td>";
|
|
if (!empty($_SESSION['site805_edit']))
|
|
echo"<td class='field_center'><img src='./images/bin_ico.png' title='$lab_ButtonName_Delete' style='cursor: pointer;' onclick=".chr(34)."document.location.href='?pg=site805&del=$sql_1'".chr(34)."></td>";
|
|
echo"
|
|
</tr>
|
|
";
|
|
}
|
|
?>
|
|
</table>
|
|
</div>
|
|
|
|
<?php
|
|
if (!empty($_SESSION['site805_edit']))
|
|
echo"
|
|
<div class=tag_buttons>
|
|
<a href='?pg=site805A'> <INPUT class='btn btn-success btn-sm' TYPE='BUTTON' VALUE='$lab_ButtonName_Add'></A>
|
|
</div>
|
|
";
|
|
?>
|
|
|
|
</div>
|
|
|
|
<?php
|
|
}
|
|
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
|
|
?>
|