You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

81 lines
3.3 KiB

package com.dsideal.newUniversityExamination.selectcourse.service;
import java.util.List;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.dsideal.newUniversityExamination.selectcourse.model.ClassRoomModel;
import com.jfinal.plugin.activerecord.Record;
public class ClassRoomService {
public final static ClassRoomService service = new ClassRoomService();
private final static ClassRoomModel dao = new ClassRoomModel();
/**
* @Description: 获取基础数据 的教室信息
* @author :周明升
* @date: 2019-1-22 上午10:08:08
* @return: String
* @throws
*/
public String getWeekOfClassById(String bureauId,String notClassId,String roomLabelId) {
JSONObject resultJson = new JSONObject();
List<Record> campusList = dao.getCampusBureauId(bureauId);
JSONArray campusArr = new JSONArray();
Record record = dao.getOrgNameBybureauId(bureauId);
resultJson.put("id", bureauId);
resultJson.put("name", String.valueOf(record.get("org_name")));
for(int i=0;i<campusList.size();i++){
JSONObject campusOb = new JSONObject();
Record campusRecord = campusList.get(i);
String campusId = String.valueOf(campusRecord.get("campus_id"));
String bureauID = String.valueOf(campusRecord.get("bureau_id"));
String campusName = String.valueOf(campusRecord.get("campus_name"));
campusOb.put("upperId",bureauID );
campusOb.put("name",campusName );
campusOb.put("id", campusId);
campusOb.put("type", 1);
//获取教学楼信息
List<Record> buildingList = dao.getbuildingListByCampusId(campusId);
JSONArray buildingArr = new JSONArray();
for(int j=0;j<buildingList.size();j++){
JSONObject buildingOb = new JSONObject();
Record buildingRecord = buildingList.get(j);
String buildingId = String.valueOf(buildingRecord.get("building_id"));
String buildingName = String.valueOf(buildingRecord.get("building_name"));
buildingOb.put("id", buildingId);
buildingOb.put("name", buildingName);
buildingOb.put("campusName", campusName);
buildingOb.put("type", 2);
buildingOb.put("upperId",campusId );
List<Record> classroomList = dao.getRoomListByBuildingId(buildingId, notClassId,roomLabelId);
JSONArray classroomArr = new JSONArray();
for(int n=0;n<classroomList.size();n++){
JSONObject classroomOb = new JSONObject();
Record classroomRecord = classroomList.get(n);
String classRoomId = String.valueOf(classroomRecord.get("class_room_id"));
String classRoomName = String.valueOf(classroomRecord.get("class_room_name"));
String labelName = String.valueOf(classroomRecord.get("label_name"));
String labelId = String.valueOf(classroomRecord.get("label_id"));
classroomOb.put("id", classRoomId);
classroomOb.put("name", classRoomName);
classroomOb.put("label_name", labelName);
classroomOb.put("label_id", labelId);
classroomOb.put("type", 3);
classroomOb.put("upperId",buildingId );
classroomArr.add(classroomOb);
}
buildingOb.put("children", classroomArr);
buildingArr.add(buildingOb);
}
campusOb.put("children", buildingArr);
campusArr.add(campusOb);
resultJson.put("children", campusArr);
}
return resultJson.toJSONString();
}
}