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'组合成功')
