/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. 

  2. 'Response.Buffer=false
    3. 

  3. Response.CodePage = 65001
    4. 

  4. Response.CharSet = "utf-8"

    5. 

  5. reportTitle = "گزارش تاخير سفارش ها"

    6. 

  6. %>

    7. 

  7. <!--#include File="../include_farsiDateHandling.asp"-->

    8. 

  8. <!--#include File="../include_JS_InputMasks.asp"-->

    9. 

  9. 

    10. 

  10. <!--#include File="reports_top.asp"-->

    11. 

  11. <%

    12. 

  12. 	dateFrom = request("dateFrom")

    13. 

  13. 	dateTo = request("dateTo")

    14. 

  14. 

    15. 

  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. 

  16. 	

    17. 

  17. %>

    18. 

  18. <!--#include File="reports_tah.asp"-->
    19.