def getMaxtime(self, equipment):
lastRow = yyyBrowseModel.objects.filter(equipment=equipment).values('data').order_by('-data').first()
lastTimestamp = timeHelper.datetime2Timestamp(lastRow['data'])
nowTimestamp = lastTimestamp + 3600
nowDateTime = timeHelper.getFormatDate('now', nowTimestamp)
beforeDateTime = timeHelper.getFormatDate('now', lastTimestamp)
return {'now': nowDateTime, 'before': beforeDateTime}
def subscribe(request):
startDate = request.GET.get('startDate', '')
endDate = request.GET.get('endDate', '')
if not startDate:
startDate = timeHelper.getFormatDate('start')
if not endDate:
endDate = timeHelper.getFormatDate('end')
subscribePieData = peanutService().getSubscribePieRangeData([startDate, endDate])
data = {"data": [subscribePieData], "startDate": startDate, "endDate": endDate}
return baseView.urlRender(request, 'peanut_subscribe.html', data, "peanut")
def register(request):
startDate = request.GET.get('startDate', '')
endDate = request.GET.get('endDate', '')
if not startDate:
startDate = timeHelper.getFormatDate('start')
if not endDate:
endDate = timeHelper.getFormatDate('end')
registerPieData = yiyiyuanService().getRegisterPieRangeData(
[startDate, endDate])
data = {
"data": [registerPieData],
"startDate": startDate,
"endDate": endDate
}
return baseView.urlRender(request, 'yiyiyuan_register.html', data,
"yiyiyuan")
def saveRegister(self, register_num, equipment, data):
haveData = yyyRegisterModel.objects.filter(data=data, equipment=equipment, register_num=register_num).count()
if haveData == 0:
yyyRegisterModel(
register_num = register_num,
equipment = equipment,
create_time = timeHelper.getFormatDate('now'),
data = data,
).save()
def saveBrowse(self, page_name, browse_num, equipment, data):
haveData = yyyBrowseModel.objects.filter(data=data, equipment=equipment, page_name=page_name, browse_num=browse_num).count()
if haveData == 0:
yyyBrowseModel(
page_name=page_name,
browse_num=browse_num,
equipment=equipment,
create_time=timeHelper.getFormatDate('now'),
data=data,
).save()
def index(request):
# 获取今天的起止时间
todayStart = timeHelper.getFormatDate('start')
todayEnd = timeHelper.getFormatDate('end')
# 获取昨天的起止时间
yesterdayStart = timeHelper.getFormatDate(
'start', timeHelper.getTimestamp(-60 * 60 * 24))
yesterdayEnd = timeHelper.getFormatDate(
'end', timeHelper.getTimestamp(-60 * 60 * 24))
dayRange = {
"today": [todayStart, todayEnd],
"yesterday": [yesterdayStart, yesterdayEnd]
}
# 获取天维度的数据
peanutDayData = peanut().getDayData(dayRange)
yiyiyuanDayData = yiyiyuan().getDayData(dayRange)
# 获取今天的是周几
num = timeHelper.getWeekNum()
# 获取这周的起止时间
thisWeekStart = timeHelper.getFormatDate(
'start', timeHelper.getTimestamp(-60 * 60 * 24 * num))
thisWeekStartEnd = timeHelper.getFormatDate('end')
# 获取上周的起止时间
lastWeekStart = timeHelper.getFormatDate(
'start', timeHelper.getTimestamp(-60 * 60 * 24 * (num + 7)))
lastWeekEend = timeHelper.getFormatDate(
'end', timeHelper.getTimestamp(-60 * 60 * 24 * (num + 1)))
weekRange = {
"thisWeek": [thisWeekStart, thisWeekStartEnd],
"lastWeek": [lastWeekStart, lastWeekEend]
}
# 获取周维度的数据
peanutWeekData = peanut().getWeekData(weekRange)
yiyiyuanWeekData = yiyiyuan().getWeekData(weekRange)
data = {
"peanutData": {
'name': '花生米富',
'dayData': peanutDayData,
'weekData': peanutWeekData,
},
"yiyiyuanData": {
'name': '先花一亿元',
'dayData': yiyiyuanDayData,
'weekData': yiyiyuanWeekData,
},
}
# 跳转到展示页面
return baseView.urlRender(request, 'index.html', data, "index")
def saveBid(self, bidNum, bidType, equipment, data):
haveData = peanutBidModel.objects.filter(data=data,
equipment=equipment,
bid_type=bidType,
bid_num=bidNum).count()
if haveData == 0:
peanutBidModel(
bid_num=bidNum,
bid_type=bidType,
equipment=equipment,
create_time=timeHelper.getFormatDate('now'),
data=data,
).save()
def browse(request):
startDate = request.GET.get('startDate')
endDate = request.GET.get('endDate')
if not startDate:
startDate = timeHelper.getFormatDate('start')
if not endDate:
endDate = timeHelper.getFormatDate('end')
pageId = int(request.GET.get('pageId', -1))
equipment = int(request.GET.get('equipment', -1))
timeRange = [startDate, endDate]
page = request.GET.get('page', 1)
getBrowseData = peanutService().getBrowseData(timeRange, pageId, equipment, page)
print(equipment)
data = {
"pageNameList": getBrowseData['pageNameList'].items(),
"contacts": getBrowseData['contacts'],
"pageId": pageId,
"equipment": equipment,
"startDate": startDate,
"endDate": endDate
}
return baseView.urlRender(request, 'peanut_browse.html', data, "peanut")
def savePageName(self, pageName):
data = peanutPageNameModel.objects.all().aggregate(
valueId=models.Max('page_name_id'))
valueId = data.get('valueId') if data.get('valueId') != None else 0
valueId += 1
now = timeHelper.getFormatDate('now')
ob = peanutPageNameModel(page_name_id=valueId,
page_name=pageName,
create_time=now)
ob.save()
if ob.id != None:
return ob.page_name_id
else:
return 0
def register(self, user_name, user_pwd):
# 查询用户名是否被注册
user = logchartUser.objects.filter(user_name=user_name).all()
if len(user) != 0:
return False
else:
user = logchartUser()
# 名字
user.user_name = user_name
# 时间
user.creat_time = timeHelper.getFormatDate('now')
# 加密密码
user.user_pwd = make_password(user_pwd)
# 保存
user.save()
return True
def pageNameSave(self, page_name):
now = timeHelper.getFormatDate('now')
ob = yyyAndroidPageNameModel(page_name_id=0,
page_name=page_name,
create_time=now)
ob.save()
def peanurUsertask():
yesterday = timeHelper.getFormatDate("none", timeHelper.getTimestamp(-86400))
importPeanutUser().doImport(str(yesterday), True)
def pageNameSave(self, page_name):
now = timeHelper.getFormatDate('now')
ob = peanutWeixinPageNameModel(page_name_id=0,
page_name=page_name,
create_time=now)
ob.save()
