Ejemplo n.º 1
0
    def POST(self):
        data = web.input()
        start = int(data["start"])
        length = int(data["length"])
        starttime = data['starttime'].replace('/', '').replace(
            ' ', '').replace(':', '') + '00'
        endtime = data["endtime"].replace('/', '').replace(' ', '').replace(
            ':', '') + '00'
        devid = data['devid']
        userid = data['userid']
        draw = int(data['draw'])
        ordernum = int(data['order[0][column]'])
        orderstyle = data['order[0][dir]']
        ids = devid.split(',')
        result = []
        count = 0

        for id in ids:
            #conditions = dict()
            #conditions['devid'] = id
            #conditions['time'] = {'$lte':endtime,'$gte':starttime}
            #maxitem = data_model('devpower_detail').find(conditions=conditions,sort=sort1,limit=1)
            #minitem = data_model('devpower_detail').find(conditions=conditions,sort=sort2,limit=1)
            finddata = common.getPowerinfo(id, starttime, endtime)
            if len(finddata) == 0:
                continue
            else:
                count += 1
                temp = []
                max = finddata[-1]
                min = finddata[0]
                maxW = float('%0.4f' % max['W'])
                minW = float('%0.4f' % min['W'])
                maxTime = max['time']
                minTime = min['time']
                power = maxW - minW
                power = float('%0.4f' % power)
                temp.append(id)
                temp.append(power)
                temp.append(minW)
                temp.append(common.strTimeToFormat(minTime))
                temp.append(maxW)
                temp.append(common.strTimeToFormat(maxTime))
                result.append(temp)

        data = {
            "draw": draw,
            "recordsTotal": count,
            "recordsFiltered": count,
            "aaData": result
        }
        data = json.dumps(data)
        return data
Ejemplo n.º 2
0
def getPower_detail(starttime, endtime, devid, start, length, draw):
    finddata = common.getPowerinfo(devid, starttime, endtime)
    count = len(finddata)
    starti = 0
    result = dict()
    resultlist = []
    for item in finddata:
        if starti != start:
            starti += 1
            continue
        del item["_id"]
        if "tablename" in item.keys():
            del item["tablename"]
        keys = item.keys()
        temp = []
        for key in keys:
            if key.lower().find("time") != -1:
                item[key] = common.strTimeToFormat(item[key])
            if isinstance(item[key], dict):
                item[key] = unparse.dictTostr(item[key])
            if key == "_id":
                item[key] = str(item[key])
            temp.append(item[key])
        resultlist.append(temp)
        if len(resultlist) == length:
            break
    result = {
        "draw": draw,
        "recordsTotal": count,
        "recordsFiltered": count,
        "aaData": resultlist
    }
    return result
Ejemplo n.º 3
0
def getPower(starttime, endtime, devid, type):
    result = []
    sort = [('time', 1)]
    data = common.getPowerinfo(devid, starttime, endtime)
    time1 = starttime
    power = 0
    for item in data:
        temp = {}
        time2 = item['time']
        temp['key'] = common.strTimeToFormat(item['time'])
        if type == 'power':
            temp['value'] = float('%0.4f' % (float(item['W'])))
            result.append(temp)
            time1 = time2
            power = float('%0.4f' % (float(item['W'])))
        elif type == 'efficiency':
            a = datetime.datetime.strptime(time2, '%Y%m%d%H%M%S')
            b = datetime.datetime.strptime(time1, '%Y%m%d%H%M%S')
            if (a - b).seconds > 600:  #两个时间差大于10分钟在这段时间内每隔5分钟填充个0
                while b < a:
                    temp1 = {}
                    temp1['key'] = common.strTimeToFormat(
                        b.strftime('%Y%m%d%H%M%S'))
                    temp1['value'] = 0
                    result.append(temp1)
                    b = b + datetime.timedelta(seconds=600)
            temp['value'] = int(item['P'])
            result.append(temp)
            time1 = time2
    a = datetime.datetime.strptime(endtime, '%Y%m%d%H%M%S')
    b = datetime.datetime.strptime(time1, '%Y%m%d%H%M%S')
    timeflag = time1[:8]
    if (a - b).seconds > 600:  #两个时间差大于10分钟在这段时间内每隔5分钟填充个0
        while b < a:
            temp1 = {}
            temp1['key'] = common.strTimeToFormat(b.strftime('%Y%m%d%H%M%S'))
            if type == 'efficiency':
                temp1['value'] = 0
            elif type == 'power':
                if b.strftime('%Y%m%d%H%M%S')[:8] == timeflag:
                    temp1['value'] = power
                else:
                    temp1['value'] = 0
            result.append(temp1)
            b = b + datetime.timedelta(seconds=600)
    return result
Ejemplo n.º 4
0
def getCmd_power(starttime, endtime, devid, start, length, draw):
    conditions = dict()
    if devid != '':
        conditions['devid'] = devid
    if starttime != '':
        conditions['starttime'] = {'$gte': starttime}
    if endtime != '':
        conditions['endtime'] = {'$lte': endtime}
    sort = [('starttime', 1)]
    data = data_model('powershowgrid').find(conditions=conditions, sort=sort)
    result = dict()
    resultlist = []
    count = 0
    starti = 0
    for item in data:
        count += len(item['result'])
    for item in data:
        for i in item['result']:
            if starti != start:
                starti += 1
                continue
            temp = []
            temp.append(item['devid'])
            temp.append(i['temp'])
            temp.append(i['W'])
            temp.append(i['P'])
            temp.append(common.strTimeToFormat(i['time']))
            if i['cmd'] == '3001':
                temp.append('持续状态')
            elif i['cmd'] == 'devTodo':
                if i['inst'].startswith('0'):
                    temp.append('关闭')
                elif i['inst'].startswith('1'):
                    if i['time'] == item['starttime']:
                        temp.append("打开(" + i['inst'] + ")")
                    else:
                        temp.append("调整温度模式(" + i['inst'] + ")")
                else:
                    if i['actionid'] == '2':
                        temp.append("打开")
                    if i['actionid'] == '0':
                        temp.append("关闭")
            resultlist.append(temp)
            if len(resultlist) == length:
                break
        if len(resultlist) == length:
            break

    result = {
        "draw": draw,
        "recordsTotal": count,
        "recordsFiltered": count,
        "aaData": resultlist
    }
    return result
Ejemplo n.º 5
0
def getTemp(starttime, endtime, devid):
    province = devid.split('_')[0]
    city = devid.split('_')[1]
    conditions = dict()
    conditions['city'] = province
    conditions['area'] = city
    conditions['time'] = {'$gte': starttime, '$lte': endtime}
    sort = [('time', 1)]
    data = data_model('live.area.temp.history').find(conditions=conditions,
                                                     sort=sort)
    result = []
    for item in data:
        if item['temNow'] == '暂无实况':
            continue
        temp = {}
        temp['key'] = common.strTimeToFormat(item['time'])
        temp['value'] = item['temNow']
        result.append(temp)
    return result
Ejemplo n.º 6
0
def getCmd(starttime, endtime, devid, start, length, draw):
    sender = False
    if devid.startswith('sender_'):
        devid = devid[7:]
        sender = True
    sort = []
    sort.append(('acceptTime', pymongo.ASCENDING))
    conditions = {}
    conditions['acceptTime'] = {'$gte': starttime, '$lte': endtime}
    if sender:
        pre = devid[:3]
        stuff = devid[3:]
        rexexp = '^' + pre + '.*' + stuff + '$'
        rexexp = re.compile(rexexp)
        conditions['content.sender'] = rexexp
    else:
        conditions['content.devID'] = devid
    conditions['content.CMD'] = {'$exists': True}
    conditions['mark'] = {'$ne': 'dev'}

    result = dict()
    count = data_model('loger').count(conditions=conditions)
    findlist = data_model('loger').find(conditions=conditions,
                                        sort=sort,
                                        limit=length,
                                        skip=start)
    resultlist = []
    for item in findlist:
        print item
        temp = []
        temp.append(devid)
        temp.append(item["content"]["CMD"])
        temp.append(common.strTimeToFormat(item['acceptTime']))
        resultlist.append(temp)

    result = {
        "draw": draw,
        "recordsTotal": count,
        "recordsFiltered": count,
        "aaData": resultlist
    }
    return result
Ejemplo n.º 7
0
 def POST(self):
     data = web.input()
     starttime = data['starttime']
     endtime = data['endtime']
     type = data['type']
     daylist = common.getdaylist(starttime,endtime)
     if type == 'device':
         flag = 'info'
     elif type == 'user':
         flag = 'user'
     result = []
     for day in daylist:
         tablename = 'statistic_' + flag + '_' + day
         count = statistic_model(tablename).count()
         temp = {'key':'','value':0}
         temp['key'] = common.strTimeToFormat(day)
         temp['value'] = count
         result.append(temp)
     data = {'result':result}      
     data = json.dumps(data)
     return data
     
Ejemplo n.º 8
0
def getActioninst(starttime, endtime, devid, start, length, draw):
    conditions = dict()
    if starttime != '' and endtime != '':
        conditions['time'] = {'$gte': starttime, '$lte': endtime}
    sort = [('time', 1)]

    result = dict()
    resultlist = []
    count = 0
    devids = devid.split(',')
    datalist = []
    for id in devids:
        conditions['devid'] = id
        data = data_model('devcmd').find(conditions=conditions, sort=sort)
        count += len(data)
        action = ''
        for i in data:
            if 'actionid' not in i.keys():
                actionid = '6'
            else:
                actionid = i['actionid']
            temp = []
            temp.append(i['devid'])
            temp.append(common.strTimeToFormat(i['time']))
            temp.append(i['W'])
            action, mode, tempi = parseInst(i['inst'], actionid, i['time'], '')
            temp.append(action)
            temp.append(mode)
            temp.append(tempi)
            resultlist.append(temp)

    result = {
        "draw": draw,
        "recordsTotal": count,
        "recordsFiltered": count,
        "aaData": resultlist
    }
    return result
Ejemplo n.º 9
0
    def POST(self, *args):
        data = web.input()
        start = int(data["start"])
        length = int(data["length"])
        userfrom = data['userFrom']
        tablename = data["tablename"]
        draw = int(data['draw'])
        ordernum = int(data['order[0][column]'])
        orderstyle = data['order[0][dir]']
        conditions = {}
        keys = []
        sort = []
        #获取字段名,设定排序条件
        first = data_model(tablename).find_one()
        del first['_id']
        if userfrom == "业务持久化存储服务":
            devid = ''
            starttime = ''
            endtime = ''
            if "devid" in data.keys():
                devid = data['devid']
                conditions['devid'] = data['devid']
            if 'starttime' in data.keys() and 'endtime' in data.keys():
                starttime = data['starttime'].replace('/', '').replace(
                    ' ', '').replace(':', '') + '00'
                endtime = data['endtime'].replace('/', '').replace(
                    ' ', '').replace(':', '') + '00'
                conditions['time'] = {'$gte': starttime, '$lte': endtime}
            elif 'starttime' in data.keys():
                starttime = data['starttime'].replace('/', '').replace(
                    ' ', '').replace(':', '') + '00'
                conditions['time'] = {'$gte': starttime}
            elif 'endtime' in data.keys():
                endtime = data['endtime'].replace('/', '').replace(
                    ' ', '').replace(':', '') + '00'
                conditions['time'] = {'$lte': endtime}
            keys = first.keys()

            if tablename == 'powershowgrid':
                data = dict()
                data = getCmd_power(starttime, endtime, devid, start, length,
                                    draw)
                data = json.dumps(data)
                return data

            elif tablename == 'devpower_detail':
                data = dict()
                data = getPower_detail(starttime, endtime, devid, start,
                                       length, draw)
                data = json.dumps(data)
                return data

        else:
            for key in first.keys():
                if key == "_id" or key == "tablename":
                    pass
                else:
                    if key in data.keys(
                    ):  #设定查询条件,以%%包围的属于模糊匹配,以‘[’或‘(’开头的属于范围内查找,以‘{}’包围的属于子内容查找,其他请求属于精确匹配
                        #					conditions[key] = data[key]
                        try:
                            value = data[key]
                            if value[0] == '%' or value[-1] == '%':  #模糊匹配
                                pass
                            elif value[0] == '(' or value[0] == '[':
                                list = value.split(':')
                                left = list[0].split(' ')
                                right = list[1].split(' ')
                                if left[1] == '':  #<=
                                    if right[1] == ')':
                                        conditions[key] = {"$lt": right[0]}
                                    elif right[1] == ']':
                                        conditions[key] = {"$lte": right[0]}
                                elif right[0] == '':  #>=
                                    if left[0] == '(':
                                        conditions[key] = {"$gt": left[1]}
                                    elif left[0] == '[':
                                        conditions[key] = {"$gte": left[1]}
                                else:  #区间
                                    tag_left = ''
                                    tag_right = ''
                                    if left[0] == '(':
                                        tag_left = "$gt"
                                    elif left[0] == '[':
                                        tag_left = "$gte"
                                    if right[1] == ')':
                                        tag_right = "$lt"
                                    elif right[1] == ']':
                                        tag_right = "$lte"
                                    conditions[key] = {
                                        tag_left: left[1],
                                        tag_right: right[0]
                                    }
                            elif value[0] == '{' and value[-1] == '}':
                                temp = value.split('{')[1].split('}')[0]
                                list = temp.split(',')
                                for item in list:
                                    key_child = item.split(':')[0]
                                    value = item.split(':')[1]
                                    conditions[key + '.' + key_child] = value
                            else:
                                conditions[key] = data[key]
                        except Exception as e:
                            data = {
                                "draw": draw,
                                "recordsTotal": 0,
                                "recordsFiltered": 0,
                                "aaData": []
                            }
                            data = json.dumps(data)
                            return data
                    keys.append(key)

        temp = []
        ordercolumn = keys[ordernum]
        if orderstyle == 'asc':
            temp.append(ordercolumn)
            temp.append(pymongo.ASCENDING)
            sort.append(tuple(temp))
        else:
            temp.append(ordercolumn)
            temp.append(pymongo.DESCENDING)
            sort.append(tuple(temp))

        count = data_model(tablename).count(conditions=conditions)
        set = data_model(tablename).find(limit=length,
                                         skip=start,
                                         sort=sort,
                                         conditions=conditions)
        result = []
        for item in set:
            del item["_id"]
            if "tablename" in item.keys():
                del item["tablename"]
            keys = item.keys()
            temp = []
            for key in keys:
                if key.lower().find("time") != -1:
                    item[key] = common.strTimeToFormat(item[key])
                if isinstance(item[key], dict):
                    item[key] = unparse.dictTostr(item[key])
                if key == "_id":
                    item[key] = str(item[key])
                temp.append(item[key])

            result.append(temp)
        data = {
            "draw": draw,
            "recordsTotal": count,
            "recordsFiltered": count,
            "aaData": result
        }
        data = json.dumps(data)
        return data
Ejemplo n.º 10
0
def getActioninfo(starttime, endtime, devid, start, length, draw):
    conditions = dict()
    if starttime != '':
        conditions['starttime'] = {'$gte': starttime}
    if endtime != '':
        conditions['endtime'] = {'$lte': endtime}
    sort = [('starttime', 1)]

    result = dict()
    resultlist = []
    count = 0
    starti = 0
    devids = devid.split(',')
    datalist = []
    for id in devids:
        conditions['devid'] = id
        data = data_model('powershowgrid').find(conditions=conditions,
                                                sort=sort)
        datalist.append(data)
    for data in datalist:  #处理每个设备
        for item in data:  #处理某个设备的某一次完整操作
            for i in item['result']:
                if 'actionid' not in i.keys():
                    i['actionid'] = 'null'
                if i['cmd'] == '3001':
                    continue
                if i['inst'].startswith('0') or i['actionid'] == '0':
                    count += 2  #每个结束动作都会有一个小的汇总信息
                elif i['inst'].startswith('1') or i['actionid'] == '2':
                    count += 1
        if len(data) > 0:
            count += 1  #最后设备在此查询时间段内会有一个总的汇总信息,若没有操作则没有汇总信息
    for data in datalist:
        if len(data) == 0:
            continue
        runtime = 0
        power = 0.0
        for item in data:
            stime = item['starttime']
            id = item['devid']
            for i in item['result']:
                if i['cmd'] == '3001':
                    continue
                actionid = i['actionid']
                temp = []
                temp.append(item['devid'])
                temp.append(common.strTimeToFormat(i['time']))
                temp.append(i['W'])
                action, mode, tempi = parseInst(i['inst'], actionid, i['time'],
                                                stime)
                temp.append(action)
                temp.append(mode)
                temp.append(tempi)
                resultlist.append(temp)
            #添加小的汇总信息
            finddata = data_model('actioninfo').find(conditions={
                'devid': id,
                'starttime': stime
            })
            temp = []
            temp.append(id)
            temp.append(finddata[0]['runtime'])
            runtime += finddata[0]['runtime']
            temp.append(finddata[0]['power'])
            power += finddata[0]['power']
            temp.append('')
            temp.append('')
            temp.append('')
            resultlist.append(temp)
        #添加总的汇总信息
        temp = []
        temp.append(id)
        temp.append(runtime)
        temp.append(float('%0.4f' % power))
        temp.append('')
        temp.append('')
        temp.append('')
        resultlist.append(temp)
    result = {
        "draw": draw,
        "recordsTotal": count,
        "recordsFiltered": count,
        "aaData": resultlist
    }
    return result
Ejemplo n.º 11
0
def dealReport(time, month):
    tablename = 'report_month_%s' % (time)
    table = 'worktime_' + time
    devIDlist = data_model(table).find()
    count = 0
    for l in devIDlist:
        devid = l['_id']
        print devid
        #if devid != '32150609600232212924':
        #	continue
        finditem = data_model('devID').find_one(conditions={'_id': devid})
        if finditem is None:
            system = ''
        else:
            system = finditem.get('system', '')
        result = dict()
        finduser = data_model('user_dev').find_one(conditions={'_id': devid})
        if finduser is None:
            print '无用户名'
            continue
        else:
            username = finduser['username']
            sender = finduser['sender']
        result['_id'] = devid
        result['username'] = username[-4:]

        worktime, runtime, index, worktime_pre, starttime, power, power_pre = getWorktime(
            devid, time)
        if worktime == 0:  #表里无记录说明此设备不是空调类型,不予处理
            print "不是空调"
            continue
        weatherinfo, city, area = getWeather(devid, time)
        if city == '' or area == '':  #无法确定用户地理信息,不予处理
            print '无地理信息'
            continue
        #power,power_pre = getPower(devid,time)
        if power == 0:  #查询月份电量为0,说明无工作,不予处理,查询的是devpowerhistory表
            print '无电量'
            continue
        efficiencyinfo = getEfficiency(devid, time)

        cityindex = getCityindex(city, area)
        listtime, listhigh, listlower = getTemperature(city, area, time)

        data = []
        for key in weatherinfo.keys():
            temp = dict()
            temp['name'] = key
            temp['value'] = weatherinfo[key]
            data.append(temp)

        result['weather'] = {'key': weatherinfo.keys(), 'value': data}
        result['power'] = power
        result['power_pre'] = power_pre
        result['cityindex'] = cityindex
        result['efficiency'] = efficiencyinfo
        result['temperature'] = {
            'time': listtime,
            'lower': listlower,
            'high': listhigh
        }
        result['worktime'] = worktime
        result['runtime'] = runtime
        result['index'] = index
        result['starttime'] = common.strTimeToFormat(starttime)

        year1 = int(time[:4])
        month1 = int(time[4:6])
        if month1 == 1:
            month2 = 12
            year2 = year - 1
        else:
            month2 = month1 - 1
            year2 = year1

        day1 = calendar.monthrange(year1, month1)[1]
        day2 = calendar.monthrange(year2, month2)[1]

        avgpower = float(power) / day1
        avgpower = float('%0.3f' % avgpower)
        if power_pre == 0:
            avgpower_pre = 0
        else:
            avgpower_pre = float(power_pre) / day2
            avgpower_pre = float('%0.3f' % avgpower_pre)
        result['powerinfo'] = {
            'now': [float('%0.3f' % power), avgpower],
            'pre': [float('%0.3f' % power_pre), avgpower_pre]
        }

        data_model(tablename).insert(result)
        count += 1
        #	finditem = data_model('user_dev').find_one(conditions={'_id':devid})
        #	if finditem is None:
        #		pass
        #	else:
        if system == '':
            findloger = data_model('loger').find_one(
                conditions={'content.devID': devid})
            if findloger is None:
                system = 'LV_1'
            else:
                system = findloger.get('system', 'LV_1')
    #	sender = finditem['sender']
    #	username = finditem['username']
        findname = data_model('devCurrInfo').find_one(
            conditions={'deviceId': devid})
        if findname is None:
            name = '设备' + devid[:15][-4:]
        else:
            name = findname.get('devName', '设备' + devid[:15][-4:])
        content = '%s %s年%d月份使用情况汇总' % (name, time[:4], month)
        url = 'http://%s/report/month?month=%s&devid=%s' % (
            server, time, common.encrypt(15, devid))
        data_model('month_report_test').insert({
            'devid': devid,
            'month': time,
            'sender': sender,
            'url': url,
            'username': username,
            'content': content,
            'system': system
        })
        print count
    print 'OK'