#!/usr/local/bin/php
# RBS reminder mails, GPLv3, anselm at hoffmeister dot be and modified by carmean at sfu dot ca with help from others including Anselm. 
# See http://sourceforge.net/mailarchive/message.php?msg_id=25430126
# for more information.  
# I tested this by run the code from the website (e.g., the the file was email.php, and I ran it by (re)loading https://cgi.sfu.ca/~website/advising/email.php
# (but made it so all emails went to me so others would not be bothered)
#
# (This used to be good source-  http://www.ope nsource-arc hive.org/showthread.php?t=116053 but now is evil javascript advertising website)

<?
       function sendnotific ( $date, $mrbs, $email, $list ) {
               $mailtext = "Dear User (".$email."),\n\n";
               $mailtext.=   "Your appointment  is at ";
               $mailtext.= "\n".$list;
               
               $mailtext.= "\n\nIf you have changed plans and do not need ";
               $mailtext.= "this appointment, please cancel the booking.\n";
               $mailtext.= "http://yourserver.web.ca/\n\n";
               $mailtext.= "Automatic reminder mail sent by the MRBS ";
   
   
               mail($email,"Reminder ".  # to test "test@email.ca"  or for real, $email
                 strftime("%A at %I:%M %p",$date)." - your appointment",
                 $mailtext, "Bcc: youremail@email.ca\n"."From: youremail@email.ca\n".  # change this to  return
                 "Precedence: bulk\nContent-Type: text/plain;".
                 "charset=UTF-8");
       }


       setlocale(LC_ALL,"En-Us");
       $a = mysql_connect("0", "Username","Password");  # must be "0" on Fraser at SFU, localhost most other places
       if ( ! $a ) { echo "ERR:mysql_connect failed\n"; exit(1); }
       mysql_select_db('mrbs_database',$a) or die ("ERR:select_db failed\n");
       
        $s = mysql_query("SELECT " .
   " e.id, e.start_time, e.end_time, e.description, " .
   "a.area_name, r.room_name, e.create_by as US, e.create_by as EM ".
   "FROM mrbs_entry e,mrbs_area a,mrbs_room r".
   " WHERE (e.room_id=r.id) AND ".
   " (r.area_id=a.id) " .
   " AND (e.start_time>(UNIX_TIMESTAMP()+(1*86400))) ".
   " AND (e.start_time<(UNIX_TIMESTAMP()+(2*86400))) ".
   " AND (e.type='I') ".
   " AND (e.create_by!='dsandher') ".   # Do not remind this person of appointments she made for others
   
   " ORDER BY e.start_time");   #   " ORDER BY e.create_by, e.start_time");

       $list = "";
       $last = "----";
       $lastmail = "";
       $z = 0;
       while ( $a = mysql_fetch_row($s) ) {
               if ( $last != $a[6] ) {
                   if ( $last != "----" ) {
                       echo "reminder: ".$last.", ".$lastmail."\n";  
                       sendnotific($z, $last, $lastmail, $list);
                   }
                    $last = $a[6];
                   $lastmail = $a[7];
                   $list = "";
                   $z = $a[1];
               }
               $list = strftime("%a, %d %B %Y, %H:%M",
                  $a[1])."  : ".$a[4]." / ".$a[5]."\n";
       }
       if ( $last != "----" ) {
         echo "reminder: ".$last.", ".$lastmail."\n";
         sendnotific($z, $last, $lastmail, $list);
       }
?>