Data processing of bird and gun changing timetable
· Log record · 4 Comments 4422 Views

Data processing of bird and gun changing timetable

· Log record · 4 Comments 4422 Views


Since I went to college, I wanted to rain in the school's educational administration system, but the result was unpleasant. So you can only download the public class information on the educational administration website of the school to do a little action.
 Timetable data

Freshman - shotgun

At the freshman year, young and ignorant entered the student network technology department. Although the Ministry occupied most of the leisure time, it was good to get a girlfriend. Of course, this is not important. I would like to say that: at that time, a deputy department wanted to send a picture of the empty classroom to the student's daily to facilitate the students to check. In a few days, they asked me to discuss whether they could write an empty classroom inquiry system, which would be more convenient. But then Knowledge level and cognitive scope In the face of hundreds of classrooms in the school, the school timetable is at a loss. At last, the other ministries and commissions of our department hand in hand to organize and compile the data to the database after hand. I will not tell you that I have recorded the data for one week: (of course, I use the evening time to input every day. However, it is very satisfying to get the final result of the harvest.
 Empty classroom unit

Sophomore cannon

When I was in my sophomore year, I had to choose whether to stay at the student union or not. My personal opinion was that students could organize their organizational skills and so on. Later, in the development of "up sign", PHPExcel happened to be used. It was found that Excel was a good way to deal with this problem, so after idle time, it began to study it, and finally realized batch processing of classes, teachers and classroom schedules in the whole school.

Process of timetable processing

When dealing with class and teacher timetable, it is found that nineteenth rows and 36 rows are blank lines in the Excel form, which may be added to the difference between the afternoon and the evening. But in this case, a for cycle can not be completed. Finally, only three for cycles can be compromised to deal with the courses in the morning, afternoon and evening. If there are better suggestions in this respect, please contact me. Thank you!

The small problem is fine, but when it comes to dealing with empty classrooms, the problem is coming again. At the very beginning, I wanted to cycle odd numbers in one week, and circulate the binary numbers in a couple of weeks. After that, I went online to the small program. As a result, I received feedback that most of the classrooms had classes. I just responded. I made the "empty classroom" into a "classrooms". So I immediately went back to the small program platform to return the version to the version without empty classroom query function. I thought it was "reverse". Array_diff We can turn class data into "no class" data. /freeroom.php#L16-L36 OK! Finished.

Thanks to the php-cli mode, data can be cycled to the end without setting up. Set_time_limit We must say that the PHP law is 2333: P


I think the way of handling is not efficient enough, so friends who are interested in it can do so. Educational administration website Download the course data for processing, or Github Advice above!

Add new comments
  1. Do you want Amway's own colleges to try

    1. @ Ji Chang Xin

      It's interesting, but at present, the educational administration system in our school is not open.

      1. Zhang genius

        Use the intranet to penetrate.

        1. @ Zhang Tiancai

          Yes, it has now been settled.