$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);