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)