Changeset 573 for trunk/calendar_new/inc/class.bocalendar.inc.php

Timestamp:

01/07/09 15:20:18 (16 years ago)

Author:

niltonneto

Message:

Impĺementações feitas pelo desenvolvedor. (Alexandre Muller

File:

• trunk/calendar_new/inc/class.bocalendar.inc.php (modified) (3 diffs)

trunk/calendar_new/inc/class.bocalendar.inc.php

@@ -85 +85 @@
         }
 
+        // Return the events of current Year
+        function requestYearCal ($dayTime) {
+                // Performing SQL query
+                $query = "SELECT cal_id, title, description, datetime, edatetime FROM phpgw_cal where (owner = '".$this->user_id."') and ((datetime > ".$dayTime." and datetime < ".($dayTime+31104000).") or (edatetime > ".$dayTime." and edatetime < ".($dayTime+2592000)."))";
+                if (!$this->db->query($query))
+                        return false;
+
+                while($this->db->next_record())
+                        $result[] = $this->db->row();
+
+                return $result;
+        }
+
         function insertEvent ($datetime, $edatetime, $title, $description, $location)
         {
@@ -96 +109 @@
 
                 // Performing SQL insert query
-                $query = "INSERT INTO phpgw_cal VALUES (".($id['max']+1).", '".$_SESSION['calendar']['user']['email']."', ".$this->user_id.", null, null, ".$datetime.", ".time().",".$edatetime.", 2, 'E', 0, '".$title."', '".$description."', '".$location."', 0, null, null, null )";
-
+                $query = "INSERT INTO phpgw_cal VALUES (".($id['max']+1).", '".$_SESSION['calendar']['user']['email']."', ".$this->user_id.", null, null, ".$datetime.", ".time().",".$edatetime.", 2, 'E', 0, '".$title."', '".$description."', '".$location."', 0, null)";
                 if ($this->db->query($query)){
                         $query = "INSERT INTO phpgw_cal_user VALUES (".($id['max']+1).", ".$this->user_id.", 'A', 'u')";
@@ -136 +148 @@
 
                 return $return;
-
         }
 }