ViewProduct.cpp

Go to the documentation of this file.

#include <dcl/Config.h>
 
#ifdef __WINNT__
#include <windows.h>
#endif
 
#include <stdio.h>
 
#include <dcl/Files.h>
#include <dcl/Regex.h>
#include <dcl/SQL.h>
//#include <dcl/core/CollectionHashMap.h>
#include <dcl/TextTemplate.h>
 
#include "EShopServlet.h"
 
#if __DCL_HAVE_THIS_FILE__
#undef __THIS_FILE__
static const char_t __THIS_FILE__[] = L"eshop/ViewProduct.cpp";
#endif
 
__DCL_BEGIN_NAMESPACE
 
static String getContent(SQLFields& fields)
{
    StringBuilder strContent;
    String strType = fields.byName(L"CONTENT_TYPE").asString();
    if (!strType.compareNoCase(L"text", 4)) {
        SQLField& f = fields.byName(L"CONTENT");
        if (f.isNull())
            strContent = L"&nbsp;";
        else {
            strContent = f.asString();
 
            if (strType == L"text/plain") {
                StringBuilder str = L"<p>";
                str += strContent.toString().replace_r(L"\r?\n", L"</p><p>", true);
                str += L"</p>";
                strContent = str.toString();
            }
        }
    }
    else {
        // image/
        SQLField& f = fields.byName(L"FILE_NAME");
        if (f.isNull())
            strContent = L"&nbsp;";
        else {
            strContent = L"<img src=\"image/";
            strContent += f.asString() + L"\" alt=\"image\">";
        }
    }
    return strContent;
}
 
static void productDetail(TextTemplate& pi, SQLQuery& q, int nProductID)
{
    StringBuilder strSQL = L""
        "SELECT DISP_POSITION, CONTENT_TYPE, FILE_NAME, CONTENT "
        "   FROM ES_PRODUCT_DETAIL "
        "   WHERE PRODUCT_ID = ";
    strSQL += String::valueOf(nProductID) + L"  ORDER BY DISP_ORDER";
    q.execute(strSQL);
    q.fetch();
 
    if (q.eof()) {
        pi.assign(L"PRODUCT_DETAIL", L"&nbsp;");
        return;
    }
 
    TextTemplate& pd = pi[L"PRODUCT_DETAIL"];
    TextTemplate& row = pd[L"ROW"];
    int nSaveDispPosition = 0;
    while(!q.eof()) {
        SQLFields& fields = q.fields();
 
        int nDispPosition = fields.byName(L"DISP_POSITION").asInteger();
 
        switch(nDispPosition) {
            default:
                nDispPosition = 0;
            case 0: {
                if (nSaveDispPosition == 1) {
                    row.append(L"CONTENT", L"<td>&nbsp;</td>");
                    pd.append(L"ROW", row);
                }
                row.assign(L"CONTENT", L"<td colspan=\"2\">");
                row.append(L"CONTENT", getContent(fields));
                row.append(L"CONTENT", L"</td>");
                pd.append(L"ROW", row);
                break;
            }
            case 1: {   // left
                if (nSaveDispPosition == 1) {
                    row.append(L"CONTENT", L"<td>&nbsp;</td>");
                    pd.append(L"ROW", row);
                }
                row.assign(L"CONTENT", L"<td>");
                row.append(L"CONTENT", getContent(fields));
                row.append(L"CONTENT", L"</td>");
                break;
            }
            case 2: {
                if (nSaveDispPosition != 1)
                    row.assign(L"CONTENT", L"<td>&nbsp;</td>");
 
                row.append(L"CONTENT", L"<td>");
                row.append(L"CONTENT", getContent(fields));
                row.append(L"CONTENT", L"</td>");
                pd.append(L"ROW", row);
            }
        }
        q.fetch();
        nSaveDispPosition = nDispPosition;
    }   // end of while
 
    if (nSaveDispPosition == 1) {
        row.assign(L"CONTENT", L"<td>&nbsp;</td>");
        row.append(L"CONTENT", L"<td>");
        pd.append(L"ROW", row);
    }
 
    pi.assign(L"PRODUCT_DETAIL", pd);
}
 
bool EShopServlet::onViewProduct(
    HttpServletContextEx& ctx,
    const EShopSession& session
)
{
    Writer& out = ctx.writer();
 
    TextTemplate tpl = *__pViewProduct;
 
    SQLQuery q(session.SQLConn());
 
    int nCategoryID = 0;
 
    ListedStringToStringArrayMap::Iterator it =
        ctx.__queryMap.find(PRODUCT_STR);
    if (it == ctx.__queryMap.end() || (*it).value.isEmpty()) {
        StringArray& v = ctx.__queryMap[CATEGORY_STR];
        if (v.size() > 0) {
            try {
                nCategoryID = Int32::parse(v[0]);
            }
            catch(Exception* e) {
                e->destroy();
            }
        }
        else {
            q.execute(L"SELECT MIN(CATEGORY_ID) FROM ES_CATEGORY");
            q.fetch();
            if (!q.eof())
                nCategoryID = q.fields()[0].asInteger();
        }
 
        if (nCategoryID == 0)   //assert nCategoryID > 0
            return false;
 
        TextTemplate& productList = tpl[L"PRODUCT_LIST"];
        TextTemplate& row = productList[L"ROW"];
        q.execute(L""
            "SELECT PRODUCT_ID, PRODUCT_NAME, PRICE, SUMMARY, IMAGE_FILE_NAME "
            "   FROM ES_PRODUCT"
            "   WHERE CATEGORY_ID = " + String::valueOf(nCategoryID)
        + L" ORDER BY PRODUCT_ID"
            );
        q.fetch();
        int nID = 0;
        if (q.eof()) {
            tpl.assign(L"PRODUCT_LIST", L"<p>등록된 목록이 없습니다.</p>\n");
        }
        else {
            String strActionHREF = String::format(L"?%ls=%d",
                COMMAND_STR, CM_VIEW_SHOPPING_BASKET
            );
            productList.assign(L"ACTION_HREF", strActionHREF);
            productList.assign(L"PRODUCT_STR", PRODUCT_STR);
            while(!q.eof()) {
                SQLFields& fields = q.fields();
                nID = fields[0].asInteger();
 
                String strImage = Files::dirname(ctx.path()) + L"image/"
                    + fields.byName(L"IMAGE_FILE_NAME").asString();
 
                String sz = String::format(L"?%ls=%d&%ls=%d",
                    COMMAND_STR, CM_VIEW_PRODUCT,
                    PRODUCT_STR, nID);
 
                row.assign(L"IMAGE", strImage);
                row.assign(L"HREF", sz);
                row.assign(fields, L"&nbsp;");
 
                productList.append(L"ROW", row);
 
                q.fetch();
            }
            tpl.assign(L"PRODUCT_LIST", productList);
        }
        tpl.erase(L"PRODUCT_INFO");
    }
    else {
        // CM_PRODUCT_INFO
        int nProductID = 0;
        StringArray& v= ctx.__queryMap[PRODUCT_STR];
        if (v.size() > 0) {
            try {
                nProductID = Int32::parse(v[0]);
            }
            catch(Exception* e) {
                e->destroy();
            }
        }
 
        q.execute(L""
            "SELECT CATEGORY_ID, PRODUCT_ID, PRODUCT_NAME, PRICE, UNIT, "
            "       SPEC, QUALITY, ORIGIN, PRODUCER, SUMMARY "
            "   FROM ES_PRODUCT "
            "   WHERE PRODUCT_ID = " + String::valueOf(nProductID)
        );
        q.fetch();
 
        if (q.eof())
            return false;
 
        nCategoryID = q.fields()[0].asInteger();
 
        TextTemplate& pi = tpl[L"PRODUCT_INFO"];
        String strActionHREF = String::format(L"?%ls=%d",
            COMMAND_STR, CM_VIEW_SHOPPING_BASKET
        );
        pi.assign(L"ACTION_HREF", strActionHREF);
        pi.assign(L"PRODUCT_STR", PRODUCT_STR);
 
        pi.assign(L"IMAGE", L"image/" + q.fields()[1].asString() + L"s.jpg");
        pi.assign(q.fields(), L"&nbsp;");
 
        productDetail(pi, q, nProductID);
 
        tpl.assign(L"PRODUCT_INFO", pi);
        tpl.erase(L"PRODUCT_LIST");
    }
 
    // 카테고리 목록출력
    // 템플릿에는 CATEGORY_LINK와 CATEGORY_ACTIVE 두개의 내부 템플릿이
    // 포함되어 있다. 
    TextTemplate& caLink = tpl[L"CATEGORY_LINK"];
 
    // CATEGORY_ACTIVE 매크로를 삭제한다.
    tpl.erase(L"CATEGORY_ACTIVE");
 
    q.execute(L""
        "SELECT CATEGORY_ID, CATEGORY_NAME "
        "   FROM ES_CATEGORY "
        "   ORDER BY CATEGORY_ID"
    );
    q.fetch();
    int nID = 0;
    String strName;
    while(!q.eof()) {
        SQLFields& fields = q.fields();
        nID = fields[0].asInteger();
        strName = fields[1].asString();
 
        if (nID == nCategoryID) {
            TextTemplate& caActive = tpl[L"CATEGORY_ACTIVE"];
            caActive.assign(L"CAPTION", strName);
            tpl.append(L"CATEGORY_LINK", caActive);
        }
        else {
            String sz = String::format(L"?%ls=%d&%ls=%d",
                COMMAND_STR, CM_VIEW_PRODUCT,
                CATEGORY_STR, nID
            );
            caLink.assign(L"HREF", sz);
            caLink.assign(L"CAPTION", strName);
            tpl.append(L"CATEGORY_LINK", caLink);
        }
        q.fetch();
    }
 
    out << tpl;
    return true;
}
 
__DCL_END_NAMESPACE