log/xzs.20231027.log
New file @@ -0,0 +1,212 @@ 2023-10-27 13:41:08.337 INFO 11460 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 11460 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt) 2023-10-27 13:41:08.340 INFO 11460 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev 2023-10-27 13:41:08.401 INFO 11460 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 2023-10-27 13:41:08.402 INFO 11460 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 2023-10-27 13:41:12.188 INFO 11460 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$50bd9b1d] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-10-27 13:41:12.678 WARN 11460 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used 2023-10-27 13:41:12.736 INFO 11460 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext 2023-10-27 13:41:12.736 INFO 11460 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 4334 ms 2023-10-27 13:41:15.898 INFO 11460 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729 2023-10-27 13:41:16.181 INFO 11460 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@5548cc63, org.springframework.security.web.context.SecurityContextPersistenceFilter@2824fbc9, org.springframework.security.web.header.HeaderWriterFilter@6b4ff5bb, org.springframework.web.filter.CorsFilter@58ae5931, org.springframework.security.web.authentication.logout.LogoutFilter@7a637334, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@1462ea34, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@2300d93c, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@19086960, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@45feeab4, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@4fb09b9f, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@1a2e997c, org.springframework.security.web.session.SessionManagementFilter@6e1cf7b7, org.springframework.security.web.access.ExceptionTranslationFilter@395d121b, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@5198eaeb] 2023-10-27 13:41:16.214 INFO 11460 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)] 2023-10-27 13:41:16.877 INFO 11460 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed 2023-10-27 13:41:16.925 INFO 11460 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s) 2023-10-27 13:41:17.010 INFO 11460 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references 2023-10-27 13:41:17.248 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1 2023-10-27 13:41:17.296 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1 2023-10-27 13:41:17.317 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1 2023-10-27 13:41:17.327 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1 2023-10-27 13:41:17.330 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1 2023-10-27 13:41:17.361 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1 2023-10-27 13:41:17.373 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2 2023-10-27 13:41:17.401 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1 2023-10-27 13:41:17.408 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3 2023-10-27 13:41:17.411 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1 2023-10-27 13:41:17.423 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2 2023-10-27 13:41:17.430 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4 2023-10-27 13:41:17.432 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2 2023-10-27 13:41:17.437 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5 2023-10-27 13:41:17.440 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3 2023-10-27 13:41:17.442 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1 2023-10-27 13:41:17.444 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3 2023-10-27 13:41:17.453 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6 2023-10-27 13:41:17.456 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4 2023-10-27 13:41:17.465 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4 2023-10-27 13:41:17.480 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5 2023-10-27 13:41:17.482 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: exportTemplatesIdUsingGET_1 2023-10-27 13:41:17.493 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6 2023-10-27 13:41:17.506 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7 2023-10-27 13:41:17.509 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectSourceUsingPOST_1 2023-10-27 13:41:17.516 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7 2023-10-27 13:41:17.528 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8 2023-10-27 13:41:17.532 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8 2023-10-27 13:41:17.536 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2 2023-10-27 13:41:17.539 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5 2023-10-27 13:41:17.571 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9 2023-10-27 13:41:17.574 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_9 2023-10-27 13:41:17.578 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3 2023-10-27 13:41:17.582 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6 2023-10-27 13:41:17.590 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10 2023-10-27 13:41:17.592 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_10 2023-10-27 13:41:17.603 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1 2023-10-27 13:41:17.603 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1 2023-10-27 13:41:17.604 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1 2023-10-27 13:41:17.605 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1 2023-10-27 13:41:17.605 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1 2023-10-27 13:41:17.606 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1 2023-10-27 13:41:17.606 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1 2023-10-27 13:41:17.607 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1 2023-10-27 13:41:17.615 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4 2023-10-27 13:41:17.619 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_7 2023-10-27 13:41:17.627 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1 2023-10-27 13:41:17.633 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11 2023-10-27 13:41:17.634 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_11 2023-10-27 13:41:17.639 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2 2023-10-27 13:41:17.644 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1 2023-10-27 13:41:17.658 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2 2023-10-27 13:41:17.665 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3 2023-10-27 13:41:17.668 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2 2023-10-27 13:41:17.669 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1 2023-10-27 13:41:17.672 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1 2023-10-27 13:41:17.674 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3 2023-10-27 13:41:17.675 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1 2023-10-27 13:41:17.677 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1 2023-10-27 13:41:17.679 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4 2023-10-27 13:41:17.682 INFO 11460 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1 2023-10-27 13:41:17.748 INFO 11460 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final 2023-10-27 13:41:17.768 INFO 11460 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final 2023-10-27 13:41:17.886 INFO 11460 --- [restartedMain] o.s.b.w.e.u.UndertowServletWebServer : Undertow started on port(s) 8000 (http) with context path '' 2023-10-27 13:41:17.891 INFO 11460 --- [restartedMain] com.mindskip.xzs.XzsApplication : Started XzsApplication in 10.272 seconds (JVM running for 14.084) 2023-10-27 13:42:45.750 INFO 11460 --- [XNIO-1 task-1] io.undertow.servlet : Initializing Spring DispatcherServlet 'dispatcherServlet' 2023-10-27 13:42:45.751 INFO 11460 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Initializing Servlet 'dispatcherServlet' 2023-10-27 13:42:45.768 INFO 11460 --- [XNIO-1 task-1] o.s.web.servlet.DispatcherServlet : Completed initialization in 17 ms 2023-10-27 13:43:44.694 INFO 11460 --- [XNIO-1 task-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-10-27 13:43:48.654 INFO 11460 --- [XNIO-1 task-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed. 2023-10-27 13:43:48.665 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 13:43:48.695 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 13:43:48.831 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 13:43:49.432 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 13:43:49.433 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 13:43:49.442 DEBUG 11460 --- [XNIO-1 task-3] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 13:43:54.959 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 13:43:54.959 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 13:43:54.970 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 13:43:55.017 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 13:43:55.017 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 13:43:55.028 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 13:43:55.045 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.U.insertSelective : ==> Preparing: insert into t_user_event_log ( user_id, user_name, real_name, content, create_time ) values ( ?, ?, ?, ?, ? ) 2023-10-27 13:43:55.048 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.U.insertSelective : ==> Parameters: 2(Integer), admin(String), 管理员(String), admin 登录了考试系统(String), 2023-10-27 13:43:55.028(Timestamp) 2023-10-27 13:43:55.080 DEBUG 11460 --- [XNIO-1 task-4] r.c.m.x.r.U.insertSelective : <== Updates: 1 2023-10-27 13:43:55.263 INFO 11460 --- [XNIO-1 task-5] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/department/page/list 2023-10-27 13:43:55.299 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page_COUNT : ==> Preparing: SELECT count(0) FROM t_department WHERE deleted = 0 2023-10-27 13:43:55.299 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page_COUNT : ==> Parameters: 2023-10-27 13:43:55.352 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page_COUNT : <== Total: 1 2023-10-27 13:43:55.357 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page : ==> Preparing: SELECT id, name, deleted FROM t_department WHERE deleted = 0 order by id desc LIMIT ? 2023-10-27 13:43:55.357 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page : ==> Parameters: 100(Integer) 2023-10-27 13:43:55.367 DEBUG 11460 --- [XNIO-1 task-5] r.c.m.x.r.DepartmentMapper.page : <== Total: 4 2023-10-27 13:43:55.417 INFO 11460 --- [XNIO-1 task-6] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/dashboard/index 2023-10-27 13:43:55.425 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper where deleted=0 2023-10-27 13:43:55.425 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 13:43:55.445 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 13:43:55.449 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.QuestionMapper.selectAllCount : ==> Preparing: SELECT count(*) from t_question where deleted=0 2023-10-27 13:43:55.449 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.QuestionMapper.selectAllCount : ==> Parameters: 2023-10-27 13:43:55.463 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.QuestionMapper.selectAllCount : <== Total: 1 2023-10-27 13:43:55.468 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper_answer 2023-10-27 13:43:55.468 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 13:43:55.481 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 13:43:55.483 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper_question_customer_answer 2023-10-27 13:43:55.483 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 13:43:55.497 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 13:43:55.505 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.U.selectCountByDate : ==> Preparing: SELECT create_time as name,COUNT(create_time) as value from ( SELECT DATE_FORMAT(create_time,'%Y-%m-%d') as create_time from t_user_event_log WHERE create_time between ? and ? ) a GROUP BY create_time 2023-10-27 13:43:55.506 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.U.selectCountByDate : ==> Parameters: 2023-10-01 00:00:00.0(Timestamp), 2023-10-31 23:59:59.0(Timestamp) 2023-10-27 13:43:55.518 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.U.selectCountByDate : <== Total: 5 2023-10-27 13:43:55.522 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectCountByDate : ==> Preparing: SELECT create_time as name,COUNT(create_time) as value from ( SELECT DATE_FORMAT(create_time,'%Y-%m-%d') as create_time from t_exam_paper_question_customer_answer WHERE create_time between ? and ? ) a GROUP BY create_time 2023-10-27 13:43:55.522 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectCountByDate : ==> Parameters: 2023-10-01 00:00:00.0(Timestamp), 2023-10-31 23:59:59.0(Timestamp) 2023-10-27 13:43:55.532 DEBUG 11460 --- [XNIO-1 task-6] r.c.m.x.r.E.selectCountByDate : <== Total: 2 2023-10-27 15:00:07.224 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 15:00:07.231 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 15:00:07.249 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 15:00:07.265 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : ==> Preparing: select id, user_uuid, user_name, password, real_name, age, sex, birth_day, user_level, phone, role, status, image_path, create_time, modify_time, last_active_time, deleted, wx_open_id from t_user where deleted=0 and user_name=? limit 1 2023-10-27 15:00:07.266 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : ==> Parameters: admin(String) 2023-10-27 15:00:07.282 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.UserMapper.getUserByUserName : <== Total: 1 2023-10-27 15:00:07.289 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.U.insertSelective : ==> Preparing: insert into t_user_event_log ( user_id, user_name, real_name, content, create_time ) values ( ?, ?, ?, ?, ? ) 2023-10-27 15:00:07.289 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.U.insertSelective : ==> Parameters: 2(Integer), admin(String), 管理员(String), admin 登录了考试系统(String), 2023-10-27 15:00:07.283(Timestamp) 2023-10-27 15:00:07.316 DEBUG 11460 --- [XNIO-1 task-13] r.c.m.x.r.U.insertSelective : <== Updates: 1 2023-10-27 15:00:07.361 INFO 11460 --- [XNIO-1 task-14] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/department/page/list 2023-10-27 15:00:07.369 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page_COUNT : ==> Preparing: SELECT count(0) FROM t_department WHERE deleted = 0 2023-10-27 15:00:07.369 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page_COUNT : ==> Parameters: 2023-10-27 15:00:07.378 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page_COUNT : <== Total: 1 2023-10-27 15:00:07.378 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page : ==> Preparing: SELECT id, name, deleted FROM t_department WHERE deleted = 0 order by id desc LIMIT ? 2023-10-27 15:00:07.382 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page : ==> Parameters: 100(Integer) 2023-10-27 15:00:07.392 DEBUG 11460 --- [XNIO-1 task-14] r.c.m.x.r.DepartmentMapper.page : <== Total: 4 2023-10-27 15:00:07.723 INFO 11460 --- [XNIO-1 task-15] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/dashboard/index 2023-10-27 15:00:07.723 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper where deleted=0 2023-10-27 15:00:07.723 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 15:00:07.731 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 15:00:07.733 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.QuestionMapper.selectAllCount : ==> Preparing: SELECT count(*) from t_question where deleted=0 2023-10-27 15:00:07.734 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.QuestionMapper.selectAllCount : ==> Parameters: 2023-10-27 15:00:07.742 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.QuestionMapper.selectAllCount : <== Total: 1 2023-10-27 15:00:07.743 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper_answer 2023-10-27 15:00:07.743 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 15:00:07.752 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 15:00:07.753 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Preparing: SELECT count(*) from t_exam_paper_question_customer_answer 2023-10-27 15:00:07.753 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : ==> Parameters: 2023-10-27 15:00:07.761 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectAllCount : <== Total: 1 2023-10-27 15:00:07.763 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.U.selectCountByDate : ==> Preparing: SELECT create_time as name,COUNT(create_time) as value from ( SELECT DATE_FORMAT(create_time,'%Y-%m-%d') as create_time from t_user_event_log WHERE create_time between ? and ? ) a GROUP BY create_time 2023-10-27 15:00:07.775 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.U.selectCountByDate : ==> Parameters: 2023-10-01 00:00:00.0(Timestamp), 2023-10-31 23:59:59.0(Timestamp) 2023-10-27 15:00:07.785 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.U.selectCountByDate : <== Total: 5 2023-10-27 15:00:07.786 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectCountByDate : ==> Preparing: SELECT create_time as name,COUNT(create_time) as value from ( SELECT DATE_FORMAT(create_time,'%Y-%m-%d') as create_time from t_exam_paper_question_customer_answer WHERE create_time between ? and ? ) a GROUP BY create_time 2023-10-27 15:00:07.787 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectCountByDate : ==> Parameters: 2023-10-01 00:00:00.0(Timestamp), 2023-10-31 23:59:59.0(Timestamp) 2023-10-27 15:00:07.798 DEBUG 11460 --- [XNIO-1 task-15] r.c.m.x.r.E.selectCountByDate : <== Total: 2 2023-10-27 15:00:10.771 INFO 11460 --- [XNIO-1 task-16] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/education/subject/list 2023-10-27 15:00:10.775 INFO 11460 --- [XNIO-1 task-17] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/exam/paper/page 2023-10-27 15:00:10.792 DEBUG 11460 --- [XNIO-1 task-16] r.c.m.x.r.SubjectMapper.allSubject : ==> Preparing: select id, name, level, level_name, item_order, deleted from t_subject where deleted = 0 2023-10-27 15:00:10.792 DEBUG 11460 --- [XNIO-1 task-16] r.c.m.x.r.SubjectMapper.allSubject : ==> Parameters: 2023-10-27 15:00:10.803 DEBUG 11460 --- [XNIO-1 task-16] r.c.m.x.r.SubjectMapper.allSubject : <== Total: 2 2023-10-27 15:00:10.818 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.ExamPaperMapper.page_COUNT : ==> Preparing: SELECT count(0) FROM (SELECT e.* FROM t_exam_paper e LEFT JOIN t_exam_paper_department d ON e.id = d.exam_paper_id LEFT JOIN t_exam_paper_subject s ON e.id = s.exam_paper_id WHERE e.deleted = 0 AND e.type = ? GROUP BY e.id) table_count 2023-10-27 15:00:10.819 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.ExamPaperMapper.page_COUNT : ==> Parameters: 0(String) 2023-10-27 15:00:10.829 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.ExamPaperMapper.page_COUNT : <== Total: 1 2023-10-27 15:00:10.834 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.repository.ExamPaperMapper.page : ==> Preparing: SELECT e.* FROM t_exam_paper e LEFT JOIN t_exam_paper_department d ON e.id = d.exam_paper_id LEFT JOIN t_exam_paper_subject s ON e.id = s.exam_paper_id WHERE e.deleted = 0 AND e.type = ? GROUP BY e.id order by id desc LIMIT ? 2023-10-27 15:00:10.834 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.repository.ExamPaperMapper.page : ==> Parameters: 0(String), 10(Integer) 2023-10-27 15:00:10.846 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.repository.ExamPaperMapper.page : <== Total: 10 2023-10-27 15:00:10.852 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.852 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 159(Integer) 2023-10-27 15:00:10.862 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 2 2023-10-27 15:00:10.866 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.866 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 156(Integer) 2023-10-27 15:00:10.875 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 1 2023-10-27 15:00:10.875 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.876 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 155(Integer) 2023-10-27 15:00:10.885 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 2 2023-10-27 15:00:10.886 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.886 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 148(Integer) 2023-10-27 15:00:10.894 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 2 2023-10-27 15:00:10.897 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.897 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 147(Integer) 2023-10-27 15:00:10.905 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 2 2023-10-27 15:00:10.906 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.906 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 146(Integer) 2023-10-27 15:00:10.914 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 2 2023-10-27 15:00:10.916 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.916 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 93(Integer) 2023-10-27 15:00:10.925 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 1 2023-10-27 15:00:10.927 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.927 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 92(Integer) 2023-10-27 15:00:10.936 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 1 2023-10-27 15:00:10.937 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.937 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 85(Integer) 2023-10-27 15:00:10.948 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 1 2023-10-27 15:00:10.949 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Preparing: select * from t_exam_paper_subject where exam_paper_id = ? and deleted = 0 2023-10-27 15:00:10.949 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : ==> Parameters: 84(Integer) 2023-10-27 15:00:10.964 DEBUG 11460 --- [XNIO-1 task-17] r.c.m.x.r.E.getByExamPaperId : <== Total: 1 2023-10-27 15:00:15.900 INFO 11460 --- [XNIO-1 task-18] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/exam/paper/exportTemplatesId/93 2023-10-27 15:00:15.907 DEBUG 11460 --- [XNIO-1 task-18] r.c.m.x.r.E.getPaperExcelById : ==> Preparing: select u.real_name as name,a.create_user as userId,a.user_score as userScore,a.paper_score as paperScore from t_exam_paper_answer a left join t_user u on u.id = a.create_user where a.exam_paper_id = ? 2023-10-27 15:00:15.907 DEBUG 11460 --- [XNIO-1 task-18] r.c.m.x.r.E.getPaperExcelById : ==> Parameters: 93(Integer) 2023-10-27 15:00:15.917 DEBUG 11460 --- [XNIO-1 task-18] r.c.m.x.r.E.getPaperExcelById : <== Total: 0 2023-10-27 15:00:40.386 INFO 11460 --- [XNIO-1 task-19] c.mindskip.xzs.aop.InterfaceLogHandler : 访问接口:/api/admin/exam/paper/exportTemplatesId/159 2023-10-27 15:00:40.394 DEBUG 11460 --- [XNIO-1 task-19] r.c.m.x.r.E.getPaperExcelById : ==> Preparing: select u.real_name as name,a.create_user as userId,a.user_score as userScore,a.paper_score as paperScore from t_exam_paper_answer a left join t_user u on u.id = a.create_user where a.exam_paper_id = ? 2023-10-27 15:00:40.396 DEBUG 11460 --- [XNIO-1 task-19] r.c.m.x.r.E.getPaperExcelById : ==> Parameters: 159(Integer) 2023-10-27 15:00:40.405 DEBUG 11460 --- [XNIO-1 task-19] r.c.m.x.r.E.getPaperExcelById : <== Total: 0 2023-10-27 15:23:48.505 INFO 11460 --- [Thread-28] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2023-10-27 15:23:48.562 INFO 11460 --- [Thread-28] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed. 2023-10-27 15:23:48.590 INFO 11460 --- [Thread-28] io.undertow.servlet : Destroying Spring FrameworkServlet 'dispatcherServlet' log/xzs.20231108.log
New file @@ -0,0 +1,77 @@ 2023-11-08 16:58:18.438 INFO 18752 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 18752 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt) 2023-11-08 16:58:18.440 INFO 18752 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev 2023-11-08 16:58:18.503 INFO 18752 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 2023-11-08 16:58:18.503 INFO 18752 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 2023-11-08 16:58:22.335 INFO 18752 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$c822c57e] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-11-08 16:58:22.785 WARN 18752 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used 2023-11-08 16:58:22.821 INFO 18752 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext 2023-11-08 16:58:22.821 INFO 18752 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 4315 ms 2023-11-08 16:58:24.713 INFO 18752 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729 2023-11-08 16:58:24.942 INFO 18752 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@75fe3437, org.springframework.security.web.context.SecurityContextPersistenceFilter@68d6db6d, org.springframework.security.web.header.HeaderWriterFilter@22d142f1, org.springframework.web.filter.CorsFilter@44717307, org.springframework.security.web.authentication.logout.LogoutFilter@7e038ee2, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@8978af3, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@63647edd, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@1d0a7a39, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@52654006, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@188a288a, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@523a518d, org.springframework.security.web.session.SessionManagementFilter@2e305881, org.springframework.security.web.access.ExceptionTranslationFilter@5ff3f8af, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@31a5c2a0] 2023-11-08 16:58:24.971 INFO 18752 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)] 2023-11-08 16:58:25.620 INFO 18752 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed 2023-11-08 16:58:25.642 INFO 18752 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s) 2023-11-08 16:58:25.686 INFO 18752 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references 2023-11-08 16:58:25.854 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1 2023-11-08 16:58:25.891 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1 2023-11-08 16:58:25.910 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1 2023-11-08 16:58:25.917 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1 2023-11-08 16:58:25.921 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1 2023-11-08 16:58:25.950 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1 2023-11-08 16:58:25.958 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2 2023-11-08 16:58:25.977 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1 2023-11-08 16:58:25.981 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3 2023-11-08 16:58:25.984 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1 2023-11-08 16:58:25.996 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4 2023-11-08 16:58:26.000 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2 2023-11-08 16:58:26.010 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2 2023-11-08 16:58:26.012 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5 2023-11-08 16:58:26.014 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3 2023-11-08 16:58:26.016 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1 2023-11-08 16:58:26.017 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3 2023-11-08 16:58:26.026 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6 2023-11-08 16:58:26.028 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4 2023-11-08 16:58:26.031 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4 2023-11-08 16:58:26.040 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5 2023-11-08 16:58:26.048 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6 2023-11-08 16:58:26.057 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: exportTemplatesIdUsingGET_1 2023-11-08 16:58:26.061 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7 2023-11-08 16:58:26.063 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectSourceUsingPOST_1 2023-11-08 16:58:26.071 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7 2023-11-08 16:58:26.082 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8 2023-11-08 16:58:26.085 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8 2023-11-08 16:58:26.089 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2 2023-11-08 16:58:26.091 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5 2023-11-08 16:58:26.120 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9 2023-11-08 16:58:26.123 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_9 2023-11-08 16:58:26.127 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3 2023-11-08 16:58:26.132 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6 2023-11-08 16:58:26.140 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10 2023-11-08 16:58:26.143 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_10 2023-11-08 16:58:26.149 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1 2023-11-08 16:58:26.150 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1 2023-11-08 16:58:26.151 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1 2023-11-08 16:58:26.151 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1 2023-11-08 16:58:26.152 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1 2023-11-08 16:58:26.153 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1 2023-11-08 16:58:26.153 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1 2023-11-08 16:58:26.154 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1 2023-11-08 16:58:26.177 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2 2023-11-08 16:58:26.187 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2 2023-11-08 16:58:26.189 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1 2023-11-08 16:58:26.190 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1 2023-11-08 16:58:26.192 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1 2023-11-08 16:58:26.194 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3 2023-11-08 16:58:26.196 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1 2023-11-08 16:58:26.197 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1 2023-11-08 16:58:26.199 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3 2023-11-08 16:58:26.205 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2 2023-11-08 16:58:26.205 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4 2023-11-08 16:58:26.210 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_7 2023-11-08 16:58:26.219 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1 2023-11-08 16:58:26.224 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11 2023-11-08 16:58:26.225 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_11 2023-11-08 16:58:26.229 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4 2023-11-08 16:58:26.232 INFO 18752 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1 2023-11-08 16:58:26.291 INFO 18752 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final 2023-11-08 16:58:26.309 INFO 18752 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final log/xzs.20231109.log
New file @@ -0,0 +1,79 @@ 2023-11-09 10:23:38.029 INFO 28804 --- [restartedMain] com.mindskip.xzs.XzsApplication : Starting XzsApplication on DESKTOP-7A2KHS1 with PID 28804 (E:\ycll\qyksxt\target\classes started by qirong in E:\ycll\qyksxt) 2023-11-09 10:23:38.033 INFO 28804 --- [restartedMain] com.mindskip.xzs.XzsApplication : The following profiles are active: dev 2023-11-09 10:23:38.098 INFO 28804 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 2023-11-09 10:23:38.099 INFO 28804 --- [restartedMain] .e.DevToolsPropertyDefaultsPostProcessor : For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 2023-11-09 10:23:40.436 INFO 28804 --- [restartedMain] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$3df79f9a] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying) 2023-11-09 10:23:41.008 WARN 28804 --- [restartedMain] io.undertow.websockets.jsr : UT026010: Buffer pool was not set on WebSocketDeploymentInfo, the default pool will be used 2023-11-09 10:23:41.039 INFO 28804 --- [restartedMain] io.undertow.servlet : Initializing Spring embedded WebApplicationContext 2023-11-09 10:23:41.040 INFO 28804 --- [restartedMain] o.s.web.context.ContextLoader : Root WebApplicationContext: initialization completed in 2941 ms 2023-11-09 10:23:43.131 INFO 28804 --- [restartedMain] o.s.b.d.a.OptionalLiveReloadServer : LiveReload server is running on port 35729 2023-11-09 10:23:43.404 INFO 28804 --- [restartedMain] o.s.s.web.DefaultSecurityFilterChain : Creating filter chain: any request, [org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter@49aca01f, org.springframework.security.web.context.SecurityContextPersistenceFilter@1a461440, org.springframework.security.web.header.HeaderWriterFilter@6dd39bc0, org.springframework.web.filter.CorsFilter@2f506a0b, org.springframework.security.web.authentication.logout.LogoutFilter@4d6f030e, com.mindskip.xzs.configuration.spring.security.RestLoginAuthenticationFilter@6c2e56cc, org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter@3d83776, org.springframework.security.web.savedrequest.RequestCacheAwareFilter@7248c4d1, org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter@5d694980, org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter@3859b8ca, org.springframework.security.web.authentication.AnonymousAuthenticationFilter@307f40ad, org.springframework.security.web.session.SessionManagementFilter@7c0782cc, org.springframework.security.web.access.ExceptionTranslationFilter@55d84e00, org.springframework.security.web.access.intercept.FilterSecurityInterceptor@4257b35c] 2023-11-09 10:23:43.438 INFO 28804 --- [restartedMain] pertySourcedRequestMappingHandlerMapping : Mapped URL path [/v2/api-docs] onto method [public org.springframework.http.ResponseEntity<springfox.documentation.spring.web.json.Json> springfox.documentation.swagger2.web.Swagger2Controller.getDocumentation(java.lang.String,javax.servlet.http.HttpServletRequest)] 2023-11-09 10:23:44.113 INFO 28804 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Context refreshed 2023-11-09 10:23:44.137 INFO 28804 --- [restartedMain] d.s.w.p.DocumentationPluginsBootstrapper : Found 1 custom documentation plugin(s) 2023-11-09 10:23:44.183 INFO 28804 --- [restartedMain] s.d.s.w.s.ApiListingReferenceScanner : Scanning for api listing references 2023-11-09 10:23:44.405 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: taskUsingPOST_1 2023-11-09 10:23:44.452 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_1 2023-11-09 10:23:44.476 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: listUsingPOST_1 2023-11-09 10:23:44.486 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_1 2023-11-09 10:23:44.490 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_1 2023-11-09 10:23:44.543 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_1 2023-11-09 10:23:44.546 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_2 2023-11-09 10:23:44.567 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: answerSubmitUsingPOST_1 2023-11-09 10:23:44.572 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_3 2023-11-09 10:23:44.574 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_1 2023-11-09 10:23:44.585 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_4 2023-11-09 10:23:44.589 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_2 2023-11-09 10:23:44.591 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_1 2023-11-09 10:23:44.600 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_2 2023-11-09 10:23:44.611 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_5 2023-11-09 10:23:44.614 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_3 2023-11-09 10:23:44.619 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_3 2023-11-09 10:23:44.622 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_6 2023-11-09 10:23:44.624 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_4 2023-11-09 10:23:44.629 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_4 2023-11-09 10:23:44.638 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_5 2023-11-09 10:23:44.645 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_6 2023-11-09 10:23:44.654 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: exportTemplatesIdUsingGET_1 2023-11-09 10:23:44.659 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_7 2023-11-09 10:23:44.661 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectSourceUsingPOST_1 2023-11-09 10:23:44.669 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_7 2023-11-09 10:23:44.680 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_8 2023-11-09 10:23:44.684 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_8 2023-11-09 10:23:44.688 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_2 2023-11-09 10:23:44.691 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_5 2023-11-09 10:23:44.758 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_9 2023-11-09 10:23:44.760 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_9 2023-11-09 10:23:44.763 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_3 2023-11-09 10:23:44.765 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_6 2023-11-09 10:23:44.786 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_10 2023-11-09 10:23:44.788 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_10 2023-11-09 10:23:44.794 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingGET_1 2023-11-09 10:23:44.794 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingHEAD_1 2023-11-09 10:23:44.795 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPOST_1 2023-11-09 10:23:44.796 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPUT_1 2023-11-09 10:23:44.796 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingPATCH_1 2023-11-09 10:23:44.798 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingDELETE_1 2023-11-09 10:23:44.798 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingOPTIONS_1 2023-11-09 10:23:44.799 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: questionUploadAndReadExcelUsingTRACE_1 2023-11-09 10:23:44.819 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_2 2023-11-09 10:23:44.826 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_2 2023-11-09 10:23:44.833 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_1 2023-11-09 10:23:44.834 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: deleteUsingPOST_4 2023-11-09 10:23:44.837 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: editUsingPOST_7 2023-11-09 10:23:44.843 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: importUserUsingPOST_1 2023-11-09 10:23:44.849 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: pageListUsingPOST_11 2023-11-09 10:23:44.851 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: selectUsingPOST_11 2023-11-09 10:23:44.857 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_3 2023-11-09 10:23:44.859 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: currentUsingPOST_2 2023-11-09 10:23:44.860 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: logUsingPOST_1 2023-11-09 10:23:44.864 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: messagePageListUsingPOST_1 2023-11-09 10:23:44.866 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: readUsingPOST_3 2023-11-09 10:23:44.870 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: registerUsingPOST_1 2023-11-09 10:23:44.870 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: unReadCountUsingPOST_1 2023-11-09 10:23:44.874 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: updateUsingPOST_4 2023-11-09 10:23:44.877 INFO 28804 --- [restartedMain] .d.s.w.r.o.CachingOperationNameGenerator : Generating unique operation named: addUsingPOST_1 2023-11-09 10:23:44.935 INFO 28804 --- [restartedMain] org.xnio : XNIO version 3.3.8.Final 2023-11-09 10:23:44.947 INFO 28804 --- [restartedMain] org.xnio.nio : XNIO NIO Implementation Version 3.3.8.Final 2023-11-09 10:23:45.032 INFO 28804 --- [restartedMain] o.s.b.w.e.u.UndertowServletWebServer : Undertow started on port(s) 8000 (http) with context path '' 2023-11-09 10:23:45.037 INFO 28804 --- [restartedMain] com.mindskip.xzs.XzsApplication : Started XzsApplication in 7.744 seconds (JVM running for 9.552) log/xzs.20231124.log
New file Diff too large log/xzs.20231126.log
New file Diff too large src/main/java/com/mindskip/xzs/controller/admin/ExamPaperGradeController.java
@@ -165,6 +165,7 @@ // } PageHelper.startPage(grade.getPageIndex(), grade.getPageSize()); PageInfo<ExamPaperAnswer> pageInfoPageInfo = new PageInfo<>(filteredList9); pageInfoPageInfo.setTotal(info.getTotal()); return RestResponse.ok(pageInfoPageInfo); } @@ -173,20 +174,19 @@ return RestResponse.ok(examPaperAnswerService.getByCreatUser(scoreTemplatesCountVO)); } @RequestMapping(value = "/updates", method = RequestMethod.POST) public void updateDepartment(){ @RequestMapping(value = "/updates", method = RequestMethod.GET) public void updateDepartment() { List<User> users = userService.getUsers(); for (User user : users) { Integer id = user.getId(); Integer userLevel = user.getUserLevel(); UserDepartment userDepartment = userDepartMentService.selectByUser(id); if (userDepartment!=null){ userDepartment.setDepartmentId(userLevel); userDepartMentService.updateUserDepartMent(userDepartment); } UserDepartment userDepartment = new UserDepartment(); userDepartment.setUserId(id); userDepartment.setDepartmentId(userLevel); userDepartMentService.insert(userDepartment); } } } src/main/java/com/mindskip/xzs/controller/student/DashboardController.java
@@ -6,11 +6,18 @@ import com.mindskip.xzs.domain.enums.ExamPaperTypeEnum; import com.mindskip.xzs.domain.task.TaskItemAnswerObject; import com.mindskip.xzs.domain.task.TaskItemObject; import com.mindskip.xzs.domain.vo.ExamTemplatesUserCountVO; import com.mindskip.xzs.domain.vo.ExamTemplatesVO; import com.mindskip.xzs.repository.ExamPaperAnswerMapper; import com.mindskip.xzs.repository.ExamTemplatesMapper; import com.mindskip.xzs.repository.ExamTemplatesUserCountMapper; import com.mindskip.xzs.repository.ExamTemplatesUserMapper; import com.mindskip.xzs.service.*; import com.mindskip.xzs.utility.DateTimeUtil; import com.mindskip.xzs.utility.JsonUtil; import com.mindskip.xzs.viewmodel.student.dashboard.*; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RestController; @@ -31,9 +38,17 @@ private final TaskExamCustomerAnswerService taskExamCustomerAnswerService; private final TextContentService textContentService; private final ExamPaperUserService examPaperUserService; private final ExamPaperAnswerMapper answerMapper; private final ExamTemplatesMapper templatesMapper; private final ExamTemplatesUserCountMapper templatesUserCountMapper; private final ExamTemplatesUserMapper examTemplatesUserMapper; @Autowired public DashboardController(UserService userService, ExamPaperService examPaperService, QuestionService questionService, TaskExamService taskExamService, TaskExamCustomerAnswerService taskExamCustomerAnswerService, TextContentService textContentService, ExamPaperUserService examPaperUserService) { public DashboardController(UserService userService, ExamPaperService examPaperService, QuestionService questionService, TaskExamService taskExamService, TaskExamCustomerAnswerService taskExamCustomerAnswerService, TextContentService textContentService, ExamPaperUserService examPaperUserService, ExamPaperAnswerMapper answerMapper, ExamTemplatesMapper templatesMapper, ExamTemplatesUserCountMapper templatesUserCountMapper, ExamTemplatesUserMapper examTemplatesUserMapper) { this.userService = userService; this.examPaperService = examPaperService; this.questionService = questionService; @@ -41,6 +56,26 @@ this.taskExamCustomerAnswerService = taskExamCustomerAnswerService; this.textContentService = textContentService; this.examPaperUserService = examPaperUserService; this.answerMapper = answerMapper; this.templatesMapper = templatesMapper; this.templatesUserCountMapper = templatesUserCountMapper; this.examTemplatesUserMapper = examTemplatesUserMapper; } @RequestMapping(value = "/qualification/{paperId}", method = RequestMethod.GET) public RestResponse qualification(@PathVariable("paperId") String paperId) { User user = getCurrentUser(); ExamTemplatesUserCount count = new ExamTemplatesUserCount(); List<ExamTemplatesUserCount> examTemplatesUserCountList = new ArrayList<>(); List<PaperInfo> paperInfos = new ArrayList<>(); count.setUserId(user.getId()); count.setExamPaperId(Integer.parseInt(paperId)); examTemplatesUserCountList.add(count); List<ExamPaperAnswer> list1 = answerMapper.getByExamPaperIdAndUserId(examTemplatesUserCountList); if(list1.size()>0){ return RestResponse.fail(500,"当前试卷已完成考试！"); } return RestResponse.ok(); } @RequestMapping(value = "/index", method = RequestMethod.POST) @@ -53,7 +88,45 @@ Integer[] type = {ExamPaperTypeEnum.Fixed.getCode(),ExamPaperTypeEnum.Random.getCode()}; fixedPaperFilter.setExamPaperType(type); fixedPaperFilter.setUserId(user.getId()); indexVM.setFixedPaper(examPaperService.indexPaper(fixedPaperFilter)); //试卷 List<PaperInfo> list = examPaperService.indexPaper(fixedPaperFilter); ExamTemplatesUserCount count = new ExamTemplatesUserCount(); List<ExamTemplatesUserCount> examTemplatesUserCountList = new ArrayList<>(); List<PaperInfo> paperInfos = new ArrayList<>(); for (PaperInfo info : list) { count.setUserId(user.getId()); count.setExamPaperId(info.getId()); examTemplatesUserCountList.add(count); List<ExamPaperAnswer> list1 = answerMapper.getByExamPaperIdAndUserId(examTemplatesUserCountList); examTemplatesUserCountList.clear(); if(list1.size()>0){ continue; } info.setStatus("0"); paperInfos.add(info); } ExamTemplatesVO vo = new ExamTemplatesVO(); vo.setStatus("0"); List<ExamTemplates> gets = templatesMapper.gets(vo); ExamTemplatesUserCountVO templatesUserCountVO = new ExamTemplatesUserCountVO(); templatesUserCountVO.setUserId(user.getId()); for (ExamTemplates get : gets) { templatesUserCountVO.setId(get.getId()); List<ExamTemplatesUser> byUserId = examTemplatesUserMapper.getByUserId(user.getId(), get.getId()); if(byUserId.size()>0){ List<ExamTemplatesUserCount> byUserIdAndTemplatesId = templatesUserCountMapper.getByUserIdAndTemplatesId(templatesUserCountVO); if(byUserIdAndTemplatesId.size()==0){ PaperInfo info = new PaperInfo(); info.setId(get.getId()); info.setName(get.getName()); info.setStatus("1"); paperInfos.add(info); } } } indexVM.setFixedPaper(paperInfos); PaperFilter timeLimitPaperFilter = new PaperFilter(); timeLimitPaperFilter.setDateTime(new Date()); @@ -62,8 +135,22 @@ timeLimitPaperFilter.setExamPaperType(time); timeLimitPaperFilter.setUserId(user.getId()); ExamTemplatesUserCount count1 = new ExamTemplatesUserCount(); List<ExamTemplatesUserCount> examTemplatesUserCountList1 = new ArrayList<>(); List<PaperInfo> paperInfos1 = new ArrayList<>(); List<PaperInfo> limitPaper = examPaperService.indexPaper(timeLimitPaperFilter); List<PaperInfoVM> paperInfoVMS = limitPaper.stream().map(d -> { for (PaperInfo info : limitPaper) { count1.setUserId(user.getId()); count1.setExamPaperId(info.getId()); examTemplatesUserCountList1.add(count1); List<ExamPaperAnswer> list1 = answerMapper.getByExamPaperIdAndUserId(examTemplatesUserCountList1); examTemplatesUserCountList1.clear(); if(list1.size()>0){ continue; } paperInfos1.add(info); } List<PaperInfoVM> paperInfoVMS = paperInfos1.stream().map(d -> { PaperInfoVM vm = modelMapper.map(d, PaperInfoVM.class); vm.setStartTime(DateTimeUtil.dateFormat(d.getLimitStartTime())); vm.setEndTime(DateTimeUtil.dateFormat(d.getLimitEndTime())); src/main/java/com/mindskip/xzs/controller/student/ExamTemplatesController.java
@@ -25,4 +25,10 @@ User currentUser = getCurrentUser(); return RestResponse.ok(examTemplatesService.randomExam(currentUser)); } @RequestMapping(value = "/addTemplates/{id}", method = RequestMethod.GET) public RestResponse<Integer> select(@PathVariable("id") Integer id) throws Exception { User currentUser = getCurrentUser(); return RestResponse.ok(examTemplatesService.randomExam1(currentUser, id)); } } src/main/java/com/mindskip/xzs/domain/ExamPaper.java
@@ -72,6 +72,9 @@ */ private String type; private String userIds; public Integer getId() { return id; } @@ -199,4 +202,13 @@ public void setType(String type) { this.type = type; } public String getUserIds() { return userIds; } public void setUserIds(String userIds) { this.userIds = userIds; } } src/main/java/com/mindskip/xzs/domain/ExamTemplates.java
@@ -11,6 +11,8 @@ private String suggestTime; private String titleName; private Date ctime; private String status; private String menuIds; public Integer getId() { return id; @@ -60,6 +62,22 @@ this.ctime = ctime; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String getMenuIds() { return menuIds; } public void setMenuIds(String menuIds) { this.menuIds = menuIds; } @Override public String toString() { return "ExamTemplates{" + @@ -69,6 +87,8 @@ ", suggestTime='" + suggestTime + '\'' + ", titleName='" + titleName + '\'' + ", ctime='" + ctime + '\'' + ", status='" + status + '\'' + ", menuIds='" + menuIds + '\'' + '}'; } } src/main/java/com/mindskip/xzs/domain/ExamTemplatesUser.java
New file @@ -0,0 +1,43 @@ package com.mindskip.xzs.domain; import java.io.Serializable; public class ExamTemplatesUser implements Serializable { private Integer id; private String templatesId; private String userId; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getTemplatesId() { return templatesId; } public void setTemplatesId(String templatesId) { this.templatesId = templatesId; } public String getUserId() { return userId; } public void setUserId(String userId) { this.userId = userId; } @Override public String toString() { return "ExamTemplatesUser{" + "id=" + id + ", templatesId='" + templatesId + '\'' + ", userId='" + userId + '\'' + '}'; } } src/main/java/com/mindskip/xzs/domain/vo/ExamTemplatesUserCountVO.java
@@ -13,6 +13,7 @@ private String userName; private String userScore; private String paperScore; private String status; public Integer getId() { @@ -70,4 +71,12 @@ public void setPaperScore(String paperScore) { this.paperScore = paperScore; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } } src/main/java/com/mindskip/xzs/domain/vo/ExamTemplatesVO.java
@@ -16,6 +16,7 @@ private Date ctime; private Integer[] subjectId; private String status; public Integer getId() { return id; @@ -49,6 +50,14 @@ this.subjectId = subjectId; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } @Override public String toString() { return "ExamTemplatesVO{" + @@ -56,6 +65,7 @@ ", name='" + name + '\'' + ", ctime=" + ctime + ", subjectId=" + Arrays.toString(subjectId) + ", status=" + status + '}'; } } src/main/java/com/mindskip/xzs/repository/ExamPaperAnswerMapper.java
@@ -38,4 +38,6 @@ List<ExamPaperAnswer> getByCreatUser(ScoreTemplatesCountVO scoreTemplatesCountVO); List<ExamPaperAnswer> getByExamPaperIds(@Param("ids")List<Integer> ids); } src/main/java/com/mindskip/xzs/repository/ExamTemplatesMapper.java
@@ -29,7 +29,7 @@ * * @return */ List<ExamTemplates> gets(); List<ExamTemplates> gets(ExamTemplatesVO templatesVO); ExamTemplates getById(@Param("id") Integer id);
New file @@ -0,0 +1,23 @@ package com.mindskip.xzs.repository; import com.mindskip.xzs.domain.ExamTemplates; import com.mindskip.xzs.domain.ExamTemplatesUser; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import java.util.List; @Mapper public interface ExamTemplatesUserMapper extends BaseMapper<ExamTemplatesUser>{ /** * 添加 * @param examTemplatesUser * @return */ Integer add(ExamTemplatesUser examTemplatesUser); List<ExamTemplatesUser> getById(@Param("id") Integer id); List<ExamTemplatesUser> getByUserId(@Param("userId") Integer id, @Param("templatesId") Integer templatesId); } src/main/java/com/mindskip/xzs/service/ExamTemplatesService.java
@@ -27,5 +27,7 @@ void remove(Integer id); Integer randomExam1(User user, Integer id) throws Exception; } src/main/java/com/mindskip/xzs/service/impl/ExamPaperServiceImpl.java
@@ -128,6 +128,7 @@ examPaper.setCreateTime(now); examPaper.setCreateUser(user.getId()); examPaper.setDeleted(false); examPaper.setUserIds(examPaperEditRequestVM.getMenuIds()); examPaperFromVM(examPaperEditRequestVM, examPaper, titleItemsVM); examPaperMapper.insertSelective(examPaper); @@ -154,6 +155,7 @@ ExamPaper examPaper = examPaperMapper.selectByPrimaryKey(id); ExamPaperEditRequestVM vm = modelMapper.map(examPaper, ExamPaperEditRequestVM.class); vm.setLevel(examPaper.getGradeLevel()); vm.setMenuIds(examPaper.getUserIds()); TextContent frameTextContent = textContentService.selectById(examPaper.getFrameTextContentId()); List<ExamPaperTitleItemObject> examPaperTitleItemObjects = JsonUtil.toJsonListObject(frameTextContent.getContent(), ExamPaperTitleItemObject.class); List<Integer> questionIds = examPaperTitleItemObjects.stream() src/main/java/com/mindskip/xzs/service/impl/ExamTemplatesServiceImpl.java
@@ -4,10 +4,7 @@ import com.github.pagehelper.PageInfo; import com.mindskip.xzs.domain.*; import com.mindskip.xzs.domain.vo.ExamTemplatesVO; import com.mindskip.xzs.repository.BaseMapper; import com.mindskip.xzs.repository.ExamTemplatesMapper; import com.mindskip.xzs.repository.ExamTemplatesQuestionMapper; import com.mindskip.xzs.repository.ExamTemplatesSubjectMapper; import com.mindskip.xzs.repository.*; import com.mindskip.xzs.service.DepartmentService; import com.mindskip.xzs.service.ExamPaperService; import com.mindskip.xzs.service.ExamTemplatesService; @@ -20,6 +17,7 @@ import org.springframework.transaction.annotation.Transactional; import java.util.ArrayList; import java.util.Arrays; import java.util.Date; import java.util.List; import java.util.stream.Collectors; @@ -33,8 +31,9 @@ private final DepartmentService departmentService; private final ExamPaperService examPaperService; private final ExamTemplatesUserCountService examTemplatesUserCountService; private final ExamTemplatesUserMapper examTemplatesUserMapper; public ExamTemplatesServiceImpl(BaseMapper<ExamTemplates> baseMapper, ExamTemplatesMapper examTemplatesMapper, ExamTemplatesQuestionMapper examTemplatesQuestionMapper, ExamTemplatesSubjectMapper examTemplatesSubjectMapper, DepartmentService departmentService, ExamPaperService examPaperService, ExamTemplatesUserCountService examTemplatesUserCountService) { public ExamTemplatesServiceImpl(BaseMapper<ExamTemplates> baseMapper, ExamTemplatesMapper examTemplatesMapper, ExamTemplatesQuestionMapper examTemplatesQuestionMapper, ExamTemplatesSubjectMapper examTemplatesSubjectMapper, DepartmentService departmentService, ExamPaperService examPaperService, ExamTemplatesUserCountService examTemplatesUserCountService, ExamTemplatesUserMapper examTemplatesUserMapper) { super(baseMapper); this.examTemplatesMapper = examTemplatesMapper; this.examTemplatesQuestionMapper = examTemplatesQuestionMapper; @@ -42,6 +41,7 @@ this.departmentService = departmentService; this.examPaperService = examPaperService; this.examTemplatesUserCountService = examTemplatesUserCountService; this.examTemplatesUserMapper = examTemplatesUserMapper; } @Transactional(rollbackFor = Exception.class) @@ -54,6 +54,8 @@ ExamTemplates examTemplates = ExamTemplatesClassConvert.INSTANCE.ExamPaperEditRequestVMToExamTemplates(model); examTemplates.setCtime(new Date()); examTemplates.setTitleName(model.getTitleItems().get(0).getName()); examTemplates.setStatus(model.getStatus()); examTemplates.setMenuIds(model.getMenuIds()); examTemplatesMapper.add(examTemplates); List<ExamTemplatesQuestion> examTemplatesQuestions = ExamTemplatesClassConvert.INSTANCE.QuestionTypeVMListToExamTemplatesQuestionList(model.getQuestionTypeVMS()) @@ -71,6 +73,19 @@ subjects.add(examTemplatesSubject); } examTemplatesSubjectMapper.saves(subjects); if("0".equals(model.getStatus())){ Object[] obj = Arrays.stream(model.getUserIds()).sorted().distinct().toArray(); Integer[] userIds = new Integer[obj.length]; for(int i = 0;i<obj.length;i++) { userIds[i] = (Integer)obj[i]; } for (Integer userId : userIds) { ExamTemplatesUser templatesUser = new ExamTemplatesUser(); templatesUser.setTemplatesId(examTemplates.getId().toString()); templatesUser.setUserId(userId.toString()); examTemplatesUserMapper.add(templatesUser); } } } @Override @@ -81,7 +96,7 @@ @Override public PageInfo<ExamTemplates> gets(ExamTemplatesVO templatesVO) { return PageHelper.startPage(templatesVO.getPageIndex(), templatesVO.getPageSize(), "id desc").doSelectPageInfo(() -> examTemplatesMapper.gets()); examTemplatesMapper.gets(templatesVO)); } @Override @@ -114,6 +129,25 @@ } @Override public Integer randomExam1(User user, Integer templatesId) throws Exception { ExamTemplatesUserCount count = new ExamTemplatesUserCount(); ExamPaperEditRequestVM vm = restore(templatesId); count.setExamTemplatesId(vm.getId()); Integer[] id = {user.getId()}; vm.setUserIds(id); vm.setType("1"); vm.setId(null); ExamPaper examPaper = examPaperService.savePaperFromVM(vm, user); ExamPaperEditRequestVM newVM = examPaperService.examPaperToVM(examPaper.getId()); count.setExamPaperId(examPaper.getId()); count.setUserId(user.getId()); examTemplatesUserCountService.add(count); return count.getExamPaperId(); } @Override public void remove(Integer id) { removes(id); } @@ -125,6 +159,7 @@ } ExamTemplates examTemplates = examTemplatesMapper.getById(id); ExamPaperEditRequestVM vm = ExamTemplatesClassConvert.INSTANCE.ExamTemplatesToExamPaperEditRequestVM(examTemplates); vm.setMenuIds(examTemplates.getMenuIds()); Integer[] ids = examTemplatesSubjectMapper.getTemplatesId(id) .stream().map(ExamTemplatesSubject::getSubjectId).toArray(Integer[]::new); vm.setSubjectId(ids); @@ -137,6 +172,15 @@ list.add(examPaperTitleItemVM); vm.setTitleItems(list); vm.setAggregateSource(100); if("0".equals(examTemplates.getStatus())){ List<ExamTemplatesUser> byId = examTemplatesUserMapper.getById(id); List<String> collect = byId.stream().map(ExamTemplatesUser::getUserId).collect(Collectors.toList()); Integer[] userIds = new Integer[collect.size()]; for (int i = 0; i < collect.size(); i++) { userIds[i] = Integer.parseInt(collect.get(i)); } vm.setUserIds(userIds); } return vm; } public void removes(Integer id){ src/main/java/com/mindskip/xzs/viewmodel/admin/exam/ExamPaperEditRequestVM.java
@@ -44,6 +44,8 @@ private Integer[][] userId; private String type; private String status; private String menuIds; @@ -174,4 +176,20 @@ public void setType(String type) { this.type = type; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } public String getMenuIds() { return menuIds; } public void setMenuIds(String menuIds) { this.menuIds = menuIds; } } src/main/java/com/mindskip/xzs/viewmodel/admin/exam/ExamPaperPageRequestVM.java
@@ -16,6 +16,7 @@ private String userName; private String templatesName; private Integer templatesId; private String status; public Integer getId() { return id; @@ -96,4 +97,12 @@ public void setTemplatesId(Integer templatesId) { this.templatesId = templatesId; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } } src/main/java/com/mindskip/xzs/viewmodel/student/dashboard/PaperInfo.java
@@ -8,6 +8,7 @@ private String name; private Date limitStartTime; private Date limitEndTime; private String status; public Integer getId() { return id; @@ -40,4 +41,12 @@ public void setLimitEndTime(Date limitEndTime) { this.limitEndTime = limitEndTime; } public String getStatus() { return status; } public void setStatus(String status) { this.status = status; } } src/main/resources/mapper/ExamPaperAnswerMapper.xml
@@ -344,5 +344,16 @@ from t_exam_paper_answer where create_user = #{createUser} and create_time between '2023-01-01'and '2023-12-31' </select> <select id="getByExamPaperIds" resultMap="BaseResultMap" parameterType="list"> select <include refid="Base_Column_List1" /> from t_exam_paper_answer where exam_paper_id in <if test="ids !=null and ids.size() > 0"> <foreach collection="examTemplatesUserCount" item="item" index="item" open="(" separator="," close=")"> #{item} </foreach> </if> </select> </mapper> src/main/resources/mapper/ExamPaperMapper.xml
@@ -18,11 +18,12 @@ <result column="deleted" jdbcType="BIT" property="deleted" /> <result column="task_exam_id" jdbcType="INTEGER" property="taskExamId" /> <result column="type" jdbcType="VARCHAR" property="type" /> <result column="user_ids" jdbcType="VARCHAR" property="userIds" /> </resultMap> <sql id="Base_Column_List"> id, name, subject_id, paper_type, grade_level, score, question_count, suggest_time, limit_start_time, limit_end_time, frame_text_content_id, create_user, create_time, deleted, task_exam_id, type deleted, task_exam_id, type, user_ids </sql> <select id="selectByPrimaryKey" parameterType="java.lang.Integer" resultMap="BaseResultMap"> select @@ -39,14 +40,14 @@ paper_type, grade_level, score, question_count, suggest_time, limit_start_time, limit_end_time, frame_text_content_id, create_user, create_time, deleted, task_exam_id, type create_time, deleted, task_exam_id, type, user_ids ) values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{subjectId,jdbcType=INTEGER}, #{paperType,jdbcType=INTEGER}, #{gradeLevel,jdbcType=INTEGER}, #{score,jdbcType=INTEGER}, #{questionCount,jdbcType=INTEGER}, #{suggestTime,jdbcType=INTEGER}, #{limitStartTime,jdbcType=TIMESTAMP}, #{limitEndTime,jdbcType=TIMESTAMP}, #{frameTextContentId,jdbcType=INTEGER}, #{createUser,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP}, #{deleted,jdbcType=BIT}, #{taskExamId,jdbcType=INTEGER}, #{type,jdbcType=VARCHAR} #{type,jdbcType=VARCHAR}, #{userIds,jdbcType=VARCHAR} ) </insert> <insert id="insertSelective" parameterType="com.mindskip.xzs.domain.ExamPaper" useGeneratedKeys="true" keyProperty="id"> @@ -100,6 +101,9 @@ <if test="type != null"> type, </if> <if test="userIds != null"> user_ids, </if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null"> @@ -150,6 +154,9 @@ <if test="type != null"> #{type,jdbcType=VARCHAR}, </if> <if test="userIds != null"> #{userIds,jdbcType=VARCHAR}, </if> </trim> </insert> <update id="updateByPrimaryKeySelective" parameterType="com.mindskip.xzs.domain.ExamPaper"> @@ -197,6 +204,9 @@ <if test="taskExamId != null"> task_exam_id = #{taskExamId,jdbcType=INTEGER}, </if> <if test="userIds != null"> user_ids = #{userIds,jdbcType=INTEGER}, </if> </set> where id = #{id,jdbcType=INTEGER} </update> src/main/resources/mapper/ExamTemplatesMapper.xml
@@ -8,22 +8,24 @@ <result column="suggest_time" jdbcType="VARCHAR" property="suggestTime"/> <result column="title_name" jdbcType="VARCHAR" property="titleName"/> <result column="ctime" jdbcType="TIMESTAMP" property="ctime"/> <result column="status" jdbcType="VARCHAR" property="status"/> <result column="menu_ids" jdbcType="VARCHAR" property="menuIds"/> </resultMap> <sql id="Base_Column_List"> id , name, paper_type, suggest_time, title_name, ctime , name, paper_type, suggest_time, title_name, ctime, status, menu_ids </sql> <insert id="add" parameterType="com.mindskip.xzs.domain.ExamTemplates" useGeneratedKeys="true" keyProperty="id"> insert into t_exam_templates (name, paper_type, suggest_time, title_name, ctime) values (#{name}, #{paperType}, #{suggestTime}, #{titleName}, #{ctime}) insert into t_exam_templates (name, paper_type, suggest_time, title_name, ctime, status, menu_ids) values (#{name}, #{paperType}, #{suggestTime}, #{titleName}, #{ctime}, #{status}, #{menuIds}) </insert> <select id="getTime" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from t_exam_templates from t_exam_templates where status is null order by ctime desc limit 1 </select> @@ -32,6 +34,15 @@ select <include refid="Base_Column_List"/> from t_exam_templates where <choose> <when test="status != null"> status = 0 </when> <otherwise> status is null </otherwise> </choose> </select> <select id="getById" resultMap="BaseResultMap"> @@ -43,7 +54,7 @@ <select id="getByName" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from t_exam_templates where name = #{name} from t_exam_templates where name = #{name}/ </select> <delete id="removeById" parameterType="java.lang.Integer"> src/main/resources/mapper/ExamTemplatesUserCountMapper.xml
@@ -19,17 +19,23 @@ </insert> <select id="list" resultType="com.mindskip.xzs.domain.vo.ExamTemplatesUserCountVO" parameterType="com.mindskip.xzs.viewmodel.admin.exam.ExamPaperPageRequestVM"> SELECT exam_templates_id as id, count(*) as count, user_id as userId FROM `t_exam_templates_user_count` SELECT u.exam_templates_id as id, count(*) as count, u.user_id as userId FROM `t_exam_templates_user_count` u left join t_exam_templates e on u.exam_templates_id = e.id <where> <if test="templatesId != null"> and exam_templates_id = #{templatesId} </if> <if test="userId != null"> and user_id = #{userId} </if> <if test="templatesId != null"> and u.exam_templates_id = #{templatesId} </if> <if test="userId != null"> and u.user_id = #{userId} </if> <if test="status != null"> and e.status = 0 </if> <if test="status == null"> and e.status is null </if> </where> GROUP BY exam_templates_id, user_id GROUP BY u.exam_templates_id, u.user_id </select> <select id="getByTemplatesIds" resultMap="BaseResultMap"> src/main/resources/mapper/ExamTemplatesUserMapper.xml
New file @@ -0,0 +1,31 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.mindskip.xzs.repository.ExamTemplatesUserMapper"> <resultMap id="BaseResultMap" type="com.mindskip.xzs.domain.ExamTemplatesUser"> <id column="id" jdbcType="INTEGER" property="id"/> <result column="templates_id" jdbcType="VARCHAR" property="templatesId"/> <result column="user_id" jdbcType="VARCHAR" property="userId"/> </resultMap> <sql id="Base_Column_List"> id, templates_id, user_id </sql> <insert id="add" parameterType="com.mindskip.xzs.domain.ExamTemplatesUser" useGeneratedKeys="true" keyProperty="id"> insert into t_exam_templates_user (templates_id, user_id) values (#{templatesId}, #{userId}) </insert> <select id="getById" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from t_exam_templates_user where templates_id = #{id} </select> <select id="getByUserId" resultMap="BaseResultMap"> select <include refid="Base_Column_List"/> from t_exam_templates_user where user_id = #{userId} and templates_id = #{templatesId} </select> </mapper>
