kleentex/admin/Affiliate_UI.cpp

Go to the documentation of this file.

/*

  Affiliate_UI.cpp

  User Interface Definition and Implementation 
  for Affiliate.
  Copyright (c) 2007 by D.K. McCombs.
  davidmc@w3sys.com
  W3 Systems Design Inc.

*/
#include <iostream>
#include <iomanip>
#include "cgiClass.h"
#include "cgiTemplates.h"
#include "connectstring"
#include "forms.h"
#include "ocTypes.h"
#include "ocString.h"
#include "cgiTemplates.h"

#include "read_write_base.hpp"
#include "superlist_base.hpp"
#include "forms_base.hpp"
#include "Affiliate.hpp"
#include "openLogin.h" 
#include "sublist_base.hpp"
using namespace std;
openLogin oLogin;

 class Ordered_List:  public sublist_base
{
  double total;
  double commission;
public: 
  ocString Parent_Id;
  // Constructor
  Ordered_List(cgiScript&sc):sublist_base(sc),total(0),commission(0){;}  
  ~Ordered_List(){;}
  
  bool list_display( void )
  {
    bool breturn = true;
    total = 0;
    commission = 0;
    string sql =  "select odr.Id as 'Order Id', "                        // 0
     "odr.Order_Total as 'Order Total', "                                // 1
     "prm.Percent_Commission as 'Commission', "                          // 2
     "date_format(odr.Order_Date, '%m/%d/%Y') as 'Date Ordered', "       // 3
     "ost.Name as 'Order Status', ost.Id  "                                       // 4 , 5
     "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 where aff.Id = ";
    sql +=  Parent_Id;             
    hotCol=-1;    
    editLink = listTemplate.getParagraph("hotcolumn");
    editLink = editLink.replace("$prog$","Ordered_Popup.cgi");        
    string heading = "Order Id|Order Total|Commission|Date Ordered|Order Status|Pay";
    
    emitHeadings(heading);
    
    getData( sql );   
    emitData();
    emitEnd();
    return breturn;
  }
  virtual void sendField( int iField, ocString & td )
  {
    money lineAmount;
    money lineCommission;
    ocString content;
    // certain Field Formatting...
    switch( iField )
    {
    case 1:
      lineAmount = atof(rs.getField(iField).format().c_str());
      webIO << ocString(listTemplate.getParagraph("td")).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 << ocString(listTemplate.getParagraph("td")).replace( "$data$", lineCommission.format("%n") );
      break;
    case 5:
      content = " &nbsp; ";
      if( rs.getField(5).format() != "3" )
      { 
        content = "<input type='checkbox' name='odrId' value='";
        content += rs.getField(0).format();
        content += "' />";
      }
      webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", content);
      break;
    default:
      webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", rs.getField(iField).format().c_str() );
      break;
    }

  }

  void derived_complete_event( void )
  {
    money totalAmount = total;
    money totalCommission = commission;
    string payButton = "<input type='button' onclick='payCommission("+ Parent_Id +")' value='Pay'/>";
    webIO << listTemplate.getParagraph("tr");
    ocString totalText = "Total: ";
    webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", totalText );
    webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", totalAmount.format("%n") );
    webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", totalCommission.format("%n") );
    for( int pos=0; pos < 2; pos ++ )
      webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$"," &nbsp; ");
    webIO << ocString(listTemplate.getParagraph("td")).replace( "$data$", payButton );
    webIO << listTemplate.getParagraph("end_tr");
  }
};
 
 class Affiliate_List:  public list_base
{
  public:
  // Constructor
    Affiliate_List(cgiScript&sc,Session_Obj & session):list_base(sc,session){;}
    ~Affiliate_List(){;}
  
    bool list_display( void )
    {
      bool breturn = true;

      hotCol=-2;
      editLink = listTemplate.getParagraph("hotcolumn");
      editLink = editLink.replace("$prog$","Affiliate_UI.cgi");
      emitFilter( "Affiliate_UI.cgi",
                  "<h2>Affiliates · Search by Organization Name</h2>" );
      string heading =
          "<a class='sortcol' href='Affiliate_UI.cgi?sort=Id'>Id</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Organization_Name'>Organization</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=First'>First</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Last'>Last</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Phone'>Phone</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Mobile'>Mobile</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Email'>Email</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=City'>City</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=State'>State</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Zip'>Zip</a>|"
                    "<a class='sortcol' href='Affiliate_UI.cgi?sort=Country'>Country</a>"
                    ;
      emitHeadings(heading);
      getFilteredData(
                    "Id, "
                    "Organization_Name, "
                    "First, "
                    "Last, "
                    "Phone, "
                    "Mobile, "
                    "Email, "
                    "City, "
                    "State, "
                    "Zip, "
                    "Country "
                    ,"Affiliate",
      "Organization_Name like '$filter$%'" );
      emitData();
      emitNavigation("Affiliate_UI.cgi");
      emitEnd();
      return breturn;
    }
};

class Affiliate_form:  public Affiliate_Obj, public forms_base
{
  public:
    Affiliate_form(cgiScript & script):Affiliate_Obj(),forms_base(script){setKey(*this);}
    virtual ~Affiliate_form(){;}
  
    void form_id_transfer( void )
    {
      llongFXfer( "Id", Id );
    }
    void form_data_transfer( void )
    {
      stringFXfer( "Organization_Name", Organization_Name);
            stringFXfer( "First", First);
            stringFXfer( "Last", Last);
            llongFXfer( "Promotion", Promotion);
            stringFXfer( "Phone", Phone);
            stringFXfer( "Mobile", Mobile);
            stringFXfer( "Email", Email);
            stringFXfer( "Password", Password);
            stringFXfer( "Address_1", Address_1);
            stringFXfer( "Address_2", Address_2);
            stringFXfer( "City", City);
            stringFXfer( "State", State);
            stringFXfer( "Zip", Zip);
            //stringFXfer( "Country", Country);

    }
  
    bool dbf_action( string mode, changeMap & changes )
    {
      return db_action( mode, changes );
    }

  // implement pure virtual of form display
    bool form_display( void )
    {
      bool breturn = true;
      ocString sql; // for combo boxes
      script << makeTop("Affiliate_UI.cgi", "Affiliate")
          << formTemplate.getParagraph("advanced_begin");
      script << makeStaticBox("Id", "Id", Id ,"8");
      script << "<br class='clearall'>" << endl;
      script << formTemplate.getParagraph("advanced_end");

      script << makeTextBox("Organization Name", "Organization_Name", Organization_Name ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("First", "First", First ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Last", "Last", Last ,"125","35");
      script << "<br class='clearall'>" << endl;
      sql = "select Id, Name from Promotion where Percent_Commission > 0.0 order by Name";

      script << makeComboBox("Promotion", "Promotion", Promotion ,sql,"Please Choose");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Phone", "Phone", Phone ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Mobile", "Mobile", Mobile ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Email", "Email", Email ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Password", "Password", Password ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Address 1", "Address_1", Address_1 ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Address 2", "Address_2", Address_2 ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("City", "City", City ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << makeStateBox("State", "State", State );
      script << "<br class='clearall'>" << endl;

      script << makeTextBox("Zip", "Zip", Zip ,"125","35");
      script << "<br class='clearall'>" << endl;

      script << "<br class='clearall'>" << endl;
      script << makeButtons( key() );

      if( key() )
      {
        Ordered_List OrderedList(script);
        OrderedList.Parent_Id.append(key());
        OrderedList.loadListTemplates("Templates/spawninglist.htmp");
        script << "<h4>Commission Orders:</h4>" << endl;
        OrderedList.list_display();
      }
      script << makeBottom( m_result ) << endl;
      return breturn;
    }

};



int main( int argcount, char ** args )
{
  cgiScript script( "text/html", false );
  Affiliate_form myFrm(script);
  Affiliate_List mylist(script,oLogin.Session());
  if( oLogin.testLoginStatus() )
  {
    script.closeHeader();
    cgiTemplates pgTemplate;    
    pgTemplate.load("Templates/adminPane.htmp");
    
    script << ocString(pgTemplate.getParagraph("top"))
                     .replaceAll("$heading$","Affiliate")
                     .replace("<!--Added_Header_Content-->","<SCRIPT type=\"text/javascript\" src=\"payCommission.js\"></SCRIPT>");

    myFrm.loadControlTemplates("Templates/divform.htmp");  
    myFrm.form_action();  
    myFrm.form_display();
    
    mylist.loadListTemplates("Templates/navlist.htmp");  
    mylist.list_display();
        
    ocString end = pgTemplate.getParagraph("bottom");
    script << end;          
  }
  else
  {
    script.Redirect("signIn.html"); 
  } 
}
// compile implementations here
#include "read_write_base.cpp"
#include "forms_base.cpp"

---