def approval_new(): """添加审批单 使用 WTForm 来创建表单并验证和获取表单内容 """ print('nimei') form = ApprovalForm() list_subject = [(1, u'公务卡消费'), (2, u'非公务卡消费')] form.cost_type.choices = list_subject form.subject.choices = Subject.get_subjects() print 'nimeimei' if request.method == 'POST' and form.validate(): approval = Approval() approval.agent_id = Person.judge(form.agent.data) approval.payee_id = Person.judge(form.payee.data) approval.subject_list = dict(Subject.get_subjects())[form.subject] db.session.add(approval) approval.save() form_list = [form.cost_type, approval.agent_id, form.max_money, approval.id, form.subject] invoices = Invoice.find_relation(form_list) if invoices[1] == None: approval_index = Approval.query.get(approval.id) approval_index.invoice_count = invoices[0] approval_index.subject_list += (' '+dict(Subject.get_subjects())[form.subject]) approval_index.status = 'Printed' approval.save() flash(u'组合成功') return redirect('/approval/%d' % int(approval.id)) return redirect('/approval/%d/chioce' % int(approval.id), incoices) # if request.method == 'POST' and form.validate(): # approval = Approval() # approval.agent_id = Person.judge(form.agent.data) # approval.payee_id = Person.judge(form.payee.data) # form.populate_obj(approval) # if request.files[form.picture.name]: # try: # pic = Picture(request.files[form.picture.name]) # db.session.add(pic) # pic.save() # approval.picture_id = pic.id # except: # flash(u'图片保存失败', 'error') # db.session.add(approval) # approval.save() # print 'nimei',approval.id # flash(u'成功添加审批单') # return redirect('/approval/%d' % int(approval.id)) return render_template('/approval/edit.html', form = form, title=u'添加审批单')
def importbill_save(bills_list, bill_id): """HTML账单导入之后经过解析,将所得数据(bills_list)保存到对应的数据库中,此方法被(bill)bill_new视图方法调用 """ cur_list = {'USD':10, 'EUR':11, 'GBP':12, 'CNY':1, 'HK':14, 'MOP':15} person_id = Person.judge(bills_list[0][2][0][3]) bills_list = bills_list[1][1:-1] try: for account in bills_list: acc = Account() acc.funder_id = person_id acc.bill_id = bill_id acc.is_submit = True acc.enter_date = account[0][0] acc.card_no = account[2][0] acc.trade_abstract = account[3][0] acc.transaction_place = account[4][0] money_transaction = str(account[5][0]).split('/') money_enter = str(account[6][0]).split('/') print money_transaction[1] acc.transaction_money = float(money_transaction[0]) acc.currency = money_transaction[1] acc.enter_money = float(money_enter[0]) acc.china_yuan = acc.transaction_money*float(str(cur_list[money_transaction[1]])) db.session.add(acc) acc.save() except: return flash(u'保存账单条目失败', 'error') return flash(u'保存账单条目成功')
def account_new(): """添加账单条目 """ form = AccountForm(request.form) if request.method == 'POST' and form.validate(): account = Account() form.populate_obj(account) account.funder_id = Person.judge(form.funder.data) account.china_yuan = form.transaction_money.data*account.get_forex(form.currency.data) db.session.add(account) account.save() print 'ni' flash(u'成功添加账单条目') return redirect('/account/%d' % int(account.id)) return render_template('/account/edit.html', form=form, title=u'添加账单条目')
def account_edit(id): """编辑账单条目 和添加类似,参加 Person 的实现 """ account = Account.query.get(id) form = AccountForm(request.form, obj=account) if account.funder_id: form.funder.data = account.funders.name if request.method == 'POST' and form.validate(): form.populate_obj(account) account.funder_id = Person.judge(form.funder.data) account.china_yuan = form.enter_money.data*account.get_forex(form.currency.data) account.save() flash(u'成功更新账单条目信息') return redirect('/account/%d' % id) return render_template('/account/edit.html', form=form, title=u'编辑账单条目')
""" <<<<<<< HEAD print('nimei') form = ApprovalForm() list_subject = [(1, u'公务卡消费'), (2, u'非公务卡消费')] form.cost_type.choices = list_subject form.subject.choices = Subject.get_subjects() print 'nimeimei' ======= form = ApprovalForm(request.form) form.status.choices = Approval.get_status() form.approval_type.choices = Approval.get_approval_type() >>>>>>> 797deb1d9a238a9098207cfc01bab6963414987f if request.method == 'POST' and form.validate(): approval = Approval() approval.agent_id = Person.judge(form.agent.data) approval.payee_id = Person.judge(form.payee.data) <<<<<<< HEAD approval.subject_list = dict(Subject.get_subjects())[form.subject] db.session.add(approval) approval.save() form_list = [form.cost_type, approval.agent_id, form.max_money, approval.id, form.subject] invoices = Invoice.find_relation(form_list) if invoices[1] == None: approval_index = Approval.query.get(approval.id) approval_index.invoice_count = invoices[0] approval_index.subject_list += (' '+dict(Subject.get_subjects())[form.subject]) approval_index.status = 'Printed' approval.save() flash(u'组合成功')