/****** Object:  View [dbo].[ViwAccSellFactorTrucks]    Script Date: 25/1/2025 01:31:02 ب.ظ ******/
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, 
                Main.AvarezSeller, Main.AvarezBuyer, Main.HamlCode, Main.CompanyCode, Main.FactorLazem, Main.Status, Main.TaghirStatus, Main.VizTotalID, Main.VizControlID, Main.VizDetailID1, Main.VizDetailID2, Main.VizValue
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


