亚晨yacn软件config数据获取

亚晨yacn软件config数据获取

同目录下新建Config文件夹，将服务器中config文件夹下的xml文件（建议拷贝备份文件）拷贝到新建的文件夹下，运行程序即可
导入到excel文件用“|”隔开即可

#!/usr/bin/env python
# -*- coding :utf-8 -*-

from xml.dom.minidom import parse
import xml.dom.minidom
import time


def AlarmPoint(wAlarmPoint):
    fname = (now + "AlarmPoint.txt")
    with open(fname, 'a+') as f:
        f.write(wAlarmPoint.encode("gbk", "ignore").decode("gbk") + "
")


def AlarmOutput(wAlarmOutput):
    fname = (now + "AlarmOutput.txt")
    with open(fname, 'a+') as f:
        f.write(wAlarmOutput.encode("gbk", "ignore").decode("gbk") + "
")


def MonitoringPoints(wMonitoringPoints):
    fname = (now + "MonitoringPoints.txt")
    with open(fname, 'a+') as f:
        f.write(wMonitoringPoints.encode("gbk", "ignore").decode("gbk") + "
")


def ReviceInfo(wReviceInfo):
    fname = (now + "DeviceInfo.txt")
    with open(fname, 'a+') as f:
        f.write(wReviceInfo.encode("gbk", "ignore").decode("gbk") + "
")


def rAlarmPoint(collection):
    for i in range(1, 9999):
        data = collection.getElementsByTagName("point_%d" % i)
        for root in data:
            try:
                if not root.getElementsByTagName('channel_no'): continue
                org = root.getElementsByTagName('org')[0]
                org = org.childNodes[0].data
                point_name = root.getElementsByTagName('point_name')[0]
                point_name = point_name.childNodes[0].data
                # data2 = collection.getElementsByTagName("channel_0")
                device_id = root.getElementsByTagName('device_id')[0]
                device_id = device_id.childNodes[0].data
                channel_no = root.getElementsByTagName('channel_no')[0]
                channel_no = channel_no.childNodes[0].data
                wAlarmPoint = org + '|' + point_name + '|' + device_id + '|' + channel_no
                print(wAlarmPoint)
                AlarmPoint(wAlarmPoint)
            except IndexError:
                pass
    return GoTo(5)


def rAlarmOutput(collection):
    for i in range(1, 9999):
        data = collection.getElementsByTagName("point_%d" % i)
        for root in data:
            try:
                if not root.getElementsByTagName('dc_1'): continue
                org = root.getElementsByTagName('org')[0]
                org = org.childNodes[0].data
                point_name = root.getElementsByTagName('point_name')[0]
                point_name = point_name.childNodes[0].data
                device_id = root.getElementsByTagName('dc_1')[0].getAttribute('device_id')
                deviceid_name = root.getElementsByTagName('dc_1')[0].getAttribute('deviceid_name')
                channel_id = root.getElementsByTagName('dc_1')[0].getAttribute('channel_id')
                channelid_name = root.getElementsByTagName('dc_1')[0].getAttribute('channelid_name')
                wAlarmOutput = org + '|' + point_name + '|' + device_id + '|' + deviceid_name + '|' + channel_id + '|' + channelid_name
                print(wAlarmOutput)
                AlarmOutput(wAlarmOutput)
            except IndexError:
                pass
    return GoTo(4)


def rMonitoringPoints(collection):
    for i in range(1, 9999):
        data = collection.getElementsByTagName("point_%d" % i)
        for root in data:
            try:
                if not root.getElementsByTagName('ptz_preno'): continue
                org = root.getElementsByTagName('org')[0]
                org = org.childNodes[0].data
                point_name = root.getElementsByTagName('point_name')[0]
                point_name = point_name.childNodes[0].data
                deviceid = root.getElementsByTagName('deviceid')[0]
                deviceid = deviceid.childNodes[0].data
                deviceidname = root.getElementsByTagName('deviceid')[0].getAttribute('name')
                channelid = root.getElementsByTagName('channelid')[0]
                channelid = channelid.childNodes[0].data
                channelidname = root.getElementsByTagName('channelid')[0].getAttribute('name')
                wMonitoringPoints = org + '|' + point_name + '|' + deviceid + '|' + deviceidname + '|' + channelid + '|' + channelidname
                print(wMonitoringPoints)
                MonitoringPoints(wMonitoringPoints)
            except IndexError:
                pass
    return GoTo(3)


def rDeviceInfo(collection):
    for i in range(1, 9999):
        data = collection.getElementsByTagName("device_%d" % i)
        for root in data:
            try:
                if not root.getElementsByTagName('friend_code') or not root.getElementsByTagName('ip_address') or not root.getElementsByTagName('user_name'): continue
                friend_code = root.getElementsByTagName('friend_code')[0]  # 设备编号
                friend_code = friend_code.childNodes[0].data
                device_name = root.getElementsByTagName('device_name')[0]  # 设备名称
                device_name = device_name.childNodes[0].data
                ip_address = root.getElementsByTagName('ip_address')[0]  # 设备IP地址
                ip_address = ip_address.childNodes[0].data
                user_name = root.getElementsByTagName('user_name')[0]  # 设备用户名
                user_name = user_name.childNodes[0].data
                password = root.getElementsByTagName('password')[0]  # 设备密码
                password = password.childNodes[0].data
                server_port = root.getElementsByTagName('server_port')[0]  # 设备端口
                server_port = server_port.childNodes[0].data
                wReviceInfo = friend_code + '|' + device_name + '|' + ip_address + '|' + user_name + '|' + password + '|' + server_port
                print(wReviceInfo)
                ReviceInfo(wReviceInfo)
            except IndexError:
                pass
    return GoTo(2)


def GoTo(i):
    if i == 1:
        DomDeviceInfo = xml.dom.minidom.parse("Config/DeviceInfo.xml")
        collection = DomDeviceInfo.documentElement
        rDeviceInfo(collection)#设备表
    elif i == 2:
        DomDeviceInfo = xml.dom.minidom.parse("Config/Point.xml")
        collection = DomDeviceInfo.documentElement
        rMonitoringPoints(collection)#监控点
    elif i == 3:
        DomDeviceInfo = xml.dom.minidom.parse("Config/Point.xml")
        collection = DomDeviceInfo.documentElement
        rAlarmOutput(collection)#报警输出
    elif i == 4:
        DomDeviceInfo = xml.dom.minidom.parse("Config/Point.xml")
        collection = DomDeviceInfo.documentElement
        rAlarmPoint(collection)#报警点
    else:
        exit()


if __name__ == '__main__':
    now = time.strftime("%Y%m%d", time.localtime(time.time()))
    GoTo(1)