Changeset 20338 for events/phpframework/plain_php/trunk/model/phwittr/TimelineService.php

Timestamp:

10/01/08 07:41:06 (3 months ago)

Author:

anatoo

Message:

メール周り追加

Files:

• events/phpframework/plain_php/trunk/model/phwittr/TimelineService.php (modified) (5 diffs)

events/phpframework/plain_php/trunk/model/phwittr/TimelineService.php

@@ -3 +3 @@
 class TimelineService
 {
-    protected $pdo, $context;
-    function __construct(PDO $pdo, ApplicationContext $context)
+    protected $pdo, $baseUrl;
+    function __construct(PDO $pdo, $base_url)
     {
         $this->pdo = $pdo;
-        $this->context = $context;
+        $this->baseUrl = $base_url;
     }
     function fetchPublicTimeline($offset, $limit)
@@ -55 +55 @@
     {
         $smt = $this->pdo->prepare('
-            select statuses.* from statuses 
+            select statuses.*, users.user_name, users.image from statuses 
             left join users on users.id = statuses.user_id where users.id = :user_id 
             order by statuses.created_at desc 
@@ -92 +92 @@
             select count(users.id) 
                 from statuses left join users on users.id = statuses.user_id
-                     left join followers f1 on f1.user_id = users.id
-                      
-                where users.delete_flag = 0 and f1.follow_id = :user_id
-                      or users.id = :user_id');
+                              left join (select * from followers where user_id = :user_id) f1 on f1.follow_id = users.id
+                          
+                where users.delete_flag = 0 and f1.user_id = :user_id
+                      or users.id = :user_id ');
         
         $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT);
@@ -105 +105 @@
             select users.user_name, users.image, statuses.* 
                 from statuses left join users on users.id = statuses.user_id
-                              left join followers f1 on f1.user_id = users.id
+                              left join (select * from followers where user_id = :user_id) f1 on f1.follow_id = users.id
                           
-                where users.delete_flag = 0 and f1.follow_id = :user_id
+                where users.delete_flag = 0 and f1.user_id = :user_id
                       or users.id = :user_id 
                        
@@ -138 +138 @@
         $status['comment'] = preg_replace('#(https?://[[:alnum:]+$;?.%,!\#~*/:@&=_-]+)#', '<a href="$1">$1</a>' , h($status['comment']));
         $status['comment'] = preg_replace('#@([[:word:]]{1,30})#', 
-                                '@<a href="' . $this->context->baseUrl . '/$1">$1</a>', 
+                                '@<a href="' . $this->baseUrl . '/$1">$1</a>', 
                                 $status['comment']);
         return $status;