Kod:
rssql = ("select*from agent WHERE sip = '"& Request.form("link") &"' AND tarih >= '"& Request.form("tarih1") &"' and tarih <= '"& Request.form("tarih2") &"' ")
bu
Kod:
<%
Response.Buffer = True
if session("uye_id")<0 or session("uye_id")="" then
response.redirect "../login.asp"
end if
%>
<html>
<head>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>AGENT Kontrol</title>
</head>
<body *****font-family: Verdana; font-size: 10pt; word-spacing: 0; text-align: Justify; margin: 0">
<center><img src="../img/header.jpg" height="300" width="1300"></center>
<table border=2>
<tr>
<td width="50"><font size="1" face="Verdana"><center><font color="blue"><center> <a href="../s_kontrol.asp"><img src="img/geri.png" height="32" width="32"><br></a></center> </font></font></td>
</tr>
<tr>
<td width="20" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>ID</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Agent</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Cevaplandı</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Cevap Yok</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Görevi</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Sip No</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Saniye</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Dakika</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Saat</b></center></font></font></td>
<td width="200" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Tarih</b></center></font></font></td>
<td width="50" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Grafik</b></center></font></font></td>
<td width="50" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>İncele</b></center></font></font></td>
<td width="50" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b>Düzenle</b></center></font></font></td>
<td width="20" bgcolor=gray><font size="2" face="Verdana"><font color="#F2F2F2"><center><b><b>Sil</b></center></font></font></td>
</tr>
<%
Dim toplama
toplama = 0
Dim cevap1
cevap1 = 0
Dim cevap2
cevap2 = 0
%>
<%
vt="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("../agent.mdb")
set conn = Server.CreateObject("adodb.connection")
set rs = Server.CreateObject("adodb.recordset")
conn.open vt
rssql = ("select*from agent WHERE sip = '"& Request.form("link") &"' AND tarih >= '"& Request.form("tarih1") &"' and tarih <= '"& Request.form("tarih2") &"' ")
rs.open rssql, conn, 1, 3
If rs.eof or rs.bof then
Response.Write "<font face=verdana size=2 color=#ff3300><b><center>Kayıtlı Veri Bulunmamaktadır.</center></b></font>"
Response.end
end if
sayfa = Request.QueryString("sayfa")
If sayfa="" Then sayfa=1
rs.pagesize = 5555 'her sayfadaki veri sayısı
rs.absolutepage = sayfa
sayfa_sayisi = rs.pagecount
for i=1 to rs.pagesize
if rs.eof then
exit for
end if
id = request("id")
ad = Request.Form("ad")
soyad = Request.Form("soyad")
durum1 = Request.Form("durum1")
durum2 = Request.Form("durum2")
gorev = Request.Form("gorev")
sip = Request.Form("sip")
sn = Request.Form("sn")
dk = Request.Form("dk")
sa = Request.Form("sa")
cevap1 = (cevap1 + rs("durum1"))
cevap2 = (cevap2 + rs("durum2"))
toplama = (toplama + rs("sn"))
dakika = toplama/60
saat = dakika/60
%>
<tr>
<td width="20"><font size="1" face="Verdana"><center><%=rs("id")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("ad")%> <%=rs("soyad")%></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("durum1")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("durum2")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("gorev")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("sip")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("sn")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("dk")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("sa")%></center></font></td>
<td width="200"><font size="1" face="Verdana"><center><%=rs("tarih")%></center></font></td><br>
<td width="20"><font size="1" face="Verdana"><center><a onclick="window.open(this.href,'','resizable=no,location=no,menubar=no,scrollbars=no,status=no,toolbar=no,fullscreen=no,dependent=no,width=450,height=450,status'); return false" href="../grafik.asp?id=<%=rs("id")%>"><img src="img/grafik.png" height="32" width="32"></a></font></td>
<td width="50"><font size="1" face="Verdana"><center><font color="blue"><center> <a href="../s_incele.asp?id=<%=rs("id")%>"><img src="img/incele.png"height="32" width="32"></a></center> </font></font></td>
<td width="50"><font size="1" face="Verdana"><center><font color="orange"><center> <a href="../s_duzenle.asp?id=<%=rs("id")%>"><img src="img/duzenle.png" height="32" width="32"></a></center> </font></font></td>
<td width="20"><font size="1" face="Verdana"><center><font color="red"><a href="../s_sil.asp?id=<%=rs("id")%>"><img src="img/sil.png" height="32" width="32"></a></font></font></td>
</tr>
<%rs.movenext
Next%>
<center>Toplam kayıt: <font color="red"><b><%=rs.recordcount%></b></font></center><br><br>
<span class="style3">Cevaplanan Çağrı :<font color="green"><b><%=cevap1%></b></font> (Adet)</span><br>
<span class="style3">Cevapsız Çağrı :<font color="green"><b><%=cevap2%></b></font> (Adet)</span><br>
<span class="style3">Toplam Konusma Süresi :<font color="green"><b><%=toplama%></b></font> (Saniye)</span><br>
<span class="style3">Toplam Konusma Süresi :<font color="green"><b><%=dakika%></b></font> (dakika)</span><br>
<span class="style3">Toplam Konusma Süresi :<font color="green"><b><%=saat%></b></font> (saat)</span><br>
</table>
</body></html>