assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$content_output = $smarty->fetch("main.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// "Proizvodi"
case 'ukategorije':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM uberkategorija ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("ukat", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$content_output = $smarty->fetch("ukategorije.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'natkategorije':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM natkategorija WHERE id_uber='$_GET[ukat]' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("nkat", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$sql = "SELECT id,naziv FROM uberkategorija WHERE id='$_GET[ukat]'";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("natkategorije.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'kategorije':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM kategorija WHERE id_nat=$_GET[nkat] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("kat", $rs->GetArray() );
$sql = "SELECT uberkategorija.id ukti, uberkategorija.naziv uktn, natkategorija.id nkti, natkategorija.naziv nktn FROM uberkategorija, natkategorija WHERE uberkategorija.id=natkategorija.id_uber AND natkategorija.id=$_GET[nkat]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("kategorije.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'proizvodi':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM proizvod WHERE id_kat=$_GET[kat] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("proizvod", $rs->GetArray() );
$sql = "SELECT natkategorija.id nkti, natkategorija.naziv nktn, kategorija.id kati, kategorija.naziv katn FROM natkategorija, kategorija WHERE natkategorija.id=kategorija.id_nat AND kategorija.id=$_GET[kat]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("proizvodi.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'proizvodi_r':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT proizvod.id, proizvod.naziv FROM proizvod, proizvod_radovi WHERE proizvod_radovi.idr=$_GET[idr] AND proizvod.id=proizvod_radovi.idp ORDER BY proizvod.naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("proizvod", $rs->GetArray() );
$sql = "SELECT naziv FROM radovi WHERE id=$_GET[idr]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("proizvodi_r.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'proizvodi_abc':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$_GET[sl]=strip_tags($_GET[sl]);
if (!$_GET[sl]) $_GET[sl]="a";
$smarty->assign("sl", strtoupper($_GET[sl]));
if (strlen($_GET[sl])==1){
$sql = "SELECT proizvod.id, proizvod.naziv FROM proizvod WHERE SUBSTRING(proizvod.naziv,1,1)='$_GET[sl]' ORDER BY proizvod.naziv ASC";
} else {
$sql = "SELECT proizvod.id, proizvod.naziv FROM proizvod ORDER BY proizvod.naziv ASC";
}
$rs = $db -> Execute($sql);
$smarty->assign("proizvod", $rs->GetArray() );
$content_output = $smarty->fetch("proizvodi_abc.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Tvrtke po proizvodu
case 'tvrtke':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv, grad FROM tvrtka,proizvod_tvrtka WHERE id=proizvod_tvrtka.idt AND proizvod_tvrtka.idp=$_GET[idp] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$sql = "SELECT natkategorija.id nkti, natkategorija.naziv nktn, kategorija.id kati, kategorija.naziv katn, proizvod.id pid, proizvod.naziv pn FROM natkategorija, kategorija, proizvod WHERE natkategorija.id=kategorija.id_nat AND kategorija.id=proizvod.id_kat AND proizvod.id=$_GET[idp]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("tvrtke.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Tvrtke po djelatnosti
case 'tvrtke_d':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
if ($_GET[dj]){
$sql = "SELECT id, naziv, grad FROM tvrtka,djelatnost_tvrtka WHERE id=djelatnost_tvrtka.idt AND djelatnost_tvrtka.idd=$_GET[dj] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$sql = "SELECT id, naziv FROM djelatnosti WHERE id=$_GET[dj]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() ); }
$content_output = $smarty->fetch("tvrtke_d.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Tvrtke po kategoriji proizvoda
case 'tvrtke_k':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT tvrtka.id, tvrtka.naziv, tvrtka.grad FROM tvrtka,proizvod_tvrtka, proizvod, proizvod_kat WHERE tvrtka.id=proizvod_tvrtka.idt AND proizvod_tvrtka.idp=proizvod.id AND proizvod.id=proizvod_kat.idp AND proizvod_kat.idk='$_GET[kat]' GROUP BY tvrtka.naziv ORDER BY tvrtka.naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$sql = "SELECT uberkategorija.id ukti, uberkategorija.naziv uktn, natkategorija.id nkti, natkategorija.naziv nktn, kategorija.id kati, kategorija.naziv katn FROM uberkategorija, natkategorija, kategorija WHERE uberkategorija.id=natkategorija.id_uber AND natkategorija.id=kategorija.id_nat AND kategorija.id='$_GET[kat]'";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("tvrtke_k.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Tvrtke po radovima
case 'tvrtke_r':
$smarty->assign("abc_page", "proizvodi_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT tvrtka.id, tvrtka.naziv, tvrtka.grad FROM tvrtka,proizvod_tvrtka, proizvod, proizvod_radovi WHERE tvrtka.id=proizvod_tvrtka.idt AND proizvod_tvrtka.idp=proizvod.id AND proizvod.id=proizvod_radovi.idp AND proizvod_radovi.idr=$_GET[idr] GROUP BY tvrtka.naziv ORDER BY tvrtka.naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$sql = "SELECT naziv, opis FROM radovi WHERE id=$_GET[idr]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("tvrtke_r.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Tvrtke po slovu
case 'tvrtke_abc':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$_GET['sl']=strip_tags($_GET['sl']);
if (!$_GET['sl']) $_GET['sl']="a";
$smarty->assign("sl", strtoupper($_GET['sl']));
if (strlen($_GET['sl'])==1){
$sql = "SELECT id, naziv, grad, url FROM tvrtka WHERE SUBSTRING(naziv,1,1)='$_GET[sl]' ORDER BY naziv ASC";
} else {
$sql = "SELECT id, naziv, grad, url FROM tvrtka ORDER BY naziv ASC";
}
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$content_output = $smarty->fetch("tvrtke_abc.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Tvrtka
case 'tvrtka':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT * FROM tvrtka WHERE id='$_GET[idt]'";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtka", $rs->GetArray() );
if (file_exists("images/logo/".$smarty->_tpl_vars['tvrtka'][0]['id'].".gif")) $smarty->assign("slika", "![logo](images/logo/".$smarty->_tpl_vars[)
" );
switch ($_GET[sub]) {
case 1:
$sql = "SELECT id, naziv FROM djelatnosti, djelatnost_tvrtka WHERE djelatnost_tvrtka.idt='$_GET[idt]' AND djelatnost_tvrtka.idd=djelatnosti.id ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("djelatnost", $rs->GetArray() );
$subpage_content = $smarty->fetch("tvrtka_sub1.html");
$smarty->assign("subpage", $subpage_content);
break;
case 2:
$subpage_content = $smarty->fetch("tvrtka_sub2.html");
$smarty->assign("subpage", $subpage_content);
break;
case 3:
$mailmsg='';
foreach ($_POST[item] as $key => $value) {$mailmsg.=str_replace("'", "", $key).": $value\n";}
if (mail($_POST[mail_to], "Poruka sa HUGO weba", $mailmsg, "From: web@hugo")) $smarty->assign("subpage", "
Vaša poruka je poslana.");
else $smarty->assign("subpage", "
Došlo je do greške prilikom slanja poruke.");
break;
case 4:
$sql = "SELECT * FROM kontakti WHERE tvrtka='$_GET[idt]' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("kontakt", $rs->GetArray() );
$subpage_content = $smarty->fetch("tvrtka_sub4.html");
$smarty->assign("subpage", $subpage_content);
break;
case 6:
$sql = "SELECT * FROM datoteka WHERE tvrtka='$_GET[idt]' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("files", $rs->GetArray() );
$subpage_content = $smarty->fetch("tvrtka_sub6.html");
$smarty->assign("subpage", $subpage_content);
break;
case 5:
$subpage_content = $smarty->fetch("tvrtka_sub5.html");
$smarty->assign("subpage", $subpage_content);
//Tree_menu po radovima
$sql = "SELECT radovi_ukt.naziv ukt, radovi_nkt.naziv nkt, radovi_kat.naziv kat, radovi.naziv rad, proizvod.naziv, proizvod.id, radovi.id rid FROM proizvod_tvrtka, proizvod, radovi, proizvod_radovi, radovi_ukt, radovi_nkt, radovi_kat WHERE proizvod_tvrtka.idt='$_GET[idt]' AND proizvod_tvrtka.idp=proizvod.id AND proizvod_radovi.idp=proizvod.id AND proizvod_radovi.idr=radovi.id AND radovi.id_kat=radovi_kat.id AND radovi_kat.id_nkt=radovi_nkt.id AND radovi_nkt.id_ukt=radovi_ukt.id ORDER BY ukt, nkt, kat, rad, proizvod.naziv";
$rs = $db -> Execute($sql);
$tree='';
$rs = $db -> Execute($sql);
while (!$rs->EOF) {
$tmp1=$rs->fields[0];
$tree.="\n[\"".$tmp1."\", null, null,\n";
while ($rs->fields[0]==$tmp1){
$tmp2=$rs->fields[1];
$tree.="[\"".$tmp2."\", null, null,\n";
while ($rs->fields[1]==$tmp2){
$tmp3=$rs->fields[2];
$tree.="[\"".$tmp3."\", null, null,\n";
while ($rs->fields[2]==$tmp3){
$tmp4=$rs->fields[3];
$tree.="[\"".$tmp4."\", null, null,\n";
while ($rs->fields[3]==$tmp4)
{
$tree.="[\"".$rs->fields[4]."\", \"javascript:void(window.open('popup.php?id=".$rs->fields[5]."&rad=".$rs->fields[6]."','".$rs->fields[5]."','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=530,height=400'))\", null],\n";
$rs->MoveNext();
}
$tree.="],\n";
}
$tree.="],\n";
}
$tree.="],\n";
}
$tree.="],\n";
}
$smarty->assign("tree_menu", $tree);
$header_func = $smarty->fetch("header_func.html");
$smarty->assign("header_func", $header_func);
$smarty->assign("footer_func", "");
break;
default:
$subpage_content = $smarty->fetch("tvrtka_sub0.html");
$smarty->assign("subpage", $subpage_content);
//Tree_menu po kategorijama
$sql = "SELECT uberkategorija.naziv ukat, natkategorija.naziv nkat, kategorija.naziv kat, proizvod.naziv, proizvod.id, kategorija.id kid FROM proizvod, kategorija, natkategorija, uberkategorija, proizvod_tvrtka, proizvod_kat WHERE proizvod_tvrtka.idt='$_GET[idt]' AND proizvod_tvrtka.idp=proizvod.id AND proizvod.id=proizvod_kat.idp AND proizvod_kat.idk=kategorija.id AND kategorija.id_nat=natkategorija.id AND natkategorija.id_uber=uberkategorija.id ORDER BY ukat, nkat, kat, proizvod.naziv ASC";
$rs = $db -> Execute($sql);
$tree='';
while (!$rs->EOF) {
$tmp1=$rs->fields[0];
$tree.="\n[\"".$tmp1."\", null, null,\n";
while ($rs->fields[0]==$tmp1){
$tmp2=$rs->fields[1];
$tree.="[\"".$tmp2."\", null, null,\n";
while ($rs->fields[1]==$tmp2){
$tmp3=$rs->fields[2];
$tree.="[\"".$tmp3."\", null, null,\n";
while ($rs->fields[2]==$tmp3)
{
$tree.="[\"".$rs->fields[3]."\", \"javascript:void(window.open('popup.php?id=".$rs->fields[4]."&kat=".$rs->fields[5]."','".$rs->fields[4]."','toolbar=no,location=no,status=no,menubar=no,scrollbars=yes,resizable=yes,width=530,height=400'))\", null],\n";
$rs->MoveNext();
}
$tree.="],\n";
}
$tree.="],\n";
}
$tree.="],\n";
}
$smarty->assign("tree_menu", $tree);
$header_func = $smarty->fetch("header_func.html");
$smarty->assign("header_func", $header_func);
$smarty->assign("footer_func", "");
break;
}
$content_output = $smarty->fetch("tvrtka.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Djelatnosti
case 'djelatnosti':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM djelatnosti ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("dj", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$content_output = $smarty->fetch("djelatnosti.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Vrste projektiranja
case 'projektanti':
$smarty->assign("abc_page", "projektanti_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM projekt ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("p", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$content_output = $smarty->fetch("projektanti.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Projektanti po vrsti projektiranja
case 'tvrtke_p':
$smarty->assign("abc_page", "projektanti_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
if ($_GET[p]){
$sql = "SELECT id, naziv, grad FROM projektant,projektant_projekt WHERE projektant.id=projektant_projekt.idt AND projektant_projekt.idp=$_GET[p] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$sql = "SELECT id, naziv FROM projekt WHERE id=$_GET[p]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() ); }
$content_output = $smarty->fetch("tvrtke_p.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
//Projektanti po abecedi
case 'projektanti_abc':
$smarty->assign("abc_page", "projektanti_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
if (!$_GET[sl]) $_GET[sl]="a";
$smarty->assign("sl", strtoupper($_GET[sl]));
$sql = "SELECT id, naziv, grad FROM projektant WHERE SUBSTRING(naziv,1,1)='$_GET[sl]' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtke", $rs->GetArray() );
$content_output = $smarty->fetch("tvrtke_p.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Projektant
case 'projektant':
$smarty->assign("abc_page", "projektanti_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT * FROM projektant WHERE id='$_GET[id]'";
$rs = $db -> Execute($sql);
$smarty->assign("tvrtka", $rs->GetArray() );
if (file_exists("images/pr_logo/".$smarty->_tpl_vars['tvrtka'][0]['id'].".gif")) $smarty->assign("slika", "![logo](images/pr_logo/".$smarty->_tpl_vars[)
" );
switch ($_GET[sub]) {
default:
$sql = "SELECT id, naziv FROM projekt, projektant_projekt WHERE projektant_projekt.idt='$_GET[id]' AND projektant_projekt.idp=projekt.id ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("p", $rs->GetArray() );
$subpage_content = $smarty->fetch("projektant_sub1.html");
$smarty->assign("subpage", $subpage_content);
break;
case 2:
$subpage_content = $smarty->fetch("tvrtka_sub2.html");
$smarty->assign("subpage", $subpage_content);
break;
case 3:
$mailmsg='';
foreach ($_POST[item] as $key => $value) {$mailmsg.=str_replace("'", "", $key).": $value\n";}
if (mail($_POST[mail_to], "Poruka sa HUGO weba", $mailmsg, "From: web@hugo")) $smarty->assign("subpage", "
Vaša poruka je poslana.");
else $smarty->assign("subpage", "
Došlo je do greške prilikom slanja poruke.");
break;
case 4:
$sql = "SELECT * FROM kontakti WHERE tvrtka='$_GET[idt]' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("kontakt", $rs->GetArray() );
$subpage_content = $smarty->fetch("tvrtka_sub4.html");
$smarty->assign("subpage", $subpage_content);
break;
}
$content_output = $smarty->fetch("projektant.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Radovi
case 'radovi':
//Tree_menu po radovima
$sql = "SELECT radovi_vkt.naziv vkt, radovi_ukt.naziv ukt, radovi_nkt.naziv nkt, radovi_kat.naziv kat, radovi.naziv rad, radovi.id FROM radovi, radovi_nkt, radovi_ukt, radovi_kat, radovi_vkt WHERE radovi.id_kat=radovi_kat.id AND radovi_kat.id_nkt=radovi_nkt.id AND radovi_nkt.id_ukt=radovi_ukt.id AND radovi_ukt.id_vkt=radovi_vkt.id ORDER BY radovi_vkt.id,radovi_ukt.id,radovi_nkt.id,radovi_kat.id, id";
$rs = $db -> Execute($sql);
$tree='';
$rs = $db -> Execute($sql);
while (!$rs->EOF) {
$tmp1=$rs->fields[0];
$tree.="\n[\"".$tmp1."\", null, null,\n";
while ($rs->fields[0]==$tmp1){
$tmp2=$rs->fields[1];
$tree.="[\"".$tmp2."\", null, null,\n";
while ($rs->fields[1]==$tmp2){
$tmp3=$rs->fields[2];
$tree.="[\"".$tmp3."\", null, null,\n";
while ($rs->fields[2]==$tmp3){
$tmp4=$rs->fields[3];
$tree.="[\"".$tmp4."\", null, null,\n";
while ($rs->fields[3]==$tmp4)
{
$tree.="[\"".$rs->fields[4]."\", \"?pg=tvrtke_r&idr=".$rs->fields[5]."\", null],\n";
$rs->MoveNext();
}
$tree.="],\n";
}
$tree.="],\n";
}
$tree.="],\n";
}
$tree.="],\n";
}
$smarty->assign("tree_menu", $tree);
$header_func = $smarty->fetch("header_func.html");
$smarty->assign("header_func", $header_func);
$smarty->assign("footer_func", "");
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$content_output = $smarty->fetch("radovi.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Pretraživanje
case 'search':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
if (strlen($_POST[query])>1){
$query=strip_tags($_POST[query]);
$sql = "SELECT id, naziv FROM $_POST[area] WHERE naziv LIKE '%$query%' ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("results", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$smarty->assign("query",$query );
$smarty->assign("area",$_POST[area] );
$content_output = $smarty->fetch("pretraga.html");
$smarty->assign("content_block", $content_output);
}
else $smarty->assign("content_block", "
Molimo unesite barem dva slova za pretraživanje.
");
$smarty->display('index.html');
break;
// Vijesti
case 'vijesti':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT vijesti.id, vijesti.naslov, vijesti.opis, tvrtka.naziv FROM vijesti, tvrtka WHERE vijesti.idt=tvrtka.id AND vijesti.auth>0 ORDER BY vijesti.id DESC";
$rs = $db -> Execute($sql);
$smarty->assign("vijesti", $rs->GetArray() );
$content_output = $smarty->fetch("vijesti.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'vijest':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT vijesti.*, tvrtka.naziv, tvrtka.id AS idk FROM vijesti, tvrtka WHERE vijesti.idt=tvrtka.id AND vijesti.auth>0 AND vijesti.id=$_GET[id] ORDER BY vijesti.id DESC";
$rs = $db -> Execute($sql);
$smarty->assign("vijest", $rs->GetArray() );
if (file_exists("images/vijesti/".$smarty->_tpl_vars['vijest'][0]['id'].".jpg")) $smarty->assign("slika", "![](images/vijesti/".$smarty->_tpl_vars[)
" );
$content_output = $smarty->fetch("vijest.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// Norme
case 'norme':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, kratica, opis FROM norme_kat ORDER BY kratica ASC";
$rs = $db -> Execute($sql);
$smarty->assign("norme", $rs->GetArray() );
$content_output = $smarty->fetch("norme.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'norme2':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, oznaka, naslov FROM norme WHERE kat=$_GET[idk] ORDER BY oznaka ASC";
$rs = $db -> Execute($sql);
$smarty->assign("norme", $rs->GetArray() );
$sql = "SELECT kratica FROM norme_kat WHERE id=$_GET[idk]";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("norme2.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
case 'norma':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT * FROM norme WHERE id=$_GET[id]";
$rs = $db -> Execute($sql);
$smarty->assign("norma", $rs->GetArray() );
$content_output = $smarty->fetch("norma.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// ELEMENTI - kategorije elemenata
case 'elementi_k':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM elementi_kat ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("kat", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$content_output = $smarty->fetch("elementi_k.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// ELEMENTI - elemenati unutar kategorije
case 'elementi':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv, opis FROM elementi WHERE kat=$_GET[kat] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("el", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$sql = "SELECT id,naziv FROM elementi_kat WHERE id='$_GET[kat]'";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$content_output = $smarty->fetch("elementi.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// ELEMENTI - dijelovi elementa
case 'el_d':
$smarty->assign("abc_page", "tvrtke_abc");
$abc_menu = $smarty->fetch("abc_menu.html");
$smarty->assign("abc_menu", $abc_menu);
$sql = "SELECT id, naziv FROM elementi_dijelovi WHERE element_id=$_GET[el] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("dio", $rs->GetArray() );
$smarty->assign("numrows",$rs->RecordCount() );
$sql = "SELECT elementi_kat.id kid,elementi_kat.naziv knaziv, elementi.id, elementi.naziv FROM elementi_kat, elementi WHERE elementi_kat.id=elementi.kat AND elementi.id='$_GET[el]'";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
$sql = "SELECT opis FROM elementi WHERE elementi.id='$_GET[el]'";
$rs = $db -> Execute($sql);
$smarty->assign("opis", $rs->GetArray() );
if (file_exists("images/elementi/".$_GET[el].".jpg")) $smarty->assign("slika", "![](images/elementi/".$_GET[el].".jpg)
" );
$content_output = $smarty->fetch("el_d.html");
$smarty->assign("content_block", $content_output);
$smarty->display('index.html');
break;
// ELEMENTI - proizvodi i radovi za dio elementa
case 'dio':
$sql = "SELECT proizvod.id, proizvod.naziv FROM proizvod, element_proizvod WHERE proizvod.id=element_proizvod.id_pr AND element_proizvod.id_el_dio=$_GET[id] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("proizvod", $rs->GetArray() );
$sql = "SELECT radovi.id, radovi.naziv FROM radovi, element_radovi WHERE radovi.id=element_radovi.id_rad AND element_radovi.id_el_dio=$_GET[id] ORDER BY naziv ASC";
$rs = $db -> Execute($sql);
$smarty->assign("rad", $rs->GetArray() );
$sql = "SELECT naziv FROM elementi_dijelovi WHERE id='$_GET[id]'";
$path = $db -> Execute($sql);
$smarty->assign("path", $path->GetArray() );
//$content_output = $smarty->fetch("el_d.html");
//$smarty->assign("content_block", $content_output);
$smarty->display('dio.html');
break;
}
?>