kleentex/admin/Product_ui.cpp

Go to the documentation of this file.

/*
  Product_ui.cpp

  User Interface Definition and Implementation 
  for Product.
  
  Copyright (c) 2005 by D.K. McCombs.
  
  davidmc@w3sys.com
  
  W3 Systems Design Inc.  
  
*/
#include <iostream>
#include <iomanip>
#include "cgiTemplates.h"
#include "connectstring"
#include "forms.h"
#include "ocTypes.h"
#include "ocString.h"
#include "cgiTemplates.h"

#include "read_write_base.hpp"
#include "list_base.hpp"
#include "forms_base.hpp"
#include "richForm.hpp"
#include "Product.hpp"
#include "openLogin.h" 
#include "sublist_base.hpp"

using namespace std;
openLogin oLogin;
class Style_List:  public sublist_base
{

public: 
  ocString Parent_Id;
  // Constructor
  Style_List(cgiScript&sc):sublist_base(sc){;}  
  ~Style_List(){;}
  
  bool list_display( void )
  {
    bool breturn = true;
    string sql =  "select Id, "
                  "Name,  " 
                  "Image,  " 
                  "Manufacturer_Design_No  " 
                  "from Style where Product = " ;
    sql +=  Parent_Id;             
    hotCol=-2;    
    //editLink = listTemplate.getParagraph("hotcolumn");
    editLink = "<a href=\"javascript:jopen('$prog$?Id=$key$')\">$col$</a>";

    editLink = editLink.replace("$prog$","Style_ui.cgi");        
    string heading = "Id|"
                     "Name|" 
                     "Image|" 
                     "Manufacturer_Design_No";    
    emitHeadings(heading);    
    getData( sql );   
    emitData();
    ocString list_new = listTemplate.getParagraph("list_new");
    ocString url = "Style_ui.cgi?Product=";
    url += Parent_Id;
    webIO << list_new.replace("$location",url.c_str()).replace("$cols","5");
    emitEnd();
    return breturn;
  } 
/*
  void sendHotField( int iField, ocString & td )
  {
    if( iField == 2 )
    {
    string data = "<a href=\"javascript:jopen('/small_images/";
    data += rs.getField(iField).format();
    data += "','scrollbars,resizable,width=140,height=95','ImageItem')\">";
    data += rs.getField(iField).format();
    data += "</a>";
    
    webIO <<  td.replace( "$data$", data.c_str());
    }
    else sublist_base::sendHotField(iField,td);                        
  }      
*/
};

class Product_List:  public list_base
{

public: 
  // Constructor
  Product_List(cgiScript&sc):list_base(sc)
  {
    itemsPerPg=50;
  }  
  ~Product_List(){;}
  
  bool list_display( void )
  {
    bool breturn = true;

    hotCol=-2;    
    editLink = listTemplate.getParagraph("hotcolumn");
    editLink = editLink.replace("$prog$","Product_ui.cgi");
    emitFilter( "Product_ui.cgi",
                "    <B>FILTER (by Name)</B>" );  
    string heading =
      "<a class='sortcol' href='Product_ui.cgi?sort=Id'>p.Id</a>|"
      "<a class='sortcol' href='Product_ui.cgi?sort=pl.Name'>Product Line</a>|"
      "<a class='sortcol' href='Product_ui.cgi?sort=p.Name'>Name</a>|"
      "<a class='sortcol' href='Product_ui.cgi?sort=p.Lines_Custom_Text'>Lines Custom Text</a>|"
      "<a class='sortcol' href='Product_ui.cgi?sort=p.SKU'>SKU</a>"
                    ;
    emitHeadings(heading);
    getFilteredData( "p.Id, " 
                     "pl.Name, "
                     "p.Name, " 
                     "p.Lines_Custom_Text, " 
                     "p.SKU "                      
                     ,"Product p inner join Product_Line pl on p.Product_Line = pl.Id",                     
                     "p.Name like '$filter$%'" );   
    emitData();
    emitNavigation("Product_ui.cgi");         
    emitEnd();
    return breturn;
  }
   
};

/*
  The Form
  ---------
  
*/
class Product_form:  public Product_Obj, public richForm
{
private:
  // on Event of form submission, update
  bool setAttributes( string Table, string LeftId, string RightId, ocString values  )
  {
    bool bRet = false;

    if( values.length() )
    {
      ocString sql;
      ocString sqlStart = "insert into " + Table + " (" +LeftId+ ", " +RightId+ " ) values (";
      sqlStart.append(Id);
      sqlStart += ",";
      values.parseInit();
      while( !values.endOfParse() )
      {
        sql = sqlStart;
        sql += values.parse("|");
        sql += ")";   
        // script <<  sql << "<br>" << endl;
        bRet = cmd.execute(sql);
        if(!bRet) break;
      }
      bRet = true;      
    }    
    return bRet;
  }
  
  // on Event of form submission, delete
  bool deleteAttributes( string Table, string LeftId )
  {
    bool bRet = false;
    ocString sql = "delete from " +Table+ " where "  +LeftId+ " = ";
    sql.append(Id);
    bRet = cmd.execute(sql);
    return bRet;
  }
  
  // on event of getting data
  bool retrieveAttributes( string Table, string LeftId, string RightId, string & values  )
  {
    bool bRet = false; 
    values = "";   
    ocString sql = "select " +RightId+ " from " +Table+ " where " +LeftId+ " = ";
    sql.append(Id);
    if( rs.open(sql) )
    {
      bRet = true;
      bool moreData = true;
      do
      {
        values += rs.getField(0).format();
        moreData = rs.next();
        if( moreData ) values += "|";
      }
      while( moreData );
    }  
    return bRet;
  }
protected:

  // For multi select lists  
  string sizes, fonts, colors, backgrounds;

  
public: 
  bool isupplemental( void )
  {
    bool bRet = true;
    bRet = setAttributes("Product_Sizes",  "Product", "Size", sizes);
    // the others aren't settable until after insert    
    return bRet;
  }  
  // event fired after update
  bool usupplemental( changeMap & changes )
  {
    bool bRet=true;
    if( changes.count("Product_Sizes") > 0 )
    { 
      if( deleteAttributes("Product_Sizes", "Product") ) 
        bRet &= setAttributes("Product_Sizes",  "Product", "Size", sizes); 
    } 
    if( changes.count("Product_Fonts") > 0 )
    {       
      if( deleteAttributes("Product_Fonts", "Product") ) 
        bRet &= setAttributes("Product_Fonts",  "Product", "Font", fonts); 
    } 
    if( changes.count("Product_Colors") > 0 )
    { 
      if( deleteAttributes("Product_Colors", "Product") )
        bRet &= setAttributes("Product_Colors",  "Product", "Color", colors); 
    } 
    if( changes.count("Product_Backgrounds") > 0 )
    {  
      if( deleteAttributes("Product_Backgrounds", "Product") ); 
        bRet &= setAttributes("Product_Backgrounds",  "Product", "Color", backgrounds);       
    }
    return bRet; 
  } 
  bool ssupplemental( void )
  {
    bool bret = true;    
    retrieveAttributes("Product_Sizes",  "Product", "Size", sizes);
    retrieveAttributes("Product_Fonts",  "Product", "Font", fonts);
    retrieveAttributes("Product_Colors",  "Product", "Color", colors);
    retrieveAttributes("Product_Backgrounds",  "Product", "Color", backgrounds);            
    return bret;
  }    
  Product_form(cgiScript & script):Product_Obj(),richForm(script){setKey(*this);} 
  virtual ~Product_form(){;}
  
  void form_id_transfer( void )
  {
    llongFXfer( "Id", Id );
  }
  void form_data_transfer( void )
  {
    llongFXfer( "Product_Line", Product_Line);
    stringFXfer( "Name", Name);
    stringFXfer( "Product_Sizes", sizes);
    
    stringFXfer( "Product_Fonts", fonts);
    stringFXfer( "Product_Colors",colors );
    stringFXfer( "Product_Backgrounds", backgrounds);
     
    stringFXfer( "Description", Description);
    intFXfer( "Lines_Custom_Text", Lines_Custom_Text);
    stringFXfer( "SKU", SKU);
    boolFXfer( "Designer", Designer);
    llongFXfer( "Manufacturer", Manufacturer); 
  } 
  
  bool dbf_action( string mode, changeMap & changes )
  {
    if( mode=="i" || mode=="u" )
    {  Description=htmlDecode(Description);
       changes["Description"]="Description";
    }
    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("Product_ui.cgi", "Product")
           << formTemplate.getParagraph("advanced_begin");
    script << makeStaticBox("Id", "Id", Id ,"8");
    script << "<br class='clearall'>" << endl;
    script << formTemplate.getParagraph("advanced_end");
    
    sql = "Select Id, Name from Product_Line"; // for combo boxes
    script << makeComboBox("Product Line", "Product_Line", Product_Line ,sql);
    script << "<br class='clearall'>" << endl;    
    
    /* multiple styles per product
    sql = "Select Id, Name from Style"; 
    script << makeComboBox("Style", "Style", Style ,sql);
    */
    if( key() )
    {
      Style_List cList(script);
      cList.Parent_Id.append(key()); 
      cList.loadListTemplates("Templates/spawninglist.htmp"); 
      script << "<h5>Styles:</h5>" << endl;
      cList.list_display();      
    }     
     
    
    script << "<br class='clearall'>" << endl; 
    script << makeTextBox("Name", "Name", Name ,"125","35");
    script << "<br class='clearall'>" << endl;     
    
    // make description a fixed up hidden field
    Description = htmlFixup( Description );           
    string cedit = makeHiddenBox( "Description", Description );
    cedit += "<a href=\"javascript:jopen( 'richPopUpEditor.html?control=Description', 'scrollbars,resizable,width=730,height=510', 'rich' )\">";
    cedit += "Edit</a>";   
      
    ocString ctrlGrp = formTemplate.getParagraph("control_group");
    
    script << ctrlGrp.replace("$label$","Description")
                     .replace("$control$", cedit.c_str());    
               
    script << makeComboBox( "Sizes","Product_Sizes",sizes,
                            "select s.Id, concat(s.X, 'x', s.Y, u.Abbreviation, ' ', pl.Name ) from " 
                            "Size_Price s inner join Unit u on s.Units = u.Id "
                            " inner join Product_Line pl on s.Product_Line = pl.Id", 
                            "", " multiple='multiple' size='6'" );


    script << "<br class='clearall'>" << endl; 
    script << makeTextBox("Lines Custom Text", "Lines_Custom_Text", Lines_Custom_Text ,"8","8");
    script << "<br class='clearall'>" << endl; 
    script << makeTextBox("SKU", "SKU", SKU ,"125","35");
    script << "<br class='clearall'>" << endl; 

    sql = "Select Id, Name from Manufacturer";    
    script << makeComboBox("Manufacturer", "Manufacturer", Manufacturer ,sql);
    script << "<br class='clearall'>" << endl; 


    ocString DesignerProg = "Designer_ui.cgi?Product_Id=";
    DesignerProg.append(Id);
    script << makeBoolBox("Designer", "Designer", Designer ); 
    if(Designer)
    {
      script << "&nbsp; <a href=\"javascript:addChild('"+DesignerProg+"','', '' )\">Designer Form</a>";
      script << "<br class='clearall'>" << endl; 
      script << "<br class='clearall'>" << endl; 
      script << makeComboBox( "Fonts","Product_Fonts",fonts,
                              "select Id, Name from Font", 
                              "", " multiple='multiple' size='6'" );

      script << makeComboBox( "Colors","Product_Colors",colors,
                              "select Id, Name from Color" , 
                              "", " multiple='multiple' size='6'" );

      script << makeComboBox( "Backgrounds","Product_Backgrounds",backgrounds,
                              "select Id, Name from Color", 
                              "", " multiple='multiple' size='6'" );                                            
    }
    script << "<br class='clearall'>" << endl; 
    
     
       
    script << makeButtons( key() );        
    script << makeBottom( m_result ) << endl; 
    return breturn;
  }
};


int main( int argcount, char ** args )
{
  cgiScript script( "text/html", false );
  Product_form myFrm(script); 
  Product_List mylist(script);  
  if( oLogin.testLoginStatus() )
  {
    script.closeHeader();
    cgiTemplates pgTemplate;    
    pgTemplate.load("Templates/adminPane.htmp");
    
    script << ocString(pgTemplate.getParagraph("top"))
                     .replaceAll("$heading$","Product");

    myFrm.loadControlTemplates("Templates/divform.htmp");  
    myFrm.form_action();  
    myFrm.form_display();
    
    mylist.loadListTemplates("Templates/list.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"

---