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


declare @StoreId int;

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

If(@StoreId in (164,90,43,27,76,262,26,106,131,162,127,251,96,110,118,126))
begin

insert into Product_Catalogue_History(Product_Catalogue_ID, Product_Catalogue_Status_ID, reason, MonthEnd)
select pc.Product_Catalogue_ID, Last_Catalogue_Status_ID, 'Supplier Discontinued - Cooper take over', GETDATE()
from Product_Catalogue pc
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1 and Product_Catalogue_Status_ID != 4 and product_id in (
select product_id from product where hq_product_id in (40903,40905,40907))
);



update Product_Catalogue
set Product_Catalogue_Status_ID = 4,
Last_Catalogue_Status_ID = Product_Catalogue_Status_ID,
Last_Catalogue_Changed = GETDATE(),
Last_Change_Reason = 'Supplier Discontinued - Cooper take over'
where product_catalogue_id in
(
select product_catalogue_id from product_catalogue where supplier_id = 1 and Product_Catalogue_Status_ID != 4 and product_id in (
select product_id from product where hq_product_id in (40903,40905,40907))
);


update SystemSetting set SettingValueDecimal = 97.00 where settingkey = 'StandardAvailability';

update SystemSetting set SettingValueDecimal = 99.00 where settingkey = 'KeylineAvailability';

update SystemSetting set SettingValueDecimal = 99.00 where settingkey = 'PromoAvailability';

end

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