Online Reporting System for Employees of Small & Medium Scale Companies
Description
Tired monitoring your hundreds of employees work daily in excell sheets. Then Online Reporting System simplifies your work.
There is no need for mailing reports daily
-There is no need for bulkier file attachements
-There is no need for searching particular employee report
-All your employees daily report will be available in one place.
-You can save your mailbox space
-All the reports are always available online. No fear of data loss
-Can be accessed from anywhere.
-Any number of employees can use it.
-Its simple secure and easy for both users and administrator.
Online reporting system does this for you
Admin Mode :
In the admin mode adminstrator can view the work done by any employee between any two dates.
-Administrator can add any number of employees to the database.
-All admin pages are password protected.
-There can be any number of administrators.
User Mode :
In the user mode employees can simply select their name submit their daily reports.
-There is no need to send mails.
-Any number of employees can use it.
Online Reporting System - Installation Instructions
Extract all the contents of zip archieve ( Use winzip or winrar)
Upload all the contents of "upload" directory to your webserver.
Go to your server cpanel, phpmyadmin create a database and user for it
Then select your database import the .sql file to it. ( db.sql will be found in database folder)
or
Open the db.txt file copy all the content, Then open sql query window in Phpmyadmin paste all the content and run the query. Now all the database tables will be created in your database
Then go to scripts folder, edit connect_to_mysql.php file
Put your host in the place of \\\"YOUR HOST HERE\\\" Â Â ex - $db_host = \\\"localhost\\\";
Put your USERNAME in the place of \\\"YOUR USERNAME HERE\\\" Â ex - $db_username = \\\"freelancer\\\";
Put your PASSWORD in the place of \\\"YOUR PASSWORD HERE\\\" Â ex - Â $db_pass = \\\"xyz\\\";
Put your DATABASE NAME in the place of \\\"YOUR DATABASE NAME HERE\\\" Â Â Â ex - $db_name = \\\"prototype\\\";
After doing all this save and close the file.
Suppose if you get an error while running the application as \\\"could not connect to mysql\\\" or \\\"no database\\\". Double check the above steps and repeat.
Now the application is ready to use.
See start up instructions to know how to use the application.
Online Reporting System - Start up instructions
The reporting application will have some demonstration data, you can delete it whenever using PHPMYADMIN.
Admin Mode :
In the admin mode adminstrator can view the work done by any employee between any two dates.
Administrator can add employees to the database.
All admin pages are password protected.
Go to http://www.yourdomain.com/upload_folder_name/session.php
for ex if your domain is \\\"freelancer.com\\\" and you uploaded in the directory \\\"report\\\"
Then the URL is http://www.freelancer.com/report/session.php
It asks for username & password
Demo admin username is
Username - admin
Password - admin123
You can change this credentials whenever using phpmyadmin. You can also add any number of admin users.
Then submit, once logged in you will be directed to the admin page.
First you need to add your employees to the database.
First input employee name, then employee id, then add it to the database.
You can add any number of employees.
Once added, the employees list will be displayed in the alphabatical order in both user & admin mode.
To view work done by the particular employee, select employee name, then select orgin date and then select destination date. The work done by the employee between two dates will be diplayed in ascending order if the data is available.
User Mode :
In the user mode employees can submit their daily reports.
Give your employees (users) the following link to submit their reports daily
http://www.yourdomain.com/upload_folder_name/
for ex if your domain is \\\"freelancer.com\\\" and you uploaded in the directory \\\"report\\\"
Then the URL is http://www.freelancer.com/report/
They will find the reporting form.
Each employee should select their name.
once the name is selected the Employee id will be displayed for the reference.
Then select the date (By default present day date will be selected. that can be changed)
Then enter the description of work done and submit.
The report will be stored online. Simple!!!
Online Reporting System - Customization instructions
Modifying Header :
The header consists of an image of size 751*186. Replace it with your own image with the same file name
The header image is found with in images folder.
Modifying footer :
edit the footer.php file
Change the freelancer solution pvt limited to your own comany name. It will be modified in all the pages.
Else you can design your own footer and put in footer.php
Modifying time zone :
The time zone is set as Asia/calcutta as default.
Modify it to your own time zone
go to http://www.php.net/manual/en/timezones.php
get your own timezone then you should replace your timezone in two places
edit index.php line 289 you\\\'ll find
date_default_timezone_set(\\\'Asia/Calcutta\\\');
replace \\\'asia/calcutta\\\' to your own time zone  ex date_default_timezone_set(\\\'America/New_York\\\');
Then edit display.php you\\\'ll find the same in line 87 & 159.
Change that too. Now your application is completely yours.
Questions and Comments
Make a Comment
February 28, 2011 jeet420