New PHP Web Application - Lead Data collection - Email automation - Multi-Role


• Login Authentication (Email w/validation + Password)

o Customer Role (Default)

o Admin Role (Additional tab for reporting/exporting)

• Data Validation/Collection

• Email Notification (daily automated process)

o Additional PHP or HTML as needed to make website 100% functional

A custom CMS build is preferred but will accept a free content management system ([url removed, login to view], Joomla, Drupal, etc.) to view/edit/delete the Customer and Quote entity data.

# 1: Entities

• Create Customer Entity

o Assign a Customer ID number

• Create Quote Entity

o Assign a 7 character alpha-numeric Quote ID number (i.e. FS[#####])

#2: Relational Database Schema (SQL)

1. Data grid table with columns related to Quote Entity

• Shipment Type (3 types)

• Origin Detail

• Zip Code

• Location Type (6 types)

• Accessorials

• Call Before Delivery (yes or no)

• Inside Pickup (yes or no)

• Limited Access Pickup (yes or no)

• Destination

• Zip Code

• Location Type (6 types)

• Accessorials

• Call Before Delivery (yes or no)

• Inside Delivery (yes or no)

• Limited Access Delivery (yes or no)

• Packaging Type (5 types)

• Quantity (numerical)

• Weight (numerical)

• Dimensions

• Length

• Width

• Height

• Units

• Freight Class (19 types)

2. Data grid table with columns related to Customer Entity (one CustomerId to many QuoteId)

• Email Address

• Password

• Customer Type (Individual/Business)

• First Name

• Last Name

• Company Name

• Phone Number

• Business Type??

#3: Email Notification

• Create an automated process to email (address to be provided once project is accepted) on a daily basis for the previous day's lead info (attaching an Excel Spreadsheet with Customer Entity detail on first sheet, Quote Entity detail on second sheet)

• Include Customer ID # and Quote ID #

#4: Login

• New Tab for searching by QuoteId. Returns all Quote Entity detail results if left blank.

• If Admin, display all quotes, otherwise only query the QuoteIds for the current customer logged in.

**Access will be provided to FTP and local host SQL database**

The goal of this website is to allow customers to complete a quote form and log in to view saved quotes. The quote data will be logged and emailed to the administrator. There may be opportunity to additional work.

Kemahiran: Sistem Pengurusan Maklumat (Content Management System), PHP, SQL

Lihat lagi: php data collection application, wordpress website dimensions, wordpress project management free, wordpress org login, wordpress create application, web application quote, types of packaging, spreadsheet web form, spreadsheet to web application, quote lead, quote a lead, php create html, new joomla website for free, lead to quotes, lead management system in php, html 5 free web, free excel spreadsheet for automation, free business log, email address management, drupal o wordpress, data host, data dimensions, create free application, alpha packaging, o email

Tentang Majikan:
( 14 ulasan ) Palm Harbor, United States

ID Projek: #4052892

Dianugerahkan kepada:


Hi I can created the required web site with custom cms. Until you are 100% satisfied you will not loose a single dollar. Thanks -Udana-

$600 USD dalam 12 hari
(44 Ulasan)

9 pekerja bebas membida secara purata $691 untuk pekerjaan ini


I run European website design firm with years of design experience personally developing over 300+ websites. I can also provide a list of references from past customers if you'd like. I'm not the cheapest you'll find, Lagi

$888 USD dalam 7 hari
(51 Ulasan)

Time bounded Delivery. Fast and Quick Response. Quality Assured. Let's do it. Check PMB for more details.

$1200 USD dalam 30 hari
(134 Ulasan)

Dear Sir, We are expert programmers with 6+ years great industry experience . Please check message board for more details

$750 USD dalam 25 hari
(3 Ulasan)

hi sir Dolphinesoft is a professional Software Development Company providing complete IT solutions and acting as an offshore development center for overseas development firms. We are an innovative company, based in In Lagi

$500 USD dalam 30 hari
(2 Ulasan)

Hi Sir, I have done the same system to a Logistic Company situated in Florida. Which consist with Quote, Booking, Order handling, reporting with levels of authentications such as Super Admins, Admins, Pricing, Coord Lagi

$500 USD dalam 30 hari
(0 Ulasan)

SSU's core experience in Web Development, Software Development, Multimedia, Logo And 3D Animation is soo strong that it is capable of providing solutions across any industry segment. In Web Development we are doing e-C Lagi

$580 USD dalam 15 hari
(0 Ulasan)

Experts are ready to know the details of the project to satisfy you with quality service.

$500 USD dalam 30 hari
(0 Ulasan)

Hi, I would love to help you create a quote management system for your users to enter quotes and for you to manage them. I have lots of experience with MySQL and PHP, this is a very straightforward job for me. Lagi

$700 USD dalam 14 hari
(0 Ulasan)