kleentex/admin/Category.hpp

Go to the documentation of this file.

/* 
  Category.hpp

  Object Definition and Implementation 
  for Category.
  
  Copyright (C) 2004 by D.K. McCombs.
  W3 Systems Design  

*/  
#ifndef Category_HPP
#define Category_HPP

#include "read_write_base.hpp"
enum category_direction 
{
  up,rgt,btm,lft 
};

class Category_Obj: public read_write_base
{
public:
  identifier Id;
  llong Parent_Id;
  string Name;
  int Display_Order;
  int Display_Level;
  string Description;
  string Base_URL;
    
  Category_Obj():read_write_base()
  ,Id(0LL)
  ,Parent_Id(0LL)
  ,Name("")
  ,Display_Order(0)
  ,Display_Level(1)
  ,Description("")
  ,Base_URL("")
  {  
    // set name
    data_name("Category");
    // add fields
    addDXMap( new llongXfer("Id", &Id ));
    addDXMap( new llongXfer("Parent_Id", &Parent_Id ));
    addDXMap( new stringXfer("Name", &Name ));
    addDXMap( new intXfer("Display_Order", &Display_Order ));
    addDXMap( new intXfer("Display_Level", &Display_Level ));
    addDXMap( new stringXfer("Description", &Description ));
    addDXMap( new stringXfer("Base_URL", &Base_URL ));
  }
  
  /*
  Event hooks for business logic
  =========================
  // Done before any action - a false return prevents action
  virtual bool uvalidate( changeMap & changes  ) { return true; }
  virtual bool dvalidate( void ) { return true; }
  
  // Done after any action - a false return sets a warning
  virtual bool isupplemental( void ){ return true; }  
  virtual bool dsupplemental( void ){ return true; }
  virtual bool ssupplemental( void ){ return true; } 
  */
  virtual bool ivalidate( void  ) 
  { 
    if( Display_Order == 0 )
    {
      // make 1 greter than current max Display_Order
      string sql="select max(Display_Order) from Category";
      if( rs.open(sql) )
      {
        Display_Order = 1+atoi(rs.getField(0).format().c_str());
        rs.close();
      }
    }
    return true; 
  }
  virtual bool usupplemental( changeMap & changes )
  {
    /* Left comment for history, not necessarily nescessary
       -- see if changes include level or order, if so, find the current parent and set it.     
    */
    // we do want to see if we landed on someone elses spot, 
    // and if so, move them and all other categories down by 1
    ocString sql = "select count(*) from Category where Display_Order = ";
    sql.append(Display_Order);
    sql += " and Id != ";
    sql.append(Id);
    if(rs.open(sql))
    {
      long count = atol(rs.getField(0).format().c_str());
      rs.close();
      if( count != 0 )
      {
        sql = "update Category set Display_Order = Display_Order+1 where "
              "Display_Order >= ";
        sql.append(Display_Order);
        sql += " and Id != ";
        sql.append(Id);
        cmd.execute(sql);
      }
    }    
    return true; 
  }
  virtual bool dsupplemental( void )
  {
    // just delete product_categories of this category
    ocString sql = "delete from Product_Categories where Category = ";
    sql.append(Id);
    cmd.execute(sql);
    return true; 
  }
  
  /* 
   Called by cat_move_svc, note that the use of db_action 
   will cause dsupplemental to get called.
   This is as it should be.
  */
  bool move( long long cid, category_direction dir )
  {
    bool bret=false;
    int  nplace_order=0;
    int  oplace_order;
    long long oid=0;
    // load the id in question
    Id=cid;
    key(cid);
    bret = get_data();
    ocString mvSql;    
    if(bret)
    {
      oplace_order=Display_Order;
      changeMap changes;
      // good now what direction
      switch(dir)
      {
        case up:
        // first check to see if any are before you
        mvSql = "select Id, Display_Order from Category where Display_Order < ";
        mvSql.append(Display_Order);
        mvSql += " order by Display_Order desc limit 1";
        bret = false;
        if(rs.open(mvSql))
        {
          oid = atoi(rs.getField(0).format().c_str());
          Display_Order = atoll(rs.getField(1).format().c_str());          
        }
        if( !oid ) Display_Order--;
        changes["Display_Order"]="Display_Order";
        bret = db_action( "u", changes );
        if( oid )
        {
          Id=oid;
          key(oid);
          bret = get_data();
          Display_Order=oplace_order;
          changes["pDisplay_Order"]="Display_Order";
          bret = db_action( "u", changes );
        }
        break;
        
        case rgt:
          ++Display_Level;
          changes["Display_Level"]="Display_Level";
          bret = db_action( "u", changes );
        break;
        
        case btm:
        // first check to see if any are after you                
        mvSql = "select Id, Display_Order from Category where Display_Order > ";
        mvSql.append(Display_Order);
        mvSql += " order by Display_Order asc limit 1";
        bret = false;
        if(rs.open(mvSql))
        {
          oid = atoi(rs.getField(0).format().c_str());
          Display_Order = atoll(rs.getField(1).format().c_str());                    
        }
        if( !oid ) Display_Order++;
        changes["Display_Order"]="Display_Order";
        bret = db_action( "u", changes );
        if( oid )
        {
          Id=oid;
          key(oid);
          bret = get_data();
          Display_Order=oplace_order;
          changes["Display_Order"]="Display_Order";
          bret = db_action( "u", changes );
        }
        break;
        
        case lft:
        // can only go to 1
        if( Display_Level > 1 )
        {
          --Display_Level;
          changes["Display_Level"]="Display_Level";
          bret=db_action( "u", changes );          
        }
        break;
      }
    }
    return bret;
  }          
};
#endif

---