From 784d643c8d073dc31652b03b7f1bd82a9d1c627f Mon Sep 17 00:00:00 2001
From: EricsHu <hrr145632>
Date: 星期四, 23 十一月 2023 20:21:26 +0800
Subject: [PATCH] 优化班级课程

---
 src/main/java/com/qxueyou/scc/admin/classes/service/impl/ClsClassService.java |    6 +++---
 1 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/main/java/com/qxueyou/scc/admin/classes/service/impl/ClsClassService.java b/src/main/java/com/qxueyou/scc/admin/classes/service/impl/ClsClassService.java
index 4138bff..12d3d5d 100644
--- a/src/main/java/com/qxueyou/scc/admin/classes/service/impl/ClsClassService.java
+++ b/src/main/java/com/qxueyou/scc/admin/classes/service/impl/ClsClassService.java
@@ -353,11 +353,11 @@
     @Override
     public List<Map<String,Object>> queryAvailableClassIdAndName(String teacherId,String subjectId) {
         StringBuffer hql = new StringBuffer(1000);
-        // and c.endTime>=sysdate() 澧炲姞鏉′欢杩囨护鎺夊巻鍙茬彮绾�
-        hql.append("select c.classId as classId ,c.name as className from ClsClass c where c.deleteFlag is false and c.orgId=:orgId and c.createId=:createId " );
+        // and c.endTime>=sysdate() 澧炲姞鏉′欢杩囨护鎺夊巻鍙茬彮绾� and c.createId=:createId
+        hql.append("select c.classId as classId ,c.name as className from ClsClass c where c.deleteFlag is false and c.orgId=:orgId " );
         Map<String,Object> queryParam = new HashMap<String,Object>();
         queryParam.put("orgId", ClientUtils.getOrgId());
-        queryParam.put("createId", ClientUtils.getUserId());
+//        queryParam.put("createId", ClientUtils.getUserId());
 
         if(StringUtils.isNotEmpty(teacherId)||StringUtils.isNotEmpty(subjectId)){
             hql.append(" and exists (select 1 from ClsClassReSubject r ,Subject s where r.subjectId=s.subjectId and  r.classId =c.classId and r.deleteFlag is false ");

--
Gitblit v1.8.0