Changeset 6557

Timestamp:

Apr 16, 2008, 2:45:53 AM (14 years ago)

Author:

ebihara

Message:

#135:管理画面からアルバム写真管理が使用できるようにした

Location:

OpenPNE/trunk

Files:

• public_html/modules/admin/default.css (modified) (1 diff)
• webapp/lib/db/album.php (modified) (2 diffs)
• webapp/modules/admin/lib/db_admin.php (modified) (1 diff)
• webapp/modules/admin/page/edit_album_image_list.php (added)
• webapp/modules/admin/templates/edit_album_image_list.tpl (added)
• webapp/modules/admin/templates/edit_album_list.tpl (modified) (1 diff)
• webapp/modules/admin/validate/page/edit_album_image_list.ini (added)

OpenPNE/trunk/public_html/modules/admin/default.css

@@ -1498 +1498 @@
 #admin_page_edit_album_list td.formbutton { text-align: center; }
 
+/** admin_page_edit_album_image_list **/
+#admin_page_edit_album_image_list h2 { padding-left: 17px; background: url("../../admin/img/icn_ttl.gif") no-repeat 0 50%; line-height: 22px; font-size: 22px;}
+#admin_page_edit_album_image_list table { width: 100%;}
+#admin_page_edit_album_image_list td.menu { padding-right: 10px; vertical-align: top;}
+#admin_page_edit_album_image_list td.detail { padding-bottom: 10px; width: 100%; border: 1px #A4A4A6 solid; vertical-align: top;}
+#admin_page_edit_album_image_list td.menu ul { padding: 2px 18px 20px 0;}
+#admin_page_edit_album_image_list td.menu ul li { padding-top: 2px; list-style-type: none; white-space: pre;}
+#admin_page_edit_album_image_list td.detail div { padding: 20px;}
+#admin_page_edit_album_image_list td.detail h3 { padding-left: 20px; border-bottom: 1px #A3A3A6 solid; background-color: #58585C; color:#fff; line-height: 200%; font-size: medium;}
+#admin_page_edit_album_image_list div#searchForm form {margin-bottom: 10px;}
+#admin_page_edit_album_image_list p#noAlbum { text-align: center; margin: 15px 0; }
+#admin_page_edit_album_image_list table.album { margin: 15px; width: 570px; }
+#admin_page_edit_album_image_list td.textbody { width: 470px; word-break: break-all; }
+#admin_page_edit_album_image_list td.formbutton { text-align: center; }
+
 /*********** footer ***********/
 .footer { margin-top: 20px; padding: 10px 0; text-align: center;}

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

@@ -635 +635 @@
 }
 
-//管理画面用に残しておく
-function db_image_c_album_image_list($page, $page_size, &$pager)
-{
-    $db =& db_get_instance('image');
-
-    $sql = 'SELECT c_image_id FROM c_image_album ORDER BY c_image_id DESC';
-    $id_list = db_get_col_page($sql, $page, $page_size);
-
-    $c_image_list = array();
-    foreach ($id_list as $c_image_id) {
-        $sql = 'SELECT c_image_id, filename, r_datetime FROM c_image_album WHERE c_image_id = ?';
-        $params = array(intval($c_image_id));
-        $c_image_list[] = $db->get_row($sql, $params);
-    }
-
-    $sql = 'SELECT COUNT(*) FROM c_image_album';
-    $total_num = $db->get_one($sql);
-
-    $pager = admin_make_pager($page, $page_size, $total_num);
-    return $c_image_list;
-}
-
 function db_album_image_data_delete($image_filename)
 {
@@ -666 +644 @@
     image_cache_delete($image_filename);
 }
-
-
 
 function db_album_image_delete_c_image($filename)

OpenPNE/trunk/webapp/modules/admin/lib/db_admin.php

@@ -3060 +3060 @@
 }
 
+function db_admin_c_album_image_list($page, $page_size, &$pager, $c_album_id = null)
+{
+    $db =& db_get_instance('image');
+
+    $params = array();
+    $sql = 'SELECT cai.c_album_image_id, cai.image_filename, cai.r_datetime, cai.image_description, cai.c_album_id, ca.subject'
+         . ' FROM c_album_image AS cai'
+         . ' INNER JOIN c_album AS ca ON cai.c_album_id = ca.c_album_id';
+    if ($c_album_id) {
+        $sql .= ' WHERE ca.c_album_id = ?';
+        $params[] = $c_album_id;
+    }
+    $sql .= ' ORDER BY r_datetime DESC';
+    $c_image_album_list = db_get_all_page($sql, $page, $page_size, $params);
+
+    $sql = 'SELECT COUNT(*) FROM c_album_image';
+    if ($c_album_id) {
+        $sql .=  'WHERE c_album_id = ?';
+    }
+    $total_num = $db->get_one($sql, $params);
+
+    $pager = admin_make_pager($page, $page_size, $total_num);
+    return $c_image_album_list;
+}
+
+function db_admin_c_album_image_list4c_album_image_id($page, $page_size, &$pager, $c_album_image_id)
+{
+    $db =& db_get_instance('image');
+
+    $sql = 'SELECT cai.c_album_image_id, cai.image_filename, cai.r_datetime, cai.image_description, cai.c_album_id, ca.subject'
+         . ' FROM c_album_image AS cai'
+         . ' INNER JOIN c_album AS ca ON cai.c_album_id = ca.c_album_id'
+         . ' WHERE cai.c_album_image_id = ?'
+         . ' ORDER BY r_datetime DESC';
+    $params = array($c_album_image_id);
+    $c_image_album_list = db_get_all_page($sql, $page, $page_size, $params);
+
+    $sql = 'SELECT COUNT(*) FROM c_album_image'
+         . ' WHERE c_album_image_id = ?';
+    $total_num = $db->get_one($sql, $params);
+
+    $pager = admin_make_pager($page, $page_size, $total_num);
+    return $c_image_album_list;
+}
 ?>

OpenPNE/trunk/webapp/modules/admin/templates/edit_album_list.tpl

@@ -82 +82 @@
             <th>表紙</th>
             <td>
-            <img src="({if $item.album_cover_image})({t_img_album_url filename=$item.album_cover_image w=180 h=180})({else})({t_img_url_skin filename=no_image w=180 h=180})({/if})">
+            <img src="({if $item.album_cover_image})({t_img_album_url filename=$item.album_cover_image w=120 h=120})({else})({t_img_url_skin filename=no_image w=120 h=120})({/if})">
             </td>
             </tr>