def news_categories_json():
columns = []
columns.append(ColumnDT('news_category_id', filter=_default_value))
columns.append(ColumnDT('news_category_name', filter=_default_value))
columns.append(ColumnDT('count_news', filter=_default_int))
columns.append(ColumnDT('count_views', filter=_default_int))
columns.append(ColumnDT('count_votes', filter=_default_int))
columns.append(ColumnDT('count_comments', filter=_default_int))
query = db.session.query(ViewNewsCategory)
rowTable = DataTables(request, ViewNewsCategory, query, columns)
a = rowTable.output_result()
for row in a['aaData']:
row_id = row['0']
row['1'] = "<a href='" + url_for('news.list_all_by_category',
id=row_id) + "'>" + row['1'] + "</a>"
last_columns = str(len(columns))
manage_html = """
<a href="{edit_category}">
<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span>
</a>
<a href="{delete_category}">
<span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
</a>
"""
row[last_columns] = manage_html.format(
edit_category=url_for('admin.edit_news_category', cat_id=row_id),
delete_category=url_for('admin.delete_category', cat_id=row_id))
return jsonify(**a)
def news_categories_json():
columns = []
columns.append(ColumnDT('news_category_id', filter=_default_value))
columns.append(ColumnDT('news_category_name', filter=_default_value))
columns.append(ColumnDT('count_news', filter=_default_int))
columns.append(ColumnDT('count_views', filter=_default_int))
columns.append(ColumnDT('count_votes', filter=_default_int))
columns.append(ColumnDT('count_comments', filter=_default_int))
query = db.session.query(ViewNewsCategory)
rowTable = DataTables(request, ViewNewsCategory, query, columns)
a = rowTable.output_result()
for row in a['aaData']:
row_id = row['0']
row['1'] = "<a href='"+url_for('news.list_all_by_category', id=row_id)+"'>"+row['1']+"</a>"
last_columns = str(len(columns))
manage_html = """
<a href="{edit_category}">
<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span>
</a>
<a href="{delete_category}">
<span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
</a>
"""
row[last_columns] = manage_html.format(
edit_category = url_for('admin.edit_news_category', cat_id=row_id),
delete_category = url_for('admin.delete_category', cat_id=row_id))
return jsonify(**a)
def s_news_json():
columns = list()
columns.append(ColumnDT('news_id', filter=_default_value))
columns.append(ColumnDT('news_title', filter=_default_value)) # 1
columns.append(ColumnDT('user_full_name', filter=_default_value)) # 2
columns.append(ColumnDT('news_category_name', filter=_default_value)) # 3
#
columns.append(ColumnDT('users_id', filter=_default_value)) # 4
columns.append(ColumnDT('news_category_id', filter=_default_value)) # 5
query = db.session.query(ViewNews)
rowTable = DataTables(request, ViewNews, query, columns)
a = rowTable.output_result()
for i in a['aaData']:
row_id = i['0']
i['1'] = "<a href='" + url_for('news.news_one',
id=int(row_id)) + "'>" + i['1'] + "</a>"
i['2'] = "<a href='" + url_for('user.profile', user_id=int(
i['4'])) + "'>" + i['2'] + "</a>"
if i['5'] == 'None':
i['3'] = "-"
else:
i['3'] = "<a href='" + url_for('news.list_all_by_category',
id=i['5']) + "'>" + i['3'] + "</a>"
last_columns = str(4)
last_columns = str(len(columns))
manage_html = """Edit Delete"""
i[last_columns] = manage_html.format()
return jsonify(**a)
def s_news_json():
columns = list()
columns.append(ColumnDT('news_id', filter=_default_value))
columns.append(ColumnDT('news_title', filter=_default_value))# 1
columns.append(ColumnDT('user_full_name', filter=_default_value))# 2
columns.append(ColumnDT('news_category_name', filter=_default_value))# 3
#
columns.append(ColumnDT('users_id', filter=_default_value))# 4
columns.append(ColumnDT('news_category_id', filter=_default_value))# 5
query = db.session.query(ViewNews)
rowTable = DataTables(request, ViewNews, query, columns)
a = rowTable.output_result()
for i in a['aaData']:
row_id = i['0']
i['1'] = "<a href='"+url_for('news.news_one', id=int(row_id))+"'>"+i['1']+"</a>"
i['2'] = "<a href='"+url_for('user.profile', user_id=int(i['4']))+"'>"+i['2']+"</a>"
if i['5'] == 'None':
i['3'] = "-"
else:
i['3'] = "<a href='"+url_for('news.list_all_by_category', id=i['5'])+"'>"+i['3']+"</a>"
last_columns = str(4)
last_columns = str(len(columns))
manage_html = """Edit Delete"""
i[last_columns] = manage_html.format()
return jsonify(**a)
def dep_users_json(dep_id):
columns = []
columns.append(ColumnDT('id', filter=_default_value))
columns.append(ColumnDT('full_name', filter=_default_value))
columns.append(ColumnDT('email', filter=_default_value))
columns.append(ColumnDT('login', filter=_default_value))
columns.append(ColumnDT('mobile_phone', filter=_default_value))
columns.append(ColumnDT('inner_phone', filter=_default_value))
query = db.session.query(User).filter_by(department_id=dep_id)
rowTable = DataTables(request, User, query, columns)
json_result = rowTable.output_result()
departments = Department.get_all()
for row in json_result['aaData']:
row_id = row['0']
last_columns = str(len(columns))
dep_html = ''
for dep in departments:
sel = 'selected' if dep.id == dep_id else ''
dep_html += "<option value='"+str(dep.id)+"/"+row_id+"' "+sel+">"+dep.name+"</option>"
manage_html = """
<select onchange="change_user_dep(this.value)" id="first-disabled" class="selectpicker" data-hide-disabled="true" data-live-search="true" data-width="200px">
<optgroup label="Доп возможности">
<option value="0/"""+row_id+"""">Удалить из отдела</option>
</optgroup>
<optgroup label="Отделы">"""+dep_html+"""</optgroup>
</select>
<script type="text/javascript">$('.selectpicker').selectpicker({style: 'btn-default',size: 5});</script>
"""
row[last_columns] = manage_html
src_foto = ''
user = User.get_by_id(row_id)
if user.photo:
src_foto = user.photo.get_url('thumbnail')
else:
src_foto = '/static/img/no_photo.jpg'
row['1'] = """<img src="{src}" class="foto-small-struct">""".format(src = src_foto) + "<a href='"+url_for('user.profile')+"/"+row_id+"'>"+row['1']+"</a>"
head_dep = str(len(columns)+1)
if Department.is_user_head(dep_id, int(row_id)):
checked = "checked"
else:
checked = ''
row[head_dep] = "<input onclick='change_head_dep(this, "+str(dep_id)+", "+row_id+")' type='checkbox' id='head_check' "+checked+">"
return jsonify(**json_result)
def users_search_json():
columns = list()
columns.append(ColumnDT('users_id', filter=_default_value_view))
columns.append(ColumnDT('users_full_name', filter=_default_value_view))
columns.append(ColumnDT('users_login', filter=_empty))
columns.append(ColumnDT('users_email', filter=_empty))
columns.append(ColumnDT('users_status', filter=_empty))
columns.append(ColumnDT('users_mobile_phone', filter=_empty))
columns.append(ColumnDT('users_inner_phone', filter=_empty))
columns.append(ColumnDT('users_birth_date', filter=_empty))
columns.append(ColumnDT('users_skype', filter=_empty))
columns.append(ColumnDT('users_position', filter=_empty))
columns.append(ColumnDT('department_name', filter=_default_value_view))
columns.append(ColumnDT('photo_url', filter=_default_value_view))
return jsonify(**DataTables(request, ViewUsers4Search,
db.session.query(ViewUsers4Search),
columns).output_result())
def s_users_json():
columns = list()
columns.append(ColumnDT('id', filter=_default_value))
columns.append(ColumnDT('full_name', filter=_default_value))
columns.append(ColumnDT('email', filter=_default_value))
columns.append(ColumnDT('login', filter=_default_value))
columns.append(ColumnDT('mobile_phone', filter=_default_value))
columns.append(ColumnDT('inner_phone', filter=_default_value))
columns.append(ColumnDT('status', filter=_status))
query = db.session.query(User)
rowTable = DataTables(request, User, query, columns)
json_result = rowTable.output_result()
current_user = auth.service.get_user()
disabled = ''
if not current_user.is_admin and ('set_permissions' not in current_user.get_permissions()):
disabled = 'disabled'
for row in json_result['aaData']:
row_id = row['0']
row['1'] = "<a href='"+url_for('user.profile')+"/"+row_id+"'>"+row['1']+"</a>"
last_col = len(columns) - 1
# Permission
last_col += 1
per_columns = str(last_col)
per_options = ""
permissions = Permission.get_all()
set_per = User.get_user_permissions_id(row_id)
for per in permissions:
sel = ''
sel = 'selected' if per.id in set_per else ''
per_options += "<option value='"+str(per.id)+"' "+sel+">"+per.title+"</option>"
per_html = """
<select onchange="change_user_per("""+row_id+""", this)" class="selectpicker" multiple data-selected-text-format="count>1" data-width="170px" """+disabled+""">
"""+per_options+"""
</select>
<script type="text/javascript">$('.selectpicker').selectpicker({style: 'btn-default',size: 5});</script>
"""
row[per_columns] = per_html
# Roles
last_col += 1
roles_columns = str(last_col)
roles = Role.get_all()
role_options = ''
sel_role = User.get_user_role_id(row_id)
for role in roles:
sel = ''
sel = 'selected' if role.id == sel_role else ''
role_options += "<option value='"+str(role.id)+"/"+row_id+"' "+sel+">"+role.name+"</option>"
sel = ''
sel = 'selected' if 0 == sel_role else ''
role_options += "<option value='0/"+row_id+"' "+sel+">admin</option>"
role_html = """
<select onchange="change_user_role(this.value)" class="selectpicker" data-width="110px" """+disabled+""">
"""+role_options+"""
</select>
<script type="text/javascript">$('.selectpicker').selectpicker({style: 'btn-default',size: 5});</script>
"""
row[roles_columns] = role_html
# Manage
last_col += 1
last_columns = str(last_col)
manage_html = """
<a href="javascript: user.activate({0})">
<span class="glyphicon glyphicon-ok" aria-hidden="true"></span>
</a>
<a href="{1}">
<span class="glyphicon glyphicon-pencil" aria-hidden="true"></span>
</a>
<a href="javascript: user.delete({0})">
<span class="glyphicon glyphicon-remove" aria-hidden="true"></span>
</a>
""".format(
row_id,
url_for('admin.edit_user', id=row_id)
)
row[last_columns] = manage_html
return jsonify(**json_result)
