2 almost identical pages with 2 forms each. Save on DB and send emails with automatically generated Excel file

Status: Closed
Prize: €250
Entries Received: 6
Winner: spylot

Winner

Contest Brief

I have a lot of projects and few workers. This contest is aimed to find freelancers to work on other projects on a regular basis. ONLY apply if you are able to do other projects in the future.

I am based on Portugal so although I do prefer local based workers, international portuguese/english speakers can apply.

This is like an exam project, I will use it to evaluate your coding skills :)
So, do NOT minify your code. I will see how you structure and organize your HTML, JS and CSS.

So, about the project (PHP / MySQL):

I need PSD to HTML on 2 almost identical pages with 2 forms each.
One form simple sends an email for each entry and the other sends a daily email with an Excel file automatically generated (done by you) with that day's entries.
Both forms save the data on a MySQL BD (with a field telling which of the 2 pages data comes).

The pages need to be responsive and I encourage you to do mobile first development.

I provide the PSD and font files.

You should use jQuery to slide the content from the buttons and to use a TagIt like field on the "Alugueres" (see attached images).

The fields should be validated both on client (JS) and server side (PHP) and all fields marked with * are mandatory.
Field’s validation:
Telemóvel and Telefone must be checked with the Regular Expression ^9[1236][0-9]{7}|2[1-9][0-9]{7}$
Email must be a valid e-mail address
Código Postal must be checked with the RegEx ^\d{4}(-\d{3})?$
Each Aluguer code must have maximum 10 chars and be unique (can’t be repeated on the field and can’t be repeated on database)
The Email on the form “Inscreva-se” must be unique on database.
The form “Participe” only accepts emails that were already submitted on the form “Inscreva-se”.
Each form must have messages to the user telling the form was submitted successfully or why not (don’t worry too much about error messages as long as they make sense)
The button “Europcar dá prémios” is an external link (you can put # on href)

The payment will be sent after I receive the files and its all working as expected.

The PSD files and Fonts can be downloaded here:
https://dl.dropboxusercontent.com/u/4750936/PSD%20and%20Fonts.zip

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Great freelancer! Very professional, proactive and always trying to improve. Event thinks of things we forget and develop it.”

dariosantos, Portugal.

Public Clarification Board

spylot
- 7 years ago
Is the Aluguer Code shared between Agencies and Offices?
- 7 years ago
1. spylot
  - 7 years ago
  I completed the project. I decided to keep the code unique on both.
  - 7 years ago
web6021
- 7 years ago
#extended
- 7 years ago
selfvictim
- 7 years ago
#extended
- 7 years ago
harpalsoft
- 7 years ago
Interesting job. Can it be #extended for 2 more days?
- 7 years ago
njose
- 7 years ago
Hello.. I have started working. Please share the fonts separately if possible. Best, Njose
- 7 years ago
ShakthiNinja
- 7 years ago
Interesting... I like this project... I'm working on it... :)
- 7 years ago
DesignGuruPro
- 7 years ago
working
- 7 years ago
rufio72
- 7 years ago
may i use bootstrap?
- 7 years ago
1. Contest Holder
  - 7 years ago
  Yes
  - 7 years ago
joana111
- 7 years ago
Hello. Is this a mobile site or web? It's not so clear, cause you are asking to do a mobile development first
- 7 years ago
1. Contest Holder
  - 7 years ago
  Hello,
  This is a responsive website.
  By that I mean that the website adapts to whatever size the browser has.
  Mobile development first means that the layout is done firstly to small screens and then the CSS media queries are added to make the necessary changes to bigger screens. This way, the mobile phones have to interpret and renderize fewer CSS rules.
  - 7 years ago
superInnova
- 7 years ago
especially logo, "moving your ways" and icons (footer)
thanks
- 7 years ago
1. Contest Holder
  - 7 years ago
  I don't have the header and footer in layers. It's OK to slice the icons and stuff right from the flat image.
  - 7 years ago
superInnova
- 7 years ago
hi
do you have Header and footer in layers?
- 7 years ago
1. Contest Holder
  - 7 years ago
  Hi,
  I don't have the header and footer in layers. It's ok to slice the icons and stuff right from the flat image.
  - 7 years ago
codeplayers365
- 7 years ago
Hi, I'm going to start working on this project. can you please clear below query?
"One form simple sends an email for each entry and the other sends a daily email with an Excel file automatically generated (done by you) with that day's entries."
- 7 years ago
1. Contest Holder
  - 7 years ago
  Hi,
  Every entry on the form "Inscreva-se" is saved on the Database and triggers an email to some manager's email.
  Every entry on the form "Participe" is also saved on the Database however it doesn't trigger the email to the manager.
  What happens is that every day the website generates an Excel file with the previous' day entries and send it (as attachment) to the same manager's email.
  - 7 years ago