def list(self):
inputParams = self.getInput()
page = int(inputParams['page']) if inputParams.has_key('page') else 1
imgsList = Images.select().order_by(Images.id.desc())
pageString = self.getPageStr(
self.makeUrl('/admin/images/list'),
page,
config.COUNT_PER_PAGE,
imgsList.count()
)
self.privData['IMAGES_LIST'] = imgsList.paginate(page, config.COUNT_PER_PAGE)
self.privData['PAGE_STRING'] = pageString
return self.display('imagesList')
def images_list(self):
inputs = self.get_input()
if web.ctx.method == "GET":
page = int(inputs.get('page', 1))
page_size = int(inputs.get('page_size', 20))
self.private_data['current_page'] = page
self.private_data['total_page'] = 0
image_query = Images.select().where(Images.status == 0). \
order_by(Images.id.asc())
total_count = image_query.count()
total_page = (total_count + page_size - 1) / page_size
self.private_data['total_page'] = total_page
self.private_data['images_list'] = \
image_query.paginate(page, page_size).execute()
return self.display("admin/images_list")
def search(self):
inputParams = self.getInput()
keywords = inputParams['keywords'].strip().lower() if inputParams.has_key('keywords') else ''
page = int(inputParams['page']) if inputParams.has_key('page') else 1
imgsList = Images.select().where(Images.description.contains(keywords)).order_by(Images.id.desc())
pageString = self.getPageStr(
self.makeUrl('/admin/images/list'),
page,
config.COUNT_PER_PAGE,
imgsList.count()
)
self.privData['IMAGES_LIST'] = imgsList.paginate(page, config.COUNT_PER_PAGE)
self.privData['PAGE_STRING'] = pageString
return self.display('imagesList')
def GET(self):
"""
首页
:return:
"""
inputs = self.get_input()
page = int(inputs.get('page', 1))
page_size = int(inputs.get('page_size', 20))
self.private_data['article_list'] = []
self.private_data['current_page'] = 1
self.private_data['total_page'] = 0
self.private_data['category_list'] = []
try:
album = Albums.get(Albums.is_show == 1)
images = Images.select().where(Images.status == 0,
Images.album == album.id)
images_dict_list = []
for image in images.dicts().iterator():
image_dict = {
'link': image.get("link"),
'url': config.WEB_URL + 'static/uploads/' +
image.get("uuid") + '.jpeg'
}
images_dict_list.append(image_dict)
category_list = Categories.select().where(
Categories.status == 0). \
order_by(Categories.id.desc())
article_query = Articles.select().where(Articles.status == 0). \
order_by(Articles.id.desc())
article_list = article_query.paginate(page, page_size)
total_count = article_query.count()
total_page = (total_count + page_size - 1) / page_size
self.private_data['article_list'] = article_list.execute()
self.private_data['current_page'] = page
self.private_data['total_page'] = total_page
self.private_data['images_list'] = images_dict_list
self.private_data['category_list'] = category_list.execute()
except Exception as e:
log.error('Failed to get home data. Error msg %s', e)
log.error(traceback.format_exc())
return self.display('front/index')
def list(self):
inputParams = self.getInput()
page = int(inputParams['page']) if inputParams.has_key('page') else 1
imgsList = Images.select()
albumsList = Albums().select()
current_user = Users.get(Users.name == self.isLogin())
if not self.isAdmin():
imgsList = imgsList.where(Images.owner == current_user)
albumsList = albumsList.where(Albums.owner == current_user)
pageString = self.getPageStr(
self.makeUrl('/admin/images/list'),
page,
config.COUNT_PER_PAGE,
imgsList.count()
)
self.privData['IMAGES_LIST'] = imgsList.order_by(Images.id.desc()).paginate(page, config.COUNT_PER_PAGE)
self.privData['PAGE_STRING'] = pageString
self.privData['ALBUMS_LIST'] = albumsList
return self.display('imagesList')
def donation_show(id):
pic = Images.select().where(Images.user_id==current_user.id, Images.id==int(id)).first()
#generate token here & pass to html
client_token = gateway.client_token.generate()
return render_template('/images/image_donation.html',bucket_name = os.environ.get('S3_BUCKET_NAME'),pic=pic,client_token=client_token)
def new():
# prefetch: prevent case like n+1 query
user_with_images = prefetch(User.select(), Images.select())
# breakpoint()
return render_template('images/image_galery.html', bucket_name = os.environ.get('S3_BUCKET_NAME'),user_with_images=user_with_images)
