+ ResourcePicture.includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.mylist ar, page = 1, page_size = Author.default_resource_picture_page_size
+ ResourcePicture.where(self.mylist_where(ar)).includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.himlist ar, page = 1, page_size = Author.default_resource_picture_page_size
+ ResourcePicture.where(self.himlist_where(ar)).includes(ResourcePicture.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_paginate page = 1, page_size = self.default_page_size
+ Kaminari.paginate_array(Array.new(ResourcePicture.count, nil)).page(page).per(page_size)
+ end
+
+ def self.mylist_paginate ar, page = 1, page_size = Author.default_resource_picture_page_size
+ Kaminari.paginate_array(Array.new(ResourcePicture.where(self.mylist_where(ar)).count, nil)).page(page).per(page_size)
+ end
+
+ def self.himlist_paginate ar, page = 1, page_size = Author.default_resource_picture_page_size
+ Kaminari.paginate_array(Array.new(ResourcePicture.where(self.himlist_where(ar)).count, nil)).page(page).per(page_size)
+ end
+
+ def self.list_by_original_picture_where original_picture_id
+ ['resource_pictures.original_picture_id = ?', original_picture_id]
+ end
+
+ def self.list_by_original_picture original_picture_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_original_picture_where(original_picture_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_license_where license_id
+ ['resource_pictures.license_id = ?', license_id]
+ end
+
+ def self.list_by_license license_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_license_where(license_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)
+ end
+
+ def self.list_by_artist_where artist_id
+ ['resource_pictures.artist_id = ?', artist_id]
+ end
+
+ def self.list_by_artist artist_id, roles, page = 1, page_size = self.default_page_size
+ self.where(self.list_by_artist_where(artist_id)).includes(self.list_opt).order('resource_pictures.updated_at desc').offset((page -1) * page_size).limit(page_size)