PageRenderTime 63ms CodeModel.GetById 58ms app.highlight 1ms RepoModel.GetById 2ms app.codeStats 0ms

/beta/reports/orders_latency.asp

http://github.com/khaneh/Orders
ASP | 20 lines | 14 code | 5 blank | 1 comment | 0 complexity | 882a21309c7c9d506d5d6ae121d294a4 MD5 | raw file
 1<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><%
 2'Response.Buffer=false
 3Response.CodePage = 65001
 4Response.CharSet = "utf-8"
 5reportTitle = "گزارش تاخير سفارش ها"
 6%>
 7<!--#include File="../include_farsiDateHandling.asp"-->
 8<!--#include File="../include_JS_InputMasks.asp"-->
 9
10<!--#include File="reports_top.asp"-->
11<%
12	dateFrom = request("dateFrom")
13	dateTo = request("dateTo")
14
15	mySQL = "SELECT orders_trace.radif_sefareshat AS [شماره سفارش], orders_trace.salesperson AS [سفارش گيرنده], orders_trace.order_date AS [تاريخ سفارش], orders_trace.return_date AS [موعد تحويل], OrderTraceLog.InsertedDate AS [تاريخ آماده تحويل], dbo.diffDate(OrderTraceLog.InsertedDate,  orders_trace.return_date) AS تاخير, orders_trace.order_kind AS [نوع سفارش], orders_trace.Type AS [كد نوع] FROM OrderTraceLog RIGHT OUTER JOIN orders_trace ON OrderTraceLog.[Order] = orders_trace.radif_sefareshat WHERE (OrderTraceLog.Step = 10) AND (orders_trace.order_date >= N'" & dateFrom & "') AND (orders_trace.order_date <= N'" & dateTo & "')"
16	
17%>
18<!--#include File="reports_tah.asp"-->
19
20