Changeset 6895

Timestamp:

May 1, 2008, 4:35:51 AM (14 years ago)

Author:

ebihara

Message:

アップロード画像リスト用関数もOpenPNE_Img_Storageに移動

Location:

OpenPNE/branches/work/ebihara/prj_renew_OpenPNE_Img/webapp/lib

Files:

• OpenPNE/Img/Storage.php (modified) (1 diff)
• db/image.php (modified) (1 diff)

OpenPNE/branches/work/ebihara/prj_renew_OpenPNE_Img/webapp/lib/OpenPNE/Img/Storage.php

@@ -76 +76 @@
     }
 
+    function getImageList($page, $page_size)
+    {
+        $sql = 'SELECT c_image_id FROM c_image ORDER BY c_image_id DESC';
+        $id_list = $this->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 WHERE c_image_id = ?';
+            $params = array(intval($c_image_id));
+            $c_image_list[] = $this->db->get_row($sql, $params);
+        }
+
+        return $c_image_list;
+    }
+
+    function getTotalImageCount()
+    {
+        $sql = 'SELECT COUNT(*) FROM c_image';
+        return $this->db->get_one($sql);
+    }
+
     function isImageExists($filename)
     {

OpenPNE/branches/work/ebihara/prj_renew_OpenPNE_Img/webapp/lib/db/image.php

@@ -23 +23 @@
 function db_image_c_image_list($page, $page_size, &$pager)
 {
-    $db =& db_get_instance('image');
+    require_once 'OpenPNE/Img.php';
+    $img =& new OpenPNE_Img();
+    $c_image_list = $img->storage->getImageList($page, $page_size);
 
-    $sql = 'SELECT c_image_id FROM c_image 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 WHERE c_image_id = ?';
-        $params = array(intval($c_image_id));
-        $c_image_list[] = $db->get_row($sql, $params);
-    }
-
-    $sql = 'SELECT COUNT(*) FROM c_image';
-    $total_num = $db->get_one($sql);
+    $total_num = $img->storage->getTotalImageCount();
 
     $pager = admin_make_pager($page, $page_size, $total_num);