/beta/reports/orders_latency.asp
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