Changeset 5132 for trunk/calendar/inc/class.socalendar_sql.inc.php

Timestamp:

11/03/11 13:21:19 (12 years ago)

Author:

wmerlotto

Message:

Ticket #2305 - Enviando alteracoes, desenvolvidas internamente na Prognus, do modulo calendar.

File:

• trunk/calendar/inc/class.socalendar_sql.inc.php (modified) (8 diffs)

trunk/calendar/inc/class.socalendar_sql.inc.php

@@ -13 +13 @@
   *  option) any later version.                                              *
   \**************************************************************************/
-
+if($_SESSION['isCrun']){
+        $_SESSION['isCrun'] = false;
+        $_SESSION['rootPath'] = PHPGW_INCLUDE_ROOT;
+        require_once $_SESSION['rootPath'].'/API/class.servicelocator.php';
+}else{
+        require_once $_SESSION['rootPath'].'/API/class.servicelocator.php';
+}
 
         if (@$GLOBALS['phpgw_info']['flags']['included_classes']['socalendar_'])
@@ -569 +575 @@
                                 $this->set_title(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('title'))));
                                 $this->set_description(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('description'))));
-                                $this->set_observations(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('observations'))));
-                                $this->set_notifications_owner(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('notifications_owner'))));
-                                $this->set_alter_by(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('alter_by'))));
-                                $this->set_attachment(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('attachment'))));
                                 $this->set_ex_participants(stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('ex_participants'))));
                                 $this->add_attribute('uid',$GLOBALS['phpgw']->strip_html($this->stream->f('uid')));
                                 $this->add_attribute('location',stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('location'))));
+                                $this->add_attribute('organizer',stripslashes($GLOBALS['phpgw']->strip_html($this->stream->f('organizer'))));
                                 $this->add_attribute('reference',(int)$this->stream->f('reference'));
 
@@ -737 +740 @@
                         else
                         {
-                                //$user_where .= $this->user;
                                 $user_where .= $this->user . ') OR (phpgw_cal.owner=' . $this->user;
                         }
@@ -902 +904 @@
                 }
 
-                function save_event(&$event)
+                function save_event(&$event,$sendMail = true, $importAccount = false)
                 {
 
@@ -954 +956 @@
                         $enddate = $this->maketime($event['end']) - $GLOBALS['phpgw']->datetime->tz_offset;
                         $today = time() - $GLOBALS['phpgw']->datetime->tz_offset;
-//
-//                      if($event['recur_type'] != MCAL_RECUR_NONE)
-//                      {
-//                              $type = 'M';
-//                      }
-//                      else
-//                      {
+
+
                                 if ($event['type'] == 'hourAppointment')
                                         $type = 'H';
@@ -967 +964 @@
                                 }else
                                         $type = 'E';
-//                      }
-                        if(is_array($event['attachment']))
-                            $sattach=serialize($event['attachment']);
-                        else if(is_array(unserialize($event['attachment'])))
-                            $sattach=$event['attachment'];
-                        else
-                            $sattach='';
+                        
 
                         $sql = 'UPDATE phpgw_cal SET '
@@ -986 +977 @@
                                         . "title='".$this->stream->db_addslashes($event['title'])."', "
                                         . "description='".$this->stream->db_addslashes($event['description'])."', "
-                                        . "observations='".$this->stream->db_addslashes($event['observations'])."', "
-                    . 'notifications_owner='.(int)$event['notifications_owner'].','
-                                        . "attachment='".$this->stream->db_addslashes($sattach)."', "
-                                        . "alter_by='".$this->stream->db_addslashes($GLOBALS['phpgw_info']['user']['fullname'])."', "
                                         . "ex_participants='".$this->stream->db_addslashes($event['ex_participants'])."', "
+                                        . "organizer='".$this->stream->db_addslashes($event['organizer'])."', "
                                         . "location='".$this->stream->db_addslashes($event['location'])."', "
                                         . ($event['groups']?"groups='".(count($event['groups'])>1?implode(',',$event['groups']):','.$event['groups'][0].',')."', ":'')
@@ -1095 +1083 @@
                         $GLOBALS['phpgw_info']['cal_new_event_id'] = $event['id'];
                         $this->event = $event;
+
+                        if($sendMail)
+                        {
+                            if($importAccount)
+                                $this->sendEmailEvendAccepted($event,$importAccount);
+                            else
+                                $this->sendEmailEvendAccepted($event);
+                        }
+        
                         return True;
                 }
+
+                function sendEmailEvendAccepted($event,$importAccount = false)
+                {
+
+                    if(!$importAccount)
+                        $importAccount['mail'] = $GLOBALS['phpgw_info']['user']['email'];
+
+                    //verifica se eh um evento externo se sim envia o vcard de aceitação em anexo
+                    if($event['owner'] == '-2')
+                    {
+                        $mailService = ServiceLocator::getService('mail');
+
+                        $tmpbody.= "<b>".lang("Event Accepted")."</b> ";
+                        $tmpbody.= "<br><br>".lang("name").": ".$event['title']."<br>";
+                        $tmpbody.= "<br>".lang("description").": ".$event['description']."<br>";
+
+                        $ev[0] = $event;
+
+                        $tmpattach=  $GLOBALS['calendar']->bocalendar->create_vcard($ev,'REPLY',true,$importAccount);
+                        
+                        $mailService->addStringAttachment($tmpattach, 'suggestion.ics', 'application/ics');
+                        $mailService->addStringAttachment($tmpattach, 'vcalendar.ics', 'utf-8', 'text/calendar; charset=utf-8; method=REPLY;', '7bit', '');
+                 
+                        if(strchr($event['organizer'],'@') && strchr($event['organizer'],'<') && strchr($event['organizer'],'>'))
+                        {
+                            $mail = substr($event['organizer'], strpos($event['organizer'],'<'), strpos($event['organizer'],'>'));
+                            $mail = str_replace('<','', str_replace('>','',$mail));
+                        }
+
+                        if($mail)
+                            $mailService->sendMail($mail,$importAccount['mail'],$event['title'],$tmpbody);
+
+                    }
+                    else
+                        $GLOBALS['calendar']->bocalendar->send_update(MSG_ACCEPTED, $event['participants'],$event);
+
+                    return;
+                }
 
                 function get_alarm($cal_id)