602E-Shop
<%WBC%>
ErrorTemplate: err.htw
SQLStatement: top_zbozi [0+10]
+ SELECT Cenik.id_cenik, Cenik.PORADITOP, Cenik.anotace, Cenik.kod_zbozi, Cenik.htwobr, Cenik.htwtxt, Cenik.nazev_zbozi, cenik.jednotka, Cenik.pozn, cenik.novinka, cenik.sleva, cenik.skladem,
+ min_cena as cenam, ((Trunc((min_cena*(1.0+s_dph.procento/100.0))/S_TAB_ROUND.koef))*S_TAB_ROUND.koef) as cenamp
+ FROM CENIK, S_DPH , SYS_PAR , S_TAB_ROUND
+ WHERE Cenik.top=TRUE AND SYS_PAR.ROUND_IMP=S_TAB_ROUND.ID_ROUND
+ AND (s_dph.id_dph=cenik.dph) AND (s_dph.uc_rok=year(today))
+ ORDER BY Cenik.PORADITOP
<%/WBC%>
<%if top_zbozi.CurrentRecord > 0%>
<%CURRENT_DATE%>
uvedeno v koncových cenách
<%begindetail top_zbozi%>
<% kod_zbozi %> - <% nazev_zbozi %>
<% anotace %>
<% if htwobr=="" %>< obrázek zboží není k dispozici >
<% else %><% if htwtxt<>"" %><% endif %><% if htwtxt<>"" %><% endif %>
<% endif %>
<%if sleva%> <%endif%>
<%if novinka%> <%endif%>
<%if skladem%><%endif%>
<% pozn %>
<% cenam;-102 %> Kč
<% cenamp;-102 %> Kč
<%if (currentRecord=2) OR (currentRecord=4) OR (currentRecord=6) OR (currentRecord=8) OR (currentRecord=10)%>
<%endif%>
<%enddetail%>