def index(order_id): order = ClientMediumOrder.get(order_id) if not order: abort(404) invoices = ClientMediumInvoice.query.filter_by(client_medium_order=order) invoices_data = { 'PASS': [{'invoice': x, 'form': get_invoice_from(x)} for x in invoices if x.invoice_status == INVOICE_STATUS_PASS], 'NORMAL': [{'invoice': x, 'form': get_invoice_from(x)} for x in invoices if x.invoice_status == INVOICE_STATUS_NORMAL], 'APPLY': [{'invoice': x, 'form': get_invoice_from(x)} for x in invoices if x.invoice_status == INVOICE_STATUS_APPLY], 'APPLYPASS': [{'invoice': x, 'form': get_invoice_from(x)} for x in invoices if x.invoice_status == INVOICE_STATUS_APPLYPASS], 'FAIL': [{'invoice': x, 'form': get_invoice_from(x)} for x in invoices if x.invoice_status == INVOICE_STATUS_FAIL], } reminder_emails = [(u.name, u.email) for u in User.all_active()] new_invoice_form = ClientMediumInvoiceForm() new_invoice_form.client_medium_order.choices = [(order.id, order.medium.name)] new_invoice_form.back_time.data = datetime.date.today() return tpl('/saler/client_medium_order/invoice/index.html', order=order, invoices_data=invoices_data, new_invoice_form=new_invoice_form, INVOICE_STATUS_CN=INVOICE_STATUS_CN, reminder_emails=reminder_emails, INVOICE_TYPE_CN=INVOICE_TYPE_CN)
def new_invoice(order_id): order = ClientMediumOrder.get(order_id) if not order: abort(404) form = ClientMediumInvoiceForm(request.form) form.client_medium_order.choices = [(order.id, order.medium.name)] if request.method == 'POST' and form.validate(): if int(form.money.data) > (int(order.money) - int(order.invoice_apply_sum) - int(order.invoice_pass_sum)): flash(u"新建发票失败,您申请的发票超过了合同总额", 'danger') return redirect(url_for("finance_client_medium_order_invoice.info", order_id=order_id)) invoice = ClientMediumInvoice.add(client_medium_order=order, company=form.company.data, tax_id=form.tax_id.data, address=form.address.data, phone=form.phone.data, bank_id=form.bank_id.data, bank=form.bank.data, detail=form.detail.data, money=form.money.data, invoice_type=form.invoice_type.data, creator=g.user, invoice_status=0, invoice_num=request.values.get( 'new_invoice_num', ''), back_time=form.back_time.data, create_time=request.values.get('create_time', datetime.datetime.now().strftime('%Y-%m-%d'))) invoice.save() flash(u'开发票(%s)成功!' % form.company.data, 'success') order.add_comment(g.user, u"已开发票信息:%s" % ( u'发票内容: %s; 发票金额: %s元' % (invoice.detail, str(invoice.money))), msg_channel=1) else: for k in form.errors: flash(u"新建发票失败,%s" % (form.errors[k][0]), 'danger') return redirect(url_for("finance_client_medium_order_invoice.info", order_id=order.id))
def back_invoice(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) if request.method == 'POST': money = float(request.values.get('money', 0)) back_time = request.values.get( 'back_time', datetime.date.today().strftime('%Y-%m-%d')) num = request.values.get('num', '') bm = BackInvoiceRebate.add( client_medium_order=order, money=money, back_time=back_time, num=num, create_time=datetime.date.today().strftime('%Y-%m-%d')) bm.save() flash(u'返点发票信息保存成功!', 'success') order.add_comment( g.user, u"更新了返点发票信息,发票金额: %s; 发票时间: %s; 发票号: %s;" % (money, back_time, num), msg_channel=4) apply_context = { 'order': order, 'num': money, 'type': 'invoice', } back_money_apply_signal.send( current_app._get_current_object(), apply_context=apply_context) return redirect(url_for("finance_client_medium_order_back_money.back_money", order_id=order.id)) return tpl('/finance/client_medium_order/back_money/info.html', order=order)
def info(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) invoices_data = { 'PASS': [{'invoice': x, 'form': get_invoice_from(x)} for x in ClientMediumInvoice.query.filter_by(client_medium_order=order) if x.invoice_status == INVOICE_STATUS_PASS], 'APPLYPASS': [{'invoice': x, 'form': get_invoice_from(x)} for x in ClientMediumInvoice.query.filter_by(client_medium_order=order) if x.invoice_status == INVOICE_STATUS_APPLYPASS], } reminder_emails = [(u.name, u.email) for u in User.all_active()] new_invoice_form = ClientMediumInvoiceForm() new_invoice_form.client_medium_order.choices = [(order.id, order.medium.name)] new_invoice_form.company.data = order.agent.name new_invoice_form.bank.data = order.agent.bank new_invoice_form.bank_id.data = order.agent.bank_num new_invoice_form.address.data = order.agent.address new_invoice_form.phone.data = order.agent.phone_num new_invoice_form.tax_id.data = order.agent.tax_num new_invoice_form.back_time.data = datetime.date.today() return tpl('/finance/client_medium_order/invoice/info.html', order=order, invoices_data=invoices_data, INVOICE_STATUS_CN=INVOICE_STATUS_CN, reminder_emails=reminder_emails, INVOICE_TYPE_CN=INVOICE_TYPE_CN, new_invoice_form=new_invoice_form)
def delete(order_id, bid): order = ClientMediumOrder.get(order_id) bm = BackMoney.get(bid) order.add_comment(g.user, u"删除了回款信息,回款金额: %s; 回款时间: %s;" % (bm.money, bm.back_time_cn), msg_channel=4) bm.delete() flash(u'删除成功!', 'success') return redirect(url_for("finance_client_medium_order_back_money.back_money", order_id=order.id))
def delete_invoice(order_id, bid): order = ClientMediumOrder.get(order_id) bm = BackInvoiceRebate.get(bid) order.add_comment(g.user, u"删除了返点发票信息,发票金额: %s; 开票时间: %s; 发票号: %s;" % ( bm.money, bm.back_time_cn, bm.num), msg_channel=4) bm.delete() flash(u'删除成功!', 'success') return redirect(url_for("finance_client_medium_order_back_money.back_money", order_id=order.id))
def index(): if not g.user.is_finance(): abort(404) orders = list(ClientMediumOrder.all()) if request.args.get('selected_status'): status_id = int(request.args.get('selected_status')) else: status_id = -1 orderby = request.args.get('orderby', '') search_info = request.args.get('searchinfo', '').strip() location_id = int(request.args.get('selected_location', '-1')) page = int(request.args.get('p', 1)) year = int(request.values.get('year', datetime.datetime.now().year)) # page = max(1, page) # start = (page - 1) * ORDER_PAGE_NUM if location_id >= 0: orders = [o for o in orders if location_id in o.locations] if status_id >= 0: orders = [o for o in orders if o.contract_status == status_id] orders = [ k for k in orders if k.client_start.year == year or k.client_end.year == year ] if search_info != '': orders = [ o for o in orders if search_info.lower() in o.search_invoice_info.lower() ] if orderby and len(orders): orders = sorted(orders, key=lambda x: getattr(x, orderby), reverse=True) select_locations = TEAM_LOCATION_CN.items() select_locations.insert(0, (-1, u'全部区域')) select_statuses = CONTRACT_STATUS_CN.items() select_statuses.insert(0, (-1, u'全部合同状态')) paginator = Paginator(orders, ORDER_PAGE_NUM) try: orders = paginator.page(page) except: orders = paginator.page(paginator.num_pages) return tpl( '/finance/client_medium_order/back_money/index.html', orders=orders, locations=select_locations, location_id=location_id, statuses=select_statuses, status_id=status_id, orderby=orderby, now_date=datetime.date.today(), search_info=search_info, page=page, year=year, params= '&orderby=%s&searchinfo=%s&selected_location=%s&selected_status=%s&year=%s' % (orderby, search_info, location_id, status_id, str(year)))
def delete(order_id, bid): order = ClientMediumOrder.get(order_id) bm = BackMoney.get(bid) order.add_comment(g.user, u"删除了回款信息,回款金额: %s; 回款时间: %s;" % (bm.money, bm.back_time_cn), msg_channel=4) bm.delete() flash(u'删除成功!', 'success') return redirect( url_for("finance_client_medium_order_back_money.back_money", order_id=order.id))
def delete_invoice(order_id, bid): order = ClientMediumOrder.get(order_id) bm = BackInvoiceRebate.get(bid) order.add_comment(g.user, u"删除了返点发票信息,发票金额: %s; 开票时间: %s; 发票号: %s;" % (bm.money, bm.back_time_cn, bm.num), msg_channel=4) bm.delete() flash(u'删除成功!', 'success') return redirect( url_for("finance_client_medium_order_back_money.back_money", order_id=order.id))
def index_pass(): if not g.user.is_finance(): abort(404) orders = list(ClientMediumOrder.all()) search_info = request.args.get('searchinfo', '') location_id = int(request.args.get('selected_location', '-1')) year = int(request.values.get('year', datetime.datetime.now().year)) page = int(request.args.get('p', 1)) if location_id >= 0: orders = [o for o in orders if location_id in o.locations] orders = [ k for k in orders if k.client_start.year == year or k.client_end.year == year ] if search_info != '': orders = [ o for o in orders if search_info.lower() in o.search_invoice_info.lower() ] select_locations = TEAM_LOCATION_CN.items() select_locations.insert(0, (-1, u'全部区域')) select_statuses = CONTRACT_STATUS_CN.items() select_statuses.insert(0, (-1, u'全部合同状态')) paginator = Paginator(orders, ORDER_PAGE_NUM) try: orders = paginator.page(page) except: orders = paginator.page(paginator.num_pages) type = request.args.get('type', '') if type == 'excel': orders = set([ invoice.client_medium_order for invoice in ClientMediumInvoice.get_invoices_status(INVOICE_STATUS_PASS) ]) xls = write_excel(list(orders)) response = get_download_response( xls, ("%s-%s.xls" % (u"申请过的发票信息", datetime.datetime.now().strftime('%Y%m%d%H%M%S')) ).encode('utf-8')) return response return tpl('/finance/client_medium_order/invoice/index_pass.html', orders=orders, locations=select_locations, location_id=location_id, statuses=select_statuses, now_date=datetime.date.today(), search_info=search_info, page=page, year=year, params='&searchinfo=%s&selected_location=%s&year=%s' % (search_info, location_id, str(year)))
def index(): if not g.user.is_finance(): abort(404) orders = list(ClientMediumOrder.all()) if request.args.get('selected_status'): status_id = int(request.args.get('selected_status')) else: status_id = -1 orderby = request.args.get('orderby', '') search_info = request.args.get('searchinfo', '').strip() location_id = int(request.args.get('selected_location', '-1')) page = int(request.args.get('p', 1)) year = int(request.values.get('year', datetime.datetime.now().year)) # page = max(1, page) # start = (page - 1) * ORDER_PAGE_NUM if location_id >= 0: orders = [o for o in orders if location_id in o.locations] if status_id >= 0: orders = [o for o in orders if o.contract_status == status_id] orders = [k for k in orders if k.client_start.year == year or k.client_end.year == year] if search_info != '': orders = [ o for o in orders if search_info.lower() in o.search_invoice_info.lower()] if orderby and len(orders): orders = sorted( orders, key=lambda x: getattr(x, orderby), reverse=True) select_locations = TEAM_LOCATION_CN.items() select_locations.insert(0, (-1, u'全部区域')) select_statuses = CONTRACT_STATUS_CN.items() select_statuses.insert(0, (-1, u'全部合同状态')) paginator = Paginator(orders, ORDER_PAGE_NUM) try: orders = paginator.page(page) except: orders = paginator.page(paginator.num_pages) return tpl('/finance/client_medium_order/back_money/index.html', orders=orders, locations=select_locations, location_id=location_id, statuses=select_statuses, status_id=status_id, orderby=orderby, now_date=datetime.date.today(), search_info=search_info, page=page, year=year, params='&orderby=%s&searchinfo=%s&selected_location=%s&selected_status=%s&year=%s' % (orderby, search_info, location_id, status_id, str(year)))
def new_invoice(order_id): order = ClientMediumOrder.get(order_id) if not order: abort(404) form = ClientMediumInvoiceForm(request.form) form.client_medium_order.choices = [(order.id, order.medium.name)] if request.method == 'POST' and form.validate(): if int(form.money.data) > (int(order.money) - int( order.invoice_apply_sum) - int(order.invoice_pass_sum)): flash(u"新建发票失败,您申请的发票超过了合同总额", 'danger') return redirect( url_for("finance_client_medium_order_invoice.info", order_id=order_id)) invoice = ClientMediumInvoice.add( client_medium_order=order, company=form.company.data, tax_id=form.tax_id.data, address=form.address.data, phone=form.phone.data, bank_id=form.bank_id.data, bank=form.bank.data, detail=form.detail.data, money=form.money.data, invoice_type=form.invoice_type.data, creator=g.user, invoice_status=0, invoice_num=request.values.get('new_invoice_num', ''), back_time=form.back_time.data, create_time=request.values.get( 'create_time', datetime.datetime.now().strftime('%Y-%m-%d'))) invoice.save() flash(u'开发票(%s)成功!' % form.company.data, 'success') order.add_comment(g.user, u"已开发票信息:%s" % (u'发票内容: %s; 发票金额: %s元' % (invoice.detail, str(invoice.money))), msg_channel=1) else: for k in form.errors: flash(u"新建发票失败,%s" % (form.errors[k][0]), 'danger') return redirect( url_for("finance_client_medium_order_invoice.info", order_id=order.id))
def info(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) invoices_data = { 'PASS': [{ 'invoice': x, 'form': get_invoice_from(x) } for x in ClientMediumInvoice.query.filter_by( client_medium_order=order) if x.invoice_status == INVOICE_STATUS_PASS], 'APPLYPASS': [{ 'invoice': x, 'form': get_invoice_from(x) } for x in ClientMediumInvoice.query.filter_by( client_medium_order=order) if x.invoice_status == INVOICE_STATUS_APPLYPASS], } reminder_emails = [(u.name, u.email) for u in User.all_active()] new_invoice_form = ClientMediumInvoiceForm() new_invoice_form.client_medium_order.choices = [(order.id, order.medium.name)] new_invoice_form.company.data = order.agent.name new_invoice_form.bank.data = order.agent.bank new_invoice_form.bank_id.data = order.agent.bank_num new_invoice_form.address.data = order.agent.address new_invoice_form.phone.data = order.agent.phone_num new_invoice_form.tax_id.data = order.agent.tax_num new_invoice_form.back_time.data = datetime.date.today() return tpl('/finance/client_medium_order/invoice/info.html', order=order, invoices_data=invoices_data, INVOICE_STATUS_CN=INVOICE_STATUS_CN, reminder_emails=reminder_emails, INVOICE_TYPE_CN=INVOICE_TYPE_CN, new_invoice_form=new_invoice_form)
def back_invoice(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) if request.method == 'POST': money = float(request.values.get('money', 0)) back_time = request.values.get( 'back_time', datetime.date.today().strftime('%Y-%m-%d')) num = request.values.get('num', '') bm = BackInvoiceRebate.add( client_medium_order=order, money=money, back_time=back_time, num=num, create_time=datetime.date.today().strftime('%Y-%m-%d')) bm.save() flash(u'返点发票信息保存成功!', 'success') order.add_comment(g.user, u"更新了返点发票信息,发票金额: %s; 发票时间: %s; 发票号: %s;" % (money, back_time, num), msg_channel=4) apply_context = { 'order': order, 'num': money, 'type': 'invoice', } back_money_apply_signal.send(current_app._get_current_object(), apply_context=apply_context) return redirect( url_for("finance_client_medium_order_back_money.back_money", order_id=order.id)) return tpl('/finance/client_medium_order/back_money/info.html', order=order)
def index_pass(): if not g.user.is_finance(): abort(404) orders = list(ClientMediumOrder.all()) search_info = request.args.get('searchinfo', '') location_id = int(request.args.get('selected_location', '-1')) year = int(request.values.get('year', datetime.datetime.now().year)) page = int(request.args.get('p', 1)) if location_id >= 0: orders = [o for o in orders if location_id in o.locations] orders = [k for k in orders if k.client_start.year == year or k.client_end.year == year] if search_info != '': orders = [ o for o in orders if search_info.lower() in o.search_invoice_info.lower()] select_locations = TEAM_LOCATION_CN.items() select_locations.insert(0, (-1, u'全部区域')) select_statuses = CONTRACT_STATUS_CN.items() select_statuses.insert(0, (-1, u'全部合同状态')) paginator = Paginator(orders, ORDER_PAGE_NUM) try: orders = paginator.page(page) except: orders = paginator.page(paginator.num_pages) type = request.args.get('type', '') if type == 'excel': orders = set([invoice.client_medium_order for invoice in ClientMediumInvoice.get_invoices_status( INVOICE_STATUS_PASS)]) xls = write_excel(list(orders)) response = get_download_response( xls, ("%s-%s.xls" % (u"申请过的发票信息", datetime.datetime.now().strftime('%Y%m%d%H%M%S'))).encode('utf-8')) return response return tpl('/finance/client_medium_order/invoice/index_pass.html', orders=orders, locations=select_locations, location_id=location_id, statuses=select_statuses, now_date=datetime.date.today(), search_info=search_info, page=page, year=year, params='&searchinfo=%s&selected_location=%s&year=%s' % (search_info, location_id, str(year)))
def index(order_id): order = ClientMediumOrder.get(order_id) if not order: abort(404) return tpl('/saler/client_medium_order/back_money/index.html', order=order)
def client_medium_order_schedule_upload(): order_id = request.values.get('order') order = ClientMediumOrder.get(order_id) return attachment_upload(order, FILE_TYPE_SCHEDULE)
def finish_client_medium_order_upload(): order_id = request.values.get('order') order = ClientMediumOrder.get(order_id) return attachment_upload(order, FILE_TYPE_FINISH)
def back_money(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) if request.method == 'POST': money = float(request.values.get('money', 0)) back_time = request.values.get( 'back_time', datetime.date.today().strftime('%Y-%m-%d')) back_money_status = request.values.get('back_money_status', '') if back_money_status != '': if int(back_money_status) == 0: order.back_money_status = int(back_money_status) order.save() flash(u'完成所有回款!', 'success') order.add_comment(g.user, u"完成所有回款", msg_channel=4) apply_context = { 'order': order, 'num': 0, 'type': 'end', } back_money_apply_signal.send(current_app._get_current_object(), apply_context=apply_context) flash(u'更新了回款状态,回款已完成!', 'success') order.add_comment(g.user, u"更新了回款状态,回款已完成;", msg_channel=4) elif int(back_money_status) == -1: order.back_money_status = int(back_money_status) order.save() flash(u'该项目为划账!', 'success') order.add_comment(g.user, u"坏账项目", msg_channel=4) apply_context = { 'order': order, 'num': -1, 'type': 'end', } back_money_apply_signal.send(current_app._get_current_object(), apply_context=apply_context) else: order.back_money_status = int(back_money_status) order.save() apply_context = { 'order': order, 'num': 0, 'type': 'no_end', } back_money_apply_signal.send(current_app._get_current_object(), apply_context=apply_context) flash(u'更新了回款状态,回款未完成!', 'success') order.add_comment(g.user, u"更新了回款状态,回款未完成;", msg_channel=4) else: bm = BackMoney.add( client_medium_order=order, money=money, back_time=back_time, create_time=datetime.date.today().strftime('%Y-%m-%d')) bm.save() apply_context = { 'order': order, 'num': money, 'type': 'money', } back_money_apply_signal.send(current_app._get_current_object(), apply_context=apply_context) flash(u'回款信息保存成功!', 'success') order.add_comment(g.user, u"更新了回款信息,回款金额: %s; 回款时间: %s;" % (money, back_time), msg_channel=4) return redirect( url_for("finance_client_medium_order_back_money.back_money", order_id=order.id)) return tpl('/finance/client_medium_order/back_money/info.html', order=order)
def client_medium_order_files(order_id): co = ClientMediumOrder.get(order_id) return tpl("order_files.html", order=co)
def client_medium_order_contract_upload(): order_id = request.values.get('order') order = ClientMediumOrder.get(order_id) return attachment_upload(order, FILE_TYPE_CONTRACT)
def back_money(order_id): if not g.user.is_finance(): abort(404) order = ClientMediumOrder.get(order_id) if not order: abort(404) if request.method == 'POST': money = float(request.values.get('money', 0)) back_time = request.values.get( 'back_time', datetime.date.today().strftime('%Y-%m-%d')) back_money_status = request.values.get('back_money_status', '') if back_money_status != '': if int(back_money_status) == 0: order.back_money_status = int(back_money_status) order.save() flash(u'完成所有回款!', 'success') order.add_comment(g.user, u"完成所有回款", msg_channel=4) apply_context = { 'order': order, 'num': 0, 'type': 'end', } back_money_apply_signal.send( current_app._get_current_object(), apply_context=apply_context) flash(u'更新了回款状态,回款已完成!', 'success') order.add_comment( g.user, u"更新了回款状态,回款已完成;", msg_channel=4) elif int(back_money_status) == -1: order.back_money_status = int(back_money_status) order.save() flash(u'该项目为划账!', 'success') order.add_comment(g.user, u"坏账项目", msg_channel=4) apply_context = { 'order': order, 'num': -1, 'type': 'end', } back_money_apply_signal.send( current_app._get_current_object(), apply_context=apply_context) else: order.back_money_status = int(back_money_status) order.save() apply_context = { 'order': order, 'num': 0, 'type': 'no_end', } back_money_apply_signal.send( current_app._get_current_object(), apply_context=apply_context) flash(u'更新了回款状态,回款未完成!', 'success') order.add_comment( g.user, u"更新了回款状态,回款未完成;", msg_channel=4) else: bm = BackMoney.add( client_medium_order=order, money=money, back_time=back_time, create_time=datetime.date.today().strftime('%Y-%m-%d')) bm.save() apply_context = { 'order': order, 'num': money, 'type': 'money', } back_money_apply_signal.send( current_app._get_current_object(), apply_context=apply_context) flash(u'回款信息保存成功!', 'success') order.add_comment( g.user, u"更新了回款信息,回款金额: %s; 回款时间: %s;" % (money, back_time), msg_channel=4) return redirect(url_for("finance_client_medium_order_back_money.back_money", order_id=order.id)) return tpl('/finance/client_medium_order/back_money/info.html', order=order)