Files
oa-monitor/bin/collect-business.sh.bak.v1.202610281838

56 lines
2.5 KiB
Bash
Executable File
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
#!/usr/bin/env bash
# ============================================================================
# OA Monitor · 业务指标采集(每 15 分钟)
# ⚠️ ecology_message_log 没有 created datetime 列!
# 时间用 CREATEDATE varchar(10) + CREATETIME varchar(8) 拼接
# ============================================================================
set -u
SCRIPT_DIR="$(cd "$(dirname "$0")" && pwd)"
source "${SCRIPT_DIR}/../lib/common.sh"
NOW=$(date +%s)
NOW_DATE=$(date '+%Y-%m-%d')
NOW_HOUR=$(date '+%H')
NOW_MIN=$(date '+%M')
# 1 小时前的时间(用于计算小时增量)
HOUR_AGO_DATE=$(date -v-1H '+%Y-%m-%d' 2>/dev/null || date --date='1 hour ago' '+%Y-%m-%d' 2>/dev/null)
HOUR_AGO_TIME=$(date -v-1H '+%H:%M:%S' 2>/dev/null || date --date='1 hour ago' '+%H:%M:%S' 2>/dev/null)
# --- 1. ecology_message_log 小时增量(正确用 CREATEDATE + CREATETIME 拼接)---
MSG_HOURLY=$(MYSQL_PWD="${DB_PASS}" timeout 30 mysql -h39.100.72.102 -P3306 -uecology ecology -N -e "
SELECT COUNT(*) FROM ecology_message_log
WHERE (CREATEDATE = '${NOW_DATE}' AND CREATETIME >= DATE_FORMAT(NOW() - INTERVAL 1 HOUR, '%H:%i:%s'))
OR (CREATEDATE = '${HOUR_AGO_DATE}' AND CREATETIME >= '${HOUR_AGO_TIME}');
" 2>/dev/null | tail -1)
MSG_HOURLY=${MSG_HOURLY:-0}
# --- 2. 正在流转的审批数 ---
# 泛微 CURRENTSTATUS 全 NULL,STATUS 存中文节点名(如"行政审批层级1 /审批人1 至 归档")
# 判断:CURRENTNODEID > 0 且不包含"归档"
ONGOING=$(MYSQL_PWD="${DB_PASS}" timeout 30 mysql -h39.100.72.102 -P3306 -uecology ecology -N -e "
SELECT COUNT(*) FROM workflow_requestbase
WHERE CURRENTNODEID > 0 AND (STATUS IS NULL OR STATUS NOT LIKE '%归档%');
" 2>/dev/null | tail -1)
ONGOING=${ONGOING:-0}
# --- 3. 今日新建审批数 ---
NEW_TODAY=$(MYSQL_PWD="${DB_PASS}" timeout 30 mysql -h39.100.72.102 -P3306 -uecology ecology -N -e "
SELECT COUNT(*) FROM workflow_requestbase WHERE CREATEDATE = '${NOW_DATE}';
" 2>/dev/null | tail -1)
NEW_TODAY=${NEW_TODAY:-0}
# --- 4. 超时任务数 ---
OVERDUE=$(MYSQL_PWD="${DB_PASS}" timeout 30 mysql -h39.100.72.102 -P3306 -uecology ecology -N -e "
SELECT COUNT(*) FROM workflow_requestlog
WHERE timeout = 1 AND operatedate >= DATE_SUB(CURDATE(), INTERVAL 1 DAY);
" 2>/dev/null | tail -1)
OVERDUE=${OVERDUE:-0}
FAIL_RATE="0.0" # ecology_message_log 没有失败率字段,暂置 0
sqlite_exec "INSERT INTO business_metrics VALUES (
${NOW}, ${MSG_HOURLY}, ${FAIL_RATE}, ${ONGOING}, ${OVERDUE}
);"
log_info "[BIZ] ✅ msg_hourly=${MSG_HOURLY} ongoing=${ONGOING} new_today=${NEW_TODAY} overdue=${OVERDUE}"