public ListListThe Integer classTotalCount=stageClassDao. FindClassTotalCount (RowGuid); 
The Integer classStudyCount=stageClassDao. FindClassStudyCount (RowGuid); 
For (StageClass1Node stageClass: stage) {
//a stage for class 
Integer stageClassCount=stageClassDao. FindStageClassCount (stageClass getStageRowGuid ()); 
StageClass. SetStageClassCount (stageClassCount); 
The Integer buyCourseCount=courseAllDao. FindBuyCourseCount (RowGuid); 
The Integer classCount=courseAllDao. FindClassCount (RowGuid); 
StageClass. SetStudyClassCount (classStudyCount);//the current course has the number of learning lessons 
If (stageClass getTIstest ()==null) {
StageClass. SetTIstest (0); 
} 
If (buyCourseCount==null) {
StageClass. SetBuyCount (0); 
} else {
StageClass. SetBuyCount (buyCourseCount); 
} 
If (classCount==null) {
StageClass. SetClassCount (0); 
} else {
StageClass. SetClassCount (classTotalCount); 
} 
If (stageClass getBuyCount ()==null) {
StageClass. SetBuyCount (0); 
} 
for (int i=0; iString classRowGuid=stage. The get (I). GetClassRowGuid (); 
List ClassLinkStatus=classLinkVoDao. FindClassLinkStatus (classRowGuid); 
For (ClassLinkVo ClassLinkVo: classLinkStatus) {
Stage. The get (I). The setList (classLinkStatus); 
StageClass. SetList (classLinkStatus); 
If (classLinkVo. GetTLinkName (.) the equals (" work ")) {
ClassLinkVo. SetType (3); 
} else if (classLinkVo getTLinkName (.) the equals (" preview ")) {
ClassLinkVo. SetType (1); 
} else if (classLinkVo getTLinkName (.) the equals (" class ")) {
ClassLinkVo. SetType (2); 
} 
} 
} 
} 
Return stage; 
} 

 @ Data 
Public class StageClass1 {

private String id; 
Private String StageRowGuid; 
Private String classRowGuid; 
Private String StageName; 
Private String ClassName. 
Private String tCourseName; 
Private String ClassUpdateDate; 
Private String StageUpdateDate; 
Private String imgUrl; 
/* * 
* user name 
*/
Private String tUsername; 
/* * 
* real name 
*/
Private String tRealyname; 

Private Integer buyCount; 
Private Integer classCount; 
Private Integer tIstest; 
Private Integer studyClassCount; 
Private Integer stageClassCount; 
Private List List; 

} 

 & lt; ? The XML version="1.0" encoding="utf-8"?> 

 
 

The SELECT s.i d stage_id, s.r ow_guid stage_rowguid, s.t _name StageName, c.t _img_url, 
C.i d every, c.r ow_guid classRowGuid, c.t _name ClassName, c.t _istest, 
Co. t_course_name, e. _username, e. _realyname, c.t _update_date ClassUpdateDate, 
S.t _update_date StageUpdateDate 
The FROM tb_course co LEFT JOIN tb_stage s ON FIND_IN_SET (s.r ow_guid, Co. stage_id) LEFT the JOIN 
Tb_class c ON FIND_IN_SET (c.i d, s.t _class_id), tb_employee e WHERE Co. row_guid=# {RowGuid} 
AND s.t _update_man=e.i d 
 

 

 @ Data 
@ ToString 
Public class StageClass1Node extends StageClass1 {

Private List}