def merget_douban_target_personal_info():
if request.method == 'POST':
outsource_ids = request.values.getlist('outsources')
outsources = DoubanOutSource.gets(outsource_ids)
emails = request.values.getlist('email')
msg = request.values.get('msg', '')
merger_outsources = []
for o in outsources:
o.status = OUTSOURCE_STATUS_APPLY_MONEY
o.create_time = datetime.date.today()
o.save()
merger_outsource = MergerDoubanPersonalOutSource.add(outsources=outsources,
invoice=request.values.get(
'invoice', ''),
pay_num=request.values.get(
'pay_num', 0),
num=request.values.get(
'num', 0),
remark=request.values.get(
'remark', ''),
status=1)
merger_outsource.save()
merger_outsources.append(merger_outsource)
flash(u'合并付款申请成功', 'success')
title = u'【费用报备】%s' % (u'合并付款申请审批')
for k in merger_outsources:
apply_context = {"sender": g.user,
"to": emails,
"msg": msg,
"title": title,
"action": -1,
"merger_outsource": k}
merger_outsource_apply_signal.send(
current_app._get_current_object(), apply_context=apply_context)
return redirect(url_for("outsource.merget_douban_target_personal_info"))
apply_outsources = DoubanOutSource.get_personal_outsources(2)
# 审核中的合并付款
apply_merger_outsources = MergerDoubanPersonalOutSource.get_outsource_by_status(
MERGER_OUTSOURCE_STATUS_APPLY)
m_outsources = []
for k in apply_merger_outsources:
m_outsources += k.outsources
apply_money_outsources = [
k for k in DoubanOutSource.get_personal_outsources(3) if k not in m_outsources]
reminder_emails = [(u.name, u.email) for u in User.all_active()]
form = MergerOutSourceForm(request.form)
return tpl('merger_douban_target_personal_info.html',
apply_outsources=apply_outsources, reminder_emails=reminder_emails,
apply_merger_outsources=apply_merger_outsources,
apply_money_outsources=apply_money_outsources,
OUTSOURCE_STATUS_APPLY_MONEY=OUTSOURCE_STATUS_APPLY_MONEY,
OUTSOURCE_STATUS_PAIED=OUTSOURCE_STATUS_PAIED,
OUTSOURCE_STATUS_PASS=OUTSOURCE_STATUS_PASS,
form=form, INVOICE_RATE=INVOICE_RATE)
def outsource_pay_num(outsource_id):
if not g.user.is_finance():
abort(404)
type = request.values.get('type', '')
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
else:
outsource = OutSource.get(outsource_id)
if not outsource:
abort(404)
if outsource.invoice:
pay_num = outsource.num
else:
pay_num = outsource.num * float(1 - INVOICE_RATE)
pay_num = request.values.get('pay_num', pay_num)
outsource.pay_num = pay_num
outsource.save()
flash(u'保存成功!', 'success')
if type == 'douban':
outsource.douban_order.add_comment(g.user,
u"更新了外包:\n\r%s 打款金额%s" % (
outsource.name, str(outsource.pay_num)),
msg_channel=2)
else:
outsource.client_order.add_comment(g.user,
u"更新了外包:\n\r%s 打款金额%s" % (
outsource.name, str(outsource.pay_num)),
msg_channel=2)
if type == 'douban':
return redirect(url_for("finance_outsource_pay.douban_info", order_id=outsource.douban_order.id))
else:
return redirect(url_for("finance_outsource_pay.info", order_id=outsource.client_order.id))
def new_douban_outsource():
form = DoubanOutsourceForm(request.form)
order = DoubanOrder.get(form.douban_order.data)
try:
int(form.num.data)
except:
flash(u'保存失败，金额必须为数字!', 'danger')
return redirect(url_for("outsource.douban_outsources", order_id=order.id))
status = 0
if g.user.is_super_leader():
status = 2
outsource = DoubanOutSource.add(target=OutSourceTarget.get(form.target.data),
douban_order=order,
num=form.num.data,
type=form.type.data,
subtype=form.subtype.data,
remark=form.remark.data,
invoice=False,
status=status,
pay_num=form.num.data)
flash(u'新建外包成功!', 'success')
outsource.douban_order.add_comment(g.user,
u"""新建外包:\n\r %s""" % outsource.name,
msg_channel=2)
if g.user.is_super_leader():
_insert_executive_report(order, rtype='reload')
return redirect(outsource.info_path())
def order_info():
now_year = int(request.values.get('year', datetime.datetime.now().year))
outsources = [_target_outsource_to_dict(
k, 'client_order') for k in OutSource.all()]
outsources += [_target_outsource_to_dict(k, 'douban_order')
for k in DoubanOutSource.all()]
outsources = [k for k in outsources if k]
orders = [k for k in ClientOrder.all() if (k.client_start.year ==
now_year or k.client_end.year == now_year) and k.status == 1]
orders += [k for k in DoubanOrder.all() if (k.client_start.year ==
now_year or k.client_end.year == now_year) and k.status == 1]
order_obj = []
for k in orders:
order_dict = {}
if k.__tablename__ == 'bra_client_order':
order_dict['outsource_obj'] = [o for o in outsources if o[
'order_type'] == 'client_order' and o['order_id'] == k.id]
else:
order_dict['outsource_obj'] = [o for o in outsources if o[
'order_type'] == 'douban_order' and o['order_id'] == k.id]
order_dict['contract'] = k.contract
order_dict['campaign'] = k.campaign
order_dict['money'] = k.money
order_dict['locations_cn'] = k.locations_cn
order_dict['outsources_sum'] = k.outsources_sum
order_dict['outsources_percent'] = k.outsources_percent
order_dict['outsources_paied_sum'] = k.outsources_paied_sum_by_shenji('all')
if order_dict['outsource_obj']:
order_obj.append(order_dict)
if request.values.get('action', '') == 'download':
return write_outsource_order_info_excel(order_obj)
return tpl('/data_query/outsource/order_info.html', orders=order_obj, now_year=now_year)
def _all_douban_order_outsource():
outsource = [{
'order_id': o.douban_order.id,
'money': o.num,
'type': 'douban'
} for o in DoubanOutSource.all() if o.status in [2, 3, 4]]
outsource += [{
'order_id': o.medium_order.id,
'money': o.num,
'type': 'client'
} for o in OutSource.all() if o.status in [2, 3, 4]]
return outsource
def outsource_back(outsource_id):
if not g.user.is_finance():
abort(404)
type = request.values.get('type', '')
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
else:
outsource = OutSource.get(outsource_id)
outsource.status = OUTSOURCE_STATUS_APPLY_MONEY
outsource.create_time = datetime.date.today()
outsource.save()
flash(u'外包款项撤回，名称:%s打款金额%s' %
(outsource.name, str(outsource.pay_num)), 'success')
if type == 'douban':
outsource.douban_order.add_comment(
g.user, u'外包款项撤回，名称%s打款金额%s' % (outsource.name, str(outsource.pay_num)), msg_channel=2)
else:
outsource.client_order.add_comment(
g.user, u'外包款项撤回，名称%s打款金额%s' % (outsource.name, str(outsource.pay_num)), msg_channel=2)
if type == 'douban':
order = outsource.douban_order
else:
order = outsource.medium_order.client_order
if type == 'douban':
to_users = outsource.douban_order.direct_sales + outsource.douban_order.agent_sales + \
[outsource.douban_order.creator, g.user] + \
User.operater_leaders() + outsource.douban_order.operater_users
else:
to_users = outsource.client_order.direct_sales + outsource.client_order.agent_sales + \
[outsource.client_order.creator, g.user] + \
User.operater_leaders() + outsource.client_order.operater_users
to_emails = list(set([x.email for x in to_users]))
title = u'【费用报备】%s-%s-%s' % (order.contract or u'无合同号', order.jiafang_name, u'外包款项撤回')
apply_context = {"sender": g.user,
"to": to_emails,
"action_msg": u'外包款项撤回',
"msg": u'',
"order": order,
"title": title,
"to_users": ','.join([k.name for k in order.agent_sales] + [k.name for k in order.operater_users]),
"outsources": [outsource]}
outsource_apply_signal.send(
current_app._get_current_object(), context=apply_context)
if type == 'douban':
return redirect(url_for("finance_outsource_pay.douban_info", order_id=outsource.douban_order.id))
else:
return redirect(url_for("finance_outsource_pay.info", order_id=outsource.client_order.id))
def update_personal_pay_num():
type = request.values.get('type', '')
outsource_id = request.values.get('outsource_id')
pay_num = request.values.get('update_pay_num', 0)
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
else:
outsource = OutSource.get(outsource_id)
outsource.pay_num = pay_num
outsource.save()
flash(u'修改实际付款金额:%s 成功' % (str(pay_num)), 'success')
if type == 'douban':
return redirect(url_for("outsource.merget_douban_target_personal_info"))
else:
return redirect(url_for("outsource.merget_client_target_personal_info"))
def order_info():
now_year = int(request.values.get('year', datetime.datetime.now().year))
outsources = [
_target_outsource_to_dict(k, 'client_order') for k in OutSource.all()
]
outsources += [
_target_outsource_to_dict(k, 'douban_order')
for k in DoubanOutSource.all()
]
outsources = [k for k in outsources if k]
orders = [
k for k in ClientOrder.all()
if (k.client_start.year == now_year or k.client_end.year == now_year)
and k.status == 1
]
orders += [
k for k in DoubanOrder.all()
if (k.client_start.year == now_year or k.client_end.year == now_year)
and k.status == 1
]
order_obj = []
for k in orders:
order_dict = {}
if k.__tablename__ == 'bra_client_order':
order_dict['outsource_obj'] = [
o for o in outsources
if o['order_type'] == 'client_order' and o['order_id'] == k.id
]
else:
order_dict['outsource_obj'] = [
o for o in outsources
if o['order_type'] == 'douban_order' and o['order_id'] == k.id
]
order_dict['contract'] = k.contract
order_dict['campaign'] = k.campaign
order_dict['money'] = k.money
order_dict['locations_cn'] = k.locations_cn
order_dict['outsources_sum'] = k.outsources_sum
order_dict['outsources_percent'] = k.outsources_percent
order_dict['outsources_paied_sum'] = k.outsources_paied_sum_by_shenji(
'all')
if order_dict['outsource_obj']:
order_obj.append(order_dict)
if request.values.get('action', '') == 'download':
return write_outsource_order_info_excel(order_obj)
return tpl('/data_query/outsource/order_info.html',
orders=order_obj,
now_year=now_year)
def outsource_delete(outsource_id):
type = request.values.get('type', '')
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
order = outsource.douban_order
else:
outsource = OutSource.get(outsource_id)
order = outsource.medium_order
if type == "douban":
outsource.douban_order.add_comment(g.user,
u"删除了外包:\n\r%s" % outsource.name,
msg_channel=2)
else:
outsource.client_order.add_comment(g.user,
u"删除了外包:\n\r%s" % outsource.name,
msg_channel=2)
url = outsource.info_path()
outsource.delete()
_insert_executive_report(order, rtype='reload')
return redirect(url)
def _all_douban_order_outsource():
outsource = [{'order_id': o.douban_order.id, 'money': o.num, 'type': 'douban'}
for o in DoubanOutSource.all() if o.status in [2, 3, 4]]
outsource += [{'order_id': o.medium_order.id, 'money': o.num, 'type': 'client'}
for o in OutSource.all() if o.status in [2, 3, 4]]
return outsource
def merget_douban_target_info(target_id):
target = OutSourceTarget.get(target_id)
if request.method == 'POST':
form = MergerOutSourceForm(request.form)
outsource_ids = request.values.getlist('outsources')
outsources = DoubanOutSource.gets(outsource_ids)
emails = request.values.getlist('email')
msg = request.values.get('msg', '')
action = int(request.values.get('action', 1))
merger_outsources = []
if action == 1:
for o in outsources:
o.status = OUTSOURCE_STATUS_APPLY_MONEY
o.create_time = datetime.date.today()
o.save()
merger_outsource = MergerDoubanOutSource.add(target=target,
outsources=outsources,
invoice=form.invoice.data,
pay_num=form.pay_num.data,
num=form.num.data,
remark=form.remark.data,
status=1)
merger_outsource.save()
merger_outsources.append(merger_outsource)
elif action == 2:
for o in outsources:
o.status = OUTSOURCE_STATUS_APPLY_MONEY
o.create_time = datetime.date.today()
o.save()
merger_outsource = MergerDoubanOutSource.add(target=target,
outsources=[o],
invoice=False,
pay_num=o.pay_num,
num=o.pay_num,
remark=o.remark,
status=1)
merger_outsource.save()
merger_outsources.append(merger_outsource)
flash(u'合并付款申请成功', 'success')
title = u'【费用报备】%s' % (u'合并付款申请审批')
for k in merger_outsources:
apply_context = {"sender": g.user,
"to": emails,
"msg": msg,
"title": title,
"action": 1,
"merger_outsource": k}
merger_outsource_apply_signal.send(
current_app._get_current_object(), apply_context=apply_context)
return redirect(url_for("outsource.merget_douban_target_info", target_id=target_id))
apply_outsources = DoubanOutSource.get_outsources_by_target(target_id, 2)
paid_outsources = list(MergerDoubanOutSource.get_outsources_by_status(0, target_id))
apply_merger_outsources = MergerDoubanOutSource.get_outsources_by_status(
MERGER_OUTSOURCE_STATUS_APPLY, target_id=target_id)
# 在流程中的合并付款中的外包项不用出现再正在付款中
m_outsources = []
for k in apply_merger_outsources:
m_outsources += k.outsources
apply_money_outsources = [k for k in DoubanOutSource.get_outsources_by_target(target_id, 3)
if k not in m_outsources]
reminder_emails = [(u.name, u.email) for u in User.all_active()]
form = MergerOutSourceForm(request.form)
return tpl('merger_douban_target_info.html', target=target, reminder_emails=reminder_emails,
OUTSOURCE_STATUS_APPLY_MONEY=OUTSOURCE_STATUS_APPLY_MONEY,
OUTSOURCE_STATUS_PAIED=OUTSOURCE_STATUS_PAIED,
OUTSOURCE_STATUS_PASS=OUTSOURCE_STATUS_PASS,
form=form, INVOICE_RATE=INVOICE_RATE,
apply_merger_outsources=apply_merger_outsources,
apply_money_outsources=apply_money_outsources,
paid_outsources=paid_outsources, apply_outsources=apply_outsources)
def outsource_status(order_id):
type = request.values.get('type', '')
if type == 'douban':
order = DoubanOrder.get(order_id)
else:
order = ClientOrder.get(order_id)
if not order:
abort(404)
outsource_ids = request.values.getlist('outsources')
action = int(request.values.get('action', 0))
# emails = request.values.getlist('email')
msg = request.values.get('msg', '')
to_users = order.direct_sales + order.agent_sales + \
[order.creator, g.user] + order.operater_users
try:
outsource_apply_user = User.outsource_leaders_email(
(order.agent_sales + order.direct_sales)[0])
except:
outsource_apply_user = []
outsources_ids = set(outsource_ids) | set(
[str(k.id) for k in order.apply_outsources()])
if type == 'douban':
total_outsources = DoubanOutSource.gets(outsources_ids)
outsources = DoubanOutSource.gets(outsource_ids)
else:
total_outsources = OutSource.gets(outsources_ids)
outsources = OutSource.gets(outsource_ids)
if not outsources:
abort(403)
if order.money:
outsource_percent = sum(
[k.pay_num for k in total_outsources]) / float(order.money)
else:
outsource_percent = sum([k.pay_num for k in total_outsources]) / 1
if action == 0:
if outsource_percent >= 0.02:
next_status = OUTSOURCE_STATUS_EXCEED
action_msg = u'外包费用超过2%，申请审批'
else:
next_status = OUTSOURCE_STATUS_APPLY_LEADER
action_msg = u'外包费用申请审批'
# to_users_name = ','.join(
# [k.name for k in outsource_apply_user] + [k.name for k in order.operater_users])
elif action == 1:
next_status = OUTSOURCE_STATUS_PASS
action_msg = u'外包费用审批通过'
# to_users_name = ','.join(
# [k.name for k in order.agent_sales] + [k.name for k in order.operater_users])
elif action == 2:
next_status = OUTSOURCE_STATUS_NEW
action_msg = u'外包费用拒绝通过'
# to_users_name = ','.join(
# [k.name for k in order.agent_sales] + [k.name for k in order.operater_users])
elif action == 3:
next_status = OUTSOURCE_STATUS_APPLY_MONEY
action_msg = u'外包费用申请打款'
# to_users_name = ','.join([k.name for k in User.operater_leaders()])
elif action == 100:
# to_users_name = ','.join([k.name for k in outsource_apply_user] + [k.name for k in order.operater_users])
outsources_json = json.loads(
request.values.get('outsource_json', '[]'))
outsources = []
# 先修改外包金额
for k in outsources_json:
if type == 'douban':
outsource = DoubanOutSource.get(k['id'])
else:
outsource = OutSource.get(k['id'])
outsource.num = float(k['num'])
outsource.target = OutSourceTarget.get(k['target'])
outsource.type = k['type']
outsource.subtype = k['subtype']
outsource.remark = k['remark']
outsource.pay_num = float(k['num'])
# outsource.status = next_status
outsource.save()
outsources.append(outsource)
# 根据修改后的金额，计算是否超过占比
outsource_percent = float(order.outsources_percent) / 100
if outsource_percent >= 0.02:
action_msg = u'外包费用超过2%，修改并申请审批'
next_status = OUTSOURCE_STATUS_EXCEED
else:
action_msg = u'外包费用修改并重新申请审批'
next_status = OUTSOURCE_STATUS_APPLY_LEADER
for k in outsources_json:
if type == 'douban':
outsource = DoubanOutSource.get(k['id'])
else:
outsource = OutSource.get(k['id'])
outsource.status = next_status
outsource.save()
else:
action_msg = u'外包费用消息提醒'
if action < 4:
for outsource in outsources:
outsource.status = next_status
outsource.save()
if action == 1:
_insert_executive_report(order, rtype='reload')
order.add_comment(g.user,
u"%s:\n\r%s\n\r%s" % (
action_msg, "\n\r".join([o.name for o in outsources]), msg),
msg_channel=2)
# to_emails = list(set(emails + [x.email for x in to_users] + [k.email for k in outsource_apply_user]))
apply_context = {"to_users": to_users + outsource_apply_user,
"outsource_apply_user": outsource_apply_user,
"action_msg": action_msg,
"info": msg,
"order": order,
"action": action,
"outsource_percent": outsource_percent,
"outsources": outsources}
outsource_apply_signal.send(
current_app._get_current_object(), context=apply_context)
if type == 'douban':
return redirect(url_for("outsource.douban_outsources", order_id=order.id))
else:
return redirect(url_for("outsource.client_outsources", order_id=order.id))
def outsource(outsource_id):
type = request.values.get('type', '')
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
else:
outsource = OutSource.get(outsource_id)
if not outsource:
abort(404)
if type == 'douban':
form = DoubanOutsourceForm(request.form)
else:
form = OutsourceForm(request.form)
outsource.target = OutSourceTarget.get(form.target.data)
if type == 'douban':
outsource.douban_order = DoubanOrder.get(form.douban_order.data)
else:
outsource.medium_order = Order.get(form.medium_order.data)
try:
int(form.num.data)
except:
flash(u'保存失败，金额必须为数字!', 'danger')
return redirect(outsource.info_path())
outsource.num = form.num.data
outsource.type = form.type.data
outsource.subtype = form.subtype.data
outsource.remark = form.remark.data
outsource.invoice = True
outsource.pay_num = form.num.data
outsource.save()
flash(u'保存成功!', 'success')
if type == "douban":
outsource.douban_order.add_comment(g.user,
u"更新了外包:\n\r%s" % outsource.name,
msg_channel=2)
else:
outsource.client_order.add_comment(g.user,
u"更新了外包:\n\r%s" % outsource.name,
msg_channel=2)
if type == 'douban':
order = outsource.douban_order
else:
order = outsource.medium_order.client_order
if outsource.status not in [0, 4]:
to_users = order.direct_sales + order.agent_sales + \
[order.creator, g.user] + order.operater_users
try:
outsource_apply_user = User.outsource_leaders_email(
order.agent_sales[0])
except:
outsource_apply_user = []
if outsource.status in [1, 2, 5]:
to_users_name = ','.join(
[k.name for k in order.operater_users] + [k.name for k in order.agent_sales])
elif outsource.status == 3:
to_users += User.finances()
to_users_name = ','.join(
[k.name for k in User.finances()] + [k.name for k in order.operater_users])
to_emails = list(
set([x.email for x in to_users] + [k.email for k in outsource_apply_user]))
title = u'【费用报备】%s-%s-%s' % (order.contract or u'无合同号', order.jiafang_name, u'修改外包信息')
apply_context = {"sender": g.user,
"to": to_emails,
"action_msg": u'修改外包信息',
"msg": '',
"order": order,
"title": title,
"to_users": to_users_name,
"outsources": [outsource]}
outsource_apply_signal.send(
current_app._get_current_object(), context=apply_context)
return redirect(outsource.info_path())
elif o.type == 2:
type = 1
else:
type = 2
invoice = ''
on_time = o.medium_order.medium_end
create_time = datetime.datetime.now()
OtherCost.add(company=company,
client_order=client_order,
money=money,
type=type,
invoice=invoice,
on_time=on_time,
create_time=create_time)
outsources = DoubanOutSource.all()
outsources = [o for o in outsources if o.target_id == 271]
for o in outsources:
company = o.target.name
douban_order = o.douban_order
money = o.num
if o.type == 9:
type = 3
elif o.type == 8:
type = 2
elif o.type == 2:
type = 1
else:
type = 2
invoice = ''
on_time = o.douban_order.client_end
def outsource_pass(outsource_id):
if not g.user.is_finance():
abort(404)
type = request.values.get('type', '')
if type == 'douban':
outsource = DoubanOutSource.get(outsource_id)
else:
outsource = OutSource.get(outsource_id)
if not outsource:
abort(404)
outsources_ids = request.values.getlist('outsources')
if type == 'douban':
outsources = DoubanOutSource.gets(outsources_ids)
else:
outsources = OutSource.gets(outsources_ids)
if not outsources:
abort(403)
emails = request.values.getlist('email')
msg = request.values.get('msg', '')
action = int(request.values.get('action', 0))
if type == 'douban':
to_users = outsource.douban_order.direct_sales + outsource.douban_order.agent_sales + \
[outsource.douban_order.creator, g.user] + User.operater_leaders()
else:
to_users = outsource.client_order.direct_sales + outsource.client_order.agent_sales + \
[outsource.client_order.creator, g.user] + User.operater_leaders()
to_emails = list(set(emails + [x.email for x in to_users]))
if action != 10:
outsource_status = OUTSOURCE_STATUS_PAIED
action_msg = u'外包款已打'
for outsource in outsources:
outsource.status = outsource_status
outsource.create_time = datetime.date.today()
outsource.save()
flash(u'外包款已打，名称:%s打款金额%s' %
(outsource.name, str(outsource.pay_num)), 'success')
if type == 'douban':
outsource.douban_order.add_comment(
g.user, u'外包款已打，名称%s打款金额%s' % (outsource.name, str(outsource.pay_num)), msg_channel=2)
else:
outsource.client_order.add_comment(
g.user, u'外包款已打，名称%s打款金额%s' % (outsource.name, str(outsource.pay_num)), msg_channel=2)
else:
action_msg = u'消息提醒'
if type == 'douban':
order = outsource.douban_order
else:
order = outsource.medium_order.client_order
title = u'【费用报备】%s-%s-%s' % (order.contract or u'无合同号', order.jiafang_name, action_msg)
apply_context = {"sender": g.user,
"to": to_emails,
"action_msg": action_msg,
"msg": msg,
"order": order,
"title": title,
"to_users": ','.join([k.name for k in order.agent_sales] + [k.name for k in order.operater_users]),
"outsources": outsources}
outsource_apply_signal.send(
current_app._get_current_object(), apply_context=apply_context)
if type == 'douban':
return redirect(url_for("finance_outsource_pay.douban_info", order_id=outsource.douban_order.id))
else:
return redirect(url_for("finance_outsource_pay.info", order_id=outsource.client_order.id))