1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
| <%
dim conn
dim SQLQuery
dim RS
dim dd,df
dim date_debut,date_fin
dd = "01/" & Trim(Request.Form("m_debut"))& "/" & Trim(Request.Form("a_debut"))
select case Trim(Request.Form("m_fin"))
case "1","3","5","7","8","10","12"
df = "31/" & Trim(Request.Form("m_fin")) & "/" & Trim(Request.Form("a_fin"))
case "4","6","9","11"
df = "30/" & Trim(Request.Form("m_fin")) & "/" & Trim(Request.Form("a_fin"))
case "2"
if (clng(Request.Form("a_fin")) mod 4 = 0) then
df = "29/" & Trim(Request.Form("m_fin")) & "/" & Trim(Request.Form("a_fin"))
else
df = "28/" & Trim(Request.Form("m_fin")) & "/" & Trim(Request.Form("a_fin"))
end if
end select
date_debut = dateValue(dd)
date_fin = dateValue(df)
if date_debut > date_fin then
Response.Write "<Table >"
Response.Write "<TR>"
Response.Write " <td><font face=arial size=3 color=red><br><div align=center>La 2éme date de doit être supérieure à la 1ére date </div></font></td><br>"
Response.Write "<TR>"
Response.Write "<TD><br><a href=CHOIX.asp><b><font color=#663366><div align=center>RETOUR</der></font></b></a></TD>"
Response.Write "</TR>"
Response.Write "</TABLE>"
else
Set conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.createobject("ADODB.Recordset")
conn.Open session("nomDNS"),"PYRA","PYRADBA"
SQLQuery = "select n_incident,date_inc,rs1,nom,prenom,descrpt_inc,statut_inc from Pylog " & _
"inner join pyuaf on pyuaf.t_user = pylog.suid " & _
"inner join incident on incident.t_user = pyuaf.t_user " & _
"inner join adres on incident.t_adress_cli=adres.t_adres " & _
"inner join inter on incident.t_inter=inter.t_inter " & _
"where pylog.login = '" & Session("login") & "' " & _
"and incident.date_inc between '" & date_debut & "' and '" & date_fin & "' " & _
"order by n_incident"
Set RS = conn.Execute(SQLQuery)
If RS.BOF and RS.EOF then
Response.Write "<Table >"
Response.Write "<TR>"
Response.Write " <td><font face=arial size=4 color=#6699CC><div align=center> Aucune demande n'est deposée</div></font></td><br>"
'Response.Write sqlquery
Response.Write "</TR>"
Response.Write "</TABLE>"
else
Response.Write "<TR>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Numéro de l'incident</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Date de l'incident</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Société</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Interlocuteur</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Message</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Statut</div></b></font></TD>"
Response.Write "<TD bgcolor=#1772A2><font face=arial size=2 color=#FFFFFF><b><div align=center>Valider</div></b></font></TD>"
Response.Write "</TR>"
while not RS.EOF
Response.Write "<TR>"
Response.Write "<TD><div align=center>" & (RS("n_incident").value) & "</div></TD>"
Response.Write "<TD><div align=center>" & (RS("date_inc").value) & "</div></TD>"
Response.Write "<TD><div align=center>" & (RS("rs1").value) & "</div></TD>"
Response.Write "<TD><div align=center>" & (RS("nom").value) & "</div></TD>"
Response.Write "<TD><div align=center>" & (RS("descrpt_inc").value) & "</div></TD>"
if (RS("statut_inc").value = 0) then
Response.Write "<TD><div align=center><a href=valide.asp> Non encore Validé </a></div></TD>"
Response.Write "<TD><div align=center><form name=""form1"" method=""post"" action=""mail.asp""><input type=""submit"" name=""submit"" value=""Valider""></form></div></TD>"
else
Response.Write "<TD><div align=center> Validé </div> </TD>"
end if
Response.Write "</TR>"
RS.MoveNext
wend
end if
end if
%> |
Partager