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)