$result_course = $conn->query($sql_course);
$info_course = $result_course->fetch_array();
echo "<td>";
echo $info_course['course_name'];
echo "</td>";
$sql_teacher = "SELECT teacher_name FROM `teacher` WHERE teacher_id = '" . $info_course['teacher_id'] . "'";
$result_teacher = $conn->query($sql_teacher);
$info_teacher = $result_teacher->fetch_array();
echo "<td>";
echo $info_teacher['teacher_name'];
echo "</td>";
$week = substr($info['time_add'], 10, 2);
$j_jie = substr($info['time_add'], 12, 1);
$z_zhou = substr($info['time_add'], 13, 1);
echo "<td>";
echo "第" . $week . "周 " . zhou($z_zhou) . " " . jie($j_jie);
echo "</td>";
$address = substr($info['time_add'], 5, 2);
$sql_address = "SELECT * FROM school where school_id = '{$address}'";
$result_address = $conn->query($sql_address);
$info_address = $result_address->fetch_array();
echo "<td>";
echo $info_address['school_name'] . substr($info['time_add'], 7, 3);
echo "</td>";
echo "<td>";
$class_array = explode('@', $info['course_class']);
//班级信息分割成数组
//编辑专业班级字符串
$class = "";
for ($i = 0; $i < count($class_array); $i++) {
$sql3 = "select student_major from student_information where student_number = substr({$class_array[$i]},1,6)";
$objPHPExcel->getActiveSheet()->setCellValue('C2', '课程');
$objPHPExcel->getActiveSheet()->getStyle('C2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('C2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('D2', '班级');
$objPHPExcel->getActiveSheet()->getStyle('D2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->setCellValue('E2', '备注');
$objPHPExcel->getActiveSheet()->getStyle('E2')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('E2')->getFont()->setBold(true);
$sql = "SELECT `time_add`,`course_id`,`course_class`,`tips` FROM `teacher_sj_schedule` WHERE time_add like '{$db_year}%' AND course_class!='' AND course_id in (SELECT course_id FROM `course` WHERE teacher_id = " . $teacher_row['teacher_id'] . ")ORDER BY time_add";
$result = $conn->query($sql);
$i = 3;
while ($row = $result->fetch_assoc()) {
//第一列
$col_a = GetTimeCol($row['time_add']);
$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, '第' . $col_a['week'] . '周 ' . zhou($col_a['zhou']) . ' ' . jie($col_a['jie']));
//第二列
$info_address = GetSiteCol($conn, $row['time_add']);
$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $info_address['school_name'] . substr($row['time_add'], 7, 3));
//第三列
$info_course = GetCourseCol($conn, $row['course_id']);
$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $info_course['course_name']);
//第四列
$class = GetClassCol($conn, $row['course_class']);
$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $class);
//第五列
$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, $row['tips']);
$lesson_sheet[] = array('week' => $col_a['week'], 'zhou' => $col_a['zhou'], 'jie' => $col_a['jie'], 'address' => $info_address['school_name'] . substr($row['time_add'], 7, 3), 'course' => $info_course['course_name']);
//居中
$objPHPExcel->getActiveSheet()->getStyle('A' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B' . $i)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
