[ADMIN SITE] Nguyên tắc hiễn thị chung

[LeDangIUH]

Cái nào đăng kí sau hay summit sao phải dược hiễn thị trên cùng của danh sách thống kế bên admin, hay spadmin.

Hồ sơ đăng ký, bao sao san pham .....

[lyquoclam]

Hi anh @LeDangIUH

Chạy 2 scripts bên dưới cho tất cả databases:

Hồ Sơ Đăng Ký

ALTER PROCEDURE [dbo].[sp_getRequest_Skip_Take]
    @Skip int, 
    @Take int,
    @HolderID bigint,
    @hour int
AS
BEGIN
    --declare @Skip int
    --declare @Take int
    --set @Skip  = 0;
    --set @Take = 10;

    declare @totalItem int;
    declare @todate smalldatetime  = GetDate();
    set @totalItem  = (select Count(*) from RequestCompany)
    SELECT 
        rc.CompanyTempID,
        rc.CompanyName as RequestName,
        c.CompanyName,
        rc.CompanyID,
        --rc.ImageID,
        @totalItem TotalRow,
        i.ImageUrl RequestImageUrl,
        i.ImageName RequestImageName,
        ic.ImageUrl ,
        ic.ImageName,
        CAST( (
            select 
                Count(rp.ProductTempID)
            from RequestProduct rp 
            where rp.CompanyTempID = rc.CompanyTempID
        ) as bigint) as ProductCount,
        rc.CreatedTime,
        rc.Note,
        rc.IsActive,
        rc.RequestType,
        rc.[Status],
        rc.HolderID,
        u.UserName HolderName

    FROM RequestCompany rc 
        left join Company c on c.CompanyID  = rc.CompanyID
        left join Image i on i.ImageID = rc.ImageID
        left join Image ic on ic.ImageID = c.ImageID
        left join [User] u on u.UserID = rc.HolderID
    where @todate >= DATEADD(hour,@hour,rc.CreatedTime)
    and (
        @HolderID is null or (
            rc.HolderID = @HolderID and rc.DeparmentType = 'SUPERVIOR'
        )
    )
    ORDER BY rc.CompanyTempID desc
    OFFSET (@Skip) ROWS FETCH NEXT (@Take) ROWS ONLY
END

Báo Cáo Sản Phẩm

ALTER PROCEDURE [dbo].[sp_GetAll_ProductReport]
AS
BEGIN
    SELECT pr.ProductReportID, pr.UserID, u.UserName, u.PhoneNumber, pr.ReportContent, pr.ProductID, p.ProductName, c.CompanyID, c.CompanyName, pr.CreatedDate, pr.IsDeleted, pr.IsSolved
    FROM 
        ProductReport pr inner join [User] u on pr.UserID = u.UserID
        inner join Product p on pr.ProductID = p.ProductID
        join Company c on p.CompanyID = c.CompanyID
ORDER BY pr.CreatedDate desc
END

[lyquoclam]

Hi anh @LeDangIUH

Chạy 2 scripts bên dưới cho tất cả databases:

Hồ Sơ Đăng Ký

ALTER PROCEDURE [dbo].[sp_getRequest_Skip_Take]
    @Skip int, 
    @Take int,
    @HolderID bigint,
    @hour int
AS
BEGIN
    --declare @Skip int
    --declare @Take int
    --set @Skip  = 0;
    --set @Take = 10;

    declare @totalItem int;
    declare @todate smalldatetime  = GetDate();
    set @totalItem  = (select Count(*) from RequestCompany)
    SELECT 
        rc.CompanyTempID,
        rc.CompanyName as RequestName,
        c.CompanyName,
        rc.CompanyID,
        --rc.ImageID,
        @totalItem TotalRow,
        i.ImageUrl RequestImageUrl,
        i.ImageName RequestImageName,
        ic.ImageUrl ,
        ic.ImageName,
        CAST( (
            select 
                Count(rp.ProductTempID)
            from RequestProduct rp 
            where rp.CompanyTempID = rc.CompanyTempID
        ) as bigint) as ProductCount,
        rc.CreatedTime,
        rc.Note,
        rc.IsActive,
        rc.RequestType,
        rc.[Status],
        rc.HolderID,
        u.UserName HolderName

    FROM RequestCompany rc 
        left join Company c on c.CompanyID  = rc.CompanyID
        left join Image i on i.ImageID = rc.ImageID
        left join Image ic on ic.ImageID = c.ImageID
        left join [User] u on u.UserID = rc.HolderID
    where @todate >= DATEADD(hour,@hour,rc.CreatedTime)
    and (
        @HolderID is null or (
            rc.HolderID = @HolderID and rc.DeparmentType = 'SUPERVIOR'
        )
    )
    ORDER BY rc.CreatedTime desc
    OFFSET (@Skip) ROWS FETCH NEXT (@Take) ROWS ONLY
END

Báo Cáo Sản Phẩm

ALTER PROCEDURE [dbo].[sp_GetAll_ProductReport]
AS
BEGIN
    SELECT pr.ProductReportID, pr.UserID, u.UserName, u.PhoneNumber, pr.ReportContent, pr.ProductID, p.ProductName, c.CompanyID, c.CompanyName, pr.CreatedDate, pr.IsDeleted, pr.IsSolved
    FROM 
        ProductReport pr inner join [User] u on pr.UserID = u.UserID
        inner join Product p on pr.ProductID = p.ProductID
        join Company c on p.CompanyID = c.CompanyID
ORDER BY pr.CreatedDate desc
END

[lyquoclam]

Fixed 03/10/2016 Note: Đợi build, nhớ chạy script ở trên nha anh Dang