def user_watch_info():
print "user watch info..."
try:
title_name_ = "user_watch_info.csv"
user_watch = UserWatchInfo.objects.all()
row_title = ['id', '昵称','视频名称','观看时间', '是否PC登陆']
data = []
data.append(row_title)
if getLen(user_watch) > 0:
for uw in user_watch:
row = []
row.append(uw.id)
row.append(uw.account.nickname)
row.append(uw.video.title)
row.append(str(uw.release_date).split('+')[0])
if uw.pc_flag == 1:
row.append('是')
else:
row.append('否')
data.append(row)
filepath = write_csv(title_name_, data)
return filepath
except Exception, e:
print "Excel, user_watch_info: ", str(e)
return -1
def users_info():
try:
title_name_ = "users.csv"
accounts = Account.objects.all()
row_title = ["id", "昵称", "性别",
"个性签名", "购买数量", "收藏数量","购物车数量", "上次登陆时间"]
data = []
data.append(row_title)
if getLen(accounts) > 0:
for acc in accounts:
try:
row = []
row.append(acc.id)
row.append(acc.nickname)
row.append(acc.sex)
row.append(acc.info)
row.append(get_paid_num(acc.user))
row.append(get_collect_num(acc.user))
row.append(get_unpay_num(acc.user))
last_login = str(acc.user.last_login).split('+')
if last_login == []:
row.append("")
else:
row.append(last_login[0])
data.append(row)
except Exception, e:
print "userinfo: ", str(e)
filepath = write_csv(title_name_, data)
return filepath
def user_order_info():
print "user order info..."
try:
title_name_ = "user_order_info.csv"
user_order = UserOrderInfo.objects.all()
row_title = ['id', '昵称','视频名称','订单号', '价格', '是否付款', '下单时间', '是否PC登陆']
data = []
data.append(row_title)
if getLen(user_order) > 0:
for uo in user_order:
row = []
row.append(uo.id)
row.append(uo.account.nickname)
row.append(uo.order.video.title)
row.append(uo.order.id)
row.append(uo.order.price)
if uo.order.pay_state == 2:
row.append('是')
else:
row.append('否')
row.append(str(uo.release_date).split('+')[0])
if uo.pc_flag == 1:
row.append('是')
else:
row.append('否')
data.append(row)
filepath = write_csv(title_name_, data)
return filepath
except Exception, e:
print "Excel, user_order_info: ", str(e)
return -1
def get_datainfo_given_title(title):
data_info = DataInfo.objects.all()
if getLen(data_info) > 0:
for line in data_info:
if line.title.encode('utf-8') == title:
return line
title_info = DataInfo()
title_info.title = title
title_info.filename = ""
title_info.modify_datetime = str(datetime.datetime.now()).split('.')[0]
title_info.save()
return title_info
