Changeset 1562 for branches/release-32/lib/MT/CMS/Dashboard.pm

Timestamp:

03/24/08 22:48:54 (20 months ago)

Author:

bchoate

Message:

Optimizations for dashboard widgets; restrict range of entries/comments for stats widget to 120 days worth.

Files:

• branches/release-32/lib/MT/CMS/Dashboard.pm (modified) (4 diffs)

branches/release-32/lib/MT/CMS/Dashboard.pm

@@ -103 +103 @@
         require MT::Comment;
         $param->{comment_count} = MT::Comment->count(
-            { junk_status => [ 0, 1 ], },
+            { visible => 1, },
             {
                 join => MT::Entry->join_on(
@@ -359 +359 @@
         ],
     };
+
+    require MT::Util;
+    my @ts = MT::Util::offset_time_list(time - (121 * 24 * 60 * 60), $blog_id);
+    my $earliest = sprintf('%04d%02d%02d%02d%02d%02d',
+        $ts[5]+1900, $ts[4]+1, @ts[3,2,1,0]);
+    $terms->{authored_on} = [ $earliest, undef ];
+    $args->{range_incl}{authored_on} = 1;
+
     $terms->{blog_id} = $blog_id if $blog_id;
     if ( !$user->is_superuser && !$blog_id ) {
@@ -411 +419 @@
             {
                 ( $blog_id ? ( blog_id => $blog_id ) : () ),
-                junk_status => [ 0, 1 ],
+                visible => 1,
             },
             $args
@@ -441 +449 @@
         ],
     };
+
+    require MT::Util;
+    my @ts = MT::Util::offset_time_list(time - (121 * 24 * 60 * 60), $blog_id);
+    my $earliest = sprintf('%04d%02d%02d%02d%02d%02d',
+        $ts[5]+1900, $ts[4]+1, @ts[3,2,1,0]);
+    $terms->{created_on} = [ $earliest, undef ];
+    $args->{range_incl}{created_on} = 1;
+
     if ( !$user->is_superuser && !$blog_id ) {
         $args->{join} = MT::Permission->join_on(