• SARL HENRI ARRIETA

Connect SQL server

46.21.205.19

---

Setup_CreateBDGp

@sBDGpNew : BDGpNiArrietaV4, @sBDGpModele : BD_GpModele4_Auto_Nissan

1

---

Setup_InsertBDREF3

@sNomGroupeV4 : NiArrietaV4, @sBDGpNew : BDGpNiArrietaV4, @sURL_eSeller : arrieta.smit.selectup.com, @sURL_ServeurPub : arrieta.serveurpub.selectup.com, @sURL_BackOffice : arrieta.backoffice.selectup.com, @sURL_Reporting : arrieta.reporting.selectup.com, @iIDActivite : 1, @iIDTypeProduit : 8, @iFAM_FactureeSeller : 0

---

Setup_PlaqueInsert

@iIDActivite : 1, @sNomSociete : SARL HENRI ARRIETA, @sListeMailsCompte : sav@selectup.com, @sListeMarque : NISSAN

1

---

Setup_SiteInsert

@iIDPlaque : 1, @sCodeSite : 036461, @sNomSite : SARL HENRI ARRIETA, @sAdresse1 : ZAC St Frédéric II, @sAdresse2 : 15, rue du Chalibardon, @sCP : 64100, @sVille : BAYONNE, @sEMail : , @sTel : 05 59 55 72 74, @sFax : , @iTypeSite : 6

1

---

activateCorporateSales_BDREF3

INSERT INTO [dbo].[CompteWSImportCRM] (Login, Password, NomGroupe, ServeurGp, BDGp, IDCompany, Actif, IDPlaque) VALUES ('NiCS036461', 'CS962wM$90', 'NiArrietaV4', 'prod-crm-sql', 'BDGpNiArrietaV4', 1, 1, 1)

---

Connect SQL server

46.21.205.19

---

activateCorporateSales_BDGp

UPDATE [dbo].[Plaque] SET InterfaceCorporateSales = 1 WHERE IDPlaque = 1;

---

Setup_PeopleInsert

@iIDSite : 1, @iDRPROFILE_ID : 11, @sNom : HIRIART, @sPrenom : MARINA, @sLogin : FRD4635, @sPassword : marina, @bAccesESeller : 1, @sEmail : marina.hiriart@garagearrieta.fr, @sTelFixe : 05 59 55 72 74, @sTelPortable : , @bReceptionneLeads : 0, @sCodeVendeurNissan : FRD4635, @sSrvBDRefNissan : [INO-CRM-SQL]

2

---

Setup_PeopleInsert

@iIDSite : 1, @iDRPROFILE_ID : 10, @sNom : DIEVAL, @sPrenom : NICOLAS, @sLogin : FRD00388, @sPassword : nicolas, @bAccesESeller : 1, @sEmail : nicolas.dieval@garagearrieta.fr, @sTelFixe : , @sTelPortable : 06 12 43 41 42, @bReceptionneLeads : 0, @sCodeVendeurNissan : FRD00388, @sSrvBDRefNissan : [INO-CRM-SQL]

3

---

Resume Plaque & Site

SELECT p.IDPlaque, p.Libelle AS Plaque, s.IDSite, s.Descr AS Site FROM Plaque p LEFT OUTER JOIN SITE s ON p.IDPlaque = s.IDPlaque ORDER BY p.IDPlaque, s.IDSite;

IDPlaque	Plaque	IDSite	Site
0	Select Up	0	Select Up
1	SARL HENRI ARRIETA	1	SARL HENRI ARRIETA

---

Resume People

SELECT pl.Libelle AS Societe, s.Descr AS Site, p.Lastname, p.Firstname, p.LoginWEB, p.Password FROM PEOPLE p LEFT OUTER JOIN Site_People sp ON p.IDCompany = sp.IDCompany AND p.IDPeople = sp.IDPeople LEFT OUTER JOIN SITE s ON sp.IDCompany = s.IDCompany AND sp.IDSite = s.IDSite LEFT OUTER JOIN Plaque pl ON s.IDPlaque = pl.IDPlaque ORDER BY p.IDPeople;

Societe	Site	Lastname	Firstname	LoginWEB	Password
		Passerelle(1)		pass1	pass1
Select Up	Select Up	Test(1)	Test(1)	test	test
SARL HENRI ARRIETA	SARL HENRI ARRIETA	HIRIART	MARINA	FRD4635	marina
SARL HENRI ARRIETA	SARL HENRI ARRIETA	DIEVAL	NICOLAS	FRD00388	nicolas

---

AddUrlToIIS

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tem="http://tempuri.org/"> <soapenv:Header/> <soapenv:Body> <tem:ConfigIIS> <tem:sNomSiteCRM>arrieta.smit.selectup.com</tem:sNomSiteCRM> <tem:sNomSiteBackoffice>arrieta.backoffice.selectup.com</tem:sNomSiteBackoffice> <tem:sNomSitePub>arrieta.serveurpub.selectup.com</tem:sNomSitePub> <tem:sNomSiteReporting>arrieta.reporting.selectup.com</tem:sNomSiteReporting> </tem:ConfigIIS> </soapenv:Body> </soapenv:Envelope>

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><s:Body><ConfigIISResponse xmlns="http://tempuri.org/"><ConfigIISResult>0</ConfigIISResult></ConfigIISResponse></s:Body></s:Envelope>

---