PageCategoryForm Class Reference

#include <Page.h>

Inheritance diagram for PageCategoryForm:

Public Member Functions
	PageCategoryForm (HtmlPage *pPage)
virtual void	onPrint (Session &session) __DCL_THROWS1(Exception *)
virtual void	onPost (Session &session) __DCL_THROWS1(Exception *)
Public Member Functions inherited from HtmlView
const HtmlPage *	page () const
String	SELF () const
String	VNO () const
virtual void	init (SQLFields &fields) __DCL_THROWS1(Exception *)
virtual void	onGet (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 20 of file Page.h.

Constructor & Destructor Documentation

PageCategoryForm()

PageCategoryForm::PageCategoryForm

(

HtmlPage *

pPage

)

Member Function Documentation

onPost()

void PageCategoryForm::onPost ( Session & session )

virtual

Reimplemented from FormView.

Definition at line 79 of file Page.cpp.

{
//  HtmlView::dump(session);
 
    ListedStringToStringArrayMap& mapForm = session.__ctx.__formMap;
    StringArray& vCategoryID = mapForm[L"CATEGORY_ID"];
    StringArray& vCategoryName = mapForm[L"CATEGORY_NAME"];
    StringArray& vDescription = mapForm[L"COMMENT"];
    StringArray& vDeleteID = mapForm[L"DELETE_ID"];
 
    if (vCategoryID.size() <= 1) {
        // 스킨 템플릿에서 마지막 CATEGORY_ID는 사용하지 않는다.
        __pPage->refresh(session, session.__ctx.getHttpHeader(L"Referer"));
        return;
    }
 
    // vCategoryID와 vDeleteID가 숫자문자열인지 검사한다.
    // 숫자가 아닌 값이 있는경우에는 예외 발생하여 처리 중단됨
    Array<int> vnCategoryID(vCategoryID.size() - 1);
    for(size_t i = 0; i < vCategoryID.size() - 1; i++)
        vnCategoryID[i] = (unsigned int)Integer::parse(vCategoryID[i], 10);
 
    for(size_t i = 0; i < vDeleteID.size(); i++)
        Integer::parse(vDeleteID[i], 10);
 
    SQLQuery& q = session.__query;
    SQLQuery qInsert(q.connection());
    SQLQuery qUpdate(q.connection());
 
    qInsert.prepare(L""
        "INSERT INTO DCL_PAGE_CATEGORY (CATEGORY_ID, CATEGORY_NAME, COMMENT"
            ", UPDATE_TIME)"
        "\n VALUES(:CATEGORY_ID, :CATEGORY_NAME, :COMMENT, CURRENT_TIMESTAMP)"
    );
    qUpdate.prepare(L""
        "UPDATE DCL_PAGE_CATEGORY"
        "\n SET CATEGORY_NAME = :CATEGORY_NAME"
            ", COMMENT = :COMMENT, UPDATE_TIME = CURRENT_TIMESTAMP"
        "\n WHERE CATEGORY_ID = :CATEGORY_ID"
    );
 
    int iDelete = 0;
    for(size_t i = 0; i < vCategoryID.size() - 1; i++) {
        if (iDelete < (ssize_t) vDeleteID.size() && vCategoryID[i] == vDeleteID[iDelete]) {
            q.execute(L""
                "SELECT COUNT(*) FROM DCL_PAGE "
                "\n WHERE CATEGORY_ID = " + vDeleteID[iDelete]
            );
            q.fetch();
            if (q.fields()[0].asInteger() == 0) {
                q.execute(L""
                    "DELETE FROM DCL_PAGE_CATEGORY"
                    "\n WHERE CATEGORY_ID = " + vDeleteID[iDelete]
                );
            }
            iDelete++;
        }
        else {
            String& strID = vCategoryID[i];
            String& strName = vCategoryName[i];
            String& strDesc = vDescription[i];
 
            q.execute(L""
                "SELECT COUNT(*) FROM DCL_PAGE_CATEGORY"
                "\n WHERE CATEGORY_ID = " + strID
            );
            q.fetch();
 
            SQLQuery* pQuery = &qInsert;
            if (q.fields()[0].asInteger() != 0)   // then UPDATE
                pQuery = &qUpdate;
 
            pQuery->params().byName(L"CATEGORY_ID").setValue(vnCategoryID[i]);
            pQuery->params().byName(L"CATEGORY_NAME").setValue(strName);
            if (strDesc.isEmpty())
                pQuery->params().byName(L"COMMENT").setNull();
            else
                pQuery->params().byName(L"COMMENT").setValue(strDesc);
 
            pQuery->execute();
        }
    }
 
    __pPage->refresh(session, session.__ctx.getHttpHeader(L"Referer"));
}

onPrint()

void PageCategoryForm::onPrint ( Session & session )

virtual

Reimplemented from FormView.

Definition at line 61 of file Page.cpp.

{
    SQLQuery& q = session.__query;
 
    TextTemplate& CATEGORY = (*this)[L"CATEGORY"];
    q.execute(L"SELECT * FROM DCL_PAGE_CATEGORY ORDER BY CATEGORY_ID");
    q.fetch();
    while(!q.eof()) {
        CATEGORY.assign(q.fields(), L"");
        CATEGORY.assign(L"VNO", VNO());
        append(L"CATEGORY", CATEGORY);
        q.fetch();
    }
 
    FormView::onPrint(session);
}

---

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

• Page.h
• Page.cpp