Changeset 5316
- Timestamp:
- Feb 23, 2008, 3:05:20 AM (14 years ago)
- Location:
- OpenPNE/trunk/webapp
- Files:
-
- 3 edited
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/webapp/lib/db/friend.php
r4933 r5316 350 350 } 351 351 352 function db_friend_c_friend_list_disp4c_member_id($c_member_id )352 function db_friend_c_friend_list_disp4c_member_id($c_member_id, $page = 1, $size = 20) 353 353 { 354 354 $sql = "SELECT c_member_id,". … … 364 364 " ORDER BY c_friend.r_datetime DESC"; 365 365 $params = array(intval($c_member_id)); 366 $ result = db_get_all($sql, $params);367 368 foreach ($ result as $key=>$value) {366 $c_friend_list = db_get_all_page($sql, $page, $size, $params); 367 368 foreach ($c_friend_list as $key => $value) { 369 369 $c_friend = p_common_c_friend4c_member_id_from4c_member_id_to($value['c_member_id_to'], $value['c_member_id_from']); 370 $result[$key]['intro'] = $c_friend['intro']; 371 372 $result[$key]['friend_count'] = db_friend_count_friends($value['c_member_id_from']); 373 } 374 return $result; 370 $c_friend_list[$key]['intro'] = $c_friend['intro']; 371 372 $c_friend_list[$key]['friend_count'] = db_friend_count_friends($value['c_member_id_from']); 373 } 374 375 $total_num = db_friend_count_friends($c_member_id); 376 $prev = 0; 377 $next = 0; 378 if ($total_num) { 379 $total_page_num = ceil($total_num / $size); 380 if ($page < $total_page_num) { 381 $next = $page + 1; 382 } 383 384 if ($page > 1) { 385 $prev = $page - 1; 386 } 387 } 388 389 return array($c_friend_list, $prev, $next, $total_num); 375 390 } 376 391 -
OpenPNE/trunk/webapp/modules/pc/page/h_manage_friend.php
r4933 r5316 10 10 { 11 11 $u = $GLOBALS['AUTH']->uid(); 12 $page = $requests['page']; 13 $size = 20; 14 15 list($c_friend_list, $prev, $next, $total_num) = db_friend_c_friend_list_disp4c_member_id($u, $page, $size); 16 17 $pager = array( 18 'prev' => $prev, 19 'next' => $next, 20 'total_num' => $total_num, 21 ); 22 $pager['start'] = $size * ($page - 1) + 1; 23 $pager['end'] = $size * $page; 24 if ($pager['end'] > $total_num) { 25 $pager['end'] = $total_num; 26 } 12 27 13 28 $this->set('inc_navi', fetch_inc_navi('h')); 14 $this->set('c_friend_list', db_friend_c_friend_list_disp4c_member_id($u)); 29 $this->set('c_friend_list', $c_friend_list); 30 $this->set('pager', $pager); 15 31 16 32 return 'success'; -
OpenPNE/trunk/webapp/modules/pc/templates/h_manage_friend.tpl
r4419 r5316 30 30 </table> 31 31 <!-- ここまで:小タイトル --> 32 <!-- ここから:ページャー --> 33 <table border="0" cellspacing="0" cellpadding="0" style="width:634px;"> 34 ({*********}) 35 <tr> 36 <td style="width:634px;height:1px;" class="bg_01" colspan="3"><img src="./skin/dummy.gif" alt="dot" class="dot"></td> 37 </tr> 38 ({*********}) 39 <tr> 40 <td style="width:634px;" class="bg_02" align="right" valign="middle"> 41 <div style="padding:4px 3px;"> 42 43 ({if $pager.prev}) 44 <a href="({t_url m=pc a=page_h_manage_friend page=$pager.prev})">前を表示</a> 45 ({/if}) 46 ({if $pager.total_num}) 47 ({$pager.start})件~({$pager.end})件を表示 48 ({/if}) 49 ({if $pager.next}) 50 <a href="({t_url m=pc a=page_h_manage_friend page=$pager.next})">次を表示</a> 51 ({/if}) 52 53 </div> 54 </td> 55 </tr> 56 ({*********}) 57 <tr> 58 <td style="width:634px;height:1px;" class="bg_01" colspan="3"><img src="./skin/dummy.gif" alt="dot" class="dot"></td> 59 </tr> 60 ({*********}) 61 </table> 62 <!-- ここまで:ページャー --> 32 63 ({*ここまで:header*}) 33 64 ({*ここから:body*}) … … 89 120 ({*ここまで:body*}) 90 121 ({*ここから:footer*}) 91 <!-- 無し --> 122 <!-- ここから:ページャー --> 123 <table border="0" cellspacing="0" cellpadding="0" style="width:634px;"> 124 <tr> 125 <td style="width:634px;height:1px;" class="bg_01" colspan="3"><img src="./skin/dummy.gif" alt="dot" class="dot"></td> 126 </tr> 127 ({*********}) 128 <tr> 129 <td style="width:634px;" class="bg_02" align="right" valign="middle"> 130 <div style="padding:4px 3px;"> 131 132 ({if $pager.prev}) 133 <a href="({t_url m=pc a=page_h_manage_friend page=$pager.prev})">前を表示</a> 134 ({/if}) 135 ({if $pager.total_num}) 136 ({$pager.start})件~({$pager.end})件を表示 137 ({/if}) 138 ({if $pager.next}) 139 <a href="({t_url m=pc a=page_h_manage_friend page=$pager.next})">次を表示</a> 140 ({/if}) 141 142 </div> 143 </td> 144 </tr> 145 ({*********}) 146 </table> 147 <!-- ここまで:ページャー --> 92 148 ({*ここまで:footer*}) 93 149 </div>
Note: See TracChangeset
for help on using the changeset viewer.