Changeset 457 for trunk/calendar_new/inc

Timestamp:

09/22/08 16:44:30 (16 years ago)

Author:

niltonneto

Message:

Alterações feitas por Alexandre Muller.
Melhorias e correção na versão AJAX da Agenda.
Email: amuller@…

Location:

trunk/calendar_new/inc

Files:

• class.bocalendar.inc.php (modified) (1 diff)
• class.uicalendar.inc.php (modified) (4 diffs)

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

@@ -53 +53 @@
                 // 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+604800).") or (edatetime > ".$dayTime." and edatetime < ".($dayTime+604800)."))";
+                if (!$this->db->query($query))
+                        return false;
+
+                while($this->db->next_record())
+                        $result[] = $this->db->row();
+
+                return $result;
+        }
+
+        function requestDetailsEvent($id) {
+                // Performing SQL query
+                $query = "SELECT title, description, datetime, edatetime, groups, location FROM phpgw_cal where (owner = '".$this->user_id."') and (cal_id = ".$id.")";
                 if (!$this->db->query($query))
                         return false;

trunk/calendar_new/inc/class.uicalendar.inc.php

@@ -23 +23 @@
                 $start = isset ($_REQUEST["start"]) ? $_REQUEST["start"] : NULL;
                 $end = isset ($_REQUEST["end"]) ? $_REQUEST["end"] : NULL;
-                $description = isset ($_REQUEST["desc"]) ? $_REQUEST["desc"] : NULL;
-                if ($start == NULL || $end == NULL || $description == NULL)
+                $title = isset ($_REQUEST["title"]) ? $_REQUEST["title"] : NULL;
+                if ($start == NULL || $end == NULL || $title == NULL)
                         return "false;Empty field";
-                if (!eregi("^[a-zA-Z_.0-9-]*",$description))
+                if (!eregi("^[a-zA-Z_.0-9-]*",$title))
                         return "false;Invalid char in description";
                 if (!eregi("^[0-9]*",$start))
@@ -33 +33 @@
                         return "false;Wrong formed text";
 
-                return $this->db_obj->insertEvent($start, $end, $description, $description);
+                return $this->db_obj->insertEvent($start, $end, $title);
         }
 
@@ -66 +66 @@
 
                 $retorno = "<today>".date('Ydm',$dayViewTime)."</today>";
-                include_once("class.bocalendar.inc.php");
-                $obj = new bocalendar();
 
-                $fromBo = $obj->requestDayCal($dayViewTime);
+                $fromBo = $this->db_obj->requestDayCal($dayViewTime);
 
 
@@ -128 +126 @@
                 return $retorno;
         }
+
+        function getDetails (){
+                $eventId = isset ($_REQUEST["id"]) ? $_REQUEST["id"] : NULL;
+                $fromBo = $this->db_obj->requestDetailsEvent($eventId);
+                $_SESSION['debug'] = $fromBo;
+                foreach ($fromBo[0] as $field => $line) {
+                        $buff .= "<".$field.">".$line."</".$field.">";
+                }
+                return $buff;
+        }
+
         function getViewMonth () {
                 $monthViewTime = isset ($_REQUEST["time"]) ?  strtotime(substr($_REQUEST["time"],0,4)."-".substr($_REQUEST["time"],6,2)."-".substr($_REQUEST["time"],4,2)) : strtotime(date('Y-m-d', time()));