Modifica di Moderazione Occasioni a posteriori (sezione)

== Database e Store Procedure == 

* <code>CRUD_Products_Bargain_ToModerate</code>
* <code>CRUD_Bargain_Merge</code>

<syntaxhighlight lang="sql">
-- Gestione dei flag ToModerate nel caso un'occasione debba entrare in Outlet/Commerce
--IF @BeforeUpdateOutletApproved = 0 AND @OutletApproved = 1 BEGIN
--	UPDATE ProductBargain SET OutletApproved = 0, OutletToModerate = GETDATE() WHERE ProductId = @ProductId
--END
--IF @BeforeUpdateCommerceApproved = 0 AND @CommerceApproved = 1 BEGIN
--	UPDATE ProductBargain SET CommerceApproved = 0, CommerceToModerate = GETDATE() WHERE ProductId = @ProductId
--END
--NO MODERAZIONE  Gestione dei flag ToModerate nel caso un'occasione debba entrare in Outlet/Commerce
IF @BeforeUpdateOutletApproved = 0 AND @OutletApproved = 1 BEGIN
	UPDATE ProductBargain SET OutletApproved = 1, OutletToModerate = GETDATE() WHERE ProductId = @ProductId
END
IF @BeforeUpdateCommerceApproved = 0 AND @CommerceApproved = 1 BEGIN
	UPDATE ProductBargain SET CommerceApproved = 1, CommerceToModerate = GETDATE() WHERE ProductId = @ProductId
END
</syntaxhighlight>

* <code>Nop_BargainAdd</code> -> ProductBargain.CommerceToModerate = GETDATE()
<syntaxhighlight lang="sql">
-- Aggiorno il campo NopID e PermalinkNop in ProductBargain e CommerceToModerate con la data corrente
	UPDATE ProductBargain
	SET ProductBargain.NopID = @LastInserted, ProductBargain.CommerceToModerate = GETDATE()
	WHERE ProductBargain.ProductId = @ProductID

UPDATE ProductThumbs
	SET ProductThumbs.PermalinkNop = ProductBargain.PermalinkNop	
	FROM ProductBargain
</syntaxhighlight>

* <code>Nop_BargainSync</code>
<syntaxhighlight lang="sql">
-- Aggiorno il campo ProductBargain.CommerceToModerate = GETDATE() per la moderazione a posteriori
	UPDATE ProductBargain
	SET  ProductBargain.CommerceToModerate = GETDATE()
	WHERE ProductBargain.ProductId = @ProductID
</syntaxhighlight>