Case Study - Retired Teachers of Ontario

Retired Teachers of Ontario
Since 1968, Retired Teachers of Ontario - RTO/ERO has provided excellent retirement programs and services for teachers, school and board administrators, educational support staff and college and university faculty. RTO/ERO is a voluntary membership organization with a strong and active voice of over 64,000 paid members. RTO/ERO is the only organization with representation from elementary, secondary, public, Catholic and francophone schools.

1. Splash Page with Multilingual Option
2. Member Center which is accessible to the paid members
3. Online Registration with Beanstream Payment Gateway
4. External data source for Drupal user authentication and login (remote authentication with MS SQL Server)
5. Interactive District Map
6. Job Postings and Volunteer Opportunities Board
7. Events and Calendar Sections
8. Collapsible Breadcrumbs
9. Photo Gallery

• Block translation
• CCK translation
• Content type translation
• Internationalization
• Language Icons
• Menu translation
• String translation

   1. Download freetds and iodbc from :
      http://www.iodbc.org/downloads/iODBC/libiodbc-3.52.7.tar.gz
      ftp://ftp.ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgz
   2. First extract and configure iODBC and then FreeTDS:
      cd $HOME/local
      tar -xvf libiodbc-3.52.7
      tar -xvf freetds-0.82.tar.gz
      cd libiodbc-3.52.7
      ./configure—prefix=$HOME/local/libiodbc—exec-prefix=$HOME/local/libiodbc—enable-gui=no
      make make install
      cd freetds-0.82
      ./configure -prefix=$HOME/local/freetds—with-iodbc=$HOME/local/libiodbc—with-tdsver=8.0
      make
      make install 
   3. Find where tsql is created:
      find $HOME -name “tsql”
      result should be:
       /home/gloscon/local/freetds-0.82/src/apps/tsql
       /home/gloscon/local/freetds/bin/tsql
   4. copy all file from /home/gloscon/local/freetds/bin to /home/gloscon/bin
      cp /home/gloscon/local/freetds/bin/* to /home/gloscon/bin
   5. To validate the connection, create sqlquery.sql file and try to connect MSSQL and use tsql from PHP:
      sqlquery.sql looks like
      use gloscon_db
      select * from user_master
      go

      PHP look like:
      exec(”/home/gloscon/bin/tsql -S MSSQL_Server_IP -U ‘Domain\username’ -P ‘password’ < /home/gloscon/public_html/sqlquery.sql”, $output, $return); echo “Dir returned $return, and output:\n”; var_dump($output);

D. Drupal and third party Membership application integration - MS SQL Server authentication

    function tsql($query){
    $newsinID1 = "USE gloscon_db";   
    $newsinID6 = $query;
    $newsinID7 = "go";
    $newsinID5 = "exit";
   
    $newsinID = $newsinID1."\n".$newsinID6 ."\n".$newsinID7."\n".$newsinID5."\n";
    $filename = tempnam('/tmp', '');
    $fp = fopen($filename, 'w');
   
     fwrite($fp, $newsinID);
     fclose($fp);
   
     $firsttoe = "/home/gloscon/bin/tsql -H 192.168.0.1 -p 1433 -U visitor -P visitor < $filename";
     exec($firsttoe, $output, $return);
     unlink($filename);
  
     return $output; 
}

E. Online Registration with Benstream Payment Gateway and Ubercart


    function uc_beanstream_charge($order_id, $amount, $data) {
  + foreach($response_data as $key => $val){
  + $rdata = explode('=',$val);
  + $response_array[$rdata[0]] = urldecode($rdata[1]);
  + }
  + $message_id = $response_array['trnApproved'];
  + $message_text = $response_array['messageText'];
  + $auth_code = $response_array['trnId'];
   
  - $response_code = explode('=', $response_data[0]);
  - $response_text = explode('=', $response_data[3]);
  - $approval_code = explode('=', $response_data[4]);
  - $message_id = $response_code[0];
  - $message_text = $response_text[0];
  - $auth_code = $approval_code[0];
  }

Credits : Transition Networks Thanks to Mary Olson for her assistance in editing this case study.