Company's reporting system based on PHP/MySQL. Is it a good idea?
With that system all departments will report to a common platform which in request will output statistical and expert calculations based on these reports. To be more specific all departments will report about the container park status, imports/exports of the month, prospect bookings, and business plan. The system will calculate various statistics in order to be flexible with our rates in order to motivate our customers to book with us and be able to move the containers to other recommended destinations which will be listed by the system. Also note that one rule is that containers cant be idled for long time in ports because we pay storages and it this is very expensive.
The system will accommodate other reporting and expert functions progressively, but initially will remain simple.
That system (PHP program) can also include an e-commerce section which will be targeted to potential clients or agents who might be interested to ship with us online. The e-commerce will offer credit card facilities but only for those interested to get the tariff option. For those who want an offer they need to wait for an offer number!!! Then they will enter their offer number in our system and pay by credit card if they wish!!!! The offer numbers will be stored in the same system and they can be listed on request.
The program will include an administrators panel which will be used by any administrator for a number of tasks. It will offer options like,
-Imports Exports Sample Days.
Here the administrator has the choice to enter how many days in the raw the system will use from Imports Exports table in order to make its statistical calculations.
Etc
The system in its simpler form can be used via intranet that can be set up from the existing IT department. Regular daily backups of the database would ensure smooth operation of the system.
Any ideas?
