{$$3220259140 . } 602ESHOP - Detail položky <%WBC%> ErrorTemplate: err.htw RequiredValues: heslo jmeno objednavka polozka BeginProgram: www_cenik dealcena("%?jmeno%","%?heslo%"); EndProgram; GetVariable: wdcena:=dcena GetVariable: jmeno:=w_jmeno GetVariable: heslo:=w_heslo SQLStatement: zbozi #ifexists + SELECT Cenik.id_cenik + FROM CENIK, OBJ_POLOZKY, S_DPH, vyrobci, SYS_PAR , S_TAB_ROUND + WHERE OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk 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.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, OBJ_POLOZKY, S_DPH, vyrobci, S_TAB_ROUND, SYS_PAR + WHERE OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk 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 Cenik.vyrobce=vyrobci.id #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, OBJ_POLOZKY, S_DPH, SYS_PAR , S_TAB_ROUND + WHERE OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk 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: 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 , OBJ_POLOZKY + WHERE OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk AND rabat<>NONEINTEGER #then + SELECT rabat.metoda, rabat.nad_mnoz, rabat.proc + FROM rabat, cenik , OBJ_POLOZKY + WHERE rabat.metoda=cenik.rabat AND + OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk + ORDER BY rabat.metoda, rabat.nad_mnoz #else + SELECT rabat.metoda, rabat.nad_mnoz, rabat.proc + FROM s_zbozi_sk, rabat, cenik , OBJ_POLOZKY + WHERE OBJ_POLOZKY.id_dobj=%objednavka% AND OBJ_POLOZKY.id_pol=%polozka% AND + Cenik.ID_CENIK=OBJ_POLOZKY.id_cnk AND + s_zbozi_sk.id_skupiny=cenik.skupina_zbozi AND rabat.metoda=s_zbozi_sk.rabat + ORDER BY rabat.metoda, rabat.nad_mnoz #endif SQLStatement: skupiny +SELECT S_zbozi_sk.kod_skupiny AS kod +FROM S_zbozi_sk #if W_check_kod<>"" +WHERE ( #repeat var=check_kod delimiter=` OR ` + s_zbozi_sk.kod_skupiny="%check_kod%" #endrepeat + ) #endif <%/WBC%>
<%if zbozi.CurrentRecord > 0%>
 <%zbozi.kod_zbozi%> - <%zbozi.nazev_zbozi%>
<%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 %>
<%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%> 		 
<%endif%>
Zpět na předchozí stránku