|
查詢篇-如何查詢顧問名下正式學員數(shù)量？
2016年09月27日 08:59
點擊率：10042
|
 查詢市場部門員工所招的學員數(shù)量，時間是以學生報名的時間為準，如果要百分百準確請在學員報名時候從潛在學員里轉(zhuǎn)正并提交。通過查詢可以方便了解員工的本月招生業(yè)績。  1.轉(zhuǎn)正操作。【客服】-【顧問工作臺】-【潛在回訪】找到要轉(zhuǎn)正的學員點【轉(zhuǎn)正】。 注意事項：
一、“轉(zhuǎn)正”只是錄入正式學員信息的一個快捷方式，點擊“轉(zhuǎn)正”后，需要補充學員信息，點擊提交才能報名成功。 二、如果您不具備“轉(zhuǎn)正”權限，而擁有正式報名權限，可直接進入（報名客服-學員報名）錄入學員信息，如果尋找到匹配的手機號碼、郵箱、QQ等咨詢信息，系統(tǒng)會自動將潛在咨詢信息處理成“成功”狀態(tài)。   2.添加查詢應用。【分析】-【查詢管理】-【應用市場】找到“ 查詢顧問名下正式學員數(shù)量 ”點綠色下載箭頭添加查詢應用。   3.對查詢進行授權，由指定權限的人員進行查看及出現(xiàn)位置設置。      access版本 主查詢： Select
Student.SchoolName as 校區(qū)名稱,
Student.ConsultantID as 顧問編號,
Student.ConsultantName as 顧問姓名,
count(Student.StudentID) as 人數(shù),
Student.ConsultantID as ShowKey,
Student.SchoolName as ShowKey1
from Student
where
SchoolID in ( {@SchoolID:校區(qū)} )
and Student.DateAndTime >= {@StartDate:開始日期}
and Student.DateAndTime <= {@EndDate:結(jié)束日期}
and Student.ConsultantID <> NULL
group by Student.SchoolName,Student.ConsultantID,Student.ConsultantName
子查詢：
Select
Student.SchoolID as 校區(qū)編號,
Student.SchoolName as 校區(qū)名稱,
Student.StudentID as 學號,
Student.StudentName as 學員姓名,
Student.Byname as 別名,
Student.Appellation as 稱呼,
GetSex(Student.Sex) as 性別,
GetStudentType(Student.StudentType) as 學員類型,
Student.Birthday as 出生日期,
Student.DateAndTime as 報名日期,
Student.Tel as 電話,
Student.MobileTel as 手機,
Student.Tel1 as 其它電話1,
Student.Tel2 as 其它電話2,
Student.Tel3 as 其它電話3,
Student.Email as 電子信箱,
Student.HomeAddress as 家庭地址,
Student.PostCode as 郵編,
Student.School as 學校,
Student.Grade as 年級,
Student.Class as 班級,
Student.Company as 單位,
Student.Headship as 職務,
Student.IDcard as 身份證號,
Student.SignInID as ID卡號,
Student.LastClassName as 最后加入的班級,
Student.StuClassCount as 選班數(shù)量,
Student.ConsultantID as 顧問編號,
Student.ConsultantName as 顧問姓名,
Student.MediaID as 媒體編號,
Student.MediaName as 媒體名稱,
Student.Remark as 備注,
Student.UserID as 錄入者編號,
Student.TrueName as 錄入者姓名
from Student
where
SchoolID in ( {@SchoolID:校區(qū)} )
and Student.DateAndTime >= {@StartDate:開始日期}
and Student.DateAndTime <= {@EndDate:結(jié)束日期}
and Student.ConsultantID= {@ShowKey}
and Student.SchoolName= {@ShowKey1}
SQL版
主查詢：
Select
Student.SchoolName as 校區(qū)名稱,
Student.ConsultantID as 顧問編號,
Student.ConsultantName as 顧問姓名,
count(Student.StudentID) as 人數(shù),
Student.ConsultantID as ShowKey,
Student.SchoolName as ShowKey1
from Student
where
SchoolID in ( {@SchoolID:校區(qū)} )
and Student.DateAndTime >= {@StartDate:開始日期}
and Student.DateAndTime <= {@EndDate:結(jié)束日期}
and Student.ConsultantID <>''
group by Student.SchoolName,Student.ConsultantID,Student.ConsultantName
子查詢：
Select
Student.SchoolID as 校區(qū)編號,
Student.SchoolName as 校區(qū)名稱,
Student.StudentID as 學號,
Student.StudentName as 學員姓名,
Student.Byname as 別名,
Student.Appellation as 稱呼,
GetSex(Student.Sex) as 性別,
GetStudentType(Student.StudentType) as 學員類型,
Student.Birthday as 出生日期,
Student.DateAndTime as 報名日期,
Student.Tel as 電話,
Student.MobileTel as 手機,
Student.Tel1 as 其它電話1,
Student.Tel2 as 其它電話2,
Student.Tel3 as 其它電話3,
Student.Email as 電子信箱,
Student.HomeAddress as 家庭地址,
Student.PostCode as 郵編,
Student.School as 學校,
Student.Grade as 年級,
Student.Class as 班級,
Student.Company as 單位,
Student.Headship as 職務,
Student.IDcard as 身份證號,
Student.SignInID as ID卡號,
Student.LastClassName as 最后加入的班級,
Student.StuClassCount as 選班數(shù)量,
Student.ConsultantID as 顧問編號,
Student.ConsultantName as 顧問姓名,
Student.MediaID as 媒體編號,
Student.MediaName as 媒體名稱,
Student.Remark as 備注,
Student.UserID as 錄入者編號,
Student.TrueName as 錄入者姓名
from Student
where
SchoolID in ( {@SchoolID:校區(qū)} )
and Student.DateAndTime >= {@StartDate:開始日期}
and Student.DateAndTime <= {@EndDate:結(jié)束日期}
and Student.ConsultantID= {@ShowKey}
and Student.SchoolName= {@ShowKey1}
連云港麥田軟件開發(fā)有限公司(原名：連云港市蘇網(wǎng)軟件開發(fā)有限公司)，坐落在著名的西游記故鄉(xiāng)、水晶之鄉(xiāng)、黃海之濱--江蘇.連云港，是專業(yè)的教育培訓管理解決方案提供服務商，旗下產(chǎn)品--麥田培訓學校管理軟件(原名：蘇網(wǎng)培訓學校管理軟件)是國內(nèi)最知名使用人數(shù)最多的培訓管理軟件之一。
麥田培訓學校管理軟件早期研發(fā)地點：江蘇.蘇州，故曾命名為“蘇網(wǎng)”。早期的培訓模型主要參考上海、江浙等沿海一帶的培訓機構。2008年春，正式企業(yè)化運作，不斷采集全國各大城市及海外華人培訓特點，各類培訓機構管理方式。提煉管理的普遍性，進行標準化、通用化。并且研發(fā)各種查詢、報表、打印、系統(tǒng)提醒、短信編程等元素，實現(xiàn)企業(yè)的個性化需求。——麥田培訓學校管理軟件不僅僅是一款管理類軟件，更是培訓管理系統(tǒng)的開發(fā)平臺。MTcnsoft 專業(yè)于教育培訓管理的開發(fā)，擁有資深的培訓行業(yè)軟件架構師，加上多年的開源及運作經(jīng)驗，對用戶的需求、使用習慣等理解十分透徹，自從成立公司后，不斷招聘研發(fā)人員，為我們向廣大用戶提供更優(yōu)質(zhì)的服務和產(chǎn)品有了更大的保障。
麥田培訓學校管理軟件基于C#+Sql Server的技術開發(fā)，功能十分強大成熟，實施成本低。從2006年開始發(fā)布第一個正式版本以來，至今已經(jīng)發(fā)布兩個系列，多款優(yōu)秀版本。麥田培訓學校管理軟件以簡單、健壯、靈活、幾大特點深受廣大用戶的青睞。
我們對產(chǎn)品追求的終極目標是：實用，易用！
擁有麥田，擁有一個好的未來！
銷售熱線：0518-85201423
服務熱線：0518-85201423
|