Modifica di Designbest Core Sviluppo (sezione)

==== Operazione per Outlet WP, Nop Commerce e Lead manager ====
* Outlet Plugin - Usare il pulsante '''POST IMPORT SKU CHANGE''' per cambiare tutti gli SKU da <code>old_bargainID</code> a nuovo <code>ProductID</code> di DesignbestCore.
* Nop - Sql, copiare il '''trigger''' come specificato nell'ultimo punto del paragrafo precedente (verificare esistenza '''utente''' <code>wmuser</code> su <code>_DesignbestCore</code>)
* LM - Backuppare database <code>LeadManager</code> con il comando ''"Export Data-tier Application"'' in un file <code>bacpac</code>
* LM - Query per <br/>
::modificare il campo <code>category.code</code> con i nuovi id ambiente ai 23 record presenti che non iniziano con ''O'',<br/>
::modificare il campo <code>product.code</code> con i nuovi id occasione, lanciare i risultati di queste due query come update su database <code>LeadManager</code>
<br/><br/>
'''N.B.''' Se si fa una import questa parte risutla sbagliata. Conviene ripristinare il DB da produzione e poi lanciare queste.
<div class="mw-collapsible mw-collapsed" style="border:solid 1px;padding:2rem;">
<syntaxhighlight lang="sql">
-- Lead Manager - Adeguamento nuovi ID category e product (occasioni) (lanciare su database DesignbestCore e eseguire l'output su LeadManager)
SELECT 'UPDATE category SET code = ''' + CAST(ID AS VARCHAR(10)) + ''' WHERE code = ''' + CAST(temp_old_id AS VARCHAR(10)) + ''' AND category = ''' + [Name] + ''''
FROM Category
WHERE CategoryLevel = 1

-- REMEMBER: l'esecuzione di queste update dura quasi 7 minuti (lanciare su database DesignbestCore e eseguire l'output su LeadManager)
SELECT 'UPDATE product SET code = ''' + CAST(ProductId AS VARCHAR(10)) + ''' WHERE code = ''O' + CAST(old_BargainID AS VARCHAR(10)) + ''''
FROM ProductBargain
WHERE old_BargainID <> 0

-- category change in product (database LeadManager)
UPDATE product SET categoryID = 2 WHERE categoryID = 23
UPDATE product SET categoryID = 17 WHERE categoryID = 24
UPDATE product SET categoryID = 2 WHERE categoryID = 28
UPDATE product SET categoryID = 2 WHERE categoryID = 30
UPDATE product SET categoryID = 2 WHERE categoryID = 36
UPDATE product SET categoryID = 10 WHERE categoryID = 37
UPDATE product SET categoryID = 6 WHERE categoryID = 40
UPDATE product SET categoryID = 20 WHERE categoryID = 41
UPDATE product SET categoryID = 12 WHERE categoryID = 44
UPDATE product SET categoryID = 1 WHERE categoryID = 45
UPDATE product SET categoryID = 2 WHERE categoryID = 46
UPDATE product SET categoryID = 3 WHERE categoryID = 47
UPDATE product SET categoryID = 4 WHERE categoryID = 48
UPDATE product SET categoryID = 5 WHERE categoryID = 49
UPDATE product SET categoryID = 6 WHERE categoryID = 50
UPDATE product SET categoryID = 7 WHERE categoryID = 51
UPDATE product SET categoryID = 8 WHERE categoryID = 52
UPDATE product SET categoryID = 20 WHERE categoryID = 53
UPDATE product SET categoryID = 1 WHERE categoryID = 54
UPDATE product SET categoryID = 10 WHERE categoryID = 55
UPDATE product SET categoryID = 11 WHERE categoryID = 56
UPDATE product SET categoryID = 12 WHERE categoryID = 57
UPDATE product SET categoryID = 13 WHERE categoryID = 58
UPDATE product SET categoryID = 14 WHERE categoryID = 59
UPDATE product SET categoryID = 18 WHERE categoryID = 60
UPDATE product SET categoryID = 19 WHERE categoryID = 61
UPDATE product SET categoryID = 21 WHERE categoryID = 62
UPDATE product SET categoryID = 22 WHERE categoryID = 63
-- category change in repository
UPDATE repository SET categoryID = 2 WHERE categoryID = 23
UPDATE repository SET categoryID = 17 WHERE categoryID = 24
UPDATE repository SET categoryID = 2 WHERE categoryID = 28
UPDATE repository SET categoryID = 2 WHERE categoryID = 30
UPDATE repository SET categoryID = 2 WHERE categoryID = 36
UPDATE repository SET categoryID = 10 WHERE categoryID = 37
UPDATE repository SET categoryID = 6 WHERE categoryID = 40
UPDATE repository SET categoryID = 20 WHERE categoryID = 41
UPDATE repository SET categoryID = 12 WHERE categoryID = 44
UPDATE repository SET categoryID = 1 WHERE categoryID = 45
UPDATE repository SET categoryID = 2 WHERE categoryID = 46
UPDATE repository SET categoryID = 3 WHERE categoryID = 47
UPDATE repository SET categoryID = 4 WHERE categoryID = 48
UPDATE repository SET categoryID = 5 WHERE categoryID = 49
UPDATE repository SET categoryID = 6 WHERE categoryID = 50
UPDATE repository SET categoryID = 7 WHERE categoryID = 51
UPDATE repository SET categoryID = 8 WHERE categoryID = 52
UPDATE repository SET categoryID = 20 WHERE categoryID = 53
UPDATE repository SET categoryID = 1 WHERE categoryID = 54
UPDATE repository SET categoryID = 10 WHERE categoryID = 55
UPDATE repository SET categoryID = 11 WHERE categoryID = 56
UPDATE repository SET categoryID = 12 WHERE categoryID = 57
UPDATE repository SET categoryID = 13 WHERE categoryID = 58
UPDATE repository SET categoryID = 14 WHERE categoryID = 59
UPDATE repository SET categoryID = 18 WHERE categoryID = 60
UPDATE repository SET categoryID = 19 WHERE categoryID = 61
UPDATE repository SET categoryID = 21 WHERE categoryID = 62
UPDATE repository SET categoryID = 22 WHERE categoryID = 63

-- Tronchiamo config_company_category
TRUNCATE TABLE config_company_category

-- Cancelliamo le category outlet
DELETE FROM category WHERE categoryID >= 23

-- Ci inseriamo tutto di tutti
INSERT INTO config_company_category(companyID, categoryID)
SELECT DISTINCT company.companyID, category.categoryID
FROM category, company
ORDER BY company.companyID, category.categoryID
</syntaxhighlight>
</div>