申請(qǐng)免費(fèi)試用、咨詢電話:400-8352-114
算法:根據(jù)班級(jí)狀態(tài)(開(kāi)課中,尚未開(kāi)課),搜集班級(jí)下面的學(xué)員,并且課時(shí)未上完,選班狀態(tài)正常。注意:一名學(xué)員報(bào)多門課程,會(huì)被重復(fù)統(tǒng)計(jì)。
(此查詢針對(duì)access版本,SQL版只要將其中的Now()函數(shù)替換為GetDate()即可)主查詢:Select count(*)
as 人數(shù),
Now()
as ShowKey from StuClass,Class where StuClass.ClassID =
Class.ClassID
and StuClass.Lessons >
StuClass.CourseProgress
and StuClass.ScStateID
in (1,2)
and Class.SchoolID
in (
{@SchoolID:校區(qū)} )
and ((
Class.EndDate > Now()
and Class.StartDate < Now())
or Class.StartDate > Now())
子查詢:Select StuClass.StudentID
as 學(xué)員編號(hào),
StuClass.StudentName
as 學(xué)員姓名,
StuClass.ClassID
as 班級(jí)編號(hào),
StuClass.ClassName
as 班級(jí)名稱,
StuClass.Lessons
as 已購(gòu)總課時(shí),
StuClass.CourseProgress
as 課程進(jìn)度 from StuClass,Class where StuClass.ClassID =
Class.ClassID
and StuClass.Lessons >
StuClass.CourseProgress
and StuClass.ScStateID
in (1,2)
and Class.SchoolID
in (
{@SchoolID} )
and ((
Class.EndDate >
{@ShowKey} and Class.StartDate <
{@ShowKey} )
or Class.StartDate >
{@ShowKey} )
(把以上代碼粘貼到《泛普培訓(xùn)學(xué)校管理軟件》查詢管理里,可直接使用)