Hello Everyone!
In this Video, I am going to tell about our Timesheet Script.
It is a Web Application developed using PHP and MySQL as Database.
This Timesheet script will be useful for anyone or any Company, and particularly it will be
very useful for small businesses and start-ups.
Because, they can save a lot of Money by purchasing our Timesheet which won't require any Monthly
Renewal Fees or Yearly Renewal Fees or any kind of "Per user" license fee.
You can just buy it by making one-time payment and you can use it for any number of users
continuously, without making any further payment.
That is the unique advantage of our timesheet script.
Apart from that we provide our script with source code.
That means, you can make any kind of custom changes in your setup, you can change the
look and feel of your timesheet, you can change any texts or you can even the work flow or
functionality of the timesheet application installed in your setup.
Since it is developed using PHP and MySQL which are open-source and free, you need not
make any other kind of payments for using our timesheet script.
That means there are no hidden charges for using this script.
We made this timesheet application very simple and easy-to-use so that any one can easily
start using this application without requiring any kind of training, and installing this
application also is very easy.
You have to just run install script from the web browser by giving MySQL connection details
and it will be installed automatically within few seconds, and after that, you can start
using the web application.
Anyway, if you find any difficulty in installing the script, we can do it for you.
Almost all the web hosting servers are provided with PHP and MySQL by default.
So, you can easily install it in any web hosting server, or if you want it to install it in
your own server, you can do it by installing Apache or any kind of web server with PHP
and MySQL Database.
Though our timesheet script is a very simple application, still it can support all the
basic features of any Timesheet.
For example, it can be used as in Attendance system for tracking employees work hours and
for assigning Project to Employees as well as checking the Return on Investment(ROI)
of any project, and it can be used managing Leave or Vacation for Employees and it can
be used for Client Billing purpose also.
This Timesheet supports various User Types, like Site Admin, Admins and Employees or Users.
The users can enter the timesheet on Daily basis or on Weekly basis, and they can submit
it on weekly.
The Admins can see the timesheet reports by filtering with various options like Projects,
Employees, or Date Range, and they can export it to pdf file or csv file, and the Defaulters
List feature can help to make sure that everyone is entering the timesheet properly.
And the site admin can take the Data backup and they can Restore it if there is a need
to do so.
A lot of our Customers are using this timesheet application, some of them are using it as
it is, and some other are using it with custom changes, we made a lot of different kinds
of custom changes, ranging from simple date format change to complete workflow change,
and if you want to develop a similar application from scratch, we can do it.
It is our Demo application.
Here you can use the built-in users or you can create you own login.
Here now I am logging in as Admin.
Admin user role is for managing Employees and Projects, and for viewing the Reports
of them, and in case of Employee Details, it will list all the Employee under him, and
he can create new Employees by giving the details like Username , it will be used for
logging in, and the Name, First name , Last Name and Company name or Department name,
he can not change for the Employee, because whatever Company is assigned for the Admin
will be coming for the Employees also.
Once after entering the details, on clicking the 'Save Details' buttons, Employee will
be created.
And the Per our Rate is for entering the Amount to be paid for the Employee per Hour of work.
These details will be used for calculating the Return on Investment (ROI) analysis of
any project.
The Admin can manage the Projects.
There are two Kinds of Projects, one is the Normal Project where the Admin has to choose
the Employees, that means assign the Employees for that project while creating the Project
or while editing the project.
Another one is Non-Project, here Admin need not assign Employees, just give the Project
Code and Project Name, and then create non-project.
For example, Leave, Training, Vacation, that kind of activities, they need not be assigned
for the Employees, so it is applicable for all the Employees, so no need to assign Employees
to that project created with Non-Project.
While entering the status, the non-projects will be appearing for all the Employees, but
the projects will be appearing to the Employees for whom the Project is assigned.
Here in the weekly status entry, the user can choose the previous week, or current week
or next week or they can just navigate using the previous/next buttons on weekly basis
and they can enter the time here and add the comments by clicking this icon and they can
either save the timesheet as the Draft or they can directly submit the timesheet.
So, if they are saving the timesheet means they can edit it at any time.
But if they are submitting it means, they can not do it again.
It will be locked.
And, once after submitting the timesheet it will be appearing in the Report.
But the details entered just by clicking the Save button won't appearing in the Report,
it will be like a Draft.
The People can either use the weekly status or daily status entry for saving the timesheet,
but they have to use the weekly for submitting it, there no option for submitting it from
the daily.
In the Daily, there are two things we need to consider.
One is, this start time and end time, it is just for reference, not going to be taken
as Work Hours, you have to enter the Work Hours separately and you can add the comments,
you can either use the Hourly basis or Minute basis.
If you have any questions you can ask me about it, and Defaulters list is nothing but the
list of Employees who haven't entered the timesheet for the selected Date.
Admin can see this, because timesheet system will be useful only if all the people are
entering the timesheet properly.
Report is simple report, but very useful.
Here the Admin can choose the Date Range- starting Date and End date for the report,
or they can filter with Employees , Projects or all combinations of these things.
Say for example, if they want to see the report for this particular user, choose like this,
it will be showing the report only for that user and for any particular project we can
filter, and we can choose the project and then choose All employees and we can choose
the time also.
And, they can see the report as the PDF or they can see it as CSV file also .
If there are a lot of employees just use the auto suggestion/completion, like you can type few letters, it will be
populating the list of employees, similarly you can use it for Project also.
Now let me login as Employee i-e User.
In case of user login, the users can enter their own status entry using weekly status
entry screen or daily status entry screen.
They can see their own report.
Here also PDF and CSV download options are there.
It is the SiteAdmin login.
Here SiteAdmin can approve any new Admins or Deactivate any existing Admin and he can
take database backup and do the Restore operation.
In Summary, this timesheet application is a simple yet useful application.
A lot of people are using this and we have done a lot of custom changes and we can do any
kind of custom changes based on the requirements or if you want us to develop from the scratch
we can do it for your requirements and if you have any questions you can contact me
through the email.
Thanks for watching this Video.
If you like our Timesheet, tell about it to your Friends who may be interested in buying
it.