Example #1
0
    def get(self):
        substid = self.get_argument('substid')
        subst = manage.get_subst_info(substid = substid)
        eu = manage.get_eu_info(substid)

        EVENT = []
        for e in eu:
            euaddr = e.get('euaddr')
            euaddr = '1' * 24
            fields = ['euaddr', 'HappenTime', 'Note', 'Content', 'DealWith']
            sql = "select {} from JQR_EVENT_ERC where euaddr='{}' order by HappenTime DESC".format(','.join(fields), euaddr)
            data, t = mysql_util.m_query(sql, fields, findall=True)

            for d in data:
                d['name'] = e.get('name')
                d['HappenTime'] = str(d['HappenTime'])

            EVENT.extend(data)

        fields = ['pointid', 'HappenTime', 'Note', 'Content']
        sql = "select {} from YW_EVENT_ERC where substid='{}' and DealWith=0 order by HappenTime DESC".format(','.join(fields), substid)
        data, t = mysql_util.m_query(sql, fields, findall=True)

        data = [{'pointid':'1', 'HappenTime': '2', 'Note': '3', 'Content':'4'}]

        for d in data:
            d['HappenTime'] = str(d['HappenTime'])

        EVENT.extend(data)

        self.render("erc_history.html", data = EVENT)
Example #2
0
    def get(self):
        substid = self.get_argument('substid')
        subst = manage.get_subst_info(substid = substid)
        eu = manage.get_eu_info(substid)

        jqr_event = []
        for e in eu:
            euaddr = e.get('euaddr')
            fields = ['ERC_ID', 'euaddr', 'HappenTime', 'Note', 'Content']
            sql = "select {} from JQR_EVENT_ERC where euaddr='{}' and DealWith=0 order by HappenTime DESC".format(','.join(fields), euaddr)
            data, t = mysql_util.m_query(sql, fields, findall=True)
            if not data:
                data = [{'ERC_ID': 1, 'euaddr': '0000000100000001', 'HappenTime': 'HappenTime', 'Note': 'Note', 'Content': 'Content'},
                        {'ERC_ID': 2, 'euaddr': '0000000100000001', 'HappenTime': 'HappenTime', 'Note': 'Note', 'Content': 'Content'}]

            for d in data:
                d['name'] = e.get('name')
                d['HappenTime'] = str(d.get('HappenTime'))

            jqr_event.extend(data)

        fields = ['ERC_ID', 'PointID', 'HappenTime', 'Note', 'Content']
        sql = "select {} from YW_EVENT_ERC where substid='{}' and DealWith=0 order by HappenTime DESC".format(','.join(fields), substid)
        yw_event, t = mysql_util.m_query(sql, fields, findall=True)

        if not yw_event:
            yw_event = [{'PointID':'1', 'HappenTime': '2', 'Note': '5', 'Content':'4'}]

        for d in yw_event:
            d['HappenTime'] = str(d['HappenTime'])

        self.write(dict(status = True, jqr_event = jqr_event, yw_event = yw_event))
Example #3
0
    def get(self):
        bind_args = dict((k, v[-1]) for k, v in self.request.arguments.items())
        substid = self.get_argument('substid')
        euaddr = self.get_argument('euaddr', None)
        subst_info = manage.get_subst_info(substid = substid)
        eu = manage.get_eu_info(substid)
        data, map_data = manage.get_map_info_by_substid(substid)

        self.render("control_status.html",bind_args=bind_args, subst_info = subst_info, eu = eu, data =data, map_data = map_data)
Example #4
0
    def get(self):
        substid = self.get_argument('substid')
        subst = manage.get_subst_info(substid = substid)
        m, mapinfo = manage.get_map_info_by_substid(substid)
        eu = manage.get_eu_info(substid)

        data = []
        for e in eu:
            euaddr = e.get('euaddr')
            fields = ['EuAddr', 'CollectTime', 'SchemeNum', 'PlanNum', 'MeasuNum', 'JqrTime', 'BatteryCapat', 'BatteryVar', 'JqrConMode', 'LocalTemp', 'LocalHum', 'LocalWind', 'SysTemp', 'JqrSpeed', 'CurrentPoint', 'CurrentPointLog', 'FrontPoint', 'FrontPointLog']

            sql = "select {} from TermRealTimeShowData where euaddr='{}'".format(','.join(fields), euaddr)
            d, t = mysql_util.m_query(sql, fields, findall=True)
            for _d in d:
                _d['name'] = e.get('name')
                _d['JqrTime'] = str(_d.get('JqrTime'))
                _d['CollectTime'] = str(_d.get('CollectTime'))
            data.extend(d)

        self.write(dict(status = True, data = data, mapinfo = mapinfo))
Example #5
0
    def get(self):
        substid = self.get_argument('substid')
        euaddr = self.get_argument('euaddr', None)
        eu = manage.get_eu_info(substid)

        self.render("control_manual.html",eu=eu,substid=substid,euaddr=euaddr)