Changeset 484 for branches/nathan/modules/base/include/snapshot_include.php

Timestamp:

04/07/09 11:10:54 (3 years ago)

Author:

brieb

Message:

• Fixed problem with endless loop on workload
• Fixed problem with assigned notes not falling off after being marked completed.
• Added 2nd System message detailing how to remove system messages or new installs.

Files:

• branches/nathan/modules/base/include/snapshot_include.php (modified) (4 diffs)

branches/nathan/modules/base/include/snapshot_include.php

@@ -114 +114 @@
 
                                 $querystatement.="
-                                        assignedtoid = ".$this->userid."
-                                         OR (
-                                                type = 'TS'
-                                                AND (assignedtoid = 0 OR assignedtoid IS NULL)
-                                                AND createdby = ".$this->userid."
-                                        ) AND (completed = 0
-                                                OR (completed = 1 AND completeddate >= CURDATE())
+                                        ((
+                                                assignedtoid = ".$this->userid."
+                                                OR      (
+                                                        type = 'TS'
+                                                        AND (assignedtoid = 0 OR assignedtoid IS NULL)
+                                                        AND createdby = ".$this->userid."
+                                                        )
+                                        )
+                                                AND     (
+                                                        completed = 0
+                                                        OR      (
+                                                                completed = 1
+                                                                AND completeddate >= CURDATE()
+                                                                )
+                                                        )
                                         )";
 
@@ -130 +138 @@
 
                                 $querystatement.="
-                                        assignedbyid = ".$this->userid."
+                                        (assignedbyid = ".$this->userid."
                                         AND (completed = 0
                                                 OR (completed = 1 AND completeddate >= CURDATE())
-                                        )";
+                                        ))";
 
                                 $title = "Delegations";
@@ -143 +151 @@
 
                 $querystatement.="AND (
-                                        (startdate IS NULL AND enddate IS NULL AND assignedtodate IS NULL) OR
-                                        (startdate IS NOT NULL AND startdate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY)) OR
-                                        (enddate IS NOT NULL AND enddate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY)) OR
-                                        (assignedtodate IS NOT NULL AND assignedtodate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY))
+                                        (startdate IS NULL AND enddate IS NULL AND assignedtodate IS NULL)
+
+                                        OR (
+                                                (startdate IS NOT NULL AND startdate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY))
+                                                AND (
+                                                        (enddate IS NOT NULL AND enddate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY))
+                                                        OR (assignedtodate IS NOT NULL AND assignedtodate <= DATE_ADD(CURDATE(),INTERVAL 30 DAY))
+                                                )
+                                        )
                                    )";
 
@@ -235 +248 @@
                                                                 case "Now":
                                                                         $section["title"] = "Soon";
-                                                                        $section["date"] = mktime(0,0,0,date("m"),date("d")+7,date("Y"));;
+                                                                        $section["date"] = mktime(0,0,0,date("m"),date("d")+7,date("Y"));
                                                                         break;
 
                                                                 case "Soon":
                                                                         $section["title"] = "Later";
-                                                                        $section["date"] = mktime(0,0,0,date("m"),date("d")+31,date("Y"));;
+//                                                                      $section["date"] = mktime(0,0,0,date("m"),date("d")+31,date("Y"));
+                                                                        $section["date"] = mktime(0,0,0,date("m"),date("d"),2038);
                                                                         break;