Changeset 6411

Timestamp:

Apr 8, 2008, 1:36:34 PM (13 years ago)

Author:

cybaron

Message:

h_homeに表示される最新アルバム一覧取得用関数追加
p_h_home_c_album_friend_list4c_member_id()

File:

• OpenPNE/branches/work/asano/pne_album/webapp/lib/db/album.php (modified) (3 diffs)

OpenPNE/branches/work/asano/pne_album/webapp/lib/db/album.php

@@ -223 +223 @@
 }
 
-/*
-function p_fh_album_list_album_image_list4c_album_id($c_album_id, $page_size, $page)
-{
-    $sql = 'SELECT * FROM c_album_image WHERE c_album_id = ?';
-    $params = array(intval($c_album_id));
-    $list = db_get_all_page($sql, $page, $page_size, $params);
-
-    
-    $sql = 'SELECT COUNT(*) FROM c_album_image WHERE c_album_id = ?';
-    $total_num = db_get_one($sql, $params);
-
-    if ($total_num != 0) {
-        $total_page_num =  ceil($total_num / $page_size);
-        if ($page >= $total_page_num) {
-            $next = false;
-        } else {
-            $next = true;
-        }
-
-        if ($page <= 1) {
-            $prev = false;
-        } else {
-            $prev = true;
-        }
-    }
-    return array($list, $prev, $next, $total_num);
-}
-*/
-
-//取得相册列表
-/*
-function p_fh_album_list_fh_album_list4c_member_id($c_member_id, $page_size, $page,$u = null)
-{
-    $pf_cond = db_album_public_flag_condition($c_member_id, $u);
-    $sql = 'SELECT * FROM c_album WHERE c_member_id = ?'.$pf_cond.
-           ' ORDER BY r_datetime DESC';
-    $params = array(intval($c_member_id));
-    $list = db_get_row($sql,$params);
-    
-//    print "<pre>";
-//    echo "IN DATABASE<br><br>";
-//    print_r ($list);
-//    echo "IN DATABASE<br><br>";
-//    print "</pre>";
-    
-    $sql = 'SELECT COUNT(*) FROM c_album WHERE c_member_id = ?' . $pf_cond;
-    $params1 = array();
-    $total_num = db_get_one($sql, $params);
-    
-    if ($total_num != 0) {
-        $total_page_num =  ceil($total_num / $page_size);
-        if ($page >= $total_page_num) {
-            $next = false;
-        } else {
-            $next = true;
-        }
-
-        if ($page <= 1) {
-            $prev = false;
-        } else {
-            $prev = true;
-        }
-    }
-    
-    $temp = array($list, $prev, $next, $total_num); 
-    
-
-    return $temp;
-}
-*/
-
-/*
-function db_album_category_c_album_category4c_album_id($c_album_id)
-{
-    $sql = 'SELECT category_name FROM c_album_category AS cac,c_album_category_album AS caca WHERE cac.c_album_category_id = caca.c_album_category_id AND caca.c_album_id = ?';
-    $params = array(intval($c_album_id));
-    return db_get_one($sql, $params);
-}
-*/
-
 /**
  * 特定ユーザーのアルバムリスト取得
@@ -418 +338 @@
 
     foreach ($lst as $key=>$value) {
-        //$lst[$key]['count_comments'] = db_album_count_c_album_comment4c_album_id($value['c_album_id']);
         $lst[$key]['c_member'] = db_common_c_member4c_member_id($value['c_member_id']);
     }
@@ -442 +361 @@
     return array($lst, $prev, $next, $total_num);
 }
+
+/**
+ * フレンド最新アルバムリスト取得[h_home用]
+ * 日記公開範囲を考慮
+ * 
+ * @param   int $c_member_id
+ * @param   int $limit
+ * @return  array_of_array  (c_album.*, nickname)
+ */
+function p_h_home_c_album_friend_list4c_member_id($c_member_id, $limit)
+{
+    $friends = db_friend_c_member_id_list($c_member_id, true);
+    if (!$friends) {
+        return array();
+    }
+    $ids = implode(',', array_map('intval', $friends));
+
+    $sql = 'SELECT * FROM c_album' .
+            ' WHERE c_member_id IN (' . $ids . ')' .
+            ' AND public_flag <> \'private\'' .
+            ' ORDER BY r_datetime DESC';
+
+    $c_album_friend_list = db_get_all_limit($sql, 0, $limit);
+
+    foreach ($c_album_friend_list as $key => $value) {
+        $c_member = db_common_c_member4c_member_id_LIGHT($value['c_member_id']);
+        $c_diary_friend_list[$key]['nickname'] = $c_member['nickname'];
+    }
+
+    return $c_album_friend_list;
+}
+
 
 /**