def entity_codes_down(request):
"""
下载券码
@return
"""
code_main_id = request.GET.get('id', '')
if code_main_id:
g_data = []
filename = 'No.%s_codes.txt' % code_main_id
redeem_code_url = PtConst.CREATECODES
para = {'id': code_main_id}
r = requests.get(redeem_code_url, params=para)
r_data = r.json()
csv_data = [[
"cardSeqNo", "cardPwd", "qrCode", "status", "exchangeTime",
"creteTime"
]]
for obj in r_data['data']:
if obj:
g_data.append([
str(obj['cardSeqNo']),
str(obj['cardPwd']),
str(obj['qrCode']),
str(obj['status']),
str(obj['exchangeTime']),
str(obj['creteTime']),
])
csv_data.extend(g_data)
return get_csv_response(filename, csv_data)
return JsonResponse({'code': '-1', 'msg': '无参数'})
def invite_csv(request):
start_date = request.GET.get("start_date")
end_date = request.GET.get("end_date")
key = request.GET.get("key")
key = key.strip(' ')
key = key.strip('\t')
whos = request.GET.get("who")
end_date_d = datetime.datetime.strptime(
end_date, "%Y-%m-%d") + datetime.timedelta(days=1)
# csv_da = filter_invite_list(start_date, end_date_d, key, int(whos))
if whos == '0':
who = '邀请人'
csv_data = [[
"PTUID",
"用户手机号",
"邀请注册成功人数",
"首单下单成功人数",
"首单服务完成人数",
"获券总额",
"修改时间",
]]
elif whos == '1':
who = '被邀请人'
csv_data = [[
"PTUID", "被邀请人手机号", "获券/注册时间", "首单下单成功时间", "首单服务完成时间", "获券总额",
"邀请人手机号"
]]
else:
return
filename = '%s%s(%s-%s).csv' % (str(who), str(key), str(start_date),
str(end_date))
csv_data.extend(csv_da)
return get_csv_response(filename, csv_data)
def invite_detail_csv(request):
ptuid = request.GET.get("pt_uid")
csv_d = cursor_data(ptuid)
csv_data = [[
"PTUID", "邀请人获券", "被邀请人获券面值", "被邀人获券时间", "被邀人手机号", "被邀人获券", "被邀人获券时间"
]]
filename = '邀请人详情(%s).csv' % (str(ptuid))
csv_data.extend(csv_d)
return get_csv_response(filename, csv_data)
def phone_fee_goods_management_csv(request):
filename = 'phone_fee_product_list.csv'
csv_data = [[
u"排序",
u"状态",
u"供应商",
u"省份",
u"运营商",
u"面值",
u"售价",
u"进货价",
u"提示语",
]]
csv_data.extend(g_data)
return get_csv_response(filename, csv_data)
def daojia_coupon_detail_csv(request):
start_date = request.GET.get("start_date")
end_date = request.GET.get("end_date")
filename = '%s(%s-%s).csv' % ("到家优惠券明细", str(start_date), str(end_date))
csv_data = [[
"CP名称",
"CP_ID",
"订单号",
"优惠券编号",
"活动名称",
"优惠券实耗",
"葡萄承担成本",
"CP承担成本",
]]
csv_data.extend(g_data)
return get_csv_response(filename, csv_data)
def order_coupons_query_csv(request):
"""
获取csv
:param request:
:return:
"""
start_date = request.GET.get("start_date")
end_date = request.GET.get("end_date")
key = request.GET.get("key")
csv_data = [[
"ID", "PTUID", "用户手机号", "优惠券ID", "优惠券名称", "面额", "使用限制", "使用说明", "参与活动",
"优惠券领取时间", "优惠券截止日期", "优惠券使用时间", "订单号", "优惠券使用商品名称"
]]
filename = '优惠券列表%s(%s-%s).csv' % (str(key), str(start_date),
str(end_date))
csv_data.extend(g_data)
return get_csv_response(filename, csv_data)