Group.cpp

Go to the documentation of this file.

#include <dcl/Config.h>
 
#ifdef __WINNT__
#include <windows.h>
#endif
 
#include <dcl/URI.h>
 
#include "HtmlPage.h"
#include "LinkUtility.h"
#include "User.h"
 
#if __DCL_HAVE_THIS_FILE__
#undef __THIS_FILE__
static const char_t __THIS_FILE__[] = __T("fastpage/Group.cpp");
#endif
 
__DCL_BEGIN_NAMESPACE
/*
IMPLEMENT_CLASSINFO_EX(GroupListView, HtmlView)
 
GroupListView::GroupListView(HtmlPage* pPage)
    : HtmlView(pPage)
{
    __nParts = 5;
    __nRows = 20;
    __nShortComment = 20;
}
 
void GroupListView::init(SQLFields& fields)
    __DCL_THROWS1(Exception*)
{
    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;
    }
}
 
void GroupListView::onPrint()
    __DCL_THROWS1(Exception*)
{
    Session& session = *(__pPage->session());
    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;
    String strThisPage = __pPage->__strPageID;
    String strThisPageEnc;
 
    String strCategoryID = getDefault(mapQuery, L"category");
    String strSort = getDefault(mapQuery, L"sort");
//  String strCriteria = getDefault(mapQuery, L"criteria");
    String strName = getDefault(mapQuery, L"name");
 
    String strWhere;
    String strOrderBy;
 
    if (session.isSysAdmin())
        strWhere += L"G.GROUP_ID >= 0";
    else {
        int nCategoryID = Integer::parse(strCategoryID, 10, 0);
        if (nCategoryID <= 0) {
            // 일반 사용자는 시스템 그룹 카테고리를 볼 수 없다.
            strCategoryID.clear();
        }
 
        strWhere += L"G.GROUP_ID > " + String::valueOf(SYSTEM_GROUP_ID_END);
    }
 
    if (!strCategoryID.isEmpty()) {
        strWhere += L" AND G.CATEGORY_ID = " + strCategoryID;
        strThisPage +="&category=" + strCategoryID;
    }
    else {
        strCategoryID = L"1";
        strWhere += L" AND G.CATEGORY_ID = 1";
    }
 
    if (!strName.isEmpty()) {
        strWhere += L" AND (G.GROUP_NAME LIKE \'%" + strName + L"%\')";
        strThisPage += L"&name=" + URLEncoder::encode(strName);
    }
 
    if (!strSort.isEmpty()) {
        if (strSort == L"id" && session.isSysAdmin()) {
            // 관리자만 GROUP_ID를 사용하여 소트할 수 있다.
            strOrderBy = L" G.GROUP_ID ASC";
            strThisPage += L"&sort=id";
        }
        else if (strSort == L"nuser") {
            strOrderBy = L" G.NUSER DESC, G.GROUP_NAME ASC";
            strThisPage += L"&sort=nuser";
        }
//      else if (strSort == L"nvisit") {
//          strOrderBy = L" G.NVISIT_ALL DESC,";
//          strThisPage += L"&sort=nvisit";
//      }
//      else if (strSort == L"nmsg") {
            strOrderBy = L" G.NMESSAGE DESC, G.GROUP_NAME ASC";
            strThisPage += L"&sort=nmsg";
        }
    }
 
    if (strOrderBy.isEmpty())
        strOrderBy = L" G.NUSER DESC, G.NMESSAGE DESC, G.GROUP_NAME ASC";
 
    assign(L"DETAIL", strDetailPage);
    assign(L"WRITE", strWritePage);
    assign(L"SORT", strSort);
    assign(L"CATEGORY", strCategoryID);
    assign(L"GROUP_NAME", strName);
    if (!session.isSysGuest()) {
        TextTemplate& ADD = (*this)[L"ADD"];
        ADD.assign(L"WRITE", strWritePage);
        ADD.assign(L"CATEGORY_ID", strCategoryID);
        assign(L"ADD", ADD);
    }
    else
        assign(L"ADD", (*this)[L"NADD"]);
 
    int nUsingRecord = nRows;
    int nTotalRecord = nUsingRecord;
    int nTotalPart = 1;
 
    // nNo를 표시하기 위해서 조건에 만족하는 전체레코드의 개수가 항상 필요하다.
    q.execute(
        "SELECT COUNT(*) "
        "\n FROM DCL_GROUP AS G"
        "\n WHERE " + strWhere
    );
    q.fetch();
    nTotalRecord = q.fields()[0].asInteger();
    if (nTotalRecord == 0) {
        assign(L"EMPTY", (*this)[L"EMPTY"]);
        HtmlView::onPrint();
        return;
    }
 
    __DCL_VERIFY(nTotalRecord > 0);
 
    nTotalPart = nTotalRecord / nUsingRecord;
    if (nTotalRecord % nUsingRecord)
        nTotalPart++;
 
    if (nCurrentPart <= 0 || nCurrentPart > nTotalPart)
        nCurrentPart = nTotalPart;
 
    String 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& ROW = (*this)[L"ROW"];
 
    String strSQL =
        "SELECT G.GROUP_ID, G.SIGN_ID, G.GROUP_NAME, G.OWNER_ID"
            ", G.OPEN_TYPE, G.REGIST_DATE, G.COMMENT"
            ", G.TODAY_NUSER, G.TODAY_NVISIT, G.TODAY_NMESSAGE"
            ", G.NUSER, G.NVISIT, G.NMESSAGE"
            ", U.USER_NAME AS OWNER_NAME, U.NICKNAME AS OWNER_NICKNAME"
        "\n FROM DCL_GROUP AS G"
        "\n  INNER JOIN DCL_USER AS U ON (G.OWNER_ID = U.USER_ID)"
        "\n WHERE " + strWhere + 
        "\n ORDER BY " + strOrderBy +
        "\n LIMIT " + String::valueOf(nUsingRecord) +
        "\n  OFFSET " + String::valueOf(nOffset);
 
    __DCL_TRACE1(L"%ls\n", strSQL.data());
 
    q.execute(strSQL);
    q.fetch();
    if (q.eof())
        assign(L"EMPTY", (*this)[L"EMPTY"]);
    else {
//      if (__bNoAsc)
//          nNo = 1;
 
        do {
            ROW.assign(q.fields(), L"&nbsp;");
 
            SQLField& field = q.fields().byName(L"COMMENT");
            if (field.isNull()) {
                ROW.assign(L"SHORT_COMMENT", L"&nbsp;");
                ROW.assign(L"COMMENT", L"");
            }
            else {
                String strComment = field.asString();
                if (strComment.isEmpty())
                    ROW.assign(L"SHORT_COMMENT", L"&nbsp;");
                else {
                    if (strComment.mbLength() > __nShortComment)
                        ROW.assign(L"SHORT_COMMENT", strComment.mbLeft(__nShortComment) + L"...");
                    else
                        ROW.assign(L"SHORT_COMMENT", strComment);
                }
            }
 
            ROW.assign(L"NO", String::valueOf(nNo));
//          if (__bNoAsc)
//              nNo++;
//          else
                nNo--;
 
            ROW.assign(L"DETAIL", strDetailPage);
            ROW.assign(L"WRITE", strWritePage);
            ROW.assign(L"_THIS", strThisPageEnc);
#ifdef __DCL_DEBUG
            ROW.assign(L"_DHE", L"dhed");
#else
            ROW.assign(L"_DHE", L"dhe");
#endif
            append(L"ROW", ROW);
 
            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();
}
 
IMPLEMENT_CLASSINFO_EX(GroupWriteForm, FormView)
 
GroupWriteForm::GroupWriteForm(HtmlPage* pPage)
    : FormView(pPage)
{
}
 
void GroupWriteForm::onPrint()
    __DCL_THROWS1(Exception*)
{
    Session& session = *(__pPage->session());
    ListedStringToStringArrayMap& mapQuery = session.__ctx.__queryMap;
    SQLQuery& q = session.__query;
 
    String strListPage = getDefault(mapQuery, L"list");
    if (!strListPage.isEmpty()) {
        String strListPageEnc = URLEncoder::encode(strListPage);
        assign(L"_LIST", strListPageEnc);
    }
    else
        strListPage = __strListPage;
 
    assign(L"LIST", strListPage);
 
    // "category"가 있으면 새로운 그룹, 그렇지 않으면 수정
    String strCategoryID = getDefault(mapQuery, L"category");
    String strGroupID = getDefault(mapQuery, L"group");
 
#define CM_INVALID  0
#define CM_INSERT   1
#define CM_MODIFY   2
    int nCM = CM_INVALID;
    if (!strCategoryID.isEmpty()) {
        // new
        // CATEGORY_ID를 검사
        int nCategoryID = Integer::parse(strCategoryID, 10, 0);
        q.execute(
            "SELECT CATEGORY_ID, CATEGORY_NAME"
            "\n FROM DCL_GROUP_CATEGORY"
            "\n WHERE CATEGORY_ID = " + String::valueOf(nCategoryID)
        );
        q.fetch();
        if (!q.eof()) {
            if (nCategoryID == SYSTEM_GROUP_CATEGORY && session.isSysAdmin())
                nCM = CM_INSERT;
            else if (nCategoryID >= DEFAULT_GROUP_CATEGORY && !session.isSysGuest())
                nCM = CM_INSERT;
            else {
                // Permission Denied
                __DCL_TRACE2(L"%d, %d\n", nCategoryID, session.__nRoleID);
            }
        }
        else {
            // invalid CATEGORY_ID
            __DCL_TRACE1(L"invalid CATEGORY_ID: %d\n", nCategoryID);
        }
    }
    else {
        // modify
        if (strGroupID.isEmpty()) {
            if (session.isSysAdmin() || session.isMemberAdmin()) {
                nCM = CM_MODIFY;
                strGroupID = String::valueOf(__pPage->site()->nUserID);
            }
        }
        else {
            if (session.isSysAdmin())
                nCM = CM_MODIFY;
        }
    }
 
    if (nCM == CM_INVALID)
        return;
    else if (nCM == CM_INSERT) {
        assign(q.fields(), L"");
    }
    else {
        // CM_MODIFY
        q.execute(
            "SELECT G.GROUP_ID, G.CATEGORY_ID, G.SIGN_ID, G.GROUP_NAME"
                ", G.OPEN_TYPE, G.COMMENT"
                ", C.CATEGORY_NAME"
            "\n FROM DCL_GROUP AS G"
            "\n  INNER JOIN DCL_GROUP_CATEGORY AS C ON (G.CATEGORY_ID = C.CATEGORY_ID)"
            "\n WHERE G.GROUP_ID = " + strGroupID
        );
        q.fetch();
        if (!q.eof())
            assign(q.fields(), L"");
        else
            return;
    }
 
    FormView::onPrint();
}
 
void GroupWriteForm::onPost()
    __DCL_THROWS1(Exception*)
{
}
 
IMPLEMENT_CLASSINFO_EX(GroupDetailView, HtmlView)
 
GroupDetailView::GroupDetailView(HtmlPage* pPage)
    : HtmlView(pPage)
{
}
 
void GroupDetailView::init(SQLFields& fields)
    __DCL_THROWS1(Exception*)
{
    HtmlView::init(fields);
 
    __mapParams.lookup(L"LIST", __strListPage);
    __mapParams.lookup(L"WRITE", __strWritePage);
}
 
void GroupDetailView::onPrint()
    __DCL_THROWS1(Exception*)
{
    Session& session = *(__pPage->session());
    ListedStringToStringArrayMap& mapQuery = session.__ctx.__queryMap;
    SQLQuery& q = session.__query;
 
    String strListPage = getDefault(mapQuery, L"list");
    String strListPageEnc;
    String strWritePage = __strWritePage;
    if (strListPage.isEmpty())
        strListPage = __strListPage;
 
    strListPageEnc = URLEncoder::encode(strListPage);
 
    assign(L"LIST", strListPage);
    assign(L"_LIST", strListPageEnc);
    assign(L"WRITE", strWritePage);
 
    String strGroupIDs  = mapQuery[L"group"].toString(L',', false);
 
    TextTemplate& GROUP = (*this)[L"GROUP"];
    TextTemplate& EMPTY = (*this)[L"EMPTY"];
 
    if (strGroupIDs.isEmpty()) {
        assign(L"EMPTY", EMPTY);
        HtmlView::onPrint();
        return;
    }
 
    q.execute(
        "SELECT G.GROUP_ID, G.SIGN_ID, G.GROUP_NAME, G.OPEN_TYPE"
            ", G.REGIST_DATE, G.COMMENT"
            ", G.TODAY, G.TODAY_NUSER, G.TODAY_NVISIT, G.TODAY_NMESSAGE"
            ", G.NUSER, G.NVISIT, G.NMESSAGE"
            ", C.CATEGORY_NAME, U.USER_NAME AS OWNER_NAME"
        "\n FROM DCL_GROUP AS G"
        "\n  INNER JOIN DCL_GROUP_CATEGORY AS C ON (G.CATEGORY_ID = C.CATEGORY_ID)"
        "\n  INNER JOIN DCL_USER AS U ON (G.OWNER_ID = U.USER_ID)"
        "\n WHERE G.GROUP_ID IN (L" + strGroupIDs + L")"
        "\n ORDER BY G.GROUP_ID ASC"
    );
 
    q.fetch();
    if (q.eof())
        assign(L"EMPTY", EMPTY);
    else {
        do {
            GROUP.assign(q.fields(), L"&nbsp;");
 
            SQLField& field = q.fields().byName(L"COMMENT");
            if (!field.isNull()) {
                String strComment = field.asString();
                if (!strComment.isEmpty())
                    strComment = Html::format(
                        strComment,
                        4,          // TAB 문자를 4개의 ' '로 변환
                        String(),   // 빈 문자열
                        "<br>"
                    );
                else
                    strComment = L"&nbsp;";
 
                GROUP.assign(L"COMMENT", strComment);
            }
 
            GROUP.assign(L"LIST", strListPage);
            GROUP.assign(L"_LIST", strListPageEnc);
            GROUP.assign(L"WRITE", strWritePage);
            append(L"GROUP", GROUP);
 
            q.fetch();
        } while(!q.eof());
    }
    HtmlView::onPrint();
}
 
IMPLEMENT_CLASSINFO_EX(GroupSearchForm, FormView)
 
GroupSearchForm::GroupSearchForm(HtmlPage* pPage)
    : FormView(pPage)
{
}
 
void GroupSearchForm::onPrint()
    __DCL_THROWS1(Exception*)
{
    FormView::onPrint();
}
 
void GroupSearchForm::onPost()
    __DCL_THROWS1(Exception*)
{
}
*/
 
__DCL_END_NAMESPACE