# coding:utf-8
'''
created on 2019/1/17
@author:sunyihuan
'''
from utils import connect_mongodb_sheji, ts2utcdatetime, id2ObjectId
import xlwt
import pymongo
mdb = connect_mongodb_sheji()
# 2018年10月1日开始
wangluo_counts = mdb.xm_hair_need.find({
"status": 101,
"source": 2,
"ctime": {
"$gt": ts2utcdatetime(1538323200)
}
}).count()
xianchang_counts = mdb.xm_hair_need.find({"status": 101, "source": 1}).count()
def writeHead_wangluo(sh):
sh.write(0, 2, "three_court")
sh.write(0, 3, "face_length")
sh.write(0, 4, "face_sense")
sh.write(0, 5, "face_shape")
sh.write(0, 6, "natural_style")
sh.write(0, 7, "height")
def changJing_data(day_time_start):
'''
返回某一日数据看板中的数据
:param day_time_start: 日期，格式为："2018-12-21"
:return:
sheji_st：设计沟通场景日活,
sheji_st_vip：设计沟通场景VIP日活,
poster_st：营销拓客场景日活,
poster_st_vip：营销拓客场景VIP日活,
stylists：美助app日活,
stylists_yes：美助app昨日留存,
stylists_vip：美助app中VIP日活
'''
mdb = connect_mongodb_sheji() # 链接sheji
star_timeStamp = day2timestamp(day_time_start)
vip_st = mdb.wxuser.distinct("_id", {"expireat": {
"$gt": star_timeStamp
}}) # vip列表
vip_st = list_change_type(int, vip_st)
poster_st = mdb.log_poster.distinct(
"uid",
{"ctime": {
"$gt": star_timeStamp,
"$lt": star_timeStamp + 86400
}}) # 使用海报发型师uv
fxcl_st = mdb.log_material.distinct(
"uid",
{"ctime": {
"$gt": star_timeStamp,
"$lt": star_timeStamp + 86400
}}) # 使用海报发型师uv
poster_st = set(poster_st) | set(fxcl_st)
poster_st = list_change_type(int, poster_st)
stylist_one = mdb.xm_hair_scheme.distinct(
"myid", {
"utime": {
"$gte": ts2utcdatetime(star_timeStamp + 0 * 86400),
"$lt": ts2utcdatetime(star_timeStamp + 86400)
},
"is_finish": 1
}) # 完成订单发型师
stylist_one = list_change_type(int, stylist_one)
stylist_t = mdb.xm_good_hair.distinct(
"myid", {
"utime": {
"$gte": ts2utcdatetime(star_timeStamp + 0 * 86400),
"$lt": ts2utcdatetime(star_timeStamp + 86400)
},
"status": 1
}) # 收藏发型的发型师
stylist_t = list_change_type(int, stylist_t)
sheji_st = set(stylist_one) | set(stylist_t) # 设计沟通场景发型师日活
sheji_st = list_change_type(int, sheji_st)
sheji_st_vip = (set(stylist_one) | set(stylist_t)) & set(
vip_st) # 设计沟通场景发型师VIP日活
poster_st_vip = set(vip_st) & set(poster_st) # 使用海报发型师中VIP的人数
stylists = seven_day_stylist(star_timeStamp,
star_timeStamp + 86400) # 美业助手app当日uv
stylists_yestday = seven_day_stylist(star_timeStamp - 86400,
star_timeStamp) # 美业助手app昨日uv
vip_st = list_change_type(str, vip_st)
stylists_yes = set(stylists) & set(stylists_yestday) # 次日留存人数
stylists_vip = set(stylists) & set(vip_st) # 美业助手app当日VIP日活
return sheji_st, sheji_st_vip, poster_st, poster_st_vip, stylists, stylists_yes, stylists_vip