ZipCode.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 "HtmlView.h"
 
#if __DCL_HAVE_THIS_FILE__
#undef __THIS_FILE__
static const char_t __THIS_FILE__[] = __T("fastpage/ZipCode.cpp");
#endif
 
__DCL_BEGIN_NAMESPACE
 
IMPLEMENT_CLASSINFO_EX(ZipCodeListView, HtmlView)
 
ZipCodeListView::ZipCodeListView(HtmlPage* pPage)
    : HtmlView(pPage)
{
    __nParts = 5;
    __nRows = 10;
}
 
void ZipCodeListView::init(SQLFields& fields)
    __DCL_THROWS1(Exception*)
{
    HtmlView::init(fields);
 
    String rValue;
    if (__mapParams.lookup(L"PARTS", rValue) && !rValue.isEmpty()) {
        int n = Integer::parse(rValue, 10, 0);
        if (5 <= n && n <= 20)
            __nParts = n;
    }
 
    if (__mapParams.lookup(L"ROWS", rValue) && !rValue.isEmpty()) {
        int n = Integer::parse(rValue, 10, 0);
        if (n > 0)
            __nRows = n;
    }
}
 
void ZipCodeListView::onPrint(Session& session)
    __DCL_THROWS1(Exception*)
{
    SQLQuery& q = session.__query;
    ListedStringToStringArrayMap& mapQuery = session.__ctx.__queryMap;
 
    int nCurrentPart = Integer::parse(getDefault(mapQuery, L"part"), 10, 1);
    int nRows = __nRows;
 
    StringBuilder strThisPage = __pPage->__strPageID;
    String strThisPageEnc;
 
    String strSido = getDefault(mapQuery, L"sido");
    String strGugun = getDefault(mapQuery, L"gugun");
    String strDong = getDefault(mapQuery, L"dong");
 
    StringBuilder strWhere;
 
    if (!strSido.isEmpty()) {
        strWhere = L"SIDO LIKE \'" + strSido + L"%\'";
        strThisPage += L"&sido=" + strSido;
    }
    if (!strGugun.isEmpty()) {
        if (!strWhere.isEmpty())
            strWhere += L" AND ";
        strWhere += L"GUGUN LIKE \'" + strGugun + L"%\'";
        strThisPage += L"&gugun=" + strGugun;
    }
    if (!strDong.isEmpty()) {
        if (!strWhere.isEmpty())
            strWhere += L" AND ";
        strWhere += L"DONG LIKE \'" + strDong + L"%\'";
        strThisPage += L"&dong=" + strDong;
    }
 
    if (strWhere.isEmpty()) {
        assign(L"DEFAULT", (*this)[L"DEFAULT"]);
        HtmlView::onPrint(session);
        return;
    }
 
    assign(L"SIDO", strSido);
    assign(L"GUGUN", strGugun);
    assign(L"DONG", strDong);
 
    int nUsingRecord = nRows;
    int nTotalRecord = nUsingRecord;
    int nTotalPart = 1;
 
    StringBuilder strSQL = L""
        "SELECT COUNT(*)"
        "\n FROM DCL_ZIPCODE";
    if (!strWhere.isEmpty())
        strSQL += L"\n WHERE " + strWhere.toString();
 
    q.execute(strSQL);
    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& ROW = (*this)[L"ROW"];
 
    strSQL = L""
        "SELECT ZIPCODE"
            ", CONCAT(SIDO, ' ', GUGUN, ' ', DONG) AS ADDRESS"
            ", BUNJI"
        "\n FROM DCL_ZIPCODE";
 
    if (!strWhere.isEmpty())
        strSQL += L"\n WHERE " + strWhere.toString();
 
    strSQL += L"\n ORDER BY ZIPCODE"
        "\n LIMIT " + String::valueOf(nUsingRecord) + L""
        "\n  OFFSET " + String::valueOf(nOffset);
 
    q.execute(strSQL);
    q.fetch();
    if (q.eof())
        assign(L"EMPTY", (*this)[L"EMPTY"]);
    else {
//      if (__bNoAsc)
//          nNo = nOffset;
 
        TextTemplate& ROW = (*this)[L"ROW"];
        do {
            ROW.assign(q.fields(), L"&nbsp;");
            ROW.assign(L"VNO", VNO());
            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(session);
}
 
__DCL_END_NAMESPACE