We have a client that is spending a lot of time manually entering this information into an Excel spreadsheet. This is very time consuming but it is the only way they know how to track it. The client has purchased a time clock product from a company at timeclockplus.com. They purchased 3 card swipe unit (that connects directly to the internet), 100 employee swipe cards and the software to use the application (custom software & SQL server to collect all needed information). The employees are assigned a swipe card with a unique number. As they begin work on a specific job the card is swiped & a job number is entered. The same is repeated when the employee is done working on that job. This will track who performed labor for which client at which location (naturally the date & time will also be collected). The software that comes with the product does not really fit their needs.
They would like a custom application to access the information collected by the SQL server. Then add more information to the SQL (e.g. manual labor times in & out, cost of materials used on the job, what the customer was charged for the materials and the cost of equipment rentals). All the needed information to create reports and calculate payroll would be housed within the SQL server. They would like to have a Payroll Report, Job Summary Report, Status Report of all jobs within the company and print invoices.
The SQL server contains many tables setup by the software program. One of these tables contains the swipe card information. The other tables contain information the program needs but for our purposes they are not needed. We have created a table to contain system users, materials, hours (to contain the collected data from the card swipes) and a jobs table (to contain the financial information & contain the primary key that allows all the other tables to associate to it). This will allow the collection of data pertaining to a job to be displayed.
The person that works the system should have to create the jobs, add the materials (rentals include with this) to the job & then add any labor that was performed manually (not collected by the time clock. Then the system should collect the information on the time swipes to have all the information needed about the job. The user could then view the reports to collect the information they need. This application must be easy to use & work. Its purpose is to allow the easy display of collected information.
19 freelanceria on tarjonnut keskimäärin 516 $ tähän työhön
Works been gone through throughly, we at Attr Apps make sure that the work comes out pixcel perfect! Best Regards! Attr Apps No beating around the bush.