Đã Đóng

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.

Kĩ năng: PHP, Thiết kế trang web, Phát triển cơ sở dữ liệu, Web Hosting, MySQL

Về khách hàng:
( 1 Nhận xét ) Cranston, United States

ID dự án: #33737218

136 freelancer chào giá trung bình$716 cho công việc này

(429 Nhận xét)
9.6
(189 Nhận xét)
9.4
(57 Nhận xét)
9.2
(749 Nhận xét)
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 Thêm

$500 USD trong 15 ngày
(238 Nhận xét)
9.1
(404 Nhận xét)
9.0
(861 Nhận xét)
9.1
(246 Nhận xét)
8.7
(291 Nhận xét)
8.8
(189 Nhận xét)
8.5
(393 Nhận xét)
8.8
(296 Nhận xét)
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+ Thêm

$750 USD trong 20 ngày
(68 Nhận xét)
8.3
(285 Nhận xét)
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 Thêm

$450 USD trong 7 ngày
(353 Nhận xét)
7.9
(116 Nhận xét)
8.0
(401 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(38 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(136 Nhận xét)
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 Thêm

$500 USD trong 7 ngày
(6 Nhận xét)
7.5