<?php include_once('head_g.php'); ?>
<?php include_once('head_d.php'); ?>
<?php include_once('header.php'); ?>
<?php include_once('levo.php'); ?>
<?php include_once('desno.php'); ?>
<div id="sredina">
<?
if($_GET[idkat2
] or
$_GET[idkat3
]) $vid="style='display:block;'"; else $vid="style='display:none;'";
?>
<div class="sortiranje"
<?=$vid?>>
<?
$ein=count(explode(",",$in));
if($_GET[idkat1
] and
($_GET[idkat2
] or
$_GET[idkat3
])) {
?>
<?=$_GET[tip
]?>
<div style="float:left; width:148px; height:30px; border-right:1px solid #cbcbcb; margin-top:7px; padding-left:19px;">
<?
if($_GET[tdc
]) $tdc=explode("-",$_GET[tdc
]);
$tiki=$tdc[0];
if(preg_match("/Black/",$tdc[0])) $tdc[0]="Black & Decker_72";
$fir=explode("_",$tdc[0]);
$dati=$tdc[1];
$ceni=$tdc[2];
?>
<strong>Izaberi proizvodjača:</strong>
<select name='naslov1' style='width:125px;' onchange="prikazis(this.options[this.selectedIndex].value)">
<?
if($tdc[1]!="" or
$tdc[2]!=""){
$fis="-$tdc[1]-$tdc[2]/"; $qus=$queryst1;}
else {$fis="/";$qus=$queryst11;}
?>
<option value='
<?=$qus?><?=$fis?>'>Svi proizvodjači</option>
<?
$sf=mysql_query("SELECT id,ime FROM firme WHERE id IN (SELECT idfirme FROM proizvodi_new WHERE katid IN($in))");
while($sf1=mysql_fetch_assoc($sf))
{
if($fir[1]==$sf1[id
]) $el="SELECTED"; else $el="";
echo "<option value="$querys$sf1[ime
]_
$sf1[id
]-$dati-$ceni/" $el>$sf1[ime]</option>";
}
?>
</select>
</div>
<div style="float:left; width:198px; height:30px; border-right:1px solid #cbcbcb; margin-top:7px; padding-left:18px;">
<strong>Sortiraj po ceni:</strong>
<select name='datum' style='width:165px;' onchange="prikazis(this.options[this.selectedIndex].value)">
<?
if($tdc[0]!="" or
$tdc[2]!=""){
$fis="$tdc[0]--$tdc[2]/";$qus=$queryst1;}
else {$fis="/";$qus=$queryst11;}
?>
<!-- <option value='
<?=$qus?><?=$fis?>'>Po nazivu A->Z</option> -->
<option value=''>-- odaberite --</option>
<?
if($_GET[tip
]) $ti="&tip=$_GET[tip]"; else $ti="";
if($_GET[cena
]) $cen="&cena=$_GET[cena]"; else $cen="";
$ti_cen=$ti.$cen;
if($tdc[1]==1) $sd1="SELECTED"; else $sd1="";
if($tdc[1]==2) $sd2="SELECTED"; else $sd2="";
if($tdc[1]==3) $sd3="SELECTED"; else $sd3="";
if($tdc[1]==4) $sd4="SELECTED"; else $sd4="";
if($tdc[1]==5) $sd5="SELECTED"; else $sd5="";
if($tdc[1]==6) $sd6="SELECTED"; else $sd6="";
if($tdc[1]==7) $sd7="SELECTED"; else $sd7="";
if($tdc[1]==8) $sd8="SELECTED"; else $sd8="";
?>
<!--
<option value="
<?=$querys?><?=$tiki?>-1-
<?=$ceni?>/"
<?=$sd1?>>Opadajuće po datumu</option>
<option value="
<?=$querys?><?=$tiki?>-2-
<?=$ceni?>/"
<?=$sd2?>>Rastuće po datumu</option>
-->
<option value="
<?=$querys?><?=$tiki?>-4-
<?=$ceni?>/"
<?=$sd4?>>Rastuće po ceni</option>
<option value="
<?=$querys?><?=$tiki?>-3-
<?=$ceni?>/"
<?=$sd3?>>Opadajuće po ceni</option>
<!--
<option value="
<?=$querys?><?=$tiki?>-5-
<?=$ceni?>/"
<?=$sd5?>>Po nazivu A->Z</option>
<option value="
<?=$querys?><?=$tiki?>-6-
<?=$ceni?>/"
<?=$sd6?>>Po nazivu Z->A</option>
<option value="
<?=$querys?><?=$tiki?>-7-
<?=$ceni?>/"
<?=$sd7?>>Po proizvodjacu A->Z</option>
<option value="
<?=$querys?><?=$tiki?>-8-
<?=$ceni?>/"
<?=$sd8?>>Po proizvodjacu Z->A</option>
-->
</select>
</div>
<div style="float:left; height:30px; margin-top:7px; padding-left:19px;">
<strong>Prikaži:</strong>
<select name='cena' style='width:110px;' onchange="prikazis(this.options[this.selectedIndex].value)">
<?
if($tdc[0]!="" or
$tdc[1]!=""){
$fis="$tdc[0]-$tdc[1]-/";$qus=$queryst1;}
else {$fis="/";$qus=$queryst11;}
?>
<option value='
<?=$qus?><?=$fis?>'>9 proizvoda</option>
<?
if($_GET[tip
]) $ti="&tip=$_GET[tip]"; else $ti="";
if($_GET[datum
]) $dat="&datum=$_GET[datum]"; else $dat="";
$ti_dat=$ti.$dat;
if($tdc[2]==3) $sc1="SELECTED"; else
if($tdc[2]==6) $sc2="SELECTED"; else
if($tdc[2]==12) $sc3="SELECTED"; else
if($tdc[2]==24) $sc4="SELECTED"; else
if($tdc[2]==48) $sc5="SELECTED"; else
{ $sc1="SELECTED"; $sc2=""; $sc3=""; $sc4=""; $sc5="";}
?>
<option value="
<?=$querys?><?=$tiki?>-
<?=$dati?>-6/"
<?=$sc2?>>6 proizvoda</option>
<option value="
<?=$querys?><?=$tiki?>-
<?=$dati?>-12/"
<?=$sc3?>>12 proizvoda</option>
<option value="
<?=$querys?><?=$tiki?>-
<?=$dati?>-24/"
<?=$sc4?>>24 proizvoda</option>
<option value="
<?=$querys?><?=$tiki?>-
<?=$dati?>-48/"
<?=$sc5?>>48 proizvoda</option>
</select>
</div>
<!-- end sortiranje --></div>
<script>
function prikazis(page)
{
var ura=page;
window.location=ura
}
</script>
<?
//if(($_GET[idkat2] or $_GET[idkat1]) and $_GET[idkat3]){echo "test";
if($_GET[idkat2
]) $ides=$idkats2; else $ides=$idkats1;
$kk=mysql_query("SELECT * FROM kateg_proizvoda_new WHERE id_parent=$ides");
if(mysql_num_rows($kk)>0){
?>
<img src="slicice/pozadina-proizvodi-l.gif" style="float:left;" />
<div style="width:auto; height:15px; float:left; background:url(slicice/pozadina-proizvodi-s.gif) repeat-x;padding:2px 0 3px 0px;">
<?
//if($_GET[idkat1] and ($_GET[idkat2] or $_GET[idkat3])) {
echo kategorije3
($idkats,$patH);
?>
</div>
<img src="slicice/pozadina-proizvodi-d.gif" style="float:left;" />
<div style="width:535px;min-height:80px;border:1px solid #cbcbcb; float:left; padding:5px;">
<?
while($kk1=mysql_fetch_assoc($kk))
{
$ci=mysql_query("SELECT * FROM proizvodi_new WHERE katid=$kk1[id] AND akt='Y'");
$ci1=mysql_num_rows($ci);
if($_GET[idkat2
]) $idv2="$_GET[idkat2]/"; else $idv2="";
echo "<a href='$patH/proizvodi/$_GET[idkat1]/$idv2$kk1[ime]__$kk1[id]/' class='sc1' style='color:#0087c5;font-size:11px;margin-right:40px;'>$kk1[ime] ($ci1)»</a> ";
}
$is= mysql_num_rows($kk);
?>
</div>
<?
}
//}
// }
}
if($_GET[idkat1
] and
!$_GET[idkat2
] and
!$_GET[idkat3
])
echo "</div>";
?>
<?
if(($is>0 and
!$_GET[idkat3
]) or
($_GET[idkat1
] and
!$_GET[idkat2
] and
!$_GET[idkat3
])){
?>
<div style="width:398px; height:24px; background:url(
<?=$patH?>/slicice/proizvodi.png); margin:5px 0 10px 0; padding:10px 0 0 150px; font-weight:bold; float:left;">
<div style='padding-left:10px;'>
<? echo kategorije3
($idkats,$patH); ?>
</div>
</div>
<?
}else{
?>
<div style="width:398px; height:24px; background:url(
<?=$patH?>/slicice/proizvodi1.png); margin:5px 0 10px 0; padding:10px 0 0 150px; font-weight:bold; float:left;">
<div style='padding-left:10px;'>
<? echo kategorije3
($idkats,$patH); ?>
</div>
</div>
<?
}
?>
<table border="0" width="99%" cellspacing="0" cellpadding="0">
<tr>
<!-- body_text //-->
<td width="100%" valign="top">
<?
if($_GET[idkat2
] or
$_GET[idkat3
]) $nastr=9; else $nastr=6;
if($tdc[2]) $ByPage1=$tdc[2]; else $ByPage1=$nastr;
if($_GET[link2
]) $Start1=$_GET[link2
]; else $Start1=0;
if($tdc[0]) $idfirme=" AND proizvodi_new.idfirme='$fir[1]'";
if($tdc[1]==1) $orderby="ORDER BY proizvodi_new.id DESC"; else
if($tdc[1]==2) $orderby="ORDER BY proizvodi_new.id ASC"; else
if($tdc[1]==3) $orderby="ORDER BY trenutna_cena DESC"; else
if($tdc[1]==4)
$orderby="ORDER BY trenutna_cena ASC";
//$orderby=" ORDER BY cena1=if(cena1>cena,-1,-1 ) ASC, cena ASC";
else
if($tdc[1]==5) $orderby="ORDER BY proizvodi_new.naslov ASC"; else
if($tdc[1]==6) $orderby="ORDER BY proizvodi_new.naslov DESC"; else
if($tdc[1]==7) $orderby="ORDER BY firme.ime ASC"; else
if($tdc[1]==8) $orderby="ORDER BY firme.ime DESC";
else $orderby="ORDER BY proizvodi_new.naslov ASC";
//$pr=mysql_query("SELECT * FROM proizvodi_new WHERE akt='Y' AND katid IN ($in) $idfirme $orderby LIMIT $Start1,$ByPage1");
if($ein>1){
$pr=mysql_query("SELECT*, IFNULL(cena1, cena) AS trenutna_cena,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.katid IN ($in) $idfirme AND idtip LIKE '%-2-%' $orderby LIMIT $Start1,$ByPage1");
if(mysql_num_rows($pr)==0)
{
$pr=mysql_query("SELECT naslov,naslov1,opis,slika1,cena,cena1,nalageru, idtip,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.cena1>0 AND proizvodi_new.katid IN ($in) $idfirme ORDER BY RAND() LIMIT 6");
}
$ukup=mysql_query("SELECT*, IFNULL(cena1, cena) AS trenutna_cena,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.katid IN ($in) $idfirme AND idtip LIKE '%-2-%'");
if(mysql_num_rows($pr)==0)
{
echo "<div style='width:100%;margin-top:30px;text-align:center;padding-bottom:30px;font-size:14px;'>Trenutno nema akcija u ovoj kategoriji!</div>";
}
}
else
//$pr=mysql_query("SELECT naslov,naslov1,opis,slika1,cena,cena1,nalageru, idtip,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.katid IN ($in) $idfirme $orderby LIMIT $Start1,$ByPage1");
{
$pr=mysql_query("SELECT *, IFNULL(cena1, cena) AS trenutna_cena,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.katid IN ($in) $idfirme $orderby LIMIT $Start1,$ByPage1");
$ukup=mysql_query("SELECT *, IFNULL(cena1, cena) AS trenutna_cena,proizvodi_new.id as 'idd' FROM proizvodi_new WHERE proizvodi_new.akt='Y' AND proizvodi_new.katid IN ($in) $idfirme");
}
$br_prik=mysql_num_rows($pr);
$n=0;
while($pr1=mysql_fetch_assoc($pr)){
if($pr1[id
]=="" and
$pr1[naslov1
]=="panasonic_klima_cu_uw12gke") $pr1[id
]=4204;
$b=$n%3;
if($b==0 and
$n>0)
echo "<div style='float:left;width:100%;height:10px;'></div>";
$cen= format_cene
($pr1[id
]);
$cene=explode("-",$cen);
$akc=preg_match("/-2-/",$pr1[idtip
]);
$best=preg_match("/-6-/",$pr1[idtip
]);
?>
<div class="prikaz">
<div style="text-align:center; width:170px; height:155px; margin-top:5px;">
<a href='
<?=$patH?>/proizvodi_info/
<? echo "$pr1[naslov1]__$pr1[id]/"; ?>'>
<?
$fi=mysql_query("SELECT * FROM firme WHERE id='$pr1[idfirme]'");
$fi1=mysql_fetch_array($fi);
$img=image_size1
($higs,'',$pr1[slika1
],"images");
$im=explode("-",$img);
echo "<img src='$patH/images/$pr1[slika1]' border='0' alt='".stripslashes("$pr1[naslov]")."' title='".stripslashes("$pr1[naslov]")."' width='$im[0]' height='$im[1]' /></a>";
//echo "<img src='$patH/thumb/$pr1[slika1]/$im[0]/150/' border='0' alt='".stripslashes("$pr1[naslov]")."' title='".stripslashes("$pr1[naslov]")."' width='$im[0]' height='150'></a>";
if($pr1[nalageru
]==0)
echo "<span style='color:red;font-weight:bold;'>NEMA NA LAGERU</span>";
else echo "";
?>
</div>
<div style="text-align:center; padding:5px; width:160px; height:40px;">
<a class="ml5" href="
<?=$patH?>/proizvodi_info/
<? echo "$pr1[naslov1]__$pr1[id]/";?>">
<?
//echo stripslashes("$fi1[ime]")." ".stripslashes("$pr1[naslov]");
echo stripslashes("$pr1[naslov]");
?>
</a>
</div>
<div class="sc2" style="vertical-align:top; height:35px; margin-left:10px;"><!--div za cenu-->
<?
if($cene[1]>0){
?>
<s style="color:#7F7F7F; font-size:9px">
<?
}
echo $cene[0];
?>
<span class="currency_symbol">
<?=$din?></span>
<?
if($cene[1]>0){
?>
</s>
<span style="color: #ff0000">
<span class="currency_symbol"></span>
<?
echo $cene[1];
?>
<span class="currency_symbol">
<?=$din?></span></span>
<?
}
?>
</div>
<div style="margin-left:5px; float:left; height:35px;">
<a href="javascript:void(0)" onclick="displaySubs(
<?=$pr1[id
]?>,'yes','
<?=$patH?>',this);" onmouseout="hides('info');">
<img src="
<?=$patH?>/images/buttons/dodaj.gif" border="0" alt="Kupi belu tehniku" title="Kupovina bele tehnike" width="98" height="20" /></a>
</div>
<?
if($best==1){
?>
<img src='
<?=$patH?>/slicice/best_bay.gif' width='51' height='40' class='akcija_gif' />
<?
}else
if($cene[1]>0 and
$akc==1){
?>
<img src='
<?=$patH?>/slicice/akcija.gif' width='51' height='40' class='akcija_gif' />
<?
}
?>
<!-- end prikaz --></div>
<?
$n++;
}
?>
<div id='info' ><div style='padding:3px;'>Prebačno u korpu</div></div>
</td>
<!-- body_text_eof //-->
</tr>
</table>
<?
$br_zapisa=mysql_num_rows($ukup);
?>
<div class="smallText" style="float:left; padding-top:8px;">
<?
if($_GET[link2
]==0) $jed=1; else $jed=0;
$od=$_GET[link2
]+$jed;
$do=$br_prik+$_GET[link2
];
echo "Prikazano <b>$od</b> - <b>$do</b> (od ukupno <b>$br_zapisa</b> proizvoda)";
?>
</div>
<div class="smallText" style="float:right;">
<?
include("$page_path2/pagin.php");
if($_GET[tdc
]) $tdce="$tiki-$dati-$ceni"; else $tdce="";
if($_GET[idkat1
] and
($_GET[idkat2
] or
$_GET[idkat3
] or
$ein>1))
pagin
($br_zapisa,$ByPage1,"$_GET[link2]","$querys$tdce/");
?>
</div>
<div style="width:548px; height:20px; background:url(
<?=$patH?>/slicice/gradient.gif) bottom no-repeat;"></div>
<?
$on=mysql_query("SELECT * FROM strane WHERE id_page='".idpages
("azuriranje.php","slo")."' AND akt='Y'");
while($on1=mysql_fetch_assoc($on))
{
echo "";
if(strlen($on1[naslov
])>0)
echo "<span >$on1[naslov]</span>";
opis
(1,$on1[opis
],"","","");
echo "";
read_images
($on1[id
],$idpage,"idstrane",184,177,"$on1[naslov]");
}
?>
<!-- end #sredina --></div>
<br class="clearfloat" />
<?php include_once('footer.php'); ?>