systemLogController.js 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412
  1. "use strict";
  2. Object.defineProperty(exports, "__esModule", { value: true });
  3. exports.SystemLogController = void 0;
  4. const systemLog_1 = require("../models/systemLog");
  5. const helpers_1 = require("../utils/helpers");
  6. class SystemLogController {
  7. static async getAllSystemLogs(req, res) {
  8. try {
  9. const page = Number((0, helpers_1.toString)(req.query.page)) || 1;
  10. const limit = Number((0, helpers_1.toString)(req.query.limit)) || 20;
  11. const offset = (page - 1) * limit;
  12. const systemLogs = await systemLog_1.SystemLogModel.getAll(limit, offset);
  13. const total = await systemLog_1.SystemLogModel.getCount();
  14. res.status(200).json({
  15. success: true,
  16. data: systemLogs,
  17. pagination: {
  18. page,
  19. limit,
  20. total,
  21. pages: Math.ceil(total / limit)
  22. }
  23. });
  24. }
  25. catch (error) {
  26. console.error('获取系统日志列表失败:', error);
  27. res.status(500).json({
  28. success: false,
  29. message: '获取系统日志列表失败',
  30. error: error instanceof Error ? error.message : '未知错误'
  31. });
  32. }
  33. }
  34. static async getSystemLogById(req, res) {
  35. try {
  36. const id = (0, helpers_1.toString)(req.params.id);
  37. if (!id || isNaN(Number(id))) {
  38. res.status(400).json({
  39. success: false,
  40. message: '无效的ID'
  41. });
  42. return;
  43. }
  44. const systemLog = await systemLog_1.SystemLogModel.getById(Number(id));
  45. if (!systemLog) {
  46. res.status(404).json({
  47. success: false,
  48. message: '系统日志不存在'
  49. });
  50. return;
  51. }
  52. res.status(200).json({
  53. success: true,
  54. data: systemLog
  55. });
  56. }
  57. catch (error) {
  58. console.error('获取系统日志失败:', error);
  59. res.status(500).json({
  60. success: false,
  61. message: '获取系统日志失败',
  62. error: error instanceof Error ? error.message : '未知错误'
  63. });
  64. }
  65. }
  66. static async getSystemLogsByLevel(req, res) {
  67. try {
  68. const level = (0, helpers_1.toString)(req.params.level);
  69. const page = Number((0, helpers_1.toString)(req.query.page)) || 1;
  70. const limit = Number((0, helpers_1.toString)(req.query.limit)) || 20;
  71. const offset = (page - 1) * limit;
  72. if (!level) {
  73. res.status(400).json({
  74. success: false,
  75. message: '日志级别不能为空'
  76. });
  77. return;
  78. }
  79. if (!['info', 'warn', 'error', 'debug'].includes(level)) {
  80. res.status(400).json({
  81. success: false,
  82. message: '日志级别必须是info、warn、error或debug之一'
  83. });
  84. return;
  85. }
  86. const systemLogs = await systemLog_1.SystemLogModel.getByLevel(level, limit, offset);
  87. const total = await systemLog_1.SystemLogModel.getCountByLevel(level);
  88. res.status(200).json({
  89. success: true,
  90. data: systemLogs,
  91. pagination: {
  92. page,
  93. limit,
  94. total,
  95. pages: Math.ceil(total / limit)
  96. }
  97. });
  98. }
  99. catch (error) {
  100. console.error('根据日志级别获取系统日志失败:', error);
  101. res.status(500).json({
  102. success: false,
  103. message: '根据日志级别获取系统日志失败',
  104. error: error instanceof Error ? error.message : '未知错误'
  105. });
  106. }
  107. }
  108. static async getSystemLogsBySource(req, res) {
  109. try {
  110. const source = (0, helpers_1.toString)(req.params.source);
  111. const page = Number((0, helpers_1.toString)(req.query.page)) || 1;
  112. const limit = Number((0, helpers_1.toString)(req.query.limit)) || 20;
  113. const offset = (page - 1) * limit;
  114. if (!source) {
  115. res.status(400).json({
  116. success: false,
  117. message: '来源不能为空'
  118. });
  119. return;
  120. }
  121. const systemLogs = await systemLog_1.SystemLogModel.getBySource(source, limit, offset);
  122. const total = await systemLog_1.SystemLogModel.getCountBySource(source);
  123. res.status(200).json({
  124. success: true,
  125. data: systemLogs,
  126. pagination: {
  127. page,
  128. limit,
  129. total,
  130. pages: Math.ceil(total / limit)
  131. }
  132. });
  133. }
  134. catch (error) {
  135. console.error('根据来源获取系统日志失败:', error);
  136. res.status(500).json({
  137. success: false,
  138. message: '根据来源获取系统日志失败',
  139. error: error instanceof Error ? error.message : '未知错误'
  140. });
  141. }
  142. }
  143. static async getSystemLogsByModule(req, res) {
  144. try {
  145. const module = (0, helpers_1.toString)(req.params.module);
  146. const page = Number((0, helpers_1.toString)(req.query.page)) || 1;
  147. const limit = Number((0, helpers_1.toString)(req.query.limit)) || 20;
  148. const offset = (page - 1) * limit;
  149. if (!module) {
  150. res.status(400).json({
  151. success: false,
  152. message: '模块不能为空'
  153. });
  154. return;
  155. }
  156. const systemLogs = await systemLog_1.SystemLogModel.getByModule(module, limit, offset);
  157. const total = await systemLog_1.SystemLogModel.getCountByModule ? await systemLog_1.SystemLogModel.getCountByModule(module) : 0;
  158. res.status(200).json({
  159. success: true,
  160. data: systemLogs,
  161. pagination: {
  162. page,
  163. limit,
  164. total,
  165. pages: Math.ceil(total / limit)
  166. }
  167. });
  168. }
  169. catch (error) {
  170. console.error('根据模块获取系统日志失败:', error);
  171. res.status(500).json({
  172. success: false,
  173. message: '根据模块获取系统日志失败',
  174. error: error instanceof Error ? error.message : '未知错误'
  175. });
  176. }
  177. }
  178. static async getSystemLogsByTimeRange(req, res) {
  179. try {
  180. const { start_time, end_time } = req.query;
  181. const page = Number(req.query.page) || 1;
  182. const limit = Number(req.query.limit) || 20;
  183. const offset = (page - 1) * limit;
  184. if (!start_time || !end_time) {
  185. res.status(400).json({
  186. success: false,
  187. message: '开始时间和结束时间不能为空'
  188. });
  189. return;
  190. }
  191. const startDate = new Date(start_time);
  192. const endDate = new Date(end_time);
  193. if (isNaN(startDate.getTime()) || isNaN(endDate.getTime())) {
  194. res.status(400).json({
  195. success: false,
  196. message: '无效的时间格式'
  197. });
  198. return;
  199. }
  200. if (startDate >= endDate) {
  201. res.status(400).json({
  202. success: false,
  203. message: '开始时间必须早于结束时间'
  204. });
  205. return;
  206. }
  207. const systemLogs = await systemLog_1.SystemLogModel.getByTimeRange(startDate, endDate, limit, offset);
  208. const total = await systemLog_1.SystemLogModel.getCountByTimeRange(startDate, endDate);
  209. res.status(200).json({
  210. success: true,
  211. data: systemLogs,
  212. pagination: {
  213. page,
  214. limit,
  215. total,
  216. pages: Math.ceil(total / limit)
  217. }
  218. });
  219. }
  220. catch (error) {
  221. console.error('根据时间范围获取系统日志失败:', error);
  222. res.status(500).json({
  223. success: false,
  224. message: '根据时间范围获取系统日志失败',
  225. error: error instanceof Error ? error.message : '未知错误'
  226. });
  227. }
  228. }
  229. static async getSystemLogsByMultipleConditions(req, res) {
  230. try {
  231. const { level, source, module, message, start_time, end_time } = req.query;
  232. const page = Number(req.query.page) || 1;
  233. const limit = Number(req.query.limit) || 20;
  234. const offset = (page - 1) * limit;
  235. const conditions = {};
  236. if (level !== undefined && level !== '') {
  237. if (!['info', 'warn', 'error', 'debug'].includes(level)) {
  238. res.status(400).json({
  239. success: false,
  240. message: '日志级别必须是info、warn、error或debug之一'
  241. });
  242. return;
  243. }
  244. conditions.level = level;
  245. }
  246. if (source !== undefined && source !== '')
  247. conditions.source = source;
  248. if (module !== undefined && module !== '')
  249. conditions.module = module;
  250. if (message !== undefined && message !== '')
  251. conditions.message = message;
  252. let startDate, endDate;
  253. if (start_time && end_time) {
  254. startDate = new Date(start_time);
  255. endDate = new Date(end_time);
  256. if (isNaN(startDate.getTime()) || isNaN(endDate.getTime())) {
  257. res.status(400).json({
  258. success: false,
  259. message: '无效的时间格式'
  260. });
  261. return;
  262. }
  263. if (startDate >= endDate) {
  264. res.status(400).json({
  265. success: false,
  266. message: '开始时间必须早于结束时间'
  267. });
  268. return;
  269. }
  270. }
  271. const fuzzyFields = ['message', 'source', 'module'];
  272. const systemLogs = await systemLog_1.SystemLogModel.getByMultipleConditions(conditions, startDate, endDate, limit, offset, fuzzyFields);
  273. const total = await systemLog_1.SystemLogModel.getCountByMultipleConditions(conditions, startDate, endDate, fuzzyFields);
  274. res.status(200).json({
  275. success: true,
  276. data: systemLogs,
  277. pagination: {
  278. page,
  279. limit,
  280. total,
  281. pages: Math.ceil(total / limit)
  282. }
  283. });
  284. }
  285. catch (error) {
  286. console.error('根据多条件查询系统日志失败:', error);
  287. res.status(500).json({
  288. success: false,
  289. message: '根据多条件查询系统日志失败',
  290. error: error instanceof Error ? error.message : '未知错误'
  291. });
  292. }
  293. }
  294. static async getSystemLogStats(req, res) {
  295. try {
  296. const stats = await systemLog_1.SystemLogModel.getFullStats();
  297. res.status(200).json({
  298. success: true,
  299. data: stats,
  300. message: '获取系统日志统计信息成功'
  301. });
  302. }
  303. catch (error) {
  304. console.error('获取系统日志统计信息失败:', error);
  305. res.status(500).json({
  306. success: false,
  307. message: '获取系统日志统计信息失败',
  308. error: error instanceof Error ? error.message : '未知错误'
  309. });
  310. }
  311. }
  312. static async getRecentSystemLogs(req, res) {
  313. try {
  314. const limit = Number(req.query.limit) || 10;
  315. if (limit > 100) {
  316. res.status(400).json({
  317. success: false,
  318. message: '限制数量不能超过100'
  319. });
  320. return;
  321. }
  322. const systemLogs = await systemLog_1.SystemLogModel.getRecent(limit);
  323. res.status(200).json({
  324. success: true,
  325. data: systemLogs,
  326. message: '获取最近系统日志成功'
  327. });
  328. }
  329. catch (error) {
  330. console.error('获取最近系统日志失败:', error);
  331. res.status(500).json({
  332. success: false,
  333. message: '获取最近系统日志失败',
  334. error: error instanceof Error ? error.message : '未知错误'
  335. });
  336. }
  337. }
  338. static async createSystemLog(req, res) {
  339. try {
  340. const { level, message, source, module, user_id, username, ip_address, details } = req.body;
  341. if (!level || !message || !source) {
  342. res.status(400).json({
  343. success: false,
  344. message: '日志级别、消息和来源不能为空'
  345. });
  346. return;
  347. }
  348. if (!['info', 'warn', 'error', 'debug'].includes(level)) {
  349. res.status(400).json({
  350. success: false,
  351. message: '日志级别必须是info、warn、error或debug之一'
  352. });
  353. return;
  354. }
  355. const systemLog = await systemLog_1.SystemLogModel.create({
  356. level,
  357. message,
  358. source,
  359. module,
  360. user_id,
  361. username,
  362. ip_address,
  363. details
  364. });
  365. res.status(201).json({
  366. success: true,
  367. data: systemLog,
  368. message: '创建系统日志成功'
  369. });
  370. }
  371. catch (error) {
  372. console.error('创建系统日志失败:', error);
  373. res.status(500).json({
  374. success: false,
  375. message: '创建系统日志失败',
  376. error: error instanceof Error ? error.message : '未知错误'
  377. });
  378. }
  379. }
  380. static async cleanupOldSystemLogs(req, res) {
  381. try {
  382. const { days } = req.query;
  383. let daysToDelete = days;
  384. if (!daysToDelete && req.body && req.body.days) {
  385. daysToDelete = req.body.days;
  386. }
  387. if (!daysToDelete || isNaN(Number(daysToDelete)) || Number(daysToDelete) < 1) {
  388. res.status(400).json({
  389. success: false,
  390. message: '请提供有效的天数(大于0的数字)'
  391. });
  392. return;
  393. }
  394. const deletedCount = await systemLog_1.SystemLogModel.cleanup(Number(daysToDelete));
  395. res.status(200).json({
  396. success: true,
  397. data: { deletedCount },
  398. message: `成功清理${deletedCount}条${daysToDelete}天前的系统日志`
  399. });
  400. }
  401. catch (error) {
  402. console.error('清理旧系统日志失败:', error);
  403. res.status(500).json({
  404. success: false,
  405. message: '清理旧系统日志失败',
  406. error: error instanceof Error ? error.message : '未知错误'
  407. });
  408. }
  409. }
  410. }
  411. exports.SystemLogController = SystemLogController;
  412. //# sourceMappingURL=systemLogController.js.map