Modifica di Designbest Core Sviluppo (sezione)

==== Negozi ====
Qui rimaniamo col vecchio approccio delle '''viste indicizzate''' dato che non ci sono self-join al momento.<br/>
Script di creazione delle viste:
<div class="mw-collapsible mw-collapsed" style="border:solid 1px;padding:2rem;">
<syntaxhighlight lang="sql">
DROP VIEW IF EXISTS dbo.FT_Shops_IT
GO
DROP VIEW IF EXISTS dbo.FT_Shops_EN
GO
DROP VIEW IF EXISTS dbo.FT_Shops_FR
GO
DROP VIEW IF EXISTS dbo.FT_Shops_DE
GO

-- ITALIA
CREATE VIEW dbo.FT_Shops_IT WITH SCHEMABINDING
AS
	SELECT
		ShopPoint.ID,
		ShopPoint.[Name],
		ShopNet.[Name] AS ShopNetName,
		LocDescription.[LocaleValue] AS [Description],
		ShopPoint.Referente,
		ShopPoint.[Address],
		ShopPoint.Phone,
		ShopPoint.Mail,
        ShopPoint.BackofficeNotes,
		Region.[Name] AS Region,
		Province.[Name] AS Province,
		City.[Name] AS City,
		ShopPoint.Visible
	FROM dbo.ShopPoint
		INNER JOIN dbo.ShopNet ON ShopPoint.ShopNetID = ShopNet.ID
		INNER JOIN dbo.City ON ShopPoint.CityID = City.ID
		INNER JOIN dbo.Province ON City.ProvinceID = Province.ID
		INNER JOIN dbo.Region ON Province.RegionID = Region.ID
		INNER JOIN dbo.LocalizedProperty AS LocDescription ON ShopPoint.ID = LocDescription.EntityId AND LocDescription.LanguageId = 1 AND LocDescription.LocaleKeyGroup = 'ShopPoint' AND LocDescription.LocaleKey = 'Description'
	WHERE ShopPoint.VisibilityTypeID = 0
GO

CREATE UNIQUE CLUSTERED INDEX UQ_ID   
    ON dbo.FT_Shops_IT(ID)
GO

-- WORLD
CREATE VIEW dbo.FT_Shops_EN WITH SCHEMABINDING
AS
	SELECT
		ShopPoint.ID,
		ShopPoint.[Name],
		ShopNet.[Name] AS ShopNetName,
		LocDescription.[LocaleValue] AS [Description],
		ShopPoint.Referente,
		ShopPoint.[Address],
		ShopPoint.Phone,
		ShopPoint.Mail,
        ShopPoint.BackofficeNotes,
		Region.[Name] AS Region,
		Province.[Name] AS Province,
		City.[Name] AS City,
		ShopPoint.Visible
	FROM dbo.ShopPoint
		INNER JOIN dbo.ShopNet ON ShopPoint.ShopNetID = ShopNet.ID
		INNER JOIN dbo.City ON ShopPoint.CityID = City.ID
		INNER JOIN dbo.Province ON City.ProvinceID = Province.ID
		INNER JOIN dbo.Region ON Province.RegionID = Region.ID
		INNER JOIN dbo.LocalizedProperty AS LocDescription ON ShopPoint.ID = LocDescription.EntityId AND LocDescription.LanguageId = 2 AND LocDescription.LocaleKeyGroup = 'ShopPoint' AND LocDescription.LocaleKey = 'Description'
	WHERE ShopPoint.VisibilityTypeID = 0
GO

CREATE UNIQUE CLUSTERED INDEX UQ_ID   
    ON dbo.FT_Shops_EN(ID)
GO

-- FRANCIA
CREATE VIEW dbo.FT_Shops_FR WITH SCHEMABINDING
AS
	SELECT
		ShopPoint.ID,
		ShopPoint.[Name],
		ShopNet.[Name] AS ShopNetName,
		LocDescription.[LocaleValue] AS [Description],
		ShopPoint.Referente,
		ShopPoint.[Address],
		ShopPoint.Phone,
		ShopPoint.Mail,
        ShopPoint.BackofficeNotes,
		Region.[Name] AS Region,
		Province.[Name] AS Province,
		City.[Name] AS City,
		ShopPoint.Visible
	FROM dbo.ShopPoint
		INNER JOIN dbo.ShopNet ON ShopPoint.ShopNetID = ShopNet.ID
		INNER JOIN dbo.City ON ShopPoint.CityID = City.ID
		INNER JOIN dbo.Province ON City.ProvinceID = Province.ID
		INNER JOIN dbo.Region ON Province.RegionID = Region.ID
		INNER JOIN dbo.LocalizedProperty AS LocDescription ON ShopPoint.ID = LocDescription.EntityId AND LocDescription.LanguageId = 3 AND LocDescription.LocaleKeyGroup = 'ShopPoint' AND LocDescription.LocaleKey = 'Description'
	WHERE ShopPoint.VisibilityTypeID = 0
GO

CREATE UNIQUE CLUSTERED INDEX UQ_ID   
    ON dbo.FT_Shops_FR(ID)
GO

-- GERMANIA
CREATE VIEW dbo.FT_Shops_DE WITH SCHEMABINDING
AS
	SELECT
		ShopPoint.ID,
		ShopPoint.[Name],
		ShopNet.[Name] AS ShopNetName,
		LocDescription.[LocaleValue] AS [Description],
		ShopPoint.Referente,
		ShopPoint.[Address],
		ShopPoint.Phone,
		ShopPoint.Mail,
        ShopPoint.BackofficeNotes,
		Region.[Name] AS Region,
		Province.[Name] AS Province,
		City.[Name] AS City,
		ShopPoint.Visible
	FROM dbo.ShopPoint
		INNER JOIN dbo.ShopNet ON ShopPoint.ShopNetID = ShopNet.ID
		INNER JOIN dbo.City ON ShopPoint.CityID = City.ID
		INNER JOIN dbo.Province ON City.ProvinceID = Province.ID
		INNER JOIN dbo.Region ON Province.RegionID = Region.ID
		INNER JOIN dbo.LocalizedProperty AS LocDescription ON ShopPoint.ID = LocDescription.EntityId AND LocDescription.LanguageId = 4 AND LocDescription.LocaleKeyGroup = 'ShopPoint' AND LocDescription.LocaleKey = 'Description'
	WHERE ShopPoint.VisibilityTypeID = 0
GO

CREATE UNIQUE CLUSTERED INDEX UQ_ID   
    ON dbo.FT_Shops_DE(ID)
GO
</syntaxhighlight>
</div>
Le viste implicate sono
* <code>FT_Shops_IT</code>
* <code>FT_Shops_EN</code>
* <code>FT_Shops_FR</code>
* <code>FT_Shops_DE</code>

Per effettuare una '''ricerca negozi''' utilizzare la <code>FullText_Shops_Search</code>