| | |
| | | #!/bin/sh |
| | | |
| | | sqlite3 /work/iot_cfg.db ".headers on " "select d.name as 设备名称,'1.3.6.1.4.1.27116.'||d.type||'.'||d.id||'.'||a.passcode as OID, d.id as 设备ID, d.type as 设备类型, a.passcode as 通道号, a.name as 数据名称,a.note as 备注 from device d left join accuracy a on d.id=a.id where uploadFlag=0" > /tmp/oid_list.csv |
| | | sqlite3 /work/iot_cfg.db "SELECT name as 设备名称, '1.3.6.1.4.1.27116.'||type||'.'||id||'.3' as OID, id as 设备ID, type as 设备类型, 3 as 通道号 , '状态' as 数据名称, '0-正常;1-告警' as 备注 FROM ioDevice ;" >> /tmp/oid_list.csv |
| | | sqlite3 /work/iot_cfg.db ".headers on " "select d.name as 设备名称,'1.3.6.1.4.1.27116.'||d.type||'.'||d.id||'.'||a.passcode as OID, d.id as 设备ID, a.passcode as 通道号, a.name as 数据名称,a.note as 备注 from device d left join accuracy a on d.id=a.id where uploadFlag=0" > /tmp/oid_list.csv |
| | | sqlite3 /work/iot_cfg.db "SELECT name as 设备名称, '1.3.6.1.4.1.27116.'||type||'.'||id||'.3' as OID, id as 设备ID, 3 as 通道号 , '状态' as 数据名称, '0-正常;1-告警' as 备注 FROM ioDevice ;" >> /tmp/oid_list.csv |
| | | |
| | | sed -i 's/|/,/g' /tmp/oid_list.csv |
| | | |
| | |
| | | |
| | | # 获取传入的 OID |
| | | OID="$1" |
| | | jsoner=./jsoner |
| | | |
| | | #echo "脚本被调用, OID: $OID" |
| | | chn=${OID##*.} |
| | |
| | | |
| | | chn=`expr $chn - 1 ` |
| | | |
| | | #echo "$jsoner -g /tmp/$id value-$chn.value" |
| | | val=`$jsoner -g /tmp/$id value-$chn.value` |
| | | #echo "jsoner -g /tmp/$id value-$chn.value" |
| | | val=`jsoner -g /tmp/$id value-$chn.value` |
| | | ret=$? |
| | | #echo "ret = $ret" |
| | | |
| | |
| | | mul=MulticastIP |
| | | lk=linkage |
| | | rtsp=rtsp |
| | | export applist=" $main $dc $net $gate $svr $lk" |
| | | export applist=" $main $dc $net $gate $svr $lk $mul start_snmpd" |
| | | |
| | |
| | | 2025-07-09-v001 |
| | | 2025-07-18-v001 |
| | | type=1 |
| | | IGD3000 |
| | |
| | | killall -9 MainControl |
| | | killall -9 svr |
| | | |
| | | `/usr/local/bin/export.sh` > /dev/null |
| | | killall -9 snmpd |
| | | |
| | |
| | | |
| | | if [ "$enable" == "true" ] |
| | | then |
| | | `/usr/local/bin/export.sh` > /dev/null |
| | | `jsoner -s /work/sysConfig.json snmp "1"` > /dev/null |
| | | |
| | | else |
| | | `jsoner -s /work/sysConfig.json snmp "0"` > /dev/null |
| | | fi |
| | |
| | | |
| | | echo "{\"code\": \"success\"}" |
| | | |
| | | echo 0 > /usr/local/dev/do1 |
| | | # echo 0 > /usr/local/dev/do1 |
| | | |
| | | # 原始字符串 |
| | | str=`sqlite3 /work/iot_cfg.db "select alarm from alarm;"` |
| | | |
| | | # 移除逗号,生成连续字符序列 |
| | | clean_str=${str//,/} |
| | | |
| | | # 需要检查的位置列表(1、3、5、7) |
| | | positions="0 1 2 3" # 索引从0开始,对应第1、3、5、7个字符 |
| | | |
| | | # 遍历位置并判断 |
| | | for pos in $positions; do |
| | | char="${clean_str:$pos:1}" # 提取指定位置的字符 |
| | | if [[ "$char" == "1" ]]; then |
| | | actual_pos=$((pos + 1)) # 转换为实际位置(从1计数) |
| | | echo 0 > /usr/local/dev/do$actual_pos |
| | | fi |
| | | done |
| | |
| | | var data = warnList;
|
| | | var html = '';
|
| | | if (data != null && data.length > 0) {
|
| | | for (var i = data.length - 1; i > data.length - 12; i--) {
|
| | | for (var i = data.length - 1; i > data.length - 6; i--) {
|
| | | if(i < 0){
|
| | | break;
|
| | | }
|