Files
2026-09-03 11:24:19 +02:00

78 lines
3.1 KiB
PHP

<?php
if (!empty($_SESSION['user']))
{
echo"
<div class='tag100'>
<div class='head_tag'>Instrukcje</div>
<div class='tag'>
<table WIDTH='100%'>
<tr>
<td WIDTH='5px'><img src=./images/pdf_ico.png></td>
<td><a class='knowledge' href='./foto/SoftSPM_instrukcja.pdf' target='_blank'>Instrukcja systemu SoftSPM</a></td>
</tr>
</table>
</div>
</div>
";
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';
$wynik = mysql_query("select DIC_ID,$decFieldLang from sys_dictionaries where DIC_TYPE='KNOWLEDGE_BASE_CATEGORY'");
if($wynik)while ($r = mysql_fetch_array($wynik))
{
$var_DIC_ID = $r["DIC_ID"];
$var_DIC_NAME = $r["$decFieldLang"];
$isInCategory=sqlValue("select count(1) from seg_knowledge_base where SKB_STATUS='1' and SKB_CATEGORY_ID=$var_DIC_ID");
if ($isInCategory>0)
{
echo"
<div class='tag100'>
<div class='head_tag'>$var_DIC_NAME</div>
<div class='tag'>
<table WIDTH='100%'>";
$re = mysql_query("select SKB_ID,SUBSTRING_INDEX(SKB_FILE_NAME, '.', -1) ICO,SKB_FILE_DESC from seg_knowledge_base where SKB_STATUS='1' and SKB_CATEGORY_ID=$var_DIC_ID order by SKB_FILE_DESC,ICO");
if($re)while ($rc = mysql_fetch_array($re))
{
$vSKB_ID = $rc["SKB_ID"];
$vICO = $rc["ICO"];
$vSKB_FILE_DESC = $rc["SKB_FILE_DESC"];
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 WIDTH='5px'><img src=$icoFile></td>
<td><a class='knowledge' href='./sites/filegeneratefromdb.php?fno=$vSKB_ID' target='_blank'>$vSKB_FILE_DESC</a></td>
</tr>
";
}
echo"
</table>
</div>
</div>
";
}
}
}
else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001);
?>