Completed

PHP/MySQL Database - Matching CDL drivers to open positions

What we need: A MySQL database with a PHP interface to match CDL drivers with local jobs within a predetermined radius of their zip code.

Driver interface fields

- Drive Name

- Distance willing to drive

- City

- State

- Driver Zip Code

- Zip code Array (need to be able to paste in a comma delimited string of zip codes. If zip codes could be automatically populated based on the Drive Zip Code and Distance willing to drive, it's be great, but if not, the Zip Code Array can be obtained through [url removed, login to view])

- Excluded Carriers

- Notes

Job Interface Fields

- Zip Code of Job

- Carrier

- Job Number

- Estimated Salary

- Description

There should be a Dashboard that shows which Drivers match what Jobs. Basically, the tool will need to check the Driver Zip Code Array and if one of the zip codes matches a Zip Code of a Job, it will display their Driver information along with the details of the job on the Dashboard. There needs to be the ability to add & remove jobs and drivers from the database. If a Carrier is listed in the Driver's "Excluded Carriers", it should not show up in the potential matches for that driver. Also, if a Driver has turned a position down, it needs to be marked off so that it doesn't show up again for that driver as a potential match.

There are 4 carriers that cannot be input into the Job Interface, they have to be manually searched on the carrier's website. There will need to be a place in the Driver Interface to input the last date each of the 4 carriers was searched for each driver.

I have attached an example Excel spreadsheet that does everything needed. The full file is too large to function effectively, hence why we want to switch to a PHP/MySQL database.

If it helps, here are the locations in the example Excel spreadsheet

Formula location: A2

=IF(ISNUMBER(LARGE(S2:AAC2,1)),CONCATENATE(IF(ISNUMBER(LARGE(S2:AAC2,5))=TRUE,VLOOKUP(LARGE(S2:AAC2,5),Jobs!A:E,5,0),""),IF(ISNUMBER(LARGE(S2:AAC2,4))=TRUE,CONCATENATE(VLOOKUP(LARGE(S2:AAC2,4),Jobs!A:E,5,0)," & "),""),IF(ISNUMBER(LARGE(S2:AAC2,3))=TRUE,CONCATENATE(VLOOKUP(LARGE(S2:AAC2,3),Jobs!A:E,5,0)," & "),""),IF(ISNUMBER(LARGE(S2:AAC2,2))=TRUE,CONCATENATE(VLOOKUP(LARGE(S2:AAC2,2),Jobs!A:E,5,0)," & "),""),IF(ISNUMBER(LARGE(S2:AAC2,1))=TRUE,CONCATENATE(VLOOKUP(LARGE(S2:AAC2,1),Jobs!A:E,5,0)," "))),"")

Formula location: S2

=IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$K3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$L3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$M3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$N3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$O3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$P3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$Q3,"",IF(IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,5,0),"")=$R3,"",IFNA(VLOOKUP(MATCH(S3,Jobs!$B:$B,0),Jobs!$A:$E,1,0),"")))))))))

Skills: Codeigniter, HTML, MySQL, PHP, SQL

See more: employees information system php mysql database, sending flash data php mysql database flash cs3, php mysql database creator, php mysql database query script, php mysql database webpage examples, post ajax php mysql database, php mysql database load script, parse xml php mysql database, upload video php mysql database, php mysql database remote, admin approval using php mysql database, business directory listings php mysql database, php mysql database populate form selected, php mysql database manipulation, simple php mysql database

About the Employer:
( 2 reviews ) Wapwallopen, United States

Project ID: #15345007

Awarded to:

Tushar051

I have 100% job completion rate:) I have above 5yr of experience in Web Development & Designing, Web application development. Relevant Skills and Experience My strengths are in PHP, Codeigniter, Laravel, Wordpress, M More

$260 USD in 10 days
(15 Reviews)
4.8

15 freelancers are bidding on average $460 for this job

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html Relevant Skills and Experience Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expe More

$526 USD in 10 days
(206 Reviews)
8.4
seekdeveloper

Hi, I have read your post and understood your requirement. Looking for the freelancer to work on your next project? Or just need some issues/bugs/fixes ASAP? I have 8+ years of experience and I'm here for you! My More

$777 USD in 10 days
(121 Reviews)
8.7
pointlogic

Hello..I am expert working on Codeignitor and i can do your work. Relevant Skills and Experience I have in-depth knowledge of php, mysql, javascript , jquery, paypal integrations, API's, css, html, html5, wordpress. I More

$500 USD in 10 days
(285 Reviews)
8.1
hawkscodeaus

Web developer, 7+ yrs of experience in development and designing Relevant Skills and Experience I am good in PHP*(Laravel, ASP.net, C#, YII, CakePHP, Codeigniter), HTML*,CSS, MySQL, Ms-SQL,Twitter BootStrap, Mongo DB, More

$400 USD in 10 days
(93 Reviews)
7.2
$444 USD in 6 days
(52 Reviews)
6.3
hjr122413

Hi Thanks for your posting. I have many experiences in php, mysql, web developing, so if you hire me, I can finish this project perfectly. **** I checked the excel file you sent. I have many experiences in mysql, More

$500 USD in 10 days
(40 Reviews)
5.8
polarjin2017

Hello? Relevant Skills and Experience How are you? I am good in php and My SQL Proposed Milestones $555 USD - 1

$555 USD in 10 days
(23 Reviews)
5.1
suniljoshi151

HTML, MySQL, PHP, SQL 7 Yrs of experience Relevant Skills and Experience PHP,HTML,Website design,Shopify,Magento,Drupal, open cart,E-Commerce, Wordpress EXPERIENCE IN ALL THE FRAMEWORKS. Proposed Milestones $500 USD More

$500 USD in 10 days
(57 Reviews)
5.9
meghas27

Dear Hiring Manager, I had a look at your given job post and came to know that you are looking for Website developer to build unique website as per your requirement. Relevant Skills and Experience [url removed, login to view] More

$250 USD in 10 days
(47 Reviews)
4.7
designncoding

Hey, I have checked job description and quite interested in working with you. I have core expertise in Codeigniter, HTML, MySQL, PHP, SQL Relevant Skills and Experience I have 6 years of exp. Proposed Milestones $5 More

$555 USD in 10 days
(10 Reviews)
3.6
Sndeep88

Hello, Having read your job description, I feel to be a good fit for this job, as I have hands on experience working on the PHP, Mysql, HTML, JQuery Frameworks, as well as Major CMS's like Joomla, WordPress and Mag More

$555 USD in 10 days
(13 Reviews)
4.0
simrankaurc

Hello, I am very interested in the project and you would like to apply to it. I'm a web developer with 7 years experience in PHP, MYSQL, CSS3, HTML5 and deep knowledge Wordpress, WP pluggin, development issues More

$250 USD in 10 days
(6 Reviews)
2.7
$277 USD in 10 days
(3 Reviews)
1.7
mulama1991

Hi, I have reviewed your requirement and I can do this job as per your requirement. I have a advanced skills in WORDPRESS , Laravel, Angular JS ,PHP, Codeigniter,MYSQL, Joomla,JavaScript, API Integration,Plugins , More

$555 USD in 10 days
(1 Review)
1.7