Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Need help with this Report Management System.

zupal1461zupal1461 Posts: 5Member
First of,
I don't know where to post this, so if needed, please transfer this topic to the right thread. Thanks :)

Now,
I am a 4th year BSIT graduating student and currently OJT (On-The-Job Training). (not sure if this will be of any use though)

We chose to create a system for a company who gave us a system to make.

This system that they want is to be done using MySQL as their database. The programming language, we are still choosing between VB.Net, PHP and Java. Also, the system should be able to do it's task offline, and should be ready for online implementation

Now, this system, is a 3-level system (main office, field office, sub-office).


-- the sub-office, will be creating a report and,
a.) if offline, generate a report and save it in a certain file format which will be email to the field office,
b.) if online, generate a report and then send it to the field office.

-- the field office, after receiving the report from the sub-offices (there are several sub-offices in every field office), will then collect and collate all the data from the sub-offices.
a.) if offline, the program should be able to import the report from the sub-office to be saved in the database
b.) if online, receive the report then save it to the database

after receiving and collecting, it will then create a new report based on the data collected, then send it to the main office, which will then save it to their database, and collate all the data from the field offices.
And just like the field office, the main office should be able to do both a and b in the field office. An addition, the company also wants to be able to view the report coming from the sub-offices.

THE PROBLEM:
Our problem now is,
- In what file format do we save the report, so that only the data written in that report will/can be extracted and saved to the database?
-- or, is their another way that we can import/export selected data from the database that we can implement using either JAVA or PHP?

- Is their a way to implement or run a PHP web application in offline mode (or something like that)?

* If there are problems, or if my post or question isn't clear enough, please do tell. I will try my best to clear it as much as I can.

* We are asked to finish this in one month. And all the advice, links, reference will really help a lot.

- Thank you in advance.
Sign In or Register to comment.