+ a.id_dobj=str2int("%objednavka%") AND b.id_cnk=cenik.id_cenik
+ ORDER BY b.ID_POL
#endif
SQLStatement: celkem
#ifexists
+ SELECT sum_cena
+ FROM obj_header
+ WHERE id_dobj=%obj_so% AND sum_cena>0
#then
+ SELECT sum_cena, ob_sleva, sum_obj, SUMVAHA, K_UHRADE, (CAST((K_UHRADE*100) AS INT)) AS CASTKA, POSTOVNE, 0.00 AS nula, (ob_sleva/sum_cena) AS w_sleva
+ FROM obj_header
+ WHERE id_dobj=%obj_so%
#else
+ SELECT sum_cena, ob_sleva, sum_obj, SUMVAHA, K_UHRADE, (CAST((K_UHRADE*100) AS INT)) AS CASTKA, POSTOVNE, 0.00 AS nula, (0.00) AS w_sleva
+ FROM obj_header
+ WHERE id_dobj=%obj_so%
#endif
SQLStatement: sys_par
+ SELECT round_sum,(today+sys_par.splatnost) AS splatnost, (today) AS vystaveni FROM Sys_par
<%if ((CurrentRecord=1) OR (CurrentRecord=3) OR (CurrentRecord=5) OR (CurrentRecord=7) OR (CurrentRecord=9) OR (CurrentRecord=11) OR (CurrentRecord=13) OR (CurrentRecord=15) OR (CurrentRecord=17) OR (CurrentRecord=19) OR (CurrentRecord=21) OR (CurrentRecord=23) OR (CurrentRecord=25)) %>
<%if (platbaEXB.ex_server<>"") AND (platbaEXB.ex_shop<>"") AND (platbaEXB.ex_ucet<>"") AND (platbaEXB.ex_kod_b<>"") AND (obj.cis_eob<>"") AND (platbaEXB.k_symb<>"") AND (platbaEXB.backurl<>"")%>