Cerrado

Build a website with Database

Project Description:

We are contractors to FedEx and we deliver FedEx Packages. We get a contract from FedEx which is usually 1 year, sometimes can be 2 years as well. There can be multiple contracts active at a time. The contract has rates for every business stop (FedEx calls business stops as Ground Stops), and every home delivery stop (FedEx calls Home Delivery stops as Ecommerce Stops).

The Employee and Vehicle tables will have all the information about the employees and about the trucks. The vehicles could be Vans (Step Vans or Cargo Vans) or trucks (Cutaway trucks or Box Trucks).

Daily Attendance is for marking attendance for employees. I don’t know if there should be a separate table for that or if we can incorporate it in some other table. That’s for you to decide. Attendance could be P meaning Present, CO meaning Call Out, NCNS meaning No Call No Show, DO is Day Off, PTO is Paid Time Off, S is suspended. WA is the Work Area (explained below).

Everyday we run different routes. A route is called a Work Area. A driver drives a vehicle on a work area on any given date. FedEx loads packages on the truck assigned to a work area. For example, on Thursdays, we run 9 work areas. One of them might have 120 stops and 145 packages, the other work area might have 95 stops and 102 packages and so on.

We want a website where each user should be able to login and check his weekly stops and packages delivered and picked up along with their attendance. The manager should be able to enter data and view some reports. Admin user should be able to enter data and view all reports. The data to be stored, mentioned on the next page, is only an idea of what needs to be stored. More data might be needed to get the reports mentioned on page 3. The structure of the database and the entities will be decided by the developer. The next page is by no means a database schema. More report requirements will be communicated as and when required.

Please ask as many questions as you can. This project is at a preliminary stage and more information will be clear as we start the project and as more questions are answered.

Habilidades: PHP, Diseño de sitios web, Desarrollo de base de datos, Web Hosting, MySQL

Sobre el cliente:
( 1 comentario ) Cranston, United States

Nº del proyecto: #33737218

136 freelancers están ofertando un promedio de $716 por este trabajo

(429 comentarios)
9.6
(189 comentarios)
9.4
(57 comentarios)
9.2
(749 comentarios)
9.4
r4rony

Hi, Hope you are doing well! I have carefully read your project description you really explained it well. I hope this system have a web admin with driver mobile app to track live location of vans or trucks. In the ad Más

$500 USD en 15 días
(238 comentarios)
9.1
(404 comentarios)
9.0
(861 comentarios)
9.1
(246 comentarios)
8.7
(291 comentarios)
8.8
(189 comentarios)
8.5
(393 comentarios)
8.8
(296 comentarios)
8.3
AzzkaNoor

Hi. I have seen your project. "Build a website with Database". Experienced Web developer here with 7+ years of extensive hands-on experience in Web development. I am happy to mention that I rank in the top 2% among 58+ Más

$750 USD en 20 días
(68 comentarios)
8.3
(285 comentarios)
8.1
Brightinfotech3

Dear Sir/Mam, I Hope you are doing well..!!! I have gone through your project detail as per my understanding we need to design and develop website with database based on your requirement. For more discussion kindly Más

$450 USD en 7 días
(353 comentarios)
7.9
(116 comentarios)
8.0
(401 comentarios)
7.7
gahisharma

Hi, Hope you are doing well. We are a much expertise group of iOS, Android, Website developers, and Designers. We have developed Native Apps for various concepts like: #E-commerce, #Social Network, #Chat App - Voice Más

$500 USD en 7 días
(38 comentarios)
7.8
sapnathakur14

Dear Hiring Manager, I hope you are doing Great ..!! I am writing to express my interest in your job opening for a Magento developer. About me:- ================== Over the last 6+ years, I am working as a Magento de Más

$500 USD en 7 días
(136 comentarios)
7.8
sashast

Hi, there ⭐⭐⭐⭐⭐ my portfolio website ⭐⭐⭐⭐⭐ [login to view URL] I am proficient with website design and development I have good experience of 4+ years in this field and I have done a few projects similar to your Más

$500 USD en 7 días
(6 comentarios)
7.5