nonesale post/list-inside - Danh sách bài viết (web-admin)

 

Tầng Puplic
Trang web , list Post bài viết

http://saleplatform-stag.fpt.net/web-admin/Post/Index

http://saleplatform.fpt.net/web-admin/Post/Index

Tầng Core

{{domain}}/utility/api/v1.0/post/list-inside

{

  "Title": null,

  "Status": 1,

  "SaleTeamId": 0,

  "PageNumber": 1,

  "PageSize": 20,

  "Type": 2

}

{

    "Code": 200,

    "Message": {

        "Message": "Thành công.",

        "ExMessage": null

    },

    "Data": [

        {

            "Id": 154,

            "Title": "huong dan hv1",

            "Content": "<p>abc</p>",

            "Image": "https://hi-static.fpt.vn/sys/mobisalevn/dev/images/posts/17_11_2022_14_23_59_thumbnail_image001_(8).png",

            "DateAvalible": "10/31/2022 00:00:00",

            "ExpirationDate": "12/11/2022 00:00:00",

            "SortOrder": 1,

            "Status": 1,

            "Type": 2

        },

        {

            "Id": 153,

            "Title": "foxwikinew1",

            "Content": "<p>1</p>",

            "Image": "https://hi-static.fpt.vn/sys/mobisalevn/dev/images/posts/17_11_2022_14_19_23_hinh-anh-con-ca1-1.jpg",

            "DateAvalible": "10/17/2020 00:00:00",

            "ExpirationDate": "06/17/2026 00:00:00",

            "SortOrder": 1,

            "Status": 1,

            "Type": 2

        },

    ]

}

Câu lệnh SQL trên C# của Utility

SELECT  p.ID,

        p.Title,

        p.Content,

        p.ShortDescription,

        p.Image, 

        p.DateAvalible, 

        p.ExpirationDate,

        p.SortOrder,

        p.Type,

        p.Status,

        p.CreatedBy, 

        p.CreatedDate,

        p.UpdatedBy,

        p.UpdatedDate

        FROM SalePlatform..SPF_Post(nolock) p 

        WHERE (@pStatus = -1 OR (@pStatus <> -1 AND p.Status = @pStatus)) 

        AND (@pSaleTeamId = 0 OR (@pSaleTeamId <> 0 AND (',' + RTRIM(p.SaleTeamID) + ',') LIKE '%,'+CAST(@pSaleTeamId as varchar(5))+',%' OR p.SaleTeamID = '')) 

        AND (ISNULL(@pTitle,'') = '' OR (@pTitle <> '' AND p.Title LIKE '%'+@pTitle+'%')) 

        AND P.Type = @pType

        ORDER BY p.SortOrder ,p.ID OFFSET @pPageSize * (@pPageNumber - 1) ROWS FETCH NEXT @pPageSize ROW ONLY