Find Jobs
Hire Freelancers

PHP and MySQL job

$10-30 CAD

Completed
Posted over 4 years ago

$10-30 CAD

Paid on delivery
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. Context: 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: id name 2) [login to view URL] with these methods: create save load delete 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.
Project ID: 22632453

About the project

10 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 years of experience working with wordpress prestashop, symfony, laravel, python, raw php
$20 CAD in 7 days
5.0 (7 reviews)
4.2
4.2
10 freelancers are bidding on average $21 CAD for this job
User Avatar
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. It's important to me to build long-term relationships with clients. I can provide you these: - More than 8 hours in a day, if needed. - More than 5 days in a week. ( If project will turn to be closed with Deadline, I will work, even though it's holiday or weekend. ) - Guide Document which about I have completed. Please get in touch with me to discuss more. Look forward to working with you. Thank you for taking time to look at my proposal. Warmest regards,
$20 CAD in 7 days
4.9 (23 reviews)
5.6
5.6
User Avatar
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?
$10 CAD in 7 days
4.9 (92 reviews)
5.6
5.6
User Avatar
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 skills will be disclosed via chat. Shall I get all technical/non-technical details via a document? Please check my certifications to estimate my skills.
$20 CAD in 7 days
5.0 (1 review)
2.1
2.1
User Avatar
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 roles etc. Please initiate a CHAT to proceed further. After hearing from you, I will provide you final budget and time frame for your job. Looking forward to get your response.
$30 CAD in 7 days
5.0 (1 review)
1.2
1.2
User Avatar
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.
$15 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 teamwork and shared code repository skills - Yes. - Experience with automated software testing strategies - Not much but few. - Good knowledge of Git & GitHub and code collaboration techniques - Have worked on many projects with GitHub setup - Good English and communication skills - Yes - Experience working in agile development teams (Scrum/Kanban) - Have experience working in Scrum.
$20 CAD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 to know that i'm a newbie. Just finished university and looking for some projects to spend my spare time on and I think yours would worth it. cheers
$26 CAD in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 to all of our valued customers..
$31 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
Vancouver, Canada
4.6
9
Payment method verified
Member since Apr 12, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.