OSDN Git Service

try paging
authoryasushiito <yas@pen-chan.jp>
Mon, 3 Jun 2013 09:58:18 +0000 (18:58 +0900)
committeryasushiito <yas@pen-chan.jp>
Mon, 3 Jun 2013 09:58:18 +0000 (18:58 +0900)
Gemfile
app/models/author.rb
app/models/resource_picture.rb
app/views/home/resource_pictures.html.erb

diff --git a/Gemfile b/Gemfile
index b9b9b40..70787a1 100644 (file)
--- a/Gemfile
+++ b/Gemfile
@@ -2,6 +2,7 @@ source 'http://rubygems.org'
 
 gem 'rails', '3.1.1'
 gem 'devise', '=1.5.2'
+gem 'kaminari'
 gem 'rest-client'
 gem 'aws-s3'
 gem 'validates_existence'
index 2281293..b234a79 100644 (file)
@@ -216,7 +216,7 @@ class Author < ActiveRecord::Base
   end
   
   def self.default_resource_picture_page_size
-    100
+    25
   end
   
   def self.resource_picture_max_page_size
index f85e866..333ca88 100644 (file)
@@ -88,7 +88,7 @@ class ResourcePicture < ActiveRecord::Base
   end
   
   def self.default_page_size
-    100
+    25
   end
   
   def self.max_page_size
@@ -117,7 +117,7 @@ class ResourcePicture < ActiveRecord::Base
   end
   
   def self.list_opt
-    {:include => {:license => {}, :artist => {}, :picture => {}} }
+    {:license => {}, :artist => {}, :picture => {} }
   end
   
   def self.list_json_opt
@@ -129,7 +129,8 @@ class ResourcePicture < ActiveRecord::Base
     opt.merge!(ResourcePicture.list_opt)
     opt.merge!({:limit => page_size, :offset => (page -1) * page_size}) if page_size > 0
     opt.merge!({:conditions => ['resource_pictures.artist_id = ?', ar.id], :order => 'resource_pictures.updated_at desc'})
-    ResourcePicture.find(:all, opt)
+#    ResourcePicture.where(['resource_pictures.artist_id = ?', ar.id]).includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').limit(page_size).offset((page -1) * page_size) 
+    Kaminari.paginate_array(ResourcePicture.where(['resource_pictures.artist_id = ?', ar.id]).includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc')).page(page).per(page_size) 
   end
   
   def self.show rid, roles
index ead33de..36217f9 100644 (file)
@@ -36,3 +36,4 @@
   </tr>
 <% end %>
 </table>
+<%= paginate(@resource_pictures) %>