spCloneSite_Layouts
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SourceClientSitesID | int | IN | |
| @TargetClientSitesID | int | IN | |
| @CurrentUserID | int | IN | |
| @CopyBatchGuid | uniqueidentifier | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spCloneSite_Layouts]
(
@SourceClientSitesID int,
@TargetClientSitesID int,
@CurrentUserID int,
@CopyBatchGuid uniqueidentifier
)
AS
BEGIN TRANSACTION
INSERT INTO SiteLayouts
(ClientSitesID, Name, Description, Content, Guid, OwnerID, Deleted, Stylesheet, StyleSheetID, DocType, CopySourceID, CopyBatchGUID)
SELECT
@TargetClientSitesID,
SiteLayouts.Name,
SiteLayouts.Description,
dbo.UFN_UPDATECOPYCONTENTHTML(SiteLayouts.Content,@CopyBatchGUID),
newid(),
SiteLayouts.OwnerID,
SiteLayouts.Deleted,
Stylesheet,
SiteStyleSheets.ID,
DocType,
SiteLayouts.ID,
@CopyBatchGUID
FROM SiteLayouts
LEFT JOIN SiteStyleSheets ON SiteStyleSheets.CopySourceID = SiteLayouts.StyleSheetID AND SiteStyleSheets.CopyBatchGuid = @CopyBatchGuid
LEFT OUTER JOIN
(select PAGEMODELITEM.OBJECTGUID
from dbo.PAGEMODELITEM
inner join dbo.PAGEMODEL on PAGEMODEL.ID = PAGEMODELITEM.PAGEMODELID
where PAGEMODEL.LOCKARTIFACTS = 1
) PMI on PMI.OBJECTGUID = SiteLayouts.Guid
WHERE SiteLayouts.ClientSitesID = @SourceClientSitesID AND SiteLayouts.Deleted = 0 AND PMI.OBJECTGUID is null
COMMIT TRANSACTION