{$$3220254690 . } 602E-shop - Detail položky <%WBC%> ErrorTemplate: err.htw RequiredValues: heslo jmeno sk_ru BeginProgram: www_find_id find_id(%sk_ru%, "%WDCENA%", "%W_NAZEV%", "%jmeno%", "%heslo%", "%W_SLEVA%", "%W_NOVINKA%","%W_kod%", "%W_cena_od%", "%W_cena_do%", "%W_vyrobce%", "%Wvyber%", "%check_kod%"); EndProgram; GetVariable: wid_last:= wwid_last GetVariable: wid_first:=wwid_first GetVariable: wid_prev:= wwid_prev GetVariable: wid_next:= wwid_next GetVariable: wpocet:= wwpocet GetVariable: wirec:= wwirec ;GetVariable: w_nazev:= ww_nazev SQLStatement: zbozi #ifexists + SELECT Cenik.id_cenik + FROM CENIK, S_DPH, vyrobci, SYS_PAR , S_TAB_ROUND + WHERE Cenik.ID_CENIK=%sk_ru% AND Cenik.vyrobce=vyrobci.id AND SYS_PAR.ROUND_IMP=S_TAB_ROUND.ID_ROUND + AND (s_dph.id_dph=cenik.dph) AND (s_dph.uc_rok=year(today)) AND SYS_PAR.vyrobci=TRUE #then + SELECT Cenik.id_cenik, Cenik.pozn, Cenik.htwtxt, Cenik.htwobr, Cenik.nazev_zbozi, cenik.jednotka, cenik.anotace, cenik.hmotnost, cenik.kod_zbozi, + %wdcena% as cenam, cenik.novinka, cenik.sleva, cenik.SLEVAPROC,cenik.skladem, ((Trunc((%wdcena%*(1.0+s_dph.procento/100.0))/S_TAB_ROUND.koef))*S_TAB_ROUND.koef) as cenap, vyrobci.nazev AS vyrobce + FROM CENIK, S_DPH, vyrobci, SYS_PAR , S_TAB_ROUND + WHERE Cenik.ID_CENIK=%sk_ru% AND Cenik.vyrobce=vyrobci.id AND SYS_PAR.ROUND_IMP=S_TAB_ROUND.ID_ROUND + AND (s_dph.id_dph=cenik.dph) AND (s_dph.uc_rok=year(today)) #else + SELECT Cenik.id_cenik, Cenik.pozn, Cenik.htwtxt, Cenik.htwobr, Cenik.nazev_zbozi, cenik.jednotka, cenik.anotace, cenik.hmotnost, cenik.kod_zbozi, + %wdcena% as cenam, cenik.novinka, cenik.sleva, cenik.SLEVAPROC,cenik.skladem, ((Trunc((%wdcena%*(1.0+s_dph.procento/100.0))/S_TAB_ROUND.koef))*S_TAB_ROUND.koef) as cenap, "" AS vyrobce + FROM CENIK, S_DPH, SYS_PAR , S_TAB_ROUND + WHERE Cenik.ID_CENIK=%sk_ru% AND SYS_PAR.ROUND_IMP=S_TAB_ROUND.ID_ROUND + AND (s_dph.id_dph=cenik.dph) AND (s_dph.uc_rok=year(today)) #endif SQLStatement: kody_skupiny +SELECT S_zbozi_sk.kod_skupiny AS kod +FROM S_zbozi_sk #if check_kod<>"" +WHERE s_zbozi_sk.kod_skupiny="%check_kod%" #endif SQLStatement: tlrabat #ifexists + SELECT S_deal_sk.mn_rab + FROM Obchodni_partneri, S_deal_sk + WHERE S_deal_sk.deal_id=Obchodni_partneri.deal_sk + AND (Obchodni_partneri.intr_user="%jmeno%" + AND Obchodni_partneri.intr_pswd="%heslo%") #then + SELECT S_deal_sk.mn_rab AS ANO + FROM Obchodni_partneri, S_deal_sk + WHERE S_deal_sk.deal_id=Obchodni_partneri.deal_sk + AND (Obchodni_partneri.intr_user="%jmeno%" + AND Obchodni_partneri.intr_pswd="%heslo%") #else + SELECT NZ_MNRAB AS ANO FROM Sys_par #endif SQLStatement: rabaty #ifexists + SELECT cenik.id_cenik,rabat FROM CENIK WHERE cenik.id_cenik=str2int("%sk_ru%") AND rabat<>NONEINTEGER #then + SELECT rabat.metoda, rabat.nad_mnoz, rabat.proc + FROM rabat, cenik + WHERE cenik.id_cenik=str2int("%sk_ru%") AND + rabat.metoda=cenik.rabat + ORDER BY rabat.metoda, rabat.nad_mnoz #else + SELECT rabat.metoda, rabat.nad_mnoz, rabat.proc + FROM s_zbozi_sk, rabat, cenik + WHERE cenik.id_cenik=str2int("%sk_ru%") AND + s_zbozi_sk.id_skupiny=cenik.skupina_zbozi AND rabat.metoda=s_zbozi_sk.rabat + ORDER BY rabat.metoda, rabat.nad_mnoz #endif <%/WBC%>

<%if wirec>1%> <%else%> <%endif%> /ceniks.wbc<%else%><%if wvyber="N"%>/cenikn.wbc<%else%><%if wvyber="J"%>/cenikj.wbc<%else%>/cenikmn.wbc<%endif%><%endif%><%endif%>"> /ceniks.wbc<%else%><%if wvyber="N"%>/cenikn.wbc<%else%><%if wvyber="J"%>/cenikj.wbc<%else%>/cenikmn.wbc<%endif%><%endif%><%endif%>"> <%if wirec <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>   
<%if wvyber="J"%> <%else%> <%endif%>  <%zbozi.kod_zbozi%> - <%zbozi.nazev_zbozi%>  
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>   
<%if zbozi.CurrentRecord > 0%> <%if wvyber="J"%> <%else%> <%endif%> <%if wvyber="M"%> <%else%> <%endif%>
<% if zbozi.htwtxt!="" %> <% endif %>
<%if zbozi.anotace<>""%> (<%zbozi.anotace%>) <%endif%>
<% if zbozi.htwobr=="" %>< obrázek zboží není k dispozici > <% else %><% if zbozi.htwtxt<>"" %><% endif %><%zbozi.nazev_zbozi%><% if zbozi.htwtxt<>"" %><% endif %> <% endif %>
Objednejte si:  <%zbozi.jednotka%> 
<%if zbozi.SLEVA%>Sleva <%zbozi.SLEVAPROC%>  %<% endif %>

<% zbozi.pozn %>
<%if zbozi.hmotnost>0 %> <%endif%> <%if zbozi.vyrobce<>"" %> <%endif%>
Cena bez DPH :  <% zbozi.cenam;-102 %>  Kč
Cena s DPH :  <% zbozi.cenap;-102 %> Kč
Hmotnost :  <% zbozi.hmotnost;-102 %> Kg
Výrobce :  <% zbozi.vyrobce;-102 %>
 <%if zbozi.sleva%>Sleva

<%endif%> <%if zbozi.novinka%>Novinka

<%endif%> <%if zbozi.skladem%>Skladem<%endif%>
<%if rabaty.totalcount > 0%> <%if tlrabat.ANO%> <%begindetail rabaty%> <%enddetail%>
Množstevní rabaty k vybrané položce
 Nad množství Sleva v % 
<%nad_mnoz;-102%> <%(1-proc)*100;-102%> 
<%endif%> <%endif%> 		 
podrobný popis zboží   
<%endif%>
<%if wirec>1%> <%else%> <%endif%> /ceniks.wbc<%else%><%if wvyber="N"%>/cenikn.wbc<%else%><%if wvyber="J"%>/cenikj.wbc<%else%>/cenikmn.wbc<%endif%><%endif%><%endif%>"> /ceniks.wbc<%else%><%if wvyber="N"%>/cenikn.wbc<%else%><%if wvyber="J"%>/cenikj.wbc<%else%>/cenikmn.wbc<%endif%><%endif%><%endif%>"> <%if wirec <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>   
<%if wvyber="J"%> <%else%> <%endif%>  <%zbozi.kod_zbozi%> - <%zbozi.nazev_zbozi%>  
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>
<%if wvyber="J"%> <%else%> <%endif%>