ViewSalesReport.cpp

Go to the documentation of this file.

#include <dcl/Config.h>
 
#ifdef __WINNT__
#include <windows.h>
#endif
 
#include <dcl/DateTime.h>
 
#include "EShopServlet.h"
 
#if __DCL_HAVE_THIS_FILE__
#undef __THIS_FILE__
static const char_t __THIS_FILE__[] = L"eshop/ViewSalesReport.cpp";
#endif
 
__DCL_BEGIN_NAMESPACE
 
void EShopServlet::onViewSalesReport(
    HttpServletContextEx& ctx,
    const EShopSession& session
)
{
    Writer& out = ctx.writer();
    ListedStringToStringArrayMap& params = ctx.__queryMap;
 
    TextTemplate tpl(readTemplate(L"view_sales_report.html"));
    TextTemplate& row = tpl[L"ROW"];
 
    tpl.assign(L"TODAY", DateTime::getCurrentLocalTime().date().toStringF(L"%Y-%m-%d"));
 
    SQLQuery q(session.SQLConn());
    q.execute(L""
        "SELECT D.PRODUCT_ID, P.PRODUCT_NAME,"
        "   SUM(D.QUANTITY) AS QUANTITY, P.PRICE,"
        "   SUM(D.QUANTITY * P.PRICE) AS AMOUNT \n"
        "FROM (ES_ORDER_DETAIL D \n"
        "       INNER JOIN ES_ORDER_MASTER M ON (D.ORDER_ID = M.ORDER_ID) \n"
        "       ) \n"
        "       INNER JOIN ES_PRODUCT P ON (D.PRODUCT_ID = P.PRODUCT_ID) \n"
        "WHERE  \n"
        "   CURRENT_DATE <= M.ORDER_DATETIME \n"
        "   AND M.ORDER_DATETIME < DATE_ADD(CURRENT_DATE, INTERVAL 1 DAY) \n"
        "GROUP BY D.PRODUCT_ID "
    );
    q.fetch();
    double fSum = 0.;
    while(!q.eof()) {
        double fAmount = 0.;
        SQLField& f = q.fields().byName(L"AMOUNT");
//      out << f.dataTypeName();
        f.getValue(fAmount);
        fSum += fAmount;
        row.assign(q.fields(), L"&nbsp;");
        tpl.append(L"ROW", row);
        q.fetch();
    }
    tpl.assign(L"TOTAL", String::valueOf(fSum));
    out << tpl;
}
 
__DCL_END_NAMESPACE