Changeset 3786

Timestamp:

Aug 29, 2007, 2:59:51 PM (12 years ago)

Author:

ebihara

Message:

#177:日記コメントのソート順が新着順になっていたのを修正

Location:

OpenPNE/trunk/webapp

Files:

• lib/db/diary.php (modified) (1 diff)
• modules/pc/page/fh_diary.php (modified) (2 diffs)
• modules/pc/templates/fh_diary.tpl (modified) (2 diffs)

OpenPNE/trunk/webapp/lib/db/diary.php

@@ -913 +913 @@
  * 日記へのコメントリストを取得
  */
-function k_p_fh_diary_c_diary_comment_list4c_diary_id($c_diary_id, $page_size, $page)
-{
-    $sql = 'SELECT * FROM c_diary_comment WHERE c_diary_id = ? ORDER BY r_datetime DESC';
+function k_p_fh_diary_c_diary_comment_list4c_diary_id($c_diary_id, $page_size, $page, $desc = true)
+{
+    $sql = 'SELECT * FROM c_diary_comment WHERE c_diary_id = ? ORDER BY r_datetime ';
+    if ($desc) {
+        $sql .= 'DESC';
+    } else {
+        $sql .= 'ASC';
+    }
     $params = array(intval($c_diary_id));
     $c_diary_comment_list = db_get_all_page($sql, $page, $page_size, $params);

OpenPNE/trunk/webapp/modules/pc/page/fh_diary.php

@@ -72 +72 @@
         }
 
-//        $this->set("target_diary_comment_list", db_diary_get_c_diary_comment_list4c_diary_id($target_c_diary_id));
-        list ($c_diary_comment_list, $is_prev, $is_next, $total_num, $total_page_num)
-            = k_p_fh_diary_c_diary_comment_list4c_diary_id($target_c_diary_id, $page_size, $page);
+        list ($c_diary_comment_list, $is_next, $is_prev, $total_num, $total_page_num)
+            = k_p_fh_diary_c_diary_comment_list4c_diary_id($target_c_diary_id, $page_size, $page, false);
         $this->set('target_diary_comment_list', $c_diary_comment_list);
         $this->set("is_prev", $is_prev);
@@ -85 +84 @@
 
         $pager = array();
-        $pager['end'] = $total_num - ($page_size * ($page - 1));
-        $pager['start'] = $pager['end'] - count($c_diary_comment_list) + 1;
+        $pager['start'] = ($page_size * ($page - 1)) + 1;
+        $pager['end'] = $pager['start'] + count($c_diary_comment_list) - 1;
         $this->set('pager', $pager);
 

OpenPNE/trunk/webapp/modules/pc/templates/fh_diary.tpl

@@ -564 +564 @@
 ({else})
 <a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;is_all=1">すべて表示</a>
-({if $is_next})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=1&amp;page=({$page})">＜前</a> ({/if})
-({if $is_prev})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=-1&amp;page=({$page})">次＞</a> ({/if})
+({if $is_next})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=-1&amp;page=({$page})">＜前</a> ({/if})
+({if $is_prev})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=1&amp;page=({$page})">次＞</a> ({/if})
 ({/if})
  ({$pager.start})番～({$pager.end})番を表示
@@ -674 +674 @@
 ({else})
 <a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;is_all=1">すべて表示</a>
-({if $is_next})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=1&amp;page=({$page})">＜前</a> ({/if})
-({if $is_prev})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=-1&amp;page=({$page})">次＞</a> ({/if})
+({if $is_next})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=-1&amp;page=({$page})">＜前</a> ({/if})
+({if $is_prev})<a href="({t_url m=pc a=page_fh_diary})&amp;target_c_diary_id=({$target_diary.c_diary_id})&amp;direc=1&amp;page=({$page})">次＞</a> ({/if})
 ({/if})
  ({$pager.start})番～({$pager.end})番を表示