home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2000 May
/
Chip_2000-05_cd1.bin
/
tema
/
SW602
/
Winbase
/
EShop_start
/
ODESLANI.WWW
< prev
next >
Wrap
Text File
|
2000-03-21
|
9KB
|
208 lines
{$$3220261109 . }<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//CZ">
<HTML>
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="TEXT/HTML; CHARSET=WINDOWS-1250">
<META NAME="AUTHOR" CONTENT="Software602 - Pdur">
<META NAME="Keywords" CONTENT=" ">
<TITLE>602ESHOP - Pokladna</TITLE>
<STYLE TYPE="text/css">
<!--
.white { font-size: 12pt; font-family: Arial; color: #FFFFFF }
.invblue { font-size: 14pt; font-family: Arial; color: #104080; background: #FFFFFF }
.lightblue { font-size: 12pt; font-family: Arial; color: #BDE7FF }
.blue8 { font-size: 8pt; font-family: Arial; color: #104080; background: #BDE7FF }
.black8 { font-size: 8pt; font-family: Arial; color: #000000; background: #BDE7FF }
.blue9 { font-size: 9pt; font-family: Arial; color: #104080; background: #BDE7FF }
.black9 { font-size: 8pt; font-family: Arial; color: #000000; background: #FFFFFF }
.black9c { font-size: 9pt; font-family: Arial; color: #000000; }
.orange { font-size: 9pt; color: #ff8000; }
-->
</STYLE>
</HEAD>
<%WBC%>
ErrorTemplate: err.htw
RequiredValues: heslo jmeno objednavka
SQLStatement: defaultdoprava
#ifexists
+ SELECT zpusob
+ FROM Obchodni_partneri, S_deal_sk, Spoj_doprava,s_doprava, default_hodnoty
+ WHERE default_hodnoty.ZP_DOPRAV=s_doprava.ID_DOPRAVA AND S_doprava.id_doprava=Spoj_doprava.id_doprava
+ AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=Obchodni_partneri.deal_sk
+ AND (obchodni_partneri.intr_user="%jmeno%" AND obchodni_partneri.intr_pswd="%heslo%")
#then
+ SELECT zpusob
+ FROM Obchodni_partneri, S_deal_sk, Spoj_doprava,s_doprava, default_hodnoty
+ WHERE default_hodnoty.ZP_DOPRAV=s_doprava.ID_DOPRAVA AND S_doprava.id_doprava=Spoj_doprava.id_doprava
+ AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=Obchodni_partneri.deal_sk
+ AND (obchodni_partneri.intr_user="%jmeno%" AND obchodni_partneri.intr_pswd="%heslo%")
#else
+ SELECT zpusob
+ FROM Obchodni_partneri, S_deal_sk, Spoj_doprava,s_doprava, default_hodnoty
+ WHERE default_hodnoty.ZP_DOPRAV=s_doprava.ID_DOPRAVA AND S_doprava.id_doprava=Spoj_doprava.id_doprava
+ AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=0
#endif
SQLStatement: typuziv
+ SELECT nazev_typ, id_typ FROM s_typ_uziv
SQLStatement: doprava
#ifexists
+ SELECT S_doprava.id_doprava,S_doprava.zpusob,S_doprava.popis,S_doprava.kod
+ FROM Obchodni_partneri, S_deal_sk, Spoj_doprava, S_doprava
+ WHERE S_doprava.id_doprava=Spoj_doprava.id_doprava AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=Obchodni_partneri.deal_sk
+ AND (obchodni_partneri.intr_user="%jmeno%" AND obchodni_partneri.intr_pswd="%heslo%")
#then
+ SELECT S_doprava.id_doprava,S_doprava.zpusob,S_doprava.popis,S_doprava.kod
+ FROM Obchodni_partneri, S_deal_sk, Spoj_doprava, S_doprava
+ WHERE S_doprava.id_doprava=Spoj_doprava.id_doprava AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=Obchodni_partneri.deal_sk
+ AND (obchodni_partneri.intr_user="%jmeno%" AND obchodni_partneri.intr_pswd="%heslo%")
#else
+ SELECT S_doprava.id_doprava,S_doprava.zpusob,S_doprava.popis,S_doprava.kod
+ FROM S_deal_sk, Spoj_doprava, S_doprava
+ WHERE S_doprava.id_doprava=Spoj_doprava.id_doprava AND Spoj_doprava.id_dealsk=S_deal_sk.deal_id
+ AND S_deal_sk.deal_id=0
#endif
BeginProgram:w_copy_vars
w_dat();
EndProgram;
GetVariable: KDY:=datum_dodani
SQLStatement: obj
#ifexists
+ SELECT OBJ_HEADER.id_dobj
+ FROM OBJ_HEADER, S_doprava
+ WHERE id_dobj=%objednavka% AND S_doprava.kod=Obj_header.doprav
#then
+ SELECT OBJ_HEADER.id_dobj,OBJ_HEADER.cis_eob,OBJ_HEADER.datum,OBJ_HEADER.pozn,OBJ_HEADER.datum_d,S_doprava.zpusob
+ FROM OBJ_HEADER, S_doprava
+ WHERE id_dobj=%objednavka% AND S_doprava.kod=Obj_header.doprav
#else
+ SELECT OBJ_HEADER.id_dobj,OBJ_HEADER.cis_eob,OBJ_HEADER.datum,OBJ_HEADER.pozn,OBJ_HEADER.datum_d, "" AS zpusob
+ FROM OBJ_HEADER
+ WHERE id_dobj=%objednavka%
#endif
SQLStatement: novy
#ifexists
+ SELECT S_typ_uziv.id_typ,S_typ_uziv.nazev_typ, Obchodni_partneri.intr_user
+ FROM Obj_header, Obchodni_partneri, S_typ_uziv
+ WHERE (Obchodni_partneri.id=Obj_header.id_org) AND (id_dobj=%objednavka%)
+ AND (Obchodni_partneri.intr_user<>"") AND (S_typ_uziv.id_typ=Obchodni_partneri.typ)
#then
+ SELECT S_typ_uziv.id_typ,S_typ_uziv.nazev_typ, Obchodni_partneri.intr_user
+ FROM Obj_header, Obchodni_partneri, S_typ_uziv
+ WHERE (Obchodni_partneri.id=Obj_header.id_org) AND (id_dobj=%objednavka%)
+ AND (Obchodni_partneri.intr_user<>"") AND (S_typ_uziv.id_typ=Obchodni_partneri.typ)
#else
+ SELECT DEFAULT_HODNOTY.TYP_UZIV, "" AS intr_user
+ FROM DEFAULT_HODNOTY
#endif
<%/WBC%>
<body LEFTMARGIN=0 TOPMARGIN=0 BGCOLOR="#FFFFFF" background="/catalog/back_bd2.gif">
<div align="center" style="width: 580px;">
<!--<div align="RIGHT" class="black">-->
<%if obj.totalcount > 0%>
<FORM METHOD=POST ACTION="<%wb_url%>/pokladnawbc.wbc">
<INPUT TYPE="hidden" NAME="jmeno" VALUE="<%jmeno%>">
<INPUT TYPE="hidden" NAME="heslo" VALUE="<%heslo%>">
<INPUT TYPE="hidden" NAME="objednavka" VALUE="<%objednavka%>">
<INPUT TYPE="hidden" NAME="cena" VALUE="<%cena;-102%>">
<INPUT TYPE="hidden" NAME="cenaDPH" VALUE="<%cenaDPH;-102%>">
<INPUT type="hidden" NAME="W_nazev" VALUE="">
<INPUT type="hidden" NAME="sk_ru" VALUE="">
<INPUT TYPE="hidden" NAME="showerror" VALUE="0">
<INPUT TYPE="hidden" NAME="wbegin" VALUE="0">
<INPUT TYPE="hidden" NAME="wvyber" VALUE="N">
<div align="CENTER" style="width: 580px;">
<BR>
<!--
<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="0" BGCOLOR="#104080">
<TR>
<TD ALIGN="LEFT" ><STRONG><SPAN CLASS="white">Objednßvka Φφslo </SPAN><SPAN CLASS="invblue"> <%obj.cis_eob%> </SPAN><SPAN CLASS="white"> ze dne <%obj.datum%> </SPAN></strong> </TD>
</TR>
</TABLE>
-->
<SPAN CLASS="invblue"><STRONG>Objednßvka Φφslo <%obj.cis_eob%> ze dne <%obj.datum%> </SPAN></strong>
<BR>
<BR>
<font face="Arial" size="2" color="#104080"> <strong>Zvolte zp∙sob dodßnφ a platby: </strong> </font> <BR><BR>
<TABLE BORDER="2" CELLSPACING="1" CELLPADDING="0" BGCOLOR="#DEdede">
<%begindetail doprava%>
<TR>
<TD ALIGN="LEFT" BGCOLOR="#BDE7FF"><SPAN CLASS="blue9"><strong> <%zpusob%> </strong><BR></SPAN>
<SPAN CLASS="black8"> <%popis%> </SPAN>
</TD>
<%if obj.zpusob=""%>
<%if defaultdoprava.totalcount>0%>
<TD ALIGN="CENTER" BGCOLOR="#BDE7FF"><SPAN CLASS="blue9"><INPUT TYPE="RADIO" NAME="w_zpusob" <%if (zpusob=defaultdoprava.zpusob) OR (currentrecord=1)%>CHECKED<%endif%> VALUE="<%zpusob%>"></SPAN></TD>
<%else%>
<TD ALIGN="CENTER" BGCOLOR="#BDE7FF"><SPAN CLASS="blue9"><INPUT TYPE="RADIO" NAME="w_zpusob" <%if currentrecord=1%>CHECKED<%endif%> VALUE="<%zpusob%>"></SPAN></TD>
<%endif%>
<%else%>
<TD ALIGN="CENTER" BGCOLOR="#BDE7FF"><SPAN CLASS="blue9"><INPUT TYPE="RADIO" NAME="w_zpusob" <%if (zpusob=obj.zpusob) OR (currentrecord=1)%>CHECKED<%endif%> VALUE="<%zpusob%>"></SPAN></TD>
<%endif%>
</TR>
<%enddetail%>
</TABLE>
<table width="570" border="0">
<TR ALIGN="CENTER"><td CLASS="black9c"><B>Poznßmka:</B><br></TD></TR>
<TR ALIGN="CENTER"><td CLASS="black9c"><input type="Text" name="w_POZN" value="<%obj.pozn%>" size="50%"></B></TD>
</TR></table>
<BR>
<font face="Arial" size="2" color="#104080"> <strong>Nejbli₧Üφ mo₧n² termφn dodßnφ:</strong></FONT><font face="Arial" size="2" color="#FF0000"><strong> <%kdy%></strong></FONT>
<BR>
<div align="CENTER" style="width: 580px;"><font face="Arial" size="2" color="#104080"> <strong>Vßmi po₧adovan² termφn dodßnφ: </strong></FONT>
<%if obj.datum_d>kdy%>
<input type="Text" name="w_datum_d" value="<%obj.datum_d%>" size="10">
<%else%>
<input type="Text" name="w_datum_d" value="<%kdy%>" size="10">
<%endif%>
</B><BR>
<font face="Arial" size="1" color="#104080"> <strong>Zadßnφ kratÜφho termφnu dodßnφ nenφ brßno v ·vahu.</strong></FONT>
<BR><BR>
<%if novy.intr_user="" %>
<div align="CENTER" style="width: 580px;"><font face="Arial" size="2" color="#104080"> <strong>Budete nadßle objednßvat jako: </strong></FONT>
<TABLE BORDER="0" CELLSPACING="1" CELLPADDING="0" BGCOLOR="#BDE7FF">
<%begindetail typuziv%>
<TR>
<TD ALIGN="LEFT" BGCOLOR="#BDE7FF"><SPAN CLASS="blue8"><%nazev_typ%> </TD>
<TD ALIGN="CENTER" BGCOLOR="#BDE7FF"><SPAN CLASS="blue8"><INPUT TYPE="RADIO" NAME="W_typ" <%if id_typ=novy.typ_uziv%>CHECKED<%endif%> VALUE="<%id_typ%>"></TD>
</TR>
<%enddetail%>
</TABLE>
<%else%>
<INPUT type="hidden" NAME="W_typ" VALUE=<%novy.id_typ%>>
<%endif%>
<BR>
<div align="CENTER" style="width: 580px;">
<INPUT CLASS="black9c" TYPE="submit" NAME="DalÜφ" VALUE="DalÜφ">
</FORM>
</div>
<%else%>
<br>
<div align="CENTER" style="width: 570px;">
<b><FONT SIZE="2" COLOR="#104080">Objednßvka nebyla nalezena. Bu∩ nebyla zalo₧ena nebo byla u₧ zruÜena.<BR>Zobrazte si polo₧ky naÜeho katalogu a objednejte si.</FONT></b>
</div>
<%endif%>
</DIV>
</BODY>
</HTML><font size="-3" color="#FFFFFF">