kleentex/source/affiliateLogin.h

Go to the documentation of this file.

#ifndef OPEN_LOGIN_H
#define OPEN_LOGIN_H

#include "cgiCookie.h"
#include "openDB.hpp"
#include "connectstring"
#include "../admin/Affiliate.hpp"
#include "cgiTemplates.h"
#include "Session.hpp"
#include "read_base.hpp"
// #include "Status_Enumerations.h"

#define ALT_USER_QUERY "select Id, concat(Last, ', ', First) from mohawk.People where Is_Admin > 0"

class openService
{
  public:
  // serviceItemMap serviceItems;
  string id,cat_name,sequence,tree_depth,menu_name,
         uri,xml_params;
  string xml_param1;
  openService()
  {;}
    virtual ~openService()
  {;}
  openService(const openService&in):id(in.id), sequence(in.sequence),
         tree_depth(in.tree_depth), cat_name(in.cat_name),  menu_name(in.menu_name),
         uri(in.uri), xml_params(in.xml_params),xml_param1(xml_params)
  {;}
  openService & operator = ( const openService & in )
  {
    id=in.id;
    sequence=in.sequence;
    tree_depth=in.tree_depth;
    cat_name=in.cat_name;
    menu_name=in.menu_name;
    uri=in.uri;
    xml_param1 = xml_params=in.xml_params;
    return *this;
  }
};
typedef map < string, openService > serviceMap;
typedef vector < string > serviceVector;


class openLogin
{
  Affiliate_Obj person;
  quickQuery qqry;
  openRS & rs;
  ocString sql;
protected:
  
  // for superlists
  Session_Obj session;
  
  // for intranet code compatibility
  serviceMap services;
  serviceVector serviceNames;

  void setCookieValue( cgiCookie & cookie, const char * name, string & value )
  {
    if( value.length() == 0 )
    {
      // set the timeout to 'Thu, 01-Jan-1970 00:00:00 GMT'
      // so the cookie will expire NOW.
      string & date = cookie.setTimeout( 1, 1, 1970, 0, 0 );
      cookie.set( name, value.c_str() );
      date = ""; // set the date to null fo the next cookie setting.
    }
    else
    {
      cookie.set( name, value.c_str() );
    }
  }  
  
public:
  string lastError;
  string token;
  openLogin():person(),qqry(),rs(qqry.getRS()){;}
  ~openLogin(){;}
  
  // for superlists
  Session_Obj & Session( void )
  {
    return session;
  }  
  // for intranet code compatibility
  // bool fetchServices( string criteria = "" ) { return false; }
  bool fetchServices( string criteria = "" )
  {
    bool bRet = false;
    bool open = false;
    
    // get the role services - tie back to both roles and groups
    sql = "select distinct s.id, s.cat_name, s.menu_name, s.uri, "// 0,1,2,3
      "s.sequence, s.tree_depth, " // 4, 5
      "rs.xml_params" // 6
      " from services s "
      "inner join role_services rs on rs.service_id = s.id "
      "inner join roles r on r.id = rs.role_id "
      "inner join user_roles ur on ur.role_id = r.id "
      "where ur.user_id = ";
    sql.append(person.Id);
    sql += " and s.enabled = 1";
    sql += " and ur.enabled = 1";
    sql += " and rs.enabled = 1";

    
    if( criteria.length() )
    {
      sql += " and ";
      sql += criteria;
    }
    
    sql += " order by s.sequence, s.tree_depth";
    
    for( open = rs.open(sql); open; open = rs.next() )
    {
      bRet = true;
      openService service;
      /*
      id,cat_name,menu_name,uri,sequence,tree_depth,
         xml_params,xml_param1,xml_param2
      */
      service.id =    rs.getField(0).format();
      service.cat_name =  rs.getField(1).format();
      service.menu_name =     rs.getField(2).format();
      service.uri =           rs.getField(3).format();
      service.sequence =      rs.getField(4).format();
      service.tree_depth =    rs.getField(5).format();
      service.xml_params =    rs.getField(6).format();
      string key = service.uri;

      // duplicate prevention
      if( services.find(key) == services.end() )
      {
        services.insert(make_pair(key,service));
        serviceNames.push_back(key);
      }
    }
    rs.close();
    if( !bRet )
    {
      lastError += " no services for ";
      lastError += person.First;
      lastError += " ";
      lastError += person.Last;
      lastError += " are enabled. <!--";
      lastError += sql;
      lastError += " | ";
      lastError += rs.getErrors();
      lastError += "-->";
    }
    return bRet;

  }  // end fetch 

  void signOff( void )
  {
    cgiCookie cookie;
    // cookies valid for entire site
    cookie.setPath("/");
    string empty="";
    setCookieValue( cookie, "intraToken", empty );
  }

  bool checkUser( const char * user, const char * password )
  {
    // be pessimistic about the return code
    bool bRet = false;
    // be pessimistic about the error string
    lastError = "Bad Login / Password combination: ";


    // establish cookies
    cgiCookie cookie;
    // cookies valid for entire site
    cookie.setPath("/");

    if( user && password && strlen(user) && strlen(password) )
    {
      string wc =  " Email='";
      wc += user;
      wc += "' and Password='";
      wc += password;
      wc += "'";
      
      if( person.get_data(wc) && person.Id > 0)
      {
        ocString sId;
        sId.append(person.Id);
        
        // set sesson cookies
        setCookieValue( cookie, "intraToken", sId );

        // error? what error?
        lastError = "";
        // return true
        bRet = true;
      } // end if query returned data
      else
      {
        lastError += " No such user " + wc + " on this site, please try again. ";
        // DBG     lastError += person.last_result();
      }
    } // end if user and password
    else
    {
      lastError += " Both the login and password must be entered. ";
    }
    setCookieValue( cookie, "lastError", lastError );
    if( bRet )
    {
      ocString LoginData = "";
      LoginData.append( person.Id );
      session.SetData( "Affiliate", LoginData );
      if( person.Promotion > 1 )
      {
        LoginData = "";
        LoginData.append( person.Promotion );
        // For media player
        session.SetData( "Promotion", LoginData );
      }
      session.Synch();
    }
    return bRet;
  }

  bool testLoginStatus( void )
  {
    bool bRet = false;
    cgiCookie cookie;
    string & rId = cookie.get("intraToken");

    if( rId.length() > 0 )
    {
      person.Id=atoll(rId.c_str());
      person.key(person.Id);
      bRet=person.get_data();
      // end if query returned data
    } // end if Id has length
    return bRet;
  }
private:
  string m_menu;
public:  
  string menu ( void )
  { /*
    cgiTemplates menuTmplt;
    menuTmplt.load("Templates/admin_menu.htmp");
    if( person.Id )
    {
      m_menu = menuTmplt.getParagraph("everyone_top");
    }
    else
    {
      m_menu = menuTmplt.getParagraph("admin_signin");
    }
    */
    return m_menu;
  }
  
  
  string Id( void )
  {
    ocString temp;
    temp.append(person.Id);
    return temp;
  }
  string myStaff( void )
  {
    // of course, I am part of my staff
    return Id();
  }
  string & Last( void )
  {
    return person.Last;
  }
  string & First( void )
  {
    return person.First;
  }
  string & Email ( void )
  {
    return person.Email;
  }
  string & PhoneNumber ( void )
  {
    return person.Phone;
  }
  string & Login ( void )
  {
    return person.Email;
  }
  string & Password ( void )
  {
    return person.Password;
  }
  string getSql( void )
  {
    return "";
  }
  string getLastError( void )
  {
    return lastError; // person.last_result();
  }
  string FullName( void )
  {
    return person.First + " " + person.Last;
  }
           
  
  //  Added group_id  site_admin
  string GroupId( void )
  {
    return "";
  }
  bool SiteAdmin( void )
  {
    return false;
  }
  
  // for intranet code compatibility
  serviceMap & Services( void )
  {
    return services;
  }
  serviceVector & ServiceNames( void )
  {
    return serviceNames;
  }

  Affiliate_Obj & Person( void )
  {
    return person;
  }


};


#endif

---