----delete ZVN_ReportList_mst---------------
IF EXISTS
(
    SELECT 1
    FROM ZVN_ReportList_mst
    WHERE ReportId = 'KT18'
          AND SiteRef = 'PVD'
)
    DELETE FROM dbo.ZVN_ReportList_mst
    WHERE ReportId = 'KT18'
          AND SiteRef = 'PVD';
GO
----insert ZVN_ReportList_mst---------------
IF NOT EXISTS
(
    SELECT 1
    FROM ZVN_ReportList_mst
    WHERE ReportId = 'KT18'
          AND SiteRef = 'PVD'
)
BEGIN

    INSERT dbo.ZVN_ReportList_mst
    (
        CreatedBy,
        UpdatedBy,
        CreateDate,
        RecordDate,
        RowPointer,
        NoteExistsFlag,
        InWorkflow,
        SiteRef,
        ReportId,
        ReportName,
        ReportGroup,
        ReportParams,
        BGTaskName,
        RequiredParams,
        ReportProfile,
        ReportOptions
    )
    VALUES
    (   'sa',                                                                  -- CreatedBy - UsernameType
        'sa',                                                                  -- UpdatedBy - UsernameType
        GETDATE(),                                                             -- CreateDate - CurrentDateType
        GETDATE(),                                                             -- RecordDate - CurrentDateType
        NEWID(),                                                               -- RowPointer - RowPointerType
        0,                                                                     -- NoteExistsFlag - FlagNyType
        0,                                                                     -- InWorkflow - FlagNyType
        'PVD',                                                                 -- SiteRef - SiteType
        N'KT18',                                                               -- ReportId - nvarchar(50)
        N'KT18 - Báo cáo xuất nhập tồn theo dự án',                            -- ReportName - nvarchar(250)
        N'SX',                                                                 -- ReportGroup - nvarchar(10)
                                                                               --N'V(vDate1),V(vDate2),V(vWarehouse),V(vLoc),V(vProducCode),V(vAcct),V(vSite), V(vProj),V(vItem)' ,-- ReportParams - nvarchar(250)
        N'V(vDate1),V(vDate2),V(vWarehouse),V(vAcct),V(vProductCode),V(vloc)', -- ReportParams - nvarchar(250)
        N'PVG_Rpt_GetQtyNXT',                                                  -- BGTaskName - nvarchar(100)
        N'V(vDate1),V(vDate2)',                                                -- RequiredParams - nvarchar(250)
        N'',                                                                   -- ReportProfile - nvarchar(250)
        N''                                                                    -- ReportOptions - nvarchar(500)
        );

END;
GO

----insert BGTaskDefinitions---------------
IF NOT EXISTS
(
    SELECT 1
    FROM BGTaskDefinitions
    WHERE TaskName = 'PVG_Rpt_GetQtyNXT'
)
BEGIN

    INSERT dbo.BGTaskDefinitions
    (
        TaskName,
        TaskTypeCode,
        TaskExecutable,
        ExclusiveFlag,
        TaskDescription,
        MaxConcurrent,
        NoteExistsFlag,
        CreatedBy,
        UpdatedBy,
        CreateDate,
        RecordDate,
        RowPointer,
        InWorkflow,
        IsolationLevel,
        ReportType
    )
    SELECT 'PVG_Rpt_GetQtyNXT',
           'RPT',
           'PVG_Rpt_GetQtyNXT',
           0,
           'PVG_Rpt_GetQtyNXT',
           20,
           0,
           'sa',
           'sa',
           GETDATE(),
           GETDATE(),
           NEWID(),
           0,
           NULL,
           'SSRS';

END;

--SELECT * FROM ZVN_ReportList_mst WHERE ReportId ='KT18'