/beta/reports/invoices_isA_by_customer.asp

http://github.com/khaneh/Orders · ASP · 24 lines · 14 code · 8 blank · 2 comment · 0 complexity · ce4da37e3cb368dec098b23ed8953940 MD5 · raw file

  1. <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><%
  2. 'Response.Buffer=false
  3. Response.CodePage = 65001
  4. Response.CharSet = "utf-8"
  5. reportTitle = "گزارش جمع فروش و برگشت الف بر حسب مشتري"
  6. %>
  7. <!--#include File="../include_farsiDateHandling.asp"-->
  8. <!--#include File="../include_JS_InputMasks.asp"-->
  9. <!--#include File="reports_top.asp"-->
  10. <%
  11. dateFrom = request("dateFrom")
  12. dateTo = request("dateTo")
  13. mySQL = "SELECT Accounts.ID AS كد, Accounts.AccountTitle AS [عنوان حساب], Accounts.City1 AS شهر, Accounts.Address1 AS آدرس, Accounts.EconomicalCode AS كداقتصادي, SUM(Invoices.IsReverse * Invoices.TotalReceivable) AS SumReverse, SUM((1 - Invoices.IsReverse) * Invoices.TotalReceivable) AS [جمع برگشت], COUNT(Accounts.AccountTitle) AS InvoiceCount FROM Accounts INNER JOIN Invoices ON Accounts.ID = Invoices.Customer WHERE (Invoices.Issued = 1) AND (Invoices.Voided = 0) AND (Invoices.IssuedDate >= N'" & dateFrom & "') AND (Invoices.IssuedDate <= N'" & dateTo & "') AND (Invoices.IsA = 1) GROUP BY Accounts.AccountTitle, Accounts.EconomicalCode, Accounts.ID, Accounts.City1, Accounts.Address1, Accounts.Tel1, Accounts.Mobile1 ORDER BY Accounts.ID"
  14. 'mySQL = "SELECT Accounts.ID AS كد, Accounts.AccountTitle AS [عنوان حساب], Accounts.City1 AS شهر, Accounts.Address1 AS آدرس, Accounts.Tel1 AS تلفن, Accounts.Mobile1 AS موبايل, Accounts.EconomicalCode AS كداقتصادي, SUM(Invoices.IsReverse * Invoices.TotalReceivable) AS [جمع برگشت], SUM((1 - Invoices.IsReverse) * Invoices.TotalReceivable) AS [جمع فاكتور], COUNT(Accounts.AccountTitle) AS [تعداد فاكتورها] FROM Accounts INNER JOIN Invoices ON Accounts.ID = Invoices.Customer WHERE (Invoices.Issued = 1) AND (Invoices.Voided = 0) AND (Invoices.IssuedDate >= N'" & dateFrom & "') AND (Invoices.IssuedDate <= N'" & dateTo & "') AND (Invoices.IsA = 1) GROUP BY Accounts.AccountTitle, Accounts.EconomicalCode, Accounts.ID, Accounts.City1, Accounts.Address1, Accounts.Tel1, Accounts.Mobile1 ORDER BY Accounts.ID"
  15. %>
  16. <!--#include File="reports_tah.asp"-->