PHP and MySQL job

NOTE: if I do not like your code I will not accept it and you will not get paid! So if you are not qualified, do not apply for this project.

I am looking to find a PHP (7.0) and MySQL (5.6 and 5.7) developer for a long-term relationship to help me with my existing professional software. Your code has to follow best-practices, be clean, maintainable, and have full test coverage. The front-end is already in place, I just need you to write the back-end code. The front-end interacts with the back-end via APIs.


I have a website where customers can order services from companies online.

There is also an administrative area where companies can create an order when a customer calls them.

I am now adding 'coupons' to the software, the front-end code is all ready.

New functionality I am adding:

1. In the administrative area the company will be able to create, update and delete coupons. The properties of a coupon are:

code (string)

description (string)

validFrom (date)

validUntil (date)

value (float)

isPercent (boolean)

serviceIds (array)

2. In the administrative area, the company can create an order. When creating an order, the company will be able to choose which coupon to apply from a list of matching coupons (the service and dates match).

3. When the customer is ordering online, they can enter a coupon code. If it is a valid coupon (it belongs to this company, it applies to their chosen service, and the service dates are within the coupon's valid dates), they will be given a discount of the coupon's amount.

So I need you to create the building blocks for this: the tables, the Coupon class, a file that will be the API endpoint, and file containing the PHPUnit tests.

Attached is the screenshot of the administrative area where coupons are managed.

You will provide 4 files:

1) [login to view URL] that creates two mysql tables:

a) "coupons":

id (int, primary key, auto increment)

userId (int)

code (varchar 20)

description (varchar 255)

validFrom (date)

validUntil (date)

value (decimal 5,2)

isPercent (boolean)

b) "couponServices":

couponId (int)

serviceId (int)

c) note that another table "services" already exists that contains:



2) [login to view URL] with these methods:





plus whatever methods you need to complete the next step

3) [login to view URL] which will be an API endpoint. It will:

a) create a coupon when there is a POST request

b) update a coupon when there is a PUT request

c) delete a coupon when there is a DELETE request

d) return a JSON object with { id, value, isPercent } of a single coupon (the matching coupon) when there is a GET request and these query params: couponCode, serviceId, startDate, endDate

e) return a JSON object with { id, code, value, isPercent } of all coupons (the matching coupons) when there is a GET request and these query params: serviceId, startDate, endDate

f) return a JSON object with { id, code, description, validFrom, validUntil, value, isPercent, serviceIds, serviceName} of all coupons when there is a GET request with no query params

4) [login to view URL] which will have phpunit tests to fully cover the class.

I suggest you supply me one file at a time, starting with #1. If your code is unsatisfactory I will let you know before you proceed.

Aptitudini: PHP, MySQL, Arhitectură software, Testare / QA, Testare automatizări

Vezi mai multe: cron job tutorial php mysql, php mysql job posting software products, job portal php mysql, php mysql website creation job hourly rates, php mysql ajax job board script, php mysql job site software, simple php mysql job tracker, create cron job php mysql, job php mysql zagreb, flex php mysql job description, php mysql job boards, php mysql job seeker employer job posting, php mysql job board, access php mysql job, ratemyteacher clone easy php mysql job, php mysql job tracker, php mysql job recruitment site, php mysql job tracking, php mysql job

Despre angajator:
( 9 recenzii ) Vancouver, Canada

ID Proiect: #22632453

Acordat lui:


hi, how are you? i have read your requirements and conditions, which are just more that fare. for your requirements i would like to be able to chat directly with you, that way i could send the files as requested. 9 ye Mai multe

%selectedBids___i_sum_sub_7%%project_currencyDetails_sign_sub_8% CAD în 7 zile
(7 Recenzii)

10 freelanceri licitează în medie 21$ pentru acest proiect


Dear Client! I am very happy to see your project detail. I think it is just my project. :) I read your requirement carefully and understood fully. I am sure I can do your project. I have much experience with 8+years. Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(23 recenzii)

Hello sir I hope you are doing well. After reading your offer, this looks like a perfect fit for my skill sets so May I discuss with you for further details about this project?

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(92 recenzii)

Your project's posting has caught my attention as this lies exactly in my domain of expertise. To ask a few questions & to gather all the requirements for this project, i request you to message me. Expertise and skill Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(1 părere)

Hi, I have prior experience in developing website using PHP with Unit Testing. I would like to have a discussion with you regarding your requirement like your main business logic, list of features to be added, user Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(1 părere)

Hello from Inteliyo, We have gone through your requirements and would love do this piece of work for you. We can assure you for an end to end delivery/solution in a professional manner. Hereby, requesting you to sha Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 6 zile
(0 recenzii)

Dear client. I have read your proposal carefully. I can do it. Though I am a new freelancer, I have good experience with PHP & MySQL. You can check my skill. Please contact me. I can satisfy you. Regards, Long.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD în 1 zi
(0 recenzii)

Hi, I can start immediately and work to support and work as your PHP developer team. - Experience in back-end web development. Proficiency with Laravel. -of experience in backend web development and in Laravel. - Good Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 7 zile
(0 recenzii)

Been working on a PHP + MariaDB based site for a few months which was about streaming/recording cameras remotely. Currently working as a full stack developer (java, liquibase, vue.js, typescript) but i would like you t Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% CAD în 14 zile
(0 recenzii)

Hi, we are confident that we will deliver you beyond your expectations. We have team of experts serving the industries last 10 years plus, since we are new to this platform therefore offering very competitive rates t Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD în 1 zi
(0 recenzii)