def common_list(DynamicModel, view):
# 接收参数
action = request.args.get('action')
id = request.args.get('id')
page = int(request.args.get('page')) if request.args.get('page') else 1
length = int(request.args.get('length')) if request.args.get(
'length') else cfg.ITEMS_PER_PAGE
# 删除操作
if action == 'del' and id:
try:
DynamicModel.get(DynamicModel.id == id).delete_instance()
flash('删除成功')
except:
flash('删除失败')
# 查询列表
query = DynamicModel.select()
total_count = query.count()
# 处理分页
if page:
query = query.paginate(page, length)
dict = {'content': utils.query_to_list(query), 'total_count': total_count,
'total_page': math.ceil(total_count / length), 'page': page, 'length': length}
return render_template(view, form=dict, current_user=current_user)
def common_list(DynamicModel, view):
# 接收参数
action = request.args.get('action')
id = request.args.get('id')
page = int(request.args.get('page')) if request.args.get('page') else 1
length = int(request.args.get('length')) if request.args.get(
'length') else cfg.ITEMS_PER_PAGE
# Delete Operation
if action == 'del' and id:
try:
DynamicModel.get(DynamicModel.id == id).delete_instance()
flash('Successfully Deleted', 'success')
except:
flash('Failed to Delete', 'danger')
# Query List
query = DynamicModel.select()
total_count = query.count()
# Processing Pagination
if page: query = query.paginate(page, length)
dict = {
'content': utils.query_to_list(query),
'total_count': total_count,
'total_page': math.ceil(total_count / length),
'page': page,
'length': length
}
return render_template(view, form=dict, current_user=current_user)
def common_list(DynamicModel, view):
# 接收参数
action = request.args.get('action')
id = request.args.get('id')
page = int(request.args.get('page')) if request.args.get('page') else 1
length = int(request.args.get('length')) if request.args.get('length') else cfg.ITEMS_PER_PAGE
# 删除操作
if action == 'del' and id:
try:
DynamicModel.get(DynamicModel.id == id).delete_instance()
flash('删除成功')
except:
flash('删除失败')
# 查询列表
query = DynamicModel.select()
total_count = query.count()
# 处理分页
if page: query = query.paginate(page, length)
dict = {'content': utils.query_to_list(query), 'total_count': total_count,
'total_page': math.ceil(total_count / length), 'page': page, 'length': length}
return render_template(view, form=dict, current_user=current_user)
def filelist():
if request.args.get('meetingID') is None or request.args.get(
'fileName') is None:
return common_list(Pastefile, 'filelist.html')
id = request.args.get('id', '')
page = int(request.args.get('page')) if request.args.get('page') else 1
length = int(request.args.get('length')) if request.args.get(
'length') else cfg.ITEMS_PER_PAGE
meetingID = request.args.get('meetingID')
fileName = request.args.get('fileName')
query = Pastefile.select()
if meetingID.strip() != '':
query = Pastefile.select().where(Pastefile.meetingID == meetingID)
if fileName.strip() != '':
query = Pastefile.select().where(Pastefile.fileName == fileName)
# 查询列表
total_count = query.count()
# 处理分页
if page: query = query.paginate(page, length)
dict = {
'content': utils.query_to_list(query),
'total_count': total_count,
'total_page': math.ceil(total_count / length),
'page': page,
'length': length
}
return render_template('filelist.html',
form=dict,
current_user=current_user)
def index_plot(DynamicModel, view):
query = DynamicModel.select()
query_df = pd.DataFrame(list(query.dicts()))
Expenses = query_df[query_df["account_type"] == "Z"].round(3)
month_time = Expenses.groupby("account_month").sum().index
month_time = [i.strftime('%y-%m') for i in month_time]
Expenses['account_date'] = pd.to_datetime(Expenses['account_date'])
nowtime = datetime.now().strftime("%Y-%m")
try:
ruble = round(change_rate("BYN", "CNY"), 2)
USDs = round(change_rate("USD", "CNY"), 2)
except:
ruble = 2.50
USDs = 6.55
dict = {
'content':
utils.query_to_list(query),
"account_name":
list(month_time),
"account_money":
Expenses.groupby("account_month").sum()["account_money"].round(
3).to_list(),
"days_statistic":
Expenses.groupby("account_date").sum()["account_money"][-1].round(3),
"months_statistic":
Expenses.groupby("account_month").sum()["account_money"][-1].round(3),
"Ruble":
ruble,
"USDs":
USDs,
"hist_count":
Expenses.set_index('account_date').sort_index()[nowtime:].groupby(
"account_name").sum()["account_money"].round(3).to_list(),
"hist_name":
Expenses.set_index('account_date').sort_index()[nowtime:].groupby(
"account_name").sum().index
}
return render_template(view, form=dict, current_user=current_user)