优化菜单查询

EricsHu

2023-11-26 1da190e7f267bcd3501884f3aeaac7476850fec7

 src/main/java/com/qxueyou/scc/evaluate/service/impl/EvaluateService.java

@@ -63,6 +63,11 @@
import com.qxueyou.scc.teach.subject.model.QSubject;
import com.qxueyou.scc.teach.subject.model.Subject;
import com.qxueyou.scc.user.model.QUser;
import org.springframework.web.context.request.RequestContextHolder;
import org.springframework.web.context.request.ServletRequestAttributes;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;

@Service
public class EvaluateService extends CommonAppService implements IEvaluateService {
@@ -152,6 +157,15 @@
               hql = hql+" and s.evaluateName like:evaluateName";
               args = CollectionUtils.newObjectMap("evaluateName", keyword);
            }
            //根据创建id查询问卷列表
            HttpServletRequest request =((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
            HttpSession session = request.getSession();
            Object admin = session.getAttribute("admin");
            if (admin==null){
               hql = hql+" and s.createId in (:createId)";
               args = CollectionUtils.newObjectMap("createId",ClientUtils.getUserId());

            }
            hql = hql+" and s.deleteFlag is false group by s.evaluateId";
      List<Map<String, Object>> results2 = findListWithMapByHql(hql, args);
      for (Map<String, Object> map: results2) {