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.

Taidot: PHP, Verkkosivujen suunnittelu, Tietokantakehitys, Web hosting, MySQL

Tietoa asiakkaasta:
( 1 arvostelu ) Cranston, United States

Projektin tunnus: #33737218

136 freelanceria on tarjonnut keskimäärin $716 tähän työhön

(429 arvostelua)
(189 arvostelua)
(57 arvostelua)
(749 arvostelua)

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 Lisää

$500 USD 15 päivässä
(238 arvostelua)
(404 arvostelua)
(861 arvostelua)
(246 arvostelua)
(291 arvostelua)
(189 arvostelua)
(393 arvostelua)
(296 arvostelua)

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+ Lisää

$750 USD 20 päivässä
(68 arvostelua)
(285 arvostelua)

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 Lisää

$450 USD 7 päivässä
(353 arvostelua)
(116 arvostelua)
(401 arvostelua)

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 Lisää

$500 USD 7 päivässä
(38 arvostelua)

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 Lisää

$500 USD 7 päivässä
(136 arvostelua)

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 Lisää

$500 USD 7 päivässä
(6 arvostelua)