Loading...

PULSE

Corporate information system
 /   /  PULSE

1. Objective

The subject area is helicopter flights. The Flight service was tasked to organize a remote collaboration at company branches, getting rid of paper-based workflows, Microsoft Word and Excel files transferred via e- mail. It was decided to create a Corporate Information System (ERP) to solve these problems.

2. Result

Air Line company ERP with high functionality:

  • Keeping a lot of documents in digital format with an attached scan copy
  • Timetable uploading in Excel format
  • SMS sending
  • Telegram-bot integration
  • Generating flight data
  • User actions logging
  • Unloading of flight statistics for customers in Excel format
  • Automatic dispatch of operational flight plan via e-mail and Telegram-bot
  • Data storage of the aircrafts condition, aviation components and their logistics
  • ...and many others

3. Experience

I got an experience with:

  • Koala Framework
  • ExtJS 2.3 frontend library based on JavaScript
  • Zend Framework 1.12 and it's ORM based on PHP
  • MVC pattern
  • PHPExcel 1.8 library
  • Composer dependency manager
  • SMTP protocol for e-mail sending
  • SMPP protocol for SMS sending
  • Telegram bots API
  • Ububtu Server 14.04. Cron jobs, logrotate, files and folders permissions.
  • MySQL server 5.7 and DB architecture
  • Apache 2.4 web-server
Flights page

Employees page (captains, co-pilots, engeneers)

Project details

Client: Aviashelf

Date: September 29, 2017

At the moment, "PULSE" ERP is servicing 3 branches of an Air Line Company and in addition to the Flight service (FS) it covers the Engineering and Aviation Service (EAS), the Production Dispatch Department (PDD), the Production Dispatch Service (PDS), the Material and Technical Supply Department (MTSD) and partly Accounting. The FS is filled out with information about pilots’ names, personal data, documents with scan copies, flight checks and other flight documents. Captains enter data about performed types of work that automatically generates a code for their timetables which can be uploaded to Excel and passed to the accounting department. EAS enters employees personal data of its employees into the system, so those employees can be selected and added to a flight task.

The PDS uses the system as an interactive "electronic board" which shows a list of all machines and their current operating status: serviceable, faulty, and if faulty, which components are required to be replaced, how much time it takes for replacement and other. PDD forms flight tasks, communicating directly with customers, and also maintains an operational plan for all flights - any changes recorded in the database are sent by e-mail and Telegram to internal employees of the Air Line Company and customers. MTSD conducts logistics - which aviation components are on track and by which date should be delivered. The ERP is connected to the Telegram, in addition to automatic data sending, it can respond to requests and show both a general operational plan and the same plan for an employee, it can also display a list of periodic inspections that need to be repeated.


 Previous  All works Next