SQL Time-Tracking DB & Interface -- 2

Заказчик: AI | Опубликовано: 09.10.2025
Бюджет: 750 $

I would like to hire someone to create a Microsoft SQL database that is accessed on our intro Internet site using a web browser. The user interface will include the following fields. The staff member the staff member’s office location. The client name, the date the time started the time finished and the description of the work. I believe to do this we’re gonna need three tables one for the staff members another for the clients and a third for the office location. Built into this database and the user interface, I would like two hidden fields that the user or staff will not see they include the cost of the staffs work and the billing rate to the client I believe I will need to be able to generate two primary reports one for the work that the staff has done that includes a description of the clients. The staff worked on along with the number of hours, along with the total of their cost, and the total of the revenue generated from that specific client the second report is going to have a list of the clients. The description of the services performed the billable amount for those services and the cost along with the staff’s name for the cost of those services This server and the website will be hosted on an Internet site internally and not available to external users, and it will be a dedicated server. Core needs • Database schema that stores employee profiles, customers, raw punch data and a simple status flag so the system knows who is currently punched in. • Web interface (plain HTML/CSS/JS is fine; PHP or another thin back-end layer if you prefer) with two main screens: one for the actual punch button and one for basic admin review of today’s records. • Basic validation and protection against duplicate punches. • Simple report or query I can run to pull a date-range of hours per employee and per customer. Keep it structured and easy for a non-technical manager to extend later. If you already have a preferred stack—MySQL + PHP, SQLite + Flask, etc.—let me know; I’m flexible as long as setup is straightforward.