/****** Object:  View [dbo].[ViwAccSellFactorTrucks]    Script Date: 7/26/2023 02:20:55 ب.ظ ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER VIEW [dbo].[ViwAccSellFactorTrucks]
AS
SELECT        Main.ID, Main.Number, Main.OrderDate, Main.OrderTotalID, Main.OrderControlID, Main.OrderDetailID1, Main.OrderDetailID2, Main.Type, Main.Source, Main.BuyerTotalID, Main.BuyerControlID, Main.BuyerDetailID1, 
                         Main.BuyerDetailID2, Main.SellerTotalID, Main.SellerControlID, Main.SellerDetailID1, Main.SellerDetailID2, Main.Request, Main.RequestUnit, Main.RequestText, Main.SendDate, Main.ControlA, Main.ControlB, Main.ControlC, 
                         Main.ControlD, Main.SellType, Main.SellTime, Main.SellPrice, Main.BuyType, Main.BuyTime, Main.BuyPrice, Main.City, Main.Destination, Main.Address, Main.DocItemID, Main.DocItemRelationID, Main.DocItemType, 
                         Main.Description, Main.UpdateDate, Main.Updater, Main.Trailer, COALESCE (Trucks.Weigh, 0) AS TrucksWeight, dbo.FARSI_DATE2(Main.OrderDate) AS OrderDatePer, CAST(0 AS bit) AS Selected, COALESCE (Trucks.DocItemID, 0) 
                         AS TrucksDocItemID, Main.PrintCount, Main.BuyerRef, Trucks.TrucksDate, Main.MelliCode, Main.Tel, Main.BuyPrice2, Main.SellPrice2, Main.BuyerPaid, Main.SellerPaid, Main.IsPermanent, Main.CancelDate, Main.InsertDate, 
                         Main.Inserter, Main.Barbari, Main.Canceler, Main.PermanentDate, Main.Permanenter, Main.Sender, Main.WareOrderID, Main.FinancialCode, Main.PostalCode, Main.WareInID, Main.WareOutID, Trucks.MinDate, Trucks.MaxDate, 
                         Main.FactorID, Main.Sign1User, Main.Sign1Date, Main.Sign2User, Main.Sign2Date, dbo.FARSI_DATE2(Main.UpdateDate) AS UpdateDatePer, dbo.FARSI_DATE2(Main.InsertDate) AS InsertDatePer, dbo.FARSI_DATE2(Main.SendDate) 
                         AS SendDatePer, dbo.FARSI_DATE2(Main.CancelDate) AS CancelDatePer, CONVERT(bit, CASE MelliCards.Image1 WHEN MelliCards.Image1 THEN 1 ELSE 0 END) AS HasMelliImage, Main.Flags, Main.IsFalsi, Main.Zir5Darsad, 
                         Main.HaghAmalKari, Main.Type1Code, Main.CityCode, Main.KalaTypeID, Main.DestCode, Main.MoreStr0, Main.MoreStr1, Main.MoreStr2, Main.MoreStr3, Main.MoreStr4, Main.MoreStr5, Main.MoreStr6, Main.MoreStr7, 
                         Main.MoreStr8, Main.MoreStr9, Main.MoreNum0, Main.MoreNum1, Main.MoreNum2, Main.MoreNum3, Main.MoreNum4, Main.MoreNum5, Main.MoreNum6, Main.MoreNum7, Main.MoreNum8, Main.MoreNum9, Main.MoreDate0, 
                         Main.MoreDate1, Main.MoreDate2, Main.MoreDate3, Main.MoreDate4, Main.MoreDate5, Main.MoreDate6, Main.MoreDate7, Main.MoreDate8, Main.MoreDate9, Main.MoreFlags, Main.Cottage, Main.BuyerCostCenter, 
                         Main.BuyerProject, Main.SellerCostCenter, Main.SellerProject, Main.BPeygiri, Main.BOstan, Main.BShahr, Main.BPardakhti, Main.BKhShomHesab, Main.BShivPardakht, Main.BShenArzeh, Main.BKhShenasMelli, 
                         Main.BKhCodePosti, Main.BKhAddress, Main.BShenVariz, Main.BKhMobile, Main.BKhYekta, Main.BTak, Main.BJoft, Main.BBarnamehNashodeh, Main.BTakhsis
FROM            dbo.AccSellFactor AS Main WITH (NOLOCK) LEFT OUTER JOIN
                             (SELECT        SellFactorID, CAST(0 AS bigint) AS DocItemID, SUM(Weigh) AS Weigh, Date AS TrucksDate, MIN(Date) AS MinDate, MAX(Date) AS MaxDate
                                FROM            dbo.AccSellFactorTrucks WITH (NOLOCK)
                                GROUP BY SellFactorID, Date) AS Trucks ON Main.ID = Trucks.SellFactorID LEFT OUTER JOIN
                         dbo.MelliCards ON Main.MelliCode = dbo.MelliCards.MelliCode
GO


