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()