ViewOrder.cpp

Go to the documentation of this file.

#include <dcl/Config.h>
 
#ifdef __WINNT__
#include <windows.h>
#endif
 
#include "EShopServlet.h"
 
#if __DCL_HAVE_THIS_FILE__
#undef __THIS_FILE__
static const char_t __THIS_FILE__[] = L"eshop/ViewOrder.cpp";
#endif
 
__DCL_BEGIN_NAMESPACE
 
void EShopServlet::onViewOrder(
    HttpServletContextEx& ctx,
    const EShopSession& session
)
{
    Writer& out = ctx.writer();
    ListedStringToStringArrayMap& params = ctx.__formMap;
 
    if (session.command() == CM_ORDER) {
        String strName = (params[L"name"])[0];
        String strTel = (params[L"tel"])[0];
        String strAddr = (params[L"tel"])[0];
 
        SQLQuery q(session.SQLConn());
        q.prepare(L""
            "INSERT INTO ES_ORDER_MASTER(ORDER_DATETIME, USER_ID,"
            "       DELIVERY_NAME, DELIVERY_TEL, DELIVERY_ADDR)\n"
            "   VALUES(CURRENT_TIMESTAMP, :USER_ID, :DELIVERY_NAME, "
            "       :DELIVERY_TEL, :DELIVERY_ADDR)"
        );
        q.params()[0].setValue(session.userID());
        q.params()[1].setValue(strName);
        q.params()[2].setValue(strTel);
        q.params()[3].setValue(strAddr);
        q.execute();
 
        q.execute(L""
            "SELECT MAX(ORDER_ID) FROM ES_ORDER_MASTER "
            "   WHERE USER_ID = " + String::valueOf(session.userID())
        );
        q.fetch();
 
        q.execute(L""
            "INSERT INTO ES_ORDER_DETAIL\n"
            "   SELECT " + q.fields()[0].asString() + L", S.PRODUCT_ID, P.PRICE, S.QUANTITY "
            "       FROM ES_SHOPPING_BASKET S "
            "           INNER JOIN ES_PRODUCT P ON S.PRODUCT_ID = P.PRODUCT_ID \n"
            "       WHERE SESSION_ID = \'" + session.sessionID() + L"\'"
        );
 
        q.execute(L""
            "DELETE FROM ES_SHOPPING_BASKET "
            "   WHERE SESSION_ID = \'" + session.sessionID() + L"\'"
        );
    }
 
    SQLQuery qMaster(session.SQLConn());
    qMaster.prepare(L""
        "SELECT * FROM ES_ORDER_MASTER "
        "   WHERE USER_ID = :USER_ID"
    );
    qMaster.params()[0].setValue(session.userID());
    qMaster.execute();
    qMaster.fetch();
 
    TextTemplate tpl = *__pViewOrder;
    TextTemplate& tplOrder = tpl[L"ORDER"];
    TextTemplate& tplEmpty = tpl[L"EMPTY"];
 
    if (qMaster.eof()) {
        tpl.erase(L"ORDER");
        tpl.assign(L"EMPTY", tplEmpty);
    }
    else {
        String strDetailSQL = L""
            "SELECT P.IMAGE_FILE_NAME, P.PRODUCT_NAME, P.QUALITY, "
            "       D.PRICE, D.QUANTITY, D.PRICE * D.QUANTITY AS AMOUNT\n"
            "   FROM ES_ORDER_DETAIL D "
            "       INNER JOIN ES_PRODUCT P ON (D.PRODUCT_ID = P.PRODUCT_ID)\n"
            "   WHERE D.ORDER_ID = :ORDER_ID \n"
            "   ORDER BY D.PRODUCT_ID";
 
        SQLQuery qDetail(session.SQLConn());
 
        TextTemplate& tplMaster = tplOrder[L"MASTER_ROW"];
        TextTemplate& tplDetail = tplMaster[L"DETAIL_ROW"];
        int nNo = 1;
        int64_t nTotal = 0;
        while(!qMaster.eof()) {
            int nOrderID = qMaster.fields().byName(L"ORDER_ID").asInteger();
 
            // SELECT에서 prepare는 한번만 하면 되지만 이 부분에서
            // SQL 드라이버 및 라이브러리에 버그가 발견되었다.
            // 매번 parepare 한다. 2004.12.09
            qDetail.prepare(strDetailSQL);
            qDetail.params()[0].setValue(nOrderID);
            qDetail.execute();
            qDetail.fetch();
            bool bFirst = true;
            int64_t nSubTotal = 0;
            while(!qDetail.eof()) {
                int64_t nAmount = 0;
                qDetail.fields().byName(L"AMOUNT").getValue(nAmount);
                nSubTotal += nAmount;
                tplDetail.assign(qDetail.fields(), L"&nbsp;");  
                if (bFirst) {
                    bFirst = false;
                    tplMaster.assign(L"DETAIL_ROW", tplDetail);
                }
                else
                    tplMaster.append(L"DETAIL_ROW", tplDetail);
 
                qDetail.fetch();
            }
            nTotal += nSubTotal;
            tplMaster.assign(L"SUB_TOTAL", String::valueOf(nSubTotal));
 
            tplMaster.assign(qMaster.fields(), L"&nbsp;");
            tplMaster.assign(L"NO", String::valueOf(nNo++));
            tplOrder.append(L"MASTER_ROW", tplMaster);
            qMaster.fetch();
        }
        tplOrder.assign(L"TOTAL", String::valueOf(nTotal));
        tpl.assign(L"ORDER", tplOrder);
        tpl.erase(L"EMPTY");
    }
 
    out << tpl;
}
 
__DCL_END_NAMESPACE