def pay_rebate_agent_invoice():
now_date = datetime.datetime.now()
info = request.values.get('info', '').strip()
location = int(request.values.get('location', 0))
year = request.values.get('year', now_date.strftime('%Y'))
month = request.values.get('month', now_date.strftime('%m'))
if month != '00':
search_date = datetime.datetime.strptime(
str(year) + '-' + str(month), '%Y-%m')
end_search_date = (
search_date + datetime.timedelta(days=(search_date.max.day - search_date.day) + 1)).replace(day=1)
orders = [k for k in AgentInvoicePay.query.filter(AgentInvoicePay.pay_time >= search_date,
AgentInvoicePay.pay_time < end_search_date)
if k.client_order.status == 1]
else:
orders = [k for k in AgentInvoicePay.all() if k.pay_time.year == int(
year) and k.client_order.status == 1]
if location != 0:
orders = [k for k in orders if location in k.client_order.locations]
if info:
orders = [k for k in orders if info in k.client_order.search_invoice_info]
orders = sorted(list(orders), key=lambda x: x.pay_time, reverse=False)
if request.values.get('action', '') == 'download':
response = write_order_excel(list(orders), 'pay_rebate_agent_invoice')
return response
return tpl('/saler/client_order/data_query/index.html',
orders=orders, location=location,
year=year, month=month, info=info,
title=u"已收客户返点发票", t_type='pay_rebate_agent_invoice')
def apply():
if not g.user.is_finance():
abort(404)
search_info = request.args.get('searchinfo', '').strip()
location_id = int(request.args.get('selected_location', '-1'))
orders = list(AgentInvoicePay.query.filter_by(pay_status=4))
if location_id >= 0:
orders = [o for o in orders if location_id in o.agent_invoice.client_order.locations]
if search_info != '':
orders = [
o for o in orders if search_info.lower() in o.agent_invoice.client_order.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'全部合同状态'))
for i in orders:
client_order = i.agent_invoice.client_order
agent_invoices = [k.id for k in AgentInvoice.query.filter_by(client_order=client_order)]
pays = [k for k in AgentInvoicePay.all() if k.agent_invoice_id in agent_invoices]
i.apply_num = len([k for k in pays if k.pay_status == 4])
i.pay_num = len([k for k in pays if k.pay_status == 0])
return tpl('/finance/client_order/agent_pay/index_pass.html', orders=orders, title=u'申请中的客户付款',
locations=select_locations,
location_id=location_id, statuses=select_statuses,
now_date=datetime.date.today(), search_info=search_info,
params='?&searchinfo=%s&selected_location=%s' %
(search_info, location_id))
def _all_agent_rebate_pay():
agent_rebate_pay_data = [{
'order_id': k.agent_invoice.client_order_id,
'money': k.money,
'agent_id': k.agent_invoice.agent_id,
'pay_time': k.pay_time
} for k in AgentInvoicePay.all() if k.pay_status == 0]
return agent_rebate_pay_data
def index():
if not g.user.is_finance():
abort(404)
orders = list(ClientOrder.all())
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))
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)
for i in orders.object_list:
client_order = i
agent_invoices = [
k.id
for k in AgentInvoice.query.filter_by(client_order=client_order)
]
pays = [
k for k in AgentInvoicePay.all()
if k.agent_invoice_id in agent_invoices
]
i.apply_num = len([k for k in pays if k.pay_status == 4])
i.pay_num = len([k for k in pays if k.pay_status == 0])
return tpl('/finance/client_order/agent_pay/index.html',
orders=orders,
title=u'全部客户付款',
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 apply():
if not g.user.is_finance():
abort(404)
search_info = request.args.get('searchinfo', '').strip()
location_id = int(request.args.get('selected_location', '-1'))
orders = list(AgentInvoicePay.query.filter_by(pay_status=4))
if location_id >= 0:
orders = [
o for o in orders
if location_id in o.agent_invoice.client_order.locations
]
if search_info != '':
orders = [
o for o in orders if search_info.lower() in
o.agent_invoice.client_order.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'全部合同状态'))
for i in orders:
client_order = i.agent_invoice.client_order
agent_invoices = [
k.id
for k in AgentInvoice.query.filter_by(client_order=client_order)
]
pays = [
k for k in AgentInvoicePay.all()
if k.agent_invoice_id in agent_invoices
]
i.apply_num = len([k for k in pays if k.pay_status == 4])
i.pay_num = len([k for k in pays if k.pay_status == 0])
return tpl('/finance/client_order/agent_pay/index_pass.html',
orders=orders,
title=u'申请中的客户付款',
locations=select_locations,
location_id=location_id,
statuses=select_statuses,
now_date=datetime.date.today(),
search_info=search_info,
params='?&searchinfo=%s&selected_location=%s' %
(search_info, location_id))
def pay_rebate_agent_invoice():
now_date = datetime.datetime.now()
info = request.values.get('info', '').strip()
location = int(request.values.get('location', 0))
year = request.values.get('year', now_date.strftime('%Y'))
month = request.values.get('month', now_date.strftime('%m'))
if month != '00':
search_date = datetime.datetime.strptime(
str(year) + '-' + str(month), '%Y-%m')
end_search_date = (search_date + datetime.timedelta(
days=(search_date.max.day - search_date.day) + 1)).replace(day=1)
orders = [
k for k in AgentInvoicePay.query.filter(
AgentInvoicePay.pay_time >= search_date,
AgentInvoicePay.pay_time < end_search_date)
if k.client_order.status == 1
]
else:
orders = [
k for k in AgentInvoicePay.all()
if k.pay_time.year == int(year) and k.client_order.status == 1
]
if location != 0:
orders = [k for k in orders if location in k.client_order.locations]
if info:
orders = [
k for k in orders if info in k.client_order.search_invoice_info
]
orders = sorted(list(orders), key=lambda x: x.pay_time, reverse=False)
if request.values.get('action', '') == 'download':
response = write_order_excel(list(orders), 'pay_rebate_agent_invoice')
return response
return tpl('/saler/client_order/data_query/index.html',
orders=orders,
location=location,
year=year,
month=month,
info=info,
title=u"已收客户返点发票",
t_type='pay_rebate_agent_invoice')
def index():
if not g.user.is_finance():
abort(404)
orders = list(ClientOrder.all())
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))
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)
for i in orders.object_list:
client_order = i
agent_invoices = [k.id for k in AgentInvoice.query.filter_by(client_order=client_order)]
pays = [k for k in AgentInvoicePay.all() if k.agent_invoice_id in agent_invoices]
i.apply_num = len([k for k in pays if k.pay_status == 4])
i.pay_num = len([k for k in pays if k.pay_status == 0])
return tpl('/finance/client_order/agent_pay/index.html', orders=orders, title=u'全部客户付款',
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 _all_agent_rebate_pay():
agent_rebate_pay_data = [{'order_id': k.agent_invoice.client_order_id,
'money': k.money, 'agent_id': k.agent_invoice.agent_id,
'pay_time': k.pay_time} for k in AgentInvoicePay.all() if k.pay_status == 0]
return agent_rebate_pay_data
def cost():
client_invoices = list(Invoice.all())
medium_invoices = list(MediumInvoice.all())
medium_invoice_pays = list(MediumInvoicePay.all())
medium_invoice_rebate_invoice = list(MediumRebateInvoice.all())
agent_invoices = list(AgentInvoice.all())
agent_invoice_pays = list(AgentInvoicePay.all())
back_moneys = list(BackMoney.all())
back_money_rebates = list(BackInvoiceRebate.all())
now_date = datetime.datetime.now()
info = request.values.get('info', '').strip()
location = int(request.values.get('location', 0))
year = request.values.get('year', now_date.strftime('%Y'))
month = request.values.get('month', now_date.strftime('%m'))
if month != '00':
search_date = datetime.datetime.strptime(
str(year) + '-' + str(month), '%Y-%m')
orders = set([
k.client_order for k in ClientOrderExecutiveReport.query.filter_by(
month_day=search_date) if k.status == 1
])
else:
orders = [
k for k in ClientOrder.all() if k.client_start.year == int(year)
or k.client_end.year == int(year)
]
if location != 0:
orders = [k for k in orders if location in k.locations]
if info:
orders = [k for k in orders if info in k.search_info]
orders = sorted(list(orders), key=lambda x: x.client_start, reverse=False)
for order in orders:
order.pass_invoice_sum = sum([
k.money for k in client_invoices
if k.invoice_status == 0 and k.client_order == order
])
order.back_money_sum = sum(
[k.money for k in back_moneys if k.client_order == order])
order.back_money_rebate_sum = sum(
[k.money for k in back_money_rebates if k.client_order == order])
order.agent_invoice_sum = sum(
[k.money for k in agent_invoices if k.client_order == order])
agent_invoice_pay_sum = 0.0
invoices = [k for k in agent_invoices if k.client_order == order]
for invoice in invoices:
agent_invoice_pay_sum += sum([
k.money for k in agent_invoice_pays
if k.pay_status == 0 and k.agent_invoice == invoice
])
order.agent_invoice_pay_sum = agent_invoice_pay_sum
order.medium_invoice_sum = sum(
[k.money for k in medium_invoices if k.client_order == order])
invoices = [k for k in medium_invoices if k.client_order == order]
order.medium_invoice_pay_sum = sum([
k.money for k in medium_invoice_pays
if k.pay_status == 0 and k.medium_invoice in invoices
])
order.medium_invoice_rebate_invoice_sum = sum([
k.money for k in medium_invoice_rebate_invoice
if k.client_order == order and k.invoice_status == 0
])
for m in order.medium_orders:
m.medium_invoice_sum = sum([
k.money for k in medium_invoices
if k.client_order == order and k.medium == m.medium
])
m_invoices = [
k for k in medium_invoices
if k.client_order == order and k.medium == m.medium
]
m.medium_invoice_pay_sum = sum([
k.money for k in medium_invoice_pays
if k.pay_status == 0 and k.medium_invoice in m_invoices
])
m.medium_invoice_rebate_invoice_sum = sum([
k.money for k in medium_invoice_rebate_invoice
if k.client_order == order and k.invoice_status == 0
and k.medium == m.medium
])
if request.values.get('action', '') == 'download':
response = write_order_excel(list(orders))
return response
return tpl('cost.html',
orders=orders,
location=location,
year=year,
month=month,
info=info)
def cost():
client_invoices = list(Invoice.all())
medium_invoices = list(MediumInvoice.all())
medium_invoice_pays = list(MediumInvoicePay.all())
medium_invoice_rebate_invoice = list(MediumRebateInvoice.all())
agent_invoices = list(AgentInvoice.all())
agent_invoice_pays = list(AgentInvoicePay.all())
back_moneys = list(BackMoney.all())
back_money_rebates = list(BackInvoiceRebate.all())
now_date = datetime.datetime.now()
info = request.values.get('info', '').strip()
location = int(request.values.get('location', 0))
year = request.values.get('year', now_date.strftime('%Y'))
month = request.values.get('month', now_date.strftime('%m'))
if month != '00':
search_date = datetime.datetime.strptime(
str(year) + '-' + str(month), '%Y-%m')
orders = set([k.client_order for k in ClientOrderExecutiveReport.query.filter_by(
month_day=search_date) if k.status == 1])
else:
orders = [k for k in ClientOrder.all() if k.client_start.year == int(
year) or k.client_end.year == int(year)]
if location != 0:
orders = [k for k in orders if location in k.locations]
if info:
orders = [k for k in orders if info in k.search_info]
orders = sorted(list(orders), key=lambda x: x.client_start, reverse=False)
for order in orders:
order.pass_invoice_sum = sum(
[k.money for k in client_invoices if k.invoice_status == 0 and k.client_order == order])
order.back_money_sum = sum(
[k.money for k in back_moneys if k.client_order == order])
order.back_money_rebate_sum = sum(
[k.money for k in back_money_rebates if k.client_order == order])
order.agent_invoice_sum = sum(
[k.money for k in agent_invoices if k.client_order == order])
agent_invoice_pay_sum = 0.0
invoices = [k for k in agent_invoices if k.client_order == order]
for invoice in invoices:
agent_invoice_pay_sum += sum(
[k.money for k in agent_invoice_pays if k.pay_status == 0 and k.agent_invoice == invoice])
order.agent_invoice_pay_sum = agent_invoice_pay_sum
order.medium_invoice_sum = sum(
[k.money for k in medium_invoices if k.client_order == order])
invoices = [k for k in medium_invoices if k.client_order == order]
order.medium_invoice_pay_sum = sum(
[k.money for k in medium_invoice_pays if k.pay_status == 0 and k.medium_invoice in invoices])
order.medium_invoice_rebate_invoice_sum = sum(
[k.money for k in medium_invoice_rebate_invoice if k.client_order == order and k.invoice_status == 0])
for m in order.medium_orders:
m.medium_invoice_sum = sum(
[k.money for k in medium_invoices if k.client_order == order and k.medium == m.medium])
m_invoices = [
k for k in medium_invoices if k.client_order == order and k.medium == m.medium]
m.medium_invoice_pay_sum = sum(
[k.money for k in medium_invoice_pays if k.pay_status == 0 and k.medium_invoice in m_invoices])
m.medium_invoice_rebate_invoice_sum = sum(
[k.money for k in medium_invoice_rebate_invoice if k.client_order == order and
k.invoice_status == 0 and k.medium == m.medium])
if request.values.get('action', '') == 'download':
response = write_order_excel(list(orders))
return response
return tpl('cost.html', orders=orders, location=location,
year=year, month=month, info=info)