def rebate_export(r):
start, num = get_paginator(r)
params = r.REQUEST
condition = make_conditions(r, type='type', bankcard_id='bankcard_id', verify_status='verify_status')
if 'create_time_start' in params:
condition['create_time__gte'] = get_stamp_by_date(params['create_time_start'])
if 'create_time_end' in params:
condition['create_time__lte'] = get_stamp_by_date(params['create_time_end'])
if 'user_id' in r.REQUEST:
condition['bankcard__user_id'] = r.REQUEST['user_id']
withdraws = Withdraw.objects.filter(**condition)
data = []
for wit in withdraws:
d = {}
d['account_id'] = wit.bankcard.account_id
d['owner_name'] = wit.bankcard.owner_name
if wit.type == Const['model.withdraw.type.principal']:
d['amount'] = wit.amount
else:
d['amount'] = wit.reward
d['bank_name'] = wit.bankcard.bank_name
d['account_name'] = wit.bankcard.account_name
d['bank_city'] = wit.bankcard.bank_city
data.append(d)
metas = {
'account_id': u'收款卡号',
'owner_name': u'收款用户',
'amount': u'返款金额',
'bank_name': u'收款银行',
'account_name': u'收款支行',
'bank_city': u'归属',
}
return CsvResponse(metas, data)
def home_capital(request):
user, last_notice = _home_init(request)
user.notice_set(Const['model.remind.principal'], False)
params = request.REQUEST
page = int(params['page']) if 'page' in params else 1
num = int(params['num']) if 'num' in params else 10
start = (page - 1) * num
timestamp = before15(30)
conditions = make_conditions(request)
conditions['user_id'] = user.id
if 'create_time_start' in params or 'create_time_end' in params:
if 'create_time_start' in params:
conditions['create_time__gte'] = get_stamp_by_date(
params['create_time_start'])
if 'create_time_end' in params:
conditions['create_time__lte'] = get_stamp_by_date(
params['create_time_end'])
else:
conditions['create_time__gte'] = 0
if 'capital_type' in params:
if int(params['capital_type']) == 0:
conditions['amount__lte'] = 0.0
elif int(params['capital_type']) == 1:
conditions['amount__gte'] = 0.0
query = Record.objects.filter(**conditions)
pagebar = _pagebar_obj(query.count(), page, num)
records = query[start:start + num]
return render(request, 'home/home_capital.html', locals())
def user_listidc(r):
start, num = get_paginator(r)
condition = make_conditions(r, id='user_id', verify_status='verify_status')
if 'register_start_time' in r.REQUEST:
condition['register_time__gte'] = get_stamp_by_date(
r.REQUEST['register_start_time'])
users = User.objects.exclude(idc_name='').filter(**condition)[start:start +
num]
logger.debug(users.query)
total = User.objects.exclude(idc_name='').filter(**condition).count()
data = []
for u in users:
try:
idcphotos = json.loads(u.idc_photo)
except Exception:
idcphotos = [None, None]
data.append({
'user_id': u.id,
'register_time': u.register_time,
'user_name': u.idc_name,
'idc_photo1': idcphotos[0],
'idc_photo2': idcphotos[1],
'verify_status': u.verify_status,
})
return JsonResponse(code=Const['code.success'],
data={
'total': total,
'users': data
})
def withdraw_list(r):
start, num = get_paginator(r)
params = r.REQUEST
condition = make_conditions(r, type='type', bankcard_id='bankcard_id', verify_status='verify_status')
if 'create_time_start' in params:
condition['create_time__gte'] = get_stamp_by_date(params['create_time_start'])
if 'create_time_end' in params:
condition['create_time__lte'] = get_stamp_by_date(params['create_time_end'])
if 'user_id' in r.REQUEST:
condition['bankcard__user_id'] = r.REQUEST['user_id']
withdraws = Withdraw.objects.filter(**condition)[start:start + num]
total = Withdraw.objects.filter(**condition).count()
data = []
for wit in withdraws:
d = wit.to_dict()
if wit.reward == 0:
d['reward'] = wit.amount
d['bank_name'] = wit.bankcard.bank_name
d['bank_city'] = wit.bankcard.bank_city
d['owner_name'] = wit.bankcard.owner_name
d['account_id'] = wit.bankcard.account_id
d['account_name'] = wit.bankcard.account_name
d['user_id'] = wit.bankcard.user_id
d['user_qq'] = wit.bankcard.user.qq
d['user_name'] = wit.bankcard.user.idc_name
d['user_phone'] = wit.bankcard.user.phone
d['create_time'] = wit.create_time
data.append(d)
return JsonResponse(code=Const['code.success'],
data={'total': total, 'withdraws': data})
def user_capitalrecordexport(r, uid):
conditions = make_conditions(r)
conditions['user_id'] = uid
params = r.REQUEST
if 'create_time_start' in params or 'create_time_end' in params:
if 'create_time_start' in params:
conditions['create_time__gte'] = get_stamp_by_date(
params['create_time_start'])
if 'create_time_end' in params:
conditions['create_time__lte'] = get_stamp_by_date(
params['create_time_end'])
else:
conditions['create_time__gte'] = 0
if 'capital_type' in params:
if int(params['capital_type']) == 0:
conditions['amount__lte'] = 0.0
elif int(params['capital_type']) == 1:
conditions['amount__gte'] = 0.0
query = Record.objects.filter(**conditions)
data = []
for o in query:
data.append({
'time': get_datetime_by_stamp(o.create_time),
'type': u'收入' if o.is_income() else u'支出',
'content': o.description,
'amount': o.amount,
})
return CsvResponse(
{
'time': u'时间',
'type': u'收支类型',
'content': u'描述',
'amount': u'金额',
}, data)
def tbaccount_list(r):
start, num = get_paginator(r)
condition = make_conditions(r, user_id='user_id', status='verify_status')
if 'register_start_time' in r.REQUEST:
condition['user__register_time__gte'] = get_stamp_by_date(
r.REQUEST['register_start_time'])
tbs = TBAccount.objects.filter(**condition)[start:start + num]
total = TBAccount.objects.filter(**condition).count()
data = []
for t in tbs:
d = t.to_dict()
try:
pics = json.loads(t.pic_paths)
except Exception:
pics = [None, None]
if not isinstance(pics, list):
pics = [None, None]
# 获取user的身份证姓名信息，如果没有提交，那么使用旺旺号码
idc_name = t.user.idc_name
if (idc_name):
d['name'] = idc_name
else:
d['name'] = u'未绑定身份证--' + d['name']
d['pic1'] = pics[0]
d['pic2'] = pics[1]
d['register_time'] = t.user.register_time
d['tb_register_time'] = t.register_time # 旺旺注册时间
data.append(d)
return JsonResponse(code='code.success',
data={
'total': total,
'tbaccounts': data
})
def notice_modify(r, nid):
notice = Notice.objects.get(pk=nid)
conditions = make_conditions(r, content='content', url='url', pic_path='pic_path', important='important')
if 'important' in conditions:
conditions['important'] = bool(int(conditions['important']))
conditions['update_time'] = msec_time()
obj_modify(notice, conditions)
notice.save()
return JsonResponse(code=Const['code.success'])
def recharge_list(r):
start, num = get_paginator(r)
condition = make_conditions(r, user_id='user_id', verify_status='verify_status')
recharges = Recharge.objects.filter(**condition)[start:start + num]
total = Recharge.objects.filter(**condition).count()
data = []
for rec in recharges:
d = rec.to_dict()
d['user_qq'] = rec.user.qq
d['user_name'] = rec.user.idc_name
d['user_phone'] = rec.user.phone
data.append(d)
return JsonResponse(code=Const['code.success'],
data={'total': total, 'recharges': data})
def bankcard_modify(r, bid):
conditions = make_conditions(r,
bank_name='bank_name',
bank_city='bank_city',
bank_province='bank_province',
bank_district='bank_district',
owner_name='owner_name',
account_id='account_id',
account_name='account_name')
bks = Bankcard.objects.filter(account_id=conditions['account_id'])
if len(bks) > 0 and bks[0].id != bid:
return JsonResponse(code=Const['code.bankcard.repeat'])
bankcard = Bankcard.objects.get(pk=bid)
for key in conditions:
setattr(bankcard, key, conditions[key])
bankcard.verify_status = Const['model.verify.need_check']
bankcard.save()
return JsonResponse(code=Const['code.success'])
def user_listaccount(r):
start, num = get_paginator(r)
condition = make_conditions(r, id='user_id')
total = User.objects.filter(**condition).count()
users = User.objects.filter(**condition)[start:start + num]
data = []
for u in users:
data.append({
'principal': u.principal,
'commission': u.commission,
'is_close_seller_return': u.is_close_sellerreturn,
'user_id': u.id
})
return JsonResponse(code=Const['code.success'],
data={
'total': total,
'users': data
})
def bankcard_list(r):
start, num = get_paginator(r)
condition = make_conditions(r,
user_id='user_id',
verify_status='verify_status')
if 'register_start_time' in r.REQUEST:
condition['user__register_time__gte'] = get_stamp_by_date(
r.REQUEST['register_start_time'])
bankcards = Bankcard.objects.filter(**condition)[start:start + num]
total = Bankcard.objects.filter(**condition).count()
data = []
for b in bankcards:
d = b.to_dict()
d['register_time'] = b.user.register_time
data.append(d)
return JsonResponse(code='code.success',
data={
'total': total,
'bankcards': data
})
def user_list(r):
start, num = get_paginator(r)
conditions = make_conditions(r,
pk='user_id',
phone='phone',
qq='qq',
buyer_level='buyer_level',
register_time='register_time')
if 'register_time' in conditions:
conditions['register_time'] = get_stamp_by_date(
conditions['register_time'])
total = User.objects.filter(**conditions).count()
users = User.objects.filter(**conditions)[start:start + num]
data = []
for u in users:
try:
idcphotos = json.loads(u.idc_photo)
except Exception:
idcphotos = [None, None]
data.append({
'id': u.id,
'register_time': u.register_time,
'user_name': u.idc_name,
'phone': u.phone,
'qq': u.qq,
'buyer_level': u.buyer_level,
'seller_level': u.seller_level,
'idc_photo1': idcphotos[0],
'idc_photo2': idcphotos[1],
'verify_status': u.verify_status,
'principal': u.principal,
'commission': u.commission,
'flags': u.flag_dump(),
})
return JsonResponse(code=Const['code.success'],
data={
'total': total,
'users': data
})
def record_list(r):
start, num = get_paginator(r)
condition = make_conditions(r,
user_id='user_id',
start_time='start_time',
end_time='end_time')
if 'start_time' in condition:
condition['create_time__gte'] = get_stamp_by_date(
condition['start_time'])
if 'end_time' in condition:
condition['create_time__lte'] = get_stamp_by_date(
condition['end_time'])
total = Record.objects.filter(**sub_dict(
condition, 'user_id', 'create_time__lte', 'create_time__gte')).count()
records = Record.objects.filter(
**sub_dict(condition, 'user_id', 'create_time__lte',
'create_time__gte'))[start:start + num]
return JsonResponse(code=Const['code.success'],
data={
'total': total,
'records': [re.to_dict() for re in records]
})
def tbaccount_modify(r, tid):
conditions = make_conditions(r,
wangwang='wangwang',
name='name',
phone='phone',
city='city',
address='address',
pic_paths='pic_paths',
register_time='register_time',
gender='gender',
age='age',
is_credit_card_open='is_credit_card_open',
wangwang_level='wangwang_level',
is_huabei_open='is_huabei_open')
tbs = TBAccount.objects.filter(wangwang=conditions['wangwang'])
if len(tbs) > 0 and tbs[0].id != tid:
return JsonResponse(code=Const['code.tbaccount.exist'])
tbaccount = TBAccount.objects.get(pk=tid)
for key in conditions:
setattr(tbaccount, key, conditions[key])
tbaccount.status = Const['model.verify.need_check']
tbaccount.save()
return JsonResponse(code=Const['code.success'])
def user_exportorders(r, uid):
conditions = make_conditions(r,
task__store_id='store_id',
tb__wangwang='buyer_wangwang',
task_id='task_id',
tb__user_id='buyer_id',
order_type='order_type')
params = r.REQUEST
conditions['task__store__user_id'] = uid
if 'receive_start' in params:
conditions['receive_time__gte'] = get_stamp_by_date(
params['receive_start'])
if 'receive_end' in params:
conditions['receive_time__lte'] = get_stamp_by_date(
params['receive_end'])
if 'order_status' in params:
if params['order_status'] == '1':
conditions['status__in'] = [
Const['model.order.status.received'],
Const['model.order.status.step1'],
Const['model.order.status.step2'],
Const['model.order.status.step9']
]
elif params['order_status'] == '2':
conditions['status__in'] = [
Const['model.order.status.step3'],
Const['model.order.status.returnmoney']
]
elif params['order_status'] == '3':
conditions['status'] = Const['model.order.status.deliver']
elif params['order_status'] == '4':
conditions['status'] = Const['model.order.status.comment']
elif params['order_status'] == '5':
conditions['status'] = Const['model.order.status.completed']
if 'o_type' in params:
if params['o_type'] == 'flow':
conditions['order_type__in'] = [
Const['model.order.type.flow'],
Const['model.order.type.collect']
]
elif params['o_type'] == 'buy_order':
conditions['order_type__in'] = [0, 1, 2, 5, 6]
orders = Order.objects.exclude(status__in=[
Const['model.order.status.init'], Const['model.order.status.cancel']
]).filter(**conditions)
logger.debug(orders.query)
data = []
for o in orders:
t = o.task
bk = o.bankcard
commodities = json.loads(t.commodities)
search_entry = json.loads(t.search_entries)[
o.search_entry_index] if o.search_entry_index >= 0 else None
bc = o.get_buyer_commit()
sc = o.get_seller_commit()
data.append({
'order_id':
o.id,
'receive_time':
get_datetime_by_stamp(o.receive_time),
'buyer_id':
o.tb.user_id,
'buyer_wangwang':
o.tb.wangwang,
'task_type':
o.get_display_type(),
'order_status':
o.get_display_status(),
'total_price':
t.total_price,
'buyer_commit':
bc if bc else '',
'seller_commit':
sc if sc else '',
'store_name':
t.store.name,
'commodity_name':
commodities[0]['name'],
'search_keyword':
search_entry['keyword'] if search_entry else '',
'bk_name':
bk.owner_name if bk else '',
'bk_bank':
bk.bank_name if bk else '',
'bk_account':
bk.account_id if bk else '',
'bk_city':
bk.bank_city if bk else '',
'bk_zh':
bk.account_name if bk else '',
'order_all_pay':
o.seller_payment,
})
return CsvResponse(
{
'order_id': u'订单ID',
'receive_time': u'接单时间',
'buyer_id': u'买手ID',
'buyer_wangwang': u'买手旺旺',
'task_type': u'订单类型',
'order_status': u'订单状态',
'total_price': u'商家要求垫付金额',
'buyer_commit': u'买手实际垫付金额',
'seller_commit': u'商家实际返款金额',
'store_name': u'店铺名',
'commodity_name': u'商品名',
'search_keyword': u'搜索关键词',
'bk_name': u'返款人姓名',
'bk_bank': u'返款银行名',
'bk_account': u'返款账户',
'bk_city': u'返款银行所在地',
'bk_zh': u'返款银行支行',
'order_all_pay': u'商家支付总额（包括佣金）',
}, data)
