def admin_category(self):
"""
显示管理板块页面
"""
from uliweb.utils.generic import ListView
category = get_model('forumcategory')
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(request.values.get('rows', 10))
def action(value, obj):
return '<a href="%s">%s</a> <a href="%s" onclick="return confirm(\'确定要删除当前板块吗？\');">%s</a>' % (
url_for(ForumView.category_edit, id=obj.id), '编辑',
url_for(ForumView.category_delete, id=obj.id), '删除')
view = ListView(category,
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map={'action': action})
if 'data' in request.values:
return json(view.json())
else:
result = view.run(head=True, body=False)
result.update({'table': view})
return result
def admin_forum_query(self):
"""
显示管理论坛页面
"""
from uliweb.utils.generic import ListView
cat = request.GET.get('category_id', 0)
condition = self.model.c.category == int(cat)
def ordering(value, obj):
return obj.ordering
def topictype(value, obj):
return dict([(x.id, unicode(x))
for x in obj.forum_topictypes.all()])
view = ListView(self.model,
pagination=False,
condition=condition,
fields_convert_map={
'managers': convert_managers,
'ordering': ordering,
'topictype': topictype
})
return json(view.json())
def _get_users_list_view(self, c):
from uliweb.utils.generic import ListView
from uliweb.orm import get_model
from uliweb import request
from uliweb.core.html import Tag
from uliweb import orm
def username(value, obj):
return str(Tag('a', value, href='/users/view/%d' % obj.id))
def boolean_convert(b, obj):
if b:
return '<div class="ui-icon ui-icon-check"></div>'
else:
return '<div class="ui-icon ui-icon-closethick"></div>'
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(request.values.get('rows', settings.get_var('PARA/ROWS_PER_PAGE', 10)))
User = get_model('user')
query = None
condition = None
if c.get('username'):
condition = (User.c.username.like('%'+c['username']+'%')) & condition
fields_convert_map = {'username':username}
view = ListView(User, condition=condition, query=query,
rows_per_page=rows_per_page, pageno=pageno,
fields_convert_map=fields_convert_map, id='users_table')
view.types_convert_map = {orm.BooleanProperty:boolean_convert}
return view
def tasks(self):
from uliweb.utils.generic import ListView, get_sort_field
workflow_id = int(request.GET.get("workflow", -1))
cond = None
if workflow_id > 0:
cond = (self.wftask_model.c.workflow == workflow_id)
fields = [ 'id',
{'name': 'spec_name', 'width':200}, 'desc',
'state',
{'name': 'workflow', 'width':200},
'alias_name', 'created_user', 'created_date', 'modified_user', 'modified_date']
def workflow(value, obj):
from uliweb.core.html import Tag
display = obj.workflow.spec_name + ("%04d"%obj.workflow.id)
tag = Tag('a', display, href='/redbreast/workflow/%d' % obj.workflow.id)
return str(tag) + (" <a class='btn btn-small btn-primary' href='/redbreast/tasks?workflow=%d'>Filter</a>" % obj.workflow.id)
fields_convert_map = {'workflow':workflow, 'id': task_id}
view = ListView(self.wftask_model, condition=cond,
fields_convert_map=fields_convert_map, fields=fields)
if 'data' in request.values:
return json(view.json())
else:
result = view.run(head=True, body=False)
result.update({'table':view})
return result
def list(self):
from uliweb.utils.generic import ListView
def title(value, obj):
return obj.get_url()
view = ListView(self.model,
condition=(self.model.c.deleted == False),
fields_convert_map={'title': title},
pagination=False)
return view.run()
def admin_categories(self):
"""
返回版块信息
"""
from uliweb.utils.generic import ListView
def ordering(value, obj):
return obj.ordering
view = ListView('forumcategory',
pagination=False,
fields_convert_map={'ordering': ordering})
return json(view.json())
def list(self):
from uliweb.utils.generic import ListView
pageno = request.GET.get('page', 0)
view = ListView(self.model,
pageno=pageno,
order_by=self.model.c.publish_date.desc())
return {
'blogs': view.query(),
'view': view,
'count': view.query().count()
}
def index(self):
"""
教程显示首页
"""
from uliweb.utils.generic import ListView
condition = (self.model.c.deleted == False)
pageno = int(request.GET.get('page', 1)) - 1
rows_per_page = int(request.GET.get('rows', 10))
cateobjects = self.model_cate.all()
# def render(r, obj):
# from uliweb import Storage
#
# data = Storage(dict(r))
# data['image'] = obj.get_image()
# data['author'] = unicode(obj.modified_user)
# data['modified_date'] = self._get_date(obj.modified_date)
# return data
def image(value, obj):
return obj.get_image()
def author(value, obj):
return unicode(obj.modified_user)
def modified_date(value, obj):
return self._get_date(obj.modified_date)
fields_convert_map = {
'image': image,
'author': author,
'modified_date': modified_date
}
view = ListView(self.model,
condition=condition,
order_by=self.model.c.modified_date.desc(),
pageno=pageno,
rows_per_page=rows_per_page,
fields_convert_map=fields_convert_map)
view.query()
pagination = functions.create_pagination(request.url, view.total,
pageno + 1, rows_per_page)
return {
'pagination': pagination,
'objects': view.objects(),
'cateobjects': cateobjects
}
def _get_list_view(self):
from uliweb.utils.generic import ListView
if functions.has_role(request.user, 'superuser'):
condition = None
else:
condition = self.model.teachers.in_(request.user.id)
view = ListView(self.model, pagination=False,
condition=condition,
order_by=[self.model.c.order.desc(), self.model.c.create_date.desc()],
fields_convert_map={'link':self.convert_link}
)
return view
def get_audit_list(c):
from uliweb.utils.generic import ListView
from uliweb.orm import get_model
from uliweb import request, settings
from uliweb.utils.textconvert import text2html
from uliweb.core.js import json_dumps
pageno = int(request.GET.get('pageno', 0))
Audit = get_model('audit')
condition = None
order_by = Audit.c.modified_date.desc()
if c.get('table_id'):
condition = (Audit.c.table_id == c['table_id']) & condition
if c.get('obj_id'):
condition = (Audit.c.obj_id == c['obj_id']) & condition
if c.get('title'):
condition = (Audit.c.title.like(c['title'])) & condition
if c.get('modify_flag'):
condition = (Audit.c.modify_flag == c['modify_flag']) & condition
if c.get('modified_date'):
condition = (Audit.c.modified_date == c['modified_date']) & condition
if c.get('modified_user'):
condition = (Audit.c.modified_user == c['modified_user']) & condition
def changed_value(value, obj):
if value:
import pickle
return text2html(json_dumps(pickle.loads(value)))
else:
return ''
def old_value(value, obj):
if value:
import pickle
return text2html(json_dumps(pickle.loads(value)))
else:
return ''
fields = ({'name':'table_id', 'width':100}, 'obj_id', {'name':'title', 'width':200}, 'modify_flag', 'changed_value', 'old_value',
'modified_date', 'modified_user')
fields_convert_map = {'changed_value':changed_value, 'old_value':old_value}
view = ListView(Audit, condition=condition, order_by=order_by, fields=fields,
rows_per_page=settings.get_var('PARA/ROWS_PER_PAGE', 10), pageno=pageno,
fields_convert_map=fields_convert_map, id='audit_table', pagination=False,
table_width=False)
return view
def list(self):
from uliweb.utils.generic import ListView
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('PARA/ROWS_PER_PAGE', 10)))
def name(value, obj):
return '<a href="%s">%s</a>' % (url_for(RoleView.view,
id=obj.id), value)
fields = [
{
'name': 'name',
'verbose_name': _('Name'),
'width': 150
},
{
'name': 'description',
'verbose_name': _('Description'),
'width': 200
},
{
'name': 'reserve',
'verbose_name': _('Is Reserved'),
'width': 80
},
]
fields_convert_map = {'name': name}
view = ListView(self.model,
rows_per_page=rows_per_page,
pageno=pageno,
fields=fields,
fields_convert_map=fields_convert_map)
if 'data' in request.values:
return json(view.json())
else:
result = view.run(head=True, body=False)
result.update({'table': view})
return result
def workflows(self):
from uliweb.utils.generic import ListView, get_sort_field
fields = ['id',
{'name':'spec_name','width':200}, 'desc', 'state',
'created_user', 'created_date',
'modified_user', 'modified_date']
def id(value, obj):
from uliweb.core.html import Tag
return str(Tag('a', ("%04d"%obj.id), href='/redbreast/workflow/%d' % obj.id))
fields_convert_map = {'id': id}
view = ListView(self.wf_model,
fields_convert_map=fields_convert_map, fields=fields)
if 'data' in request.values:
return json(view.json())
else:
result = view.run(head=True, body=False)
result.update({'table':view})
return result
def workflow(self, id):
from uliweb.utils.generic import DetailView, ListView
obj = self.wf_model.get(int(id))
def get_wf_detail():
fields1 = ['id', 'spec_name',
'desc', 'state', 'created_user', 'created_date',
'modified_user', 'modified_date']
layout1 = [
'-- 基本信息 --',
('id', 'state', 'spec_name'),
('desc'),
('created_user', 'created_date'),
('modified_user', 'modified_date'),
]
view1 = DetailView(self.wf_model, obj=obj, fields=fields1, layout=layout1)
result1 = view1.run()
return result1['view']
fields2 = [ 'id',
{'name': 'spec_name', 'width':200}, 'desc',
'state',
'alias_name', 'created_user', 'created_date', 'modified_user', 'modified_date']
cond = self.wftask_model.c.workflow == obj.id
fields_convert_map = {'id': task_id}
view2 = ListView(self.wftask_model, condition=cond,
fields_convert_map=fields_convert_map, fields=fields2)
if 'data' in request.values:
return json(view2.json())
else:
result2 = view2.run(head=True, body=False)
result2.update({'table':view2, 'detailview': get_wf_detail(), 'workflow': obj})
return result2
def topic_view(self, forum_id, topic_id):
"""
显示某主题页面
"""
from uliweb.utils.generic import ListView
import uuid
from uliweb import settings
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('PARA/FORUM_PAGE_NUMS')))
Post = get_model('forumpost')
Topic = get_model('forumtopic')
Forum = get_model('forum')
forum = Forum.get(int(forum_id))
condition = Post.c.topic == int(topic_id)
order_by = [Post.c.floor]
def created_on(value, obj):
return date.to_local(value).strftime('%Y-%m-%d %H:%M:%S %Z')
def content(value, obj):
if obj.deleted:
return u'<div class="deleted">内容已经被 %s 于时间 %s 删除 </div>' % (
obj.deleted_by.username, obj.field_str(obj.deleted_on))
else:
return value
def username(value, obj):
return obj.posted_by.username
def userimage(value, obj):
get_user_image = function('get_user_image')
url = get_user_image(obj.posted_by)
return url
def actions(value, obj):
if not request.user:
return ''
a = []
is_manager = forum.managers.has(request.user)
if obj.floor == 1:
#第一楼为主贴，可以允许关闭，顶置等操作
if is_manager:
a.append('<a href="#" rel="%d" class="close">%s</a>' %
(obj.id, self.status['close'][obj.topic.closed]))
a.append('<a href="#" rel="%d" class="hidden">%s</a>' %
(obj.id, self.status['hidden'][obj.topic.hidden]))
a.append('<a href="#" rel="%d" class="top">%s</a>' %
(obj.id, self.status['sticky'][obj.topic.sticky]))
a.append(
'<a href="#" rel="%d" class="essence">%s</a>' %
(obj.id, self.status['essence'][obj.topic.essence]))
a.append(
'<a href="#" rel="%d" class="homepage">%s</a>' %
(obj.id, self.status['homepage'][obj.topic.homepage]))
if is_manager or (
obj.posted_by.id == request.user.id
and obj.created_on + timedelta(days=settings.get_var(
'PARA/FORUM_EDIT_DELAY')) >= date.now()):
#作者或管理员且在n天之内，则可以编辑
url = url_for(ForumView.edit_topic,
forum_id=forum_id,
topic_id=topic_id)
a.append('<a href="%s" rel="%d" class="edit">编辑</a>' %
(url, obj.id))
if is_manager:
url = url_for(ForumView.remove_topic,
forum_id=forum_id,
topic_id=topic_id)
a.append(
'<a href="%s" rel="%d" class="delete_topic">删除主题</a>' %
(url, obj.id))
if is_manager or (obj.posted_by.id == request.user.id):
if (obj.deleted and (obj.deleted_by.id == request.user.id
or is_manager)) or not obj.deleted:
a.append('<a href="#" rel="%d" class="delete">%s</a>' %
(obj.id, self.status['delete'][obj.deleted]))
if obj.posted_by.id == request.user.id:
a.append('<a href="#" rel="%d" class="email">%s</a>' %
(obj.id, self.status['email'][obj.reply_email]))
return ' | '.join(a)
def updated(value, obj):
if obj.floor == 1 and obj.topic.updated_on:
return u'<div class="updated">由 %s 于 %s 更新</div>' % (
obj.topic.modified_user.username,
timesince(obj.topic.updated_on))
fields = [
'topic',
'id',
'username',
'userimage',
'posted_by',
'content',
'created_on',
'actions',
'floor',
'updated',
]
fields_convert_map = {
'created_on': created_on,
'content': content,
'username': username,
'userimage': userimage,
'actions': actions,
'updated': updated
}
view = ListView(Post,
fields=fields,
condition=condition,
order_by=order_by,
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map=fields_convert_map)
if 'data' in request.values:
return json(view.json())
else:
# key = '__topicvisited__:forumtopic:%d:%s:%s' % (request.user.id, forum_id, topic_id)
key = '__topicvisited__:forumtopic:%s:%s:%s' % (
request.remote_addr, forum_id, topic_id)
cache = function('get_cache')()
v = cache.get(key, None)
if not v:
Topic.filter(Topic.c.id == int(topic_id)).update(
num_views=Topic.c.num_views + 1)
cache.set(key, 1,
settings.get_var('PARA/FORUM_USER_VISITED_TIMEOUT'))
slug = uuid.uuid1().hex
topic = Topic.get(int(topic_id))
return {
'forum': forum,
'topic': topic,
'slug': slug,
'has_email': bool(request.user and request.user.email)
}
def list(self):
from uliweb import request
from uliweb.utils.generic import ListView
from uliweb.utils.common import get_choice
import math
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('MESSAGES/PAGE_NUMS', 10)))
read_flag = request.GET.get('read', '')
type_flag = request.GET.get('type', '')
condition = None
condition = (self.model.c.user == request.user.id) & condition
condition = (self.model.c.send_flag == 'r') & condition
if read_flag:
condition = (self.model.c.read_flag
== bool(read_flag == '1')) & condition
if type_flag:
condition = (self.model.c.type == type_flag) & condition
def create_date(value, obj):
from uliweb.utils.timesince import timesince
return timesince(value)
def user_image(value, obj):
return functions.get_user_image(obj.sender, size=20)
def message(value, obj):
return value
fields_convert_map = {
'create_date': create_date,
'user_image': user_image,
'message': message
}
view = ListView(self.model,
condition=condition,
order_by=[self.model.c.create_date.desc()],
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map=fields_convert_map)
view.query()
result = {}
result['read_flag'] = read_flag
result['type_flag'] = type_flag
result['message_type_name'] = get_choice(
settings.get_var('MESSAGES/MESSAGE_TYPE'), type_flag, '全部类型')
pages = int(math.ceil(1.0 * view.total / rows_per_page))
# result['page'] = pageno+1
# result['total'] = view.total
# result['pages'] = pages
result['pagination'] = functions.create_pagination(
request.url, view.total, pageno + 1, rows_per_page)
result['objects'] = list(view.objects())
ids = []
for row in result['objects']:
ids.append(row._obj_.id)
self.model.filter(self.model.c.id.in_(ids)).update(read_flag=True)
_del_key(request.user.id)
return result
def query(self):
from uliweb.utils.generic import ListView
view = ListView(self.model, pagination=False)
return json(view.json())
def index(self):
from uliweb.utils.generic import ListView
view = ListView(self.model)
fields_list = view.table_info['fields_list']
return {'fields': fields_list}
def forum_index(self, id):
"""
显示某论坛页面
"""
from uliweb.utils.generic import ListView
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('PARA/FORUM_INDEX_NUMS')))
Topic = get_model('forumtopic')
Forum = get_model('forum')
forum = Forum.get(int(id))
condition = Topic.c.forum == int(id)
order_by = [Topic.c.sticky.desc(), Topic.c.created_on.desc()]
if not forum.managers.has(request.user):
condition = (Topic.c.hidden == False) & condition
filter = request.GET.get('filter', 'all')
if filter == 'essence':
condition = (Topic.c.essence == True) & condition
def created_on(value, obj):
return value.strftime('%Y-%m-%d')
def last_reply_on(value, obj):
return timesince(value)
def subject(value, obj):
if obj.topic_type:
_type = u'[%s]' % obj.get_display_value('topic_type')
else:
_type = ''
s = ''
if obj.sticky:
s += u'<font color="red">[顶]</font>'
if obj.hidden:
s += u'<font color="red">[隐]</font>'
if obj.closed:
s += u'<font color="red">[关]</font>'
if obj.essence:
s += u'<font color="red">[精]</font>'
if obj.homepage:
s += u'<font color="red">[首]</font>'
return _type + '<a href="/forum/%d/%d">%s</a>' % (int(id), obj.id,
obj.subject) + s
fields_convert_map = {
'created_on': created_on,
'subject': subject,
'last_reply_on': last_reply_on
}
view = ListView(Topic,
condition=condition,
order_by=order_by,
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map=fields_convert_map)
if 'data' in request.values:
return json(view.json())
else:
return {'forum': forum, 'filter': filter}
def topic_view(self, forum_id, topic_id):
"""
显示某主题页面
"""
from uliweb.utils.generic import ListView
from uliweb import settings
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('PARA/FORUM_PAGE_NUMS')))
Post = get_model('forumpost')
Topic = get_model('forumtopic')
Forum = get_model('forum')
forum = Forum.get(int(forum_id))
condition = Post.c.topic == int(topic_id)
condition1 = (Post.c.parent == None) & condition
condition2 = (Post.c.parent != None) & condition
order_by = [Post.c.floor]
def created_on(value, obj):
return date.to_local(value).strftime('%Y-%m-%d %H:%M:%S %Z')
def content(value, obj):
if obj.deleted:
return u'<div class="deleted">内容已经被 %s 于时间 %s 删除 </div>' % (
obj.deleted_by.username, obj.field_str(obj.deleted_on))
else:
return value
def username(value, obj):
return obj.posted_by.username
def userimage(value, obj):
get_user_image = function('get_user_image')
url = get_user_image(obj.posted_by)
return url
def actions(value, obj):
if not request.user:
return ''
a = []
is_manager = forum.managers.has(request.user)
if obj.floor == 1 and obj.parent == None:
#第一楼为主贴，可以允许关闭，顶置等操作
if is_manager:
a.append('<a href="#" rel="%d" class="close">%s</a>' %
(obj.id, self.status['close'][obj.topic.closed]))
a.append('<a href="#" rel="%d" class="hidden">%s</a>' %
(obj.id, self.status['hidden'][obj.topic.hidden]))
a.append('<a href="#" rel="%d" class="top">%s</a>' %
(obj.id, self.status['sticky'][obj.topic.sticky]))
a.append(
'<a href="#" rel="%d" class="essence">%s</a>' %
(obj.id, self.status['essence'][obj.topic.essence]))
a.append(
'<a href="#" rel="%d" class="homepage">%s</a>' %
(obj.id, self.status['homepage'][obj.topic.homepage]))
if is_manager or (
obj.posted_by.id == request.user.id
and obj.created_on + timedelta(days=settings.get_var(
'PARA/FORUM_EDIT_DELAY')) >= date.now()):
#作者或管理员且在n天之内，则可以编辑
url = url_for(ForumView.edit_topic,
forum_id=forum_id,
topic_id=topic_id)
a.append('<a href="%s" rel="%d" class="edit">编辑</a>' %
(url, obj.id))
if is_manager:
url = url_for(ForumView.remove_topic,
forum_id=forum_id,
topic_id=topic_id)
a.append(
'<a href="%s" rel="%d" class="delete_topic">删除主题</a>' %
(url, obj.id))
if is_manager or (obj.posted_by.id == request.user.id):
if (obj.deleted and (obj.deleted_by.id == request.user.id
or is_manager)) or not obj.deleted:
a.append('<a href="#" rel="%d" class="delete">%s</a>' %
(obj.id, self.status['delete'][obj.deleted]))
if obj.posted_by.id == request.user.id:
a.append('<a href="#" rel="%d" class="email">%s</a>' %
(obj.id, self.status['email'][obj.reply_email]))
a.append('<a href="/forum/%d/%d/%d/new_reply">回复该作者</a>' %
(forum_id, topic_id, obj.id))
return ' | '.join(a)
def updated(value, obj):
if obj.floor == 1 and obj.topic.updated_on and not obj.parent:
return u'<div class="updated">由 %s 于 %s 更新</div>' % (
obj.topic.modified_user.username,
timesince(obj.topic.updated_on))
fields = [
'topic',
'id',
'username',
'userimage',
'posted_by',
'content',
'created_on',
'actions',
'floor',
'updated',
'parent',
]
fields_convert_map = {
'created_on': created_on,
'content': content,
'username': username,
'userimage': userimage,
'actions': actions,
'updated': updated
}
#view1 为生成一级回复，即回复主题
view1 = ListView(Post,
fields=fields,
condition=condition1,
order_by=order_by,
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map=fields_convert_map)
#view2 为生成二级乃至多级回复
view2 = ListView(Post,
fields=fields,
condition=condition2,
order_by=order_by,
pagination=False,
fields_convert_map=fields_convert_map)
key = '__topicvisited__:forumtopic:%s:%s:%s' % (request.remote_addr,
forum_id, topic_id)
cache = function('get_cache')()
v = cache.get(key, None)
if not v:
Topic.filter(Topic.c.id == int(topic_id)).update(
num_views=Topic.c.num_views + 1)
cache.set(key, 1,
settings.get_var('PARA/FORUM_USER_VISITED_TIMEOUT'))
slug = uuid.uuid1().hex
topic = Topic.get(int(topic_id))
#处理posts和sub_posts
query = view1.query()
posts = []
sub_posts = {}
def process_sub(ids):
_ids = []
for x in Post.filter(Post.c.parent.in_(ids)).order_by(
Post.c.floor):
obj = view2.object(x)
d = sub_posts.setdefault(str(x._parent_), [])
d.append(obj)
_ids.append(x.id)
if _ids:
process_sub(_ids)
ids = []
for row in query:
posts.append(view1.object(row))
ids.append(row.id)
process_sub(ids)
pagination = functions.create_pagination(request.url, view1.total,
pageno + 1, rows_per_page)
return {
'forum': forum,
'topic': topic,
'slug': slug,
'has_email': bool(request.user and request.user.email),
'page': pageno + 1,
'pagination': pagination,
'posts': posts,
'sub_posts': sub_posts
}
def forum_index(self, id):
"""
显示某论坛页面
"""
from uliweb.utils.generic import ListView
from sqlalchemy.sql import and_
import math
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(
request.values.get('rows',
settings.get_var('PARA/FORUM_INDEX_NUMS')))
Topic = get_model('forumtopic')
Forum = get_model('forum')
User = get_model('user')
forum = Forum.get(int(id))
condition = Topic.c.forum == int(id)
order_by = [Topic.c.sticky.desc(), Topic.c.last_reply_on.desc()]
if not forum.managers.has(request.user):
condition = (Topic.c.hidden == False) & condition
filter = request.GET.get('filter', 'all')
if filter == 'essence':
condition = (Topic.c.essence == True) & condition
elif filter == 'sticky':
condition = (Topic.c.sticky == True) & condition
term = request.GET.get('term', '')
type = request.GET.get('type', '1')
if term:
if type == '1': #查找主题
condition = (Topic.c.subject.like('%' + term +
'%')) & condition
elif type == '2': #查找用户名
condition = and_(
Topic.c.posted_by == User.c.id,
User.c.username.like('%' + term + '%')
| User.c.nickname.like('%' + term + '%'),
) & condition
def created_on(value, obj):
return value.strftime('%Y-%m-%d')
def last_reply_on(value, obj):
return timesince(value)
def subject(value, obj):
if obj.topic_type:
_type = u'[%s]' % obj.get_display_value('topic_type')
else:
_type = ''
s = ''
if obj.sticky:
s += u'<font color="red">[顶]</font>'
if obj.hidden:
s += u'<font color="red">[隐]</font>'
if obj.closed:
s += u'<font color="red">[关]</font>'
if obj.essence:
s += u'<font color="red">[精]</font>'
if obj.homepage:
s += u'<font color="red">[首]</font>'
return _type + '<a href="/forum/%d/%d">%s</a>' % (int(id), obj.id,
obj.subject) + s
fields_convert_map = {
'created_on': created_on,
'subject': subject,
'last_reply_on': last_reply_on
}
view = ListView(Topic,
condition=condition,
order_by=order_by,
rows_per_page=rows_per_page,
pageno=pageno,
fields_convert_map=fields_convert_map)
view.query() #in order to get the total count
objects = view.objects()
pages = int(math.ceil(1.0 * view.total / rows_per_page))
return {
'forum':
forum,
'objects':
objects,
'filter':
filter,
'term':
term,
'page':
pageno + 1,
'total':
view.total,
'pages':
pages,
'pagination':
functions.create_pagination(request.url, view.total, pageno + 1,
rows_per_page),
'type':
type,
'filter_name':
dict(settings.get_var('PARA/FILTERS')).get(filter)
}
def generic_list(model=None,
get_url=get_url,
layout=None,
template=None,
key_field='id',
add_button_text=None,
view=None,
data=None,
json_result=True,
pagination=True,
rows=10):
from uliweb.utils.generic import ListView
from uliweb import request, response
from uliweb.core.html import Tag
if not view:
def key(value, obj):
url = get_url('view', id=obj.id)
return str(Tag('a', value, href="%s" % url))
if not model or not get_model(model):
error("Can't find model [%s], please check it" % model)
pageno = int(request.GET.get('pageno', 0))
rows_per_page = rows
if json_result:
pageno = int(request.values.get('page', 1)) - 1
rows_per_page = int(request.values.get('rows', rows))
fields_convert_map = {key_field: key}
_id = '%s_table' % model
view = ListView(model,
rows_per_page=rows_per_page,
pageno=pageno,
id=_id,
fields_convert_map=fields_convert_map,
pagination=pagination)
else:
_id = view.id
if 'data' in request.values:
if json_result:
return json(view.json())
else:
result = view.run(head=False, body=True)
return json(result)
else:
result = view.run(head=True, body=False)
if isinstance(result, dict):
layout = layout or 'layout.html'
template = template or 'generic_list.html'
response.template = template
data = data or {}
result['layout'] = layout
result['table_id'] = _id
result['get_url'] = get_url
result['add_button_text'] = add_button_text or _('New')
if json_result:
result['table'] = view
result.update(data)
return result
