def new_agent():
if not (g.user.is_contract() or g.user.is_super_leader()):
abort(403)
form = NewAgentForm(request.form)
if request.method == 'POST' and form.validate():
db_agent_name = Agent.name_exist(form.name.data)
if not db_agent_name:
agent = Agent.add(form.name.data, Group.get(form.group.data),
form.tax_num.data, form.address.data, form.phone_num.data,
form.bank.data, form.bank_num.data, form.contact.data,
form.contact_phone.data)
flash(u'新建代理/直客(%s)成功!' % agent.name, 'success')
else:
flash(u'新建代理/直客(%s)失败, 名称已经被占用!' % form.name.data, 'danger')
return tpl('/client/agent/info.html', form=form, title=u"新建代理公司", status='news')
agent.add_comment(g.user, u"新建了代理: %s\n\n税号：%s\n\n地址：%s\n\n电话：%s\n\n开户行：%s\n\n\
银行账号：%s\n\n内部联系人：%s\n\n内部联系人电话：%s\n\n" %
(agent.name, agent.tax_num, agent.address, agent.phone_num,
agent.bank, agent.bank_num, agent.contact, agent.contact_phone),
msg_channel=13)
return redirect(url_for("client.agents"))
return tpl('/client/agent/info.html',
form=form,
status='news',
title=u"新建代理/直客")
def __init__(self, *args, **kwargs):
super(ClientMediumOrderForm, self).__init__(*args, **kwargs)
self.agent.choices = [(m.id, m.name) for m in Agent.all()]
self.client.choices = [(c.id, c.name) for c in Client.all()]
self.direct_sales.choices = [(m.id, m.name) for m in User.sales()]
self.agent_sales.choices = [(m.id, m.name) for m in User.sales()]
self.assistant_sales.choices = [(m.id, m.name) for m in User.sales()]
operaters = User.gets_by_team_type(
TEAM_TYPE_OPERATER) + User.gets_by_team_type(
TEAM_TYPE_OPERATER_LEADER)
self.operaters.choices = [(m.id, m.name) for m in operaters]
self.operaters.hidden = True
self.designers.choices = [
(m.id, m.name) for m in User.gets_by_team_type(TEAM_TYPE_DESIGNER)
]
self.designers.hidden = True
self.planers.choices = [
(m.id, m.name) for m in User.gets_by_team_type(TEAM_TYPE_PLANNER)
]
self.planers.hidden = True
self.sale_CPM.hidden = True
self.medium_CPM.hidden = True
self.contract_type.choices = CONTRACT_TYPE_CN.items()
self.resource_type.choices = RESOURCE_TYPE_CN.items()
self.sale_type.choices = SALE_TYPE_CN.items()
self.medium_group.choices = [(m.id, m.name) for m in MediumGroup.all()]
self.medium.choices = [(m.id, m.name) for m in Medium.all()]
def agent_rebate(agent_id):
agent = Agent.get(agent_id)
rebates = AgentRebate.query.filter_by(agent=agent)
medium_rebates = AgentMediumRebate.query.filter_by(agent=agent)
return tpl('/client/agent/rebate/index.html',
agent=agent, rebates=rebates,
medium_rebates=medium_rebates)
def agent_medium_rebate_delete(agent_id, rebate_id):
rebate = AgentMediumRebate.get(rebate_id)
agent = Agent.get(agent_id)
agent.add_comment(g.user, u"删除了媒体返点信息: 所属媒体:%s 执行年:%s 返点信息:%s%%" %
(rebate.medium.name, rebate.year.year, str(rebate.rebate)), msg_channel=9)
rebate.delete()
return redirect(url_for('client.agent_rebate', agent_id=agent_id))
def agent_rebate_delete(agent_id, rebate_id):
rebate = AgentRebate.get(rebate_id)
agent = Agent.get(agent_id)
agent.add_comment(g.user, u"删除了返点信息: 执行年:%s 致趣返点信息:%s%% 豆瓣返点信息:%s%%" %
(rebate.year.year, str(rebate.inad_rebate), str(rebate.douban_rebate)), msg_channel=9)
rebate.delete()
return redirect(url_for('client.agent_rebate', agent_id=agent_id))
def index():
if not g.user.is_super_admin():
abort(403)
form = FrameworkOrderForm(request.form)
if request.method == 'POST' and form.validate():
order = FrameworkOrder.add(group=Group.get(form.group.data),
agents=Agent.gets(form.agents.data),
description=form.description.data,
money=int(
round(float(form.money.data or 0))),
client_start=form.client_start.data,
client_end=form.client_end.data,
reminde_date=form.reminde_date.data,
direct_sales=User.gets(
form.direct_sales.data),
agent_sales=User.gets(form.agent_sales.data),
contract_type=form.contract_type.data,
creator=g.user,
contract_status=2,
contract=request.values.get('contract'),
create_time=datetime.now())
order.add_comment(g.user, u"导入了框架订单")
flash(u'导入框架订单成功', 'success')
return redirect(order.info_path())
else:
form.client_start.data = datetime.now().date()
form.client_end.data = datetime.now().date()
form.reminde_date.data = datetime.now().date()
return tpl('insert_framework_order.html', form=form)
def rebate_agent_douban_by_month(self, year, month):
if self.medium_id == 3:
try:
rebate = Agent.get(94).douban_rebate_by_year(year)
except:
rebate = 0
elif self.medium_id == 8:
try:
rebate = Agent.get(105).douban_rebate_by_year(year)
except:
rebate = 0
else:
rebate = 0
ex_money = self.get_executive_report_medium_money_by_month(
year, month, 'normal')['medium_money2']
return round(ex_money * rebate / 100, 2)
def index():
if not g.user.is_super_admin():
abort(403)
form = ClientOrderForm(request.form)
mediums = [(m.id, m.name) for m in Medium.all()]
if request.method == 'POST' and form.validate():
if ClientOrder.query.filter_by(contract=request.values.get('contract')).count() > 0:
flash(u'合同号已存在', 'danger')
return redirect(url_for('util_insert_orders.index'))
order = ClientOrder.add(agent=Agent.get(form.agent.data),
client=Client.get(form.client.data),
campaign=form.campaign.data,
money=int("%.0f" % (form.money.data or 0)),
client_start=form.client_start.data,
client_end=form.client_end.data,
reminde_date=form.reminde_date.data,
direct_sales=User.gets(form.direct_sales.data),
agent_sales=User.gets(form.agent_sales.data),
contract_type=form.contract_type.data,
resource_type=form.resource_type.data,
sale_type=form.sale_type.data,
contract=request.values.get('contract', ''),
creator=g.user,
contract_status=2,
create_time=datetime.now())
order.add_comment(g.user,
u"导入了客户订单:%s - %s - %s" % (
order.agent.name,
order.client.name,
order.campaign
))
medium_ids = request.values.getlist('medium')
medium_moneys = request.values.getlist('medium_money')
medium_moneys2 = request.values.getlist('medium_money2')
medium_contracts = request.values.getlist('medium_contract')
if medium_ids and medium_moneys and len(medium_ids) == len(medium_moneys):
for x in range(len(medium_ids)):
medium = Medium.get(medium_ids[x])
mo = Order.add(campaign=order.campaign,
medium=medium,
sale_money=int("%.0f" % (form.money.data or 0)),
medium_money=int(medium_moneys[x] or 0),
medium_money2=int(medium_moneys2[x] or 0),
medium_contract=medium_contracts[x],
medium_start=order.client_start,
medium_end=order.client_end,
creator=g.user)
order.medium_orders = order.medium_orders + [mo]
order.add_comment(g.user, u"导入了媒体订单: %s %s元" %
(medium.name, mo.sale_money))
order.save()
flash(u'导入客户订单成功!', 'success')
insert_executive_report(order, '')
return redirect(order.info_path())
else:
form.client_start.data = datetime.now().date()
form.client_end.data = datetime.now().date()
form.reminde_date.data = datetime.now().date()
return tpl('insert_order.html', form=form, mediums=mediums)
def douban_order_json():
if not (g.user.is_super_leader() or g.user.is_aduit()
or g.user.is_finance()):
abort(403)
now_date = datetime.datetime.now()
location = int(request.values.get('location', 0))
start_year = str(request.values.get('start_year', now_date.year))
start_month = str(request.values.get('start_month', now_date.month))
end_year = str(request.values.get('end_year', now_date.year - 1))
end_month = str(request.values.get('end_month', now_date.month))
start_date_month = datetime.datetime.strptime(
start_year + '-' + start_month, '%Y-%m')
end_date_month = datetime.datetime.strptime(end_year + '-' + end_month,
'%Y-%m')
douban_orders = DoubanOrderExecutiveReport.query.filter(
DoubanOrderExecutiveReport.month_day >= start_date_month,
DoubanOrderExecutiveReport.month_day <= end_date_month)
medium_orders = MediumOrderExecutiveReport.query.filter(
MediumOrderExecutiveReport.month_day >= start_date_month,
MediumOrderExecutiveReport.month_day <= end_date_month)
medium_orders = [_format_order(k) for k in medium_orders if k.status == 1]
medium_date = [{
'agent_name': k['agent'].name,
'medium_id': k['medium_id'],
'money': _get_money_by_location(k, location)
} for k in medium_orders if k['medium_id'] in [3, 8]]
douban_orders = [
_format_order(k, 'douban') for k in douban_orders if k.status == 1
]
douban_date = [{
'agent_name': k['agent'].name,
'money': _get_money_by_location(k, location)
} for k in douban_orders]
agent_params = {}
for k in Agent.all():
agent_params[k.name] = 0
for k in douban_date + medium_date:
if k['agent_name'] in agent_params:
agent_params[k['agent_name']] += k['money']
agent_params = sorted(agent_params.iteritems(), key=lambda x: x[1])
agent_params.reverse()
data = [{"name": u"占比", "data": []}]
sum_saler_money = sum([v for k, v in agent_params])
for k, v in agent_params:
if v > 0:
if sum_saler_money == 0:
percent = u'0.00%'
else:
percent = v / sum_saler_money * 100
data[0]['data'].append({'name': k, 'y': v, 'percent': percent})
return jsonify({
'data': data,
'title': u'直签豆瓣订单（含：优力、无线）代理分析',
'total': float(sum_saler_money)
})
def __init__(self, *args, **kwargs):
super(FrameworkOrderForm, self).__init__(*args, **kwargs)
self.agents.choices = [(a.id, a.name) for a in Agent.all()]
self.group.choices = [(g.id, g.name) for g in Group.all()]
self.direct_sales.choices = [(m.id, m.name) for m in User.sales()]
self.agent_sales.choices = [(m.id, m.name) for m in User.sales()]
self.assistant_sales.choices = [(m.id, m.name) for m in User.sales()]
self.contract_type.choices = CONTRACT_TYPE_CN.items()
def agents():
agents = Agent.all()
agent_rebate = AgentRebate.all()
agent_mediun_rebate = AgentMediumRebate.all()
agent_rebate_data = {}
for k in agent_rebate:
if str(k.agent.id) + '_' + str(k.year.year) not in agent_rebate_data:
agent_rebate_data[str(k.agent.id) + '_' + str(k.year.year)] = str(k.inad_rebate) + '%'
agent_medium_rebate_data = {}
for k in agent_mediun_rebate:
if str(k.agent.id) + '_' + k.medium_name or '' + '_' + str(k.year.year) not in agent_rebate_data:
agent_medium_rebate_data[str(k.agent.id) + '_' + k.medium_name + '_' +
str(k.year.year)] = str(k.rebate) + '%'
info = request.values.get('info', '')
if info:
agents = [k for k in agents if info in k.name]
agent_data = []
for agent in agents:
dict_agent = {}
dict_agent['id'] = agent.id
dict_agent['name'] = agent.name
dict_agent['group_name'] = agent.group.name
dict_agent['group_id'] = agent.group.id
if str(agent.id) + '_2014' in agent_rebate_data:
dict_agent['rebate_2014'] = agent_rebate_data[str(agent.id) + '_2014']
else:
dict_agent['rebate_2014'] = u'无'
if str(agent.id) + '_2015' in agent_rebate_data:
dict_agent['rebate_2015'] = agent_rebate_data[str(agent.id) + '_2015']
else:
dict_agent['rebate_2015'] = u'无'
if str(agent.id) + '_2016' in agent_rebate_data:
dict_agent['rebate_2016'] = agent_rebate_data[str(agent.id) + '_2016']
else:
dict_agent['rebate_2016'] = u'无'
dict_agent['mediums_rebate'] = []
agent_mediums = set([k.medium_name for k in agent_mediun_rebate if k.agent == agent])
for m in agent_mediums:
m_dict = {}
m_dict['name'] = m
if str(agent.id) + '_' + m + '_2014' in agent_medium_rebate_data:
m_dict['rebate_2014'] = agent_medium_rebate_data[str(agent.id) + '_' + m + '_2014']
else:
m_dict['rebate_2014'] = u'无'
if str(agent.id) + '_' + m + '_2015' in agent_medium_rebate_data:
m_dict['rebate_2015'] = agent_medium_rebate_data[str(agent.id) + '_' + m + '_2015']
else:
m_dict['rebate_2015'] = u'无'
if str(agent.id) + '_' + m + '_2016' in agent_medium_rebate_data:
m_dict['rebate_2016'] = agent_medium_rebate_data[str(agent.id) + '_' + m + '_2016']
else:
m_dict['rebate_2016'] = u'无'
dict_agent['mediums_rebate'].append(m_dict)
agent_data.append(dict_agent)
if request.values.get('action') == 'excel':
return write_client_excel(agents=agent_data)
return tpl('/client/agent/index.html', agents=agent_data, info=info)
def __init__(self, *args, **kwargs):
super(ClientOrderForm, self).__init__(*args, **kwargs)
self.agent.choices = [(m.id, m.name) for m in Agent.all()]
self.client.choices = [(c.id, c.name) for c in Client.all()]
self.direct_sales.choices = [(m.id, m.name) for m in User.sales()]
self.agent_sales.choices = [(m.id, m.name) for m in User.sales()]
self.assistant_sales.choices = [(m.id, m.name) for m in User.sales()]
self.contract_type.choices = CONTRACT_TYPE_CN.items()
self.resource_type.choices = RESOURCE_TYPE_CN.items()
self.sale_type.choices = SALE_TYPE_CN.items()
def client_order_excle_data():
now_date = datetime.datetime.now()
location = int(request.values.get('location', 0))
start_year = str(request.values.get('start_year', now_date.year))
start_month = str(request.values.get('start_month', now_date.month))
end_year = str(request.values.get('end_year', now_date.year - 1))
end_month = str(request.values.get('end_month', now_date.month))
start_date_month = datetime.datetime.strptime(
start_year + '-' + start_month, '%Y-%m')
end_date_month = datetime.datetime.strptime(end_year + '-' + end_month,
'%Y-%m')
medium_orders = MediumOrderExecutiveReport.query.filter(
MediumOrderExecutiveReport.month_day >= start_date_month,
MediumOrderExecutiveReport.month_day <= end_date_month)
medium_orders = [_format_order(k) for k in medium_orders if k.status == 1]
medium_date = [{
'agent_name': k['agent'].name,
'money': _get_money_by_location(k, location)
} for k in medium_orders]
agent_params = {}
for k in Agent.all():
agent_params[k.name] = 0
for k in medium_date:
if k['agent_name'] in agent_params:
agent_params[k['agent_name']] += k['money']
agent_params = sorted(agent_params.iteritems(), key=lambda x: x[1])
agent_params = [(k, v) for k, v in agent_params if v > 0]
agent_params.reverse()
headings = ['#', u'代理名称', u'执行额', u'占比']
data = []
data.append([k + 1 for k in range(len(agent_params))])
data.append([k for k, v in agent_params])
data.append([v for k, v in agent_params])
sum_saler_money = sum([v for k, v in agent_params])
if sum_saler_money:
data.append(
['%.2f%%' % (v / sum_saler_money * 100) for k, v in agent_params])
else:
data.append(['0.00%' for k, v in agent_params])
return {
'data': data,
'title': u'新媒体订单代理分析',
'total': float(sum_saler_money),
'headings': headings
}
def agents():
clients = []
for k in Agent.all():
agent_licence_file = k.get_last_client_file(100)
if agent_licence_file:
licence_file = agent_licence_file.agent_path
else:
licence_file = ''
agent_f_certifcate_file = k.get_last_client_file(101)
if agent_f_certifcate_file:
f_certifcate_file = agent_f_certifcate_file.agent_path
else:
f_certifcate_file = ''
agent_o_certifcate_file = k.get_last_client_file(102)
if agent_o_certifcate_file:
o_certifcate_file = agent_o_certifcate_file.agent_path
else:
o_certifcate_file = ''
agent_tax_certifcate_file = k.get_last_client_file(103)
if agent_tax_certifcate_file:
tax_certifcate_file = agent_tax_certifcate_file.agent_path
else:
tax_certifcate_file = ''
agent_t_info_file = k.get_last_client_file(104)
if agent_t_info_file:
t_info_file = agent_t_info_file.agent_path
else:
t_info_file = ''
agent_a_licence_file = k.get_last_client_file(105)
if agent_a_licence_file:
a_licence_file = agent_a_licence_file.agent_path
else:
a_licence_file = ''
dict_agent = {}
dict_agent['id'] = k.id
dict_agent['name'] = k.name
dict_agent['licence_file'] = licence_file
dict_agent['f_certifcate_file'] = f_certifcate_file
dict_agent['o_certifcate_file'] = o_certifcate_file
dict_agent['tax_certifcate_file'] = tax_certifcate_file
dict_agent['t_info_file'] = t_info_file
dict_agent['a_licence_file'] = a_licence_file
dict_agent['files'] = [f.agent_path for f in k.get_agent_attachments()]
clients.append(dict_agent)
return jsonify({'data': clients})
def index():
print g.user.is_contract()
if not (g.user.is_super_admin() or g.user.is_contract()):
abort(403)
form = DoubanOrderForm(request.form)
if request.method == 'POST' and form.validate():
if DoubanOrder.query.filter_by(contract=request.values.get('contract')).count() > 0:
flash(u'合同号已存在', 'danger')
return redirect(url_for('util_insert_douban_orders.index'))
order = DoubanOrder.add(client=Client.get(form.client.data),
agent=Agent.get(form.agent.data),
campaign=form.campaign.data,
money=int(round(float(form.money.data or 0))),
medium_CPM=form.medium_CPM.data,
sale_CPM=form.sale_CPM.data,
client_start=form.client_start.data,
client_end=form.client_end.data,
reminde_date=form.reminde_date.data,
direct_sales=User.gets(form.direct_sales.data),
agent_sales=User.gets(form.agent_sales.data),
operaters=User.gets(form.operaters.data),
designers=User.gets(form.designers.data),
planers=User.gets(form.planers.data),
contract_type=form.contract_type.data,
resource_type=form.resource_type.data,
sale_type=form.sale_type.data,
creator=g.user,
contract=request.values.get('contract'),
contract_status=2,
create_time=datetime.now())
order.add_comment(g.user,
u"导入了直签豆瓣订单:%s - %s - %s" % (
order.agent.name,
order.client.name,
order.campaign
))
insert_executive_report(order, '')
flash(u'导入订单成功', 'success')
return redirect(order.info_path())
else:
form.client_start.data = datetime.now().date()
form.client_end.data = datetime.now().date()
form.reminde_date.data = datetime.now().date()
return tpl('insert_douban_order.html', form=form)
def new_invoice(order_id,
redirect_endpoint='saler_client_order_agent_invoice.index'):
order = ClientOrder.get(order_id)
if not order:
abort(404)
form = AgentInvoiceForm(request.form)
form.client_order.choices = [(order.id, order.client.name)]
form.agent.choices = [(order.id, order.client.name) for k in order.agents]
form.bool_invoice.choices = AGENT_INVOICE_BOOL_INVOICE_CN.items()
# if order.agent_money < order.agents_invoice_sum + float(form.money.data):
# flash(u'新建打款发票失败，发票超过代理总金额!', 'danger')
# return redirect(url_for(redirect_endpoint, order_id=order_id))
if request.method == 'POST':
invoice = AgentInvoice.add(client_order=order,
agent=Agent.get(form.agent.data),
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,
pay_money=form.money.data,
invoice_type=form.invoice_type.data,
invoice_status=AGENT_INVOICE_STATUS_NORMAL,
creator=g.user,
invoice_num=form.invoice_num.data,
add_time=form.add_time.data,
bool_invoice=form.bool_invoice.data)
invoice.save()
flash(u'新建打款发票(%s)成功!' % form.company.data, 'success')
order.add_comment(
g.user,
u"添加打款发票申请信息：%s" %
(u'发票内容: %s; 发票金额: %s元; 发票号: %s' %
(invoice.detail, str(invoice.money), invoice.invoice_num)),
msg_channel=5)
else:
for k in form.errors:
flash(u"新建打款发票失败，%s" % (form.errors[k][0]), 'danger')
return redirect(url_for(redirect_endpoint, order_id=order_id))
def index():
print g.user.is_contract()
if not (g.user.is_super_admin() or g.user.is_contract()):
abort(403)
form = DoubanOrderForm(request.form)
if request.method == 'POST' and form.validate():
if DoubanOrder.query.filter_by(
contract=request.values.get('contract')).count() > 0:
flash(u'合同号已存在', 'danger')
return redirect(url_for('util_insert_douban_orders.index'))
order = DoubanOrder.add(client=Client.get(form.client.data),
agent=Agent.get(form.agent.data),
campaign=form.campaign.data,
money=int(round(float(form.money.data or 0))),
medium_CPM=form.medium_CPM.data,
sale_CPM=form.sale_CPM.data,
client_start=form.client_start.data,
client_end=form.client_end.data,
reminde_date=form.reminde_date.data,
direct_sales=User.gets(form.direct_sales.data),
agent_sales=User.gets(form.agent_sales.data),
operaters=User.gets(form.operaters.data),
designers=User.gets(form.designers.data),
planers=User.gets(form.planers.data),
contract_type=form.contract_type.data,
resource_type=form.resource_type.data,
sale_type=form.sale_type.data,
creator=g.user,
contract=request.values.get('contract'),
contract_status=2,
create_time=datetime.now())
order.add_comment(
g.user, u"导入了直签豆瓣订单:%s - %s - %s" %
(order.agent.name, order.client.name, order.campaign))
insert_executive_report(order, '')
flash(u'导入订单成功', 'success')
return redirect(order.info_path())
else:
form.client_start.data = datetime.now().date()
form.client_end.data = datetime.now().date()
form.reminde_date.data = datetime.now().date()
return tpl('insert_douban_order.html', form=form)
def agent_medium_rebate_create(agent_id):
agent = Agent.get(agent_id)
if request.method == 'POST':
rebate = float(request.values.get('rebate', 0))
year = request.values.get(
'year', datetime.datetime.now().strftime('%Y'))
now_year = datetime.datetime.strptime(year, '%Y').date()
medium_name = request.values.get('medium_name', '')
AgentMediumRebate.add(agent=agent,
medium=Medium.get(1),
medium_name=medium_name,
rebate=rebate,
year=now_year,
creator=g.user,
create_time=datetime.datetime.now())
flash(u'添加成功!', 'success')
agent.add_comment(g.user, u"新建了媒体返点信息: 所属媒体:%s 执行年:%s 返点信息:%s%%" %
(medium_name, year, str(rebate)), msg_channel=9)
return redirect(url_for('client.agent_rebate', agent_id=agent_id))
return tpl('/client/agent/rebate/medium/create.html', agent=agent, medium_groups=MediumGroup.all())
def index():
if not (g.user.is_super_leader() or g.user.is_aduit() or g.user.is_finance()):
abort(403)
now_date = datetime.datetime.now()
year = int(request.values.get('year', now_date.year))
orders = [_format_order(k, year) for k in ClientOrder.all()]
orders = [k for k in orders if k['client_start'].year == year]
# 去掉撤单、申请中的合同
orders = [k for k in orders if k['contract_status'] in [2, 4, 5, 10, 19, 20] and k['status'] == 1 and k['contract']]
# 获取所有代理
agents = [{'name': a.name, 'id': a.id, 'group_id': a.group.id} for a in Agent.all()]
# 获取代理集团
groups = [{'name': gp.name, 'agents': [p for p in agents if p['group_id'] == gp.id]} for gp in Group.all()]
# xxx_count 用于html合并表单
agent_obj = []
total_is_sale_money = 0
total_is_medium_money = 0
for k in groups:
if not k['agents']:
html_order_count = 0
else:
html_order_count = 1
excel_order_count = 0
agent_data = []
for a in k['agents']:
order_data = [o for o in orders if o['agent_id'] == a['id']]
if order_data:
html_order_count += len(order_data) + 1
excel_order_count += len(order_data)
total_is_sale_money += sum([o['is_sale_money'] for o in order_data])
total_is_medium_money += sum([o['is_medium_money'] for o in order_data])
agent_data.append({'name': a['name'], 'orders': order_data, 'html_order_count': len(order_data)})
if agent_data:
agent_obj.append({'name': k['name'], 'agents': agent_data, 'html_order_count': html_order_count,
'excel_order_count': excel_order_count})
action = request.values.get('action', '')
if action == 'excel':
return write_agent_total_excel(year=year, agent_obj=agent_obj, total_is_sale_money=total_is_sale_money,
total_is_medium_money=total_is_medium_money)
return tpl('/data_query/super_leader/agent_total.html', year=year, agent_obj=agent_obj,
total_is_sale_money=total_is_sale_money, total_is_medium_money=total_is_medium_money)
def files_upload(f_type, id):
if f_type == 'medium_group':
obj_data = MediumGroup.get(id)
elif f_type == 'agent':
obj_data = Agent.get(id)
type = int(request.values.get('type', 5))
try:
request.files['file'].filename.encode('gb2312')
except:
flash(u'文件名中包含非正常字符，请使用标准字符', 'danger')
if f_type == 'medium_group':
return redirect(url_for('client.medium_group_detail', medium_group_id=id))
elif f_type == 'agent':
return redirect(url_for('client.agent_detail', agent_id=id))
filename = files_set.save(request.files['file'])
obj_data.add_client_attachment(g.user, filename, type)
flash(FILE_TYPE_CN[type] + u' 上传成功', 'success')
if f_type == 'medium_group':
return redirect(url_for('client.medium_group_detail', medium_group_id=id))
elif f_type == 'agent':
return redirect(url_for('client.agent_detail', agent_id=id))
def agent_detail(agent_id):
if not (g.user.is_contract() or g.user.is_super_leader() or g.user.is_finance()):
abort(403)
agent = Agent.get(agent_id)
if not agent:
abort(404)
form = NewAgentForm(request.form)
if request.method == 'POST' and form.validate():
agent.name = form.name.data
agent.group = Group.get(form.group.data)
agent.tax_num = form.tax_num.data
agent.address = form.address.data
agent.phone_num = form.phone_num.data
agent.bank = form.bank.data
agent.bank_num = form.bank_num.data
agent.contact = form.contact.data
agent.contact_phone = form.contact_phone.data
agent.save()
agent.add_comment(g.user, u"修改了代理: %s\n\n税号：%s\n\n地址：%s\n\n电话：%s\n\n开户行：%s\n\n\
银行账号：%s\n\n内部联系人：%s\n\n内部联系人电话：%s\n\n" %
(agent.name, agent.tax_num, agent.address, agent.phone_num,
agent.bank, agent.bank_num, agent.contact, agent.contact_phone),
msg_channel=13)
flash(u'保存成功', 'success')
else:
form.name.data = agent.name
form.group.data = agent.group.id if agent.group else None
form.tax_num.data = agent.tax_num
form.address.data = agent.address
form.phone_num.data = agent.phone_num
form.bank.data = agent.bank
form.bank_num.data = agent.bank_num
form.contact.data = agent.contact or ""
form.contact_phone.data = agent.contact_phone or ""
return tpl('/client/agent/info.html',
form=form,
agent=agent,
status='update',
title=u"代理/直客-" + agent.name,
FILE_TYPE_CN=FILE_TYPE_CN)
def agent_rebate_create(agent_id):
agent = Agent.get(agent_id)
if request.method == 'POST':
douban_rebate = float(request.values.get('douban_rebate', 0))
inad_rebate = float(request.values.get('inad_rebate', 0))
year = request.values.get(
'year', datetime.datetime.now().strftime('%Y'))
now_year = datetime.datetime.strptime(year, '%Y').date()
if AgentRebate.query.filter_by(agent=agent, year=now_year).count() > 0:
flash(u'该执行年返点信息已存在!', 'danger')
return tpl('/client/agent/rebate/create.html', agent=agent)
AgentRebate.add(agent=agent,
douban_rebate=douban_rebate,
inad_rebate=inad_rebate,
year=now_year,
creator=g.user,
create_time=datetime.datetime.now())
flash(u'添加成功!', 'success')
agent.add_comment(g.user, u"新建了返点信息: 执行年:%s 致趣返点信息:%s%% 豆瓣返点信息:%s%%" %
(year, str(inad_rebate), str(douban_rebate)), msg_channel=9)
return redirect(url_for('client.agent_rebate', agent_id=agent_id))
return tpl('/client/agent/rebate/create.html', agent=agent)
def new_invoice(order_id, redirect_endpoint='saler_client_order_agent_invoice.index'):
order = ClientOrder.get(order_id)
if not order:
abort(404)
form = AgentInvoiceForm(request.form)
form.client_order.choices = [(order.id, order.client.name)]
form.agent.choices = [(order.id, order.client.name) for k in order.agents]
form.bool_invoice.choices = AGENT_INVOICE_BOOL_INVOICE_CN.items()
# if order.agent_money < order.agents_invoice_sum + float(form.money.data):
# flash(u'新建打款发票失败，发票超过代理总金额!', 'danger')
# return redirect(url_for(redirect_endpoint, order_id=order_id))
if request.method == 'POST':
invoice = AgentInvoice.add(client_order=order,
agent=Agent.get(form.agent.data),
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,
pay_money=form.money.data,
invoice_type=form.invoice_type.data,
invoice_status=AGENT_INVOICE_STATUS_NORMAL,
creator=g.user,
invoice_num=form.invoice_num.data,
add_time=form.add_time.data,
bool_invoice=form.bool_invoice.data)
invoice.save()
flash(u'新建打款发票(%s)成功!' % form.company.data, 'success')
order.add_comment(g.user, u"添加打款发票申请信息：%s" % (
u'发票内容: %s; 发票金额: %s元; 发票号: %s' % (invoice.detail, str(invoice.money), invoice.invoice_num)), msg_channel=5)
else:
for k in form.errors:
flash(u"新建打款发票失败，%s" % (form.errors[k][0]), 'danger')
return redirect(url_for(redirect_endpoint, order_id=order_id))
def tax_info(agent_id):
agent = Agent.get(agent_id)
return jsonify(agent.tax_info)
def client_agent_upload():
agent_id = request.values.get('agent')
agent = Agent.get(agent_id)
return attachment_upload(agent, FILE_TYPE_AGENT)
def agent_delete(agent_id):
Agent.get(agent_id).delete()
flash(u'删除成功', 'success')
return redirect(url_for('client.agents'))
def tax_info(agent_id):
agent = Agent.get(agent_id)
return jsonify(agent.tax_info)
def _into_order(param):
group = Group.query.filter_by(name=u'默认集团').first()
if not group:
group = Group.add(name=u'默认集团')
group.save()
agent = Agent.query.filter_by(name=param['agent_name']).first()
if not agent:
agent = Agent.add(
name=param['agent_name'],
group=group,
tax_num='',
address='',
phone_num='',
bank='',
bank_num='',
)
client = Client.query.filter_by(name=param['client_name']).first()
if not client:
client = Client.add(name=param['client_name'], industry=1)
# client.save()
medium = Medium.query.filter_by(name=param['medium_name']).first()
if not medium:
medium = Medium.add(name=param['medium_name'],
abbreviation=param['medium_name'],
tax_num='',
address='',
phone_num='',
bank='',
bank_num='',
owner=Team.query.filter_by(type=8).first())
team_huabei = Team.query.filter_by(name=u'导入渠道销售团队华北').first()
if not team_huabei:
team_huabei = Team.add(
name=u'导入渠道销售团队华北',
type=4,
location=1,
admins=[],
)
team_huanan = Team.query.filter_by(name=u'导入渠道销售团队华南').first()
if not team_huanan:
team_huanan = Team.add(
name=u'导入渠道销售团队华南',
type=4,
location=3,
admins=[],
)
team_huadong = Team.query.filter_by(name=u'导入渠道销售团队华东').first()
if not team_huadong:
team_huadong = Team.add(
name=u'导入渠道销售团队华东',
type=4,
location=2,
admins=[],
)
team_qita = Team.query.filter_by(name=u'导入渠道销售团队其他').first()
if not team_qita:
team_qita = Team.add(
name=u'导入渠道销售团队其他',
type=4,
location=0,
admins=[],
)
if not param['agent_sale_name']:
agents = []
else:
agent_names = param['agent_sale_name'].split(' ')
agents = []
if param['location'] == u'华北':
team = team_huabei
elif param['location'] == u'华东':
team = team_huadong
elif param['location'] == u'华南':
team = team_huanan
else:
team = team_qita
for k in agent_names:
name = k.strip()
p_name = p.get_pinyin(name, '').lower()
email = p_name + '@inad.com'
user = User.query.filter_by(email=email).first()
if not user:
user = User.add(name, email, 'pwd@inad', team, 1)
agents.append(user.id)
if param['contract_type'].find(u'非标') >= 0:
contract_type = 1
else:
contract_type = 0
if param['resource_type'].find(u'硬广') >= 0:
resource_type = 0
elif param['resource_type'].find(u'互动') >= 0:
resource_type = 1
else:
resource_type = 4
if param['sale_type'] == u'代理':
sale_type = 0
else:
sale_type = 1
if ClientOrder.query.filter_by(agent=agent,
client=client,
campaign=param['campaign'],
status=1).first():
return
order = ClientOrder.add(
agent=agent,
client=client,
campaign=param['campaign'],
money=param['money'],
client_start=param['medium_start'],
client_end=param['medium_end'],
reminde_date=param['reminde_date'],
direct_sales=[],
agent_sales=User.gets(agents),
contract_type=contract_type,
resource_type=resource_type,
sale_type=sale_type,
creator=g.user,
create_time=datetime.datetime.now(),
)
order.add_comment(
g.user, u"新建了客户订单:%s - %s - %s" %
(order.agent.name, order.client.name, order.campaign))
mo = Order.add(campaign=order.campaign,
medium=medium,
sale_money=param['money'],
medium_money=param['medium_money'],
medium_money2=param['medium_money2'],
medium_start=param['medium_start'],
medium_end=param['medium_end'],
creator=g.user)
order.add_comment(g.user,
u"新建了媒体订单: %s %s元" % (medium.name, mo.sale_money))
order.medium_orders = [mo]
order.save()
return
from app import app
from libs.db import db
db.create_all()
from models.user import (User, Team, TEAM_TYPE_SUPER_ADMIN, TEAM_TYPE_MEDIUM,
TEAM_TYPE_LEADER, TEAM_TYPE_DIRECT_SELLER)
from models.medium import Medium, MediumGroup
from models.client import Client, Agent, Group
from models.order import Order
from config import DEFAULT_PASSWORD
admin_team = Team.add(u'管理员', type=TEAM_TYPE_SUPER_ADMIN)
medium_team = Team.add(u'媒体', type=TEAM_TYPE_MEDIUM)
leader_team = Team.add('ledaer', type=TEAM_TYPE_LEADER)
sale_team = Team.add('ledaer', type=TEAM_TYPE_DIRECT_SELLER)
user = User.add(name="admin", email="*****@*****.**", password=DEFAULT_PASSWORD, team=admin_team)
leader = User.add(name="leader", email="*****@*****.**", password=DEFAULT_PASSWORD, team=leader_team)
saler = User.add(name="saler", email="*****@*****.**", password=DEFAULT_PASSWORD, team=sale_team)
medium_group = MediumGroup.add(name='测试媒体供应商', tax_num="", address="",
phone_num="", bank="", bank_num="", level=100)
medium = Medium.add(medium_group, u"测试媒体", owner=medium_team)
client = Client.add(u"测试客户", 0)
group = Group.add(u'测试代理集团')
agent = Agent.add(u"测试代理", group=group)
def test_agent(session):
agent = add_agent('testagent')
agent2 = Agent.get(agent.id)
assert agent2.name == 'testagent'
def add_agent(name):
agent = Agent.add(name)
return agent
def update(oid):
out = Out.get(oid)
joiners_form = JoinersForm(request.form)
joiners_form.joiners.data = [u.id for u in out.joiners]
m_persions = []
if g.user.is_out_saler:
m_persions += [{'key': '1' + '-' +
str(k.id) + '-' + k.name, 'name': k.name} for k in Client.all()]
m_persions += [{'key': '2' + '-' +
str(k.id) + '-' + k.name, 'name': k.name} for k in Agent.all()]
m_persions += [{'key': '3' + '-' +
str(k.id) + '-' + k.name, 'name': k.name} for k in Medium.all()]
m_persions.append({'key': 100, 'name': u'其他'})
if request.method == 'POST':
if g.user.is_out_saler:
creator_type = 1
else:
creator_type = 2
start_time = request.values.get('start_time', '')
end_time = request.values.get('end_time', '')
# m_person有两种类型，一种是其他所以填写，一种是代理+客户+媒体组合而成，例如：1-1，2-1，3-1（具体请查看m_persions）
m_persion = request.values.get('m_persion', '')
m_persion_type = int(request.values.get('m_persion_type', 1))
reason = request.values.get('reason', '')
persions = request.values.get('persions', '')
address = request.values.get('address', '')
joiners = User.gets(request.values.getlist('joiners'))
out.start_time = datetime.datetime.strptime(
start_time, '%Y-%m-%d %H:%M')
out.end_time = datetime.datetime.strptime(end_time, '%Y-%m-%d %H:%M')
out.reason = reason
out.joiners = joiners
out.persions = persions
out.address = address
out.m_persion = m_persion
out.m_persion_type = m_persion_type
out.creator_type = creator_type
out.status = int(request.values.get('action', 0))
out.create_time = datetime.datetime.now()
out.save()
# 先删除外出报表，在从新添加
OutReport.query.filter_by(out_id=oid).delete()
for k in list(set(joiners + [out.creator])):
OutReport.add(
start_time=datetime.datetime.strptime(
start_time, '%Y-%m-%d %H:%M'),
end_time=datetime.datetime.strptime(
end_time, '%Y-%m-%d %H:%M'),
reason=reason,
out=out,
meeting_s='',
persions=persions,
address=address,
m_persion=m_persion,
m_persion_type=m_persion_type,
creator_type=creator_type,
status=int(request.values.get('action', 0)),
creator=k,
create_time=datetime.datetime.now()
)
if int(int(request.values.get('action', 0))) == OUT_STATUS_APPLY:
flash(u'已发送申请', 'success')
account_out_apply_signal.send(
current_app._get_current_object(), out=out, status=1)
else:
flash(u'添加成功，请及时申请外出报备', 'success')
return redirect(url_for('account_out.index'))
return tpl('/account/out/update.html', out=out, m_persions=m_persions, joiners_form=joiners_form)
leader_team = Team.add('ledaer', type=TEAM_TYPE_LEADER)
sale_team = Team.add('ledaer', type=TEAM_TYPE_DIRECT_SELLER)
user = User.add(name="admin",
email="*****@*****.**",
password=DEFAULT_PASSWORD,
team=admin_team)
leader = User.add(name="leader",
email="*****@*****.**",
password=DEFAULT_PASSWORD,
team=leader_team)
saler = User.add(name="saler",
email="*****@*****.**",
password=DEFAULT_PASSWORD,
team=sale_team)
medium_group = MediumGroup.add(name='测试媒体供应商',
tax_num="",
address="",
phone_num="",
bank="",
bank_num="",
level=100)
medium = Medium.add(medium_group, u"测试媒体", owner=medium_team)
client = Client.add(u"测试客户", 0)
group = Group.add(u'测试代理集团')
agent = Agent.add(u"测试代理", group=group)
def client_agent_upload():
agent_id = request.values.get('agent')
agent = Agent.get(agent_id)
return attachment_upload(agent, FILE_TYPE_AGENT)