SURVEY 1.9 KB

123456
  1. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.service.survey.SurveyApiImpl.querySubjectlistByOrgId(SurveyApiImpl.java:2806): OrgId-------------> 10011
  2. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.dao.SurveryDaoImpl.querySubjectlistByOrgId(SurveryDaoImpl.java:1601): querySubjectlistByOrgId count sql---------------> select count(*) from SV_SUBJECT where 1=1 and Status!=0 and orgid=? and SurveyType=4[10011]
  3. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.dao.SurveryDaoImpl.querySubjectlistByOrgId(SurveryDaoImpl.java:1615): querySubjectlistByOrgId sql sql---------------> select SubjectId,SubjectTitle,PeriodOrder,ObjType,CreateTime,Status,SurveyType,Quantity,Overtime,Overtype,Replytype,(select COUNT(*) orgsample from SV_SAMPLE where SV_SAMPLE.SubjectId=SV_SUBJECT.SubjectId and SV_SAMPLE.Status=2) CountSample from SV_SUBJECT where 1=1 and Status!=0 and orgid=? and SurveyType=4 order by createtime desc[10011]
  4. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.service.survey.SurveyApiImpl.querySubjectlistByOrgId(SurveyApiImpl.java:2806): OrgId-------------> 10011
  5. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.dao.SurveryDaoImpl.querySubjectlistByOrgId(SurveryDaoImpl.java:1601): querySubjectlistByOrgId count sql---------------> select count(*) from SV_SUBJECT where 1=1 and Status!=0 and orgid=? and SurveyType=4[10011]
  6. [INFO] 2015-12-08 11:39:37 >> [A-deal-110] com.yihu.hos.dao.SurveryDaoImpl.querySubjectlistByOrgId(SurveryDaoImpl.java:1615): querySubjectlistByOrgId sql sql---------------> select SubjectId,SubjectTitle,PeriodOrder,ObjType,CreateTime,Status,SurveyType,Quantity,Overtime,Overtype,Replytype,(select COUNT(*) orgsample from SV_SAMPLE where SV_SAMPLE.SubjectId=SV_SUBJECT.SubjectId and SV_SAMPLE.Status=2) CountSample from SV_SUBJECT where 1=1 and Status!=0 and orgid=? and SurveyType=4 order by createtime desc[10011]