PhpSpreadsheet在地铁时刻表打印排版系统中的应用研究  

Research on the Application of PhpSpreadsheet in the Printing and Typesetting System of Subway Schedule

作　　者：黄勋科 HUANG Xunke(Operation Branch of Zhengzhou Metro Group Co.,Ltd.,Zhengzhou 450000,China)

机构地区：[1]郑州地铁集团有限公司运营分公司,河南郑州450000

出　　处：《河南科技》2023年第15期13-18,共6页Henan Science and Technology

摘　　要：【目的】地铁乘务管理系统已普遍应用于国内各地铁公司运营业务,其核心功能是交路表编制、班表编制、出退勤管理、安全事件管理、考勤管理等,但仍存在部分功能不足,如在导出版时刻表排版、排班规则生成等方面还没实现“最后一码”工作。通过研究,为实现导出版时刻表自动化排版提供参考。【方法】阐述了时刻表排版的工作内容,利用PhpSpreadsheet开发时刻表打印排版系统。【结果】解决导出版时刻表排版的“最后一码”问题。【结论】时刻表打印排版系统可以实现时刻表自动化排版,提高工作效率,实现压缩交路表编制周期的目的。[Purposes]The subway crew management system has been widely used in the operation busi-ness of interior subway companies,and its core functions are the design of train number table,the design of work schedules,on and off duty management,safety incident management,attendance management and so on,but there are still some functional deficiencies.For instance,the"last code"work has not been achieved in the layout of the exported timetable and the generation of scheduling rules.The study,how-ever,provides reference for the automatic typesetting of the exported timetable.[Methods]By studying the printing and typesetting of schedule,this paper designs schedule printing and typesetting system with PhpSpreadsheet.[Findings]This"last one code"challenge in exporeted timetable has been solved.[Con-clusions]Schedule printing and typesetting system can realize schedule automatic typesetting,improve work efficiency,and then achieve the objective of period compression of the design of train number table.

关 键 词：时刻表打印排版 PhpSpreadsheet 地铁乘务管理系统 交路表编制 

分 类 号：TP391.1[自动化与计算机技术—计算机应用技术]