kleentex/source/commissionsReport.hpp

Go to the documentation of this file.

/*
   commissionsReport.hpp
   
   Commissions Report
   
   
*/

#include "ocTypes.h"
#include "rep_base.hpp"

/*
   Something New
   
   The template for reports is in the main template
*/

class commissions_report: public rep_base
{
  double total;
  double commission;
  string filter;
public:
  commissions_report(ostream&sc, const cgiTemplates & in):rep_base(sc),total(0),commission(0)
  {
    copyTemplates(in);
    topKey = "reptop";
    endKey = "repend";
  }
  ~commissions_report(){;}

  void setFilter( string filterVal ){ filter=filterVal; }
  bool run( llong AffiliateId, string Name )
  {
     total = 0;
     commission = 0;
     ocString sql =
     "select odr.Id as 'Order Id', "
     "odr.Order_Total as 'Order Total', "
     "prm.Percent_Commission as 'Commission', "
     "date_format(odr.Order_Date, '%m/%d/%Y') as 'Date Ordered', "
     "ost.Name as 'Order Status' "
     "from Ordered as odr "
     "inner join Promotion as prm on odr.Promotion = prm.Id "
     "inner Join Affiliate aff on aff.Promotion = prm.Id "
     "inner join Order_Status ost on ost.Id = Order_Status_Id "
     "left join Commission_Check_Orders cco on cco.Ordered = odr.Id "
     "where aff.Id = ";
      sql.append( AffiliateId );
      if( filter.length() )
      {
        sql += " and ";
        sql += filter;
      }
      sql += " order by odr.Order_Date desc limit 500";

      // webIO << sql << endl;
      emitTop( Name );
      emitHeadings("Order Id|Order Total|Commission|Date Ordered|Order Status");

      if ( getData( sql ) )
      {
        emitData();
        emitEnd(); 
      }
      
      emitEnd();

  }
  virtual void sendField( int iField, ocString & td )
  {
    money lineAmount;
    money lineCommission;
    // certain Field Formatting...
    switch( iField )
    {
    case 1:
      lineAmount = atof(rs.getField(iField).format().c_str());
      webIO << part(dataKey).replace( "$data$", lineAmount.format("%n") );
      total += lineAmount.amount();
      break;
    case 2:
      lineAmount = atof(rs.getField(1).format().c_str());
      lineCommission.amount() = atof(rs.getField(iField).format().c_str());
      lineCommission.amount() *= lineAmount.amount();
      lineCommission.amount() /= 100.0;
      commission += lineCommission.amount();
      webIO << part(dataKey).replace( "$data$", lineCommission.format("%n") );
      break;
    default:
      webIO << part(dataKey).replace( "$data$", rs.getField(iField).format().c_str() );
      break; 
    }

  } 

  void derived_complete_event( void )
  {
    money totalAmount = total;
    money totalCommission = commission;
    webIO << part(rowKey);
    ocString totalText = "Total: ";
    webIO << part(dataKey).replace( "$data$", totalText );
    webIO << part(dataKey).replace( "$data$", totalAmount.format("%n") );
    webIO << part(dataKey).replace( "$data$", totalCommission.format("%n") );
    for( int pos=3; pos < rs.getFieldCount(); pos ++ )
      webIO << part(dataKey).replace( "$data$"," &nbsp; ");
      
    webIO << part(endRowKey);
  }
};

---