#include <Page.h>

Inheritance diagram for PageListView:

Public Member Functions
	PageListView (HtmlPage *pPage)
virtual void	init (SQLFields &fields) __DCL_THROWS1(Exception *)
virtual void	onPrint (Session &session) __DCL_THROWS1(Exception *)
Public Member Functions inherited from HtmlView
const HtmlPage *	page () const
String	SELF () const
String	VNO () const
virtual void	onGet (Session &session) __DCL_THROWS1(Exception *)
virtual void	onPost (Session &session) __DCL_THROWS1(Exception *)
Public Member Functions inherited from Object
virtual String	toString () const
virtual void	destroy ()
String	className () const
bool	isInstanceOf (const std::type_info &typeinfo) const
virtual const std::type_info &	typeInfo () const

Additional Inherited Members
Static Public Member Functions inherited from HtmlView
static HtmlView *	createObject (HtmlPage *pPage, int nClassID, int nIndex)
Protected Member Functions inherited from HtmlView
	HtmlView (HtmlPage *pPage)
Protected Member Functions inherited from TextTemplate
virtual String	onSQLFieldValue (_CONST SQLField &_field, const String &_fieldIsNullValue)
void	parseHelper (const char_t _begin, const char_t _end)
void	parse (const char_t _begin, const char_t _end)
int	append (const char_t *_name, const String &_value, bool _clearExists)
int	append (const char_t *_name, const TextTemplate &_template, bool _clearExists)
int	append (const StringStringArray &_nameToValues, bool _clearExists)
int	append (_CONST SQLFields &_fields, const String &_fieldIsNullValue, bool _clearExists)
Protected Member Functions inherited from Object
virtual	~Object ()
	Object ()
Static Protected Member Functions inherited from HtmlView
static size_t	split (const String &str, StringStringArray &v)
static void	dump (Session &session)
static String	getDefault (ListedStringToStringArrayMap &map, const String &strKey)
static size_t	getShortString (SQLField &field, size_t _len, String &strLong, String &strShort)
Protected Attributes inherited from HtmlView
HtmlPage *	__pPage
int	__nIndex
int	__nClassID
StringToStringMap	__mapParams
Protected Attributes inherited from TextTemplate
void *	__textList
void *	__subTemplateMap

Detailed Description

Definition at line 33 of file Page.h.

Constructor & Destructor Documentation

◆ PageListView()

PageListView::PageListView ( HtmlPage * pPage )

Member Function Documentation

◆ init()

void PageListView::init ( SQLFields & fields )

virtual

Reimplemented from HtmlView.

Definition at line 176 of file Page.cpp.

{
    HtmlView::init(fields);
 
    __mapParams.lookup(L"DETAIL", __strDetailPage);
    __mapParams.lookup(L"WRITE", __strWritePage);
 
    String rValue;
 
    if (__mapParams.lookup(L"PARTS", rValue) && !rValue.isEmpty()) {
        __nParts = Integer::parse(rValue, 10, __nParts);
        if (__nParts < 5 || __nParts > 20)
            __nParts = 5;
    }
 
    if (__mapParams.lookup(L"ROWS", rValue) && !rValue.isEmpty()) {
        __nRows = Integer::parse(rValue, 10, __nRows);
        if (__nRows <= 0)
            __nRows = 20;
    }
 
    if (__mapParams.lookup(L"SHORT_COMMENT", rValue) && !rValue.isEmpty()) {
        int n = Integer::parse(rValue, 10, __nShortComment);
        if (n > 0)
            __nShortComment = n;
    }
}

◆ onPrint()

void PageListView::onPrint ( Session & session )

virtual

Reimplemented from HtmlView.

Definition at line 205 of file Page.cpp.

{
    SQLQuery& q = session.__query;
    ListedStringToStringArrayMap& mapQuery = session.__ctx.__queryMap;
 
    int nCurrentPart = Integer::parse(getDefault(mapQuery, L"part"), 10, 1);
    int nRows = __nRows;
 
    String strDetailPage = __strDetailPage;
    String strWritePage = __strWritePage;
    StringBuilder strThisPage = __pPage->__strPageID;
    String strThisPageEnc;
 
    String strCategoryID = getDefault(mapQuery, L"category");
 
    TextTemplate& CATEGORY = (*this)[L"CATEGORY"];
    q.execute(L""
        "SELECT CATEGORY_ID, CATEGORY_NAME"
        "\n FROM DCL_PAGE_CATEGORY"
        "\n ORDER BY CATEGORY_ID"
    );
    q.fetch();
    while(!q.eof()) {
        CATEGORY.assign(q.fields(), L"");
        append(L"CATEGORY", CATEGORY);
 
        q.fetch();
    }
 
    String strWhere;
    if (!strCategoryID.isEmpty()) {
        strWhere = L"\n WHERE P.CATEGORY_ID = " + strCategoryID;
        strThisPage += L"&category=" + strCategoryID;
    }
 
    assign(L"DETAIL", strDetailPage);
    assign(L"WRITE", strWritePage);
    assign(L"_THIS", URLEncoder::encode(strThisPage));
    assign(L"CATEGORY_ID", strCategoryID);
 
    int nUsingRecord = nRows;
    int nTotalRecord = nUsingRecord;
    int nTotalPart = 1;
 
    // nNo를 표시하기 위해서 조건에 만족하는 전체레코드의 개수가 항상 필요하다.
    q.execute(L""
        "SELECT COUNT(*) "
        "\n FROM DCL_PAGE AS P"
        + strWhere
    );
    q.fetch();
    nTotalRecord = q.fields()[0].asInteger();
    if (nTotalRecord == 0) {
        assign(L"EMPTY", (*this)[L"EMPTY"]);
        HtmlView::onPrint(session);
        return;
    }
 
    __DCL_VERIFY(nTotalRecord > 0);
 
    nTotalPart = nTotalRecord / nUsingRecord;
    if (nTotalRecord % nUsingRecord)
        nTotalPart++;
 
    if (nCurrentPart <= 0 || nCurrentPart > nTotalPart)
        nCurrentPart = nTotalPart;
 
    StringBuilder strThisPageEx = strThisPage;
    if (nCurrentPart > 1)
        strThisPageEx += L"&part=" + String::valueOf(nCurrentPart);
 
    strThisPageEnc = URLEncoder::encode(strThisPageEx);
    assign(L"_THIS", strThisPageEnc);
 
    int nOffset = (nCurrentPart - 1) * nUsingRecord;
 
    int nNo = nTotalRecord - ((nCurrentPart - 1) * nUsingRecord);
    int nRow = 1;
    TextTemplate& PAGE = (*this)[L"PAGE"];
 
    q.execute(L""
        "SELECT P.PAGE_ID, P.TYPE, P.CHARSET, P.LANGUAGE, P.TITLE, P.COMMENT"
            ", P.UPDATE_TIME, R.ROLE_NAME, C.CATEGORY_NAME"
        "\n FROM DCL_PAGE AS P"
        "\n  INNER JOIN DCL_ROLE AS R ON (P.PERM_ID = R.ROLE_ID)"
        "\n  INNER JOIN DCL_PAGE_CATEGORY AS C ON (P.CATEGORY_ID = C.CATEGORY_ID)"
        + strWhere + L""
        "\n ORDER BY P.PAGE_ID DESC"
        "\n LIMIT " + String::valueOf(nUsingRecord) + L""
        "\n  OFFSET " + String::valueOf(nOffset)
    );
 
    q.fetch();
    if (q.eof())
        assign(L"EMPTY", (*this)[L"EMPTY"]);
    else {
        do {
            PAGE.assign(q.fields(), L"&nbsp;");
            SQLField& field = q.fields().byName(L"COMMENT");
            if (field.isNull()) {
                PAGE.assign(L"COMMENT", L"");
                PAGE.assign(L"SHORT_COMMENT", L"&nbsp;");
            }
            else {
                String strDesc = field.asString();
                if ((ssize_t) strDesc.length() > __nShortComment)
                    PAGE.assign(L"SHORT_COMMENT", strDesc.left(__nShortComment) + L"...");
                else
                    PAGE.assign(L"SHORT_COMMENT", strDesc);
            }
 
            PAGE.assign(L"NO", String::valueOf(nNo--));
            PAGE.assign(L"DETAIL", strDetailPage);
            PAGE.assign(L"WRITE", strWritePage);
            PAGE.assign(L"_THIS", strThisPageEnc);
 
            append(L"PAGE", PAGE);
 
            q.fetch();
        } while(!q.eof());
 
        TextTemplate* pPART_LINK = atP(L"PART_LINK");
        if (pPART_LINK && nTotalPart > 1) {
            PartLink pl(pPART_LINK, strThisPage, String());
            pl.assign(this, nTotalPart, nCurrentPart, __nParts);
        }
    }
 
    HtmlView::onPrint(session);
}

The documentation for this class was generated from the following files: