/beta/reports/inv_details.asp

 1<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><%
 2'Response.Buffer=false
 3Response.CodePage = 65001
 4Response.CharSet = "utf-8"
 5
 6reportTitle = "گزارش جزييات خروج از انبار"
 7%>
 8<!--#include File="../include_farsiDateHandling.asp"-->
 9<!--#include File="../include_JS_InputMasks.asp"-->
10
11<!--#include File="reports_top.asp"-->
12<%
13
14	dateFrom = request("dateFrom")
15	dateTo = request("dateTo")
16
17	mySQL = "SELECT dbo.InventoryItems.OldItemID AS [كد كالا], dbo.InventoryItems.Name AS [نام كالا], dbo.InventoryLog.Qtty AS تعداد, dbo.InventoryLog.logDate AS [تاريخ خروج], dbo.InventoryLog.owner AS مالك, dbo.InventoryLog.comments AS توضيحات, dbo.InventoryLog.RelatedInvoiceID AS [فاكتور فروش], dbo.Users.RealName AS گيرنده, Users_1.RealName AS [مسئول انبار] FROM dbo.InventoryLog INNER Join dbo.InventoryPickuplists ON dbo.InventoryLog.RelatedID = dbo.InventoryPickuplists.id INNER Join dbo.Users ON dbo.InventoryPickuplists.GiveTo = dbo.Users.ID INNER Join dbo.InventoryItems ON dbo.InventoryLog.ItemID = dbo.InventoryItems.ID INNER Join dbo.Users Users_1 ON dbo.InventoryLog.CreatedBy = Users_1.ID WHERE (dbo.InventoryLog.IsInput = 0) AND (dbo.InventoryLog.Voided = 0) AND (dbo.InventoryLog.logDate >= N'" & dateFrom & "') AND (dbo.InventoryLog.logDate <= N'" & dateTo & "')"
18	
19%>
20<!--#include File="reports_tah.asp"-->