Print 'Doing pre run Checks to ensure script not already run';
Select * from Script_History where Script_Name='DatabaseUpdate11062025';
if @@ROWCOUNT!=0
	BEGIN
		RAISERROR('THIS SCRIPT HAS ALREADY BEEN RUN ON THIS SERVER, CANNOT CONTINUE, PLEASE CONTACT DEV',11,1);
		RETURN;
	END
GO

ALTER PROCEDURE [dbo].[spGetOnOrderVals] 
         @start_date DATETIME, 
	     @end_date DATETIME 
	  AS BEGIN 
	  SET NOCOUNT ON; 
	     SELECT pol.Product_ID, pol.Quantity 
         FROM Purchase_Order AS po
         INNER JOIN Purchase_Order_Line AS pol ON po.Purchase_Order_ID = pol.Purchase_Order_ID
         LEFT OUTER JOIN Stock_Receipt AS sr ON po.Purchase_Order_ID = sr.Purchase_Order_ID and sr.IsCbucksInvoice = 0
         WHERE 
			po.Server_Uploaded = 1 AND 
			po.Authorized_Date IS NOT NULL AND 
			po.Supplier_ID = 1 AND 
			sr.Purchase_Order_ID IS NULL AND
			po.Authorized_Date BETWEEN @start_date AND @end_date 
	  END

declare @StoreId int;
set @StoreId = (select default_value from system_default where Default_Name = 'Main_store_id');

If(@StoreId not in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10))
begin
	truncate table StockTakeReport
end



Print 'Insert into script history if everything else is cool';
	Insert into Script_History (RunDate,Script_Name) Values (CURRENT_TIMESTAMP,'DatabaseUpdate11062025');
	IF @@ERROR != 0
		BEGIN
			RAISERROR ('UNABLE TO CONTINUE WITH SCRIPT', 11, 1);
			RETURN;
		END
GO