1、查询班次信息<br>classScheduleGateway.getByClassId(qry.getClassId())<br>表class_schedule<br>
SELECT id,class_id,class_name,version,org_id,org_code,org_name,status,del,creater,modify_time,create_time,modifier FROM class_schedule WHERE del=false AND (class_id = 1722858607073157122)<br>
2、又查一次班次信息<br>classScheduleGateway.getByClassId(classId())<br>表class_schedule
3、查询class_info获取班次培训起止日期<br>classInfoGateway.getClassById(classId)<br>表class_info
SELECT id,name,org_id,org_name,type,year,main_term,main_type,main_attachment,main_day,master_year,study_start_time,study_end_time,study_method,student_count,report_count,study_hour,classroom_id,classroom_name,enter_type,plan,enter_start_time,enter_end_time,dept_id,dept_name,enter_place,enter_contact_person,enter_contact,remark,status,del,create_time,creater,modify_time,modifier,org_code,course_release_status,course_release_time,text_manager_name,text_attendant_name,temp_hand_book,is_on_file FROM class_info WHERE id=1722858607073157122 AND del=false<br>
4、查询排课日志，就是哪个日期有什么课<br>classScheduleUndoLogGateway.list<br>表class_schedule_undo_log<br>
SELECT id,class_id,schedule_id,version,version_sn,day,time_segment,time_segment_sn,action,data,del,creater,create_time,modifier,modify_time FROM class_schedule_undo_log WHERE (schedule_id = 1722858607110905858 AND version = 1 AND day >= '2023-11-11' AND day < '2023-12-31') ORDER BY id ASC
