Changeset 1720 for trunk/calendar/inc/class.bocalendar.inc.php

Timestamp:

11/27/09 15:43:28 (14 years ago)

Author:

eduardoalex

Message:

Ticket #682 - Adicionada verificacao se o delegado ja esta no evento

File:

• trunk/calendar/inc/class.bocalendar.inc.php (modified) (1 diff)

trunk/calendar/inc/class.bocalendar.inc.php

@@ -383 +383 @@
 
                         $this->so->cal->stream->lock(array("phpgw_cal_user"));
-                        $sql = "update phpgw_cal_user set cal_login = $idDelegado,cal_status='U' where cal_id=$idEvento 
-                                        and cal_login=$idDelegador";
-
-                        $this->so->cal->stream->query($sql,__LINE__,__FILE__,0,-1,true);
-
+                        $sql = "SELECT * FROM phpgw_cal_user where cal_id=$idEvento and cal_login=$idDelegado";
+                        
+                        $this->so->cal->stream->query($sql,__LINE__,__FILE__);
+                        if($this->so->cal->stream->next_record())
+                        {
+                                throw new Exception("The selected User is already included in this event");
+                        }else{
+                                $sql = "update phpgw_cal_user set cal_login = $idDelegado,cal_status='U' where cal_id=$idEvento 
+                                                and cal_login=$idDelegador";
+
+                                $this->so->cal->stream->query($sql,__LINE__,__FILE__,0,-1,true);
+                                
+                                $event = $this->so->read_entry($idEvento);
+
+                                $this->send_update(MSG_ADDED,array($idDelegado => 'U'),$event,$event);
+                        }
                         $this->so->cal->stream->unlock();
-                        $event = $this->so->read_entry($idEvento);
-                        /*foreach($event as $id=>$value)
-                                echo "<br>".$id."  --  ".$value;
-                        exit(0);*/
-                        $this->send_update(MSG_ADDED,array($idDelegado => 'U'),$event,$event);
                 }