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